Columns Validations
channel • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.
• channel must be present in the set of channel that are given in store master
store_code • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.
• store_code must be present in the store master
store • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.
brand • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.
• brand should be present in the set of brands provided in style master.
• It is a mandatory input
category • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.
• category must be present as the key in the style master.
sub_category • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.
• sub_category should be present in the style master
• Cat subcat combination should be present in style master
brand_segment • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.
price_bucket • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.
• price_bucket must be present in the Price bucket input mapped to given category
gender • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.
• gender must be present in the set of genders that are given in the style master.
attribute1 • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.
attribute2 • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.
attribute3 • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.
attribute4 • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.
attribute5 • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.
attribute6 • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.
attribute7 • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.
attribute8 • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.
attribute9 • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.
forecast_period • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.
• it should be an integer.
• it should be present in the od input periods
revenue_contribution • it must be number.