shipment - AWS Supply Chain

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