DW_NS_INBOUND_SHIPMENT_F
This fact table stores the header level information of inbound shipment that tracks incoming shipment containing multiple purchase order items.
Details
Module:
Key Columns
id
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| id | NUMBER | 38 | 0 | True | Transaction Identifier. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 999 | This column is for Oracle Internal use only. Composite key that consists of all PK values of the transaction. This consists combination of columns that defines the granularity of the table and identifies a row uniquely. | ||||
| actualdeliverydate | TIMESTAMP | Actual date the shipment arrived at the receiving location. | |||||
| actualshippingdate | TIMESTAMP | The date when the consignment was actually shipped. | |||||
| billoflading | VARCHAR2 | 512 | The number from the bill of lading documentation. | ||||
| expecteddeliverydate | TIMESTAMP | The date when the shipment is expected to be delivered to the receiving location. | |||||
| expectedshippingdate | TIMESTAMP | The date for when the shipment is expected to leave. | |||||
| externaldocumentnumber | VARCHAR2 | 512 | The identifying number for the shipment as supplied by the shipping company. | ||||
| lastmodifieddate | TIMESTAMP | Last Modification Date. | |||||
| shipmentbasecurrency | NUMBER | 38 | 0 | Transaction currency identifier. | DW_NS_currency_D | id | |
| shipmentcreateddate | TIMESTAMP | Transaction creation date. | |||||
| shipmentmemo | VARCHAR2 | 999 | Textual description provided by transaction creators. | ||||
| shipmentnumber | VARCHAR2 | 256 | Shipment Number is the configurable system generated number. | ||||
| shipmentstatus | VARCHAR2 | 128 | Read-only field that indicates the status of the transaction. | DW_NS_INBOUNDSHIPMENTSTATUS_D | key | ||
| vesselnumber | VARCHAR2 | 512 | Shipment Vessel's IMO Number | ||||
| type | VARCHAR2 | 16 | Transaction type. |