{ "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": 12961, "jd_customerid": 5946, "jd_contactid": 7359, "jd_additionalcontacts": "7359", "jd_templateid": 1, "jd_jobmultiquoteid": 12966, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "11574", "jd_jobstatus": 6, "jd_contactaddid": 0, "jd_orderstatus": 3, "jd_accref": "ZOHO0032", "jd_invoiceno": "8422", "jd_listprice": "0.00", "jd_netprice": "30.00", "jd_vat": "6.00", "jd_isvaton": 1, "jd_deliverycost": "30.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "36.00", "jd_grossprofit": "30.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "36.00", "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": 1, "jd_updatedby": 16, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "0.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"11574\",\"35\":\"ZOHO0032\",\"36\":6,\"37\":1,\"38\":\"\",\"39\":24,\"40\":3,\"41\":1,\"44\":\"Zohooo 494\",\"45\":\"FirstnameTest 517\",\"46\":\"LastNameTest 521\",\"47\":\"7684376668\",\"48\":\"teststdt@gmail.com\",\"49\":\"TestAddress443\",\"50\":\"TestAddress443\",\"51\":\"Chennai\",\"52\":\"\",\"53\":\"600021\",\"54\":19,\"285\":1,\"286\":\"7684376687\",\"287\":\"CF108855\",\"288\":\"ARF858097\",\"289\":\"Testing Notes\",\"551\":1,\"558\":\"\",\"612\":\"\",\"614\":\"\",\"615\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "0.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "12961", "jd_createddate": 1749427200, "jd_orderdate": 1749513600, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1749465888, "jd_updatedat": 1749535982 } ], "deleted": [] }, "bm_orderitem": { "created": [ { "oi_id": 80599, "oi_jobid": 12956, "oi_jobtempid": "0", "oi_jobmultiquoteid": 12961, "oi_productid": 303, "oi_recipeid": 303, "oi_ruleid": 0, "oi_qty": 2, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":25472,\"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\":25472,\"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\":25471,\"labelname\":\"Quantity\",\"value\":\"2\",\"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\":25471,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":25473,\"labelname\":\"Supplier\",\"value\":\"527\",\"valueid\":null,\"type\":17,\"optionid\":\"527\",\"optionvalue\":[{\"id\":527,\"optionid\":527,\"optionname\":\"Supplier N981\",\"deleted\":0,\"optionquantity\":1}],\"issubfabric\":0,\"labelnamecode\":\"Supplier\",\"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\":17,\"mandatory\":0,\"fieldname\":\"Supplier\",\"fieldid\":25473,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"527\",\"optionsvalue\":[{\"id\":527,\"optionid\":527,\"optionname\":\"Supplier N981\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":25474,\"labelname\":\"Width\",\"value\":\"1000\",\"valueid\":null,\"type\":11,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Width\",\"fabricorcolor\":0,\"widthfraction\":\"0___0\",\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":11,\"mandatory\":0,\"fieldname\":\"Width\",\"fieldid\":25474,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":25475,\"labelname\":\"Drop\",\"value\":\"1000\",\"valueid\":null,\"type\":12,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Drop\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":\"0___0\",\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":12,\"mandatory\":0,\"fieldname\":\"Drop\",\"fieldid\":25475,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":25477,\"labelname\":\"Product Type\",\"value\":1580,\"valueid\":\"1915\",\"type\":13,\"optionid\":1580,\"optionvalue\":[{\"id\":1915,\"fieldid\":25477,\"fieldoptionlinkid\":1915,\"optionid\":1580,\"mainsupplier\":\"527\",\"blindtypecode\":null,\"optionname\":\"Blind Price k651\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"issubfabric\":0,\"labelnamecode\":\"Product 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\":13,\"mandatory\":0,\"fieldname\":\"Product Type\",\"fieldid\":25477,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":1580,\"optionsvalue\":[{\"id\":1915,\"fieldid\":25477,\"fieldoptionlinkid\":1915,\"optionid\":1580,\"mainsupplier\":\"527\",\"blindtypecode\":null,\"optionname\":\"Blind Price k651\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"editruleoverride\":0},{\"id\":25476,\"labelname\":\"Blind fabric\",\"value\":\"BlindFabric a295\",\"valueid\":\"16940\",\"type\":5,\"optionid\":\"16940\",\"optionvalue\":[{\"optionid\":16940,\"optionname\":\"BlindFabric a295\",\"optioncode\":\"BlindFabric r551\",\"optionquantity\":1,\"fieldoptionlinkid\":16940,\"forchildfieldoptionlinkid\":\"5_2_16940_1\",\"subdatacount\":1,\"optionimage\":null,\"description\":\"BlindFabric j254\",\"pricegroup\":\"Blind Price k651\",\"pricegroupid\":1580}],\"issubfabric\":0,\"labelnamecode\":\"Blind fabric\",\"fabricorcolor\":1,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":5,\"mandatory\":0,\"fieldname\":\"Blind fabric\",\"fieldid\":25476,\"subchild\":[{\"fieldtypeid\":5,\"fieldid\":25484,\"status\":0,\"labelnamecode\":\"Color\",\"fieldname\":\"Color\",\"field_has_sub_option\":1,\"selection\":0,\"seq\":2,\"mandatory\":0,\"fieldlevel\":2,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionsvalue\":[{\"optionid\":87521,\"optionname\":\"Blind colour Q277\",\"optioncode\":\"Blind Colour I307\",\"optionquantity\":1,\"fieldoptionlinkid\":87521,\"forchildfieldoptionlinkid\":\"5_87521\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null,\"description\":null}],\"optionsbackup\":[{\"optionid\":87521,\"optionname\":\"Blind colour Q277\",\"optioncode\":\"Blind Colour I307\",\"optionquantity\":1,\"fieldoptionlinkid\":87521,\"forchildfieldoptionlinkid\":\"5_87521\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null,\"description\":null}],\"editablecolumns\":[],\"subchild\":[],\"optionsselectedcolumns\":{\"optionid\":\"Option Id\",\"optionname\":\"Color Name\",\"optioncode\":\"Color Code\",\"description\":\"Description\"},\"hasstock\":1,\"optiondefault\":\"87521\",\"value\":\"87521\",\"fabricorcolor\":2,\"subfieldlinkid\":\"16940\",\"issubfabric\":0,\"forchildsubfieldlinkid\":\"5_2_16940_1\",\"masterparentfieldid\":25476,\"dualseq\":1,\"linktopricegroup\":0,\"fieldInformation\":null,\"multiseq\":1,\"editruleoverride\":1,\"dumydata\":[{\"optionid\":87521,\"optionname\":\"Blind colour Q277\",\"optioncode\":\"Blind Colour I307\",\"optionquantity\":1,\"fieldoptionlinkid\":87521,\"forchildfieldoptionlinkid\":\"5_87521\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null,\"description\":null}],\"blindswidth\":0}],\"fieldInformation\":null,\"optiondefault\":\"16940\",\"optionsvalue\":[{\"optionid\":16940,\"optionname\":\"BlindFabric a295\",\"optioncode\":\"BlindFabric r551\",\"optionquantity\":1,\"fieldoptionlinkid\":16940,\"forchildfieldoptionlinkid\":\"5_2_16940_1\",\"subdatacount\":1,\"optionimage\":null,\"description\":\"BlindFabric j254\",\"pricegroup\":\"Blind Price k651\",\"pricegroupid\":1580}],\"editruleoverride\":1},{\"id\":25484,\"labelname\":\"Color\",\"value\":\"Blind colour Q277\",\"valueid\":\"87521\",\"type\":5,\"optionid\":\"87521\",\"optionvalue\":[{\"optionid\":87521,\"optionname\":\"Blind colour Q277\",\"optioncode\":\"Blind Colour I307\",\"optionquantity\":1,\"fieldoptionlinkid\":87521,\"forchildfieldoptionlinkid\":\"5_87521\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null,\"description\":null}],\"issubfabric\":0,\"labelnamecode\":\"Color\",\"fabricorcolor\":2,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":2,\"fieldtypeid\":5,\"mandatory\":0,\"fieldname\":\"Color\",\"fieldid\":25484,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"87521\",\"optionsvalue\":[{\"optionid\":87521,\"optionname\":\"Blind colour Q277\",\"optioncode\":\"Blind Colour I307\",\"optionquantity\":1,\"fieldoptionlinkid\":87521,\"forchildfieldoptionlinkid\":\"5_87521\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null,\"description\":null}],\"editruleoverride\":1},{\"id\":25478,\"labelname\":\"Multilist\",\"value\":\"Multi Option Y177,Multi Option p966,Multi Option c674\",\"valueid\":\"66525,66526,66527\",\"type\":3,\"optionid\":\"44491,44492,44471\",\"optionvalue\":[{\"optionid\":44491,\"optionqty\":\"1\",\"description\":\"description040\",\"optioncode\":\"codeA723\",\"optionname\":\"Multi Option Y177\",\"pricegroups\":null,\"unittype\":\"mm\",\"unitcost\":100,\"fieldoptionlinkid\":66525,\"forchildfieldoptionlinkid\":\"3_66525\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"100.00\",\"costprice\":100,\"costwithdiscount\":100,\"customersellingprice\":100,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":100,\"sellingpriceType\":1},{\"optionid\":44492,\"optionqty\":\"1\",\"description\":\"descriptionT039\",\"optioncode\":\"codey869\",\"optionname\":\"Multi Option p966\",\"pricegroups\":null,\"unittype\":\"mm\",\"unitcost\":100,\"fieldoptionlinkid\":66526,\"forchildfieldoptionlinkid\":\"3_66526\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"100.00\",\"costprice\":100,\"costwithdiscount\":100,\"customersellingprice\":100,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":100,\"sellingpriceType\":1},{\"optionid\":44471,\"optionqty\":\"1\",\"description\":\"description040\",\"optioncode\":\"codeM313\",\"optionname\":\"Multi Option c674\",\"pricegroups\":null,\"unittype\":\"mm\",\"unitcost\":100,\"fieldoptionlinkid\":66527,\"forchildfieldoptionlinkid\":\"3_66527\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"100.00\",\"costprice\":100,\"costwithdiscount\":100,\"customersellingprice\":100,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":100,\"sellingpriceType\":1}],\"issubfabric\":0,\"labelnamecode\":\"Multilist\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1,1,1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Multilist\",\"fieldid\":25478,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"44491,44492,44471\",\"optionsvalue\":[{\"optionid\":44491,\"optionqty\":\"1\",\"description\":\"description040\",\"optioncode\":\"codeA723\",\"optionname\":\"Multi Option Y177\",\"pricegroups\":null,\"unittype\":\"mm\",\"unitcost\":100,\"fieldoptionlinkid\":66525,\"forchildfieldoptionlinkid\":\"3_66525\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"100.00\",\"costprice\":100,\"costwithdiscount\":100,\"customersellingprice\":100,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":100,\"sellingpriceType\":1},{\"optionid\":44492,\"optionqty\":\"1\",\"description\":\"descriptionT039\",\"optioncode\":\"codey869\",\"optionname\":\"Multi Option p966\",\"pricegroups\":null,\"unittype\":\"mm\",\"unitcost\":100,\"fieldoptionlinkid\":66526,\"forchildfieldoptionlinkid\":\"3_66526\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"100.00\",\"costprice\":100,\"costwithdiscount\":100,\"customersellingprice\":100,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":100,\"sellingpriceType\":1},{\"optionid\":44471,\"optionqty\":\"1\",\"description\":\"description040\",\"optioncode\":\"codeM313\",\"optionname\":\"Multi Option c674\",\"pricegroups\":null,\"unittype\":\"mm\",\"unitcost\":100,\"fieldoptionlinkid\":66527,\"forchildfieldoptionlinkid\":\"3_66527\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"100.00\",\"costprice\":100,\"costwithdiscount\":100,\"customersellingprice\":100,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":100,\"sellingpriceType\":1}],\"editruleoverride\":1},{\"id\":25479,\"labelname\":\"Singlelist\",\"value\":\"Multi Option a989\",\"valueid\":\"66529\",\"type\":3,\"optionid\":\"44494\",\"optionvalue\":[{\"optionid\":44494,\"optionqty\":\"1\",\"description\":\"descriptionT039\",\"optioncode\":\"codeU801\",\"optionname\":\"Multi Option a989\",\"pricegroups\":null,\"unittype\":\"mm\",\"unitcost\":100,\"fieldoptionlinkid\":66529,\"forchildfieldoptionlinkid\":\"3_66529\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"100.00\",\"costprice\":100,\"costwithdiscount\":100,\"customersellingprice\":100,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":100,\"sellingpriceType\":1}],\"issubfabric\":0,\"labelnamecode\":\"Singlelist\",\"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\":0,\"fieldname\":\"Singlelist\",\"fieldid\":25479,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"44494\",\"optionsvalue\":[{\"optionid\":44494,\"optionqty\":\"1\",\"description\":\"descriptionT039\",\"optioncode\":\"codeU801\",\"optionname\":\"Multi Option a989\",\"pricegroups\":null,\"unittype\":\"mm\",\"unitcost\":100,\"fieldoptionlinkid\":66529,\"forchildfieldoptionlinkid\":\"3_66529\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"100.00\",\"costprice\":100,\"costwithdiscount\":100,\"customersellingprice\":100,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":100,\"sellingpriceType\":1}],\"editruleoverride\":1},{\"id\":25480,\"labelname\":\"Text Field\",\"value\":\"Testing text\",\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Text Field\",\"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\":\"Text Field\",\"fieldid\":25480,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":25481,\"labelname\":\"Location List\",\"value\":\"Blind Location q637\",\"valueid\":\"66536\",\"type\":4,\"optionid\":\"44495\",\"optionvalue\":[{\"optionid\":44495,\"fieldoptionlinkid\":66536,\"id\":66536,\"subcount\":0,\"hasprice\":0,\"locationid\":432,\"optionname\":\"Blind Location q637\"}],\"issubfabric\":0,\"labelnamecode\":\"Location List\",\"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\":4,\"mandatory\":0,\"fieldname\":\"Location List\",\"fieldid\":25481,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"44495\",\"optionsvalue\":[{\"optionid\":44495,\"fieldoptionlinkid\":66536,\"id\":66536,\"subcount\":0,\"hasprice\":0,\"locationid\":432,\"optionname\":\"Blind Location q637\"}],\"editruleoverride\":1},{\"id\":25482,\"labelname\":\"Numeric Field\",\"value\":\"12233\",\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Numeric Field\",\"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\":6,\"mandatory\":0,\"fieldname\":\"Numeric Field\",\"fieldid\":25482,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1}]", "oi_description": "Supplier: Supplier N981, Width: 1000, Drop: 1000, Product Type: Blind Price k651, Blind fabric: BlindFabric a295, Color: Blind colour Q277, Multilist: Multi Option Y177,Multi Option p966,Multi Option c674, Singlelist: Multi Option a989, Text Field: Testing text, Location List: Blind Location q637, Numeric Field: 12233", "oi_reportdescription": "##Quantity: 2##,##Supplier: Supplier N981##,##Width: 1000 mm##,##Drop: 1000 mm##,##Product Type: Blind Price k651##,##Blind fabric: BlindFabric a295##,##Color: Blind colour Q277##,##Multilist: Multi Option Y177,Multi Option p966,Multi Option c674##,##Singlelist: Multi Option a989##,##Text Field: Testing text##,##Location List: Blind Location q637##,##Numeric Field: 12233##", "oi_reporttitles": "##Quantity:<\/br>##Supplier:<\/br>##Width:<\/br>##Drop:<\/br>##Product Type:<\/br>##Blind fabric:<\/br>##Color:<\/br>##Multilist:<\/br>##Singlelist:<\/br>##Text Field:<\/br>##Location List:<\/br>##Numeric Field:", "oi_productionformulajsondata": "[]", "oi_operationstatus": "101", "oi_scanstatus": "101", "oi_operationworkroom_data": "[{\"link_id\":101,\"process_id\":101,\"product_id\":303,\"phc_id\":101,\"pd_id\":101,\"name\":\"Process341\",\"phc_linkstations\":0,\"quantity\":2,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"100.00\",\"phc_contractsellingprice\":\"100.00\",\"phc_tradesellingprice\":\"100.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"100.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"200.00\",\"Hour\\\/mins\":\"20 mins\",\"phc_processcostid\":1,\"markupprice\":\"200.00\",\"price\":\"0.00\"}]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"200.00\",\"cost_with_discount\":\"200.00\",\"cost_with_markup\":\"200.00\",\"gross_price\":\"240.00\",\"vat_price\":\"40.00\"}", "oi_pricecomesfrom_calculations": "[]", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "200.000", "oi_netprice": "1000.000", "oi_pricesfromoperations": null, "oi_vatprice": "200.000", "oi_vatvalue": "20.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "1200.000", "oi_overrideprice": "0.000", "oi_overridetype": 2, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "1000.000", "oi_endcustomeroverridevatprice": "200.000", "oi_endcustomeroverridegrossprice": "1200.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[25472, 25471, 25473, 25474, 25475, 25477, 25476, 25484, 25478, 25479, 25480, 25481, 25482]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "80599", "oi_productiondate": 1749427200, "oi_createdat": 1749482813, "oi_updatedat": 1749463116, "oi_createdby": 1, "oi_updatedby": 1 } ], "updated": [], "deleted": [] }, "bm_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_notelist": { "created": [ { "nl_id": 485763, "nl_ordertempid": 0, "nl_orderid": 12961, "nl_notescategory": 1, "nl_type": 4, "nl_platform": 2, "nl_desc": "Invoice Created (201749535955)", "nl_manualNotes": null, "nl_createdby": "16", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 0, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "485763", "nl_endddate": 1749513600, "nl_starttime": 1749535955, "created_at": 1749535955, "updated_at": 1749535981, "created_by": 16, "updated_by": null }, { "nl_id": 485764, "nl_ordertempid": 0, "nl_orderid": 12961, "nl_notescategory": 1, "nl_type": 4, "nl_platform": 2, "nl_desc": "Invoice Deleted (\"201749535955\")", "nl_manualNotes": null, "nl_createdby": "16", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 0, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "485764", "nl_endddate": 1749513600, "nl_starttime": 1749535970, "created_at": 1749535970, "updated_at": 1749535981, "created_by": 16, "updated_by": null }, { "nl_id": 485765, "nl_ordertempid": 0, "nl_orderid": 12961, "nl_notescategory": 1, "nl_type": 4, "nl_platform": 2, "nl_desc": "Invoice Created (8422)", "nl_manualNotes": null, "nl_createdby": "16", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 0, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "485765", "nl_endddate": 1749513600, "nl_starttime": 1749535974, "created_at": 1749535974, "updated_at": 1749535981, "created_by": 16, "updated_by": null } ], "updated": [], "deleted": [] }, "bm_deliveryaddresssetting": { "created": [], "updated": [], "deleted": [] }, "bm_jobchecklist": { "created": [], "updated": [], "deleted": [] }, "bm_Invoice": { "created": [ { "invoice_id": 8080, "job_id": 12961, "customer_id": 5946, "ref_no": "8422", "invoice_type": 1, "invoice_split_type": 0, "invoice_split_cal": 0, "invoice_split_cal_value": null, "net_amount": "30.000", "vat_amount": "6.000", "gross_amount": "36.000", "delivery_amount": "30.000", "delivery": 0, "commission_amount": "0.000", "commission": 0, "total_amount": "36.000", "split_net_amount": null, "split_vat_amount": null, "outstanding_amount": "36.000", "paid_amount": "0.000", "paid_status": 0, "status": 0, "transfer": 0, "transfer_id": null, "id": "8080", "paymentDueDate": 1749513600, "invoiceDate": 1749513600, "transferDate": null, "createdat": 1749535974, "updatedat": 1749535981, "createdby": 16, "updatedby": null } ], "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": 35548, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 485763, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 12961, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 16, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Trade\",\"Description\":\"Invoice Created (201749535955)\",\"Created By\":\"Siva\",\"Date\":\"2025-06-10\",\"Time\":\"06:12:35\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":485763,\"nl_ordertempid\":0,\"nl_orderid\":12961,\"nl_notescategory\":1,\"nl_type\":4,\"nl_platform\":2,\"nl_desc\":\"Invoice Created (201749535955)\",\"nl_manualNotes\":null,\"nl_createdby\":\"16\",\"nl_endddate\":\"2025-06-10\",\"nl_starttime\":\"06:12:35\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":16,\"created_at\":\"2025-06-10T06:12:35.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-10T06:13:01.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "35548", "cl_createdat": "1749535981.000000", "cl_updatedat": null }, { "cl_id": 35549, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 485764, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 12961, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 16, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Trade\",\"Description\":\"Invoice Deleted (\\\"201749535955\\\")\",\"Created By\":\"Siva\",\"Date\":\"2025-06-10\",\"Time\":\"06:12:50\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":485764,\"nl_ordertempid\":0,\"nl_orderid\":12961,\"nl_notescategory\":1,\"nl_type\":4,\"nl_platform\":2,\"nl_desc\":\"Invoice Deleted (\\\"201749535955\\\")\",\"nl_manualNotes\":null,\"nl_createdby\":\"16\",\"nl_endddate\":\"2025-06-10\",\"nl_starttime\":\"06:12:50\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":16,\"created_at\":\"2025-06-10T06:12:50.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-10T06:13:01.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "35549", "cl_createdat": "1749535981.000000", "cl_updatedat": null }, { "cl_id": 35550, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 485765, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 12961, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 16, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Trade\",\"Description\":\"Invoice Created (201749535974)\",\"Created By\":\"Siva\",\"Date\":\"2025-06-10\",\"Time\":\"06:12:54\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":485765,\"nl_ordertempid\":0,\"nl_orderid\":12961,\"nl_notescategory\":1,\"nl_type\":4,\"nl_platform\":2,\"nl_desc\":\"Invoice Created (201749535974)\",\"nl_manualNotes\":null,\"nl_createdby\":\"16\",\"nl_endddate\":\"2025-06-10\",\"nl_starttime\":\"06:12:54\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":16,\"created_at\":\"2025-06-10T06:12:54.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-10T06:13:01.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "35550", "cl_createdat": "1749535981.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_notelist": { "61749535955": 485763, "61749535956": 485764, "61749535957": 485765 }, "bm_Invoice": { "121749535974": 8080 } }, "timestamp": 1749535981 }