Skip to end of banner
Go to start of banner

Input Validations: Closing Inventory Projection

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 2 Current »

Warehouse Inwards

Columns

Validations

day

  • warehouse, ean and day combination must be unique.

  • should be in the format of yyyy-mm-dd.

ean

  • ean should be present in ean master

warehouse

  • warehouse should be present in warehouse master

qty

  • it should be an integer.

  • it should not be less than one.

Store Inwards

Columns

Validaitons

channel

  • channel, store_code, day and ean combination should be unique.

store_code

  • Store must be present in store master

store

  • 255 char limit.

ean

  • It should be present in ean master

day

  • It should be in the format of yyyy-mm-dd.

qty

  • It should be an integer.

  • It should not be less than one.

Lead time

Columns

Validations

channel

  • channel, style_code and season combination must be unique.

  • channel should be present in store master.

style_code

  • It should be present in style master

season

  • 255 char limit.

lead_time

  • it should be integer.

  • should not be less than zero.

  • lead time input must be at overall level or channel level but not mixture of both.

  • No labels