{
"status": "success",
"upcomingorder_list": {
"bm_customertemplatedata": {
"created": [],
"updated": [
{
"ctd_id": 115,
"ctd_createdfrom": 0,
"ctd_templateid": 2,
"ctd_moduleid": 3,
"ctd_latitude": "",
"ctd_longitude": "",
"ctd_leadimage": null,
"ctd_jobcustomoizedkeyvalue": "",
"ctd_customoizedkeyvalue": "{\"61\": 1, \"598\": 25, \"62\": \"QUOT0020\"}",
"ctd_deletedcustokeyvalue": "{}",
"ctd_isenablecustspecvatrate": 0,
"ctd_custspecvatrate": "0.00",
"ctd_vatregnum": null,
"ctd_custsurcharge": null,
"ctd_defaultdelcost": null,
"ctd_defaultapptype": null,
"ctd_defaultstaff": null,
"ctd_addcredit": "0.00",
"ctd_totredeemed": "0.00",
"ctd_balance": "0.00",
"ctd_creditlimit": "0.00",
"ctd_creditavailable": "0.00",
"ctd_overdue": 0,
"ctd_paymenttermstype": 0,
"ctd_paymenttermsvalue": 0,
"ctd_paymenttermsdesc": null,
"ctd_ishold": 0,
"ctd_jobview": 0,
"ctd_jobtypeview": 0,
"ctd_discount": "0.00",
"ctd_language": 0,
"ctd_notymsg": 0,
"ctd_onlinelogoname": null,
"ctd_onlinelogo": null,
"ctd_onlinesendemail": 0,
"ctd_fordesktopisenable": 0,
"ctd_foronlineisenable": 0,
"ctd_enabledproductdesktop": "0",
"ctd_enabledproductonline": "0",
"ctd_onlineproductmarkup": null,
"ctd_onlineendcustomeruseprefix": null,
"ctd_onlineendcustomersequence": null,
"ctd_onlinequotecustomerterms": null,
"ctd_onlinequotepaymentterms": null,
"ctd_onlineinvoicecustomerterms": null,
"ctd_onlineinvoicepaymentterms": null,
"ctd_seq": 0,
"ctd_status": 0,
"id": "115",
"ctd_createdat": 1742439984,
"ctd_updatedat": 1742440656,
"ctd_createdby": 0,
"ctd_updatedby": null
}
],
"deleted": []
},
"bm_customercontactinfo": {
"created": [],
"updated": [
{
"cci_id": 176,
"cci_customerid": 115,
"cci_templateid": 3,
"roleid": 0,
"cci_customizedarray": "{\"79\":\"Quote 23\",\"83\":\"1\"}",
"cci_customizedarraydel": "{}",
"cci_addressinfo": "{\"87\":\"Quote 23\",\"90\":35,\"91\":\"Quote 23\"}",
"cci_ismarketingemails": 0,
"cci_smsverifystatus": 0,
"cci_isdocumentreceived": 0,
"cci_receiveddocfor": null,
"cci_isonlineportal": 0,
"cci_latitude": null,
"cci_longitude": null,
"cci_username": null,
"cci_password": null,
"cci_confirmpassword": null,
"cci_seq": 0,
"cci_status": 0,
"cci_deviceplatform": 1,
"cci_mobcustomertempid": 31742439984,
"id": "176",
"cci_createdat": 1742439984,
"cci_updatedat": 1742440656,
"cci_createdby": 0,
"cci_updatedby": null
}
],
"deleted": []
},
"bm_appointment": {
"created": [],
"updated": [],
"deleted": []
},
"bm_tasklist": {
"created": [],
"updated": [],
"deleted": []
},
"bm_jobdetails": {
"created": [
{
"jd_id": 321,
"jd_customerid": 115,
"jd_contactid": 176,
"jd_additionalcontacts": "176",
"jd_templateid": 1,
"jd_jobmultiquoteid": 333,
"jd_deletedcustokeyvalue": "{}",
"jd_jobref": "ON1670",
"jd_jobstatus": 3,
"jd_contactaddid": 0,
"jd_orderstatus": 3,
"jd_accref": "QUOT0020",
"jd_invoiceno": "",
"jd_listprice": "55.00",
"jd_netprice": "55.00",
"jd_vat": "11.00",
"jd_isvaton": 1,
"jd_deliverycost": "0.00",
"jd_deliverycosttypeid": 5,
"jd_overridetypeid": 1,
"jd_orderformprice": "0.00",
"jd_editpricebyid": null,
"jd_isroundon": 0,
"jd_grossprice": "66.00",
"jd_grossprofit": "0.00",
"jd_costprice": "55.00",
"jd_overrideprice": null,
"jd_overridenetprice": null,
"jd_overridevatprice": null,
"jd_overridegrossprice": null,
"jd_amountoutstanding": "66.00",
"jd_totpaid": "0.00",
"jd_creditlimit": "0.00",
"jd_creditbalance": "0.00",
"jd_overdue": "0.00",
"jd_userdefinedarray": null,
"jd_deliverycostid": 0,
"jd_iscostpriceon": 0,
"jd_isonlineorder": 1,
"jd_isonlineordersubmitted": 0,
"jd_endcustomervatprice": null,
"jd_endcustomeroverridetype": 0,
"jd_endcustomeroverridevalue": null,
"jd_endcustomeroverridenetprice": "0.00",
"jd_endcustomeroverridevatprice": "0.00",
"jd_endcustomeroverridegrossprice": "0.00",
"jd_endcustomerdeliverycost": null,
"jd_endcustomerdeliverycostinclvat": 0,
"jd_endcustomerfittingcost": null,
"jd_endcustomerfittingcostinclvat": 0,
"jd_onlinedeliveryaddreddtype": 0,
"jd_onlinedeliveryaddreddid": 0,
"jd_seq": 0,
"jd_status": 0,
"jd_createdby": 2,
"jd_updatedby": 2,
"jd_deviceplatform": 0,
"jd_fromjobref": "",
"jd_importorder": 0,
"jd_quickquote": 23,
"jd_deliveryvatperc": "20.000",
"jd_fromdbname": null,
"jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"ON1670\",\"35\":\"QUOT0020\",\"36\":3,\"37\":1,\"38\":\"\",\"39\":\"\",\"40\":3,\"41\":2,\"44\":\"\",\"45\":\"\",\"46\":\"Quote 23\",\"47\":\"\",\"48\":\"\",\"49\":\"Quote 23\",\"50\":\"\",\"51\":\"Quote 23\",\"52\":\"\",\"53\":\"\",\"54\":35,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":2,\"558\":\"\",\"603\":\"\",\"612\":\"\",\"613\":\"\",\"614\":1,\"615\":\"\",\"countryText\":\"USA\"}",
"jd_custompricefields": "",
"jd_cdeliveryvatperc": "20.000",
"jd_commission": "[]",
"jd_commissionprice": "0.00",
"jd_commissionsetting": 0,
"jd_commissionaddedvalue": "0.00",
"id": "321",
"jd_createddate": 1742428800,
"jd_orderdate": null,
"jd_duedate": 1742428800,
"jd_sceduleddate": null,
"jd_invoicedate": null,
"jd_completeddate": null,
"jd_sageexportdate": null,
"jd_createdat": 1742439984,
"jd_updatedat": 1742440656
}
],
"updated": [
{
"jd_id": 321,
"jd_customerid": 115,
"jd_contactid": 176,
"jd_additionalcontacts": "176",
"jd_templateid": 1,
"jd_jobmultiquoteid": 333,
"jd_deletedcustokeyvalue": "{}",
"jd_jobref": "ON1670",
"jd_jobstatus": 3,
"jd_contactaddid": 0,
"jd_orderstatus": 3,
"jd_accref": "QUOT0020",
"jd_invoiceno": "",
"jd_listprice": "55.00",
"jd_netprice": "55.00",
"jd_vat": "11.00",
"jd_isvaton": 1,
"jd_deliverycost": "0.00",
"jd_deliverycosttypeid": 5,
"jd_overridetypeid": 1,
"jd_orderformprice": "0.00",
"jd_editpricebyid": null,
"jd_isroundon": 0,
"jd_grossprice": "66.00",
"jd_grossprofit": "0.00",
"jd_costprice": "55.00",
"jd_overrideprice": null,
"jd_overridenetprice": null,
"jd_overridevatprice": null,
"jd_overridegrossprice": null,
"jd_amountoutstanding": "66.00",
"jd_totpaid": "0.00",
"jd_creditlimit": "0.00",
"jd_creditbalance": "0.00",
"jd_overdue": "0.00",
"jd_userdefinedarray": null,
"jd_deliverycostid": 0,
"jd_iscostpriceon": 0,
"jd_isonlineorder": 1,
"jd_isonlineordersubmitted": 0,
"jd_endcustomervatprice": null,
"jd_endcustomeroverridetype": 0,
"jd_endcustomeroverridevalue": null,
"jd_endcustomeroverridenetprice": "0.00",
"jd_endcustomeroverridevatprice": "0.00",
"jd_endcustomeroverridegrossprice": "0.00",
"jd_endcustomerdeliverycost": null,
"jd_endcustomerdeliverycostinclvat": 0,
"jd_endcustomerfittingcost": null,
"jd_endcustomerfittingcostinclvat": 0,
"jd_onlinedeliveryaddreddtype": 0,
"jd_onlinedeliveryaddreddid": 0,
"jd_seq": 0,
"jd_status": 0,
"jd_createdby": 2,
"jd_updatedby": 2,
"jd_deviceplatform": 0,
"jd_fromjobref": "",
"jd_importorder": 0,
"jd_quickquote": 23,
"jd_deliveryvatperc": "20.000",
"jd_fromdbname": null,
"jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"ON1670\",\"35\":\"QUOT0020\",\"36\":3,\"37\":1,\"38\":\"\",\"39\":\"\",\"40\":3,\"41\":2,\"44\":\"\",\"45\":\"\",\"46\":\"Quote 23\",\"47\":\"\",\"48\":\"\",\"49\":\"Quote 23\",\"50\":\"\",\"51\":\"Quote 23\",\"52\":\"\",\"53\":\"\",\"54\":35,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":2,\"558\":\"\",\"603\":\"\",\"612\":\"\",\"613\":\"\",\"614\":1,\"615\":\"\",\"countryText\":\"USA\"}",
"jd_custompricefields": "",
"jd_cdeliveryvatperc": "20.000",
"jd_commission": "[]",
"jd_commissionprice": "0.00",
"jd_commissionsetting": 0,
"jd_commissionaddedvalue": "0.00",
"id": "321",
"jd_createddate": 1742428800,
"jd_orderdate": null,
"jd_duedate": 1742428800,
"jd_sceduleddate": null,
"jd_invoicedate": null,
"jd_completeddate": null,
"jd_sageexportdate": null,
"jd_createdat": 1742439984,
"jd_updatedat": 1742440656
}
],
"deleted": []
},
"bm_orderitem": {
"created": [
{
"oi_id": 1274,
"oi_jobid": 321,
"oi_jobtempid": "0",
"oi_jobmultiquoteid": 333,
"oi_productid": 14,
"oi_recipeid": 16,
"oi_ruleid": 0,
"oi_qty": 1,
"oi_seq": 0,
"oi_customseq": 0,
"oi_productcustomseq": 0,
"oi_jsondata": "[{\"id\":1777,\"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\":1776,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":4706,\"labelname\":\"Location\",\"value\":\"hall\",\"valueid\":\"\",\"type\":29,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1778,\"labelname\":\"Supplier\",\"value\":\"4\",\"valueid\":\"\",\"type\":17,\"optionid\":\"4\",\"optionvalue\":[{\"id\":4,\"optionid\":4,\"optionname\":\"My Blinds Company\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1780,\"labelname\":\"Measure To\",\"value\":\"Blind Size\",\"valueid\":\"4543\",\"type\":3,\"optionid\":\"1251\",\"optionvalue\":[{\"optionid\":1251,\"optionname\":\"Blind Size\",\"description\":\"\",\"optioncode\":\"BS\",\"pricegroups\":\"\",\"optionqty\":1,\"unittype\":null,\"unitcost\":1375,\"fieldoptionlinkid\":4543,\"forchildfieldoptionlinkid\":\"3_4543\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"1375.00\",\"fieldid\":4543}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1781,\"labelname\":\"Width\",\"value\":\"2500\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1782,\"labelname\":\"Drop\",\"value\":\"2200\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1779,\"labelname\":\"Product Type\",\"value\":64,\"valueid\":\"83\",\"type\":13,\"optionid\":\"64\",\"optionvalue\":[{\"id\":83,\"fieldid\":1779,\"fieldoptionlinkid\":83,\"optionid\":64,\"mainsupplier\":\"4\",\"blindtypecode\":\"\",\"optionname\":\"Band AA\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1783,\"labelname\":\"Fabric\",\"value\":\"Alessi\",\"valueid\":\"1811\",\"type\":5,\"optionid\":\"1811\",\"optionvalue\":[{\"optionid\":1811,\"optionname\":\"Alessi\",\"optioncode\":\"ALSS\",\"optionquantity\":1,\"fieldoptionlinkid\":1811,\"forchildfieldoptionlinkid\":\"5_2_1811_1\",\"optionimage\":\"\",\"subdatacount\":1,\"description\":\"\",\"pricegroup\":\"Band AA\",\"pricegroupid\":64}],\"fabricorcolor\":1,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1792,\"labelname\":\"Color\",\"value\":\"Platinum\",\"valueid\":\"5112\",\"type\":5,\"optionid\":\"5112\",\"optionvalue\":[{\"optionid\":5112,\"optionname\":\"Platinum\",\"optioncode\":\"\",\"optionquantity\":1,\"fieldoptionlinkid\":5112,\"forchildfieldoptionlinkid\":\"5_3_5112_1\",\"minimumdiscount\":\"\",\"maximumdiscount\":\"\",\"optionimage\":\"5112_139.jpg\",\"subdatacount\":0}],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1784,\"labelname\":\"Control Type\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1788,\"labelname\":\"Control Side\",\"value\":\"Left\",\"valueid\":\"4558\",\"type\":3,\"optionid\":\"1283\",\"optionvalue\":[{\"optionid\":1283,\"optionname\":\"Left\",\"description\":\"\",\"optioncode\":\"LRO\",\"pricegroups\":\"AQBand-A\",\"optionqty\":1,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":4558,\"forchildfieldoptionlinkid\":\"3_4558\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1789,\"labelname\":\"Tube Size\",\"value\":\"38mm Tube\",\"valueid\":\"4561\",\"type\":3,\"optionid\":\"1286\",\"optionvalue\":[{\"optionid\":1286,\"optionname\":\"38mm Tube\",\"description\":\"\",\"optioncode\":\"38T\",\"pricegroups\":\"Band AA\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":20,\"pricingtype\":\"\",\"fieldoptionlinkid\":4561,\"forchildfieldoptionlinkid\":\"3_4561\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"20.00\",\"fieldid\":4561}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1790,\"labelname\":\"Extras\",\"value\":\"Bottom Bar\",\"valueid\":\"5850\",\"type\":3,\"optionid\":\"1607\",\"optionvalue\":[{\"optionid\":1607,\"optionname\":\"Bottom Bar\",\"description\":\"\",\"optioncode\":\"BB\",\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":20,\"pricingtype\":\"\",\"fieldoptionlinkid\":5850,\"forchildfieldoptionlinkid\":\"3_5850\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"60.00\",\"fieldid\":5850}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]",
"oi_description": "Unit Type: mm, Quantity: 1, Location: hall, Supplier: My Blinds Company, Measure To: Blind Size, Width: 2500, Drop: 2200, Product Type: Band AA, Fabric: Alessi, Color: Platinum, Control Side: Left, Tube Size: 38mm Tube, Extras: Bottom Bar",
"oi_reportdescription": "##Quantity: 1##,##Location: hall##,##Supplier: My Blinds Company##,##Measure To: Blind Size##,##Width: 2500 mm##,##Drop: 2200 mm##,##Product Type: Band AA##,##Fabric: Alessi##,##Color: Platinum##,##Control Side: Left##,##Tube Size: 38mm Tube##,##Extras: Bottom Bar##",
"oi_reporttitles": "##Quantity:##Location:##Supplier:##Measure To:##Width:##Drop:##Product Type:##Fabric:##Color:##Control Side:##Tube Size:##Extras:",
"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": "55.000",
"oi_netprice": "55.000",
"oi_pricesfromoperations": null,
"oi_vatprice": "11.000",
"oi_vatvalue": "20.000",
"oi_vatselected": 1,
"oi_vattype": 1,
"oi_vatonoff": 1,
"oi_grossprice": "66.000",
"oi_overrideprice": "0.000",
"oi_overridetype": 1,
"oi_overridevalue": null,
"oi_overridenetprice": "0.000",
"oi_overridevatprice": "0.000",
"oi_overridegrossprice": "0.000",
"oi_ready": 0,
"oi_onhold": 0,
"oi_platformcreatedfrom": "web",
"oi_copiedfrom": 0,
"oi_isonlineorder": 0,
"oi_endcustomervatprice": null,
"oi_endcustomeroverridetype": 1,
"oi_endcustomeroverridevalue": null,
"oi_endcustomeroverridenetprice": "0.000",
"oi_endcustomeroverridevatprice": "0.000",
"oi_endcustomeroverridegrossprice": "0.000",
"oi_sage_flag": 0,
"oi_status": 0,
"oi_jsondataid": "[1777, 1776, 4706, 1778, 1780, 1781, 1782, 1779, 1783, 1792, 1784, 1788, 1789, 1790]",
"oi_deviceplatform": 1,
"oi_custompricefields": "",
"oi_editransfer": 0,
"oi_apisup_orderid": 0,
"oi_commissionprice": "0.000",
"oi_commissionvatprice": "0.000",
"id": "1274",
"oi_productiondate": 1742439990,
"oi_createdat": 1742440037,
"oi_updatedat": null,
"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": [
{
"jmq_id": 333,
"jmq_jobid": 321,
"jmq_quotationname": "Q1",
"jmq_isdefault": 0,
"jmq_isaccepted": 1,
"jmq_isdeclined": 0,
"jmq_acceptanceplatform": 0,
"jmq_ismigrated": 0,
"jmq_listprice": "55.00",
"jmq_netprice": "55.00",
"jmq_vat": "11.00",
"jmq_isvaton": 1,
"jmq_deliverycost": "0.00",
"jmq_deliverycosttypeid": 5,
"jmq_overridetypeid": 1,
"jmq_orderformprice": "0.00",
"jmq_editpricebyid": null,
"jmq_isroundon": 0,
"jmq_grossprice": "66.00",
"jmq_grossprofit": "0.00",
"jmq_costprice": "55.00",
"jmq_overrideprice": null,
"jmq_overridenetprice": null,
"jmq_overridevatprice": null,
"jmq_overridegrossprice": null,
"jmq_amountoutstanding": "66.00",
"jmq_totpaid": "0.00",
"jmq_creditlimit": "0.00",
"jmq_creditbalance": "0.00",
"jmq_overdue": "0.00",
"jmq_userdefinedarray": null,
"jmq_deliverycostid": 0,
"jmq_iscostpriceon": 0,
"jmq_custompricefields": "",
"jmq_isonlineorder": 0,
"jmq_isonlineordersubmitted": 0,
"jmq_endcustomervatprice": null,
"jmq_endcustomeroverridetype": 0,
"jmq_endcustomeroverridevalue": null,
"jmq_endcustomeroverridenetprice": "0.00",
"jmq_endcustomeroverridevatprice": "0.00",
"jmq_endcustomeroverridegrossprice": "0.00",
"jmq_endcustomerdeliverycost": null,
"jmq_endcustomerdeliverycostinclvat": 0,
"jmq_endcustomerfittingcost": null,
"jmq_endcustomerfittingcostinclvat": 0,
"jmq_onlinedeliveryaddreddtype": 0,
"jmq_onlinedeliveryaddreddid": null,
"jmq_commission": "[]",
"jmq_commissionprice": "0.00",
"jmq_commissionsetting": 0,
"jmq_commissionaddedvalue": "0.00",
"jmq_deliveryvatperc": "20.000",
"jmq_cdeliveryvatperc": "20.000",
"id": "333",
"jmq_duedate": 1742428800,
"jmq_sceduleddate": null,
"jmq_createdat": "1742439984.000000",
"jmq_updatedat": "1742440656.000000",
"jmq_createdby": 2,
"jmq_updatedby": 2
}
],
"updated": [
{
"jmq_id": 333,
"jmq_jobid": 321,
"jmq_quotationname": "Q1",
"jmq_isdefault": 0,
"jmq_isaccepted": 1,
"jmq_isdeclined": 0,
"jmq_acceptanceplatform": 0,
"jmq_ismigrated": 0,
"jmq_listprice": "55.00",
"jmq_netprice": "55.00",
"jmq_vat": "11.00",
"jmq_isvaton": 1,
"jmq_deliverycost": "0.00",
"jmq_deliverycosttypeid": 5,
"jmq_overridetypeid": 1,
"jmq_orderformprice": "0.00",
"jmq_editpricebyid": null,
"jmq_isroundon": 0,
"jmq_grossprice": "66.00",
"jmq_grossprofit": "0.00",
"jmq_costprice": "55.00",
"jmq_overrideprice": null,
"jmq_overridenetprice": null,
"jmq_overridevatprice": null,
"jmq_overridegrossprice": null,
"jmq_amountoutstanding": "66.00",
"jmq_totpaid": "0.00",
"jmq_creditlimit": "0.00",
"jmq_creditbalance": "0.00",
"jmq_overdue": "0.00",
"jmq_userdefinedarray": null,
"jmq_deliverycostid": 0,
"jmq_iscostpriceon": 0,
"jmq_custompricefields": "",
"jmq_isonlineorder": 0,
"jmq_isonlineordersubmitted": 0,
"jmq_endcustomervatprice": null,
"jmq_endcustomeroverridetype": 0,
"jmq_endcustomeroverridevalue": null,
"jmq_endcustomeroverridenetprice": "0.00",
"jmq_endcustomeroverridevatprice": "0.00",
"jmq_endcustomeroverridegrossprice": "0.00",
"jmq_endcustomerdeliverycost": null,
"jmq_endcustomerdeliverycostinclvat": 0,
"jmq_endcustomerfittingcost": null,
"jmq_endcustomerfittingcostinclvat": 0,
"jmq_onlinedeliveryaddreddtype": 0,
"jmq_onlinedeliveryaddreddid": null,
"jmq_commission": "[]",
"jmq_commissionprice": "0.00",
"jmq_commissionsetting": 0,
"jmq_commissionaddedvalue": "0.00",
"jmq_deliveryvatperc": "20.000",
"jmq_cdeliveryvatperc": "20.000",
"id": "333",
"jmq_duedate": 1742428800,
"jmq_sceduleddate": null,
"jmq_createdat": "1742439984.000000",
"jmq_updatedat": "1742440656.000000",
"jmq_createdby": 2,
"jmq_updatedby": 2
}
],
"deleted": []
},
"bm_jobstatus_tracks": {
"created": [
{
"jst_id": 404,
"jst_jobid": 320,
"jst_job_current_status": 3,
"id": "404",
"jst_createdat": "1742395917.444121"
},
{
"jst_id": 405,
"jst_jobid": 321,
"jst_job_current_status": 3,
"id": "405",
"jst_createdat": "1742440656.479171"
}
],
"updated": [],
"deleted": []
},
"bm_customindividuallogs": {
"created": [
{
"cl_id": 14683,
"cl_logname": "default",
"cl_type": null,
"cl_modulename": "All Jobs",
"cl_message": "Quotation Report report generated by Kat All Jobs",
"cl_event": "created",
"cl_subjectid": 868,
"cl_subjecttype": "App\\Models\\Reports\\bm_reportactivitylog",
"cl_parentid": 2147483647,
"cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails",
"cl_causerid": 2,
"cl_changedfrom": "null",
"cl_changedto": "{\"Category: \":\"Quotation\"}",
"cl_customproperties": "{\"attributes\":{\"ral_id\":868,\"ral_jobid\":2147483647,\"ral_reportid\":14,\"ral_categoryid\":1,\"ral_description\":\"Quotation Report report generated by Kat\",\"ral_attachment\":\"\",\"ral_actionid\":1,\"ral_createdat\":\"2025-03-20T03:07:38.000000Z\",\"ral_updatedat\":\"2025-03-20T03:07:38.000000Z\",\"ral_createdby\":2,\"ral_updatedby\":null}}",
"cl_attachment": null,
"cl_deviceplatform": "android",
"cl_deviceipaddress": "",
"cl_devicenameversion": "",
"cl_devicelocation": "",
"cl_causertype": "App\\Models\\BMUsers",
"id": "14683",
"cl_createdat": "1742440058.000000",
"cl_updatedat": null
},
{
"cl_id": 14684,
"cl_logname": "default",
"cl_type": null,
"cl_modulename": "Job",
"cl_message": "new job has been created in Job",
"cl_event": "created",
"cl_subjectid": 321,
"cl_subjecttype": "App\\Models\\Job\\bm_jobdetails",
"cl_parentid": 321,
"cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails",
"cl_causerid": 2,
"cl_changedfrom": "null",
"cl_changedto": "{\"Organisation Name\":\"The Blind Man\",\"\":\"USA\",\"Account Type\":\"Domestic\",\"Created By\":\"Kat\",\"Last Name\":\"Quote 23\",\"Address1\":\"Quote 23\",\"Town \\\/ City\":\"Quote 23\",\"Country\":\"USA\",\"Assigned to\":2,\"jd_additionalcontacts\":\"176\",\"Production Due Date\":\"2025-03-20\",\"Job Ref No\":\"ON1670\",\"Job Status\":\"Quote\",\"Order Status\":\"Order confirmed\",\"Net Price\":\"55.00\",\"VAT Price\":\"11.00\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"Less Than\",\"Gross Price Amount\":\"66.00\",\"Total CostPrice\":\"55.00\",\"Amount Outstanding\":\"66.00\",\"jd_isonlineorder\":1,\"jd_quickquote\":23,\"Delivery Vat Percentage\":\"20.000\",\"jd_cdeliveryvatperc\":\"20.000\",\"jd_commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}",
"cl_customproperties": "{\"attributes\":{\"jd_id\":321,\"jd_customerid\":115,\"jd_contactid\":176,\"jd_additionalcontacts\":\"176\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"ON1670\\\",\\\"35\\\":\\\"QUOT0020\\\",\\\"36\\\":3,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":\\\"\\\",\\\"40\\\":3,\\\"41\\\":2,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"\\\",\\\"46\\\":\\\"Quote 23\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"Quote 23\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"Quote 23\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":35,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":2,\\\"558\\\":\\\"\\\",\\\"603\\\":\\\"\\\",\\\"612\\\":\\\"\\\",\\\"613\\\":\\\"\\\",\\\"614\\\":1,\\\"615\\\":\\\"\\\",\\\"countryText\\\":\\\"USA\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-03-20\",\"jd_orderdate\":null,\"jd_duedate\":\"2025-03-20\",\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":null,\"jd_jobref\":\"ON1670\",\"jd_jobstatus\":3,\"jd_contactaddid\":0,\"jd_orderstatus\":3,\"jd_accref\":\"QUOT0020\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"55.00\",\"jd_netprice\":\"55.00\",\"jd_vat\":\"11.00\",\"jd_isvaton\":1,\"jd_deliverycost\":\"0.00\",\"jd_deliverycosttypeid\":5,\"jd_overridetypeid\":1,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":null,\"jd_isroundon\":0,\"jd_grossprice\":\"66.00\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"55.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"66.00\",\"jd_totpaid\":\"0.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":null,\"jd_deliverycostid\":0,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":0,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":0,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":0,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":0,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":2,\"jd_createdat\":\"2025-03-20T03:06:24.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-03-20T03:17:36.000000Z\",\"jd_deviceplatform\":0,\"jd_fromjobref\":\"\",\"jd_fromdbname\":null,\"jd_importorder\":0,\"jd_quickquote\":23,\"jd_myob_flag\":0,\"jd_myobinvoiceid\":\"\",\"jd_qboflag\":0,\"jd_qboinvoiceid\":0,\"jd_qbodisplayname\":\"\",\"jd_deliveryvatperc\":\"20.000\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"20.000\",\"jd_commission\":\"[]\",\"jd_commissionprice\":\"0.00\",\"jd_commissionsetting\":0,\"jd_commissionaddedvalue\":\"0.00\",\"jd_onlineprefixseq\":null,\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":0,\"jd_rework_count\":0}}",
"cl_attachment": null,
"cl_deviceplatform": "android",
"cl_deviceipaddress": "",
"cl_devicenameversion": "",
"cl_devicelocation": "",
"cl_causertype": "App\\Models\\BMUsers",
"id": "14684",
"cl_createdat": "1742440656.000000",
"cl_updatedat": null
},
{
"cl_id": 14685,
"cl_logname": "default",
"cl_type": null,
"cl_modulename": "Quotation",
"cl_message": "Q1 has been generated in ON1670",
"cl_event": "created",
"cl_subjectid": 333,
"cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel",
"cl_parentid": 321,
"cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails",
"cl_causerid": 2,
"cl_changedfrom": "null",
"cl_changedto": "{\"jmq_id\":333,\"jmq_jobid\":321,\"Quotation Name\":\"Q1\",\"jmq_isdefault\":0,\"Quotation\":\"Accepted\",\"jmq_isdeclined\":0,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"Production Due Date\":\"0000-00-00\",\"jmq_listprice\":\"55.00\",\"Net Price\":\"55.00\",\"VAT Price\":\"11.00\",\"VAT\":1,\"jmq_deliverycost\":\"0.00\",\"Delivery Cost\":5,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"66.00\",\"Gross Profit\":\"0.00\",\"Total CostPrice\":\"55.00\",\"Amount Outstanding\":\"66.00\",\"Total Paid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_deliverycostid\":0,\"Total Cost Price\":0,\"jmq_isonlineorder\":0,\"Is Online Order Submitted\":0,\"End Customer Override Type\":0,\"End Customer Override Net Price\":\"0.00\",\"End Customer Override Vat Price\":\"0.00\",\"End Customer Override Gross Price\":\"0.00\",\"End Customer Delivery Cost Include Vat\":0,\"End Customer Fitting Cost Include Vat\":0,\"Online Delivery Addreddtype\":0,\"jmq_commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"Delivery Vat Percentage\":\"20.000\",\"jmq_cdeliveryvatperc\":\"20.000\",\"jmq_grossprofit_percentage\":\"0.00\",\"jmq_ready\":0}",
"cl_customproperties": "{\"attributes\":{\"jmq_id\":333,\"jmq_jobid\":321,\"jmq_quotationname\":\"Q1\",\"jmq_isdefault\":0,\"jmq_isaccepted\":1,\"jmq_isdeclined\":0,\"jmq_esignflag\":null,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"jmq_duedate\":\"0000-00-00\",\"jmq_sceduleddate\":\"0000-00-00\",\"jmq_listprice\":\"55.00\",\"jmq_netprice\":\"55.00\",\"jmq_vat\":\"11.00\",\"jmq_isvaton\":1,\"jmq_deliverycost\":\"0.00\",\"jmq_deliverycosttypeid\":5,\"jmq_overridetypeid\":1,\"jmq_orderformprice\":\"0.00\",\"jmq_editpricebyid\":null,\"jmq_isroundon\":0,\"jmq_grossprice\":\"66.00\",\"jmq_grossprofit\":\"0.00\",\"jmq_costprice\":\"55.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"66.00\",\"jmq_totpaid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_userdefinedarray\":null,\"jmq_deliverycostid\":0,\"jmq_iscostpriceon\":0,\"jmq_custompricefields\":\"\",\"jmq_isonlineorder\":0,\"jmq_isonlineordersubmitted\":0,\"jmq_endcustomervatprice\":null,\"jmq_endcustomeroverridetype\":0,\"jmq_endcustomeroverridevalue\":null,\"jmq_endcustomeroverridenetprice\":\"0.00\",\"jmq_endcustomeroverridevatprice\":\"0.00\",\"jmq_endcustomeroverridegrossprice\":\"0.00\",\"jmq_endcustomerdeliverycost\":null,\"jmq_endcustomerdeliverycostinclvat\":0,\"jmq_endcustomerfittingcost\":null,\"jmq_endcustomerfittingcostinclvat\":0,\"jmq_onlinedeliveryaddreddtype\":0,\"jmq_onlinedeliveryaddreddid\":null,\"jmq_commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"jmq_deliveryvatperc\":\"20.000\",\"jmq_cdeliveryvatperc\":\"20.000\",\"jmq_createdby\":2,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-03-20T03:06:24.000000Z\",\"jmq_updatedat\":null,\"jmq_grossprofit_percentage\":\"0.00\",\"jmq_ready\":0}}",
"cl_attachment": null,
"cl_deviceplatform": "android",
"cl_deviceipaddress": "",
"cl_devicenameversion": "",
"cl_devicelocation": "",
"cl_causertype": "App\\Models\\BMUsers",
"id": "14685",
"cl_createdat": "1742440656.000000",
"cl_updatedat": null
},
{
"cl_id": 14686,
"cl_logname": "default",
"cl_type": null,
"cl_modulename": "Job",
"cl_message": "Job has been updated the field jd_jobmultiquoteid",
"cl_event": "modified",
"cl_subjectid": 321,
"cl_subjecttype": "App\\Models\\Job\\bm_jobdetails",
"cl_parentid": 321,
"cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails",
"cl_causerid": 2,
"cl_changedfrom": "[]",
"cl_changedto": "{\"jd_jobmultiquoteid\":333}",
"cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":333},\"old\":{\"jd_jobmultiquoteid\":null}}",
"cl_attachment": null,
"cl_deviceplatform": "android",
"cl_deviceipaddress": "",
"cl_devicenameversion": "",
"cl_devicelocation": "",
"cl_causertype": "App\\Models\\BMUsers",
"id": "14686",
"cl_createdat": "1742440656.000000",
"cl_updatedat": null
},
{
"cl_id": 14687,
"cl_logname": "default",
"cl_type": null,
"cl_modulename": "Line Item",
"cl_message": "Q1 - new item has been created in Line Item for the product of Roller Blinds",
"cl_event": "created",
"cl_subjectid": 1274,
"cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem",
"cl_parentid": 321,
"cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails",
"cl_causerid": 2,
"cl_changedfrom": "null",
"cl_changedto": "{\"Unit Type\":\" mm\",\" Quantity\":\" 1\",\" Location\":\" hall\",\" Supplier\":\" My Blinds Company\",\" Measure To\":\" Blind Size\",\" Width\":\" 2500\",\" Drop\":\" 2200\",\" Product Type\":\" Band AA\",\" Fabric\":\" Alessi\",\" Color\":\" Platinum\",\" Control Side\":\" Left\",\" Tube Size\":\" 38mm Tube\",\" Extras\":\" Bottom Bar\"}",
"cl_customproperties": "{\"attributes\":{\"oi_id\":1274,\"oi_jobid\":321,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":333,\"oi_credit_id\":0,\"oi_productid\":14,\"oi_recipeid\":16,\"oi_ruleid\":0,\"oi_qty\":1,\"oi_seq\":0,\"oi_customseq\":0,\"oi_productcustomseq\":0,\"oi_jsondata\":\"[{\\\"id\\\":1777,\\\"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\\\":1776,\\\"labelname\\\":\\\"Quantity\\\",\\\"value\\\":1,\\\"valueid\\\":\\\"\\\",\\\"type\\\":14,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":4706,\\\"labelname\\\":\\\"Location\\\",\\\"value\\\":\\\"hall\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":29,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":1778,\\\"labelname\\\":\\\"Supplier\\\",\\\"value\\\":\\\"4\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":17,\\\"optionid\\\":\\\"4\\\",\\\"optionvalue\\\":[{\\\"id\\\":4,\\\"optionid\\\":4,\\\"optionname\\\":\\\"My Blinds Company\\\",\\\"deleted\\\":0,\\\"optionquantity\\\":1}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":1780,\\\"labelname\\\":\\\"Measure To\\\",\\\"value\\\":\\\"Blind Size\\\",\\\"valueid\\\":\\\"4543\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"1251\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":1251,\\\"optionname\\\":\\\"Blind Size\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"BS\\\",\\\"pricegroups\\\":\\\"\\\",\\\"optionqty\\\":1,\\\"unittype\\\":null,\\\"unitcost\\\":1375,\\\"fieldoptionlinkid\\\":4543,\\\"forchildfieldoptionlinkid\\\":\\\"3_4543\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"1375.00\\\",\\\"fieldid\\\":4543}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":1781,\\\"labelname\\\":\\\"Width\\\",\\\"value\\\":\\\"2500\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":11,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":1782,\\\"labelname\\\":\\\"Drop\\\",\\\"value\\\":\\\"2200\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":12,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":1779,\\\"labelname\\\":\\\"Product Type\\\",\\\"value\\\":64,\\\"valueid\\\":\\\"83\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"64\\\",\\\"optionvalue\\\":[{\\\"id\\\":83,\\\"fieldid\\\":1779,\\\"fieldoptionlinkid\\\":83,\\\"optionid\\\":64,\\\"mainsupplier\\\":\\\"4\\\",\\\"blindtypecode\\\":\\\"\\\",\\\"optionname\\\":\\\"Band AA\\\",\\\"optionquantity\\\":1,\\\"subcount\\\":0,\\\"status\\\":0,\\\"subdatacount\\\":0}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":1783,\\\"labelname\\\":\\\"Fabric\\\",\\\"value\\\":\\\"Alessi\\\",\\\"valueid\\\":\\\"1811\\\",\\\"type\\\":5,\\\"optionid\\\":\\\"1811\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":1811,\\\"optionname\\\":\\\"Alessi\\\",\\\"optioncode\\\":\\\"ALSS\\\",\\\"optionquantity\\\":1,\\\"fieldoptionlinkid\\\":1811,\\\"forchildfieldoptionlinkid\\\":\\\"5_2_1811_1\\\",\\\"optionimage\\\":\\\"\\\",\\\"subdatacount\\\":1,\\\"description\\\":\\\"\\\",\\\"pricegroup\\\":\\\"Band AA\\\",\\\"pricegroupid\\\":64}],\\\"fabricorcolor\\\":1,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":1792,\\\"labelname\\\":\\\"Color\\\",\\\"value\\\":\\\"Platinum\\\",\\\"valueid\\\":\\\"5112\\\",\\\"type\\\":5,\\\"optionid\\\":\\\"5112\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":5112,\\\"optionname\\\":\\\"Platinum\\\",\\\"optioncode\\\":\\\"\\\",\\\"optionquantity\\\":1,\\\"fieldoptionlinkid\\\":5112,\\\"forchildfieldoptionlinkid\\\":\\\"5_3_5112_1\\\",\\\"minimumdiscount\\\":\\\"\\\",\\\"maximumdiscount\\\":\\\"\\\",\\\"optionimage\\\":\\\"5112_139.jpg\\\",\\\"subdatacount\\\":0}],\\\"fabricorcolor\\\":2,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":1784,\\\"labelname\\\":\\\"Control Type\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":1788,\\\"labelname\\\":\\\"Control Side\\\",\\\"value\\\":\\\"Left\\\",\\\"valueid\\\":\\\"4558\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"1283\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":1283,\\\"optionname\\\":\\\"Left\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"LRO\\\",\\\"pricegroups\\\":\\\"AQBand-A\\\",\\\"optionqty\\\":1,\\\"unittype\\\":null,\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":4558,\\\"forchildfieldoptionlinkid\\\":\\\"3_4558\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":1789,\\\"labelname\\\":\\\"Tube Size\\\",\\\"value\\\":\\\"38mm Tube\\\",\\\"valueid\\\":\\\"4561\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"1286\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":1286,\\\"optionname\\\":\\\"38mm Tube\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"38T\\\",\\\"pricegroups\\\":\\\"Band AA\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":null,\\\"unitcost\\\":20,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":4561,\\\"forchildfieldoptionlinkid\\\":\\\"3_4561\\\",\\\"hasstock\\\":1,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"20.00\\\",\\\"fieldid\\\":4561}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":1790,\\\"labelname\\\":\\\"Extras\\\",\\\"value\\\":\\\"Bottom Bar\\\",\\\"valueid\\\":\\\"5850\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"1607\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":1607,\\\"optionname\\\":\\\"Bottom Bar\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"BB\\\",\\\"pricegroups\\\":\\\"\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":null,\\\"unitcost\\\":20,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":5850,\\\"forchildfieldoptionlinkid\\\":\\\"3_5850\\\",\\\"hasstock\\\":1,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"60.00\\\",\\\"fieldid\\\":5850}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0}]\",\"oi_description\":\"Unit Type: mm, Quantity: 1, Location: hall, Supplier: My Blinds Company, Measure To: Blind Size, Width: 2500, Drop: 2200, Product Type: Band AA, Fabric: Alessi, Color: Platinum, Control Side: Left, Tube Size: 38mm Tube, Extras: Bottom Bar\",\"oi_onlinedescription\":null,\"oi_imagepath\":null,\"oi_reportdescription\":\"##Quantity: 1##,##Location: hall##,##Supplier: My Blinds Company##,##Measure To: Blind Size##,##Width: 2500 mm##,##Drop: 2200 mm##,##Product Type: Band AA##,##Fabric: Alessi##,##Color: Platinum##,##Control Side: Left##,##Tube Size: 38mm Tube##,##Extras: Bottom Bar##\",\"oi_onlinereportdescription\":null,\"oi_reporttitles\":\"##Quantity:##Location:##Supplier:##Measure To:##Width:##Drop:##Product Type:##Fabric:##Color:##Control Side:##Tube Size:##Extras:\",\"oi_onlinereporttitles\":null,\"oi_productionformulajsondata\":\"[]\",\"oi_productiondate\":\"2025-03-20 03:06:30\",\"oi_operationstatus\":null,\"oi_scanstatus\":\"\",\"oi_operationworkroom_data\":\"[]\",\"oi_operationcalender_data\":\"[]\",\"oi_operation_calculations\":\"[]\",\"oi_pricecomesfrom_calculations\":\"{}\",\"oi_pricetablepriceevenbom\":\"{}\",\"oi_productionstatus\":null,\"oi_costoverride\":0,\"oi_costprice\":\"55.000\",\"oi_netprice\":\"55.000\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"11.000\",\"oi_vatvalue\":\"20.000\",\"oi_vatselected\":1,\"oi_vattype\":1,\"oi_vatonoff\":1,\"oi_grossprice\":\"66.000\",\"oi_overrideprice\":\"0.000\",\"oi_overridetype\":1,\"oi_overridevalue\":null,\"oi_overridenetprice\":\"0.000\",\"oi_overridevatprice\":\"0.000\",\"oi_overridegrossprice\":\"0.000\",\"oi_ready\":0,\"oi_onhold\":0,\"oi_platformcreatedfrom\":\"web\",\"oi_platformlastupdatedfrom\":\"web\",\"oi_copiedfrom\":0,\"oi_isonlineorder\":0,\"oi_endcustomervatprice\":null,\"oi_endcustomeroverridetype\":1,\"oi_endcustomeroverridevalue\":null,\"oi_endcustomeroverridenetprice\":\"0.000\",\"oi_endcustomeroverridevatprice\":\"0.000\",\"oi_endcustomeroverridegrossprice\":\"0.000\",\"oi_sage_flag\":0,\"oi_status\":0,\"oi_createdby\":2,\"oi_createdat\":\"2025-03-20T03:07:17.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":null,\"oi_jsondataid\":\"[1777, 1776, 4706, 1778, 1780, 1781, 1782, 1779, 1783, 1792, 1784, 1788, 1789, 1790]\",\"oi_deviceplatform\":1,\"oi_custompricefields\":\"\",\"oi_editransfer\":0,\"oi_apisup_orderid\":0,\"oi_commissionprice\":\"0.000\",\"oi_commissionvatprice\":\"0.000\",\"oi_jsondatabackup\":\"\",\"oi_stockdeduct\":0,\"oi_deductedstockdetails\":null}}",
"cl_attachment": null,
"cl_deviceplatform": "android",
"cl_deviceipaddress": "",
"cl_devicenameversion": "",
"cl_devicelocation": "",
"cl_causertype": "App\\Models\\BMUsers",
"id": "14687",
"cl_createdat": "1742440656.000000",
"cl_updatedat": null
}
],
"updated": [],
"deleted": []
},
"bm_productInfo": {
"created": [],
"updated": [],
"deleted": []
},
"bm_fields": {
"created": [],
"updated": [],
"deleted": []
},
"bm_fieldOptionLink": {
"created": [],
"updated": [],
"deleted": []
},
"bm_option": {
"created": [],
"updated": [],
"deleted": []
},
"bm_optionproduct": {
"created": [],
"updated": [],
"deleted": []
},
"bm_linkedfieldswithproduct": {
"created": [],
"updated": [],
"deleted": []
},
"bm_productionstatus": {
"created": [],
"updated": [],
"deleted": []
},
"bm_productpricemap": {
"created": [],
"updated": [],
"deleted": []
},
"bm_productrecipe": {
"created": [],
"updated": [],
"deleted": []
},
"bm_productrecipemap": {
"created": [],
"updated": [],
"deleted": []
},
"bm_supproductcode": {
"created": [],
"updated": [],
"deleted": []
},
"bm_rulesetup": {
"created": [],
"updated": [],
"deleted": []
},
"bm_formulas": {
"created": [],
"updated": [],
"deleted": []
},
"bm_customercommission": {
"created": [],
"updated": [],
"deleted": []
},
"bm_productgroupdetails": {
"created": [],
"updated": [],
"deleted": []
},
"bm_productgroupmaterialmap": {
"created": [],
"updated": [],
"deleted": []
},
"bm_productpricedetails": {
"created": [],
"updated": [],
"deleted": []
},
"bm_fabriccolourmap": {
"created": [],
"updated": [],
"deleted": []
},
"bm_fabricdetails": {
"created": [],
"updated": [],
"deleted": []
},
"bm_colordetails": {
"created": [],
"updated": [],
"deleted": []
},
"bm_optiondiscount": {
"created": [],
"updated": [],
"deleted": []
},
"bm_optionpricebook": {
"created": [],
"updated": [],
"deleted": []
},
"bm_allowances": {
"created": [],
"updated": [],
"deleted": []
},
"bm_xyoptionpricedata": {
"created": [],
"updated": [],
"deleted": []
},
"bm_delivery_cost_setup": {
"created": [],
"updated": [],
"deleted": []
},
"bm_organizationdetails": {
"created": [],
"updated": [],
"deleted": []
},
"bm_applicationSetup": {
"created": [],
"updated": [],
"deleted": []
}
},
"synctodelete": {
"bm_terms": {},
"bm_Invoice": {},
"bm_notelist": {},
"bm_tasklist": {},
"bm_orderitem": {
"71742440037": 1274
},
"bm_CreditNote": {},
"bm_jobdetails": {
"41742439984": 321
},
"bm_paymentlist": {},
"bm_OverPayment": {},
"bm_appointment": {},
"bm_jobmultiquote": {
"141742439984": 333
},
"bm_InvoiceDetails": {},
"bm_job_paymentlist": {},
"bm_CreditNoteDetails": {},
"bm_customercontactinfo": {
"51742439984": 176
},
"bm_invoice_credit_note": {},
"bm_customertemplatedata": {
"31742439984": 115
}
},
"timestamp": 1742440656
}