DW_AP_SLA_SUPPLIER_PAYMENTS_CA

This table contains Supplier Aggregate level for Payment installment counts.

Details

Module: Payables

Key Columns

GLOBAL_CURRENCY_CODE, FISCAL_PERIOD_SET_NAME, FISCAL_PERIOD_NAME, XLA_LEDGER_CURRENCY_CODE, SUPPLIER_PARTY_ID, FISCAL_PERIOD_TYPE, PAYABLES_PAYMENTS_BU_ID, XLA_LEDGER_ID, PAYABLES_BU_ID, LEGAL_ENTITY_ID, INVOICE_CURRENCY_CODE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SUPPLIER_PARTY_ID NUMBER 38 0 True Supplier identifier. DW_PARTY_D PARTY_ID
PAYABLES_BU_ID NUMBER 38 0 True Payables invoicing business unit identifier. DW_INTERNAL_ORG_D ORGANIZATION_ID
PAYABLES_PAYMENTS_BU_ID NUMBER 38 0 True Payables payments business unit identifier. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEGAL_ENTITY_ID NUMBER 38 0 True Legal entity identifier. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
XLA_LEDGER_ID NUMBER 38 0 True Self-contained accounting information set for single or multiple legal or management entities.
FISCAL_PERIOD_SET_NAME VARCHAR2 16 True Accounting calendar name. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE VARCHAR2 16 True Accounting period type. DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
FISCAL_PERIOD_NAME VARCHAR2 64 True Accounting period name.
XLA_LEDGER_CURRENCY_CODE VARCHAR2 16 True Functional currency of the ledger.
INVOICE_CURRENCY_CODE VARCHAR2 16 True Invoice currency code.
GLOBAL_CURRENCY_CODE VARCHAR2 16 True Global currency code.
SOURCE_RECORD_ID VARCHAR2 512 This column is for Oracle Internal use only. Source record identifier.
INSTALLMENT_PAYMENT_DAYS_COUNT NUMBER 38 0 Installment Payment Days Count.
FULLY_PAID_INSTALLMENT_COUNT NUMBER 38 0 Fully Paid Installment Count.