inbound_order
Primary key (PK)
The table below lists the colum names that are uniquely identified in the data entity.
| Name | Column |
|---|---|
| inbound_order | id, tpartner_id |
The table below lists the column names supported by the data entity:
| Column | Data type | Required | Description |
|---|---|---|---|
|
id |
string |
Yes 1 |
Object ID. |
|
company_id2 |
string |
No |
Company ID. |
|
order_creation_date |
timestamp |
No |
Order creation date. |
|
order_type |
string |
No |
Displays the type of order. Reserved order types in AWS Supply Chain:
|
|
order_status |
string |
No |
Status of the order. |
|
to_site_id2 |
string |
No |
Site where the order will arrive. |
|
tpartner_id2 |
string |
Yes1 |
Trading partner that the order will be sent to. |
|
order_currency_uom |
string |
No |
Currency UOM that the company uses. |
|
vendor_currency_uom |
string |
No |
Currency UOM that the vendor uses. |
|
exchange_rate |
double |
No |
Exchange rate used for conversion. |
|
exchange_rate_date |
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_location_1 |
string |
No |
Incoterm location 1. Can be a site_id or the location used on order/EDI. |
|
incoterm_location_2 |
string |
No |
Incoterm location 2. Can be a site_id or the location used on order/EDI. |
|
submitted_date |
timestamp |
No |
Date and time when order was submitted to vendor. |
|
agreement_start_date |
timestamp |
No |
If PO is associated with contract or agreement, then start datetime of contract. |
|
agreement_end_date |
timestamp |
No |
If PO is associated with contract or agreement, then end datetime of contract. |
|
shipping_instr_code |
string |
No |
Code for shipping instructions. |
|
payment_terms_code |
string |
No |
Code for payment instructions. |
|
std_terms_agreement |
string |
No |
Agreement between company and vendor. |
|
std_terms_agreement_ver |
string |
No |
Version of agreement between company and vendor. |
|
agreement_number |
string |
No |
Number associated with contract or agreement. |
|
inbound_order_url |
string |
No |
URL to access inbound order record in source system. |
|
source_update_dttm |
timestamp |
No |
Date time stamp of the update made in the source system. |
|
source_event_id |
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_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 |
|---|---|---|---|
| tpartner_id | Organization | trading_partner | id |
| company_id | Organization | company | id |
| to_site_id | Network | site | id |
