Request Name :- Batch Start Time; Batch Start; Request Start Time:- 3/20/2026 11:18:31 PM; Request Name :- Item Colors 0; Item Colors Flexi Field :- 0; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:31 PM; Request Name :- Item Colors 0; Item Colors Flexi Field :- 0; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:31 PM; Request Name :- Item Colors 0; Item Colors Flexi Field :- 0; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:31 PM; Request Name :- Item Colors 0; Item Colors Flexi Field :- 0; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:31 PM; Request Name :- Item Colors 0; Item Colors Flexi Field :- 0; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:31 PM; Request Name :- Item Colors 0; Item Colors Flexi Field :- 0; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:31 PM; Request Name :- Item Colors 0; Item Colors Flexi Field :- 0; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:31 PM; Request Name :- Item Colors 0; Item Colors Flexi Field :- 0; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:31 PM; Request Name :- Item Colors 0; Item Colors Flexi Field :- 0; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:31 PM; Request Name :- Item Colors 0; Item Colors Flexi Field :- 0; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:31 PM; Request Name :- CustomList-Search; CustomList :- ,; Request Start Time:- 3/20/2026 11:18:31 PM; Request Name :- Item Colors 0; Item Colors Flexi Field CustomList :- 0; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:31 PM; Request Name :- Item Colors 0; Item Colors Flexi Field :- 0; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:31 PM; Request Name :- Item Colors 0; Item Colors Flexi Field :- 0; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:31 PM; Request Name :- Item Colors 0; Item Colors Flexi Field :- 0; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:31 PM; Request Name :- CustomList-Search; CustomList :- Footwear,Footwear; Request Start Time:- 3/20/2026 11:18:31 PM; Request Name :- customList-Search; CustomList :- 6; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:31 PM; Request Name :- Item Colors 0; Item Colors Flexi Field CustomList :- 6; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:31 PM; Request Name :- CustomList-Search; CustomList :- Winter,Winter; Request Start Time:- 3/20/2026 11:18:31 PM; Request Name :- customList-Search; CustomList :- 133; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:32 PM; Request Name :- Item Colors 0; Item Colors Flexi Field CustomList :- 133; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:32 PM; Request Name :- Item Colors 0; Item Colors Flexi Field :- 0; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:32 PM; Request Name :- CustomList-Search; CustomList :- High Boots,High Boots; Request Start Time:- 3/20/2026 11:18:32 PM; Request Name :- customList-Search; CustomList :- 23; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:32 PM; Request Name :- Item Colors 0; Item Colors Flexi Field CustomList :- 23; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:32 PM; Request Name :- Item Colors 0; Item Colors Flexi Field :- 0; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:32 PM; Request Name :- Item Colors 417851143217; Item Colors Flexi Field :- 0; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:32 PM; Request Name :- CustomList-Search; CustomList :- WI26 3,WI26 3; Request Start Time:- 3/20/2026 11:18:32 PM; Request Name :- customList-Search; CustomList :- 49; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:32 PM; Request Name :- Item Colors 417851143217; Item Colors Flexi Field CustomList :- 49; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:32 PM; Request Name :- Item Colors 417851198041; Item Colors Flexi Field :- 0; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:32 PM; Request Name :- customList-Search; CustomList :- 49; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:32 PM; Request Name :- Item Colors 417851198041; Item Colors Flexi Field CustomList :- 49; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:32 PM; Request Name :- Item Colors Start; Item Colors ; Request Start Time:- 3/20/2026 11:18:32 PM; Request Name :- UPSERT INITIALISE; Available Count Block ; Request Start Time:- 3/20/2026 11:18:32 PM; Request Name :- UPSERT INITIALISE; Available Count Block :- 2,2; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:32 PM; Request Name :- Item Colors Start; Item Colors :- 1107473; Request Start Time:- 3/20/2026 11:18:32 PM; Request Name :- Item Colors 417851143217; Item Colors FieldName :- subsidiary,FieldValue :- 1; Request Start Time:- 3/20/2026 11:18:32 PM; Request Name :- Item Colors 417851143217; Item Colors Subsidiary Field ; Request Start Time:- 3/20/2026 11:18:32 PM; Request Name :- Item Colors 417851143217; Item Colors Subsidiary Field :- 1; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:32 PM; Request Name :- Supplier-Search; Supplier; Request Start Time:- 3/20/2026 11:18:32 PM; Request Name :- Supplier-Search; Supplier; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:33 PM; Request Name :- Item Colors 417851143217; Item Colors FieldName :- custitem_psgss_merc_division,FieldValue :- WOMENS|1; Request Start Time:- 3/20/2026 11:18:33 PM; Request Name :- Item Colors 417851143217; Item Colors Select Field ; Request Start Time:- 3/20/2026 11:18:33 PM; Request Name :- Item Colors 417851143217; Item Colors Select Field :- 1; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:33 PM; Request Name :- Item Colors 417851143217; Item Colors FieldName :- custitem_psgss_merc_class,FieldValue :- Shoes|25; Request Start Time:- 3/20/2026 11:18:33 PM; Request Name :- Item Colors 417851143217; Item Colors Select Field ; Request Start Time:- 3/20/2026 11:18:33 PM; Request Name :- Item Colors 417851143217; Item Colors Select Field :- 25; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:33 PM; Request Name :- Item Colors 417851143217; Item Colors FieldName :- custitem_psgss_merc_subclass,FieldValue :- Shoes|1049; Request Start Time:- 3/20/2026 11:18:33 PM; Request Name :- Item Colors 417851143217; Item Colors Select Field ; Request Start Time:- 3/20/2026 11:18:33 PM; Request Name :- Item Colors 417851143217; Item Colors Select Field :- 1049; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:33 PM; Request Name :- Item Colors 417851143217; Item Colors FieldName :- custitem_ab_care_instruction,FieldValue :- ; Request Start Time:- 3/20/2026 11:18:33 PM; Request Name :- Item Colors 417851143217; Item Colors FieldName :- custitem_psgss_merc_dept,FieldValue :- Non-Apparel; Request Start Time:- 3/20/2026 11:18:33 PM; Request Name :- Item Colors 417851143217; Item Colors Flexi Field ; Request Start Time:- 3/20/2026 11:18:33 PM; Request Name :- Item Colors 417851143217; Item Colors FieldName :- custitem_ab_pd_category,FieldValue :- Footwear; Request Start Time:- 3/20/2026 11:18:33 PM; Request Name :- Item Colors 417851143217; Item Colors Flexi Field ; Request Start Time:- 3/20/2026 11:18:33 PM; Request Name :- Item Colors 417851143217; Item Colors FieldName :- custitem_ab_merch_category,FieldValue :- High Boots|23; Request Start Time:- 3/20/2026 11:18:33 PM; Request Name :- Item Colors 417851143217; Item Colors Flexi Field ; Request Start Time:- 3/20/2026 11:18:33 PM; Request Name :- Item Colors 417851143217; Item Colors FieldName :- custitem_ab_original_item_collection,FieldValue :- Winter; Request Start Time:- 3/20/2026 11:18:33 PM; Request Name :- Item Colors 417851143217; Item Colors Flexi Field ; Request Start Time:- 3/20/2026 11:18:33 PM; Request Name :- Item Colors 417851143217; Item Colors FieldName :- custitem_original_season,FieldValue :- CASE WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP26 1' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP26 2' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP26 3' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP26 CO' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU26 1' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU26 2' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU26 3' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU26 CO' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 1' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 2' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 3' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 CO' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI26 1' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI26 2' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI26 3' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 PERM' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 CO' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 PERM' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA27 1' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA27 2' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA27 3' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA28 1' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA28 2' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA28 3' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA29 1' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA29 2' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA29 3' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA30 1' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA30 2' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA30 3' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 1' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 2' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 3' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP28 1' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP28 2' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP28 3' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP29 1' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP29 2' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP29 3' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP30 1' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP30 2' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP30 3' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU27 1' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU27 2' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU27 3' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU28 1' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU28 2' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU28 3' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU29 1' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU29 2' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU29 3' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU30 1' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU30 2' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU30 3' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI27 1' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI27 2' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI27 3' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI28 1' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI28 2' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI28 3' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI29 1' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI29 2' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI29 3' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI30 1' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI30 2' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI30 3' THEN 461 ELSE 0 END; Request Start Time:- 3/20/2026 11:18:33 PM; Request Name :- Item Colors 417851143217; Item Colors Select Field ; Request Start Time:- 3/20/2026 11:18:33 PM; Request Name :- Item Colors 417851143217; Item Colors Select Field :- CASE WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP26 1' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP26 2' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP26 3' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP26 CO' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU26 1' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU26 2' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU26 3' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU26 CO' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 1' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 2' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 3' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 CO' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI26 1' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI26 2' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI26 3' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 PERM' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 CO' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 PERM' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA27 1' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA27 2' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA27 3' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA28 1' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA28 2' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA28 3' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA29 1' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA29 2' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA29 3' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA30 1' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA30 2' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA30 3' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 1' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 2' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 3' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP28 1' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP28 2' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP28 3' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP29 1' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP29 2' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP29 3' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP30 1' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP30 2' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP30 3' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU27 1' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU27 2' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU27 3' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU28 1' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU28 2' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU28 3' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU29 1' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU29 2' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU29 3' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU30 1' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU30 2' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU30 3' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI27 1' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI27 2' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI27 3' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI28 1' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI28 2' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI28 3' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI29 1' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI29 2' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI29 3' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI30 1' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI30 2' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI30 3' THEN 461 ELSE 0 END; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:33 PM; Request Name :- Item Colors 417851143217; Item Colors FieldName :- custitem_ab_original_drop,FieldValue :- WI26 3; Request Start Time:- 3/20/2026 11:18:33 PM; Request Name :- Item Colors 417851143217; Item Colors Flexi Field ; Request Start Time:- 3/20/2026 11:18:33 PM; Request Name :- Item Colors 417851143217; Item Colors externalId :- ArticleColors417851143217; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:33 PM; Request Name :- Item Colors 1107473; Item Colors 3; Request Start Time:- 3/20/2026 11:18:33 PM; Request Name :- Item Colors Start; Item Colors :- 1107474; Request Start Time:- 3/20/2026 11:18:33 PM; Request Name :- Item Colors 417851198041; Item Colors FieldName :- subsidiary,FieldValue :- 1; Request Start Time:- 3/20/2026 11:18:33 PM; Request Name :- Item Colors 417851198041; Item Colors Subsidiary Field ; Request Start Time:- 3/20/2026 11:18:33 PM; Request Name :- Item Colors 417851198041; Item Colors Subsidiary Field :- 1; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:33 PM; Request Name :- Supplier-Search; Supplier; Request Start Time:- 3/20/2026 11:18:33 PM; Request Name :- Supplier-Search; Supplier; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:34 PM; Request Name :- Item Colors 417851198041; Item Colors FieldName :- custitem_psgss_merc_division,FieldValue :- WOMENS|1; Request Start Time:- 3/20/2026 11:18:34 PM; Request Name :- Item Colors 417851198041; Item Colors Select Field ; Request Start Time:- 3/20/2026 11:18:34 PM; Request Name :- Item Colors 417851198041; Item Colors Select Field :- 1; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:34 PM; Request Name :- Item Colors 417851198041; Item Colors FieldName :- custitem_psgss_merc_class,FieldValue :- Shoes|25; Request Start Time:- 3/20/2026 11:18:34 PM; Request Name :- Item Colors 417851198041; Item Colors Select Field ; Request Start Time:- 3/20/2026 11:18:34 PM; Request Name :- Item Colors 417851198041; Item Colors Select Field :- 25; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:34 PM; Request Name :- Item Colors 417851198041; Item Colors FieldName :- custitem_psgss_merc_subclass,FieldValue :- Shoes|1049; Request Start Time:- 3/20/2026 11:18:34 PM; Request Name :- Item Colors 417851198041; Item Colors Select Field ; Request Start Time:- 3/20/2026 11:18:34 PM; Request Name :- Item Colors 417851198041; Item Colors Select Field :- 1049; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:34 PM; Request Name :- Item Colors 417851198041; Item Colors FieldName :- custitem_ab_care_instruction,FieldValue :- ; Request Start Time:- 3/20/2026 11:18:34 PM; Request Name :- Item Colors 417851198041; Item Colors FieldName :- custitem_psgss_merc_dept,FieldValue :- Non-Apparel; Request Start Time:- 3/20/2026 11:18:34 PM; Request Name :- Item Colors 417851198041; Item Colors Flexi Field ; Request Start Time:- 3/20/2026 11:18:34 PM; Request Name :- Item Colors 417851198041; Item Colors FieldName :- custitem_ab_pd_category,FieldValue :- Footwear; Request Start Time:- 3/20/2026 11:18:34 PM; Request Name :- Item Colors 417851198041; Item Colors Flexi Field ; Request Start Time:- 3/20/2026 11:18:34 PM; Request Name :- Item Colors 417851198041; Item Colors FieldName :- custitem_ab_merch_category,FieldValue :- High Boots|23; Request Start Time:- 3/20/2026 11:18:34 PM; Request Name :- Item Colors 417851198041; Item Colors Flexi Field ; Request Start Time:- 3/20/2026 11:18:34 PM; Request Name :- Item Colors 417851198041; Item Colors FieldName :- custitem_ab_original_item_collection,FieldValue :- Winter; Request Start Time:- 3/20/2026 11:18:34 PM; Request Name :- Item Colors 417851198041; Item Colors Flexi Field ; Request Start Time:- 3/20/2026 11:18:34 PM; Request Name :- Item Colors 417851198041; Item Colors FieldName :- custitem_original_season,FieldValue :- CASE WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP26 1' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP26 2' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP26 3' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP26 CO' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU26 1' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU26 2' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU26 3' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU26 CO' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 1' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 2' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 3' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 CO' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI26 1' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI26 2' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI26 3' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 PERM' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 CO' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 PERM' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA27 1' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA27 2' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA27 3' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA28 1' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA28 2' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA28 3' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA29 1' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA29 2' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA29 3' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA30 1' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA30 2' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA30 3' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 1' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 2' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 3' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP28 1' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP28 2' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP28 3' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP29 1' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP29 2' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP29 3' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP30 1' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP30 2' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP30 3' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU27 1' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU27 2' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU27 3' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU28 1' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU28 2' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU28 3' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU29 1' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU29 2' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU29 3' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU30 1' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU30 2' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU30 3' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI27 1' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI27 2' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI27 3' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI28 1' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI28 2' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI28 3' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI29 1' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI29 2' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI29 3' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI30 1' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI30 2' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI30 3' THEN 461 ELSE 0 END; Request Start Time:- 3/20/2026 11:18:34 PM; Request Name :- Item Colors 417851198041; Item Colors Select Field ; Request Start Time:- 3/20/2026 11:18:34 PM; Request Name :- Item Colors 417851198041; Item Colors Select Field :- CASE WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP26 1' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP26 2' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP26 3' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP26 CO' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU26 1' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU26 2' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU26 3' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU26 CO' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 1' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 2' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 3' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 CO' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI26 1' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI26 2' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI26 3' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 PERM' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 CO' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 PERM' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA27 1' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA27 2' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA27 3' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA28 1' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA28 2' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA28 3' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA29 1' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA29 2' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA29 3' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA30 1' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA30 2' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA30 3' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 1' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 2' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 3' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP28 1' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP28 2' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP28 3' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP29 1' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP29 2' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP29 3' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP30 1' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP30 2' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP30 3' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU27 1' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU27 2' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU27 3' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU28 1' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU28 2' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU28 3' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU29 1' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU29 2' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU29 3' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU30 1' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU30 2' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU30 3' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI27 1' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI27 2' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI27 3' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI28 1' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI28 2' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI28 3' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI29 1' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI29 2' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI29 3' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI30 1' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI30 2' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI30 3' THEN 461 ELSE 0 END; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:34 PM; Request Name :- Item Colors 417851198041; Item Colors FieldName :- custitem_ab_original_drop,FieldValue :- WI26 3; Request Start Time:- 3/20/2026 11:18:34 PM; Request Name :- Item Colors 417851198041; Item Colors Flexi Field ; Request Start Time:- 3/20/2026 11:18:34 PM; Request Name :- Item Colors 417851198041; Item Colors externalId :- ArticleColors417851198041; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:34 PM; Request Name :- Item Colors 1107474; Item Colors 4; Request Start Time:- 3/20/2026 11:18:34 PM; Request Name :- Upsert; Upsert Netsuite Records ; Request Start Time:- 3/20/2026 11:18:34 PM; Request Name :- Upsert Successfull; Upsert Netsuite Records 1; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:37 PM; Request Name :- Item Colors End; Item Colors :- 1107473; ErrorMsg:- ERROR :- [Code=INVALID_KEY_OR_REF] Invalid custitem_original_season reference key CASE WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP26 1' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP26 2' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP26 3' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP26 CO' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU26 1' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU26 2' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU26 3' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU26 CO' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 1' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 2' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 3' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 CO' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI26 1' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI26 2' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI26 3' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 PERM' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 CO' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 PERM' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA27 1' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA27 2' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA27 3' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA28 1' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA28 2' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA28 3' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA29 1' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA29 2' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA29 3' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA30 1' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA30 2' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA30 3' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 1' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 2' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 3' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP28 1' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP28 2' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP28 3' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP29 1' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP29 2' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP29 3' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP30 1' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP30 2' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP30 3' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU27 1' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU27 2' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU27 3' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU28 1' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU28 2' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU28 3' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU29 1' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU29 2' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU29 3' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU30 1' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU30 2' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU30 3' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI27 1' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI27 2' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI27 3' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI28 1' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI28 2' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI28 3' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI29 1' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI29 2' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI29 3' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI30 1' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI30 2' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI30 3' THEN 461 ELSE 0 END. ; Response End Time:- 3/20/2026 11:18:37 PM; Request Name :- Item Colors End; Item Colors :- 1107474; ErrorMsg:- ERROR :- [Code=INVALID_KEY_OR_REF] Invalid custitem_original_season reference key CASE WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP26 1' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP26 2' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP26 3' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP26 CO' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU26 1' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU26 2' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU26 3' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU26 CO' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 1' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 2' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 3' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 CO' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI26 1' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI26 2' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI26 3' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 PERM' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 CO' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 PERM' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA27 1' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA27 2' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA27 3' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA28 1' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA28 2' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA28 3' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA29 1' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA29 2' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA29 3' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA30 1' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA30 2' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA30 3' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 1' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 2' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 3' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP28 1' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP28 2' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP28 3' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP29 1' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP29 2' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP29 3' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP30 1' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP30 2' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP30 3' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU27 1' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU27 2' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU27 3' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU28 1' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU28 2' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU28 3' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU29 1' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU29 2' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU29 3' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU30 1' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU30 2' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU30 3' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI27 1' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI27 2' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI27 3' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI28 1' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI28 2' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI28 3' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI29 1' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI29 2' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI29 3' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI30 1' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI30 2' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI30 3' THEN 461 ELSE 0 END. ; Response End Time:- 3/20/2026 11:18:37 PM; Request Name :- UPSERT NEXT; Available Count Block ; Request Start Time:- 3/20/2026 11:18:38 PM; Request Name :- UPSERT NEXT; Available Count Block :- 0,2; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:38 PM; Request Name :- Item Colors End; Item Colors ; ErrorMsg:- ERROR :- [Code=INVALID_KEY_OR_REF] Invalid custitem_original_season reference key CASE WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP26 1' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP26 2' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP26 3' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP26 CO' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU26 1' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU26 2' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU26 3' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU26 CO' THEN 152 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 1' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 2' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 3' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 CO' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI26 1' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI26 2' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI26 3' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA26 PERM' THEN 151 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 CO' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 PERM' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA27 1' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA27 2' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA27 3' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA28 1' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA28 2' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA28 3' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA29 1' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA29 2' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA29 3' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA30 1' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA30 2' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'FA30 3' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 1' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 2' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP27 3' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP28 1' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP28 2' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP28 3' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP29 1' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP29 2' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP29 3' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP30 1' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP30 2' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SP30 3' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU27 1' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU27 2' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU27 3' THEN 456 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU28 1' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU28 2' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU28 3' THEN 458 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU29 1' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU29 2' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU29 3' THEN 460 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU30 1' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU30 2' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Spring/Summer' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'SU30 3' THEN 462 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI27 1' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI27 2' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI27 3' THEN 455 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI28 1' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI28 2' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI28 3' THEN 457 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI29 1' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI29 2' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI29 3' THEN 459 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI30 1' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI30 2' THEN 461 WHEN 'Articles.article_cust_seasons_name' = 'Fall/Winter' AND 'ArticleColors.articlecolor_cust_monthlydrops_name' = 'WI30 3' THEN 461 ELSE 0 END. ; Response End Time:- 3/20/2026 11:18:38 PM; Request Name :- Batch End Time; Batch End ; ErrorMsg:- ; Response End Time:- 3/20/2026 11:18:38 PM;