transportation_lane - AWS Supply Chain

transportation_lane

Primary key (PK)

The table below lists the colum names that are uniquely identified in the data entity.

Name Column
transportation_lane id, from_site_id, to_site_id, from_geo_id, to_geo_id, carrier_tpartner_id, trans_mode, service_type, product_group_id

The table below lists the column names supported by the data entity:

Column Data type Required Description

id

string

Yes

Lane ID.

from_site_id2

string

Yes1

Origin site location for the lane. You can exclude this field if the from_geo_id is populated.

to_site_id2

string

Yes1

Destination site location for the lane. You can exclude this field if the to_geo_id is populated.

company_id2

string

No

Company ID.

from_geo_id2

string

Yes1

When lane definition is at geographical level, displays the 'from' or 'source' geographical region.

to_geo_id2

string

Yes1

When lane definition is at geographical level, displays the 'to' or 'source' geographical region.

carrier_tpartner_id2

string

Yes1

ID of the carrier.

trans_mode

string

Yes1

Transportation mode, for example, ship, rail, or truck.

service_type

string

Yes1

Provides information on the shipping method for the carrier.

product_group_id2

string

Yes1

Product group ID if transit time varies by product group.

product_id2

string

No

Product ID is used when a lane has product-specific configuration.

transit_time

double

No

Transit time of products.

transit_time_sd

double

No

Standard deviation of transit time.

time_uom

string

No

Unit of measure of transit time.

distance

double

No

Distance traveled on the lane.

distance_uom

string

No

Unit of measure (UOM) of distance.

eff_start_date

timestamp

No

Date and time when this record becomes effective.

eff_end_date

timestamp

No

Date and time till when this record becomes effective.

daily_start_time

string

No

Time when the lane begins operating.

daily_end_time

string

No

Time when the lane ends operation.

open_sun

string

No

Displays whether the lane is open on Sunday.

open_mon

string

No

Displays whether the lane is open on Monday.

open_tue

string

No

Displays whether the lane is open on Tuesday.

open_wed

string

No

Displays whether the lane is open on Wednesday.

open_thu

string

No

Displays whether the lane is open on Thursday.

open_fri

string

No

Displays whether the lane is open on Thursday.

open_sat

string

No

Displays whether the lane is open on Saturday.

cost_per_unit

double

No

Cost per distance UOM.

cost_per_weight

double

No

Cost per weight UOM.

cost_currency

string

No

Currency UOM of costs.

weight_uom

string

No

Unit of measurement for weight.

emissions_per_unit

double

No

Carbon emissions emitted per unit distance UOM.

emissions_per_weight

double

No

Carbon emissions emitted per weight UOM.

source

string

No

Source of data.

transportation_cost

double

No

Transportation cost related to the transport lane.

transportation_cost_uom

string

No

Transportation cost UOM related to the transport lane.

source_event_id

string

No

ID of the event created in the source system.

source_update_dttm

timestamp

No

Date time stamp of the update made in the source system.

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
from_site_id, to_site_id Network site id
company_id Organization company id
from_geo_id, to_geo_id Organization geography id
carrier_tpartner_id Organization trading_partner id
product_group_id Product product_hierarchy id
product_id Product product_id id