Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - JL Tables and Views

TABLE - JL.JL_AR_AP_AWT_CERTIF_ALL

TABLE - JL.JL_AR_AP_MTBT_THRESHOLDS

TABLE - JL.JL_AR_AP_PROVINCES

TABLE - JL.JL_AR_AP_SUP_AWT_CR_LTS

TABLE - JL.JL_AR_AP_TRX_DGI_CODES

TABLE - JL.JL_AR_AR_DOC_LETTER_ALL

TABLE - JL.JL_AR_FA_EXHIBIT_GROUPS

TABLE - JL.JL_AR_FA_EXHIBIT_REPORT

TABLE - JL.JL_AR_TURN_UPL_ALL

TABLE - JL.JL_AR_TURN_UPL_T

TABLE - JL.JL_BR_AP_COLLECTION_DOCS_ALL

TABLE - JL.JL_BR_AP_CONSOLID_INVOICES_ALL

TABLE - JL.JL_BR_AP_INT_COLLECTION_TMP

TABLE - JL.JL_BR_AP_INT_COLLECT_ALL

TABLE - JL.JL_BR_AP_INT_COLLECT_EXT_ALL

TABLE - JL.JL_BR_AP_OPERATIONS

TABLE - JL.JL_BR_AP_TAX_CALENDAR_HEADERS

TABLE - JL.JL_BR_AP_TAX_CALENDAR_LINES

TABLE - JL.JL_BR_AR_BANK_INSTRUCTIONS

TABLE - JL.JL_BR_AR_BANK_OCCURRENCES

TABLE - JL.JL_BR_AR_BANK_RETURNS_ALL

TABLE - JL.JL_BR_AR_BORDEROS_ALL

TABLE - JL.JL_BR_AR_COLLECTION_DOCS_ALL

TABLE - JL.JL_BR_AR_COMP_INV_ALL

TABLE - JL.JL_BR_AR_CUST_INT_ERR

TABLE - JL.JL_BR_AR_DISTRIBUTNS_ALL

TABLE - JL.JL_BR_AR_MC_OCC_DOCS

TABLE - JL.JL_BR_AR_OCCURRENCE_DOCS_ALL

TABLE - JL.JL_BR_AR_PAY_SCHED_AUX

TABLE - JL.JL_BR_AR_POSTING_TMP

TABLE - JL.JL_BR_AR_REC_MET_ACCTS_EXT_ALL

TABLE - JL.JL_BR_AR_REMIT_BORDEROS_ALL

TABLE - JL.JL_BR_AR_RET_INTERFACE_ALL

TABLE - JL.JL_BR_AR_RET_INTERFACE_EXT_ALL

TABLE - JL.JL_BR_AR_RET_INTERFACE_TMP

TABLE - JL.JL_BR_AR_SELECT_ACCOUNTS_ALL

TABLE - JL.JL_BR_AR_SELECT_CONTROLS_ALL

TABLE - JL.JL_BR_AR_TX_CATEG_ALL

TABLE - JL.JL_BR_AR_TX_EXC_FSC_ALL

TABLE - JL.JL_BR_AR_TX_EXC_ITM_ALL

TABLE - JL.JL_BR_AR_TX_FSC_CLS_ALL

TABLE - JL.JL_BR_AR_TX_GROUP_ALL

TABLE - JL.JL_BR_AR_TX_LOCN_ALL

TABLE - JL.JL_BR_AR_TX_RULES_ALL

TABLE - JL.JL_BR_BALANCES_ALL

TABLE - JL.JL_BR_CINFOS_BOOKS

TABLE - JL.JL_BR_COMPANY_INFOS

TABLE - JL.JL_BR_CUSTOMER_TRX_EXTS

TABLE - JL.JL_BR_CUST_TRX_LINES_EXTS

TABLE - JL.JL_BR_EILOG

TABLE - JL.JL_BR_GL_LEGAL_REP

TABLE - JL.JL_BR_INTERFACE_LINES_EXTS

TABLE - JL.JL_BR_INV_API_TRX_LINES_T

TABLE - JL.JL_BR_JOURNALS_ALL

TABLE - JL.JL_BR_LOCAL_HOLIDAY_DATES

