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
| 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 |