# DW_AP_SLA_PAYMENTS_CF

This table contains details of Payables payment distribution transactions.This table supports the post SLA account details coming from the subledger accounting module.

## Details

Module: Payables

## Key Columns

REF_AE_HEADER_ID, PAYMENT_HIST_DIST_ID, INVOICE_ID, TEMP_LINE_NUM, INVOICE_DISTRIBUTION_ID, AE_HEADER_ID, INVOICE_PAYMENT_ID, REVERSED_PAY_HIST_DIST_ID, PAYMENT_CANCELLED_FLAG

## Columns

Columns
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 |  |  | 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. |  |
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_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
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
PAYMENT_DISTRIBUTION_TYPE_CODE | VARCHAR2 | 32 |  |  | Payment distribution type. Values are from the table DW_AP_DISTRIBUTION_TYPE_LKP_TL with CODE_TYPE=PAY_DIST_TYPES. | DW_AP_DISTRIBUTION_TYPE_LKP_TL | AP_DISTRIBUTION_TYPE_LKP_CODE
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 | 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_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
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
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_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_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 | 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_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_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
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_YESNO_LKP_TL with CODE_TYPE=FA_YESNO. | DW_YESNO_LKP_TL | YESNO_LKP_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. |  |
INVOICE_PAYMENT_AMOUNT | NUMBER |  |  |  | Payment amount that is paid. |  |
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
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 |  |
MAX_CHK_DATE_FISCAL_PERIOD_NAME | VARCHAR2 | 64 |  |  | Max Accounting Period Name based on Payment Check date |  |
INVOICE_INTER_COMPANY_FLAG | VARCHAR2 | 16 |  |  | Intercompany flag added to incorporate FUN team's intercompany feature. | DW_YESNO_LKP_TL | YESNO_LKP_CODE

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