TABLE - JL.JL_BR_LOCAL_HOLIDAY_SETS

TABLE - JL.JL_BR_SPED_EXTR_DATA_H

TABLE - JL.JL_BR_SPED_EXTR_DATA_T

TABLE - JL.JL_BR_SPED_EXTR_MSGS

TABLE - JL.JL_BR_SPED_EXTR_PARAM

TABLE - JL.JL_BR_SPED_PARTIC_CODES

TABLE - JL.JL_BR_SPED_PARTIC_REL

TABLE - JL.JL_BR_TAX_LMSG_ALL

TABLE - JL.JL_CANCEL_GT

TABLE - JL.JL_CL_AP_AWT_CERT

TABLE - JL.JL_CL_GL_ACCT_HIER_TMP

TABLE - JL.JL_CO_FA_ADJUSTMENTS

TABLE - JL.JL_CO_FA_APPRAISALS

TABLE - JL.JL_CO_FA_APPRAISAL_BOOKS

TABLE - JL.JL_CO_FA_ASSET_APPRS

TABLE - JL.JL_CO_FA_PURGE

TABLE - JL.JL_CO_GL_BALANCES

TABLE - JL.JL_CO_GL_CONC_CTRL

TABLE - JL.JL_CO_GL_CONC_ERRS

TABLE - JL.JL_CO_GL_MG_CONFIGS

TABLE - JL.JL_CO_GL_MG_HEADERS

TABLE - JL.JL_CO_GL_MG_LINES

TABLE - JL.JL_CO_GL_MG_LITERALS

TABLE - JL.JL_CO_GL_MG_RANGES

TABLE - JL.JL_CO_GL_NITS

TABLE - JL.JL_CO_GL_NIT_ACCTS

TABLE - JL.JL_CO_GL_TRX

TABLE - JL.JL_MX_FA_ISR_IMPAC

TABLE - JL.JL_REMIT3_GT

TABLE - JL.JL_REMIT_GT

TABLE - JL.JL_ZZ_AP_AWT_TYPES

TABLE - JL.JL_ZZ_AP_COMP_AWT_TYPES

TABLE - JL.JL_ZZ_AP_INV_DIS_WH_ALL

TABLE - JL.JL_ZZ_AP_INV_DIS_WH_ALL_T

TABLE - JL.JL_ZZ_AP_SUPP_AWT_TYPES

TABLE - JL.JL_ZZ_AP_SUP_AWT_CD_ALL

TABLE - JL.JL_ZZ_AR_TX_ATT_CLS_ALL

TABLE - JL.JL_ZZ_AR_TX_ATT_VAL_ALL

TABLE - JL.JL_ZZ_AR_TX_CATEG_ALL

TABLE - JL.JL_ZZ_AR_TX_CAT_ATT_ALL

TABLE - JL.JL_ZZ_AR_TX_CAT_DTL_ALL

TABLE - JL.JL_ZZ_AR_TX_CUS_CLS_ALL

TABLE - JL.JL_ZZ_AR_TX_EXC_CUS_ALL

TABLE - JL.JL_ZZ_AR_TX_EXC_FSC_ALL

TABLE - JL.JL_ZZ_AR_TX_EXC_ITM_ALL

TABLE - JL.JL_ZZ_AR_TX_FSC_CLS_ALL

TABLE - JL.JL_ZZ_AR_TX_GROUPS_ALL

TABLE - JL.JL_ZZ_AR_TX_LGL_MSG_ALL

TABLE - JL.JL_ZZ_AR_TX_LOCN_ALL

TABLE - JL.JL_ZZ_AR_TX_NAT_RAT_ALL

TABLE - JL.JL_ZZ_AR_TX_RULES_ALL

TABLE - JL.JL_ZZ_AR_TX_SCHEDULES_ALL

TABLE - JL.JL_ZZ_FA_RETIREMNT_ADJS

TABLE - JL.JL_ZZ_FA_RETIREMNT_JES

TABLE - JL.JL_ZZ_GL_AXI

TABLE - JL.JL_ZZ_GL_AXI_ACCOUNTS

TABLE - JL.JL_ZZ_GL_AXI_MODELS

TABLE - JL.JL_ZZ_GL_AXI_MODEL_RANGES

