This table contains Aggrigate level of Payables payment distribution transactions.This table supports the post SLA account details coming from the subledger accounting module.
Module: Payables
FISCAL_PERIOD_NAME, TRANSACTION_TYPE, INVOICE_PAYMENT_ID, XLA_LEDGER_ID, XLA_TRANSACTION_CURRENCY_CODE
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
INVOICE_PAYMENT_ID | NUMBER | 38 | 0 | True | Invoice payment identifier. | ||
XLA_LEDGER_ID | NUMBER | 38 | 0 | True | Self-contained accounting information set for single or multiple legal or management entities. | ||
XLA_TRANSACTION_CURRENCY_CODE | VARCHAR2 | 16 | True | Entered currency for the transaction data | |||
FISCAL_PERIOD_NAME | VARCHAR2 | 64 | True | Accounting period name. | |||
TRANSACTION_TYPE | VARCHAR2 | 64 | True | Transaction type - value can be PAYMENT MATURITY, PAYMENT CLEARING, or PAYMENT UNCLEARING | |||
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. | ||||
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 | |
XLA_LEDGER_CURRENCY_CODE | VARCHAR2 | 16 | Functional currency of the ledger. | ||||
INVOICE_CURRENCY_CODE | VARCHAR2 | 16 | Invoice currency code. | ||||
PAYMENT_CURRENCY_CODE | VARCHAR2 | 16 | Payment currency code. | ||||
GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 | Global currency code. | ||||
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 | |
CHECKS_THIRD_PARTY_ID | NUMBER | 38 | 0 | Third party payee identifier associated with check. | DW_PARTY_D | SUPPLIER_ID | |
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 | ||
INVOICE_NUMBER | VARCHAR2 | 64 | Invoice number. | ||||
INVOICE_ID | NUMBER | 38 | 0 | Invoice identifier. | |||
INVOICED_ON_DATE | DATE | Date when invoiced is created. | |||||
INVOICE_GROUP | VARCHAR2 | 64 | Invoice Group or Invoice batch name | ||||
INVOICE_DESCRIPTION | VARCHAR2 | 256 | Invoice description. | ||||
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 | ||
INVOICE_RECEIVED_DATE | DATE | Date when invoice is received. | |||||
FIRST_DISCOUNT_DATE | DATE | Date when first discount is available. | |||||
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_VOUCHER_NUMBER | NUMBER | Voucher number (Sequential Numbering) for invoice | |||||
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_SCHEDULE_NUMBER | NUMBER | 38 | 0 | Invoice schedule number. | |||
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 | ||
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 | ||
INVOICE_SCHEDULE_DUE_DATE | DATE | Invoice schedule due date. | |||||
MAX_CHECK_DATE | DATE | Max check date of non-voided payments for all INVOICE_SCHEDULE_STATUS_CODE = 'Y' | |||||
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. | |||||
CHECK_VOID_DATE | DATE | Date when payment is voided | |||||
PAYMENT_REASON_COMMENTS | VARCHAR2 | 256 | Reason for payment. | ||||
PAYMENT_CANCELLED_FLAG | VARCHAR2 | 16 | Indicates a cancelled payment. | ||||
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 | ||
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 | ||
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 | ||
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_GLOBAL_AMOUNT | BIGDECIMAL | 10 | Unrounded global debit amount for the journal line minus Unrounded global credit amount for the journal line. |
Copyright © 2019, 2023, Oracle and/or its affiliates.