supply_plan
Primary key (PK)
The table below lists the colum names that are uniquely identified in the data entity.
Name | Column |
---|---|
supply_plan | supply_plan_id |
The table below lists the column names supported by the data entity:
Column | Data type | Required | Description |
---|---|---|---|
supply_plan_id |
string |
Yes |
Supply plan ID. |
company_id1 |
string |
No |
Company ID. |
plan_uuid |
string |
No |
Unique plan identifier generated by the application. To be only used if this ID is separate from supply_plan_id. |
snapshot_date |
timestamp |
No |
Date and time till when data is collected. |
creation_date |
timestamp |
No |
Date and time till when plan was created. |
status |
string |
No |
Supply plan status. |
tpartner_id1 |
string |
No |
Trading partner ID. For example, contract Manufacturer, or supplier in n-tier network. |
product_id1 |
string |
No |
Product ID. |
product_group_id1 |
string |
No |
Product group ID. |
to_site_id1 |
string |
No |
Site where the order will arrive. |
from_site_id1 |
string |
No |
Site where order line originates. |
plan_need_by_date |
timestamp |
No |
Future date and time by when supply is needed at to_site_id. |
plan_quantity |
double |
No |
Planned quantity |
commit_date |
timestamp |
No |
Date committed by tpartner against the plan_date. |
commit_quantity |
double |
No |
Quantity committed by tpartner. |
supply_upside |
double |
No |
Upside capacity published by the supplier. |
plan_type |
string |
No |
Type of plan. For example, Forecast Commit, Supplier Plan. |
plan_window_start |
timestamp |
No |
If plan corresponds to a planning bucket or window in application, this field stores the start of the planning window. |
plan_window_end |
timestamp |
No |
If plan corresponds to a planning bucket or window in application, this field stores the end of the planning window. |
source |
string |
No |
Source of data. |
production_process_id1 |
string |
No |
ID associated with a specific production process. |
plan_cycle_sequence |
double |
No |
Sequence number of the plan cycle for a particular order. |
quantity_uom |
string |
No |
UOM associated with the quantity. |
plan_id |
string |
No |
Recurring plan that covers multiple supply plan records. |
plan_sequence_id |
string |
No |
Unique identifier or sequence number assigned to each individual supply plan or supply plan version. |
plan_cost |
double |
No |
Estimated or projected cost associated with a particular supply plan. This cost includes various factors such as raw material costs, labor costs, transportation costs, storage costs, and any other relevant expenses involved in executing the supply plan. It provides a financial measure to assess the viability and feasibility of the planned supply activities. |
required_date |
timestamp |
No |
Date when you are required to execute a plan under a specific supply_plan generated by supply planning. |
production_process_id |
string |
No |
ID associated with a specific production process. |
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. |
total_supply_quantity |
double |
No |
The total supply expected to be delivered on the plan_need_by_date. |
projected_inventory_level |
double |
No |
Inventory quantity projected based on the plan_need_by_date. |
target_inventory_level |
double |
No |
The target inventory level on the required_date. |
1Foreign 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 |
status | Organization | trading_partner | id |
product_group_id | Product | product_hierarchy | id |
to_site_id, from_site_id | Network | site | id |
production_process_id | Operation | production_process | production_process_id |