TABLE - JL.JL_ZZ_GL_AXI_TMP

TABLE - JL.JL_ZZ_INFO_T

VIEW - APPS.AS_TAX_LINES_SUMMARY_VBR

VIEW - APPS.JL_AR_AR_CUST_TRX_TYPES_V

VIEW - APPS.JL_AR_AR_DOC_LETTER_V

VIEW - APPS.JL_BR_AP_COLLECTION_DOCS_V

VIEW - APPS.JL_BR_AP_CONSOLID_INVOICES_V

VIEW - APPS.JL_BR_AP_INT_COLLECT_EXT_V

VIEW - APPS.JL_BR_AP_INVOICES_SHIP_V

VIEW - APPS.JL_BR_AP_SICI_INVOICES_TN_V

VIEW - APPS.JL_BR_AP_SICI_INVOICES_V

VIEW - APPS.JL_BR_AR_BANK_RETURNS_V

VIEW - APPS.JL_BR_AR_BORDEROS_SAB_V

VIEW - APPS.JL_BR_AR_BORDEROS_V

VIEW - APPS.JL_BR_AR_COLLECTION_DOCS_IOB_V

VIEW - APPS.JL_BR_AR_COLL_DOCS_SAB_V

VIEW - APPS.JL_BR_AR_COLL_DOC_DISTS_L_V

VIEW - APPS.JL_BR_AR_COLL_OCC_DOCS_H_V

VIEW - APPS.JL_BR_AR_OCCURRENCE_DOCS_V

VIEW - APPS.JL_BR_AR_OCC_DOCS_ALL_MRC_V

VIEW - APPS.JL_BR_AR_OCC_DOCS_MRC_V

VIEW - APPS.JL_BR_AR_PAYMENT_SCH_IOB_V

VIEW - APPS.JL_BR_AR_RCT_MTHD_1_V

VIEW - APPS.JL_BR_AR_RCT_MTHD_2_V

VIEW - APPS.JL_BR_AR_REC_MET_ACCTS_EXT_R_V

VIEW - APPS.JL_BR_AR_REC_MET_ACCTS_EXT_V

VIEW - APPS.JL_BR_AR_RET_INTERFACE_EXT_V

VIEW - APPS.JL_BR_AR_RET_INTER_V

VIEW - APPS.JL_BR_AR_SELECT_ACCOUNTS_V

VIEW - APPS.JL_BR_AR_SELECT_CONTROLS_V

VIEW - APPS.JL_CO_FA_AEL_GL_V

VIEW - APPS.JL_CO_FA_AEL_SL_V

VIEW - APPS.JL_CO_FA_APPRAISAL_BOOKS_V

VIEW - APPS.JL_CO_FA_ASSET_APPRS_V

VIEW - APPS.JL_CO_GL_ACCOUNTS_V

VIEW - APPS.JL_CO_GL_BALANCES_V

VIEW - APPS.JL_CO_GL_NIT_ACCTS_V

VIEW - APPS.JL_ZZ_AR_PO_TX_FSC_CLS_V

VIEW - APPS.JL_ZZ_AR_PO_TX_TXN_NAT_V

VIEW - APPS.JL_ZZ_AR_TX_ATTCLS_VAL_V

VIEW - APPS.JL_ZZ_AR_TX_ATT_CLS_LOOKUP_V

VIEW - APPS.JL_ZZ_AR_TX_ATT_CLS_V

VIEW - APPS.JL_ZZ_AR_TX_ATT_VAL_V

VIEW - APPS.JL_ZZ_AR_TX_CATEGRY

VIEW - APPS.JL_ZZ_AR_TX_CATEGRY_V

VIEW - APPS.JL_ZZ_AR_TX_CAT_ATT_TN_V

VIEW - APPS.JL_ZZ_AR_TX_CAT_ATT_V

VIEW - APPS.JL_ZZ_AR_TX_CAT_DTL_V

VIEW - APPS.JL_ZZ_AR_TX_CUS_CLS_V

VIEW - APPS.JL_ZZ_AR_TX_EXC_CUS_V

VIEW - APPS.JL_ZZ_AR_TX_EXC_FSC_V

