# transportation\$1lane
<a name="network-transporation-lane-entity"></a>

**Primary key (PK)**

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


| Name | Column | 
| --- | --- | 
| transportation\$1lane | id, from\$1site\$1id, to\$1site\$1id, from\$1geo\$1id, to\$1geo\$1id, carrier\$1tpartner\$1id, trans\$1mode, service\$1type, product\$1group\$1id | 

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


| Column | Data type | Required | Description | 
| --- | --- | --- | --- | 
|  id  |  string  |  Yes  |  Lane ID.  | 
|  from\$1site\$1id2  |  string  |  Yes1  |  Origin site location for the lane. You can exclude this field if the from\$1geo\$1id is populated.  | 
|  to\$1site\$1id2  |  string  |  Yes1  |  Destination site location for the lane. You can exclude this field if the to\$1geo\$1id is populated.  | 
|  company\$1id2  |  string  |  No  |  Company ID.  | 
|  from\$1geo\$1id2  |  string  |  Yes1  |  When lane definition is at geographical level, displays the 'from' or 'source' geographical region.  | 
|  to\$1geo\$1id2  |  string  |  Yes1  |  When lane definition is at geographical level, displays the 'to' or 'source' geographical region.  | 
|  carrier\$1tpartner\$1id2  |  string  |  Yes1  |  ID of the carrier.  | 
|  trans\$1mode  |  string  |  Yes1  |  Transportation mode, for example, ship, rail, or truck.  | 
|  service\$1type  |  string  |  Yes1  |  Provides information on the shipping method for the carrier.  | 
|  product\$1group\$1id2  |  string  |  Yes1  |  Product group ID if transit time varies by product group.  | 
|  product\$1id2  |  string  |  No  |  Product ID is used when a lane has product-specific configuration.  | 
|  transit\$1time  |  double  |  No  |  Transit time of products.  | 
|  transit\$1time\$1sd  |  double  |  No  |  Standard deviation of transit time.  | 
|  time\$1uom  |  string  |  No  |  Unit of measure of transit time.  | 
|  distance  |  double  |  No  |  Distance traveled on the lane.  | 
|  distance\$1uom  |  string  |  No  |  Unit of measure (UOM) of distance.  | 
|  eff\$1start\$1date  |  timestamp  |  No  |  Date and time when this record becomes effective.   | 
|  eff\$1end\$1date  |  timestamp  |  No  |  Date and time till when this record becomes effective.  | 
|  daily\$1start\$1time  |  string  |  No  |  Time when the lane begins operating.  | 
|  daily\$1end\$1time  |  string  |  No  |  Time when the lane ends operation.  | 
|  open\$1sun  |  string  |  No  |  Displays whether the lane is open on Sunday.  | 
|  open\$1mon  |  string  |  No  |  Displays whether the lane is open on Monday.  | 
|  open\$1tue  |  string  |  No  |  Displays whether the lane is open on Tuesday.  | 
|  open\$1wed  |  string  |  No  |  Displays whether the lane is open on Wednesday.  | 
|  open\$1thu  |  string  |  No  |  Displays whether the lane is open on Thursday.  | 
|  open\$1fri  |  string  |  No  |  Displays whether the lane is open on Thursday.  | 
|  open\$1sat  |  string  |  No  |  Displays whether the lane is open on Saturday.  | 
|  cost\$1per\$1unit  |  double  |  No  |  Cost per distance UOM.  | 
|  cost\$1per\$1weight  |  double  |  No  |  Cost per weight UOM.  | 
|  cost\$1currency  |  string  |  No  |  Currency UOM of costs.  | 
|  weight\$1uom  |  string  |  No  |  Unit of measurement for weight.  | 
|  emissions\$1per\$1unit  |  double  |  No  |  Carbon emissions emitted per unit distance UOM.  | 
|  emissions\$1per\$1weight  |  double  |  No  |  Carbon emissions emitted per weight UOM.  | 
|  source  |  string  |  No  |  Source of data.  | 
|  transportation\$1cost   |  double  |  No  |  Transportation cost related to the transport lane.  | 
|  transportation\$1cost\$1uom   |  string  |  No  |  Transportation cost UOM related to the transport lane.  | 
|  source\$1event\$1id  |  string  |  No  |  ID of the event created in the source system.  | 
|  source\$1update\$1dttm  |  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\$1RESERVED\$1NO\$1VALUE\$1PROVIDED.

2Foreign key

**Foreign key (FK)**

The table below lists the columns with the associated foreign key.


| Column | Category | FK/Data entity | FK/Column | 
| --- | --- | --- | --- | 
| from\$1site\$1id, to\$1site\$1id | Network | site | id | 
| company\$1id | Organization | company | id | 
| from\$1geo\$1id, to\$1geo\$1id | Organization | geography | id | 
| carrier\$1tpartner\$1id | Organization | trading\$1partner | id | 
| product\$1group\$1id | Product | product\$1hierarchy | id | 
| product\$1id | Product | product\$1id | id |