DW_AP_SLA_PAYMENTS_CF

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

Details

Module: Payables

Key Columns

PAYMENT_CANCELLED_FLAG, INVOICE_DISTRIBUTION_ID, REF_AE_HEADER_ID, INVOICE_ID, TEMP_LINE_NUM, PAYMENT_HIST_DIST_ID, AE_HEADER_ID, REVERSED_PAY_HIST_DIST_ID, INVOICE_PAYMENT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
INVOICE_ID NUMBER 38 0 True Invoice identifier.
INVOICE_PAYMENT_ID NUMBER 38 0 True Invoice payment identifier.
INVOICE_DISTRIBUTION_ID NUMBER 38 0 True Related invoice distribution.
PAYMENT_HIST_DIST_ID NUMBER 38 0 True Payment history distribution identifier.
REVERSED_PAY_HIST_DIST_ID NUMBER 38 0 True Reversed payment distribution accounting event identifier.
PAYMENT_CANCELLED_FLAG VARCHAR2 16 True Indicates a cancelled payment.
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 256 This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of invoice identifier, invoice payment identifier, related invoice distribution, payment history distribution identifier, reversed payment history distribution identifier,Reversed subledger journal entry header identifier,Intermediary line number generated by the accounting engine when the entries are in most detail form and Subledger journal entry identifier.
SUBLEDGER_FACT_LINKAGE_ID VARCHAR2 256 Subledger Fact Linkage Identifier
LINKAGE_ID NUMBER 38 0 Sub ledger linkage identifier.
INVOICE_NUMBER VARCHAR2 64 Invoice number.
INVOICE_SCHEDULE_NUMBER NUMBER 38 0 Invoice schedule number.
INVOICE_GROUP VARCHAR2 64 Invoice Group or Invoice batch name
CHECK_ID NUMBER 38 0 Check Identifier
CHECK_NUMBER NUMBER 38 0 Check number.
CHECK_VOID_DATE DATE Date when payment is voided
PURCHASE_ORDER_NUMBER VARCHAR2 32 Purchase order number.
PURCHASE_ORDER_LINE_NUMBER NUMBER Purchase order line number.
INVOICE_DESCRIPTION VARCHAR2 256 Invoice description.
PAYMENT_REASON_COMMENTS VARCHAR2 256 Reason for payment.
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
BANK_ACCOUNT_ID NUMBER 38 0 Bank account identifier. DW_BANK_ACCOUNT_D BANK_ACCOUNT_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
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
ACCOUNTING_DATE DATE Accounting date.
INVOICED_ON_DATE DATE Date when invoiced is created.
INVOICE_RECEIVED_DATE DATE Date when invoice is received.
INVOICE_SCHEDULE_DUE_DATE DATE Invoice schedule due date.
FIRST_DISCOUNT_DATE DATE Date when first discount is available.
SECOND_DISCOUNT_DATE DATE Date when second discount is available.
THIRD_DISCOUNT_DATE DATE Date when third discount is available.
PURCHASE_ORDER_DATE TIMESTAMP Purchase order creation date.
CHECK_DATE DATE Date when check was issued.
CHECK_CLEARED_DATE DATE Check cleared date.
PAYMENT_TERMS_ID NUMBER 38 0 Payment terms identifier. DW_AP_TERMS_D PAYMENT_TERMS_ID
PAYMENT_METHOD_CODE VARCHAR2 32 Payment method (Checks). Values are from the table DW_AP_PAYMENT_METHOD_LKP_TL with CODE_TYPE=AP_PAYMENT_METHOD_CODE. Possible values are Bills Payable, CHECK, EFT, FUTURE_PAY35, NETTING, WIRE, and so on. DW_AP_PAYMENT_METHOD_LKP_TL AP_PAYMENT_METHOD_LKP_CODE
INV_SCH_PAYMENT_METHOD_CODE VARCHAR2 32 Payment method (Invoice Schedules). Values are from the table DW_AP_PAYMENT_METHOD_LKP_TL with CODE_TYPE=AP_PAYMENT_METHOD_CODE. Possible values are Bills Payable, CHECK, EFT, FUTURE_PAY35, NETTING, WIRE, and so on. DW_AP_PAYMENT_METHOD_LKP_TL AP_PAYMENT_METHOD_LKP_CODE
PAYMENT_DISTRIBUTION_TYPE_CODE VARCHAR2 32 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
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 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_SCHEDULE_STATUS_CODE VARCHAR2 32 Invoice schedule status. Values are from the table DW_AP_INV_SCH_STATUS_LKP_TL with CODE_TYPE=INVOICE PAYMENT STATUS. DW_AP_INV_SCH_STATUS_LKP_TL AP_INV_SCH_STATUS_LKP_CODE
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_ACCOUNTING_STATUS_CODE VARCHAR2 32 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
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
INVOICE_CURRENCY_CODE VARCHAR2 16 Invoice currency code.
PAYMENT_CURRENCY_CODE VARCHAR2 16 Payment currency code.
INVOICE_CURRENCY_AMOUNT NUMBER Related invoice distribution amount in invoice currency.
PAYMENT_CURRENCY_AMOUNT NUMBER Payment distribution amount in payment currency.
DISCOUNT_TAKEN_INVOICE_AMOUNT NUMBER Discount taken amount in invoice currency.
DISCOUNT_TAKEN_PAYMENT_AMOUNT NUMBER Discount taken amount in payment currency.
DISCOUNT_LOST_INVOICE_AMOUNT NUMBER Lost discount amount in invoice currency.
DISCOUNT_LOST_PAYMENT_AMOUNT NUMBER Lost discount amount in payment currency.
GLOBAL_CURRENCY_CODE VARCHAR2 16 Global currency code.
GLOBAL_CURRENCY_EXCH_RATE BIGDECIMAL 10 Global currency conversion rate.
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 Invoice creation date.
INVOICE_CREATION_DATE_1 DATE Invoice creation date.
CHECK_CREATED_BY_USER_ID VARCHAR2 128 User who created the check. DW_USER_D USERNAME
CHECK_UPDATED_BY_USER_ID VARCHAR2 128 User who updated the check. 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
INVOICE_ACCOUNTING_DATE DATE Date when invoice was accounted
INVOICE_APPROVAL_STATUS_CODE VARCHAR2 64 Invoice approval status. Values are from the table DW_AP_INV_APPR_STATUS_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. DW_AP_INV_APPR_STATUS_LKP_TL AP_INV_APPR_STATUS_LKP_CODE
INVOICE_VALIDATION_STATUS_CODE VARCHAR2 16 Invoice validation status. Values are from the table DW_AP_INV_VAL_STATUS_LKP_TL with CODE_TYPE=AP_INVOICE_VALIDATION_STATUS_CODE. DW_AP_INV_VAL_STATUS_LKP_TL AP_INV_VAL_STATUS_LKP_CODE
INVOICE_PO_NUMBER VARCHAR2 32 PO number the invoice is matched to.
INVOICE_PAYMENT_STATUS_CODE VARCHAR2 16 Invoice payment status. Values are from the table DW_AP_INV_SCH_STATUS_LKP_TL with CODE_TYPE=INVOICE PAYMENT STATUS. DW_AP_INV_SCH_STATUS_LKP_TL AP_INV_SCH_STATUS_LKP_CODE
MAX_CHECK_DATE DATE Max check date of non-voided payments for all INVOICE_SCHEDULE_STATUS_CODE = 'Y'
INVOICE_VOUCHER_NUMBER NUMBER Voucher number (Sequential Numbering) for invoice
ACCOUNTING_EVENT_ID NUMBER 38 0 Identifier of the accounting event.
TRANSACTION_TYPE VARCHAR2 64 Transaction type - value can be PAYMENT MATURITY, PAYMENT CLEARING, or PAYMENT UNCLEARING
XLA_TRANSACTION_AMOUNT BIGDECIMAL 10 Unrounded entered debit amount for the journal line minus Unrounded entered credit amount for the journal line.
XLA_LEDGER_AMOUNT BIGDECIMAL 10 Unrounded accounted debit for journal entry line minus Unrounded accounted credit for journal entry line.
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_GLOBAL_AMOUNT BIGDECIMAL 10 Unrounded global debit amount for the journal line minus Unrounded global credit amount for the journal line.
XLA_GLOBAL_DR_AMOUNT BIGDECIMAL 10 Unrounded global debit amount for the journal line.
XLA_GLOBAL_CR_AMOUNT BIGDECIMAL 10 Unrounded global credit amount for the journal line.
XLA_MANUAL_OVERRIDE_FLAG VARCHAR2 32 Indicates a manual override. Values are from the table DW_YESNO_LKP_TL with CODE_TYPE=FA_YESNO. DW_YESNO_LKP_TL YESNO_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 Indicates whether the journal line rule is seeded.
AE_LINE_NUM NUMBER 38 0 Number that is associated with each subledger journal entry line.
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 Line level unrounded entered debit amount for the journal line minus Line level unrounded entered credit amount for the journal line.
XLA_LINE_ENTERED_DR_AMOUNT BIGDECIMAL 10 Line level unrounded entered debit amount for the journal line.
XLA_LINE_ENTERED_CR_AMOUNT BIGDECIMAL 10 Line level unrounded entered credit amount for the journal line.
XLA_LINE_LEDGER_AMOUNT BIGDECIMAL 10 Line level unrounded accounted debit amount of the journal entry line minus Line level unrounded accounted credit amount of the journal entry line.
XLA_LINE_ACCOUNTED_DR_AMOUNT BIGDECIMAL 10 Line level unrounded accounted debit amount of the journal entry line.
XLA_LINE_ACCOUNTED_CR_AMOUNT BIGDECIMAL 10 Line level unrounded accounted credit amount of the journal entry line.
XLA_LINE_GLOBAL_AMOUNT BIGDECIMAL 10 Line level unrounded global debit amount for the journal line minus Line level unrounded global credit amount for the journal line.
XLA_LINE_GLOBAL_DR_AMOUNT BIGDECIMAL 10 Line level unrounded global debit amount for the journal line.
XLA_LINE_GLOBAL_CR_AMOUNT BIGDECIMAL 10 Line level unrounded global credit amount for the journal 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_EVENT_ID NUMBER 38 0 Identifier of the categorization of accounting events that is unique within an application and event class.
XLA_TRANSACTION_CURRENCY_CODE VARCHAR2 16 Entered currency for the transaction data
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.
XDL_CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
INVOICE_PAYMENT_AMOUNT NUMBER Payment amount that is paid.
INVOICE_CANCELLED_DATE DATE Date when the invoice was canceled.
INVOICE_SCH_HOLD_STATUS_FLAG VARCHAR2 16 Flag that indicates if scheduled payment is on hold .Values are from the table DW_YESNO_LKP_TL with CODE_TYPE=FA_YESNO. DW_YESNO_LKP_TL YESNO_LKP_CODE
INV_VOUCHER_NUM VARCHAR2 64 Voucher number - validated (Sequential Numbering enabled) or non-validated (Sequential Numbering not enabled)