Skip to end of banner
Go to start of banner

Revenue contribution Override

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 »

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.

  • No labels