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 |
