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

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

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_INSERT_LEDGER_CAT_LKP_TL with CODE_TYPE=GL_ASF_LEDGER_CATEGORY. Possible values are PRIMARY, SECONDARY, ALC, and so on. DW_INSERT_LEDGER_CAT_LKP_TL INSERT_LEDGER_CAT_LKP_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_AP_DISTRIBUTION_TYPE_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_AP_DISTRIBUTION_TYPE_LKP_TL with CODE_TYPE=PAY_DIST_TYPES. DW_AP_DISTRIBUTION_TYPE_LKP_TL AP_DISTRIBUTION_TYPE_LKP_CODE
AP_ACCOUNTING_STATUS_CODE VARCHAR2 32 Invoice distribution accounting status or Payment accounting status. Values are from the table DW_AP_ACCOUNTING_STATUS_LKP_TL with CODE_TYPE=AP_ACCOUNTING_STATUS. DW_AP_ACCOUNTING_STATUS_LKP_TL AP_ACCOUNTING_STATUS_LKP_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_AP_INVOICE_TYPE_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_AP_INVOICE_TYPE_LKP_TL AP_INVOICE_TYPE_LKP_CODE
INVOICE_SOURCE_CODE VARCHAR2 32 Invoice source. Values are from the table DW_AP_INVOICE_SOURCE_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_AP_INVOICE_SOURCE_LKP_TL AP_INVOICE_SOURCE_LKP_CODE
INVOICE_CANCELLED_FLAG VARCHAR2 32 Indicates a cancelled invoice. Values are from the table DW_YESNO_LKP_TL with CODE_TYPE=FA_YESNO. DW_YESNO_LKP_TL YESNO_LKP_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_YESNO_LKP_TL with CODE_TYPE=FA_YESNO. DW_YESNO_LKP_TL YESNO_LKP_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_AP_PAYMENT_STATUS_LKP_TL with CODE_TYPE=CHECK STATE. DW_AP_PAYMENT_STATUS_LKP_TL AP_PAYMENT_STATUS_LKP_CODE
PAYMENT_CANCELLED_FLAG VARCHAR2 16 Indicates a cancelled payment. Values are from the table DW_YESNO_LKP_TL with CODE_TYPE=FA_YESNO. DW_YESNO_LKP_TL YESNO_LKP_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_AR_TRANSACTION_CLASS_LKP_TL with CODE_TYPE=AR_TRANSACTION_TYPE_CODE. Possible values are INV, CM, DM, or CB. DW_AR_TRANSACTION_CLASS_LKP_TL AR_TRANSACTION_CLASS_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_AR_RECEIPT_TYPE_LKP_TL with CODE_TYPE=PAYMENT_CATEGORY_TYPE. Possible values are CASH for Standard ,MISC for Miscellaneous. DW_AR_RECEIPT_TYPE_LKP_TL AR_RECEIPT_TYPE_LKP_CODE
RECEIPT_STATUS_CODE VARCHAR2 32 Receipt status. Values are from the table DW_RCPT_CREATION_STATUS_LKP_TL with CODE_TYPE=RECEIPT_CREATION_STATUS. Possible values are APPROVED, CLEARED, CONFIRMED, REMITTED, REVERSED, RISK_ELIMINATED DW_RCPT_CREATION_STATUS_LKP_TL RECEIPT_CREATION_STATUS_CODE
RECEIPT_APPLN_STATUS_CODE VARCHAR2 32 Receipt application status. Values are from the table DW_AR_RECEIPT_STATUS_LKP_TL with CODE_TYPE=RECEIPT_STATUS. Possible values are NSF forNonsufficient funds, APP for Applied, STOP for Stopped payment and so on. DW_AR_RECEIPT_STATUS_LKP_TL RECEIPT_STATUS_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_ADJUSTMENT_STATUS_LKP_TL with CODE_TYPE=ADJUSTMENT_STATUS. Possible values are A, R, and so on. DW_ADJUSTMENT_STATUS_LKP_TL CODE
CREDITMEMO_APPL_STATUS_CODE VARCHAR2 32 Credit memo application status. Values are from the table DW_AR_RECEIPT_STATUS_LKP_TL with CODE_TYPE=RECEIPT_STATUS or AR_APPLICATION_STATUS. Possible values are APP, ACTIVITY, and so on. DW_AR_RECEIPT_STATUS_LKP_TL RECEIPT_STATUS_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_YN_LKP_TL with CODE_TYPE='YES/NO'. DW_YN_LKP_TL YN_LKP_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_GL_TRANSFER_STATUS_LKP_TL with CODE_TYPE=GL_TRANSFER_STATUS. DW_GL_TRANSFER_STATUS_LKP_TL GL_TRANSFER_STATUS_LKP_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_JOURNAL_CATEGORY_LKP_TL with CODE_TYPE=JOURNAL_CATEGORY. DW_JOURNAL_CATEGORY_LKP_TL JOURNAL_CATEGORY_LKP_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_JOURNAL_SOURCE_LKP_TL with CODE_TYPE=GL_JOURNAL_SOURCE. DW_JOURNAL_SOURCE_LKP_TL JOURNAL_SOURCE_LKP_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_JOURNAL_STATUS_LKP_TL with CODE_TYPE=GL_JOURNAL_STATUS. Possible values are U or P. DW_JOURNAL_STATUS_LKP_TL GL_JOURNAL_STATUS_LKP_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_JOURNAL_REV_STAT_LKP_TL with CODE_TYPE=JE_REVERSAL_STATUS. DW_JOURNAL_REV_STAT_LKP_TL GL_JOURNAL_REV_STAT_LKP_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_GL_BATCH_APP_STATUS_LKP_TL with CODE_TYPE=JE_BATCH_APPROVAL_STATUS. Possible values are V,R,I,A,J,Z. DW_GL_BATCH_APP_STATUS_LKP_TL GL_BATCH_APP_STATUS_LKP_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