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

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

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     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 NUMBER       Unrounded entered amount    
XLA_LEDGER_AMOUNT NUMBER       Unrounded accounted amount    
XLA_ENTERED_DR_AMOUNT NUMBER       Unrounded entered debit amount for the journal line.    
XLA_ENTERED_CR_AMOUNT NUMBER       Unrounded entered credit amount for the journal line.    
XLA_ACCOUNTED_DR_AMOUNT NUMBER       Unrounded accounted debit for journal entry line.    
XLA_ACCOUNTED_CR_AMOUNT NUMBER       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 NUMBER       XLA Line Amount in transaction Currency    
XLA_LINE_ENTERED_DR_AMOUNT NUMBER       Unrounded entered debit amount for the journal line.    
XLA_LINE_ENTERED_CR_AMOUNT NUMBER       Unrounded entered credit amount for the journal line.    
XLA_LINE_LEDGER_AMOUNT NUMBER       XLA Line Amount in Ledger Currency    
XLA_LINE_ACCOUNTED_DR_AMOUNT NUMBER       Unrounded accounted debit amount of the journal entry line.    
XLA_LINE_ACCOUNTED_CR_AMOUNT NUMBER       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 NUMBER       Journal Amount in transaction currency.    
TRANSACTION_CURRENCY_CODE VARCHAR2 16     Journal Transaction currency code.    
LEDGER_CURRENCY_AMOUNT NUMBER       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 NUMBER       Recon Column to equalize distribution and line amounts in trx currency    
RECON_XLA_LEDGER_AMOUNT NUMBER       Recon Column to equalize distribution and line amounts in ledger currency    
RECON_XLA_ENTERED_DR_AMOUNT NUMBER       Unrounded entered debit amount for the journal line/dist line.    
RECON_XLA_ENTERED_CR_AMOUNT NUMBER       Unrounded entered credit amount for the journal line/dist line.    
RECON_XLA_ACCOUNTED_DR_AMOUNT NUMBER       Unrounded accounted debit amount for the journal line/dist line.    
RECON_XLA_ACCOUNTED_CR_AMOUNT NUMBER       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 NUMBER       Journal entry line debit amount in entered currency.    
JOURNAL_LINE_ENTERED_CR NUMBER       Journal entry line credit amount in entered currency.    
JOURNAL_LINE_ACCOUNTED_DR NUMBER       Journal entry line debit amount in base currency.    
JOURNAL_LINE_ACCOUNTED_CR NUMBER       Journal entry line credit amount in base currency.