VIEW - APPS.JL_ZZ_AR_TX_EXC_ITM_V

VIEW - APPS.JL_ZZ_AR_TX_FSC_CLS_V

VIEW - APPS.JL_ZZ_AR_TX_FSC_LOOKUP_V

VIEW - APPS.JL_ZZ_AR_TX_GROUPS_V

VIEW - APPS.JL_ZZ_AR_TX_LGL_MSG_V

VIEW - APPS.JL_ZZ_AR_TX_LGM_V

VIEW - APPS.JL_ZZ_AR_TX_LOCN_V

VIEW - APPS.JL_ZZ_AR_TX_NAT_RAT_V

VIEW - APPS.JL_ZZ_AR_TX_RULES_V

VIEW - APPS.JL_ZZ_AR_TX_SCHEDULES_V

VIEW - APPS.JL_ZZ_FA_ADJ_SUMMARY_V

VIEW - APPS.JL_ZZ_FA_BOOKS_PERIODS_V

Table: JL_AR_AP_AWT_CERTIF_ALL

Primary Key: JL_AR_AP_AWT_CERTIF_ALL_PK

1. CERTIFICATE_ID

Foreign Keys from this table:

Comments

JL_AR_AP_AWT_CERTIF_ALL contains all necessary information to issue withholding certificates.
It also stores the original certificate number and its status that allows reprinting capability.
Its records are inserted by a server side program and retrieved during the certificate printing.
.

Indexes

Columns

[top of page]

JL.JL_AR_AP_AWT_CERTIF_ALL does not reference any database object

JL.JL_AR_AP_AWT_CERTIF_ALL is referenced by following:

JL

VIEW - JL_AR_AP_AWT_CERTIF_ALL#

[top of page]

Table: JL_AR_AP_MTBT_THRESHOLDS

Comments

JL_AR_AP_MTBT_THRESHOLDS is used to capture Threshold values of simplified regime contributor type for Monotributa Suppliers

Columns

[top of page]

JL.JL_AR_AP_MTBT_THRESHOLDS does not reference any database object

JL.JL_AR_AP_MTBT_THRESHOLDS is referenced by following:

JL

VIEW - JL_AR_AP_MTBT_THRESHOLDS#

[top of page]

Table: JL_AR_AP_PROVINCES

Primary Key: JL_AR_AP_PROVINCES_PK

1. PROVINCE_CODE

Comments

JL_AR_AP_PROVINCES contains information about the Argentine provices. Province code is needed to define provincial withholding type. The province code assigned to the ship-to location will be one of the withholding defaulting criteria when entering documents.
.
This table corresponds to the Provinces window.
.

Indexes

Columns

[top of page]

JL.JL_AR_AP_PROVINCES does not reference any database object

JL.JL_AR_AP_PROVINCES is referenced by following:

JL

VIEW - JL_AR_AP_PROVINCES#

[top of page]

Table: JL_AR_AP_SUP_AWT_CR_LTS

Primary Key: JL_AR_AP_SUP_AWT_CR_LTS_PK

1. SEQ_NUM

Comments

JL_AR_AP_SUP_AWT_CR_LTS contains credit letters, amounts and respective balance to date
per supplier and applicable withholding type. The credit letter amounts will be manually entered and
the balance will be calculated automatically by the system as credit letters are entered or witholding taxes are calculated.
.
This table corresponds to the Supplier Withholding Credit Letters window.
.

Indexes

Columns

[top of page]

JL.JL_AR_AP_SUP_AWT_CR_LTS does not reference any database object

JL.JL_AR_AP_SUP_AWT_CR_LTS is referenced by following:

JL

VIEW - JL_AR_AP_SUP_AWT_CR_LTS#

[top of page]

Table: JL_AR_AP_TRX_DGI_CODES

Primary Key: JL_AR_AP_TRX_DGI_CODES_PK

1. TRX_CATEGORY_LETTER_ID

Comments

JL_AR_AP_TRX_DGI_CODES stores DGI transaction codes associated to the different combinations of legal transaction categories and transaction letters. This code will be defaulted automatically when entering invoices and will be used for legal reporting purposes.
This table corresponds to the Transaction Type Codes window.

Indexes

Columns

[top of page]

