This is the reconciliation table with AP facts, AR facts,XLA details, Journal details and GL balance details.
Module: Subledger Accounting
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
| 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.