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. |