cll f399 technical reference manual

LAD Consulting Localizations

Oracle

CLL F399

Ecuador LAD Add-on

Localizations Legal Reports

Technical Reference Manual RELEASE 12

Jun 2014

Version 1.2

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.

Ecuador LAD Add-on Localizations Technical Reference Manual

Legal Reports

Oracle Proprietary, Confidential Information - Use Restricted by Contract

ii

Document Control

Change Record

Date Author Version Change Reference

03-Jun-14 John Edward Trujillo 1 Document Creation

08-Jul-14 John Edward Trujillo 1.1 Documento Update

29-Sep-14 Gesiane Toryi 1.2 Review and Publish


Legal Reports


iii

Content

Document Control ...................................................................................................................... ii

C H A P T E R 1 High Level Design .................................................................................................................... 1

High Level Design Overview ..................................................................................................... 2

Oracle Ecuador Localizations Overview ........................................................................... 2 List of Tables ...................................................................................................................... 2 List of Views ....................................................................................................................... 2 List of Modules ................................................................................................................... 2

List of Views .............................................................................................................................. 3

Views .................................................................................................................................. 3

List of Tables ............................................................................................................................. 4

New Tables ......................................................................................................................... 4

List of Modules .......................................................................................................................... 5

Forms .................................................................................................................................. 5 Reports ................................................................................................................................ 5 Concurrent Programs .......................................................................................................... 5 Triggers............................................................................................................................... 5 Packages ............................................................................................................................. 6 Descriptive Flexfields ......................................................................................................... 6 Lookups .............................................................................................................................. 6 Value Sets ........................................................................................................................... 7

C H A P T E R 2 Detailed Design ......................................................................................................................... 8

Detailed Design.......................................................................................................................... 9

Views and Tables Definition .............................................................................................. 9 Module Definition .............................................................................................................. 9 Package Definition .............................................................................................................. 9 Triggers Definition ............................................................................................................. 9 Descriptive Flexfields ......................................................................................................... 9 Value Sets ........................................................................................................................... 9 Segment Values .................................................................................................................. 9

View and Table Definition ....................................................................................................... 10

Description ....................................................................................................................... 10 Changes ............................................................................................................................ 10 Columns Detail ................................................................................................................. 10 Indexes .............................................................................................................................. 11

Table Definition ....................................................................................................................... 12


Legal Reports


iv

CLL_F399_AP_INVOICES_EXT ................................................................................... 12 CLL_F399_INVOICE_LINES_EXT ............................................................................... 13 CLL_F399_AP_HZ_PARTIES_EXT .............................................................................. 14 CLL_F399_AP_HZ_PARTIES_EXT_U1 ................................................................................. 14 CLL_F399_AP_SUPPLIER_SITES_EXT ....................................................................... 15 CLL_F399_AP_TAX_CODES_EXT .............................................................................. 16 CLL_F399_AR_CUSTOMER_TRX_EXT ...................................................................... 17 CLL_F399_AR_HZ_PARTIES_EXT .............................................................................. 18 CLL_F399_CUST_TRX_TYPES_EXT .......................................................................... 19 CLL_F399_LEGAL_ENTITY_EXT ............................................................................... 20 CLL_F399_ZX_RATES_B_EXT .................................................................................... 21 CLL_F399_AP_EXP_REP_HEAD_EXT ........................................................................ 22 CLL_F399_EXP_REP_LIN_EXT ................................................................................... 23

View Definition ....................................................................................................................... 24

CLL_F399_RA_CUSTOMER_TRX_EXP_V ................................................................. 24 CLL_F399_AP_INVOICES_V ........................................................................................ 25 CLL_F399_ENTITY_V ................................................................................................... 26 CLL_F399_RA_CUSTOMER_TRX_V ........................................................................... 27 CLL_F399_AP_INVOICES_VOID_V ............................................................................ 27

Modules Definition .................................................................................................................. 28

Module Overview ............................................................................................................. 28 CLLECATS ...................................................................................................................... 29

Ecuador LAD Add-on Localizations Technical Reference Manual 1

Legal Reports


C H A P T E R

1 High Level Design

This chapter presents the High Level Design of Oracle Ecuador 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 Ecuador Localizations together with list of tables, modules and views complements will

be shown for the better understanding of the process.


Legal Reports


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 Ecuador

Localizations. Through this chapter it is possible to understand the details of the design and of the

implementation of Oracle Ecuador Localizations.

Oracle Ecuador 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 Ecuador 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 Ecuador 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 Ecuador Localizations. For more

information please read the Tables Definition of the Detailed Design in chapter 2.


Legal Reports


List of Views

There are no views for Ecuador Localizations

Views

View Name Description

CLL_F399_AP_INVOICES_V

CLL_F399_AP_INVOICES_VOID_V

CLL_F399_ENTITY_V

