inbound_order_line_schedule
Primary key (PK)
The table below lists the colum names that are uniquely identified in the data entity.
Name | Column |
---|---|
inbound_order_line_schedule | id, order_id, order_line_id, product_id |
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_id2 |
string |
Yes 1 |
ID of parent order. |
order_line_id2 |
string |
Yes |
ID of parent order line. |
company_id2 |
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.
NoteNull is also an accepted value, or you can enter your own value. |
schedule_creation_date |
timestamp |
No |
Schedule creation date. |
product_id2 |
string |
Yes 1 |
Product ID. |
external_line_number |
string |
No |
External line number. |
expected_delivery_date |
timestamp |
No |
Expected delivery date of the products. |
confirmation_date |
timestamp |
No |
Date and time when the vendor confirmed the order line schedule, or order. |
goods_issue_date |
timestamp |
No |
Date and time when the material was available at origin to ship. |
material_availability_date |
timestamp |
No |
Date and time when the material was available at origin to ship. |
ship_date |
timestamp |
No |
Date and time when vendor will ship products in this order-line-schedule. |
delivery_date |
timestamp |
No |
Date and time when the vendor can deliver products in this schedule. |
quantity_submitted |
double |
No |
Quantity submitted to vendor (POs) or for transfer. |
quantity_confirmed |
double |
No |
Quantity confirmed by the vendor. |
quantity_received |
double |
No |
Quantity received into inventory at the destination. |
sap_lips__vbeln |
string |
No |
Delivery Number. Predicate key for SAP mapping. Upsert key for VTTP |
sap_vttp__tknum |
string |
No |
Shipment Number. Predicate key for SAP mapping. Upsert key for VTTK |
source_event_id |
string |
No |
ID of the event created in the source system. |
source_update_dttm |
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_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 |
---|---|---|---|
company_id | Organization | company | id |
product_id | Product | product | id |
order_id | Inbound | inbound_order | id |
order_line_id | Inbound | inbound_order_line | id |