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 |
