DW_AP_SLA_PAYMENTS_CA
This table contains Aggrigate level of Payables payment distribution transactions.This table supports the post SLA account details coming from the subledger accounting module.
Details
Module: Payables
Key Columns
XLA_LEDGER_ID, TRANSACTION_TYPE, XLA_TRANSACTION_CURRENCY_CODE, FISCAL_PERIOD_NAME, INVOICE_PAYMENT_ID
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) |