inv_policy

id

string

Yes

Policy ID.

site_id²

string

Yes¹

Site ID for the policy being defined.

product_id²

string

Yes¹

Product ID for the policy being defined.

company_id²

string

No

Company ID.

product_group_id²

string

Yes¹

Product group ID that the policies are being defined for. Overridden at product level.

dest_geo_id²

string

Yes¹

Sets default values at geo level of the destination.

vendor_tpartner_id²

string

Yes¹

Trading partner ID of the vendor. This field is used when policies vary by vendor.

status

string

No

Status of the inventory policy record, for example, on-hold, or active.

ss_policy

string

No

Type of safety stock policy. The safety stock policy is associated with corresponding data.

abs_level – Uses units specified in min/max safety stock (SS). Source is customer system or external tool. Ordering is suggested whenever inventory falls below min SS level.

sl – Targets inventory between min and max service level for in-stock percentages. For example, if min/max service level is 50% and 90%, ordering will be done to maintain inventory between these percentiles of forecast over plan horizon.

DOC_dem – Uses days of cover computed from historical demand as target level of inventory.

DOC_fcst – Uses days of cover computed from forecast as target level of inventory.

fallback_policy_1

string

No

Fallback inventory policy.

repl_interval

double

No

Specifies the replenishment interval.

min_safety_stock

double

No

For safety stock policy "abs_level". This field is absolute value of minimum safety stock level.

max_safety_stock

double

No

For safety stock policy "abs_level". This is absolute value of maximum safety stock level.

min_inventory_qty

double

No

Minimum inventory level quantity threshold.

max_inventory_qty

double

No

Maximum inventory level quantity threshold.

target_inventory_qty

double

No

Target inventory level quantity.

woc_limit

double

No

Provides the weeks of cover limit.

max_doc_limit

double

No

Provides the maximum days of cover value for safety stock policies "DOC_dem" and "DOC_fcst".

min_doc_limit

double

No

Provides the minimum days of cover value for safety stock policies "DOC_dem" and "DOC_fcst".

target_doc_limit

double

No

Provides the target value for safety stock policies "DOC_dem" and "DOC_fcst".

permitted_var

double

No

Allowed variance used in policies where deviations from min,max, and target is allowed.

min_sl

No

Provides minimum service level (sl). Used for safety stock policy sl.

target_sl

double

No

Target service level used of policy sl.

max_sl

double

No

Provides maximum service level (sl). Used for safety stock policy.

qty_uom

string

No

Quantity UOM associated with this inventory policy.

min_order_qty

double

No

Minimum order quantity.

max_order_qty

double

No

Maximum order quantity.

order_qty_multiple

double

No

Order quantity computed in multiples of this value.

holding_cost_percent

double

No

Annualized holding cost of inventory in percent.

eff_start_date

timestamp

Yes¹

Dates from when the record is effective.

eff_end_date

timestamp

Yes¹

Dates till when the record is effective.

salvage_value_percentage

double

No

Product cost that can be expected to recovered at the end of Long Term Horizon.

segment_id ²

string

No

ID of segment associated with the inventory policy

demand_planning_enabled

string

No

Identifies parts used for demand planning.

inventory_planning_enabled

string

No

Identifies parts used for inventory planning.

mrp_enabled

string

No

Identifies parts enabled for planning in MRP.

purchased_item

string

No

Identifies parts that are purchased.

source

string

No

Source of data.

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.