# DW_RCV_SHIPMENTS_AGG_CF

This fact table stores RCV Shipment Aggregates

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

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