# DW_INVOICE_SPEND_AGG_CF

This fact table stores Invoice Spend Aggregates

## Details

Module: Purchasing

## Key Columns

SYSTEM_GEN_PK

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
SYSTEM_GEN_PK | VARCHAR2 | 512 |  | True | Generated Primary Key for Internal Use Only |  |
SOURCE_RECORD_ID | VARCHAR2 | 512 |  |  | This column is for Oracle Internal use only. System Generated |  |
PROCUREMENT_BU_ID | NUMBER | 38 | 0 |  | Procurement business unit identifier | DW_INTERNAL_ORG_D | ORGANIZATION_ID
PAYABLES_BU_ID | NUMBER | 38 | 0 |  | Payable invoicing business unit identifier | DW_INTERNAL_ORG_D | ORGANIZATION_ID
SUPPLIER_ID | NUMBER | 38 | 0 |  | Supplier identifier | DW_PARTY_D | SUPPLIER_ID
SUPPLIER_SITE_ID | NUMBER | 38 | 0 |  | Supplier site identifier | DW_SUPPLIER_SITE_D | SUPPLIER_SITE_ID
SPEND_SEC_BU_ID | NUMBER | 38 | 0 |  | Indicates Procurement BU incase of PO matched distributions otherwise supplier site procurement BU | DW_INTERNAL_ORG_D | ORGANIZATION_ID
SPEND_PURCHASING_CATEGORY_ID | NUMBER | 38 | 0 |  | Indicates Procurement Item Purchasing Category incase of PO matched distributions otherwise Invoice Line Item Purchasing Category | DW_ITEM_CATEGORIES_D | CATEGORY_ID
XLA_LEDGER_ID | NUMBER | 38 | 0 |  | Self-contained accounting information set for single or multiple legal or management entities | DW_LEDGER_D | LEDGER_ID
INVOICED_FISCAL_PERIOD_NAME | VARCHAR2 | 64 |  |  | Fiscal Period Name anchored to Invoiced On Date |  |
ACCOUNTING_FISCAL_PERIOD_NAME | VARCHAR2 | 64 |  |  | Fiscal Period Name anchored to Distribution Accounting Date |  |
PROJECT_ID | NUMBER | 38 | 0 |  | Identifier of the project used to build the transaction descriptive flexfield for project related transaction distributions | DW_PROJECT_D | PROJECT_ID
TASK_ID | NUMBER | 38 | 0 |  | Identifier of the task used to build the transaction descriptive flexfield for project related transaction distributions | DW_PROJECT_ELEMENT_D | PROJ_ELEMENT_ID
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | Accounting period type #1 | DW_FISCAL_PERIOD_D | FISCAL_PERIOD_TYPE
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | Accounting calendar name #1 | DW_FISCAL_PERIOD_D | FISCAL_PERIOD_SET_NAME
XLA_LEDGER_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Ledger currency code | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
SPEND_XLA_LEDGER_AMOUNT | BIGDECIMAL |  | 10 |  | Spend Subledger Amount in Ledger Currency |  |
AGREEMENT_LEAKAGE_XLA_LEDGER_AMOUNT | BIGDECIMAL |  | 10 |  | Agreement Leakage Subledger Amount in Ledger Currency |  |
AGREEMENT_BASED_XLA_LEDGER_AMOUNT | BIGDECIMAL |  | 10 |  | Agreement Based Subledger Amount in Ledger Currency |  |
PURCHASE_ORDER_MATCHED_XLA_LEDGER_AMOUNT | BIGDECIMAL |  | 10 |  | Purchase Order Matched Subledger Amount in Ledger Currency |  |
ADDRESSABLE_XLA_LEDGER_AMOUNT | BIGDECIMAL |  | 10 |  | Addressable Subledger Amount in Ledger Currency |  |
NEGOTIATED_XLA_LEDGER_AMOUNT | BIGDECIMAL |  | 10 |  | Negotiatied Subledger Amount in Ledger Currency |  |
TOTAL_XLA_LEDGER_AMOUNT | BIGDECIMAL |  | 10 |  | Total Subledger Amount in Ledger Currency |  |
GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Global currency code | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
SPEND_XLA_GLOBAL_AMOUNT | BIGDECIMAL |  | 10 |  | Spend Subledger Amount in Global Currency |  |
AGREEMENT_LEAKAGE_XLA_GLOBAL_AMOUNT | BIGDECIMAL |  | 10 |  | Agreement Leakage Subledger Amount in Global Currency |  |
AGREEMENT_BASED_XLA_GLOBAL_AMOUNT | BIGDECIMAL |  | 10 |  | Agreement Based Subledger Amount in Global Currency |  |
PURCHASE_ORDER_MATCHED_XLA_GLOBAL_AMOUNT | BIGDECIMAL |  | 10 |  | Purchase Order Matched Subledger Amount in Global Currency |  |
ADDRESSABLE_XLA_GLOBAL_AMOUNT | BIGDECIMAL |  | 10 |  | Addressable Subledger Amount in Global Currency |  |
NEGOTIATED_XLA_GLOBAL_AMOUNT | BIGDECIMAL |  | 10 |  | Negotiatied Subledger Amount in Global Currency |  |
TOTAL_XLA_GLOBAL_AMOUNT | BIGDECIMAL |  | 10 |  | Total Subledger Amount in Global Currency |  |

## Notes

#1 In these cases to join with DW_FISCAL_PERIOD_D apart from FISCAL_PERIOD_TYPE and FISCAL_PERIOD_SET_NAME the relationship should be based on INVOICED_FISCAL_PERIOD_NAME/ACCOUNTING_FISCAL_PERIOD_NAME column.

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