DW_NS_INBOUND_SHIPMENT_SNAPSHOT_F
This fact contains daily end of the day attribute change information of a given inbound shipment from open to close date.
Details
Module:
Key Columns
SNAPSHOT_DATE, ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| ID | NUMBER | 38 | 0 | True | Transaction Identifier. | ||
| SNAPSHOT_DATE | DATE | True | Specific date on which values of attributes and metrics of this snapshot is based. | ||||
| 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. | ||||
| 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. | ||||
| vesselnumber | VARCHAR2 | 512 | Shipment Vessel's IMO Number | ||||
| type | VARCHAR2 | 16 | Transaction type. | ||||
| closedate | TIMESTAMP | Date on which the transaction is closed. | |||||
| daysopen | NUMBER | 38 | 0 | Number of days a transaction has been opened. |