JL.JL_AR_AP_TRX_DGI_CODES does not reference any database object

JL.JL_AR_AP_TRX_DGI_CODES is referenced by following:

JL

VIEW - JL_AR_AP_TRX_DGI_CODES#

[top of page]

Table: JL_AR_AR_DOC_LETTER_ALL

Primary Key: JL_AR_AR_DOC_LETTER_ALL_PK

1. TAX_CATEGORY_ID
2. ORG_TAX_ATTRIBUTE_NAME
3. ORG_TAX_ATTRIBUTE_VALUE
4. CON_TAX_ATTRIBUTE_NAME
5. CON_TAX_ATTRIBUTE_VALUE
6. END_DATE_ACTIVE

Comments

JL_AR_AR_DOC_LETTER_ALL contains information about Document Letter Assignments for VAT conditions of ship-from and ship-to locations. The Ship-from location's VAT condition is determined by Organization tax condition name and value. The Ship-To location's VAT condition is determined by Contributor tax condition name and value. The Document Letters are defined as QuickCodes and are extensible.

Columns

[top of page]

JL.JL_AR_AR_DOC_LETTER_ALL does not reference any database object

JL.JL_AR_AR_DOC_LETTER_ALL is referenced by following:

JL

VIEW - JL_AR_AR_DOC_LETTER_ALL#

[top of page]

Table: JL_AR_FA_EXHIBIT_GROUPS

Primary Key: JL_AR_FA_EXHIBIT_GROUPS_PK

1. EXHIBIT_GROUP_ID

Comments

The JL_AR_FA_ EXHIBIT_GROUPS table defines the exhibit of
fixed assets groups used to produce the Argentine Exhibit of Fixed Assets
report.

Indexes

Columns

[top of page]

JL.JL_AR_FA_EXHIBIT_GROUPS does not reference any database object

JL.JL_AR_FA_EXHIBIT_GROUPS is referenced by following:

JL

VIEW - JL_AR_FA_EXHIBIT_GROUPS#

[top of page]

Table: JL_AR_FA_EXHIBIT_REPORT

Comments

JL_AR_FA_EXHIBIT_REPORT holds information generated
during the execution of Argentine Exhibit of Assets report.
Records are extracted before being presented by the report

Columns

[top of page]

JL.JL_AR_FA_EXHIBIT_REPORT does not reference any database object

JL.JL_AR_FA_EXHIBIT_REPORT is referenced by following:

JL

VIEW - JL_AR_FA_EXHIBIT_REPORT#

[top of page]

Table: JL_AR_TURN_UPL_ALL

Primary Key: JL_AR_TURN_UPL_ALL_PK

1. START_DATE
2. END_DATE
3. TAXPAYER_ID

Comments

JL_AR_TURN_UPL_ALL stores checked and approved data related to Argentine Applicable Tax Rates

Columns

[top of page]

JL.JL_AR_TURN_UPL_ALL does not reference any database object

JL.JL_AR_TURN_UPL_ALL is referenced by following:

JL

VIEW - JL_AR_TURN_UPL_ALL#

[top of page]

Table: JL_AR_TURN_UPL_T

Primary Key: JL_AR_TURN_UPL_T_PK

1. START_DATE
2. END_DATE
3. TAXPAYER_ID

Comments

JL_AR_TURN_UPL_T stores temporary data related to Argentine Applicable Tax Rates

Indexes

Columns

[top of page]

JL.JL_AR_TURN_UPL_T does not reference any database object

JL.JL_AR_TURN_UPL_T is referenced by following:

JL

VIEW - JL_AR_TURN_UPL_T#

[top of page]

Table: JL_BR_AP_COLLECTION_DOCS_ALL

Primary Key: JL_BR_AP_COLLEC_DOC_PK

1. BANK_COLLECTION_ID

Foreign Keys from this table:

Comments

JL_BR_AP_COLLECTION_DOCS contains records for bank collection documents you enter. A Bank Collection Document is a form sent by banks and used to do payments of titles registered in a collection portfolio.
A payment schedule is released for payment only after a bank collection document is associated to it.
There is one row in JL_BR_AP_COLLECTION_DOCS for each collection document you enter.

Indexes

