# DW_AP_SLA_PAYMENTS_ALL_CA

This table contains Aggregate level of Payables payment distribution transactions with expanded filter and 4 new metrics.This table supports the post SLA account details coming from the subledger accounting module.

## Details

Module: Payables

## Key Columns

XLA_LEDGER_ID, FISCAL_PERIOD_NAME, INVOICE_PAYMENT_ID, XLA_TRANSACTION_CURRENCY_CODE, TRANSACTION_TYPE

## Columns

Columns
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 |  |  | 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. |  |
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_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 | AP_INVOICE_TYPE_LKP_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_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_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_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_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_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
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
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_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_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
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
PAYABLES_CODE_COMB_ID | NUMBER | 38 | 0 |  | Payables liability account identifier. | DW_GL_CODE_COMBINATION_D | CODE_COMBINATION_ID
BANK_ACCOUNT_ID | NUMBER | 38 | 0 |  | Bank account identifier. | DW_BANK_ACCOUNT_D | BANK_ACCOUNT_ID
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
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. |  |
INVOICE_PAYMENT_AMOUNT | NUMBER |  |  |  | Payment amount that is paid. |  |
INV_VOUCHER_NUM | VARCHAR2 | 64 |  |  | Voucher number - validated (Sequential Numbering enabled) or non-validated (Sequential Numbering not enabled) |  |
INV_CREATION_DATE_FISCAL_PERIOD_NAME | VARCHAR2 | 64 |  |  | Accounting Period Name based on Invoice creation date |  |
INV_SCH_DATE_FISCAL_PERIOD_NAME | VARCHAR2 | 64 |  |  | Accounting Period Name based on Invoice schedule due date |  |
INVOICED_ON_DATE_FISCAL_PERIOD_NAME | VARCHAR2 | 64 |  |  | Accounting Period Name based on Invoiced on date |  |
CHK_DATE_FISCAL_PERIOD_NAME | VARCHAR2 | 64 |  |  | Accounting Period Name based on Payment Check date |  |
DISCOUNT_TAKEN_AMT_TC | NUMBER |  |  |  | Discount taken from payment for transactional currency. |  |
DISCOUNT_TAKEN_AMT_LC | NUMBER |  |  |  | Discount taken from payment for ledger currency. |  |
DISCOUNT_TAKEN_AMT_GC | NUMBER |  |  |  | Discount taken from payment for global currency. |  |
INTEREST_PENALTIES_PAID_AMT_TC | NUMBER |  |  |  | Interest Paid for Penalties for transactional currency. |  |
INTEREST_PENALTIES_PAID_AMT_LC | NUMBER |  |  |  | Interest Paid for Penalties for ledger currency. |  |
INTEREST_PENALTIES_PAID_AMT_GC | NUMBER |  |  |  | Interest Paid for Penalties for global currency. |  |
DISC_TAKEN_EXCH_GAIN_LOSS_AMT_LC | NUMBER |  |  |  | Discount taken exchange gain or loss amount for ledger currency. |  |
DISC_TAKEN_EXCH_GAIN_LOSS_AMT_GC | NUMBER |  |  |  | Discount taken exchange gain or loss amount for global currency. |  |
PMT_EXCH_GAIN_LOSS_AMT_LC | NUMBER |  |  |  | Payment exchange gain or loss amount for ledger currency. |  |
PMT_EXCH_GAIN_LOSS_AMT_GC | NUMBER |  |  |  | Payment exchange gain or loss amount for global currency. |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.