{ "status": "success", "upcomingorder_list": { "bm_customertemplatedata": { "created": [], "updated": [ { "ctd_id": 4008, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\":1,\"62\":\"TEST0013\",\"63\":\"Test 1\",\"64\":\"\",\"65\":\"\",\"66\":\"\",\"67\":\"\",\"68\":\"\",\"69\":\"\",\"70\":\"\",\"71\":\"\",\"72\":36,\"73\":\"\",\"568\":\"\",\"600\":25,\"617\":\"\"}", "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": "4008", "ctd_createdat": 1748512439, "ctd_updatedat": 1749046447, "ctd_createdby": 0, "ctd_updatedby": null } ], "deleted": [] }, "bm_customercontactinfo": { "created": [], "updated": [ { "cci_id": 4183, "cci_customerid": 4008, "cci_templateid": 3, "roleid": 2, "cci_customizedarray": "{\"75\":12,\"76\":\"\",\"77\":\"Jessica \",\"78\":\"\",\"79\":\"J \",\"81\":\"\",\"82\":\"\",\"83\":0,\"source\":\"Google\",\"undefined\":\"\",\"country\":\"Argentina\",\"companyname\":\"Test 1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"85\":1,\"86\":\"\",\"87\":\"\",\"88\":\"\",\"89\":\"\",\"90\":\"Argentina\",\"91\":\"\",\"92\":\"INR(\u0930)\"}", "cci_ismarketingemails": 0, "cci_smsverifystatus": 0, "cci_isdocumentreceived": 0, "cci_receiveddocfor": "[null,null,null,null,null,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": 31748512439, "id": "4183", "cci_createdat": 1748512460, "cci_updatedat": 1748513521, "cci_createdby": 1, "cci_updatedby": null } ], "deleted": [] }, "bm_appointment": { "created": [ { "app_eventid": 10051, "app_description": "Appointment for Aarathi", "app_summary": "-Jessica J", "app_private": 0, "app_appointmentType": 0, "app_userId": 14, "app_orderId": 5731, "app_customerId": 4183, "app_isAllDay": 0, "app_timezone": "Asia\/Kolkata", "app_latitude": 0, "app_longitude": 0, "app_parentappid": null, "app_recurrencerule": null, "app_userdefinedValue": "[]", "app_recurrenceexception": null, "app_attachment": null, "guid": "", "app_staff": "", "app_appointtype": "", "app_confirmed": 0, "app_travelHour": "0", "app_travelMinute": "0", "app_onsiteHour": null, "app_onsiteMinute": null, "app_location": null, "app_traveltime": null, "app_googleid": "0", "app_platform": "web", "app_cal_status": 868, "app_status": 0, "app_markasread": 0, "app_statusInGoogle": 0, "app_runid": null, "app_jobtimehour": "0", "app_jobtimeminute": "30", "app_products": null, "app_deviceplatform": 2, "app_recurrenceexception_date": null, "app_deliveryaddressid": null, "id": "10051", "app_sdate": 1748995200, "app_edate": 1748995200, "app_stime": 1749029436, "app_etime": 1749031236, "app_sdatetime": 1749029436, "app_edatetime": 1749031236, "app_until": null, "app_createdAt": 1749046343, "app_updatedAt": 1749046343, "app_createdBy": 1, "app_updatedBy": null } ], "updated": [], "deleted": [] }, "bm_tasklist": { "created": [], "updated": [], "deleted": [] }, "bm_jobdetails": { "created": [ { "jd_id": 5731, "jd_customerid": 4008, "jd_contactid": 4183, "jd_additionalcontacts": "4183", "jd_templateid": 1, "jd_jobmultiquoteid": 5760, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5728", "jd_jobstatus": 6, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "TEST0013", "jd_invoiceno": "Invoice9663", "jd_listprice": "400.00", "jd_netprice": "400.00", "jd_vat": "40.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "jd_isroundon": 0, "jd_grossprice": "440.00", "jd_grossprofit": "-40.00", "jd_costprice": "440.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "235.00", "jd_totpaid": "205.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": null, "jd_deliverycostid": null, "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": "0.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5728\",\"35\":\"TEST0013\",\"36\":6,\"37\":1,\"38\":\"\",\"39\":\"\",\"40\":13,\"41\":1,\"44\":\"Test 1\",\"45\":\"Jessica \",\"46\":\"J \",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":\"Argentina\",\"285\":12,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":\"\",\"610\":\"\",\"611\":\"\",\"612\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "0.000", "jd_commission": null, "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5731", "jd_createddate": 1748995200, "jd_orderdate": 1748995200, "jd_duedate": 1748995200, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": 0, "jd_sageexportdate": null, "jd_createdat": 1749046343, "jd_updatedat": 1749046447 } ], "updated": [ { "jd_id": 5728, "jd_customerid": 4011, "jd_contactid": 4187, "jd_additionalcontacts": "4187", "jd_templateid": 1, "jd_jobmultiquoteid": 5757, "jd_deletedcustokeyvalue": "{\"32\":\"\",\"34\":\"AQ5725\",\"35\":\"JOHN0007\",\"36\":6,\"38\":\"201749045126\",\"40\":13}", "jd_jobref": "AQ5725", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "JOHN0007", "jd_invoiceno": "Invoice9662", "jd_listprice": "0.00", "jd_netprice": "0.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "0.00", "jd_grossprofit": "43.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "-55.00", "jd_totpaid": "55.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "92.45", "jd_endcustomeroverridevatprice": "9.25", "jd_endcustomeroverridegrossprice": "101.70", "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": "0.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":22,\"41\":1,\"44\":\"John Smith Pvt Ltd\",\"45\":\"Johny\",\"46\":\"Leo\",\"47\":\"595955848\",\"48\":\"\",\"49\":\"Cit Nagar\",\"50\":\"Nandanam\",\"51\":\"ChennaiChenain\",\"52\":\"India\",\"53\":\"635301\",\"54\":36,\"285\":12,\"286\":\"264945946\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":1,\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "0.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5728", "jd_createddate": 1748995200, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": 0, "jd_sageexportdate": null, "jd_createdat": 1749044646, "jd_updatedat": 1749046447 }, { "jd_id": 5731, "jd_customerid": 4008, "jd_contactid": 4183, "jd_additionalcontacts": "4183", "jd_templateid": 1, "jd_jobmultiquoteid": 5760, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5728", "jd_jobstatus": 6, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "TEST0013", "jd_invoiceno": "Invoice9663", "jd_listprice": "400.00", "jd_netprice": "400.00", "jd_vat": "40.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "jd_isroundon": 0, "jd_grossprice": "440.00", "jd_grossprofit": "-40.00", "jd_costprice": "440.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "235.00", "jd_totpaid": "205.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": null, "jd_deliverycostid": null, "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": "0.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5728\",\"35\":\"TEST0013\",\"36\":6,\"37\":1,\"38\":\"\",\"39\":\"\",\"40\":13,\"41\":1,\"44\":\"Test 1\",\"45\":\"Jessica \",\"46\":\"J \",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":\"Argentina\",\"285\":12,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":\"\",\"610\":\"\",\"611\":\"\",\"612\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "0.000", "jd_commission": null, "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5731", "jd_createddate": 1748995200, "jd_orderdate": 1748995200, "jd_duedate": 1748995200, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": 0, "jd_sageexportdate": null, "jd_createdat": 1749046343, "jd_updatedat": 1749046447 } ], "deleted": [] }, "bm_orderitem": { "created": [ { "oi_id": 31349, "oi_jobid": 5731, "oi_jobtempid": "0", "oi_jobmultiquoteid": 5760, "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\":\"\",\"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\":\"567\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":324,\"labelname\":\"Drop\",\"value\":\"50\",\"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\":355,\"labelname\":\"Fabric\",\"value\":\"127mm _ Banlight Duo RD FR\",\"valueid\":\"4868\",\"type\":5,\"optionid\":\"4868\",\"optionvalue\":[{\"optionid\":4868,\"optionname\":\"127mm _ Banlight Duo RD FR\",\"optioncode\":\"VEF95\",\"optionquantity\":1,\"fieldoptionlinkid\":4868,\"forchildfieldoptionlinkid\":\"5_2_4868_1\",\"optionimage\":\"\",\"subdatacount\":1,\"pricegroup\":\"band z\",\"pricegroupid\":474}],\"fabricorcolor\":1,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":8291,\"labelname\":\"Color\",\"value\":\"Almond\",\"valueid\":\"14553\",\"type\":5,\"optionid\":\"14553\",\"optionvalue\":[{\"optionid\":14553,\"optionname\":\"Almond\",\"optioncode\":\"LE18400\",\"optionquantity\":1,\"fieldoptionlinkid\":14553,\"forchildfieldoptionlinkid\":\"5_3_14553_1\",\"minimumdiscount\":\"\",\"maximumdiscount\":\"\",\"optionimage\":\"14553_139.jpg\",\"subdatacount\":0}],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":325,\"labelname\":\"Vision Panel Size\",\"value\":\"160mm\",\"valueid\":\"1062\",\"type\":3,\"optionid\":\"776\",\"optionvalue\":[{\"optionid\":776,\"optionname\":\"160mm\",\"optioncode\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":1062,\"forchildfieldoptionlinkid\":\"3_1062\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"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,\"pricingtype\":\"\",\"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\":\"Right hand operation\",\"valueid\":\"1066\",\"type\":3,\"optionid\":\"483\",\"optionvalue\":[{\"optionid\":483,\"optionname\":\"Right hand operation\",\"optioncode\":\"kind\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":40,\"pricingtype\":\"\",\"fieldoptionlinkid\":1066,\"forchildfieldoptionlinkid\":\"3_1066\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":1066}],\"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,\"pricingtype\":\"\",\"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\":\"Stainless\",\"valueid\":\"1073\",\"type\":3,\"optionid\":\"731\",\"optionvalue\":[{\"optionid\":731,\"optionname\":\"Stainless\",\"optioncode\":\"STA\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":1073,\"forchildfieldoptionlinkid\":\"3_1073\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":1073}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":330,\"labelname\":\"Roll\",\"value\":\"Rev\",\"valueid\":\"1078\",\"type\":3,\"optionid\":\"783\",\"optionvalue\":[{\"optionid\":783,\"optionname\":\"Rev\",\"optioncode\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":1078,\"forchildfieldoptionlinkid\":\"3_1078\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":331,\"labelname\":\"System Type\",\"value\":\"Hybrid Oc VIS Bei\",\"valueid\":\"1080\",\"type\":3,\"optionid\":\"785\",\"optionvalue\":[{\"optionid\":785,\"optionname\":\"Hybrid Oc VIS Bei\",\"optioncode\":\"HOVB\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":1080,\"forchildfieldoptionlinkid\":\"3_1080\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"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},{\"id\":7269,\"labelname\":\"Dual\",\"value\":\"\",\"valueid\":\"\",\"type\":5,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":1,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]", "oi_description": "Supplier: Markilux, Width: 567, Drop: 50, Product Type: band z, Fabric: 127mm _ Banlight Duo RD FR, Color: Almond, Vision Panel Size: 160mm, Measure To: Blind Size, Controls: Right hand operation, Brackets: Face Fix, Chain Colour: Stainless, Roll: Rev, System Type: Hybrid Oc VIS Bei", "oi_reportdescription": "##Quantity: 1##,##Supplier: Markilux##,##Width: 567 mm##,##Drop: 50 mm##,##Product Type: band z##,##Fabric: 127mm _ Banlight Duo RD FR##,##Color: Almond##,##Vision Panel Size: 160mm##,##Measure To: Blind Size##,##Controls: Right hand operation##,##Brackets: Face Fix##,##Chain Colour: Stainless##,##Roll: Rev##,##System Type: Hybrid Oc VIS Bei##", "oi_reporttitles": "##Quantity:##Supplier:##Width:##Drop:##Product Type:##Fabric:##Color:##Vision Panel Size:##Measure To:##Controls:##Brackets:##Chain Colour:##Roll:##System Type:", "oi_productionformulajsondata": "[]", "oi_operationstatus": null, "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "[]", "oi_pricecomesfrom_calculations": "{}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "440.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": 1, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 0, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "0.000", "oi_endcustomeroverridevatprice": "0.000", "oi_endcustomeroverridegrossprice": "0.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[6887, 319, 320, 322, 323, 324, 321, 355, 8291, 325, 326, 327, 328, 329, 330, 331, 332, 335, 333, 336, 337, 7270, 7269]", "oi_deviceplatform": 2, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "31349", "oi_productiondate": 1749046353, "oi_createdat": 1749046396, "oi_updatedat": 1749046447, "oi_createdby": 1, "oi_updatedby": null } ], "updated": [ { "oi_id": 31346, "oi_jobid": 5728, "oi_jobtempid": "0", "oi_jobmultiquoteid": 5757, "oi_productid": 14, "oi_recipeid": 14, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 0, "oi_customseq": 0, "oi_productcustomseq": 0, "oi_jsondata": "[{\"id\":6892,\"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\":4408,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"1\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":4409,\"labelname\":\"Supplier\",\"value\":4,\"valueid\":\"\",\"type\":17,\"optionid\":\"4\",\"optionvalue\":[{\"id\":4,\"optionid\":4,\"optionname\":\"Master Blinds\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":4412,\"labelname\":\"Location\",\"value\":\"kitchen \",\"valueid\":\"\",\"type\":18,\"optionid\":\"kitchen \",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":4411,\"labelname\":\"Blind or Recess\",\"value\":\"Blind size\",\"valueid\":\"5454\",\"type\":3,\"optionid\":\"474\",\"optionvalue\":[{\"optionid\":474,\"optionname\":\"Blind size\",\"optioncode\":\"ksc\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":5454,\"forchildfieldoptionlinkid\":\"3_5454\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":4413,\"labelname\":\"Width\",\"value\":\"500\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":4414,\"labelname\":\"Drop\",\"value\":\"500\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":4430,\"labelname\":\"Color\",\"value\":\"Stone\",\"valueid\":\"9107\",\"type\":20,\"optionid\":\"9107\",\"optionvalue\":[{\"optionid\":9107,\"optionname\":\"Stone\",\"optioncode\":\"6293\",\"optionquantity\":1,\"fieldoptionlinkid\":9107,\"forchildfieldoptionlinkid\":\"20_2_9107_0\",\"minimumdiscount\":\"\",\"maximumdiscount\":\"\",\"subdatacount\":0,\"optionimage\":\"\",\"supplier\":\"Master Blinds\",\"pricegroup\":\"Group 1\",\"pricegroupid\":372}],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":4410,\"labelname\":\"Wood Size\",\"value\":372,\"valueid\":\"434\",\"type\":13,\"optionid\":\"372\",\"optionvalue\":[{\"id\":434,\"fieldid\":4410,\"fieldoptionlinkid\":434,\"optionid\":372,\"mainsupplier\":4,\"blindtypecode\":\"\",\"optionname\":\"Group 1\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":4415,\"labelname\":\"Control Type\",\"value\":\"Motor\",\"valueid\":\"5457\",\"type\":3,\"optionid\":\"480\",\"optionvalue\":[{\"optionid\":480,\"optionname\":\"Motor\",\"optioncode\":\"\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":5457,\"forchildfieldoptionlinkid\":\"3_5457\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":5457}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":4416,\"labelname\":\"Control Side\",\"value\":\"Left Tilt And Right Raise Lower\",\"valueid\":\"5465\",\"type\":3,\"optionid\":\"484\",\"optionvalue\":[{\"optionid\":484,\"optionname\":\"Left Tilt And Right Raise Lower\",\"optioncode\":\"EWV011\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":5465,\"forchildfieldoptionlinkid\":\"3_5465\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":4417,\"labelname\":\"Manual Controls\",\"value\":\"RH Wand LH Cord Lock\",\"valueid\":\"5461\",\"type\":3,\"optionid\":\"516\",\"optionvalue\":[{\"optionid\":516,\"optionname\":\"RH Wand LH Cord Lock\",\"optioncode\":\"EWV043\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":5461,\"forchildfieldoptionlinkid\":\"3_5461\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":4418,\"labelname\":\"Installation Height mm\",\"value\":\"34\",\"valueid\":\"\",\"type\":18,\"optionid\":\"34\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":4419,\"labelname\":\"Brackets\",\"value\":\"Face Fix Swivel Bracket Silver\",\"valueid\":\"5468\",\"type\":3,\"optionid\":\"485\",\"optionvalue\":[{\"optionid\":485,\"optionname\":\"Face Fix Swivel Bracket Silver\",\"optioncode\":\"EWV012\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":5468,\"forchildfieldoptionlinkid\":\"3_5468\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":4420,\"labelname\":\"Tape Options\",\"value\":\"Ladder Tape\",\"valueid\":\"5472\",\"type\":3,\"optionid\":\"477\",\"optionvalue\":[{\"optionid\":477,\"optionname\":\"Ladder Tape\",\"optioncode\":\"EWV004\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":6.45,\"fieldoptionlinkid\":5472,\"forchildfieldoptionlinkid\":\"3_5472\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":1,\"optionimage\":\"\",\"reportprice\":\"6.45\",\"fieldid\":5472}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":4429,\"labelname\":\"Ladder Tape Options\",\"value\":\"W06\",\"valueid\":\"5537\",\"type\":3,\"optionid\":\"532\",\"optionvalue\":[{\"optionid\":532,\"optionname\":\"W06\",\"optioncode\":\"ESC004\",\"optionqty\":\"1\",\"unittype\":null,\"fieldoptionlinkid\":5537,\"forchildfieldoptionlinkid\":\"3_5537\",\"hasstock\":0,\"subdatacount\":0,\"hasprice\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":4421,\"labelname\":\"Motorization\",\"value\":\"Battery Motor Tilt 50 RTS\",\"valueid\":\"5475\",\"type\":3,\"optionid\":\"521\",\"optionvalue\":[{\"optionid\":521,\"optionname\":\"Battery Motor Tilt 50 RTS\",\"optioncode\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":5475,\"forchildfieldoptionlinkid\":\"3_5475\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":1,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":4425,\"labelname\":\"Battery Motor Tilt 50 RTS Options\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":4422,\"labelname\":\"Extras\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":4424,\"labelname\":\"Special Instructions\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]", "oi_description": "Unit Type: mm, Quantity: 1, Supplier: Master Blinds, Location: kitchen , Blind or Recess: Blind size, Width: 500, Drop: 500, Color: Stone, Control Type: Motor, Control Side: Left Tilt And Right Raise Lower, Manual Controls: RH Wand LH Cord Lock, Installation Height mm: 34, Brackets: Face Fix Swivel Bracket Silver, Tape Options: Ladder Tape, Ladder Tape Options: W06, Motorization: Battery Motor Tilt 50 RTS", "oi_reportdescription": "##Quantity: 1##,##Supplier: Master Blinds##,##Location: kitchen ##,##Blind or Recess: Blind size##,##Width: 500 mm##,##Drop: 500 mm##,##Color: Stone##,##Control Type: Motor##,##Control Side: Left Tilt And Right Raise Lower##,##Manual Controls: RH Wand LH Cord Lock##,##Installation Height mm: 34##,##Brackets: Face Fix Swivel Bracket Silver##,##Tape Options: Ladder Tape##,##Ladder Tape Options: W06##,##Motorization: Battery Motor Tilt 50 RTS##", "oi_reporttitles": "##Quantity:##Supplier:##Location:##Blind or Recess:##Width:##Drop:##Color:##Control Type:##Control Side:##Manual Controls:##Installation Height mm:##Brackets:##Tape Options:##Ladder Tape Options:##Motorization:", "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": "49.450", "oi_netprice": "92.450", "oi_pricesfromoperations": null, "oi_vatprice": "9.250", "oi_vatvalue": "10.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "101.700", "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": 1, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 0, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "92.450", "oi_endcustomeroverridevatprice": "9.250", "oi_endcustomeroverridegrossprice": "101.700", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[6892, 4408, 4409, 4412, 4411, 4413, 4414, 4430, 4410, 4415, 4416, 4417, 4418, 4419, 4420, 4429, 4421, 4425, 4422, 4424]", "oi_deviceplatform": 2, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "31346", "oi_productiondate": 1749044982, "oi_createdat": 1749045076, "oi_updatedat": 1749046447, "oi_createdby": 1, "oi_updatedby": 1 } ], "deleted": [] }, "bm_paymentlist": { "created": [ { "pl_id": 4076, "pl_orderid": null, "pl_invoice_id": 2604, "pl_customer_id": 4008, "pl_overpayment_id": 0, "pl_jobpayment_id": 2147483647, "pl_amount": "150.00", "pl_paymentmethod": 14, "pl_paymentcategory": 1, "pl_paymenttype": 8, "pl_surchargetype": 2, "pl_surchargemethod": 2, "pl_surchargeamount": "0.00", "pl_surchargevalue": "0.00", "pl_surchargetotal": "1500.00", "pl_userid": "1", "pl_decription": null, "pl_paymentinvoice": null, "pl_paymentstatus": 0, "pl_seq": 0, "pl_status": 0, "pl_refundtype": null, "pl_deviceplatform": 2, "id": "4076", "pl_paiddate": 1748995200, "created_at": 1749046437, "updated_at": null, "created_by": 1, "updated_by": null } ], "updated": [], "deleted": [] }, "bm_notelist": { "created": [ { "nl_id": 105232, "nl_ordertempid": 0, "nl_orderid": 5731, "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": "105232", "nl_endddate": 1748995200, "nl_starttime": 1749046343, "created_at": 1749046343, "updated_at": 1749046447, "created_by": 1, "updated_by": null }, { "nl_id": 105233, "nl_ordertempid": 0, "nl_orderid": 5731, "nl_notescategory": 1, "nl_type": 26, "nl_platform": 2, "nl_desc": "Invoice Created (Invoice9663)", "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": "105233", "nl_endddate": 1748995200, "nl_starttime": 1749046437, "created_at": 1749046437, "updated_at": 1749046447, "created_by": 1, "updated_by": null }, { "nl_id": 105234, "nl_ordertempid": 0, "nl_orderid": 5731, "nl_notescategory": 1, "nl_type": 26, "nl_platform": 2, "nl_desc": "payment added against invoice no ('Invoice9663') amount ('150')", "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": "105234", "nl_endddate": 1748995200, "nl_starttime": 1749046437, "created_at": 1749046437, "updated_at": 1749046447, "created_by": 1, "updated_by": null } ], "updated": [], "deleted": [] }, "bm_deliveryaddresssetting": { "created": [ { "das_id": 5587, "das_jobid": 5730, "das_appointmentaddress": 4220, "das_invoiceaddress": 4220, "das_invoicedeliveryaddress": 4220, "das_purchaseaddress": 0, "das_worksheetaddress": 0, "id": "5587", "das_createdat": 1749046243, "das_updatedat": 1749046243, "das_createdby": 1, "das_updatedby": null }, { "das_id": 5588, "das_jobid": 5731, "das_appointmentaddress": 4183, "das_invoiceaddress": 4183, "das_invoicedeliveryaddress": 4183, "das_purchaseaddress": 0, "das_worksheetaddress": 0, "id": "5588", "das_createdat": 1749046448, "das_updatedat": 1749046448, "das_createdby": 1, "das_updatedby": null } ], "updated": [], "deleted": [] }, "bm_jobchecklist": { "created": [], "updated": [], "deleted": [] }, "bm_Invoice": { "created": [ { "invoice_id": 2604, "job_id": 5731, "customer_id": 4008, "ref_no": "Invoice9663", "invoice_type": 1, "invoice_split_type": 0, "invoice_split_cal": 0, "invoice_split_cal_value": null, "net_amount": "400.000", "vat_amount": "40.000", "gross_amount": "440.000", "delivery_amount": "0.000", "delivery": 0, "commission_amount": "0.000", "commission": 0, "total_amount": "440.000", "split_net_amount": null, "split_vat_amount": null, "outstanding_amount": "290.000", "paid_amount": "150.000", "paid_status": 2, "status": 0, "transfer": 0, "transfer_id": null, "id": "2604", "paymentDueDate": 1748995200, "invoiceDate": 1748995200, "transferDate": null, "createdat": 1749046437, "updatedat": 1749046447, "createdby": 1, "updatedby": null } ], "updated": [], "deleted": [] }, "bm_InvoiceDetails": { "created": [ { "ind_id": 15183, "ind_invoice_id": 2604, "ind_order_id": 31349, "ind_qty": 1, "ind_net_amount": "400.000", "ind_vat_amount": "40.000", "ind_gross_amount": "440.000", "ind_status": 0, "id": "15183", "ind_createdat": 1749046437, "ind_updatedat": 1749046437, "ind_createdby": 1, "ind_updatedby": null } ], "updated": [], "deleted": [] }, "bm_invoice_credit_note": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNote": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNoteDetails": { "created": [], "updated": [], "deleted": [] }, "bm_job_paymentlist": { "created": [ { "jp_id": 396, "jp_job_id": 5731, "jp_amount": "150.000", "jp_amountoutstanding": "0.000", "jp_paymentmethod": 14, "jp_paymentcategory": 1, "jp_paymenttype": 8, "jp_surchargetype": 2, "jp_surchargemethod": 2, "jp_surchargeamount": "0.000", "jp_surchargevalue": null, "jp_surchargetotal": "150.000", "jp_userid": 1, "jp_decription": "", "jp_deviceplatform": 2, "jp_status": 0, "jp_transfer": 0, "jp_transfer_id": null, "id": "396", "jp_paiddate": 1748995200, "jp_createdat": 1749046407, "jp_updatedat": 1749046448, "jp_createdby": 1, "jp_updatedby": null } ], "updated": [], "deleted": [] }, "bm_OverPayment": { "created": [], "updated": [], "deleted": [] }, "bm_terms": { "created": [], "updated": [], "deleted": [] }, "bm_jobmultiquote": { "created": [ { "jmq_id": 5760, "jmq_jobid": 5731, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "400.00", "jmq_netprice": "400.00", "jmq_vat": "40.00", "jmq_isvaton": 1, "jmq_deliverycost": "0.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 1, "jmq_orderformprice": "0.00", "jmq_editpricebyid": null, "jmq_isroundon": 0, "jmq_grossprice": "440.00", "jmq_grossprofit": "-40.00", "jmq_costprice": "440.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "235.00", "jmq_totpaid": "205.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": null, "jmq_deliverycostid": null, "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": "0.000", "jmq_cdeliveryvatperc": "0.000", "id": "5760", "jmq_duedate": 1748995200, "jmq_sceduleddate": null, "jmq_createdat": "1749046343.000000", "jmq_updatedat": "1749046447.000000", "jmq_createdby": 1, "jmq_updatedby": 1 } ], "updated": [ { "jmq_id": 5760, "jmq_jobid": 5731, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "400.00", "jmq_netprice": "400.00", "jmq_vat": "40.00", "jmq_isvaton": 1, "jmq_deliverycost": "0.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 1, "jmq_orderformprice": "0.00", "jmq_editpricebyid": null, "jmq_isroundon": 0, "jmq_grossprice": "440.00", "jmq_grossprofit": "-40.00", "jmq_costprice": "440.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "235.00", "jmq_totpaid": "205.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": null, "jmq_deliverycostid": null, "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": "0.000", "jmq_cdeliveryvatperc": "0.000", "id": "5760", "jmq_duedate": 1748995200, "jmq_sceduleddate": null, "jmq_createdat": "1749046343.000000", "jmq_updatedat": "1749046447.000000", "jmq_createdby": 1, "jmq_updatedby": 1 } ], "deleted": [] }, "bm_jobstatus_tracks": { "created": [ { "jst_id": 6420, "jst_jobid": 5729, "jst_job_current_status": 1, "id": "6420", "jst_createdat": "1749046242.392085" }, { "jst_id": 6421, "jst_jobid": 5730, "jst_job_current_status": 6, "id": "6421", "jst_createdat": "1749046242.580908" }, { "jst_id": 6422, "jst_jobid": 5731, "jst_job_current_status": 6, "id": "6422", "jst_createdat": "1749046447.549447" } ], "updated": [], "deleted": [] }, "bm_customindividuallogs": { "created": [ { "cl_id": 57749, "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": 5586, "cl_subjecttype": "App\\Models\\Job\\bm_deliveryaddresssetting", "cl_parentid": 5729, "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\":5586,\"das_jobid\":5729,\"das_appointmentaddress\":4219,\"das_invoiceaddress\":4219,\"das_invoicedeliveryaddress\":4219,\"das_purchaseaddress\":0,\"das_worksheetaddress\":0,\"das_createdby\":1,\"das_createdat\":\"2025-06-04T14:10:42.000000Z\",\"das_updatedby\":null,\"das_updatedat\":\"2025-06-04T14:10:42.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "57749", "cl_createdat": "1749046243.000000", "cl_updatedat": null }, { "cl_id": 57750, "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": 5587, "cl_subjecttype": "App\\Models\\Job\\bm_deliveryaddresssetting", "cl_parentid": 5730, "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\":5587,\"das_jobid\":5730,\"das_appointmentaddress\":4220,\"das_invoiceaddress\":4220,\"das_invoicedeliveryaddress\":4220,\"das_purchaseaddress\":0,\"das_worksheetaddress\":0,\"das_createdby\":1,\"das_createdat\":\"2025-06-04T14:10:43.000000Z\",\"das_updatedby\":null,\"das_updatedat\":\"2025-06-04T14:10:43.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "57750", "cl_createdat": "1749046243.000000", "cl_updatedat": null }, { "cl_id": 57751, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 5731, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5731, "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\",\"Company Name\":\"Test 1\",\"First Name\":\"Jessica \",\"Last Name\":\"J \",\"Country\":null,\"Salutation\":\"Dr\",\"Assigned to\":1,\"Additional Contacts\":\"4183\",\"Order Date\":\"2025-06-04\",\"Completed Date\":\"1970-01-01\",\"Job Ref No\":\"AQ5728\",\"Job Status\":\"Invoiced\",\"Order Status\":\"Enquiry\",\"Net Price\":\"400.00\",\"VAT Price\":\"40.00\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"Gross Price Amount\":\"440.00\",\"Gross Profit\":\"-40.00\",\"Total CostPrice\":\"440.00\",\"Amount Outstanding\":\"235.00\",\"Total Paid\":\"205.00\",\"jd_isonlineorder\":1,\"jd_fromjobrefwhole\":\"''\",\"Job Rework Enable\":\"On\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":5731,\"jd_customerid\":4008,\"jd_contactid\":4183,\"jd_additionalcontacts\":\"4183\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"AQ5728\\\",\\\"35\\\":\\\"TEST0013\\\",\\\"36\\\":6,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":\\\"\\\",\\\"40\\\":13,\\\"41\\\":1,\\\"44\\\":\\\"Test 1\\\",\\\"45\\\":\\\"Jessica \\\",\\\"46\\\":\\\"J \\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":\\\"Argentina\\\",\\\"285\\\":12,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":1,\\\"558\\\":\\\"\\\",\\\"559\\\":\\\"\\\",\\\"610\\\":\\\"\\\",\\\"611\\\":\\\"\\\",\\\"612\\\":\\\"\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-06-04\",\"jd_orderdate\":\"2025-06-04\",\"jd_duedate\":null,\"jd_sceduleddate\":null,\"jd_invoicedate\":\"0000-00-00\",\"jd_completeddate\":\"1970-01-01\",\"jd_jobref\":\"AQ5728\",\"jd_jobstatus\":6,\"jd_contactaddid\":0,\"jd_orderstatus\":13,\"jd_accref\":\"TEST0013\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"400.00\",\"jd_netprice\":\"400.00\",\"jd_vat\":\"40.00\",\"jd_isvaton\":1,\"jd_deliverycost\":\"0.00\",\"jd_deliverycosttypeid\":1,\"jd_overridetypeid\":1,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":null,\"jd_isroundon\":0,\"jd_grossprice\":\"440.00\",\"jd_grossprofit\":\"-40.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"440.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"235.00\",\"jd_totpaid\":\"205.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":null,\"jd_deliverycostid\":null,\"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-04T14:12:23.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-06-04T14:14:07.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\":\"0.000\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"0.000\",\"jd_commission\":null,\"jd_commissionprice\":\"0.00\",\"jd_commissionsetting\":0,\"jd_commissionaddedvalue\":\"0.00\",\"jd_onlineprefixseq\":null,\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":1,\"jd_rework_count\":0}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "57751", "cl_createdat": "1749046447.000000", "cl_updatedat": null }, { "cl_id": 57752, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment", "cl_message": "new item has been created in Appointment", "cl_event": "created", "cl_subjectid": 10051, "cl_subjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_parentid": 5731, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Repeat On\":\"yearly on June 04\",\"Description\":\"Appointment for Aarathi\",\"app_summary\":\"-Jessica J\",\"Staff\":\"Aarthi\",\"Job Ref No\":\"AQ5728\",\"app_customerId\":4183,\"Start Date & Time\":\"2025-06-04 09:30:36\",\"End Date & Time\":\"2025-06-04 10:00:36\",\"Appointment Status\":\"Waiting\",\"app_jobtimeminute\":\"30\",\"app_deviceplatform\":2}", "cl_customproperties": "{\"attributes\":{\"app_eventid\":10051,\"app_description\":\"Appointment for Aarathi\",\"app_summary\":\"-Jessica J\",\"app_private\":0,\"app_appointmentType\":0,\"app_userId\":14,\"app_orderId\":5731,\"app_customerId\":4183,\"app_isAllDay\":0,\"app_sdate\":\"2025-06-04\",\"app_edate\":\"2025-06-04\",\"app_stime\":\"09:30:36\",\"app_etime\":\"10:00:36\",\"app_sdatetime\":\"2025-06-04 09:30:36\",\"app_edatetime\":\"2025-06-04 10:00:36\",\"app_timezone\":\"Asia\\\/Kolkata\",\"app_latitude\":0,\"app_longitude\":0,\"app_parentappid\":null,\"app_recurrencerule\":null,\"app_userdefinedValue\":\"[]\",\"app_recurrenceexception\":null,\"app_recurrenceexception_date\":null,\"app_attachment\":null,\"guid\":\"\",\"app_until\":null,\"app_staff\":\"\",\"app_appointtype\":\"\",\"app_confirmed\":0,\"app_coordinates\":\"\",\"app_travelHour\":\"0\",\"app_travelMinute\":\"0\",\"app_onsiteHour\":null,\"app_onsiteMinute\":null,\"app_location\":null,\"app_traveltime\":null,\"app_googleid\":\"0\",\"app_platform\":\"web\",\"app_cal_status\":868,\"app_status\":0,\"app_markasread\":0,\"app_statusInGoogle\":0,\"app_createdBy\":1,\"app_updatedBy\":null,\"app_createdAt\":\"2025-06-04T14:12:23.000000Z\",\"app_updatedAt\":\"2025-06-04T14:12:23.000000Z\",\"app_runid\":null,\"app_deliveryaddressid\":null,\"app_jobtimehour\":\"0\",\"app_jobtimeminute\":\"30\",\"app_products\":null,\"app_deviceplatform\":2}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "57752", "cl_createdat": "1749046447.000000", "cl_updatedat": null }, { "cl_id": 57753, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105232, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 5731, "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-04\",\"Time\":\"14:12:23\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105232,\"nl_ordertempid\":0,\"nl_orderid\":5731,\"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-04\",\"nl_starttime\":\"14:12:23\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":1,\"created_at\":\"2025-06-04T14:12:23.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-04T14:14:07.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "57753", "cl_createdat": "1749046447.000000", "cl_updatedat": null }, { "cl_id": 57754, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105233, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 5731, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Trade\",\"Description\":\"Invoice Created (201749046437)\",\"Created By\":\"admin\",\"Date\":\"2025-06-04\",\"Time\":\"14:13:57\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105233,\"nl_ordertempid\":0,\"nl_orderid\":5731,\"nl_notescategory\":1,\"nl_type\":26,\"nl_platform\":2,\"nl_desc\":\"Invoice Created (201749046437)\",\"nl_manualNotes\":null,\"nl_createdby\":\"1\",\"nl_endddate\":\"2025-06-04\",\"nl_starttime\":\"14:13:57\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":1,\"created_at\":\"2025-06-04T14:13:57.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-04T14:14:07.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "57754", "cl_createdat": "1749046447.000000", "cl_updatedat": null }, { "cl_id": 57755, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105234, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 5731, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Trade\",\"Description\":\"payment added against invoice no ('201749046437') amount ('150')\",\"Created By\":\"admin\",\"Date\":\"2025-06-04\",\"Time\":\"14:13:57\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105234,\"nl_ordertempid\":0,\"nl_orderid\":5731,\"nl_notescategory\":1,\"nl_type\":26,\"nl_platform\":2,\"nl_desc\":\"payment added against invoice no ('201749046437') amount ('150')\",\"nl_manualNotes\":null,\"nl_createdby\":\"1\",\"nl_endddate\":\"2025-06-04\",\"nl_starttime\":\"14:13:57\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":1,\"created_at\":\"2025-06-04T14:13:57.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-04T14:14:07.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "57755", "cl_createdat": "1749046447.000000", "cl_updatedat": null }, { "cl_id": 57756, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in AQ5728", "cl_event": "created", "cl_subjectid": 5760, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 5731, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":5760,\"jmq_jobid\":5731,\"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\":\"400.00\",\"Net Price\":\"400.00\",\"VAT Price\":\"40.00\",\"VAT\":1,\"jmq_deliverycost\":\"0.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"440.00\",\"Gross Profit\":\"-40.00\",\"Total CostPrice\":\"440.00\",\"Amount Outstanding\":\"235.00\",\"Total Paid\":\"205.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"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\":\"0.000\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":5760,\"jmq_jobid\":5731,\"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\":\"400.00\",\"jmq_netprice\":\"400.00\",\"jmq_vat\":\"40.00\",\"jmq_isvaton\":1,\"jmq_deliverycost\":\"0.00\",\"jmq_deliverycosttypeid\":1,\"jmq_overridetypeid\":1,\"jmq_orderformprice\":\"0.00\",\"jmq_editpricebyid\":null,\"jmq_isroundon\":0,\"jmq_grossprice\":\"440.00\",\"jmq_grossprofit\":\"-40.00\",\"jmq_costprice\":\"440.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"235.00\",\"jmq_totpaid\":\"205.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_userdefinedarray\":null,\"jmq_deliverycostid\":null,\"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\":\"0.000\",\"jmq_cdeliveryvatperc\":\"0.000\",\"jmq_createdby\":1,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-06-04T14:12:23.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": "57756", "cl_createdat": "1749046447.000000", "cl_updatedat": null }, { "cl_id": 57757, "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": 5731, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5731, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":5760}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":5760},\"old\":{\"jd_jobmultiquoteid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "57757", "cl_createdat": "1749046447.000000", "cl_updatedat": null }, { "cl_id": 57758, "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": 31349, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 5731, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Supplier\":\" Markilux\",\" Width\":\" 567\",\" Drop\":\" 50\",\" Product Type\":\" band z\",\" Fabric\":\" 127mm _ Banlight Duo RD FR\",\" Color\":\" Almond\",\" Vision Panel Size\":\" 160mm\",\" Measure To\":\" Blind Size\",\" Controls\":\" Right hand operation\",\" Brackets\":\" Face Fix\",\" Chain Colour\":\" Stainless\",\" Roll\":\" Rev\",\" System Type\":\" Hybrid Oc VIS Bei\"}", "cl_customproperties": "{\"attributes\":{\"oi_id\":31349,\"oi_jobid\":5731,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":5760,\"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\\\":\\\"\\\",\\\"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\\\":\\\"567\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":11,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":324,\\\"labelname\\\":\\\"Drop\\\",\\\"value\\\":\\\"50\\\",\\\"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\\\":355,\\\"labelname\\\":\\\"Fabric\\\",\\\"value\\\":\\\"127mm _ Banlight Duo RD FR\\\",\\\"valueid\\\":\\\"4868\\\",\\\"type\\\":5,\\\"optionid\\\":\\\"4868\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":4868,\\\"optionname\\\":\\\"127mm _ Banlight Duo RD FR\\\",\\\"optioncode\\\":\\\"VEF95\\\",\\\"optionquantity\\\":1,\\\"fieldoptionlinkid\\\":4868,\\\"forchildfieldoptionlinkid\\\":\\\"5_2_4868_1\\\",\\\"optionimage\\\":\\\"\\\",\\\"subdatacount\\\":1,\\\"pricegroup\\\":\\\"band z\\\",\\\"pricegroupid\\\":474}],\\\"fabricorcolor\\\":1,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":8291,\\\"labelname\\\":\\\"Color\\\",\\\"value\\\":\\\"Almond\\\",\\\"valueid\\\":\\\"14553\\\",\\\"type\\\":5,\\\"optionid\\\":\\\"14553\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":14553,\\\"optionname\\\":\\\"Almond\\\",\\\"optioncode\\\":\\\"LE18400\\\",\\\"optionquantity\\\":1,\\\"fieldoptionlinkid\\\":14553,\\\"forchildfieldoptionlinkid\\\":\\\"5_3_14553_1\\\",\\\"minimumdiscount\\\":\\\"\\\",\\\"maximumdiscount\\\":\\\"\\\",\\\"optionimage\\\":\\\"14553_139.jpg\\\",\\\"subdatacount\\\":0}],\\\"fabricorcolor\\\":2,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":325,\\\"labelname\\\":\\\"Vision Panel Size\\\",\\\"value\\\":\\\"160mm\\\",\\\"valueid\\\":\\\"1062\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"776\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":776,\\\"optionname\\\":\\\"160mm\\\",\\\"optioncode\\\":\\\"\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":1062,\\\"forchildfieldoptionlinkid\\\":\\\"3_1062\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"}],\\\"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,\\\"pricingtype\\\":\\\"\\\",\\\"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\\\":\\\"Right hand operation\\\",\\\"valueid\\\":\\\"1066\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"483\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":483,\\\"optionname\\\":\\\"Right hand operation\\\",\\\"optioncode\\\":\\\"kind\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":null,\\\"unitcost\\\":40,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":1066,\\\"forchildfieldoptionlinkid\\\":\\\"3_1066\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"0.00\\\",\\\"fieldid\\\":1066}],\\\"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,\\\"pricingtype\\\":\\\"\\\",\\\"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\\\":\\\"Stainless\\\",\\\"valueid\\\":\\\"1073\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"731\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":731,\\\"optionname\\\":\\\"Stainless\\\",\\\"optioncode\\\":\\\"STA\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":null,\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":1073,\\\"forchildfieldoptionlinkid\\\":\\\"3_1073\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"0.00\\\",\\\"fieldid\\\":1073}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":330,\\\"labelname\\\":\\\"Roll\\\",\\\"value\\\":\\\"Rev\\\",\\\"valueid\\\":\\\"1078\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"783\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":783,\\\"optionname\\\":\\\"Rev\\\",\\\"optioncode\\\":\\\"\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":1078,\\\"forchildfieldoptionlinkid\\\":\\\"3_1078\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":331,\\\"labelname\\\":\\\"System Type\\\",\\\"value\\\":\\\"Hybrid Oc VIS Bei\\\",\\\"valueid\\\":\\\"1080\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"785\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":785,\\\"optionname\\\":\\\"Hybrid Oc VIS Bei\\\",\\\"optioncode\\\":\\\"HOVB\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":1080,\\\"forchildfieldoptionlinkid\\\":\\\"3_1080\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"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},{\\\"id\\\":7269,\\\"labelname\\\":\\\"Dual\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":5,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":1,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0}]\",\"oi_description\":\"Supplier: Markilux, Width: 567, Drop: 50, Product Type: band z, Fabric: 127mm _ Banlight Duo RD FR, Color: Almond, Vision Panel Size: 160mm, Measure To: Blind Size, Controls: Right hand operation, Brackets: Face Fix, Chain Colour: Stainless, Roll: Rev, System Type: Hybrid Oc VIS Bei\",\"oi_onlinedescription\":null,\"oi_imagepath\":null,\"oi_reportdescription\":\"##Quantity: 1##,##Supplier: Markilux##,##Width: 567 mm##,##Drop: 50 mm##,##Product Type: band z##,##Fabric: 127mm _ Banlight Duo RD FR##,##Color: Almond##,##Vision Panel Size: 160mm##,##Measure To: Blind Size##,##Controls: Right hand operation##,##Brackets: Face Fix##,##Chain Colour: Stainless##,##Roll: Rev##,##System Type: Hybrid Oc VIS Bei##\",\"oi_onlinereportdescription\":null,\"oi_reporttitles\":\"##Quantity:##Supplier:##Width:##Drop:##Product Type:##Fabric:##Color:##Vision Panel Size:##Measure To:##Controls:##Brackets:##Chain Colour:##Roll:##System Type:\",\"oi_onlinereporttitles\":null,\"oi_productionformulajsondata\":\"[]\",\"oi_productiondate\":\"2025-06-04 14:12:33\",\"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\":\"440.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\":1,\"oi_overridevalue\":null,\"oi_overridenetprice\":\"0.000\",\"oi_overridevatprice\":\"0.000\",\"oi_overridegrossprice\":\"0.000\",\"oi_ready\":0,\"oi_onhold\":0,\"oi_platformcreatedfrom\":\"web\",\"oi_platformlastupdatedfrom\":\"web\",\"oi_copiedfrom\":0,\"oi_isonlineorder\":0,\"oi_endcustomervatprice\":null,\"oi_endcustomeroverridetype\":1,\"oi_endcustomeroverridevalue\":null,\"oi_endcustomeroverridenetprice\":\"0.000\",\"oi_endcustomeroverridevatprice\":\"0.000\",\"oi_endcustomeroverridegrossprice\":\"0.000\",\"oi_sage_flag\":0,\"oi_supid\":null,\"oi_status\":0,\"oi_createdby\":1,\"oi_createdat\":\"2025-06-04T14:13:16.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":null,\"oi_jsondataid\":\"[6887, 319, 320, 322, 323, 324, 321, 355, 8291, 325, 326, 327, 328, 329, 330, 331, 332, 335, 333, 336, 337, 7270, 7269]\",\"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": "57758", "cl_createdat": "1749046447.000000", "cl_updatedat": null }, { "cl_id": 57759, "cl_logname": "model", "cl_type": null, "cl_modulename": "Production Due Date", "cl_message": "Production Due Date has been updated", "cl_event": "modified", "cl_subjectid": 5731, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5731, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "{\"Production Due Date\":\"0000-00-00\"}", "cl_changedto": "{\"Production Due Date\":\"2025-06-04\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "57759", "cl_createdat": "1749046447.000000", "cl_updatedat": null }, { "cl_id": 57760, "cl_logname": "default", "cl_type": null, "cl_modulename": "Payments", "cl_message": "new item has been created in Payments", "cl_event": "created", "cl_subjectid": 4076, "cl_subjecttype": "App\\Models\\Payment\\bm_paymentlist", "cl_parentid": 4076, "cl_parentsubjecttype": "App\\Models\\Payment\\bm_paymentlist", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"pl_invoice_id\":2604,\"pl_customer_id\":4008,\"pl_overpayment_id\":0,\"pl_jobpayment_id\":2147483647,\"Amount\":\"150.00\",\"Payment Method\":\"stripe\",\"Payment Type\":\"Deposit\",\"pl_surchargetype\":2,\"pl_surchargemethod\":2,\"pl_surchargeamount\":\"0.00\",\"pl_surchargevalue\":\"0.00\",\"pl_surchargetotal\":\"1500.00\",\"User Entered\":\"admin\",\"Paid Date\":\"2025-06-04\",\"pl_myob_flag\":0,\"pl_qbo_flag\":0}", "cl_customproperties": "{\"attributes\":{\"pl_id\":4076,\"pl_orderid\":null,\"pl_invoice_id\":2604,\"pl_customer_id\":4008,\"pl_overpayment_id\":0,\"pl_jobpayment_id\":2147483647,\"pl_amount\":\"150.00\",\"pl_paymentmethod\":14,\"pl_paymentcategory\":1,\"pl_paymenttype\":8,\"pl_surchargetype\":2,\"pl_surchargemethod\":2,\"pl_surchargeamount\":\"0.00\",\"pl_surchargevalue\":\"0.00\",\"pl_surchargetotal\":\"1500.00\",\"pl_userid\":\"1\",\"pl_paiddate\":\"2025-06-04\",\"pl_decription\":null,\"pl_paymentinvoice\":null,\"pl_paymentstatus\":0,\"pl_xero_flag\":0,\"pl_xerooverpaymentid\":null,\"pl_seq\":0,\"pl_status\":0,\"pl_refundtype\":null,\"created_by\":1,\"created_at\":\"2025-06-04T14:13:57.000000Z\",\"updated_by\":null,\"updated_at\":null,\"pl_deviceplatform\":2,\"pl_myob_flag\":0,\"pl_qbo_flag\":0}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "57760", "cl_createdat": "1749046448.000000", "cl_updatedat": null }, { "cl_id": 57761, "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": 5588, "cl_subjecttype": "App\\Models\\Job\\bm_deliveryaddresssetting", "cl_parentid": 5731, "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\":5588,\"das_jobid\":5731,\"das_appointmentaddress\":4183,\"das_invoiceaddress\":4183,\"das_invoicedeliveryaddress\":4183,\"das_purchaseaddress\":0,\"das_worksheetaddress\":0,\"das_createdby\":1,\"das_createdat\":\"2025-06-04T14:14:08.000000Z\",\"das_updatedby\":null,\"das_updatedat\":\"2025-06-04T14:14:08.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "57761", "cl_createdat": "1749046448.000000", "cl_updatedat": null } ], "updated": [], "deleted": [] }, "bm_productInfo": { "created": [], "updated": [ { "pi_productid": 13, "pi_productname": "Do not use Aluminium Venetians", "pi_pcode": "999", "pi_category": 4, "pi_productgroup": 1, "pi_producttype": 0, "pi_qtyperunit": "0.00", "pi_unitprice": "0.00", "pi_costfactor": null, "pi_commissionrate": "0.000", "pi_commissionmethod": null, "pi_reorderlevel": null, "pi_taxclass": null, "pi_serialno": null, "pi_qtyinstock": null, "pi_supplierid": null, "pi_imagename": null, "pi_currencyid": null, "pi_supplierdefault": null, "pi_productseqno": null, "pi_domesticmarkup": "0.00", "pi_contractmarkup": "0.00", "pi_trademarkup": "0.00", "pi_childsafe": null, "pi_quantyshowhide": null, "pi_compquantyshowhide": null, "pi_stockcontrol": null, "pi_productiontab": null, "pi_fabriccolorcodehide": null, "pi_defaultunitfornewcurtainsorder": null, "pi_costpricecomesfrom": "2", "pi_netpricecomesfrom": "2", "pi_shuttercontract": "0.00", "pi_shuttertrade": "0.00", "pi_shutterdomestic": "0.00", "pi_shutterecommerce": "0.00", "pi_customerdiscount": null, "pi_discountoverridesubwidth": null, "pi_manufacturer_cost": null, "pi_fabrichide": null, "pi_hidecompparameter": null, "pi_factorybarcodeproduct": null, "pi_showhideproductorder": 1, "pi_ecommercestatus": 0, "pi_productdescription": "", "pi_ecomproductdesc": null, "pi_homeimage": null, "pi_galleryimage": null, "pi_innerpageimage": null, "pi_frameimage": "[]", "pi_ecommercecompmarkup": "0.00", "pi_showframeminmax": null, "pi_fabricdefaultdiscount": null, "pi_productstatusmultiple": null, "pi_followproductionseq": 1, "pi_productionformulasheetname": null, "pi_productrules": null, "pi_showexcelfromula": null, "pi_supplierheading": null, "pi_producttypehide": null, "pi_dualproducttypeheading": "Fabric 2", "pi_fabricheading": null, "pi_dualproducttypeenable": 0, "pi_fabricbeforeproducttype": null, "pi_suppliermandatory": null, "pi_showfabric": null, "pi_ecommercesample": "1", "pi_priceavalcheck": null, "pi_showcomponentcode": null, "pi_showmaxarea": null, "pi_recessallowance": null, "pi_deductionname": null, "pi_deductionvalue": "0.00", "pi_stackqty": null, "pi_blindstype": null, "pi_suppliershowhide": null, "pi_pricealert": null, "pi_metatitle": null, "pi_metadescription": null, "pi_metakeyword": null, "pi_canonicaltag": null, "pi_alttexttag": null, "pi_headertag": "H1", "pi_productimage": "[]", "pi_workroom": 1, "pi_mobileapp": 1, "pi_jobtransfer": 0, "pi_seq": 52, "pi_status": 0, "pi_createdby": 1, "pi_defaultunittype": 2, "pi_jobfraction": 1, "pi_unittypeseq": "2,3,1,4", "pi_deafultimage": "{\"defaultimage\":{\"framedefault\":\"\",\"productdefault\":\"\",\"backgrounddefault\":\"\",\"bannerdefault\":\"\"}}", "pi_backgroundimage": "[]", "pi_discountappliesto": "{\"optionschk\":1,\"operationschk\":1,\"pricetablechk\":1}", "pi_ecomProductName": null, "pi_productgroupseq": null, "pi_unitypedata": "{\"1\":1,\"2\":1,\"3\":1,\"4\":1}", "id": "13" } ], "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_jobdetails": { "41749046343": 5731 }, "bm_appointment": { "151749046343": 10051 }, "bm_notelist": { "61749046343": 105232, "61749046344": 105233, "61749046345": 105234 }, "bm_jobmultiquote": { "141749046343": 5760 }, "bm_orderitem": { "71749046396": 31349 }, "bm_Invoice": { "121749046437": 2604 }, "bm_InvoiceDetails": { "101749046437": 15183 }, "bm_paymentlist": { "81749046437": 4076 }, "bm_job_paymentlist": { "81749046407": 396 }, "bm_deliveryaddresssetting": { "161749046427": 5588 } }, "timestamp": 1749046447 }