DW_GL_SLA_RECON_CF

This is the reconciliation table with AP facts, AR facts,XLA details, Journal details and GL balance details.

Details

Module: Subledger Accounting

Key Columns

TEMP_LINE_NUM, PARENT_STRIPE, SOURCE_DISTRIBUTION_ID_NUM_1, APPLICATION_ID, JOURNAL_LINE_NUM, AE_HEADER_ID, AE_LINE_NUM, REF_AE_HEADER_ID, JOURNAL_HEADER_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PARENT_STRIPE VARCHAR2 128   True To identify different types of Entities eg. AR_RECEIPTS, AR_TRANSACTIONS etc    
APPLICATION_ID NUMBER 38 0 True 101 for GL, 200 for AP, 222 for AR    
AE_HEADER_ID NUMBER 38 0 True Subledger journal entry identifier.    
AE_LINE_NUM NUMBER 38 0 True Number that is associated with each subledger journal entry line.    
REF_AE_HEADER_ID NUMBER 38 0 True Reversed subledger journal entry header identifier    
TEMP_LINE_NUM NUMBER 38 0 True Intermediary line number generated by the accounting engine when the entries are in most detail form.    
SOURCE_DISTRIBUTION_ID_NUM_1 NUMBER 38 0 True Sub legder transaction source distribution identifier.    
JOURNAL_HEADER_ID NUMBER 38 0 True Journal entry header identifier.    
JOURNAL_LINE_NUM NUMBER 38 0 True Journal line number.    
SOURCE_RECORD_ID VARCHAR2 999     This column is for Oracle Internal use only. Unique record identifier    
STRIPE VARCHAR2 128     To identify different types of stripes eg. Posted to GL, transferred to GL etc    
XLA_LEDGER_ID NUMBER 38 0   SLA ledger identifier DW_LEDGER_D LEDGER_ID
RECON_LEDGER_ID NUMBER 38 0   Ledger Id DW_LEDGER_D LEDGER_ID
JOURNAL_LEDGER_ID NUMBER 38 0   Journal Ledger identifier. DW_LEDGER_D LEDGER_ID
JOURNAL_LEDGER_CATEGORY_CODE VARCHAR2 128     Journal Ledger category. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=GL_ASF_LEDGER_CATEGORY. Possible values are PRIMARY, SECONDARY, ALC, and so on. DW_CODE_VALUES_LKP_TL CODE
LEGAL_ENTITY_ID NUMBER 38 0   Legal entity identifier. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
GL_CODE_COMBINATION_ID NUMBER 38 0   GL account identifier. DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
COST_CENTER_SEGMENT VARCHAR2 32     Cost center segment. DW_COST_CENTER_D COST_CENTER_SEGMENT
COST_CENTER_VALUESET_CODE VARCHAR2 64     Cost center value set code. DW_COST_CENTER_D COST_CENTER_VALUESET_CODE
GL_BALANCING_SEGMENT VARCHAR2 32     Balancing segment. DW_BALANCING_SEGMENT_D GL_BALANCING_SEGMENT
GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64     Balancing segment value set code. DW_BALANCING_SEGMENT_D GL_BLNC_SGMNT_VALUESET_CODE
NATURAL_ACCOUNT_SEGMENT VARCHAR2 32     Natural account segment. DW_NATURAL_ACCOUNT_D NATURAL_ACCOUNT_SEGMENT
NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64     Natural account value set code. DW_NATURAL_ACCOUNT_D NTRL_ACNT_SGMNT_VALUESET_CODE
GL_SEGMENT1 VARCHAR2 32     Accounting segment 1. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT1_VALUESET_CODE VARCHAR2 64     Accounting segment 1 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT2 VARCHAR2 32     Accounting segment 2. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT2_VALUESET_CODE VARCHAR2 64     Accounting segment 2 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT3 VARCHAR2 32     Accounting segment 3. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT3_VALUESET_CODE VARCHAR2 64     Accounting segment 3 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT4 VARCHAR2 32     Accounting segment 4. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT4_VALUESET_CODE VARCHAR2 64     Accounting segment 4 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT5 VARCHAR2 32     Accounting segment 5. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT5_VALUESET_CODE VARCHAR2 64     Accounting segment 5 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT6 VARCHAR2 32     Accounting segment 6. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT6_VALUESET_CODE VARCHAR2 64     Accounting segment 6 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT7 VARCHAR2 32     Accounting segment 7. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT7_VALUESET_CODE VARCHAR2 64     Accounting segment 7 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT8 VARCHAR2 32     Accounting segment 8. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT8_VALUESET_CODE VARCHAR2 64     Accounting segment 8 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT9 VARCHAR2 32     Accounting segment 9. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT9_VALUESET_CODE VARCHAR2 64     Accounting segment 9 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT10 VARCHAR2 32     Accounting segment 10. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT10_VALUESET_CODE VARCHAR2 64     Accounting segment 10 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
FISCAL_PERIOD_SET_NAME VARCHAR2 16     Accounting calendar name. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE VARCHAR2 16     Accounting period type. DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
FISCAL_PERIOD_NAME VARCHAR2 256     Accounting period name. DW_FISCAL_DAY_D FISCAL_PERIOD_NAME
ACCOUNTING_DATE DATE       Pre-SLA Accounting date. DW_FISCAL_DAY_D FISCAL_DAY_DATE
RECON_FISCAL_PERIOD_SET_NAME VARCHAR2 16     Accounting calendar name(driven by xla accounting date for AP and AR, Journal header effective date for GL ).. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
RECON_FISCAL_PERIOD_TYPE VARCHAR2 16     Accounting period type(driven by xla accounting date for AP and AR, Journal header effective date for GL ).. DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
RECON_FISCAL_PERIOD_NAME VARCHAR2 256     Accounting period name(driven by xla accounting date for AP and AR, Journal header effective date for GL ). DW_FISCAL_DAY_D FISCAL_PERIOD_NAME
RECON_ACCOUNTING_DATE DATE       Accounting date(driven by xla accounting date for AP and AR, Journal header effective date for GL ).. DW_FISCAL_DAY_D FISCAL_DAY_DATE
JRNL_HDR_DFLT_EFFECTIVE_DATE DATE       Journal header effective date. DW_FISCAL_DAY_D FISCAL_DAY_DATE
SUPPLIER_PARTY_ID NUMBER 38 0   Supplier identifier. DW_PARTY_D PARTY_ID
SUPPLIER_SITE_ID NUMBER 38 0   Supplier site identifier. DW_SUPPLIER_SITE_D SUPPLIER_SITE_ID
THIRD_PARTY_ID NUMBER 38 0   Third party payee identifier. DW_PARTY_D SUPPLIER_ID
PAYABLES_BU_ID NUMBER 38 0   Payables invoicing business unit identifier. DW_INTERNAL_ORG_D ORGANIZATION_ID
PAYABLES_CODE_COMB_ID NUMBER 38 0   Payables Account Identifier DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
INVOICE_ID NUMBER 38 0   Invoice identifier    
INVOICE_NUMBER VARCHAR2 64     Invoice number    
INVOICE_GROUP VARCHAR2 64     Invoice Group or Invoice batch name    
INVOICE_DESCRIPTION VARCHAR2 256     Invoice description    
INVOICE_VOUCHER_NUMBER VARCHAR2 64     Voucher number related to the invoice; Validated (Sequential Numbering enabled) or Non-Validated (Sequential Numbering not enabled)    
AP_DISTRIBUTION_TYPE_CODE VARCHAR2 32     Distribution type. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=INVOICE DISTRIBUTION TYPE. Possible values are ITEM, ERV, NONREC_TAX, TRV, FREIGHT, MISCELLANEOUS, TIPV, AWT, IPV, REC_TAX, ACCRUAL, PREPAY, TERV, and so on (OR) Payment distribution type. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=PAY_DIST_TYPES. DW_CODE_VALUES_LKP_TL CODE
AP_ACCOUNTING_STATUS_CODE VARCHAR2 32     Invoice distribution accounting status or Payment accounting status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_ACCOUNTING_STATUS. DW_CODE_VALUES_LKP_TL CODE
PURCHASE_ORDER_DATE TIMESTAMP       Purchase order creation date.    
INVOICED_ON_DATE DATE       Date when invoiced is created.    
INVOICE_RECEIVED_DATE DATE       Date when invoice is received.    
PAYMENT_TERMS_ID NUMBER 38 0   Payment terms identifier. DW_AP_TERMS_D PAYMENT_TERMS_ID
INVOICE_TYPE_CODE VARCHAR2 32     Invoice type. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=INVOICE TYPE. Possible values are STANDARD, CREDIT, DEBIT, PAYMENT REQUEST, PREPAYMENT, INTEREST, INVOICE REQUEST, AWT, CREDIT MEMO REQUEST, EXPENSE REPORT, MIXED, and so on. DW_CODE_VALUES_LKP_TL CODE
INVOICE_SOURCE_CODE VARCHAR2 32     Invoice source. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=SOURCE. Possible values are INVOICE GATEWAY, Recurring Invoice, SelfService, Confirm PaymentBatch, LOANS, Manual Invoice Entry, QuickCheck, and so on. DW_CODE_VALUES_LKP_TL CODE
INVOICE_CANCELLED_FLAG VARCHAR2 32     Indicates a cancelled invoice. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. DW_CODE_VALUES_LKP_TL CODE
HEADER_CREATED_BY_USER_ID VARCHAR2 128     User who created the invoice. DW_USER_D USERNAME
CREATED_BY_USER_ID VARCHAR2 128     User who created the record. DW_USER_D USERNAME
UPDATED_BY_USER_ID VARCHAR2 128     User who updated the record. DW_USER_D USERNAME
INVOICE_CREATION_DATE TIMESTAMP       Date when invoice row was created in the table.    
INVOICE_LINE_NUMBER NUMBER       Invoice line number.    
DISTRIBUTION_LINE_NUMBER NUMBER 38 0   Distribution line number.    
PURCHASE_ORDER_NUMBER VARCHAR2 32     Purchase order number.    
PURCHASE_ORDER_LINE_NUMBER NUMBER       Purchase order line number.    
RECEIVING_SHIPMENT_RECEIPT_NUM VARCHAR2 32     Shipment receipt number.    
RECEIVING_SHIPMENT_LINE_NUMBER NUMBER 38 0   Shipment line number.    
DISTRIBUTION_DESCRIPTION VARCHAR2 256     Distribution description.    
AP_INVOICE_ACCOUNTING_DATE DATE       Date when invoice was accounted DW_FISCAL_DAY_D FISCAL_DAY_DATE
PREPAY_DIST_TYPE_CODE VARCHAR2 32     Type of prepayment application distribution.    
DISTRIBUTION_CANCELLED_FLAG VARCHAR2 16     Indicates a cancelled distribution. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. DW_CODE_VALUES_LKP_TL CODE
PAYABLES_PAYMENTS_BU_ID NUMBER 38 0   Payables payments business unit identifier. DW_INTERNAL_ORG_D ORGANIZATION_ID
INVOICE_SCHEDULE_NUMBER NUMBER 38 0   Invoice schedule number.    
CHECK_ID NUMBER 38 0   Check Identifier    
CHECK_NUMBER NUMBER 38 0   Check number.    
PAYMENT_REASON_COMMENTS VARCHAR2 256     Reason for payment.    
CHECK_DATE DATE       Date when check was issued.    
CHECK_CLEARED_DATE DATE       Check cleared date.    
PAYMENT_STATUS_CODE VARCHAR2 32     Payment status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=CHECK STATE. DW_CODE_VALUES_LKP_TL CODE
PAYMENT_CANCELLED_FLAG VARCHAR2 16     Indicates a cancelled payment. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. DW_CODE_VALUES_LKP_TL CODE
CUSTOMER_ID NUMBER 38 0   Customer identifier. DW_PARTY_D PARTY_ID
CUSTOMER_ACCOUNT_ID NUMBER 38 0   Customer account identifier. DW_CUSTOMER_ACCOUNT_D CUSTOMER_ACCOUNT_ID
RECEIVABLES_BU_ORG_ID NUMBER 38 0   Receivables business unit organization identifier. DW_INTERNAL_ORG_D ORGANIZATION_ID
CUSTOMER_TRX_ID NUMBER 38 0   Customer Transaction Identifier    
TRANSACTION_NUMBER VARCHAR2 32     Transaction number.    
CREDITMEMO_NUMBER VARCHAR2 32     Creditmemo Transaction number.    
TRANSACTION_CLASS_CODE VARCHAR2 32     Transaction class. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AR_TRANSACTION_TYPE_CODE. Possible values are INV, CM, DM, or CB. DW_CODE_VALUES_LKP_TL CODE
BATCH_SOURCE_SEQ_ID NUMBER 38 0   Batch source sequence identifier. DW_AR_TRX_BATCH_SOURCES_D BATCH_SOURCE_SEQ_ID
CUST_TRX_TYPE_SEQ_ID NUMBER 38 0   Transaction type identifier DW_AR_TRANSACTION_TYPES_D CUST_TRX_TYPE_SEQ_ID
LINE_NUMBER NUMBER 38 0   Invoice Line Number    
DETAIL_LINE_NUMBER NUMBER 38 0   Invoice Detail Number    
DISTRIBUTION_COMMENTS VARCHAR2 256     Distribution Line comments    
RECEIVABLES_RECEIPT_BU_ORG_ID NUMBER 38 0   Receivables receipt business unit organization identifier. DW_INTERNAL_ORG_D ORGANIZATION_ID
CASH_RECEIPT_ID NUMBER 38 0   Cash Receipt ID    
RECEIPT_NUMBER VARCHAR2 32     Receipt number.    
RECEIPT_TYPE VARCHAR2 32     Receipt type. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=PAYMENT_CATEGORY_TYPE. Possible values are CASH for Standard ,MISC for Miscellaneous. DW_CODE_VALUES_LKP_TL CODE
RECEIPT_STATUS_CODE VARCHAR2 32     Receipt status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=RECEIPT_CREATION_STATUS. Possible values are APPROVED, CLEARED, CONFIRMED, REMITTED, REVERSED, RISK_ELIMINATED DW_CODE_VALUES_LKP_TL CODE
RECEIPT_APPLN_STATUS_CODE VARCHAR2 32     Receipt application status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=RECEIPT_STATUS. Possible values are NSF forNonsufficient funds, APP for Applied, STOP for Stopped payment and so on. DW_CODE_VALUES_LKP_TL CODE
RECEIPT_APPLN_ACCOUNTING_DATE DATE       Receipt application accounting date. DW_FISCAL_DAY_D FISCAL_DAY_DATE
ADJUSTMENT_ID NUMBER 38 0   Adjustment identifier.    
ADJUSTMENT_NUMBER VARCHAR2 128     Adjustment number.    
ADJUSTMENT_TYPE VARCHAR2 16     Adjustment type . Possible values are CHARGES,INVOICE,LINE,FREIGHT,TAX and so on.    
ADJUSTMENT_STATUS_CODE VARCHAR2 32     Adjustment status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=ADJUSTMENT_STATUS. Possible values are A, R, and so on. DW_CODE_VALUES_LKP_TL CODE
CREDITMEMO_APPL_STATUS_CODE VARCHAR2 32     Credit memo application status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=RECEIPT_STATUS or AR_APPLICATION_STATUS. Possible values are APP, ACTIVITY, and so on. DW_CODE_VALUES_LKP_TL CODE
APPLIED_TRANSACTION_NUMBER VARCHAR2 32     Applied transaction number.    
XLA_TRANSACTION_AMOUNT BIGDECIMAL   10   Unrounded entered amount    
XLA_LEDGER_AMOUNT BIGDECIMAL   10   Unrounded accounted amount    
XLA_ENTERED_DR_AMOUNT BIGDECIMAL   10   Unrounded entered debit amount for the journal line.    
XLA_ENTERED_CR_AMOUNT BIGDECIMAL   10   Unrounded entered credit amount for the journal line.    
XLA_ACCOUNTED_DR_AMOUNT BIGDECIMAL   10   Unrounded accounted debit for journal entry line.    
XLA_ACCOUNTED_CR_AMOUNT BIGDECIMAL   10   Unrounded accounted credit for journal entry line.    
XLA_MANUAL_OVERRIDE_FLAG VARCHAR2 16     Indicates a manual override. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE='YES/NO'. DW_CODE_VALUES_LKP_TL CODE
SOURCE_DISTRIBUTION_TYPE VARCHAR2 32     Classification of transaction source distribution    
ACCOUNTING_LINE_CODE VARCHAR2 32     Short name of a rule to convert transactional data into a journal entry line.    
ACCOUNTING_LINE_TYPE_CODE VARCHAR2 16     Type of journal line rule: Debit, Credit, Gain or Loss.    
ACCOUNTING_CLASS_CODE VARCHAR2 32     Short name of a lookup type that is shared across application used to classify journal entry lines. DW_XLA_ACCOUNT_CLASS_LKP_TL ACCOUNTING_CLASS_CODE
XLA_LINE_TRANSACTION_AMOUNT BIGDECIMAL   10   XLA Line Amount in transaction Currency    
XLA_LINE_ENTERED_DR_AMOUNT BIGDECIMAL   10   Unrounded entered debit amount for the journal line.    
XLA_LINE_ENTERED_CR_AMOUNT BIGDECIMAL   10   Unrounded entered credit amount for the journal line.    
XLA_LINE_LEDGER_AMOUNT BIGDECIMAL   10   XLA Line Amount in Ledger Currency    
XLA_LINE_ACCOUNTED_DR_AMOUNT BIGDECIMAL   10   Unrounded accounted debit amount of the journal entry line.    
XLA_LINE_ACCOUNTED_CR_AMOUNT BIGDECIMAL   10   Unrounded accounted credit amount of the journal entry line.    
XLA_TRX_CURRENCY_CODE VARCHAR2 16     Transaction Currency Code    
RECON_TRX_CURRENCY_CODE VARCHAR2 16     Transaction Currency Code (driven by xla trx currency code for AP and AR, Journal Transaction currency code for GL )    
XLA_LEDGER_CURRENCY_CODE VARCHAR2 16     Functional currency of the ledger.    
RECON_LEDGER_CURRENCY_CODE VARCHAR2 16     Ledger Currency Code (driven by xla ledger currency code for AP and AR, Journal Ledger currency code for GL )    
GL_SL_LINK_ID NUMBER 38 0   Audit trail from subledger application to general ledger.    
EVENT_TYPE_CODE VARCHAR2 32     Unique abbreviated name assigned to an event type and used for reporting or in reference to an option. DW_XLA_EVENT_TYPES_LKP_TL EVENT_TYPE_CODE
EVENT_CLASS_CODE VARCHAR2 32     Unique abbreviated name assigned to an event class and used for reporting or in reference to an option. DW_XLA_EVENT_CLASSES_LKP_TL EVENT_CLASS_CODE
GL_TRANSFER_STATUS_CODE VARCHAR2 32     General Ledger transfer status code. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=GL_TRANSFER_STATUS. DW_CODE_VALUES_LKP_TL CODE
GL_TRANSFER_DATE DATE       Date when journal entry is transferred to general ledger. DW_FISCAL_DAY_D FISCAL_DAY_DATE
XLA_ACCOUNTING_DATE DATE       SLA Accounting date. DW_FISCAL_DAY_D FISCAL_DAY_DATE
XLA_CREATED_BY_USER_ID VARCHAR2 128     Who column: indicates the user who created the row. DW_USER_D USERNAME
JOURNAL_BATCH_ID NUMBER       Journal entry batch defining column.    
GL_FISCAL_PERIOD_SET_NAME VARCHAR2 16     Accounting calendar name. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
GL_FISCAL_PERIOD_NAME VARCHAR2 16     Accounting period name. DW_FISCAL_DAY_D FISCAL_PERIOD_NAME
ACCT_PERIOD_START_DATE DATE       Accounting period start date. DW_FISCAL_DAY_D FISCAL_DAY_DATE
ACCT_PERIOD_END_DATE DATE       Accounting period end date. DW_FISCAL_DAY_D FISCAL_DAY_DATE
JOURNAL_BATCH_NAME VARCHAR2 128     User-defined journal batch name.    
JOURNAL_HEADER_NAME VARCHAR2 128     User-entered journal header name.    
JOURNAL_HEADER_DESCRIPTION VARCHAR2 256     User-entered journal header description.    
JOURNAL_POSTED_DATE DATE       Date when journal entry header was posted. DW_FISCAL_DAY_D FISCAL_DAY_DATE
JOURNAL_CATEGORY VARCHAR2 32     Journal category code. Journal entry is assigned a journal entry category to identify its purpose. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=JOURNAL_CATEGORY. DW_CODE_VALUES_LKP_TL CODE
JOURNAL_SOURCE VARCHAR2 32     Journal source. Journal entry is assigned a source name to indicate how it was created. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=GL_JOURNAL_SOURCE. DW_CODE_VALUES_LKP_TL CODE
JOURNAL_LINE_DESCRIPTION VARCHAR2 256     User-entered journal line description.    
JOURNAL_LINE_STATUS VARCHAR2 16     Journal entry line status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=GL_JOURNAL_STATUS. Possible values are U or P. DW_CODE_VALUES_LKP_TL CODE
DEBIT_CREDIT_IND VARCHAR2 32     Indicates debit or credit    
TRANSACTION_CURRENCY_AMOUNT BIGDECIMAL   10   Journal Amount in transaction currency.    
TRANSACTION_CURRENCY_CODE VARCHAR2 16     Journal Transaction currency code.    
LEDGER_CURRENCY_AMOUNT BIGDECIMAL   10   Journal Amount in ledger currency.    
LEDGER_CURRENCY_CODE VARCHAR2 16     Journal Ledger currency code.    
CURRENCY_CONVERSION_DATE DATE       Journal Currency conversion date.    
JOURNAL_REVERSAL_STATUS VARCHAR2 16     Reversed journal entry status code.Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=JE_REVERSAL_STATUS. DW_CODE_VALUES_LKP_TL CODE
JOURNAL_HEADER_CREATED_BY_ID VARCHAR2 128     Journal header created by user identifier DW_USER_D USERNAME
JOURNAL_LINE_CREATED_BY_ID VARCHAR2 128     Journal line created by user identifier DW_USER_D USERNAME
JOURNAL_APPROVAL_STATUS_CODE VARCHAR2 16     Journal entry batch approval status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=JE_BATCH_APPROVAL_STATUS. Possible values are V,R,I,A,J,Z. DW_CODE_VALUES_LKP_TL CODE
JOURNAL_APPROVED_BY VARCHAR2 128     Defining column of the employee who submitted the journal batch for approval. DW_USER_D USERNAME
JOURNAL_BATCH_DESCRIPTION VARCHAR2 256     Journal entry batch description.    
JOURNAL_HEADER_CREATION_DATE TIMESTAMP       Date and time of the creation of the journal header row    
TRANSLATED_FLAG VARCHAR2 16     Indicates currency translation.    
CURRENCY_TYPE VARCHAR2 64     Currency type.    
TRXN_CRNC_PRD_NET_ACTIVITY NUMBER       Accounting period net balance.    
TRXN_CRNC_PRD_NET_ACTIVITY_DR NUMBER       Accounting period net credit.    
TRXN_CRNC_PRD_NET_ACTIVITY_CR NUMBER       Accounting period net debit.    
LDGR_CRNC_PRD_NET_ACTIVITY NUMBER       Accounting period net balance in ledger currency.    
LDGR_CRNC_PRD_NET_ACTIVITY_DR NUMBER       Accounting period net credit in ledger currency.    
LDGR_CRNC_PRD_NET_ACTIVITY_CR NUMBER       Accounting period net debit in ledger currency.    
DELTA_FLAG VARCHAR2 16     Delta flag to identify if the records exist in Distribution link table or if it exists only in xla_ae_lines.    
EVENT_ID NUMBER 38 0   Identifier of the categorization of accounting events that is unique within an application and event class    
ACCOUNTING_ENTRY_STATUS_CODE VARCHAR2 32     Status code of the accounting entry    
JGZZ_RECON_REF VARCHAR2 256     Reconciliation reference.    
RECON_BU_ID NUMBER 38 0   Common across all pillars - business unit organization identifier. DW_INTERNAL_ORG_D ORGANIZATION_ID
RECON_XLA_TRANSACTION_AMOUNT BIGDECIMAL   10   Recon Column to equalize distribution and line amounts in trx currency    
RECON_XLA_LEDGER_AMOUNT BIGDECIMAL   10   Recon Column to equalize distribution and line amounts in ledger currency    
RECON_XLA_ENTERED_DR_AMOUNT BIGDECIMAL   10   Unrounded entered debit amount for the journal line/dist line.    
RECON_XLA_ENTERED_CR_AMOUNT BIGDECIMAL   10   Unrounded entered credit amount for the journal line/dist line.    
RECON_XLA_ACCOUNTED_DR_AMOUNT BIGDECIMAL   10   Unrounded accounted debit amount for the journal line/dist line.    
RECON_XLA_ACCOUNTED_CR_AMOUNT BIGDECIMAL   10   Unrounded accounted credit amount for the journal line/dist line.    
RELATIONSHIP_TYPE_CODE VARCHAR2 32     Relationship level between source and target ledger.    
JOURNAL_LINE_ENTERED_DR BIGDECIMAL   10   Journal entry line debit amount in entered currency.    
JOURNAL_LINE_ENTERED_CR BIGDECIMAL   10   Journal entry line credit amount in entered currency.    
JOURNAL_LINE_ACCOUNTED_DR BIGDECIMAL   10   Journal entry line debit amount in base currency.    
JOURNAL_LINE_ACCOUNTED_CR BIGDECIMAL   10   Journal entry line credit amount in base currency.    
XLA_LINE_CREATION_DATE TIMESTAMP       XLA line creation date    

Copyright © 2019, 2024, Oracle and/or its affiliates.