# inbound\$1order


**Primary key (PK)**

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


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

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


| Column | Data type | Required | Description | 
| --- | --- | --- | --- | 
|  id  |  string  |  Yes 1  |  Object ID.  | 
|  company\$1id2  |  string  |  No  |  Company ID.  | 
|  order\$1creation\$1date  |  timestamp  |  No  |  Order creation date.  | 
|  order\$1type  |  string  |  No  |  Displays the type of order. Reserved order types in AWS Supply Chain: [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/aws-supply-chain/latest/userguide/replenishment-inbound-order-entity.html)  | 
|  order\$1status  |  string  |  No  |  Status of the order.  | 
|  to\$1site\$1id2  |  string  |  No  |  Site where the order will arrive.  | 
|  tpartner\$1id2  |  string  |  Yes1  |  Trading partner that the order will be sent to.  | 
|  order\$1currency\$1uom  |  string  |  No  |  Currency UOM that the company uses.  | 
|  vendor\$1currency\$1uom  |  string  |  No  |  Currency UOM that the vendor uses.  | 
|  exchange\$1rate  |  double  |  No  |  Exchange rate used for conversion.  | 
|  exchange\$1rate\$1date  |  timestamp  |  No  |  Date and time when exchange rate was calculated.  | 
|  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.  | 
|  submitted\$1date  |  timestamp  |  No  |  Date and time when order was submitted to vendor.  | 
|  agreement\$1start\$1date  |  timestamp  |  No  |  If PO is associated with contract or agreement, then start datetime of contract.  | 
|  agreement\$1end\$1date  |  timestamp  |  No  |  If PO is associated with contract or agreement, then end datetime of contract.  | 
|  shipping\$1instr\$1code  |  string  |  No  |  Code for shipping instructions.  | 
|  payment\$1terms\$1code  |  string  |  No  |  Code for payment instructions.  | 
|  std\$1terms\$1agreement  |  string  |  No  |  Agreement between company and vendor.  | 
|  std\$1terms\$1agreement\$1ver  |  string  |  No  |  Version of agreement between company and vendor.  | 
|  agreement\$1number  |  string  |  No  |  Number associated with contract or agreement.  | 
|  inbound\$1order\$1url  |  string  |  No  |  URL to access inbound order 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.  | 

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 | 
| to\$1site\$1id | Network | site | id |