Store Targets
| Columns | Validations |
|---|---|
| brand | brand, channel, store_code and month combination must be unique. |
| channel | 255 char limit. |
| store_code | store should be present in storemap. |
| month | should be in the format of yyyy-mm-dd. |
| target | it is a double value. |
| value should not be less than zero. |
Category Key Sizes
| Columns | Validations |
|---|---|
| category | category and sub_category combination must be unique. |
| should be present in as key in the catsubcatmap. | |
| sub_category | value should be present in set of sub categories for the given category. |
| sizeset_1 | 255 char limit. |
| sizeset_2 | 255 char limit. |
| sizeset_3 | 255 char limit. |
| sizeset_4 | 255 char limit. |
Retail Calendar
| Columns | Validations |
|---|---|
| start_date | should be in the format of yyyy-mm-dd. |
| Retail week start date must be " + weekStart | |
| end_date | should be in the format of yyyy-mm-dd. |
| end_date should not be before start_date. | |
| Retail week end date must be " + weekEnd | |
| retail_week | retail_week and financial_yr combination must be unique. |
| it is an integer. | |
| value should not be less than zero. | |
| financial_yr | 255 char limit. |
| season | season should be present in season set of styles seasons mapping. |
Style Level Merchandise Tagging
| Columns | Validations |
|---|---|
| channel | channel and style_code combination must be unique. |
| channel should be present in channelStoremap. | |
| style_code | style should be present in style map. |
| style_tag | 255 char limit. |
Buy Quantity
| Columns | Validations |
|---|---|
| channel | channel, store_code and style_code combination must be unique. |
| store_code | store_code should be present in storemap. |
| store | 255 char limit. |
| style_code | style_code should be present in sylemap. |
| buy_quantity | it is an integer. |
| value should not be less than zero. |