CLL_F399_EXP_REP_LIN_EX_DFV

CLL_F399_INVOICE_LINES_EXT_DFV

CLL_F399_RA_CUSTOMER_TRX_EXP_V

CLL_F399_RA_CUSTOMER_TRX_V


Legal Reports


List of Tables

This section lists and briefly describes each table in Oracle Ecuador Localizations .

New Tables

Table Name Description

CLL_F399_AP_INVOICES_EXT

CLL_F399_AP_SUPPLIERS_EXT

CLL_F399_AP_SUPPLIER_SITES_EXT

CLL_F399_AP_TAX_CODES_EXT

CLL_F399_AR_CUSTOMER_TRX_EXT

CLL_F399_AR_HZ_PARTIES_EXT

CLL_F399_CUST_TRX_TYPES_EXT

CLL_F399_LEGAL_ENTITY_EXT

CLL_F399_ZX_RATES_B_EXT


Legal Reports


List of Modules

This section lists each form, report, concurrent program and stored procedure used in Oracle Ecuador

Localizations.

Forms

Form Description Field Name

CLLECNUS Numbering Setup

CLLECPLI Purchase Liquidation Invoice Entry

CLLECNUC Numbering Cancelation

CLLECETI Occasional Suppliers

Reports

Report Description Field Name

Concurrent Programs

Concurrent Program Description Field Name

CLLECATS AP-AR Ecuador Annex Transactional Simplified

Triggers

Trigger Description Name


Legal Reports


Packages

Package File

Procedures File

Package Name

Procedure Name

Procedure Description

APPS CLL_F399_INV_LINE_EXT_LOAD_PKG PACKAGE

APPS CLL_F399_INV_LINE_EXT_LOAD_PKG PACKAGE BODY

APPS CLL_F399_ATS_PKG PACKAGE

APPS CLL_F399_ATS_PKG PACKAGE BODY

APPS CLL_F399_EXPREPEXT_TO_INV_PKG PACKAGE

APPS CLL_F399_EXPREPEXT_TO_INV_PKG PACKAGE BODY

Descriptive Flexfields

Descriptive Name Title

CLL_F399_AR_CUSTOMER_TRX_EXT Ecuador Customer Transaction Extension

CLL_F399_AR_HZ_PARTIES_EXT Ecuador Customers Extension

CLL_F399_AP_INVOICES_EXT Ecuador Invoices Extension

CLL_F399_LEGAL_ENTITY_EXT Ecuador Legal Entity Extension

CLL_F399_AP_SUPPLIERS_EXT Ecuador Suppliers Extension

CLL_F399_ZX_RATES_B_EXT Ecuador Tax Rates Extension

CLL_F399_CUST_TRX_TYPES_EXT Ecuador Transaction Types Extension

CLL_F399_AP_TAX_CODES_EXT Ecuador Withholding Tax Code Extension

??? Ecuador Expense Reports Headers Extension

Ecuador Vendor Sites Extension

Ecuador Expense Report Lines Extension

Ecuador Invoice Lines Extension

Lookups

Descriptive Name Title

CLL_F399_AUTHO_VOUCHERS_TYPES

CLL_F399_EXPORT_TYPES

CLL_F399_INCOME_CONCEPTS

CLL_F399_INVOICE_STATUS

CLL_F399_INVOICE_TYPE_CODES

CLL_F399_PAY_METHOD

CLL_F399_PAY_TYPE

CLL_F399_PURCHASE_ID_TYPE_CODE

CLL_F399_SALES_ID_TYPE_CODES

CLL_F399_SUPPLIER_TYPE

CLL_F399_TAX_SUPPORT

CLL_F399_TAX_TYPES

CLL_F399_VAT_CONCEPTS

CLL_F399_WITHHOLDING_TYPES


Legal Reports


Value Sets

Value Set Name Description

CLL_F399_PURCHASE_ID_TYPE_CODE Ecuador Purchase Identification Type Codes

CLL_F399_SUPPLIER_TYPE Ecuador Supplier Type

CLL_F399_PAY_TYPE Ecuador Payment Types

CLL_F399_SALES_ID_TYPE_CODES Ecuador Sales Identification Type Codes

CLL_F399_TAX_SUPPORT Ecuador Tax Support Codes

CLL_F399_AUTH_VOUCHERS_TYPES Ecuador Authorized Vouchers Types

CLL_F399_PAY_METHOD Ecuador Payment Methods

CLL_F399_TAX_TYPES Ecuador Tax Types

CLL_F399_INVOICE_TYPE_CODES Ecuador Invoice Type Code

CLL_F399_EXPORT_TYPES Ecuador Export Types

CLL_F399_WITHHOLDING_TYPES Ecuador Withholding Types

CLL_F399_INCOME_CONCEPTS Ecuador Concepts for Income Withholding type

