inbound_order_line
Primary key (PK)
The table below lists the colum names that are uniquely identified in the data entity.
| Name | Column |
|---|---|
| inbound_order_line | id, order_id, tpartner_id, product_id |
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_id2 |
string |
Yes1 |
ID of parent order. |
|
company_id2 |
string |
No |
Company ID. |
|
tpartner_id2 |
string |
Yes1 |
Partner that the order will be sent to. |
|
line_creation_date |
timestamp |
No |
Line creation date. |
|
product_id2 |
string |
Yes1 |
Product ID. |
|
product_group_id2 |
string |
No |
Product group ID. |
|
supplier_product_id |
string |
No |
Product number used by supplier. |
|
order_type |
string |
No |
Type of order. |
|
external_line_number |
string |
No |
Alternate line number if used by customer system. |
|
status |
string |
No |
Status of the line, for example, canceled, closed, or open. |
|
from_site_id2 |
string |
No |
Site where order line originates. |
|
to_site_id2 |
string |
No |
Site where the order will arrive. |
|
vendor_status |
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_uom |
string |
No |
Cost UOM in company's currency. |
|
submitted_cost |
double |
No |
Cost of the product at the time of submission, in company's currency. |
|
submitted_cost_vendor |
double |
No |
Cost of the product at the time of submission, in vendor's currency. |
|
shipping_cost |
double |
No |
Inbound shipping cost from vendor to company. |
|
tax_cost |
double |
No |
Tax cost for the product. |
|
quantity_submitted |
double |
Yes |
Quantity submitted to vendor. |
|
quantity_confirmed |
double |
No |
Quantity confirmed by the vendor. |
|
quantity_received |
double |
No |
Quantity received into inventory. |
|
quantity_uom |
string |
No |
Quantity UOM for the order line. |
|
submitted_date |
timestamp |
No |
Date and time when the order was submitted to vendor. |
|
expected_delivery_date |
timestamp |
No |
Date when the order is expected to be delivered. |
|
confirmation_date |
timestamp |
No |
Date and time when the order was confirmed by the vendor. |
|
earliest_ship_date |
timestamp |
No |
Earliest date and time when the vendor can ship products in this order. |
|
latest_ship_date |
timestamp |
No |
Latest date and time when the vendor can ship products in this order. |
|
earliest_delivery_date |
timestamp |
No |
Earliest date and time when the vendor can deliver products in this order. |
|
latest_delivery_date |
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_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. |
|
requisition_number |
string |
No |
Requisition number. |
|
order_receive_date |
timestamp |
No |
Date and time when the order is unloaded into the company location. |
|
reservation_id2 |
string |
No |
Reservation ID associated with the line. |
|
reference_object |
string |
No |
If record is created by or in response to another object / entity, then enter the entity name. For example, inbound_order, outbound_order |
|
reference_object_type |
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_object_id |
string |
No |
ID of associated reference object. |
|
reference_detail_id |
string |
No |
ID of associated reference object ID's detail/line, if any. |
|
inbound_order_line_url |
string |
No |
URL to access inbound order line 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. |
|
sap_lips__vbeln |
string |
No |
Delivery Number. Predicate key for SAP mapping. Upsert key for VTTP, LIKP. |
|
sap_vttp__tknum |
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_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 |
| product_id | Product | product | id |
| from_site_id | Network | site | id |
| product_group_id | Product | product_hierarchy | id |
| order_id | Inbound | inbound_order | id |
| reservation_id | Planning | reservation | reservation_id |
