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.