DW_REQUISITION_AGG_CF
Requisitions Aggregate Fact
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 | ||||
| PO_PROC_BU_ID | NUMBER | 38 | 0 | Procurement business unit identifier | |||
| SECURITY_PROC_BU_ID | NUMBER | 38 | 0 | If REQ_PROC_BU_ID is null then PO_PROC_BU_ID else REQ_PROC_BU_ID | DW_INTERNAL_ORG_D | ORGANIZATION_ID | |
| REQUISITION_BU_ID | NUMBER | 38 | 0 | Requisition business unit identifier | |||
| REQ_BU_PRIMARY_LEDGER_ID | NUMBER | 38 | 0 | Primary ledger identifier of requisition business unit | |||
| REQ_FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | Accounting calendar name. | ||||
| REQ_FISCAL_PERIOD_TYPE | VARCHAR2 | 16 | Accounting period type. | ||||
| REQUISITION_HEADER_CREATION_PERIOD | VARCHAR2 | 64 | Accounting period name. | ||||
| GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 | Global currency code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| REQUISITION_AMOUNT | NUMBER | Requisition amount in global currency | |||||
| REQUISITION_COUNT | NUMBER | Count of requisitions | |||||
| REQ_SUBMIT_TO_FULFIL_TIME | NUMBER | Time taken to fulfil requisition i.e. from req line last submit date to purchase order line closed date | |||||
| REQ_APPROVAL_CYCLE_TIME | NUMBER | Time taken to get requisition approved in first cycle i.e. from first submit date to first approval date | |||||
| COUNT_OF_FULFILLED_REQ | NUMBER | Count of requisition line id from last submit date to purchase order line closed date | |||||
| COUNT_OF_APPROVED_REQ | NUMBER | Count of requisition header id from first submit date to first approval date |