{
"status": "success",
"upcomingorder_list": {
"bm_customertemplatedata": {
"created": [],
"updated": [],
"deleted": []
},
"bm_customercontactinfo": {
"created": [],
"updated": [],
"deleted": []
},
"bm_appointment": {
"created": [
{
"app_eventid": 16296,
"app_description": "",
"app_summary": "Annual Leave",
"app_private": 1,
"app_appointmentType": 5,
"app_userId": 2,
"app_orderId": 0,
"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": 0,
"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": 0,
"app_statusInGoogle": 0,
"app_runid": 0,
"app_jobtimehour": "4",
"app_jobtimeminute": "0",
"app_products": "[]",
"app_deviceplatform": 0,
"app_recurrenceexception_date": null,
"app_deliveryaddressid": null,
"id": "16296",
"app_sdate": 1753833600,
"app_edate": 1753833600,
"app_stime": 1752480000,
"app_etime": 1752494400,
"app_sdatetime": 1753862400,
"app_edatetime": 1753876800,
"app_until": null,
"app_createdAt": 1752493533,
"app_updatedAt": 1752493533,
"app_createdBy": 3,
"app_updatedBy": null
}
],
"updated": [],
"deleted": []
},
"bm_tasklist": {
"created": [],
"updated": [],
"deleted": []
},
"bm_jobdetails": {
"created": [],
"updated": [
{
"jd_id": 13271,
"jd_customerid": 5678,
"jd_contactid": 7059,
"jd_additionalcontacts": "7059",
"jd_templateid": 1,
"jd_jobmultiquoteid": 13276,
"jd_deletedcustokeyvalue": "{}",
"jd_jobref": "11861",
"jd_jobstatus": 1,
"jd_contactaddid": 0,
"jd_orderstatus": 3,
"jd_accref": "PAYN0001",
"jd_invoiceno": "",
"jd_listprice": "359.83",
"jd_netprice": "359.83",
"jd_vat": "64.77",
"jd_isvaton": 1,
"jd_deliverycost": "0.00",
"jd_deliverycosttypeid": 1,
"jd_overridetypeid": 4,
"jd_orderformprice": "10.00",
"jd_editpricebyid": 0,
"jd_isroundon": 0,
"jd_grossprice": "388.62",
"jd_grossprofit": "66.39",
"jd_costprice": "225.08",
"jd_overrideprice": "10.00",
"jd_overridenetprice": null,
"jd_overridevatprice": null,
"jd_overridegrossprice": null,
"jd_amountoutstanding": "388.62",
"jd_totpaid": "0.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": 1,
"jd_endcustomeroverridevalue": null,
"jd_endcustomeroverridenetprice": "0.00",
"jd_endcustomeroverridevatprice": "0.00",
"jd_endcustomeroverridegrossprice": "0.00",
"jd_endcustomerdeliverycost": null,
"jd_endcustomerdeliverycostinclvat": 1,
"jd_endcustomerfittingcost": null,
"jd_endcustomerfittingcostinclvat": 1,
"jd_onlinedeliveryaddreddtype": 0,
"jd_onlinedeliveryaddreddid": 0,
"jd_seq": 0,
"jd_status": 0,
"jd_createdby": 10,
"jd_updatedby": 10,
"jd_deviceplatform": 0,
"jd_fromjobref": "",
"jd_importorder": 0,
"jd_quickquote": 0,
"jd_deliveryvatperc": "20.000",
"jd_fromdbname": null,
"jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"11861\",\"35\":\"PAYN0001\",\"36\":1,\"37\":1,\"38\":\"\",\"39\":1,\"40\":3,\"41\":10,\"44\":\"\",\"45\":\"Maria\",\"46\":\"Payne\",\"47\":\"\",\"48\":\"maria.payne@accordmarketing.com\",\"49\":\"42 Burmo Way\",\"50\":\"Potton\",\"51\":\"Sandy\",\"52\":\"\",\"53\":\"SG19 2FE\",\"54\":19,\"285\":2,\"286\":\"07834005408\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":\"10\",\"558\":\"0\",\"612\":\"\"}",
"jd_custompricefields": "",
"jd_cdeliveryvatperc": "20.000",
"jd_commission": "[]",
"jd_commissionprice": "0.00",
"jd_commissionsetting": 0,
"jd_commissionaddedvalue": "0.00",
"id": "13271",
"jd_createddate": 1752451200,
"jd_orderdate": null,
"jd_duedate": 1752451200,
"jd_sceduleddate": null,
"jd_invoicedate": null,
"jd_completeddate": null,
"jd_sageexportdate": null,
"jd_createdat": 1752485744,
"jd_updatedat": 1752493558
}
],
"deleted": []
},
"bm_orderitem": {
"created": [
{
"oi_id": 84386,
"oi_jobid": 13274,
"oi_jobtempid": "0",
"oi_jobmultiquoteid": 13279,
"oi_productid": 185,
"oi_recipeid": 185,
"oi_ruleid": 0,
"oi_qty": 1,
"oi_seq": 73,
"oi_customseq": 1,
"oi_productcustomseq": 1,
"oi_jsondata": "[{\"id\":17899,\"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\":17899,\"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\":17898,\"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\":17898,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":17900,\"labelname\":\"Issue Reported\",\"value\":\"Curtain track stopped working.\",\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Issue Reported\",\"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\":1,\"fieldname\":\"Issue Reported\",\"fieldid\":17900,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":17901,\"labelname\":\"Suggested Solution\",\"value\":\"Repair track.\",\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Suggested Solution\",\"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\":1,\"fieldname\":\"Suggested Solution\",\"fieldid\":17901,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":17902,\"labelname\":\"Warranty\",\"value\":\"Outside Warranty\",\"valueid\":\"50805\",\"type\":3,\"optionid\":\"35682\",\"optionvalue\":[{\"optionid\":35682,\"optionqty\":\"1\",\"optioncode\":\"4142\",\"optionname\":\"Outside Warranty\",\"unitcost\":null,\"unittype\":null,\"fieldoptionlinkid\":50805,\"forchildfieldoptionlinkid\":\"3_50805\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"issubfabric\":0,\"labelnamecode\":\"Warranty\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":1,\"fieldname\":\"Warranty\",\"fieldid\":17902,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"35682\",\"optionsvalue\":[{\"optionid\":35682,\"optionqty\":\"1\",\"optioncode\":\"4142\",\"optionname\":\"Outside Warranty\",\"unitcost\":null,\"unittype\":null,\"fieldoptionlinkid\":50805,\"forchildfieldoptionlinkid\":\"3_50805\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"editruleoverride\":1},{\"id\":17903,\"labelname\":\"Parts Required\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Parts Required\",\"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\":\"Parts Required\",\"fieldid\":17903,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":17904,\"labelname\":\"Special Instructions\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Special Instructions\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Special Instructions\",\"fieldid\":17904,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":17905,\"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\":17905,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]",
"oi_description": "Issue Reported: Curtain track stopped working., Suggested Solution: Repair track., Warranty: Outside Warranty",
"oi_reportdescription": "##Quantity: 1##,##Issue Reported: Curtain track stopped working.##,##Suggested Solution: Repair track.##,##Warranty: Outside Warranty##",
"oi_reporttitles": "##Quantity:<\/br>##Issue Reported:<\/br>##Suggested Solution:<\/br>##Warranty:",
"oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":null,\"value\":\"-\",\"formula\":null,\"price\":null,\"sellingprice\":\"0.00\",\"recipeid\":null,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":null,\"fieldtype_id\":0,\"fractionvalue\":null}]",
"oi_operationstatus": "0",
"oi_scanstatus": "",
"oi_operationworkroom_data": "[]",
"oi_operationcalender_data": "[]",
"oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"0.00\",\"cost_with_discount\":\"0.00\",\"cost_with_markup\":\"0.00\",\"gross_price\":\"0.00\",\"vat_price\":\"0.00\"}",
"oi_pricecomesfrom_calculations": "{\"label\":\"Price table cost\",\"unit_type\":\"-\",\"cost_price\":\"0.00\",\"show_hide\":true}",
"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": "40.000",
"oi_overridetype": 2,
"oi_overridevalue": "40",
"oi_overridenetprice": "33.330",
"oi_overridevatprice": "6.670",
"oi_overridegrossprice": "40.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": "[17899, 17898, 17900, 17901, 17902, 17903, 17904, 17905]",
"oi_deviceplatform": 0,
"oi_custompricefields": "",
"oi_editransfer": 0,
"oi_apisup_orderid": 0,
"oi_commissionprice": "0.000",
"oi_commissionvatprice": "0.000",
"id": "84386",
"oi_productiondate": 1752496465,
"oi_createdat": 1752496465,
"oi_updatedat": 1752492926,
"oi_createdby": 8,
"oi_updatedby": 8
}
],
"updated": [
{
"oi_id": 84377,
"oi_jobid": 13271,
"oi_jobtempid": "0",
"oi_jobmultiquoteid": 13276,
"oi_productid": 58,
"oi_recipeid": 58,
"oi_ruleid": 0,
"oi_qty": 1,
"oi_seq": 1,
"oi_customseq": 1,
"oi_productcustomseq": 1,
"oi_jsondata": "[{\"id\":2694,\"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\":2693,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"1\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":2697,\"labelname\":\"Room\",\"value\":\"Kitchen\",\"valueid\":\"\",\"type\":18,\"optionid\":\"Kitchen\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":2695,\"labelname\":\"Supplier\",\"value\":15,\"valueid\":\"\",\"type\":17,\"optionid\":\"15\",\"optionvalue\":[{\"id\":15,\"optionid\":15,\"optionname\":\"Excel\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":2698,\"labelname\":\"Size\",\"value\":\"Blind\",\"valueid\":\"15681\",\"type\":3,\"optionid\":\"13760\",\"optionvalue\":[{\"optionid\":13760,\"optionname\":\"Blind\",\"description\":\"\",\"optioncode\":851,\"pricegroups\":\"Band A_AR_RB,Band B_AR_RB,Band C_AR_RB,Band D_AR_RB,Band E_AR_RB,Elements_AR_RB,LL Band A_AR_RB,LL Band B_AR_RB,LL Band C_AR_RB,LL Band D_AR_RB,LL Band E_AR_RB,LL Elements_AR_RB,MC Band A_AR_RB,MC Band B_AR_RB,MC Band C_AR_RB,MC Band D_AR_RB,MC Band E_AR_RB,MC Elements_AR_RB,Simplicity_EX_RB,Range 1_EX_RB,Range 2_EX_RB,Range 3_EX_RB,Range 4_EX_RB,Range 5_EX_RB,Range 6_EX_RB,Range 6+5per_EX_RB,Range 6+10per_EX_RB,Range 6+15per_EX_RB,Range 6+25per_EX_RB,Range 6+20per_EX_RB,Range 6+35per_EX_RB,Range 6+45per_EX_RB,Range 6+50per_EX_RB,Digitally Printed_EX_RB,Blackout System System 40_EX_RB,R20C Crank A_YE_RB,R20C Crank B_YE_RB,R20C Crank C_YE_RB,R20 A_YE_RB,R20 B_YE_RB,R20 C_YE_RB\",\"domesticsellingprice\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":15681,\"forchildfieldoptionlinkid\":\"3_15681\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":2699,\"labelname\":\"Width\",\"value\":\"1138\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":2700,\"labelname\":\"Drop\",\"value\":\"1000\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":2701,\"labelname\":\"Fabric\",\"value\":\"Unishade 2000 BO FR \",\"valueid\":\"2647\",\"type\":5,\"optionid\":\"2647\",\"optionvalue\":[{\"optionid\":2647,\"optionname\":\"Unishade 2000 BO FR \",\"optionquantity\":1,\"fieldoptionlinkid\":2647,\"forchildfieldoptionlinkid\":\"5_2_2647_1\",\"subdatacount\":1,\"optionimage\":null,\"supplier\":\"Decora\",\"pricegroup\":\"Range 4_EX_RB\",\"pricegroupid\":84}],\"fabricorcolor\":1,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":3391,\"labelname\":\"Color\",\"value\":\"White\",\"valueid\":\"12805\",\"type\":5,\"optionid\":\"12805\",\"optionvalue\":[{\"optionid\":12805,\"optionname\":\"White\",\"optionquantity\":1,\"fieldoptionlinkid\":12805,\"forchildfieldoptionlinkid\":\"5_12805\",\"minimumdiscount\":\"\",\"maximumdiscount\":\"\",\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":2696,\"labelname\":\"Pricing Band\",\"value\":84,\"valueid\":\"84\",\"type\":13,\"optionid\":\"84\",\"optionvalue\":[{\"id\":84,\"fieldid\":2696,\"fieldoptionlinkid\":84,\"optionid\":84,\"mainsupplier\":15,\"blindtypecode\":\"\",\"optionname\":\"Range 4_EX_RB\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3414,\"labelname\":\"Brackets\",\"value\":\"Top Fix\",\"valueid\":\"16396\",\"type\":3,\"optionid\":\"13763\",\"optionvalue\":[{\"optionid\":13763,\"optionname\":\"Top Fix\",\"description\":\"\",\"optioncode\":4090,\"pricegroups\":\"Band A_AR_RB,Band B_AR_RB,Band C_AR_RB,Band D_AR_RB,Band E_AR_RB,Elements_AR_RB,LL Band A_AR_RB,LL Band B_AR_RB,LL Band C_AR_RB,LL Band D_AR_RB,LL Band E_AR_RB,LL Elements_AR_RB,MC Band A_AR_RB,MC Band B_AR_RB,MC Band C_AR_RB,MC Band D_AR_RB,MC Band E_AR_RB,MC Elements_AR_RB,Simplicity_EX_RB,Range 1_EX_RB,Range 2_EX_RB,Range 3_EX_RB,Range 4_EX_RB,Range 5_EX_RB,Range 6_EX_RB,Range 6+5per_EX_RB,Range 6+10per_EX_RB,Range 6+15per_EX_RB,Range 6+25per_EX_RB,Range 6+20per_EX_RB,Range 6+35per_EX_RB,Range 6+45per_EX_RB,Range 6+50per_EX_RB,Digitally Printed_EX_RB,Blackout System System 40_EX_RB,R20C Crank A_YE_RB,R20C Crank B_YE_RB,R20C Crank C_YE_RB,R20 A_YE_RB,R20 B_YE_RB,R20 C_YE_RB\",\"domesticsellingprice\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":16396,\"forchildfieldoptionlinkid\":\"3_16396\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3415,\"labelname\":\"System\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3426,\"labelname\":\"Control Type\",\"value\":\"Motor\",\"valueid\":\"16441\",\"type\":3,\"optionid\":\"13798\",\"optionvalue\":[{\"optionid\":13798,\"optionname\":\"Motor\",\"description\":\"\",\"optioncode\":18310,\"pricegroups\":\"Band A_AR_RB,Band B_AR_RB,Band C_AR_RB,Band D_AR_RB,Band E_AR_RB,Elements_AR_RB,LL Band A_AR_RB,LL Band B_AR_RB,LL Band C_AR_RB,LL Band D_AR_RB,LL Band E_AR_RB,LL Elements_AR_RB,MC Band A_AR_RB,MC Band B_AR_RB,MC Band C_AR_RB,MC Band D_AR_RB,MC Band E_AR_RB,MC Elements_AR_RB,Simplicity_EX_RB,Range 1_EX_RB,Range 2_EX_RB,Range 3_EX_RB,Range 4_EX_RB,Range 5_EX_RB,Range 6_EX_RB,Range 6+5per_EX_RB,Range 6+10per_EX_RB,Range 6+15per_EX_RB,Range 6+25per_EX_RB,Range 6+20per_EX_RB,Range 6+35per_EX_RB,Range 6+45per_EX_RB,Range 6+50per_EX_RB,Digitally Printed_EX_RB,Blackout System System 40_EX_RB,R20C Crank A_YE_RB,R20C Crank B_YE_RB,R20C Crank C_YE_RB,R20 A_YE_RB,R20 B_YE_RB,R20 C_YE_RB\",\"domesticsellingprice\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":16441,\"forchildfieldoptionlinkid\":\"3_16441\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":2,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":16441}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":3427,\"labelname\":\"Control Side\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3428,\"labelname\":\"Roll Direction\",\"value\":\"Reverse off the front \",\"valueid\":\"16447\",\"type\":3,\"optionid\":\"13802\",\"optionvalue\":[{\"optionid\":13802,\"optionname\":\"Reverse off the front \",\"description\":\"\",\"optioncode\":51754,\"pricegroups\":\"\",\"domesticselling price\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"fieldoptionlinkid\":16447,\"forchildfieldoptionlinkid\":\"3_16447\",\"hasstock\":0,\"subdatacount\":0,\"hasprice\":1,\"optionimage\":\"\",\"unitcost\":0,\"reportprice\":\"0.00\",\"fieldid\":16447}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":3439,\"labelname\":\"Motorisation\",\"value\":\"Sonesse 30 Li Ion Ultra RTS Rechargeable\",\"valueid\":\"16607\",\"type\":3,\"optionid\":\"13937\",\"optionvalue\":[{\"optionid\":13937,\"optionname\":\"Sonesse 30 Li Ion Ultra RTS Rechargeable\",\"description\":\"\",\"optioncode\":21020,\"pricegroups\":\"Simplicity_EX_RB,Range 1_EX_RB,Range 2_EX_RB,Range 3_EX_RB,Range 4_EX_RB,Range 5_EX_RB,Range 6_EX_RB,Range 6+5per_EX_RB,Range 6+10per_EX_RB,Range 6+15per_EX_RB,Range 6+25per_EX_RB,Range 6+20per_EX_RB,Range 6+35per_EX_RB,Range 6+45per_EX_RB,Range 6+50per_EX_RB,Digitally Printed_EX_RB,Blackout System System 40_EX_RB\",\"domesticsellingprice\":156,\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":104,\"fieldoptionlinkid\":16607,\"forchildfieldoptionlinkid\":\"3_16607\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":3,\"optionimage\":\"\",\"reportprice\":\"156.00\",\"fieldid\":16607}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":3455,\"labelname\":\"Power Options\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3456,\"labelname\":\"Control\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3457,\"labelname\":\"Product Information\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3472,\"labelname\":\"Cassette Fascia\",\"value\":\"Louvolite Full Fascia Open Cassette 70mm \",\"valueid\":\"16740\",\"type\":3,\"optionid\":\"14049\",\"optionvalue\":[{\"optionid\":14049,\"optionname\":\"Louvolite Full Fascia Open Cassette 70mm \",\"description\":\"Max width 300cm\",\"optioncode\":14501,\"pricegroups\":\"Simplicity_EX_RB,Range 1_EX_RB,Range 2_EX_RB,Range 3_EX_RB,Range 4_EX_RB,Range 5_EX_RB,Range 6_EX_RB,Range 6+5per_EX_RB,Range 6+10per_EX_RB,Range 6+15per_EX_RB,Range 6+25per_EX_RB,Range 6+20per_EX_RB,Range 6+35per_EX_RB,Range 6+45per_EX_RB,Range 6+50per_EX_RB\",\"domesticsellingprice\":\"\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":26,\"fieldoptionlinkid\":16740,\"forchildfieldoptionlinkid\":\"3_16740\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":3,\"optionimage\":\"\",\"reportprice\":\"52.00\",\"fieldid\":16740}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":3477,\"labelname\":\"Fabric Covered\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3478,\"labelname\":\"Colour\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":23414,\"labelname\":\"End Caps\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3494,\"labelname\":\"Bottom Bar\",\"value\":\"Louvolite Smart Rail\",\"valueid\":\"63055\",\"type\":3,\"optionid\":\"43917\",\"optionvalue\":[{\"optionid\":43917,\"optionname\":\"Louvolite Smart Rail\",\"description\":\"\",\"optioncode\":\"\",\"pricegroups\":\"Simplicity_EX_RB,Range 1_EX_RB,Range 2_EX_RB,Range 3_EX_RB,Range 4_EX_RB,Range 5_EX_RB,Range 6_EX_RB,Range 6+5per_EX_RB,Range 6+10per_EX_RB,Range 6+15per_EX_RB,Range 6+25per_EX_RB,Range 6+20per_EX_RB,Range 6+35per_EX_RB,Range 6+45per_EX_RB,Range 6+50per_EX_RB,Digitally Printed_EX_RB\",\"domesticsellingprice\":\"\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":10,\"fieldoptionlinkid\":63055,\"forchildfieldoptionlinkid\":\"3_63055\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":1,\"optionimage\":\"\",\"reportprice\":\"15.00\",\"fieldid\":63055}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":23249,\"labelname\":\"Colour\",\"value\":\"White Smart Rail\",\"valueid\":\"63381\",\"type\":3,\"optionid\":\"43941\",\"optionvalue\":[{\"optionid\":43941,\"optionname\":\"White Smart Rail\",\"description\":\"\",\"optioncode\":\"\",\"pricegroups\":\"Simplicity_EX_RB,Range 1_EX_RB,Range 2_EX_RB,Range 3_EX_RB,Range 4_EX_RB,Range 5_EX_RB,Range 6_EX_RB,Range 6+5per_EX_RB,Range 6+10per_EX_RB,Range 6+15per_EX_RB,Range 6+25per_EX_RB,Range 6+20per_EX_RB,Range 6+35per_EX_RB,Range 6+45per_EX_RB,Range 6+50per_EX_RB\",\"domesticselling price\":\"\",\"optionqty\":\"1\",\"unittype\":null,\"fieldoptionlinkid\":63381,\"forchildfieldoptionlinkid\":\"3_63381\",\"hasstock\":0,\"subdatacount\":0,\"hasprice\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":3503,\"labelname\":\"Scallops\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3509,\"labelname\":\"Braid\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3515,\"labelname\":\"Pulls\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3519,\"labelname\":\"Extras\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3520,\"labelname\":\"Fitting\",\"value\":\"Fitting\",\"valueid\":\"17063\",\"type\":3,\"optionid\":\"14334\",\"optionvalue\":[{\"optionid\":14334,\"optionname\":\"Fitting\",\"description\":\"\",\"optioncode\":18831,\"pricegroups\":\"Band A_AR_RB,Band B_AR_RB,Band C_AR_RB,Band D_AR_RB,Band E_AR_RB,Elements_AR_RB,LL Band A_AR_RB,LL Band B_AR_RB,LL Band C_AR_RB,LL Band D_AR_RB,LL Band E_AR_RB,LL Elements_AR_RB,MC Band A_AR_RB,MC Band B_AR_RB,MC Band C_AR_RB,MC Band D_AR_RB,MC Band E_AR_RB,MC Elements_AR_RB,Simplicity_EX_RB,Range 1_EX_RB,Range 2_EX_RB,Range 3_EX_RB,Range 4_EX_RB,Range 5_EX_RB,Range 6_EX_RB,Range 6+5per_EX_RB,Range 6+10per_EX_RB,Range 6+15per_EX_RB,Range 6+25per_EX_RB,Range 6+20per_EX_RB,Range 6+35per_EX_RB,Range 6+45per_EX_RB,Range 6+50per_EX_RB,Digitally Printed_EX_RB,Blackout System System 40_EX_RB,R20C Crank A_YE_RB,R20C Crank B_YE_RB,R20C Crank C_YE_RB,R20 A_YE_RB,R20 B_YE_RB,R20 C_YE_RB\",\"domesticsellingprice\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":33.33,\"fieldoptionlinkid\":17063,\"forchildfieldoptionlinkid\":\"3_17063\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"33.33\",\"fieldid\":17063}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3521,\"labelname\":\"Special Instructions\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3522,\"labelname\":\"Workroom Notes\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]",
"oi_description": "Unit Type: mm, Quantity: 1, Room: Kitchen, Supplier: Excel, Size: Blind, Width: 1138, Drop: 1000, Fabric: Unishade 2000 BO FR , Color: White, Brackets: Top Fix, Control Type: Motor, Roll Direction: Reverse off the front , Motorisation: Sonesse 30 Li Ion Ultra RTS Rechargeable, Cassette Fascia: Louvolite Full Fascia Open Cassette 70mm , Bottom Bar: Louvolite Smart Rail, Colour: White Smart Rail, Fitting: Fitting",
"oi_reportdescription": "##Quantity: 1##,##Room: Kitchen##,##Supplier: Excel##,##Size: Blind##,##Width: 1138 mm##,##Drop: 1000 mm##,##Fabric: Unishade 2000 BO FR ##,##Color: White##,##Brackets: Top Fix##,##Control Type: Motor##,##Roll Direction: Reverse off the front ##,##Motorisation: Sonesse 30 Li Ion Ultra RTS Rechargeable##,##Cassette Fascia: Louvolite Full Fascia Open Cassette 70mm ##,##Bottom Bar: Louvolite Smart Rail##,##Colour: White Smart Rail##,##Fitting: Fitting##",
"oi_reporttitles": "##Quantity:##Room:##Supplier:##Size:##Width:##Drop:##Fabric:##Color:##Brackets:##Control Type:##Roll Direction:##Motorisation:##Cassette Fascia:##Bottom Bar:##Colour:##Fitting:",
"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": "225.080",
"oi_netprice": "359.830",
"oi_pricesfromoperations": null,
"oi_vatprice": "71.970",
"oi_vatvalue": "20.000",
"oi_vatselected": 1,
"oi_vattype": 1,
"oi_vatonoff": 1,
"oi_grossprice": "431.800",
"oi_overrideprice": "0.000",
"oi_overridetype": 4,
"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": 4,
"oi_endcustomeroverridevalue": null,
"oi_endcustomeroverridenetprice": "359.830",
"oi_endcustomeroverridevatprice": "71.970",
"oi_endcustomeroverridegrossprice": "431.800",
"oi_sage_flag": 0,
"oi_status": 0,
"oi_jsondataid": "[2694, 2693, 2697, 2695, 2698, 2699, 2700, 2701, 3391, 2696, 3414, 3415, 3426, 3427, 3428, 3439, 3455, 3456, 3457, 3472, 3477, 3478, 23414, 3494, 23249, 3503, 3509, 3515, 3519, 3520, 3521, 3522]",
"oi_deviceplatform": 2,
"oi_custompricefields": "",
"oi_editransfer": 0,
"oi_apisup_orderid": 0,
"oi_commissionprice": "0.000",
"oi_commissionvatprice": "0.000",
"id": "84377",
"oi_productiondate": 1752489529,
"oi_createdat": 1752489529,
"oi_updatedat": 1752493558,
"oi_createdby": 10,
"oi_updatedby": 10
}
],
"deleted": []
},
"bm_paymentlist": {
"created": [],
"updated": [],
"deleted": []
},
"bm_notelist": {
"created": [
{
"nl_id": 489656,
"nl_ordertempid": 0,
"nl_orderid": 13271,
"nl_notescategory": 1,
"nl_type": 26,
"nl_platform": 2,
"nl_desc": "measurements",
"nl_manualNotes": null,
"nl_createdby": "10",
"nl_attachmnettext": "mobileattachment1752493558_0.jpg",
"nl_attachmnetURL": "\/storage\/attachments\/CONCORDE\/notesfiles\/489656_mobileattachment1752493558_0.jpg",
"nl_isonlinenote": 0,
"nl_seq": 0,
"nl_status": 0,
"nl_barcodeprocessid": null,
"id": "489656",
"nl_endddate": 1752451200,
"nl_starttime": 1752493474,
"created_at": 1752493474,
"updated_at": 1752493558,
"created_by": 10,
"updated_by": null
}
],
"updated": [],
"deleted": []
},
"bm_deliveryaddresssetting": {
"created": [],
"updated": [],
"deleted": []
},
"bm_jobchecklist": {
"created": [],
"updated": [],
"deleted": []
},
"bm_Invoice": {
"created": [],
"updated": [],
"deleted": []
},
"bm_InvoiceDetails": {
"created": [],
"updated": [],
"deleted": []
},
"bm_invoice_credit_note": {
"created": [],
"updated": [],
"deleted": []
},
"bm_CreditNote": {
"created": [],
"updated": [],
"deleted": []
},
"bm_CreditNoteDetails": {
"created": [],
"updated": [],
"deleted": []
},
"bm_job_paymentlist": {
"created": [],
"updated": [],
"deleted": []
},
"bm_OverPayment": {
"created": [],
"updated": [],
"deleted": []
},
"bm_terms": {
"created": [],
"updated": [],
"deleted": []
},
"bm_jobmultiquote": {
"created": [],
"updated": [],
"deleted": []
},
"bm_jobstatus_tracks": {
"created": [],
"updated": [],
"deleted": []
},
"bm_customindividuallogs": {
"created": [
{
"cl_id": 74161,
"cl_logname": "default",
"cl_type": null,
"cl_modulename": "Appointment",
"cl_message": "new item has been created in Appointment",
"cl_event": "created",
"cl_subjectid": 16296,
"cl_subjecttype": "App\\Models\\Calendar\\bm_appointment",
"cl_parentid": 16296,
"cl_parentsubjecttype": "App\\Models\\Calendar\\bm_appointment",
"cl_causerid": 3,
"cl_changedfrom": "null",
"cl_changedto": "{\"Repeat On\":\"yearly on July 14\",\"app_summary\":\"Annual Leave\",\"Private\":\"enabled\",\"Appointment Type\":\"Annual Leave\",\"Staff\":\"Kieren\",\"Start Date & Time\":\"2025-07-30 08:00:00\",\"End Date & Time\":\"2025-07-30 12:00:00\",\"Appointment Status\":\"Ready\",\"app_jobtimehour\":\"4\",\"app_products\":\"[]\"}",
"cl_customproperties": "{\"attributes\":{\"app_eventid\":16296,\"app_description\":\"\",\"app_summary\":\"Annual Leave\",\"app_private\":1,\"app_appointmentType\":5,\"app_userId\":2,\"app_orderId\":0,\"app_customerId\":0,\"app_isAllDay\":0,\"app_sdate\":\"2025-07-30\",\"app_edate\":\"2025-07-30\",\"app_stime\":\"08:00:00\",\"app_etime\":\"12:00:00\",\"app_sdatetime\":\"2025-07-30 08:00:00\",\"app_edatetime\":\"2025-07-30 12:00:00\",\"app_timezone\":\"Europe\\\/London\",\"app_latitude\":null,\"app_longitude\":null,\"app_parentappid\":null,\"app_recurrencerule\":null,\"app_userdefinedValue\":\"[]\",\"app_recurrenceexception\":null,\"app_recurrenceexception_date\":null,\"app_attachment\":null,\"guid\":\"\",\"app_outlookuid\":null,\"app_until\":null,\"app_staff\":\"\",\"app_appointtype\":\"\",\"app_confirmed\":0,\"app_coordinates\":\"\",\"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\":0,\"app_statusInGoogle\":0,\"app_createdBy\":3,\"app_updatedBy\":null,\"app_createdAt\":\"2025-07-14T11:45:33.000000Z\",\"app_updatedAt\":\"2025-07-14T11:45:33.000000Z\",\"app_runid\":0,\"app_deliveryaddressid\":null,\"app_jobtimehour\":\"4\",\"app_jobtimeminute\":\"0\",\"app_products\":\"[]\",\"app_deviceplatform\":0,\"app_statusInOutlook\":null}}",
"cl_attachment": null,
"cl_deviceplatform": "Desktop",
"cl_deviceipaddress": "",
"cl_devicenameversion": "",
"cl_devicelocation": "",
"cl_causertype": "App\\Models\\BMUsers",
"id": "74161",
"cl_createdat": "1752493533.000000",
"cl_updatedat": null
},
{
"cl_id": 74162,
"cl_logname": "default",
"cl_type": null,
"cl_modulename": "Notes",
"cl_message": "new item has been created in Notes",
"cl_event": "created",
"cl_subjectid": 489656,
"cl_subjecttype": "App\\Models\\Notes\\bm_notelist",
"cl_parentid": 13271,
"cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails",
"cl_causerid": 10,
"cl_changedfrom": "null",
"cl_changedto": "{\"Type\":\"Mobile Picture\",\"Platform\":\"Trade\",\"Description\":\"measurements\",\"Created By\":\"Margaret\",\"Date\":\"2025-07-14\",\"Time\":\"11:44:34\",\"Is online note\":\"No\"}",
"cl_customproperties": "{\"attributes\":{\"nl_id\":489656,\"nl_ordertempid\":0,\"nl_orderid\":13271,\"nl_notescategory\":1,\"nl_type\":26,\"nl_platform\":2,\"nl_desc\":\"measurements\",\"nl_manualNotes\":null,\"nl_createdby\":\"10\",\"nl_endddate\":\"2025-07-14\",\"nl_starttime\":\"11:44:34\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":10,\"created_at\":\"2025-07-14T11:44:34.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-07-14T11:45:58.000000Z\",\"nl_barcodeprocessid\":null}}",
"cl_attachment": null,
"cl_deviceplatform": "ios",
"cl_deviceipaddress": "",
"cl_devicenameversion": "",
"cl_devicelocation": "",
"cl_causertype": "App\\Models\\BMUsers",
"id": "74162",
"cl_createdat": "1752493558.000000",
"cl_updatedat": null
},
{
"cl_id": 74163,
"cl_logname": "default",
"cl_type": null,
"cl_modulename": "Notes",
"cl_message": "Notes has been updated the fields Attachment,Attachment URL",
"cl_event": "modified",
"cl_subjectid": 489656,
"cl_subjecttype": "App\\Models\\Notes\\bm_notelist",
"cl_parentid": 13271,
"cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails",
"cl_causerid": 10,
"cl_changedfrom": "[]",
"cl_changedto": "{\"Attachment\":\"mobileattachment1752493558_0.jpg\",\"Attachment URL\":\"\\\/storage\\\/attachments\\\/CONCORDE\\\/notesfiles\\\/489656_mobileattachment1752493558_0.jpg\"}",
"cl_customproperties": "{\"attributes\":{\"nl_attachmnettext\":\"mobileattachment1752493558_0.jpg\",\"nl_attachmnetURL\":\"\\\/storage\\\/attachments\\\/CONCORDE\\\/notesfiles\\\/489656_mobileattachment1752493558_0.jpg\"},\"old\":{\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null}}",
"cl_attachment": null,
"cl_deviceplatform": "ios",
"cl_deviceipaddress": "",
"cl_devicenameversion": "",
"cl_devicelocation": "",
"cl_causertype": "App\\Models\\BMUsers",
"id": "74163",
"cl_createdat": "1752493558.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": {
"bm_notelist": {
"61752493474": 489656
}
},
"timestamp": 1752493558
}