# DW_AP_SLA_SUPPLIER_PAYMENTS_CA

This table contains Supplier Aggregate level for Payment installment counts.

## Details

Module: Payables

## Key Columns

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

## 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
SUPPLIER_SITE_ID | NUMBER | 38 | 0 | True | Supplier site identifier. | DW_SUPPLIER_SITE_D | SUPPLIER_SITE_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. |  |

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