{ "status": "success", "upcomingorder_list": { "bm_customertemplatedata": { "created": [], "updated": [ { "ctd_id": 4047, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\": 1, \"600\": 25, \"62\": \"TEST0017\"}", "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": "4047", "ctd_createdat": 1749203891, "ctd_updatedat": 1749210903, "ctd_createdby": 0, "ctd_updatedby": null } ], "deleted": [] }, "bm_customercontactinfo": { "created": [], "updated": [ { "cci_id": 4230, "cci_customerid": 4047, "cci_templateid": 3, "roleid": 0, "cci_customizedarray": "{\"75\":12,\"77\":\"Mob\",\"79\":\"Test\",\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"90\":36}", "cci_ismarketingemails": 0, "cci_smsverifystatus": 0, "cci_isdocumentreceived": 0, "cci_receiveddocfor": null, "cci_isonlineportal": 0, "cci_latitude": null, "cci_longitude": null, "cci_username": null, "cci_password": null, "cci_confirmpassword": null, "cci_seq": 0, "cci_status": 0, "cci_deviceplatform": 2, "cci_mobcustomertempid": 31749203891, "id": "4230", "cci_createdat": 1749203891, "cci_updatedat": 1749210903, "cci_createdby": 0, "cci_updatedby": null } ], "deleted": [] }, "bm_appointment": { "created": [ { "app_eventid": 10054, "app_description": null, "app_summary": "AQ5763-Jack K-6578567658-Surveyor", "app_private": 0, "app_appointmentType": 63, "app_userId": 7, "app_orderId": 5766, "app_customerId": 0, "app_isAllDay": 0, "app_timezone": "Asia\/Calcutta", "app_latitude": null, "app_longitude": null, "app_parentappid": null, "app_recurrencerule": null, "app_userdefinedValue": "[]", "app_recurrenceexception": null, "app_attachment": "[]", "guid": "", "app_staff": "", "app_appointtype": "", "app_confirmed": 0, "app_travelHour": "0", "app_travelMinute": "0", "app_onsiteHour": "0", "app_onsiteMinute": "0", "app_location": null, "app_traveltime": null, "app_googleid": "0", "app_platform": "web", "app_cal_status": 868, "app_status": 0, "app_markasread": 0, "app_statusInGoogle": 0, "app_runid": 0, "app_jobtimehour": "0", "app_jobtimeminute": "30", "app_products": null, "app_deviceplatform": 1, "app_recurrenceexception_date": null, "app_deliveryaddressid": 8, "id": "10054", "app_sdate": 1749168000, "app_edate": 1749168000, "app_stime": 1749202236, "app_etime": 1749204036, "app_sdatetime": 1749202236, "app_edatetime": 1749204036, "app_until": null, "app_createdAt": 1749204291, "app_updatedAt": 1749204293, "app_createdBy": 1, "app_updatedBy": null } ], "updated": [], "deleted": [] }, "bm_tasklist": { "created": [ { "tl_id": 102, "tl_orderid": 0, "tl_taskcategory": 1, "tl_taskdate": "2025-06-06", "tl_tasktime": "03:21:18", "tl_taskmethod": "0", "tl_istaskprivate": 1, "tl_userid": "4", "tl_priority": 0, "tl_addjobid": 0, "tl_desc": "Test data @sampless", "tl_status": 0, "tl_markasread": 0, "tl_taskstatus": 1, "tl_userdefinedfields": "{\"1\":\"\",\"2\":\"2\",\"3\":\"2025-06-10T09:51:00.000Z\"}", "tl_markcompleted": 0, "tl_jobmode": "0", "tl_recurrencerule": "", "tl_repeatmaindescription": "0", "tl_repeatmethod": "daily", "tl_starttask": "", "tl_startdata": "", "tl_endtask": "", "tl_enddata": "", "tl_istaskrepeat": 0, "tl_deviceplatform": 1, "id": "102", "tl_createdat": 1749203825, "tl_updatedat": 1749203844, "tl_createdby": 1, "tl_updatedby": 1 } ], "updated": [ { "tl_id": 102, "tl_orderid": 0, "tl_taskcategory": 1, "tl_taskdate": "2025-06-06", "tl_tasktime": "03:21:18", "tl_taskmethod": "0", "tl_istaskprivate": 1, "tl_userid": "4", "tl_priority": 0, "tl_addjobid": 0, "tl_desc": "Test data @sampless", "tl_status": 0, "tl_markasread": 0, "tl_taskstatus": 1, "tl_userdefinedfields": "{\"1\":\"\",\"2\":\"2\",\"3\":\"2025-06-10T09:51:00.000Z\"}", "tl_markcompleted": 0, "tl_jobmode": "0", "tl_recurrencerule": "", "tl_repeatmaindescription": "0", "tl_repeatmethod": "daily", "tl_starttask": "", "tl_startdata": "", "tl_endtask": "", "tl_enddata": "", "tl_istaskrepeat": 0, "tl_deviceplatform": 1, "id": "102", "tl_createdat": 1749203825, "tl_updatedat": 1749203844, "tl_createdby": 1, "tl_updatedby": 1 } ], "deleted": [] }, "bm_jobdetails": { "created": [ { "jd_id": 5767, "jd_customerid": 4047, "jd_contactid": 4230, "jd_additionalcontacts": "4230", "jd_templateid": 1, "jd_jobmultiquoteid": 5798, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5764", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "TEST0017", "jd_invoiceno": "", "jd_listprice": "800.00", "jd_netprice": "870.00", "jd_vat": "87.00", "jd_isvaton": 1, "jd_deliverycost": "70.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 8, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "jd_isroundon": 0, "jd_grossprice": "960.00", "jd_grossprofit": "70.00", "jd_costprice": "800.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "960.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": "10.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5764\",\"35\":\"TEST0017\",\"36\":1,\"37\":1,\"38\":\"\",\"39\":\"\",\"40\":13,\"41\":1,\"44\":\"\",\"45\":\"Mob\",\"46\":\"Test\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":12,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "10.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5767", "jd_createddate": 1749168000, "jd_orderdate": null, "jd_duedate": 1749168000, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": 0, "jd_sageexportdate": null, "jd_createdat": 1749203891, "jd_updatedat": 1749210903 } ], "updated": [ { "jd_id": 5766, "jd_customerid": 4046, "jd_contactid": 4228, "jd_additionalcontacts": "4228,8", "jd_templateid": 1, "jd_jobmultiquoteid": 5797, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5763", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "KJAC0001", "jd_invoiceno": "", "jd_listprice": "375.00", "jd_netprice": "445.00", "jd_vat": "44.50", "jd_isvaton": 1, "jd_deliverycost": "70.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "489.50", "jd_grossprofit": "70.00", "jd_costprice": "375.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "489.50", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\\\"\\\\\\\"\\\\\\\\\\\\\\\"\\\\\\\\\\\\\\\"\\\\\\\"\\\"\"", "jd_deliverycostid": 1, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": "", "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": "", "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": "", "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 1, "jd_updatedby": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "10.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5763\",\"35\":\"KJAC0001\",\"36\":1,\"37\":1,\"38\":\"\",\"39\":\"\",\"40\":13,\"41\":1,\"44\":\"\",\"45\":\"Jack\",\"46\":\"K\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":1,\"286\":\"6578567658\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":\"3\",\"610\":\"\",\"611\":\"\",\"612\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "10.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5766", "jd_createddate": 1749168000, "jd_orderdate": null, "jd_duedate": 1749168000, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1749202761, "jd_updatedat": 1749204268 }, { "jd_id": 5767, "jd_customerid": 4047, "jd_contactid": 4230, "jd_additionalcontacts": "4230", "jd_templateid": 1, "jd_jobmultiquoteid": 5798, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5764", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "TEST0017", "jd_invoiceno": "", "jd_listprice": "800.00", "jd_netprice": "870.00", "jd_vat": "87.00", "jd_isvaton": 1, "jd_deliverycost": "70.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 8, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "jd_isroundon": 0, "jd_grossprice": "960.00", "jd_grossprofit": "70.00", "jd_costprice": "800.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "960.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": "10.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5764\",\"35\":\"TEST0017\",\"36\":1,\"37\":1,\"38\":\"\",\"39\":\"\",\"40\":13,\"41\":1,\"44\":\"\",\"45\":\"Mob\",\"46\":\"Test\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":12,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "10.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5767", "jd_createddate": 1749168000, "jd_orderdate": null, "jd_duedate": 1749168000, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": 0, "jd_sageexportdate": null, "jd_createdat": 1749203891, "jd_updatedat": 1749210903 } ], "deleted": [] }, "bm_orderitem": { "created": [ { "oi_id": 31364, "oi_jobid": 5766, "oi_jobtempid": "0", "oi_jobmultiquoteid": 5797, "oi_productid": 271, "oi_recipeid": 274, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":7507,\"labelname\":\"Unit Type\",\"value\":1,\"valueid\":\"1\",\"type\":34,\"optionid\":1,\"optionvalue\":[{\"optionid\":1,\"optionname\":\"cm\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":1,\"forchildfieldoptionlinkid\":\"34_1\"}],\"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\":7507,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":1,\"optionsvalue\":[{\"optionid\":1,\"optionname\":\"cm\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":1,\"forchildfieldoptionlinkid\":\"34_1\"}],\"editruleoverride\":0},{\"id\":7505,\"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\":0,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":14,\"mandatory\":0,\"fieldname\":\"Quantity\",\"fieldid\":7505,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7506,\"labelname\":\"Supplier\",\"value\":\"32\",\"valueid\":null,\"type\":17,\"optionid\":\"32\",\"optionvalue\":[{\"id\":32,\"optionid\":32,\"optionname\":\"Perfa\",\"deleted\":0,\"optionquantity\":1}],\"issubfabric\":0,\"labelnamecode\":\"Supplier\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":17,\"mandatory\":0,\"fieldname\":\"Supplier\",\"fieldid\":7506,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"32\",\"optionsvalue\":[{\"id\":32,\"optionid\":32,\"optionname\":\"Perfa\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":7610,\"labelname\":\"Room\",\"value\":null,\"valueid\":null,\"type\":29,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Room\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":29,\"mandatory\":0,\"fieldname\":\"Room\",\"fieldid\":7610,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7611,\"labelname\":\"Blind Size or Recess\",\"value\":\"Recess size\",\"valueid\":\"22497\",\"type\":3,\"optionid\":\"1351\",\"optionvalue\":[{\"optionid\":1351,\"optionqty\":\"1\",\"description\":\"Recess size\",\"optioncode\":\"RS\",\"optionname\":\"Recess size\",\"pricegroups\":null,\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":22497,\"forchildfieldoptionlinkid\":\"3_22497\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"issubfabric\":0,\"labelnamecode\":\"Blind Size or Recess\",\"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\":\"Blind Size or Recess\",\"fieldid\":7611,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"1351\",\"optionsvalue\":[{\"optionid\":1351,\"optionqty\":\"1\",\"description\":\"Recess size\",\"optioncode\":\"RS\",\"optionname\":\"Recess size\",\"pricegroups\":null,\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":22497,\"forchildfieldoptionlinkid\":\"3_22497\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"editruleoverride\":1},{\"id\":7508,\"labelname\":\"Pricing Band\",\"value\":480,\"valueid\":\"628\",\"type\":13,\"optionid\":480,\"optionvalue\":[{\"id\":628,\"fieldid\":7508,\"fieldoptionlinkid\":628,\"optionid\":480,\"mainsupplier\":\"32\",\"blindtypecode\":null,\"optionname\":\"Honeycell FH Group 6\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"issubfabric\":0,\"labelnamecode\":\"Pricing Band\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":13,\"mandatory\":0,\"fieldname\":\"Pricing Band\",\"fieldid\":7508,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":480,\"optionsvalue\":[{\"id\":628,\"fieldid\":7508,\"fieldoptionlinkid\":628,\"optionid\":480,\"mainsupplier\":\"32\",\"blindtypecode\":null,\"optionname\":\"Honeycell FH Group 6\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"editruleoverride\":1},{\"id\":7509,\"labelname\":\"Fabric\",\"value\":\"Oxford Cellular LF 305 cm\",\"valueid\":\"5086\",\"type\":5,\"optionid\":\"5086\",\"optionvalue\":[{\"optionid\":5086,\"optionname\":\"Oxford Cellular LF 305 cm\",\"optioncode\":null,\"optionquantity\":1,\"fieldoptionlinkid\":5086,\"forchildfieldoptionlinkid\":\"5_2_5086_1\",\"optionimage\":null,\"subdatacount\":1,\"fabricmapid\":5086,\"pricegroup\":\"Honeycell FH Group 6\",\"pricegroupid\":480}],\"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\":7509,\"subchild\":[{\"fieldtypeid\":5,\"labelnamecode\":\"Color\",\"fieldid\":7573,\"status\":0,\"fieldname\":\"Color\",\"field_has_sub_option\":1,\"selection\":0,\"seq\":0,\"mandatory\":1,\"fieldlevel\":2,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"fabricorcolor\":2,\"optionsvalue\":[{\"optionid\":16291,\"optionname\":\"5220 White\",\"optioncode\":\"White\",\"optionquantity\":1,\"fieldoptionlinkid\":16291,\"forchildfieldoptionlinkid\":\"5_3_16291_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0},{\"optionid\":16292,\"optionname\":\"5222 Beige\",\"optioncode\":\"Beige\",\"optionquantity\":1,\"fieldoptionlinkid\":16292,\"forchildfieldoptionlinkid\":\"5_3_16292_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0},{\"optionid\":16293,\"optionname\":\"5229 Light Grey\",\"optioncode\":\"Light Grey\",\"optionquantity\":1,\"fieldoptionlinkid\":16293,\"forchildfieldoptionlinkid\":\"5_3_16293_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0},{\"optionid\":16294,\"optionname\":\"5227 Charcoal\",\"optioncode\":\"Charcoal\",\"optionquantity\":1,\"fieldoptionlinkid\":16294,\"forchildfieldoptionlinkid\":\"5_3_16294_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0}],\"optionsbackup\":[{\"optionid\":16291,\"optionname\":\"5220 White\",\"optioncode\":\"White\",\"optionquantity\":1,\"fieldoptionlinkid\":16291,\"forchildfieldoptionlinkid\":\"5_3_16291_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0},{\"optionid\":16292,\"optionname\":\"5222 Beige\",\"optioncode\":\"Beige\",\"optionquantity\":1,\"fieldoptionlinkid\":16292,\"forchildfieldoptionlinkid\":\"5_3_16292_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0},{\"optionid\":16293,\"optionname\":\"5229 Light Grey\",\"optioncode\":\"Light Grey\",\"optionquantity\":1,\"fieldoptionlinkid\":16293,\"forchildfieldoptionlinkid\":\"5_3_16293_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0},{\"optionid\":16294,\"optionname\":\"5227 Charcoal\",\"optioncode\":\"Charcoal\",\"optionquantity\":1,\"fieldoptionlinkid\":16294,\"forchildfieldoptionlinkid\":\"5_3_16294_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0}],\"editablecolumns\":[],\"subfieldlinkid\":5086,\"forchildsubfieldlinkid\":\"5_2_5086_1\",\"optionsselectedcolumns\":{\"optionid\":\"Option Id\",\"optionname\":\"Color Name\",\"optioncode\":\"Color Code\"},\"optiondefault\":\"16292\",\"value\":null,\"issubfabric\":0,\"masterparentfieldid\":7509,\"hasstock\":0,\"subchild\":[],\"supplierid\":\"0\",\"editruleoverride\":1,\"linktopricegroup\":0,\"dualseq\":1,\"fieldInformation\":null,\"multiseq\":0,\"dumydata\":[],\"blindswidth\":0}],\"fieldInformation\":null,\"optiondefault\":\"5086\",\"optionsvalue\":[{\"optionid\":5086,\"optionname\":\"Oxford Cellular LF 305 cm\",\"optioncode\":null,\"optionquantity\":1,\"fieldoptionlinkid\":5086,\"forchildfieldoptionlinkid\":\"5_2_5086_1\",\"optionimage\":null,\"subdatacount\":1,\"fabricmapid\":5086,\"pricegroup\":\"Honeycell FH Group 6\",\"pricegroupid\":480}],\"editruleoverride\":1},{\"id\":7573,\"labelname\":\"Color\",\"value\":\"5222 Beige\",\"valueid\":\"16292\",\"type\":5,\"optionid\":\"16292\",\"optionvalue\":[{\"optionid\":16292,\"optionname\":\"5222 Beige\",\"optioncode\":\"Beige\",\"optionquantity\":1,\"fieldoptionlinkid\":16292,\"forchildfieldoptionlinkid\":\"5_3_16292_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0}],\"issubfabric\":0,\"labelnamecode\":\"Color\",\"fabricorcolor\":2,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":2,\"fieldtypeid\":5,\"mandatory\":1,\"fieldname\":\"Color\",\"fieldid\":7573,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"16292\",\"optionsvalue\":[{\"optionid\":16292,\"optionname\":\"5222 Beige\",\"optioncode\":\"Beige\",\"optionquantity\":1,\"fieldoptionlinkid\":16292,\"forchildfieldoptionlinkid\":\"5_3_16292_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0}],\"editruleoverride\":1},{\"id\":7612,\"labelname\":\"Fabric Type\",\"value\":\"Cellular LF\",\"valueid\":\"22499\",\"type\":3,\"optionid\":\"2656\",\"optionvalue\":[{\"optionid\":2656,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"U-02\",\"optionname\":\"Cellular LF\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22499,\"forchildfieldoptionlinkid\":\"3_22499\",\"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,\"sellingpriceType\":1}],\"issubfabric\":0,\"labelnamecode\":\"Fabric Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Fabric Type\",\"fieldid\":7612,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"2656\",\"optionsvalue\":[{\"optionid\":2656,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"U-02\",\"optionname\":\"Cellular LF\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22499,\"forchildfieldoptionlinkid\":\"3_22499\",\"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,\"sellingpriceType\":1}],\"editruleoverride\":1},{\"id\":7613,\"labelname\":\"Blind Model\",\"value\":\"P1800 Chain Operated\",\"valueid\":\"22506\",\"type\":3,\"optionid\":\"2661\",\"optionvalue\":[{\"optionid\":2661,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"P1800 Chain Operated\",\"optionname\":\"P1800 Chain Operated\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":35,\"fieldoptionlinkid\":22506,\"forchildfieldoptionlinkid\":\"3_22506\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":4,\"optionimage\":null,\"reportprice\":\"35.00\",\"costprice\":35,\"costwithdiscount\":35,\"customersellingprice\":35,\"customermarkupvalue\":1,\"optiontype\":3,\"quantity\":1,\"optionnetprice\":35,\"sellingpriceType\":1}],\"issubfabric\":0,\"labelnamecode\":\"Blind ModelBM\",\"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\":\"Blind Model\",\"fieldid\":7613,\"subchild\":[{\"fieldtypeid\":3,\"labelnamecode\":\"Steering ControlPC02\",\"fieldid\":7616,\"fieldname\":\"Steering Control\",\"selection\":0,\"seq\":100,\"mandatory\":1,\"fieldlevel\":2,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"field_has_sub_option\":1,\"fabricorcolor\":0,\"subfieldlinkid\":22506,\"forchildsubfieldlinkid\":\"3_22506\",\"optionsvalue\":[{\"optionid\":2659,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"LF\",\"optionname\":\"Left\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22508,\"forchildfieldoptionlinkid\":\"3_22508\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":2660,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"RT\",\"optionname\":\"Right\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22509,\"forchildfieldoptionlinkid\":\"3_22509\",\"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,\"sellingpriceType\":1}],\"optionsbackup\":[{\"optionid\":2659,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"LF\",\"optionname\":\"Left\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22508,\"forchildfieldoptionlinkid\":\"3_22508\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":2660,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"RT\",\"optionname\":\"Right\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22509,\"forchildfieldoptionlinkid\":\"3_22509\",\"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,\"sellingpriceType\":1}],\"editablecolumns\":[\"optionqty\"],\"optionsselectedcolumns\":{\"optionid\":\"Option Id\",\"optionqty\":\"Option Qty\",\"optionname\":\"Option Name\",\"optioncode\":\"Option Code\",\"description\":\"Description\",\"pricegroups\":\"Price Groups\"},\"optiondefault\":\"2660\",\"masterparentfieldid\":7613,\"subchild\":[],\"value\":null,\"issubfabric\":0,\"supplierid\":\"32\",\"editruleoverride\":1,\"textfieldheight\":1,\"fieldInformation\":null,\"numeric_minvalue\":0,\"numeric_maxvalue\":0,\"dumydata\":[],\"blindswidth\":0},{\"fieldtypeid\":3,\"labelnamecode\":\"Chain TypePC03\",\"fieldid\":7617,\"fieldname\":\"Chain Type\",\"selection\":0,\"seq\":101,\"mandatory\":1,\"fieldlevel\":2,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"field_has_sub_option\":1,\"fabricorcolor\":0,\"subfieldlinkid\":22506,\"forchildsubfieldlinkid\":\"3_22506\",\"optionsvalue\":[{\"optionid\":2662,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"PS02\",\"optionname\":\"Plastic_White\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22511,\"forchildfieldoptionlinkid\":\"3_22511\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":2663,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"PS03\",\"optionname\":\"Plastic_Grey\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22512,\"forchildfieldoptionlinkid\":\"3_22512\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":2664,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"PS04\",\"optionname\":\"Plastic_Brown\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22513,\"forchildfieldoptionlinkid\":\"3_22513\",\"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,\"sellingpriceType\":1},{\"optionid\":2665,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"PS05\",\"optionname\":\"Plastic_Black\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22514,\"forchildfieldoptionlinkid\":\"3_22514\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":2666,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"PS06\",\"optionname\":\"Metal_Chrome\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22515,\"forchildfieldoptionlinkid\":\"3_22515\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":2667,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"PS07\",\"optionname\":\"Metal_Gunmetal Black\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22516,\"forchildfieldoptionlinkid\":\"3_22516\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":2668,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"PS08\",\"optionname\":\"Metal_Antique Gold\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22517,\"forchildfieldoptionlinkid\":\"3_22517\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null}],\"optionsbackup\":[{\"optionid\":2662,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"PS02\",\"optionname\":\"Plastic_White\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22511,\"forchildfieldoptionlinkid\":\"3_22511\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":2663,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"PS03\",\"optionname\":\"Plastic_Grey\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22512,\"forchildfieldoptionlinkid\":\"3_22512\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":2664,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"PS04\",\"optionname\":\"Plastic_Brown\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22513,\"forchildfieldoptionlinkid\":\"3_22513\",\"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,\"sellingpriceType\":1},{\"optionid\":2665,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"PS05\",\"optionname\":\"Plastic_Black\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22514,\"forchildfieldoptionlinkid\":\"3_22514\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":2666,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"PS06\",\"optionname\":\"Metal_Chrome\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22515,\"forchildfieldoptionlinkid\":\"3_22515\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":2667,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"PS07\",\"optionname\":\"Metal_Gunmetal Black\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22516,\"forchildfieldoptionlinkid\":\"3_22516\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":2668,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"PS08\",\"optionname\":\"Metal_Antique Gold\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22517,\"forchildfieldoptionlinkid\":\"3_22517\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null}],\"editablecolumns\":[\"optionqty\"],\"optionsselectedcolumns\":{\"optionid\":\"Option Id\",\"optionqty\":\"Option Qty\",\"optionname\":\"Option Name\",\"optioncode\":\"Option Code\",\"description\":\"Description\",\"pricegroups\":\"Price Groups\"},\"optiondefault\":\"2664\",\"masterparentfieldid\":7613,\"subchild\":[],\"value\":null,\"issubfabric\":0,\"supplierid\":\"32\",\"editruleoverride\":1,\"textfieldheight\":1,\"fieldInformation\":null,\"numeric_minvalue\":0,\"numeric_maxvalue\":0,\"dumydata\":[],\"blindswidth\":0},{\"fieldtypeid\":3,\"labelnamecode\":\"Child Safety Breakaway ChainPC04\",\"fieldid\":7618,\"fieldname\":\"Child Safety Breakaway Chain\",\"selection\":0,\"seq\":102,\"mandatory\":1,\"fieldlevel\":2,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"field_has_sub_option\":1,\"fabricorcolor\":0,\"subfieldlinkid\":22506,\"forchildsubfieldlinkid\":\"3_22506\",\"optionsvalue\":[{\"optionid\":2669,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"NO\",\"optionname\":\"No\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22519,\"forchildfieldoptionlinkid\":\"3_22519\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":2670,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"Yes\",\"optionname\":\"Yes\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22520,\"forchildfieldoptionlinkid\":\"3_22520\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"optionsbackup\":[{\"optionid\":2669,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"NO\",\"optionname\":\"No\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22519,\"forchildfieldoptionlinkid\":\"3_22519\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":2670,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"Yes\",\"optionname\":\"Yes\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22520,\"forchildfieldoptionlinkid\":\"3_22520\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"editablecolumns\":[\"optionqty\"],\"optionsselectedcolumns\":{\"optionid\":\"Option Id\",\"optionqty\":\"Option Qty\",\"optionname\":\"Option Name\",\"optioncode\":\"Option Code\",\"description\":\"Description\",\"pricegroups\":\"Price Groups\"},\"optiondefault\":\"2670\",\"masterparentfieldid\":7613,\"subchild\":[],\"value\":null,\"issubfabric\":0,\"supplierid\":\"32\",\"editruleoverride\":1,\"textfieldheight\":1,\"fieldInformation\":null,\"numeric_minvalue\":0,\"numeric_maxvalue\":0,\"dumydata\":[],\"blindswidth\":0},{\"fieldtypeid\":18,\"labelnamecode\":\"Chain SizePC05\",\"fieldoptionlinkid\":0,\"forchildfieldoptionlinkid\":\"3_0\",\"fieldid\":7619,\"fieldname\":\"Chain Size\",\"selection\":0,\"field_has_sub_option\":0,\"mandatory\":1,\"seq\":103,\"optiondefault\":null,\"fieldlevel\":2,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"subfieldlinkid\":22506,\"forchildsubfieldlinkid\":\"3_22506\",\"fabricorcolor\":0,\"editablecolumns\":[],\"masterparentfieldid\":\"7613\",\"optionsvalue\":[],\"optionsbackup\":[],\"subchild\":[],\"value\":null,\"issubfabric\":0,\"supplierid\":\"32\",\"editruleoverride\":1,\"textfieldheight\":1,\"dualseq\":0,\"fieldInformation\":null,\"numberfraction\":null,\"numeric_minvalue\":0,\"numeric_maxvalue\":0,\"dumydata\":[],\"blindswidth\":0}],\"fieldInformation\":null,\"optiondefault\":\"2661\",\"optionsvalue\":[{\"optionid\":2661,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"P1800 Chain Operated\",\"optionname\":\"P1800 Chain Operated\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":35,\"fieldoptionlinkid\":22506,\"forchildfieldoptionlinkid\":\"3_22506\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":4,\"optionimage\":null,\"reportprice\":\"35.00\",\"costprice\":35,\"costwithdiscount\":35,\"customersellingprice\":35,\"customermarkupvalue\":1,\"optiontype\":3,\"quantity\":1,\"optionnetprice\":35,\"sellingpriceType\":1}],\"editruleoverride\":1},{\"id\":7616,\"labelname\":\"Steering Control\",\"value\":\"Right\",\"valueid\":\"22509\",\"type\":3,\"optionid\":\"2660\",\"optionvalue\":[{\"optionid\":2660,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"RT\",\"optionname\":\"Right\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22509,\"forchildfieldoptionlinkid\":\"3_22509\",\"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,\"sellingpriceType\":1}],\"issubfabric\":0,\"labelnamecode\":\"Steering ControlPC02\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":2,\"fieldtypeid\":3,\"mandatory\":1,\"fieldname\":\"Steering Control\",\"fieldid\":7616,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"2660\",\"optionsvalue\":[{\"optionid\":2660,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"RT\",\"optionname\":\"Right\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22509,\"forchildfieldoptionlinkid\":\"3_22509\",\"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,\"sellingpriceType\":1}],\"editruleoverride\":1},{\"id\":7617,\"labelname\":\"Chain Type\",\"value\":\"Plastic_Brown\",\"valueid\":\"22513\",\"type\":3,\"optionid\":\"2664\",\"optionvalue\":[{\"optionid\":2664,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"PS04\",\"optionname\":\"Plastic_Brown\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22513,\"forchildfieldoptionlinkid\":\"3_22513\",\"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,\"sellingpriceType\":1}],\"issubfabric\":0,\"labelnamecode\":\"Chain TypePC03\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":2,\"fieldtypeid\":3,\"mandatory\":1,\"fieldname\":\"Chain Type\",\"fieldid\":7617,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"2664\",\"optionsvalue\":[{\"optionid\":2664,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"PS04\",\"optionname\":\"Plastic_Brown\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22513,\"forchildfieldoptionlinkid\":\"3_22513\",\"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,\"sellingpriceType\":1}],\"editruleoverride\":1},{\"id\":7618,\"labelname\":\"Child Safety Breakaway Chain\",\"value\":\"Yes\",\"valueid\":\"22520\",\"type\":3,\"optionid\":\"2670\",\"optionvalue\":[{\"optionid\":2670,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"Yes\",\"optionname\":\"Yes\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22520,\"forchildfieldoptionlinkid\":\"3_22520\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"issubfabric\":0,\"labelnamecode\":\"Child Safety Breakaway ChainPC04\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":2,\"fieldtypeid\":3,\"mandatory\":1,\"fieldname\":\"Child Safety Breakaway Chain\",\"fieldid\":7618,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"2670\",\"optionsvalue\":[{\"optionid\":2670,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"Yes\",\"optionname\":\"Yes\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22520,\"forchildfieldoptionlinkid\":\"3_22520\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"editruleoverride\":1},{\"id\":7619,\"labelname\":\"Chain Size\",\"value\":\"sample data\",\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Chain SizePC05\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":2,\"fieldtypeid\":18,\"mandatory\":1,\"fieldname\":\"Chain Size\",\"fieldid\":7619,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":7609,\"labelname\":\"Fixing Type\",\"value\":\"Face Fix brackets\",\"valueid\":\"22495\",\"type\":3,\"optionid\":\"2653\",\"optionvalue\":[{\"optionid\":2653,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"ECS22\",\"optionname\":\"Face Fix brackets\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":12,\"fieldoptionlinkid\":22495,\"forchildfieldoptionlinkid\":\"3_22495\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"12.00\",\"costprice\":12,\"costwithdiscount\":12,\"customersellingprice\":12,\"customermarkupvalue\":1,\"optiontype\":3,\"quantity\":1,\"optionnetprice\":12,\"sellingpriceType\":1}],\"issubfabric\":0,\"labelnamecode\":\"Fixing Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Fixing Type\",\"fieldid\":7609,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"2653\",\"optionsvalue\":[{\"optionid\":2653,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"ECS22\",\"optionname\":\"Face Fix brackets\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":12,\"fieldoptionlinkid\":22495,\"forchildfieldoptionlinkid\":\"3_22495\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"12.00\",\"costprice\":12,\"costwithdiscount\":12,\"customersellingprice\":12,\"customermarkupvalue\":1,\"optiontype\":3,\"quantity\":1,\"optionnetprice\":12,\"sellingpriceType\":1}],\"editruleoverride\":1},{\"id\":7644,\"labelname\":\"Width\",\"value\":\"234\",\"valueid\":null,\"type\":11,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Width\",\"fabricorcolor\":0,\"widthfraction\":\"0_cm_3_0\",\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":11,\"mandatory\":0,\"fieldname\":\"Width\",\"fieldid\":7644,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":7645,\"labelname\":\"Drop\",\"value\":\"234\",\"valueid\":null,\"type\":12,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Drop\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":\"0_cm_3_0\",\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":12,\"mandatory\":0,\"fieldname\":\"Drop\",\"fieldid\":7645,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":7646,\"labelname\":\"Profile Colour\",\"value\":\"Brown\",\"valueid\":\"22632\",\"type\":3,\"optionid\":\"2727\",\"optionvalue\":[{\"optionid\":2727,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"PR044\",\"optionname\":\"Brown\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22632,\"forchildfieldoptionlinkid\":\"3_22632\",\"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,\"sellingpriceType\":1}],\"issubfabric\":0,\"labelnamecode\":\"Profile 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\":\"Profile Colour\",\"fieldid\":7646,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"2727\",\"optionsvalue\":[{\"optionid\":2727,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"PR044\",\"optionname\":\"Brown\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22632,\"forchildfieldoptionlinkid\":\"3_22632\",\"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,\"sellingpriceType\":1}],\"editruleoverride\":1},{\"id\":7647,\"labelname\":\"Additional\",\"value\":\"Yes Extension Cable For Battery Pack,Yes Transformer Instead Battery Pack\",\"valueid\":\"22638,22639\",\"type\":3,\"optionid\":\"2733,2734\",\"optionvalue\":[{\"optionid\":2733,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"rf5\",\"optionname\":\"Yes Extension Cable For Battery Pack\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22638,\"forchildfieldoptionlinkid\":\"3_22638\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":2734,\"optionqty\":\"1\",\"description\":null,\"optioncode\":null,\"optionname\":\"Yes Transformer Instead Battery Pack\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22639,\"forchildfieldoptionlinkid\":\"3_22639\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"issubfabric\":0,\"labelnamecode\":\"Additional\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1,1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Additional\",\"fieldid\":7647,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"2733,2734\",\"optionsvalue\":[{\"optionid\":2733,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"rf5\",\"optionname\":\"Yes Extension Cable For Battery Pack\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22638,\"forchildfieldoptionlinkid\":\"3_22638\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":2734,\"optionqty\":\"1\",\"description\":null,\"optioncode\":null,\"optionname\":\"Yes Transformer Instead Battery Pack\",\"pricegroups\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":22639,\"forchildfieldoptionlinkid\":\"3_22639\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"editruleoverride\":1},{\"id\":7648,\"labelname\":\"Special Instructions\",\"value\":\"test data\",\"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\":7648,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1}]", "oi_description": "Supplier: Perfa, Blind Size or Recess: Recess size, Pricing Band: Honeycell FH Group 6, Fabric: Oxford Cellular LF 305 cm, Color: 5222 Beige, Fabric Type: Cellular LF, Blind Model: P1800 Chain Operated, Steering Control: Right, Chain Type: Plastic_Brown, Child Safety Breakaway Chain: Yes, Chain Size: sample data, Fixing Type: Face Fix brackets, Width: 234, Drop: 234, Profile Colour: Brown, Additional: Yes Extension Cable For Battery Pack,Yes Transformer Instead Battery Pack, Special Instructions: test data", "oi_reportdescription": "##Quantity: 1##,##Supplier: Perfa##,##Blind Size or Recess: Recess size##,##Pricing Band: Honeycell FH Group 6##,##Fabric: Oxford Cellular LF 305 cm##,##Color: 5222 Beige##,##Fabric Type: Cellular LF##,##Blind Model: P1800 Chain Operated##,##Steering Control: Right##,##Chain Type: Plastic_Brown##,##Child Safety Breakaway Chain: Yes##,##Chain Size: sample data##,##Fixing Type: Face Fix brackets##,##Width: 234 cm##,##Drop: 234 cm##,##Profile Colour: Brown##,##Additional: Yes Extension Cable For Battery Pack,Yes Transformer Instead Battery Pack##,##Special Instructions: test data##", "oi_reporttitles": "##Quantity:<\/br>##Supplier:<\/br>##Blind Size or Recess:<\/br>##Pricing Band:<\/br>##Fabric:<\/br>##Color:<\/br>##Fabric Type:<\/br>##Blind Model:<\/br>##Steering Control:<\/br>##Chain Type:<\/br>##Child Safety Breakaway Chain:<\/br>##Chain Size:<\/br>##Fixing Type:<\/br>##Width:<\/br>##Drop:<\/br>##Profile Colour:<\/br>##Additional:<\/br>##Special Instructions:", "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\":42,\"value\":\"228\",\"formula\":\"if(UnitType=\\\"cm\\\",Round(if(BlindModelBM=\\\"A011P_1705\\\",Blind_Width-1.1,Blind_Width-0.7),2),if(UnitType=\\\"mm\\\",Round(if(BlindModelBM=\\\"A011P_1705\\\",Blind_Width-11,Blind_Width-7),2),if(UnitType=\\\"m\\\",Round(if(BlindModelBM=\\\"A011P_1705\\\",Blind_Width-0.01,Blind_Width-0.007),2),if(UnitType=\\\"Inch\\\",Round(if(BlindModelBM=\\\"A011P_1705\\\",Blind_Width-0.43,Blind_Width-0.28),2)))))\",\"price\":\"-\",\"recipeid\":274,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"228\"},{\"productionoveride\":0,\"id\":43,\"value\":null,\"formula\":\"IF(BlindModelBM=\\\"P1700CordOperated\\\",(Profile_Width-(2*50))\\\/(Number_of_Holes-1)),IF(BlindModelBM=\\\"P1800ChainOperated\\\",(Profile_Width-(2*70))\\\/(Number_of_Holes-1)),IF(BlindModelBM=\\\"P1900Motorised\\\",(Profile_Width-(2*50))\\\/(Number_of_Holes-1))\",\"price\":\"-\",\"recipeid\":274,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":44,\"value\":\"438\",\"formula\":\"IF(BlindModelBM=\\\"P1700CordOperated\\\",(Tension_Profile_Width-(2*50))\\\/(Number_of_Holes-1),IF(BlindModelBM=\\\"P1800ChainOperated\\\",(Tension_Profile_Width-(2*70))\\\/(Number_of_Holes-1),IF(BlindModelBM=\\\"P1900Motorised\\\",(Tension_Profile_Width-(2*50))\\\/(Number_of_Holes-1))))\",\"price\":\"-\",\"recipeid\":274,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"438\"},{\"productionoveride\":0,\"id\":45,\"value\":\"2335\",\"formula\":\"IF(BlindSizeorRecess=\\\"RecessSize\\\",Width-5,IF(BlindSizeorRecess=\\\"ExactBlindSize\\\",Width,\\\"\\\"))\",\"price\":\"-\",\"recipeid\":274,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"2335\"},{\"productionoveride\":0,\"id\":46,\"value\":\"2340\",\"formula\":\"IF(BlindSizeorRecess=\\\"ExactBlindSize\\\",Drop,Drop)\",\"price\":\"-\",\"recipeid\":274,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"2340\"},{\"productionoveride\":0,\"id\":47,\"value\":null,\"formula\":\"IF(BlindModelBM=\\\"A011P_1705\\\",((Blind_Width\\\/2)+Blind_Drop))\",\"price\":\"-\",\"recipeid\":274,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":48,\"value\":\"2321\",\"formula\":\"IF(BlindModelBM=\\\"P1700CordOperated\\\",Blind_Width-25,IF(BlindModelBM=\\\"P1800ChainOperated\\\",Blind_Width-14,IF(BlindModelBM=\\\"P1900Motorised\\\",Blind_Width-7)))\",\"price\":\"-\",\"recipeid\":274,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"2321\"},{\"productionoveride\":0,\"id\":49,\"value\":\"2333\",\"formula\":\"IF(BlindModelBM=\\\"P1700CordOperated\\\",Blind_Width-2,IF(BlindModelBM=\\\"P1800ChainOperated\\\",Blind_Width-2,IF(BlindModelBM=\\\"P1900Motorised\\\",Blind_Width-2)))\",\"price\":\"-\",\"recipeid\":274,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"2333\"},{\"productionoveride\":0,\"id\":50,\"value\":\"6\",\"formula\":\"IF(Width>1250,6,IF(Width>900,4,IF(Width>600,3,2)))\",\"price\":\"-\",\"recipeid\":274,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"6\"},{\"productionoveride\":0,\"id\":51,\"value\":\"167\",\"formula\":\"IF(FabricType=\\\"CellularBO\\\",Drop\\\/13,IF(FabricType=\\\"CellularLF\\\",Drop\\\/14,IF(FabricType=\\\"Pleated\\\",((Drop\\\/40)*1.2)+3)))\",\"price\":\"-\",\"recipeid\":274,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"167\"},{\"productionoveride\":0,\"id\":52,\"value\":\"70\",\"formula\":\"IF(Left(BlindModelBM,3)=\\\"P17\\\",50,IF(Left(BlindModelBM,3)=\\\"P18\\\",70,IF(Left(BlindModelBM,3)=\\\"P19\\\",50)))\",\"price\":\"-\",\"recipeid\":274,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"70\"},{\"productionoveride\":0,\"id\":53,\"value\":null,\"formula\":\"IF(BlindModelBM=\\\"P1700CordOperated\\\",Blind_Width+Blind_Drop+100)\",\"price\":\"-\",\"recipeid\":274,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":54,\"value\":\"2328\",\"formula\":\"IF(BlindModelBM=\\\"P1700CordOperated\\\",Blind_Width-7,IF(BlindModelBM=\\\"P1800ChainOperated\\\",Blind_Width-7,IF(BlindModelBM=\\\"P1900Motorised\\\",Blind_Width-7)))\",\"price\":\"-\",\"recipeid\":274,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"2328\"},{\"productionoveride\":0,\"id\":55,\"value\":\"2271\",\"formula\":\"IF(BlindModelBM=\\\"P1800ChainOperated\\\",Blind_Width-64,IF(BlindModelBM=\\\"P1900Motorised\\\",(Profile_Width-182)\\\/2))\",\"price\":\"-\",\"recipeid\":274,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"2271\"},{\"productionoveride\":0,\"id\":56,\"value\":\"2340\",\"formula\":\"Blind_Drop\",\"price\":\"-\",\"recipeid\":274,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"2340\"},{\"productionoveride\":0,\"id\":57,\"value\":\"6.4\",\"formula\":\"IF(BlindModelBM=\\\"P1800ChainOperated\\\",\\\"6.4\\\",IF(BlindModelBM=\\\"P1700CordOperated\\\",\\\"13\\\"))\",\"price\":\"-\",\"recipeid\":274,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"6.4\"},{\"productionoveride\":0,\"id\":58,\"value\":\"2321\",\"formula\":\"IF(BlindModelBM=\\\"P1800ChainOperated\\\",Blind_Width-14,IF(BlindModelBM=\\\"P1900Motorised\\\",Blind_Width-7,IF(BlindModelBM=\\\"P1700CordOperated\\\",Blind_Width-25)))\",\"price\":\"-\",\"recipeid\":274,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"2321\"},{\"productionoveride\":0,\"id\":59,\"value\":\"2490\",\"formula\":\"IF(BlindModelBM=\\\"P1800ChainOperated\\\",Blind_Drop+150,IF(BlindModelBM=\\\"P1900Motorised\\\",Blind_Drop+300))\",\"price\":\"-\",\"recipeid\":274,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"2490\"},{\"productionoveride\":0,\"id\":60,\"value\":null,\"formula\":\"IF(BlindModelBM=\\\"P1700CordOperated\\\",Blind_Drop+50)\",\"price\":\"-\",\"recipeid\":274,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"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\":\"328.00\",\"show_hide\":true,\"category\":3}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "375.000", "oi_netprice": "375.000", "oi_pricesfromoperations": null, "oi_vatprice": "37.500", "oi_vatvalue": "10.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "412.500", "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": "375.000", "oi_endcustomeroverridevatprice": "37.500", "oi_endcustomeroverridegrossprice": "412.500", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[7507, 7505, 7506, 7610, 7611, 7508, 7509, 7573, 7612, 7613, 7616, 7617, 7618, 7619, 7609, 7644, 7645, 7646, 7647, 7648]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "31364", "oi_productiondate": 1749222564, "oi_createdat": 1749222564, "oi_updatedat": 1749202858, "oi_createdby": 1, "oi_updatedby": null }, { "oi_id": 31365, "oi_jobid": 5767, "oi_jobtempid": "0", "oi_jobmultiquoteid": 5798, "oi_productid": 9, "oi_recipeid": 9, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 0, "oi_customseq": 0, "oi_productcustomseq": 0, "oi_jsondata": "[{\"id\":6887,\"labelname\":\"Unit Type\",\"value\":2,\"valueid\":\"2\",\"type\":34,\"optionid\":\"2\",\"optionvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":\"\",\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":319,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"1\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":320,\"labelname\":\"Supplier\",\"value\":1,\"valueid\":\"\",\"type\":17,\"optionid\":\"1\",\"optionvalue\":[{\"id\":1,\"optionid\":1,\"optionname\":\"Markilux\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":322,\"labelname\":\"Room\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":323,\"labelname\":\"Width\",\"value\":\"500\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":324,\"labelname\":\"Drop\",\"value\":\"200\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":321,\"labelname\":\"Product Type\",\"value\":474,\"valueid\":\"621\",\"type\":13,\"optionid\":\"474\",\"optionvalue\":[{\"id\":621,\"fieldid\":321,\"fieldoptionlinkid\":621,\"optionid\":474,\"mainsupplier\":1,\"blindtypecode\":\"101\",\"optionname\":\"band z\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":325,\"labelname\":\"Vision Panel Size\",\"value\":\"125mm\",\"valueid\":\"1061\",\"type\":3,\"optionid\":\"775\",\"optionvalue\":[{\"optionid\":775,\"optionname\":\"125mm\",\"optioncode\":\"\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":1061,\"forchildfieldoptionlinkid\":\"3_1061\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":1061}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":326,\"labelname\":\"Measure To\",\"value\":\"Blind Size\",\"valueid\":\"1064\",\"type\":3,\"optionid\":\"778\",\"optionvalue\":[{\"optionid\":778,\"optionname\":\"Blind Size\",\"optioncode\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":1064,\"forchildfieldoptionlinkid\":\"3_1064\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":327,\"labelname\":\"Controls\",\"value\":\"Left hand operation\",\"valueid\":\"1065\",\"type\":3,\"optionid\":\"482\",\"optionvalue\":[{\"optionid\":482,\"optionname\":\"Left hand operation\",\"optioncode\":\"jndf\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":1065,\"forchildfieldoptionlinkid\":\"3_1065\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":1065}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":328,\"labelname\":\"Brackets\",\"value\":\"Face Fix\",\"valueid\":\"1070\",\"type\":3,\"optionid\":\"488\",\"optionvalue\":[{\"optionid\":488,\"optionname\":\"Face Fix\",\"optioncode\":\"\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":1070,\"forchildfieldoptionlinkid\":\"3_1070\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":329,\"labelname\":\"Chain Colour\",\"value\":\"Nickel\",\"valueid\":\"1072\",\"type\":3,\"optionid\":\"469\",\"optionvalue\":[{\"optionid\":469,\"optionname\":\"Nickel\",\"optioncode\":\"6\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":1072,\"forchildfieldoptionlinkid\":\"3_1072\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":1072}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":330,\"labelname\":\"Roll\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":331,\"labelname\":\"System Type\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":332,\"labelname\":\"Tube Size\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":335,\"labelname\":\"Control Type\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":333,\"labelname\":\"Motorisation\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":336,\"labelname\":\"Fixing\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":337,\"labelname\":\"Extras\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":7270,\"labelname\":\"Product Type\",\"value\":\"\",\"valueid\":\"\",\"type\":13,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]", "oi_description": "Unit Type: mm, Quantity: 1, Supplier: Markilux, Width: 500, Drop: 200, Vision Panel Size: 125mm, Measure To: Blind Size, Controls: Left hand operation, Brackets: Face Fix, Chain Colour: Nickel", "oi_reportdescription": "##Quantity: 1##,##Supplier: Markilux##,##Width: 500 mm##,##Drop: 200 mm##,##Vision Panel Size: 125mm##,##Measure To: Blind Size##,##Controls: Left hand operation##,##Brackets: Face Fix##,##Chain Colour: Nickel##", "oi_reporttitles": "##Quantity:##Supplier:##Width:##Drop:##Vision Panel Size:##Measure To:##Controls:##Brackets:##Chain Colour:", "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": "400.000", "oi_netprice": "400.000", "oi_pricesfromoperations": null, "oi_vatprice": "40.000", "oi_vatvalue": "10.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "440.000", "oi_overrideprice": "0.000", "oi_overridetype": 6, "oi_overridevalue": null, "oi_overridenetprice": "400.000", "oi_overridevatprice": "40.000", "oi_overridegrossprice": "440.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 0, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 6, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "400.000", "oi_endcustomeroverridevatprice": "40.000", "oi_endcustomeroverridegrossprice": "440.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[6887, 319, 320, 322, 323, 324, 321, 325, 326, 327, 328, 329, 330, 331, 332, 335, 333, 336, 337, 7270]", "oi_deviceplatform": 2, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "31365", "oi_productiondate": 1749203905, "oi_createdat": 1749203943, "oi_updatedat": 1749210903, "oi_createdby": 1, "oi_updatedby": null }, { "oi_id": 31366, "oi_jobid": 5767, "oi_jobtempid": "0", "oi_jobmultiquoteid": 5798, "oi_productid": 9, "oi_recipeid": 9, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 0, "oi_customseq": 0, "oi_productcustomseq": 0, "oi_jsondata": "[{\"id\":6887,\"labelname\":\"Unit Type\",\"value\":2,\"valueid\":\"2\",\"type\":34,\"optionid\":\"2\",\"optionvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":\"\",\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":319,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"1\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":320,\"labelname\":\"Supplier\",\"value\":1,\"valueid\":\"\",\"type\":17,\"optionid\":\"1\",\"optionvalue\":[{\"id\":1,\"optionid\":1,\"optionname\":\"Markilux\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":322,\"labelname\":\"Room\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":323,\"labelname\":\"Width\",\"value\":\"500\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":324,\"labelname\":\"Drop\",\"value\":\"200\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":321,\"labelname\":\"Product Type\",\"value\":474,\"valueid\":\"621\",\"type\":13,\"optionid\":\"474\",\"optionvalue\":[{\"id\":621,\"fieldid\":321,\"fieldoptionlinkid\":621,\"optionid\":474,\"mainsupplier\":1,\"blindtypecode\":\"101\",\"optionname\":\"band z\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":325,\"labelname\":\"Vision Panel Size\",\"value\":\"125mm\",\"valueid\":\"1061\",\"type\":3,\"optionid\":\"775\",\"optionvalue\":[{\"optionid\":775,\"optionname\":\"125mm\",\"optioncode\":\"\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":1061,\"forchildfieldoptionlinkid\":\"3_1061\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":1061}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":326,\"labelname\":\"Measure To\",\"value\":\"Blind Size\",\"valueid\":\"1064\",\"type\":3,\"optionid\":\"778\",\"optionvalue\":[{\"optionid\":778,\"optionname\":\"Blind Size\",\"optioncode\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":1064,\"forchildfieldoptionlinkid\":\"3_1064\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":327,\"labelname\":\"Controls\",\"value\":\"Left hand operation\",\"valueid\":\"1065\",\"type\":3,\"optionid\":\"482\",\"optionvalue\":[{\"optionid\":482,\"optionname\":\"Left hand operation\",\"optioncode\":\"jndf\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":1065,\"forchildfieldoptionlinkid\":\"3_1065\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":1065}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":328,\"labelname\":\"Brackets\",\"value\":\"Face Fix\",\"valueid\":\"1070\",\"type\":3,\"optionid\":\"488\",\"optionvalue\":[{\"optionid\":488,\"optionname\":\"Face Fix\",\"optioncode\":\"\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":1070,\"forchildfieldoptionlinkid\":\"3_1070\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":329,\"labelname\":\"Chain Colour\",\"value\":\"Nickel\",\"valueid\":\"1072\",\"type\":3,\"optionid\":\"469\",\"optionvalue\":[{\"optionid\":469,\"optionname\":\"Nickel\",\"optioncode\":\"6\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":1072,\"forchildfieldoptionlinkid\":\"3_1072\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":1072}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":330,\"labelname\":\"Roll\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":331,\"labelname\":\"System Type\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":332,\"labelname\":\"Tube Size\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":335,\"labelname\":\"Control Type\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":333,\"labelname\":\"Motorisation\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":336,\"labelname\":\"Fixing\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":337,\"labelname\":\"Extras\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":7270,\"labelname\":\"Product Type\",\"value\":\"\",\"valueid\":\"\",\"type\":13,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]", "oi_description": "Supplier: Markilux, Width: 500, Drop: 200, Product Type: band z, Vision Panel Size: 125mm, Measure To: Blind Size, Controls: Left hand operation, Brackets: Face Fix, Chain Colour: Nickel", "oi_reportdescription": "##Quantity: 1##,##Supplier: Markilux##,##Width: 500 mm##,##Drop: 200 mm##,##Product Type: band z##,##Vision Panel Size: 125mm##,##Measure To: Blind Size##,##Controls: Left hand operation##,##Brackets: Face Fix##,##Chain Colour: Nickel##", "oi_reporttitles": "##Quantity:##Supplier:##Width:##Drop:##Product Type:##Vision Panel Size:##Measure To:##Controls:##Brackets:##Chain Colour:", "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": "400.000", "oi_netprice": "400.000", "oi_pricesfromoperations": null, "oi_vatprice": "40.000", "oi_vatvalue": "10.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "440.000", "oi_overrideprice": "0.000", "oi_overridetype": 6, "oi_overridevalue": null, "oi_overridenetprice": "400.000", "oi_overridevatprice": "40.000", "oi_overridegrossprice": "440.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 0, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 6, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "0.000", "oi_endcustomeroverridevatprice": "0.000", "oi_endcustomeroverridegrossprice": "0.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[6887, 319, 320, 322, 323, 324, 321, 325, 326, 327, 328, 329, 330, 331, 332, 335, 333, 336, 337, 7270]", "oi_deviceplatform": 2, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "31366", "oi_productiondate": 1749203905, "oi_createdat": 1749204929, "oi_updatedat": 1749210903, "oi_createdby": 1, "oi_updatedby": null } ], "updated": [], "deleted": [] }, "bm_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_notelist": { "created": [ { "nl_id": 105249, "nl_ordertempid": null, "nl_orderid": 5766, "nl_notescategory": 1, "nl_type": 24, "nl_platform": 1, "nl_desc": "test data", "nl_manualNotes": null, "nl_createdby": "1", "nl_attachmnettext": "1749203407.jpg", "nl_attachmnetURL": null, "nl_isonlinenote": 1, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "105249", "nl_endddate": 1749168000, "nl_starttime": 1749223207, "created_at": 1749203407, "updated_at": 1749203407, "created_by": 1, "updated_by": null }, { "nl_id": 105250, "nl_ordertempid": null, "nl_orderid": 5766, "nl_notescategory": 0, "nl_type": 0, "nl_platform": 0, "nl_desc": null, "nl_manualNotes": null, "nl_createdby": "1", "nl_attachmnettext": "", "nl_attachmnetURL": null, "nl_isonlinenote": 1, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "105250", "nl_endddate": null, "nl_starttime": 1749168000, "created_at": 1749204929, "updated_at": 1749204930, "created_by": 1, "updated_by": null }, { "nl_id": 105251, "nl_ordertempid": 0, "nl_orderid": 5767, "nl_notescategory": 1, "nl_type": 17, "nl_platform": 2, "nl_desc": "New job has been created in job", "nl_manualNotes": null, "nl_createdby": "1", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 0, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "105251", "nl_endddate": 1749168000, "nl_starttime": 1749203891, "created_at": 1749203891, "updated_at": 1749210903, "created_by": 1, "updated_by": null } ], "updated": [], "deleted": [] }, "bm_deliveryaddresssetting": { "created": [ { "das_id": 5623, "das_jobid": 5767, "das_appointmentaddress": 4230, "das_invoiceaddress": 4230, "das_invoicedeliveryaddress": 4230, "das_purchaseaddress": 0, "das_worksheetaddress": 0, "id": "5623", "das_createdat": 1749210903, "das_updatedat": 1749210903, "das_createdby": 1, "das_updatedby": null } ], "updated": [], "deleted": [] }, "bm_jobchecklist": { "created": [], "updated": [], "deleted": [] }, "bm_Invoice": { "created": [], "updated": [], "deleted": [] }, "bm_InvoiceDetails": { "created": [], "updated": [], "deleted": [] }, "bm_invoice_credit_note": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNote": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNoteDetails": { "created": [], "updated": [], "deleted": [] }, "bm_job_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_OverPayment": { "created": [], "updated": [], "deleted": [] }, "bm_terms": { "created": [], "updated": [], "deleted": [] }, "bm_jobmultiquote": { "created": [ { "jmq_id": 5798, "jmq_jobid": 5767, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "800.00", "jmq_netprice": "870.00", "jmq_vat": "87.00", "jmq_isvaton": 1, "jmq_deliverycost": "70.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 8, "jmq_orderformprice": "0.00", "jmq_editpricebyid": null, "jmq_isroundon": 0, "jmq_grossprice": "960.00", "jmq_grossprofit": "70.00", "jmq_costprice": "800.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "960.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": "10.000", "jmq_cdeliveryvatperc": "10.000", "id": "5798", "jmq_duedate": 1749168000, "jmq_sceduleddate": null, "jmq_createdat": "1749203891.000000", "jmq_updatedat": "1749210903.000000", "jmq_createdby": 1, "jmq_updatedby": 1 } ], "updated": [ { "jmq_id": 5798, "jmq_jobid": 5767, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "800.00", "jmq_netprice": "870.00", "jmq_vat": "87.00", "jmq_isvaton": 1, "jmq_deliverycost": "70.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 8, "jmq_orderformprice": "0.00", "jmq_editpricebyid": null, "jmq_isroundon": 0, "jmq_grossprice": "960.00", "jmq_grossprofit": "70.00", "jmq_costprice": "800.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "960.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": "10.000", "jmq_cdeliveryvatperc": "10.000", "id": "5798", "jmq_duedate": 1749168000, "jmq_sceduleddate": null, "jmq_createdat": "1749203891.000000", "jmq_updatedat": "1749210903.000000", "jmq_createdby": 1, "jmq_updatedby": 1 } ], "deleted": [] }, "bm_jobstatus_tracks": { "created": [ { "jst_id": 6460, "jst_jobid": 5767, "jst_job_current_status": 1, "id": "6460", "jst_createdat": "1749210903.625214" } ], "updated": [], "deleted": [] }, "bm_customindividuallogs": { "created": [ { "cl_id": 58137, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105249, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 5766, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"Mobile Signature\",\"Platform\":\"All Options\",\"Description\":\"test data\",\"Created By\":\"admin\",\"Date\":\"2025-06-06\",\"Time\":\"15:20:07\",\"Is online note\":\"Yes\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105249,\"nl_ordertempid\":null,\"nl_orderid\":5766,\"nl_notescategory\":1,\"nl_type\":24,\"nl_platform\":1,\"nl_desc\":\"test data\",\"nl_manualNotes\":null,\"nl_createdby\":\"1\",\"nl_endddate\":\"2025-06-06\",\"nl_starttime\":\"15:20:07\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":1,\"nl_seq\":0,\"nl_status\":0,\"created_by\":1,\"created_at\":\"2025-06-06T09:50:07.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-06T09:50:07.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "58137", "cl_createdat": "1749203407.000000", "cl_updatedat": null }, { "cl_id": 58138, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "Notes has been updated the fields Time,Attachment,Is online note", "cl_event": "modified", "cl_subjectid": 105249, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 5766, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "{\"Time\":\"15:20:07:34\"}", "cl_changedto": "{\"Time\":\"15:20:07\",\"Attachment\":\"1749203407.jpg\",\"Is online note\":\"Yes\"}", "cl_customproperties": "{\"attributes\":{\"nl_starttime\":\"15:20:07\",\"nl_attachmnettext\":\"1749203407.jpg\",\"nl_isonlinenote\":1,\"nl_seq\":0,\"nl_status\":0},\"old\":{\"nl_starttime\":\"15:20:07:34\",\"nl_attachmnettext\":null,\"nl_isonlinenote\":null,\"nl_seq\":null,\"nl_status\":null}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "58138", "cl_createdat": "1749203407.000000", "cl_updatedat": null }, { "cl_id": 58139, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the field ", "cl_event": "modified", "cl_subjectid": 5766, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5766, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "[]", "cl_changedto": "{\"\":13}", "cl_customproperties": "{\"attributes\":{\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"AQ5763\\\",\\\"35\\\":\\\"KJAC0001\\\",\\\"36\\\":1,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":\\\"\\\",\\\"40\\\":13,\\\"41\\\":1,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"Jack\\\",\\\"46\\\":\\\"K\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":36,\\\"285\\\":1,\\\"286\\\":\\\"6578567658\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":1,\\\"558\\\":\\\"\\\",\\\"559\\\":\\\"3\\\",\\\"610\\\":\\\"\\\",\\\"611\\\":\\\"\\\",\\\"612\\\":1}\",\"jd_listprice\":\"375.00\",\"jd_userdefinedarray\":\"\\\"\\\\\\\"\\\\\\\"\\\"\",\"jd_endcustomeroverridevalue\":\"\",\"jd_endcustomerdeliverycost\":\"\",\"jd_endcustomerfittingcost\":\"\",\"jd_updatedat\":\"2025-06-06T09:50:15.000000Z\"},\"old\":{\"jd_jobcustomoizedkeyvalue\":\"{\\\"33\\\":25,\\\"37\\\":1,\\\"39\\\":\\\"\\\",\\\"41\\\":1,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"Jack\\\",\\\"46\\\":\\\"K\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":36,\\\"285\\\":1,\\\"286\\\":\\\"6578567658\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":1,\\\"558\\\":\\\"\\\",\\\"559\\\":\\\"3\\\",\\\"610\\\":\\\"\\\",\\\"611\\\":\\\"\\\",\\\"612\\\":1}\",\"jd_listprice\":\"445.00\",\"jd_userdefinedarray\":\"\\\"\\\"\",\"jd_endcustomeroverridevalue\":null,\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerfittingcost\":null,\"jd_updatedat\":\"2025-06-06T09:41:01.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "58139", "cl_createdat": "1749203415.000000", "cl_updatedat": null }, { "cl_id": 58140, "cl_logname": "default", "cl_type": null, "cl_modulename": "Task", "cl_message": "new item has been created in Task", "cl_event": "created", "cl_subjectid": 102, "cl_subjecttype": "App\\Models\\Task\\bm_tasklist", "cl_parentid": 102, "cl_parentsubjecttype": "App\\Models\\Task\\bm_tasklist", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"data\":\"2\",\"Category\":\"Critical\",\"Task Date\":\"2025-06-06\",\"Task Time\":\"00:21:18\",\"tl_istaskprivate\":1,\"Created By\":\"Abi\",\"Description\":\"Test data @sampless\",\"Repeat Method\":\"daily\",\"tl_deviceplatform\":1,\"tl_subject\":\"Mobile Task\"}", "cl_customproperties": "{\"attributes\":{\"tl_id\":102,\"tl_orderid\":0,\"tl_taskcategory\":1,\"tl_taskdate\":\"2025-06-06\",\"tl_tasktime\":\"00:21:18\",\"tl_taskmethod\":\"0\",\"tl_istaskprivate\":1,\"tl_userid\":\"4\",\"tl_priority\":0,\"tl_addjobid\":0,\"tl_desc\":\"Test data @sampless\",\"tl_status\":0,\"tl_markasread\":0,\"tl_taskstatus\":1,\"tl_userdefinedfields\":\"{\\\"1\\\":\\\"\\\",\\\"2\\\":\\\"2\\\",\\\"3\\\":\\\"2025-06-10T09:51:00.000Z\\\"}\",\"tl_markcompleted\":0,\"tl_jobmode\":\"0\",\"tl_recurrencerule\":\"\",\"tl_repeatmaindescription\":\"\",\"tl_repeatmethod\":\"daily\",\"tl_starttask\":\"\",\"tl_startdata\":\"\",\"tl_endtask\":\"\",\"tl_enddata\":\"\",\"tl_createdat\":\"2025-06-06T09:57:05.000000Z\",\"tl_createdby\":1,\"tl_updatedby\":null,\"tl_updatedat\":\"2025-06-06T09:57:05.000000Z\",\"tl_istaskrepeat\":0,\"tl_deviceplatform\":1,\"tl_subject\":\"Mobile Task\",\"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": "58140", "cl_createdat": "1749203825.000000", "cl_updatedat": null }, { "cl_id": 58141, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment-Notification", "cl_message": "new item has been created in Appointment-Notification", "cl_event": "created", "cl_subjectid": 91, "cl_subjecttype": "App\\Models\\Task\\bm_tasknotification", "cl_parentid": 117, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"tn_id\":91,\"tn_noficationfrom\":\"task\",\"Notification Type\":\"0\",\"Notification Time\":\"00:21:18\",\"created_by\":1,\"created_at\":\"2025-06-06T09:57:05.000000Z\",\"bm_tasklist_tl_id\":102}", "cl_customproperties": "{\"attributes\":{\"tn_id\":91,\"tn_noficationfrom\":\"task\",\"tn_noficationtype\":\"0\",\"tn_noficationtime\":\"00:21:18\",\"tn_templateid\":null,\"tn_status\":0,\"created_by\":1,\"created_at\":\"2025-06-06T09:57:05.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-06T09:57:05.000000Z\",\"bm_tasklist_tl_id\":102,\"tn_reminder_value\":null,\"tn_reminder_before\":null}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "58141", "cl_createdat": "1749203825.000000", "cl_updatedat": null }, { "cl_id": 58142, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment-Notification", "cl_message": "new item has been created in Appointment-Notification", "cl_event": "created", "cl_subjectid": 92, "cl_subjecttype": "App\\Models\\Task\\bm_tasknotification", "cl_parentid": 92, "cl_parentsubjecttype": "App\\Models\\Task\\bm_tasknotification", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"tn_id\":92,\"tn_noficationfrom\":\"task\",\"Notification Type\":\"0\",\"Notification Time\":\"00:21:18\",\"created_by\":1,\"created_at\":\"2025-06-06T09:57:24.000000Z\",\"bm_tasklist_tl_id\":0}", "cl_customproperties": "{\"attributes\":{\"tn_id\":92,\"tn_noficationfrom\":\"task\",\"tn_noficationtype\":\"0\",\"tn_noficationtime\":\"00:21:18\",\"tn_templateid\":null,\"tn_status\":0,\"created_by\":1,\"created_at\":\"2025-06-06T09:57:24.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-06T09:57:24.000000Z\",\"bm_tasklist_tl_id\":0,\"tn_reminder_value\":null,\"tn_reminder_before\":null}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "58142", "cl_createdat": "1749203844.000000", "cl_updatedat": null }, { "cl_id": 58143, "cl_logname": "default", "cl_type": null, "cl_modulename": "Alternative Address", "cl_message": "Alternative Address has been updated the field Invoice Add", "cl_event": "modified", "cl_subjectid": 5622, "cl_subjecttype": "App\\Models\\Job\\bm_deliveryaddresssetting", "cl_parentid": 5766, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "{\"Invoice Add\":\"Alternative Delivery Address (First Name=Jack,Last Name=K)\"}", "cl_changedto": "{\"Invoice Add\":\"Alternative Delivery Address (First Name=Moon,Last Name=M,Address1=Test Data %4012344)\"}", "cl_customproperties": "{\"attributes\":{\"das_invoiceaddress\":4229,\"das_updatedat\":\"2025-06-06T09:58:57.000000Z\"},\"old\":{\"das_invoiceaddress\":4228,\"das_updatedat\":\"2025-06-06T09:39:22.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "58143", "cl_createdat": "1749203938.000000", "cl_updatedat": null }, { "cl_id": 58144, "cl_logname": "default", "cl_type": null, "cl_modulename": "Alternative Address", "cl_message": "Alternative Address has been updated the field Appointments Add", "cl_event": "modified", "cl_subjectid": 5622, "cl_subjecttype": "App\\Models\\Job\\bm_deliveryaddresssetting", "cl_parentid": 5766, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "{\"Appointments Add\":\"Alternative Delivery Address (First Name=Jack,Last Name=K)\"}", "cl_changedto": "{\"Appointments Add\":\"Alternative Delivery Address (First Name=Moon,Last Name=M,Address1=Test Data %4012344)\"}", "cl_customproperties": "{\"attributes\":{\"das_appointmentaddress\":4229,\"das_updatedat\":\"2025-06-06T09:59:03.000000Z\"},\"old\":{\"das_appointmentaddress\":4228,\"das_updatedat\":\"2025-06-06T09:58:57.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "58144", "cl_createdat": "1749203943.000000", "cl_updatedat": null }, { "cl_id": 58145, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the field Additional Contacts", "cl_event": "modified", "cl_subjectid": 5766, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5766, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "{\"Additional Contacts\":\"4228\"}", "cl_changedto": "{\"Additional Contacts\":\"4228,8\"}", "cl_customproperties": "{\"attributes\":{\"jd_additionalcontacts\":\"4228,8\",\"jd_userdefinedarray\":\"\\\"\\\\\\\"\\\\\\\\\\\\\\\"\\\\\\\\\\\\\\\"\\\\\\\"\\\"\",\"jd_updatedat\":\"2025-06-06T10:04:06.000000Z\"},\"old\":{\"jd_additionalcontacts\":\"4228\",\"jd_userdefinedarray\":\"\\\"\\\\\\\"\\\\\\\"\\\"\",\"jd_updatedat\":\"2025-06-06T09:50:15.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "58145", "cl_createdat": "1749204246.000000", "cl_updatedat": null }, { "cl_id": 58146, "cl_logname": "default", "cl_type": null, "cl_modulename": "Alternative Address", "cl_message": "Alternative Address has been updated the field Appointments Add", "cl_event": "modified", "cl_subjectid": 5622, "cl_subjecttype": "App\\Models\\Job\\bm_deliveryaddresssetting", "cl_parentid": 5766, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "{\"Appointments Add\":\"Alternative Delivery Address (First Name=Moon,Last Name=M,Address1=Test Data %4012344)\"}", "cl_changedto": "{\"Appointments Add\":\"Alternative Delivery Address (First Name=Joe,Last Name=Bloggs,Address1=1 Culvers Avenue ,Address2= )\"}", "cl_customproperties": "{\"attributes\":{\"das_appointmentaddress\":8,\"das_updatedat\":\"2025-06-06T10:04:22.000000Z\"},\"old\":{\"das_appointmentaddress\":4229,\"das_updatedat\":\"2025-06-06T09:59:03.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "58146", "cl_createdat": "1749204262.000000", "cl_updatedat": null }, { "cl_id": 58147, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment", "cl_message": "new item has been created in Appointment", "cl_event": "created", "cl_subjectid": 10054, "cl_subjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_parentid": 5766, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Repeat On\":\"yearly on June 06\",\"app_summary\":\"AQ5763-Jack K-6578567658-Surveyor\",\"Appointment Type\":\"Surveyor\",\"Staff\":\"Kristian\",\"Job Ref No\":\"AQ5763\",\"Start Date & Time\":\"2025-06-06 09:30:36\",\"End Date & Time\":\"2025-06-06 10:00:36\",\"Appointment Status\":\"Waiting\",\"app_deliveryaddressid\":8,\"app_jobtimeminute\":\"30\",\"app_deviceplatform\":1}", "cl_customproperties": "{\"attributes\":{\"app_eventid\":10054,\"app_description\":null,\"app_summary\":\"AQ5763-Jack K-6578567658-Surveyor\",\"app_private\":0,\"app_appointmentType\":63,\"app_userId\":7,\"app_orderId\":5766,\"app_customerId\":0,\"app_isAllDay\":0,\"app_sdate\":\"2025-06-06\",\"app_edate\":\"2025-06-06\",\"app_stime\":\"09:30:36\",\"app_etime\":\"10:00:36\",\"app_sdatetime\":\"2025-06-06 09:30:36\",\"app_edatetime\":\"2025-06-06 10:00:36\",\"app_timezone\":\"Asia\\\/Calcutta\",\"app_latitude\":null,\"app_longitude\":null,\"app_parentappid\":null,\"app_recurrencerule\":null,\"app_userdefinedValue\":\"[]\",\"app_recurrenceexception\":null,\"app_recurrenceexception_date\":null,\"app_attachment\":null,\"guid\":\"\",\"app_until\":null,\"app_staff\":\"\",\"app_appointtype\":\"\",\"app_confirmed\":0,\"app_coordinates\":\"\",\"app_travelHour\":\"0\",\"app_travelMinute\":\"0\",\"app_onsiteHour\":\"0\",\"app_onsiteMinute\":\"0\",\"app_location\":null,\"app_traveltime\":null,\"app_googleid\":\"0\",\"app_platform\":\"web\",\"app_cal_status\":868,\"app_status\":0,\"app_markasread\":0,\"app_statusInGoogle\":0,\"app_createdBy\":1,\"app_updatedBy\":null,\"app_createdAt\":\"2025-06-06T10:04:51.000000Z\",\"app_updatedAt\":\"2025-06-06T10:04:51.000000Z\",\"app_runid\":0,\"app_deliveryaddressid\":8,\"app_jobtimehour\":\"0\",\"app_jobtimeminute\":\"30\",\"app_products\":null,\"app_deviceplatform\":1}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "58147", "cl_createdat": "1749204291.000000", "cl_updatedat": null }, { "cl_id": 58148, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment", "cl_message": "Appointment has been updated the field Uploaded Attachment", "cl_event": "modified", "cl_subjectid": 10054, "cl_subjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_parentid": 5766, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "[]", "cl_changedto": "{\"Uploaded Attachment\":\"[]\"}", "cl_customproperties": "{\"attributes\":{\"app_attachment\":\"[]\",\"app_updatedAt\":\"2025-06-06T10:04:53.000000Z\"},\"old\":{\"app_attachment\":null,\"app_updatedAt\":\"2025-06-06T10:04:51.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "58148", "cl_createdat": "1749204293.000000", "cl_updatedat": null }, { "cl_id": 58149, "cl_logname": "default", "cl_type": null, "cl_modulename": "All Jobs", "cl_message": "Quotation report generated by admin All Jobs", "cl_event": "created", "cl_subjectid": 7701, "cl_subjecttype": "App\\Models\\Reports\\bm_reportactivitylog", "cl_parentid": 5766, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Category: \":\"Quotation\"}", "cl_customproperties": "{\"attributes\":{\"ral_id\":7701,\"ral_jobid\":5766,\"ral_reportid\":1,\"ral_categoryid\":1,\"ral_description\":\"Quotation report generated by admin\",\"ral_attachment\":\"\",\"ral_actionid\":1,\"ral_createdat\":\"2025-06-06T10:05:29.000000Z\",\"ral_updatedat\":\"2025-06-06T10:05:29.000000Z\",\"ral_createdby\":1,\"ral_updatedby\":null}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "58149", "cl_createdat": "1749204329.000000", "cl_updatedat": null }, { "cl_id": 58150, "cl_logname": "default", "cl_type": null, "cl_modulename": "All Jobs", "cl_message": "Quotation report generated by admin All Jobs", "cl_event": "created", "cl_subjectid": 7702, "cl_subjecttype": "App\\Models\\Reports\\bm_reportactivitylog", "cl_parentid": 2147483647, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Category: \":\"Quotation\"}", "cl_customproperties": "{\"attributes\":{\"ral_id\":7702,\"ral_jobid\":2147483647,\"ral_reportid\":1,\"ral_categoryid\":1,\"ral_description\":\"Quotation report generated by admin\",\"ral_attachment\":\"\",\"ral_actionid\":1,\"ral_createdat\":\"2025-06-06T10:11:11.000000Z\",\"ral_updatedat\":\"2025-06-06T10:11:11.000000Z\",\"ral_createdby\":1,\"ral_updatedby\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "58150", "cl_createdat": "1749204671.000000", "cl_updatedat": null }, { "cl_id": 58151, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "Notes has been updated the fields Type,Platform,Time,Is online note", "cl_event": "modified", "cl_subjectid": 105250, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 5766, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "[]", "cl_changedto": "{\"Type\":null,\"Platform\":\"Immediate\",\"Time\":\"00:00:00\",\"Is online note\":\"Yes\"}", "cl_customproperties": "{\"attributes\":{\"nl_notescategory\":0,\"nl_type\":0,\"nl_platform\":0,\"nl_starttime\":\"00:00:00\",\"nl_attachmnettext\":\"\",\"nl_isonlinenote\":1,\"nl_seq\":0,\"nl_status\":0,\"updated_at\":\"2025-06-06T10:15:30.000000Z\"},\"old\":{\"nl_notescategory\":null,\"nl_type\":null,\"nl_platform\":null,\"nl_starttime\":null,\"nl_attachmnettext\":null,\"nl_isonlinenote\":null,\"nl_seq\":null,\"nl_status\":null,\"updated_at\":\"2025-06-06T10:15:29.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "58151", "cl_createdat": "1749204930.000000", "cl_updatedat": null }, { "cl_id": 58152, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 5767, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5767, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"Aquarius Blinds\",\"\":13,\"Account Type\":\"Domestic\",\"Created By\":\"admin\",\"First Name\":\"Mob\",\"Last Name\":\"Test\",\"Country\":\"India\",\"Salutation\":\"Dr\",\"Assigned to\":1,\"Additional Contacts\":\"4230\",\"Production Due Date\":\"2025-06-05\",\"Completed Date\":\"1970-01-01\",\"Job Ref No\":\"AQ5764\",\"Job Status\":\"Lead\",\"Order Status\":\"Enquiry\",\"Net Price\":\"870.00\",\"VAT Price\":\"87.00\",\"VAT\":\"Enabled\",\"DeliveryCost\":\"70.00\",\"Delivery Cost\":\"All Options\",\"Gross Price Amount\":\"960.00\",\"Gross Profit\":\"70.00\",\"Total CostPrice\":\"800.00\",\"Amount Outstanding\":\"960.00\",\"jd_isonlineorder\":1,\"Delivery Vat Percentage\":\"10.000\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":5767,\"jd_customerid\":4047,\"jd_contactid\":4230,\"jd_additionalcontacts\":\"4230\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"AQ5764\\\",\\\"35\\\":\\\"TEST0017\\\",\\\"36\\\":1,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":\\\"\\\",\\\"40\\\":13,\\\"41\\\":1,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"Mob\\\",\\\"46\\\":\\\"Test\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":36,\\\"285\\\":12,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":1,\\\"558\\\":\\\"\\\",\\\"559\\\":1,\\\"610\\\":\\\"\\\",\\\"611\\\":\\\"\\\",\\\"612\\\":1}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-06-06\",\"jd_orderdate\":null,\"jd_duedate\":\"2025-06-05\",\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":\"1970-01-01\",\"jd_jobref\":\"AQ5764\",\"jd_jobstatus\":1,\"jd_contactaddid\":0,\"jd_orderstatus\":13,\"jd_accref\":\"TEST0017\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"800.00\",\"jd_netprice\":\"870.00\",\"jd_vat\":\"87.00\",\"jd_isvaton\":1,\"jd_deliverycost\":\"70.00\",\"jd_deliverycosttypeid\":1,\"jd_overridetypeid\":8,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":null,\"jd_isroundon\":0,\"jd_grossprice\":\"960.00\",\"jd_grossprofit\":\"70.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"800.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"960.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-06-06T09:58:11.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-06-06T11:55:03.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\":\"10.000\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"10.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": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "58152", "cl_createdat": "1749210903.000000", "cl_updatedat": null }, { "cl_id": 58153, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105251, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 5767, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"Job Created\",\"Platform\":\"Trade\",\"Description\":\"New job has been created in job\",\"Created By\":\"admin\",\"Date\":\"2025-06-06\",\"Time\":\"09:58:11\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105251,\"nl_ordertempid\":0,\"nl_orderid\":5767,\"nl_notescategory\":1,\"nl_type\":17,\"nl_platform\":2,\"nl_desc\":\"New job has been created in job\",\"nl_manualNotes\":null,\"nl_createdby\":\"1\",\"nl_endddate\":\"2025-06-06\",\"nl_starttime\":\"09:58:11\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":1,\"created_at\":\"2025-06-06T09:58:11.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-06T11:55:03.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "58153", "cl_createdat": "1749210903.000000", "cl_updatedat": null }, { "cl_id": 58154, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in AQ5764", "cl_event": "created", "cl_subjectid": 5798, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 5767, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":5798,\"jmq_jobid\":5767,\"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\":\"800.00\",\"Net Price\":\"870.00\",\"VAT Price\":\"87.00\",\"VAT\":1,\"jmq_deliverycost\":\"70.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":8,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"960.00\",\"Gross Profit\":\"70.00\",\"Total CostPrice\":\"800.00\",\"Amount Outstanding\":\"960.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\":\"10.000\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":5798,\"jmq_jobid\":5767,\"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\":\"800.00\",\"jmq_netprice\":\"870.00\",\"jmq_vat\":\"87.00\",\"jmq_isvaton\":1,\"jmq_deliverycost\":\"70.00\",\"jmq_deliverycosttypeid\":1,\"jmq_overridetypeid\":8,\"jmq_orderformprice\":\"0.00\",\"jmq_editpricebyid\":null,\"jmq_isroundon\":0,\"jmq_grossprice\":\"960.00\",\"jmq_grossprofit\":\"70.00\",\"jmq_costprice\":\"800.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"960.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\":\"10.000\",\"jmq_cdeliveryvatperc\":\"10.000\",\"jmq_createdby\":1,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-06-06T09:58:11.000000Z\",\"jmq_updatedat\":null,\"jmq_grossprofit_percentage\":\"0.00\",\"jmq_ready\":0}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "58154", "cl_createdat": "1749210903.000000", "cl_updatedat": null }, { "cl_id": 58155, "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": 5767, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5767, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":5798}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":5798},\"old\":{\"jd_jobmultiquoteid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "58155", "cl_createdat": "1749210903.000000", "cl_updatedat": null }, { "cl_id": 58156, "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 Vision Blinds", "cl_event": "created", "cl_subjectid": 31365, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 5767, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Unit Type\":\" mm\",\" Quantity\":\" 1\",\" Supplier\":\" Markilux\",\" Width\":\" 500\",\" Drop\":\" 200\",\" Vision Panel Size\":\" 125mm\",\" Measure To\":\" Blind Size\",\" Controls\":\" Left hand operation\",\" Brackets\":\" Face Fix\",\" Chain Colour\":\" Nickel\"}", "cl_customproperties": "{\"attributes\":{\"oi_id\":31365,\"oi_jobid\":5767,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":5798,\"oi_credit_id\":0,\"oi_productid\":9,\"oi_recipeid\":9,\"oi_ruleid\":0,\"oi_qty\":1,\"oi_seq\":0,\"oi_customseq\":0,\"oi_productcustomseq\":0,\"oi_jsondata\":\"[{\\\"id\\\":6887,\\\"labelname\\\":\\\"Unit Type\\\",\\\"value\\\":2,\\\"valueid\\\":\\\"2\\\",\\\"type\\\":34,\\\"optionid\\\":\\\"2\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":2,\\\"optionname\\\":\\\"mm\\\",\\\"optioncode\\\":\\\"\\\",\\\"optionquantity\\\":1,\\\"unittype\\\":0,\\\"unitcost\\\":0,\\\"pricingtype\\\":0,\\\"fieldoptionlinkid\\\":2,\\\"forchildfieldoptionlinkid\\\":\\\"34_2\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":319,\\\"labelname\\\":\\\"Quantity\\\",\\\"value\\\":1,\\\"valueid\\\":\\\"\\\",\\\"type\\\":14,\\\"optionid\\\":\\\"1\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":320,\\\"labelname\\\":\\\"Supplier\\\",\\\"value\\\":1,\\\"valueid\\\":\\\"\\\",\\\"type\\\":17,\\\"optionid\\\":\\\"1\\\",\\\"optionvalue\\\":[{\\\"id\\\":1,\\\"optionid\\\":1,\\\"optionname\\\":\\\"Markilux\\\",\\\"deleted\\\":0,\\\"optionquantity\\\":1}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":322,\\\"labelname\\\":\\\"Room\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":323,\\\"labelname\\\":\\\"Width\\\",\\\"value\\\":\\\"500\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":11,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":324,\\\"labelname\\\":\\\"Drop\\\",\\\"value\\\":\\\"200\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":12,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":321,\\\"labelname\\\":\\\"Product Type\\\",\\\"value\\\":474,\\\"valueid\\\":\\\"621\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"474\\\",\\\"optionvalue\\\":[{\\\"id\\\":621,\\\"fieldid\\\":321,\\\"fieldoptionlinkid\\\":621,\\\"optionid\\\":474,\\\"mainsupplier\\\":1,\\\"blindtypecode\\\":\\\"101\\\",\\\"optionname\\\":\\\"band z\\\",\\\"optionquantity\\\":1,\\\"subcount\\\":0,\\\"status\\\":0,\\\"subdatacount\\\":0}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":325,\\\"labelname\\\":\\\"Vision Panel Size\\\",\\\"value\\\":\\\"125mm\\\",\\\"valueid\\\":\\\"1061\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"775\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":775,\\\"optionname\\\":\\\"125mm\\\",\\\"optioncode\\\":\\\"\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":null,\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":1061,\\\"forchildfieldoptionlinkid\\\":\\\"3_1061\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"0.00\\\",\\\"fieldid\\\":1061}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":326,\\\"labelname\\\":\\\"Measure To\\\",\\\"value\\\":\\\"Blind Size\\\",\\\"valueid\\\":\\\"1064\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"778\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":778,\\\"optionname\\\":\\\"Blind Size\\\",\\\"optioncode\\\":\\\"\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":1064,\\\"forchildfieldoptionlinkid\\\":\\\"3_1064\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":327,\\\"labelname\\\":\\\"Controls\\\",\\\"value\\\":\\\"Left hand operation\\\",\\\"valueid\\\":\\\"1065\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"482\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":482,\\\"optionname\\\":\\\"Left hand operation\\\",\\\"optioncode\\\":\\\"jndf\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":null,\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":1065,\\\"forchildfieldoptionlinkid\\\":\\\"3_1065\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"0.00\\\",\\\"fieldid\\\":1065}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":328,\\\"labelname\\\":\\\"Brackets\\\",\\\"value\\\":\\\"Face Fix\\\",\\\"valueid\\\":\\\"1070\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"488\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":488,\\\"optionname\\\":\\\"Face Fix\\\",\\\"optioncode\\\":\\\"\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":null,\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":1070,\\\"forchildfieldoptionlinkid\\\":\\\"3_1070\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":329,\\\"labelname\\\":\\\"Chain Colour\\\",\\\"value\\\":\\\"Nickel\\\",\\\"valueid\\\":\\\"1072\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"469\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":469,\\\"optionname\\\":\\\"Nickel\\\",\\\"optioncode\\\":\\\"6\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":1072,\\\"forchildfieldoptionlinkid\\\":\\\"3_1072\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"0.00\\\",\\\"fieldid\\\":1072}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":330,\\\"labelname\\\":\\\"Roll\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":331,\\\"labelname\\\":\\\"System Type\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":332,\\\"labelname\\\":\\\"Tube Size\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":335,\\\"labelname\\\":\\\"Control Type\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":333,\\\"labelname\\\":\\\"Motorisation\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":336,\\\"labelname\\\":\\\"Fixing\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":337,\\\"labelname\\\":\\\"Extras\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7270,\\\"labelname\\\":\\\"Product Type\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0}]\",\"oi_description\":\"Unit Type: mm, Quantity: 1, Supplier: Markilux, Width: 500, Drop: 200, Vision Panel Size: 125mm, Measure To: Blind Size, Controls: Left hand operation, Brackets: Face Fix, Chain Colour: Nickel\",\"oi_onlinedescription\":null,\"oi_imagepath\":null,\"oi_reportdescription\":\"##Quantity: 1##,##Supplier: Markilux##,##Width: 500 mm##,##Drop: 200 mm##,##Vision Panel Size: 125mm##,##Measure To: Blind Size##,##Controls: Left hand operation##,##Brackets: Face Fix##,##Chain Colour: Nickel##\",\"oi_onlinereportdescription\":null,\"oi_reporttitles\":\"##Quantity:##Supplier:##Width:##Drop:##Vision Panel Size:##Measure To:##Controls:##Brackets:##Chain Colour:\",\"oi_onlinereporttitles\":null,\"oi_productionformulajsondata\":\"[]\",\"oi_productiondate\":\"2025-06-06 09:58:25\",\"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\":\"400.000\",\"oi_netprice\":\"400.000\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"40.000\",\"oi_vatvalue\":\"10.000\",\"oi_vatselected\":1,\"oi_vattype\":1,\"oi_vatonoff\":1,\"oi_grossprice\":\"440.000\",\"oi_overrideprice\":\"0.000\",\"oi_overridetype\":6,\"oi_overridevalue\":null,\"oi_overridenetprice\":\"400.000\",\"oi_overridevatprice\":\"40.000\",\"oi_overridegrossprice\":\"440.000\",\"oi_ready\":0,\"oi_onhold\":0,\"oi_platformcreatedfrom\":\"web\",\"oi_platformlastupdatedfrom\":\"web\",\"oi_copiedfrom\":0,\"oi_isonlineorder\":0,\"oi_endcustomervatprice\":null,\"oi_endcustomeroverridetype\":6,\"oi_endcustomeroverridevalue\":null,\"oi_endcustomeroverridenetprice\":\"400.000\",\"oi_endcustomeroverridevatprice\":\"40.000\",\"oi_endcustomeroverridegrossprice\":\"440.000\",\"oi_sage_flag\":0,\"oi_supid\":null,\"oi_status\":0,\"oi_createdby\":1,\"oi_createdat\":\"2025-06-06T09:59:03.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":null,\"oi_jsondataid\":\"[6887, 319, 320, 322, 323, 324, 321, 325, 326, 327, 328, 329, 330, 331, 332, 335, 333, 336, 337, 7270]\",\"oi_deviceplatform\":2,\"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": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "58156", "cl_createdat": "1749210903.000000", "cl_updatedat": null }, { "cl_id": 58157, "cl_logname": "model", "cl_type": null, "cl_modulename": "Production Due Date", "cl_message": "Production Due Date has been updated", "cl_event": "modified", "cl_subjectid": 5767, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5767, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "{\"Production Due Date\":\"2025-06-05\"}", "cl_changedto": "{\"Production Due Date\":\"2025-06-06\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "58157", "cl_createdat": "1749210903.000000", "cl_updatedat": null }, { "cl_id": 58158, "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 Vision Blinds", "cl_event": "created", "cl_subjectid": 31366, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 5767, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Supplier\":\" Markilux\",\" Width\":\" 500\",\" Drop\":\" 200\",\" Product Type\":\" band z\",\" Vision Panel Size\":\" 125mm\",\" Measure To\":\" Blind Size\",\" Controls\":\" Left hand operation\",\" Brackets\":\" Face Fix\",\" Chain Colour\":\" Nickel\"}", "cl_customproperties": "{\"attributes\":{\"oi_id\":31366,\"oi_jobid\":5767,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":5798,\"oi_credit_id\":0,\"oi_productid\":9,\"oi_recipeid\":9,\"oi_ruleid\":0,\"oi_qty\":1,\"oi_seq\":0,\"oi_customseq\":0,\"oi_productcustomseq\":0,\"oi_jsondata\":\"[{\\\"id\\\":6887,\\\"labelname\\\":\\\"Unit Type\\\",\\\"value\\\":2,\\\"valueid\\\":\\\"2\\\",\\\"type\\\":34,\\\"optionid\\\":\\\"2\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":2,\\\"optionname\\\":\\\"mm\\\",\\\"optioncode\\\":\\\"\\\",\\\"optionquantity\\\":1,\\\"unittype\\\":0,\\\"unitcost\\\":0,\\\"pricingtype\\\":0,\\\"fieldoptionlinkid\\\":2,\\\"forchildfieldoptionlinkid\\\":\\\"34_2\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":319,\\\"labelname\\\":\\\"Quantity\\\",\\\"value\\\":1,\\\"valueid\\\":\\\"\\\",\\\"type\\\":14,\\\"optionid\\\":\\\"1\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":320,\\\"labelname\\\":\\\"Supplier\\\",\\\"value\\\":1,\\\"valueid\\\":\\\"\\\",\\\"type\\\":17,\\\"optionid\\\":\\\"1\\\",\\\"optionvalue\\\":[{\\\"id\\\":1,\\\"optionid\\\":1,\\\"optionname\\\":\\\"Markilux\\\",\\\"deleted\\\":0,\\\"optionquantity\\\":1}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":322,\\\"labelname\\\":\\\"Room\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":323,\\\"labelname\\\":\\\"Width\\\",\\\"value\\\":\\\"500\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":11,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":324,\\\"labelname\\\":\\\"Drop\\\",\\\"value\\\":\\\"200\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":12,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":321,\\\"labelname\\\":\\\"Product Type\\\",\\\"value\\\":474,\\\"valueid\\\":\\\"621\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"474\\\",\\\"optionvalue\\\":[{\\\"id\\\":621,\\\"fieldid\\\":321,\\\"fieldoptionlinkid\\\":621,\\\"optionid\\\":474,\\\"mainsupplier\\\":1,\\\"blindtypecode\\\":\\\"101\\\",\\\"optionname\\\":\\\"band z\\\",\\\"optionquantity\\\":1,\\\"subcount\\\":0,\\\"status\\\":0,\\\"subdatacount\\\":0}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":325,\\\"labelname\\\":\\\"Vision Panel Size\\\",\\\"value\\\":\\\"125mm\\\",\\\"valueid\\\":\\\"1061\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"775\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":775,\\\"optionname\\\":\\\"125mm\\\",\\\"optioncode\\\":\\\"\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":null,\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":1061,\\\"forchildfieldoptionlinkid\\\":\\\"3_1061\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"0.00\\\",\\\"fieldid\\\":1061}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":326,\\\"labelname\\\":\\\"Measure To\\\",\\\"value\\\":\\\"Blind Size\\\",\\\"valueid\\\":\\\"1064\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"778\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":778,\\\"optionname\\\":\\\"Blind Size\\\",\\\"optioncode\\\":\\\"\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":1064,\\\"forchildfieldoptionlinkid\\\":\\\"3_1064\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":327,\\\"labelname\\\":\\\"Controls\\\",\\\"value\\\":\\\"Left hand operation\\\",\\\"valueid\\\":\\\"1065\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"482\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":482,\\\"optionname\\\":\\\"Left hand operation\\\",\\\"optioncode\\\":\\\"jndf\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":null,\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":1065,\\\"forchildfieldoptionlinkid\\\":\\\"3_1065\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"0.00\\\",\\\"fieldid\\\":1065}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":328,\\\"labelname\\\":\\\"Brackets\\\",\\\"value\\\":\\\"Face Fix\\\",\\\"valueid\\\":\\\"1070\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"488\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":488,\\\"optionname\\\":\\\"Face Fix\\\",\\\"optioncode\\\":\\\"\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":null,\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":1070,\\\"forchildfieldoptionlinkid\\\":\\\"3_1070\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":329,\\\"labelname\\\":\\\"Chain Colour\\\",\\\"value\\\":\\\"Nickel\\\",\\\"valueid\\\":\\\"1072\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"469\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":469,\\\"optionname\\\":\\\"Nickel\\\",\\\"optioncode\\\":\\\"6\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":1072,\\\"forchildfieldoptionlinkid\\\":\\\"3_1072\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"0.00\\\",\\\"fieldid\\\":1072}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":330,\\\"labelname\\\":\\\"Roll\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":331,\\\"labelname\\\":\\\"System Type\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":332,\\\"labelname\\\":\\\"Tube Size\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":335,\\\"labelname\\\":\\\"Control Type\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":333,\\\"labelname\\\":\\\"Motorisation\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":336,\\\"labelname\\\":\\\"Fixing\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":337,\\\"labelname\\\":\\\"Extras\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7270,\\\"labelname\\\":\\\"Product Type\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0}]\",\"oi_description\":\"Supplier: Markilux, Width: 500, Drop: 200, Product Type: band z, Vision Panel Size: 125mm, Measure To: Blind Size, Controls: Left hand operation, Brackets: Face Fix, Chain Colour: Nickel\",\"oi_onlinedescription\":null,\"oi_imagepath\":null,\"oi_reportdescription\":\"##Quantity: 1##,##Supplier: Markilux##,##Width: 500 mm##,##Drop: 200 mm##,##Product Type: band z##,##Vision Panel Size: 125mm##,##Measure To: Blind Size##,##Controls: Left hand operation##,##Brackets: Face Fix##,##Chain Colour: Nickel##\",\"oi_onlinereportdescription\":null,\"oi_reporttitles\":\"##Quantity:##Supplier:##Width:##Drop:##Product Type:##Vision Panel Size:##Measure To:##Controls:##Brackets:##Chain Colour:\",\"oi_onlinereporttitles\":null,\"oi_productionformulajsondata\":\"[]\",\"oi_productiondate\":\"2025-06-06 09:58:25\",\"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\":\"400.000\",\"oi_netprice\":\"400.000\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"40.000\",\"oi_vatvalue\":\"10.000\",\"oi_vatselected\":1,\"oi_vattype\":1,\"oi_vatonoff\":1,\"oi_grossprice\":\"440.000\",\"oi_overrideprice\":\"0.000\",\"oi_overridetype\":6,\"oi_overridevalue\":null,\"oi_overridenetprice\":\"400.000\",\"oi_overridevatprice\":\"40.000\",\"oi_overridegrossprice\":\"440.000\",\"oi_ready\":0,\"oi_onhold\":0,\"oi_platformcreatedfrom\":\"web\",\"oi_platformlastupdatedfrom\":\"web\",\"oi_copiedfrom\":0,\"oi_isonlineorder\":0,\"oi_endcustomervatprice\":null,\"oi_endcustomeroverridetype\":6,\"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-06-06T10:15:29.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":null,\"oi_jsondataid\":\"[6887, 319, 320, 322, 323, 324, 321, 325, 326, 327, 328, 329, 330, 331, 332, 335, 333, 336, 337, 7270]\",\"oi_deviceplatform\":2,\"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": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "58158", "cl_createdat": "1749210903.000000", "cl_updatedat": null }, { "cl_id": 58159, "cl_logname": "default", "cl_type": null, "cl_modulename": "Alternative Address", "cl_message": "Alternative Address has been updated the fields Appointments Add,Invoice Add,Invoice Delivery Add,Purchase Add,Worksheet Add", "cl_event": "modified", "cl_subjectid": 5623, "cl_subjecttype": "App\\Models\\Job\\bm_deliveryaddresssetting", "cl_parentid": 5767, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Appointments Add\":\"Alternative Delivery Address\",\"Invoice Add\":\"Alternative Delivery Address\",\"Invoice Delivery Add\":\"Alternative Delivery Address\",\"Purchase Add\":\"Default(Same as billing add)\",\"Worksheet Add\":\"Default(Same as billing add)\"}", "cl_customproperties": "{\"attributes\":{\"das_id\":5623,\"das_jobid\":5767,\"das_appointmentaddress\":4230,\"das_invoiceaddress\":4230,\"das_invoicedeliveryaddress\":4230,\"das_purchaseaddress\":0,\"das_worksheetaddress\":0,\"das_createdby\":1,\"das_createdat\":\"2025-06-06T11:55:03.000000Z\",\"das_updatedby\":null,\"das_updatedat\":\"2025-06-06T11:55:03.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "58159", "cl_createdat": "1749210903.000000", "cl_updatedat": null } ], "updated": [], "deleted": [] }, "bm_productInfo": { "created": [], "updated": [], "deleted": [] }, "bm_fields": { "created": [], "updated": [], "deleted": [] }, "bm_fieldOptionLink": { "created": [], "updated": [], "deleted": [] }, "bm_option": { "created": [], "updated": [], "deleted": [] }, "bm_optionproduct": { "created": [], "updated": [], "deleted": [] }, "bm_linkedfieldswithproduct": { "created": [], "updated": [], "deleted": [] }, "bm_productionstatus": { "created": [], "updated": [], "deleted": [] }, "bm_productpricemap": { "created": [], "updated": [], "deleted": [] }, "bm_productrecipe": { "created": [], "updated": [], "deleted": [] }, "bm_productrecipemap": { "created": [], "updated": [], "deleted": [] }, "bm_supproductcode": { "created": [], "updated": [], "deleted": [] }, "bm_rulesetup": { "created": [], "updated": [], "deleted": [] }, "bm_formulas": { "created": [], "updated": [], "deleted": [] }, "bm_customercommission": { "created": [], "updated": [], "deleted": [] }, "bm_productgroupdetails": { "created": [], "updated": [], "deleted": [] }, "bm_productgroupmaterialmap": { "created": [], "updated": [], "deleted": [] }, "bm_productpricedetails": { "created": [], "updated": [], "deleted": [] }, "bm_fabriccolourmap": { "created": [], "updated": [], "deleted": [] }, "bm_fabricdetails": { "created": [], "updated": [], "deleted": [] }, "bm_colordetails": { "created": [], "updated": [], "deleted": [] }, "bm_optiondiscount": { "created": [], "updated": [], "deleted": [] }, "bm_optionpricebook": { "created": [], "updated": [], "deleted": [] }, "bm_allowances": { "created": [], "updated": [], "deleted": [] }, "bm_xyoptionpricedata": { "created": [], "updated": [], "deleted": [] }, "bm_delivery_cost_setup": { "created": [], "updated": [], "deleted": [] }, "bm_organizationdetails": { "created": [], "updated": [], "deleted": [] }, "bm_applicationSetup": { "created": [], "updated": [], "deleted": [] } }, "synctodelete": { "bm_customercontactinfo": { "51749203891": 4230 }, "bm_customertemplatedata": { "31749203891": 4047 }, "bm_jobdetails": { "41749203891": 5767 }, "bm_notelist": { "61749203891": 105251 }, "bm_jobmultiquote": { "141749203891": 5798 }, "bm_orderitem": { "71749203943": 31365, "71749204929": 31366 }, "bm_deliveryaddresssetting": { "161749204014": 5623 } }, "timestamp": 1749210903 }