DW_NS_INBOUND_SHIPMENT_ITEM_F
This fact table stores the line level information of inbound shipment that tracks incoming shipment containing multiple purchase order items.
Details
Module:
Key Columns
id, inboundshipment
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| id | NUMBER | 38 | 0 | True | Transaction Identifier. | ||
| inboundshipment | NUMBER | 38 | 0 | True | |||
| 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. | ||||
| expectedrate | NUMBER | ||||||
| incoterm | NUMBER | 38 | 0 | Standardized three-letter trade term used on transactions related to international commercial procurement practices. Incoterms define where an entity takes ownership of a product. | DW_NS_IncoTerm_D | id | |
| pocurrency | NUMBER | 38 | 0 | DW_NS_currency_D | id | ||
| porate | NUMBER | ||||||
| quantitybilled | NUMBER | ||||||
| quantityexpected | NUMBER | ||||||
| quantityreceived | NUMBER | ||||||
| quantityremaining | NUMBER | ||||||
| receivinglocation | NUMBER | 38 | 0 | DW_NS_location_D | id | ||
| shipmentitemdescription | VARCHAR2 | 999 | |||||
| shipmentitemeffectivedate | TIMESTAMP | ||||||
| shipmentitemexchangerate | NUMBER | ||||||
| totalunitcost | NUMBER | ||||||
| unit | NUMBER | 38 | 0 | Unit of Measure. | DW_NS_unitsTypeUom_D | internalid | |
| unitlandedcost | NUMBER | ||||||
| vendorid | NUMBER | 38 | 0 | DW_NS_vendor_D | id | ||
| lastmodifieddate | TIMESTAMP | Last Modification Date. | |||||
| shipmentbasecurrency | NUMBER | 38 | 0 | Transaction currency identifier. | DW_NS_currency_D | id | |
| 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. | ||||
| shipmentcreateddate | TIMESTAMP | Transaction creation date. | |||||
| 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. | ||||
| shipment_expectedrate | NUMBER | ||||||
| shipment_porate | NUMBER | ||||||
| shipment_itemamount | NUMBER | ||||||
| shipment_totalunitcost | NUMBER | ||||||
| shipment_unitlandedcost | NUMBER | ||||||
| itemamount | NUMBER | ||||||
| item | NUMBER | 38 | 0 | Identifier of the item. | DW_NS_item_D | id | |
| purchaseorder_transaction | NUMBER | 38 | 0 | DW_NS_PURCHASE_ORDER_LINES_F | transaction | ||
| purchaseorder_line | NUMBER | 38 | 0 | DW_NS_PURCHASE_ORDER_LINES_F | id | ||
| purchaseorder_trandisplayname | VARCHAR2 | 999 | |||||
| purchaseorder_typebaseddocumentnumber | VARCHAR2 | 512 | |||||
| purchaseorder_subsidiary | NUMBER | 38 | 0 | DW_NS_subsidiary_D | id | ||
| purchaseorder_class | NUMBER | 38 | 0 | DW_NS_classification_D | id | ||
| purchaseorder_department | NUMBER | 38 | 0 | DW_NS_department_D | id |