# DW_AP_PAYMENTS_CF

This table contains details of Payables invoice payment transactions covering both accounted and unaccounted payments data

## Details

Module: Payables

## Key Columns

INVOICE_SCHEDULE_NUMBER, INVOICE_PAYMENT_ID, INVOICE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
INVOICE_ID | NUMBER | 38 | 0 | True | Unique invoice identifier that identifies the invoice to which the payment belongs. |  |
INVOICE_PAYMENT_ID | NUMBER | 38 | 0 | True | Invoice payment identifier. |  |
INVOICE_SCHEDULE_NUMBER | NUMBER | 38 | 0 | True | Number identifying a payment. |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. Source record identifier - combination of INVOICE_ID, INVOICE_PAYMENT_ID and INVOICE_SCHEDULE_NUMBER. |  |
INV_SCH_ID | VARCHAR2 | 256 |  |  | Invoice Schedule identifier |  |
CHECK_ID | NUMBER | 38 | 0 |  | Unique Identifier maintained for every payment made. |  |
CHECK_NUMBER | NUMBER | 38 | 0 |  | Check number printed on physical check. |  |
INVOICE_NUMBER | VARCHAR2 | 64 |  |  | Invoice number. |  |
PAYMENT_LEDGER_ID | NUMBER | 38 | 0 |  | Ledger identifier of the payment. | DW_LEDGER_D | LEDGER_ID
PAYABLES_PAYMENTS_BU_ID | NUMBER | 38 | 0 |  | Payables payments business unit identifier. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
PAYMENTS_THIRD_PARTY_ID | NUMBER | 38 | 0 |  | Payments Third party supplier identifier | DW_PARTY_D | SUPPLIER_ID
CHECKS_THIRD_PARTY_ID | NUMBER | 38 | 0 |  | Checks Third party supplier identifier | DW_PARTY_D | SUPPLIER_ID
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
BANK_ACCOUNT_ID | NUMBER | 38 | 0 |  | Bank account identifier. | DW_BANK_ACCOUNT_D | BANK_ACCOUNT_ID
CHECK_PAYMENT_ID | NUMBER | 38 | 0 |  | Oracle Payments payment identifier | DW_IBY_PAYMENTS_ALL_D | PAYMENT_ID
CHECK_CE_BANK_ACCT_USE_ID | NUMBER | 38 | 0 |  | Identifier of internal bank account used. |  |
CHECK_PAYMENT_DOCUMENT_ID | NUMBER | 38 | 0 |  | Identifier of payment document used to make payment. | DW_CE_PAYMENT_DOCUMENTS_D | PAYMENT_DOCUMENT_ID
CHECK_PAYMENT_PROFILE_ID | NUMBER | 38 | 0 |  | Payment process profile identifier | DW_IBY_ACCT_PMT_PROFILES_TL | PAYMENT_PROFILE_ID
CREATED_BY_USER_ID | VARCHAR2 | 64 |  |  | Indicates the user who created the row. | DW_USER_D | USERNAME
UPDATED_BY_USER_ID | VARCHAR2 | 64 |  |  | Indicates the user who last updated the row. | DW_USER_D | USERNAME
CHECK_CREATED_BY_USER_ID | VARCHAR2 | 64 |  |  | Indicates the user who created the check. | DW_USER_D | USERNAME
CHECK_UPDATED_BY_USER_ID | VARCHAR2 | 64 |  |  | Indicates the user who last updated the check. | DW_USER_D | USERNAME
INVOICE_CREATED_BY_USER_ID | VARCHAR2 | 64 |  |  | User who created the invoice. | DW_USER_D | USERNAME
INVOICE_UPDATED_BY_USER_ID | VARCHAR2 | 64 |  |  | User who updated the invoice. | DW_USER_D | USERNAME
ACCTS_PAY_CODE_COMBINATION_ID | NUMBER | 38 | 0 |  | Accounting Flexfield identifier for accounts payable liability account | DW_GL_CODE_COMBINATION_D | CODE_COMBINATION_ID
PAYMENT_TERMS_ID | NUMBER | 38 | 0 |  | Payment terms identifier. | DW_AP_TERMS_D | PAYMENT_TERMS_ID
INVOICE_PAYABLES_BU_ID | NUMBER | 38 | 0 |  | Payables invoicing business unit identifier. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
INVOICE_LEDGER_ID | NUMBER | 38 | 0 |  | Ledger identifier of the invoice. | DW_LEDGER_D | LEDGER_ID
INVOICE_LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Legal entity identifier. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID
INVOICE_THIRD_PARTY_ID | NUMBER | 38 | 0 |  | Third party payee identifier. | DW_PARTY_D | SUPPLIER_ID
INVOICE_ACCTS_PAY_CODE_COMBINATION_ID | NUMBER | 38 | 0 |  | Payables liability account identifier. | DW_GL_CODE_COMBINATION_D | CODE_COMBINATION_ID
INVOICE_BATCH_ID | NUMBER | 38 | 0 |  | Unique invoice group identifier. |  |
INVOICE_PO_HEADER_ID | NUMBER | 38 | 0 |  | PO Header identifier. |  |
INVOICE_DESCRIPTION | VARCHAR2 | 256 |  |  | Invoice description. |  |
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_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_VALIDATION_STATUS_CODE | VARCHAR2 | 32 |  |  | 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_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_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
INVOICE_ACCOUNTING_DATE | DATE |  |  |  | Date when invoice was accounted |  |
INVOICE_CANCELLED_DATE | DATE |  |  |  | Date when the invoice was canceled. |  |
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_INTER_COMPANY_FLAG | VARCHAR2 | 16 |  |  | Intercompany flag added to incorporate FUN team's intercompany feature. | DW_YESNO_LKP_TL | YESNO_LKP_CODE
INVOICE_CREATION_DATE | TIMESTAMP |  |  |  | Invoice Creation Date. |  |
INVOICE_CREATION_DATE_1 | DATE |  |  |  | Invoice creation date. |  |
INVOICE_LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Invoice Updated Date. |  |
INVOICE_VOUCHER_NUMBER | NUMBER | 38 | 0 |  | Voucher number (Sequential Numbering) for invoice |  |
INV_VOUCHER_NUM | VARCHAR2 | 64 |  |  | Voucher number - validated (Sequential Numbering enabled) or non-validated (Sequential Numbering not enabled) |  |
PAYMENT_REASON_COMMENTS | VARCHAR2 | 256 |  |  | Reason for payment. |  |
INVOICE_GROUP | VARCHAR2 | 64 |  |  | Invoice Group or Invoice batch name |  |
INVOICE_SCHEDULE_DUE_DATE | DATE |  |  |  | Invoice schedule due date. |  |
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. |  |
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_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
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
REVERSAL_INV_PMT_ID | NUMBER | 38 | 0 |  | Identifier for invoice payment reversed through current invoice payment |  |
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
ACCOUNTING_EVENT_ID | NUMBER | 38 | 0 |  | Accounting event identifier. Refers to the accounting event that accounted for the distribution |  |
ACCOUNTING_DATE | DATE |  |  |  | Date when the payment is to be accounted. |  |
PAYMENT_METHOD_CODE | VARCHAR2 | 32 |  |  | Payment method used to make payment. | DW_AP_PAYMENT_METHOD_LKP_TL | AP_PAYMENT_METHOD_LKP_CODE
PAYMENT_STATUS_CODE | VARCHAR2 | 32 |  |  | Status of payment (for example, NEGOTIABLE, SET UP, SPOILED) | DW_AP_PAYMENT_STATUS_LKP_TL | AP_PAYMENT_STATUS_LKP_CODE
PAYMENT_CREATION_DATE | TIMESTAMP |  |  |  | Indicates the date and time of the creation of the row. |  |
CHECK_DATE | DATE |  |  |  | Date on which payment is made and mentioned on payment document. |  |
MAX_CHECK_DATE | DATE |  |  |  | Max check date of non-voided payments for all INVOICE_SCHEDULE_STATUS_CODE = 'Y' |  |
CHECK_CLEARED_DATE | DATE |  |  |  | Date when payment is cleared in cash management. |  |
CHECK_RELEASED_DATE | DATE |  |  |  | Date and time user released stop payment |  |
CHECK_STOPPED_DATE | DATE |  |  |  | Date and time user recorded stop payment |  |
CHECK_MATURITY_EXCHANGE_DATE | DATE |  |  |  | Date maturity exchange rate is effective, usually the maturity date for the payment |  |
CHECK_VOID_DATE | DATE |  |  |  | Date on which payment is voided. |  |
CHECK_FUTURE_PAY_DUE_DATE | DATE |  |  |  | Negotiable date for future dated payment |  |
CHECK_VOUCHER_NUM | NUMBER | 38 | 0 |  | Check Voucher number associated with payment made. |  |
CHECK_CHECKRUN_NAME | VARCHAR2 | 256 |  |  | Name of payment batch or quick payment identifier. |  |
CHECK_RECON_FLAG | VARCHAR2 | 16 |  |  | Recon flag is set to 'Y' on Clearing and set to 'N' on unclearing apis called by CE | DW_YN_LKP_TL | YN_LKP_CODE
REVERSAL_FLAG | VARCHAR2 | 16 |  |  | Flag that indicates whether current invoice payment is a reversal of another invoice payment | DW_YN_LKP_TL | YN_LKP_CODE
PAYMENT_CANCELLED_FLAG | VARCHAR2 | 16 |  |  | Indicates a cancelled payment. | DW_YESNO_LKP_TL | YESNO_LKP_CODE
PAYMENT_ACCOUNTING_FLAG | VARCHAR2 | 16 |  |  | Flag that indicates if the payment has been accounted (Y or N) | DW_YN_LKP_TL | YN_LKP_CODE
PAYMENT_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Payment currency code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
PAYMENT_AMOUNT | NUMBER |  |  |  | Payment amount that is paid. |  |
DISCOUNT_TAKEN_AMOUNT | NUMBER |  |  |  | Discount amount on payment. |  |
DISCOUNT_LOST_AMOUNT | NUMBER |  |  |  | Discount amount lost when the invoice payment is not made in time to avail discount. |  |
LEDGER_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Ledger currency code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
PAYMENT_EXCHANGE_DATE | DATE |  |  |  | Date when a conversion rate is used to convert an amount into another currency for payment. |  |
PAYMENT_EXCHANGE_RATE | NUMBER |  |  |  | Ratio at which the principal unit of one currency is converted into another currency for payment. |  |
LEDGER_PAYMENT_AMOUNT | NUMBER |  |  |  | Payment amount in ledger currency at payment's exchange rate, only used for foreign currency invoice payments |  |
LEDGER_PAYMENT_AMOUNT_INV_EXCH_RT | NUMBER |  |  |  | Payment amount in ledger currency at invoice's exchange rate, only used for foreign currency invoice payments |  |
GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Global currency code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
GLOBAL_CURRENCY_EXCH_RATE | NUMBER |  |  |  | Global currency conversion rate. |  |
GLOBAL_PAYMENT_AMOUNT | NUMBER |  |  |  | Payment Amount in Global currency. |  |
INVOICE_EXCHANGE_DATE | DATE |  |  |  | Date from Invoice header when a conversion rate is used to convert an amount into another currency for payment. |  |
INVOICE_EXCHANGE_RATE | NUMBER |  |  |  | Header Exchange rate - Ratio at which the principal unit of one currency is converted into another currency for an invoice. |  |
INVOICE_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Invoice currency code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
INV_CURR_PAYMENT_AMOUNT | NUMBER |  |  |  | The amount to be paid in invoice currency. |  |
INV_CURR_DISCOUNT_TAKEN_AMOUNT | NUMBER |  |  |  | The amount of discount taken in invoice currency. |  |
INV_CURR_DISCOUNT_LOST_AMOUNT | NUMBER |  |  |  | The amount of discount lost in invoice currency. |  |
INV_CURR_DISCOUNT_AVAILABLE_AMOUNT | NUMBER |  |  |  | Discount amount available at first discount date in invoice currency. |  |
INV_CURR_SECOND_DISC_AVAILABLE_AMOUNT | NUMBER |  |  |  | Discount amount available at second discount date in invoice currency. |  |
INV_CURR_THIRD_DISC_AVAILABLE_AMOUNT | NUMBER |  |  |  | Discount amount available at third discount date in invoice currency. |  |
INV_CURR_DISCOUNT_REMAINING_AMOUNT | NUMBER |  |  |  | The part of the discount amount that is still available to use if the invoice is paid before the discount due date. |  |
INV_TO_PMT_X_CURR_RATE | NUMBER |  |  |  | The conversion rate used to convert the invoice currency to payment currency. |  |
FISCAL_PERIOD_NAME | VARCHAR2 | 64 |  |  | Period name associated with the payment. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | Name of the accounting calendar. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | Accounting period type. Examples are Weekly, Monthly, Quarterly. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
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 |  |
MAX_CHK_DATE_FISCAL_PERIOD_NAME | VARCHAR2 | 64 |  |  | Max Accounting Period Name based on Payment Check date |  |

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