work_order_plan - AWS Supply Chain

work_order_plan

Primary key (PK)

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

Name Column
work_order_plan process_id, product_id, business_process_id, business_process_sequence

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

Column Data type Required Description

process_id1

string

Yes

Work order ID.

process_product_id

string

No

ID associated with the process and product.

preferred_source

string

No

Describes if the product is sourced from inventory (that is, stocked to forecasted) or from direct purchase (for non-stocked products).

product_id

string

Yes

Product ID (material) in the work order.

business_process_id

string

Yes

Business process identifier. For example, PO, PR, RFQ and so on. Product ID (material) in the work order. The plan should include both the purchasing and distribution business processes.

site_id

string

No

The site linked to the business process. This field is optional for purchasing process and mandatory for distribution related processes.

business_process_sequence

int

Yes

Business process sequence.

duration

int

Yes

Unit in days.

notes

string

No

Additional notes on work order plan.

flex_1

string

No

Plan flexible field 1.

flex_2

string

No

Plan flexible field 2.

flex_3

string

No

Plan flexible field 3.

flex_4

string

No

Plan flexible field 4.

flex_5

string

No

Plan flexible field 5.

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.

1Foreign key

Foreign key (FK)

The table below lists the columns with the associated foreign key.

Column Category FK/Data entity FK/Column
process_id Insights process_header id