supply_plan - AWS Supply Chain

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