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

INVOICE_PAYMENT_ID, TRANSACTION_TYPE, FISCAL_PERIOD_NAME, XLA_LEDGER_ID, XLA_TRANSACTION_CURRENCY_CODE

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     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_CODE_VALUES_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_CODE_VALUES_LKP_TL CODE
INVOICE_SOURCE_CODE VARCHAR2 32     Invoice source. Values are from the table DW_CODE_VALUES_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_CODE_VALUES_LKP_TL CODE
INVOICE_CANCELLED_FLAG VARCHAR2 32     Indicates a cancelled invoice. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. DW_CODE_VALUES_LKP_TL 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_CODE_VALUES_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.    
INVOICE_VALIDATION_STATUS_CODE VARCHAR2 16     Invoice validation status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_INVOICE_VALIDATION_STATUS_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_CODE_VALUES_LKP_TL with CODE_TYPE=INVOICE PAYMENT STATUS. DW_CODE_VALUES_LKP_TL CODE
INV_SCH_PAYMENT_METHOD_CODE VARCHAR2 32     Payment method (Invoice Schedules). Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_PAYMENT_METHOD_CODE. Possible values are Bills Payable, CHECK, EFT, FUTURE_PAY35, NETTING, WIRE, and so on. DW_CODE_VALUES_LKP_TL 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_CODE_VALUES_LKP_TL with CODE_TYPE=AP_PAYMENT_METHOD_CODE. Possible values are Bills Payable, CHECK, EFT, FUTURE_PAY35, NETTING, WIRE, and so on. DW_CODE_VALUES_LKP_TL CODE
PAYMENT_STATUS_CODE VARCHAR2 32     Payment status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=CHECK STATE. DW_CODE_VALUES_LKP_TL CODE
PAYMENT_ACCOUNTING_STATUS_CODE VARCHAR2 32     Payment accounting status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_ACCOUNTING_STATUS. DW_CODE_VALUES_LKP_TL 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
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.    

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