{ "status": "success", "upcomingorder_list": { "bm_customertemplatedata": { "created": [], "updated": [ { "ctd_id": 5878, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"62\": \"TEST0009\", \"63\": \"\", \"61\": 1, \"598\": 25, \"64\": 1}", "ctd_deletedcustokeyvalue": "{}", "ctd_isenablecustspecvatrate": 0, "ctd_custspecvatrate": "0.00", "ctd_vatregnum": null, "ctd_custsurcharge": null, "ctd_defaultdelcost": null, "ctd_defaultapptype": null, "ctd_defaultstaff": null, "ctd_addcredit": "0.00", "ctd_totredeemed": "0.00", "ctd_balance": "0.00", "ctd_creditlimit": "0.00", "ctd_creditavailable": "0.00", "ctd_overdue": 0, "ctd_paymenttermstype": 0, "ctd_paymenttermsvalue": 0, "ctd_paymenttermsdesc": null, "ctd_ishold": 0, "ctd_jobview": 0, "ctd_jobtypeview": 0, "ctd_discount": "0.00", "ctd_language": 0, "ctd_notymsg": 0, "ctd_onlinelogoname": null, "ctd_onlinelogo": null, "ctd_onlinesendemail": 0, "ctd_fordesktopisenable": 1, "ctd_foronlineisenable": 1, "ctd_enabledproductdesktop": "31,57,58,59,60,61,62,65,66,69,70,71,73,74,75,76,108,120,153,156,164,168,172,173,174,176,178,182,184,185,186,190,191,192,213,215,216,217,219,220,248,249,250,251,252,254,255,257,258,259,260,261,262,263,264,265,266,267,268,269,270,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291", "ctd_enabledproductonline": "31,57,58,59,60,61,62,65,66,69,70,71,73,74,75,76,108,120,153,156,164,168,172,173,174,176,178,182,184,185,186,190,191,192,213,215,216,217,219,220,248,249,250,251,252,254,255,257,258,259,260,261,262,263,264,265,266,267,268,269,270,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291", "ctd_onlineproductmarkup": null, "ctd_onlineendcustomeruseprefix": null, "ctd_onlineendcustomersequence": "2", "ctd_onlinequotecustomerterms": null, "ctd_onlinequotepaymentterms": null, "ctd_onlineinvoicecustomerterms": null, "ctd_onlineinvoicepaymentterms": null, "ctd_seq": 0, "ctd_status": 0, "id": "5878", "ctd_createdat": 1748416563, "ctd_updatedat": 1748417004, "ctd_createdby": 0, "ctd_updatedby": null }, { "ctd_id": 762, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\": 1, \"62\": \"WARE1002\", \"63\": \"\", \"64\": 4, \"65\": \"\", \"66\": null, \"67\": \"16 Farrell Road\", \"68\": \"\", \"69\": \"Wootton\", \"70\": \"MK43 9DU\", \"71\": \"Bedford\", \"72\": 19, \"73\": \"\", \"598\": \"25\"}", "ctd_deletedcustokeyvalue": "{}", "ctd_isenablecustspecvatrate": 0, "ctd_custspecvatrate": "0.00", "ctd_vatregnum": null, "ctd_custsurcharge": "0.00", "ctd_defaultdelcost": "0.000", "ctd_defaultapptype": "", "ctd_defaultstaff": "", "ctd_addcredit": "0.00", "ctd_totredeemed": "0.00", "ctd_balance": "0.00", "ctd_creditlimit": "0.00", "ctd_creditavailable": "0.00", "ctd_overdue": 0, "ctd_paymenttermstype": 0, "ctd_paymenttermsvalue": 0, "ctd_paymenttermsdesc": "", "ctd_ishold": 0, "ctd_jobview": 0, "ctd_jobtypeview": 0, "ctd_discount": "0.00", "ctd_language": 0, "ctd_notymsg": 0, "ctd_onlinelogoname": null, "ctd_onlinelogo": null, "ctd_onlinesendemail": 0, "ctd_fordesktopisenable": 1, "ctd_foronlineisenable": 0, "ctd_enabledproductdesktop": "60,164,191,153,168,57,186,156,77,71,72,73,65,74,75,184,70,174,61,62,63,76,64,66,58,176,120,178,190,182,59,108,67,69,175,185,31,172,173,247,192,248,249,250,251,252,253,254,255,256,257", "ctd_enabledproductonline": "247,248,249,250,251,252,253,254,255,256,257", "ctd_onlineproductmarkup": null, "ctd_onlineendcustomeruseprefix": null, "ctd_onlineendcustomersequence": "1", "ctd_onlinequotecustomerterms": null, "ctd_onlinequotepaymentterms": null, "ctd_onlineinvoicecustomerterms": null, "ctd_onlineinvoicepaymentterms": null, "ctd_seq": 0, "ctd_status": 0, "id": "762", "ctd_createdat": 1740814341, "ctd_updatedat": 1748417092, "ctd_createdby": 1, "ctd_updatedby": 1 }, { "ctd_id": 5879, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\": 1, \"64\": 1, \"598\": 25, \"62\": \"ATES0001\"}", "ctd_deletedcustokeyvalue": "{}", "ctd_isenablecustspecvatrate": 0, "ctd_custspecvatrate": "0.00", "ctd_vatregnum": null, "ctd_custsurcharge": null, "ctd_defaultdelcost": null, "ctd_defaultapptype": null, "ctd_defaultstaff": null, "ctd_addcredit": "0.00", "ctd_totredeemed": "0.00", "ctd_balance": "0.00", "ctd_creditlimit": "0.00", "ctd_creditavailable": "0.00", "ctd_overdue": 0, "ctd_paymenttermstype": 0, "ctd_paymenttermsvalue": 0, "ctd_paymenttermsdesc": null, "ctd_ishold": 0, "ctd_jobview": 0, "ctd_jobtypeview": 0, "ctd_discount": "0.00", "ctd_language": 0, "ctd_notymsg": 0, "ctd_onlinelogoname": null, "ctd_onlinelogo": null, "ctd_onlinesendemail": 0, "ctd_fordesktopisenable": 0, "ctd_foronlineisenable": 0, "ctd_enabledproductdesktop": "0", "ctd_enabledproductonline": "0", "ctd_onlineproductmarkup": null, "ctd_onlineendcustomeruseprefix": null, "ctd_onlineendcustomersequence": null, "ctd_onlinequotecustomerterms": null, "ctd_onlinequotepaymentterms": null, "ctd_onlineinvoicecustomerterms": null, "ctd_onlineinvoicepaymentterms": null, "ctd_seq": 0, "ctd_status": 0, "id": "5879", "ctd_createdat": 1748417077, "ctd_updatedat": 1748417133, "ctd_createdby": 0, "ctd_updatedby": null } ], "deleted": [] }, "bm_customercontactinfo": { "created": [], "updated": [ { "cci_id": 1014, "cci_customerid": 762, "cci_templateid": 3, "roleid": 2, "cci_customizedarray": "{\"82\":\"\",\"77\":\"Sara\",\"79\":\"Wareing\",\"78\":\"\",\"76\":\"\",\"81\":\"0\",\"75\":10,\"83\":\"\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"16 Farrell Road\",\"89\":\"Wootton\",\"90\":19,\"86\":\"\",\"91\":\"Bedford\",\"88\":\"MK43 9DU\"}", "cci_ismarketingemails": 0, "cci_smsverifystatus": 0, "cci_isdocumentreceived": 0, "cci_receiveddocfor": "[\"null\"]", "cci_isonlineportal": 0, "cci_latitude": null, "cci_longitude": null, "cci_username": "", "cci_password": "", "cci_confirmpassword": "", "cci_seq": 0, "cci_status": 0, "cci_deviceplatform": 0, "cci_mobcustomertempid": 0, "id": "1014", "cci_createdat": 1740814341, "cci_updatedat": 1748417074, "cci_createdby": 1, "cci_updatedby": null }, { "cci_id": 7295, "cci_customerid": 5878, "cci_templateid": 3, "roleid": 1, "cci_customizedarray": "{\"82\":\"\",\"77\":\"\",\"79\":\"Teste\",\"78\":\"\",\"76\":\"\",\"81\":\"0\",\"75\":1,\"62\":\"\",\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"\",\"89\":\"\",\"90\":19,\"86\":\"\",\"91\":\"\",\"88\":\"435 VBN\"}", "cci_ismarketingemails": 0, "cci_smsverifystatus": 0, "cci_isdocumentreceived": 0, "cci_receiveddocfor": null, "cci_isonlineportal": 0, "cci_latitude": null, "cci_longitude": null, "cci_username": null, "cci_password": null, "cci_confirmpassword": null, "cci_seq": 0, "cci_status": 0, "cci_deviceplatform": 0, "cci_mobcustomertempid": 0, "id": "7295", "cci_createdat": 1748416563, "cci_updatedat": 1748416963, "cci_createdby": 0, "cci_updatedby": null }, { "cci_id": 7296, "cci_customerid": 5879, "cci_templateid": 3, "roleid": 0, "cci_customizedarray": "{\"75\":1,\"77\":\"Test\",\"79\":\"A\",\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"88\":\"09\",\"90\":19}", "cci_ismarketingemails": 0, "cci_smsverifystatus": 0, "cci_isdocumentreceived": 0, "cci_receiveddocfor": null, "cci_isonlineportal": 0, "cci_latitude": null, "cci_longitude": null, "cci_username": null, "cci_password": null, "cci_confirmpassword": null, "cci_seq": 0, "cci_status": 0, "cci_deviceplatform": 2, "cci_mobcustomertempid": 31748417077, "id": "7296", "cci_createdat": 1748417077, "cci_updatedat": 1748417133, "cci_createdby": 0, "cci_updatedby": null } ], "deleted": [] }, "bm_appointment": { "created": [], "updated": [], "deleted": [] }, "bm_tasklist": { "created": [], "updated": [], "deleted": [] }, "bm_jobdetails": { "created": [ { "jd_id": 12776, "jd_customerid": 5878, "jd_contactid": 7295, "jd_additionalcontacts": "7295", "jd_templateid": 1, "jd_jobmultiquoteid": 12780, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "11442", "jd_jobstatus": 3, "jd_contactaddid": 0, "jd_orderstatus": 3, "jd_accref": "TEST0009", "jd_invoiceno": "", "jd_listprice": "41.58", "jd_netprice": "41.58", "jd_vat": "8.32", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 2, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "49.90", "jd_grossprofit": "2.75", "jd_costprice": "38.83", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "49.90", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": "", "jd_endcustomeroverridenetprice": "41.58", "jd_endcustomeroverridevatprice": "8.32", "jd_endcustomeroverridegrossprice": "49.90", "jd_endcustomerdeliverycost": "", "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": "", "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 14, "jd_updatedby": 14, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "20.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":1,\"41\":14,\"44\":\"\",\"45\":\"\",\"46\":\"Teste\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"435 VBN\",\"54\":19,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":14,\"558\":\"0\",\"612\":\"\",\"614\":\"\",\"615\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "20.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "12776", "jd_createddate": 1748390400, "jd_orderdate": null, "jd_duedate": 1748563200, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1748416963, "jd_updatedat": 1748417004 }, { "jd_id": 12777, "jd_customerid": 762, "jd_contactid": 1014, "jd_additionalcontacts": "1014", "jd_templateid": 1, "jd_jobmultiquoteid": 12781, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "11443", "jd_jobstatus": 3, "jd_contactaddid": 0, "jd_orderstatus": 3, "jd_accref": "WARE1002", "jd_invoiceno": "", "jd_listprice": "351.09", "jd_netprice": "351.09", "jd_vat": "70.22", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 2, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "421.31", "jd_grossprofit": "144.78", "jd_costprice": "206.31", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "421.31", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": "", "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": "", "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": "", "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 14, "jd_updatedby": 14, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "20.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":\"25\",\"37\":1,\"39\":4,\"41\":14,\"44\":\"\",\"45\":\"Sara\",\"46\":\"Wareing\",\"47\":\"\",\"48\":\"\",\"49\":\"16 Farrell Road\",\"50\":\"Wootton\",\"51\":\"Bedford\",\"52\":\"\",\"53\":\"MK43 9DU\",\"54\":19,\"285\":10,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":14,\"558\":\"0\",\"612\":\"\",\"614\":\"\",\"615\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "20.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "12777", "jd_createddate": 1748390400, "jd_orderdate": null, "jd_duedate": 1748563200, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1748417074, "jd_updatedat": 1748417092 }, { "jd_id": 12778, "jd_customerid": 5879, "jd_contactid": 7296, "jd_additionalcontacts": "7296", "jd_templateid": 1, "jd_jobmultiquoteid": 12782, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "11444", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 3, "jd_accref": "ATES0001", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "0.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "jd_isroundon": 0, "jd_grossprice": "0.00", "jd_grossprofit": "0.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "0.00", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": null, "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 1, "jd_updatedby": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "20.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"11444\",\"35\":\"ATES0001\",\"36\":1,\"37\":1,\"38\":\"\",\"39\":1,\"40\":3,\"41\":1,\"44\":\"\",\"45\":\"Test\",\"46\":\"A\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"09\",\"54\":19,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"612\":\"\",\"614\":\"\",\"615\":\"\",\"countryText\":\"UK\",\"adminUser\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "20.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "12778", "jd_createddate": 1748390400, "jd_orderdate": null, "jd_duedate": 1748390400, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1748417077, "jd_updatedat": 1748417134 } ], "updated": [ { "jd_id": 12776, "jd_customerid": 5878, "jd_contactid": 7295, "jd_additionalcontacts": "7295", "jd_templateid": 1, "jd_jobmultiquoteid": 12780, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "11442", "jd_jobstatus": 3, "jd_contactaddid": 0, "jd_orderstatus": 3, "jd_accref": "TEST0009", "jd_invoiceno": "", "jd_listprice": "41.58", "jd_netprice": "41.58", "jd_vat": "8.32", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 2, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "49.90", "jd_grossprofit": "2.75", "jd_costprice": "38.83", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "49.90", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": "", "jd_endcustomeroverridenetprice": "41.58", "jd_endcustomeroverridevatprice": "8.32", "jd_endcustomeroverridegrossprice": "49.90", "jd_endcustomerdeliverycost": "", "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": "", "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 14, "jd_updatedby": 14, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "20.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":1,\"41\":14,\"44\":\"\",\"45\":\"\",\"46\":\"Teste\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"435 VBN\",\"54\":19,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":14,\"558\":\"0\",\"612\":\"\",\"614\":\"\",\"615\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "20.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "12776", "jd_createddate": 1748390400, "jd_orderdate": null, "jd_duedate": 1748563200, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1748416963, "jd_updatedat": 1748417004 }, { "jd_id": 12777, "jd_customerid": 762, "jd_contactid": 1014, "jd_additionalcontacts": "1014", "jd_templateid": 1, "jd_jobmultiquoteid": 12781, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "11443", "jd_jobstatus": 3, "jd_contactaddid": 0, "jd_orderstatus": 3, "jd_accref": "WARE1002", "jd_invoiceno": "", "jd_listprice": "351.09", "jd_netprice": "351.09", "jd_vat": "70.22", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 2, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "421.31", "jd_grossprofit": "144.78", "jd_costprice": "206.31", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "421.31", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": "", "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": "", "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": "", "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 14, "jd_updatedby": 14, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "20.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":\"25\",\"37\":1,\"39\":4,\"41\":14,\"44\":\"\",\"45\":\"Sara\",\"46\":\"Wareing\",\"47\":\"\",\"48\":\"\",\"49\":\"16 Farrell Road\",\"50\":\"Wootton\",\"51\":\"Bedford\",\"52\":\"\",\"53\":\"MK43 9DU\",\"54\":19,\"285\":10,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":14,\"558\":\"0\",\"612\":\"\",\"614\":\"\",\"615\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "20.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "12777", "jd_createddate": 1748390400, "jd_orderdate": null, "jd_duedate": 1748563200, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1748417074, "jd_updatedat": 1748417092 }, { "jd_id": 12778, "jd_customerid": 5879, "jd_contactid": 7296, "jd_additionalcontacts": "7296", "jd_templateid": 1, "jd_jobmultiquoteid": 12782, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "11444", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 3, "jd_accref": "ATES0001", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "0.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "jd_isroundon": 0, "jd_grossprice": "0.00", "jd_grossprofit": "0.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "0.00", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": null, "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 1, "jd_updatedby": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "20.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"11444\",\"35\":\"ATES0001\",\"36\":1,\"37\":1,\"38\":\"\",\"39\":1,\"40\":3,\"41\":1,\"44\":\"\",\"45\":\"Test\",\"46\":\"A\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"09\",\"54\":19,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"612\":\"\",\"614\":\"\",\"615\":\"\",\"countryText\":\"UK\",\"adminUser\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "20.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "12778", "jd_createddate": 1748390400, "jd_orderdate": null, "jd_duedate": 1748390400, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1748417077, "jd_updatedat": 1748417134 } ], "deleted": [] }, "bm_orderitem": { "created": [ { "oi_id": 80457, "oi_jobid": 12776, "oi_jobtempid": "0", "oi_jobmultiquoteid": 12780, "oi_productid": 60, "oi_recipeid": 60, "oi_ruleid": 7, "oi_qty": 1, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":3892,\"labelname\":\"Unit Type\",\"value\":2,\"valueid\":\"2\",\"type\":34,\"optionid\":2,\"optionvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"issubfabric\":0,\"labelnamecode\":\"Unit Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":34,\"mandatory\":0,\"fieldname\":\"Unit Type\",\"fieldid\":3892,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":2,\"optionsvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"editruleoverride\":0},{\"id\":3891,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":null,\"type\":14,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Quantity\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":14,\"mandatory\":0,\"fieldname\":\"Quantity\",\"fieldid\":3891,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3895,\"labelname\":\"Room\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Room\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Room\",\"fieldid\":3895,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3893,\"labelname\":\"Supplier\",\"value\":15,\"valueid\":null,\"type\":17,\"optionid\":15,\"optionvalue\":[{\"id\":15,\"optionid\":15,\"optionname\":\"Excel\",\"deleted\":0,\"optionquantity\":1}],\"issubfabric\":0,\"labelnamecode\":\"Supplier\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":17,\"mandatory\":0,\"fieldname\":\"Supplier\",\"fieldid\":3893,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":15,\"optionsvalue\":[{\"id\":15,\"optionid\":15,\"optionname\":\"Excel\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":3896,\"labelname\":\"Size\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Size\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Size\",\"fieldid\":3896,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3897,\"labelname\":\"Width\",\"value\":null,\"valueid\":null,\"type\":11,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Width\",\"fabricorcolor\":0,\"widthfraction\":\"0_mm_3_0\",\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":11,\"mandatory\":0,\"fieldname\":\"Width\",\"fieldid\":3897,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3898,\"labelname\":\"Drop\",\"value\":null,\"valueid\":null,\"type\":12,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Drop\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":\"0_mm_3_0\",\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":12,\"mandatory\":0,\"fieldname\":\"Drop\",\"fieldid\":3898,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3894,\"labelname\":\"Pricing Band\",\"value\":null,\"valueid\":null,\"type\":13,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Pricing Band\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":13,\"mandatory\":0,\"fieldname\":\"Pricing Band\",\"fieldid\":3894,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3904,\"labelname\":\"Control Type\",\"value\":\"Wand\",\"valueid\":\"17572\",\"type\":3,\"optionid\":\"14488\",\"optionvalue\":[{\"optionid\":14488,\"optionqty\":\"1\",\"optionname\":\"Wand\",\"description\":null,\"optioncode\":\"17950\",\"pricegroups\":\"Diffused Band A_AAB,Diffused Band B_AAB,Band_A_EAB,Band_B_EAB\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":17572,\"forchildfieldoptionlinkid\":\"3_17572\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":2,\"optionimage\":null,\"reportprice\":\"0.00\",\"costprice\":0,\"costwithdiscount\":0,\"customersellingprice\":0,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":0,\"sellingpriceType\":1}],\"issubfabric\":0,\"labelnamecode\":\"Control Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Control Type\",\"fieldid\":3904,\"subchild\":[{\"fieldtypeid\":3,\"fieldid\":3905,\"labelnamecode\":\"Bunch\",\"fieldname\":\"Bunch\",\"selection\":0,\"field_has_sub_option\":1,\"seq\":5,\"mandatory\":1,\"fieldlevel\":2,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"fabricorcolor\":0,\"subfieldlinkid\":17572,\"forchildsubfieldlinkid\":\"3_17572\",\"optionsvalue\":[{\"optionid\":14489,\"optionqty\":\"1\",\"optionname\":\"RH Bunch Wand\",\"description\":null,\"optioncode\":\"51638\",\"pricegroups\":null,\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":17574,\"forchildfieldoptionlinkid\":\"3_17574\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":14490,\"optionqty\":\"1\",\"optionname\":\"LH Bunch Wand\",\"description\":null,\"optioncode\":\"51639\",\"pricegroups\":null,\"unittype\":\"Each\",\"unitcost\":5.5,\"fieldoptionlinkid\":17575,\"forchildfieldoptionlinkid\":\"3_17575\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"8.25\",\"costprice\":5.5,\"costwithdiscount\":5.5,\"customersellingprice\":8.25,\"customermarkupvalue\":1.5,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":5.5,\"sellingpriceType\":1},{\"optionid\":14491,\"optionqty\":\"1\",\"optionname\":\"Split Draw Wand RH\",\"description\":null,\"optioncode\":\"51640\",\"pricegroups\":null,\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":17576,\"forchildfieldoptionlinkid\":\"3_17576\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":14492,\"optionqty\":\"1\",\"optionname\":\"Split Draw Wand LH\",\"description\":null,\"optioncode\":\"51641\",\"pricegroups\":null,\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":17577,\"forchildfieldoptionlinkid\":\"3_17577\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null}],\"optionsbackup\":[{\"optionid\":14489,\"optionqty\":\"1\",\"optionname\":\"RH Bunch Wand\",\"description\":null,\"optioncode\":\"51638\",\"pricegroups\":null,\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":17574,\"forchildfieldoptionlinkid\":\"3_17574\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":14490,\"optionqty\":\"1\",\"optionname\":\"LH Bunch Wand\",\"description\":null,\"optioncode\":\"51639\",\"pricegroups\":null,\"unittype\":\"Each\",\"unitcost\":5.5,\"fieldoptionlinkid\":17575,\"forchildfieldoptionlinkid\":\"3_17575\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"8.25\",\"costprice\":5.5,\"costwithdiscount\":5.5,\"customersellingprice\":8.25,\"customermarkupvalue\":1.5,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":5.5,\"sellingpriceType\":1},{\"optionid\":14491,\"optionqty\":\"1\",\"optionname\":\"Split Draw Wand RH\",\"description\":null,\"optioncode\":\"51640\",\"pricegroups\":null,\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":17576,\"forchildfieldoptionlinkid\":\"3_17576\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":14492,\"optionqty\":\"1\",\"optionname\":\"Split Draw Wand LH\",\"description\":null,\"optioncode\":\"51641\",\"pricegroups\":null,\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":17577,\"forchildfieldoptionlinkid\":\"3_17577\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null}],\"editablecolumns\":[\"optionqty\"],\"optionsselectedcolumns\":{\"optionid\":\"Option Id\",\"optionqty\":\"Option Qty\",\"optionname\":\"Option Name\",\"optioncode\":\"Option Code\",\"description\":\"Description\",\"pricegroups\":\"Price Groups\"},\"optiondefault\":\"14490\",\"masterparentfieldid\":3904,\"supplierid\":\"19,15\",\"subchild\":[],\"issubfabric\":0,\"textfieldheight\":1,\"editruleoverride\":1,\"fieldInformation\":null,\"dumydata\":[],\"blindswidth\":0},{\"fieldtypeid\":3,\"fieldid\":3906,\"labelnamecode\":\"Wand Length\",\"fieldname\":\"Wand Length\",\"selection\":0,\"field_has_sub_option\":1,\"seq\":6,\"mandatory\":0,\"fieldlevel\":2,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"fabricorcolor\":0,\"subfieldlinkid\":17572,\"forchildsubfieldlinkid\":\"3_17572\",\"optionsvalue\":[{\"optionid\":14494,\"optionqty\":\"1\",\"optionname\":\"750mm\",\"description\":null,\"optioncode\":\"51649\",\"pricegroups\":null,\"unittype\":\"Each\",\"fieldoptionlinkid\":17580,\"forchildfieldoptionlinkid\":\"3_17580\",\"hasstock\":0,\"subdatacount\":0,\"hasprice\":1,\"optionimage\":null,\"unitcost\":0,\"reportprice\":\"0.00\",\"costprice\":0,\"costwithdiscount\":0,\"customersellingprice\":0,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":0,\"sellingpriceType\":1}],\"optionsbackup\":[{\"optionid\":14494,\"optionqty\":\"1\",\"optionname\":\"750mm\",\"description\":null,\"optioncode\":\"51649\",\"pricegroups\":null,\"unittype\":\"Each\",\"fieldoptionlinkid\":17580,\"forchildfieldoptionlinkid\":\"3_17580\",\"hasstock\":0,\"subdatacount\":0,\"hasprice\":1,\"optionimage\":null,\"unitcost\":0,\"reportprice\":\"0.00\",\"costprice\":0,\"costwithdiscount\":0,\"customersellingprice\":0,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":0,\"sellingpriceType\":1}],\"editablecolumns\":[\"optionqty\"],\"optionsselectedcolumns\":{\"optionid\":\"Option Id\",\"optionqty\":\"Option Qty\",\"optionname\":\"Option Name\",\"optioncode\":\"Option Code\",\"description\":\"Description\",\"pricegroups\":\"Price Groups\"},\"optiondefault\":\"14494\",\"masterparentfieldid\":3904,\"supplierid\":\"19,15\",\"subchild\":[],\"issubfabric\":0,\"textfieldheight\":1,\"editruleoverride\":null,\"fieldInformation\":null,\"dumydata\":[{\"optionid\":14494,\"optionqty\":\"1\",\"optionname\":\"750mm\",\"description\":null,\"optioncode\":\"51649\",\"pricegroups\":null,\"unittype\":\"Each\",\"fieldoptionlinkid\":17580,\"forchildfieldoptionlinkid\":\"3_17580\",\"hasstock\":0,\"subdatacount\":0,\"hasprice\":1,\"optionimage\":null}],\"blindswidth\":0}],\"fieldInformation\":null,\"optiondefault\":\"14488\",\"optionsvalue\":[{\"optionid\":14488,\"optionqty\":\"1\",\"optionname\":\"Wand\",\"description\":null,\"optioncode\":\"17950\",\"pricegroups\":\"Diffused Band A_AAB,Diffused Band B_AAB,Band_A_EAB,Band_B_EAB\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":17572,\"forchildfieldoptionlinkid\":\"3_17572\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":2,\"optionimage\":null,\"reportprice\":\"0.00\",\"costprice\":0,\"costwithdiscount\":0,\"customersellingprice\":0,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":0,\"sellingpriceType\":1}],\"editruleoverride\":0},{\"id\":3905,\"labelname\":\"Bunch\",\"value\":\"LH Bunch Wand\",\"valueid\":\"17575\",\"type\":3,\"optionid\":\"14490\",\"optionvalue\":[{\"optionid\":14490,\"optionqty\":\"1\",\"optionname\":\"LH Bunch Wand\",\"description\":null,\"optioncode\":\"51639\",\"pricegroups\":null,\"unittype\":\"Each\",\"unitcost\":5.5,\"fieldoptionlinkid\":17575,\"forchildfieldoptionlinkid\":\"3_17575\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"8.25\",\"costprice\":5.5,\"costwithdiscount\":5.5,\"customersellingprice\":8.25,\"customermarkupvalue\":1.5,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":5.5,\"sellingpriceType\":1}],\"issubfabric\":0,\"labelnamecode\":\"Bunch\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":2,\"fieldtypeid\":3,\"mandatory\":1,\"fieldname\":\"Bunch\",\"fieldid\":3905,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"14490\",\"optionsvalue\":[{\"optionid\":14490,\"optionqty\":\"1\",\"optionname\":\"LH Bunch Wand\",\"description\":null,\"optioncode\":\"51639\",\"pricegroups\":null,\"unittype\":\"Each\",\"unitcost\":5.5,\"fieldoptionlinkid\":17575,\"forchildfieldoptionlinkid\":\"3_17575\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"8.25\",\"costprice\":5.5,\"costwithdiscount\":5.5,\"customersellingprice\":8.25,\"customermarkupvalue\":1.5,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":5.5,\"sellingpriceType\":1}],\"editruleoverride\":1},{\"id\":3906,\"labelname\":\"Wand Length\",\"value\":\"750mm\",\"valueid\":\"17580\",\"type\":3,\"optionid\":\"14494\",\"optionvalue\":[{\"optionid\":14494,\"optionqty\":\"1\",\"optionname\":\"750mm\",\"description\":null,\"optioncode\":\"51649\",\"pricegroups\":null,\"unittype\":\"Each\",\"fieldoptionlinkid\":17580,\"forchildfieldoptionlinkid\":\"3_17580\",\"hasstock\":0,\"subdatacount\":0,\"hasprice\":1,\"optionimage\":null,\"unitcost\":0,\"reportprice\":\"0.00\",\"costprice\":0,\"costwithdiscount\":0,\"customersellingprice\":0,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":0,\"sellingpriceType\":1}],\"issubfabric\":0,\"labelnamecode\":\"Wand Length\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":2,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Wand Length\",\"fieldid\":3906,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"14494\",\"optionsvalue\":[{\"optionid\":14494,\"optionqty\":\"1\",\"optionname\":\"750mm\",\"description\":null,\"optioncode\":\"51649\",\"pricegroups\":null,\"unittype\":\"Each\",\"fieldoptionlinkid\":17580,\"forchildfieldoptionlinkid\":\"3_17580\",\"hasstock\":0,\"subdatacount\":0,\"hasprice\":1,\"optionimage\":null,\"unitcost\":0,\"reportprice\":\"0.00\",\"costprice\":0,\"costwithdiscount\":0,\"customersellingprice\":0,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":0,\"sellingpriceType\":1}],\"editruleoverride\":0},{\"id\":3917,\"labelname\":\"Headrail Colour\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Headrail Colour\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Headrail Colour\",\"fieldid\":3917,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3919,\"labelname\":\"Fascia\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fascia\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Fascia\",\"fieldid\":3919,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3921,\"labelname\":\"Product Information\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Product Information\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Product Information\",\"fieldid\":3921,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3926,\"labelname\":\"Extras\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Extras\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Extras\",\"fieldid\":3926,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3928,\"labelname\":\"Special Instrctions\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Special Instrctions\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Special Instrctions\",\"fieldid\":3928,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3927,\"labelname\":\"Fitting\",\"value\":\"Fitting\",\"valueid\":\"17654\",\"type\":3,\"optionid\":\"14553\",\"optionvalue\":[{\"optionid\":14553,\"optionqty\":\"1\",\"optionname\":\"Fitting\",\"description\":null,\"optioncode\":\"14928\",\"pricegroups\":\"Diffused Band A_AAB,Diffused Band B_AAB,Band_A_EAB,Band_B_EAB\",\"unittype\":\"Each\",\"unitcost\":33.33,\"fieldoptionlinkid\":17654,\"forchildfieldoptionlinkid\":\"3_17654\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"33.33\",\"costprice\":33.33,\"costwithdiscount\":33.33,\"customersellingprice\":33.33,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":33.33,\"sellingpriceType\":1}],\"issubfabric\":0,\"labelnamecode\":\"Fitting\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Fitting\",\"fieldid\":3927,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"14553\",\"optionsvalue\":[{\"optionid\":14553,\"optionqty\":\"1\",\"optionname\":\"Fitting\",\"description\":null,\"optioncode\":\"14928\",\"pricegroups\":\"Diffused Band A_AAB,Diffused Band B_AAB,Band_A_EAB,Band_B_EAB\",\"unittype\":\"Each\",\"unitcost\":33.33,\"fieldoptionlinkid\":17654,\"forchildfieldoptionlinkid\":\"3_17654\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"33.33\",\"costprice\":33.33,\"costwithdiscount\":33.33,\"customersellingprice\":33.33,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":33.33,\"sellingpriceType\":1}],\"editruleoverride\":0},{\"id\":3929,\"labelname\":\"Workroom Notes\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Workroom Notes\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Workroom Notes\",\"fieldid\":3929,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Supplier: Excel, Control Type: Wand, Bunch: LH Bunch Wand, Wand Length: 750mm, Fitting: Fitting", "oi_reportdescription": "##Quantity: 1##,##Supplier: Excel##,##Control Type: Wand##,##Bunch: LH Bunch Wand##,##Wand Length: 750mm##,##Fitting: Fitting##", "oi_reporttitles": "##Quantity:<\/br>##Supplier:<\/br>##Control Type:<\/br>##Bunch:<\/br>##Wand Length:<\/br>##Fitting:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":null,\"value\":\"-\",\"formula\":null,\"price\":null,\"recipeid\":null,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":null,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":100,\"value\":null,\"formula\":\"Quantity*2\",\"price\":null,\"recipeid\":60,\"stockupdate\":0,\"fieldid\":17616,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Top Fix\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":121,\"value\":\"1.00\",\"formula\":\"Quantity\",\"price\":\"-\",\"recipeid\":60,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"1.00\"},{\"formula\":\"noFormula\",\"stockupdate\":0,\"isdelete\":0,\"fieldtype_id\":3,\"fractionvalue\":null},{\"formula\":\"noFormula\",\"stockupdate\":0,\"isdelete\":0,\"fieldtype_id\":3,\"fractionvalue\":null},{\"formula\":\"noFormula\",\"stockupdate\":0,\"isdelete\":0,\"fieldtype_id\":3,\"fractionvalue\":null},{\"formula\":\"noFormula\",\"stockupdate\":0,\"isdelete\":0,\"fieldtype_id\":3,\"fractionvalue\":null}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"0.00\",\"cost_with_discount\":\"0.00\",\"cost_with_markup\":\"0.00\",\"gross_price\":\"0.00\",\"vat_price\":\"0.00\"}", "oi_pricecomesfrom_calculations": "{\"label\":\"Price table cost\",\"unit_type\":\"-\",\"cost_price\":\"0.00\",\"show_hide\":true,\"category\":3}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "38.830", "oi_netprice": "41.580", "oi_pricesfromoperations": null, "oi_vatprice": "8.320", "oi_vatvalue": "20.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "49.900", "oi_overrideprice": "0.000", "oi_overridetype": 2, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "41.580", "oi_endcustomeroverridevatprice": "8.320", "oi_endcustomeroverridegrossprice": "49.900", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[3892, 3891, 3895, 3893, 3896, 3897, 3898, 3894, 3904, 3905, 3906, 3917, 3919, 3921, 3926, 3928, 3927, 3929]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "80457", "oi_productiondate": 1748563200, "oi_createdat": 1748436772, "oi_updatedat": 1748416995, "oi_createdby": 14, "oi_updatedby": null }, { "oi_id": 80458, "oi_jobid": 12777, "oi_jobtempid": "0", "oi_jobmultiquoteid": 12781, "oi_productid": 59, "oi_recipeid": 59, "oi_ruleid": 7, "oi_qty": 1, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\": 3523, \"labelname\": \"Quantity\", \"labelnamecode\": \"Quantity\", \"value\": 1, \"valueid\": null, \"type\": 14, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3524, \"labelname\": \"Unit Type\", \"value\": 2, \"valueid\": 2, \"type\": 34, \"optionid\": 2, \"optionvalue\": [{\"optionid\": 1, \"optionname\": \"cm\", \"optioncode\": null, \"optionquantity\": 1, \"unittype\": 0, \"unitcost\": 0, \"pricingtype\": 0, \"fieldoptionlinkid\": 1, \"forchildfieldoptionlinkid\": \"0_1\"}, {\"optionid\": 2, \"optionname\": \"mm\", \"optioncode\": null, \"optionquantity\": 1, \"unittype\": 0, \"unitcost\": 0, \"pricingtype\": 0, \"fieldoptionlinkid\": 2, \"forchildfieldoptionlinkid\": \"0_2\"}, {\"optionid\": 3, \"optionname\": \"m\", \"optioncode\": null, \"optionquantity\": 1, \"unittype\": 0, \"unitcost\": 0, \"pricingtype\": 0, \"fieldoptionlinkid\": 3, \"forchildfieldoptionlinkid\": \"0_3\"}, {\"optionid\": 4, \"optionname\": \"inch\", \"optioncode\": null, \"optionquantity\": 1, \"unittype\": 0, \"unitcost\": 0, \"pricingtype\": 0, \"fieldoptionlinkid\": 4, \"forchildfieldoptionlinkid\": \"0_4\"}], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1, \"labelnamecode\": \"Unit Type\"}, {\"id\": 3525, \"labelname\": \"Supplier\", \"labelnamecode\": \"Supplier\", \"value\": 11, \"valueid\": null, \"type\": 17, \"optionid\": 11, \"optionvalue\": [{\"id\": 11, \"optionid\": 11, \"optionname\": \"Stevens\", \"optionquantity\": 1, \"deleted\": 0}], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3526, \"labelname\": \"Pricing Band\", \"labelnamecode\": \"Pricing Band\", \"value\": \"4133\", \"valueid\": null, \"type\": 13, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3527, \"labelname\": \"Room\", \"labelnamecode\": \"Room\", \"value\": \"\", \"valueid\": null, \"type\": 18, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3528, \"labelname\": \"Size\", \"labelnamecode\": \"Size\", \"value\": \"Recess\", \"valueid\": \"17066\", \"type\": 3, \"optionid\": \"14337\", \"optionvalue\": [{\"optionid\": 14337, \"optionqty\": \"1\", \"description\": \"\", \"optioncode\": \"4098\", \"optionname\": \"Recess\", \"unittype\": null, \"unitcost\": 0, \"fieldoptionlinkid\": 17066, \"forchildfieldoptionlinkid\": \"3_17066\", \"hasstock\": 0, \"hasprice\": 0, \"subdatacount\": 0, \"optionimage\": null, \"reportprice\": \"0.00\", \"costprice\": 0, \"costwithdiscount\": 0, \"customersellingprice\": 0, \"customermarkupvalue\": 1, \"optiontype\": 1, \"quantity\": \"1\"}], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3529, \"labelname\": \"Width\", \"labelnamecode\": \"Width\", \"value\": \"1765\", \"valueid\": null, \"type\": 11, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3530, \"labelname\": \"Drop\", \"labelnamecode\": \"Drop\", \"value\": \"1185\", \"valueid\": null, \"type\": 12, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3531, \"labelname\": \"Fabric\", \"labelnamecode\": \"Fabric1383\", \"value\": null, \"valueid\": null, \"type\": 5, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 1, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3844, \"labelname\": \"Brackets\", \"labelnamecode\": \"Brackets\", \"value\": \"Top Fix Metal \", \"valueid\": \"17381\", \"type\": 3, \"optionid\": \"14340\", \"optionvalue\": [{\"optionid\": 14340, \"optionqty\": \"1.0\", \"description\": \"\", \"optioncode\": \"11298\", \"optionname\": \"Top Fix Metal \", \"unittype\": null, \"unitcost\": 0, \"fieldoptionlinkid\": 17381, \"forchildfieldoptionlinkid\": \"3_17381\", \"hasstock\": 0, \"hasprice\": 1, \"subdatacount\": 0, \"optionimage\": null, \"reportprice\": \"0.00\", \"costprice\": 0, \"costwithdiscount\": 0, \"customersellingprice\": 0, \"customermarkupvalue\": 1, \"optiontype\": 1, \"quantity\": \"1.0\"}], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3845, \"labelname\": \"Headrail System\", \"labelnamecode\": \"Headrail System\", \"value\": \"\", \"valueid\": \"\", \"type\": 3, \"optionid\": \"\", \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3853, \"labelname\": \"Control Type\", \"labelnamecode\": \"Control Type\", \"value\": \"Wand max 3m wide \", \"valueid\": \"17502\", \"type\": 3, \"optionid\": \"14437\", \"optionvalue\": [{\"optionid\": 14437, \"optionqty\": \"1.0\", \"description\": \"\", \"optioncode\": \"18745\", \"optionname\": \"Wand max 3m wide \", \"unittype\": null, \"unitcost\": 0, \"fieldoptionlinkid\": 17502, \"forchildfieldoptionlinkid\": \"3_17502\", \"hasstock\": 0, \"hasprice\": 1, \"subdatacount\": 0, \"optionimage\": null, \"reportprice\": \"0.00\", \"costprice\": 0, \"costwithdiscount\": 0, \"customersellingprice\": 0, \"customermarkupvalue\": 1, \"optiontype\": 1, \"quantity\": \"1.0\"}], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3879, \"labelname\": \"Weights\", \"labelnamecode\": \"Weights\", \"value\": \"Gravity Weights Chainless \", \"valueid\": \"17539\", \"type\": 3, \"optionid\": \"14466\", \"optionvalue\": [{\"optionid\": 14466, \"optionqty\": \"1.0\", \"description\": \"\", \"optioncode\": \"15471\", \"optionname\": \"Gravity Weights Chainless \", \"unittype\": null, \"unitcost\": 0, \"fieldoptionlinkid\": 17539, \"forchildfieldoptionlinkid\": \"3_17539\", \"hasstock\": 0, \"hasprice\": 1, \"subdatacount\": 0, \"optionimage\": null, \"reportprice\": \"0.00\", \"costprice\": 0, \"costwithdiscount\": 0, \"customersellingprice\": 0, \"customermarkupvalue\": 1, \"optiontype\": 1, \"quantity\": \"1.0\"}], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3880, \"labelname\": \"Extras\", \"labelnamecode\": \"Extras\", \"value\": \"\", \"valueid\": null, \"type\": 3, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3888, \"labelname\": \"Fitting\", \"labelnamecode\": \"Fitting\", \"value\": \"Fitting\", \"valueid\": \"17565\", \"type\": 3, \"optionid\": \"14485\", \"optionvalue\": [{\"optionid\": 14485, \"optionqty\": \"1.0\", \"description\": \"\", \"optioncode\": \"18835\", \"optionname\": \"Fitting\", \"unittype\": null, \"unitcost\": 33.33, \"fieldoptionlinkid\": 17565, \"forchildfieldoptionlinkid\": \"3_17565\", \"hasstock\": 0, \"hasprice\": 1, \"subdatacount\": 0, \"optionimage\": null, \"reportprice\": \"0.00\", \"costprice\": 33.33, \"costwithdiscount\": 0, \"customersellingprice\": 0, \"customermarkupvalue\": 1, \"optiontype\": 1, \"quantity\": \"1.0\"}], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3889, \"labelname\": \"Special Instructions\", \"labelnamecode\": \"Special Instructions\", \"value\": \"Silver rail and components\", \"valueid\": null, \"type\": 18, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3890, \"labelname\": \"Workroom Notes\", \"labelnamecode\": \"Workroom Notes\", \"value\": \"\", \"valueid\": null, \"type\": 18, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}]", "oi_description": "Quantity: 1, Unit Type: mm, Supplier: Stevens, Size: Recess, Width: 1765, Drop: 1185, Brackets: Top Fix Metal , Control Type: Wand max 3m wide , Weights: Gravity Weights Chainless , Fitting: Fitting, Special Instructions: Silver rail and components", "oi_reportdescription": "##Quantity: 1##,##Supplier: Stevens##,##Size: Recess##,##Width: 1765 mm##,##Drop: 1185 mm##,##Brackets: Top Fix Metal ##,##Control Type: Wand max 3m wide ##,##Weights: Gravity Weights Chainless ##,##Fitting: Fitting##,##Special Instructions: Silver rail and components##", "oi_reporttitles": "##Quantity: 1##,##Supplier: Stevens##,##Size: Recess##,##Width: 1765 mm##,##Drop: 1185 mm##,##Brackets: Top Fix Metal ##,##Control Type: Wand max 3m wide ##,##Weights: Gravity Weights Chainless ##,##Fitting: Fitting##,##Special Instructions: Silver rail and components##", "oi_productionformulajsondata": "[]", "oi_operationstatus": "", "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "[]", "oi_pricecomesfrom_calculations": "{\"label\": \"Price table cost\", \"unit_type\": \"-\", \"cost_price\": 103.130, \"show_hide\": true, \"category\": 3}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "103.130", "oi_netprice": "175.520", "oi_pricesfromoperations": null, "oi_vatprice": "35.100", "oi_vatvalue": "20.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "210.620", "oi_overrideprice": "210.620", "oi_overridetype": 2, "oi_overridevalue": "210.62", "oi_overridenetprice": "175.520", "oi_overridevatprice": "35.100", "oi_overridegrossprice": "210.620", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 5666, "oi_isonlineorder": 1, "oi_endcustomervatprice": "0.000", "oi_endcustomeroverridetype": 0, "oi_endcustomeroverridevalue": "0", "oi_endcustomeroverridenetprice": "0.000", "oi_endcustomeroverridevatprice": "0.000", "oi_endcustomeroverridegrossprice": "0.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[3523, 3524, 3525, 3526, 3527, 3528, 3529, 3530, 3531, 3844, 3845, 3853, 3879, 3880, 3888, 3889, 3890]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "80458", "oi_productiondate": 1748563200, "oi_createdat": 1748436865, "oi_updatedat": 1748417079, "oi_createdby": 14, "oi_updatedby": 14 }, { "oi_id": 80459, "oi_jobid": 12777, "oi_jobtempid": "0", "oi_jobmultiquoteid": 12781, "oi_productid": 59, "oi_recipeid": 59, "oi_ruleid": 7, "oi_qty": 1, "oi_seq": 2, "oi_customseq": 2, "oi_productcustomseq": 2, "oi_jsondata": "[{\"id\": 3523, \"labelname\": \"Quantity\", \"labelnamecode\": \"Quantity\", \"value\": 1, \"valueid\": null, \"type\": 14, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3524, \"labelname\": \"Unit Type\", \"value\": 2, \"valueid\": 2, \"type\": 34, \"optionid\": 2, \"optionvalue\": [{\"optionid\": 1, \"optionname\": \"cm\", \"optioncode\": null, \"optionquantity\": 1, \"unittype\": 0, \"unitcost\": 0, \"pricingtype\": 0, \"fieldoptionlinkid\": 1, \"forchildfieldoptionlinkid\": \"0_1\"}, {\"optionid\": 2, \"optionname\": \"mm\", \"optioncode\": null, \"optionquantity\": 1, \"unittype\": 0, \"unitcost\": 0, \"pricingtype\": 0, \"fieldoptionlinkid\": 2, \"forchildfieldoptionlinkid\": \"0_2\"}, {\"optionid\": 3, \"optionname\": \"m\", \"optioncode\": null, \"optionquantity\": 1, \"unittype\": 0, \"unitcost\": 0, \"pricingtype\": 0, \"fieldoptionlinkid\": 3, \"forchildfieldoptionlinkid\": \"0_3\"}, {\"optionid\": 4, \"optionname\": \"inch\", \"optioncode\": null, \"optionquantity\": 1, \"unittype\": 0, \"unitcost\": 0, \"pricingtype\": 0, \"fieldoptionlinkid\": 4, \"forchildfieldoptionlinkid\": \"0_4\"}], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1, \"labelnamecode\": \"Unit Type\"}, {\"id\": 3525, \"labelname\": \"Supplier\", \"labelnamecode\": \"Supplier\", \"value\": 11, \"valueid\": null, \"type\": 17, \"optionid\": 11, \"optionvalue\": [{\"id\": 11, \"optionid\": 11, \"optionname\": \"Stevens\", \"optionquantity\": 1, \"deleted\": 0}], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3526, \"labelname\": \"Pricing Band\", \"labelnamecode\": \"Pricing Band\", \"value\": \"4133\", \"valueid\": null, \"type\": 13, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3527, \"labelname\": \"Room\", \"labelnamecode\": \"Room\", \"value\": \"\", \"valueid\": null, \"type\": 18, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3528, \"labelname\": \"Size\", \"labelnamecode\": \"Size\", \"value\": \"Recess\", \"valueid\": \"17066\", \"type\": 3, \"optionid\": \"14337\", \"optionvalue\": [{\"optionid\": 14337, \"optionqty\": \"1\", \"description\": \"\", \"optioncode\": \"4098\", \"optionname\": \"Recess\", \"unittype\": null, \"unitcost\": 0, \"fieldoptionlinkid\": 17066, \"forchildfieldoptionlinkid\": \"3_17066\", \"hasstock\": 0, \"hasprice\": 0, \"subdatacount\": 0, \"optionimage\": null, \"reportprice\": \"0.00\", \"costprice\": 0, \"costwithdiscount\": 0, \"customersellingprice\": 0, \"customermarkupvalue\": 1, \"optiontype\": 1, \"quantity\": \"1\"}], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3529, \"labelname\": \"Width\", \"labelnamecode\": \"Width\", \"value\": \"1783\", \"valueid\": null, \"type\": 11, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3530, \"labelname\": \"Drop\", \"labelnamecode\": \"Drop\", \"value\": \"1180\", \"valueid\": null, \"type\": 12, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3531, \"labelname\": \"Fabric\", \"labelnamecode\": \"Fabric1383\", \"value\": null, \"valueid\": null, \"type\": 5, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 1, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3844, \"labelname\": \"Brackets\", \"labelnamecode\": \"Brackets\", \"value\": \"Top Fix Metal \", \"valueid\": \"17381\", \"type\": 3, \"optionid\": \"14340\", \"optionvalue\": [{\"optionid\": 14340, \"optionqty\": \"1.0\", \"description\": \"\", \"optioncode\": \"11298\", \"optionname\": \"Top Fix Metal \", \"unittype\": null, \"unitcost\": 0, \"fieldoptionlinkid\": 17381, \"forchildfieldoptionlinkid\": \"3_17381\", \"hasstock\": 0, \"hasprice\": 1, \"subdatacount\": 0, \"optionimage\": null, \"reportprice\": \"0.00\", \"costprice\": 0, \"costwithdiscount\": 0, \"customersellingprice\": 0, \"customermarkupvalue\": 1, \"optiontype\": 1, \"quantity\": \"1.0\"}], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3845, \"labelname\": \"Headrail System\", \"labelnamecode\": \"Headrail System\", \"value\": \"\", \"valueid\": \"\", \"type\": 3, \"optionid\": \"\", \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3853, \"labelname\": \"Control Type\", \"labelnamecode\": \"Control Type\", \"value\": \"Wand max 3m wide \", \"valueid\": \"17502\", \"type\": 3, \"optionid\": \"14437\", \"optionvalue\": [{\"optionid\": 14437, \"optionqty\": \"1.0\", \"description\": \"\", \"optioncode\": \"18745\", \"optionname\": \"Wand max 3m wide \", \"unittype\": null, \"unitcost\": 0, \"fieldoptionlinkid\": 17502, \"forchildfieldoptionlinkid\": \"3_17502\", \"hasstock\": 0, \"hasprice\": 1, \"subdatacount\": 0, \"optionimage\": null, \"reportprice\": \"0.00\", \"costprice\": 0, \"costwithdiscount\": 0, \"customersellingprice\": 0, \"customermarkupvalue\": 1, \"optiontype\": 1, \"quantity\": \"1.0\"}], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3879, \"labelname\": \"Weights\", \"labelnamecode\": \"Weights\", \"value\": \"Gravity Weights Chainless \", \"valueid\": \"17539\", \"type\": 3, \"optionid\": \"14466\", \"optionvalue\": [{\"optionid\": 14466, \"optionqty\": \"1.0\", \"description\": \"\", \"optioncode\": \"15471\", \"optionname\": \"Gravity Weights Chainless \", \"unittype\": null, \"unitcost\": 0, \"fieldoptionlinkid\": 17539, \"forchildfieldoptionlinkid\": \"3_17539\", \"hasstock\": 0, \"hasprice\": 1, \"subdatacount\": 0, \"optionimage\": null, \"reportprice\": \"0.00\", \"costprice\": 0, \"costwithdiscount\": 0, \"customersellingprice\": 0, \"customermarkupvalue\": 1, \"optiontype\": 1, \"quantity\": \"1.0\"}], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3880, \"labelname\": \"Extras\", \"labelnamecode\": \"Extras\", \"value\": \"\", \"valueid\": null, \"type\": 3, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3888, \"labelname\": \"Fitting\", \"labelnamecode\": \"Fitting\", \"value\": \"Fitting\", \"valueid\": \"17565\", \"type\": 3, \"optionid\": \"14485\", \"optionvalue\": [{\"optionid\": 14485, \"optionqty\": \"1.0\", \"description\": \"\", \"optioncode\": \"18835\", \"optionname\": \"Fitting\", \"unittype\": null, \"unitcost\": 33.33, \"fieldoptionlinkid\": 17565, \"forchildfieldoptionlinkid\": \"3_17565\", \"hasstock\": 0, \"hasprice\": 1, \"subdatacount\": 0, \"optionimage\": null, \"reportprice\": \"0.00\", \"costprice\": 33.33, \"costwithdiscount\": 0, \"customersellingprice\": 0, \"customermarkupvalue\": 1, \"optiontype\": 1, \"quantity\": \"1.0\"}], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3889, \"labelname\": \"Special Instructions\", \"labelnamecode\": \"Special Instructions\", \"value\": \"\", \"valueid\": null, \"type\": 18, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3890, \"labelname\": \"Workroom Notes\", \"labelnamecode\": \"Workroom Notes\", \"value\": \"Silver rail and components\", \"valueid\": null, \"type\": 18, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}]", "oi_description": "Quantity: 1, Unit Type: mm, Supplier: Stevens, Size: Recess, Width: 1783, Drop: 1180, Brackets: Top Fix Metal , Control Type: Wand max 3m wide , Weights: Gravity Weights Chainless , Fitting: Fitting, Workroom Notes: Silver rail and components", "oi_reportdescription": "##Quantity: 1##,##Supplier: Stevens##,##Size: Recess##,##Width: 1783 mm##,##Drop: 1180 mm##,##Brackets: Top Fix Metal ##,##Control Type: Wand max 3m wide ##,##Weights: Gravity Weights Chainless ##,##Fitting: Fitting##,##Workroom Notes: Silver rail and components##", "oi_reporttitles": "##Quantity: 1##,##Supplier: Stevens##,##Size: Recess##,##Width: 1783 mm##,##Drop: 1180 mm##,##Brackets: Top Fix Metal ##,##Control Type: Wand max 3m wide ##,##Weights: Gravity Weights Chainless ##,##Fitting: Fitting##,##Workroom Notes: Silver rail and components##", "oi_productionformulajsondata": "[]", "oi_operationstatus": "", "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "[]", "oi_pricecomesfrom_calculations": "{\"label\": \"Price table cost\", \"unit_type\": \"-\", \"cost_price\": 103.180, \"show_hide\": true, \"category\": 3}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "103.180", "oi_netprice": "175.570", "oi_pricesfromoperations": null, "oi_vatprice": "35.110", "oi_vatvalue": "20.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "210.690", "oi_overrideprice": "210.690", "oi_overridetype": 2, "oi_overridevalue": "210.69", "oi_overridenetprice": "175.570", "oi_overridevatprice": "35.120", "oi_overridegrossprice": "210.690", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 5667, "oi_isonlineorder": 1, "oi_endcustomervatprice": "0.000", "oi_endcustomeroverridetype": 0, "oi_endcustomeroverridevalue": "0", "oi_endcustomeroverridenetprice": "0.000", "oi_endcustomeroverridevatprice": "0.000", "oi_endcustomeroverridegrossprice": "0.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[3523, 3524, 3525, 3526, 3527, 3528, 3529, 3530, 3531, 3844, 3845, 3853, 3879, 3880, 3888, 3889, 3890]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "80459", "oi_productiondate": 1748563200, "oi_createdat": 1748436865, "oi_updatedat": 1748417079, "oi_createdby": 14, "oi_updatedby": 14 }, { "oi_id": 80460, "oi_jobid": 12778, "oi_jobtempid": "0", "oi_jobmultiquoteid": 12782, "oi_productid": 248, "oi_recipeid": 248, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 0, "oi_customseq": 0, "oi_productcustomseq": 0, "oi_jsondata": "[{\"id\":22031,\"labelname\":\"Unit Type\",\"value\":2,\"valueid\":\"2\",\"type\":34,\"optionid\":\"2\",\"optionvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":\"\",\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22030,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22034,\"labelname\":\"Room\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22032,\"labelname\":\"Supplier\",\"value\":37,\"valueid\":\"\",\"type\":17,\"optionid\":\"37\",\"optionvalue\":[{\"id\":37,\"optionid\":37,\"optionname\":\"Master Blinds\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22036,\"labelname\":\"Width\",\"value\":\"800\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22037,\"labelname\":\"Drop\",\"value\":\"800\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22038,\"labelname\":\"Fabric\",\"value\":\"Elan Metallic Duotone\",\"valueid\":\"16043\",\"type\":5,\"optionid\":\"16043\",\"optionvalue\":[{\"optionid\":16043,\"optionname\":\"Elan Metallic Duotone\",\"optionquantity\":1,\"fieldoptionlinkid\":16043,\"forchildfieldoptionlinkid\":\"5_2_16043_1\",\"optionimage\":\"\",\"subdatacount\":1,\"pricegroup\":\"Smartcord Band C_MBCB\",\"pricegroupid\":1444}],\"fabricorcolor\":1,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22134,\"labelname\":\"Color\",\"value\":\"Bronze 4720\",\"valueid\":\"81957\",\"type\":5,\"optionid\":\"81957\",\"optionvalue\":[{\"optionid\":81957,\"optionname\":\"Bronze 4720\",\"optionquantity\":1,\"fieldoptionlinkid\":81957,\"forchildfieldoptionlinkid\":\"5_3_81957_1\",\"minimumdiscount\":\"\",\"maximumdiscount\":\"\",\"optionimage\":\"\",\"subdatacount\":0}],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22033,\"labelname\":\"Product Type\",\"value\":1444,\"valueid\":\"1444\",\"type\":13,\"optionid\":\"1444\",\"optionvalue\":[{\"id\":1444,\"fieldid\":22033,\"fieldoptionlinkid\":1444,\"optionid\":1444,\"mainsupplier\":37,\"blindtypecode\":\"\",\"optionname\":\"Smartcord Band C_MBCB\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22685,\"labelname\":\"Special Instructions\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22686,\"labelname\":\"Workroom Notes\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]", "oi_description": "Unit Type: mm, Quantity: 1, Supplier: Master Blinds, Width: 800, Drop: 800, Fabric: Elan Metallic Duotone, Color: Bronze 4720, Product Type: Smartcord Band C_MBCB", "oi_reportdescription": "##Quantity: 1##,##Supplier: Master Blinds##,##Width: 800 mm##,##Drop: 800 mm##,##Fabric: Elan Metallic Duotone##,##Color: Bronze 4720##,##Product Type: Smartcord Band C_MBCB##", "oi_reporttitles": "##Quantity:##Supplier:##Width:##Drop:##Fabric:##Color:##Product Type:", "oi_productionformulajsondata": "[]", "oi_operationstatus": null, "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "[]", "oi_pricecomesfrom_calculations": "{}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "0.000", "oi_netprice": "0.000", "oi_pricesfromoperations": null, "oi_vatprice": "0.000", "oi_vatvalue": "20.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "0.000", "oi_overrideprice": "0.000", "oi_overridetype": 2, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 0, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 2, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "0.000", "oi_endcustomeroverridevatprice": "0.000", "oi_endcustomeroverridegrossprice": "0.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[22031, 22030, 22034, 22032, 22036, 22037, 22038, 22134, 22033, 22685, 22686]", "oi_deviceplatform": 2, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "80460", "oi_productiondate": 1748417085, "oi_createdat": 1748417121, "oi_updatedat": 1748417134, "oi_createdby": 1, "oi_updatedby": null } ], "updated": [ { "oi_id": 80458, "oi_jobid": 12777, "oi_jobtempid": "0", "oi_jobmultiquoteid": 12781, "oi_productid": 59, "oi_recipeid": 59, "oi_ruleid": 7, "oi_qty": 1, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\": 3523, \"labelname\": \"Quantity\", \"labelnamecode\": \"Quantity\", \"value\": 1, \"valueid\": null, \"type\": 14, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3524, \"labelname\": \"Unit Type\", \"value\": 2, \"valueid\": 2, \"type\": 34, \"optionid\": 2, \"optionvalue\": [{\"optionid\": 1, \"optionname\": \"cm\", \"optioncode\": null, \"optionquantity\": 1, \"unittype\": 0, \"unitcost\": 0, \"pricingtype\": 0, \"fieldoptionlinkid\": 1, \"forchildfieldoptionlinkid\": \"0_1\"}, {\"optionid\": 2, \"optionname\": \"mm\", \"optioncode\": null, \"optionquantity\": 1, \"unittype\": 0, \"unitcost\": 0, \"pricingtype\": 0, \"fieldoptionlinkid\": 2, \"forchildfieldoptionlinkid\": \"0_2\"}, {\"optionid\": 3, \"optionname\": \"m\", \"optioncode\": null, \"optionquantity\": 1, \"unittype\": 0, \"unitcost\": 0, \"pricingtype\": 0, \"fieldoptionlinkid\": 3, \"forchildfieldoptionlinkid\": \"0_3\"}, {\"optionid\": 4, \"optionname\": \"inch\", \"optioncode\": null, \"optionquantity\": 1, \"unittype\": 0, \"unitcost\": 0, \"pricingtype\": 0, \"fieldoptionlinkid\": 4, \"forchildfieldoptionlinkid\": \"0_4\"}], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1, \"labelnamecode\": \"Unit Type\"}, {\"id\": 3525, \"labelname\": \"Supplier\", \"labelnamecode\": \"Supplier\", \"value\": 11, \"valueid\": null, \"type\": 17, \"optionid\": 11, \"optionvalue\": [{\"id\": 11, \"optionid\": 11, \"optionname\": \"Stevens\", \"optionquantity\": 1, \"deleted\": 0}], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3526, \"labelname\": \"Pricing Band\", \"labelnamecode\": \"Pricing Band\", \"value\": \"4133\", \"valueid\": null, \"type\": 13, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3527, \"labelname\": \"Room\", \"labelnamecode\": \"Room\", \"value\": \"\", \"valueid\": null, \"type\": 18, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3528, \"labelname\": \"Size\", \"labelnamecode\": \"Size\", \"value\": \"Recess\", \"valueid\": \"17066\", \"type\": 3, \"optionid\": \"14337\", \"optionvalue\": [{\"optionid\": 14337, \"optionqty\": \"1\", \"description\": \"\", \"optioncode\": \"4098\", \"optionname\": \"Recess\", \"unittype\": null, \"unitcost\": 0, \"fieldoptionlinkid\": 17066, \"forchildfieldoptionlinkid\": \"3_17066\", \"hasstock\": 0, \"hasprice\": 0, \"subdatacount\": 0, \"optionimage\": null, \"reportprice\": \"0.00\", \"costprice\": 0, \"costwithdiscount\": 0, \"customersellingprice\": 0, \"customermarkupvalue\": 1, \"optiontype\": 1, \"quantity\": \"1\"}], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3529, \"labelname\": \"Width\", \"labelnamecode\": \"Width\", \"value\": \"1765\", \"valueid\": null, \"type\": 11, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3530, \"labelname\": \"Drop\", \"labelnamecode\": \"Drop\", \"value\": \"1185\", \"valueid\": null, \"type\": 12, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3531, \"labelname\": \"Fabric\", \"labelnamecode\": \"Fabric1383\", \"value\": null, \"valueid\": null, \"type\": 5, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 1, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3844, \"labelname\": \"Brackets\", \"labelnamecode\": \"Brackets\", \"value\": \"Top Fix Metal \", \"valueid\": \"17381\", \"type\": 3, \"optionid\": \"14340\", \"optionvalue\": [{\"optionid\": 14340, \"optionqty\": \"1.0\", \"description\": \"\", \"optioncode\": \"11298\", \"optionname\": \"Top Fix Metal \", \"unittype\": null, \"unitcost\": 0, \"fieldoptionlinkid\": 17381, \"forchildfieldoptionlinkid\": \"3_17381\", \"hasstock\": 0, \"hasprice\": 1, \"subdatacount\": 0, \"optionimage\": null, \"reportprice\": \"0.00\", \"costprice\": 0, \"costwithdiscount\": 0, \"customersellingprice\": 0, \"customermarkupvalue\": 1, \"optiontype\": 1, \"quantity\": \"1.0\"}], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3845, \"labelname\": \"Headrail System\", \"labelnamecode\": \"Headrail System\", \"value\": \"\", \"valueid\": \"\", \"type\": 3, \"optionid\": \"\", \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3853, \"labelname\": \"Control Type\", \"labelnamecode\": \"Control Type\", \"value\": \"Wand max 3m wide \", \"valueid\": \"17502\", \"type\": 3, \"optionid\": \"14437\", \"optionvalue\": [{\"optionid\": 14437, \"optionqty\": \"1.0\", \"description\": \"\", \"optioncode\": \"18745\", \"optionname\": \"Wand max 3m wide \", \"unittype\": null, \"unitcost\": 0, \"fieldoptionlinkid\": 17502, \"forchildfieldoptionlinkid\": \"3_17502\", \"hasstock\": 0, \"hasprice\": 1, \"subdatacount\": 0, \"optionimage\": null, \"reportprice\": \"0.00\", \"costprice\": 0, \"costwithdiscount\": 0, \"customersellingprice\": 0, \"customermarkupvalue\": 1, \"optiontype\": 1, \"quantity\": \"1.0\"}], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3879, \"labelname\": \"Weights\", \"labelnamecode\": \"Weights\", \"value\": \"Gravity Weights Chainless \", \"valueid\": \"17539\", \"type\": 3, \"optionid\": \"14466\", \"optionvalue\": [{\"optionid\": 14466, \"optionqty\": \"1.0\", \"description\": \"\", \"optioncode\": \"15471\", \"optionname\": \"Gravity Weights Chainless \", \"unittype\": null, \"unitcost\": 0, \"fieldoptionlinkid\": 17539, \"forchildfieldoptionlinkid\": \"3_17539\", \"hasstock\": 0, \"hasprice\": 1, \"subdatacount\": 0, \"optionimage\": null, \"reportprice\": \"0.00\", \"costprice\": 0, \"costwithdiscount\": 0, \"customersellingprice\": 0, \"customermarkupvalue\": 1, \"optiontype\": 1, \"quantity\": \"1.0\"}], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3880, \"labelname\": \"Extras\", \"labelnamecode\": \"Extras\", \"value\": \"\", \"valueid\": null, \"type\": 3, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3888, \"labelname\": \"Fitting\", \"labelnamecode\": \"Fitting\", \"value\": \"Fitting\", \"valueid\": \"17565\", \"type\": 3, \"optionid\": \"14485\", \"optionvalue\": [{\"optionid\": 14485, \"optionqty\": \"1.0\", \"description\": \"\", \"optioncode\": \"18835\", \"optionname\": \"Fitting\", \"unittype\": null, \"unitcost\": 33.33, \"fieldoptionlinkid\": 17565, \"forchildfieldoptionlinkid\": \"3_17565\", \"hasstock\": 0, \"hasprice\": 1, \"subdatacount\": 0, \"optionimage\": null, \"reportprice\": \"0.00\", \"costprice\": 33.33, \"costwithdiscount\": 0, \"customersellingprice\": 0, \"customermarkupvalue\": 1, \"optiontype\": 1, \"quantity\": \"1.0\"}], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3889, \"labelname\": \"Special Instructions\", \"labelnamecode\": \"Special Instructions\", \"value\": \"Silver rail and components\", \"valueid\": null, \"type\": 18, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3890, \"labelname\": \"Workroom Notes\", \"labelnamecode\": \"Workroom Notes\", \"value\": \"\", \"valueid\": null, \"type\": 18, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}]", "oi_description": "Quantity: 1, Unit Type: mm, Supplier: Stevens, Size: Recess, Width: 1765, Drop: 1185, Brackets: Top Fix Metal , Control Type: Wand max 3m wide , Weights: Gravity Weights Chainless , Fitting: Fitting, Special Instructions: Silver rail and components", "oi_reportdescription": "##Quantity: 1##,##Supplier: Stevens##,##Size: Recess##,##Width: 1765 mm##,##Drop: 1185 mm##,##Brackets: Top Fix Metal ##,##Control Type: Wand max 3m wide ##,##Weights: Gravity Weights Chainless ##,##Fitting: Fitting##,##Special Instructions: Silver rail and components##", "oi_reporttitles": "##Quantity: 1##,##Supplier: Stevens##,##Size: Recess##,##Width: 1765 mm##,##Drop: 1185 mm##,##Brackets: Top Fix Metal ##,##Control Type: Wand max 3m wide ##,##Weights: Gravity Weights Chainless ##,##Fitting: Fitting##,##Special Instructions: Silver rail and components##", "oi_productionformulajsondata": "[]", "oi_operationstatus": "", "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "[]", "oi_pricecomesfrom_calculations": "{\"label\": \"Price table cost\", \"unit_type\": \"-\", \"cost_price\": 103.130, \"show_hide\": true, \"category\": 3}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "103.130", "oi_netprice": "175.520", "oi_pricesfromoperations": null, "oi_vatprice": "35.100", "oi_vatvalue": "20.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "210.620", "oi_overrideprice": "210.620", "oi_overridetype": 2, "oi_overridevalue": "210.62", "oi_overridenetprice": "175.520", "oi_overridevatprice": "35.100", "oi_overridegrossprice": "210.620", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 5666, "oi_isonlineorder": 1, "oi_endcustomervatprice": "0.000", "oi_endcustomeroverridetype": 0, "oi_endcustomeroverridevalue": "0", "oi_endcustomeroverridenetprice": "0.000", "oi_endcustomeroverridevatprice": "0.000", "oi_endcustomeroverridegrossprice": "0.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[3523, 3524, 3525, 3526, 3527, 3528, 3529, 3530, 3531, 3844, 3845, 3853, 3879, 3880, 3888, 3889, 3890]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "80458", "oi_productiondate": 1748563200, "oi_createdat": 1748436865, "oi_updatedat": 1748417079, "oi_createdby": 14, "oi_updatedby": 14 }, { "oi_id": 80459, "oi_jobid": 12777, "oi_jobtempid": "0", "oi_jobmultiquoteid": 12781, "oi_productid": 59, "oi_recipeid": 59, "oi_ruleid": 7, "oi_qty": 1, "oi_seq": 2, "oi_customseq": 2, "oi_productcustomseq": 2, "oi_jsondata": "[{\"id\": 3523, \"labelname\": \"Quantity\", \"labelnamecode\": \"Quantity\", \"value\": 1, \"valueid\": null, \"type\": 14, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3524, \"labelname\": \"Unit Type\", \"value\": 2, \"valueid\": 2, \"type\": 34, \"optionid\": 2, \"optionvalue\": [{\"optionid\": 1, \"optionname\": \"cm\", \"optioncode\": null, \"optionquantity\": 1, \"unittype\": 0, \"unitcost\": 0, \"pricingtype\": 0, \"fieldoptionlinkid\": 1, \"forchildfieldoptionlinkid\": \"0_1\"}, {\"optionid\": 2, \"optionname\": \"mm\", \"optioncode\": null, \"optionquantity\": 1, \"unittype\": 0, \"unitcost\": 0, \"pricingtype\": 0, \"fieldoptionlinkid\": 2, \"forchildfieldoptionlinkid\": \"0_2\"}, {\"optionid\": 3, \"optionname\": \"m\", \"optioncode\": null, \"optionquantity\": 1, \"unittype\": 0, \"unitcost\": 0, \"pricingtype\": 0, \"fieldoptionlinkid\": 3, \"forchildfieldoptionlinkid\": \"0_3\"}, {\"optionid\": 4, \"optionname\": \"inch\", \"optioncode\": null, \"optionquantity\": 1, \"unittype\": 0, \"unitcost\": 0, \"pricingtype\": 0, \"fieldoptionlinkid\": 4, \"forchildfieldoptionlinkid\": \"0_4\"}], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1, \"labelnamecode\": \"Unit Type\"}, {\"id\": 3525, \"labelname\": \"Supplier\", \"labelnamecode\": \"Supplier\", \"value\": 11, \"valueid\": null, \"type\": 17, \"optionid\": 11, \"optionvalue\": [{\"id\": 11, \"optionid\": 11, \"optionname\": \"Stevens\", \"optionquantity\": 1, \"deleted\": 0}], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3526, \"labelname\": \"Pricing Band\", \"labelnamecode\": \"Pricing Band\", \"value\": \"4133\", \"valueid\": null, \"type\": 13, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3527, \"labelname\": \"Room\", \"labelnamecode\": \"Room\", \"value\": \"\", \"valueid\": null, \"type\": 18, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3528, \"labelname\": \"Size\", \"labelnamecode\": \"Size\", \"value\": \"Recess\", \"valueid\": \"17066\", \"type\": 3, \"optionid\": \"14337\", \"optionvalue\": [{\"optionid\": 14337, \"optionqty\": \"1\", \"description\": \"\", \"optioncode\": \"4098\", \"optionname\": \"Recess\", \"unittype\": null, \"unitcost\": 0, \"fieldoptionlinkid\": 17066, \"forchildfieldoptionlinkid\": \"3_17066\", \"hasstock\": 0, \"hasprice\": 0, \"subdatacount\": 0, \"optionimage\": null, \"reportprice\": \"0.00\", \"costprice\": 0, \"costwithdiscount\": 0, \"customersellingprice\": 0, \"customermarkupvalue\": 1, \"optiontype\": 1, \"quantity\": \"1\"}], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3529, \"labelname\": \"Width\", \"labelnamecode\": \"Width\", \"value\": \"1783\", \"valueid\": null, \"type\": 11, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3530, \"labelname\": \"Drop\", \"labelnamecode\": \"Drop\", \"value\": \"1180\", \"valueid\": null, \"type\": 12, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3531, \"labelname\": \"Fabric\", \"labelnamecode\": \"Fabric1383\", \"value\": null, \"valueid\": null, \"type\": 5, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 1, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3844, \"labelname\": \"Brackets\", \"labelnamecode\": \"Brackets\", \"value\": \"Top Fix Metal \", \"valueid\": \"17381\", \"type\": 3, \"optionid\": \"14340\", \"optionvalue\": [{\"optionid\": 14340, \"optionqty\": \"1.0\", \"description\": \"\", \"optioncode\": \"11298\", \"optionname\": \"Top Fix Metal \", \"unittype\": null, \"unitcost\": 0, \"fieldoptionlinkid\": 17381, \"forchildfieldoptionlinkid\": \"3_17381\", \"hasstock\": 0, \"hasprice\": 1, \"subdatacount\": 0, \"optionimage\": null, \"reportprice\": \"0.00\", \"costprice\": 0, \"costwithdiscount\": 0, \"customersellingprice\": 0, \"customermarkupvalue\": 1, \"optiontype\": 1, \"quantity\": \"1.0\"}], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3845, \"labelname\": \"Headrail System\", \"labelnamecode\": \"Headrail System\", \"value\": \"\", \"valueid\": \"\", \"type\": 3, \"optionid\": \"\", \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3853, \"labelname\": \"Control Type\", \"labelnamecode\": \"Control Type\", \"value\": \"Wand max 3m wide \", \"valueid\": \"17502\", \"type\": 3, \"optionid\": \"14437\", \"optionvalue\": [{\"optionid\": 14437, \"optionqty\": \"1.0\", \"description\": \"\", \"optioncode\": \"18745\", \"optionname\": \"Wand max 3m wide \", \"unittype\": null, \"unitcost\": 0, \"fieldoptionlinkid\": 17502, \"forchildfieldoptionlinkid\": \"3_17502\", \"hasstock\": 0, \"hasprice\": 1, \"subdatacount\": 0, \"optionimage\": null, \"reportprice\": \"0.00\", \"costprice\": 0, \"costwithdiscount\": 0, \"customersellingprice\": 0, \"customermarkupvalue\": 1, \"optiontype\": 1, \"quantity\": \"1.0\"}], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3879, \"labelname\": \"Weights\", \"labelnamecode\": \"Weights\", \"value\": \"Gravity Weights Chainless \", \"valueid\": \"17539\", \"type\": 3, \"optionid\": \"14466\", \"optionvalue\": [{\"optionid\": 14466, \"optionqty\": \"1.0\", \"description\": \"\", \"optioncode\": \"15471\", \"optionname\": \"Gravity Weights Chainless \", \"unittype\": null, \"unitcost\": 0, \"fieldoptionlinkid\": 17539, \"forchildfieldoptionlinkid\": \"3_17539\", \"hasstock\": 0, \"hasprice\": 1, \"subdatacount\": 0, \"optionimage\": null, \"reportprice\": \"0.00\", \"costprice\": 0, \"costwithdiscount\": 0, \"customersellingprice\": 0, \"customermarkupvalue\": 1, \"optiontype\": 1, \"quantity\": \"1.0\"}], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3880, \"labelname\": \"Extras\", \"labelnamecode\": \"Extras\", \"value\": \"\", \"valueid\": null, \"type\": 3, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3888, \"labelname\": \"Fitting\", \"labelnamecode\": \"Fitting\", \"value\": \"Fitting\", \"valueid\": \"17565\", \"type\": 3, \"optionid\": \"14485\", \"optionvalue\": [{\"optionid\": 14485, \"optionqty\": \"1.0\", \"description\": \"\", \"optioncode\": \"18835\", \"optionname\": \"Fitting\", \"unittype\": null, \"unitcost\": 33.33, \"fieldoptionlinkid\": 17565, \"forchildfieldoptionlinkid\": \"3_17565\", \"hasstock\": 0, \"hasprice\": 1, \"subdatacount\": 0, \"optionimage\": null, \"reportprice\": \"0.00\", \"costprice\": 33.33, \"costwithdiscount\": 0, \"customersellingprice\": 0, \"customermarkupvalue\": 1, \"optiontype\": 1, \"quantity\": \"1.0\"}], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3889, \"labelname\": \"Special Instructions\", \"labelnamecode\": \"Special Instructions\", \"value\": \"\", \"valueid\": null, \"type\": 18, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}, {\"id\": 3890, \"labelname\": \"Workroom Notes\", \"labelnamecode\": \"Workroom Notes\", \"value\": \"Silver rail and components\", \"valueid\": null, \"type\": 18, \"optionid\": null, \"optionvalue\": [], \"fabricorcolor\": 0, \"widthfraction\": \"\", \"widthfractiontext\": \"\", \"dropfractiontext\": \"\", \"dropfraction\": \"\", \"editruleoverride\": 0, \"showfieldonjob\": 1, \"optionquantity\": null, \"globaledit\": false, \"issubfabric\": 0, \"showFieldOnCustomerPortal\": 1}]", "oi_description": "Quantity: 1, Unit Type: mm, Supplier: Stevens, Size: Recess, Width: 1783, Drop: 1180, Brackets: Top Fix Metal , Control Type: Wand max 3m wide , Weights: Gravity Weights Chainless , Fitting: Fitting, Workroom Notes: Silver rail and components", "oi_reportdescription": "##Quantity: 1##,##Supplier: Stevens##,##Size: Recess##,##Width: 1783 mm##,##Drop: 1180 mm##,##Brackets: Top Fix Metal ##,##Control Type: Wand max 3m wide ##,##Weights: Gravity Weights Chainless ##,##Fitting: Fitting##,##Workroom Notes: Silver rail and components##", "oi_reporttitles": "##Quantity: 1##,##Supplier: Stevens##,##Size: Recess##,##Width: 1783 mm##,##Drop: 1180 mm##,##Brackets: Top Fix Metal ##,##Control Type: Wand max 3m wide ##,##Weights: Gravity Weights Chainless ##,##Fitting: Fitting##,##Workroom Notes: Silver rail and components##", "oi_productionformulajsondata": "[]", "oi_operationstatus": "", "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "[]", "oi_pricecomesfrom_calculations": "{\"label\": \"Price table cost\", \"unit_type\": \"-\", \"cost_price\": 103.180, \"show_hide\": true, \"category\": 3}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "103.180", "oi_netprice": "175.570", "oi_pricesfromoperations": null, "oi_vatprice": "35.110", "oi_vatvalue": "20.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "210.690", "oi_overrideprice": "210.690", "oi_overridetype": 2, "oi_overridevalue": "210.69", "oi_overridenetprice": "175.570", "oi_overridevatprice": "35.120", "oi_overridegrossprice": "210.690", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 5667, "oi_isonlineorder": 1, "oi_endcustomervatprice": "0.000", "oi_endcustomeroverridetype": 0, "oi_endcustomeroverridevalue": "0", "oi_endcustomeroverridenetprice": "0.000", "oi_endcustomeroverridevatprice": "0.000", "oi_endcustomeroverridegrossprice": "0.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[3523, 3524, 3525, 3526, 3527, 3528, 3529, 3530, 3531, 3844, 3845, 3853, 3879, 3880, 3888, 3889, 3890]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "80459", "oi_productiondate": 1748563200, "oi_createdat": 1748436865, "oi_updatedat": 1748417079, "oi_createdby": 14, "oi_updatedby": 14 } ], "deleted": [] }, "bm_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_notelist": { "created": [ { "nl_id": 485594, "nl_ordertempid": 0, "nl_orderid": 12778, "nl_notescategory": 1, "nl_type": 5, "nl_platform": 2, "nl_desc": "New job has been created in job", "nl_manualNotes": null, "nl_createdby": "1", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 0, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "485594", "nl_endddate": 1748390400, "nl_starttime": 1748417077, "created_at": 1748417077, "updated_at": 1748417133, "created_by": 1, "updated_by": null } ], "updated": [], "deleted": [] }, "bm_deliveryaddresssetting": { "created": [ { "das_id": 12744, "das_jobid": 12776, "das_appointmentaddress": 7295, "das_invoiceaddress": 7295, "das_invoicedeliveryaddress": 0, "das_purchaseaddress": 0, "das_worksheetaddress": 0, "id": "12744", "das_createdat": 1748416963, "das_updatedat": 1748416963, "das_createdby": 14, "das_updatedby": null }, { "das_id": 12745, "das_jobid": 12777, "das_appointmentaddress": 1014, "das_invoiceaddress": 1014, "das_invoicedeliveryaddress": 0, "das_purchaseaddress": 0, "das_worksheetaddress": 0, "id": "12745", "das_createdat": 1748417074, "das_updatedat": 1748417074, "das_createdby": 14, "das_updatedby": null } ], "updated": [], "deleted": [] }, "bm_jobchecklist": { "created": [], "updated": [], "deleted": [] }, "bm_Invoice": { "created": [], "updated": [], "deleted": [] }, "bm_InvoiceDetails": { "created": [], "updated": [], "deleted": [] }, "bm_invoice_credit_note": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNote": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNoteDetails": { "created": [], "updated": [], "deleted": [] }, "bm_job_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_OverPayment": { "created": [], "updated": [], "deleted": [] }, "bm_terms": { "created": [ { "termsid": 231470, "orderid": 12776, "jobmultiquoteid": 12780, "isresportshow": 1, "termsCategory": 3, "termsName": "Standard", "termsDescription": "", "status": 0, "seq": 1, "id": "231470", "created_at": 1748416963, "updated_at": 1748416963, "terms_created_at": 1722585567, "created_by": null, "updated_by": null }, { "termsid": 231471, "orderid": 12776, "jobmultiquoteid": 12780, "isresportshow": 1, "termsCategory": 4, "termsName": "Standard", "termsDescription": "", "status": 0, "seq": 1, "id": "231471", "created_at": 1748416963, "updated_at": 1748416963, "terms_created_at": 1722585567, "created_by": null, "updated_by": null }, { "termsid": 231472, "orderid": 12777, "jobmultiquoteid": 12781, "isresportshow": 1, "termsCategory": 3, "termsName": "Standard", "termsDescription": "", "status": 0, "seq": 1, "id": "231472", "created_at": 1748417074, "updated_at": 1748417074, "terms_created_at": 1722585567, "created_by": null, "updated_by": null }, { "termsid": 231473, "orderid": 12777, "jobmultiquoteid": 12781, "isresportshow": 1, "termsCategory": 4, "termsName": "Standard", "termsDescription": "", "status": 0, "seq": 1, "id": "231473", "created_at": 1748417074, "updated_at": 1748417074, "terms_created_at": 1722585567, "created_by": null, "updated_by": null } ], "updated": [], "deleted": [] }, "bm_jobmultiquote": { "created": [ { "jmq_id": 12780, "jmq_jobid": 12776, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "41.58", "jmq_netprice": "41.58", "jmq_vat": "8.32", "jmq_isvaton": 1, "jmq_deliverycost": "0.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 2, "jmq_orderformprice": "0.00", "jmq_editpricebyid": 0, "jmq_isroundon": 0, "jmq_grossprice": "49.90", "jmq_grossprofit": "2.75", "jmq_costprice": "38.83", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "49.90", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": "\"\"", "jmq_deliverycostid": 0, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 1, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 1, "jmq_endcustomeroverridevalue": "", "jmq_endcustomeroverridenetprice": "41.58", "jmq_endcustomeroverridevatprice": "8.32", "jmq_endcustomeroverridegrossprice": "49.90", "jmq_endcustomerdeliverycost": "", "jmq_endcustomerdeliverycostinclvat": 1, "jmq_endcustomerfittingcost": "", "jmq_endcustomerfittingcostinclvat": 1, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "20.000", "jmq_cdeliveryvatperc": "20.000", "id": "12780", "jmq_duedate": 1748563200, "jmq_sceduleddate": null, "jmq_createdat": "1748416963.000000", "jmq_updatedat": "1748416963.000000", "jmq_createdby": 14, "jmq_updatedby": 14 }, { "jmq_id": 12781, "jmq_jobid": 12777, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "351.09", "jmq_netprice": "351.09", "jmq_vat": "70.22", "jmq_isvaton": 1, "jmq_deliverycost": "0.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 2, "jmq_orderformprice": "0.00", "jmq_editpricebyid": 0, "jmq_isroundon": 0, "jmq_grossprice": "421.31", "jmq_grossprofit": "144.78", "jmq_costprice": "206.31", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "421.31", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": "\"\"", "jmq_deliverycostid": 0, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 1, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 1, "jmq_endcustomeroverridevalue": "", "jmq_endcustomeroverridenetprice": "0.00", "jmq_endcustomeroverridevatprice": "0.00", "jmq_endcustomeroverridegrossprice": "0.00", "jmq_endcustomerdeliverycost": "", "jmq_endcustomerdeliverycostinclvat": 1, "jmq_endcustomerfittingcost": "", "jmq_endcustomerfittingcostinclvat": 1, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "20.000", "jmq_cdeliveryvatperc": "20.000", "id": "12781", "jmq_duedate": 1748563200, "jmq_sceduleddate": null, "jmq_createdat": "1748417074.000000", "jmq_updatedat": "1748417074.000000", "jmq_createdby": 14, "jmq_updatedby": 14 }, { "jmq_id": 12782, "jmq_jobid": 12778, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "0.00", "jmq_netprice": "0.00", "jmq_vat": "0.00", "jmq_isvaton": 1, "jmq_deliverycost": "0.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 1, "jmq_orderformprice": "0.00", "jmq_editpricebyid": null, "jmq_isroundon": 0, "jmq_grossprice": "0.00", "jmq_grossprofit": "0.00", "jmq_costprice": "0.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "0.00", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": null, "jmq_deliverycostid": 0, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 0, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 0, "jmq_endcustomeroverridevalue": null, "jmq_endcustomeroverridenetprice": "0.00", "jmq_endcustomeroverridevatprice": "0.00", "jmq_endcustomeroverridegrossprice": "0.00", "jmq_endcustomerdeliverycost": null, "jmq_endcustomerdeliverycostinclvat": 0, "jmq_endcustomerfittingcost": null, "jmq_endcustomerfittingcostinclvat": 0, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "20.000", "jmq_cdeliveryvatperc": "20.000", "id": "12782", "jmq_duedate": 1748390400, "jmq_sceduleddate": null, "jmq_createdat": "1748417077.000000", "jmq_updatedat": "1748417134.000000", "jmq_createdby": 1, "jmq_updatedby": 1 } ], "updated": [ { "jmq_id": 12780, "jmq_jobid": 12776, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "41.58", "jmq_netprice": "41.58", "jmq_vat": "8.32", "jmq_isvaton": 1, "jmq_deliverycost": "0.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 2, "jmq_orderformprice": "0.00", "jmq_editpricebyid": 0, "jmq_isroundon": 0, "jmq_grossprice": "49.90", "jmq_grossprofit": "2.75", "jmq_costprice": "38.83", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "49.90", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": "\"\"", "jmq_deliverycostid": 0, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 1, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 1, "jmq_endcustomeroverridevalue": "", "jmq_endcustomeroverridenetprice": "41.58", "jmq_endcustomeroverridevatprice": "8.32", "jmq_endcustomeroverridegrossprice": "49.90", "jmq_endcustomerdeliverycost": "", "jmq_endcustomerdeliverycostinclvat": 1, "jmq_endcustomerfittingcost": "", "jmq_endcustomerfittingcostinclvat": 1, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "20.000", "jmq_cdeliveryvatperc": "20.000", "id": "12780", "jmq_duedate": 1748563200, "jmq_sceduleddate": null, "jmq_createdat": "1748416963.000000", "jmq_updatedat": "1748416963.000000", "jmq_createdby": 14, "jmq_updatedby": 14 }, { "jmq_id": 12781, "jmq_jobid": 12777, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "351.09", "jmq_netprice": "351.09", "jmq_vat": "70.22", "jmq_isvaton": 1, "jmq_deliverycost": "0.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 2, "jmq_orderformprice": "0.00", "jmq_editpricebyid": 0, "jmq_isroundon": 0, "jmq_grossprice": "421.31", "jmq_grossprofit": "144.78", "jmq_costprice": "206.31", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "421.31", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": "\"\"", "jmq_deliverycostid": 0, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 1, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 1, "jmq_endcustomeroverridevalue": "", "jmq_endcustomeroverridenetprice": "0.00", "jmq_endcustomeroverridevatprice": "0.00", "jmq_endcustomeroverridegrossprice": "0.00", "jmq_endcustomerdeliverycost": "", "jmq_endcustomerdeliverycostinclvat": 1, "jmq_endcustomerfittingcost": "", "jmq_endcustomerfittingcostinclvat": 1, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "20.000", "jmq_cdeliveryvatperc": "20.000", "id": "12781", "jmq_duedate": 1748563200, "jmq_sceduleddate": null, "jmq_createdat": "1748417074.000000", "jmq_updatedat": "1748417074.000000", "jmq_createdby": 14, "jmq_updatedby": 14 }, { "jmq_id": 12782, "jmq_jobid": 12778, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "0.00", "jmq_netprice": "0.00", "jmq_vat": "0.00", "jmq_isvaton": 1, "jmq_deliverycost": "0.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 1, "jmq_orderformprice": "0.00", "jmq_editpricebyid": null, "jmq_isroundon": 0, "jmq_grossprice": "0.00", "jmq_grossprofit": "0.00", "jmq_costprice": "0.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "0.00", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": null, "jmq_deliverycostid": 0, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 0, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 0, "jmq_endcustomeroverridevalue": null, "jmq_endcustomeroverridenetprice": "0.00", "jmq_endcustomeroverridevatprice": "0.00", "jmq_endcustomeroverridegrossprice": "0.00", "jmq_endcustomerdeliverycost": null, "jmq_endcustomerdeliverycostinclvat": 0, "jmq_endcustomerfittingcost": null, "jmq_endcustomerfittingcostinclvat": 0, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "20.000", "jmq_cdeliveryvatperc": "20.000", "id": "12782", "jmq_duedate": 1748390400, "jmq_sceduleddate": null, "jmq_createdat": "1748417077.000000", "jmq_updatedat": "1748417134.000000", "jmq_createdby": 1, "jmq_updatedby": 1 } ], "deleted": [] }, "bm_jobstatus_tracks": { "created": [ { "jst_id": 13614, "jst_jobid": 12776, "jst_job_current_status": 1, "id": "13614", "jst_createdat": "1748416963.750710" }, { "jst_id": 13615, "jst_jobid": 12776, "jst_job_current_status": 3, "id": "13615", "jst_createdat": "1748416998.508788" }, { "jst_id": 13616, "jst_jobid": 12777, "jst_job_current_status": 1, "id": "13616", "jst_createdat": "1748417074.245321" }, { "jst_id": 13617, "jst_jobid": 12777, "jst_job_current_status": 3, "id": "13617", "jst_createdat": "1748417085.766600" }, { "jst_id": 13618, "jst_jobid": 12778, "jst_job_current_status": 1, "id": "13618", "jst_createdat": "1748417133.894977" } ], "updated": [], "deleted": [] }, "bm_customindividuallogs": { "created": [ { "cl_id": 32926, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 12776, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 12776, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 14, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"Concorde Blinds, Curtains, Shutters\",\"Account Type\":\"Domestic\",\"Source\":\"Website\",\"Created By\":\"Yogeshwari\",\"Last Name\":\"Teste\",\"Zipcode \\\/ Postcode\":\"435 VBN\",\"Country\":\"UK\",\"Salutation\":\"Mr.\",\"Assigned to\":14,\"Role\":\"0\",\"Additional Contacts\":\"7295\",\"Job Status\":\"Lead\",\"Order Status\":\"1) Enquiry\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"jd_isonlineorder\":1,\"End Customer Override Type\":1,\"End Customer Delivery Cost Include Vat\":1,\"End Customer Fitting Cost Include Vat\":1,\"Delivery Vat Percentage\":\"20.000\",\"Commission\":\"[]\",\"jd_onlineprefixseq\":\"1\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":12776,\"jd_customerid\":5878,\"jd_contactid\":7295,\"jd_additionalcontacts\":\"7295\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"33\\\":25,\\\"37\\\":1,\\\"39\\\":1,\\\"41\\\":14,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"\\\",\\\"46\\\":\\\"Teste\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"435 VBN\\\",\\\"54\\\":19,\\\"285\\\":1,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":14,\\\"558\\\":\\\"0\\\",\\\"612\\\":\\\"\\\",\\\"614\\\":\\\"\\\",\\\"615\\\":\\\"\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-05-28\",\"jd_orderdate\":\"0000-00-00\",\"jd_duedate\":\"0000-00-00\",\"jd_sceduleddate\":\"0000-00-00\",\"jd_invoicedate\":\"0000-00-00\",\"jd_completeddate\":\"0000-00-00\",\"jd_jobref\":null,\"jd_jobstatus\":1,\"jd_contactaddid\":0,\"jd_orderstatus\":3,\"jd_accref\":\",TEST0009\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"0.00\",\"jd_netprice\":\"0.00\",\"jd_vat\":\"0.00\",\"jd_isvaton\":1,\"jd_deliverycost\":\"0.00\",\"jd_deliverycosttypeid\":1,\"jd_overridetypeid\":2,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":0,\"jd_isroundon\":0,\"jd_grossprice\":\"0.00\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"0.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"0.00\",\"jd_totpaid\":\"0.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":\"\\\"\\\"\",\"jd_deliverycostid\":0,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":1,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":1,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":1,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":null,\"jd_organizationid\":0,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":14,\"jd_createdat\":\"2025-05-28T07:22:43.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-05-28T07:22:43.000000Z\",\"jd_deviceplatform\":0,\"jd_fromjobref\":\"\",\"jd_fromdbname\":null,\"jd_importorder\":0,\"jd_quickquote\":0,\"jd_myob_flag\":0,\"jd_myobinvoiceid\":\"\",\"jd_qboflag\":0,\"jd_qboinvoiceid\":0,\"jd_qbodisplayname\":\"\",\"jd_deliveryvatperc\":\"20.000\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"20.000\",\"jd_commission\":\"[]\",\"jd_commissionprice\":\"0.00\",\"jd_commissionsetting\":0,\"jd_commissionaddedvalue\":\"0.00\",\"jd_onlineprefixseq\":\"1\",\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":0,\"jd_rework_count\":0,\"salesorderid\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "32926", "cl_createdat": "1748416963.000000", "cl_updatedat": null }, { "cl_id": 32932, "cl_logname": "default", "cl_type": null, "cl_modulename": "Line Item", "cl_message": "Q1 - new item has been created in Line Item for the product of Allusion Blind", "cl_event": "created", "cl_subjectid": 80457, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 12776, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 14, "cl_changedfrom": "null", "cl_changedto": "{\"Supplier\":\" Excel\",\" Control Type\":\" Wand\",\" Bunch\":\" LH Bunch Wand\",\" Wand Length\":\" 750mm\",\" Fitting\":\" Fitting\"}", "cl_customproperties": "{\"attributes\":{\"oi_id\":80457,\"oi_jobid\":12776,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":12780,\"oi_credit_id\":0,\"oi_productid\":60,\"oi_recipeid\":60,\"oi_ruleid\":0,\"oi_qty\":1,\"oi_seq\":1,\"oi_customseq\":1,\"oi_productcustomseq\":1,\"oi_jsondata\":\"[{\\\"id\\\":3892,\\\"labelname\\\":\\\"Unit Type\\\",\\\"value\\\":2,\\\"valueid\\\":\\\"2\\\",\\\"type\\\":34,\\\"optionid\\\":2,\\\"optionvalue\\\":[{\\\"optionid\\\":2,\\\"optionname\\\":\\\"mm\\\",\\\"optioncode\\\":null,\\\"optionquantity\\\":1,\\\"unittype\\\":0,\\\"unitcost\\\":0,\\\"pricingtype\\\":0,\\\"fieldoptionlinkid\\\":2,\\\"forchildfieldoptionlinkid\\\":\\\"34_2\\\"}],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Unit Type\\\",\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":null,\\\"widthfractiontext\\\":null,\\\"dropfractiontext\\\":null,\\\"dropfraction\\\":null,\\\"showfieldonjob\\\":1,\\\"showFieldOnCustomerPortal\\\":1,\\\"optionquantity\\\":null,\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":1,\\\"fieldtypeid\\\":34,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Unit Type\\\",\\\"fieldid\\\":3892,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":2,\\\"optionsvalue\\\":[{\\\"optionid\\\":2,\\\"optionname\\\":\\\"mm\\\",\\\"optioncode\\\":null,\\\"optionquantity\\\":1,\\\"unittype\\\":0,\\\"unitcost\\\":0,\\\"pricingtype\\\":0,\\\"fieldoptionlinkid\\\":2,\\\"forchildfieldoptionlinkid\\\":\\\"34_2\\\"}],\\\"editruleoverride\\\":0},{\\\"id\\\":3891,\\\"labelname\\\":\\\"Quantity\\\",\\\"value\\\":1,\\\"valueid\\\":null,\\\"type\\\":14,\\\"optionid\\\":null,\\\"optionvalue\\\":[],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Quantity\\\",\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":null,\\\"widthfractiontext\\\":null,\\\"dropfractiontext\\\":null,\\\"dropfraction\\\":null,\\\"showfieldonjob\\\":1,\\\"showFieldOnCustomerPortal\\\":1,\\\"optionquantity\\\":null,\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":1,\\\"fieldtypeid\\\":14,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Quantity\\\",\\\"fieldid\\\":3891,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":3895,\\\"labelname\\\":\\\"Room\\\",\\\"value\\\":null,\\\"valueid\\\":null,\\\"type\\\":18,\\\"optionid\\\":null,\\\"optionvalue\\\":[],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Room\\\",\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":null,\\\"widthfractiontext\\\":null,\\\"dropfractiontext\\\":null,\\\"dropfraction\\\":null,\\\"showfieldonjob\\\":1,\\\"showFieldOnCustomerPortal\\\":1,\\\"optionquantity\\\":null,\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":1,\\\"fieldtypeid\\\":18,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Room\\\",\\\"fieldid\\\":3895,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":3893,\\\"labelname\\\":\\\"Supplier\\\",\\\"value\\\":15,\\\"valueid\\\":null,\\\"type\\\":17,\\\"optionid\\\":15,\\\"optionvalue\\\":[{\\\"id\\\":15,\\\"optionid\\\":15,\\\"optionname\\\":\\\"Excel\\\",\\\"deleted\\\":0,\\\"optionquantity\\\":1}],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Supplier\\\",\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":null,\\\"widthfractiontext\\\":null,\\\"dropfractiontext\\\":null,\\\"dropfraction\\\":null,\\\"showfieldonjob\\\":1,\\\"showFieldOnCustomerPortal\\\":1,\\\"optionquantity\\\":null,\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":1,\\\"fieldtypeid\\\":17,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Supplier\\\",\\\"fieldid\\\":3893,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":15,\\\"optionsvalue\\\":[{\\\"id\\\":15,\\\"optionid\\\":15,\\\"optionname\\\":\\\"Excel\\\",\\\"deleted\\\":0,\\\"optionquantity\\\":1}],\\\"editruleoverride\\\":0},{\\\"id\\\":3896,\\\"labelname\\\":\\\"Size\\\",\\\"value\\\":null,\\\"valueid\\\":null,\\\"type\\\":3,\\\"optionid\\\":null,\\\"optionvalue\\\":[],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Size\\\",\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":null,\\\"widthfractiontext\\\":null,\\\"dropfractiontext\\\":null,\\\"dropfraction\\\":null,\\\"showfieldonjob\\\":1,\\\"showFieldOnCustomerPortal\\\":1,\\\"optionquantity\\\":null,\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":1,\\\"fieldtypeid\\\":3,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Size\\\",\\\"fieldid\\\":3896,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":3897,\\\"labelname\\\":\\\"Width\\\",\\\"value\\\":null,\\\"valueid\\\":null,\\\"type\\\":11,\\\"optionid\\\":null,\\\"optionvalue\\\":[],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Width\\\",\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"0_mm_3_0\\\",\\\"widthfractiontext\\\":null,\\\"dropfractiontext\\\":null,\\\"dropfraction\\\":null,\\\"showfieldonjob\\\":1,\\\"showFieldOnCustomerPortal\\\":1,\\\"optionquantity\\\":null,\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":1,\\\"fieldtypeid\\\":11,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Width\\\",\\\"fieldid\\\":3897,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":3898,\\\"labelname\\\":\\\"Drop\\\",\\\"value\\\":null,\\\"valueid\\\":null,\\\"type\\\":12,\\\"optionid\\\":null,\\\"optionvalue\\\":[],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Drop\\\",\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":null,\\\"widthfractiontext\\\":null,\\\"dropfractiontext\\\":null,\\\"dropfraction\\\":\\\"0_mm_3_0\\\",\\\"showfieldonjob\\\":1,\\\"showFieldOnCustomerPortal\\\":1,\\\"optionquantity\\\":null,\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":1,\\\"fieldtypeid\\\":12,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Drop\\\",\\\"fieldid\\\":3898,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":3894,\\\"labelname\\\":\\\"Pricing Band\\\",\\\"value\\\":null,\\\"valueid\\\":null,\\\"type\\\":13,\\\"optionid\\\":null,\\\"optionvalue\\\":[],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Pricing Band\\\",\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":null,\\\"widthfractiontext\\\":null,\\\"dropfractiontext\\\":null,\\\"dropfraction\\\":null,\\\"showfieldonjob\\\":1,\\\"showFieldOnCustomerPortal\\\":1,\\\"optionquantity\\\":null,\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":1,\\\"fieldtypeid\\\":13,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Pricing Band\\\",\\\"fieldid\\\":3894,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":3904,\\\"labelname\\\":\\\"Control Type\\\",\\\"value\\\":\\\"Wand\\\",\\\"valueid\\\":\\\"17572\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"14488\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":14488,\\\"optionqty\\\":\\\"1\\\",\\\"optionname\\\":\\\"Wand\\\",\\\"description\\\":null,\\\"optioncode\\\":\\\"17950\\\",\\\"pricegroups\\\":\\\"Diffused Band A_AAB,Diffused Band B_AAB,Band_A_EAB,Band_B_EAB\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":17572,\\\"forchildfieldoptionlinkid\\\":\\\"3_17572\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":2,\\\"optionimage\\\":null,\\\"reportprice\\\":\\\"0.00\\\",\\\"costprice\\\":0,\\\"costwithdiscount\\\":0,\\\"customersellingprice\\\":0,\\\"customermarkupvalue\\\":1,\\\"optiontype\\\":1,\\\"quantity\\\":1,\\\"optionnetprice\\\":0,\\\"sellingpriceType\\\":1}],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Control Type\\\",\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":null,\\\"widthfractiontext\\\":null,\\\"dropfractiontext\\\":null,\\\"dropfraction\\\":null,\\\"showfieldonjob\\\":1,\\\"showFieldOnCustomerPortal\\\":1,\\\"optionquantity\\\":\\\"1\\\",\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":1,\\\"fieldtypeid\\\":3,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Control Type\\\",\\\"fieldid\\\":3904,\\\"subchild\\\":[{\\\"fieldtypeid\\\":3,\\\"fieldid\\\":3905,\\\"labelnamecode\\\":\\\"Bunch\\\",\\\"fieldname\\\":\\\"Bunch\\\",\\\"selection\\\":0,\\\"field_has_sub_option\\\":1,\\\"seq\\\":5,\\\"mandatory\\\":1,\\\"fieldlevel\\\":2,\\\"showfieldonjob\\\":1,\\\"showFieldOnCustomerPortal\\\":1,\\\"fabricorcolor\\\":0,\\\"subfieldlinkid\\\":17572,\\\"forchildsubfieldlinkid\\\":\\\"3_17572\\\",\\\"optionsvalue\\\":[{\\\"optionid\\\":14489,\\\"optionqty\\\":\\\"1\\\",\\\"optionname\\\":\\\"RH Bunch Wand\\\",\\\"description\\\":null,\\\"optioncode\\\":\\\"51638\\\",\\\"pricegroups\\\":null,\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":17574,\\\"forchildfieldoptionlinkid\\\":\\\"3_17574\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":null},{\\\"optionid\\\":14490,\\\"optionqty\\\":\\\"1\\\",\\\"optionname\\\":\\\"LH Bunch Wand\\\",\\\"description\\\":null,\\\"optioncode\\\":\\\"51639\\\",\\\"pricegroups\\\":null,\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":5.5,\\\"fieldoptionlinkid\\\":17575,\\\"forchildfieldoptionlinkid\\\":\\\"3_17575\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":null,\\\"reportprice\\\":\\\"8.25\\\",\\\"costprice\\\":5.5,\\\"costwithdiscount\\\":5.5,\\\"customersellingprice\\\":8.25,\\\"customermarkupvalue\\\":1.5,\\\"optiontype\\\":1,\\\"quantity\\\":1,\\\"optionnetprice\\\":5.5,\\\"sellingpriceType\\\":1},{\\\"optionid\\\":14491,\\\"optionqty\\\":\\\"1\\\",\\\"optionname\\\":\\\"Split Draw Wand RH\\\",\\\"description\\\":null,\\\"optioncode\\\":\\\"51640\\\",\\\"pricegroups\\\":null,\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":17576,\\\"forchildfieldoptionlinkid\\\":\\\"3_17576\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":null},{\\\"optionid\\\":14492,\\\"optionqty\\\":\\\"1\\\",\\\"optionname\\\":\\\"Split Draw Wand LH\\\",\\\"description\\\":null,\\\"optioncode\\\":\\\"51641\\\",\\\"pricegroups\\\":null,\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":17577,\\\"forchildfieldoptionlinkid\\\":\\\"3_17577\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":null}],\\\"optionsbackup\\\":[{\\\"optionid\\\":14489,\\\"optionqty\\\":\\\"1\\\",\\\"optionname\\\":\\\"RH Bunch Wand\\\",\\\"description\\\":null,\\\"optioncode\\\":\\\"51638\\\",\\\"pricegroups\\\":null,\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":17574,\\\"forchildfieldoptionlinkid\\\":\\\"3_17574\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":null},{\\\"optionid\\\":14490,\\\"optionqty\\\":\\\"1\\\",\\\"optionname\\\":\\\"LH Bunch Wand\\\",\\\"description\\\":null,\\\"optioncode\\\":\\\"51639\\\",\\\"pricegroups\\\":null,\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":5.5,\\\"fieldoptionlinkid\\\":17575,\\\"forchildfieldoptionlinkid\\\":\\\"3_17575\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":null,\\\"reportprice\\\":\\\"8.25\\\",\\\"costprice\\\":5.5,\\\"costwithdiscount\\\":5.5,\\\"customersellingprice\\\":8.25,\\\"customermarkupvalue\\\":1.5,\\\"optiontype\\\":1,\\\"quantity\\\":1,\\\"optionnetprice\\\":5.5,\\\"sellingpriceType\\\":1},{\\\"optionid\\\":14491,\\\"optionqty\\\":\\\"1\\\",\\\"optionname\\\":\\\"Split Draw Wand RH\\\",\\\"description\\\":null,\\\"optioncode\\\":\\\"51640\\\",\\\"pricegroups\\\":null,\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":17576,\\\"forchildfieldoptionlinkid\\\":\\\"3_17576\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":null},{\\\"optionid\\\":14492,\\\"optionqty\\\":\\\"1\\\",\\\"optionname\\\":\\\"Split Draw Wand LH\\\",\\\"description\\\":null,\\\"optioncode\\\":\\\"51641\\\",\\\"pricegroups\\\":null,\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":17577,\\\"forchildfieldoptionlinkid\\\":\\\"3_17577\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":null}],\\\"editablecolumns\\\":[\\\"optionqty\\\"],\\\"optionsselectedcolumns\\\":{\\\"optionid\\\":\\\"Option Id\\\",\\\"optionqty\\\":\\\"Option Qty\\\",\\\"optionname\\\":\\\"Option Name\\\",\\\"optioncode\\\":\\\"Option Code\\\",\\\"description\\\":\\\"Description\\\",\\\"pricegroups\\\":\\\"Price Groups\\\"},\\\"optiondefault\\\":\\\"14490\\\",\\\"masterparentfieldid\\\":3904,\\\"supplierid\\\":\\\"19,15\\\",\\\"subchild\\\":[],\\\"issubfabric\\\":0,\\\"textfieldheight\\\":1,\\\"editruleoverride\\\":1,\\\"fieldInformation\\\":null,\\\"dumydata\\\":[],\\\"blindswidth\\\":0},{\\\"fieldtypeid\\\":3,\\\"fieldid\\\":3906,\\\"labelnamecode\\\":\\\"Wand Length\\\",\\\"fieldname\\\":\\\"Wand Length\\\",\\\"selection\\\":0,\\\"field_has_sub_option\\\":1,\\\"seq\\\":6,\\\"mandatory\\\":0,\\\"fieldlevel\\\":2,\\\"showfieldonjob\\\":1,\\\"showFieldOnCustomerPortal\\\":1,\\\"fabricorcolor\\\":0,\\\"subfieldlinkid\\\":17572,\\\"forchildsubfieldlinkid\\\":\\\"3_17572\\\",\\\"optionsvalue\\\":[{\\\"optionid\\\":14494,\\\"optionqty\\\":\\\"1\\\",\\\"optionname\\\":\\\"750mm\\\",\\\"description\\\":null,\\\"optioncode\\\":\\\"51649\\\",\\\"pricegroups\\\":null,\\\"unittype\\\":\\\"Each\\\",\\\"fieldoptionlinkid\\\":17580,\\\"forchildfieldoptionlinkid\\\":\\\"3_17580\\\",\\\"hasstock\\\":0,\\\"subdatacount\\\":0,\\\"hasprice\\\":1,\\\"optionimage\\\":null,\\\"unitcost\\\":0,\\\"reportprice\\\":\\\"0.00\\\",\\\"costprice\\\":0,\\\"costwithdiscount\\\":0,\\\"customersellingprice\\\":0,\\\"customermarkupvalue\\\":1,\\\"optiontype\\\":1,\\\"quantity\\\":1,\\\"optionnetprice\\\":0,\\\"sellingpriceType\\\":1}],\\\"optionsbackup\\\":[{\\\"optionid\\\":14494,\\\"optionqty\\\":\\\"1\\\",\\\"optionname\\\":\\\"750mm\\\",\\\"description\\\":null,\\\"optioncode\\\":\\\"51649\\\",\\\"pricegroups\\\":null,\\\"unittype\\\":\\\"Each\\\",\\\"fieldoptionlinkid\\\":17580,\\\"forchildfieldoptionlinkid\\\":\\\"3_17580\\\",\\\"hasstock\\\":0,\\\"subdatacount\\\":0,\\\"hasprice\\\":1,\\\"optionimage\\\":null,\\\"unitcost\\\":0,\\\"reportprice\\\":\\\"0.00\\\",\\\"costprice\\\":0,\\\"costwithdiscount\\\":0,\\\"customersellingprice\\\":0,\\\"customermarkupvalue\\\":1,\\\"optiontype\\\":1,\\\"quantity\\\":1,\\\"optionnetprice\\\":0,\\\"sellingpriceType\\\":1}],\\\"editablecolumns\\\":[\\\"optionqty\\\"],\\\"optionsselectedcolumns\\\":{\\\"optionid\\\":\\\"Option Id\\\",\\\"optionqty\\\":\\\"Option Qty\\\",\\\"optionname\\\":\\\"Option Name\\\",\\\"optioncode\\\":\\\"Option Code\\\",\\\"description\\\":\\\"Description\\\",\\\"pricegroups\\\":\\\"Price Groups\\\"},\\\"optiondefault\\\":\\\"14494\\\",\\\"masterparentfieldid\\\":3904,\\\"supplierid\\\":\\\"19,15\\\",\\\"subchild\\\":[],\\\"issubfabric\\\":0,\\\"textfieldheight\\\":1,\\\"editruleoverride\\\":null,\\\"fieldInformation\\\":null,\\\"dumydata\\\":[{\\\"optionid\\\":14494,\\\"optionqty\\\":\\\"1\\\",\\\"optionname\\\":\\\"750mm\\\",\\\"description\\\":null,\\\"optioncode\\\":\\\"51649\\\",\\\"pricegroups\\\":null,\\\"unittype\\\":\\\"Each\\\",\\\"fieldoptionlinkid\\\":17580,\\\"forchildfieldoptionlinkid\\\":\\\"3_17580\\\",\\\"hasstock\\\":0,\\\"subdatacount\\\":0,\\\"hasprice\\\":1,\\\"optionimage\\\":null}],\\\"blindswidth\\\":0}],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":\\\"14488\\\",\\\"optionsvalue\\\":[{\\\"optionid\\\":14488,\\\"optionqty\\\":\\\"1\\\",\\\"optionname\\\":\\\"Wand\\\",\\\"description\\\":null,\\\"optioncode\\\":\\\"17950\\\",\\\"pricegroups\\\":\\\"Diffused Band A_AAB,Diffused Band B_AAB,Band_A_EAB,Band_B_EAB\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":17572,\\\"forchildfieldoptionlinkid\\\":\\\"3_17572\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":2,\\\"optionimage\\\":null,\\\"reportprice\\\":\\\"0.00\\\",\\\"costprice\\\":0,\\\"costwithdiscount\\\":0,\\\"customersellingprice\\\":0,\\\"customermarkupvalue\\\":1,\\\"optiontype\\\":1,\\\"quantity\\\":1,\\\"optionnetprice\\\":0,\\\"sellingpriceType\\\":1}],\\\"editruleoverride\\\":0},{\\\"id\\\":3905,\\\"labelname\\\":\\\"Bunch\\\",\\\"value\\\":\\\"LH Bunch Wand\\\",\\\"valueid\\\":\\\"17575\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"14490\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":14490,\\\"optionqty\\\":\\\"1\\\",\\\"optionname\\\":\\\"LH Bunch Wand\\\",\\\"description\\\":null,\\\"optioncode\\\":\\\"51639\\\",\\\"pricegroups\\\":null,\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":5.5,\\\"fieldoptionlinkid\\\":17575,\\\"forchildfieldoptionlinkid\\\":\\\"3_17575\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":null,\\\"reportprice\\\":\\\"8.25\\\",\\\"costprice\\\":5.5,\\\"costwithdiscount\\\":5.5,\\\"customersellingprice\\\":8.25,\\\"customermarkupvalue\\\":1.5,\\\"optiontype\\\":1,\\\"quantity\\\":1,\\\"optionnetprice\\\":5.5,\\\"sellingpriceType\\\":1}],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Bunch\\\",\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":null,\\\"widthfractiontext\\\":null,\\\"dropfractiontext\\\":null,\\\"dropfraction\\\":null,\\\"showfieldonjob\\\":1,\\\"showFieldOnCustomerPortal\\\":1,\\\"optionquantity\\\":\\\"1\\\",\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":2,\\\"fieldtypeid\\\":3,\\\"mandatory\\\":1,\\\"fieldname\\\":\\\"Bunch\\\",\\\"fieldid\\\":3905,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":\\\"14490\\\",\\\"optionsvalue\\\":[{\\\"optionid\\\":14490,\\\"optionqty\\\":\\\"1\\\",\\\"optionname\\\":\\\"LH Bunch Wand\\\",\\\"description\\\":null,\\\"optioncode\\\":\\\"51639\\\",\\\"pricegroups\\\":null,\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":5.5,\\\"fieldoptionlinkid\\\":17575,\\\"forchildfieldoptionlinkid\\\":\\\"3_17575\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":null,\\\"reportprice\\\":\\\"8.25\\\",\\\"costprice\\\":5.5,\\\"costwithdiscount\\\":5.5,\\\"customersellingprice\\\":8.25,\\\"customermarkupvalue\\\":1.5,\\\"optiontype\\\":1,\\\"quantity\\\":1,\\\"optionnetprice\\\":5.5,\\\"sellingpriceType\\\":1}],\\\"editruleoverride\\\":1},{\\\"id\\\":3906,\\\"labelname\\\":\\\"Wand Length\\\",\\\"value\\\":\\\"750mm\\\",\\\"valueid\\\":\\\"17580\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"14494\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":14494,\\\"optionqty\\\":\\\"1\\\",\\\"optionname\\\":\\\"750mm\\\",\\\"description\\\":null,\\\"optioncode\\\":\\\"51649\\\",\\\"pricegroups\\\":null,\\\"unittype\\\":\\\"Each\\\",\\\"fieldoptionlinkid\\\":17580,\\\"forchildfieldoptionlinkid\\\":\\\"3_17580\\\",\\\"hasstock\\\":0,\\\"subdatacount\\\":0,\\\"hasprice\\\":1,\\\"optionimage\\\":null,\\\"unitcost\\\":0,\\\"reportprice\\\":\\\"0.00\\\",\\\"costprice\\\":0,\\\"costwithdiscount\\\":0,\\\"customersellingprice\\\":0,\\\"customermarkupvalue\\\":1,\\\"optiontype\\\":1,\\\"quantity\\\":1,\\\"optionnetprice\\\":0,\\\"sellingpriceType\\\":1}],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Wand Length\\\",\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":null,\\\"widthfractiontext\\\":null,\\\"dropfractiontext\\\":null,\\\"dropfraction\\\":null,\\\"showfieldonjob\\\":1,\\\"showFieldOnCustomerPortal\\\":1,\\\"optionquantity\\\":\\\"1\\\",\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":2,\\\"fieldtypeid\\\":3,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Wand Length\\\",\\\"fieldid\\\":3906,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":\\\"14494\\\",\\\"optionsvalue\\\":[{\\\"optionid\\\":14494,\\\"optionqty\\\":\\\"1\\\",\\\"optionname\\\":\\\"750mm\\\",\\\"description\\\":null,\\\"optioncode\\\":\\\"51649\\\",\\\"pricegroups\\\":null,\\\"unittype\\\":\\\"Each\\\",\\\"fieldoptionlinkid\\\":17580,\\\"forchildfieldoptionlinkid\\\":\\\"3_17580\\\",\\\"hasstock\\\":0,\\\"subdatacount\\\":0,\\\"hasprice\\\":1,\\\"optionimage\\\":null,\\\"unitcost\\\":0,\\\"reportprice\\\":\\\"0.00\\\",\\\"costprice\\\":0,\\\"costwithdiscount\\\":0,\\\"customersellingprice\\\":0,\\\"customermarkupvalue\\\":1,\\\"optiontype\\\":1,\\\"quantity\\\":1,\\\"optionnetprice\\\":0,\\\"sellingpriceType\\\":1}],\\\"editruleoverride\\\":0},{\\\"id\\\":3917,\\\"labelname\\\":\\\"Headrail Colour\\\",\\\"value\\\":null,\\\"valueid\\\":null,\\\"type\\\":3,\\\"optionid\\\":null,\\\"optionvalue\\\":[],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Headrail Colour\\\",\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":null,\\\"widthfractiontext\\\":null,\\\"dropfractiontext\\\":null,\\\"dropfraction\\\":null,\\\"showfieldonjob\\\":1,\\\"showFieldOnCustomerPortal\\\":1,\\\"optionquantity\\\":null,\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":1,\\\"fieldtypeid\\\":3,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Headrail Colour\\\",\\\"fieldid\\\":3917,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":3919,\\\"labelname\\\":\\\"Fascia\\\",\\\"value\\\":null,\\\"valueid\\\":null,\\\"type\\\":3,\\\"optionid\\\":null,\\\"optionvalue\\\":[],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Fascia\\\",\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":null,\\\"widthfractiontext\\\":null,\\\"dropfractiontext\\\":null,\\\"dropfraction\\\":null,\\\"showfieldonjob\\\":1,\\\"showFieldOnCustomerPortal\\\":1,\\\"optionquantity\\\":null,\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":1,\\\"fieldtypeid\\\":3,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Fascia\\\",\\\"fieldid\\\":3919,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":3921,\\\"labelname\\\":\\\"Product Information\\\",\\\"value\\\":null,\\\"valueid\\\":null,\\\"type\\\":3,\\\"optionid\\\":null,\\\"optionvalue\\\":[],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Product Information\\\",\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":null,\\\"widthfractiontext\\\":null,\\\"dropfractiontext\\\":null,\\\"dropfraction\\\":null,\\\"showfieldonjob\\\":1,\\\"showFieldOnCustomerPortal\\\":1,\\\"optionquantity\\\":null,\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":1,\\\"fieldtypeid\\\":3,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Product Information\\\",\\\"fieldid\\\":3921,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":3926,\\\"labelname\\\":\\\"Extras\\\",\\\"value\\\":null,\\\"valueid\\\":null,\\\"type\\\":3,\\\"optionid\\\":null,\\\"optionvalue\\\":[],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Extras\\\",\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":null,\\\"widthfractiontext\\\":null,\\\"dropfractiontext\\\":null,\\\"dropfraction\\\":null,\\\"showfieldonjob\\\":1,\\\"showFieldOnCustomerPortal\\\":1,\\\"optionquantity\\\":null,\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":1,\\\"fieldtypeid\\\":3,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Extras\\\",\\\"fieldid\\\":3926,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":3928,\\\"labelname\\\":\\\"Special Instrctions\\\",\\\"value\\\":null,\\\"valueid\\\":null,\\\"type\\\":18,\\\"optionid\\\":null,\\\"optionvalue\\\":[],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Special Instrctions\\\",\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":null,\\\"widthfractiontext\\\":null,\\\"dropfractiontext\\\":null,\\\"dropfraction\\\":null,\\\"showfieldonjob\\\":1,\\\"showFieldOnCustomerPortal\\\":1,\\\"optionquantity\\\":null,\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":1,\\\"fieldtypeid\\\":18,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Special Instrctions\\\",\\\"fieldid\\\":3928,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":3927,\\\"labelname\\\":\\\"Fitting\\\",\\\"value\\\":\\\"Fitting\\\",\\\"valueid\\\":\\\"17654\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"14553\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":14553,\\\"optionqty\\\":\\\"1\\\",\\\"optionname\\\":\\\"Fitting\\\",\\\"description\\\":null,\\\"optioncode\\\":\\\"14928\\\",\\\"pricegroups\\\":\\\"Diffused Band A_AAB,Diffused Band B_AAB,Band_A_EAB,Band_B_EAB\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":33.33,\\\"fieldoptionlinkid\\\":17654,\\\"forchildfieldoptionlinkid\\\":\\\"3_17654\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":null,\\\"reportprice\\\":\\\"33.33\\\",\\\"costprice\\\":33.33,\\\"costwithdiscount\\\":33.33,\\\"customersellingprice\\\":33.33,\\\"customermarkupvalue\\\":1,\\\"optiontype\\\":1,\\\"quantity\\\":1,\\\"optionnetprice\\\":33.33,\\\"sellingpriceType\\\":1}],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Fitting\\\",\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":null,\\\"widthfractiontext\\\":null,\\\"dropfractiontext\\\":null,\\\"dropfraction\\\":null,\\\"showfieldonjob\\\":1,\\\"showFieldOnCustomerPortal\\\":1,\\\"optionquantity\\\":\\\"1\\\",\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":1,\\\"fieldtypeid\\\":3,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Fitting\\\",\\\"fieldid\\\":3927,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":\\\"14553\\\",\\\"optionsvalue\\\":[{\\\"optionid\\\":14553,\\\"optionqty\\\":\\\"1\\\",\\\"optionname\\\":\\\"Fitting\\\",\\\"description\\\":null,\\\"optioncode\\\":\\\"14928\\\",\\\"pricegroups\\\":\\\"Diffused Band A_AAB,Diffused Band B_AAB,Band_A_EAB,Band_B_EAB\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":33.33,\\\"fieldoptionlinkid\\\":17654,\\\"forchildfieldoptionlinkid\\\":\\\"3_17654\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":null,\\\"reportprice\\\":\\\"33.33\\\",\\\"costprice\\\":33.33,\\\"costwithdiscount\\\":33.33,\\\"customersellingprice\\\":33.33,\\\"customermarkupvalue\\\":1,\\\"optiontype\\\":1,\\\"quantity\\\":1,\\\"optionnetprice\\\":33.33,\\\"sellingpriceType\\\":1}],\\\"editruleoverride\\\":0},{\\\"id\\\":3929,\\\"labelname\\\":\\\"Workroom Notes\\\",\\\"value\\\":null,\\\"valueid\\\":null,\\\"type\\\":18,\\\"optionid\\\":null,\\\"optionvalue\\\":[],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Workroom Notes\\\",\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":null,\\\"widthfractiontext\\\":null,\\\"dropfractiontext\\\":null,\\\"dropfraction\\\":null,\\\"showfieldonjob\\\":1,\\\"showFieldOnCustomerPortal\\\":1,\\\"optionquantity\\\":null,\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":1,\\\"fieldtypeid\\\":18,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Workroom Notes\\\",\\\"fieldid\\\":3929,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0}]\",\"oi_description\":\"Supplier: Excel, Control Type: Wand, Bunch: LH Bunch Wand, Wand Length: 750mm, Fitting: Fitting\",\"oi_onlinedescription\":\"Unit Type: mm, Quantity: 1, Supplier: Excel, Control Type: Wand, Bunch: LH Bunch Wand, Wand Length: 750mm, Fitting: Fitting\",\"oi_imagepath\":null,\"oi_reportdescription\":\"##Quantity: 1##,##Supplier: Excel##,##Control Type: Wand##,##Bunch: LH Bunch Wand##,##Wand Length: 750mm##,##Fitting: Fitting##\",\"oi_onlinereportdescription\":\"##Quantity: 1##, ##Supplier: Excel##, ##Control Type: Wand##, ##Bunch: LH Bunch Wand##, ##Wand Length: 750mm##, ##Fitting: Fitting##\",\"oi_reporttitles\":\"##Quantity:<\\\/br>##Supplier:<\\\/br>##Control Type:<\\\/br>##Bunch:<\\\/br>##Wand Length:<\\\/br>##Fitting:\",\"oi_onlinereporttitles\":\"##Quantity:, ##Supplier:, ##Control Type:, ##Bunch:, ##Wand Length:, ##Fitting:\",\"oi_productionformulajsondata\":\"[{\\\"productionoveride\\\":0,\\\"id\\\":null,\\\"value\\\":\\\"-\\\",\\\"formula\\\":null,\\\"price\\\":null,\\\"recipeid\\\":null,\\\"stockupdate\\\":0,\\\"fieldid\\\":null,\\\"isdelete\\\":0,\\\"defaultstock\\\":null,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":100,\\\"value\\\":null,\\\"formula\\\":\\\"Quantity*2\\\",\\\"price\\\":null,\\\"recipeid\\\":60,\\\"stockupdate\\\":0,\\\"fieldid\\\":17616,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":3,\\\"option_name\\\":\\\"Top Fix\\\",\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":121,\\\"value\\\":\\\"1.00\\\",\\\"formula\\\":\\\"Quantity\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":60,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":\\\"1.00\\\"},{\\\"formula\\\":\\\"noFormula\\\",\\\"stockupdate\\\":0,\\\"isdelete\\\":0,\\\"fieldtype_id\\\":3,\\\"fractionvalue\\\":null},{\\\"formula\\\":\\\"noFormula\\\",\\\"stockupdate\\\":0,\\\"isdelete\\\":0,\\\"fieldtype_id\\\":3,\\\"fractionvalue\\\":null},{\\\"formula\\\":\\\"noFormula\\\",\\\"stockupdate\\\":0,\\\"isdelete\\\":0,\\\"fieldtype_id\\\":3,\\\"fractionvalue\\\":null},{\\\"formula\\\":\\\"noFormula\\\",\\\"stockupdate\\\":0,\\\"isdelete\\\":0,\\\"fieldtype_id\\\":3,\\\"fractionvalue\\\":null}]\",\"oi_productiondate\":\"2025-05-28 12:52:52\",\"oi_operationstatus\":\"0\",\"oi_scanstatus\":\"\",\"oi_operationworkroom_data\":\"[]\",\"oi_operationcalender_data\":\"[]\",\"oi_operation_calculations\":\"{\\\"calendar\\\":\\\"0.00\\\",\\\"workroom\\\":\\\"0.00\\\",\\\"cost_with_discount\\\":\\\"0.00\\\",\\\"cost_with_markup\\\":\\\"0.00\\\",\\\"gross_price\\\":\\\"0.00\\\",\\\"vat_price\\\":\\\"0.00\\\"}\",\"oi_pricecomesfrom_calculations\":\"{\\\"label\\\":\\\"Price table cost\\\",\\\"unit_type\\\":\\\"-\\\",\\\"cost_price\\\":\\\"0.00\\\",\\\"show_hide\\\":true,\\\"category\\\":3}\",\"oi_pricetablepriceevenbom\":\"{\\\"sellingPrice\\\":0,\\\"pricetableCostAfterSuppdisc\\\":0,\\\"priceTableCost\\\":0}\",\"oi_productionstatus\":null,\"oi_costoverride\":0,\"oi_costprice\":\"38.830\",\"oi_netprice\":\"41.580\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"8.320\",\"oi_vatvalue\":\"20.000\",\"oi_vatselected\":1,\"oi_vattype\":1,\"oi_vatonoff\":1,\"oi_grossprice\":\"49.900\",\"oi_overrideprice\":\"0.000\",\"oi_overridetype\":2,\"oi_overridevalue\":null,\"oi_overridenetprice\":\"0.000\",\"oi_overridevatprice\":\"0.000\",\"oi_overridegrossprice\":\"0.000\",\"oi_ready\":0,\"oi_onhold\":0,\"oi_platformcreatedfrom\":\"web\",\"oi_platformlastupdatedfrom\":\"web\",\"oi_copiedfrom\":0,\"oi_isonlineorder\":1,\"oi_endcustomervatprice\":null,\"oi_endcustomeroverridetype\":1,\"oi_endcustomeroverridevalue\":null,\"oi_endcustomeroverridenetprice\":\"41.580\",\"oi_endcustomeroverridevatprice\":\"8.320\",\"oi_endcustomeroverridegrossprice\":\"49.900\",\"oi_sage_flag\":0,\"oi_supid\":null,\"oi_status\":0,\"oi_createdby\":14,\"oi_createdat\":\"2025-05-28T12:52:52.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":\"2025-05-28T07:23:10.000000Z\",\"oi_jsondataid\":\"[3892, 3891, 3895, 3893, 3896, 3897, 3898, 3894, 3904, 3905, 3906, 3917, 3919, 3921, 3926, 3928, 3927, 3929]\",\"oi_deviceplatform\":0,\"oi_custompricefields\":\"\",\"oi_editransfer\":0,\"oi_apisup_orderid\":0,\"oi_commissionprice\":\"0.000\",\"oi_commissionvatprice\":\"0.000\",\"oi_jsondatabackup\":\"\",\"oi_stockdeduct\":0,\"oi_deductedstockdetails\":null,\"lineitem_id\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "32932", "cl_createdat": "1748416990.000000", "cl_updatedat": null }, { "cl_id": 32933, "cl_logname": "model", "cl_type": null, "cl_modulename": "Production Due Date", "cl_message": "Production Due Date has been updated", "cl_event": "modified", "cl_subjectid": 12776, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 12776, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 14, "cl_changedfrom": "{\"Production Due Date\":\"0000-00-00\"}", "cl_changedto": "{\"Production Due Date\":\"2025-05-28\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "32933", "cl_createdat": "1748416990.000000", "cl_updatedat": null }, { "cl_id": 32934, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the fields Net Price,VAT Price,Gross Price Amount,Gross Profit,Gross Profit Percentage,Total CostPrice,Amount Outstanding", "cl_event": "modified", "cl_subjectid": 12776, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 12776, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 14, "cl_changedfrom": "{\"Net Price\":\"0.00\",\"VAT Price\":\"0.00\",\"Gross Price Amount\":\"0.00\",\"Gross Profit\":\"0.00\",\"Gross Profit Percentage\":\"0.00\",\"Total CostPrice\":\"0.00\",\"Amount Outstanding\":\"0.00\"}", "cl_changedto": "{\"Net Price\":\"41.58\",\"VAT Price\":\"8.32\",\"Gross Price Amount\":\"49.90\",\"Gross Profit\":\"2.75\",\"Gross Profit Percentage\":\"6.61\",\"Total CostPrice\":\"38.83\",\"Amount Outstanding\":\"49.90\"}", "cl_customproperties": "{\"attributes\":{\"jd_listprice\":\"41.58\",\"jd_netprice\":\"41.58\",\"jd_vat\":\"8.32\",\"jd_grossprice\":\"49.90\",\"jd_grossprofit\":\"2.75\",\"jd_grossprofit_percentage\":\"6.61\",\"jd_costprice\":\"38.83\",\"jd_amountoutstanding\":\"49.90\",\"jd_updatedat\":\"2025-05-28T07:23:12.000000Z\"},\"old\":{\"jd_listprice\":\"0.00\",\"jd_netprice\":\"0.00\",\"jd_vat\":\"0.00\",\"jd_grossprice\":\"0.00\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"0.00\",\"jd_amountoutstanding\":\"0.00\",\"jd_updatedat\":\"2025-05-28T07:23:10.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "32934", "cl_createdat": "1748416992.000000", "cl_updatedat": null }, { "cl_id": 32935, "cl_logname": "QUEUE_7", "cl_type": "QUEUE_7", "cl_modulename": "Line Item", "cl_message": "Q1 - Line Item has been updated the field Production Date for the product of Allusion Blind", "cl_event": "modified", "cl_subjectid": 80457, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 12776, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 14, "cl_changedfrom": "{\"Production Date\":\"2025-05-28 12:52:52\"}", "cl_changedto": "{\"Production Date\":\"2025-05-30 00:00:00\"}", "cl_customproperties": "{\"attributes\":{\"oi_ruleid\":7,\"oi_productiondate\":\"2025-05-30 00:00:00\",\"oi_updatedat\":\"2025-05-28T07:23:15.000000Z\"},\"old\":{\"oi_ruleid\":0,\"oi_productiondate\":\"2025-05-28 12:52:52\",\"oi_updatedat\":\"2025-05-28T07:23:10.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "32935", "cl_createdat": "1748416995.000000", "cl_updatedat": null }, { "cl_id": 32936, "cl_logname": "model", "cl_type": "QUEUE_7", "cl_modulename": "Production Due Date", "cl_message": "Production Due Date has been updated", "cl_event": "modified", "cl_subjectid": 12776, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 12776, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 14, "cl_changedfrom": "{\"Production Due Date\":\"2025-05-28\"}", "cl_changedto": "{\"Production Due Date\":\"2025-05-30\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "32936", "cl_createdat": "1748416995.000000", "cl_updatedat": null }, { "cl_id": 32937, "cl_logname": "default", "cl_type": null, "cl_modulename": "All Jobs", "cl_message": "Quotation report generated by Yogeshwari All Jobs", "cl_event": "created", "cl_subjectid": 3359, "cl_subjecttype": "App\\Models\\Reports\\bm_reportactivitylog", "cl_parentid": 12776, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 14, "cl_changedfrom": "null", "cl_changedto": "{\"Category: \":\"Quotation\"}", "cl_customproperties": "{\"attributes\":{\"ral_id\":3359,\"ral_jobid\":12776,\"ral_reportid\":1,\"ral_categoryid\":1,\"ral_description\":\"Quotation report generated by Yogeshwari\",\"ral_attachment\":\"\",\"ral_actionid\":1,\"ral_createdat\":\"2025-05-28T07:23:15.000000Z\",\"ral_updatedat\":\"2025-05-28T07:23:15.000000Z\",\"ral_createdby\":14,\"ral_updatedby\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "32937", "cl_createdat": "1748416995.000000", "cl_updatedat": null }, { "cl_id": 32938, "cl_logname": "model", "cl_type": "QUEUE_8", "cl_modulename": "Job Status", "cl_message": "Job Status has been updated", "cl_event": "modified", "cl_subjectid": 12776, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 12776, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 14, "cl_changedfrom": "{\"Job Status\":\"Lead\"}", "cl_changedto": "{\"Job Status\":\"Quote\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "32938", "cl_createdat": "1748416998.000000", "cl_updatedat": null }, { "cl_id": 32939, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the fields End Customer Override Net Price,End Customer Override Vat Price,End Customer Override Gross Price", "cl_event": "modified", "cl_subjectid": 12776, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 12776, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 14, "cl_changedfrom": "{\"End Customer Override Net Price\":\"0.00\",\"End Customer Override Vat Price\":\"0.00\",\"End Customer Override Gross Price\":\"0.00\"}", "cl_changedto": "{\"End Customer Override Net Price\":\"41.58\",\"End Customer Override Vat Price\":\"8.32\",\"End Customer Override Gross Price\":\"49.90\"}", "cl_customproperties": "{\"attributes\":{\"jd_endcustomeroverridevalue\":\"\",\"jd_endcustomeroverridenetprice\":\"41.58\",\"jd_endcustomeroverridevatprice\":\"8.32\",\"jd_endcustomeroverridegrossprice\":\"49.90\",\"jd_endcustomerdeliverycost\":\"\",\"jd_endcustomerfittingcost\":\"\",\"jd_updatedat\":\"2025-05-28T07:23:24.000000Z\"},\"old\":{\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerfittingcost\":null,\"jd_updatedat\":\"2025-05-28T07:23:18.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "32939", "cl_createdat": "1748417004.000000", "cl_updatedat": null }, { "cl_id": 32942, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 12777, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 12777, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 14, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"Concorde Blinds, Curtains, Shutters\",\"Account Type\":\"Domestic\",\"Source\":\"Previous Customer\",\"Created By\":\"Yogeshwari\",\"First Name\":\"Sara\",\"Last Name\":\"Wareing\",\"Address1\":\"16 Farrell Road\",\"Address2\":\"Wootton\",\"Town \\\/ City\":\"Bedford\",\"Zipcode \\\/ Postcode\":\"MK43 9DU\",\"Country\":\"UK\",\"Salutation\":\"Ms.\",\"Assigned to\":14,\"Role\":\"0\",\"Additional Contacts\":\"1014\",\"Job Status\":\"Lead\",\"Order Status\":\"1) Enquiry\",\"Net Price\":\"351.09\",\"VAT Price\":\"70.22\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"Gross Price Amount\":\"421.31\",\"Gross Profit\":\"144.78\",\"Gross Profit Percentage\":\"41.24\",\"Total CostPrice\":\"206.31\",\"Amount Outstanding\":\"421.31\",\"jd_isonlineorder\":1,\"End Customer Override Type\":1,\"End Customer Delivery Cost Include Vat\":1,\"End Customer Fitting Cost Include Vat\":1,\"Delivery Vat Percentage\":\"20.000\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":12777,\"jd_customerid\":762,\"jd_contactid\":1014,\"jd_additionalcontacts\":\"1014\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"33\\\":\\\"25\\\",\\\"37\\\":1,\\\"39\\\":4,\\\"41\\\":14,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"Sara\\\",\\\"46\\\":\\\"Wareing\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"16 Farrell Road\\\",\\\"50\\\":\\\"Wootton\\\",\\\"51\\\":\\\"Bedford\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"MK43 9DU\\\",\\\"54\\\":19,\\\"285\\\":10,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":14,\\\"558\\\":\\\"0\\\",\\\"612\\\":\\\"\\\",\\\"614\\\":\\\"\\\",\\\"615\\\":\\\"\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-05-28\",\"jd_orderdate\":\"0000-00-00\",\"jd_duedate\":\"0000-00-00\",\"jd_sceduleddate\":\"0000-00-00\",\"jd_invoicedate\":\"0000-00-00\",\"jd_completeddate\":\"0000-00-00\",\"jd_jobref\":null,\"jd_jobstatus\":1,\"jd_contactaddid\":0,\"jd_orderstatus\":3,\"jd_accref\":\"WARE1002\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"351.09\",\"jd_netprice\":\"351.09\",\"jd_vat\":\"70.22\",\"jd_isvaton\":1,\"jd_deliverycost\":\"0.00\",\"jd_deliverycosttypeid\":1,\"jd_overridetypeid\":2,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":0,\"jd_isroundon\":0,\"jd_grossprice\":\"421.31\",\"jd_grossprofit\":\"144.78\",\"jd_grossprofit_percentage\":\"41.24\",\"jd_costprice\":\"206.31\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"421.31\",\"jd_totpaid\":\"0.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":\"\\\"\\\"\",\"jd_deliverycostid\":0,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":1,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":1,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":1,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":null,\"jd_organizationid\":0,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":14,\"jd_createdat\":\"2025-05-28T07:24:34.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-05-28T07:24:34.000000Z\",\"jd_deviceplatform\":0,\"jd_fromjobref\":\"\",\"jd_fromdbname\":null,\"jd_importorder\":0,\"jd_quickquote\":0,\"jd_myob_flag\":0,\"jd_myobinvoiceid\":\"\",\"jd_qboflag\":0,\"jd_qboinvoiceid\":0,\"jd_qbodisplayname\":\"\",\"jd_deliveryvatperc\":\"20.000\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"20.000\",\"jd_commission\":\"[]\",\"jd_commissionprice\":\"0.00\",\"jd_commissionsetting\":0,\"jd_commissionaddedvalue\":\"0.00\",\"jd_onlineprefixseq\":\"\",\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":0,\"jd_rework_count\":0,\"salesorderid\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "32942", "cl_createdat": "1748417074.000000", "cl_updatedat": null }, { "cl_id": 32951, "cl_logname": "QUEUE_7", "cl_type": "QUEUE_7", "cl_modulename": "Line Item", "cl_message": "Q1 - Line Item has been updated the field Production Date for the product of Vertical Blind", "cl_event": "modified", "cl_subjectid": 80458, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 12777, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 14, "cl_changedfrom": "{\"Production Date\":\"2025-05-28 12:54:25\"}", "cl_changedto": "{\"Production Date\":\"2025-05-30 00:00:00\"}", "cl_customproperties": "{\"attributes\":{\"oi_ruleid\":7,\"oi_productiondate\":\"2025-05-30 00:00:00\",\"oi_updatedat\":\"2025-05-28T07:24:39.000000Z\"},\"old\":{\"oi_ruleid\":0,\"oi_productiondate\":\"2025-05-28 12:54:25\",\"oi_updatedat\":\"2025-05-28T07:24:34.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "32951", "cl_createdat": "1748417079.000000", "cl_updatedat": null }, { "cl_id": 32952, "cl_logname": "model", "cl_type": "QUEUE_7", "cl_modulename": "Production Due Date", "cl_message": "Production Due Date has been updated", "cl_event": "modified", "cl_subjectid": 12777, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 12777, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 14, "cl_changedfrom": "{\"Production Due Date\":\"2025-05-28\"}", "cl_changedto": "{\"Production Due Date\":\"2025-05-30\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "32952", "cl_createdat": "1748417079.000000", "cl_updatedat": null }, { "cl_id": 32953, "cl_logname": "QUEUE_7", "cl_type": "QUEUE_7", "cl_modulename": "Line Item", "cl_message": "Q1 - Line Item has been updated the field Production Date for the product of Vertical Blind", "cl_event": "modified", "cl_subjectid": 80459, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 12777, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 14, "cl_changedfrom": "{\"Production Date\":\"2025-05-28 12:54:25\"}", "cl_changedto": "{\"Production Date\":\"2025-05-30 00:00:00\"}", "cl_customproperties": "{\"attributes\":{\"oi_ruleid\":7,\"oi_productiondate\":\"2025-05-30 00:00:00\",\"oi_updatedat\":\"2025-05-28T07:24:39.000000Z\"},\"old\":{\"oi_ruleid\":0,\"oi_productiondate\":\"2025-05-28 12:54:25\",\"oi_updatedat\":\"2025-05-28T07:24:34.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "32953", "cl_createdat": "1748417079.000000", "cl_updatedat": null }, { "cl_id": 32954, "cl_logname": "default", "cl_type": null, "cl_modulename": "All Jobs", "cl_message": "Quotation report generated by Yogeshwari All Jobs", "cl_event": "created", "cl_subjectid": 3360, "cl_subjecttype": "App\\Models\\Reports\\bm_reportactivitylog", "cl_parentid": 12777, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 14, "cl_changedfrom": "null", "cl_changedto": "{\"Category: \":\"Quotation\"}", "cl_customproperties": "{\"attributes\":{\"ral_id\":3360,\"ral_jobid\":12777,\"ral_reportid\":1,\"ral_categoryid\":1,\"ral_description\":\"Quotation report generated by Yogeshwari\",\"ral_attachment\":\"\",\"ral_actionid\":1,\"ral_createdat\":\"2025-05-28T07:24:43.000000Z\",\"ral_updatedat\":\"2025-05-28T07:24:43.000000Z\",\"ral_createdby\":14,\"ral_updatedby\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "32954", "cl_createdat": "1748417083.000000", "cl_updatedat": null }, { "cl_id": 32955, "cl_logname": "model", "cl_type": "QUEUE_8", "cl_modulename": "Job Status", "cl_message": "Job Status has been updated", "cl_event": "modified", "cl_subjectid": 12777, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 12777, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 14, "cl_changedfrom": "{\"Job Status\":\"Lead\"}", "cl_changedto": "{\"Job Status\":\"Quote\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "32955", "cl_createdat": "1748417085.000000", "cl_updatedat": null }, { "cl_id": 32956, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 12778, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 12778, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"Concorde Blinds, Curtains, Shutters\",\"\":1,\"Account Type\":\"Domestic\",\"Source\":\"Website\",\"Created By\":\"admin\",\"First Name\":\"Test\",\"Last Name\":\"A\",\"Zipcode \\\/ Postcode\":\"09\",\"Country\":\"UK\",\"Salutation\":\"Mr.\",\"Assigned to\":1,\"Additional Contacts\":\"7296\",\"Production Due Date\":\"2025-05-28\",\"Job Ref No\":\"11444\",\"Job Status\":\"Lead\",\"Order Status\":\"1) Enquiry\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"jd_isonlineorder\":1,\"Delivery Vat Percentage\":\"20.000\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":12778,\"jd_customerid\":5879,\"jd_contactid\":7296,\"jd_additionalcontacts\":\"7296\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"11444\\\",\\\"35\\\":\\\"ATES0001\\\",\\\"36\\\":1,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":1,\\\"40\\\":3,\\\"41\\\":1,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"Test\\\",\\\"46\\\":\\\"A\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"09\\\",\\\"54\\\":19,\\\"285\\\":1,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":1,\\\"558\\\":\\\"\\\",\\\"612\\\":\\\"\\\",\\\"614\\\":\\\"\\\",\\\"615\\\":\\\"\\\",\\\"countryText\\\":\\\"UK\\\",\\\"adminUser\\\":1}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-05-28\",\"jd_orderdate\":null,\"jd_duedate\":\"2025-05-28\",\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":null,\"jd_jobref\":\"11444\",\"jd_jobstatus\":1,\"jd_contactaddid\":0,\"jd_orderstatus\":3,\"jd_accref\":\"ATES0001\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"0.00\",\"jd_netprice\":\"0.00\",\"jd_vat\":\"0.00\",\"jd_isvaton\":1,\"jd_deliverycost\":\"0.00\",\"jd_deliverycosttypeid\":1,\"jd_overridetypeid\":1,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":null,\"jd_isroundon\":0,\"jd_grossprice\":\"0.00\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"0.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"0.00\",\"jd_totpaid\":\"0.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":null,\"jd_deliverycostid\":0,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":0,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":0,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":0,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":0,\"jd_organizationid\":0,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":1,\"jd_createdat\":\"2025-05-28T07:24:37.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-05-28T07:25:33.000000Z\",\"jd_deviceplatform\":0,\"jd_fromjobref\":\"\",\"jd_fromdbname\":null,\"jd_importorder\":0,\"jd_quickquote\":0,\"jd_myob_flag\":0,\"jd_myobinvoiceid\":\"\",\"jd_qboflag\":0,\"jd_qboinvoiceid\":0,\"jd_qbodisplayname\":\"\",\"jd_deliveryvatperc\":\"20.000\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"20.000\",\"jd_commission\":\"[]\",\"jd_commissionprice\":\"0.00\",\"jd_commissionsetting\":0,\"jd_commissionaddedvalue\":\"0.00\",\"jd_onlineprefixseq\":null,\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":0,\"jd_rework_count\":0,\"salesorderid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "32956", "cl_createdat": "1748417133.000000", "cl_updatedat": null }, { "cl_id": 32957, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 485594, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 12778, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"Job Created\",\"Platform\":\"Trade\",\"Description\":\"New job has been created in job\",\"Created By\":\"admin\",\"Date\":\"2025-05-28\",\"Time\":\"07:24:37\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":485594,\"nl_ordertempid\":0,\"nl_orderid\":12778,\"nl_notescategory\":1,\"nl_type\":5,\"nl_platform\":2,\"nl_desc\":\"New job has been created in job\",\"nl_manualNotes\":null,\"nl_createdby\":\"1\",\"nl_endddate\":\"2025-05-28\",\"nl_starttime\":\"07:24:37\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":1,\"created_at\":\"2025-05-28T07:24:37.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-05-28T07:25:33.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "32957", "cl_createdat": "1748417133.000000", "cl_updatedat": null }, { "cl_id": 32958, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in 11444", "cl_event": "created", "cl_subjectid": 12782, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 12778, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":12782,\"jmq_jobid\":12778,\"Quotation Name\":\"Q1\",\"jmq_isdefault\":0,\"Quotation\":\"Accepted\",\"jmq_isdeclined\":0,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"Production Due Date\":\"0000-00-00\",\"List Price\":\"0.00\",\"Net Price\":\"0.00\",\"VAT Price\":\"0.00\",\"VAT\":1,\"jmq_deliverycost\":\"0.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"0.00\",\"Gross Profit\":\"0.00\",\"Total CostPrice\":\"0.00\",\"Amount Outstanding\":\"0.00\",\"Total Paid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_deliverycostid\":0,\"Total Cost Price\":0,\"jmq_isonlineorder\":0,\"Is Online Order Submitted\":0,\"End Customer Override Type\":0,\"End Customer Override Net Price\":\"0.00\",\"End Customer Override Vat Price\":\"0.00\",\"End Customer Override Gross Price\":\"0.00\",\"End Customer Delivery Cost Include Vat\":0,\"End Customer Fitting Cost Include Vat\":0,\"Online Delivery Addreddtype\":0,\"Commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"Delivery Vat Percentage\":\"20.000\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":12782,\"jmq_jobid\":12778,\"jmq_quotationname\":\"Q1\",\"jmq_isdefault\":0,\"jmq_isaccepted\":1,\"jmq_isdeclined\":0,\"jmq_esignflag\":null,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"jmq_duedate\":\"0000-00-00\",\"jmq_sceduleddate\":\"0000-00-00\",\"jmq_listprice\":\"0.00\",\"jmq_netprice\":\"0.00\",\"jmq_vat\":\"0.00\",\"jmq_isvaton\":1,\"jmq_deliverycost\":\"0.00\",\"jmq_deliverycosttypeid\":1,\"jmq_overridetypeid\":1,\"jmq_orderformprice\":\"0.00\",\"jmq_editpricebyid\":null,\"jmq_isroundon\":0,\"jmq_grossprice\":\"0.00\",\"jmq_grossprofit\":\"0.00\",\"jmq_costprice\":\"0.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"0.00\",\"jmq_totpaid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_userdefinedarray\":null,\"jmq_deliverycostid\":0,\"jmq_iscostpriceon\":0,\"jmq_custompricefields\":\"\",\"jmq_isonlineorder\":0,\"jmq_isonlineordersubmitted\":0,\"jmq_endcustomervatprice\":null,\"jmq_endcustomeroverridetype\":0,\"jmq_endcustomeroverridevalue\":null,\"jmq_endcustomeroverridenetprice\":\"0.00\",\"jmq_endcustomeroverridevatprice\":\"0.00\",\"jmq_endcustomeroverridegrossprice\":\"0.00\",\"jmq_endcustomerdeliverycost\":null,\"jmq_endcustomerdeliverycostinclvat\":0,\"jmq_endcustomerfittingcost\":null,\"jmq_endcustomerfittingcostinclvat\":0,\"jmq_onlinedeliveryaddreddtype\":0,\"jmq_onlinedeliveryaddreddid\":null,\"jmq_commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"jmq_deliveryvatperc\":\"20.000\",\"jmq_cdeliveryvatperc\":\"20.000\",\"jmq_createdby\":1,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-05-28T07:24:37.000000Z\",\"jmq_updatedat\":null,\"jmq_grossprofit_percentage\":\"0.00\",\"jmq_ready\":0}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "32958", "cl_createdat": "1748417133.000000", "cl_updatedat": null }, { "cl_id": 32959, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the field Multi Quote Id", "cl_event": "modified", "cl_subjectid": 12778, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 12778, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":12782}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":12782},\"old\":{\"jd_jobmultiquoteid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "32959", "cl_createdat": "1748417133.000000", "cl_updatedat": null }, { "cl_id": 32960, "cl_logname": "default", "cl_type": null, "cl_modulename": "Line Item", "cl_message": "Q1 - new item has been created in Line Item for the product of Cellular Blind", "cl_event": "created", "cl_subjectid": 80460, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 12778, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Unit Type\":\" mm\",\" Quantity\":\" 1\",\" Supplier\":\" Master Blinds\",\" Width\":\" 800\",\" Drop\":\" 800\",\" Fabric\":\" Elan Metallic Duotone\",\" Color\":\" Bronze 4720\",\" Product Type\":\" Smartcord Band C_MBCB\"}", "cl_customproperties": "{\"attributes\":{\"oi_id\":80460,\"oi_jobid\":12778,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":12782,\"oi_credit_id\":0,\"oi_productid\":248,\"oi_recipeid\":248,\"oi_ruleid\":0,\"oi_qty\":1,\"oi_seq\":0,\"oi_customseq\":0,\"oi_productcustomseq\":0,\"oi_jsondata\":\"[{\\\"id\\\":22031,\\\"labelname\\\":\\\"Unit Type\\\",\\\"value\\\":2,\\\"valueid\\\":\\\"2\\\",\\\"type\\\":34,\\\"optionid\\\":\\\"2\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":2,\\\"optionname\\\":\\\"mm\\\",\\\"optioncode\\\":\\\"\\\",\\\"optionquantity\\\":1,\\\"unittype\\\":0,\\\"unitcost\\\":0,\\\"pricingtype\\\":0,\\\"fieldoptionlinkid\\\":2,\\\"forchildfieldoptionlinkid\\\":\\\"34_2\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":22030,\\\"labelname\\\":\\\"Quantity\\\",\\\"value\\\":1,\\\"valueid\\\":\\\"\\\",\\\"type\\\":14,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":22034,\\\"labelname\\\":\\\"Room\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":22032,\\\"labelname\\\":\\\"Supplier\\\",\\\"value\\\":37,\\\"valueid\\\":\\\"\\\",\\\"type\\\":17,\\\"optionid\\\":\\\"37\\\",\\\"optionvalue\\\":[{\\\"id\\\":37,\\\"optionid\\\":37,\\\"optionname\\\":\\\"Master Blinds\\\",\\\"deleted\\\":0,\\\"optionquantity\\\":1}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":22036,\\\"labelname\\\":\\\"Width\\\",\\\"value\\\":\\\"800\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":11,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":22037,\\\"labelname\\\":\\\"Drop\\\",\\\"value\\\":\\\"800\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":12,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":22038,\\\"labelname\\\":\\\"Fabric\\\",\\\"value\\\":\\\"Elan Metallic Duotone\\\",\\\"valueid\\\":\\\"16043\\\",\\\"type\\\":5,\\\"optionid\\\":\\\"16043\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":16043,\\\"optionname\\\":\\\"Elan Metallic Duotone\\\",\\\"optionquantity\\\":1,\\\"fieldoptionlinkid\\\":16043,\\\"forchildfieldoptionlinkid\\\":\\\"5_2_16043_1\\\",\\\"optionimage\\\":\\\"\\\",\\\"subdatacount\\\":1,\\\"pricegroup\\\":\\\"Smartcord Band C_MBCB\\\",\\\"pricegroupid\\\":1444}],\\\"fabricorcolor\\\":1,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":22134,\\\"labelname\\\":\\\"Color\\\",\\\"value\\\":\\\"Bronze 4720\\\",\\\"valueid\\\":\\\"81957\\\",\\\"type\\\":5,\\\"optionid\\\":\\\"81957\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":81957,\\\"optionname\\\":\\\"Bronze 4720\\\",\\\"optionquantity\\\":1,\\\"fieldoptionlinkid\\\":81957,\\\"forchildfieldoptionlinkid\\\":\\\"5_3_81957_1\\\",\\\"minimumdiscount\\\":\\\"\\\",\\\"maximumdiscount\\\":\\\"\\\",\\\"optionimage\\\":\\\"\\\",\\\"subdatacount\\\":0}],\\\"fabricorcolor\\\":2,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":22033,\\\"labelname\\\":\\\"Product Type\\\",\\\"value\\\":1444,\\\"valueid\\\":\\\"1444\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"1444\\\",\\\"optionvalue\\\":[{\\\"id\\\":1444,\\\"fieldid\\\":22033,\\\"fieldoptionlinkid\\\":1444,\\\"optionid\\\":1444,\\\"mainsupplier\\\":37,\\\"blindtypecode\\\":\\\"\\\",\\\"optionname\\\":\\\"Smartcord Band C_MBCB\\\",\\\"optionquantity\\\":1,\\\"subcount\\\":0,\\\"status\\\":0,\\\"subdatacount\\\":0}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":22685,\\\"labelname\\\":\\\"Special Instructions\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":22686,\\\"labelname\\\":\\\"Workroom Notes\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0}]\",\"oi_description\":\"Unit Type: mm, Quantity: 1, Supplier: Master Blinds, Width: 800, Drop: 800, Fabric: Elan Metallic Duotone, Color: Bronze 4720, Product Type: Smartcord Band C_MBCB\",\"oi_onlinedescription\":null,\"oi_imagepath\":null,\"oi_reportdescription\":\"##Quantity: 1##,##Supplier: Master Blinds##,##Width: 800 mm##,##Drop: 800 mm##,##Fabric: Elan Metallic Duotone##,##Color: Bronze 4720##,##Product Type: Smartcord Band C_MBCB##\",\"oi_onlinereportdescription\":null,\"oi_reporttitles\":\"##Quantity:##Supplier:##Width:##Drop:##Fabric:##Color:##Product Type:\",\"oi_onlinereporttitles\":null,\"oi_productionformulajsondata\":\"[]\",\"oi_productiondate\":\"2025-05-28 07:24:45\",\"oi_operationstatus\":null,\"oi_scanstatus\":\"\",\"oi_operationworkroom_data\":\"[]\",\"oi_operationcalender_data\":\"[]\",\"oi_operation_calculations\":\"[]\",\"oi_pricecomesfrom_calculations\":\"{}\",\"oi_pricetablepriceevenbom\":\"{}\",\"oi_productionstatus\":null,\"oi_costoverride\":0,\"oi_costprice\":\"0.000\",\"oi_netprice\":\"0.000\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"0.000\",\"oi_vatvalue\":\"20.000\",\"oi_vatselected\":1,\"oi_vattype\":1,\"oi_vatonoff\":1,\"oi_grossprice\":\"0.000\",\"oi_overrideprice\":\"0.000\",\"oi_overridetype\":2,\"oi_overridevalue\":null,\"oi_overridenetprice\":\"0.000\",\"oi_overridevatprice\":\"0.000\",\"oi_overridegrossprice\":\"0.000\",\"oi_ready\":0,\"oi_onhold\":0,\"oi_platformcreatedfrom\":\"web\",\"oi_platformlastupdatedfrom\":\"web\",\"oi_copiedfrom\":0,\"oi_isonlineorder\":0,\"oi_endcustomervatprice\":null,\"oi_endcustomeroverridetype\":2,\"oi_endcustomeroverridevalue\":null,\"oi_endcustomeroverridenetprice\":\"0.000\",\"oi_endcustomeroverridevatprice\":\"0.000\",\"oi_endcustomeroverridegrossprice\":\"0.000\",\"oi_sage_flag\":0,\"oi_supid\":null,\"oi_status\":0,\"oi_createdby\":1,\"oi_createdat\":\"2025-05-28T07:25:21.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":null,\"oi_jsondataid\":\"[22031, 22030, 22034, 22032, 22036, 22037, 22038, 22134, 22033, 22685, 22686]\",\"oi_deviceplatform\":2,\"oi_custompricefields\":\"\",\"oi_editransfer\":0,\"oi_apisup_orderid\":0,\"oi_commissionprice\":\"0.000\",\"oi_commissionvatprice\":\"0.000\",\"oi_jsondatabackup\":\"\",\"oi_stockdeduct\":0,\"oi_deductedstockdetails\":null,\"lineitem_id\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "32960", "cl_createdat": "1748417134.000000", "cl_updatedat": null } ], "updated": [], "deleted": [] }, "bm_productInfo": { "created": [], "updated": [], "deleted": [] }, "bm_fields": { "created": [], "updated": [], "deleted": [] }, "bm_fieldOptionLink": { "created": [], "updated": [], "deleted": [] }, "bm_option": { "created": [], "updated": [], "deleted": [] }, "bm_optionproduct": { "created": [], "updated": [], "deleted": [] }, "bm_linkedfieldswithproduct": { "created": [], "updated": [], "deleted": [] }, "bm_productionstatus": { "created": [], "updated": [], "deleted": [] }, "bm_productpricemap": { "created": [], "updated": [], "deleted": [] }, "bm_productrecipe": { "created": [], "updated": [], "deleted": [] }, "bm_productrecipemap": { "created": [], "updated": [], "deleted": [] }, "bm_supproductcode": { "created": [], "updated": [], "deleted": [] }, "bm_rulesetup": { "created": [], "updated": [], "deleted": [] }, "bm_formulas": { "created": [], "updated": [], "deleted": [] }, "bm_customercommission": { "created": [], "updated": [], "deleted": [] }, "bm_productgroupdetails": { "created": [], "updated": [], "deleted": [] }, "bm_productgroupmaterialmap": { "created": [], "updated": [], "deleted": [] }, "bm_productpricedetails": { "created": [], "updated": [], "deleted": [] }, "bm_fabriccolourmap": { "created": [], "updated": [], "deleted": [] }, "bm_fabricdetails": { "created": [], "updated": [], "deleted": [] }, "bm_colordetails": { "created": [], "updated": [], "deleted": [] }, "bm_optiondiscount": { "created": [], "updated": [], "deleted": [] }, "bm_optionpricebook": { "created": [], "updated": [], "deleted": [] }, "bm_allowances": { "created": [], "updated": [], "deleted": [] }, "bm_xyoptionpricedata": { "created": [], "updated": [], "deleted": [] }, "bm_delivery_cost_setup": { "created": [], "updated": [], "deleted": [] }, "bm_organizationdetails": { "created": [], "updated": [], "deleted": [] }, "bm_applicationSetup": { "created": [], "updated": [], "deleted": [] } }, "synctodelete": { "bm_customercontactinfo": { "51748417077": 7296 }, "bm_customertemplatedata": { "31748417077": 5879 }, "bm_jobdetails": { "41748417077": 12778 }, "bm_notelist": { "61748417077": 485594 }, "bm_jobmultiquote": { "141748417077": 12782 }, "bm_orderitem": { "71748417121": 80460 } }, "timestamp": 1748417133 }