Columns

[top of page]

JL.JL_BR_AP_COLLECTION_DOCS_ALL does not reference any database object

JL.JL_BR_AP_COLLECTION_DOCS_ALL is referenced by following:

JL

VIEW - JL_BR_AP_COLLECTION_DOCS_ALL#

[top of page]

Table: JL_BR_AP_CONSOLID_INVOICES_ALL

Primary Key: JL_BR_AP_CONS_INVOICES_PK

1. CONSOLIDATED_INVOICE_ID

Foreign Keys from this table:

Comments

JL_BR_AP_CONSOLID_INVOICES_ALL contains records for the consolidated invoices
you enter. There is one row for each consolidated invoice you enter. A consolidated invoice can have one or more shipping invoices attached to it.
.
This table corresponds to the Consolidated Invoices window.
.

Indexes

Columns

[top of page]

JL.JL_BR_AP_CONSOLID_INVOICES_ALL does not reference any database object

JL.JL_BR_AP_CONSOLID_INVOICES_ALL is referenced by following:

JL

VIEW - JL_BR_AP_CONSOLID_INVOICES_AL#

[top of page]

Table: JL_BR_AP_INT_COLLECTION_TMP

Comments

JL_BR_AP_INT_COLLECTION_TMP is the temporary table for the bank collection documents interface. It is used to summarize the results of the Import Collection Document process.
.

Columns

[top of page]

JL.JL_BR_AP_INT_COLLECTION_TMP does not reference any database object

JL.JL_BR_AP_INT_COLLECTION_TMP is referenced by following:

JL

VIEW - JL_BR_AP_INT_COLLECTION_TMP#

[top of page]

Table: JL_BR_AP_INT_COLLECT_ALL

Primary Key: JL_BR_AP_INT_COLLECT_PK

1. FILE_CONTROL
2. ENTRY_SEQUENTIAL_NUMBER

Comments

The JL_BR_AP_INT_COLLECT_ALL table contains records for bank collection documents that you enter. A Bank Collection Document is a form sent by banks and used to do payments of titles
registered in a collection portfolio.
This is the open interface table for Brazilian Accounts Payables Bank collection Document Open Interface
Scope: public
Product: JL
Display Name: Brazilian Accounts Payables Bank collection Document
Lifecycle: active
Category: BUSINESS_ENTITY JL_BR_AP_BANK_COLLECTION_DOC

Indexes

Columns

[top of page]

JL.JL_BR_AP_INT_COLLECT_ALL does not reference any database object

JL.JL_BR_AP_INT_COLLECT_ALL is referenced by following:

JL

VIEW - JL_BR_AP_INT_COLLECT_ALL#

[top of page]

Table: JL_BR_AP_INT_COLLECT_EXT_ALL

Primary Key: JL_BR_AP_COLLECT_EXT_PK

1. FILE_CONTROL
2. ENTRY_SEQUENTIAL_NUMBER

Comments

JL_BR_AP_INT_COLLECT_EXT is the extended table for the bank collection documents interface. To initiate Import Bank Collection Documents, the user must load the bank collection document file sent by the supplier's bank in the JL_BR_AP_INT_COLLECT table. Then, the system will validate each of the interface entries. The valid entries are inserted into the JL_BR_AP_COLLECTION_DOCS table and the invalid entries are inserted into the JL_BR_AP_INT_COLLECT_EXT table. If a few entries do not go through the validation during the import of collection documents, the user can load the collection document file to the JL_BR_AP_INT_COLLECT table again or correct the invalid data in the JL_BR_AP_INT_COLLECT_EXT table. If the option is to correct the interface, after this is done, Oracle Payables automatically transfers the corrected entries from the JL_BR_AP_INT_COLLECT_EXT table to the JL_BR_AP_COLLECTION_DOCS table.
This table corresponds to the Imported Collection Documents window.
.

Indexes

Columns

[top of page]

JL.JL_BR_AP_INT_COLLECT_EXT_ALL does not reference any database object

JL.JL_BR_AP_INT_COLLECT_EXT_ALL is referenced by following:

JL

VIEW - JL_BR_AP_INT_COLLECT_EXT_ALL#

[top of page]

Table: JL_BR_AP_OPERATIONS

