Request Name :- Batch Start Time; Batch Start; Request Start Time:- 1/5/2023 8:37:42 AM; Request Name :- CustomList-Search; CustomList :- CASE WHEN ('CK' = 'AE' AND 'CK' = 'NX') THEN 1 WHEN ('CK' = 'AP' AND 'CK' = 'AP') THEN 3 WHEN ('CK' = 'AO' AND 'CK' = 'AS') THEN 4 WHEN ('CK' = 'BO' AND 'CK' = 'BO') THEN 5 WHEN ('CK' = 'DP' AND 'CK' = 'BO') THEN 5 WHEN ('CK' = 'CG' AND 'CK' = 'CL') THEN 6 WHEN ('CK' = 'CL' AND 'CK' = 'CL') THEN 6 WHEN ('CK' = 'DI' AND 'CK' = 'BW') THEN 8 WHEN ('CK' = 'DU' AND 'CK' = 'DU') THEN 10 WHEN ('CK' = 'FL' AND 'CK' = 'UK') THEN 11 WHEN ('CK' = 'FR' AND 'CK' = 'UK') THEN 13 WHEN ('CK' = 'GT' AND 'CK' = 'GT') THEN 14 WHEN ('CK' = 'LL' AND 'CK' = 'UK') THEN 15 WHEN ('CK' = 'CK' AND 'CK' = 'MC') THEN 21 WHEN ('CK' = 'CW' AND 'CK' = 'MC') THEN 21 WHEN ('CK' = 'HK' AND 'CK' = 'MS') THEN 23 WHEN ('CK' = 'HW' AND 'CK' = 'MS') THEN 23 WHEN ('CK' = 'MK' AND 'CK' = 'MT') THEN 27 WHEN ('CK' = 'MW' AND 'CK' = 'MT') THEN 27 WHEN ('CK' = 'MI' AND 'CK' = 'AS') THEN 4 WHEN ('CK' = 'MC' AND 'CK' = 'UK') THEN 30 WHEN ('CK' = 'ML' AND 'CK' = 'UK') THEN 30 WHEN ('CK' = 'NM' AND 'CK' = 'NX') THEN 1 WHEN ('CK' = 'RA' AND 'CK' = 'BW') THEN 8 WHEN ('CK' = 'RM' AND 'CK' = 'ZL') THEN 19 WHEN ('CK' = 'SD' AND 'CK' = 'SD') THEN 20 WHEN ('CK' = 'TP' AND 'CK' = 'AS') THEN 4 WHEN ('CK' = 'TS' AND 'CK' = 'AS') THEN 4 WHEN ('CK' = 'US' AND 'CK' = 'ZL') THEN 19 WHEN ('CK' = 'WA' AND 'CK' = 'BO') THEN 5 ELSE 0 END,CASE WHEN ('CK' = 'AE' AND 'CK' = 'NX') THEN 1 WHEN ('CK' = 'AP' AND 'CK' = 'AP') THEN 3 WHEN ('CK' = 'AO' AND 'CK' = 'AS') THEN 4 WHEN ('CK' = 'BO' AND 'CK' = 'BO') THEN 5 WHEN ('CK' = 'DP' AND 'CK' = 'BO') THEN 5 WHEN ('CK' = 'CG' AND 'CK' = 'CL') THEN 6 WHEN ('CK' = 'CL' AND 'CK' = 'CL') THEN 6 WHEN ('CK' = 'DI' AND 'CK' = 'BW') THEN 8 WHEN ('CK' = 'DU' AND 'CK' = 'DU') THEN 10 WHEN ('CK' = 'FL' AND 'CK' = 'UK') THEN 11 WHEN ('CK' = 'FR' AND 'CK' = 'UK') THEN 13 WHEN ('CK' = 'GT' AND 'CK' = 'GT') THEN 14 WHEN ('CK' = 'LL' AND 'CK' = 'UK') THEN 15 WHEN ('CK' = 'CK' AND 'CK' = 'MC') THEN 21 WHEN ('CK' = 'CW' AND 'CK' = 'MC') THEN 21 WHEN ('CK' = 'HK' AND 'CK' = 'MS') THEN 23 WHEN ('CK' = 'HW' AND 'CK' = 'MS') THEN 23 WHEN ('CK' = 'MK' AND 'CK' = 'MT') THEN 27 WHEN ('CK' = 'MW' AND 'CK' = 'MT') THEN 27 WHEN ('CK' = 'MI' AND 'CK' = 'AS') THEN 4 WHEN ('CK' = 'MC' AND 'CK' = 'UK') THEN 30 WHEN ('CK' = 'ML' AND 'CK' = 'UK') THEN 30 WHEN ('CK' = 'NM' AND 'CK' = 'NX') THEN 1 WHEN ('CK' = 'RA' AND 'CK' = 'BW') THEN 8 WHEN ('CK' = 'RM' AND 'CK' = 'ZL') THEN 19 WHEN ('CK' = 'SD' AND 'CK' = 'SD') THEN 20 WHEN ('CK' = 'TP' AND 'CK' = 'AS') THEN 4 WHEN ('CK' = 'TS' AND 'CK' = 'AS') THEN 4 WHEN ('CK' = 'US' AND 'CK' = 'ZL') THEN 19 WHEN ('CK' = 'WA' AND 'CK' = 'BO') THEN 5 ELSE 0 END; Request Start Time:- 1/5/2023 8:37:43 AM; Request Name :- Item 32156126280; Item Flexi Field CustomList :- 0; ErrorMsg:- ; Response End Time:- 1/5/2023 8:37:43 AM; Request Name :- CustomList-Search; CustomList :- ,; Request Start Time:- 1/5/2023 8:37:43 AM; Request Name :- Item 32156126280; Item Flexi Field CustomList :- 0; ErrorMsg:- ; Response End Time:- 1/5/2023 8:37:44 AM; Request Name :- CustomList-Search; CustomList :- SS24,SS24; Request Start Time:- 1/5/2023 8:37:44 AM; Request Name :- Item 32156126280; Item Flexi Field CustomList :- 0; ErrorMsg:- ; Response End Time:- 1/5/2023 8:37:45 AM; Request Name :- CustomRecord-Search; CustomRecord :- MAR24; Request Start Time:- 1/5/2023 8:37:45 AM; Request Name :- CustomRecord-Search; CustomRecord :- ; ErrorMsg:- ; Response End Time:- 1/5/2023 8:37:45 AM; Request Name :- Item 32156126280; Item Flexi Field CustomRecord :- 0; ErrorMsg:- ; Response End Time:- 1/5/2023 8:37:45 AM; Request Name :- Item 32156126280; Item Flexi Field :- 0; ErrorMsg:- ; Response End Time:- 1/5/2023 8:37:45 AM; Request Name :- Item 32156126280; Item Flexi Field :- 0; ErrorMsg:- ; Response End Time:- 1/5/2023 8:37:45 AM; Request Name :- Item 32156126280; Item Flexi Field :- 0; ErrorMsg:- ; Response End Time:- 1/5/2023 8:37:45 AM; Request Name :- CustomList-Search; CustomList :- ,; Request Start Time:- 1/5/2023 8:37:45 AM; Request Name :- Item 32156126280; Item Flexi Field CustomList :- 0; ErrorMsg:- ; Response End Time:- 1/5/2023 8:37:46 AM; Request Name :- Item 32156126280; Item Flexi Field :- 0; ErrorMsg:- ; Response End Time:- 1/5/2023 8:37:46 AM; Request Name :- Item 32156126280; Item Flexi Field :- 0; ErrorMsg:- ; Response End Time:- 1/5/2023 8:37:46 AM; Request Name :- Item Start; Item ; Request Start Time:- 1/5/2023 8:37:46 AM; Request Name :- UPSERT INITIALISE; Available Count Block ; Request Start Time:- 1/5/2023 8:37:46 AM; Request Name :- UPSERT INITIALISE; Available Count Block :- 1,1; ErrorMsg:- ; Response End Time:- 1/5/2023 8:37:46 AM; Request Name :- Item Start; Item :- 491348; Request Start Time:- 1/5/2023 8:37:46 AM; Request Name :- Department-Search; Department :- 156; Request Start Time:- 1/5/2023 8:37:46 AM; Request Name :- Department-Search; Department :- 145; ErrorMsg:- ; Response End Time:- 1/5/2023 8:37:46 AM; Request Name :- Item 32156126280; Item FieldName :- subsidiary,FieldValue :- 1; Request Start Time:- 1/5/2023 8:37:46 AM; Request Name :- Item 32156126280; Item Subsidiary Field ; Request Start Time:- 1/5/2023 8:37:46 AM; Request Name :- Item 32156126280; Item Subsidiary Field :- 1; ErrorMsg:- ; Response End Time:- 1/5/2023 8:37:46 AM; Request Name :- Item 32156126280; Item FieldName :- custitem_dck_wpg,FieldValue :- Kids|3; Request Start Time:- 1/5/2023 8:37:46 AM; Request Name :- Item 32156126280; Item Select Field ; Request Start Time:- 1/5/2023 8:37:46 AM; Request Name :- Item 32156126280; Item Select Field :- 3; ErrorMsg:- ; Response End Time:- 1/5/2023 8:37:46 AM; Request Name :- Item 32156126280; Item FieldName :- custitem_wfx_wps,FieldValue :- Jewellery|214; Request Start Time:- 1/5/2023 8:37:46 AM; Request Name :- Item 32156126280; Item Select Field ; Request Start Time:- 1/5/2023 8:37:46 AM; Request Name :- Item 32156126280; Item Select Field :- 214; ErrorMsg:- ; Response End Time:- 1/5/2023 8:37:46 AM; Request Name :- Item 32156126280; Item FieldName :- custitem_dck_ss,FieldValue :- Rings; Request Start Time:- 1/5/2023 8:37:46 AM; Request Name :- Item 32156126280; Item Flexi Field ; Request Start Time:- 1/5/2023 8:37:46 AM; Request Name :- Item 32156126280; Item FieldName :- custitem_dck_customercode,FieldValue :- MANDCC; Request Start Time:- 1/5/2023 8:37:46 AM; Request Name :- Item 32156126280; Item Select Field ; Request Start Time:- 1/5/2023 8:37:46 AM; Request Name :- CustomRecord-Search; CustomRecord :- MANDCC; Request Start Time:- 1/5/2023 8:37:46 AM; Request Name :- CustomRecord-Search; CustomRecord :- ; ErrorMsg:- ; Response End Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item Select Field :- 8; ErrorMsg:- ; Response End Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item FieldName :- custitem_dck_brandcode,FieldValue :- CK; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item Flexi Field ; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item FieldName :- custitem_dck_events,FieldValue :- N/A; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item Flexi Field ; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item FieldName :- custitem_dck_feature,FieldValue :- Metal; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item Flexi Field ; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item FieldName :- custitem_dck_original_season,FieldValue :- SS24; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item Flexi Field ; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item FieldName :- custitem_dck_recycled,FieldValue :- Yes; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item Flexi Field ; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item FieldName :- custitem_dck_story,FieldValue :- Angelica; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item Flexi Field ; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item FieldName :- custitem_dck_commission,FieldValue :- Standard; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item Flexi Field ; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item FieldName :- custitem_dck_relppt,FieldValue :- M&Co Full Price; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item Flexi Field ; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item FieldName :- custitem_dck_key_line,FieldValue :- Yes; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item Flexi Field ; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item FieldName :- custitem_dck_md_phase,FieldValue :- SS24 ESS1; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item Flexi Field ; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item FieldName :- custitem_dck_speed_market,FieldValue :- No; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item Flexi Field ; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item FieldName :- custitem_dck_ticket_type,FieldValue :- <case>CASE WHEN ('CK' = 'AE' AND 'MANDCC' = 'NX') THEN 1 WHEN ('CK' = 'AP' AND 'MANDCC' = 'AP') THEN 3 WHEN ('CK' = 'AO' AND 'MANDCC' = 'AS') THEN 4 WHEN ('CK' = 'BO' AND 'MANDCC' = 'BO') THEN 5 WHEN ('CK' = 'DP' AND 'MANDCC' = 'BO') THEN 5 WHEN ('CK' = 'CG' AND 'MANDCC' = 'CL') THEN 6 WHEN ('CK' = 'CL' AND 'MANDCC' = 'CL') THEN 6 WHEN ('CK' = 'DI' AND 'MANDCC' = 'BW') THEN 8 WHEN ('CK' = 'DU' AND 'MANDCC' = 'DU') THEN 10 WHEN ('CK' = 'FL' AND 'MANDCC' = 'UK') THEN 11 WHEN ('CK' = 'FR' AND 'MANDCC' = 'UK') THEN 13 WHEN ('CK' = 'GT' AND 'MANDCC' = 'GT') THEN 14 WHEN ('CK' = 'LL' AND 'MANDCC' = 'UK') THEN 15 WHEN ('CK' = 'CK' AND 'MANDCC' = 'MC') THEN 21 WHEN ('CK' = 'CW' AND 'MANDCC' = 'MC') THEN 21 WHEN ('CK' = 'HK' AND 'MANDCC' = 'MS') THEN 23 WHEN ('CK' = 'HW' AND 'MANDCC' = 'MS') THEN 23 WHEN ('CK' = 'MK' AND 'MANDCC' = 'MT') THEN 27 WHEN ('CK' = 'MW' AND 'MANDCC' = 'MT') THEN 27 WHEN ('CK' = 'MI' AND 'MANDCC' = 'AS') THEN 4 WHEN ('CK' = 'MC' AND 'MANDCC' = 'UK') THEN 30 WHEN ('CK' = 'ML' AND 'MANDCC' = 'UK') THEN 30 WHEN ('CK' = 'NM' AND 'MANDCC' = 'NX') THEN 1 WHEN ('CK' = 'RA' AND 'MANDCC' = 'BW') THEN 8 WHEN ('CK' = 'RM' AND 'MANDCC' = 'ZL') THEN 19 WHEN ('CK' = 'SD' AND 'MANDCC' = 'SD') THEN 20 WHEN ('CK' = 'TP' AND 'MANDCC' = 'AS') THEN 4 WHEN ('CK' = 'TS' AND 'MANDCC' = 'AS') THEN 4 WHEN ('CK' = 'US' AND 'MANDCC' = 'ZL') THEN 19 WHEN ('CK' = 'WA' AND 'MANDCC' = 'BO') THEN 5 ELSE 0 END</case>; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item Flexi Field ; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item FieldName :- custitem_dck_matrixtype,FieldValue :- 1; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item Select Field ; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item Select Field :- 1; ErrorMsg:- ; Response End Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item FieldName :- custitem_dck_season,FieldValue :- SS24|211; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item Select Field ; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item Select Field :- 211; ErrorMsg:- ; Response End Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item FieldName :- custitem_dck_test,FieldValue :- ; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item FieldName :- custitem_dck_countryofreceipt,FieldValue :- ; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item FieldName :- custitem_dck_otbperiod,FieldValue :- MAR24; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item Flexi Field ; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item FieldName :- custitem_dck_finish,FieldValue :- GL; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item Flexi Field ; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item FieldName :- custitem_dck_customer_appeal,FieldValue :- Classic; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item Flexi Field ; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item FieldName :- custitem_dck_end_use,FieldValue :- Casual; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item Flexi Field ; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item FieldName :- custitem_dck_product_type,FieldValue :- Wrap Ring; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item Flexi Field ; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item FieldName :- custitem_dck_ranges_item,FieldValue :- R1; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Item 32156126280; Item Flexi Field ; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Currency Fetch; Currency :- ; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Currency Fetch; Currency :- ; ErrorMsg:- ; Response End Time:- 1/5/2023 8:37:47 AM; Request Name :- Supplier-Search; Supplier; Request Start Time:- 1/5/2023 8:37:47 AM; Request Name :- Supplier-Search; Supplier; ErrorMsg:- ; Response End Time:- 1/5/2023 8:37:48 AM; Request Name :- Item 32156126280; Item externalId :- Articles32156126280; ErrorMsg:- ; Response End Time:- 1/5/2023 8:37:48 AM; Request Name :- Item 491348; Item 2; Request Start Time:- 1/5/2023 8:37:48 AM; Request Name :- Upsert; Upsert Netsuite Records ; Request Start Time:- 1/5/2023 8:37:48 AM; Request Name :- Upsert Successfull; Upsert Netsuite Records 1; ErrorMsg:- ; Response End Time:- 1/5/2023 8:37:50 AM; Request Name :- Item End; Item :- 491348; ErrorMsg:- ERROR :- [Code=INVALID_KEY_OR_REF] Invalid custitem_dck_relppt reference key 819. ; Response End Time:- 1/5/2023 8:37:51 AM; Request Name :- UPSERT NEXT; Available Count Block ; Request Start Time:- 1/5/2023 8:37:51 AM; Request Name :- UPSERT NEXT; Available Count Block :- 0,1; ErrorMsg:- ; Response End Time:- 1/5/2023 8:37:51 AM; Request Name :- Item End; Item ; ErrorMsg:- ERROR :- [Code=INVALID_KEY_OR_REF] Invalid custitem_dck_relppt reference key 819. ; Response End Time:- 1/5/2023 8:37:51 AM; Request Name :- Batch End Time; Batch End ; ErrorMsg:- ; Response End Time:- 1/5/2023 8:37:51 AM;