This table contains details of Payables payment distribution transactions.This table supports the post SLA account details coming from the subledger accounting module.
Module: Payables
REVERSED_PAY_HIST_DIST_ID, INVOICE_ID, INVOICE_DISTRIBUTION_ID, PAYMENT_CANCELLED_FLAG, INVOICE_PAYMENT_ID, TEMP_LINE_NUM, PAYMENT_HIST_DIST_ID, REF_AE_HEADER_ID, AE_HEADER_ID
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 | 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_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_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_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 | ||
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 | ||
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_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_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_CODE_VALUES_LKP_TL with CODE_TYPE=INVOICE PAYMENT STATUS. | ||||
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_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. | 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 | 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. |
Copyright © 2019, 2023, Oracle and/or its affiliates.