inbound_order_line_schedule - AWS Supply Chain

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.

  • Can celled - Populated in SAP mapping. Also used for deleted.

  • Open - Not populated in SAP mapping.

  • Closed - Not populated in SAP mapping.

  • InTransit - Not populated in SAP mapping.

  • Confirmed - Not populated in SAP mapping.

Note

Null 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