{ "status": "success", "upcomingorder_list": { "bm_customertemplatedata": { "created": [], "updated": [ { "ctd_id": 229, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\": 1, \"62\": \"DOBE1001\", \"63\": \"\", \"64\": 4, \"65\": \"g.dobeson@ntlworld.com\", \"66\": null, \"67\": \"1 Cartwright Close\", \"68\": \"\", \"69\": \"Bromham\", \"70\": \"MK43 8QF\", \"71\": \"Bedford\", \"72\": 19, \"73\": \"01234825798\", \"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": "229", "ctd_createdat": 1740814308, "ctd_updatedat": 1752492926, "ctd_createdby": 1, "ctd_updatedby": 1 }, { "ctd_id": 229, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\": 1, \"62\": \"DOBE1001\", \"63\": \"\", \"64\": 4, \"65\": \"g.dobeson@ntlworld.com\", \"66\": null, \"67\": \"1 Cartwright Close\", \"68\": \"\", \"69\": \"Bromham\", \"70\": \"MK43 8QF\", \"71\": \"Bedford\", \"72\": 19, \"73\": \"01234825798\", \"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": "229", "ctd_createdat": 1740814308, "ctd_updatedat": 1752492926, "ctd_createdby": 1, "ctd_updatedby": 1 } ], "deleted": [] }, "bm_customercontactinfo": { "created": [], "updated": [ { "cci_id": 437, "cci_customerid": 229, "cci_templateid": 3, "roleid": 2, "cci_customizedarray": "{\"82\":\"g.dobeson@ntlworld.com\",\"77\":\"\",\"79\":\"Dobeson\",\"78\":\"07983907413\",\"76\":\"01234825798\",\"81\":\"0\",\"75\":1,\"83\":\"\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"1 Cartwright Close\",\"89\":\"Bromham\",\"90\":19,\"86\":\"\",\"91\":\"Bedford\",\"88\":\"MK43 8QF\"}", "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": "437", "cci_createdat": 1740814308, "cci_updatedat": 1752492926, "cci_createdby": 1, "cci_updatedby": null } ], "deleted": [] }, "bm_appointment": { "created": [], "updated": [], "deleted": [] }, "bm_tasklist": { "created": [], "updated": [], "deleted": [] }, "bm_jobdetails": { "created": [ { "jd_id": 13274, "jd_customerid": 229, "jd_contactid": 437, "jd_additionalcontacts": "437", "jd_templateid": 1, "jd_jobmultiquoteid": 13279, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "11864", "jd_jobstatus": 4, "jd_contactaddid": 0, "jd_orderstatus": 8, "jd_accref": "DOBE1001", "jd_invoiceno": "", "jd_listprice": "33.33", "jd_netprice": "33.33", "jd_vat": "6.67", "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": "40.00", "jd_grossprofit": "33.33", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "40.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_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_seq": 0, "jd_status": 0, "jd_createdby": 8, "jd_updatedby": 8, "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\":8,\"44\":\"\",\"45\":\"\",\"46\":\"Dobeson\",\"47\":\"07983907413\",\"48\":\"g.dobeson@ntlworld.com\",\"49\":\"1 Cartwright Close\",\"50\":\"Bromham\",\"51\":\"Bedford\",\"52\":\"\",\"53\":\"MK43 8QF\",\"54\":19,\"285\":1,\"286\":\"01234825798\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":\"10\",\"558\":\"0\",\"612\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "20.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "13274", "jd_createddate": 1752451200, "jd_orderdate": 1752451200, "jd_duedate": 1752451200, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1752492926, "jd_updatedat": 1752492926 } ], "updated": [ { "jd_id": 13271, "jd_customerid": 5678, "jd_contactid": 7059, "jd_additionalcontacts": "7059", "jd_templateid": 1, "jd_jobmultiquoteid": 13276, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "11861", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 3, "jd_accref": "PAYN0001", "jd_invoiceno": "", "jd_listprice": "323.85", "jd_netprice": "323.85", "jd_vat": "64.77", "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": "388.62", "jd_grossprofit": "98.77", "jd_costprice": "225.08", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "388.62", "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": 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": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 10, "jd_updatedby": 10, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "20.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"11861\",\"35\":\"PAYN0001\",\"36\":1,\"37\":1,\"38\":\"\",\"39\":1,\"40\":3,\"41\":10,\"44\":\"\",\"45\":\"Maria\",\"46\":\"Payne\",\"47\":\"\",\"48\":\"maria.payne@accordmarketing.com\",\"49\":\"42 Burmo Way\",\"50\":\"Potton\",\"51\":\"Sandy\",\"52\":\"\",\"53\":\"SG19 2FE\",\"54\":19,\"285\":2,\"286\":\"07834005408\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":\"10\",\"558\":\"0\",\"612\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "20.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "13271", "jd_createddate": 1752451200, "jd_orderdate": null, "jd_duedate": 1752451200, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1752485744, "jd_updatedat": 1752493136 }, { "jd_id": 13274, "jd_customerid": 229, "jd_contactid": 437, "jd_additionalcontacts": "437", "jd_templateid": 1, "jd_jobmultiquoteid": 13279, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "11864", "jd_jobstatus": 4, "jd_contactaddid": 0, "jd_orderstatus": 8, "jd_accref": "DOBE1001", "jd_invoiceno": "", "jd_listprice": "33.33", "jd_netprice": "33.33", "jd_vat": "6.67", "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": "40.00", "jd_grossprofit": "33.33", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "40.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_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_seq": 0, "jd_status": 0, "jd_createdby": 8, "jd_updatedby": 8, "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\":8,\"44\":\"\",\"45\":\"\",\"46\":\"Dobeson\",\"47\":\"07983907413\",\"48\":\"g.dobeson@ntlworld.com\",\"49\":\"1 Cartwright Close\",\"50\":\"Bromham\",\"51\":\"Bedford\",\"52\":\"\",\"53\":\"MK43 8QF\",\"54\":19,\"285\":1,\"286\":\"01234825798\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":\"10\",\"558\":\"0\",\"612\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "20.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "13274", "jd_createddate": 1752451200, "jd_orderdate": 1752451200, "jd_duedate": 1752451200, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1752492926, "jd_updatedat": 1752492926 } ], "deleted": [] }, "bm_orderitem": { "created": [ { "oi_id": 84386, "oi_jobid": 13274, "oi_jobtempid": "0", "oi_jobmultiquoteid": 13279, "oi_productid": 185, "oi_recipeid": 185, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 73, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":17899,\"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\":17899,\"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\":17898,\"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\":17898,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":17900,\"labelname\":\"Issue Reported\",\"value\":\"Curtain track stopped working.\",\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Issue Reported\",\"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\":1,\"fieldname\":\"Issue Reported\",\"fieldid\":17900,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":17901,\"labelname\":\"Suggested Solution\",\"value\":\"Repair track.\",\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Suggested Solution\",\"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\":1,\"fieldname\":\"Suggested Solution\",\"fieldid\":17901,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":17902,\"labelname\":\"Warranty\",\"value\":\"Outside Warranty\",\"valueid\":\"50805\",\"type\":3,\"optionid\":\"35682\",\"optionvalue\":[{\"optionid\":35682,\"optionqty\":\"1\",\"optioncode\":\"4142\",\"optionname\":\"Outside Warranty\",\"unitcost\":null,\"unittype\":null,\"fieldoptionlinkid\":50805,\"forchildfieldoptionlinkid\":\"3_50805\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"issubfabric\":0,\"labelnamecode\":\"Warranty\",\"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\":1,\"fieldname\":\"Warranty\",\"fieldid\":17902,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"35682\",\"optionsvalue\":[{\"optionid\":35682,\"optionqty\":\"1\",\"optioncode\":\"4142\",\"optionname\":\"Outside Warranty\",\"unitcost\":null,\"unittype\":null,\"fieldoptionlinkid\":50805,\"forchildfieldoptionlinkid\":\"3_50805\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"editruleoverride\":1},{\"id\":17903,\"labelname\":\"Parts Required\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Parts Required\",\"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\":\"Parts Required\",\"fieldid\":17903,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":17904,\"labelname\":\"Special Instructions\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Special Instructions\",\"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 Instructions\",\"fieldid\":17904,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":17905,\"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\":17905,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Issue Reported: Curtain track stopped working., Suggested Solution: Repair track., Warranty: Outside Warranty", "oi_reportdescription": "##Quantity: 1##,##Issue Reported: Curtain track stopped working.##,##Suggested Solution: Repair track.##,##Warranty: Outside Warranty##", "oi_reporttitles": "##Quantity:<\/br>##Issue Reported:<\/br>##Suggested Solution:<\/br>##Warranty:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":null,\"value\":\"-\",\"formula\":null,\"price\":null,\"sellingprice\":\"0.00\",\"recipeid\":null,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":null,\"fieldtype_id\":0,\"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}", "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": "40.000", "oi_overridetype": 2, "oi_overridevalue": "40", "oi_overridenetprice": "33.330", "oi_overridevatprice": "6.670", "oi_overridegrossprice": "40.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": "0.000", "oi_endcustomeroverridevatprice": "0.000", "oi_endcustomeroverridegrossprice": "0.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[17899, 17898, 17900, 17901, 17902, 17903, 17904, 17905]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "84386", "oi_productiondate": 1752496465, "oi_createdat": 1752496465, "oi_updatedat": 1752492926, "oi_createdby": 8, "oi_updatedby": 8 } ], "updated": [ { "oi_id": 84377, "oi_jobid": 13271, "oi_jobtempid": "0", "oi_jobmultiquoteid": 13276, "oi_productid": 58, "oi_recipeid": 58, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":2694,\"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\":2693,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"1\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":2697,\"labelname\":\"Room\",\"value\":\"Kitchen\",\"valueid\":\"\",\"type\":18,\"optionid\":\"Kitchen\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":2695,\"labelname\":\"Supplier\",\"value\":15,\"valueid\":\"\",\"type\":17,\"optionid\":\"15\",\"optionvalue\":[{\"id\":15,\"optionid\":15,\"optionname\":\"Excel\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":2698,\"labelname\":\"Size\",\"value\":\"Blind\",\"valueid\":\"15681\",\"type\":3,\"optionid\":\"13760\",\"optionvalue\":[{\"optionid\":13760,\"optionname\":\"Blind\",\"description\":\"\",\"optioncode\":851,\"pricegroups\":\"Band A_AR_RB,Band B_AR_RB,Band C_AR_RB,Band D_AR_RB,Band E_AR_RB,Elements_AR_RB,LL Band A_AR_RB,LL Band B_AR_RB,LL Band C_AR_RB,LL Band D_AR_RB,LL Band E_AR_RB,LL Elements_AR_RB,MC Band A_AR_RB,MC Band B_AR_RB,MC Band C_AR_RB,MC Band D_AR_RB,MC Band E_AR_RB,MC Elements_AR_RB,Simplicity_EX_RB,Range 1_EX_RB,Range 2_EX_RB,Range 3_EX_RB,Range 4_EX_RB,Range 5_EX_RB,Range 6_EX_RB,Range 6+5per_EX_RB,Range 6+10per_EX_RB,Range 6+15per_EX_RB,Range 6+25per_EX_RB,Range 6+20per_EX_RB,Range 6+35per_EX_RB,Range 6+45per_EX_RB,Range 6+50per_EX_RB,Digitally Printed_EX_RB,Blackout System System 40_EX_RB,R20C Crank A_YE_RB,R20C Crank B_YE_RB,R20C Crank C_YE_RB,R20 A_YE_RB,R20 B_YE_RB,R20 C_YE_RB\",\"domesticsellingprice\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":15681,\"forchildfieldoptionlinkid\":\"3_15681\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":2699,\"labelname\":\"Width\",\"value\":\"1138\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":2700,\"labelname\":\"Drop\",\"value\":\"1000\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":2701,\"labelname\":\"Fabric\",\"value\":\"Unishade 2000 BO FR \",\"valueid\":\"2647\",\"type\":5,\"optionid\":\"2647\",\"optionvalue\":[{\"optionid\":2647,\"optionname\":\"Unishade 2000 BO FR \",\"optionquantity\":1,\"fieldoptionlinkid\":2647,\"forchildfieldoptionlinkid\":\"5_2_2647_1\",\"subdatacount\":1,\"optionimage\":null,\"supplier\":\"Decora\",\"pricegroup\":\"Range 4_EX_RB\",\"pricegroupid\":84}],\"fabricorcolor\":1,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":3391,\"labelname\":\"Color\",\"value\":\"White\",\"valueid\":\"12805\",\"type\":5,\"optionid\":\"12805\",\"optionvalue\":[{\"optionid\":12805,\"optionname\":\"White\",\"optionquantity\":1,\"fieldoptionlinkid\":12805,\"forchildfieldoptionlinkid\":\"5_12805\",\"minimumdiscount\":\"\",\"maximumdiscount\":\"\",\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":2696,\"labelname\":\"Pricing Band\",\"value\":84,\"valueid\":\"84\",\"type\":13,\"optionid\":\"84\",\"optionvalue\":[{\"id\":84,\"fieldid\":2696,\"fieldoptionlinkid\":84,\"optionid\":84,\"mainsupplier\":15,\"blindtypecode\":\"\",\"optionname\":\"Range 4_EX_RB\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3414,\"labelname\":\"Brackets\",\"value\":\"Top Fix\",\"valueid\":\"16396\",\"type\":3,\"optionid\":\"13763\",\"optionvalue\":[{\"optionid\":13763,\"optionname\":\"Top Fix\",\"description\":\"\",\"optioncode\":4090,\"pricegroups\":\"Band A_AR_RB,Band B_AR_RB,Band C_AR_RB,Band D_AR_RB,Band E_AR_RB,Elements_AR_RB,LL Band A_AR_RB,LL Band B_AR_RB,LL Band C_AR_RB,LL Band D_AR_RB,LL Band E_AR_RB,LL Elements_AR_RB,MC Band A_AR_RB,MC Band B_AR_RB,MC Band C_AR_RB,MC Band D_AR_RB,MC Band E_AR_RB,MC Elements_AR_RB,Simplicity_EX_RB,Range 1_EX_RB,Range 2_EX_RB,Range 3_EX_RB,Range 4_EX_RB,Range 5_EX_RB,Range 6_EX_RB,Range 6+5per_EX_RB,Range 6+10per_EX_RB,Range 6+15per_EX_RB,Range 6+25per_EX_RB,Range 6+20per_EX_RB,Range 6+35per_EX_RB,Range 6+45per_EX_RB,Range 6+50per_EX_RB,Digitally Printed_EX_RB,Blackout System System 40_EX_RB,R20C Crank A_YE_RB,R20C Crank B_YE_RB,R20C Crank C_YE_RB,R20 A_YE_RB,R20 B_YE_RB,R20 C_YE_RB\",\"domesticsellingprice\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":16396,\"forchildfieldoptionlinkid\":\"3_16396\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3415,\"labelname\":\"System\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3426,\"labelname\":\"Control Type\",\"value\":\"Motor\",\"valueid\":\"16441\",\"type\":3,\"optionid\":\"13798\",\"optionvalue\":[{\"optionid\":13798,\"optionname\":\"Motor\",\"description\":\"\",\"optioncode\":18310,\"pricegroups\":\"Band A_AR_RB,Band B_AR_RB,Band C_AR_RB,Band D_AR_RB,Band E_AR_RB,Elements_AR_RB,LL Band A_AR_RB,LL Band B_AR_RB,LL Band C_AR_RB,LL Band D_AR_RB,LL Band E_AR_RB,LL Elements_AR_RB,MC Band A_AR_RB,MC Band B_AR_RB,MC Band C_AR_RB,MC Band D_AR_RB,MC Band E_AR_RB,MC Elements_AR_RB,Simplicity_EX_RB,Range 1_EX_RB,Range 2_EX_RB,Range 3_EX_RB,Range 4_EX_RB,Range 5_EX_RB,Range 6_EX_RB,Range 6+5per_EX_RB,Range 6+10per_EX_RB,Range 6+15per_EX_RB,Range 6+25per_EX_RB,Range 6+20per_EX_RB,Range 6+35per_EX_RB,Range 6+45per_EX_RB,Range 6+50per_EX_RB,Digitally Printed_EX_RB,Blackout System System 40_EX_RB,R20C Crank A_YE_RB,R20C Crank B_YE_RB,R20C Crank C_YE_RB,R20 A_YE_RB,R20 B_YE_RB,R20 C_YE_RB\",\"domesticsellingprice\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":16441,\"forchildfieldoptionlinkid\":\"3_16441\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":2,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":16441}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":3427,\"labelname\":\"Control Side\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3428,\"labelname\":\"Roll Direction\",\"value\":\"Reverse off the front \",\"valueid\":\"16447\",\"type\":3,\"optionid\":\"13802\",\"optionvalue\":[{\"optionid\":13802,\"optionname\":\"Reverse off the front \",\"description\":\"\",\"optioncode\":51754,\"pricegroups\":\"\",\"domesticselling price\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"fieldoptionlinkid\":16447,\"forchildfieldoptionlinkid\":\"3_16447\",\"hasstock\":0,\"subdatacount\":0,\"hasprice\":1,\"optionimage\":\"\",\"unitcost\":0,\"reportprice\":\"0.00\",\"fieldid\":16447}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":3439,\"labelname\":\"Motorisation\",\"value\":\"Sonesse 30 Li Ion Ultra RTS Rechargeable\",\"valueid\":\"16607\",\"type\":3,\"optionid\":\"13937\",\"optionvalue\":[{\"optionid\":13937,\"optionname\":\"Sonesse 30 Li Ion Ultra RTS Rechargeable\",\"description\":\"\",\"optioncode\":21020,\"pricegroups\":\"Simplicity_EX_RB,Range 1_EX_RB,Range 2_EX_RB,Range 3_EX_RB,Range 4_EX_RB,Range 5_EX_RB,Range 6_EX_RB,Range 6+5per_EX_RB,Range 6+10per_EX_RB,Range 6+15per_EX_RB,Range 6+25per_EX_RB,Range 6+20per_EX_RB,Range 6+35per_EX_RB,Range 6+45per_EX_RB,Range 6+50per_EX_RB,Digitally Printed_EX_RB,Blackout System System 40_EX_RB\",\"domesticsellingprice\":156,\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":104,\"fieldoptionlinkid\":16607,\"forchildfieldoptionlinkid\":\"3_16607\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":3,\"optionimage\":\"\",\"reportprice\":\"156.00\",\"fieldid\":16607}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":3455,\"labelname\":\"Power Options\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3456,\"labelname\":\"Control\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3457,\"labelname\":\"Product Information\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3472,\"labelname\":\"Cassette Fascia\",\"value\":\"Louvolite Full Fascia Open Cassette 70mm \",\"valueid\":\"16740\",\"type\":3,\"optionid\":\"14049\",\"optionvalue\":[{\"optionid\":14049,\"optionname\":\"Louvolite Full Fascia Open Cassette 70mm \",\"description\":\"Max width 300cm\",\"optioncode\":14501,\"pricegroups\":\"Simplicity_EX_RB,Range 1_EX_RB,Range 2_EX_RB,Range 3_EX_RB,Range 4_EX_RB,Range 5_EX_RB,Range 6_EX_RB,Range 6+5per_EX_RB,Range 6+10per_EX_RB,Range 6+15per_EX_RB,Range 6+25per_EX_RB,Range 6+20per_EX_RB,Range 6+35per_EX_RB,Range 6+45per_EX_RB,Range 6+50per_EX_RB\",\"domesticsellingprice\":\"\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":26,\"fieldoptionlinkid\":16740,\"forchildfieldoptionlinkid\":\"3_16740\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":3,\"optionimage\":\"\",\"reportprice\":\"52.00\",\"fieldid\":16740}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":3477,\"labelname\":\"Fabric Covered\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3478,\"labelname\":\"Colour\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":23414,\"labelname\":\"End Caps\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3494,\"labelname\":\"Bottom Bar\",\"value\":\"Louvolite Smart Rail\",\"valueid\":\"63055\",\"type\":3,\"optionid\":\"43917\",\"optionvalue\":[{\"optionid\":43917,\"optionname\":\"Louvolite Smart Rail\",\"description\":\"\",\"optioncode\":\"\",\"pricegroups\":\"Simplicity_EX_RB,Range 1_EX_RB,Range 2_EX_RB,Range 3_EX_RB,Range 4_EX_RB,Range 5_EX_RB,Range 6_EX_RB,Range 6+5per_EX_RB,Range 6+10per_EX_RB,Range 6+15per_EX_RB,Range 6+25per_EX_RB,Range 6+20per_EX_RB,Range 6+35per_EX_RB,Range 6+45per_EX_RB,Range 6+50per_EX_RB,Digitally Printed_EX_RB\",\"domesticsellingprice\":\"\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":10,\"fieldoptionlinkid\":63055,\"forchildfieldoptionlinkid\":\"3_63055\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":1,\"optionimage\":\"\",\"reportprice\":\"15.00\",\"fieldid\":63055}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":23249,\"labelname\":\"Colour\",\"value\":\"White Smart Rail\",\"valueid\":\"63381\",\"type\":3,\"optionid\":\"43941\",\"optionvalue\":[{\"optionid\":43941,\"optionname\":\"White Smart Rail\",\"description\":\"\",\"optioncode\":\"\",\"pricegroups\":\"Simplicity_EX_RB,Range 1_EX_RB,Range 2_EX_RB,Range 3_EX_RB,Range 4_EX_RB,Range 5_EX_RB,Range 6_EX_RB,Range 6+5per_EX_RB,Range 6+10per_EX_RB,Range 6+15per_EX_RB,Range 6+25per_EX_RB,Range 6+20per_EX_RB,Range 6+35per_EX_RB,Range 6+45per_EX_RB,Range 6+50per_EX_RB\",\"domesticselling price\":\"\",\"optionqty\":\"1\",\"unittype\":null,\"fieldoptionlinkid\":63381,\"forchildfieldoptionlinkid\":\"3_63381\",\"hasstock\":0,\"subdatacount\":0,\"hasprice\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":3503,\"labelname\":\"Scallops\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3509,\"labelname\":\"Braid\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3515,\"labelname\":\"Pulls\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3519,\"labelname\":\"Extras\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3520,\"labelname\":\"Fitting\",\"value\":\"Fitting\",\"valueid\":\"17063\",\"type\":3,\"optionid\":\"14334\",\"optionvalue\":[{\"optionid\":14334,\"optionname\":\"Fitting\",\"description\":\"\",\"optioncode\":18831,\"pricegroups\":\"Band A_AR_RB,Band B_AR_RB,Band C_AR_RB,Band D_AR_RB,Band E_AR_RB,Elements_AR_RB,LL Band A_AR_RB,LL Band B_AR_RB,LL Band C_AR_RB,LL Band D_AR_RB,LL Band E_AR_RB,LL Elements_AR_RB,MC Band A_AR_RB,MC Band B_AR_RB,MC Band C_AR_RB,MC Band D_AR_RB,MC Band E_AR_RB,MC Elements_AR_RB,Simplicity_EX_RB,Range 1_EX_RB,Range 2_EX_RB,Range 3_EX_RB,Range 4_EX_RB,Range 5_EX_RB,Range 6_EX_RB,Range 6+5per_EX_RB,Range 6+10per_EX_RB,Range 6+15per_EX_RB,Range 6+25per_EX_RB,Range 6+20per_EX_RB,Range 6+35per_EX_RB,Range 6+45per_EX_RB,Range 6+50per_EX_RB,Digitally Printed_EX_RB,Blackout System System 40_EX_RB,R20C Crank A_YE_RB,R20C Crank B_YE_RB,R20C Crank C_YE_RB,R20 A_YE_RB,R20 B_YE_RB,R20 C_YE_RB\",\"domesticsellingprice\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":33.33,\"fieldoptionlinkid\":17063,\"forchildfieldoptionlinkid\":\"3_17063\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"33.33\",\"fieldid\":17063}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3521,\"labelname\":\"Special Instructions\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3522,\"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, Room: Kitchen, Supplier: Excel, Size: Blind, Width: 1138, Drop: 1000, Fabric: Unishade 2000 BO FR , Color: White, Brackets: Top Fix, Control Type: Motor, Roll Direction: Reverse off the front , Motorisation: Sonesse 30 Li Ion Ultra RTS Rechargeable, Cassette Fascia: Louvolite Full Fascia Open Cassette 70mm , Bottom Bar: Louvolite Smart Rail, Colour: White Smart Rail, Fitting: Fitting", "oi_reportdescription": "##Quantity: 1##,##Room: Kitchen##,##Supplier: Excel##,##Size: Blind##,##Width: 1138 mm##,##Drop: 1000 mm##,##Fabric: Unishade 2000 BO FR ##,##Color: White##,##Brackets: Top Fix##,##Control Type: Motor##,##Roll Direction: Reverse off the front ##,##Motorisation: Sonesse 30 Li Ion Ultra RTS Rechargeable##,##Cassette Fascia: Louvolite Full Fascia Open Cassette 70mm ##,##Bottom Bar: Louvolite Smart Rail##,##Colour: White Smart Rail##,##Fitting: Fitting##", "oi_reporttitles": "##Quantity:##Room:##Supplier:##Size:##Width:##Drop:##Fabric:##Color:##Brackets:##Control Type:##Roll Direction:##Motorisation:##Cassette Fascia:##Bottom Bar:##Colour:##Fitting:", "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": "225.080", "oi_netprice": "359.830", "oi_pricesfromoperations": null, "oi_vatprice": "71.970", "oi_vatvalue": "20.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "431.800", "oi_overrideprice": "10.000", "oi_overridetype": 4, "oi_overridevalue": "10.000", "oi_overridenetprice": "323.850", "oi_overridevatprice": "64.770", "oi_overridegrossprice": "388.620", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 4, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "359.830", "oi_endcustomeroverridevatprice": "71.970", "oi_endcustomeroverridegrossprice": "431.800", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[2694, 2693, 2697, 2695, 2698, 2699, 2700, 2701, 3391, 2696, 3414, 3415, 3426, 3427, 3428, 3439, 3455, 3456, 3457, 3472, 3477, 3478, 23414, 3494, 23249, 3503, 3509, 3515, 3519, 3520, 3521, 3522]", "oi_deviceplatform": 2, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "84377", "oi_productiondate": 1752489529, "oi_createdat": 1752489529, "oi_updatedat": 1752493136, "oi_createdby": 10, "oi_updatedby": 10 }, { "oi_id": 84386, "oi_jobid": 13274, "oi_jobtempid": "0", "oi_jobmultiquoteid": 13279, "oi_productid": 185, "oi_recipeid": 185, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 73, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":17899,\"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\":17899,\"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\":17898,\"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\":17898,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":17900,\"labelname\":\"Issue Reported\",\"value\":\"Curtain track stopped working.\",\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Issue Reported\",\"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\":1,\"fieldname\":\"Issue Reported\",\"fieldid\":17900,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":17901,\"labelname\":\"Suggested Solution\",\"value\":\"Repair track.\",\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Suggested Solution\",\"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\":1,\"fieldname\":\"Suggested Solution\",\"fieldid\":17901,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":17902,\"labelname\":\"Warranty\",\"value\":\"Outside Warranty\",\"valueid\":\"50805\",\"type\":3,\"optionid\":\"35682\",\"optionvalue\":[{\"optionid\":35682,\"optionqty\":\"1\",\"optioncode\":\"4142\",\"optionname\":\"Outside Warranty\",\"unitcost\":null,\"unittype\":null,\"fieldoptionlinkid\":50805,\"forchildfieldoptionlinkid\":\"3_50805\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"issubfabric\":0,\"labelnamecode\":\"Warranty\",\"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\":1,\"fieldname\":\"Warranty\",\"fieldid\":17902,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"35682\",\"optionsvalue\":[{\"optionid\":35682,\"optionqty\":\"1\",\"optioncode\":\"4142\",\"optionname\":\"Outside Warranty\",\"unitcost\":null,\"unittype\":null,\"fieldoptionlinkid\":50805,\"forchildfieldoptionlinkid\":\"3_50805\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"editruleoverride\":1},{\"id\":17903,\"labelname\":\"Parts Required\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Parts Required\",\"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\":\"Parts Required\",\"fieldid\":17903,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":17904,\"labelname\":\"Special Instructions\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Special Instructions\",\"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 Instructions\",\"fieldid\":17904,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":17905,\"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\":17905,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Issue Reported: Curtain track stopped working., Suggested Solution: Repair track., Warranty: Outside Warranty", "oi_reportdescription": "##Quantity: 1##,##Issue Reported: Curtain track stopped working.##,##Suggested Solution: Repair track.##,##Warranty: Outside Warranty##", "oi_reporttitles": "##Quantity:<\/br>##Issue Reported:<\/br>##Suggested Solution:<\/br>##Warranty:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":null,\"value\":\"-\",\"formula\":null,\"price\":null,\"sellingprice\":\"0.00\",\"recipeid\":null,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":null,\"fieldtype_id\":0,\"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}", "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": "40.000", "oi_overridetype": 2, "oi_overridevalue": "40", "oi_overridenetprice": "33.330", "oi_overridevatprice": "6.670", "oi_overridegrossprice": "40.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": "0.000", "oi_endcustomeroverridevatprice": "0.000", "oi_endcustomeroverridegrossprice": "0.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[17899, 17898, 17900, 17901, 17902, 17903, 17904, 17905]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "84386", "oi_productiondate": 1752496465, "oi_createdat": 1752496465, "oi_updatedat": 1752492926, "oi_createdby": 8, "oi_updatedby": 8 } ], "deleted": [] }, "bm_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_notelist": { "created": [ { "nl_id": 489655, "nl_ordertempid": 0, "nl_orderid": 13093, "nl_notescategory": 1, "nl_type": 7, "nl_platform": 3, "nl_desc": "SG track ordered via Hallis", "nl_manualNotes": null, "nl_createdby": "2", "nl_attachmnettext": "", "nl_attachmnetURL": "", "nl_isonlinenote": 1, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "489655", "nl_endddate": 1752451200, "nl_starttime": 1752496634, "created_at": 1752493064, "updated_at": 1752493064, "created_by": 2, "updated_by": null } ], "updated": [], "deleted": [] }, "bm_deliveryaddresssetting": { "created": [ { "das_id": 13266, "das_jobid": 13274, "das_appointmentaddress": 437, "das_invoiceaddress": 437, "das_invoicedeliveryaddress": 0, "das_purchaseaddress": 0, "das_worksheetaddress": 0, "id": "13266", "das_createdat": 1752492926, "das_updatedat": 1752492926, "das_createdby": 8, "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": 234172, "orderid": 13274, "jobmultiquoteid": 13279, "isresportshow": 1, "termsCategory": 2, "termsName": "Standard", "termsDescription": "", "status": 0, "seq": 1, "id": "234172", "created_at": 1752492926, "updated_at": 1752492926, "terms_created_at": 1722586185, "created_by": null, "updated_by": null }, { "termsid": 234173, "orderid": 13274, "jobmultiquoteid": 13279, "isresportshow": 1, "termsCategory": 3, "termsName": "Standard", "termsDescription": "", "status": 0, "seq": 1, "id": "234173", "created_at": 1752492926, "updated_at": 1752492926, "terms_created_at": 1722585567, "created_by": null, "updated_by": null }, { "termsid": 234174, "orderid": 13274, "jobmultiquoteid": 13279, "isresportshow": 1, "termsCategory": 4, "termsName": "Standard", "termsDescription": "", "status": 0, "seq": 1, "id": "234174", "created_at": 1752492926, "updated_at": 1752492926, "terms_created_at": 1722585567, "created_by": null, "updated_by": null } ], "updated": [], "deleted": [] }, "bm_jobmultiquote": { "created": [ { "jmq_id": 13279, "jmq_jobid": 13274, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "33.33", "jmq_netprice": "33.33", "jmq_vat": "6.67", "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": "40.00", "jmq_grossprofit": "33.33", "jmq_costprice": "0.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "40.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": 1, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 1, "jmq_endcustomeroverridevalue": null, "jmq_endcustomeroverridenetprice": "0.00", "jmq_endcustomeroverridevatprice": "0.00", "jmq_endcustomeroverridegrossprice": "0.00", "jmq_endcustomerdeliverycost": null, "jmq_endcustomerdeliverycostinclvat": 1, "jmq_endcustomerfittingcost": null, "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": "13279", "jmq_duedate": 1752451200, "jmq_sceduleddate": null, "jmq_createdat": "1752492926.000000", "jmq_updatedat": "1752492926.000000", "jmq_createdby": 8, "jmq_updatedby": null } ], "updated": [], "deleted": [] }, "bm_jobstatus_tracks": { "created": [ { "jst_id": 15364, "jst_jobid": 13274, "jst_job_current_status": 4, "id": "15364", "jst_createdat": "1752492926.190735" } ], "updated": [], "deleted": [] }, "bm_customindividuallogs": { "created": [ { "cl_id": 74140, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 13274, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 13274, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 8, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"Concorde Blinds, Curtains, Shutters\",\"Account Type\":\"Domestic\",\"Source\":\"Previous Customer\",\"Created By\":\"Marlena\",\"Last Name\":\"Dobeson\",\"Mobile\":\"07983907413\",\"Email\":\"g.dobeson@ntlworld.com\",\"Address1\":\"1 Cartwright Close\",\"Address2\":\"Bromham\",\"Town \\\/ City\":\"Bedford\",\"Zipcode \\\/ Postcode\":\"MK43 8QF\",\"Country\":\"UK\",\"Salutation\":\"Mr.\",\"Phone\":\"01234825798\",\"Account manager\":\"10\",\"Role\":\"0\",\"Additional Contacts\":\"437\",\"Order Date\":\"2025-07-14\",\"Job Status\":\"Order\",\"Order Status\":\"5) Order Ready\",\"Net Price\":\"33.33\",\"VAT Price\":\"6.67\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"Gross Price Amount\":\"40.00\",\"Gross Profit\":\"33.33\",\"Gross Profit Percentage\":\"100.00\",\"Amount Outstanding\":\"40.00\",\"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\":\"''\",\"Job Rework Enable\":\"On\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":13274,\"jd_customerid\":229,\"jd_contactid\":437,\"jd_additionalcontacts\":\"437\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"33\\\":\\\"25\\\",\\\"37\\\":1,\\\"39\\\":4,\\\"41\\\":8,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"\\\",\\\"46\\\":\\\"Dobeson\\\",\\\"47\\\":\\\"07983907413\\\",\\\"48\\\":\\\"g.dobeson@ntlworld.com\\\",\\\"49\\\":\\\"1 Cartwright Close\\\",\\\"50\\\":\\\"Bromham\\\",\\\"51\\\":\\\"Bedford\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"MK43 8QF\\\",\\\"54\\\":19,\\\"285\\\":1,\\\"286\\\":\\\"01234825798\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":\\\"10\\\",\\\"558\\\":\\\"0\\\",\\\"612\\\":\\\"\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-07-14\",\"jd_orderdate\":\"2025-07-14\",\"jd_duedate\":\"0000-00-00\",\"jd_duedatechangedmanually\":0,\"jd_sceduleddate\":\"0000-00-00\",\"jd_invoicedate\":\"0000-00-00\",\"jd_completeddate\":\"0000-00-00\",\"jd_jobref\":null,\"jd_jobstatus\":4,\"jd_contactaddid\":0,\"jd_orderstatus\":8,\"jd_accref\":\"DOBE1001\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"33.33\",\"jd_netprice\":\"33.33\",\"jd_vat\":\"6.67\",\"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\":\"40.00\",\"jd_grossprofit\":\"33.33\",\"jd_grossprofit_percentage\":\"100.00\",\"jd_costprice\":\"0.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"40.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_accountingsoftware_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\":8,\"jd_createdat\":\"2025-07-14T11:35:26.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-07-14T11:35:26.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\":1,\"jd_rework_count\":0,\"salesorderid\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "74140", "cl_createdat": "1752492926.000000", "cl_updatedat": null }, { "cl_id": 74149, "cl_logname": "default", "cl_type": null, "cl_modulename": "All Jobs", "cl_message": "Quote Custom report generated by Margaret All Jobs", "cl_event": "created", "cl_subjectid": 6923, "cl_subjecttype": "App\\Models\\Reports\\bm_reportactivitylog", "cl_parentid": 13271, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 10, "cl_changedfrom": "null", "cl_changedto": "{\"Category: \":\"Quotation\"}", "cl_customproperties": "{\"attributes\":{\"ral_id\":6923,\"ral_jobid\":13271,\"ral_reportid\":12,\"ral_categoryid\":1,\"ral_description\":\"Quote Custom report generated by Margaret\",\"ral_attachment\":\"\",\"ral_actionid\":1,\"ral_createdat\":\"2025-07-14T11:35:32.000000Z\",\"ral_updatedat\":\"2025-07-14T11:35:32.000000Z\",\"ral_createdby\":10,\"ral_updatedby\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "74149", "cl_createdat": "1752492932.000000", "cl_updatedat": null }, { "cl_id": 74150, "cl_logname": "default", "cl_type": null, "cl_modulename": "All Jobs", "cl_message": "Quote Custom report generated by Margaret All Jobs", "cl_event": "created", "cl_subjectid": 6924, "cl_subjecttype": "App\\Models\\Reports\\bm_reportactivitylog", "cl_parentid": 13271, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 10, "cl_changedfrom": "null", "cl_changedto": "{\"Category: \":\"Quotation\"}", "cl_customproperties": "{\"attributes\":{\"ral_id\":6924,\"ral_jobid\":13271,\"ral_reportid\":12,\"ral_categoryid\":1,\"ral_description\":\"Quote Custom report generated by Margaret\",\"ral_attachment\":\"\",\"ral_actionid\":1,\"ral_createdat\":\"2025-07-14T11:37:29.000000Z\",\"ral_updatedat\":\"2025-07-14T11:37:29.000000Z\",\"ral_createdby\":10,\"ral_updatedby\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "74150", "cl_createdat": "1752493049.000000", "cl_updatedat": null }, { "cl_id": 74151, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 489655, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 13093, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 2, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"General\",\"Platform\":\"Ecommerce\",\"Description\":\"SG track ordered via Hallis\",\"Created By\":\"Kieren\",\"Date\":\"2025-07-14\",\"Time\":\"12:37:14\",\"Is online note\":\"Yes\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":489655,\"nl_ordertempid\":0,\"nl_orderid\":13093,\"nl_notescategory\":1,\"nl_type\":7,\"nl_platform\":3,\"nl_desc\":\"SG track ordered via Hallis\",\"nl_manualNotes\":null,\"nl_createdby\":\"2\",\"nl_endddate\":\"2025-07-14\",\"nl_starttime\":\"12:37:14\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":1,\"nl_seq\":0,\"nl_status\":0,\"created_by\":2,\"created_at\":\"2025-07-14T11:37:44.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-07-14T11:37:44.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "74151", "cl_createdat": "1752493064.000000", "cl_updatedat": null }, { "cl_id": 74152, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "Notes has been updated the fields Time,Is online note", "cl_event": "modified", "cl_subjectid": 489655, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 13093, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 2, "cl_changedfrom": "{\"Time\":\"12:37:14:00\"}", "cl_changedto": "{\"Time\":\"12:37:14\",\"Is online note\":\"Yes\"}", "cl_customproperties": "{\"attributes\":{\"nl_ordertempid\":0,\"nl_starttime\":\"12:37:14\",\"nl_attachmnettext\":\"\",\"nl_attachmnetURL\":\"\",\"nl_isonlinenote\":1,\"nl_seq\":0,\"nl_status\":0},\"old\":{\"nl_ordertempid\":\"\",\"nl_starttime\":\"12:37:14:00\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":null,\"nl_seq\":null,\"nl_status\":\"\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "74152", "cl_createdat": "1752493064.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": [] }, "bm_price_setup": { "created": [], "updated": [], "deleted": [] }, "bm_calendarsetup": { "created": [], "updated": [], "deleted": [] }, "bm_appointmenttype": { "created": [], "updated": [], "deleted": [] }, "bm_userWorkDay": { "created": [], "updated": [], "deleted": [] }, "bm_users": { "created": [], "updated": [], "deleted": [] }, "custom_fields": { "created": [], "updated": [], "deleted": [] }, "customfieldvalues": { "created": [], "updated": [], "deleted": [] } }, "synctodelete": [], "timestamp": 1752493136 }