DW_AP_SLA_LIAB_PMT_CF

This table contains details of Payables payment distribution transactions and Payables liability distribution.This table supports the post SLA account details coming from the subledger accounting module.

Details

Module: Payables

Key Columns

REF_AE_HEADER_ID, INVOICE_ID, TEMP_LINE_NUM, AE_HEADER_ID, SOURCE_DISTRIBUTION_TYPE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SOURCE_DISTRIBUTION_TYPE VARCHAR2 32   True Classification of transaction source distribution.    
INVOICE_ID NUMBER 38 0 True Invoice identifier.    
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.    
AE_HEADER_ID NUMBER 38 0 True Subledger journal entry identifier.    
SOURCE_RECORD_ID VARCHAR2 512     Source record identifier. Value is derived from a combination of Invoice identifier, Reversed subledger journal entry header identifier, Intermediary line number generated by the accounting engine when the entries are in most detail form, Subledger journal entry identifier.    
LINKAGE_ID NUMBER 38 0   Sub ledger linkage identifier.    
INVOICE_NUMBER VARCHAR2 64     Invoice number.    
INVOICE_GROUP VARCHAR2 64     Invoice Group or Invoice batch name    
INVOICE_DESCRIPTION VARCHAR2 256     Invoice description.    
INVOICE_SCHEDULE_NUMBER NUMBER 38 0   Invoice schedule number.    
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
CHECKS_THIRD_PARTY_ID NUMBER 38 0   Third party payee identifier associated with check. DW_PARTY_D SUPPLIER_ID
PAYMENTS_THIRD_PARTY_ID NUMBER 38 0   Third party payee identifier associated with Payment. DW_PARTY_D SUPPLIER_ID
PAYABLES_BU_ID NUMBER 38 0   Payables invoicing business unit identifier. DW_INTERNAL_ORG_D ORGANIZATION_ID
PAYABLES_PAYMENTS_BU_ID NUMBER 38 0   Payables payments business unit identifier. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEGAL_ENTITY_ID NUMBER 38 0   Legal entity identifier. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
PAYABLES_CODE_COMB_ID NUMBER 38 0   Payables liability account identifier. DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
PAYMENT_TERMS_ID NUMBER 38 0   Payment terms identifier. DW_AP_TERMS_D PAYMENT_TERMS_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
INVOICED_ON_DATE DATE       Date when invoiced is created.    
INVOICE_RECEIVED_DATE DATE       Date when invoice is received.    
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
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. DW_CODE_VALUES_LKP_TL CODE
PREPAY_DIST_TYPE_CODE VARCHAR2 32     Type of prepayment application distribution.    
INVOICE_ACCOUNTING_STATUS_CODE VARCHAR2 32     Invoice distribution accounting status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_ACCOUNTING_STATUS. 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
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
PAYMENT_CANCELLED_FLAG VARCHAR2 16     Indicates a cancelled payment.    
INVOICE_CREATION_DATE TIMESTAMP       Invoice creation date.    
INVOICE_CREATION_DATE_1 DATE       Invoice creation date.    
INVOICE_ACCOUNTING_DATE DATE       Date when invoice was accounted    
INVOICE_APPROVAL_STATUS_CODE VARCHAR2 64     Invoice approval status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_WFAPPROVAL_STATUS. Possible values are INITIATED, MANUALLY APPROVED, NOT REQUIRED, REJECTED, REMOVED FROM APPROVAL, REQUIRED, WFAPPROVED, and so on.    
INVOICE_VALIDATION_STATUS_CODE VARCHAR2 16     Invoice validation status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_INVOICE_VALIDATION_STATUS_CODE.    
INVOICE_PAYMENT_STATUS_CODE VARCHAR2 16     Invoice payment status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=INVOICE PAYMENT STATUS.    
CHECK_ID NUMBER 38 0   Check Identifier    
CHECK_NUMBER NUMBER 38 0   Check number.    
CHECK_DATE DATE       Date when check was issued.    
CHECK_CLEARED_DATE DATE       Check cleared date.    
PAYMENT_METHOD_CODE VARCHAR2 32     Payment method (Checks). Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_PAYMENT_METHOD_CODE. Possible values are Bills Payable, CHECK, EFT, FUTURE_PAY35, NETTING, WIRE, and so on. DW_CODE_VALUES_LKP_TL CODE
INV_SCH_PAYMENT_METHOD_CODE VARCHAR2 32     Payment method (Invoice Schedules). Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_PAYMENT_METHOD_CODE. Possible values are Bills Payable, CHECK, EFT, FUTURE_PAY35, NETTING, WIRE, and so on. DW_CODE_VALUES_LKP_TL CODE
PAYMENT_DISTRIBUTION_TYPE_CODE VARCHAR2 32     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
INVOICE_SCHEDULE_STATUS_CODE VARCHAR2 32     Invoice schedule status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=INVOICE PAYMENT STATUS. DW_CODE_VALUES_LKP_TL CODE
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_ACCOUNTING_STATUS_CODE VARCHAR2 32     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
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
HEADER_CREATED_BY_USER_ID VARCHAR2 128     User who created the invoice. DW_USER_D USERNAME
HEADER_UPDATED_BY_USER_ID VARCHAR2 128     User who updated the invoice. DW_USER_D USERNAME
XLA_TRANSACTION_AMOUNT NUMBER       Unrounded entered debit amount for the journal line minus Unrounded entered credit amount for the journal line.    
XLA_LEDGER_AMOUNT NUMBER       Unrounded accounted debit for journal entry line minus Unrounded accounted credit for journal entry line.    
XLA_GLOBAL_AMOUNT NUMBER       Unrounded global debit amount for the journal line minus Unrounded global credit amount for the journal line.    
XLA_MANUAL_OVERRIDE_FLAG VARCHAR2 32     Indicates a manual override. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. DW_CODE_VALUES_LKP_TL CODE
AE_LINE_NUM NUMBER 38 0   Number that is associated with each subledger journal entry line.    
XLA_LEDGER_ID NUMBER 38 0   Self-contained accounting information set for single or multiple legal or management entities.    
XLA_LEDGER_CURRENCY_CODE VARCHAR2 16     Functional currency of the ledger.    
XLA_TRANSACTION_CURRENCY_CODE VARCHAR2 16     Entered currency for the transaction data    
GLOBAL_CURRENCY_CODE VARCHAR2 16     Global currency code.    
XLA_ACCOUNTING_DATE DATE       Date, referenced from Oracle Fusion General Ledger, used to determine the accounting period for transactions.    
FISCAL_PERIOD_NAME VARCHAR2 64     Accounting period name.    
FISCAL_YEAR_NUMBER NUMBER 38 0   Fiscal Year in YYYY format.    
FISCAL_QUARTER_NUMBER NUMBER 38 0   Fiscal quarter. Possible values are 1, 2, 3, and 4.    
AP_TRANSACTION_AMOUNT NUMBER            
AP_LEDGER_AMOUNT NUMBER            
AP_GLOBAL_AMOUNT NUMBER            
INVOICE_CURRENCY_CODE VARCHAR2 16     Invoice currency code.    
INVOICE_VOUCHER_NUMBER NUMBER       Voucher number (Sequential Numbering) for invoice    
PAYMENT_REASON_COMMENTS VARCHAR2 256     Payment reason.    
INVOICE_LINE_NUMBER NUMBER       Invoice line number.    
INVOICE_DISTRIBUTION_ID NUMBER 38 0   Invoice distribution identifier.    
DISTRIBUTION_LINE_NUMBER NUMBER 38 0   Distribution line number.    
RECEIVING_SHIPMENT_RECEIPT_NUM VARCHAR2 32     Shipment receipt number.    
RECEIVING_SHIPMENT_LINE_NUMBER NUMBER 38 0   Shipment line number.    
PAYMENT_CURRENCY_CODE VARCHAR2 16     Payment currency code.    
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
E_THIRD_PARTY_ID NUMBER 38 0   Equalised column for Third party payee identifier. DW_PARTY_D SUPPLIER_ID
E_CREATED_BY_USER_ID VARCHAR2 128     Equalised column for User who created the record. DW_USER_D USERNAME
E_LAST_UPDATED_BY_USER_ID VARCHAR2 128     Equalised column for User who updated the record.. DW_USER_D USERNAME