Primary Key: JL_BR_AP_OPERATIONS_PK

1. CFO_CODE

Comments

JL_BR_AP_OPERATIONS contains information about operations fiscal codes.
This table corresponds to the Operation Fiscal Codes window.
.

Indexes

Columns

[top of page]

JL.JL_BR_AP_OPERATIONS does not reference any database object

JL.JL_BR_AP_OPERATIONS is referenced by following:

JL

VIEW - JL_BR_AP_OPERATIONS#

[top of page]

Table: JL_BR_AP_TAX_CALENDAR_HEADERS

Primary Key: JL_BR_AP_TAX_CALENDAR_HEAD_PK

1. TAX_CALENDAR_NAME

Foreign Keys to this table:

Comments

JL_BR_AP_TAX_CALENDAR_HEADERS stores the information related to the withholding tax that allows the user to have a specific due date to pay the withholding tax, defined by tax type.
This table corresponds to the TAX_CALENDAR_HEADERS block of the Tax Calendars window.

Indexes

Columns

[top of page]

JL.JL_BR_AP_TAX_CALENDAR_HEADERS does not reference any database object

JL.JL_BR_AP_TAX_CALENDAR_HEADERS is referenced by following:

JL

VIEW - JL_BR_AP_TAX_CALENDAR_HEADERS#

[top of page]

Table: JL_BR_AP_TAX_CALENDAR_LINES

Primary Key: JL_BR_AP_TAX_CALENDAR_LINE_PK

1. TAX_CALENDAR_ID

Foreign Keys from this table:

Comments

JL_BR_AP_TAX_CALENDAR_LINES stores the lines for each withholding tax calendar header, related to the withholding tax, that allows the user to have a specific due date to pay the withholding tax.
This table corresponds to the TAX_CALENDAR_LINES block of the Tax Calendars window.
.

Indexes

Columns

[top of page]

JL.JL_BR_AP_TAX_CALENDAR_LINES does not reference any database object

JL.JL_BR_AP_TAX_CALENDAR_LINES is referenced by following:

JL

VIEW - JL_BR_AP_TAX_CALENDAR_LINES#

[top of page]

Table: JL_BR_AR_BANK_INSTRUCTIONS

Primary Key: JL_BR_AR_BANK_INSTRUCTIONS_PK

1. BANK_PARTY_ID
2. BANK_INSTRUCTION_CODE

Foreign Keys from this table:

Comments

JL_BR_AR_BANK_INSTRUCTIONS stores the Bank Instruction Codes and their association with the pre-defined Standard Instruction Codes seeded in FND_LOOKUPS. Bank Instruction codes are used for sending Instructions to the banks for collection documents.

Indexes

Columns

[top of page]

JL.JL_BR_AR_BANK_INSTRUCTIONS does not reference any database object

JL.JL_BR_AR_BANK_INSTRUCTIONS is referenced by following:

JL

VIEW - JL_BR_AR_BANK_INSTRUCTIONS#

[top of page]

Table: JL_BR_AR_BANK_OCCURRENCES

Primary Key: JL_BR_AR_BANK_OCCURRENCES_PK

1. BANK_PARTY_ID
2. BANK_OCCURRENCE_CODE
3. BANK_OCCURRENCE_TYPE

Foreign Keys from this table:

Foreign Keys to this table:

Comments

JL_BR_AR_BANK_OCCURRENCES stores occurrence codes and their association with pre-defined standard occurrence codes seeded in FND_LOOKUPS. Bank Occurrence codes are used for sending occurrences to the banks for collection documents.

Indexes

Columns

[top of page]

JL.JL_BR_AR_BANK_OCCURRENCES does not reference any database object

JL.JL_BR_AR_BANK_OCCURRENCES is referenced by following:

JL

VIEW - JL_BR_AR_BANK_OCCURRENCES#

[top of page]

Table: JL_BR_AR_BANK_RETURNS_ALL

Primary Key: JL_BR_AR_BANK_RETURNS_ALL_PK

1. RETURN_ID

Foreign Keys from this table:

Comments

JL_BR_AR_BANK_RETURNS_ALL stores the bank return documents which have been succesfully validated by the Import Bank Returns program. It also stores the manually entered bank returns.

