Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.