DW_PURCHASE_ORDER_AGG_CF

Purchase Order Aggregate Fact

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 ID DW_INTERNAL_ORG_D ORGANIZATION_ID
PO_REQUISITION_BU_ID NUMBER 38 0 Req BU ID DW_INTERNAL_ORG_D ORGANIZATION_ID
PO_REQUISITION_LEDGER_ID NUMBER 38 0 Primary ledger ID of Requisition BU
REQ_FISCAL_PERIOD_SET_NAME VARCHAR2 16 Accounting calendar name. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
REQ_FISCAL_PERIOD_TYPE VARCHAR2 16 Accounting period type. DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
FISCAL_PERIOD_NAME VARCHAR2 64 Accounting period name. DW_FISCAL_DAY_D FISCAL_PERIOD_NAME
GLOBAL_CURRENCY_CODE VARCHAR2 16 Global currency code. DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
PR_TO_PO_CYCLE_TIME NUMBER PR to PO cycle time in days ( PO Creation date - Requisition Approval date)
PO_OPEN_CYCLE_TIME NUMBER PO Open cycle time in days (PO Processed date - PO Creation date)
PO_CLOSE_CYCLE_TIME NUMBER PO Close cycle time in days (PO Close date - PO Creation date)
ORDERED_AMOUNT_GLOBAL NUMBER Ordered amount in global currency
PO_COUNT NUMBER Total Number of Purchase orders
COUNT_OF_PR_PO NUMBER count of purchase order id in PR to PO cycle time in days ( PO Creation date - Requisition Approval date)
COUNT_OF_OPENED_PO NUMBER count of purchase order id in PO Open cycle time in days (PO Processed date - PO Creation date)
COUNT_OF_CLOSED_PO NUMBER count of purchase order id in PO Close cycle time in days (PO Close date - PO Creation date)