{ "status": "success", "upcomingorder_list": { "bm_customertemplatedata": { "created": [], "updated": [ { "ctd_id": 1049, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\":1,\"62\":\"AMBR1001\",\"63\":\"\",\"64\":4,\"65\":\"nambridge@btinternet.com\",\"66\":null,\"67\":\"31 High Street\",\"68\":\"\",\"69\":\"North Crawley\",\"70\":\"MK16 9HN\",\"71\":\"Newport Pagnell\",\"72\":19,\"73\":\"07970 818267\",\"598\":\"25\"}", "ctd_deletedcustokeyvalue": "{}", "ctd_isenablecustspecvatrate": 0, "ctd_custspecvatrate": "0.00", "ctd_vatregnum": null, "ctd_custsurcharge": "0.00", "ctd_defaultdelcost": "0.000", "ctd_defaultapptype": "", "ctd_defaultstaff": "", "ctd_addcredit": "0.00", "ctd_totredeemed": "0.00", "ctd_balance": "0.00", "ctd_creditlimit": "0.00", "ctd_creditavailable": "0.00", "ctd_overdue": 0, "ctd_paymenttermstype": 0, "ctd_paymenttermsvalue": 0, "ctd_paymenttermsdesc": "", "ctd_ishold": 0, "ctd_jobview": 0, "ctd_jobtypeview": 0, "ctd_discount": "0.00", "ctd_language": 0, "ctd_notymsg": 0, "ctd_onlinelogoname": null, "ctd_onlinelogo": null, "ctd_onlinesendemail": 0, "ctd_fordesktopisenable": 1, "ctd_foronlineisenable": 0, "ctd_enabledproductdesktop": "60,164,191,153,168,57,186,156,77,71,72,73,65,74,75,184,70,174,61,62,63,76,64,66,58,176,120,178,190,182,59,108,67,69,175,185,31,172,173,247,192,248,249,250,251,252,253,254,255,256,257", "ctd_enabledproductonline": "247,248,249,250,251,252,253,254,255,256,257", "ctd_onlineproductmarkup": null, "ctd_onlineendcustomeruseprefix": null, "ctd_onlineendcustomersequence": "2", "ctd_onlinequotecustomerterms": null, "ctd_onlinequotepaymentterms": null, "ctd_onlineinvoicecustomerterms": null, "ctd_onlineinvoicepaymentterms": null, "ctd_seq": 0, "ctd_status": 0, "id": "1049", "ctd_createdat": 1740814359, "ctd_updatedat": 1755699708, "ctd_createdby": 1, "ctd_updatedby": 1 } ], "deleted": [] }, "bm_customercontactinfo": { "created": [], "updated": [], "deleted": [] }, "bm_appointment": { "created": [], "updated": [ { "app_eventid": 16540, "app_description": "((Need to be there as close to 8:30 as we can))\nCG checked 2 rollers on my table.", "app_summary": "11742-Helen Durrant-Langwm, Mill Hill-07813 282631-Fitters", "app_private": 0, "app_appointmentType": 2, "app_userId": 5, "app_orderId": 13133, "app_customerId": 0, "app_isAllDay": 0, "app_timezone": "Europe\/London", "app_latitude": null, "app_longitude": null, "app_parentappid": null, "app_recurrencerule": null, "app_userdefinedValue": "[]", "app_recurrenceexception": null, "app_attachment": "[]", "guid": "", "app_staff": "", "app_appointtype": "", "app_confirmed": 1, "app_travelHour": "0", "app_travelMinute": "00", "app_onsiteHour": "0", "app_onsiteMinute": "0", "app_location": null, "app_traveltime": null, "app_googleid": "0", "app_platform": "web", "app_cal_status": 844, "app_status": 0, "app_markasread": 1, "app_statusInGoogle": 0, "app_runid": null, "app_jobtimehour": "1", "app_jobtimeminute": "0", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": 7452, "id": "16540", "app_sdate": 1755734400, "app_edate": 1755734400, "app_stime": 1755675000, "app_etime": 1755678600, "app_sdatetime": 1755761400, "app_edatetime": 1755765000, "app_until": null, "app_createdAt": 1754060649, "app_updatedAt": 1755699728, "app_createdBy": 5, "app_updatedBy": 9 }, { "app_eventid": 16696, "app_description": "CG checked 6 cellulars on my table.", "app_summary": "11822-Ruth Ambridge-31 High Street-07970 818267-Fitters", "app_private": 0, "app_appointmentType": 2, "app_userId": 5, "app_orderId": 13227, "app_customerId": 0, "app_isAllDay": 0, "app_timezone": "Europe\/London", "app_latitude": null, "app_longitude": null, "app_parentappid": null, "app_recurrencerule": null, "app_userdefinedValue": "[]", "app_recurrenceexception": null, "app_attachment": null, "guid": "", "app_staff": "", "app_appointtype": "", "app_confirmed": 1, "app_travelHour": "0", "app_travelMinute": "00", "app_onsiteHour": "0", "app_onsiteMinute": "0", "app_location": null, "app_traveltime": null, "app_googleid": "0", "app_platform": "web", "app_cal_status": 844, "app_status": 0, "app_markasread": 1, "app_statusInGoogle": 0, "app_runid": null, "app_jobtimehour": "1", "app_jobtimeminute": "0", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": 1306, "id": "16696", "app_sdate": 1755734400, "app_edate": 1755734400, "app_stime": 1755686400, "app_etime": 1755690000, "app_sdatetime": 1755772800, "app_edatetime": 1755776400, "app_until": null, "app_createdAt": 1755265633, "app_updatedAt": 1755699708, "app_createdBy": 5, "app_updatedBy": 9 } ], "deleted": [] }, "bm_tasklist": { "created": [], "updated": [], "deleted": [] }, "bm_jobdetails": { "created": [], "updated": [], "deleted": [] }, "bm_orderitem": { "created": [ { "oi_id": 86396, "oi_jobid": 13623, "oi_jobtempid": "0", "oi_jobmultiquoteid": 13628, "oi_productid": 261, "oi_recipeid": 261, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":23432,\"labelname\":\"Unit Type\",\"value\":2,\"valueid\":\"2\",\"type\":34,\"optionid\":2,\"optionvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"issubfabric\":0,\"labelnamecode\":\"Unit Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":34,\"mandatory\":0,\"fieldname\":\"Unit Type\",\"fieldid\":23432,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":2,\"optionsvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"editruleoverride\":0},{\"id\":23431,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":null,\"type\":14,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Quantity\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":14,\"mandatory\":0,\"fieldname\":\"Quantity\",\"fieldid\":23431,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":23433,\"labelname\":\"Supplier\",\"value\":35,\"valueid\":null,\"type\":17,\"optionid\":35,\"optionvalue\":[{\"id\":35,\"optionid\":35,\"optionname\":\"Hallis Hudson\",\"deleted\":0,\"optionquantity\":1}],\"issubfabric\":0,\"labelnamecode\":\"Supplier\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":0,\"showFieldOnCustomerPortal\":0,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":17,\"mandatory\":0,\"fieldname\":\"Supplier\",\"fieldid\":23433,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":35,\"optionsvalue\":[{\"id\":35,\"optionid\":35,\"optionname\":\"Hallis Hudson\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":23434,\"labelname\":\"Room\",\"value\":\"Doors\",\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Room\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":0,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Room\",\"fieldid\":23434,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":23435,\"labelname\":\"Size\",\"value\":\"Recess\",\"valueid\":\"63998\",\"type\":3,\"optionid\":\"43545\",\"optionvalue\":[{\"optionid\":43545,\"optionname\":\"Recess\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":63998,\"forchildfieldoptionlinkid\":\"3_63998\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"issubfabric\":0,\"labelnamecode\":\"Size\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":1,\"fieldname\":\"Size\",\"fieldid\":23435,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"43545\",\"optionsvalue\":[{\"optionid\":43545,\"optionname\":\"Recess\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":63998,\"forchildfieldoptionlinkid\":\"3_63998\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"editruleoverride\":1},{\"id\":23436,\"labelname\":\"Width\",\"value\":\"1378\",\"valueid\":null,\"type\":8,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Width\",\"fabricorcolor\":0,\"widthfraction\":\"0___0\",\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":8,\"mandatory\":0,\"fieldname\":\"Width\",\"fieldid\":23436,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":23437,\"labelname\":\"Drop\",\"value\":\"2075\",\"valueid\":null,\"type\":10,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Drop\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":\"0___0\",\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":10,\"mandatory\":0,\"fieldname\":\"Drop\",\"fieldid\":23437,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":23438,\"labelname\":\"Product\",\"value\":\"Neoscenica\",\"valueid\":\"63923\",\"type\":3,\"optionid\":\"43967\",\"optionvalue\":[{\"optionid\":43967,\"optionname\":\"Neoscenica\",\"unittype\":null,\"unitcost\":438.41,\"fieldoptionlinkid\":63923,\"forchildfieldoptionlinkid\":\"3_63923\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":2,\"optionimage\":null,\"reportprice\":657.62,\"costprice\":438.41,\"costwithdiscount\":438.41,\"customersellingprice\":657.62,\"customermarkupvalue\":1.5,\"optiontype\":11,\"quantity\":1,\"optionnetprice\":438.41,\"sellingpriceType\":1}],\"issubfabric\":0,\"labelnamecode\":\"Product\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Product\",\"fieldid\":23438,\"subchild\":[{\"fieldtypeid\":3,\"fieldid\":23474,\"labelnamecode\":\"Mesh\",\"fieldname\":\"Mesh\",\"selection\":0,\"field_has_sub_option\":1,\"seq\":30,\"mandatory\":0,\"fieldlevel\":2,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"fabricorcolor\":0,\"subfieldlinkid\":63923,\"forchildsubfieldlinkid\":\"3_63923\",\"optionsvalue\":[{\"optionid\":43968,\"optionqty\":\"1\",\"optionname\":\"Grey\",\"unittype\":null,\"fieldoptionlinkid\":63925,\"forchildfieldoptionlinkid\":\"3_63925\",\"hasstock\":0,\"subdatacount\":0,\"hasprice\":0,\"optionimage\":null}],\"optionsbackup\":[{\"optionid\":43968,\"optionqty\":\"1\",\"optionname\":\"Grey\",\"unittype\":null,\"fieldoptionlinkid\":63925,\"forchildfieldoptionlinkid\":\"3_63925\",\"hasstock\":0,\"subdatacount\":0,\"hasprice\":0,\"optionimage\":null}],\"editablecolumns\":[\"optionqty\"],\"optionsselectedcolumns\":{\"optionid\":\"Option Id\",\"optionqty\":\"Option Qty\",\"optionname\":\"Option Name\"},\"optiondefault\":\"43968\",\"masterparentfieldid\":23438,\"supplierid\":null,\"subchild\":[],\"issubfabric\":0,\"textfieldheight\":1,\"editruleoverride\":null,\"fieldInformation\":null,\"value\":\"43968\",\"dumydata\":[{\"optionid\":43968,\"optionqty\":\"1\",\"optionname\":\"Grey\",\"unittype\":null,\"fieldoptionlinkid\":63925,\"forchildfieldoptionlinkid\":\"3_63925\",\"hasstock\":0,\"subdatacount\":0,\"hasprice\":0,\"optionimage\":null}],\"blindswidth\":0},{\"fieldtypeid\":3,\"fieldid\":23475,\"labelnamecode\":\"Extras\",\"fieldname\":\"Extras\",\"selection\":1,\"field_has_sub_option\":1,\"seq\":31,\"mandatory\":0,\"fieldlevel\":2,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"fabricorcolor\":0,\"subfieldlinkid\":63923,\"forchildsubfieldlinkid\":\"3_63923\",\"optionsvalue\":[{\"optionid\":43970,\"optionqty\":\"1\",\"optionname\":\"Silver Floor Track\",\"unittype\":null,\"fieldoptionlinkid\":63928,\"forchildfieldoptionlinkid\":\"3_63928\",\"hasstock\":0,\"subdatacount\":0,\"hasprice\":1,\"optionimage\":null}],\"optionsbackup\":[{\"optionid\":43970,\"optionqty\":\"1\",\"optionname\":\"Silver Floor Track\",\"unittype\":null,\"fieldoptionlinkid\":63928,\"forchildfieldoptionlinkid\":\"3_63928\",\"hasstock\":0,\"subdatacount\":0,\"hasprice\":1,\"optionimage\":null}],\"editablecolumns\":[\"optionqty\"],\"optionsselectedcolumns\":{\"optionid\":\"Option Id\",\"optionqty\":\"Option Qty\",\"optionname\":\"Option Name\"},\"optiondefault\":null,\"masterparentfieldid\":23438,\"supplierid\":\"0\",\"subchild\":[],\"issubfabric\":0,\"textfieldheight\":1,\"editruleoverride\":null,\"fieldInformation\":null,\"dumydata\":[],\"blindswidth\":0}],\"fieldInformation\":null,\"optiondefault\":\"43967\",\"optionsvalue\":[{\"optionid\":43967,\"optionname\":\"Neoscenica\",\"unittype\":null,\"unitcost\":438.41,\"fieldoptionlinkid\":63923,\"forchildfieldoptionlinkid\":\"3_63923\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":2,\"optionimage\":null,\"reportprice\":657.62,\"costprice\":438.41,\"costwithdiscount\":438.41,\"customersellingprice\":657.62,\"customermarkupvalue\":1.5,\"optiontype\":11,\"quantity\":1,\"optionnetprice\":438.41,\"sellingpriceType\":1}],\"editruleoverride\":0},{\"id\":23474,\"labelname\":\"Mesh\",\"value\":\"Grey\",\"valueid\":\"63925\",\"type\":3,\"optionid\":\"43968\",\"optionvalue\":[{\"optionid\":43968,\"optionqty\":\"1\",\"optionname\":\"Grey\",\"unittype\":null,\"fieldoptionlinkid\":63925,\"forchildfieldoptionlinkid\":\"3_63925\",\"hasstock\":0,\"subdatacount\":0,\"hasprice\":0,\"optionimage\":null}],\"issubfabric\":0,\"labelnamecode\":\"Mesh\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":2,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Mesh\",\"fieldid\":23474,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"43968\",\"optionsvalue\":[{\"optionid\":43968,\"optionqty\":\"1\",\"optionname\":\"Grey\",\"unittype\":null,\"fieldoptionlinkid\":63925,\"forchildfieldoptionlinkid\":\"3_63925\",\"hasstock\":0,\"subdatacount\":0,\"hasprice\":0,\"optionimage\":null}],\"editruleoverride\":0},{\"id\":23475,\"labelname\":\"Extras\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Extras\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":2,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Extras\",\"fieldid\":23475,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":23461,\"labelname\":\"Frame\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Frame\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Frame\",\"fieldid\":23461,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":23462,\"labelname\":\"Fitting\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fitting\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Fitting\",\"fieldid\":23462,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":23463,\"labelname\":\"Special Instruction\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Special Instruction\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Special Instruction\",\"fieldid\":23463,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":23464,\"labelname\":\"Workroom Notes\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Workroom Notes\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Workroom Notes\",\"fieldid\":23464,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":23467,\"labelname\":\"Product type\",\"value\":null,\"valueid\":null,\"type\":21,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Product type\",\"fabricorcolor\":1,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":0,\"showFieldOnCustomerPortal\":0,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":21,\"mandatory\":0,\"fieldname\":\"Product type\",\"fieldid\":23467,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Room: Doors, Size: Recess, Width: 1378, Drop: 2075, Product: Neoscenica, Mesh: Grey", "oi_reportdescription": "##Quantity: 1##,##Room: Doors##,##Size: Recess##,##Width: 1378 mm##,##Drop: 2075 mm##,##Product: Neoscenica##,##Mesh: Grey##", "oi_reporttitles": "##Quantity:<\/br>##Room:<\/br>##Size:<\/br>##Width:<\/br>##Drop:<\/br>##Product:<\/br>##Mesh:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":null,\"value\":\"-\",\"formula\":null,\"price\":null,\"recipeid\":null,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":null,\"fieldtype_id\":0,\"fractionvalue\":null},{\"formula\":\"noFormula\",\"stockupdate\":0,\"isdelete\":0,\"fieldtype_id\":3,\"fractionvalue\":null}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"0.00\",\"cost_with_discount\":\"0.00\",\"cost_with_markup\":\"0.00\",\"gross_price\":\"0.00\",\"vat_price\":\"0.00\"}", "oi_pricecomesfrom_calculations": "{\"label\":\"Shutter cost\",\"unit_type\":\"-\",\"cost_price\":\"0.00\",\"show_hide\":true,\"category\":5}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "438.410", "oi_netprice": "657.620", "oi_pricesfromoperations": null, "oi_vatprice": "131.520", "oi_vatvalue": "20.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "789.140", "oi_overrideprice": "0.000", "oi_overridetype": 2, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "657.620", "oi_endcustomeroverridevatprice": "131.520", "oi_endcustomeroverridegrossprice": "789.140", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[23432, 23431, 23433, 23434, 23435, 23436, 23437, 23438, 23474, 23475, 23461, 23462, 23463, 23464, 23467]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "86396", "oi_productiondate": 1755648000, "oi_createdat": 1755701313, "oi_updatedat": 1755697773, "oi_createdby": 2, "oi_updatedby": 2 }, { "oi_id": 86397, "oi_jobid": 13623, "oi_jobtempid": "0", "oi_jobmultiquoteid": 13628, "oi_productid": 173, "oi_recipeid": 173, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 2, "oi_customseq": 2, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":15758,\"labelname\":\"Unit Type\",\"value\":2,\"valueid\":\"2\",\"type\":34,\"optionid\":2,\"optionvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"issubfabric\":0,\"labelnamecode\":\"Unit Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":34,\"mandatory\":0,\"fieldname\":\"Unit Type\",\"fieldid\":15758,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":2,\"optionsvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"editruleoverride\":0},{\"id\":15757,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":null,\"type\":14,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Quantity\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":14,\"mandatory\":0,\"fieldname\":\"Quantity\",\"fieldid\":15757,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":15759,\"labelname\":\"Room\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Room\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Room\",\"fieldid\":15759,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":15760,\"labelname\":\"Fitting\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fitting\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Fitting\",\"fieldid\":15760,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":15761,\"labelname\":\"Special Instructions\",\"value\":\"To Survey, Supply and Install Neoscenica\",\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Special Instructions\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Special Instructions\",\"fieldid\":15761,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":15762,\"labelname\":\"Workroom Notes\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Workroom Notes\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Workroom Notes\",\"fieldid\":15762,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Special Instructions: To Survey, Supply and Install Neoscenica", "oi_reportdescription": "##Quantity: 1##,##Special Instructions: To Survey, Supply and Install Neoscenica##", "oi_reporttitles": "##Quantity:<\/br>##Special Instructions:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":null,\"value\":\"-\",\"formula\":null,\"price\":null,\"recipeid\":null,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":null,\"fieldtype_id\":0,\"fractionvalue\":null},{\"formula\":\"noFormula\",\"stockupdate\":0,\"isdelete\":0,\"fieldtype_id\":3,\"fractionvalue\":null}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"0.00\",\"cost_with_discount\":\"0.00\",\"cost_with_markup\":\"0.00\",\"gross_price\":\"0.00\",\"vat_price\":\"0.00\"}", "oi_pricecomesfrom_calculations": "{\"label\":\"Price table cost\",\"unit_type\":\"-\",\"cost_price\":\"0.00\",\"show_hide\":true}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "0.000", "oi_netprice": "0.000", "oi_pricesfromoperations": null, "oi_vatprice": "0.000", "oi_vatvalue": "20.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "0.000", "oi_overrideprice": "250.000", "oi_overridetype": 2, "oi_overridevalue": "250", "oi_overridenetprice": "208.330", "oi_overridevatprice": "41.670", "oi_overridegrossprice": "250.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "0.000", "oi_endcustomeroverridevatprice": "0.000", "oi_endcustomeroverridegrossprice": "0.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[15758, 15757, 15759, 15760, 15761, 15762]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "86397", "oi_productiondate": 1755701366, "oi_createdat": 1755701366, "oi_updatedat": 1755697816, "oi_createdby": 2, "oi_updatedby": null } ], "updated": [], "deleted": [] }, "bm_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_notelist": { "created": [], "updated": [], "deleted": [] }, "bm_deliveryaddresssetting": { "created": [], "updated": [], "deleted": [] }, "bm_jobchecklist": { "created": [], "updated": [], "deleted": [] }, "bm_Invoice": { "created": [], "updated": [], "deleted": [] }, "bm_InvoiceDetails": { "created": [], "updated": [], "deleted": [] }, "bm_invoice_credit_note": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNote": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNoteDetails": { "created": [], "updated": [], "deleted": [] }, "bm_job_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_OverPayment": { "created": [], "updated": [], "deleted": [] }, "bm_terms": { "created": [], "updated": [], "deleted": [] }, "bm_jobmultiquote": { "created": [], "updated": [], "deleted": [] }, "bm_jobstatus_tracks": { "created": [], "updated": [], "deleted": [] }, "bm_customindividuallogs": { "created": [ { "cl_id": 95558, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment", "cl_message": "Appointment has been updated the field Description", "cl_event": "modified", "cl_subjectid": 16696, "cl_subjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_parentid": 13227, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 9, "cl_changedfrom": "{\"Description\":\"CG checked 4 cellulars on 4th.\"}", "cl_changedto": "{\"Description\":\"CG checked 6 cellulars on my table.\"}", "cl_customproperties": "{\"attributes\":{\"app_description\":\"CG checked 6 cellulars on my table.\",\"app_updatedAt\":\"2025-08-20T14:21:48.000000Z\"},\"old\":{\"app_description\":\"CG checked 4 cellulars on 4th.\",\"app_updatedAt\":\"2025-08-20T08:24:43.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "95558", "cl_createdat": "1755699708.000000", "cl_updatedat": null }, { "cl_id": 95559, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment", "cl_message": "Appointment has been updated the field Description", "cl_event": "modified", "cl_subjectid": 16540, "cl_subjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_parentid": 13133, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 9, "cl_changedfrom": "{\"Description\":\"((Need to be there as close to 8:30 as we can))\\nCG checked 2 rollers on 7th.\"}", "cl_changedto": "{\"Description\":\"((Need to be there as close to 8:30 as we can))\\nCG checked 2 rollers on my table.\"}", "cl_customproperties": "{\"attributes\":{\"app_description\":\"((Need to be there as close to 8:30 as we can))\\nCG checked 2 rollers on my table.\",\"app_updatedAt\":\"2025-08-20T14:22:08.000000Z\"},\"old\":{\"app_description\":\"((Need to be there as close to 8:30 as we can))\\nCG checked 2 rollers on 7th.\",\"app_updatedAt\":\"2025-08-20T08:22:25.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "95559", "cl_createdat": "1755699728.000000", "cl_updatedat": null } ], "updated": [], "deleted": [] }, "bm_productInfo": { "created": [], "updated": [], "deleted": [] }, "bm_fields": { "created": [], "updated": [], "deleted": [] }, "bm_fieldOptionLink": { "created": [], "updated": [], "deleted": [] }, "bm_option": { "created": [], "updated": [], "deleted": [] }, "bm_optionproduct": { "created": [], "updated": [], "deleted": [] }, "bm_linkedfieldswithproduct": { "created": [], "updated": [], "deleted": [] }, "bm_productionstatus": { "created": [], "updated": [], "deleted": [] }, "bm_productpricemap": { "created": [], "updated": [], "deleted": [] }, "bm_productrecipe": { "created": [], "updated": [], "deleted": [] }, "bm_productrecipemap": { "created": [], "updated": [], "deleted": [] }, "bm_supproductcode": { "created": [], "updated": [], "deleted": [] }, "bm_rulesetup": { "created": [], "updated": [], "deleted": [] }, "bm_formulas": { "created": [], "updated": [], "deleted": [] }, "bm_customercommission": { "created": [], "updated": [], "deleted": [] }, "bm_productgroupdetails": { "created": [], "updated": [], "deleted": [] }, "bm_productgroupmaterialmap": { "created": [], "updated": [], "deleted": [] }, "bm_productpricedetails": { "created": [], "updated": [], "deleted": [] }, "bm_fabriccolourmap": { "created": [], "updated": [], "deleted": [] }, "bm_fabricdetails": { "created": [], "updated": [], "deleted": [] }, "bm_colordetails": { "created": [], "updated": [], "deleted": [] }, "bm_optiondiscount": { "created": [], "updated": [], "deleted": [] }, "bm_optionpricebook": { "created": [], "updated": [], "deleted": [] }, "bm_allowances": { "created": [], "updated": [], "deleted": [] }, "bm_xyoptionpricedata": { "created": [], "updated": [], "deleted": [] }, "bm_delivery_cost_setup": { "created": [], "updated": [], "deleted": [] }, "bm_organizationdetails": { "created": [], "updated": [], "deleted": [] }, "bm_applicationSetup": { "created": [], "updated": [], "deleted": [] }, "bm_price_setup": { "created": [], "updated": [], "deleted": [] }, "bm_calendarsetup": { "created": [], "updated": [], "deleted": [] }, "bm_appointmenttype": { "created": [], "updated": [], "deleted": [] }, "bm_userWorkDay": { "created": [], "updated": [], "deleted": [] }, "bm_users": { "created": [], "updated": [], "deleted": [] }, "custom_fields": { "created": [], "updated": [], "deleted": [] }, "customfieldvalues": { "created": [], "updated": [], "deleted": [] } }, "synctodelete": [], "timestamp": 1755699734 }