# 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.