{
"status": "success",
"upcomingorder_list": {
"bm_customertemplatedata": {
"created": [],
"updated": [],
"deleted": []
},
"bm_customercontactinfo": {
"created": [],
"updated": [],
"deleted": []
},
"bm_appointment": {
"created": [],
"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": "323.85",
"jd_netprice": "323.85",
"jd_vat": "64.77",
"jd_isvaton": 1,
"jd_deliverycost": "0.00",
"jd_deliverycosttypeid": 1,
"jd_overridetypeid": 2,
"jd_orderformprice": "0.00",
"jd_editpricebyid": 0,
"jd_isroundon": 0,
"jd_grossprice": "388.62",
"jd_grossprofit": "134.75",
"jd_costprice": "225.08",
"jd_overrideprice": null,
"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": 1752492903
}
],
"deleted": []
},
"bm_orderitem": {
"created": [],
"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": "10.000",
"oi_overridetype": 4,
"oi_overridevalue": "10.000",
"oi_overridenetprice": "323.850",
"oi_overridevatprice": "64.770",
"oi_overridegrossprice": "388.620",
"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": 1752492903,
"oi_createdby": 10,
"oi_updatedby": 10
}
],
"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": 74138,
"cl_logname": "default",
"cl_type": null,
"cl_modulename": "All Jobs",
"cl_message": "Quote Custom report generated by Margaret All Jobs",
"cl_event": "created",
"cl_subjectid": 6922,
"cl_subjecttype": "App\\Models\\Reports\\bm_reportactivitylog",
"cl_parentid": 13271,
"cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails",
"cl_causerid": 10,
"cl_changedfrom": "null",
"cl_changedto": "{\"Category: \":\"Quotation\"}",
"cl_customproperties": "{\"attributes\":{\"ral_id\":6922,\"ral_jobid\":13271,\"ral_reportid\":12,\"ral_categoryid\":1,\"ral_description\":\"Quote Custom report generated by Margaret\",\"ral_attachment\":\"\",\"ral_actionid\":1,\"ral_createdat\":\"2025-07-14T11:34:02.000000Z\",\"ral_updatedat\":\"2025-07-14T11:34:02.000000Z\",\"ral_createdby\":10,\"ral_updatedby\":null}}",
"cl_attachment": null,
"cl_deviceplatform": "ios",
"cl_deviceipaddress": "",
"cl_devicenameversion": "",
"cl_devicelocation": "",
"cl_causertype": "App\\Models\\BMUsers",
"id": "74138",
"cl_createdat": "1752492842.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": 1752492903
}