lad consulting localizations
Post on 24-Nov-2015
336 Views
Preview:
DESCRIPTION
TRANSCRIPT
-
LAD Consulting Localizations
General Ledger Colombian Localizations
Technical Reference Manual
RELEASE 12
May 2013
Version 1.6
DISCLAIMER :
CURRENTLY, ORACLE OFFERS CERTAIN RESALABLE ASSETS OR OTHER DEFINED SERVICE
DELIVERABLES (COLLECTIVELY REFERRED TO AS "SERVICE DELIVERABLES") UNDER A LIMITED USE
LICENSE. THE SERVICE DELIVERABLES CURRENTLY INCLUDE, BUT ARE NOT LIMITED TO, ORACLE
INTEGRATION HUB. YOU AGREE THAT :
(i) SERVICE DELIVERABLES ARE NOT ORACLE STANDARD SOFTWARE PROGRAMS,
(ii) TECHNICAL SUPPORT FOR SERVICE DELIVERABLES IS NOT AVAILABLE FROM OR UNDER, OR
PROVIDED BY OR THROUGH, ORACLE'S SUPPORT SERVICES ORGANIZATION OR YOUR ORACLE
PROGRAM LICENSE AGREEMENT,
(iii) YOUR RIGHT TO USE AND RECEIVE SUPPORT SERVICES FOR SERVICE DELIVERABLES IS
SOLELY AS DESCRIBED IN YOUR CONTRACT FOR SUCH SERVICE DELIVERABLES, AND
(iv) A SERVICE REQUEST REGARDING SERVICE DELIVERABLES, REGARDLESS OF HOW INITIATED
OR LOGGED, WILL BE ADDRESSED IN ACCORDANCE WITH THE TERMS OF YOUR CONTRACT FOR
SUCH SERVICE DELIVERABLES.
-
LAD Consulting Localizations Technical Reference Manual
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
Document Control ii
Document Control
Change Record
Date Author Version Change Reference
09-may-08 Rodrigo Naves 1 Creation
15-may-08 Gustavo Meni 1.1 Document Review
29-nov-11 Lilia Medeiros 1.2 Magnectic Media based on SLA
29-dec-11 Lilia Medeiros 1.3 Alter table CLL_F041_MMEDIA_FORMATS
22-feb-12 Lilia Medeiros 1.4 Included seven columns to CLL_F041_GL_MG_LINES
15-Nov-12 Mauricio Forero 1.5 Changes Include in patch 14663638 - CLL_F041 - R12 -
COLOMBIAN Add-on
29-may-13 Mauricio Forero 1.6 Update SLA Magnetic Media model
Document Review
-
LAD Consulting Localizations Technical Reference Manual
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
Document Control iii
Content
Document Control ...................................................................................................................... ii
C H A P T E R 1 High Level Design .................................................................................................................... 1
High Level Design Overview ..................................................................................................... 2
Oracle General Ledger Colombian Localizations Overview ............................................. 2 List of Tables ...................................................................................................................... 2 List of Views ....................................................................................................................... 2 List of Modules ................................................................................................................... 2
List of Views .............................................................................................................................. 3
Views for Magnetic Media based on GL ............................................................................ 3 Views for Magnetic Media based on SLA .......................................................................... 3
List of Tables ............................................................................................................................. 4
Tables for Magnetic Media based on GL ........................................................................... 4 Tables for Magnetic Media based on SLA ......................................................................... 4
List of Modules .......................................................................................................................... 5
Forms for Magnetic Media based on GL ............................................................................ 5 Forms for Magnetic Media based on SLA .......................................................................... 5 Reports for Magnetic Media based on GL .......................................................................... 5 Reports for Magnetic Media based on SLA ........................................................................ 5 XML Publisher Templates for Magnetic Media based on GL ............................................ 6 XML Publisher Templates for Magnetic Media based on SLA .......................................... 6 Concurrent Programs for Magnetic Media based on GL .................................................... 6 Concurrent Programs for Magnetic Media based on SLA .................................................. 6 Triggers for Magnetic Media based on GL ......................................................................... 6 Triggers for Magnetic Media based on SLA ...................................................................... 7 Packages for Magnetic Media based on GL ....................................................................... 8 Packages for Magnetic Media based on SLA ..................................................................... 8 Descriptive Flexfields for Magnetic Media based on GL ................................................... 8 Descriptive Flexfields for Magnetic Media based on SLA ................................................. 8 Value Sets for Magnetic Media based on GL ................................................................... 10 Value Sets for Magnetic Media based on SLA ................................................................. 10
C H A P T E R 2 Detailed Design ....................................................................................................................... 11
Detailed Design........................................................................................................................ 12
Views and Tables Definition ............................................................................................ 12 Module Defintion.............................................................................................................. 12 Package Definition ............................................................................................................ 12 Triggers Definition ........................................................................................................... 12 Descriptive Flexfields ....................................................................................................... 12 Value Sets ......................................................................................................................... 12
-
LAD Consulting Localizations Technical Reference Manual
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
Document Control iv
Segment Values ................................................................................................................ 12
View and Table Definition ....................................................................................................... 13
Description ....................................................................................................................... 13 Changes ............................................................................................................................ 13 Columns Detail ................................................................................................................. 13 Indexes .............................................................................................................................. 14
Table Definition for Magnetic Media based on GL ................................................................. 15
CLL_F041_GL_CITY_CODES ....................................................................................... 15 CLL_F041_GL_MG_FORMAT ...................................................................................... 16 CLL_F041_GL_MG_FORMAT_COLS .......................................................................... 17 CLL_F041_GL_MG_HEADER ....................................................................................... 18 CLL_F041_GL_MG_LINES ............................................................................................ 19 CLL_F041_GL_MG_LITERALS_EXT .......................................................................... 20 CLL_F041_GL_NITS_EXT............................................................................................. 21
Table Definition for Magnetic Media based on SLA ............................................................... 23
CLL_F041_COMPANIES................................................................................................ 23 CLL_F041_COMPANY_BOOKS ................................................................................... 24 CLL_F041_COMPANY_LES .......................................................................................... 25 CLL_F041_MMEDIA_BALANCES ............................................................................... 26 CLL_F041_MMEDIA_CONCEPTS ................................................................................ 27 CLL_F041_MMEDIA_FINAL ........................................................................................ 28 CLL_F041_MMEDIA_FORMATS ................................................................................. 30 CLL_F041_MMEDIA_HEADER .................................................................................... 31 CLL_F041_MMEDIA_IFACE......................................................................................... 32 CLL_F041_MMEDIA_IFACE_ERRORS ....................................................................... 33 CLL_F041_MMEDIA_LINES ......................................................................................... 34 CLL_F041_PARTY_BAL_IFACE .................................................................................. 36 CLL_F041_PARTY_BAL_SOURCE .............................................................................. 37 CLL_F041_PARTY_BALANCES ................................................................................... 38 CLL_F041_PARTY_IFACE_ERRORS ........................................................................... 39 CLL_F041_PARTY_JOURNALS ................................................................................... 40 CLL_F041_PARTY_PERIODS ....................................................................................... 41 CLL_F041_REP_VAL_ACC_RANGES ......................................................................... 42 CLL_F041_REP_VAL_TYPES ....................................................................................... 44 Reported value identification (based on CLL_F041_REPORTED_VALUES)................ 44 Format identification (based on CLL_F041_MMEDIA_FORMATS) ............................. 44 Concept identification (based on CLL_F041_MMEDIA_CONCEPTS) .......................... 44 CLL_F041_REPORTED_VALUES ................................................................................ 45 CLL_F041_XLE_REGISTRATIONS_EXT .................................................................... 46 CLL_F041_GL_NITS_EXT............................................................................................. 47
View Definition for Magnetic Media based on GL.................................................................. 50
CLL_F041_GL_MG_LINES_V ....................................................................................... 50
View Definition for Magnetic Media based on SLA ............................................................... 53
CLL_F041_PAYABLES_V ............................................................................................. 53 CLL_F041_MMEDIA_FINAL_V ................................................................................... 53 CLL_F041_MMEDIA_LINES_V .................................................................................... 56 CLL_F041_RECEIVABLES_V ....................................................................................... 58 CLL_F041_MMEDIA_DRAFT_V .................................................................................. 59 CLL_F041_CASH_V ....................................................................................................... 61
Modules Definition for Magnetic Media based on GL ............................................................ 62
Module Overview ............................................................................................................. 62 Objects for Magnetic Media based on GL ........................................................................ 63 cll_f041_aptb.pls .............................................................................................................. 63
-
LAD Consulting Localizations Technical Reference Manual
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
Document Control v
cll_f041_apts.pls ............................................................................................................... 63 cll_f041_gmgb.pls ............................................................................................................ 63 cll_f041_gmgs.pls ............................................................................................................. 63 cll_f041_txvb.pls .............................................................................................................. 63 cll_f041_txvs.pls ............................................................................................................... 63 CLL_F041_CITY ............................................................................................................. 63 CLL_F041_GLTP ............................................................................................................ 64 CLL_F041_MGFR ........................................................................................................... 64 CLL_F041_MGRU........................................................................................................... 64 cll_f041_mgli.sql .............................................................................................................. 64 cll_f041_glid.sql ............................................................................................................... 64 cll_f041_gltd.sql ............................................................................................................... 64 CLL_F041_GLAN ........................................................................................................... 64
Modules Definition for Magnetic Media based on SLA .......................................................... 65
Module Overview ............................................................................................................. 65 Objects for Magnetic Media based on SLA ...................................................................... 68 cll_f041_mmfb.pls ............................................................................................................ 68 cll_f041_mmfs.pls ............................................................................................................ 68 cll_f041_mmgb.pls ........................................................................................................... 68 cll_f041_mmgs.pls ............................................................................................................ 68 cll_f041_minb.pls ............................................................................................................. 68 cll_f041_mins.pls.............................................................................................................. 68 cll_f041_prtb.pls ............................................................................................................... 68 cll_f041_prt.pls ................................................................................................................. 69 cll_f041_mutb.pls ............................................................................................................. 69 cll_f041_muts.pls.............................................................................................................. 69 cll_f041_utib.pls ............................................................................................................... 69 cll_f041_utis.pls ............................................................................................................... 69 cll_f041_pbib.pls .............................................................................................................. 69 cll_f041_pbib.pls .............................................................................................................. 70 CLL_F041_COMP ........................................................................................................... 70 CLL_F041_FRMT ............................................................................................................ 70 CLL_F041_MMHL .......................................................................................................... 70 CLL_F041_TPSO ............................................................................................................. 70 CLL_F041_MMLC .......................................................................................................... 70 CLL_F041_IFMM ............................................................................................................ 70 CLL_F041_TPMN ........................................................................................................... 71 CLL_F041_IFPB .............................................................................................................. 71 CLL_F041_MMDR.rtf ..................................................................................................... 71 CLL_F041_MMFI.rtf ....................................................................................................... 71 CLL_F041_PVAL.rtf ....................................................................................................... 71 CLL_F041_MMFI.xml ..................................................................................................... 71
-
LAD Consulting Localizations Technical Reference Manual 1
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
C H A P T E R
1 High Level Design
This chapter presents the High Level Design of Oracle General Ledger Colombian Localizations application satisfying the specific needs of the Strategy and Analyze phase of an
implementation. A global view of the receiving process will be explained. Diagrams and charts
of the major functions in Oracle General Ledger Colombian Localizations together with list of
tables, modules and views complements will be shown for the better understanding of the
process.
After patch 10263549, there are two solutions for Magnetic Media in the EBS R12.
The first solution, the oldest, works based on the information that are on GL and in this
document we are referencing to these objects as Magnetic Media based on GL.
The second solution, the latest, works based on the information that are on SLA and in this
document we are referencing to these objects as Magnetic Media based on SLA.
-
LAD Consulting Localizations Technical Reference Manual 2
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
High Level Design Overview
During the High Level Design, the major application components are defined (tables, views and
modules) necessary to construct the application. Below we specify what each component does
without entering in details on how its done.
This chapter can be used to rapidly learn what tables, views and module are part of Oracle General
Ledger Colombian Localizations. Through this chapter it is possible to understand the details of the
design and of the implementation of Oracle General Ledger Colombian Localizations.
Oracle General Ledger Colombian Localizations Overview
Through the Entity Relationship Diagram it is possible to learn what entities are the building blocks
of the application and learn how they relate.
List of Tables
The list of tables briefly describes each table of Oracle General Ledger Colombian Localizations. For
more information, please read the Tables Definition of the Detailed Design in chapter 2.
List of Views
The List of Views briefly describes each view in Oracle General Ledger Colombian Localizations.
For more information, please read the Tables Definition of the Detailed Design in chapter 2.
List of Modules
The list of Modules briefly describes each module of Oracle General Ledger Colombian
Localizations. For more information please read the Tables Definition of the Detailed Design in
chapter 2.
-
LAD Consulting Localizations Technical Reference Manual 3
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
List of Views
Views for Magnetic Media based on GL
View Name Description
CLL_F041_GL_MG_LINES_V Information about GL Magnetic Media Calclulation
Views for Magnetic Media based on SLA
View Name Description
CLL_F041_PAYABLES_V Information about payables used for Magnetic Media
generation.
CLL_F041_MMEDIA_FINAL_V Detailed information about finalized Magnetic Media
generation
CLL_F041_MMEDIA_LINES_V Working table for Magnetic Media calclulation
CLL_F041_RECEIVABLES_V Information about Receivables used for Magnetic Media
generation.
CLL_F041_MMEDIA_DRAFT_V Detailed information about draft Magnetic Media
generation
CLL_F041_CASH_V Information about Cash used for Magnetic Media
generation.
-
LAD Consulting Localizations Technical Reference Manual 4
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
List of Tables
This section lists and briefly describes each table in Oracle General Ledger Colombian Localizations.
Tables for Magnetic Media based on GL
Table Name Description
CLL_F041_GL_CITY_CODES Cities definition
CLL_F041_GL_MG_FORMAT GL Magnetic Media Formats
CLL_F041_GL_MG_FORMAT_COLS GL Magnetic Media Formats Columns
CLL_F041_GL_MG_HEADER GL Magnetic Media Header
CLL_F041_GL_MG_LINES GL Magnetic Media Calclulation
CLL_F041_GL_MG_LITERALS_EXT GL Magnetic Media Literal Extension
CLL_F041_GL_NITS_EXT Colombian Tax Payer Identification
Tables for Magnetic Media based on SLA
Table Name Description
CLL_F041_COMPANIES Company definition
CLL_F041_COMPANY_BOOKS Company Books and BSV assignment
CLL_F041_COMPANY_LES Company Legal Entity assignments
CLL_F041_MMEDIA_IFACE Interface table for external sources
CLL_F041_MMEDIA_BALANCES Year Balances Table
CLL_F041_MMEDIA_HEADER Header table to control each company/year processing
CLL_F041_MMEDIA_LINES Working table for Magnetic Media calclulation
CLL_F041_MMEDIA_FINAL Detailed information about finalized Magnetic Media
generation
CLL_F041_MMEDIA_FORMATS Magnetic Media Formats
CLL_F041_MMEDIA_CONCEPTS Magnetic Media Concepts
CLL_F041_REPORTED_VALUES Reported Values Definition according Concept
CLL_F041_REP_VAL_ACC_RANGES Reported Values Accounting Ranges
CLL_F041_MMEDIA_IFACE_ERRORS Error Interface table for external sources
CLL_F041_XLE_REGISTRATIONS_EXT Company Registration additional extension information
CLL_F041_PARTY_PERIODS Third party periods
CLL_F041_PARTY_BALANCES Third party balances
CLL_F041_PARTY_JOURNALS Third party journals
CLL_F041_PARTY_BAL_SOURCE Third party sources for extraction processes
CLL_F041_REP_VAL_TYPES Reported Values line types
CLL_F041_PARTY_BAL_IFACE Interface table for Third party balances
CLL_F041_PARTY_IFACE_ERRORS Error Interface table for Third party balances
-
LAD Consulting Localizations Technical Reference Manual 5
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
List of Modules
This section lists each form, report, concurrent program and stored procedure used in Oracle General
Ledger Colombian Localizations.
Forms for Magnetic Media based on GL
Form Description Field Name
CLL_F041_CITY City Codes for Magnetic Media CLL F041: City Codes for Magnetic Media
CLL_F041_GLTP Names Update CLL F041: Third Party to Manage and Control
CLL_F041_MGFR XML Formats Setup CLL F041: XML Formats Setup
CLL_F041_MGRU Concept and Format CLL F041: Concept and Format
Forms for Magnetic Media based on SLA
Form Description Field Name
CLL_F041_COMP Compay CLL F041: Company
CLL_F041_FRMT Format and Concepts
maintenance CLL F041: Formats
CLL_F041_MMHL Detail Data Format and
Concept CLL F041: Magnetic Media Maintain
CLL_F041_MMLC Sumary Data Format and
Concept CLL F041: Magnetic Media Result
CLL_F041_IFMM Magnetic Media Interface CLL F041: Magnetic Media Interface
CLL_F041_TPMN Third Party Control CLL F041: Inquiry and Control Third Party
CLL_F041_TPSO Third Party Sources CLL F041: Third Party Sources
CLL_F041_IFPB Party Balances Open Interface
Import CLL F041: Party Balances Open Interface
Reports for Magnetic Media based on GL
Report Description Field Name
CLL_F041_GLAN NIT Account details report
Reports for Magnetic Media based on SLA
Report Description Field Name
CLL_F041_PVAL Colombian Third Party Report Attributes
CLL_F041_PRTY Third Party Report Balances
-
LAD Consulting Localizations Technical Reference Manual 6
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
XML Publisher Templates for Magnetic Media based on GL
There are no XML Publisher Templates in the solution for Magnetic Media based on GL.
XML Publisher Templates for Magnetic Media based on SLA
Report Description Field Name
CLL_F041_MMDR.rtf Magnetic Media Spreadsheet Draft
CLL_F041_MMFI.rtf Magnetic Media File Spreadsheet
CLL_F041_PVAL.rtf Third Party Report Attributes
CLL_F041_PRTY.rtf Third Party Report Balances
Concurrent Programs for Magnetic Media based on GL
Concorrent Program Description Field Name
CLL_F041_GLAN NIT account details report
CLL_F041_UPNM Update Third party Information, Names and Address
CLL_F041_MGXP Print XML File
CLL_F041_MGXM Generate XML File
CLL_F041_UPMG Update Magnetic Media
Concurrent Programs for Magnetic Media based on SLA
Concorrent Program Description Field Name
CLL_F041_MMFI Magnetic Media Spreadsheet Final
CLL_F041_MMDR Magnetic Media Spreadsheet Draft
CLL_F041_MINT Magnetic Media Open Interface Import
CLL_F041_MMEDIA_GEN_VAL Magnetic Media Generate Data
Program
CLL_F041_MMEDIA_FINAL_FILE Magnetic Media Final File Program
CLL_F041_MMEDIA_THRESHOLD Process of Threshold Magnetic Media
CLL_F041_PRTY Third Party Report Balances
CLL_F041_MUTIL_CLON Process of Copy on Formats and
Concept
CLL_F041_CTPBM Third Party Maintenance Balances
CLL_F041_PVAL Third Party Report Attributes
CLL_F041_PUPD Update Third Party Attributes
CLL_F041_MINT Magnetic Media Open Interface Import
CLL_F041_IFPB Party Balances Open Interface Import
Triggers for Magnetic Media based on GL
Trigger Description Name
cll_f041_mgli CLL_F041_GL_MG_LITERALS_T1
cll_f041_gltd CLL_F041_JL_CO_GL_TRX_T2
cll_f041_glid CLL_F041_JL_CO_GL_TRX_T1
-
LAD Consulting Localizations Technical Reference Manual 7
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
Triggers for Magnetic Media based on SLA
There are no Trigger in the solution for Magnetic Media based on SLA.
-
LAD Consulting Localizations Technical Reference Manual 8
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
Packages for Magnetic Media based on GL
Package File
Procedures File
Package Name
Procedure Name
Procedure Description
cll_f041_gmgs
cll_f041_gmgb CLL_F041_GL_MG_MEDIA_PKG
Packages for Magnetic Media based on SLA
Package File
Procedures File
Package Name
Procedure Name
Procedure Description
cll_f041_mmfs
cll_f041_mmfb CLL_F041_MMEDIA_FINAL_FILE_PKG
cll_f041_mmgs
cll_f041_mmgb CLL_F041_MMEDIA_GEN_VAL_PKG Magnetic Media Generate Data Program
cll_f041_mins
cll_f041_minb CLL_F041_MMEDIA_IFACE_PKG Magnetic Media Open Interface Import
cll_f041_utis
cll_f041_utib CLL_F041_UTIL_PKG Magnetic Media Utilities
cll_f041_prts
cll_f041_prtb CLL_F041_PARTY_BALANCES_PKG Third Party Maintenance Balances
cll_f041_muts
cll_f041_mutb CLL_F041_MMEDIA_UTILITIES_PKG Magnetic Media Utilities
CLL_F041_IFPB Party Balances Open Interface Import
Descriptive Flexfields for Magnetic Media based on GL
Decriptive Name Title
CLL_F041_GL_MG_LITERALS_EXT Literal Extension
Descriptive Flexfields for Magnetic Media based on SLA
Decriptive Name Title
CLL_F041_XLE_REGISTRATIONS_EXT Company Registrations Extension
-
LAD Consulting Localizations Technical Reference Manual 9
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
Decriptive Name Title
-
LAD Consulting Localizations Technical Reference Manual 10
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
Value Sets for Magnetic Media based on GL
Value Set Name Description
CLL_F041_GL_FORMAT_MG Magnetic Media value set formats
CLL_F041_GL_LITERALES_MG Literal Additional Information
CLL_F041_GL_MG_CONCEPT_ALL Handle concept magnetic media according 2005 legislation
CLL_F041_GL_MG_FORMAT Handle formats magnetic media according 2005 legislation
CLL_F041_GL_NIT_ID Third Party list
CLL_F041_GL_FORMAT_MG_ALL Format list used by Colombian Magnetic Media solution
CLL_F041_GL_CONCEPT_MG_ALL Concept list used by Colombian Magnetic Media solution
Value Sets for Magnetic Media based on SLA
Value Set Name Description
CLL_F041_COMPANIES Companies to Magnetic Media Process
CLL_F041_COMPANIES_FINAL Companies to Magnetic Media Process
CLL_F041_CONCEPTS Concepts
CLL_F041_CONCEPTS_TO Concepts for Magnetic Media
CLL_F041_FORMATS Formats
CLL_F041_FORMAT_CODES Format Codes
CLL_F041_FORMAT_CODES_TO Format Codes To
CLL_F041_GL_MG_FORMAT Format List for Colombian Magnetic Media
CLL_F041_GL_MG_CONCEPT Concept List for Colombian Magnetic Media
CLL_F041_GL_MG_VALUES Reported Values for magnetic Media
CLL_F041_DATE Date
CLL_F041_PARTY_PERIODS Party Periods
CLL_F041_FISCAL_YEAR Fiscal Year
CLL_F041_PERIOD_NAMES Period to be reprocessed
CLL_F041_FORMATS_YEAR Formats for Year
CLL_F041_MMEDIA_PERIODS Magnetic Media Periods
CLL_F041_PARTY_BAL_IFACE_PR
OCESS
Process for Party Balances Open Interface Import
-
LAD Consulting Localizations Technical Reference Manual 11
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
C H A P T E R
2 Detailed Design
This chapter presents a detailed design used during the Oracle General Ledger Colombian Localizations implementation. Here you will find detailed definitions about tables, views,
modules and other objects used in Oracle General Ledger Colombian Localizations.
-
LAD Consulting Localizations Technical Reference Manual 12
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
Detailed Design
During the Detailed Design phase, each Applications component has its functionality detailed.
This chapter permits the understanding of the detailed structure and information flow of Oracle
General Ledger Colombian Localizations.
Convert existing application data;
Write customized reports;
Define alerts against Oracle Applications tables;
Create views for decision support - queries using Oracle Data Browser or Oracle Data Query
tools.
Views and Tables Definition
This section contains a detailed definition of Oracle General Ledger Colombian Localizations tables
and views. For each table, it provides information about objective, column description, primary key,
unique key, check constraints, foreign keys, indexes, quickcodes, sequences, module access and
database triggers. It also contains the SQL structure of each view.
Module Defintion
This section provides detailed information about each module in Oracle General Ledger Colombian
Localizations. Use this section to better understand the content details of each module and how these
functionalities are implemented.
Package Definition
This section gives a overview about the Procedures and Functions inside the Calculation Package.
Triggers Definition
This section provides information about the Triggers of Oracle General Ledger Colombian
Localizations. If the Trigger is started in before or after insert for example.
Descriptive Flexfields
This section provides detailed information of each Descriptive Flexfield used in the Oracle General
Ledger Colombian Localizations.Use this section to rapidly find the list of Descripttive Flexfields.
Value Sets
This section provides detailed information of Value Set used in the Oracle General Ledger
Colombian Localizations. The Values Sets are the information that are used in Zooms, with List of
Values.
Segment Values
This section provides detailed information of Segment Values used in the Oracle General Ledger
Colombian Localizations. The Segment Values are the information that appears when a Value Set has
the type Independent.
-
LAD Consulting Localizations Technical Reference Manual 13
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
View and Table Definition
This section contains a detailed definition of each table and view used in Oracle General Ledger
Colombian Localizations. For each table or view the following information are presented:
Description;
Changes;
Columns Detail ;
Indexes;
This section only documents the tables and views which Oracle General Ledger Colombian
Localizations owns. To obtain more details on other external tables and views used, please search the
corresponding application which the table is a component of.
Description
In this topic we will describe why this table will be used.
Changes
In this topic we will identify object modifications undergone since the previous version: if it is a new
object, if it become optional or obligatory, which columns were added or removed, the column type
changes and if the object was renamed.
Columns Detail
This topic presents the primary attributes of each column or view with a brief description of its use.
These attributes include the data type and if a value for this column is optional or obligatory.
Standard Who Column
Several tables in Oracle General Ledger Colombian Localizations contain standard who columns.
When a program or SQL command selects a row from a table, these columns are used to determine
who did the last update in this row. If your program or SQL command inserts or updates a line in an
interface table, you should update the five Standard Who Columns:
LAST_UPDATE_DATE Date when a user last updated this row.
LAST_UPDATED_BY User who last updated this row (Foreign Key to
FND_USER.USER_ID).
CREATION_DATE Date when this row was created.
CREATED_BY User who created this row(Foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN Operation system login of user who last updated this row (Foreign
Key to FND_LOGINS.LOGIN_ID).
-
LAD Consulting Localizations Technical Reference Manual 14
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
Once every line in this table contains the additional Standard Who Columns with various Foreign
Keys corresponding to the FND_USERS and FND_LOGINS tables, you should not include
LAST_UPDATED_BY, CREATED_BY or LAST_UPDATE_LOGIN columns in the Foreign Keys
list of the table.
Standard Columns about the Who (for concurrent programs)
Several tables in Oracle Integrated Receiving application have standard columns about the USER, to
distinguish changes made by each user in the forms or in the concurrent programs. When a
concurrent program inserts or updates rows in a table, the following additional columns about the
responsible user are updated.:
REQUEST_ID Concurrent request id of the program that last updated this
row (Foreign Key to FND_CONCURRENT_REQUESTS.
REQUEST_ID).
PROGRAM_APPLICATION_ID Application id of the program that last updated this row
(Foreign Key to FND_APPLICATION.APLLICATION_ID).
PROGRAM_ID Program id of the program that last updated this row. (Foreign
Key to FND_CONCURRENT_PROGRAM.
CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE Date when a program last updated this row.
Once every table contains these additional Standard Who Columns with the various Foreign Keys to
the tables FND_CONCURRENT_REQUESTS, FND_APPLICATION and
FND_CONCURRENT_PROGRAM, you should then not include the REQUEST_ID,
PROGRAM_APPLICATION_ID or PROGRAM_ID columns in the Foreign Keys list of the table.
Indexes
In this topic you can identify all the indexes related to this table and the database columns that
implement this index sequentially.
-
LAD Consulting Localizations Technical Reference Manual 15
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
Table Definition for Magnetic Media based on GL
The Table Definition section contains a detailed definition of each table in Oracle General Ledger
Colombian Localizations. For each table, the following information are available: objective, column
description, primary key, unique key, check constraints, foreign key, indexes, quick codes, sequences
and database triggers.
CLL_F041_GL_CITY_CODES
Stores the cities with its codes and status.
Changes
No changes were applied to this table in this version.
Columns description
CITY NOT NULL VARCHAR2(25) Third Party Location City STATE NOT NULL VARCHAR2(50) Third Party Location State Code CITY_CODE NOT NULL VARCHAR2(5) Third Party Location City Code
Unique Keys
Name Column
CLL_F041_GL_CITY_CODES_U1 CITY_CODE
CLL_F041_GL_CITY_CODES_U2 STATE
CITY
Name Null? Type Description
STATUS NOT NULL VARCHAR2(1) Status
ATTRIBUTE1 NULL VARCHAR2(150) Free attribute 1
ATTRIBUTE2 NULL VARCHAR2(150) Free attribute 2
ATTRIBUTE3 NULL VARCHAR2(150) Free attribute 3
ATTRIBUTE4 NULL VARCHAR2(150) Free attribute 4
ATTRIBUTE5 NULL VARCHAR2(150) Free attribute 5
ATTRIBUTE6 NULL VARCHAR2(150) Free attribute 6
ATTRIBUTE7 NULL VARCHAR2(150) Free attribute 7
ATTRIBUTE8 NULL VARCHAR2(150) Free attribute 8
ATTRIBUTE9 NULL VARCHAR2(150) Free attribute 9
ATTRIBUTE10 NULL VARCHAR2(150) Free attribute 10
ATTRIBUTE11 NULL VARCHAR2(150) Free attribute 11
ATTRIBUTE12 NULL VARCHAR2(150) Free attribute 12
ATTRIBUTE13 NULL VARCHAR2(150) Free attribute 13
ATTRIBUTE14 NULL VARCHAR2(150) Free attribute 14
ATTRIBUTE15 NULL VARCHAR2(150) Free attribute 15
ATTRIBUTE_CATEGORY NULL VARCHAR2(150) Attribute Category
CREATED_BY NOT NULL NUMBER () Created By
CREATION_DATE NOT NULL DATE Creation Date
LAST_UPDATE_DATE NOT NULL DATE Last Updated By
LAST_UPDATED_BY NOT NULL NUMBER () Last Update Date
LAST_UPDATE_LOGIN NULL NUMBER () Last Update Login
-
LAD Consulting Localizations Technical Reference Manual 16
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
CLL_F041_GL_MG_FORMAT
Stores the Magnect Media formats
Changes
No changes were applied to this table in this version.
Columns description
FORMAT_ID NOT NULL NUMBER () Format Identification
SET_OF_BOOKS_ID NOT NULL NUMBER () Set Of Books Identification
FORMAT NOT NULL NUMBER (5) Format Code
ATTRIBUTE15 NULL VARCHAR2(150) Free attribute 15 ATTRIBUTE16 NULL VARCHAR2(150) Free attribute 16 ATTRIBUTE17 NULL VARCHAR2(150) Free attribute 17 ATTRIBUTE18 NULL VARCHAR2(150) Free attribute 18 ATTRIBUTE19 NULL VARCHAR2(150) Free attribute 19
Unique Keys
Name Column
CLL_F041_GL_MG_FORMAT_U1 FORMAT_ID
CLL_F041_GL_MG_FORMAT_U2
FORMAT
SET_OF_BOOKS_ID
YEAR
Name Null? Type Description
YEAR NOT NULL NUMBER(4) Year
TAG_DETAIL NOT NULL VARCHAR2(20) Detail
ATTRIBUTE1 NULL VARCHAR2(150) Free attribute 1
ATTRIBUTE2 NULL VARCHAR2(150) Free attribute 2
ATTRIBUTE3 NULL VARCHAR2(150) Free attribute 3
ATTRIBUTE4 NULL VARCHAR2(150) Free attribute 4
ATTRIBUTE5 NULL VARCHAR2(150) Free attribute 5
ATTRIBUTE6 NULL VARCHAR2(150) Free attribute 6
ATTRIBUTE7 NULL VARCHAR2(150) Free attribute 7
ATTRIBUTE8 NULL VARCHAR2(150) Free attribute 8
ATTRIBUTE9 NULL VARCHAR2(150) Free attribute 9
ATTRIBUTE10 NULL VARCHAR2(150) Free attribute 10
ATTRIBUTE11 NULL VARCHAR2(150) Free attribute 11
ATTRIBUTE12 NULL VARCHAR2(150) Free attribute 12
ATTRIBUTE13 NULL VARCHAR2(150) Free attribute 13
ATTRIBUTE14 NULL VARCHAR2(150) Free attribute 14
ATTRIBUTE20 NULL VARCHAR2(150) Free attribute 20
ATTRIBUTE_CATEGORY NULL VARCHAR2(150) Attribute Category
CREATED_BY NOT NULL NUMBER () Created By
CREATION_DATE NOT NULL DATE Creation Date
LAST_UPDATE_DATE NOT NULL DATE Last Updated By
LAST_UPDATED_BY NOT NULL NUMBER () Last Update Date
LAST_UPDATE_LOGIN NULL NUMBER () Last Update Login
-
LAD Consulting Localizations Technical Reference Manual 17
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
CLL_F041_GL_MG_FORMAT_COLS
Stores the Magnect Media formats
Columns description
FORMAT_ID_COL NOT NULL NUMBER () Format Column Identification
FORMAT_ID NOT NULL NUMBER () Format Identification
SEG NOT NULL NUMBER () Seg
COLUMN_NAME NULL VARCHAR2(60) Column Name
COLUMN_TYPE NULL VARCHAR2(20) Column Type
LENGTH_VALUE NULL NUMBER() Length Value
TAG NULL VARCHAR2(20) Tag
REQUIRED NULL VARCHAR2(1) Required
ATTRIBUTE15 NULL VARCHAR2(150) Free attribute 15
ATTRIBUTE16 NULL VARCHAR2(150) Free attribute 16 ATTRIBUTE17 NULL VARCHAR2(150) Free attribute 17 ATTRIBUTE18 NULL VARCHAR2(150) Free attribute 18 ATTRIBUTE19 NULL VARCHAR2(150) Free attribute 19
Unique Keys
Name Column
CLL_F041_GL_MG_FORMAT_COLS_U1 FORMAT_COL_ID
Name Null? Type Description
VAL_SUM NOT NULL VARCHAR2(1) Val Sum
ATTRIBUTE1 NULL VARCHAR2(150) Free attribute 1
ATTRIBUTE2 NULL VARCHAR2(150) Free attribute 2
ATTRIBUTE3 NULL VARCHAR2(150) Free attribute 3
ATTRIBUTE4 NULL VARCHAR2(150) Free attribute 4
ATTRIBUTE5 NULL VARCHAR2(150) Free attribute 5
ATTRIBUTE6 NULL VARCHAR2(150) Free attribute 6
ATTRIBUTE7 NULL VARCHAR2(150) Free attribute 7
ATTRIBUTE8 NULL VARCHAR2(150) Free attribute 8
ATTRIBUTE9 NULL VARCHAR2(150) Free attribute 9
ATTRIBUTE10 NULL VARCHAR2(150) Free attribute 10
ATTRIBUTE11 NULL VARCHAR2(150) Free attribute 11
ATTRIBUTE12 NULL VARCHAR2(150) Free attribute 12
ATTRIBUTE13 NULL VARCHAR2(150) Free attribute 13
ATTRIBUTE14 NULL VARCHAR2(150) Free attribute 14
ATTRIBUTE20 NULL VARCHAR2(150) Free attribute 20
ATTRIBUTE_CATEGORY NULL VARCHAR2(150) Attribute Category
CREATED_BY NOT NULL NUMBER () Created By
CREATION_DATE NOT NULL DATE Creation Date
LAST_UPDATE_DATE NOT NULL DATE Last Updated By
LAST_UPDATED_BY NOT NULL NUMBER () Last Update Date
LAST_UPDATE_LOGIN NULL NUMBER () Last Update Login
-
LAD Consulting Localizations Technical Reference Manual 18
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
CLL_F041_GL_MG_HEADER
Stores the Magnect Media Header
Changes
No changes were applied to this table in this version.
Columns description
MG_HEADER_ID NOT NULL NUMBER () Header Identification
SET_OF_BOOKS_ID NULL NUMBER(15) Set Of Books Identification
REPORTED_YEAR NULL VARCHAR2(4) Reported Year
REGISTER_TYPE NULL VARCHAR2(1) Register Type
PERSON_TYPE NULL VARCHAR2(2) Person Type
COMPANY_NIT NULL VARCHAR2(14) Company Nit
VERIFYING_DIGIT NULL VARCHAR2(1) Verifying Name
COMPANY_NAME NULL VARCHAR2(60) Company Name
ECONOMIC_ACTIVITY_CODE NULL VARCHAR2(4) Economic Activity Code
CITY_CODE NULL VARCHAR2(5) City Code
COUNT_LITERAL NULL NUMBER() Count Literal
TOTAL_VALUE NULL NUMBER () Total Value
EMAIL NULL VARCHAR2 (40) Email
CONCEPT NULL NUMBER(2) Concept Code
FORMAT NULL NUMBER(5) Format Code
SHIPMENT_DATE NULL DATE Shipmet Date
START_DATE NULL DATE Start Date
END_DATE NULL DATE End Date
ATTRIBUTE1 NULL VARCHAR2(150) Free attribute 1
ATTRIBUTE15 NULL VARCHAR2(150) Free attribute 15
ATTRIBUTE16 NULL VARCHAR2(150) Free attribute 16 ATTRIBUTE17 NULL VARCHAR2(150) Free attribute 17 ATTRIBUTE18 NULL VARCHAR2(150) Free attribute 18 ATTRIBUTE19 NULL VARCHAR2(150) Free attribute 19
Unique Keys
Name Column
CLL_F041_GL_MG_HEADER_U1 MG_HEADER_ID
CLL_F041_GL_MG_HEADER_U2
SET_OF_BOOKS_ID
REPORTED_YEAR
FORMAT
Name Null? Type Description
COMPANY_ADDRESS NULL VARCHAR2(40) Company Address
ATTRIBUTE2 NULL VARCHAR2(150) Free attribute 2
ATTRIBUTE3 NULL VARCHAR2(150) Free attribute 3
ATTRIBUTE4 NULL VARCHAR2(150) Free attribute 4
ATTRIBUTE5 NULL VARCHAR2(150) Free attribute 5
ATTRIBUTE6 NULL VARCHAR2(150) Free attribute 6
ATTRIBUTE7 NULL VARCHAR2(150) Free attribute 7
ATTRIBUTE8 NULL VARCHAR2(150) Free attribute 8
ATTRIBUTE9 NULL VARCHAR2(150) Free attribute 9
ATTRIBUTE10 NULL VARCHAR2(150) Free attribute 10
ATTRIBUTE11 NULL VARCHAR2(150) Free attribute 11
ATTRIBUTE12 NULL VARCHAR2(150) Free attribute 12
ATTRIBUTE13 NULL VARCHAR2(150) Free attribute 13
ATTRIBUTE14 NULL VARCHAR2(150) Free attribute 14
ATTRIBUTE20 NULL VARCHAR2(150) Free attribute 20
ATTRIBUTE_CATEGORY NULL VARCHAR2(150) Attribute Category
CREATED_BY NOT NULL NUMBER () Created By
CREATION_DATE NOT NULL DATE Creation Date
LAST_UPDATE_DATE NOT NULL DATE Last Updated By
LAST_UPDATED_BY NOT NULL NUMBER () Last Update Date
LAST_UPDATE_LOGIN NULL NUMBER () Last Update Login
-
LAD Consulting Localizations Technical Reference Manual 19
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
CLL_F041_GL_MG_LINES
Stores the Magnect Media Lines
Changes
No changes were applied to this table in this version.
Columns description
MG_LINE_ID NOT NULL NUMBER () Line Identification
MG_HEADER_ID NOT NULL NUMBER () Header Identification
SET_OF_BOOKS_ID NULL NUMBER(15) Set Of Books Identification
REPORTED_YEAR NULL VARCHAR2(4) Reported Year
REGISTER_TYPE NULL VARCHAR2(1) Register Type
LITERAL_CODE NULL VARCHAR2(4) Literal Code
NIT NULL VARCHAR2(14) Third Party NIT Code
VERIFYING_DIGIT NULL VARCHAR2(1) Validation Digit
NIT_TYPE NULL VARCHAR2(2) Third Party NIT Type
NAME NULL VARCHAR2(60) Third Party Name
SECOND_REPORTED_VALUE NULL NUMBER () Second Reported Value
THIRD_REPORTED_VALUE NULL NUMBER() Third Reported Value
ADDRESS NULL VARCHAR2(200) Third Party Address
CITY_CODE NULL VARCHAR2 (5) Third Party City
CONCEPT NULL NUMBER(4) Concept Code
FIRST_NAME NULL VARCHAR2(60) Third Party First Name
MIDDLE_NAME NULL VARCHAR2(60) Third Party Middle Name LAST_NAME NULL VARCHAR2(60) Third Party Last Name MOTHER_LAST_NAME NULL VARCHAR2(60) Third Party Mother Name
ATTRIBUTE1 NULL VARCHAR2(150) Free attribute 1
ATTRIBUTE15 NULL VARCHAR2(150) Free attribute 15
ATTRIBUTE16 NULL VARCHAR2(150) Free attribute 16 ATTRIBUTE17 NULL VARCHAR2(150) Free attribute 17 ATTRIBUTE18 NULL VARCHAR2(150) Free attribute 18 ATTRIBUTE19 NULL VARCHAR2(150) Free attribute 19
Unique Keys
Name Column
CLL_F041_GL_MG_LINES _U1 MG_LINE_ID
CLL_F041_GL_MG_LINES _N1 REPORTED_YEAR
SET_OF_BOOKS_ID
Name Null? Type Description
FIRST_REPORTED_VALUE NULL NUMBER() First Reported Value
ATTRIBUTE2 NULL VARCHAR2(150) Free attribute 2
ATTRIBUTE3 NULL VARCHAR2(150) Free attribute 3
ATTRIBUTE4 NULL VARCHAR2(150) Free attribute 4
ATTRIBUTE5 NULL VARCHAR2(150) Free attribute 5
ATTRIBUTE6 NULL VARCHAR2(150) Free attribute 6
ATTRIBUTE7 NULL VARCHAR2(150) Free attribute 7
ATTRIBUTE8 NULL VARCHAR2(150) Free attribute 8
ATTRIBUTE9 NULL VARCHAR2(150) Free attribute 9
ATTRIBUTE10 NULL VARCHAR2(150) Free attribute 10
ATTRIBUTE11 NULL VARCHAR2(150) Free attribute 11
ATTRIBUTE12 NULL VARCHAR2(150) Free attribute 12
ATTRIBUTE13 NULL VARCHAR2(150) Free attribute 13
ATTRIBUTE14 NULL VARCHAR2(150) Free attribute 14
ATTRIBUTE20 NULL VARCHAR2(150) Free attribute 20
ATTRIBUTE_CATEGORY NULL VARCHAR2(150) Attribute Category
CREATED_BY NOT NULL NUMBER () Created By
CREATION_DATE NOT NULL DATE Creation Date
LAST_UPDATE_DATE NOT NULL DATE Last Updated By
LAST_UPDATED_BY NOT NULL NUMBER () Last Update Date
LAST_UPDATE_LOGIN NULL NUMBER () Last Update Login
NIT_ID NOT NULL NUMBER ()
OWNER_NIT_ID NOT NULL NUMBER ()
FOURTH_REPORTED_VALUE NULL NUMBER() Fourth Value
FIFTH_REPORTED_VALUE NULL NUMBER() Fifth Value
SIXTH_REPORTED_VALUE NULL NUMBER() Sixth Value
SEVENTH_REPORTED_VALUE NULL NUMBER() Seventh Value
EIGHTH_REPORTED_VALUE NULL NUMBER() Eighth Value
NINTH_REPORTED_VALUE NULL NUMBER() Ninth Value
-
LAD Consulting Localizations Technical Reference Manual 20
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
CLL_F041_GL_MG_LITERALS_EXT
Stores the Magnect Media Literals Extension
Changes
No changes were applied to this table in this version.
Columns description
LITERAL_ID NULL NUMBER(15) Literal Identification
ATTRIBUTE1 NULL VARCHAR2(150) Free attribute 1
ATTRIBUTE15 NULL VARCHAR2(150) Free attribute 15
Unique Keys
Name Column
CLL_F041_GL_MG_LITERALS_EXT_U1 LITERAL_ID
Name Null? Type Description
ATTRIBUTE2 NULL VARCHAR2(150) Free attribute 2
ATTRIBUTE3 NULL VARCHAR2(150) Free attribute 3
ATTRIBUTE4 NULL VARCHAR2(150) Free attribute 4
ATTRIBUTE5 NULL VARCHAR2(150) Free attribute 5
ATTRIBUTE6 NULL VARCHAR2(150) Free attribute 6
ATTRIBUTE7 NULL VARCHAR2(150) Free attribute 7
ATTRIBUTE8 NULL VARCHAR2(150) Free attribute 8
ATTRIBUTE9 NULL VARCHAR2(150) Free attribute 9
ATTRIBUTE10 NULL VARCHAR2(150) Free attribute 10
ATTRIBUTE11 NULL VARCHAR2(150) Free attribute 11
ATTRIBUTE12 NULL VARCHAR2(150) Free attribute 12
ATTRIBUTE13 NULL VARCHAR2(150) Free attribute 13
ATTRIBUTE14 NULL VARCHAR2(150) Free attribute 14
ATTRIBUTE_CATEGORY NULL VARCHAR2(150) Attribute Category
CREATED_BY NOT NULL NUMBER () Created By
CREATION_DATE NOT NULL DATE Creation Date
LAST_UPDATE_DATE NOT NULL DATE Last Updated By
LAST_UPDATED_BY NOT NULL NUMBER () Last Update Date
LAST_UPDATE_LOGIN NULL NUMBER () Last Update Login
-
LAD Consulting Localizations Technical Reference Manual 21
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
CLL_F041_GL_NITS_EXT
Stores the Magnetic Media NIT Extension.
Changes
Add and alter columns in this version
Columns description Name Null? Type Description
NIT_ID N NUMBER(15) Third Party NIT Code
CREATED_BY N NUMBER(15) Standard who column
LAST_UPDATED_BY N NUMBER(15) Standard who column
CREATION_DATE N DATE Standard who column
LAST_UPDATE_DATE N DATE Standard who column
LAST_UPDATE_LOGIN Y NUMBER(15) Standard who column
ATTRIBUTE_CATEGORY Y VARCHAR2(30) Attribute Category
ATTRIBUTE1 Y VARCHAR2(150) Free attribute 1
ATTRIBUTE2 Y VARCHAR2(150) Free attribute 2
ATTRIBUTE3 Y VARCHAR2(150) Free attribute 3
ATTRIBUTE4 Y VARCHAR2(150) Free attribute 4
ATTRIBUTE5 Y VARCHAR2(150) Free attribute 5
ATTRIBUTE6 Y VARCHAR2(150) Free attribute 6
ATTRIBUTE7 Y VARCHAR2(150) Free attribute 7
ATTRIBUTE8 Y VARCHAR2(150) Free attribute 8
ATTRIBUTE9 Y VARCHAR2(150) Free attribute 9
ATTRIBUTE10 Y VARCHAR2(150) Free attribute 10
ATTRIBUTE11 Y VARCHAR2(150) Free attribute 11
ATTRIBUTE12 Y VARCHAR2(150) Free attribute 12
ATTRIBUTE13 Y VARCHAR2(150) Free attribute 13
ATTRIBUTE14 Y VARCHAR2(150) Free attribute 14
ATTRIBUTE15 Y VARCHAR2(150) Free attribute 15
DOCUMENT_TYPE Y VARCHAR2(20) Document Type
DOCUMENT Y VARCHAR2(20) Document
NAME Y VARCHAR2(360) Name
FIRST_NAME Y VARCHAR2(60) First Name
SECOND_NAME Y VARCHAR2(60) Second Name
FIRST_SURNAME Y VARCHAR2(60) First Surname
SECOND_SURNAME Y VARCHAR2(60) Second Surname
COUNTRY_CODE Y VARCHAR2(30) Geography Country code
CITY_CODE Y VARCHAR2(30) Geography City code
ADDRESS Y VARCHAR2(360) Address
PHONE_NUMBER Y VARCHAR2(20) Phone
PHONE_NUMBER2 Y VARCHAR2(20) Phone
STATE_CODE Y VARCHAR2(30) Geography State code
Unique Keys Name Column
CLL_F041_GL_NITS_EXT_U1 NIT_ID
-
LAD Consulting Localizations Technical Reference Manual 22
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
-
LAD Consulting Localizations Technical Reference Manual 23
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
Table Definition for Magnetic Media based on SLA
The Table Definition section contains a detailed definition of each table in Oracle General Ledger
Colombian Localizations. For each table, the following information are available: objective, column
description, primary key, unique key, check constraints, foreign key, indexes, quick codes, sequences
and database triggers.
CLL_F041_COMPANIES
Company definition.
Changes
No changes were applied to this table in this version.
Columns description Name Null? Type Description
COMPANY_ID NULL NUMBER Company Identification
COMPANY_CODE NULL VARCHAR2(10) Company Code (for use in Interfaces)
COMPANY_NAME NULL VARCHAR2(200) Company Name
REPORTING_YEAR NULL NUMBER Reporting Year
CHART_OF_ACCOUNTS_ID NOT NULL NUMBER Chart Of Accounts Identification
CREATED_BY NOT NULL NUMBER Created By
CREATION_DATE NOT NULL DATE Creation Date
LAST_UPDATED_BY NOT NULL NUMBER Last Updated By
LAST_UPDATE_DATE NOT NULL DATE Last Update Date
LAST_UPDATE_LOGIN NULL NUMBER Last Update Login
Unique Keys Name Column
CLL_F041_COMPANIES_U1 COMPANY_ID
-
LAD Consulting Localizations Technical Reference Manual 24
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
CLL_F041_COMPANY_BOOKS
Company Books and BSV assignment
Changes
No changes were applied to this table in this version.
Columns description Name Null? Type Description
COMPANY_ID NULL NUMBER Company Identification
LEDGER_ID NULL NUMBER Ledger Identification
BSV NULL VARCHAR2(30) Company Balancing Segment Value
CREATED_BY NOT NULL NUMBER Created By
CREATION_DATE NOT NULL DATE Creation Date
LAST_UPDATED_BY NOT NULL NUMBER Last Updated By
LAST_UPDATE_DATE NOT NULL DATE Last Update Date
LAST_UPDATE_LOGIN NULL NUMBER Last Update Login
Unique Keys Name Column
CLL_F041_COMPANY_BOOKS_U1
COMPANY_ID
LEDGER_ID
BSV
-
LAD Consulting Localizations Technical Reference Manual 25
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
CLL_F041_COMPANY_LES
Company Legal Entity assignments
Changes
No changes were applied to this table in this version.
Columns description Name Null? Type Description
COMPANY_ID NULL NUMBER Company Identification
LEGAL_ENTITY_ID NULL NUMBER Ledger Identification
CREATED_BY NOT NULL NUMBER Created By
CREATION_DATE NOT NULL DATE Creation Date
LAST_UPDATED_BY NOT NULL NUMBER Last Updated By
LAST_UPDATE_DATE NOT NULL DATE Last Update Date
LAST_UPDATE_LOGIN NULL NUMBER Last Update Login
Unique Keys Name Column
CLL_F041_COMPANY_LES_U1 COMPANY_ID
LEGAL_ENTITY_ID
-
LAD Consulting Localizations Technical Reference Manual 26
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
CLL_F041_MMEDIA_BALANCES
Year Balances Table.
Changes
Add columns for reported values 1.. 9
Columns description Name Null? Type Description
BAL_LINE_ID NULL NUMBER Balance Line Identification
HEADER_ID NULL NUMBER Header Identification (if origin_system is Oracle
REPORTED_YEAR NULL NUMBER Reported Year
COMPANY_ID NULL NUMBER Company Identification (based on
CLL_F041_COMPANIES)
COMPANY_CODE NULL VARCHAR2(10) Company Code (based on
CLL_F041_COMPANIES)
CREATED_BY NOT NULL NUMBER Created By
CREATION_DATE NOT NULL DATE Creation Date
LAST_UPDATED_BY NOT NULL NUMBER Last Updated By
LAST_UPDATE_DATE NOT NULL DATE Last Update Date
LAST_UPDATE_LOGIN NULL NUMBER Last Update Login
FORMAT_CODE NULL VARCHAR2(30) Format Code
CONCEPT_CODE NULL VARCHAR2(30) Concept Code
DOCUMENT_TYPE NULL VARCHAR2(30) Document Type Code
NIT_CODE NULL VARCHAR2(30) Third Party NIT Code
NIT_VD NULL VARCHAR2(5) Third Party NIT Validation Digit
LAST_NAME1 NULL VARCHAR2(100) First Part of Individual Last Name
LAST_NAME2 NULL VARCHAR2(100) Second Part of Individual Last Name
FIRST_NAME NULL VARCHAR2(100) First name of Individual
SECOND_NAME NULL VARCHAR2(100) Second Names of Individual
PARTY_NAME NULL VARCHAR2(200) Third Party Name
ADDRESS NULL VARCHAR2(200) Third Party Location Address
DEPT_CODE NULL VARCHAR2(10) Third Party Location Department Code
CITY_CODE NULL VARCHAR2(10) Third Party Location City Code
COUNTRY_CODE NULL VARCHAR2(10) Third Party Location Country Code
FIRST_VALUE NULL NUMBER Reported First Value
SECOND_VALUE NULL NUMBER Reported Second Value
THIRD_VALUE NULL NUMBER Reported Third Value
ORIGIN_SYSTEM NULL VARCHAR2(10) System of Origin: ORACLE / OTHERS
REPORTED_VALUE_1 NULL
NUMBER Reported vale 1
REPORTED_VALUE_2 NULL
NUMBER Reported vale 2
REPORTED_VALUE_3 NULL
NUMBER Reported vale 3
REPORTED_VALUE_4 NULL
NUMBER Reported vale 4
REPORTED_VALUE_5 NULL
NUMBER Reported vale 5
REPORTED_VALUE_6 NULL
NUMBER Reported vale 6
REPORTED_VALUE_7 NULL
NUMBER Reported vale 7
REPORTED_VALUE_8 NULL
NUMBER Reported vale 8
REPORTED_VALUE_9 NULL
NUMBER Reported vale 9
Unique Keys Name Column
CLL_F041_MMEDIA_BALANCES_U1
BAL_LINE_ID
-
LAD Consulting Localizations Technical Reference Manual 27
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
CLL_F041_MMEDIA_CONCEPTS
Magnetic Media Concepts.
Changes
No changes were applied to this table in this version.
Columns description Name Null? Type Description
FORMAT_ID Y NUMBER Format Identification
CONCEPT_ID Y NUMBER Concept Identification
CONCEPT_CODE Y VARCHAR2(30) Concept Code
DESCRIPTION Y VARCHAR2(100) Concept Description
THRESHOLD_VALUE Y NUMBER Threshold Value
CONTROL_BALANCES Y VARCHAR2(1) Control Balances Indicator (Y/NULL)
CREATED_BY N NUMBER Created By
CREATION_DATE N DATE Creation Date
LAST_UPDATED_BY N NUMBER Last Updated By
LAST_UPDATE_DATE N DATE Last Update Date
LAST_UPDATE_LOGIN Y NUMBER Last Update Login
THRESHOLD_EXCLUDE_FLAG Y VARCHAR2(1) Threshold Exclude Flag
INTERFACE_FLAG Y VARCHAR2(1) Interface Falg
Unique Keys Name Column
CLL_F041_MMEDIA_CONCEPTS_U1 CONCEPT_ID
CLL_F041_MMEDIA_CONCEPTS_U2 FORMAT_ID
CONCEPT_ID
CLL_F041_MMEDIA_CONCEPTS_U3 CONCEPT_CODE
FORMAT_ID
-
LAD Consulting Localizations Technical Reference Manual 28
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
CLL_F041_MMEDIA_FINAL
Detailed information about finalized Magnetic Media generation.
Changes
No changes were applied to this table in this version.
Columns description Name Null? Type Description
HEADER_ID Y NUMBER Header Identification
LINE_ID Y NUMBER Line Identification
REPORTED_YEAR Y NUMBER Reported Year
COMPANY_ID Y NUMBER
Company Identification (based on
CLL_F041_COMPANIES)
COMPANY_CODE Y VARCHAR2(10)
Company Code (based on
CLL_F041_COMPANIES)
CREATED_BY N NUMBER Created By
CREATION_DATE N DATE Creation Date
LAST_UPDATED_BY N NUMBER Last Updated By
LAST_UPDATE_DATE N DATE Last Update Date
LAST_UPDATE_LOGIN Y NUMBER Last Update Login
FORMAT_CODE Y VARCHAR2(30) Format Code
CONCEPT_CODE Y VARCHAR2(30) Concept Code
DOCUMENT_TYPE Y VARCHAR2(30) Document Type Code
NIT_CODE Y VARCHAR2(30) Third Party NIT Code
NIT_VD Y VARCHAR2(5) Third Party NIT Validation Digit
LAST_NAME1 Y VARCHAR2(100) First Part of Individual Last Name
LAST_NAME2 Y VARCHAR2(100) Second Part of Individual Last Name
FIRST_NAME Y VARCHAR2(100) First name of Individual
SECOND_NAME Y VARCHAR2(100) Second Names of Individual
PARTY_NAME Y VARCHAR2(200) Third Party Name
ADDRESS Y VARCHAR2(200) Third Party Location - Address
DEPT_CODE Y VARCHAR2(10) Third Party Location Department Code
CITY_CODE Y VARCHAR2(10) Third Party Location City Code
COUNTRY_CODE Y VARCHAR2(10) Third Party Location Country Code
CODE_COMBINATION_ID Y NUMBER GL Code Combination Identification
ORIGIN Y VARCHAR2(10)
Origin of Information: Interface / Balances / Oracle
/ Manual
SOURCE_ID Y NUMBER Source Identification
ATTRIBUTE1 Y VARCHAR2(150) Free attribute 1
ATTRIBUTE2 Y VARCHAR2(150) Free attribute 2
ATTRIBUTE3 Y VARCHAR2(150) Free attribute 3
ATTRIBUTE4 Y VARCHAR2(150) Free attribute 4
ATTRIBUTE5 Y VARCHAR2(150) Free attribute 5
ATTRIBUTE6 Y VARCHAR2(150) Free attribute 6
ATTRIBUTE7 Y VARCHAR2(150) Free attribute 7
ATTRIBUTE8 Y VARCHAR2(150) Free attribute 8
ATTRIBUTE9 Y VARCHAR2(150) Free attribute 9
ATTRIBUTE10 Y VARCHAR2(150) Free attribute 10
ATTRIBUTE11 Y VARCHAR2(150) Free attribute 11
ATTRIBUTE12 Y VARCHAR2(150) Free attribute 12
ATTRIBUTE13 Y VARCHAR2(150) Free attribute 13
ATTRIBUTE14 Y VARCHAR2(150) Free attribute 14
ATTRIBUTE15 Y VARCHAR2(150) Free attribute 15
ATTRIBUTE_CATEGORY Y VARCHAR2(150) Attribute Category
REPORTED_VALUE_1 Y NUMBER Reported Value 1
REPORTED_VALUE_2 Y NUMBER Reported Value 2
-
LAD Consulting Localizations Technical Reference Manual 29
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
REPORTED_VALUE_3 Y NUMBER Reported Value 3
REPORTED_VALUE_4 Y NUMBER Reported Value 4
REPORTED_VALUE_5 Y NUMBER Reported Value 5
REPORTED_VALUE_6 Y NUMBER Reported Value 6
REPORTED_VALUE_7 Y NUMBER Reported Value 7
REPORTED_VALUE_8 Y NUMBER Reported Value 8
REPORTED_VALUE_9 Y NUMBER Reported Value 9
Unique Keys Name Column
CLL_F041_MMEDIA_FINAL_U1 LINE_ID
-
LAD Consulting Localizations Technical Reference Manual 30
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
CLL_F041_MMEDIA_FORMATS
Magnetic Media Formats.
Changes
No changes were applied to this table in this version.
Columns description
Name
Null? Type Description
FORMAT_ID Y NUMBER Format Identification
FORMAT_CODE Y VARCHAR2(30) Format Code
COMPANY_ID Y NUMBER
Company Identification (based on
CLL_F041_COMPANIES)
REPORTED_YEAR Y NUMBER Reported Year
DESCRIPTION Y VARCHAR2(100) Format Description
THRESHOLD_VALUE Y NUMBER Threshold Value
THIRD_PARTY_FLAG Y VARCHAR2(1) Third Party
CREATED_BY NUMBER Created By
CREATION_DATE DATE Creation Date
LAST_UPDATED_BY NUMBER Last Updated By
LAST_UPDATE_DATE DATE Last Update Date
LAST_UPDATE_LOGIN Y NUMBER Last Update Login
SOURCE_VALUES Y VARCHAR2(100)
SOURCE_FLAG_AP Y VARCHAR2(1) Payables flag
SOURCE_FLAG_AR Y VARCHAR2(1) Receivables flag
SOURCE_FLAG_GL Y VARCHAR2(1) Ledger flag
SOURCE_FLAG_CASH Y VARCHAR2(1) Cash flag
SOURCE_FLAG_FA Y VARCHAR2(1) Fixed Asset flag
SOURCE_FLAG_INV Y VARCHAR2(1) Inventory flag
THRESHOLD_SUMMARY_VAL
UE Y NUMBER Threshold Summary Value
Unique Keys Name Column
CLL_F041_MMEDIA_FORMATS_U2
COMPANY_ID
REPORTED_YEAR
FORMAT_CODE
-
LAD Consulting Localizations Technical Reference Manual 31
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
CLL_F041_MMEDIA_HEADER
Header table to control each company/year processing.
Changes
No changes were applied to this table in this version.
Columns description Name Null? Type Description
HEADER_ID NULL NUMBER Header Identification
REPORTED_YEAR NULL NUMBER Reported Year
STATUS NULL VARCHAR2(10) Status
COMPANY_ID NULL NUMBER Company Identification (based on
CLL_F041_COMPANIES)
COMPANY_CODE NULL VARCHAR2(10) Company Code (based on
CLL_F041_COMPANIES)
CREATED_BY NOT NULL NUMBER Created By
CREATION_DATE NOT NULL DATE Creation Date
LAST_UPDATED_BY NOT NULL NUMBER Last Updated By
LAST_UPDATE_DATE NOT NULL DATE Last Update Date
LAST_UPDATE_LOGIN NULL NUMBER Last Update Login
Unique Keys Name Column
CLL_F041_MMEDIA_HEADER_U1
HEADER_ID
-
LAD Consulting Localizations Technical Reference Manual 32
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
CLL_F041_MMEDIA_IFACE
Interface table for external sources.
Changes
No changes were applied to this table in this version.
Columns description Name Null? Type Description
LINE_ID Y NUMBER Interface Line Identification
REPORTED_YEAR N NUMBER Reported Year
COMPANY_ID N NUMBER
Company Identification (based on
CLL_F041_COMPANIES)
COMPANY_CODE Y VARCHAR2(10)
Company Code (based on
CLL_F041_COMPANIES)
CREATED_BY N NUMBER Created By
CREATION_DATE N DATE Creation Date
LAST_UPDATED_BY N NUMBER Last Updated By
LAST_UPDATE_DATE N DATE Last Update Date
LAST_UPDATE_LOGIN Y NUMBER Last Update Login
FORMAT_CODE N VARCHAR2(30) Format Code
CONCEPT_CODE N VARCHAR2(30) Concept Code
DOCUMENT_TYPE Y VARCHAR2(30) Document Type Code
NIT_CODE N VARCHAR2(30) Third Party NIT Code
NIT_VD Y VARCHAR2(5) Third Party NIT Validation Digit
LAST_NAME1 Y VARCHAR2(100) First Part of Individual Last Name
LAST_NAME2 Y VARCHAR2(100) Second Part of Individual Last Name
FIRST_NAME Y VARCHAR2(100) First name of Individual
SECOND_NAME Y VARCHAR2(100) Second Names of Individual
PARTY_NAME Y VARCHAR2(200) Third Party Name
ADDRESS Y VARCHAR2(200) Third Party Location - Address
DEPT_CODE Y VARCHAR2(10) Third Party Location Department Code
CITY_CODE Y VARCHAR2(10) Third Party Location City Code
COUNTRY_CODE Y VARCHAR2(10) Third Party Location Country Code
STATUS Y VARCHAR2(20) Interface Line Status Code
ERROR_CODE Y VARCHAR2(5) Interface Line Error Code
ERROR_TEXT Y VARCHAR2(100) Interface Line Error Text
REPORTED_VALUE_1 N NUMBER Reported Value 1
REPORTED_VALUE_2 Y NUMBER Reported Value 2
REPORTED_VALUE_3 Y NUMBER Reported Value 3
REPORTED_VALUE_4 Y NUMBER Reported Value 4
REPORTED_VALUE_5 Y NUMBER Reported Value 5
REPORTED_VALUE_6 Y NUMBER Reported Value 6
REPORTED_VALUE_7 Y NUMBER Reported Value 7
REPORTED_VALUE_8 Y NUMBER Reported Value 8
REPORTED_VALUE_9 Y NUMBER Reported Value 9
Unique Keys
Name Column
CLL_F041_MMEDIA_IFACE_U1 LINE_ID
-
LAD Consulting Localizations Technical Reference Manual 33
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
CLL_F041_MMEDIA_IFACE_ERRORS
Interface table for external sources
Changes
No changes were applied to this table in this version.
Columns description Name Null? Type Description
IFACE_ERROR_LINE_ID NULL NUMBER Reported Value Identification
LINE_ID NULL NUMBER Format Identification
CREATED_BY NOT NULL NUMBER Created By
CREATION_DATE NOT NULL DATE Creation Date
LAST_UPDATED_BY NOT NULL NUMBER Last Updated By
LAST_UPDATE_DATE NOT NULL DATE Last Update Date
LAST_UPDATE_LOGIN NULL NUMBER Last Update Login
ERROR_CODE NULL VARCHAR2(50) Interface Line Error Code
ERROR_TEXT NULL VARCHAR2(100) Interface Line Error Text
Unique Keys Name Column
CLL_F041_MM_IFACE_ERRORS_U1 IFACE_ERROR_LINE_ID
CLL_F041_MM_IFACE_ERRORS_U2
LINE_ID
IFACE_ERROR_LINE_ID
-
LAD Consulting Localizations Technical Reference Manual 34
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
CLL_F041_MMEDIA_LINES
Working table for Magnetic Media calculation.
Changes
Add and alter columns in this version.
Columns description Name Null? Type Description
HEADER_ID Y NUMBER Header Identification
LINE_ID Y NUMBER Line Identification
REPORTED_YEAR N NUMBER Reported Year
COMPANY_ID N NUMBER
Company Identification (based on
CLL_F041_COMPANIES)
COMPANY_CODE Y VARCHAR2(10)
Company Code (based on
CLL_F041_COMPANIES)
CREATED_BY N NUMBER Created By
CREATION_DATE N DATE Creation Date
LAST_UPDATED_BY N NUMBER Last Updated By
LAST_UPDATE_DATE N DATE Last Update Date
LAST_UPDATE_LOGIN Y NUMBER Last Update Login
FORMAT_CODE N VARCHAR2(30) Format Code
CONCEPT_CODE N VARCHAR2(30) Concept Code
DOCUMENT_TYPE Y VARCHAR2(30) Document Type Code
NIT_CODE N VARCHAR2(30) Third Party NIT Code
NIT_VD Y VARCHAR2(5) Third Party NIT Validation Digit
LAST_NAME1 Y VARCHAR2(100) First Part of Individual Last Name
LAST_NAME2 Y VARCHAR2(100) Second Part of Individual Last Name
FIRST_NAME Y VARCHAR2(100) First name of Individual
SECOND_NAME Y VARCHAR2(100) Second Names of Individual
PARTY_NAME Y VARCHAR2(200) Third Party Name
ADDRESS Y VARCHAR2(200) Third Party Location - Address
DEPT_CODE Y VARCHAR2(10) Third Party Location Department Code
CITY_CODE Y VARCHAR2(10) Third Party Location City Code
COUNTRY_CODE Y VARCHAR2(10) Third Party Location Country Code
CODE_COMBINATION_ID Y NUMBER GL Code Combination Identification
ORIGIN Y VARCHAR2(10)
Origin of Information: Interface / Balances / Oracle
/ Manual
SOURCE_ID Y NUMBER Source Identification
ATTRIBUTE1 Y VARCHAR2(150) Free attribute 1
ATTRIBUTE2 Y VARCHAR2(150) Free attribute 2
ATTRIBUTE3 Y VARCHAR2(150) Free attribute 3
ATTRIBUTE4 Y VARCHAR2(150) Free attribute 4
ATTRIBUTE5 Y VARCHAR2(150) Free attribute 5
ATTRIBUTE6 Y VARCHAR2(150) Free attribute 6
ATTRIBUTE7 Y VARCHAR2(150) Free attribute 7
ATTRIBUTE8 Y VARCHAR2(150) Free attribute 8
ATTRIBUTE9 Y VARCHAR2(150) Free attribute 9
ATTRIBUTE10 Y VARCHAR2(150) Free attribute 10
ATTRIBUTE11 Y VARCHAR2(150) Free attribute 11
ATTRIBUTE12 Y VARCHAR2(150) Free attribute 12
ATTRIBUTE13 Y VARCHAR2(150) Free attribute 13
ATTRIBUTE14 Y VARCHAR2(150) Free attribute 14
ATTRIBUTE15 Y VARCHAR2(150) Free attribute 15
ATTRIBUTE_CATEGORY Y VARCHAR2(150) Attribute Category
REPORTED_VALUE_1 N NUMBER Reported Value 1
REPORTED_VALUE_2 Y NUMBER Reported Value 2
-
LAD Consulting Localizations Technical Reference Manual 35
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
REPORTED_VALUE_3 Y NUMBER Reported Value 3
REPORTED_VALUE_4 Y NUMBER Reported Value 4
REPORTED_VALUE_5 Y NUMBER Reported Value 5
REPORTED_VALUE_6 Y NUMBER Reported Value 6
REPORTED_VALUE_7 Y NUMBER Reported Value 7
REPORTED_VALUE_8 Y NUMBER Reported Value 8
REPORTED_VALUE_9 Y NUMBER Reported Value 9
REPORTED_FLAG Y VARCHAR2(1) Reported Flag
PERIOD_NAME Y VARCHAR2(15) Period
LINE_TYPE_LOOKUP_CODE Y
VARCHAR2 (50) Line Type code
TAX_TYPE Y
VARCHAR2 (50) Tax type
TAX_NAME Y
VARCHAR2 (50) Tax Name
ACCOUNT_NUMBER_RELATED Y
VARCHAR2 (40) Account Number related
CODE_COMBINATION_ID_REL
ATED
Y
NUMBER Account id related
CATEGORY Y
VARCHAR2 (40 Category
ACCOUNT_NUMBER Y
VARCHAR2 (40 Account Number
Unique Keys Name Column
CLL_F041_MMEDIA_LINES_N1
COMPANY_ID
FORMAT_CODE
NIT_CODE
CONCEPT_CODE
CLL_F041_MMEDIA_LINES_U1 LINE_ID
-
LAD Consulting Localizations Technical Reference Manual 36
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
CLL_F041_PARTY_BAL_IFACE
Interface table for third party balances update
Changes
New table in this version
Columns description Name Null? Type Description
LINE_ID N NUMBER Line Identification
LEDGER_ID N NUMBER Ledger Identification
PARTY_PERIOD_ID Y NUMBER
Period Identification (based on
CLL_F041_PARTY_PERIODS)
PERIOD_NAME Y VARCHAR2 (15)
Period Identification (based on
CLL_F041_PARTY_PERIODS)
THIRD_PARTY_NIT N VARCHAR2 (40) Third party nit (based on JL_CO_GL_NITS)
THIRD_PARTY_NIT_DGT Y VARCHAR2 (10) Third party dv (based on JL_CO_GL_NITS)
THIRD_PARTY_NAME Y VARCHAR2 (400) Third party name (based on JL_CO_GL_NITS)
BSV_VALUE Y VARCHAR2 (40) Balancing Segment Value
ACCOUNT_NUMBER Y VARCHAR2 (40) Account Number
CODE_COMBINATION_ID N NUMBER Code combination identification
BEGIN_BALANCE N NUMBER Begin Balance
ACCOUNTED_DR N NUMBER Accounted Debit
ACCOUNTED_CR N NUMBER Accounted Credit
END_BALANCE N NUMBER End Balance
CREATION_DATE N DATE Created By
CREATED_BY N NUMBER Creation Date
LAST_UPDATE_DATE N DATE Last Updated By
LAST_UPDATED_BY N NUMBER Last Update Date
LAST_UPDATE_LOGIN Y NUMBER Last Update Login
STATUS Y VARCHAR2 (20) Line Status, Default NEW
ERROR_CODE Y VARCHAR2 (5) Error code
ERROR_TEXT Y VARCHAR2 (100) Error Text
Unique Keys Name Column
CLL_F041_PARTY_BAL_IFACE_PK LINE_ID
CLL_F041_PARTY_BAL_IFACE_U1 LEDGER_ID
PARTY_PERIOD_ID
THIRD_PARTY_NIT
CODE_COMBINATION_ID
-
LAD Consulting Localizations Technical Reference Manual 37
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
CLL_F041_PARTY_BAL_SOURCE
Sources for third party balance process
Changes
New table in this version.
Columns description Name Null? Type Description
JE_SOURCE_NAME N VARCHAR2(25) Source Name identification
USER_JE_SOURCE_NAME N VARCHAR2(25) Source User Nama
CREATED_BY N NUMBER Created By
CREATION_DATE N DATE Creation Date
LAST_UPDATED_BY N NUMBER Last Updated By
LAST_UPDATE_DATE N DATE Last Update Date
LAST_UPDATE_LOGIN Y NUMBER Last Update Login
Unique Keys Name Column
CLL_F041_PARTY_BAL_SOURCE_U1 JE_SOURCE_NAME
-
LAD Consulting Localizations Technical Reference Manual 38
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
CLL_F041_PARTY_BALANCES
Balances for Third Party Balances Model
Changes
No changes were applied to this table in this version.
Columns description Name Null? Type Description
PARTY_BALANCE_ID N NUMBER Party balances ID
PARTY_PERIOD_ID N NUMBER
Period Identification (based on
CLL_F041_PARTY_PERIODS)
LEDGER_ID N NUMBER Ledger id
PERIOD_NAME N VARCHAR2(15) Period name
BSV_VALUE N VARCHAR2(40) Balancing Segment Value
ACCOUNT_NUMBER N VARCHAR2(40) Account Number
THIRD_PARTY_NIT Y VARCHAR2(40) Nit
THIRD_PARTY_NIT_DGT Y VARCHAR2(10) DV
THIRD_PARTY_NAME N VARCHAR2(400) Party Name
BEGIN_BALANCE Y NUMBER Begin Balance
ACCOUNTED_DR Y NUMBER Accounted Debit
ACCOUNTED_CR Y NUMBER Accounted Credit
END_BALANCE Y NUMBER End Balance
CREATION_DATE N DATE Standard who column
CREATED_BY N NUMBER Standard who column
LAST_UPDATE_DATE N DATE Standard who column
LAST_UPDATED_BY N NUMBER Standard who column
LAST_UPDATE_LOGIN Y NUMBER Standard who column
CODE_COMBINATION_ID N NUMBER GL Code Combination Identification
Unique Keys Name Column
CLL_F041_PARTY_BALANCES_U1 PARTY_BALANCE_ID
CLL_F041_PARTY_BALANCES_U2
PARTY_PERIOD_ID,
LEDGER_ID
BSV_VALUE
CODE_COMBINATION_ID
THIRD_PARTY_NIT
THIRD_PARTY_NIT_DGT
-
LAD Consulting Localizations Technical Reference Manual 39
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
CLL_F041_PARTY_IFACE_ERRORS
Error Interface table for Third party balances
Changes
New table in this version.
Columns description Name Null? Type Description
IFACE_ERROR_LINE_ID NULL NUMBER Iface error line Identification
LINE_ID NULL NUMBER Line Identification(Based on
CLL_F041_PARTY_BAL_IFACE)
CREATED_BY NOT NULL NUMBER Standard who column
CREATION_DATE NOT NULL DATE Standard who column
LAST_UPDATED_BY NOT NULL NUMBER Standard who column
LAST_UPDATE_DATE NOT NULL DATE Standard who column
LAST_UPDATE_LOGIN NULL NUMBER Standard who column
ERROR_CODE NULL VARCHAR2(50) Interface Line Error Code
ERROR_TEXT NULL VARCHAR2(100) Interface Line Error Text
Unique Keys Name Column
CLL_F041_PARTY_IFACE_ERRORS_PK IFACE_ERROR_LINE_ID
CLL_F041_PARTY_IFACE_ERRORS_N1 LINE_ID
-
LAD Consulting Localizations Technical Reference Manual 40
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
CLL_F041_PARTY_JOURNALS
Details lines for Third Party Balances Model
Changes
New table in this version.
Columns description Name Null? Type Description
PARTY_JOURNAL_ID N NUMBER Journal line Identification
PARTY_PERIOD_ID N NUMBER
Period Identification (based on
CLL_F041_PARTY_PERIODS)
LEDGER_ID N NUMBER Ledger identification
PERIOD_NAME N VARCHAR2 (15)
Period name identification (based on
CLL_F041_PARTY_PERIODS)
SOURCE N VARCHAR2 (10) Source
SOURCE_ID Y NUMBER Source id identification
BSV_VALUE N VARCHAR2 (40) Balancing Segment Value
ACCOUNT_NUMBER N VARCHAR2 (40) Account Number
CODE_COMBINATION_ID Y NUMBER GL Code Combination Identification
THIRD_PARTY_NIT Y VARCHAR2 (40) Third party nit (based on JL_CO_GL_NITS)
THIRD_PARTY_NIT_DGT Y VARCHAR2 (10) Third party dv (based on JL_CO_GL_NITS)
THIRD_PARTY_NAME N VARCHAR2 (400) Third party name (based on JL_CO_GL_NITS)
ACCOUNTING_DATE N DATE Accounting Date
LINE_DESCRIPTION Y VARCHAR2 (240) Line description
ACCOUNTED_DR Y NUMBER Accounted Debit
ACCOUNTED_CR Y NUMBER Accounted Credit
CREATION_DATE N DATE Standard who column
CREATED_BY N NUMBER Standard who column
LAST_UPDATE_DATE N DATE Standard who column
LAST_UPDATED_BY N NUMBER Standard who column
LAST_UPDATE_LOGIN Y NUMBER Standard who column
LINE_TYPE_LOOKUP_CODE Y VARCHAR2 (50) Line Type code
TAX_NAME Y VARCHAR2 (50) Tax type
ACCOUNT_NUMBER_RELATE
D Y VARCHAR2 (40) Account Number related
CODE_COMBINATION_ID_REL
ATED Y NUMBER Account id related
RELATED_ID Y NUMBER Line id related
GROSS_AMOUNT Y NUMBER Gross amount
CATEGORY Y VARCHAR2 (40) Category
TAX_TYPE Y VARCHAR2 (50) Tax Type
Unique Keys Name Column
CLL_F041_PARTY_JOURNALS_N1
PARTY_PERIOD_ID
LEDGER_ID
BSV_VALUE
ACCOUNT_NUMBER
CLL_F041_PARTY_JOURNALS_N2
THIRD_PARTY_NIT
PARTY_PERIOD_ID
SOURCE
CLL_F041_PARTY_JOURNALS_N3 PARTY_PERIOD_ID
CLL_F041_PARTY_JOURNALS_U1 PARTY_JOURNAL_ID
-
LAD Consulting Localizations Technical Reference Manual 41
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
CLL_F041_PARTY_PERIODS
Periods for Third Party Balances Model
Changes
No changes were applied to this table in this version.
Columns description Name Null? Type Description
PARTY_PERIOD_ID N NUMBER Party Period Id
LEDGER_ID N NUMBER ledger id
PERIOD_NAME N VARCHAR2(15) Period
EFFECTIVE_PERIOD_NUM N NUMBER Effective Period num
PERIOD_STATUS N VARCHAR2(3) Status
CREATION_DATE N DATE Standard who column
CREATED_BY N NUMBER Standard who column
LAST_UPDATE_DATE N DATE Standard who column
LAST_UPDATED_BY N NUMBER Standard who column
LAST_UPDATE_LOGIN Y NUMBER Standard who column
START_DATE N DATE Start Date
END_DATE N DATE End Date
Unique Keys Name Column
CLL_F041_PARTY_PERIODS_U1 PARTY_PERIOD_ID
CLL_F041_PARTY_PERIODS_N1 START_DATE
END_DATE
-
LAD Consulting Localizations Technical Reference Manual 42
General Ledger Colombian Localizations
Oracle Proprietary, Confidential Information - Use Restricted by Contract
CLL_F041_REP_VAL_ACC_RANGES
Reported Values Accounting Ranges.
Changes
Add column source
Columns description Name Null? Type Description
REP_VALUE_RANGE_ID NULL NUMBER Reported Value Range Identification
REP_VALUE_ID NULL NUMBER Reported Value Identification
FORMAT_ID NULL NUMBER Format Identification
CONCEPT_ID NULL NUMBER Concept Identification
SEGMENT1_LOW NULL VARCHAR2(25) Segment 1 Low Value
SEGMENT1_HIGH NULL VARCHAR2(25) Segment 1 High Value
SEGMENT2_LOW NULL VARCHAR2(25) Segment 2 Low Value
SEGMENT2_HIGH NULL VARCHAR2(25) Segment 2 High Value
SEGMENT3_LOW NULL VARCHAR2(25) Segment 3 Low Value
SEGMENT3_HIGH NULL VARCHAR2(25) Segment 3 High Value
SEGMENT4_LOW NULL VARCHAR2(25) Segment 4 Low Value
SEGMENT4_HIGH NULL VARCHAR2(25) Segment 4 High Value
SEGMENT5_LOW NULL VARCHAR2(25) Segment 5 Low Value
SEGMENT5_HIGH NULL VARCHAR2(25) Segment 5 High Value
SEGMENT6_LOW NULL VARCHAR2(25) Segment 6 Low Value
SEGMENT6_HIGH NULL VARCHAR2(25) Segment 6 High Value
SEGMENT7_LOW NULL VARCHAR2(25) Segment 7 Low Value
SEGMENT7_HIGH NULL VARCHAR2(25) Segment 7 High Value
SEGMENT8_LOW NULL VARCHAR2(25) Segment 8 Low Value
SEGMENT8_HIGH NULL VARCHAR2(25) Segment 8 High Value
SEGMENT9_LOW NULL VARCHAR2(25) Segment 9 Low Value
SEGMENT9_HIGH NULL VARCHAR2(25) Segment 9 High Value
SEGMENT10_LOW NULL VARCHAR2(25) Segment 10 Low Value
SEGMENT10_HIGH NULL VARCHAR2(25) Segment 10 High Value
SEGMENT11_LOW NULL VARCHAR2(25) Segment 11 Low Val
top related