# inbound\$1order\$1line\$1schedule
<a name="replenishment-inbound-order-line-schedule-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\$1schedule | id, order\$1id, order\$1line\$1id, product\$1id | 

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


| Column | Data type | Required | Description | 
| --- | --- | --- | --- | 
|  id  |  string  |  Yes 1  |  Order line ID. The value must be unique.  | 
|  order\$1id2  |  string  |  Yes 1  |  ID of parent order.  | 
|  order\$1line\$1id2  |  string  |  Yes  |  ID of parent order line.  | 
|  company\$1id2  |  string  |  No  |  Company ID.  | 
|  status  |  string  |  No  |  Status of line, for example, submitted, or confirmed. The following are the reserved values for AWS Supply Chain. [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/aws-supply-chain/latest/userguide/replenishment-inbound-order-line-schedule-entity.html)  Null is also an accepted value, or you can enter your own value.   | 
|  schedule\$1creation\$1date  |  timestamp  |  No  |  Schedule creation date.  | 
|  product\$1id2  |  string  |  Yes 1  |  Product ID.  | 
|  external\$1line\$1number  |  string  |  No  |  External line number.  | 
|  expected\$1delivery\$1date  |  timestamp  |  No  |  Expected delivery date of the products.  | 
|  confirmation\$1date  |  timestamp  |  No  |  Date and time when the vendor confirmed the order line schedule, or order.  | 
|  goods\$1issue\$1date  |  timestamp  |  No  |  Date and time when the material was available at origin to ship.  | 
|  material\$1availability\$1date  |  timestamp  |  No  |  Date and time when the material was available at origin to ship.  | 
|  ship\$1date  |  timestamp  |  No  |  Date and time when vendor will ship products in this order-line-schedule.  | 
|  delivery\$1date  |  timestamp  |  No  |  Date and time when the vendor can deliver products in this schedule.  | 
|  quantity\$1submitted  |  double  |  No  |  Quantity submitted to vendor (POs) or for transfer.  | 
|  quantity\$1confirmed  |  double  |  No  |  Quantity confirmed by the vendor.  | 
|  quantity\$1received  |  double  |  No  |  Quantity received into inventory at the destination.  | 
|  sap\$1lips\$1\$1vbeln  |  string  |  No  |  Delivery Number. Predicate key for SAP mapping. Upsert key for VTTP  | 
|  sap\$1vttp\$1\$1tknum  |  string  |  No  |  Shipment Number. Predicate key for SAP mapping. Upsert key for VTTK  | 
|  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 | 
| --- | --- | --- | --- | 
| company\$1id | Organization | company | id | 
| product\$1id | Product | product | id | 
| order\$1id | Inbound | inbound\$1order | id | 
| order\$1line\$1id | Inbound | inbound\$1order\$1line | id |