CLL_F399_VAT_CONCEPTS Ecuador Concepts for Vat Withholding type

CLL_F399_INVOICE_STATUS Ecuador Invoice Status


Legal Reports


C H A P T E R

2 Detailed Design

This chapter presents a detailed design used during the Oracle Ecuador Localizations implementation. Here you will find detailed definitions about tables, views, modules and other

objects used in Oracle Ecuador Localizations.


Legal Reports


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

Ecuador 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 Ecuador 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 Definition

This section provides detailed information about each module in Oracle Ecuador Localizations. Use

this section to better understand the content details of each module and how these functionalities are

implemented.

Package Definition

This section gives an overview about the Procedures and Functions inside the Calculation Package.

Triggers Definition

This section provides information about the Triggers of Oracle Ecuador 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 Ecuador

Localizations Use this section to rapidly find the list of Descriptive Flexfields.

Value Sets

This section provides detailed information of Value Set used in the Oracle Ecuador 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 Ecuador

Localizations. The Segment Values are the information that appears when a Value Set has the type

Independent.


Legal Reports


View and Table Definition

This section contains a detailed definition of each table and view used in Oracle Ecuador

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 Ecuador 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 became 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 Ecuador 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).


Legal Reports


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.


Legal Reports


Table Definition

The Table Definition section contains a detailed definition of each table in Oracle Ecuador

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_F399_AP_INVOICES_EXT

Stores the Invoices Extension used by the Descriptive Flexfield Ecuador Invoices

Extension.

Unique Key

Name Column

CLL_F399_AP_INVOICES_EXT_U1 INVOICE_ID

Columns description

Name Null Type Description

INVOICE_ID NOT NULL NUMBER

ATTRIBUTE1 NULL VARCHAR2(150) ID Tax Support

ATTRIBUTE2 NULL VARCHAR2(150) Invoice Type Code

ATTRIBUTE3 NULL VARCHAR2(150) Sale Invoice Authorization Num

ATTRIBUTE4 NULL VARCHAR2(150) Withholding Voucher Number

ATTRIBUTE5 NULL VARCHAR2(150) Withholding Voucher Autho Num

ATTRIBUTE6 NULL VARCHAR2(150) Withholding Voucher Issue Date

ATTRIBUTE7 NULL VARCHAR2(150) Original Document Number

ATTRIBUTE8 NULL VARCHAR2(150) Settlement Purchase Document

ATTRIBUTE9 NULL VARCHAR2(150)







ATTRIBUTE_CATEGORY NULL VARCHAR2(150)

CREATED_BY NOT NULL NUMBER

CREATION_DATE NOT NULL DATE

LAST_UPDATED_BY NOT NULL NUMBER

LAST_UPDATE_DATE NOT NULL DATE

LAST_UPDATE_LOGIN NULL NUMBER


Legal Reports


CLL_F399_INVOICE_LINES_EXT

Stores the Invoice Lines Extension used by the Descriptive Flexfield Ecuador

Invoice Lines Extension.

Unique Key

Name Column

CLL_F399_INVOICE_LINES_EXT_U1 INVOICE_ID

CLL_F399_INVOICE_LINES_EXT_U1 LINE_NUMBER

Columns description


INVOICE_ID NOT NULL NUMBER

LINE_NUMBER NOT NULL NUMBER

ATTRIBUTE1 NULL VARCHAR2(150) Supplier Identification Number -

Refund

ATTRIBUTE2 NULL VARCHAR2(150) Invoice Type Code - Refund

ATTRIBUTE3 NULL VARCHAR2(150) Invoice Number - Refund

ATTRIBUTE4 NULL VARCHAR2(150) Invoice Issue Date - Refund

ATTRIBUTE5 NULL VARCHAR2(150) Invoice Authorization Number -

Refund

ATTRIBUTE6 NULL VARCHAR2(150) ATTRIBUTE7 NULL VARCHAR2(150) ATTRIBUTE8 NULL VARCHAR2(150)













ATTRIBUTE_CATEGORY NULL VARCHAR2(150)

CREATED_BY NOT NULL NUMBER

CREATION_DATE NOT NULL DATE

LAST_UPDATED_BY NOT NULL NUMBER

LAST_UPDATE_DATE NOT NULL DATE

LAST_UPDATE_LOGIN NULL NUMBER


Legal Reports


CLL_F399_AP_HZ_PARTIES_EXT

Stores the additional information for supplier invoice

Columns description


PARTY_ID NOT NULL NUMBER

ATTRIBUTE1 NULL VARCHAR2(150) Identification Type

Code

ATTRIBUTE2 NULL VARCHAR2(150) Supplier Type

ATTRIBUTE3 NULL VARCHAR2(150) Related Party

ATTRIBUTE4 NULL VARCHAR2(150) ATTRIBUTE5 NULL VARCHAR2(150) ATTRIBUTE6 NULL VARCHAR2(150) ATTRIBUTE7 NULL VARCHAR2(150) ATTRIBUTE8 NULL VARCHAR2(150) ATTRIBUTE9 NULL VARCHAR2(150) ATTRIBUTE10 NULL VARCHAR2(150) ATTRIBUTE11 NULL VARCHAR2(150) ATTRIBUTE12 NULL VARCHAR2(150) ATTRIBUTE13 NULL VARCHAR2(150) ATTRIBUTE14 NULL VARCHAR2(150) ATTRIBUTE15 NULL VARCHAR2(150) ATTRIBUTE_CATEGORY NULL VARCHAR2(150) CREATED_BY NOT NULL NUMBER CREATION_DATE NOT NULL DATE LAST_UPDATED_BY NOT NULL NUMBER LAST_UPDATE_DATE NOT NULL DATE LAST_UPDATE_LOGIN NULL NUMBER

Unique Key

Name Column

CLL_F399_AP_HZ_PARTIES_EXT_U1 PARTY_ID


Legal Reports


CLL_F399_AP_SUPPLIER_SITES_EXT

Stores the Suppliers Sites Extension used by the Descriptive Flexfield Ecuador

Suppliers Sites Extension.

Columns description


VENDOR_SITE_ID NOT NULL NUMBER ATTRIBUTE1 NULL VARCHAR2(150) Local o Foreign Payment

ATTRIBUTE2 NULL VARCHAR2(150) Foreign Payment Country

ATTRIBUTE3 NULL VARCHAR2(150) Apply Double Tax Agreement

ATTRIBUTE4 NULL VARCHAR2(150) Foreign Payment Liable

ATTRIBUTE5 NULL VARCHAR2(150) Payment Method

ATTRIBUTE6 NULL VARCHAR2(150) ATTRIBUTE7 NULL VARCHAR2(150) ATTRIBUTE8 NULL VARCHAR2(150) ATTRIBUTE9 NULL VARCHAR2(150) ATTRIBUTE10 NULL VARCHAR2(150) ATTRIBUTE11 NULL VARCHAR2(150) ATTRIBUTE12 NULL VARCHAR2(150) ATTRIBUTE13 NULL VARCHAR2(150) ATTRIBUTE14 NULL VARCHAR2(150) ATTRIBUTE15 NULL VARCHAR2(150) ATTRIBUTE_CATEGORY NULL VARCHAR2(150) CREATED_BY NOT NULL NUMBER CREATION_DATE NOT NULL DATE LAST_UPDATED_BY NOT NULL NUMBER LAST_UPDATE_DATE NOT NULL DATE LAST_UPDATE_LOGIN NULL NUMBER

Unique Key

Name Column

CLL_F399_AP_SUP_SITES_EXT_U1 VENDOR_SITE_ID


Legal Reports


CLL_F399_AP_TAX_CODES_EXT

Stores the Withholding Tax Code Extension used by the Descriptive Flexfield

Ecuador Withholding Tax Code Extension.

Columns description


TAX_ID NOT NULL NUMBER ATTRIBUTE1 NULL VARCHAR2(150) Withholding Type

ATTRIBUTE2 NULL VARCHAR2(150) Income Concept

ATTRIBUTE3 NULL VARCHAR2(150) Vat Concept


Unique Key

Name Column

CLL_F399_AP_TAX_CODES_EXT_U1 TAX_ID


Legal Reports


CLL_F399_AR_CUSTOMER_TRX_EXT

Stores the Customer Transaction Extension used by the Descriptive Flexfield

Ecuador Customer Transaction Extension.

Unique Key

Name Column

CLL_F399_AR_CUSTOMER_TRX_U1 CUSTOMER_TRX_ID

Columns description


CUSTOMER_TRX_ID NOT NULL NUMBER

ATTRIBUTE1 NULL VARCHAR2(150) Export Transaction Endorsement

ATTRIBUTE2 NULL VARCHAR2(150) Transport Document Number

ATTRIBUTE3 NULL VARCHAR2(150) Transaction Date

ATTRIBUTE4 NULL VARCHAR2(150) Sales Invoice Authorization

ATTRIBUTE5 NULL VARCHAR2(150) ATTRIBUTE6 NULL VARCHAR2(150) ATTRIBUTE7 NULL VARCHAR2(150) ATTRIBUTE8 NULL VARCHAR2(150) ATTRIBUTE9 NULL VARCHAR2(150) ATTRIBUTE10 NULL VARCHAR2(150) ATTRIBUTE11 NULL VARCHAR2(150) ATTRIBUTE12 NULL VARCHAR2(150) ATTRIBUTE13 NULL VARCHAR2(150) ATTRIBUTE14 NULL VARCHAR2(150) ATTRIBUTE15 NULL VARCHAR2(150) ATTRIBUTE_CATEGORY NULL VARCHAR2(150) CREATED_BY NOT NULL NUMBER CREATION_DATE NOT NULL DATE LAST_UPDATED_BY NOT NULL NUMBER LAST_UPDATE_DATE NOT NULL DATE LAST_UPDATE_LOGIN NULL NUMBER


Legal Reports


CLL_F399_AR_HZ_PARTIES_EXT

Stores the Customer Extension used by the Descriptive Ecuador Customers

Extension.

Unique Key

Name Column

CLL_F399_AR_HZ_PARTIES_EXT_U1 PARTY_ID

Columns description


PARTY_ID NOT NULL NUMBER ATTRIBUTE1 NULL VARCHAR2(150) Identification Type Code

ATTRIBUTE2 NULL VARCHAR2(150) ATTRIBUTE3 NULL VARCHAR2(150) ATTRIBUTE4 NULL VARCHAR2(150) ATTRIBUTE5 NULL VARCHAR2(150) ATTRIBUTE6 NULL VARCHAR2(150) ATTRIBUTE7 NULL VARCHAR2(150) ATTRIBUTE8 NULL VARCHAR2(150) ATTRIBUTE9 NULL VARCHAR2(150) ATTRIBUTE10 NULL VARCHAR2(150) ATTRIBUTE11 NULL VARCHAR2(150) ATTRIBUTE12 NULL VARCHAR2(150) ATTRIBUTE13 NULL VARCHAR2(150) ATTRIBUTE14 NULL VARCHAR2(150) ATTRIBUTE15 NULL VARCHAR2(150) ATTRIBUTE_CATEGORY NULL VARCHAR2(150) CREATED_BY NOT NULL NUMBER CREATION_DATE NOT NULL DATE LAST_UPDATED_BY NOT NULL NUMBER LAST_UPDATE_DATE NOT NULL DATE LAST_UPDATE_LOGIN NULL NUMBER


Legal Reports


CLL_F399_CUST_TRX_TYPES_EXT

Stores the Transaction Types Extension used by the Descriptive Flexfield Ecuador

Transaction Types Extension.

Columns description


CUST_TRX_TYPE_ID NOT NULL NUMBER ORG_ID NULL NUMBER Invoice Type Code

ATTRIBUTE1 NULL VARCHAR2(150) Establishment Number

ATTRIBUTE2 NULL VARCHAR2(150) Issue Point Number

ATTRIBUTE3 NULL VARCHAR2(150) Export Transaction Type Code


Unique Key

Name Column

CLL_F399_CUST_TRX_TYPES_EXT_U1 CUST_TRX_TYPE_ID

CLL_F399_CUST_TRX_TYPES_EXT_U1 ORG_ID


Legal Reports


CLL_F399_LEGAL_ENTITY_EXT

Stores the Entity Extension used by the Descriptive Flexfield Ecuador Legal Entity

Extension.

Columns description


LEGAL_ENTITY_ID NOT NULL NUMBER ATTRIBUTE1 NULL VARCHAR2(150) Numb of Est Registered on RUC

ATTRIBUTE2 NULL VARCHAR2(150) ATTRIBUTE3 NULL VARCHAR2(150) ATTRIBUTE4 NULL VARCHAR2(150) ATTRIBUTE5 NULL VARCHAR2(150) ATTRIBUTE6 NULL VARCHAR2(150) ATTRIBUTE7 NULL VARCHAR2(150) ATTRIBUTE8 NULL VARCHAR2(150) ATTRIBUTE9 NULL VARCHAR2(150) ATTRIBUTE10 NULL VARCHAR2(150) ATTRIBUTE11 NULL VARCHAR2(150) ATTRIBUTE12 NULL VARCHAR2(150) ATTRIBUTE13 NULL VARCHAR2(150) ATTRIBUTE14 NULL VARCHAR2(150) ATTRIBUTE15 NULL VARCHAR2(150) ATTRIBUTE16 NULL VARCHAR2(150) ATTRIBUTE17 NULL VARCHAR2(150) ATTRIBUTE18 NULL VARCHAR2(150) ATTRIBUTE19 NULL VARCHAR2(150) ATTRIBUTE20 NULL VARCHAR2(150) ATTRIBUTE_CATEGORY NULL VARCHAR2(150) CREATED_BY NOT NULL NUMBER CREATION_DATE NOT NULL DATE LAST_UPDATED_BY NOT NULL NUMBER LAST_UPDATE_DATE NOT NULL DATE LAST_UPDATE_LOGIN NULL NUMBER

Unique Key

Name Column

CLL_F399_LEGAL_ENTITY_EXT_U1 LEGAL_ENTITY_ID


Legal Reports


CLL_F399_ZX_RATES_B_EXT

Stores the additional information for legal entity

Columns description


TAX_RATE_ID NOT NULL NUMBER ATTRIBUTE1 NULL VARCHAR2(150) Tax Type

ATTRIBUTE2 NULL VARCHAR2(150) ATTRIBUTE3 NULL VARCHAR2(150) ATTRIBUTE4 NULL VARCHAR2(150) ATTRIBUTE5 NULL VARCHAR2(150) ATTRIBUTE6 NULL VARCHAR2(150) ATTRIBUTE7 NULL VARCHAR2(150) ATTRIBUTE8 NULL VARCHAR2(150) ATTRIBUTE9 NULL VARCHAR2(150) ATTRIBUTE10 NULL VARCHAR2(150) ATTRIBUTE11 NULL VARCHAR2(150) ATTRIBUTE12 NULL VARCHAR2(150) ATTRIBUTE13 NULL VARCHAR2(150) ATTRIBUTE14 NULL VARCHAR2(150) ATTRIBUTE15 NULL VARCHAR2(150) ATTRIBUTE_CATEGORY NULL VARCHAR2(150) CREATED_BY NOT NULL NUMBER CREATION_DATE NOT NULL DATE LAST_UPDATED_BY NOT NULL NUMBER LAST_UPDATE_DATE NOT NULL DATE LAST_UPDATE_LOGIN NULL NUMBER

Unique Key

Name Column

CLL_F399_ZX_RATES_B_EXT_U1 TAX_RATE_ID


Legal Reports


CLL_F399_AP_EXP_REP_HEAD_EXT

Stores the additional information for Expense Report header.

Columns description


REPORT_HEADER_ID NOT NULL NUMBER ATTRIBUTE1 NULL VARCHAR2(150) ID Tax Support

ATTRIBUTE2 NULL VARCHAR2(150) Invoice Type Code

ATTRIBUTE3 NULL VARCHAR2(150) Settlement Purchase Document

ATTRIBUTE4 NULL VARCHAR2(150) Sale Invoice Authorization Num

ATTRIBUTE5 NULL VARCHAR2(150) ATTRIBUTE6 NULL VARCHAR2(150) ATTRIBUTE7 NULL VARCHAR2(150) ATTRIBUTE8 NULL VARCHAR2(150) ATTRIBUTE9 NULL VARCHAR2(150) ATTRIBUTE10 NULL VARCHAR2(150) ATTRIBUTE11 NULL VARCHAR2(150) ATTRIBUTE12 NULL VARCHAR2(150) ATTRIBUTE13 NULL VARCHAR2(150) ATTRIBUTE14 NULL VARCHAR2(150) ATTRIBUTE15 NULL VARCHAR2(150) ATTRIBUTE_CATEGORY NULL VARCHAR2(150) CREATED_BY NOT NULL NUMBER CREATION_DATE NOT NULL DATE LAST_UPDATED_BY NOT NULL NUMBER LAST_UPDATE_DATE NOT NULL DATE LAST_UPDATE_LOGIN NULL NUMBER

Unique Key

Name Column

CLL_F399_AP_EXP_REP_H_EXT_U1 REPORT_HEADER_ID


Legal Reports


CLL_F399_EXP_REP_LIN_EXT

Stores the additional information for Expense Report header.

Columns description


REPORT_HEADER_ID NOT NULL NUMBER REPORT_LINE_ID NOT NULL NUMBER ATTRIBUTE1 NULL VARCHAR2(150) Supplier Id Number - Refund

ATTRIBUTE2 NULL VARCHAR2(150) Invoice Type Code - Refund

ATTRIBUTE3 NULL VARCHAR2(150) Invoice Number - Refund

ATTRIBUTE4 NULL VARCHAR2(150) Invoice Issue Date - Refund

ATTRIBUTE5 NULL VARCHAR2(150) Invoice Au Number - Refund

ATTRIBUTE6 NULL VARCHAR2(150) ATTRIBUTE7 NULL VARCHAR2(150) ATTRIBUTE8 NULL VARCHAR2(150) ATTRIBUTE9 NULL VARCHAR2(150) ATTRIBUTE10 NULL VARCHAR2(150) ATTRIBUTE11 NULL VARCHAR2(150) ATTRIBUTE12 NULL VARCHAR2(150) ATTRIBUTE13 NULL VARCHAR2(150) ATTRIBUTE14 NULL VARCHAR2(150) ATTRIBUTE15 NULL VARCHAR2(150) ATTRIBUTE_CATEGORY NULL VARCHAR2(150) CREATED_BY NOT NULL NUMBER CREATION_DATE NOT NULL DATE LAST_UPDATED_BY NOT NULL NUMBER LAST_UPDATE_DATE NOT NULL DATE LAST_UPDATE_LOGIN NULL NUMBER

Unique Key

Name Column

CLL_F399_EXP_REP_LIN_EXT_U1 REPORT_LINE_ID


Legal Reports


View Definition

The View Definition section contains a detailed definition of each view in Oracle

Ecuador Legal Reports. You will see the following fields for each view: objective,

definition, column description, indexes and sequences.

CLL_F399_RA_CUSTOMER_TRX_EXP_V

Name: cll_f399_ra_customer_trx_exp_v.xdf

Columns description

Name Type

LEGAL_ENTITY_ID

LEGAL_ENTITY_NAME_INV

LEGAL_ENTITY_IDENTIFIER_INV

ADDRESS_INV

PHONE_NUMBER_INV

EMAIL_ADDRESS_INV

ORG_ID

CUSTOMER_TRX_ID

BILL_TO_CUSTOMER_ID

TRX_DATE

PERIOD_M

PERIOD_B

PERIOD_T

PERIOD_S

PERIOD_A

DOCUMENT_TYPE

DOCUMENT_NUMBER

VERIFICATION_DIGIT

CUSTOMER_NAME

CUSTOMER_ADDRESS

CUSTOMER_PHONE

CUSTOMER_EMAIL

CITY_CODE

CITY

STATE_CODE

STATE

INV_AMOUNT

DM_AMOUNT

CM_AMOUNT

ADJ_AMOUNT

VAT_RATE

VAT_AMOUNT

WITHHOLDING_BASE_AMOUNT

WITHHOLDING_RATE

INV_WITHHOLDING_AMOUNT

DM_WITHHOLDING_AMOUNT

CM_WITHHOLDING_AMOUNT

WITHHOLDING_TAX_CODE

WITHHOLDING_TAX_TYPE

ECONOMIC_ACTIVITY

NUMBER(15)

VARCHAR2(240)

VARCHAR2(30)

VARCHAR2(905)

VARCHAR2(40)

VARCHAR2(2000)

NUMBER(15)

NUMBER(15)

NUMBER(15)

DATE

NUMBER

NUMBER

NUMBER

NUMBER

NUMBER

VARCHAR2(150)

VARCHAR2(20)

VARCHAR2(150)

VARCHAR2(360)

VARCHAR2(4000)

VARCHAR2(40)

VARCHAR2(2000)

VARCHAR2(360)

VARCHAR2(60)

VARCHAR2(360)

VARCHAR2(60)

NUMBER

NUMBER

NUMBER

NUMBER

NUMBER

NUMBER

NUMBER

NUMBER

NUMBER

NUMBER

NUMBER

VARCHAR2(30)

VARCHAR2(150)

VARCHAR2(150)


Legal Reports


CLL_F399_AP_INVOICES_V

Name: cll_f399_ap_invoices_v.xdf

Columns description

Name Type

LEGAL_ENTITY_ID NUMBER(15)

ORG_ID NUMBER(15)

VENDOR_ID NUMBER

VENDOR_NAME VARCHAR2(240)

PARTY_ID NUMBER

INVOICE_ID NUMBER(15)

INVOICE_NUM VARCHAR2(50)

GL_DATE DATE

CODSUSTENTO VARCHAR2(150)

TPIDPROV VARCHAR2(150)

IDPROV VARCHAR2(20)

TIPOCOMPROBANTE VARCHAR2(150)

TIPOPROV VARCHAR2(150)

PARTEREL VARCHAR2(150)

FECHAREGISTRO VARCHAR2(10)

ESTABLECIMIENTO VARCHAR2(9)

PUNTOEMISION VARCHAR2(9)

SECUENCIAL VARCHAR2(27)

FECHAEMISION VARCHAR2(10)

AUTORIZACION VARCHAR2(111)

BASENOGRAIVA NUMBER

BASEIMPONIBLE NUMBER

BASEIMPGRAV NUMBER

MONTOICE NUMBER

MONTOIVA NUMBER

VALORRETBIENES NUMBER

VALORRETSERVICIOS NUMBER

VALRETSERV100 NUMBER

PAGOLOCEXT VARCHAR2(150)

PAISEFECPAGO VARCHAR2(150)

APLICCONVDOBTRIB VARCHAR2(150)

PAGEXTSUJRETNORLEG VARCHAR2(150)

FORMAPAG VARCHAR2(150)

CODRETAIR VARCHAR2(150)

BASEIMPAIR NUMBER

PORCENTAJEAIR NUMBER

VALRETAIR NUMBER

FECHAPAGODIV VARCHAR2(10)

IMRENTASOC NUMBER

ANIOUTDIV VARCHAR2(4)


Legal Reports


ESTABRETENCION1 VARCHAR2(9)

PTOEMIRETENCION1 VARCHAR2(9)

SECRETENCION1 VARCHAR2(27)

AUTRETENCION1 VARCHAR2(150)

