{ "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": 1645, "jd_customerid": 915, "jd_contactid": 982, "jd_additionalcontacts": "982", "jd_templateid": 1, "jd_jobmultiquoteid": 1705, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "JBN1629", "jd_jobstatus": 3, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "TOFF0001", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "200.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "200.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "jd_isroundon": 0, "jd_grossprice": "200.00", "jd_grossprofit": "200.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "200.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": 36, "jd_updatedby": 36, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "20.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"JBN1629\",\"35\":\"TOFF0001\",\"36\":3,\"37\":2,\"38\":\"\",\"39\":\"\",\"40\":1,\"41\":36,\"44\":\"\",\"45\":\"Offline Resting \",\"46\":\"T\",\"47\":\"\",\"48\":\"\",\"49\":\"Sample Data @12345\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":35,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"614\":36,\"630\":8,\"798\":\"\",\"799\":\"\",\"808\":\"\",\"810\":\"\",\"811\":\"\",\"812\":\"\",\"countryText\":\"India\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "20.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "1645", "jd_createddate": 1743465600, "jd_orderdate": null, "jd_duedate": 1743465600, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1743506741, "jd_updatedat": 1743506926 } ], "deleted": [] }, "bm_orderitem": { "created": [ { "oi_id": 4758, "oi_jobid": 0, "oi_jobtempid": "66e57e27", "oi_jobmultiquoteid": null, "oi_productid": 53, "oi_recipeid": 104, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 158, "oi_customseq": 1, "oi_productcustomseq": 23, "oi_jsondata": "[{\"id\":7181,\"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\":7181,\"subchild\":[],\"fieldInformation\":\"Unit Type\\nUnit Type\",\"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\":3124,\"labelname\":\"Supplier\",\"value\":9,\"valueid\":null,\"type\":17,\"optionid\":\"9\",\"optionvalue\":[{\"id\":9,\"optionid\":9,\"optionname\":\"Blind Design\",\"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\":3124,\"subchild\":[],\"fieldInformation\":\"Supplier1\",\"ruleoverride\":1,\"optiondefault\":\"9\",\"optionsvalue\":[{\"id\":9,\"optionid\":9,\"optionname\":\"Blind Design\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":3123,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":null,\"type\":14,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Quantity\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":14,\"mandatory\":0,\"fieldname\":\"Quantity\",\"fieldid\":3123,\"subchild\":[],\"fieldInformation\":\"Quantity\",\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3128,\"labelname\":\"Width\",\"value\":null,\"valueid\":null,\"type\":11,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Width\",\"fabricorcolor\":0,\"widthfraction\":\"0_mm_3_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\":3128,\"subchild\":[],\"fieldInformation\":\"Width\",\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3129,\"labelname\":\"Drop\",\"value\":null,\"valueid\":null,\"type\":12,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Drop\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":\"0_mm_3_0\",\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":12,\"mandatory\":0,\"fieldname\":\"Drop\",\"fieldid\":3129,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3125,\"labelname\":\"Product Type\",\"value\":56,\"valueid\":\"226\",\"type\":13,\"optionid\":\"56\",\"optionvalue\":[{\"id\":226,\"fieldid\":3125,\"fieldoptionlinkid\":226,\"optionid\":56,\"mainsupplier\":\"9\",\"blindtypecode\":null,\"optionname\":\"A BAND\",\"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\":3125,\"subchild\":[],\"fieldInformation\":\"Product Type\",\"ruleoverride\":1,\"optiondefault\":\"56\",\"optionsvalue\":[{\"id\":226,\"fieldid\":3125,\"fieldoptionlinkid\":226,\"optionid\":56,\"mainsupplier\":\"9\",\"blindtypecode\":null,\"optionname\":\"A BAND\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"editruleoverride\":0},{\"id\":3168,\"labelname\":\"Fabric\",\"value\":\"Arundel\",\"valueid\":\"38\",\"type\":5,\"optionid\":\"38\",\"optionvalue\":[{\"optionid\":38,\"optionname\":\"Arundel\",\"optioncode\":\"ROBARUN\",\"optionquantity\":1,\"fieldoptionlinkid\":38,\"forchildfieldoptionlinkid\":\"5_2_38_1\",\"optionimage\":null,\"subdatacount\":1,\"fabricmapid\":38,\"pricegroup\":\"A BAND\",\"pricegroupid\":56}],\"issubfabric\":0,\"labelnamecode\":\"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\":\"Fabric\",\"fieldid\":3168,\"subchild\":[],\"fieldInformation\":\"Fabric\",\"ruleoverride\":1,\"optiondefault\":\"38\",\"optionsvalue\":[{\"optionid\":38,\"optionname\":\"Arundel\",\"optioncode\":\"ROBARUN\",\"optionquantity\":1,\"fieldoptionlinkid\":38,\"forchildfieldoptionlinkid\":\"5_2_38_1\",\"optionimage\":null,\"subdatacount\":1,\"fabricmapid\":38,\"pricegroup\":\"A BAND\",\"pricegroupid\":56}],\"editruleoverride\":0},{\"id\":3137,\"labelname\":\"Single select Component\",\"value\":\"Somfy AC Charger For Li ion Battery Pack\",\"valueid\":\"4663\",\"type\":3,\"optionid\":\"201\",\"optionvalue\":[{\"optionid\":201,\"optionqty\":\"1\",\"optionname\":\"Somfy AC Charger For Li ion Battery Pack\",\"optioncode\":\"R-SCBP\",\"description\":null,\"pricegroups\":\"KuroLok 100 RL Band E,KuroLok 100 RL Band F,KuroLok 125 RL Band C,KuroLok 125 RL Band D,KuroLok 125 RL Band E,KuroLok 125 RL Band F,KuroLok 100 Twin RL Band C,KuroLok 100 Twin RL Band D,KuroLok 100 Twin RL Band E,KuroLok 100 Twin RL Band F,Kuro 80 Band A\",\"unittype\":\"Each\",\"unitcost\":10,\"fieldoptionlinkid\":4663,\"forchildfieldoptionlinkid\":\"3_4663\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"10.00\",\"costprice\":10,\"costwithdiscount\":10,\"customersellingprice\":10,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":10}],\"issubfabric\":0,\"labelnamecode\":\"Single select Component\",\"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\":\"Single select Component\",\"fieldid\":3137,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"201\",\"optionsvalue\":[{\"optionid\":201,\"optionqty\":\"1\",\"optionname\":\"Somfy AC Charger For Li ion Battery Pack\",\"optioncode\":\"R-SCBP\",\"description\":null,\"pricegroups\":\"KuroLok 100 RL Band E,KuroLok 100 RL Band F,KuroLok 125 RL Band C,KuroLok 125 RL Band D,KuroLok 125 RL Band E,KuroLok 125 RL Band F,KuroLok 100 Twin RL Band C,KuroLok 100 Twin RL Band D,KuroLok 100 Twin RL Band E,KuroLok 100 Twin RL Band F,Kuro 80 Band A\",\"unittype\":\"Each\",\"unitcost\":10,\"fieldoptionlinkid\":4663,\"forchildfieldoptionlinkid\":\"3_4663\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"10.00\",\"costprice\":10,\"costwithdiscount\":10,\"customersellingprice\":10,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":10}],\"editruleoverride\":0},{\"id\":3138,\"labelname\":\"Multi Select Component\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Multi Select Component\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Multi Select Component\",\"fieldid\":3138,\"subchild\":[],\"fieldInformation\":\"Extras\\nExtras\",\"ruleoverride\":1,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":13221,\"labelname\":\"BOW\",\"value\":null,\"valueid\":null,\"type\":1,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"BOW\",\"fabricorcolor\":0,\"widthfraction\":\"0_mm_3_0\",\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":1,\"mandatory\":0,\"fieldname\":\"BOW\",\"fieldid\":13221,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3140,\"labelname\":\"Further Instructions\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Further Instructions\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Further Instructions\",\"fieldid\":3140,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":15602,\"labelname\":\"Dual PT\",\"value\":null,\"valueid\":null,\"type\":13,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Dual PTPT2\",\"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\":\"Dual PT\",\"fieldid\":15602,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Supplier: Blind Design, Product Type: A BAND, Fabric: Arundel, Single select Component: Somfy AC Charger For Li ion Battery Pack", "oi_reportdescription": "##Supplier: Blind Design##,##Quantity: 1##,##Product Type: A BAND##,##Fabric: Arundel##,##Single select Component: Somfy AC Charger For Li ion Battery Pack##", "oi_reporttitles": "##Supplier:<\/br>##Quantity:<\/br>##Product Type:<\/br>##Fabric:<\/br>##Single select Component:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":null,\"value\":\"-\",\"formula\":null,\"price\":null,\"recipeid\":null,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":null,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":377,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":104,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":378,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":104,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"formula\":\"noFormula\",\"stockupdate\":0,\"isdelete\":0,\"fieldtype_id\":3,\"fractionvalue\":null}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[{\"link_id\":43,\"process_id\":40,\"product_id\":53,\"phc_id\":43,\"pd_id\":40,\"name\":\"Fabric cut\",\"phc_linkstations\":2,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":1,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"10.00\",\"phc_contractsellingprice\":\"10.00\",\"phc_tradesellingprice\":\"10.00\",\"phc_dynamiccontact5_sellingprice\":\"10.00\",\"phc_dynamiccontact6_sellingprice\":\"10.00\",\"phc_dynamiccontact7_sellingprice\":\"10.00\",\"phc_dynamiccontact8_sellingprice\":\"10.00\",\"phc_ecommercesellingprice\":\"10.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"10.00\",\"Hour\\\/mins\":\"10 mins\",\"phc_processcostid\":1,\"markupprice\":\"10.00\",\"price\":\"0.00\"}]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"10.00\",\"cost_with_discount\":\"10.00\",\"cost_with_markup\":\"10.00\",\"gross_price\":\"12.00\",\"vat_price\":\"2.00\"}", "oi_pricecomesfrom_calculations": "{\"label\":\"Price table cost\",\"unit_type\":\"-\",\"cost_price\":\"0.00\",\"show_hide\":true,\"category\":3}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "20.000", "oi_netprice": "20.000", "oi_pricesfromoperations": null, "oi_vatprice": "4.000", "oi_vatvalue": "20.000", "oi_vatselected": 10, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "24.000", "oi_overrideprice": "0.000", "oi_overridetype": 3, "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": "20.000", "oi_endcustomeroverridevatprice": "0.000", "oi_endcustomeroverridegrossprice": "24.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[7181, 3124, 3123, 3128, 3129, 3125, 3168, 3137, 3138, 13221, 3140, 15602]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "4758", "oi_productiondate": 1743510813, "oi_createdat": 1743510813, "oi_updatedat": 1743491019, "oi_createdby": 102, "oi_updatedby": null }, { "oi_id": 4759, "oi_jobid": 1643, "oi_jobtempid": "0", "oi_jobmultiquoteid": 1703, "oi_productid": 53, "oi_recipeid": 104, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 159, "oi_customseq": 1, "oi_productcustomseq": 24, "oi_jsondata": "[{\"id\":7181,\"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\":7181,\"subchild\":[],\"fieldInformation\":\"Unit Type\\nUnit Type\",\"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\":3124,\"labelname\":\"Supplier\",\"value\":9,\"valueid\":null,\"type\":17,\"optionid\":\"9\",\"optionvalue\":[{\"id\":9,\"optionid\":9,\"optionname\":\"Blind Design\",\"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\":3124,\"subchild\":[],\"fieldInformation\":\"Supplier1\",\"ruleoverride\":1,\"optiondefault\":\"9\",\"optionsvalue\":[{\"id\":9,\"optionid\":9,\"optionname\":\"Blind Design\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":3123,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":null,\"type\":14,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Quantity\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":14,\"mandatory\":0,\"fieldname\":\"Quantity\",\"fieldid\":3123,\"subchild\":[],\"fieldInformation\":\"Quantity\",\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3128,\"labelname\":\"Width\",\"value\":\"100\",\"valueid\":null,\"type\":11,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Width\",\"fabricorcolor\":0,\"widthfraction\":\"0_mm_3_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\":3128,\"subchild\":[],\"fieldInformation\":\"Width\",\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":3129,\"labelname\":\"Drop\",\"value\":\"50\",\"valueid\":null,\"type\":12,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Drop\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":\"0_mm_3_0\",\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":12,\"mandatory\":0,\"fieldname\":\"Drop\",\"fieldid\":3129,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":3125,\"labelname\":\"Product Type\",\"value\":56,\"valueid\":\"226\",\"type\":13,\"optionid\":\"56\",\"optionvalue\":[{\"id\":226,\"fieldid\":3125,\"fieldoptionlinkid\":226,\"optionid\":56,\"mainsupplier\":\"9\",\"blindtypecode\":null,\"optionname\":\"A BAND\",\"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\":3125,\"subchild\":[],\"fieldInformation\":\"Product Type\",\"ruleoverride\":1,\"optiondefault\":\"56\",\"optionsvalue\":[{\"id\":226,\"fieldid\":3125,\"fieldoptionlinkid\":226,\"optionid\":56,\"mainsupplier\":\"9\",\"blindtypecode\":null,\"optionname\":\"A BAND\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"editruleoverride\":0},{\"id\":3168,\"labelname\":\"Fabric\",\"value\":\"Arundel\",\"valueid\":\"38\",\"type\":5,\"optionid\":\"38\",\"optionvalue\":[{\"optionid\":38,\"optionname\":\"Arundel\",\"optioncode\":\"ROBARUN\",\"optionquantity\":1,\"fieldoptionlinkid\":38,\"forchildfieldoptionlinkid\":\"5_2_38_1\",\"optionimage\":null,\"subdatacount\":1,\"fabricmapid\":38,\"pricegroup\":\"A BAND\",\"pricegroupid\":56}],\"issubfabric\":0,\"labelnamecode\":\"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\":\"Fabric\",\"fieldid\":3168,\"subchild\":[{\"fieldtypeid\":5,\"labelnamecode\":\"DSP\",\"fieldid\":3739,\"status\":0,\"fieldname\":\"DSP\",\"field_has_sub_option\":1,\"selection\":0,\"seq\":598,\"mandatory\":0,\"fieldlevel\":2,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"fabricorcolor\":2,\"optionsvalue\":[{\"optionid\":93,\"optionname\":\"Charcoal\",\"optioncode\":\"CHAR\",\"optionquantity\":1,\"fieldoptionlinkid\":93,\"forchildfieldoptionlinkid\":\"5_3_93_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0}],\"optionsbackup\":[{\"optionid\":93,\"optionname\":\"Charcoal\",\"optioncode\":\"CHAR\",\"optionquantity\":1,\"fieldoptionlinkid\":93,\"forchildfieldoptionlinkid\":\"5_3_93_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0}],\"editablecolumns\":[],\"subfieldlinkid\":38,\"forchildsubfieldlinkid\":\"5_2_38_1\",\"optionsselectedcolumns\":{\"optionid\":\"Option Id\",\"optionname\":\"Color Name\",\"optioncode\":\"Color Code\"},\"optiondefault\":\"93\",\"value\":null,\"issubfabric\":0,\"masterparentfieldid\":3168,\"hasstock\":0,\"subchild\":[],\"supplierid\":\"0\",\"editruleoverride\":null,\"linktopricegroup\":0,\"dualseq\":1,\"fieldInformation\":null,\"multiseq\":0,\"dumydata\":[]}],\"fieldInformation\":\"Fabric\",\"ruleoverride\":1,\"optiondefault\":\"38\",\"optionsvalue\":[{\"optionid\":38,\"optionname\":\"Arundel\",\"optioncode\":\"ROBARUN\",\"optionquantity\":1,\"fieldoptionlinkid\":38,\"forchildfieldoptionlinkid\":\"5_2_38_1\",\"optionimage\":null,\"subdatacount\":1,\"fabricmapid\":38,\"pricegroup\":\"A BAND\",\"pricegroupid\":56}],\"editruleoverride\":0},{\"id\":3739,\"labelname\":\"DSP\",\"value\":\"Charcoal\",\"valueid\":\"93\",\"type\":5,\"optionid\":\"93\",\"optionvalue\":[{\"optionid\":93,\"optionname\":\"Charcoal\",\"optioncode\":\"CHAR\",\"optionquantity\":1,\"fieldoptionlinkid\":93,\"forchildfieldoptionlinkid\":\"5_3_93_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0}],\"issubfabric\":0,\"labelnamecode\":\"DSP\",\"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\":\"DSP\",\"fieldid\":3739,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"93\",\"optionsvalue\":[{\"optionid\":93,\"optionname\":\"Charcoal\",\"optioncode\":\"CHAR\",\"optionquantity\":1,\"fieldoptionlinkid\":93,\"forchildfieldoptionlinkid\":\"5_3_93_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0}],\"editruleoverride\":0},{\"id\":3137,\"labelname\":\"Single select Component\",\"value\":\"Somfy AC Charger For Li ion Battery Pack\",\"valueid\":\"4663\",\"type\":3,\"optionid\":\"201\",\"optionvalue\":[{\"optionid\":201,\"optionqty\":\"1\",\"optionname\":\"Somfy AC Charger For Li ion Battery Pack\",\"optioncode\":\"R-SCBP\",\"description\":null,\"pricegroups\":\"KuroLok 100 RL Band E,KuroLok 100 RL Band F,KuroLok 125 RL Band C,KuroLok 125 RL Band D,KuroLok 125 RL Band E,KuroLok 125 RL Band F,KuroLok 100 Twin RL Band C,KuroLok 100 Twin RL Band D,KuroLok 100 Twin RL Band E,KuroLok 100 Twin RL Band F,Kuro 80 Band A\",\"unittype\":\"Each\",\"unitcost\":10,\"fieldoptionlinkid\":4663,\"forchildfieldoptionlinkid\":\"3_4663\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"10.00\",\"costprice\":10,\"costwithdiscount\":10,\"customersellingprice\":10,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":10}],\"issubfabric\":0,\"labelnamecode\":\"Single select Component\",\"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\":\"Single select Component\",\"fieldid\":3137,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"201\",\"optionsvalue\":[{\"optionid\":201,\"optionqty\":\"1\",\"optionname\":\"Somfy AC Charger For Li ion Battery Pack\",\"optioncode\":\"R-SCBP\",\"description\":null,\"pricegroups\":\"KuroLok 100 RL Band E,KuroLok 100 RL Band F,KuroLok 125 RL Band C,KuroLok 125 RL Band D,KuroLok 125 RL Band E,KuroLok 125 RL Band F,KuroLok 100 Twin RL Band C,KuroLok 100 Twin RL Band D,KuroLok 100 Twin RL Band E,KuroLok 100 Twin RL Band F,Kuro 80 Band A\",\"unittype\":\"Each\",\"unitcost\":10,\"fieldoptionlinkid\":4663,\"forchildfieldoptionlinkid\":\"3_4663\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"10.00\",\"costprice\":10,\"costwithdiscount\":10,\"customersellingprice\":10,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":10}],\"editruleoverride\":0},{\"id\":3138,\"labelname\":\"Multi Select Component\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Multi Select Component\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Multi Select Component\",\"fieldid\":3138,\"subchild\":[],\"fieldInformation\":\"Extras\\nExtras\",\"ruleoverride\":1,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":13221,\"labelname\":\"BOW\",\"value\":null,\"valueid\":null,\"type\":1,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"BOW\",\"fabricorcolor\":0,\"widthfraction\":\"0_mm_3_0\",\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":1,\"mandatory\":0,\"fieldname\":\"BOW\",\"fieldid\":13221,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3140,\"labelname\":\"Further Instructions\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Further Instructions\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Further Instructions\",\"fieldid\":3140,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":15602,\"labelname\":\"Dual PT\",\"value\":null,\"valueid\":null,\"type\":13,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Dual PTPT2\",\"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\":\"Dual PT\",\"fieldid\":15602,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Supplier: Blind Design, Width: 100, Drop: 50, Product Type: A BAND, Fabric: Arundel, DSP: Charcoal, Single select Component: Somfy AC Charger For Li ion Battery Pack", "oi_reportdescription": "##Supplier: Blind Design##,##Quantity: 1##,##Width: 100 mm##,##Drop: 50 mm##,##Product Type: A BAND##,##Fabric: Arundel##,##DSP: Charcoal##,##Single select Component: Somfy AC Charger For Li ion Battery Pack##", "oi_reporttitles": "##Supplier:<\/br>##Quantity:<\/br>##Width:<\/br>##Drop:<\/br>##Product Type:<\/br>##Fabric:<\/br>##DSP:<\/br>##Single select Component:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":null,\"value\":\"-\",\"formula\":null,\"price\":null,\"recipeid\":null,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":null,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":377,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":104,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":378,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":104,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"formula\":\"noFormula\",\"stockupdate\":0,\"isdelete\":0,\"fieldtype_id\":3,\"fractionvalue\":null}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[{\"link_id\":43,\"process_id\":40,\"product_id\":53,\"phc_id\":43,\"pd_id\":40,\"name\":\"Fabric cut\",\"phc_linkstations\":2,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":1,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"10.00\",\"phc_contractsellingprice\":\"10.00\",\"phc_tradesellingprice\":\"10.00\",\"phc_dynamiccontact5_sellingprice\":\"10.00\",\"phc_dynamiccontact6_sellingprice\":\"10.00\",\"phc_dynamiccontact7_sellingprice\":\"10.00\",\"phc_dynamiccontact8_sellingprice\":\"10.00\",\"phc_ecommercesellingprice\":\"10.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"10.00\",\"Hour\\\/mins\":\"10 mins\",\"phc_processcostid\":1,\"markupprice\":\"10.00\",\"price\":\"0.00\"}]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"10.00\",\"cost_with_discount\":\"10.00\",\"cost_with_markup\":\"10.00\",\"gross_price\":\"12.00\",\"vat_price\":\"2.00\"}", "oi_pricecomesfrom_calculations": "{\"label\":\"Price table cost\",\"unit_type\":\"-\",\"cost_price\":\"90.00\",\"show_hide\":true,\"category\":3}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "110.000", "oi_netprice": "110.000", "oi_pricesfromoperations": null, "oi_vatprice": "22.000", "oi_vatvalue": "20.000", "oi_vatselected": 10, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "132.000", "oi_overrideprice": "0.000", "oi_overridetype": 3, "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": "110.000", "oi_endcustomeroverridevatprice": "22.000", "oi_endcustomeroverridegrossprice": "132.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[7181, 3124, 3123, 3128, 3129, 3125, 3168, 3739, 3137, 3138, 13221, 3140, 15602]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "4759", "oi_productiondate": 1743511860, "oi_createdat": 1743511860, "oi_updatedat": 1743492077, "oi_createdby": 102, "oi_updatedby": 102 } ], "updated": [ { "oi_id": 4761, "oi_jobid": 1645, "oi_jobtempid": "0", "oi_jobmultiquoteid": 1705, "oi_productid": 1, "oi_recipeid": 1, "oi_ruleid": 0, "oi_qty": 2, "oi_seq": 0, "oi_customseq": 0, "oi_productcustomseq": 0, "oi_jsondata": "[{\"id\":7173,\"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\":1,\"labelname\":\"Quantity\",\"value\":\"2\",\"valueid\":\"\",\"type\":14,\"optionid\":\"1\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":2,\"labelname\":\"Supplier\",\"value\":\"1\",\"valueid\":\"\",\"type\":17,\"optionid\":\"1\",\"optionvalue\":[{\"id\":1,\"optionid\":1,\"optionname\":\"Arena1\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":5,\"labelname\":\"Width\",\"value\":\"586\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":6,\"labelname\":\"Drop\",\"value\":\"633\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":41,\"labelname\":\"Fabric\",\"value\":\"FA1\",\"valueid\":\"18\",\"type\":5,\"optionid\":\"18\",\"optionvalue\":[{\"optionid\":18,\"optionname\":\"FA1\",\"optioncode\":\"sa\",\"optionquantity\":1,\"fieldoptionlinkid\":18,\"forchildfieldoptionlinkid\":\"5_2_18_1\",\"subdatacount\":1,\"optionimage\":\"\",\"pricegroup\":\"Band C\",\"pricegroupid\":5}],\"fabricorcolor\":1,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":153,\"labelname\":\"Color\",\"value\":\"sa\",\"valueid\":\"25\",\"type\":5,\"optionid\":\"25\",\"optionvalue\":[{\"optionid\":25,\"optionname\":\"sa\",\"optioncode\":\"\",\"optionquantity\":1,\"fieldoptionlinkid\":25,\"forchildfieldoptionlinkid\":\"5_25\",\"minimumdiscount\":\"\",\"maximumdiscount\":\"\",\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3,\"labelname\":\"Product Type\",\"value\":5,\"valueid\":\"5\",\"type\":13,\"optionid\":\"5\",\"optionvalue\":[{\"id\":5,\"fieldid\":3,\"fieldoptionlinkid\":5,\"optionid\":5,\"mainsupplier\":\"1\",\"blindtypecode\":\"\",\"optionname\":\"Band C\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":39,\"labelname\":\"New Test\",\"value\":\"adssa\",\"valueid\":\"71\",\"type\":3,\"optionid\":\"20\",\"optionvalue\":[{\"optionid\":20,\"optionname\":\"adssa\",\"optioncode\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":71,\"forchildfieldoptionlinkid\":\"3_71\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":40,\"labelname\":\"Only test\",\"value\":\"fsd\",\"valueid\":\"75\",\"type\":3,\"optionid\":\"24\",\"optionvalue\":[{\"optionid\":24,\"optionname\":\"fsd\",\"optioncode\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":75,\"forchildfieldoptionlinkid\":\"3_75\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":75}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":51,\"labelname\":\"BOM Test\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":61,\"labelname\":\"TT\",\"value\":\"\",\"valueid\":\"\",\"type\":6,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":4,\"labelname\":\"Extras\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":114,\"labelname\":\"sdafds\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]", "oi_description": "Unit Type: mm, Quantity: 2, Supplier: Arena1, Width: 586, Drop: 633, Fabric: FA1, Color: sa, New Test: adssa, Only test: fsd", "oi_reportdescription": "##Quantity: 2##,##Supplier: Arena1##,##Width: 586 mm##,##Drop: 633 mm##,##Fabric: FA1##,##Color: sa##,##New Test: adssa##,##Only test: fsd##", "oi_reporttitles": "##Quantity:##Supplier:##Width:##Drop:##Fabric:##Color:##New Test:##Only test:", "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": "20.000", "oi_netprice": "20.000", "oi_pricesfromoperations": null, "oi_vatprice": "4.000", "oi_vatvalue": "20.000", "oi_vatselected": 10, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "24.000", "oi_overrideprice": "0.000", "oi_overridetype": 3, "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": 3, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "20.000", "oi_endcustomeroverridevatprice": "4.000", "oi_endcustomeroverridegrossprice": "24.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[7173, 1, 2, 5, 6, 41, 153, 3, 39, 40, 51, 61, 4, 114]", "oi_deviceplatform": 1, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "4761", "oi_productiondate": 1743506824, "oi_createdat": 1743506861, "oi_updatedat": 1743506926, "oi_createdby": 36, "oi_updatedby": 36 } ], "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": [ { "jmq_id": 1705, "jmq_jobid": 1645, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "0.00", "jmq_netprice": "200.00", "jmq_vat": "0.00", "jmq_isvaton": 1, "jmq_deliverycost": "200.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 1, "jmq_orderformprice": "0.00", "jmq_editpricebyid": null, "jmq_isroundon": 0, "jmq_grossprice": "200.00", "jmq_grossprofit": "200.00", "jmq_costprice": "0.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "200.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": "1705", "jmq_duedate": 1743465600, "jmq_sceduleddate": null, "jmq_createdat": "1743506741.000000", "jmq_updatedat": "1743506870.000000", "jmq_createdby": 36, "jmq_updatedby": 36 } ], "deleted": [] }, "bm_jobstatus_tracks": { "created": [ { "jst_id": 1834, "jst_jobid": 1645, "jst_job_current_status": 3, "id": "1834", "jst_createdat": "1743506870.185148" } ], "updated": [], "deleted": [] }, "bm_customindividuallogs": { "created": [ { "cl_id": 35496, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 1645, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 1645, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 36, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"BlindMatrix\",\"\":\"India\",\"Account Type\":\"Contract\",\"Created By\":\"Bharani\",\"First Name\":\"Offline Resting \",\"Last Name\":\"T\",\"Address1\":\"Sample Data @12345\",\"Country\":\"India\",\"Salutation\":\"Mr.\",\"Assigned to\":36,\"Role\":8,\"Additional Contacts\":\"982\",\"Production Due Date\":\"2025-04-01\",\"Job Ref No\":\"JBN1629\",\"Job Status\":\"Quote\",\"Order Status\":\"New order\",\"Net Price\":\"200.00\",\"VAT\":\"Enabled\",\"DeliveryCost\":\"200.00\",\"Delivery Cost\":\"All Options\",\"Gross Price Amount\":\"200.00\",\"Gross Profit\":\"200.00\",\"Amount Outstanding\":\"200.00\",\"jd_isonlineorder\":1,\"Delivery Vat Percentage\":\"20.000\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":1645,\"jd_customerid\":915,\"jd_contactid\":982,\"jd_additionalcontacts\":\"982\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"JBN1629\\\",\\\"35\\\":\\\"TOFF0001\\\",\\\"36\\\":3,\\\"37\\\":2,\\\"38\\\":\\\"\\\",\\\"39\\\":\\\"\\\",\\\"40\\\":1,\\\"41\\\":36,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"Offline Resting \\\",\\\"46\\\":\\\"T\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"Sample Data @12345\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":35,\\\"285\\\":1,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"614\\\":36,\\\"630\\\":8,\\\"798\\\":\\\"\\\",\\\"799\\\":\\\"\\\",\\\"808\\\":\\\"\\\",\\\"810\\\":\\\"\\\",\\\"811\\\":\\\"\\\",\\\"812\\\":\\\"\\\",\\\"countryText\\\":\\\"India\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-04-01\",\"jd_orderdate\":null,\"jd_duedate\":\"2025-04-01\",\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":null,\"jd_jobref\":\"JBN1629\",\"jd_jobstatus\":3,\"jd_contactaddid\":0,\"jd_orderstatus\":1,\"jd_accref\":\"TOFF0001\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"0.00\",\"jd_netprice\":\"200.00\",\"jd_vat\":\"0.00\",\"jd_isvaton\":1,\"jd_deliverycost\":\"200.00\",\"jd_deliverycosttypeid\":1,\"jd_overridetypeid\":1,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":null,\"jd_isroundon\":0,\"jd_grossprice\":\"200.00\",\"jd_grossprofit\":\"200.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"0.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"200.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_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":36,\"jd_createdat\":\"2025-04-01T11:25:41.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-04-01T11:27:49.000000Z\",\"jd_deviceplatform\":0,\"jd_fromjobref\":\"\",\"jd_fromdbname\":null,\"jd_importorder\":0,\"jd_quickquote\":0,\"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": "35496", "cl_createdat": "1743506870.000000", "cl_updatedat": null }, { "cl_id": 35497, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in JBN1629", "cl_event": "created", "cl_subjectid": 1705, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 1645, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 36, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":1705,\"jmq_jobid\":1645,\"Quotation Name\":\"Q1\",\"jmq_isdefault\":0,\"Quotation\":\"Accepted\",\"jmq_isdeclined\":0,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"Production Due Date\":\"0000-00-00\",\"List Price\":\"0.00\",\"Net Price\":\"200.00\",\"VAT Price\":\"0.00\",\"VAT\":1,\"jmq_deliverycost\":\"200.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"200.00\",\"Gross Profit\":\"200.00\",\"Total CostPrice\":\"0.00\",\"Amount Outstanding\":\"200.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,\"Commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"Delivery Vat Percentage\":\"20.000\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":1705,\"jmq_jobid\":1645,\"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\":\"0.00\",\"jmq_netprice\":\"200.00\",\"jmq_vat\":\"0.00\",\"jmq_isvaton\":1,\"jmq_deliverycost\":\"200.00\",\"jmq_deliverycosttypeid\":1,\"jmq_overridetypeid\":1,\"jmq_orderformprice\":\"0.00\",\"jmq_editpricebyid\":null,\"jmq_isroundon\":0,\"jmq_grossprice\":\"200.00\",\"jmq_grossprofit\":\"200.00\",\"jmq_costprice\":\"0.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"200.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\":36,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-04-01T11:25:41.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": "35497", "cl_createdat": "1743506870.000000", "cl_updatedat": null }, { "cl_id": 35498, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the field Multi Quote Id", "cl_event": "modified", "cl_subjectid": 1645, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 1645, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 36, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":1705}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":1705},\"old\":{\"jd_jobmultiquoteid\":null}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "35498", "cl_createdat": "1743506870.000000", "cl_updatedat": null }, { "cl_id": 35499, "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 BOM", "cl_event": "created", "cl_subjectid": 4761, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 1645, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 36, "cl_changedfrom": "null", "cl_changedto": "{\"Unit Type\":\" mm\",\" Quantity\":\" 1\",\" Supplier\":\" Arena1\",\" Width\":\" 586\",\" Drop\":\" 633\",\" Fabric\":\" FA1\",\" Color\":\" sa\",\" Product Type\":\" Band C\",\" New Test\":\" adssa\",\" Only test\":\" fsd\"}", "cl_customproperties": "{\"attributes\":{\"oi_id\":4761,\"oi_jobid\":1645,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":1705,\"oi_credit_id\":0,\"oi_productid\":1,\"oi_recipeid\":1,\"oi_ruleid\":0,\"oi_qty\":1,\"oi_seq\":0,\"oi_customseq\":0,\"oi_productcustomseq\":0,\"oi_jsondata\":\"[{\\\"id\\\":7173,\\\"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\\\":1,\\\"labelname\\\":\\\"Quantity\\\",\\\"value\\\":1,\\\"valueid\\\":\\\"\\\",\\\"type\\\":14,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":2,\\\"labelname\\\":\\\"Supplier\\\",\\\"value\\\":\\\"1\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":17,\\\"optionid\\\":\\\"1\\\",\\\"optionvalue\\\":[{\\\"id\\\":1,\\\"optionid\\\":1,\\\"optionname\\\":\\\"Arena1\\\",\\\"deleted\\\":0,\\\"optionquantity\\\":1}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":5,\\\"labelname\\\":\\\"Width\\\",\\\"value\\\":\\\"586\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":11,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":6,\\\"labelname\\\":\\\"Drop\\\",\\\"value\\\":\\\"633\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":12,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":41,\\\"labelname\\\":\\\"Fabric\\\",\\\"value\\\":\\\"FA1\\\",\\\"valueid\\\":\\\"18\\\",\\\"type\\\":5,\\\"optionid\\\":\\\"18\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":18,\\\"optionname\\\":\\\"FA1\\\",\\\"optioncode\\\":\\\"sa\\\",\\\"optionquantity\\\":1,\\\"fieldoptionlinkid\\\":18,\\\"forchildfieldoptionlinkid\\\":\\\"5_2_18_1\\\",\\\"optionimage\\\":\\\"\\\",\\\"subdatacount\\\":1,\\\"pricegroup\\\":\\\"Band C\\\",\\\"pricegroupid\\\":5}],\\\"fabricorcolor\\\":1,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":153,\\\"labelname\\\":\\\"Color\\\",\\\"value\\\":\\\"sa\\\",\\\"valueid\\\":\\\"25\\\",\\\"type\\\":5,\\\"optionid\\\":\\\"25\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":25,\\\"optionname\\\":\\\"sa\\\",\\\"optioncode\\\":\\\"\\\",\\\"optionquantity\\\":1,\\\"fieldoptionlinkid\\\":25,\\\"forchildfieldoptionlinkid\\\":\\\"5_3_25_1\\\",\\\"minimumdiscount\\\":\\\"\\\",\\\"maximumdiscount\\\":\\\"\\\",\\\"optionimage\\\":\\\"\\\",\\\"subdatacount\\\":0}],\\\"fabricorcolor\\\":2,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":3,\\\"labelname\\\":\\\"Product Type\\\",\\\"value\\\":5,\\\"valueid\\\":\\\"5\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"5\\\",\\\"optionvalue\\\":[{\\\"id\\\":5,\\\"fieldid\\\":3,\\\"fieldoptionlinkid\\\":5,\\\"optionid\\\":5,\\\"mainsupplier\\\":\\\"1\\\",\\\"blindtypecode\\\":\\\"\\\",\\\"optionname\\\":\\\"Band C\\\",\\\"optionquantity\\\":1,\\\"subcount\\\":0,\\\"status\\\":0,\\\"subdatacount\\\":0}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":39,\\\"labelname\\\":\\\"New Test\\\",\\\"value\\\":\\\"adssa\\\",\\\"valueid\\\":\\\"71\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"20\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":20,\\\"optionname\\\":\\\"adssa\\\",\\\"optioncode\\\":\\\"\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":71,\\\"forchildfieldoptionlinkid\\\":\\\"3_71\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":40,\\\"labelname\\\":\\\"Only test\\\",\\\"value\\\":\\\"fsd\\\",\\\"valueid\\\":\\\"75\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"24\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":24,\\\"optionname\\\":\\\"fsd\\\",\\\"optioncode\\\":\\\"\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":75,\\\"forchildfieldoptionlinkid\\\":\\\"3_75\\\",\\\"hasstock\\\":1,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"0.00\\\",\\\"fieldid\\\":75}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":51,\\\"labelname\\\":\\\"BOM Test\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":61,\\\"labelname\\\":\\\"TT\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":6,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":4,\\\"labelname\\\":\\\"Extras\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":114,\\\"labelname\\\":\\\"sdafds\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0}]\",\"oi_description\":\"Unit Type: mm, Quantity: 1, Supplier: Arena1, Width: 586, Drop: 633, Fabric: FA1, Color: sa, Product Type: Band C, New Test: adssa, Only test: fsd\",\"oi_onlinedescription\":null,\"oi_imagepath\":null,\"oi_reportdescription\":\"##Quantity: 1##,##Supplier: Arena1##,##Width: 586 mm##,##Drop: 633 mm##,##Fabric: FA1##,##Color: sa##,##Product Type: Band C##,##New Test: adssa##,##Only test: fsd##\",\"oi_onlinereportdescription\":null,\"oi_reporttitles\":\"##Quantity:##Supplier:##Width:##Drop:##Fabric:##Color:##Product Type:##New Test:##Only test:\",\"oi_onlinereporttitles\":null,\"oi_productionformulajsondata\":\"[]\",\"oi_productiondate\":\"2025-04-01 11:27:04\",\"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\":\"10.000\",\"oi_netprice\":\"10.000\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"2.000\",\"oi_vatvalue\":\"20.000\",\"oi_vatselected\":10,\"oi_vattype\":1,\"oi_vatonoff\":1,\"oi_grossprice\":\"12.000\",\"oi_overrideprice\":\"0.000\",\"oi_overridetype\":3,\"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\":3,\"oi_endcustomeroverridevalue\":null,\"oi_endcustomeroverridenetprice\":\"0.000\",\"oi_endcustomeroverridevatprice\":\"0.000\",\"oi_endcustomeroverridegrossprice\":\"0.000\",\"oi_sage_flag\":0,\"oi_status\":0,\"oi_createdby\":36,\"oi_createdat\":\"2025-04-01T11:27:41.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":null,\"oi_jsondataid\":\"[7173, 1, 2, 5, 6, 41, 153, 3, 39, 40, 51, 61, 4, 114]\",\"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": "35499", "cl_createdat": "1743506870.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": [], "timestamp": 1743506926 }