JL Tables (115)
JL - Latin America Localizations — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
JL_AR_AP_AWT_CERTIF_ALL |
44 | Argentine withholding certificate information |
JL_AR_AP_MTBT_THRESHOLDS |
9 | JL_AR_AP_MTBT_THRESHOLDS is used to capture Threshold values of simplified regime contributor type for Monotributa Suppliers |
JL_AR_AP_PROVINCES |
24 | Argentine province records |
JL_AR_AP_SUP_AWT_CR_LTS |
38 | Argentine supplier withholding credit letter information |
JL_AR_AP_TRX_DGI_CODES |
25 | Argentine DGI transaction type codes |
JL_AR_AR_DOC_LETTER_ALL |
30 | Argentine Document Letter Assignments information |
JL_AR_FA_EXHIBIT_GROUPS |
25 | Information about exhibit of fixed assets groups |
JL_AR_FA_EXHIBIT_REPORT |
19 | Release 11i: Data extraction table for Argentine Fixed Assets Exhibit report |
JL_AR_TURN_UPL_ALL |
18 | Stores data for Argentine Applicable Tax Rates |
JL_AR_TURN_UPL_T |
16 | Interface table for Argentine Applicable Tax Rates |
JL_BR_AP_COLLECTION_DOCS_ALL |
78 | Detailed Brazilian bank collection document records |
JL_BR_AP_CONSOLID_INVOICES_ALL |
39 | Detailed Brazilian consolidated invoice records |
JL_BR_AP_INT_COLLECTION_TMP |
6 | Temporary information of bank collection documents interface |
JL_BR_AP_INT_COLLECT_ALL |
74 | Bank collection document loaded from the file of supplier's bank |
JL_BR_AP_INT_COLLECT_EXT_ALL |
74 | Invalid records from the JL_BR_AP_INT_COLLECT table |
JL_BR_AP_OPERATIONS |
10 | Brazilian operations fiscal codes |
JL_BR_AP_TAX_CALENDAR_HEADERS |
9 | Brazilian withholding tax calendar header information |
JL_BR_AP_TAX_CALENDAR_LINES |
12 | Brazilian withholding tax calendar line information |
JL_BR_AR_BANK_INSTRUCTIONS |
27 | Bank Instruction Codes |
JL_BR_AR_BANK_OCCURRENCES |
29 | Bank Occurrence codes |
JL_BR_AR_BANK_RETURNS_ALL |
35 | Validated Bank Returns |
JL_BR_AR_BORDEROS_ALL |
26 | Bank Transfer Batches |
JL_BR_AR_COLLECTION_DOCS_ALL |
76 | Collection Documents |
JL_BR_AR_COMP_INV_ALL |
56 | Complementary Invoices |
JL_BR_AR_CUST_INT_ERR |
2 | Customer interface import errors |
JL_BR_AR_DISTRIBUTNS_ALL |
25 | A new table required for SLA uptake |
JL_BR_AR_MC_OCC_DOCS |
9 | Multiple reporting currency sub-table for JL_BR_AR_OCCURRENCE_DOCS_ALL |
JL_BR_AR_OCCURRENCE_DOCS_ALL |
98 | Occurrences for collection documents |
JL_BR_AR_PAY_SCHED_AUX |
22 | Temporary table for Bank Transfer batches creation |
JL_BR_AR_POSTING_TMP |
11 | Temporary table for Bank collection GL Interface report |
JL_BR_AR_REC_MET_ACCTS_EXT_ALL |
51 | Receipt Method accounts |
JL_BR_AR_REMIT_BORDEROS_ALL |
9 | Request IDs of Formatted Bank Transfer Batches |
JL_BR_AR_RET_INTERFACE_ALL |
35 | Interface table for importing bank returns |
JL_BR_AR_RET_INTERFACE_EXT_ALL |
40 | Interface table with erroneous bank returns rows |
JL_BR_AR_RET_INTERFACE_TMP |
15 | Temporary table for post bank returns report |
JL_BR_AR_SELECT_ACCOUNTS_ALL |
41 | Bank Account distribution criteria for Bank Transfer batches |
JL_BR_AR_SELECT_CONTROLS_ALL |
45 | Selection Criteria for invoices sent to Bank transfer batches |
JL_BR_AR_TX_CATEG_ALL |
19 | Brazilian Tax Categories;no longer used |
JL_BR_AR_TX_EXC_FSC_ALL |
15 | Brazilian Tax Exception By Fiscal Classification Information;no longer used |
JL_BR_AR_TX_EXC_ITM_ALL |
16 | Brazilian Tax Excption By Item Information;no longer used |
JL_BR_AR_TX_FSC_CLS_ALL |
13 | Brazilian Tax Fiscal Classification Information;no longer used |
JL_BR_AR_TX_GROUP_ALL |
22 | Brazilian Tax Groups;no longer used |
JL_BR_AR_TX_LOCN_ALL |
14 | Brazilian Tax Location Information;no longer used |
JL_BR_AR_TX_RULES_ALL |
14 | Brazilian Tax Rules Information;no longer used |
JL_BR_BALANCES_ALL |
17 | Oracle Payables and Oracle Receivables transaction balances |
JL_BR_CINFOS_BOOKS |
12 | A table to store the Company Accounting Books setup information |
JL_BR_COMPANY_INFOS |
39 | No Longer Used in R12 |
JL_BR_CUSTOMER_TRX_EXTS |
30 | Stores transactions for Brazilian SPED |
JL_BR_CUST_TRX_LINES_EXTS |
37 | Stores Brazilian Electronic Invoice Line Attributes (1:1 extension to RA_CUSTOMER_TRX_LINES_ALL table |
JL_BR_EILOG |
10 | Stores log data for Brazilian SPED |
JL_BR_GL_LEGAL_REP |
41 | Ledger Book and Subledger Information |
JL_BR_INTERFACE_LINES_EXTS |
45 | Stores Brazilian Electronic Invoice Line Attributes at Receivables Interface Line Level (1:1 extension to RA_INTERFACE_LINES_ALL table) |
JL_BR_INV_API_TRX_LINES_T |
41 | Temporary Table to Store Brazilian Electronic Invoice Line Attributes during Invoice API process (1:1 extension to Receivables Invoice API P |
JL_BR_JOURNALS_ALL |
24 | Accounting entries successfully transferred from the subledgers to GL |
JL_BR_LOCAL_HOLIDAY_DATES |
28 | Brazilian local holiday dates |
JL_BR_LOCAL_HOLIDAY_SETS |
30 | Brazilian local holiday sets |
JL_BR_SPED_EXTR_DATA_H |
38 | A history table to store the finally submitted Accounting SPED Text file data |
JL_BR_SPED_EXTR_DATA_T |
38 | A table to store data required for generating the Accounting SPED text file |
JL_BR_SPED_EXTR_MSGS |
11 | A table to store information about the Accounting SPED Text File Validation Rules that have failed |
JL_BR_SPED_EXTR_PARAM |
37 | A table to store the parameters of every Accounting SPED Data extract program submitted |
JL_BR_SPED_PARTIC_CODES |
28 | A table to store the Participant Codes setup information |
JL_BR_SPED_PARTIC_REL |
11 | A table to store the Participant Relationship setup information |
JL_BR_TAX_LMSG_ALL |
14 | Brazilian Tax Legal Messages;no longer used |
JL_CANCEL_GT |
40 | |
JL_CL_AP_AWT_CERT |
20 | Chilean withholding certificate information |
JL_CL_GL_ACCT_HIER_TMP |
15 | Chilean General Ledger "8 Columns Trial Balance" Report Account Hierarchy |
JL_CO_FA_ADJUSTMENTS |
27 | Accounting information pertaining to Colombian Oracle Assets |
JL_CO_FA_APPRAISALS |
35 | Information about the technical appraisal header |
JL_CO_FA_APPRAISAL_BOOKS |
27 | Information about the book for which the appraisal has been revaluated successfully |
JL_CO_FA_ASSET_APPRS |
29 | Information about assets appraised |
JL_CO_FA_PURGE |
21 | Information about the Colombian archive, purge and restore requests |
JL_CO_GL_BALANCES |
18 | Third Party Balances Table Summarized By Third Party Identifier And Period For A Code Combination And Set Of Books ID |
JL_CO_GL_CONC_CTRL |
11 | Third Party Control Table Containing Log For Every Submission Of 'Generate Third Party Balances' Concurrent Program |
JL_CO_GL_CONC_ERRS |
10 | Third Party Errors Table Containing Error Log That Is Refreshed On Every New Submission Of 'Generate Third Party Balances' Concurrent Progra |
JL_CO_GL_MG_CONFIGS |
29 | Magnetic Media Report Grouping Configurations |
JL_CO_GL_MG_HEADERS |
9 | Magnetic Media Movement Headers |
JL_CO_GL_MG_LINES |
26 | Magnetic Media Movement lines |
JL_CO_GL_MG_LITERALS |
34 | Magnetic Media Literals |
JL_CO_GL_MG_RANGES |
84 | Magnetic Media Account Ranges |
JL_CO_GL_NITS |
26 | Third Party Master Table |
JL_CO_GL_NIT_ACCTS |
25 | Third Party Control Accounts Table Used For Referring NIT Required Accounts |
JL_CO_GL_TRX |
26 | Third Party Transaction Table Containing Posted Transactions Of GL From Different Sources For NIT Required Accounts |
JL_MX_FA_ISR_IMPAC |
20 | Holds information generated during the execution of ISR and IMPAC reports |
JL_REMIT3_GT |
3 | |
JL_REMIT_GT |
40 | |
JL_ZZ_AP_AWT_TYPES |
45 | Withholding tax type records for Argentina and Colombia |
JL_ZZ_AP_COMP_AWT_TYPES |
28 | Withholding applicability information per company/location for Argentina and Colombia |
JL_ZZ_AP_INV_DIS_WH_ALL |
27 | Invoice distribution withholding information for Argentina and Colombia |
JL_ZZ_AP_INV_DIS_WH_ALL_T |
27 | |
JL_ZZ_AP_SUPP_AWT_TYPES |
32 | Withholding applicability information per supplier for Argentina and Colombia |
JL_ZZ_AP_SUP_AWT_CD_ALL |
31 | Withholding tax codes applicable to Argentine and Colombian suppliers |
JL_ZZ_AR_TX_ATT_CLS_ALL |
31 | Latin Tax Condition Classes Information |
JL_ZZ_AR_TX_ATT_VAL_ALL |
30 | Latin Tax Condition Values Information |
JL_ZZ_AR_TX_CATEG_ALL |
46 | Latin Tax Category Information |
JL_ZZ_AR_TX_CAT_ATT_ALL |
31 | Latin Tax Category - Conditions Association Information |
JL_ZZ_AR_TX_CAT_DTL_ALL |
30 | Latin Tax Category Detail Information |
JL_ZZ_AR_TX_CUS_CLS_ALL |
13 | Latin Tax Customer Site Profile Information |
JL_ZZ_AR_TX_EXC_CUS_ALL |
29 | Latin Tax Exception By Customer Site Information |
JL_ZZ_AR_TX_EXC_FSC_ALL |
31 | Latin Tax Exception By Fiscal Classification Information |
JL_ZZ_AR_TX_EXC_ITM_ALL |
32 | Latin Tax Exception By Item Information |
JL_ZZ_AR_TX_FSC_CLS_ALL |
30 | Latin Tax Fiscal Classification Information |
JL_ZZ_AR_TX_GROUPS_ALL |
42 | Latin Tax Group Information |
JL_ZZ_AR_TX_LGL_MSG_ALL |
14 | Latin Tax Legal Messages Information |
JL_ZZ_AR_TX_LOCN_ALL |
31 | Latin Tax Location Information |
JL_ZZ_AR_TX_NAT_RAT_ALL |
31 | Latin Tax Exception By Transaction Condition Values Information |
JL_ZZ_AR_TX_RULES_ALL |
14 | Latin Tax Rules Information |
JL_ZZ_AR_TX_SCHEDULES_ALL |
29 | Latin Tax Schedules Information |
JL_ZZ_FA_RETIREMNT_ADJS |
17 | Information about retired assets that need to be inflation adjusted |
JL_ZZ_FA_RETIREMNT_JES |
15 | Audit table that stores inflation adjustment journal entries of retired assets at code combination level |
JL_ZZ_GL_AXI |
23 | Inflation Adjustment Gain and Loss Accounts |
JL_ZZ_GL_AXI_ACCOUNTS |
83 | Runtime Inflation Adjustment Gain and Loss Account Ranges |
JL_ZZ_GL_AXI_MODELS |
25 | Accounting Models |
JL_ZZ_GL_AXI_MODEL_RANGES |
83 | Accounting Model Account Ranges |
JL_ZZ_GL_AXI_TMP |
9 | Temporary Table For Inflation Adjustment Report |
JL_ZZ_INFO_T |
45 | JL_ZZ_INFO_T is temporary table |