FECHAEMIRET1 VARCHAR2(10)

DOCMODIFICADO VARCHAR2(150)

ESTABMODIFICADO VARCHAR2(9)

PTOEMIMODIFICADO VARCHAR2(9)

SECMODIFICADO VARCHAR2(27)

AUTMODIFICADO VARCHAR2(111)

TPIDPROVREEMB VARCHAR2(150)

IDPROVREEMB VARCHAR2(20)

TIPOCOMPROBANTEREEMB VARCHAR2(150)

ESTABLECIMIENTOREEMB VARCHAR2(9)

PUNTOEMISIONREEMB VARCHAR2(9)

SECUENCIALREEMB VARCHAR2(27)

FECHAEMISIONREEMB VARCHAR2(10)

AUTORIZACIONREEMB VARCHAR2(111)

BASEIMPONIBLEREEMB NUMBER

BASEIMPGRAVREEMB NUMBER

BASENOGRAIVAREEMB NUMBER

MONTOICEREEMB NUMBER

MONTOIVAREEMB NUMBER

CLL_F399_ENTITY_V

Name: cll_f399_entity_v.xdf

Columns description

Name Type

IDINFORMANTE VARCHAR2(39)

RAZONSOCIAL VARCHAR2(720)

NUMESTABRUC VARCHAR2(9)

TOTALVENTAS NUMBER

CODIGOOPERATIVO CHAR(3)


GL_DATE DATE


Legal Reports


CLL_F399_RA_CUSTOMER_TRX_V

Name: cll_f399_ra_customer_trx_v.xdf

Columns description

Name Type

TRX_NUMBER VARCHAR2(20)

CUSTOMER_TRX_ID NUMBER(15)


TRX_DATE DATE

TPIDCLIENTE VARCHAR2(150)

IDCLIENTE VARCHAR2(20)


BASENOGRAIVA NUMBER

BASEIMPONIBLE NUMBER

BASEIMPGRAV NUMBER

MONTOIVA NUMBER

VALORRETIVA NUMBER

VALORRETRENTA NUMBER

CODESTAB VARCHAR2(150)

VENTASESTAB NUMBER

CLL_F399_AP_INVOICES_VOID_V

Name: cll_f399_ap_invoices_void_v.xdf

Columns description

Name Type


GL_DATE DATE


ESTABLECIMIENTO VARCHAR2(9)

PUNTOEMISION VARCHAR2(9)

SECUENCIAL VARCHAR2(27)

AUTORIZACION VARCHAR2(111)


Legal Reports


Modules Definition

This section describes each form, report, concurrent program and stored procedure in the Oracle

Ecuador Localizations. Read this section to learn what each module does and when Oracle Ecuador

Localizations uses them with each corresponding table.

Module Overview

This overview briefly describes each module with its functionality, type, category, used language and

the associated title with the corresponding program.

It also presents a detailed description of the module functionalities and you will be able to learn more

about each specific business activity.

The modules list is in alphabetical order, based on the internal names, that correspond to the Forms

names, Reports and Concurrent Programs registered in the Oracle Application Object Library (AOL).

We classified the modules in the following categories:

Form Each Form type module corresponds to a simple screen that you can navigate using

a menu or a subroutine activated by an automatic zoom. The Forms type module is

indexed by its registration name in Oracle Application Object Library, that is

identified by the executable file name without the extension FMX.

Report Each Report type module corresponds to a program that generates a report. This

program can be a description file of an Oracle Report, a SQL report program, a

SQL Plus script or a C/ ProC program. The Report type module is indexed by the

concurrent program name, that is registered in the Oracle Application Object

Library. To propagate a concurrent program, the registered name is identified by

the executable file name without its extension. Each Report type corresponds to a

program that generates a report. This program can be a description file of an Oracle

Report, a SQL report program, a SQL Plus script or a C/ ProC program. To

propagate a concurrent program, the registered name is identified by the executable

file name without its extension.

Concurrent

Program

Each Concurrent Program type module corresponds to a simple program that can

be made by a C/ C Pro program, a SQL Plus script, a SQL Loader script or a SQL

Report program. This module is indexed by the name registered in the Oracle

Application Object Libary. To propagate a concurrent program, the registered

name is identified by the executable file name without its extension.

Stored

Procedure

Each module of the Stored Procedure type corresponds to a simple PL*SQL

program stored in the data base. This module is indexed by the name of the

PL*SQL creation file without its file extension.

Package Each module of the Package type corresponds to a union of procedures and

variables declaration.


Legal Reports


CLLECATS

Description: AP-AR Ecuador Annex Transactional Simplified

Type: Data Template

Language: XML

Name: CLLECATS.xml

cll f399 technical reference manual

Documents

defined service deliverables

service request

list of tables

list of views

list of modules

technical support

oracle integration hub

confidential information