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)    

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