{ "status": "success", "upcomingorder_list": { "bm_customertemplatedata": { "created": [], "updated": [ { "ctd_id": 1482, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\": 1, \"64\": 23, \"742\": 25, \"62\": \"GEOR0001\", \"63\": \"\"}", "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": "1482", "ctd_createdat": 1743494121, "ctd_updatedat": 1743494256, "ctd_createdby": 0, "ctd_updatedby": null }, { "ctd_id": 1483, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\": 1, \"64\": 23, \"742\": 25, \"62\": \"OFFL0008\"}", "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": "1483", "ctd_createdat": 1743494345, "ctd_updatedat": 1743494415, "ctd_createdby": 0, "ctd_updatedby": null } ], "deleted": [] }, "bm_customercontactinfo": { "created": [], "updated": [ { "cci_id": 2730, "cci_customerid": 1482, "cci_templateid": 3, "roleid": 0, "cci_customizedarray": "{\"75\":1,\"77\":\"George\",\"81\":1,\"83\":\"1\",\"82\":\"\",\"79\":\"\",\"78\":\"\",\"76\":\"\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"90\":35,\"87\":\"\",\"89\":\"\",\"86\":\"\",\"91\":\"\",\"88\":\"\"}", "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": 1, "cci_mobcustomertempid": 31743494121, "id": "2730", "cci_createdat": 1743494121, "cci_updatedat": 1743494256, "cci_createdby": 0, "cci_updatedby": null }, { "cci_id": 2731, "cci_customerid": 1483, "cci_templateid": 3, "roleid": 0, "cci_customizedarray": "{\"75\":1,\"77\":\"Offline@6\",\"81\":1,\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"90\":35}", "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": 31743494345, "id": "2731", "cci_createdat": 1743494345, "cci_updatedat": 1743494415, "cci_createdby": 0, "cci_updatedby": null } ], "deleted": [] }, "bm_appointment": { "created": [], "updated": [], "deleted": [] }, "bm_tasklist": { "created": [], "updated": [], "deleted": [] }, "bm_jobdetails": { "created": [ { "jd_id": 2769, "jd_customerid": 1482, "jd_contactid": 2730, "jd_additionalcontacts": "2730", "jd_templateid": 1, "jd_jobmultiquoteid": 2791, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "BD2659", "jd_jobstatus": 6, "jd_contactaddid": 0, "jd_orderstatus": 2, "jd_accref": "GEOR0001", "jd_invoiceno": "IN406", "jd_listprice": "1138.78", "jd_netprice": "1138.78", "jd_vat": "103.91", "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": "1242.69", "jd_grossprofit": "0.00", "jd_costprice": "1138.78", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "1242.69", "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": 40, "jd_updatedby": 40, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "9.125", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"BD2659\",\"35\":\"GEOR0001\",\"36\":6,\"37\":1,\"38\":\"\",\"39\":23,\"40\":2,\"41\":40,\"44\":\"\",\"45\":\"George\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":35,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"470\":\"\",\"477\":\"\",\"584\":\"\",\"605\":\"\",\"606\":\"\",\"608\":40,\"633\":1,\"705\":\"\",\"718\":1,\"757\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "9.125", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "2769", "jd_createddate": 1743465600, "jd_orderdate": 1743465600, "jd_duedate": 1743465600, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1743494121, "jd_updatedat": 1743494385 }, { "jd_id": 2770, "jd_customerid": 1483, "jd_contactid": 2731, "jd_additionalcontacts": "2731", "jd_templateid": 1, "jd_jobmultiquoteid": 2792, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "BD2660", "jd_jobstatus": 3, "jd_contactaddid": 0, "jd_orderstatus": 2, "jd_accref": "OFFL0008", "jd_invoiceno": "", "jd_listprice": "190.00", "jd_netprice": "190.00", "jd_vat": "17.34", "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": "207.34", "jd_grossprofit": "95.00", "jd_costprice": "95.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "207.34", "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": 9, "jd_updatedby": 9, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "9.125", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"BD2660\",\"35\":\"OFFL0008\",\"36\":3,\"37\":1,\"38\":\"\",\"39\":23,\"40\":2,\"41\":9,\"44\":\"\",\"45\":\"Offline@6\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":35,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"470\":\"\",\"477\":\"\",\"584\":\"\",\"605\":\"\",\"606\":\"\",\"608\":9,\"633\":1,\"705\":\"\",\"718\":1,\"757\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "9.125", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "2770", "jd_createddate": 1743465600, "jd_orderdate": null, "jd_duedate": 1743465600, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1743494345, "jd_updatedat": 1743494416 } ], "updated": [ { "jd_id": 2769, "jd_customerid": 1482, "jd_contactid": 2730, "jd_additionalcontacts": "2730", "jd_templateid": 1, "jd_jobmultiquoteid": 2791, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "BD2659", "jd_jobstatus": 6, "jd_contactaddid": 0, "jd_orderstatus": 2, "jd_accref": "GEOR0001", "jd_invoiceno": "IN406", "jd_listprice": "1138.78", "jd_netprice": "1138.78", "jd_vat": "103.91", "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": "1242.69", "jd_grossprofit": "0.00", "jd_costprice": "1138.78", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "1242.69", "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": 40, "jd_updatedby": 40, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "9.125", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"BD2659\",\"35\":\"GEOR0001\",\"36\":6,\"37\":1,\"38\":\"\",\"39\":23,\"40\":2,\"41\":40,\"44\":\"\",\"45\":\"George\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":35,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"470\":\"\",\"477\":\"\",\"584\":\"\",\"605\":\"\",\"606\":\"\",\"608\":40,\"633\":1,\"705\":\"\",\"718\":1,\"757\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "9.125", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "2769", "jd_createddate": 1743465600, "jd_orderdate": 1743465600, "jd_duedate": 1743465600, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1743494121, "jd_updatedat": 1743494385 }, { "jd_id": 2770, "jd_customerid": 1483, "jd_contactid": 2731, "jd_additionalcontacts": "2731", "jd_templateid": 1, "jd_jobmultiquoteid": 2792, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "BD2660", "jd_jobstatus": 3, "jd_contactaddid": 0, "jd_orderstatus": 2, "jd_accref": "OFFL0008", "jd_invoiceno": "", "jd_listprice": "190.00", "jd_netprice": "190.00", "jd_vat": "17.34", "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": "207.34", "jd_grossprofit": "95.00", "jd_costprice": "95.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "207.34", "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": 9, "jd_updatedby": 9, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "9.125", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"BD2660\",\"35\":\"OFFL0008\",\"36\":3,\"37\":1,\"38\":\"\",\"39\":23,\"40\":2,\"41\":9,\"44\":\"\",\"45\":\"Offline@6\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":35,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"470\":\"\",\"477\":\"\",\"584\":\"\",\"605\":\"\",\"606\":\"\",\"608\":9,\"633\":1,\"705\":\"\",\"718\":1,\"757\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "9.125", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "2770", "jd_createddate": 1743465600, "jd_orderdate": null, "jd_duedate": 1743465600, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1743494345, "jd_updatedat": 1743494416 } ], "deleted": [] }, "bm_orderitem": { "created": [ { "oi_id": 6550, "oi_jobid": 2760, "oi_jobtempid": "0", "oi_jobmultiquoteid": 2782, "oi_productid": 5, "oi_recipeid": 5, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 230, "oi_customseq": 1, "oi_productcustomseq": 668, "oi_jsondata": "[{\"id\":15091,\"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\":15091,\"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\":33,\"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\":33,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":34,\"labelname\":\"Supplier\",\"value\":null,\"valueid\":null,\"type\":17,\"optionid\":null,\"optionvalue\":[],\"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\":34,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":36,\"labelname\":\"Slat Colour\",\"value\":null,\"valueid\":null,\"type\":13,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Slat 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\":13,\"mandatory\":0,\"fieldname\":\"Slat Colour\",\"fieldid\":36,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":61,\"labelname\":\"Color\",\"value\":null,\"valueid\":null,\"type\":20,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Color\",\"fabricorcolor\":2,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":20,\"mandatory\":0,\"fieldname\":\"Color\",\"fieldid\":61,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":8605,\"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\":8605,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":8606,\"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\":8606,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":13885,\"labelname\":\"Control Type\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Control 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\":3,\"mandatory\":0,\"fieldname\":\"Control Type\",\"fieldid\":13885,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2084,\"labelname\":\"Reverse Roll\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Reverse Roll\",\"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\":\"Reverse Roll\",\"fieldid\":2084,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "", "oi_reportdescription": "##Quantity: 1##", "oi_reporttitles": "##Quantity:", "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\":2374,\"value\":null,\"formula\":\"Quantity*10\",\"price\":null,\"recipeid\":5,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":873,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":5,\"stockupdate\":0,\"fieldid\":19217,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Dimmer Emitter 4 Channels SOURCE\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":455,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":5,\"stockupdate\":0,\"fieldid\":12239,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"setup option\",\"list_option_name\":\"setup option\",\"list_description\":\"check stock updation\",\"list_option_code\":\"078\",\"list_unit_type\":\"Each\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":2476,\"value\":null,\"formula\":\"Width\",\"price\":\"-\",\"recipeid\":5,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":2477,\"value\":null,\"formula\":\"Drop\",\"price\":\"-\",\"recipeid\":5,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"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,\"category\":4}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "0.000", "oi_netprice": "0.000", "oi_pricesfromoperations": null, "oi_vatprice": "0.000", "oi_vatvalue": "9.125", "oi_vatselected": 44, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "0.000", "oi_overrideprice": "0.000", "oi_overridetype": 1, "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": 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": "[15091, 33, 34, 36, 61, 8605, 8606, 13885, 2084]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "6550", "oi_productiondate": 1743510181, "oi_createdat": 1743510181, "oi_updatedat": 1743490393, "oi_createdby": 37, "oi_updatedby": 37 }, { "oi_id": 6551, "oi_jobid": 2762, "oi_jobtempid": "0", "oi_jobmultiquoteid": 2784, "oi_productid": 25, "oi_recipeid": 25, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 230, "oi_customseq": 1, "oi_productcustomseq": 4, "oi_jsondata": "[{\"id\":15111,\"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\":15111,\"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\":1748,\"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\":1748,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1749,\"labelname\":\"Supplier\",\"value\":null,\"valueid\":null,\"type\":17,\"optionid\":null,\"optionvalue\":[],\"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\":1749,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1751,\"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\":1751,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1752,\"labelname\":\"Blind or Recess\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Blind or Recess\",\"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\":\"Blind or Recess\",\"fieldid\":1752,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1753,\"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\":1753,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1754,\"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\":1754,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1750,\"labelname\":\"Product Type\",\"value\":null,\"valueid\":null,\"type\":13,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Product 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\":13,\"mandatory\":0,\"fieldname\":\"Product Type\",\"fieldid\":1750,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1766,\"labelname\":\"Fabric\",\"value\":null,\"valueid\":null,\"type\":5,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fabric\",\"fabricorcolor\":1,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":5,\"mandatory\":0,\"fieldname\":\"Fabric\",\"fieldid\":1766,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1755,\"labelname\":\"Controls\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Controls\",\"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\":\"Controls\",\"fieldid\":1755,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1756,\"labelname\":\"Brackets\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Brackets\",\"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\":\"Brackets\",\"fieldid\":1756,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1757,\"labelname\":\"Bead Depth\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Bead Depth\",\"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\":\"Bead Depth\",\"fieldid\":1757,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1758,\"labelname\":\"Rail Colour\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Rail 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\":\"Rail Colour\",\"fieldid\":1758,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1759,\"labelname\":\"Side Rails\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Side Rails\",\"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\":\"Side Rails\",\"fieldid\":1759,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1760,\"labelname\":\"Side Profile\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Side Profile\",\"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\":\"Side Profile\",\"fieldid\":1760,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1761,\"labelname\":\"Control Rod\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Control Rod\",\"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\":\"Control Rod\",\"fieldid\":1761,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":14400,\"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\":14400,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "", "oi_reportdescription": "##Quantity: 1##", "oi_reporttitles": "##Quantity:", "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\":2170,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":25,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":2171,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":25,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":2453,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":25,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":763,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":25,\"stockupdate\":0,\"fieldid\":3770,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"OptTest\",\"fractionvalue\":null}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[{\"link_id\":344,\"process_id\":190,\"product_id\":25,\"phc_id\":344,\"pd_id\":190,\"name\":\"SAMPLE ASSEM\",\"phc_linkstations\":3,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"5.00\",\"phc_contractsellingprice\":\"5.00\",\"phc_tradesellingprice\":\"5.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"5.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"5.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"5.00\",\"price\":\"0.00\"},{\"link_id\":345,\"process_id\":191,\"product_id\":25,\"phc_id\":345,\"pd_id\":191,\"name\":\"SAMPLE dispatch\",\"phc_linkstations\":4,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"5.00\",\"phc_contractsellingprice\":\"5.00\",\"phc_tradesellingprice\":\"5.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"5.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"5.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"5.00\",\"price\":\"0.00\"},{\"link_id\":343,\"process_id\":189,\"product_id\":25,\"phc_id\":343,\"pd_id\":189,\"name\":\"sample officeCH\",\"phc_linkstations\":1,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"5.00\",\"phc_contractsellingprice\":\"5.00\",\"phc_tradesellingprice\":\"5.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"5.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"5.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"5.00\",\"price\":\"0.00\"}]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"15.00\",\"cost_with_discount\":\"15.00\",\"cost_with_markup\":\"15.00\",\"gross_price\":\"16.37\",\"vat_price\":\"1.37\"}", "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": "15.000", "oi_netprice": "15.000", "oi_pricesfromoperations": null, "oi_vatprice": "1.370", "oi_vatvalue": "9.125", "oi_vatselected": 44, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "16.370", "oi_overrideprice": "0.000", "oi_overridetype": 1, "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": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "15.750", "oi_endcustomeroverridevatprice": "1.440", "oi_endcustomeroverridegrossprice": "17.190", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[15111, 1748, 1749, 1751, 1752, 1753, 1754, 1750, 1766, 1755, 1756, 1757, 1758, 1759, 1760, 1761, 14400]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "6551", "oi_productiondate": 1743510246, "oi_createdat": 1743510246, "oi_updatedat": 1743490460, "oi_createdby": 37, "oi_updatedby": 37 }, { "oi_id": 6552, "oi_jobid": 2763, "oi_jobtempid": "0", "oi_jobmultiquoteid": 2785, "oi_productid": 558, "oi_recipeid": 711, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 230, "oi_customseq": 1, "oi_productcustomseq": 2, "oi_jsondata": "[{\"id\":24667,\"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\":24667,\"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\":24666,\"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\":24666,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":24668,\"labelname\":\"Supplier\",\"value\":2,\"valueid\":null,\"type\":17,\"optionid\":2,\"optionvalue\":[{\"id\":2,\"optionid\":2,\"optionname\":\"Decora\",\"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\":24668,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":2,\"optionsvalue\":[{\"id\":2,\"optionid\":2,\"optionname\":\"Decora\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":24669,\"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\":24669,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":24670,\"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\":24670,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":24671,\"labelname\":\"Price band\",\"value\":null,\"valueid\":null,\"type\":13,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Price 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\":\"Price band\",\"fieldid\":24671,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":24672,\"labelname\":\"Fabric\",\"value\":null,\"valueid\":null,\"type\":5,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fabric\",\"fabricorcolor\":1,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":5,\"mandatory\":0,\"fieldname\":\"Fabric\",\"fieldid\":24672,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":24674,\"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\":24674,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":24675,\"labelname\":\"fff\",\"value\":null,\"valueid\":null,\"type\":4,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"fff\",\"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\":4,\"mandatory\":0,\"fieldname\":\"fff\",\"fieldid\":24675,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":24676,\"labelname\":\"fg\",\"value\":null,\"valueid\":null,\"type\":29,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"fg\",\"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\":29,\"mandatory\":0,\"fieldname\":\"fg\",\"fieldid\":24676,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Supplier: Decora", "oi_reportdescription": "##Quantity: 1##,##Supplier: Decora##", "oi_reporttitles": "##Quantity:<\/br>##Supplier:", "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}]", "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": "0.000", "oi_netprice": "0.000", "oi_pricesfromoperations": null, "oi_vatprice": "0.000", "oi_vatvalue": "9.125", "oi_vatselected": 44, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "0.000", "oi_overrideprice": "0.000", "oi_overridetype": 1, "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": 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": "[24667, 24666, 24668, 24669, 24670, 24671, 24672, 24674, 24675, 24676]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "6552", "oi_productiondate": 1743510279, "oi_createdat": 1743510279, "oi_updatedat": 1743490490, "oi_createdby": 37, "oi_updatedby": 37 }, { "oi_id": 6559, "oi_jobid": 2769, "oi_jobtempid": "0", "oi_jobmultiquoteid": 2791, "oi_productid": 17, "oi_recipeid": 17, "oi_ruleid": 0, "oi_qty": 2, "oi_seq": 0, "oi_customseq": 0, "oi_productcustomseq": 0, "oi_jsondata": "[{\"id\":15103,\"labelname\":\"Unit Type\",\"value\":4,\"valueid\":\"4\",\"type\":34,\"optionid\":\"4\",\"optionvalue\":[{\"optionid\":4,\"optionname\":\"Inches\",\"optioncode\":\"\",\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":4,\"forchildfieldoptionlinkid\":\"34_4\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":241,\"labelname\":\"Quantity\",\"value\":\"2\",\"valueid\":\"\",\"type\":14,\"optionid\":\"1\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":242,\"labelname\":\"Supplier\",\"value\":\"10\",\"valueid\":\"\",\"type\":17,\"optionid\":\"10\",\"optionvalue\":[{\"id\":10,\"optionid\":10,\"optionname\":\"Blind Design\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":244,\"labelname\":\"Room\",\"value\":\"2\",\"valueid\":\"\",\"type\":18,\"optionid\":\"2\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":246,\"labelname\":\"Width\",\"value\":\"86\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"3_Inches_4_0.09375\",\"widthfractiontext\":\"3\/32\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":6905,\"labelname\":\"Drop\",\"value\":\"96\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"3_Inches_4_0.09375\",\"dropfractiontext\":\"3\/32\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":245,\"labelname\":\"Blind or Recess\",\"value\":\"Recess\",\"valueid\":\"7656\",\"type\":3,\"optionid\":\"2485\",\"optionvalue\":[{\"optionid\":2485,\"optionname\":\"Recess\",\"optioncode\":\"BD1\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":7656,\"forchildfieldoptionlinkid\":\"3_7656\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":243,\"labelname\":\"Product Type\",\"value\":602,\"valueid\":\"602\",\"type\":13,\"optionid\":\"602\",\"optionvalue\":[{\"id\":602,\"fieldid\":243,\"fieldoptionlinkid\":602,\"optionid\":602,\"mainsupplier\":\"10\",\"blindtypecode\":\"\",\"optionname\":\"89mm Group 5\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":249,\"labelname\":\"Control Type\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":250,\"labelname\":\"Control Side\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":248,\"labelname\":\"Bunch\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":251,\"labelname\":\"Headrail System\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":252,\"labelname\":\"Headrail Colour\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":253,\"labelname\":\"Extras\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":4924,\"labelname\":\"Brackets\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":254,\"labelname\":\"Special Instructions\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":7608,\"labelname\":\"Numeric 1\",\"value\":\"\",\"valueid\":\"\",\"type\":6,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":7609,\"labelname\":\"Location_List\",\"value\":\"\",\"valueid\":\"\",\"type\":4,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":7610,\"labelname\":\"Location_Text\",\"value\":\"\",\"valueid\":\"\",\"type\":29,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]", "oi_description": "Unit Type: Inches, Quantity: 2, Supplier: Blind Design, Room: 2, Width: 3\/32, Drop: 3\/32, Blind or Recess: Recess", "oi_reportdescription": "##Quantity: 2##,##Supplier: Blind Design##,##Room: 2##,##Width: 3\/32 Inches##,##Drop: 3\/32 Inches##,##Blind or Recess: Recess##", "oi_reporttitles": "##Quantity:##Supplier:##Room:##Width:##Drop:##Blind or Recess:", "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": "1138.780", "oi_netprice": "1138.780", "oi_pricesfromoperations": null, "oi_vatprice": "103.910", "oi_vatvalue": "9.125", "oi_vatselected": 44, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "1242.690", "oi_overrideprice": "0.000", "oi_overridetype": 1, "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": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "1138.780", "oi_endcustomeroverridevatprice": "103.910", "oi_endcustomeroverridegrossprice": "1242.690", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[15103, 241, 242, 244, 246, 6905, 245, 243, 249, 250, 248, 251, 252, 253, 4924, 254, 7608, 7609, 7610]", "oi_deviceplatform": 1, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "6559", "oi_productiondate": 1743494132, "oi_createdat": 1743494174, "oi_updatedat": 1743494384, "oi_createdby": 40, "oi_updatedby": 40 }, { "oi_id": 6560, "oi_jobid": 2770, "oi_jobtempid": "0", "oi_jobmultiquoteid": 2792, "oi_productid": 5, "oi_recipeid": 5, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 0, "oi_customseq": 0, "oi_productcustomseq": 0, "oi_jsondata": "[{\"id\":15091,\"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\":33,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":34,\"labelname\":\"Supplier\",\"value\":\"53\",\"valueid\":\"\",\"type\":17,\"optionid\":\"53\",\"optionvalue\":[{\"id\":53,\"optionid\":53,\"optionname\":\"Live Source\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":36,\"labelname\":\"Slat Colour\",\"value\":783,\"valueid\":\"831\",\"type\":13,\"optionid\":\"783\",\"optionvalue\":[{\"id\":831,\"fieldid\":36,\"fieldoptionlinkid\":831,\"optionid\":783,\"mainsupplier\":\"53\",\"blindtypecode\":\"1\",\"optionname\":\"n\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":61,\"labelname\":\"Color\",\"value\":\"666\",\"valueid\":\"28409\",\"type\":20,\"optionid\":\"28409\",\"optionvalue\":[{\"optionid\":28409,\"optionname\":\"666\",\"optioncode\":\"\",\"optionquantity\":1,\"fieldoptionlinkid\":28409,\"forchildfieldoptionlinkid\":\"20_3_28409_1\",\"minimumdiscount\":\"\",\"maximumdiscount\":\"\",\"optionimage\":\"\",\"subdatacount\":0,\"pricegroup\":\"n\",\"pricegroupid\":783}],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":8605,\"labelname\":\"Width\",\"value\":\"1000\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":8606,\"labelname\":\"Drop\",\"value\":\"1000\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":13885,\"labelname\":\"Control Type\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":2084,\"labelname\":\"Reverse Roll\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]", "oi_description": "Unit Type: mm, Quantity: 1, Supplier: Live Source, Slat Colour: n, Color: 666, Width: 1000, Drop: 1000", "oi_reportdescription": "##Quantity: 1##,##Supplier: Live Source##,##Slat Colour: n##,##Color: 666##,##Width: 1000 mm##,##Drop: 1000 mm##", "oi_reporttitles": "##Quantity:##Supplier:##Slat Colour:##Color:##Width:##Drop:", "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": "95.000", "oi_netprice": "190.000", "oi_pricesfromoperations": null, "oi_vatprice": "17.340", "oi_vatvalue": "9.125", "oi_vatselected": 44, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "207.340", "oi_overrideprice": "0.000", "oi_overridetype": 1, "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": 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": "[15091, 33, 34, 36, 61, 8605, 8606, 13885, 2084]", "oi_deviceplatform": 2, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "6560", "oi_productiondate": 1743494353, "oi_createdat": 1743494382, "oi_updatedat": null, "oi_createdby": 9, "oi_updatedby": null } ], "updated": [ { "oi_id": 6559, "oi_jobid": 2769, "oi_jobtempid": "0", "oi_jobmultiquoteid": 2791, "oi_productid": 17, "oi_recipeid": 17, "oi_ruleid": 0, "oi_qty": 2, "oi_seq": 0, "oi_customseq": 0, "oi_productcustomseq": 0, "oi_jsondata": "[{\"id\":15103,\"labelname\":\"Unit Type\",\"value\":4,\"valueid\":\"4\",\"type\":34,\"optionid\":\"4\",\"optionvalue\":[{\"optionid\":4,\"optionname\":\"Inches\",\"optioncode\":\"\",\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":4,\"forchildfieldoptionlinkid\":\"34_4\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":241,\"labelname\":\"Quantity\",\"value\":\"2\",\"valueid\":\"\",\"type\":14,\"optionid\":\"1\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":242,\"labelname\":\"Supplier\",\"value\":\"10\",\"valueid\":\"\",\"type\":17,\"optionid\":\"10\",\"optionvalue\":[{\"id\":10,\"optionid\":10,\"optionname\":\"Blind Design\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":244,\"labelname\":\"Room\",\"value\":\"2\",\"valueid\":\"\",\"type\":18,\"optionid\":\"2\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":246,\"labelname\":\"Width\",\"value\":\"86\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"3_Inches_4_0.09375\",\"widthfractiontext\":\"3\/32\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":6905,\"labelname\":\"Drop\",\"value\":\"96\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"3_Inches_4_0.09375\",\"dropfractiontext\":\"3\/32\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":245,\"labelname\":\"Blind or Recess\",\"value\":\"Recess\",\"valueid\":\"7656\",\"type\":3,\"optionid\":\"2485\",\"optionvalue\":[{\"optionid\":2485,\"optionname\":\"Recess\",\"optioncode\":\"BD1\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":7656,\"forchildfieldoptionlinkid\":\"3_7656\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":243,\"labelname\":\"Product Type\",\"value\":602,\"valueid\":\"602\",\"type\":13,\"optionid\":\"602\",\"optionvalue\":[{\"id\":602,\"fieldid\":243,\"fieldoptionlinkid\":602,\"optionid\":602,\"mainsupplier\":\"10\",\"blindtypecode\":\"\",\"optionname\":\"89mm Group 5\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":249,\"labelname\":\"Control Type\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":250,\"labelname\":\"Control Side\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":248,\"labelname\":\"Bunch\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":251,\"labelname\":\"Headrail System\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":252,\"labelname\":\"Headrail Colour\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":253,\"labelname\":\"Extras\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":4924,\"labelname\":\"Brackets\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":254,\"labelname\":\"Special Instructions\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":7608,\"labelname\":\"Numeric 1\",\"value\":\"\",\"valueid\":\"\",\"type\":6,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":7609,\"labelname\":\"Location_List\",\"value\":\"\",\"valueid\":\"\",\"type\":4,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":7610,\"labelname\":\"Location_Text\",\"value\":\"\",\"valueid\":\"\",\"type\":29,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]", "oi_description": "Unit Type: Inches, Quantity: 2, Supplier: Blind Design, Room: 2, Width: 3\/32, Drop: 3\/32, Blind or Recess: Recess", "oi_reportdescription": "##Quantity: 2##,##Supplier: Blind Design##,##Room: 2##,##Width: 3\/32 Inches##,##Drop: 3\/32 Inches##,##Blind or Recess: Recess##", "oi_reporttitles": "##Quantity:##Supplier:##Room:##Width:##Drop:##Blind or Recess:", "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": "1138.780", "oi_netprice": "1138.780", "oi_pricesfromoperations": null, "oi_vatprice": "103.910", "oi_vatvalue": "9.125", "oi_vatselected": 44, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "1242.690", "oi_overrideprice": "0.000", "oi_overridetype": 1, "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": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "1138.780", "oi_endcustomeroverridevatprice": "103.910", "oi_endcustomeroverridegrossprice": "1242.690", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[15103, 241, 242, 244, 246, 6905, 245, 243, 249, 250, 248, 251, 252, 253, 4924, 254, 7608, 7609, 7610]", "oi_deviceplatform": 1, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "6559", "oi_productiondate": 1743494132, "oi_createdat": 1743494174, "oi_updatedat": 1743494384, "oi_createdby": 40, "oi_updatedby": 40 } ], "deleted": [] }, "bm_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_notelist": { "created": [ { "nl_id": 1574, "nl_ordertempid": 0, "nl_orderid": 2769, "nl_notescategory": 1, "nl_type": 10, "nl_platform": 1, "nl_desc": "Invoice Created (IN406)", "nl_manualNotes": null, "nl_createdby": "40", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 0, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "1574", "nl_endddate": 1743465600, "nl_starttime": 1743494299, "created_at": 1743494299, "updated_at": 1743494384, "created_by": 40, "updated_by": null } ], "updated": [], "deleted": [] }, "bm_deliveryaddresssetting": { "created": [ { "das_id": 1234, "das_jobid": 2769, "das_appointmentaddress": 2730, "das_invoiceaddress": 2730, "das_invoicedeliveryaddress": 2730, "das_purchaseaddress": 0, "das_worksheetaddress": 0, "id": "1234", "das_createdat": 1743494256, "das_updatedat": 1743494256, "das_createdby": 1, "das_updatedby": null } ], "updated": [], "deleted": [] }, "bm_jobchecklist": { "created": [], "updated": [], "deleted": [] }, "bm_Invoice": { "created": [ { "invoice_id": 350, "job_id": 2769, "customer_id": 1482, "ref_no": "IN406", "invoice_type": 1, "invoice_split_type": 0, "invoice_split_cal": 0, "invoice_split_cal_value": null, "net_amount": "569.390", "vat_amount": "51.960", "gross_amount": "621.350", "delivery_amount": "0.000", "delivery": 0, "commission_amount": "0.000", "commission": 0, "total_amount": "621.350", "split_net_amount": null, "split_vat_amount": null, "outstanding_amount": "621.350", "paid_amount": "0.000", "paid_status": 0, "status": 0, "transfer": 0, "transfer_id": null, "id": "350", "paymentDueDate": 1743465600, "invoiceDate": 1743465600, "transferDate": null, "createdat": 1743494299, "updatedat": 1743494385, "createdby": 40, "updatedby": null } ], "updated": [], "deleted": [] }, "bm_InvoiceDetails": { "created": [ { "ind_id": 470, "ind_invoice_id": 350, "ind_order_id": 6559, "ind_qty": 1, "ind_net_amount": "569.390", "ind_vat_amount": "51.960", "ind_gross_amount": "621.350", "ind_status": 0, "id": "470", "ind_createdat": 1743494299, "ind_updatedat": 1743494299, "ind_createdby": 40, "ind_updatedby": null } ], "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": [], "updated": [], "deleted": [] }, "bm_jobmultiquote": { "created": [ { "jmq_id": 2792, "jmq_jobid": 2770, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "190.00", "jmq_netprice": "190.00", "jmq_vat": "17.34", "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": "207.34", "jmq_grossprofit": "0.00", "jmq_costprice": "95.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "207.34", "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": "9.125", "jmq_cdeliveryvatperc": "9.125", "id": "2792", "jmq_duedate": 1743465600, "jmq_sceduleddate": null, "jmq_createdat": "1743494345.000000", "jmq_updatedat": "1743494416.000000", "jmq_createdby": 9, "jmq_updatedby": 9 } ], "updated": [ { "jmq_id": 2792, "jmq_jobid": 2770, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "190.00", "jmq_netprice": "190.00", "jmq_vat": "17.34", "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": "207.34", "jmq_grossprofit": "0.00", "jmq_costprice": "95.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "207.34", "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": "9.125", "jmq_cdeliveryvatperc": "9.125", "id": "2792", "jmq_duedate": 1743465600, "jmq_sceduleddate": null, "jmq_createdat": "1743494345.000000", "jmq_updatedat": "1743494416.000000", "jmq_createdby": 9, "jmq_updatedby": 9 } ], "deleted": [] }, "bm_jobstatus_tracks": { "created": [ { "jst_id": 2953, "jst_jobid": 2769, "jst_job_current_status": 6, "id": "2953", "jst_createdat": "1743494225.056371" }, { "jst_id": 2954, "jst_jobid": 2770, "jst_job_current_status": 3, "id": "2954", "jst_createdat": "1743494416.185510" } ], "updated": [], "deleted": [] }, "bm_customindividuallogs": { "created": [ { "cl_id": 47391, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 2769, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 2769, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 40, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"Blind Design (uk) Ltd\",\"\":2,\"Account Type\":\"Domestic\",\"Source\":\"WEB\",\"Created By\":\"Bharani\",\"First Name\":\"George\",\"Country\":\"USA\",\"Salutation\":\"Mr.\",\"Check Box6\":\"Disabled\",\"Check Box5\":\"Disabled\",\"Assigned to\":40,\"Role\":1,\"Date4\":\"2025-04-01\",\"Additional Contacts\":\"2730\",\"Order Date\":\"2025-04-01\",\"Job Ref No\":\"BD2659\",\"Job Status\":\"Invoiced\",\"Order Status\":\"Ready to Start\",\"Net Price\":\"569.39\",\"VAT Price\":\"51.96\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"Gross Price Amount\":\"621.35\",\"Total CostPrice\":\"569.39\",\"Amount Outstanding\":\"621.35\",\"jd_isonlineorder\":1,\"Delivery Vat Percentage\":\"9.125\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\",\"Job Rework Enable\":\"On\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":2769,\"jd_customerid\":1482,\"jd_contactid\":2730,\"jd_additionalcontacts\":\"2730\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"BD2659\\\",\\\"35\\\":\\\"GEOR0001\\\",\\\"36\\\":6,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":23,\\\"40\\\":2,\\\"41\\\":40,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"George\\\",\\\"46\\\":\\\"\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":35,\\\"285\\\":1,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"470\\\":\\\"\\\",\\\"477\\\":\\\"\\\",\\\"584\\\":\\\"\\\",\\\"605\\\":\\\"\\\",\\\"606\\\":\\\"\\\",\\\"608\\\":40,\\\"633\\\":1,\\\"705\\\":\\\"\\\",\\\"718\\\":1,\\\"757\\\":1}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-04-01\",\"jd_orderdate\":\"2025-04-01\",\"jd_duedate\":null,\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":null,\"jd_jobref\":\"BD2659\",\"jd_jobstatus\":6,\"jd_contactaddid\":0,\"jd_orderstatus\":2,\"jd_accref\":\"GEOR0001\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"569.39\",\"jd_netprice\":\"569.39\",\"jd_vat\":\"51.96\",\"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\":\"621.35\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"569.39\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"621.35\",\"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_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":40,\"jd_createdat\":\"2025-04-01T07:55:21.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-04-01T07:57:04.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\":\"9.125\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"9.125\",\"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\":1,\"jd_rework_count\":0}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "47391", "cl_createdat": "1743494224.000000", "cl_updatedat": null }, { "cl_id": 47392, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in BD2659", "cl_event": "created", "cl_subjectid": 2791, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 2769, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 40, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":2791,\"jmq_jobid\":2769,\"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\":\"569.39\",\"Net Price\":\"569.39\",\"VAT Price\":\"51.96\",\"VAT\":1,\"jmq_deliverycost\":\"0.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"621.35\",\"Gross Profit\":\"0.00\",\"Total CostPrice\":\"569.39\",\"Amount Outstanding\":\"621.35\",\"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\":\"9.125\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":2791,\"jmq_jobid\":2769,\"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\":\"569.39\",\"jmq_netprice\":\"569.39\",\"jmq_vat\":\"51.96\",\"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\":\"621.35\",\"jmq_grossprofit\":\"0.00\",\"jmq_costprice\":\"569.39\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"621.35\",\"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\":\"9.125\",\"jmq_cdeliveryvatperc\":\"9.125\",\"jmq_createdby\":40,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-04-01T07:55:21.000000Z\",\"jmq_updatedat\":null,\"jmq_grossprofit_percentage\":\"0.00\",\"jmq_ready\":0}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "47392", "cl_createdat": "1743494225.000000", "cl_updatedat": null }, { "cl_id": 47393, "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": 2769, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 2769, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 40, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":2791}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":2791},\"old\":{\"jd_jobmultiquoteid\":null}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "47393", "cl_createdat": "1743494225.000000", "cl_updatedat": null }, { "cl_id": 47394, "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 Verticals", "cl_event": "created", "cl_subjectid": 6559, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 2769, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 40, "cl_changedfrom": "null", "cl_changedto": "{\"Unit Type\":\" Inches\",\" Quantity\":\" 1\",\" Supplier\":\" Blind Design\",\" Room\":\" 2\",\" Width\":\" 3\\\/32\",\" Drop\":\" 3\\\/32\",\" Blind or Recess\":\" Recess\",\" Product Type\":\" 89mm Group 5\"}", "cl_customproperties": "{\"attributes\":{\"oi_id\":6559,\"oi_jobid\":2769,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":2791,\"oi_credit_id\":0,\"oi_productid\":17,\"oi_recipeid\":17,\"oi_ruleid\":0,\"oi_qty\":1,\"oi_seq\":0,\"oi_customseq\":0,\"oi_productcustomseq\":0,\"oi_jsondata\":\"[{\\\"id\\\":15103,\\\"labelname\\\":\\\"Unit Type\\\",\\\"value\\\":4,\\\"valueid\\\":\\\"4\\\",\\\"type\\\":34,\\\"optionid\\\":\\\"4\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":4,\\\"optionname\\\":\\\"Inches\\\",\\\"optioncode\\\":\\\"\\\",\\\"optionquantity\\\":1,\\\"unittype\\\":0,\\\"unitcost\\\":0,\\\"pricingtype\\\":0,\\\"fieldoptionlinkid\\\":4,\\\"forchildfieldoptionlinkid\\\":\\\"34_4\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":241,\\\"labelname\\\":\\\"Quantity\\\",\\\"value\\\":1,\\\"valueid\\\":\\\"\\\",\\\"type\\\":14,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":242,\\\"labelname\\\":\\\"Supplier\\\",\\\"value\\\":\\\"10\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":17,\\\"optionid\\\":\\\"10\\\",\\\"optionvalue\\\":[{\\\"id\\\":10,\\\"optionid\\\":10,\\\"optionname\\\":\\\"Blind Design\\\",\\\"deleted\\\":0,\\\"optionquantity\\\":1}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":244,\\\"labelname\\\":\\\"Room\\\",\\\"value\\\":\\\"2\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":246,\\\"labelname\\\":\\\"Width\\\",\\\"value\\\":\\\"86\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":11,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"3_Inches_4_0.09375\\\",\\\"widthfractiontext\\\":\\\"3\\\/32\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":6905,\\\"labelname\\\":\\\"Drop\\\",\\\"value\\\":\\\"96\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":12,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"3_Inches_4_0.09375\\\",\\\"dropfractiontext\\\":\\\"3\\\/32\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":245,\\\"labelname\\\":\\\"Blind or Recess\\\",\\\"value\\\":\\\"Recess\\\",\\\"valueid\\\":\\\"7656\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"2485\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":2485,\\\"optionname\\\":\\\"Recess\\\",\\\"optioncode\\\":\\\"BD1\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":null,\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":7656,\\\"forchildfieldoptionlinkid\\\":\\\"3_7656\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":243,\\\"labelname\\\":\\\"Product Type\\\",\\\"value\\\":602,\\\"valueid\\\":\\\"602\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"602\\\",\\\"optionvalue\\\":[{\\\"id\\\":602,\\\"fieldid\\\":243,\\\"fieldoptionlinkid\\\":602,\\\"optionid\\\":602,\\\"mainsupplier\\\":\\\"10\\\",\\\"blindtypecode\\\":\\\"\\\",\\\"optionname\\\":\\\"89mm Group 5\\\",\\\"optionquantity\\\":1,\\\"subcount\\\":0,\\\"status\\\":0,\\\"subdatacount\\\":0}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":565,\\\"labelname\\\":\\\"Fabric\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":5,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":1,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":249,\\\"labelname\\\":\\\"Control Type\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":250,\\\"labelname\\\":\\\"Control Side\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":248,\\\"labelname\\\":\\\"Bunch\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":251,\\\"labelname\\\":\\\"Headrail System\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":252,\\\"labelname\\\":\\\"Headrail Colour\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":253,\\\"labelname\\\":\\\"Extras\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":4924,\\\"labelname\\\":\\\"Brackets\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":254,\\\"labelname\\\":\\\"Special Instructions\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7608,\\\"labelname\\\":\\\"Numeric 1\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":6,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7609,\\\"labelname\\\":\\\"Location_List\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":4,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7610,\\\"labelname\\\":\\\"Location_Text\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":29,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0}]\",\"oi_description\":\"Unit Type: Inches, Quantity: 1, Supplier: Blind Design, Room: 2, Width: 3\\\/32, Drop: 3\\\/32, Blind or Recess: Recess, Product Type: 89mm Group 5\",\"oi_onlinedescription\":null,\"oi_imagepath\":null,\"oi_reportdescription\":\"##Quantity: 1##,##Supplier: Blind Design##,##Room: 2##,##Width: 3\\\/32 Inches##,##Drop: 3\\\/32 Inches##,##Blind or Recess: Recess##,##Product Type: 89mm Group 5##\",\"oi_onlinereportdescription\":null,\"oi_reporttitles\":\"##Quantity:##Supplier:##Room:##Width:##Drop:##Blind or Recess:##Product Type:\",\"oi_onlinereporttitles\":null,\"oi_productionformulajsondata\":\"[]\",\"oi_productiondate\":\"2025-04-01 07:55:32\",\"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\":\"569.390\",\"oi_netprice\":\"569.390\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"51.960\",\"oi_vatvalue\":\"9.125\",\"oi_vatselected\":44,\"oi_vattype\":1,\"oi_vatonoff\":1,\"oi_grossprice\":\"621.350\",\"oi_overrideprice\":\"0.000\",\"oi_overridetype\":1,\"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\":1,\"oi_endcustomeroverridevalue\":null,\"oi_endcustomeroverridenetprice\":\"0.000\",\"oi_endcustomeroverridevatprice\":\"0.000\",\"oi_endcustomeroverridegrossprice\":\"0.000\",\"oi_sage_flag\":0,\"oi_status\":0,\"oi_createdby\":40,\"oi_createdat\":\"2025-04-01T07:56:14.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":null,\"oi_jsondataid\":\"[15103, 241, 242, 244, 246, 6905, 245, 243, 565, 249, 250, 248, 251, 252, 253, 4924, 254, 7608, 7609, 7610]\",\"oi_deviceplatform\":1,\"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}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "47394", "cl_createdat": "1743494225.000000", "cl_updatedat": null }, { "cl_id": 47395, "cl_logname": "model", "cl_type": null, "cl_modulename": "Production Due Date", "cl_message": "Production Due Date has been updated", "cl_event": "modified", "cl_subjectid": 2769, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 2769, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 40, "cl_changedfrom": "{\"Production Due Date\":\"0000-00-00\"}", "cl_changedto": "{\"Production Due Date\":\"2025-04-01\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "47395", "cl_createdat": "1743494225.000000", "cl_updatedat": null }, { "cl_id": 47396, "cl_logname": "default", "cl_type": null, "cl_modulename": "Alternative Address", "cl_message": "Alternative Address has been updated the fields Appointments Add,Invoice Add,Invoice Delivery Add,Purchase Add,Worksheet Add", "cl_event": "modified", "cl_subjectid": 1234, "cl_subjecttype": "App\\Models\\Job\\bm_deliveryaddresssetting", "cl_parentid": 2769, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Appointments Add\":\"Alternative Delivery Address\",\"Invoice Add\":\"Alternative Delivery Address\",\"Invoice Delivery Add\":\"Alternative Delivery Address\",\"Purchase Add\":\"Default(Same as billing add)\",\"Worksheet Add\":\"Default(Same as billing add)\"}", "cl_customproperties": "{\"attributes\":{\"das_id\":1234,\"das_jobid\":2769,\"das_appointmentaddress\":2730,\"das_invoiceaddress\":2730,\"das_invoicedeliveryaddress\":2730,\"das_purchaseaddress\":0,\"das_worksheetaddress\":0,\"das_createdby\":1,\"das_createdat\":\"2025-04-01 07:57:36\",\"das_updatedby\":null,\"das_updatedat\":\"2025-04-01 07:57:36\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "47396", "cl_createdat": "1743494256.000000", "cl_updatedat": null }, { "cl_id": 47397, "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": 2769, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 2769, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "{\"\":2}", "cl_changedto": "{\"End Customer Override Net Price\":\"569.39\",\"End Customer Override Vat Price\":\"51.96\",\"End Customer Override Gross Price\":\"621.35\"}", "cl_customproperties": "{\"attributes\":{\"jd_jobcustomoizedkeyvalue\":\"{\\\"33\\\":25,\\\"37\\\":1,\\\"39\\\":23,\\\"41\\\":40,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"George\\\",\\\"46\\\":\\\"\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":35,\\\"285\\\":1,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"470\\\":\\\"\\\",\\\"477\\\":\\\"\\\",\\\"584\\\":\\\"\\\",\\\"605\\\":\\\"\\\",\\\"606\\\":\\\"\\\",\\\"608\\\":40,\\\"633\\\":1,\\\"705\\\":\\\"\\\",\\\"718\\\":1,\\\"757\\\":1}\",\"jd_deletedcustokeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"34\\\":\\\"BD2659\\\",\\\"35\\\":\\\"GEOR0001\\\",\\\"36\\\":6,\\\"38\\\":\\\"\\\",\\\"40\\\":2}\",\"jd_sceduleddate\":\"0000-00-00\",\"jd_completeddate\":\"0000-00-00\",\"jd_editpricebyid\":0,\"jd_userdefinedarray\":\"\\\"\\\"\",\"jd_endcustomeroverridevalue\":\"\",\"jd_endcustomeroverridenetprice\":\"569.39\",\"jd_endcustomeroverridevatprice\":\"51.96\",\"jd_endcustomeroverridegrossprice\":\"621.35\",\"jd_endcustomerdeliverycost\":\"\",\"jd_endcustomerfittingcost\":\"\",\"jd_updatedby\":1,\"jd_updatedat\":\"2025-04-01T07:57:36.000000Z\"},\"old\":{\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"BD2659\\\",\\\"35\\\":\\\"GEOR0001\\\",\\\"36\\\":6,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":23,\\\"40\\\":2,\\\"41\\\":40,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"George\\\",\\\"46\\\":\\\"\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":35,\\\"285\\\":1,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"470\\\":\\\"\\\",\\\"477\\\":\\\"\\\",\\\"584\\\":\\\"\\\",\\\"605\\\":\\\"\\\",\\\"606\\\":\\\"\\\",\\\"608\\\":40,\\\"633\\\":1,\\\"705\\\":\\\"\\\",\\\"718\\\":1,\\\"757\\\":1}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_sceduleddate\":null,\"jd_completeddate\":null,\"jd_editpricebyid\":null,\"jd_userdefinedarray\":null,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerfittingcost\":null,\"jd_updatedby\":40,\"jd_updatedat\":\"2025-04-01T07:57:05.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "47397", "cl_createdat": "1743494256.000000", "cl_updatedat": null }, { "cl_id": 47398, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the field jd_qbodisplayname", "cl_event": "modified", "cl_subjectid": 2769, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 2769, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "[]", "cl_changedto": "{\"jd_qbodisplayname\":\"Mr. George \"}", "cl_customproperties": "{\"attributes\":{\"jd_qbodisplayname\":\"Mr. George \"},\"old\":{\"jd_qbodisplayname\":\"\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "47398", "cl_createdat": "1743494256.000000", "cl_updatedat": null }, { "cl_id": 47399, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 1574, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 2769, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 40, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"All Options\",\"Description\":\"Invoice Created (201743494299)\",\"Created By\":\"Bharani\",\"Date\":\"2025-04-01\",\"Time\":\"07:58:19\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":1574,\"nl_ordertempid\":0,\"nl_orderid\":2769,\"nl_notescategory\":1,\"nl_type\":10,\"nl_platform\":1,\"nl_desc\":\"Invoice Created (201743494299)\",\"nl_manualNotes\":null,\"nl_createdby\":\"40\",\"nl_endddate\":\"2025-04-01\",\"nl_starttime\":\"07:58:19\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":40,\"created_at\":\"2025-04-01T07:58:19.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-04-01T07:59:44.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "47399", "cl_createdat": "1743494384.000000", "cl_updatedat": null }, { "cl_id": 47400, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 2770, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 2770, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 9, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"Blind Design (uk) Ltd\",\"\":2,\"Account Type\":\"Domestic\",\"Source\":\"WEB\",\"Created By\":\"Pruthvi\",\"First Name\":\"Offline@6\",\"Country\":\"USA\",\"Salutation\":\"Mr.\",\"Check Box6\":\"Disabled\",\"Check Box5\":\"Disabled\",\"Assigned to\":9,\"Role\":1,\"Date4\":\"2025-04-01\",\"Additional Contacts\":\"2731\",\"Production Due Date\":\"2025-03-31\",\"Job Ref No\":\"BD2660\",\"Job Status\":\"Quote\",\"Order Status\":\"Ready to Start\",\"Net Price\":\"190.00\",\"VAT Price\":\"17.34\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"Gross Price Amount\":\"207.34\",\"Gross Profit\":\"95.00\",\"Total CostPrice\":\"95.00\",\"Amount Outstanding\":\"207.34\",\"jd_isonlineorder\":1,\"Delivery Vat Percentage\":\"9.125\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":2770,\"jd_customerid\":1483,\"jd_contactid\":2731,\"jd_additionalcontacts\":\"2731\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"BD2660\\\",\\\"35\\\":\\\"OFFL0008\\\",\\\"36\\\":3,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":23,\\\"40\\\":2,\\\"41\\\":9,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"Offline@6\\\",\\\"46\\\":\\\"\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":35,\\\"285\\\":1,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"470\\\":\\\"\\\",\\\"477\\\":\\\"\\\",\\\"584\\\":\\\"\\\",\\\"605\\\":\\\"\\\",\\\"606\\\":\\\"\\\",\\\"608\\\":9,\\\"633\\\":1,\\\"705\\\":\\\"\\\",\\\"718\\\":1,\\\"757\\\":1}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-04-01\",\"jd_orderdate\":null,\"jd_duedate\":\"2025-03-31\",\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":null,\"jd_jobref\":\"BD2660\",\"jd_jobstatus\":3,\"jd_contactaddid\":0,\"jd_orderstatus\":2,\"jd_accref\":\"OFFL0008\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"190.00\",\"jd_netprice\":\"190.00\",\"jd_vat\":\"17.34\",\"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\":\"207.34\",\"jd_grossprofit\":\"95.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"95.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"207.34\",\"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_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":9,\"jd_createdat\":\"2025-04-01T07:59:05.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-04-01T08:00:15.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\":\"9.125\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"9.125\",\"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}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "47400", "cl_createdat": "1743494416.000000", "cl_updatedat": null }, { "cl_id": 47401, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in BD2660", "cl_event": "created", "cl_subjectid": 2792, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 2770, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 9, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":2792,\"jmq_jobid\":2770,\"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\":\"190.00\",\"Net Price\":\"190.00\",\"VAT Price\":\"17.34\",\"VAT\":1,\"jmq_deliverycost\":\"0.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"207.34\",\"Gross Profit\":\"0.00\",\"Total CostPrice\":\"95.00\",\"Amount Outstanding\":\"207.34\",\"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\":\"9.125\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":2792,\"jmq_jobid\":2770,\"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\":\"190.00\",\"jmq_netprice\":\"190.00\",\"jmq_vat\":\"17.34\",\"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\":\"207.34\",\"jmq_grossprofit\":\"0.00\",\"jmq_costprice\":\"95.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"207.34\",\"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\":\"9.125\",\"jmq_cdeliveryvatperc\":\"9.125\",\"jmq_createdby\":9,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-04-01T07:59:05.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": "47401", "cl_createdat": "1743494416.000000", "cl_updatedat": null }, { "cl_id": 47402, "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": 2770, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 2770, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 9, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":2792}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":2792},\"old\":{\"jd_jobmultiquoteid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "47402", "cl_createdat": "1743494416.000000", "cl_updatedat": null }, { "cl_id": 47403, "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 Wooden Venetians", "cl_event": "created", "cl_subjectid": 6560, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 2770, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 9, "cl_changedfrom": "null", "cl_changedto": "{\"Unit Type\":\" mm\",\" Quantity\":\" 1\",\" Supplier\":\" Live Source\",\" Slat Colour\":\" n\",\" Color\":\" 666\",\" Width\":\" 1000\",\" Drop\":\" 1000\"}", "cl_customproperties": "{\"attributes\":{\"oi_id\":6560,\"oi_jobid\":2770,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":2792,\"oi_credit_id\":0,\"oi_productid\":5,\"oi_recipeid\":5,\"oi_ruleid\":0,\"oi_qty\":1,\"oi_seq\":0,\"oi_customseq\":0,\"oi_productcustomseq\":0,\"oi_jsondata\":\"[{\\\"id\\\":15091,\\\"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\\\":33,\\\"labelname\\\":\\\"Quantity\\\",\\\"value\\\":1,\\\"valueid\\\":\\\"\\\",\\\"type\\\":14,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":34,\\\"labelname\\\":\\\"Supplier\\\",\\\"value\\\":\\\"53\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":17,\\\"optionid\\\":\\\"53\\\",\\\"optionvalue\\\":[{\\\"id\\\":53,\\\"optionid\\\":53,\\\"optionname\\\":\\\"Live Source\\\",\\\"deleted\\\":0,\\\"optionquantity\\\":1}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":36,\\\"labelname\\\":\\\"Slat Colour\\\",\\\"value\\\":783,\\\"valueid\\\":\\\"831\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"783\\\",\\\"optionvalue\\\":[{\\\"id\\\":831,\\\"fieldid\\\":36,\\\"fieldoptionlinkid\\\":831,\\\"optionid\\\":783,\\\"mainsupplier\\\":\\\"53\\\",\\\"blindtypecode\\\":\\\"1\\\",\\\"optionname\\\":\\\"n\\\",\\\"optionquantity\\\":1,\\\"subcount\\\":0,\\\"status\\\":0,\\\"subdatacount\\\":0}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":61,\\\"labelname\\\":\\\"Color\\\",\\\"value\\\":\\\"666\\\",\\\"valueid\\\":\\\"28409\\\",\\\"type\\\":20,\\\"optionid\\\":\\\"28409\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":28409,\\\"optionname\\\":\\\"666\\\",\\\"optioncode\\\":\\\"\\\",\\\"optionquantity\\\":1,\\\"fieldoptionlinkid\\\":28409,\\\"forchildfieldoptionlinkid\\\":\\\"20_3_28409_1\\\",\\\"minimumdiscount\\\":\\\"\\\",\\\"maximumdiscount\\\":\\\"\\\",\\\"optionimage\\\":\\\"\\\",\\\"subdatacount\\\":0,\\\"pricegroup\\\":\\\"n\\\",\\\"pricegroupid\\\":783}],\\\"fabricorcolor\\\":2,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":8605,\\\"labelname\\\":\\\"Width\\\",\\\"value\\\":\\\"1000\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":11,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":8606,\\\"labelname\\\":\\\"Drop\\\",\\\"value\\\":\\\"1000\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":12,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":13885,\\\"labelname\\\":\\\"Control Type\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":2084,\\\"labelname\\\":\\\"Reverse Roll\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0}]\",\"oi_description\":\"Unit Type: mm, Quantity: 1, Supplier: Live Source, Slat Colour: n, Color: 666, Width: 1000, Drop: 1000\",\"oi_onlinedescription\":null,\"oi_imagepath\":null,\"oi_reportdescription\":\"##Quantity: 1##,##Supplier: Live Source##,##Slat Colour: n##,##Color: 666##,##Width: 1000 mm##,##Drop: 1000 mm##\",\"oi_onlinereportdescription\":null,\"oi_reporttitles\":\"##Quantity:##Supplier:##Slat Colour:##Color:##Width:##Drop:\",\"oi_onlinereporttitles\":null,\"oi_productionformulajsondata\":\"[]\",\"oi_productiondate\":\"2025-04-01 07:59:13\",\"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\":\"95.000\",\"oi_netprice\":\"190.000\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"17.340\",\"oi_vatvalue\":\"9.125\",\"oi_vatselected\":44,\"oi_vattype\":1,\"oi_vatonoff\":1,\"oi_grossprice\":\"207.340\",\"oi_overrideprice\":\"0.000\",\"oi_overridetype\":1,\"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\":1,\"oi_endcustomeroverridevalue\":null,\"oi_endcustomeroverridenetprice\":\"0.000\",\"oi_endcustomeroverridevatprice\":\"0.000\",\"oi_endcustomeroverridegrossprice\":\"0.000\",\"oi_sage_flag\":0,\"oi_status\":0,\"oi_createdby\":9,\"oi_createdat\":\"2025-04-01T07:59:42.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":null,\"oi_jsondataid\":\"[15091, 33, 34, 36, 61, 8605, 8606, 13885, 2084]\",\"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}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "47403", "cl_createdat": "1743494416.000000", "cl_updatedat": null }, { "cl_id": 47404, "cl_logname": "model", "cl_type": null, "cl_modulename": "Production Due Date", "cl_message": "Production Due Date has been updated", "cl_event": "modified", "cl_subjectid": 2770, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 2770, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 9, "cl_changedfrom": "{\"Production Due Date\":\"2025-03-31\"}", "cl_changedto": "{\"Production Due Date\":\"2025-04-01\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "47404", "cl_createdat": "1743494416.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": { "51743494345": 2731 }, "bm_customertemplatedata": { "31743494345": 1483 }, "bm_jobdetails": { "41743494345": 2770 }, "bm_jobmultiquote": { "141743494345": 2792 }, "bm_orderitem": { "71743494382": 6560 } }, "timestamp": 1743494415 }