This is the reconciliation table with AP facts, AR facts,XLA details, Journal details and GL balance details.
Module: Subledger Accounting
APPLICATION_ID, PARENT_STRIPE, AE_LINE_NUM, SOURCE_DISTRIBUTION_ID_NUM_1, JOURNAL_HEADER_ID, JOURNAL_LINE_NUM, AE_HEADER_ID, TEMP_LINE_NUM, REF_AE_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 | 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. |
Copyright © 2019, 2023, Oracle and/or its affiliates.