DW_INVOICE_SPEND_AGG_CF
This fact table stores Invoice Spend Aggregates
Details
Module: Purchasing
Key Columns
SYSTEM_GEN_PK
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.