shipment
Primary key (PK)
The table below lists the colum names that are uniquely identified in the data entity.
Name | Column |
---|---|
shipment | id, supplier_tpartner_id, product_id, order_id, order_line_id, package_id |
The table below lists the column names supported by the data entity:
Column | Data type | Required | Description |
---|---|---|---|
id |
string |
Yes |
Shipment ID. |
creation_date |
timestamp |
No |
Creation date. |
packaging_hierarchy_type |
string |
No |
Information on how the shipment is structured, for example, container, pallet, carton, or pallet. |
supplier_tpartner_id2 |
string |
Yes1 |
Supplier partner ID of the vendor. |
supplier_description |
string |
No |
Partner description. |
company_id2 |
string |
No |
Company ID. |
customer_description |
string |
No |
Customer description. |
ship_from_site_id2 |
string |
No |
Site where this shipment starts from. |
ship_from_site_description |
string |
No |
Site description for outbound shipments. |
ship_from_site_address_1 |
string |
No |
Address of ship-from site. |
ship_from_site_address_2 |
string |
No |
Address of ship-from site. |
ship_from_site_address_city |
string |
No |
Site shipping city. |
ship_from_site_address_state |
string |
No |
Site shipping state. |
ship_from_site_address_country |
string |
No |
Site shipping country. |
ship_from_site_address_zip |
string |
No |
Site shipping postal code. |
ship_to_site_id2 |
string |
No |
Site where this shipment ends. |
ship_to_site_description |
string |
No |
Site description for inbound shipments. |
ship_to_site_address_1 |
string |
No |
Address of ship-to site. |
ship_to_site_address_2 |
string |
No |
Address of ship-to site. |
ship_to_site_address_city |
string |
No |
Site shipping city. |
ship_to_site_address_state |
string |
No |
Site shipping state. |
ship_to_site_address_country |
string |
No |
Site shipping country. |
ship_to_site_address_zip |
string |
No |
Site shipping postal code. |
origin_port |
string |
No |
Port of loading. |
destination_port |
string |
No |
Port of destination. |
transportation_mode |
string |
No |
Mode of transport. |
routing_sequence |
string |
No |
Routing sequence ID from the ASN. |
routing_description |
string |
No |
Routing description. |
carrier_id2 |
string |
No |
ID of the carrier. |
carrier_description |
string |
No |
Carrier description. |
service_level |
string |
No |
Service level of shipment. |
transportation_id |
string |
No |
Vessel code or trailer number. |
transportation_description |
string |
No |
Vessel description. |
conveyance_id |
string |
No |
Trip number. |
bill_of_lading_number |
string |
No |
Bill of lading number. |
master_bill_of_lading_number |
string |
No |
Master bill of lading number. |
carrier_reference_number |
string |
No |
Carrier reference number. |
shipper_reference_number |
string |
No |
Shipper reference number. |
equipment_code |
string |
No |
Equipment code. |
equipment_number |
string |
No |
Equipment number. |
seal_number |
string |
No |
Seal number. |
equipment_type |
string |
No |
Type of equipment. |
package_type |
string |
No |
Type of package. |
package_quantity |
double |
No |
Quantity of the package. |
weight_qualifier |
string |
No |
Code specifying the type of weight in EDI, for example, consolidated weight. |
weight |
double |
No |
Weight of the product. |
weight_uom |
string |
No |
Weight UOM of the product. |
shipment_status |
string |
No |
Status of the shipment. |
planned_ship_date |
timestamp |
No |
Planned shipping date. |
actual_ship_date |
timestamp |
No |
Actual shipping date. |
planned_delivery_date |
timestamp |
No |
Planned delivery date. |
actual_delivery_date |
timestamp |
No |
Actual delivery date. |
carrier_eta_date |
timestamp |
No |
ETA date from the carrier. |
latest_milestone |
string |
No |
Text or string field required to capture event or status related to the milestone_date, for example, arrived at consolidation center. |
latest_milestone_date |
timestamp |
No |
Latest milestone date. |
incoterms |
string |
No |
Three letter incoterm code. |
line_id |
string |
No |
Shipment line ID. |
product_id2 |
string |
Yes |
Product ID. |
product_description |
string |
No |
Product description. |
tp_product_id |
string |
No |
Trading partner product ID. |
upc |
string |
No |
UPC |
units_shipped |
double |
No |
Units shipped. |
uom |
string |
No |
UOM. |
hts_code |
string |
No |
Harmonized Tariff Schedule code. |
order_id2 |
string |
Yes1 |
Order ID. |
order_type |
string |
No |
Order type. |
order_customer_tpartner_id |
string |
No |
Customer ID of the order. |
order_supplier_tpartner_id |
string |
No |
Supplier ID of the order. |
order_line_id2 |
string |
Yes1 |
Order line ID. |
ship_to_site2 |
string |
No |
Final ship to location. |
package_id |
string |
Yes1 |
Package ID. |
source_update_dttm |
timestamp |
No |
Date time stamp of the update made in the source system. |
source_event_id |
string |
No |
ID of the event created in the source system. |
source |
string |
No |
Source of data. |
volume |
double |
No |
Volume of the shipment. |
volume_uom |
string |
No |
Volume unit of measurement of the shipment. |
sap_vttp__vbeln |
string |
No |
Delivery Number. Predicate key for SAP mapping. Upsert key for LIKP, LIPS. |
sap_but021_fs__addrnumber |
string |
No |
Address Number. Predicate key for ADRC (for Ship-to Address). |
sap_t001w__adrnr |
string |
No |
Address Number. Predicate key for SAP mapping. Upsert key for ADRC. |
sap_vttk__bev1_rpmowa |
string |
No |
Vehicle number. Predicate key for SAP mapping. Upsert key for Equi. |
units_received |
double |
No |
Represent the received quantity for a shipment for users who track receipts at a shipment level. |
1You must enter a value. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED.
2Foreign key
Foreign key (FK)
The table below lists the columns with the associated foreign key.
Column | Category | FK/Data entity | FK/Column |
---|---|---|---|
supplier_tpartner_id | Organization | trading_partner | id |
company_id | Organization | company | id |
ship_from_site_id, ship_to_site_id, ship_to_site | Network | site | id |
product_id | Product | product | id |
order_id | Inbound | inbound_order | id |
order_line_id | Inbound | inbound_order_line | id |