Indexes

Columns

[top of page]

JL.JL_BR_AR_BANK_RETURNS_ALL does not reference any database object

JL.JL_BR_AR_BANK_RETURNS_ALL is referenced by following:

JL

VIEW - JL_BR_AR_BANK_RETURNS_ALL#

[top of page]

Table: JL_BR_AR_BORDEROS_ALL

Primary Key: JL_BR_AR_BORDEROS_ALL_PK

1. BORDERO_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

JL_BR_AR_BORDEROS_ALL stores bank transfer and remittance batches.

Indexes

Columns

[top of page]

JL.JL_BR_AR_BORDEROS_ALL does not reference any database object

JL.JL_BR_AR_BORDEROS_ALL is referenced by following:

JL

VIEW - JL_BR_AR_BORDEROS_ALL#

[top of page]

Table: JL_BR_AR_COLLECTION_DOCS_ALL

Primary Key: JL_BR_AR_COLLEC_DOCS_ALL_PK

1. DOCUMENT_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

JL_BR_AR_COLLECTION_DOCS_ALL stores documents that are selected to be sent or that were sent to banks for collection. Each collection document corresponds to a payment schedule.

Indexes

Columns

[top of page]

JL.JL_BR_AR_COLLECTION_DOCS_ALL does not reference any database object

JL.JL_BR_AR_COLLECTION_DOCS_ALL is referenced by following:

JL

VIEW - JL_BR_AR_COLLECTION_DOCS_ALL#

[top of page]

Table: JL_BR_AR_COMP_INV_ALL

Primary Key: JL_BR_AR_COMP_INV_ALL_PK

1. COMP_INVOICE_ID

Foreign Keys from this table:

Comments

JL_BR_AR_COMP_INV_ALL stores Billing complementary invoices. Billing complementary invoices are created and printed to correct mistakes in a previous invoice. You can correct tax rate, tax amount, unit and total amounts, and so on.

Indexes

Columns

[top of page]

JL.JL_BR_AR_COMP_INV_ALL does not reference any database object

JL.JL_BR_AR_COMP_INV_ALL is referenced by following:

JL

VIEW - JL_BR_AR_COMP_INV_ALL#

[top of page]

Table: JL_BR_AR_CUST_INT_ERR

Comments

JL_BR_AR_CUST_INT_ERR is a temporary table used by the Brazilian Customer Interface for the Brazilian Receivables Customer Interface Error report.

Columns

[top of page]

JL.JL_BR_AR_CUST_INT_ERR does not reference any database object

JL.JL_BR_AR_CUST_INT_ERR is referenced by following:

JL

VIEW - JL_BR_AR_CUST_INT_ERR#

[top of page]

Table: JL_BR_AR_DISTRIBUTNS_ALL

Primary Key: JL_BR_AR_DISTRIBUTNS_PK

1. DISTRIBUTION_ID

Comments

Stores distributions for a collection and occurrence document.

Indexes

Columns

[top of page]

JL.JL_BR_AR_DISTRIBUTNS_ALL does not reference any database object

JL.JL_BR_AR_DISTRIBUTNS_ALL is referenced by following:

JL

VIEW - JL_BR_AR_DISTRIBUTNS_ALL#

[top of page]

Table: JL_BR_AR_MC_OCC_DOCS

Primary Key: JL_BR_AR_MC_OCC_DOCS_PK

1. OCCURRENCE_ID
2. SET_OF_BOOKS_ID

Comments

This is the Multiple Reporting Currency sub-table corresponding to the base table JL_BR_AR_OCCURRENCE_DOCS_ALL. One row is inserted into the sub-table for every reporting currency for each row created in the base table.

Columns

[top of page]

JL.JL_BR_AR_MC_OCC_DOCS does not reference any database object

JL.JL_BR_AR_MC_OCC_DOCS is referenced by following:

JL

VIEW - JL_BR_AR_MC_OCC_DOCS#

[top of page]

Table: JL_BR_AR_OCCURRENCE_DOCS_ALL

Primary Key: JL_BR_AR_OCCUR_DOCS_ALL_PK

1. OCCURRENCE_ID

Foreign Keys from this table: