DW_RCV_SHIPMENTS_AGG_CF
This fact table stores RCV Shipment Aggregates
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 | ||||
| PROCUREMENT_BU_ID | NUMBER | 38 | 0 | Procurement business unit identifier. | |||
| REQUISITION_BU_ID | NUMBER | 38 | 0 | Requisition business unit identifer. | |||
| SUPPLIER_ID | NUMBER | 38 | 0 | Supplier unique identifier. | |||
| SHIP_TO_ORG_ID | NUMBER | 38 | 0 | Inventory organization unique identifier where the receipt and shipment are created. | |||
| REQUISITION_LEDGER_ID | NUMBER | 38 | 0 | Primary ledger id of requisition BU | |||
| REQ_FISCAL_PERIOD_TYPE | VARCHAR2 | 16 | Accounting period type based on primary ledger of requisition org. | ||||
| REQ_FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | Accounting calendar name based on primary ledger of requisition org. | ||||
| SHIPMENT_HEADER_CREATION_PERIOD_NAME | VARCHAR2 | 64 | Shipment Header Creation Period Name | ||||
| ONTIME_DELIVERY_FLAG | VARCHAR2 | 32 | Indicates if shipment was received on-time. RECEIPT DATE = PROMISED DELIVERY DATE, if null NEED BY DATE. Value will be N if any one of the date attributes are NULL. | ||||
| SHIPMENT_LINE_ID_COUNT | NUMBER | Count of shipment lines |