# inbound\$1order\$1line
<a name="replenishment-inbound-order-line-entity"></a>

**Primary key (PK)**

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


| Name | Column | 
| --- | --- | 
| inbound\$1order\$1line | id, order\$1id, tpartner\$1id, product\$1id | 

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


| Column | Data type | Required | Description | 
| --- | --- | --- | --- | 
|  id  |  string  |  Yes1  |  Order line ID. The value must be unique.  | 
|  order\$1id2  |  string  |  Yes1  |  ID of parent order.  | 
|  company\$1id2  |  string  |  No  |  Company ID.  | 
|  tpartner\$1id2  |  string  |  Yes1  |  Partner that the order will be sent to.  | 
|  line\$1creation\$1date  |  timestamp  |  No  |  Line creation date.  | 
|  product\$1id2  |  string  |  Yes1  |  Product ID.  | 
|  product\$1group\$1id2  |  string  |  No  |  Product group ID.  | 
|  supplier\$1product\$1id  |  string  |  No  |  Product number used by supplier.  | 
|  order\$1type  |  string  |  No  |  Type of order.  | 
|  external\$1line\$1number  |  string  |  No  |  Alternate line number if used by customer system.  | 
|  status  |  string  |  No  |  Status of the line, for example, canceled, closed, or open.  | 
|  from\$1site\$1id2  |  string  |  No  |  Site where order line originates.  | 
|  to\$1site\$1id2  |  string  |  No  |  Site where the order will arrive.  | 
|  vendor\$1status  |  string  |  No  |  Status of the line in the vendor system..  | 
|  cost  |  double  |  No  |  Cost of the product in company's currency, after all discounts.  | 
|  cost\$1uom  |  string  |  No  |  Cost UOM in company's currency.  | 
|  submitted\$1cost  |  double  |  No  |  Cost of the product at the time of submission, in company's currency.  | 
|  submitted\$1cost\$1vendor  |  double  |  No  |  Cost of the product at the time of submission, in vendor's currency.  | 
|  shipping\$1cost  |  double  |  No  |  Inbound shipping cost from vendor to company.  | 
|  tax\$1cost  |  double  |  No  |  Tax cost for the product.  | 
|  quantity\$1submitted  |  double  |  Yes  |  Quantity submitted to vendor.  | 
|  quantity\$1confirmed  |  double  |  No  |  Quantity confirmed by the vendor.  | 
|  quantity\$1received  |  double  |  No  |  Quantity received into inventory.  | 
|  quantity\$1uom  |  string  |  No  |  Quantity UOM for the order line.  | 
|  submitted\$1date  |  timestamp  |  No  |  Date and time when the order was submitted to vendor.  | 
|  expected\$1delivery\$1date  |  timestamp  |  No  |  Date when the order is expected to be delivered.  | 
|  confirmation\$1date  |  timestamp  |  No  |  Date and time when the order was confirmed by the vendor.  | 
|  earliest\$1ship\$1date  |  timestamp  |  No  |  Earliest date and time when the vendor can ship products in this order.  | 
|  latest\$1ship\$1date  |  timestamp  |  No  |  Latest date and time when the vendor can ship products in this order.  | 
|  earliest\$1delivery\$1date  |  timestamp  |  No  |  Earliest date and time when the vendor can deliver products in this order.  | 
|  latest\$1delivery\$1date  |  timestamp  |  No  |  Latest date and time when the vendor can deliver products in this order.  | 
|  incoterm  |  string  |  No  |  Three letter incoterm code.  | 
|  incoterm2  |  string  |  No  |  Place of ownership transfer.  | 
|  incoterm\$1location\$11  |  string  |  No  |  Incoterm location 1. Can be a site\$1id or the location used on order/EDI.  | 
|  incoterm\$1location\$12  |  string  |  No  |  Incoterm location 2. Can be a site\$1id or the location used on order/EDI.  | 
|  requisition\$1number  |  string  |  No  |  Requisition number.  | 
|  order\$1receive\$1date  |  timestamp  |  No  |  Date and time when the order is unloaded into the company location.  | 
|  reservation\$1id2  |  string  |  No  |  Reservation ID associated with the line.  | 
|  reference\$1object  |  string  |  No  |  If record is created by or in response to another object / entity, then enter the entity name. For example, inbound\$1order, outbound\$1order  | 
|  reference\$1object\$1type  |  string  |  No  |  If activity is created by or in response to a specific type of object, specify the type here. For example, PO (Purchase Order) vs TO (Transfer Order)  | 
|  reference\$1object\$1id  |  string  |  No  |  ID of associated reference object.  | 
|  reference\$1detail\$1id  |  string  |  No  |  ID of associated reference object ID's detail/line, if any.  | 
|  inbound\$1order\$1line\$1url  |  string  |  No  |  URL to access inbound order line record in source system.  | 
|  source\$1update\$1dttm  |  timestamp  |  No  |  Date time stamp of the update made in the source system.  | 
|  source\$1event\$1id  |  string  |  No  |  ID of the event created in the source system.  | 
|  source  |  string  |  No  |  Source of data.  | 
|  sap\$1lips\$1\$1vbeln  |  string  |  No  |  Delivery Number. Predicate key for SAP mapping. Upsert key for VTTP, LIKP.   | 
|  sap\$1vttp\$1\$1tknum  |  string  |  No  |  Shipment Number. Predicate key for SAP mapping. Upsert key for VTTK.   | 

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 | 
| --- | --- | --- | --- | 
| tpartner\$1id | Organization | trading\$1partner | id | 
| company\$1id | Organization | company | id | 
| product\$1id | Product | product | id | 
| from\$1site\$1id | Network | site | id | 
| product\$1group\$1id | Product | product\$1hierarchy | id | 
| order\$1id | Inbound | inbound\$1order | id | 
| reservation\$1id | Planning | reservation | reservation\$1id |