{ "status": "success", "upcomingorder_list": { "bm_customertemplatedata": { "created": [], "updated": [ { "ctd_id": 3876, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\": 1, \"63\": \"Blinds \", \"64\": 25, \"600\": 25, \"62\": \"BLIN0002\"}", "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": "3876", "ctd_createdat": 1746691284, "ctd_updatedat": 1746691779, "ctd_createdby": 0, "ctd_updatedby": null } ], "deleted": [] }, "bm_customercontactinfo": { "created": [], "updated": [ { "cci_id": 4050, "cci_customerid": 3876, "cci_templateid": 3, "roleid": 0, "cci_customizedarray": "{\"75\":1,\"76\":\"85663224711\",\"77\":\"Joesph\",\"79\":\"K\",\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"Zoological Garden @12\",\"90\":4}", "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": 31746691284, "id": "4050", "cci_createdat": 1746691284, "cci_updatedat": 1746691779, "cci_createdby": 0, "cci_updatedby": null } ], "deleted": [] }, "bm_appointment": { "created": [], "updated": [], "deleted": [] }, "bm_tasklist": { "created": [ { "tl_id": 42, "tl_orderid": 0, "tl_taskcategory": 1, "tl_taskdate": "2025-05-08", "tl_tasktime": "11:45:24", "tl_taskmethod": "0", "tl_istaskprivate": 1, "tl_userid": "6", "tl_priority": 0, "tl_addjobid": 0, "tl_desc": "Live1", "tl_status": 0, "tl_markasread": 0, "tl_taskstatus": 4, "tl_userdefinedfields": "[]", "tl_markcompleted": 0, "tl_jobmode": null, "tl_recurrencerule": null, "tl_repeatmaindescription": null, "tl_repeatmethod": "daily", "tl_starttask": null, "tl_startdata": null, "tl_endtask": null, "tl_enddata": null, "tl_istaskrepeat": 0, "tl_deviceplatform": 1, "id": "42", "tl_createdat": 1746690001, "tl_updatedat": 1746690001, "tl_createdby": 1, "tl_updatedby": null } ], "updated": [], "deleted": [] }, "bm_jobdetails": { "created": [ { "jd_id": 5479, "jd_customerid": 3876, "jd_contactid": 4050, "jd_additionalcontacts": "4050", "jd_templateid": 1, "jd_jobmultiquoteid": 5504, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5499", "jd_jobstatus": 11, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "BLIN0002", "jd_invoiceno": "", "jd_listprice": "356.00", "jd_netprice": "356.00", "jd_vat": "78.32", "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": "434.32", "jd_grossprofit": "178.00", "jd_costprice": "178.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "434.32", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": null, "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 1, "jd_updatedby": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "22.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5499\",\"35\":\"BLIN0002\",\"36\":11,\"37\":1,\"38\":\"\",\"39\":25,\"40\":13,\"41\":1,\"44\":\"Blinds \",\"45\":\"Joesph\",\"46\":\"K\",\"47\":\"\",\"48\":\"\",\"49\":\"Zoological Garden @12\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":1,\"286\":\"85663224711\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"613\":\"\",\"615\":\"\",\"616\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "22.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5479", "jd_createddate": 1746662400, "jd_orderdate": null, "jd_duedate": 1746662400, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1746691284, "jd_updatedat": 1746691780 } ], "updated": [ { "jd_id": 5478, "jd_customerid": 3875, "jd_contactid": 4049, "jd_additionalcontacts": "4049", "jd_templateid": 1, "jd_jobmultiquoteid": 5503, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5498", "jd_jobstatus": 11, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "PRAD0002", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "0.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "jd_isroundon": 0, "jd_grossprice": "0.00", "jd_grossprofit": "0.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "0.00", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": null, "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 1, "jd_updatedby": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "22.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5498\",\"35\":\"PRAD0002\",\"36\":11,\"37\":1,\"38\":\"\",\"39\":25,\"40\":13,\"41\":1,\"44\":\"\",\"45\":\"Siva\",\"46\":\"Pradhosh\",\"47\":\"963\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"613\":\"\",\"615\":\"\",\"616\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "22.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5478", "jd_createddate": 1746662400, "jd_orderdate": null, "jd_duedate": 1746662400, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1746684772, "jd_updatedat": 1746690001 }, { "jd_id": 5479, "jd_customerid": 3876, "jd_contactid": 4050, "jd_additionalcontacts": "4050", "jd_templateid": 1, "jd_jobmultiquoteid": 5504, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5499", "jd_jobstatus": 11, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "BLIN0002", "jd_invoiceno": "", "jd_listprice": "356.00", "jd_netprice": "356.00", "jd_vat": "78.32", "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": "434.32", "jd_grossprofit": "178.00", "jd_costprice": "178.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "434.32", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": null, "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 1, "jd_updatedby": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "22.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5499\",\"35\":\"BLIN0002\",\"36\":11,\"37\":1,\"38\":\"\",\"39\":25,\"40\":13,\"41\":1,\"44\":\"Blinds \",\"45\":\"Joesph\",\"46\":\"K\",\"47\":\"\",\"48\":\"\",\"49\":\"Zoological Garden @12\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":1,\"286\":\"85663224711\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"613\":\"\",\"615\":\"\",\"616\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "22.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5479", "jd_createddate": 1746662400, "jd_orderdate": null, "jd_duedate": 1746662400, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1746691284, "jd_updatedat": 1746691780 } ], "deleted": [] }, "bm_orderitem": { "created": [ { "oi_id": 30977, "oi_jobid": 5470, "oi_jobtempid": "0", "oi_jobmultiquoteid": 5495, "oi_productid": 6, "oi_recipeid": 6, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":6885,\"labelname\":\"Unit Type\",\"value\":4,\"valueid\":\"4\",\"type\":34,\"optionid\":4,\"optionvalue\":[{\"optionid\":4,\"optionname\":\"Inches\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":4,\"forchildfieldoptionlinkid\":\"34_4\"}],\"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\":6885,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":4,\"optionsvalue\":[{\"optionid\":4,\"optionname\":\"Inches\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":4,\"forchildfieldoptionlinkid\":\"34_4\"}],\"editruleoverride\":0},{\"id\":218,\"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\":1,\"fieldname\":\"Quantity\",\"fieldid\":218,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":219,\"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\":219,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":222,\"labelname\":\"Frame colour\",\"value\":\"White\",\"valueid\":\"626\",\"type\":3,\"optionid\":\"456\",\"optionvalue\":[{\"optionid\":456,\"optionqty\":\"1\",\"optionname\":\"White\",\"optioncode\":\"15\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":626,\"forchildfieldoptionlinkid\":\"3_626\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"0.00\",\"costprice\":0,\"costwithdiscount\":0,\"customersellingprice\":0,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":0}],\"issubfabric\":0,\"labelnamecode\":\"Frame colour\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Frame colour\",\"fieldid\":222,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"456\",\"optionsvalue\":[{\"optionid\":456,\"optionqty\":\"1\",\"optionname\":\"White\",\"optioncode\":\"15\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":626,\"forchildfieldoptionlinkid\":\"3_626\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"0.00\",\"costprice\":0,\"costwithdiscount\":0,\"customersellingprice\":0,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":0}],\"editruleoverride\":1},{\"id\":4693,\"labelname\":\"Fitting Height\",\"value\":null,\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fitting HeightFh2\",\"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\":6,\"mandatory\":0,\"fieldname\":\"Fitting Height\",\"fieldid\":4693,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Frame colour: White", "oi_reportdescription": "##Quantity: 1##,##Frame colour: White##", "oi_reporttitles": "##Quantity:<\/br>##Frame colour:", "oi_productionformulajsondata": "[{\"formula\":\"noFormula\",\"stockupdate\":0,\"isdelete\":0,\"fieldtype_id\":3,\"fractionvalue\":null}]", "oi_operationstatus": "", "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": "[]", "oi_productionstatus": null, "oi_costoverride": 1, "oi_costprice": "100.000", "oi_netprice": "100.000", "oi_pricesfromoperations": null, "oi_vatprice": "20.000", "oi_vatvalue": "20.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "120.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": 30963, "oi_isonlineorder": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "100.000", "oi_endcustomeroverridevatprice": "20.000", "oi_endcustomeroverridegrossprice": "120.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[6885, 218, 219, 222, 4693]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "30977", "oi_productiondate": 1746703282, "oi_createdat": 1746703282, "oi_updatedat": 1746683484, "oi_createdby": 1, "oi_updatedby": null }, { "oi_id": 30978, "oi_jobid": 5471, "oi_jobtempid": "0", "oi_jobmultiquoteid": 5496, "oi_productid": 6, "oi_recipeid": 6, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":6885,\"labelname\":\"Unit Type\",\"value\":4,\"valueid\":\"4\",\"type\":34,\"optionid\":4,\"optionvalue\":[{\"optionid\":4,\"optionname\":\"Inches\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":4,\"forchildfieldoptionlinkid\":\"34_4\"}],\"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\":6885,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":4,\"optionsvalue\":[{\"optionid\":4,\"optionname\":\"Inches\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":4,\"forchildfieldoptionlinkid\":\"34_4\"}],\"editruleoverride\":0},{\"id\":218,\"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\":1,\"fieldname\":\"Quantity\",\"fieldid\":218,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":219,\"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\":219,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":222,\"labelname\":\"Frame colour\",\"value\":\"White\",\"valueid\":\"626\",\"type\":3,\"optionid\":\"456\",\"optionvalue\":[{\"optionid\":456,\"optionqty\":\"1\",\"optionname\":\"White\",\"optioncode\":\"15\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":626,\"forchildfieldoptionlinkid\":\"3_626\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"0.00\",\"costprice\":0,\"costwithdiscount\":0,\"customersellingprice\":0,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":0}],\"issubfabric\":0,\"labelnamecode\":\"Frame colour\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Frame colour\",\"fieldid\":222,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"456\",\"optionsvalue\":[{\"optionid\":456,\"optionqty\":\"1\",\"optionname\":\"White\",\"optioncode\":\"15\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":626,\"forchildfieldoptionlinkid\":\"3_626\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"0.00\",\"costprice\":0,\"costwithdiscount\":0,\"customersellingprice\":0,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":0}],\"editruleoverride\":1},{\"id\":4693,\"labelname\":\"Fitting Height\",\"value\":null,\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fitting HeightFh2\",\"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\":6,\"mandatory\":0,\"fieldname\":\"Fitting Height\",\"fieldid\":4693,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Frame colour: White", "oi_reportdescription": "##Quantity: 1##,##Frame colour: White##", "oi_reporttitles": "##Quantity:<\/br>##Frame colour:", "oi_productionformulajsondata": "[{\"formula\":\"noFormula\",\"stockupdate\":0,\"isdelete\":0,\"fieldtype_id\":3,\"fractionvalue\":null}]", "oi_operationstatus": "", "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": "[]", "oi_productionstatus": null, "oi_costoverride": 1, "oi_costprice": "100.000", "oi_netprice": "100.000", "oi_pricesfromoperations": null, "oi_vatprice": "20.000", "oi_vatvalue": "20.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "120.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": 30963, "oi_isonlineorder": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "100.000", "oi_endcustomeroverridevatprice": "20.000", "oi_endcustomeroverridegrossprice": "120.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[6885, 218, 219, 222, 4693]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "30978", "oi_productiondate": 1746706751, "oi_createdat": 1746706751, "oi_updatedat": 1746686954, "oi_createdby": 1, "oi_updatedby": null }, { "oi_id": 30979, "oi_jobid": 5472, "oi_jobtempid": "0", "oi_jobmultiquoteid": 5497, "oi_productid": 18, "oi_recipeid": 18, "oi_ruleid": 0, "oi_qty": 2, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":6894,\"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\":6894,\"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\":4694,\"labelname\":\"Quantity\",\"value\":\"2\",\"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\":4694,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":4695,\"labelname\":\"Supplier\",\"value\":\"14\",\"valueid\":null,\"type\":17,\"optionid\":\"14\",\"optionvalue\":[{\"id\":14,\"optionid\":14,\"optionname\":\"AQ Blinds\",\"deleted\":0,\"optionquantity\":1}],\"issubfabric\":0,\"labelnamecode\":\"Supplierroll23\",\"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\":4695,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"14\",\"optionsvalue\":[{\"id\":14,\"optionid\":14,\"optionname\":\"AQ Blinds\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":4696,\"labelname\":\"Location\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Location\",\"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\":\"Location\",\"fieldid\":4696,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4697,\"labelname\":\"Width\",\"value\":\"1000\",\"valueid\":null,\"type\":11,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Widthroll21\",\"fabricorcolor\":0,\"widthfraction\":\"0___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\":4697,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":4698,\"labelname\":\"Drop\",\"value\":\"2000\",\"valueid\":null,\"type\":12,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"DropRoll22\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":\"0___0\",\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":12,\"mandatory\":0,\"fieldname\":\"Drop\",\"fieldid\":4698,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":6878,\"labelname\":\"Fitting height\",\"value\":null,\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fitting heightosihc\",\"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\":6,\"mandatory\":0,\"fieldname\":\"Fitting height\",\"fieldid\":6878,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4699,\"labelname\":\"Product Type\",\"value\":\"387\",\"valueid\":\"464\",\"type\":13,\"optionid\":\"387\",\"optionvalue\":[{\"id\":464,\"fieldid\":4699,\"fieldoptionlinkid\":464,\"optionid\":387,\"mainsupplier\":\"14\",\"blindtypecode\":null,\"optionname\":\"Price group B fabric\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"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\":4699,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"387\",\"optionsvalue\":[{\"id\":464,\"fieldid\":4699,\"fieldoptionlinkid\":464,\"optionid\":387,\"mainsupplier\":\"14\",\"blindtypecode\":null,\"optionname\":\"Price group B fabric\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"editruleoverride\":1},{\"id\":4711,\"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\":4711,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4700,\"labelname\":\"Fabric Roll\",\"value\":\"Standard Roll Fabric\",\"valueid\":\"6310\",\"type\":3,\"optionid\":\"1133\",\"optionvalue\":[{\"optionid\":1133,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR01\",\"optionname\":\"Standard Roll Fabric\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":6310,\"forchildfieldoptionlinkid\":\"3_6310\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"issubfabric\":0,\"labelnamecode\":\"Fabric Roll\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Fabric Roll\",\"fieldid\":4700,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"1133\",\"optionsvalue\":[{\"optionid\":1133,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR01\",\"optionname\":\"Standard Roll Fabric\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":6310,\"forchildfieldoptionlinkid\":\"3_6310\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"editruleoverride\":0},{\"id\":4701,\"labelname\":\"Fitting\",\"value\":\"Face Fit Blind\",\"valueid\":\"6312\",\"type\":3,\"optionid\":\"1135\",\"optionvalue\":[{\"optionid\":1135,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR03\",\"optionname\":\"Face Fit Blind\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":6312,\"forchildfieldoptionlinkid\":\"3_6312\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"0.00\",\"costprice\":0,\"costwithdiscount\":0,\"customersellingprice\":0,\"customermarkupvalue\":2.2,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":0}],\"issubfabric\":0,\"labelnamecode\":\"Fitting\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Fitting\",\"fieldid\":4701,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"1135\",\"optionsvalue\":[{\"optionid\":1135,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR03\",\"optionname\":\"Face Fit Blind\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":6312,\"forchildfieldoptionlinkid\":\"3_6312\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"0.00\",\"costprice\":0,\"costwithdiscount\":0,\"customersellingprice\":0,\"customermarkupvalue\":2.2,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":0}],\"editruleoverride\":0},{\"id\":4702,\"labelname\":\"Operation side\",\"value\":\"Right Hand\",\"valueid\":\"6314\",\"type\":3,\"optionid\":\"1137\",\"optionvalue\":[{\"optionid\":1137,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR05\",\"optionname\":\"Right Hand\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":6314,\"forchildfieldoptionlinkid\":\"3_6314\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"issubfabric\":0,\"labelnamecode\":\"Operation sidevvry\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Operation side\",\"fieldid\":4702,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"1137\",\"optionsvalue\":[{\"optionid\":1137,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR05\",\"optionname\":\"Right Hand\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":6314,\"forchildfieldoptionlinkid\":\"3_6314\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"editruleoverride\":0},{\"id\":4703,\"labelname\":\"Roller tube\",\"value\":\"White 40mm Components And Steel Coated Brackets\",\"valueid\":\"6316\",\"type\":3,\"optionid\":\"1139\",\"optionvalue\":[{\"optionid\":1139,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR07\",\"optionname\":\"White 40mm Components And Steel Coated Brackets\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":6316,\"forchildfieldoptionlinkid\":\"3_6316\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"issubfabric\":0,\"labelnamecode\":\"Roller tube\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Roller tube\",\"fieldid\":4703,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"1139\",\"optionsvalue\":[{\"optionid\":1139,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR07\",\"optionname\":\"White 40mm Components And Steel Coated Brackets\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":6316,\"forchildfieldoptionlinkid\":\"3_6316\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"editruleoverride\":0},{\"id\":4704,\"labelname\":\"Chain Colour\",\"value\":\"Chrome complete With Child Safety Connector,White complete With Child Safety Connector,Black complete with child safety connector,Light Grey complete With Child Safety Connector,Beige complete With Child Safety Connector\",\"valueid\":\"6329,6330,6331,6332,6333\",\"type\":3,\"optionid\":\"1152,1153,1154,1155,1156\",\"optionvalue\":[{\"optionid\":1152,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR20\",\"optionname\":\"Chrome complete With Child Safety Connector\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":2,\"fieldoptionlinkid\":6329,\"forchildfieldoptionlinkid\":\"3_6329\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"2.00\",\"costprice\":2,\"costwithdiscount\":2,\"customersellingprice\":2,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":2},{\"optionid\":1153,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR21\",\"optionname\":\"White complete With Child Safety Connector\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":6330,\"forchildfieldoptionlinkid\":\"3_6330\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":1154,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR22\",\"optionname\":\"Black complete with child safety connector\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":6331,\"forchildfieldoptionlinkid\":\"3_6331\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":1155,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR23\",\"optionname\":\"Light Grey complete With Child Safety Connector\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":6332,\"forchildfieldoptionlinkid\":\"3_6332\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":1156,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR24\",\"optionname\":\"Beige complete With Child Safety Connector\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":6333,\"forchildfieldoptionlinkid\":\"3_6333\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"issubfabric\":0,\"labelnamecode\":\"Chain Colour\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1,1,1,1,1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Chain Colour\",\"fieldid\":4704,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"1152,1153,1154,1155,1156\",\"optionsvalue\":[{\"optionid\":1152,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR20\",\"optionname\":\"Chrome complete With Child Safety Connector\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":2,\"fieldoptionlinkid\":6329,\"forchildfieldoptionlinkid\":\"3_6329\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"2.00\",\"costprice\":2,\"costwithdiscount\":2,\"customersellingprice\":2,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":2},{\"optionid\":1153,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR21\",\"optionname\":\"White complete With Child Safety Connector\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":6330,\"forchildfieldoptionlinkid\":\"3_6330\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":1154,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR22\",\"optionname\":\"Black complete with child safety connector\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":6331,\"forchildfieldoptionlinkid\":\"3_6331\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":1155,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR23\",\"optionname\":\"Light Grey complete With Child Safety Connector\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":6332,\"forchildfieldoptionlinkid\":\"3_6332\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":1156,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR24\",\"optionname\":\"Beige complete With Child Safety Connector\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":6333,\"forchildfieldoptionlinkid\":\"3_6333\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"editruleoverride\":1},{\"id\":4705,\"labelname\":\"Fixing Plate\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fixing Plate\",\"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\":\"Fixing Plate\",\"fieldid\":4705,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4706,\"labelname\":\"Fascia\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fascia\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Fascia\",\"fieldid\":4706,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4707,\"labelname\":\"Bottom Bars\",\"value\":\"Sewn In Bottom Bar\",\"valueid\":\"6356\",\"type\":3,\"optionid\":\"1179\",\"optionvalue\":[{\"optionid\":1179,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR47\",\"optionname\":\"Sewn In Bottom Bar\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":6356,\"forchildfieldoptionlinkid\":\"3_6356\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"issubfabric\":0,\"labelnamecode\":\"Bottom Bars\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Bottom Bars\",\"fieldid\":4707,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"1179\",\"optionsvalue\":[{\"optionid\":1179,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR47\",\"optionname\":\"Sewn In Bottom Bar\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":6356,\"forchildfieldoptionlinkid\":\"3_6356\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"editruleoverride\":0},{\"id\":4708,\"labelname\":\"Motor\",\"value\":\"Somfy Soness 28 WF RTS Li lon Wirefree Motor,Somfy Soness Ultra 30WF RTS Li ion Wirefree Motor,Somfy Soness 40 IO 230v Motor 1001573,Somfy Soness 40 RTS 230v Motor 1001573,Somfy WT 230v Hard Wired Motor 1001547,Rts Yewdale Motor,Louvolite One Touch Motor,Louvolite 35mm AC Hardwired 6000 Series\",\"valueid\":\"6365,6366,21990,6367,6368,6369,6370,6371\",\"type\":3,\"optionid\":\"1188,1189,2610,1190,1191,1192,1193,1194\",\"optionvalue\":[{\"optionid\":1188,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR54\",\"optionname\":\"Somfy Soness 28 WF RTS Li lon Wirefree Motor\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":null,\"unitcost\":82,\"fieldoptionlinkid\":6365,\"forchildfieldoptionlinkid\":\"3_6365\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"164.00\",\"costprice\":82,\"costwithdiscount\":82,\"customersellingprice\":164,\"customermarkupvalue\":2,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":82},{\"optionid\":1189,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR55\",\"optionname\":\"Somfy Soness Ultra 30WF RTS Li ion Wirefree Motor\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":null,\"unitcost\":89.9,\"fieldoptionlinkid\":6366,\"forchildfieldoptionlinkid\":\"3_6366\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"179.80\",\"costprice\":89.9,\"costwithdiscount\":89.9,\"customersellingprice\":179.8,\"customermarkupvalue\":2,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":89.9},{\"optionid\":2610,\"optionqty\":\"1\",\"description\":\"Somfy Soness 40 IO 230v Motor 1001573\",\"optioncode\":null,\"optionname\":\"Somfy Soness 40 IO 230v Motor 1001573\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":null,\"unitcost\":152,\"fieldoptionlinkid\":21990,\"forchildfieldoptionlinkid\":\"3_21990\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"304.00\",\"costprice\":152,\"costwithdiscount\":152,\"customersellingprice\":304,\"customermarkupvalue\":2,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":152},{\"optionid\":1190,\"optionqty\":\"1\",\"description\":\"Somfy Soness 40 RTS 230v Motor 1001573\",\"optioncode\":\"AQR56\",\"optionname\":\"Somfy Soness 40 RTS 230v Motor 1001573\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":null,\"unitcost\":152,\"fieldoptionlinkid\":6367,\"forchildfieldoptionlinkid\":\"3_6367\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"304.00\",\"costprice\":152,\"costwithdiscount\":152,\"customersellingprice\":304,\"customermarkupvalue\":2,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":152},{\"optionid\":1191,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR57\",\"optionname\":\"Somfy WT 230v Hard Wired Motor 1001547\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":null,\"unitcost\":152,\"fieldoptionlinkid\":6368,\"forchildfieldoptionlinkid\":\"3_6368\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"304.00\",\"costprice\":152,\"costwithdiscount\":152,\"customersellingprice\":304,\"customermarkupvalue\":2,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":152},{\"optionid\":1192,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR58\",\"optionname\":\"Rts Yewdale Motor\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":null,\"unitcost\":64,\"fieldoptionlinkid\":6369,\"forchildfieldoptionlinkid\":\"3_6369\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"128.00\",\"costprice\":64,\"costwithdiscount\":64,\"customersellingprice\":128,\"customermarkupvalue\":2,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":64},{\"optionid\":1193,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR59\",\"optionname\":\"Louvolite One Touch Motor\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":null,\"unitcost\":39.77,\"fieldoptionlinkid\":6370,\"forchildfieldoptionlinkid\":\"3_6370\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"79.54\",\"costprice\":39.77,\"costwithdiscount\":39.77,\"customersellingprice\":79.54,\"customermarkupvalue\":2,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":39.77},{\"optionid\":1194,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR60\",\"optionname\":\"Louvolite 35mm AC Hardwired 6000 Series\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":null,\"unitcost\":75,\"fieldoptionlinkid\":6371,\"forchildfieldoptionlinkid\":\"3_6371\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"150.00\",\"costprice\":75,\"costwithdiscount\":75,\"customersellingprice\":150,\"customermarkupvalue\":2,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":75}],\"issubfabric\":0,\"labelnamecode\":\"Motor\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1,1,1,1,1,1,1,1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Motor\",\"fieldid\":4708,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"1188,1189,2610,1190,1191,1192,1193,1194\",\"optionsvalue\":[{\"optionid\":1188,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR54\",\"optionname\":\"Somfy Soness 28 WF RTS Li lon Wirefree Motor\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":null,\"unitcost\":82,\"fieldoptionlinkid\":6365,\"forchildfieldoptionlinkid\":\"3_6365\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"164.00\",\"costprice\":82,\"costwithdiscount\":82,\"customersellingprice\":164,\"customermarkupvalue\":2,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":82},{\"optionid\":1189,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR55\",\"optionname\":\"Somfy Soness Ultra 30WF RTS Li ion Wirefree Motor\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":null,\"unitcost\":89.9,\"fieldoptionlinkid\":6366,\"forchildfieldoptionlinkid\":\"3_6366\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"179.80\",\"costprice\":89.9,\"costwithdiscount\":89.9,\"customersellingprice\":179.8,\"customermarkupvalue\":2,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":89.9},{\"optionid\":2610,\"optionqty\":\"1\",\"description\":\"Somfy Soness 40 IO 230v Motor 1001573\",\"optioncode\":null,\"optionname\":\"Somfy Soness 40 IO 230v Motor 1001573\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":null,\"unitcost\":152,\"fieldoptionlinkid\":21990,\"forchildfieldoptionlinkid\":\"3_21990\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"304.00\",\"costprice\":152,\"costwithdiscount\":152,\"customersellingprice\":304,\"customermarkupvalue\":2,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":152},{\"optionid\":1190,\"optionqty\":\"1\",\"description\":\"Somfy Soness 40 RTS 230v Motor 1001573\",\"optioncode\":\"AQR56\",\"optionname\":\"Somfy Soness 40 RTS 230v Motor 1001573\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":null,\"unitcost\":152,\"fieldoptionlinkid\":6367,\"forchildfieldoptionlinkid\":\"3_6367\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"304.00\",\"costprice\":152,\"costwithdiscount\":152,\"customersellingprice\":304,\"customermarkupvalue\":2,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":152},{\"optionid\":1191,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR57\",\"optionname\":\"Somfy WT 230v Hard Wired Motor 1001547\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":null,\"unitcost\":152,\"fieldoptionlinkid\":6368,\"forchildfieldoptionlinkid\":\"3_6368\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"304.00\",\"costprice\":152,\"costwithdiscount\":152,\"customersellingprice\":304,\"customermarkupvalue\":2,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":152},{\"optionid\":1192,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR58\",\"optionname\":\"Rts Yewdale Motor\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":null,\"unitcost\":64,\"fieldoptionlinkid\":6369,\"forchildfieldoptionlinkid\":\"3_6369\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"128.00\",\"costprice\":64,\"costwithdiscount\":64,\"customersellingprice\":128,\"customermarkupvalue\":2,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":64},{\"optionid\":1193,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR59\",\"optionname\":\"Louvolite One Touch Motor\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":null,\"unitcost\":39.77,\"fieldoptionlinkid\":6370,\"forchildfieldoptionlinkid\":\"3_6370\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"79.54\",\"costprice\":39.77,\"costwithdiscount\":39.77,\"customersellingprice\":79.54,\"customermarkupvalue\":2,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":39.77},{\"optionid\":1194,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR60\",\"optionname\":\"Louvolite 35mm AC Hardwired 6000 Series\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":null,\"unitcost\":75,\"fieldoptionlinkid\":6371,\"forchildfieldoptionlinkid\":\"3_6371\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"150.00\",\"costprice\":75,\"costwithdiscount\":75,\"customersellingprice\":150,\"customermarkupvalue\":2,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":75}],\"editruleoverride\":1},{\"id\":4709,\"labelname\":\"Special options\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Special options\",\"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\":\"Special options\",\"fieldid\":4709,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4710,\"labelname\":\"Special Instructions\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Special Instructions\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Special Instructions\",\"fieldid\":4710,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7248,\"labelname\":\"Crank control\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Crank controlidsjcn\",\"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\":\"Crank control\",\"fieldid\":7248,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Supplier: AQ Blinds, Width: 1000, Drop: 2000, Product Type: Price group B fabric, Fabric Roll: Standard Roll Fabric, Fitting: Face Fit Blind, Operation side: Right Hand, Roller tube: White 40mm Components And Steel Coated Brackets, Chain Colour: Chrome complete With Child Safety Connector,White complete With Child Safety Connector,Black complete with child safety connector,Light Grey complete With Child Safety Connector,Beige complete With Child Safety Connector, Bottom Bars: Sewn In Bottom Bar, Motor: Somfy Soness 28 WF RTS Li lon Wirefree Motor,Somfy Soness Ultra 30WF RTS Li ion Wirefree Motor,Somfy Soness 40 IO 230v Motor 1001573,Somfy Soness 40 RTS 230v Motor 1001573,Somfy WT 230v Hard Wired Motor 1001547,Rts Yewdale Motor,Louvolite One Touch Motor,Louvolite 35mm AC Hardwired 6000 Series", "oi_reportdescription": "##Quantity: 2##,##Supplier: AQ Blinds##,##Width: 1000 mm##,##Drop: 2000 mm##,##Product Type: Price group B fabric##,##Fabric Roll: Standard Roll Fabric##,##Fitting: Face Fit Blind##,##Operation side: Right Hand##,##Roller tube: White 40mm Components And Steel Coated Brackets##,##Chain Colour: Chrome complete With Child Safety Connector,White complete With Child Safety Connector,Black complete with child safety connector,Light Grey complete With Child Safety Connector,Beige complete With Child Safety Connector##,##Bottom Bars: Sewn In Bottom Bar##,##Motor: Somfy Soness 28 WF RTS Li lon Wirefree Motor,Somfy Soness Ultra 30WF RTS Li ion Wirefree Motor,Somfy Soness 40 IO 230v Motor 1001573,Somfy Soness 40 RTS 230v Motor 1001573,Somfy WT 230v Hard Wired Motor 1001547,Rts Yewdale Motor,Louvolite One Touch Motor,Louvolite 35mm AC Hardwired 6000 Series##", "oi_reporttitles": "##Quantity:<\/br>##Supplier:<\/br>##Width:<\/br>##Drop:<\/br>##Product Type:<\/br>##Fabric Roll:<\/br>##Fitting:<\/br>##Operation side:<\/br>##Roller tube:<\/br>##Chain Colour:<\/br>##Bottom Bars:<\/br>##Motor:", "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\":5,\"value\":\"970.00\",\"formula\":\"Widthroll21-30\",\"price\":\"-\",\"recipeid\":18,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"970.00\"},{\"productionoveride\":0,\"id\":6,\"value\":\"960.00\",\"formula\":\"Widthroll21-40\",\"price\":\"-\",\"recipeid\":18,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"960.00\"},{\"productionoveride\":0,\"id\":7,\"value\":\"2300.00\",\"formula\":\"DropRoll22+300\",\"price\":\"-\",\"recipeid\":18,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"2300.00\"},{\"productionoveride\":0,\"id\":10,\"value\":\"2.00\",\"formula\":\"Round((DropRoll22+DropAllowance)\\\/1000)\",\"price\":\"-\",\"recipeid\":18,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"2.00\"},{\"formula\":\"noFormula\",\"stockupdate\":0,\"isdelete\":0,\"fieldtype_id\":3,\"fractionvalue\":null},{\"formula\":\"noFormula\",\"stockupdate\":0,\"isdelete\":0,\"fieldtype_id\":3,\"fractionvalue\":null},{\"formula\":\"noFormula\",\"stockupdate\":0,\"isdelete\":0,\"fieldtype_id\":3,\"fractionvalue\":null},{\"formula\":\"noFormula\",\"stockupdate\":0,\"isdelete\":0,\"fieldtype_id\":3,\"fractionvalue\":null},{\"formula\":\"noFormula\",\"stockupdate\":0,\"isdelete\":0,\"fieldtype_id\":3,\"fractionvalue\":null},{\"formula\":\"noFormula\",\"stockupdate\":0,\"isdelete\":0,\"fieldtype_id\":3,\"fractionvalue\":null},{\"formula\":\"noFormula\",\"stockupdate\":0,\"isdelete\":0,\"fieldtype_id\":3,\"fractionvalue\":null},{\"formula\":\"noFormula\",\"stockupdate\":0,\"isdelete\":0,\"fieldtype_id\":3,\"fractionvalue\":null},{\"formula\":\"noFormula\",\"stockupdate\":0,\"isdelete\":0,\"fieldtype_id\":3,\"fractionvalue\":null},{\"formula\":\"noFormula\",\"stockupdate\":0,\"isdelete\":0,\"fieldtype_id\":3,\"fractionvalue\":null}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"0.00\",\"cost_with_discount\":\"0.00\",\"cost_with_markup\":\"0.00\",\"gross_price\":\"0.00\",\"vat_price\":\"0.00\"}", "oi_pricecomesfrom_calculations": "{\"label\":\"Price table cost\",\"unit_type\":\"-\",\"cost_price\":\"96.00\",\"show_hide\":true,\"category\":3}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "1713.340", "oi_netprice": "3441.880", "oi_pricesfromoperations": null, "oi_vatprice": "757.210", "oi_vatvalue": "22.000", "oi_vatselected": 2, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "4199.090", "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": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "3441.880", "oi_endcustomeroverridevatprice": "757.210", "oi_endcustomeroverridegrossprice": "4199.090", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[6894, 4694, 4695, 4696, 4697, 4698, 6878, 4699, 4711, 4700, 4701, 4702, 4703, 4704, 4705, 4706, 4707, 4708, 4709, 4710, 7248]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "30979", "oi_productiondate": 1746662400, "oi_createdat": 1746707281, "oi_updatedat": 1746687554, "oi_createdby": 8, "oi_updatedby": 8 }, { "oi_id": 30984, "oi_jobid": 5479, "oi_jobtempid": "0", "oi_jobmultiquoteid": 5504, "oi_productid": 29, "oi_recipeid": 31, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 0, "oi_customseq": 0, "oi_productcustomseq": 0, "oi_jsondata": "[{\"id\":6901,\"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\":6350,\"labelname\":\"Supplier\",\"value\":\"18\",\"valueid\":\"\",\"type\":17,\"optionid\":\"18\",\"optionvalue\":[{\"id\":18,\"optionid\":18,\"optionname\":\"C & P Security\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":6879,\"labelname\":\"Location\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":6351,\"labelname\":\"Awning system\",\"value\":\"Markilux MX3,Markilux MX4\",\"valueid\":\"20404,20405\",\"type\":3,\"optionid\":\"2268,2269\",\"optionvalue\":[{\"optionid\":2268,\"optionname\":\"Markilux MX3\",\"description\":\"Markilux MX3\",\"optioncode\":\"sdvcklm\",\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":20404,\"forchildfieldoptionlinkid\":\"3_20404\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"},{\"optionid\":2269,\"optionname\":\"Markilux MX4\",\"description\":\"Markilux MX4\",\"optioncode\":\"knmdv\",\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":20405,\"forchildfieldoptionlinkid\":\"3_20405\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1,1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":6352,\"labelname\":\"Bracket colour\",\"value\":\"Frame finish in 5215 Stone Grey metallic,Frame finish in 5229 Havana Braun\",\"valueid\":\"20419,20420\",\"type\":3,\"optionid\":\"1863,1861\",\"optionvalue\":[{\"optionid\":1863,\"optionname\":\"Frame finish in 5215 Stone Grey metallic\",\"description\":\"Frame finish in 5215 Stone Grey metallic \",\"optioncode\":\"fcf\",\"pricegroups\":\"Fabric collection one,Fabric Collection Two\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":20419,\"forchildfieldoptionlinkid\":\"3_20419\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"},{\"optionid\":1861,\"optionname\":\"Frame finish in 5229 Havana Braun\",\"description\":\"Frame finish in 5229 Havana Braun\",\"optioncode\":\"fcf\",\"pricegroups\":\"Fabric collection one,Fabric Collection Two\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":20420,\"forchildfieldoptionlinkid\":\"3_20420\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1,1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":6353,\"labelname\":\"Bracket type\",\"value\":\"Spreader plate 60mm x 60mm\",\"valueid\":\"20429\",\"type\":3,\"optionid\":\"2283\",\"optionvalue\":[{\"optionid\":2283,\"optionname\":\"Spreader plate 60mm x 60mm\",\"description\":\"Spreader plate 60mm x 60mm\",\"optioncode\":\"kpndv\",\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":89,\"pricingtype\":\"\",\"fieldoptionlinkid\":20429,\"forchildfieldoptionlinkid\":\"3_20429\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":4,\"optionimage\":\"\",\"reportprice\":\"178.00\",\"fieldid\":20429}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":6357,\"labelname\":\"Standard Fig A\",\"value\":\"\",\"valueid\":\"\",\"type\":6,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":6358,\"labelname\":\"Standard Fig B\",\"value\":\"\",\"valueid\":\"\",\"type\":6,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":6359,\"labelname\":\"Standard Fig C\",\"value\":\"\",\"valueid\":\"\",\"type\":6,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":6364,\"labelname\":\"Add Galvanising\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":6413,\"labelname\":\"Product Type\",\"value\":435,\"valueid\":\"530\",\"type\":13,\"optionid\":\"435\",\"optionvalue\":[{\"id\":530,\"fieldid\":6413,\"fieldoptionlinkid\":530,\"optionid\":435,\"mainsupplier\":\"18\",\"blindtypecode\":\"10000\",\"optionname\":\"10000\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":7399,\"labelname\":\"Extras\",\"value\":\"DC2\",\"valueid\":\"22118\",\"type\":3,\"optionid\":\"2648\",\"optionvalue\":[{\"optionid\":2648,\"optionname\":\"DC2\",\"description\":\"\",\"optioncode\":\"\",\"pricegroups\":\"10000\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":22118,\"forchildfieldoptionlinkid\":\"3_22118\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":22118}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":6349,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]", "oi_description": "Unit Type: Inches, Supplier: C & P Security, Awning system: Markilux MX3,Markilux MX4, Bracket colour: Frame finish in 5215 Stone Grey metallic,Frame finish in 5229 Havana Braun, Bracket type: Spreader plate 60mm x 60mm, Product Type: 10000, Extras: DC2, Quantity: 1", "oi_reportdescription": "##Supplier: C & P Security##,##Awning system: Markilux MX3,Markilux MX4##,##Bracket colour: Frame finish in 5215 Stone Grey metallic,Frame finish in 5229 Havana Braun##,##Bracket type: Spreader plate 60mm x 60mm##,##Product Type: 10000##,##Extras: DC2##,##Quantity: 1##", "oi_reporttitles": "##Supplier:##Awning system:##Bracket colour:##Bracket type:##Product Type:##Extras:##Quantity:", "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": "89.000", "oi_netprice": "178.000", "oi_pricesfromoperations": null, "oi_vatprice": "39.160", "oi_vatvalue": "22.000", "oi_vatselected": 2, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "217.160", "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": "[6901, 6350, 6879, 6351, 6352, 6353, 6357, 6358, 6359, 6364, 6413, 7399, 6349]", "oi_deviceplatform": 1, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "30984", "oi_productiondate": 1746691435, "oi_createdat": 1746691486, "oi_updatedat": 1746691779, "oi_createdby": 1, "oi_updatedby": null }, { "oi_id": 30985, "oi_jobid": 5479, "oi_jobtempid": "0", "oi_jobmultiquoteid": 5504, "oi_productid": 29, "oi_recipeid": 31, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 0, "oi_customseq": 0, "oi_productcustomseq": 0, "oi_jsondata": "[{\"id\":6901,\"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\":6350,\"labelname\":\"Supplier\",\"value\":\"18\",\"valueid\":\"\",\"type\":17,\"optionid\":\"18\",\"optionvalue\":[{\"id\":18,\"optionid\":18,\"optionname\":\"C & P Security\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":6879,\"labelname\":\"Location\",\"value\":\"2\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":6351,\"labelname\":\"Awning system\",\"value\":\"Markilux MX3,Markilux MX4\",\"valueid\":\"20404,20405\",\"type\":3,\"optionid\":\"2268,2269\",\"optionvalue\":[{\"optionid\":2268,\"optionname\":\"Markilux MX3\",\"description\":\"Markilux MX3\",\"optioncode\":\"sdvcklm\",\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":20404,\"forchildfieldoptionlinkid\":\"3_20404\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"},{\"optionid\":2269,\"optionname\":\"Markilux MX4\",\"description\":\"Markilux MX4\",\"optioncode\":\"knmdv\",\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":20405,\"forchildfieldoptionlinkid\":\"3_20405\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1,1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":6352,\"labelname\":\"Bracket colour\",\"value\":\"Frame finish in 5215 Stone Grey metallic,Frame finish in 5229 Havana Braun\",\"valueid\":\"20419,20420\",\"type\":3,\"optionid\":\"1863,1861\",\"optionvalue\":[{\"optionid\":1863,\"optionname\":\"Frame finish in 5215 Stone Grey metallic\",\"description\":\"Frame finish in 5215 Stone Grey metallic \",\"optioncode\":\"fcf\",\"pricegroups\":\"Fabric collection one,Fabric Collection Two\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":20419,\"forchildfieldoptionlinkid\":\"3_20419\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"},{\"optionid\":1861,\"optionname\":\"Frame finish in 5229 Havana Braun\",\"description\":\"Frame finish in 5229 Havana Braun\",\"optioncode\":\"fcf\",\"pricegroups\":\"Fabric collection one,Fabric Collection Two\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":20420,\"forchildfieldoptionlinkid\":\"3_20420\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1,1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":6353,\"labelname\":\"Bracket type\",\"value\":\"Spreader plate 60mm x 60mm\",\"valueid\":\"20429\",\"type\":3,\"optionid\":\"2283\",\"optionvalue\":[{\"optionid\":2283,\"optionname\":\"Spreader plate 60mm x 60mm\",\"description\":\"Spreader plate 60mm x 60mm\",\"optioncode\":\"kpndv\",\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":89,\"fieldoptionlinkid\":20429,\"forchildfieldoptionlinkid\":\"3_20429\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":4,\"optionimage\":\"\",\"reportprice\":\"178.00\",\"fieldid\":20429}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":6357,\"labelname\":\"Standard Fig A\",\"value\":\"\",\"valueid\":\"\",\"type\":6,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":6358,\"labelname\":\"Standard Fig B\",\"value\":\"\",\"valueid\":\"\",\"type\":6,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":6359,\"labelname\":\"Standard Fig C\",\"value\":\"\",\"valueid\":\"\",\"type\":6,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":6364,\"labelname\":\"Add Galvanising\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":6413,\"labelname\":\"Product Type\",\"value\":435,\"valueid\":\"530\",\"type\":13,\"optionid\":\"435\",\"optionvalue\":[{\"id\":530,\"fieldid\":6413,\"fieldoptionlinkid\":530,\"optionid\":435,\"mainsupplier\":\"18\",\"blindtypecode\":\"10000\",\"optionname\":\"10000\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":7399,\"labelname\":\"Extras\",\"value\":\"DC2\",\"valueid\":\"22118\",\"type\":3,\"optionid\":\"2648\",\"optionvalue\":[{\"optionid\":2648,\"optionname\":\"DC2\",\"description\":\"\",\"optioncode\":\"\",\"pricegroups\":\"10000\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22118,\"forchildfieldoptionlinkid\":\"3_22118\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":22118}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":6349,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"1\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]", "oi_description": "Unit Type: Inches, Supplier: C & P Security, Location: 2, Awning system: Markilux MX3,Markilux MX4, Bracket colour: Frame finish in 5215 Stone Grey metallic,Frame finish in 5229 Havana Braun, Bracket type: Spreader plate 60mm x 60mm, Extras: DC2, Quantity: 1", "oi_reportdescription": "##Supplier: C & P Security##,##Location: 2##,##Awning system: Markilux MX3,Markilux MX4##,##Bracket colour: Frame finish in 5215 Stone Grey metallic,Frame finish in 5229 Havana Braun##,##Bracket type: Spreader plate 60mm x 60mm##,##Extras: DC2##,##Quantity: 1##", "oi_reporttitles": "##Supplier:##Location:##Awning system:##Bracket colour:##Bracket type:##Extras:##Quantity:", "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": "89.000", "oi_netprice": "178.000", "oi_pricesfromoperations": null, "oi_vatprice": "39.160", "oi_vatvalue": "22.000", "oi_vatselected": 2, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "217.160", "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": "178.000", "oi_endcustomeroverridevatprice": "39.160", "oi_endcustomeroverridegrossprice": "217.160", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[6901, 6350, 6879, 6351, 6352, 6353, 6357, 6358, 6359, 6364, 6413, 7399, 6349]", "oi_deviceplatform": 1, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "30985", "oi_productiondate": 1746691435, "oi_createdat": 1746691506, "oi_updatedat": 1746691780, "oi_createdby": 1, "oi_updatedby": null } ], "updated": [], "deleted": [] }, "bm_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_notelist": { "created": [ { "nl_id": 104969, "nl_ordertempid": 0, "nl_orderid": 5479, "nl_notescategory": 1, "nl_type": 17, "nl_platform": 1, "nl_desc": "New job has been created in job", "nl_manualNotes": null, "nl_createdby": "1", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 0, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "104969", "nl_endddate": 1746662400, "nl_starttime": 1746691284, "created_at": 1746691284, "updated_at": 1746691779, "created_by": 1, "updated_by": null } ], "updated": [], "deleted": [] }, "bm_deliveryaddresssetting": { "created": [], "updated": [], "deleted": [] }, "bm_jobchecklist": { "created": [], "updated": [], "deleted": [] }, "bm_Invoice": { "created": [], "updated": [], "deleted": [] }, "bm_InvoiceDetails": { "created": [], "updated": [], "deleted": [] }, "bm_invoice_credit_note": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNote": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNoteDetails": { "created": [], "updated": [], "deleted": [] }, "bm_job_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_OverPayment": { "created": [], "updated": [], "deleted": [] }, "bm_terms": { "created": [], "updated": [], "deleted": [] }, "bm_jobmultiquote": { "created": [ { "jmq_id": 5504, "jmq_jobid": 5479, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "356.00", "jmq_netprice": "356.00", "jmq_vat": "78.32", "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": "434.32", "jmq_grossprofit": "0.00", "jmq_costprice": "178.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "434.32", "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": "22.000", "jmq_cdeliveryvatperc": "22.000", "id": "5504", "jmq_duedate": 1746662400, "jmq_sceduleddate": null, "jmq_createdat": "1746691284.000000", "jmq_updatedat": "1746691780.000000", "jmq_createdby": 1, "jmq_updatedby": 1 } ], "updated": [ { "jmq_id": 5503, "jmq_jobid": 5478, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "0.00", "jmq_netprice": "0.00", "jmq_vat": "0.00", "jmq_isvaton": 1, "jmq_deliverycost": "0.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 1, "jmq_orderformprice": "0.00", "jmq_editpricebyid": null, "jmq_isroundon": 0, "jmq_grossprice": "0.00", "jmq_grossprofit": "0.00", "jmq_costprice": "0.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "0.00", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": null, "jmq_deliverycostid": 0, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 0, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 0, "jmq_endcustomeroverridevalue": null, "jmq_endcustomeroverridenetprice": "0.00", "jmq_endcustomeroverridevatprice": "0.00", "jmq_endcustomeroverridegrossprice": "0.00", "jmq_endcustomerdeliverycost": null, "jmq_endcustomerdeliverycostinclvat": 0, "jmq_endcustomerfittingcost": null, "jmq_endcustomerfittingcostinclvat": 0, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "22.000", "jmq_cdeliveryvatperc": "22.000", "id": "5503", "jmq_duedate": 1746662400, "jmq_sceduleddate": null, "jmq_createdat": "1746684772.000000", "jmq_updatedat": "1746690001.000000", "jmq_createdby": 1, "jmq_updatedby": 1 }, { "jmq_id": 5504, "jmq_jobid": 5479, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "356.00", "jmq_netprice": "356.00", "jmq_vat": "78.32", "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": "434.32", "jmq_grossprofit": "0.00", "jmq_costprice": "178.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "434.32", "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": "22.000", "jmq_cdeliveryvatperc": "22.000", "id": "5504", "jmq_duedate": 1746662400, "jmq_sceduleddate": null, "jmq_createdat": "1746691284.000000", "jmq_updatedat": "1746691780.000000", "jmq_createdby": 1, "jmq_updatedby": 1 } ], "deleted": [] }, "bm_jobstatus_tracks": { "created": [ { "jst_id": 6075, "jst_jobid": 5478, "jst_job_current_status": 11, "id": "6075", "jst_createdat": "1746690001.367866" }, { "jst_id": 6076, "jst_jobid": 5479, "jst_job_current_status": 11, "id": "6076", "jst_createdat": "1746691779.764271" } ], "updated": [], "deleted": [] }, "bm_customindividuallogs": { "created": [ { "cl_id": 51878, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 5478, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5478, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"Aquarius Blinds\",\"\":13,\"Account Type\":\"Domestic\",\"Source\":\"Google\",\"Created By\":\"admin\",\"First Name\":\"Siva\",\"Last Name\":\"Pradhosh\",\"Mobile\":\"963\",\"Country\":\"Australia\",\"Salutation\":\"Mr.\",\"Assigned to\":1,\"Additional Contacts\":\"4049\",\"Production Due Date\":\"2025-05-07\",\"Job Ref No\":\"AQ5498\",\"Job Status\":\"Enquiry\",\"Order Status\":\"Enquiry\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"jd_isonlineorder\":1,\"Delivery Vat Percentage\":\"22.000\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":5478,\"jd_customerid\":3875,\"jd_contactid\":4049,\"jd_additionalcontacts\":\"4049\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"AQ5498\\\",\\\"35\\\":\\\"PRAD0002\\\",\\\"36\\\":11,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":25,\\\"40\\\":13,\\\"41\\\":1,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"Siva\\\",\\\"46\\\":\\\"Pradhosh\\\",\\\"47\\\":\\\"963\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":4,\\\"285\\\":1,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":1,\\\"558\\\":\\\"\\\",\\\"559\\\":1,\\\"610\\\":\\\"\\\",\\\"611\\\":\\\"\\\",\\\"612\\\":1,\\\"613\\\":\\\"\\\",\\\"615\\\":\\\"\\\",\\\"616\\\":\\\"\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-05-08\",\"jd_orderdate\":null,\"jd_duedate\":\"2025-05-07\",\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":null,\"jd_jobref\":\"AQ5498\",\"jd_jobstatus\":11,\"jd_contactaddid\":0,\"jd_orderstatus\":13,\"jd_accref\":\"PRAD0002\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"0.00\",\"jd_netprice\":\"0.00\",\"jd_vat\":\"0.00\",\"jd_isvaton\":1,\"jd_deliverycost\":\"0.00\",\"jd_deliverycosttypeid\":1,\"jd_overridetypeid\":1,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":null,\"jd_isroundon\":0,\"jd_grossprice\":\"0.00\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"0.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"0.00\",\"jd_totpaid\":\"0.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":null,\"jd_deliverycostid\":0,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":0,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":0,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":0,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":0,\"jd_organizationid\":0,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":1,\"jd_createdat\":\"2025-05-08T06:12:52.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-05-08T07:40:01.000000Z\",\"salesorderid\":null,\"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\":\"22.000\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"22.000\",\"jd_commission\":\"[]\",\"jd_commissionprice\":\"0.00\",\"jd_commissionsetting\":0,\"jd_commissionaddedvalue\":\"0.00\",\"jd_onlineprefixseq\":null,\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":0,\"jd_rework_count\":0}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "51878", "cl_createdat": "1746690001.000000", "cl_updatedat": null }, { "cl_id": 51879, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment", "cl_message": "new item has been created in Appointment", "cl_event": "created", "cl_subjectid": 9914, "cl_subjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_parentid": 9914, "cl_parentsubjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Repeat On\":\"yearly on May 08\",\"Description\":\"Live\",\"Private\":\"enabled\",\"Appointment Type\":\"Measurer\",\"Staff\":\"Abi\",\"Start Date & Time\":\"2025-05-08 05:30:17\",\"End Date & Time\":\"2025-05-08 06:30:17\",\"Uploaded Attachment\":\"[]\",\"Appointment Status\":\"sfsdfsdf123\",\"app_jobtimehour\":\"1\",\"app_deviceplatform\":1}", "cl_customproperties": "{\"attributes\":{\"app_eventid\":9914,\"app_description\":\"Live\",\"app_summary\":null,\"app_private\":1,\"app_appointmentType\":62,\"app_userId\":4,\"app_orderId\":0,\"app_customerId\":0,\"app_isAllDay\":0,\"app_sdate\":\"2025-05-08\",\"app_edate\":\"2025-05-08\",\"app_stime\":\"05:30:17\",\"app_etime\":\"06:30:17\",\"app_sdatetime\":\"2025-05-08 05:30:17\",\"app_edatetime\":\"2025-05-08 06:30:17\",\"app_timezone\":\"Asia\\\/Kolkata\",\"app_latitude\":0,\"app_longitude\":0,\"app_parentappid\":null,\"app_recurrencerule\":null,\"app_userdefinedValue\":\"[]\",\"app_recurrenceexception\":null,\"app_recurrenceexception_date\":null,\"app_attachment\":\"[]\",\"guid\":\"\",\"app_until\":null,\"app_staff\":\"\",\"app_appointtype\":\"\",\"app_confirmed\":0,\"app_coordinates\":\"\",\"app_travelHour\":\"0\",\"app_travelMinute\":\"0\",\"app_onsiteHour\":null,\"app_onsiteMinute\":null,\"app_location\":null,\"app_traveltime\":null,\"app_googleid\":\"0\",\"app_platform\":\"web\",\"app_cal_status\":809,\"app_status\":0,\"app_markasread\":0,\"app_statusInGoogle\":0,\"app_createdBy\":1,\"app_updatedBy\":null,\"app_createdAt\":\"2025-05-08T06:14:33.000000Z\",\"app_updatedAt\":\"2025-05-08T06:14:33.000000Z\",\"app_runid\":null,\"app_deliveryaddressid\":null,\"app_jobtimehour\":\"1\",\"app_jobtimeminute\":\"0\",\"app_products\":null,\"app_deviceplatform\":1}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "51879", "cl_createdat": "1746690001.000000", "cl_updatedat": null }, { "cl_id": 51880, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 104968, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 5478, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"Job Created\",\"Platform\":\"All Options\",\"Description\":\"New job has been created in job\",\"Created By\":\"admin\",\"Date\":\"2025-05-08\",\"Time\":\"06:12:52\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":104968,\"nl_ordertempid\":0,\"nl_orderid\":5478,\"nl_notescategory\":1,\"nl_type\":17,\"nl_platform\":1,\"nl_desc\":\"New job has been created in job\",\"nl_manualNotes\":null,\"nl_createdby\":\"1\",\"nl_endddate\":\"2025-05-08\",\"nl_starttime\":\"06:12:52\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":1,\"created_at\":\"2025-05-08T06:12:52.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-05-08T07:40:01.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "51880", "cl_createdat": "1746690001.000000", "cl_updatedat": null }, { "cl_id": 51881, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in AQ5498", "cl_event": "created", "cl_subjectid": 5503, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 5478, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":5503,\"jmq_jobid\":5478,\"Quotation Name\":\"Q1\",\"jmq_isdefault\":0,\"Quotation\":\"Accepted\",\"jmq_isdeclined\":0,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"Production Due Date\":\"0000-00-00\",\"List Price\":\"0.00\",\"Net Price\":\"0.00\",\"VAT Price\":\"0.00\",\"VAT\":1,\"jmq_deliverycost\":\"0.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"0.00\",\"Gross Profit\":\"0.00\",\"Total CostPrice\":\"0.00\",\"Amount Outstanding\":\"0.00\",\"Total Paid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_deliverycostid\":0,\"Total Cost Price\":0,\"jmq_isonlineorder\":0,\"Is Online Order Submitted\":0,\"End Customer Override Type\":0,\"End Customer Override Net Price\":\"0.00\",\"End Customer Override Vat Price\":\"0.00\",\"End Customer Override Gross Price\":\"0.00\",\"End Customer Delivery Cost Include Vat\":0,\"End Customer Fitting Cost Include Vat\":0,\"Online Delivery Addreddtype\":0,\"Commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"Delivery Vat Percentage\":\"22.000\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":5503,\"jmq_jobid\":5478,\"jmq_quotationname\":\"Q1\",\"jmq_isdefault\":0,\"jmq_isaccepted\":1,\"jmq_isdeclined\":0,\"jmq_esignflag\":null,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"jmq_duedate\":\"0000-00-00\",\"jmq_sceduleddate\":\"0000-00-00\",\"jmq_listprice\":\"0.00\",\"jmq_netprice\":\"0.00\",\"jmq_vat\":\"0.00\",\"jmq_isvaton\":1,\"jmq_deliverycost\":\"0.00\",\"jmq_deliverycosttypeid\":1,\"jmq_overridetypeid\":1,\"jmq_orderformprice\":\"0.00\",\"jmq_editpricebyid\":null,\"jmq_isroundon\":0,\"jmq_grossprice\":\"0.00\",\"jmq_grossprofit\":\"0.00\",\"jmq_costprice\":\"0.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"0.00\",\"jmq_totpaid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_userdefinedarray\":null,\"jmq_deliverycostid\":0,\"jmq_iscostpriceon\":0,\"jmq_custompricefields\":\"\",\"jmq_isonlineorder\":0,\"jmq_isonlineordersubmitted\":0,\"jmq_endcustomervatprice\":null,\"jmq_endcustomeroverridetype\":0,\"jmq_endcustomeroverridevalue\":null,\"jmq_endcustomeroverridenetprice\":\"0.00\",\"jmq_endcustomeroverridevatprice\":\"0.00\",\"jmq_endcustomeroverridegrossprice\":\"0.00\",\"jmq_endcustomerdeliverycost\":null,\"jmq_endcustomerdeliverycostinclvat\":0,\"jmq_endcustomerfittingcost\":null,\"jmq_endcustomerfittingcostinclvat\":0,\"jmq_onlinedeliveryaddreddtype\":0,\"jmq_onlinedeliveryaddreddid\":null,\"jmq_commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"jmq_deliveryvatperc\":\"22.000\",\"jmq_cdeliveryvatperc\":\"22.000\",\"jmq_createdby\":1,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-05-08T06:12:52.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": "51881", "cl_createdat": "1746690001.000000", "cl_updatedat": null }, { "cl_id": 51882, "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": 5478, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5478, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":5503}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":5503},\"old\":{\"jd_jobmultiquoteid\":null}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "51882", "cl_createdat": "1746690001.000000", "cl_updatedat": null }, { "cl_id": 51883, "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 Roller Blinds 001", "cl_event": "created", "cl_subjectid": 30982, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 5478, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Unit Type\":\" Inches\",\" Quantity\":\" 100\",\" Supplier\":\" Aarthi\"}", "cl_customproperties": "{\"attributes\":{\"oi_id\":30982,\"oi_jobid\":5478,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":5503,\"oi_credit_id\":0,\"oi_productid\":250,\"oi_recipeid\":252,\"oi_ruleid\":0,\"oi_qty\":100,\"oi_seq\":0,\"oi_customseq\":0,\"oi_productcustomseq\":0,\"oi_jsondata\":\"[{\\\"id\\\":7260,\\\"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\\\":7259,\\\"labelname\\\":\\\"Quantity\\\",\\\"value\\\":\\\"100\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":14,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":7261,\\\"labelname\\\":\\\"Supplier\\\",\\\"value\\\":21,\\\"valueid\\\":\\\"\\\",\\\"type\\\":17,\\\"optionid\\\":\\\"21\\\",\\\"optionvalue\\\":[{\\\"id\\\":21,\\\"optionid\\\":21,\\\"optionname\\\":\\\"Aarthi\\\",\\\"deleted\\\":0,\\\"optionquantity\\\":1}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7262,\\\"labelname\\\":\\\"Product Type\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7264,\\\"labelname\\\":\\\"Width\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":11,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"0_Inches_1_0\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7265,\\\"labelname\\\":\\\"Drop\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":12,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"0_Inches_1_0\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7266,\\\"labelname\\\":\\\"Fabric\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":5,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":1,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0}]\",\"oi_description\":\"Unit Type: Inches, Quantity: 100, Supplier: Aarthi\",\"oi_onlinedescription\":null,\"oi_imagepath\":null,\"oi_reportdescription\":\"##Quantity: 100##,##Supplier: Aarthi##\",\"oi_onlinereportdescription\":null,\"oi_reporttitles\":\"##Quantity:##Supplier:\",\"oi_onlinereporttitles\":null,\"oi_productionformulajsondata\":\"[]\",\"oi_productiondate\":\"2025-05-08 06:13:10\",\"oi_operationstatus\":null,\"oi_scanstatus\":\"\",\"oi_operationworkroom_data\":\"[]\",\"oi_operationcalender_data\":\"[]\",\"oi_operation_calculations\":\"[]\",\"oi_pricecomesfrom_calculations\":\"{}\",\"oi_pricetablepriceevenbom\":\"{}\",\"oi_productionstatus\":null,\"oi_costoverride\":0,\"oi_costprice\":\"0.000\",\"oi_netprice\":\"0.000\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"0.000\",\"oi_vatvalue\":\"22.000\",\"oi_vatselected\":2,\"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_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_supid\":null,\"oi_status\":0,\"oi_createdby\":1,\"oi_createdat\":\"2025-05-08T06:13:39.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":null,\"oi_jsondataid\":\"[7260, 7259, 7261, 7262, 7264, 7265, 7266]\",\"oi_deviceplatform\":1,\"oi_custompricefields\":\"\",\"oi_editransfer\":0,\"oi_apisup_orderid\":0,\"lineitem_id\":null,\"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": "51883", "cl_createdat": "1746690001.000000", "cl_updatedat": null }, { "cl_id": 51884, "cl_logname": "model", "cl_type": null, "cl_modulename": "Production Due Date", "cl_message": "Production Due Date has been updated", "cl_event": "modified", "cl_subjectid": 5478, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5478, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "{\"Production Due Date\":\"2025-05-07\"}", "cl_changedto": "{\"Production Due Date\":\"2025-05-08\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "51884", "cl_createdat": "1746690001.000000", "cl_updatedat": null }, { "cl_id": 51885, "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 Awning Bracket 12344", "cl_event": "created", "cl_subjectid": 30983, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 5478, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Unit Type\":\" Inches\",\" Supplier\":\" C & P Security\",\" Extras\":\" DC2\",\" Quantity\":\" 100\"}", "cl_customproperties": "{\"attributes\":{\"oi_id\":30983,\"oi_jobid\":5478,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":5503,\"oi_credit_id\":0,\"oi_productid\":29,\"oi_recipeid\":31,\"oi_ruleid\":0,\"oi_qty\":100,\"oi_seq\":0,\"oi_customseq\":0,\"oi_productcustomseq\":0,\"oi_jsondata\":\"[{\\\"id\\\":6901,\\\"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\\\":6350,\\\"labelname\\\":\\\"Supplier\\\",\\\"value\\\":18,\\\"valueid\\\":\\\"\\\",\\\"type\\\":17,\\\"optionid\\\":\\\"18\\\",\\\"optionvalue\\\":[{\\\"id\\\":18,\\\"optionid\\\":18,\\\"optionname\\\":\\\"C & P Security\\\",\\\"deleted\\\":0,\\\"optionquantity\\\":1}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":6879,\\\"labelname\\\":\\\"Location\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":6351,\\\"labelname\\\":\\\"Awning system\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":6352,\\\"labelname\\\":\\\"Bracket colour\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":6353,\\\"labelname\\\":\\\"Bracket type\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":6413,\\\"labelname\\\":\\\"Product Type\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7399,\\\"labelname\\\":\\\"Extras\\\",\\\"value\\\":\\\"DC2\\\",\\\"valueid\\\":\\\"22118\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"2648\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":2648,\\\"optionname\\\":\\\"DC2\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"\\\",\\\"pricegroups\\\":\\\"10000\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":null,\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":22118,\\\"forchildfieldoptionlinkid\\\":\\\"3_22118\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"0.00\\\",\\\"fieldid\\\":22118}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":6349,\\\"labelname\\\":\\\"Quantity\\\",\\\"value\\\":\\\"100\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":14,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1}]\",\"oi_description\":\"Unit Type: Inches, Supplier: C & P Security, Extras: DC2, Quantity: 100\",\"oi_onlinedescription\":null,\"oi_imagepath\":null,\"oi_reportdescription\":\"##Supplier: C & P Security##,##Extras: DC2##,##Quantity: 100##\",\"oi_onlinereportdescription\":null,\"oi_reporttitles\":\"##Supplier:##Extras:##Quantity:\",\"oi_onlinereporttitles\":null,\"oi_productionformulajsondata\":\"[]\",\"oi_productiondate\":\"2025-05-08 06:13:45\",\"oi_operationstatus\":null,\"oi_scanstatus\":\"\",\"oi_operationworkroom_data\":\"[]\",\"oi_operationcalender_data\":\"[]\",\"oi_operation_calculations\":\"[]\",\"oi_pricecomesfrom_calculations\":\"{}\",\"oi_pricetablepriceevenbom\":\"{}\",\"oi_productionstatus\":null,\"oi_costoverride\":0,\"oi_costprice\":\"0.000\",\"oi_netprice\":\"0.000\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"0.000\",\"oi_vatvalue\":\"22.000\",\"oi_vatselected\":2,\"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_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_supid\":null,\"oi_status\":0,\"oi_createdby\":1,\"oi_createdat\":\"2025-05-08T06:14:00.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":null,\"oi_jsondataid\":\"[6901, 6350, 6879, 6351, 6352, 6353, 6413, 7399, 6349]\",\"oi_deviceplatform\":1,\"oi_custompricefields\":\"\",\"oi_editransfer\":0,\"oi_apisup_orderid\":0,\"lineitem_id\":null,\"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": "51885", "cl_createdat": "1746690001.000000", "cl_updatedat": null }, { "cl_id": 51886, "cl_logname": "default", "cl_type": null, "cl_modulename": "Task", "cl_message": "new item has been created in Task", "cl_event": "created", "cl_subjectid": 42, "cl_subjecttype": "App\\Models\\Task\\bm_tasklist", "cl_parentid": 42, "cl_parentsubjecttype": "App\\Models\\Task\\bm_tasklist", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Category\":\"Low\",\"Task Date\":\"2025-05-08\",\"Task Time\":\"06:15:24\",\"tl_istaskprivate\":1,\"Created By\":\"Chris Owen\",\"Description\":\"Live1\",\"Repeat Method\":\"daily\",\"tl_deviceplatform\":1}", "cl_customproperties": "{\"attributes\":{\"tl_id\":42,\"tl_orderid\":0,\"tl_taskcategory\":1,\"tl_taskdate\":\"2025-05-08\",\"tl_tasktime\":\"06:15:24\",\"tl_taskmethod\":\"0\",\"tl_istaskprivate\":1,\"tl_userid\":\"6\",\"tl_priority\":0,\"tl_addjobid\":0,\"tl_desc\":\"Live1\",\"tl_status\":0,\"tl_markasread\":0,\"tl_taskstatus\":4,\"tl_userdefinedfields\":\"[]\",\"tl_markcompleted\":0,\"tl_jobmode\":null,\"tl_recurrencerule\":null,\"tl_repeatmaindescription\":null,\"tl_repeatmethod\":\"daily\",\"tl_starttask\":null,\"tl_startdata\":null,\"tl_endtask\":null,\"tl_enddata\":null,\"tl_createdat\":\"2025-05-08T07:40:01.000000Z\",\"tl_createdby\":1,\"tl_updatedby\":null,\"tl_updatedat\":\"2025-05-08T07:40:01.000000Z\",\"tl_istaskrepeat\":0,\"tl_deviceplatform\":1,\"tl_subject\":null,\"tl_immediate_notification\":0,\"tl_parent_task_id\":null}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "51886", "cl_createdat": "1746690001.000000", "cl_updatedat": null }, { "cl_id": 51887, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 5479, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5479, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"Aquarius Blinds\",\"\":13,\"Account Type\":\"Domestic\",\"Source\":\"Google\",\"Created By\":\"admin\",\"Company Name\":\"Blinds \",\"First Name\":\"Joesph\",\"Last Name\":\"K\",\"Address1\":\"Zoological Garden @12\",\"Country\":\"Australia\",\"Salutation\":\"Mr.\",\"Phone\":\"85663224711\",\"Assigned to\":1,\"Additional Contacts\":\"4050\",\"Production Due Date\":\"2025-05-07\",\"Job Ref No\":\"AQ5499\",\"Job Status\":\"Enquiry\",\"Order Status\":\"Enquiry\",\"Net Price\":\"356.00\",\"VAT Price\":\"78.32\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"Gross Price Amount\":\"434.32\",\"Gross Profit\":\"178.00\",\"Total CostPrice\":\"178.00\",\"Amount Outstanding\":\"434.32\",\"jd_isonlineorder\":1,\"Delivery Vat Percentage\":\"22.000\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":5479,\"jd_customerid\":3876,\"jd_contactid\":4050,\"jd_additionalcontacts\":\"4050\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"AQ5499\\\",\\\"35\\\":\\\"BLIN0002\\\",\\\"36\\\":11,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":25,\\\"40\\\":13,\\\"41\\\":1,\\\"44\\\":\\\"Blinds \\\",\\\"45\\\":\\\"Joesph\\\",\\\"46\\\":\\\"K\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"Zoological Garden @12\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":4,\\\"285\\\":1,\\\"286\\\":\\\"85663224711\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":1,\\\"558\\\":\\\"\\\",\\\"559\\\":1,\\\"610\\\":\\\"\\\",\\\"611\\\":\\\"\\\",\\\"612\\\":1,\\\"613\\\":\\\"\\\",\\\"615\\\":\\\"\\\",\\\"616\\\":\\\"\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-05-08\",\"jd_orderdate\":null,\"jd_duedate\":\"2025-05-07\",\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":null,\"jd_jobref\":\"AQ5499\",\"jd_jobstatus\":11,\"jd_contactaddid\":0,\"jd_orderstatus\":13,\"jd_accref\":\"BLIN0002\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"356.00\",\"jd_netprice\":\"356.00\",\"jd_vat\":\"78.32\",\"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\":\"434.32\",\"jd_grossprofit\":\"178.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"178.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"434.32\",\"jd_totpaid\":\"0.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":null,\"jd_deliverycostid\":0,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":0,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":0,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":0,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":0,\"jd_organizationid\":0,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":1,\"jd_createdat\":\"2025-05-08T08:01:24.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-05-08T08:09:39.000000Z\",\"salesorderid\":null,\"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\":\"22.000\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"22.000\",\"jd_commission\":\"[]\",\"jd_commissionprice\":\"0.00\",\"jd_commissionsetting\":0,\"jd_commissionaddedvalue\":\"0.00\",\"jd_onlineprefixseq\":null,\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":0,\"jd_rework_count\":0}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "51887", "cl_createdat": "1746691779.000000", "cl_updatedat": null }, { "cl_id": 51888, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 104969, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 5479, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"Job Created\",\"Platform\":\"All Options\",\"Description\":\"New job has been created in job\",\"Created By\":\"admin\",\"Date\":\"2025-05-08\",\"Time\":\"08:01:24\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":104969,\"nl_ordertempid\":0,\"nl_orderid\":5479,\"nl_notescategory\":1,\"nl_type\":17,\"nl_platform\":1,\"nl_desc\":\"New job has been created in job\",\"nl_manualNotes\":null,\"nl_createdby\":\"1\",\"nl_endddate\":\"2025-05-08\",\"nl_starttime\":\"08:01:24\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":1,\"created_at\":\"2025-05-08T08:01:24.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-05-08T08:09:39.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "51888", "cl_createdat": "1746691779.000000", "cl_updatedat": null }, { "cl_id": 51889, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in AQ5499", "cl_event": "created", "cl_subjectid": 5504, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 5479, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":5504,\"jmq_jobid\":5479,\"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\":\"356.00\",\"Net Price\":\"356.00\",\"VAT Price\":\"78.32\",\"VAT\":1,\"jmq_deliverycost\":\"0.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"434.32\",\"Gross Profit\":\"0.00\",\"Total CostPrice\":\"178.00\",\"Amount Outstanding\":\"434.32\",\"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\":\"22.000\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":5504,\"jmq_jobid\":5479,\"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\":\"356.00\",\"jmq_netprice\":\"356.00\",\"jmq_vat\":\"78.32\",\"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\":\"434.32\",\"jmq_grossprofit\":\"0.00\",\"jmq_costprice\":\"178.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"434.32\",\"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\":\"22.000\",\"jmq_cdeliveryvatperc\":\"22.000\",\"jmq_createdby\":1,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-05-08T08:01:24.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": "51889", "cl_createdat": "1746691779.000000", "cl_updatedat": null }, { "cl_id": 51890, "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": 5479, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5479, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":5504}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":5504},\"old\":{\"jd_jobmultiquoteid\":null}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "51890", "cl_createdat": "1746691779.000000", "cl_updatedat": null }, { "cl_id": 51891, "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 Awning Bracket 12344", "cl_event": "created", "cl_subjectid": 30984, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 5479, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Unit Type\":\" Inches\",\" Supplier\":\" C & P Security\",\" Awning system\":\" Markilux MX3\",\"Markilux MX4\":\"Markilux MX4\",\" Bracket colour\":\" Frame finish in 5215 Stone Grey metallic\",\"Frame finish in 5229 Havana Braun\":\"Frame finish in 5229 Havana Braun\",\" Bracket type\":\" Spreader plate 60mm x 60mm\",\" Product Type\":\" 10000\",\" Extras\":\" DC2\",\" Quantity\":\" 1\"}", "cl_customproperties": "{\"attributes\":{\"oi_id\":30984,\"oi_jobid\":5479,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":5504,\"oi_credit_id\":0,\"oi_productid\":29,\"oi_recipeid\":31,\"oi_ruleid\":0,\"oi_qty\":1,\"oi_seq\":0,\"oi_customseq\":0,\"oi_productcustomseq\":0,\"oi_jsondata\":\"[{\\\"id\\\":6901,\\\"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\\\":6350,\\\"labelname\\\":\\\"Supplier\\\",\\\"value\\\":\\\"18\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":17,\\\"optionid\\\":\\\"18\\\",\\\"optionvalue\\\":[{\\\"id\\\":18,\\\"optionid\\\":18,\\\"optionname\\\":\\\"C & P Security\\\",\\\"deleted\\\":0,\\\"optionquantity\\\":1}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":6879,\\\"labelname\\\":\\\"Location\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":6351,\\\"labelname\\\":\\\"Awning system\\\",\\\"value\\\":\\\"Markilux MX3,Markilux MX4\\\",\\\"valueid\\\":\\\"20404,20405\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"2268,2269\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":2268,\\\"optionname\\\":\\\"Markilux MX3\\\",\\\"description\\\":\\\"Markilux MX3\\\",\\\"optioncode\\\":\\\"sdvcklm\\\",\\\"pricegroups\\\":\\\"\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":20404,\\\"forchildfieldoptionlinkid\\\":\\\"3_20404\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"},{\\\"optionid\\\":2269,\\\"optionname\\\":\\\"Markilux MX4\\\",\\\"description\\\":\\\"Markilux MX4\\\",\\\"optioncode\\\":\\\"knmdv\\\",\\\"pricegroups\\\":\\\"\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":20405,\\\"forchildfieldoptionlinkid\\\":\\\"3_20405\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1,1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":6352,\\\"labelname\\\":\\\"Bracket colour\\\",\\\"value\\\":\\\"Frame finish in 5215 Stone Grey metallic,Frame finish in 5229 Havana Braun\\\",\\\"valueid\\\":\\\"20419,20420\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"1863,1861\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":1863,\\\"optionname\\\":\\\"Frame finish in 5215 Stone Grey metallic\\\",\\\"description\\\":\\\"Frame finish in 5215 Stone Grey metallic \\\",\\\"optioncode\\\":\\\"fcf\\\",\\\"pricegroups\\\":\\\"Fabric collection one,Fabric Collection Two\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":20419,\\\"forchildfieldoptionlinkid\\\":\\\"3_20419\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"},{\\\"optionid\\\":1861,\\\"optionname\\\":\\\"Frame finish in 5229 Havana Braun\\\",\\\"description\\\":\\\"Frame finish in 5229 Havana Braun\\\",\\\"optioncode\\\":\\\"fcf\\\",\\\"pricegroups\\\":\\\"Fabric collection one,Fabric Collection Two\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":20420,\\\"forchildfieldoptionlinkid\\\":\\\"3_20420\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1,1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":6353,\\\"labelname\\\":\\\"Bracket type\\\",\\\"value\\\":\\\"Spreader plate 60mm x 60mm\\\",\\\"valueid\\\":\\\"20429\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"2283\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":2283,\\\"optionname\\\":\\\"Spreader plate 60mm x 60mm\\\",\\\"description\\\":\\\"Spreader plate 60mm x 60mm\\\",\\\"optioncode\\\":\\\"kpndv\\\",\\\"pricegroups\\\":\\\"\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":null,\\\"unitcost\\\":89,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":20429,\\\"forchildfieldoptionlinkid\\\":\\\"3_20429\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":4,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"178.00\\\",\\\"fieldid\\\":20429}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":6357,\\\"labelname\\\":\\\"Standard Fig A\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":6,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":6358,\\\"labelname\\\":\\\"Standard Fig B\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":6,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":6359,\\\"labelname\\\":\\\"Standard Fig C\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":6,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":6364,\\\"labelname\\\":\\\"Add Galvanising\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":6413,\\\"labelname\\\":\\\"Product Type\\\",\\\"value\\\":435,\\\"valueid\\\":\\\"530\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"435\\\",\\\"optionvalue\\\":[{\\\"id\\\":530,\\\"fieldid\\\":6413,\\\"fieldoptionlinkid\\\":530,\\\"optionid\\\":435,\\\"mainsupplier\\\":\\\"18\\\",\\\"blindtypecode\\\":\\\"10000\\\",\\\"optionname\\\":\\\"10000\\\",\\\"optionquantity\\\":1,\\\"subcount\\\":0,\\\"status\\\":0,\\\"subdatacount\\\":0}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":7399,\\\"labelname\\\":\\\"Extras\\\",\\\"value\\\":\\\"DC2\\\",\\\"valueid\\\":\\\"22118\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"2648\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":2648,\\\"optionname\\\":\\\"DC2\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"\\\",\\\"pricegroups\\\":\\\"10000\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":null,\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":22118,\\\"forchildfieldoptionlinkid\\\":\\\"3_22118\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"0.00\\\",\\\"fieldid\\\":22118}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":6349,\\\"labelname\\\":\\\"Quantity\\\",\\\"value\\\":1,\\\"valueid\\\":\\\"\\\",\\\"type\\\":14,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0}]\",\"oi_description\":\"Unit Type: Inches, Supplier: C & P Security, Awning system: Markilux MX3,Markilux MX4, Bracket colour: Frame finish in 5215 Stone Grey metallic,Frame finish in 5229 Havana Braun, Bracket type: Spreader plate 60mm x 60mm, Product Type: 10000, Extras: DC2, Quantity: 1\",\"oi_onlinedescription\":null,\"oi_imagepath\":null,\"oi_reportdescription\":\"##Supplier: C & P Security##,##Awning system: Markilux MX3,Markilux MX4##,##Bracket colour: Frame finish in 5215 Stone Grey metallic,Frame finish in 5229 Havana Braun##,##Bracket type: Spreader plate 60mm x 60mm##,##Product Type: 10000##,##Extras: DC2##,##Quantity: 1##\",\"oi_onlinereportdescription\":null,\"oi_reporttitles\":\"##Supplier:##Awning system:##Bracket colour:##Bracket type:##Product Type:##Extras:##Quantity:\",\"oi_onlinereporttitles\":null,\"oi_productionformulajsondata\":\"[]\",\"oi_productiondate\":\"2025-05-08 08:03:55\",\"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\":\"89.000\",\"oi_netprice\":\"178.000\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"39.160\",\"oi_vatvalue\":\"22.000\",\"oi_vatselected\":2,\"oi_vattype\":1,\"oi_vatonoff\":1,\"oi_grossprice\":\"217.160\",\"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_supid\":null,\"oi_status\":0,\"oi_createdby\":1,\"oi_createdat\":\"2025-05-08T08:04:46.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":null,\"oi_jsondataid\":\"[6901, 6350, 6879, 6351, 6352, 6353, 6357, 6358, 6359, 6364, 6413, 7399, 6349]\",\"oi_deviceplatform\":1,\"oi_custompricefields\":\"\",\"oi_editransfer\":0,\"oi_apisup_orderid\":0,\"lineitem_id\":null,\"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": "51891", "cl_createdat": "1746691779.000000", "cl_updatedat": null }, { "cl_id": 51892, "cl_logname": "model", "cl_type": null, "cl_modulename": "Production Due Date", "cl_message": "Production Due Date has been updated", "cl_event": "modified", "cl_subjectid": 5479, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5479, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "{\"Production Due Date\":\"2025-05-07\"}", "cl_changedto": "{\"Production Due Date\":\"2025-05-08\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "51892", "cl_createdat": "1746691779.000000", "cl_updatedat": null }, { "cl_id": 51893, "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 Awning Bracket 12344", "cl_event": "created", "cl_subjectid": 30985, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 5479, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Unit Type\":\" Inches\",\" Supplier\":\" C & P Security\",\" Location\":\" 2\",\" Awning system\":\" Markilux MX3\",\"Markilux MX4\":\"Markilux MX4\",\" Bracket colour\":\" Frame finish in 5215 Stone Grey metallic\",\"Frame finish in 5229 Havana Braun\":\"Frame finish in 5229 Havana Braun\",\" Bracket type\":\" Spreader plate 60mm x 60mm\",\" Extras\":\" DC2\",\" Quantity\":\" 1\"}", "cl_customproperties": "{\"attributes\":{\"oi_id\":30985,\"oi_jobid\":5479,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":5504,\"oi_credit_id\":0,\"oi_productid\":29,\"oi_recipeid\":31,\"oi_ruleid\":0,\"oi_qty\":1,\"oi_seq\":0,\"oi_customseq\":0,\"oi_productcustomseq\":0,\"oi_jsondata\":\"[{\\\"id\\\":6901,\\\"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\\\":6350,\\\"labelname\\\":\\\"Supplier\\\",\\\"value\\\":\\\"18\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":17,\\\"optionid\\\":\\\"18\\\",\\\"optionvalue\\\":[{\\\"id\\\":18,\\\"optionid\\\":18,\\\"optionname\\\":\\\"C & P Security\\\",\\\"deleted\\\":0,\\\"optionquantity\\\":1}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":6879,\\\"labelname\\\":\\\"Location\\\",\\\"value\\\":\\\"2\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":6351,\\\"labelname\\\":\\\"Awning system\\\",\\\"value\\\":\\\"Markilux MX3,Markilux MX4\\\",\\\"valueid\\\":\\\"20404,20405\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"2268,2269\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":2268,\\\"optionname\\\":\\\"Markilux MX3\\\",\\\"description\\\":\\\"Markilux MX3\\\",\\\"optioncode\\\":\\\"sdvcklm\\\",\\\"pricegroups\\\":\\\"\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":20404,\\\"forchildfieldoptionlinkid\\\":\\\"3_20404\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"},{\\\"optionid\\\":2269,\\\"optionname\\\":\\\"Markilux MX4\\\",\\\"description\\\":\\\"Markilux MX4\\\",\\\"optioncode\\\":\\\"knmdv\\\",\\\"pricegroups\\\":\\\"\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":20405,\\\"forchildfieldoptionlinkid\\\":\\\"3_20405\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1,1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":6352,\\\"labelname\\\":\\\"Bracket colour\\\",\\\"value\\\":\\\"Frame finish in 5215 Stone Grey metallic,Frame finish in 5229 Havana Braun\\\",\\\"valueid\\\":\\\"20419,20420\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"1863,1861\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":1863,\\\"optionname\\\":\\\"Frame finish in 5215 Stone Grey metallic\\\",\\\"description\\\":\\\"Frame finish in 5215 Stone Grey metallic \\\",\\\"optioncode\\\":\\\"fcf\\\",\\\"pricegroups\\\":\\\"Fabric collection one,Fabric Collection Two\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":20419,\\\"forchildfieldoptionlinkid\\\":\\\"3_20419\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"},{\\\"optionid\\\":1861,\\\"optionname\\\":\\\"Frame finish in 5229 Havana Braun\\\",\\\"description\\\":\\\"Frame finish in 5229 Havana Braun\\\",\\\"optioncode\\\":\\\"fcf\\\",\\\"pricegroups\\\":\\\"Fabric collection one,Fabric Collection Two\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":20420,\\\"forchildfieldoptionlinkid\\\":\\\"3_20420\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1,1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":6353,\\\"labelname\\\":\\\"Bracket type\\\",\\\"value\\\":\\\"Spreader plate 60mm x 60mm\\\",\\\"valueid\\\":\\\"20429\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"2283\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":2283,\\\"optionname\\\":\\\"Spreader plate 60mm x 60mm\\\",\\\"description\\\":\\\"Spreader plate 60mm x 60mm\\\",\\\"optioncode\\\":\\\"kpndv\\\",\\\"pricegroups\\\":\\\"\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":null,\\\"unitcost\\\":89,\\\"fieldoptionlinkid\\\":20429,\\\"forchildfieldoptionlinkid\\\":\\\"3_20429\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":4,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"178.00\\\",\\\"fieldid\\\":20429}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":6357,\\\"labelname\\\":\\\"Standard Fig A\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":6,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":6358,\\\"labelname\\\":\\\"Standard Fig B\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":6,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":6359,\\\"labelname\\\":\\\"Standard Fig C\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":6,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":6364,\\\"labelname\\\":\\\"Add Galvanising\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":6413,\\\"labelname\\\":\\\"Product Type\\\",\\\"value\\\":435,\\\"valueid\\\":\\\"530\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"435\\\",\\\"optionvalue\\\":[{\\\"id\\\":530,\\\"fieldid\\\":6413,\\\"fieldoptionlinkid\\\":530,\\\"optionid\\\":435,\\\"mainsupplier\\\":\\\"18\\\",\\\"blindtypecode\\\":\\\"10000\\\",\\\"optionname\\\":\\\"10000\\\",\\\"optionquantity\\\":1,\\\"subcount\\\":0,\\\"status\\\":0,\\\"subdatacount\\\":0}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":7399,\\\"labelname\\\":\\\"Extras\\\",\\\"value\\\":\\\"DC2\\\",\\\"valueid\\\":\\\"22118\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"2648\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":2648,\\\"optionname\\\":\\\"DC2\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"\\\",\\\"pricegroups\\\":\\\"10000\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":null,\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":22118,\\\"forchildfieldoptionlinkid\\\":\\\"3_22118\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"0.00\\\",\\\"fieldid\\\":22118}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":6349,\\\"labelname\\\":\\\"Quantity\\\",\\\"value\\\":1,\\\"valueid\\\":\\\"\\\",\\\"type\\\":14,\\\"optionid\\\":\\\"1\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0}]\",\"oi_description\":\"Unit Type: Inches, Supplier: C & P Security, Location: 2, Awning system: Markilux MX3,Markilux MX4, Bracket colour: Frame finish in 5215 Stone Grey metallic,Frame finish in 5229 Havana Braun, Bracket type: Spreader plate 60mm x 60mm, Extras: DC2, Quantity: 1\",\"oi_onlinedescription\":null,\"oi_imagepath\":null,\"oi_reportdescription\":\"##Supplier: C & P Security##,##Location: 2##,##Awning system: Markilux MX3,Markilux MX4##,##Bracket colour: Frame finish in 5215 Stone Grey metallic,Frame finish in 5229 Havana Braun##,##Bracket type: Spreader plate 60mm x 60mm##,##Extras: DC2##,##Quantity: 1##\",\"oi_onlinereportdescription\":null,\"oi_reporttitles\":\"##Supplier:##Location:##Awning system:##Bracket colour:##Bracket type:##Extras:##Quantity:\",\"oi_onlinereporttitles\":null,\"oi_productionformulajsondata\":\"[]\",\"oi_productiondate\":\"2025-05-08 08:03:55\",\"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\":\"89.000\",\"oi_netprice\":\"178.000\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"39.160\",\"oi_vatvalue\":\"22.000\",\"oi_vatselected\":2,\"oi_vattype\":1,\"oi_vatonoff\":1,\"oi_grossprice\":\"217.160\",\"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\":\"178.000\",\"oi_endcustomeroverridevatprice\":\"39.160\",\"oi_endcustomeroverridegrossprice\":\"217.160\",\"oi_sage_flag\":0,\"oi_supid\":null,\"oi_status\":0,\"oi_createdby\":1,\"oi_createdat\":\"2025-05-08T08:05:06.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":null,\"oi_jsondataid\":\"[6901, 6350, 6879, 6351, 6352, 6353, 6357, 6358, 6359, 6364, 6413, 7399, 6349]\",\"oi_deviceplatform\":1,\"oi_custompricefields\":\"\",\"oi_editransfer\":0,\"oi_apisup_orderid\":0,\"lineitem_id\":null,\"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": "51893", "cl_createdat": "1746691779.000000", "cl_updatedat": null } ], "updated": [], "deleted": [] }, "bm_productInfo": { "created": [], "updated": [ { "pi_productid": 15, "pi_productname": "Roman blind", "pi_pcode": "989", "pi_category": 3, "pi_productgroup": 0, "pi_producttype": 0, "pi_qtyperunit": "0.00", "pi_unitprice": "0.00", "pi_costfactor": null, "pi_commissionrate": "0.000", "pi_commissionmethod": null, "pi_reorderlevel": null, "pi_taxclass": null, "pi_serialno": null, "pi_qtyinstock": null, "pi_supplierid": null, "pi_imagename": null, "pi_currencyid": null, "pi_supplierdefault": null, "pi_productseqno": null, "pi_domesticmarkup": "0.00", "pi_contractmarkup": "0.00", "pi_trademarkup": "0.00", "pi_childsafe": null, "pi_quantyshowhide": null, "pi_compquantyshowhide": null, "pi_stockcontrol": null, "pi_productiontab": null, "pi_fabriccolorcodehide": null, "pi_defaultunitfornewcurtainsorder": null, "pi_costpricecomesfrom": "2", "pi_netpricecomesfrom": "2", "pi_shuttercontract": "0.00", "pi_shuttertrade": "0.00", "pi_shutterdomestic": "0.00", "pi_shutterecommerce": "0.00", "pi_customerdiscount": null, "pi_discountoverridesubwidth": null, "pi_manufacturer_cost": null, "pi_fabrichide": null, "pi_hidecompparameter": null, "pi_factorybarcodeproduct": null, "pi_showhideproductorder": 1, "pi_ecommercestatus": 0, "pi_productdescription": "Deluxe Roman blind", "pi_ecomproductdesc": null, "pi_homeimage": null, "pi_galleryimage": null, "pi_innerpageimage": null, "pi_frameimage": "[]", "pi_ecommercecompmarkup": "0.00", "pi_showframeminmax": null, "pi_fabricdefaultdiscount": null, "pi_productstatusmultiple": null, "pi_followproductionseq": 1, "pi_productionformulasheetname": null, "pi_productrules": null, "pi_showexcelfromula": null, "pi_supplierheading": null, "pi_producttypehide": null, "pi_dualproducttypeheading": "Fabric 2", "pi_fabricheading": null, "pi_dualproducttypeenable": 0, "pi_fabricbeforeproducttype": null, "pi_suppliermandatory": null, "pi_showfabric": null, "pi_ecommercesample": "1", "pi_priceavalcheck": null, "pi_showcomponentcode": null, "pi_showmaxarea": null, "pi_recessallowance": null, "pi_deductionname": null, "pi_deductionvalue": "0.00", "pi_stackqty": null, "pi_blindstype": null, "pi_suppliershowhide": null, "pi_pricealert": null, "pi_metatitle": null, "pi_metadescription": null, "pi_metakeyword": null, "pi_canonicaltag": null, "pi_alttexttag": null, "pi_headertag": "H1", "pi_productimage": "[]", "pi_workroom": 1, "pi_mobileapp": 1, "pi_jobtransfer": 0, "pi_seq": 13, "pi_status": 0, "pi_createdby": 2, "pi_defaultunittype": 2, "pi_jobfraction": 1, "pi_unittypeseq": "2,3,1,4", "pi_deafultimage": "{\"defaultimage\":{\"framedefault\":\"\",\"productdefault\":\"\",\"backgrounddefault\":\"\"}}", "pi_backgroundimage": "[]", "pi_discountappliesto": "{\"optionschk\":1,\"operationschk\":1,\"pricetablechk\":1}", "pi_ecomProductName": null, "pi_productgroupseq": null, "pi_unitypedata": "{\"1\":1,\"2\":1,\"3\":1,\"4\":1}", "id": "15" }, { "pi_productid": 25, "pi_productname": "Markilux awningsss", "pi_pcode": "905", "pi_category": 1, "pi_productgroup": 1, "pi_producttype": 0, "pi_qtyperunit": "0.00", "pi_unitprice": "0.00", "pi_costfactor": null, "pi_commissionrate": "0.000", "pi_commissionmethod": null, "pi_reorderlevel": null, "pi_taxclass": null, "pi_serialno": null, "pi_qtyinstock": null, "pi_supplierid": null, "pi_imagename": null, "pi_currencyid": null, "pi_supplierdefault": null, "pi_productseqno": null, "pi_domesticmarkup": "0.00", "pi_contractmarkup": "0.00", "pi_trademarkup": "0.00", "pi_childsafe": null, "pi_quantyshowhide": null, "pi_compquantyshowhide": null, "pi_stockcontrol": null, "pi_productiontab": null, "pi_fabriccolorcodehide": null, "pi_defaultunitfornewcurtainsorder": null, "pi_costpricecomesfrom": "2", "pi_netpricecomesfrom": "2", "pi_shuttercontract": "0.00", "pi_shuttertrade": "0.00", "pi_shutterdomestic": "0.00", "pi_shutterecommerce": "0.00", "pi_customerdiscount": null, "pi_discountoverridesubwidth": null, "pi_manufacturer_cost": null, "pi_fabrichide": null, "pi_hidecompparameter": null, "pi_factorybarcodeproduct": null, "pi_showhideproductorder": 1, "pi_ecommercestatus": 0, "pi_productdescription": "Markilux awnings", "pi_ecomproductdesc": null, "pi_homeimage": null, "pi_galleryimage": null, "pi_innerpageimage": null, "pi_frameimage": "[]", "pi_ecommercecompmarkup": "0.00", "pi_showframeminmax": null, "pi_fabricdefaultdiscount": null, "pi_productstatusmultiple": null, "pi_followproductionseq": 1, "pi_productionformulasheetname": null, "pi_productrules": null, "pi_showexcelfromula": null, "pi_supplierheading": null, "pi_producttypehide": null, "pi_dualproducttypeheading": "Fabric 2", "pi_fabricheading": null, "pi_dualproducttypeenable": 0, "pi_fabricbeforeproducttype": null, "pi_suppliermandatory": null, "pi_showfabric": null, "pi_ecommercesample": "1", "pi_priceavalcheck": null, "pi_showcomponentcode": null, "pi_showmaxarea": null, "pi_recessallowance": null, "pi_deductionname": null, "pi_deductionvalue": "0.00", "pi_stackqty": null, "pi_blindstype": null, "pi_suppliershowhide": null, "pi_pricealert": null, "pi_metatitle": null, "pi_metadescription": null, "pi_metakeyword": null, "pi_canonicaltag": null, "pi_alttexttag": null, "pi_headertag": "H1", "pi_productimage": "[]", "pi_workroom": 1, "pi_mobileapp": 1, "pi_jobtransfer": 0, "pi_seq": 1, "pi_status": 0, "pi_createdby": 2, "pi_defaultunittype": 2, "pi_jobfraction": 1, "pi_unittypeseq": "2,3,1,4", "pi_deafultimage": "{\"defaultimage\":{\"framedefault\":\"\",\"productdefault\":\"\",\"backgrounddefault\":\"\",\"bannerdefault\":\"\"}}", "pi_backgroundimage": "[]", "pi_discountappliesto": "{\"optionschk\":1,\"operationschk\":1,\"pricetablechk\":1}", "pi_ecomProductName": null, "pi_productgroupseq": null, "pi_unitypedata": "{\"1\":1,\"2\":1,\"3\":1,\"4\":1}", "id": "25" } ], "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": { "51746691284": 4050 }, "bm_customertemplatedata": { "31746691284": 3876 }, "bm_jobdetails": { "41746691284": 5479 }, "bm_notelist": { "61746691284": 104969 }, "bm_jobmultiquote": { "141746691284": 5504 }, "bm_orderitem": { "71746691486": 30984, "71746691506": 30985 } }, "timestamp": 1746691779 }