Input Validations: Allocation & IST

Store List

Columns	Validations

Columns	Validations
channel	channel and store_code combination must be unique. channel must be present in the store master.
store_code	store must be present in store master belonging to the same channel. store_code needs to be enabled in the store_configs before being enabled here. In case of IST, the dist_enabled needs to be 1 before enabling the inwards or outwards flag.

Warehouse Store Category Map

Maximum Allowed SKU Depth

Note: Download the template to get the entire channel+store+category combination for all stores and categories enabled.

Columns	Validations

Columns	Validations
channel	channel and store_code combination must be unique. channel must be present in the store master.
store_code	store must be present in store master belonging to the same channel.
category	category must be present in the style master

Warehouse Planogram

Exclusion List

Columns	Validations

Columns	Validations
channel	channel, store_code and style_code combination must be unique. channel must be present in the store master.
store_code	store must be present in store master belonging to the same channel.
style_code	style code must be present style master

Inclusion List

Column	Validations

Column	Validations
channel	channel, store_code and style_code combination must be unique. channel must be present in store master.
store_code	store must be present in store master belonging to the same channel.
style_code	style_code must be present in the style master.
store	255 character limit.

JIT Style Depth Override

Style wise reserve percentage

Columns	Validations

Columns	Validations
style_code	style_code and channel combination must be unique.
channel	channel must be present in master
reserve_percentage	it is an integer. value should not be less than zero.

Style wise Pack Sizes

Store Style Depth Override

Columns	Validations

Columns	Validations
channel	channel, store_code and style_code combination must be unique.
store_code	store must be present in store master.
style_code	style must be present in style master.
depth	it is an integer should be greater than zero.
store	255 char limit.

Style Level Merchandise Tagging

Story Style List

Story Category Combination Priority

Story Category Min Options Requirement

Pullbacks Constraint

Columns	Validations

Columns	Validations
category	category should be unique. category should be present in style master.
max_sale_qty	it is a double value. it should be greater than zero.
bottom_seller_multiplier	it is a double value. it should be greater than zero.
min_plano_fill_rate	it is a double value. it should be greater than zero.
bottom_seller_disc_multiplier	it is a double value. it should be greater than zero.

MS Enterprise Public