{ "status": "success", "upcomingorder_list": { "bm_customertemplatedata": { "created": [], "updated": [ { "ctd_id": 1490, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\": 1, \"64\": 23, \"742\": 25, \"62\": \"OFFL0010\"}", "ctd_deletedcustokeyvalue": "{}", "ctd_isenablecustspecvatrate": 0, "ctd_custspecvatrate": "0.00", "ctd_vatregnum": null, "ctd_custsurcharge": null, "ctd_defaultdelcost": null, "ctd_defaultapptype": null, "ctd_defaultstaff": null, "ctd_addcredit": "0.00", "ctd_totredeemed": "0.00", "ctd_balance": "0.00", "ctd_creditlimit": "0.00", "ctd_creditavailable": "0.00", "ctd_overdue": 0, "ctd_paymenttermstype": 0, "ctd_paymenttermsvalue": 0, "ctd_paymenttermsdesc": null, "ctd_ishold": 0, "ctd_jobview": 0, "ctd_jobtypeview": 0, "ctd_discount": "0.00", "ctd_language": 0, "ctd_notymsg": 0, "ctd_onlinelogoname": null, "ctd_onlinelogo": null, "ctd_onlinesendemail": 0, "ctd_fordesktopisenable": 0, "ctd_foronlineisenable": 0, "ctd_enabledproductdesktop": "0", "ctd_enabledproductonline": "0", "ctd_onlineproductmarkup": null, "ctd_onlineendcustomeruseprefix": null, "ctd_onlineendcustomersequence": null, "ctd_onlinequotecustomerterms": null, "ctd_onlinequotepaymentterms": null, "ctd_onlineinvoicecustomerterms": null, "ctd_onlineinvoicepaymentterms": null, "ctd_seq": 0, "ctd_status": 0, "id": "1490", "ctd_createdat": 1743503328, "ctd_updatedat": 1743508187, "ctd_createdby": 0, "ctd_updatedby": null } ], "deleted": [] }, "bm_customercontactinfo": { "created": [], "updated": [ { "cci_id": 2738, "cci_customerid": 1490, "cci_templateid": 3, "roleid": 0, "cci_customizedarray": "{\"75\":1,\"77\":\"Offline@8\",\"81\":1,\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"90\":35}", "cci_ismarketingemails": 0, "cci_smsverifystatus": 0, "cci_isdocumentreceived": 0, "cci_receiveddocfor": null, "cci_isonlineportal": 0, "cci_latitude": null, "cci_longitude": null, "cci_username": null, "cci_password": null, "cci_confirmpassword": null, "cci_seq": 0, "cci_status": 0, "cci_deviceplatform": 1, "cci_mobcustomertempid": 31743503328, "id": "2738", "cci_createdat": 1743503328, "cci_updatedat": 1743508187, "cci_createdby": 0, "cci_updatedby": null } ], "deleted": [] }, "bm_appointment": { "created": [], "updated": [], "deleted": [] }, "bm_tasklist": { "created": [], "updated": [], "deleted": [] }, "bm_jobdetails": { "created": [ { "jd_id": 2777, "jd_customerid": 1490, "jd_contactid": 2738, "jd_additionalcontacts": "2738", "jd_templateid": 1, "jd_jobmultiquoteid": 2799, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "BD2667", "jd_jobstatus": 3, "jd_contactaddid": 0, "jd_orderstatus": 2, "jd_accref": "OFFL0010", "jd_invoiceno": "", "jd_listprice": "252.75", "jd_netprice": "252.75", "jd_vat": "23.06", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "jd_isroundon": 0, "jd_grossprice": "275.81", "jd_grossprofit": "0.00", "jd_costprice": "252.75", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "275.81", "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": 9, "jd_updatedby": 9, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "9.125", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"BD2667\",\"35\":\"OFFL0010\",\"36\":3,\"37\":1,\"38\":\"\",\"39\":23,\"40\":2,\"41\":9,\"44\":\"\",\"45\":\"Offline@8\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":35,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"470\":\"\",\"477\":\"\",\"584\":\"\",\"605\":\"\",\"606\":\"\",\"608\":9,\"633\":1,\"705\":\"\",\"718\":1,\"757\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "9.125", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "2777", "jd_createddate": 1743465600, "jd_orderdate": null, "jd_duedate": 1743465600, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1743503328, "jd_updatedat": 1743508188 } ], "updated": [ { "jd_id": 2776, "jd_customerid": 1489, "jd_contactid": 2737, "jd_additionalcontacts": "2737", "jd_templateid": 1, "jd_jobmultiquoteid": 2798, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "BD2666", "jd_jobstatus": 3, "jd_contactaddid": 0, "jd_orderstatus": 2, "jd_accref": "TRRR0001", "jd_invoiceno": "", "jd_listprice": "44.00", "jd_netprice": "44.00", "jd_vat": "4.02", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "48.02", "jd_grossprofit": "12.00", "jd_costprice": "20.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "48.02", "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": "22.00", "jd_endcustomeroverridevatprice": "2.01", "jd_endcustomeroverridegrossprice": "24.01", "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": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "9.125", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":23,\"41\":1,\"44\":\"\",\"45\":\"Trrrr\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":35,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"470\":\"\",\"477\":\"\",\"584\":\"\",\"605\":\"\",\"606\":\"\",\"608\":1,\"633\":1,\"705\":\"\",\"718\":1,\"757\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "9.125", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "2776", "jd_createddate": 1743465600, "jd_orderdate": null, "jd_duedate": 1743465600, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1743496562, "jd_updatedat": 1743507024 }, { "jd_id": 2777, "jd_customerid": 1490, "jd_contactid": 2738, "jd_additionalcontacts": "2738", "jd_templateid": 1, "jd_jobmultiquoteid": 2799, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "BD2667", "jd_jobstatus": 3, "jd_contactaddid": 0, "jd_orderstatus": 2, "jd_accref": "OFFL0010", "jd_invoiceno": "", "jd_listprice": "252.75", "jd_netprice": "252.75", "jd_vat": "23.06", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "jd_isroundon": 0, "jd_grossprice": "275.81", "jd_grossprofit": "0.00", "jd_costprice": "252.75", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "275.81", "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": 9, "jd_updatedby": 9, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "9.125", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"BD2667\",\"35\":\"OFFL0010\",\"36\":3,\"37\":1,\"38\":\"\",\"39\":23,\"40\":2,\"41\":9,\"44\":\"\",\"45\":\"Offline@8\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":35,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"470\":\"\",\"477\":\"\",\"584\":\"\",\"605\":\"\",\"606\":\"\",\"608\":9,\"633\":1,\"705\":\"\",\"718\":1,\"757\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "9.125", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "2777", "jd_createddate": 1743465600, "jd_orderdate": null, "jd_duedate": 1743465600, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1743503328, "jd_updatedat": 1743508188 } ], "deleted": [] }, "bm_orderitem": { "created": [ { "oi_id": 6550, "oi_jobid": 2760, "oi_jobtempid": "0", "oi_jobmultiquoteid": 2782, "oi_productid": 5, "oi_recipeid": 5, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 230, "oi_customseq": 1, "oi_productcustomseq": 668, "oi_jsondata": "[{\"id\":15091,\"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\":15091,\"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\":33,\"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\":33,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":34,\"labelname\":\"Supplier\",\"value\":null,\"valueid\":null,\"type\":17,\"optionid\":null,\"optionvalue\":[],\"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\":34,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":36,\"labelname\":\"Slat Colour\",\"value\":null,\"valueid\":null,\"type\":13,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Slat Colour\",\"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\":\"Slat Colour\",\"fieldid\":36,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":61,\"labelname\":\"Color\",\"value\":null,\"valueid\":null,\"type\":20,\"optionid\":null,\"optionvalue\":[],\"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\":1,\"fieldtypeid\":20,\"mandatory\":0,\"fieldname\":\"Color\",\"fieldid\":61,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":8605,\"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\":8605,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":8606,\"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\":8606,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":13885,\"labelname\":\"Control Type\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Control 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\":3,\"mandatory\":0,\"fieldname\":\"Control Type\",\"fieldid\":13885,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2084,\"labelname\":\"Reverse Roll\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Reverse Roll\",\"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\":\"Reverse Roll\",\"fieldid\":2084,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "", "oi_reportdescription": "##Quantity: 1##", "oi_reporttitles": "##Quantity:", "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\":2374,\"value\":null,\"formula\":\"Quantity*10\",\"price\":null,\"recipeid\":5,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":873,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":5,\"stockupdate\":0,\"fieldid\":19217,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Dimmer Emitter 4 Channels SOURCE\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":455,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":5,\"stockupdate\":0,\"fieldid\":12239,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"setup option\",\"list_option_name\":\"setup option\",\"list_description\":\"check stock updation\",\"list_option_code\":\"078\",\"list_unit_type\":\"Each\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":2476,\"value\":null,\"formula\":\"Width\",\"price\":\"-\",\"recipeid\":5,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":2477,\"value\":null,\"formula\":\"Drop\",\"price\":\"-\",\"recipeid\":5,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"0.00\",\"cost_with_discount\":\"0.00\",\"cost_with_markup\":\"0.00\",\"gross_price\":\"0.00\",\"vat_price\":\"0.00\"}", "oi_pricecomesfrom_calculations": "{\"label\":\"Price table cost\",\"unit_type\":\"-\",\"cost_price\":\"0.00\",\"show_hide\":true,\"category\":4}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "0.000", "oi_netprice": "0.000", "oi_pricesfromoperations": null, "oi_vatprice": "0.000", "oi_vatvalue": "9.125", "oi_vatselected": 44, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "0.000", "oi_overrideprice": "0.000", "oi_overridetype": 1, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 0, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "0.000", "oi_endcustomeroverridevatprice": "0.000", "oi_endcustomeroverridegrossprice": "0.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[15091, 33, 34, 36, 61, 8605, 8606, 13885, 2084]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "6550", "oi_productiondate": 1743510181, "oi_createdat": 1743510181, "oi_updatedat": 1743490393, "oi_createdby": 37, "oi_updatedby": 37 }, { "oi_id": 6551, "oi_jobid": 2762, "oi_jobtempid": "0", "oi_jobmultiquoteid": 2784, "oi_productid": 25, "oi_recipeid": 25, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 230, "oi_customseq": 1, "oi_productcustomseq": 4, "oi_jsondata": "[{\"id\":15111,\"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\":15111,\"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\":1748,\"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\":1748,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1749,\"labelname\":\"Supplier\",\"value\":null,\"valueid\":null,\"type\":17,\"optionid\":null,\"optionvalue\":[],\"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\":1749,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1751,\"labelname\":\"Room\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Room\",\"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\":\"Room\",\"fieldid\":1751,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1752,\"labelname\":\"Blind or Recess\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Blind or Recess\",\"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\":\"Blind or Recess\",\"fieldid\":1752,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1753,\"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\":1753,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1754,\"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\":1754,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1750,\"labelname\":\"Product Type\",\"value\":null,\"valueid\":null,\"type\":13,\"optionid\":null,\"optionvalue\":[],\"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\":1750,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1766,\"labelname\":\"Fabric\",\"value\":null,\"valueid\":null,\"type\":5,\"optionid\":null,\"optionvalue\":[],\"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\":1766,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1755,\"labelname\":\"Controls\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Controls\",\"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\":\"Controls\",\"fieldid\":1755,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1756,\"labelname\":\"Brackets\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Brackets\",\"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\":\"Brackets\",\"fieldid\":1756,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1757,\"labelname\":\"Bead Depth\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Bead Depth\",\"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\":\"Bead Depth\",\"fieldid\":1757,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1758,\"labelname\":\"Rail Colour\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Rail Colour\",\"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\":\"Rail Colour\",\"fieldid\":1758,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1759,\"labelname\":\"Side Rails\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Side Rails\",\"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\":\"Side Rails\",\"fieldid\":1759,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1760,\"labelname\":\"Side Profile\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Side Profile\",\"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\":\"Side Profile\",\"fieldid\":1760,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1761,\"labelname\":\"Control Rod\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Control Rod\",\"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\":\"Control Rod\",\"fieldid\":1761,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":14400,\"labelname\":\"Extras\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Extras\",\"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\":\"Extras\",\"fieldid\":14400,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "", "oi_reportdescription": "##Quantity: 1##", "oi_reporttitles": "##Quantity:", "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\":2170,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":25,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":2171,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":25,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":2453,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":25,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":763,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":25,\"stockupdate\":0,\"fieldid\":3770,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"OptTest\",\"fractionvalue\":null}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[{\"link_id\":344,\"process_id\":190,\"product_id\":25,\"phc_id\":344,\"pd_id\":190,\"name\":\"SAMPLE ASSEM\",\"phc_linkstations\":3,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"5.00\",\"phc_contractsellingprice\":\"5.00\",\"phc_tradesellingprice\":\"5.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"5.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"5.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"5.00\",\"price\":\"0.00\"},{\"link_id\":345,\"process_id\":191,\"product_id\":25,\"phc_id\":345,\"pd_id\":191,\"name\":\"SAMPLE dispatch\",\"phc_linkstations\":4,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"5.00\",\"phc_contractsellingprice\":\"5.00\",\"phc_tradesellingprice\":\"5.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"5.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"5.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"5.00\",\"price\":\"0.00\"},{\"link_id\":343,\"process_id\":189,\"product_id\":25,\"phc_id\":343,\"pd_id\":189,\"name\":\"sample officeCH\",\"phc_linkstations\":1,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"5.00\",\"phc_contractsellingprice\":\"5.00\",\"phc_tradesellingprice\":\"5.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"5.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"5.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"5.00\",\"price\":\"0.00\"}]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"15.00\",\"cost_with_discount\":\"15.00\",\"cost_with_markup\":\"15.00\",\"gross_price\":\"16.37\",\"vat_price\":\"1.37\"}", "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": "15.000", "oi_netprice": "15.000", "oi_pricesfromoperations": null, "oi_vatprice": "1.370", "oi_vatvalue": "9.125", "oi_vatselected": 44, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "16.370", "oi_overrideprice": "0.000", "oi_overridetype": 1, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 0, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "15.750", "oi_endcustomeroverridevatprice": "1.440", "oi_endcustomeroverridegrossprice": "17.190", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[15111, 1748, 1749, 1751, 1752, 1753, 1754, 1750, 1766, 1755, 1756, 1757, 1758, 1759, 1760, 1761, 14400]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "6551", "oi_productiondate": 1743510246, "oi_createdat": 1743510246, "oi_updatedat": 1743490460, "oi_createdby": 37, "oi_updatedby": 37 }, { "oi_id": 6552, "oi_jobid": 2763, "oi_jobtempid": "0", "oi_jobmultiquoteid": 2785, "oi_productid": 558, "oi_recipeid": 711, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 230, "oi_customseq": 1, "oi_productcustomseq": 2, "oi_jsondata": "[{\"id\":24667,\"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\":24667,\"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\":24666,\"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\":24666,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":24668,\"labelname\":\"Supplier\",\"value\":2,\"valueid\":null,\"type\":17,\"optionid\":2,\"optionvalue\":[{\"id\":2,\"optionid\":2,\"optionname\":\"Decora\",\"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\":24668,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":2,\"optionsvalue\":[{\"id\":2,\"optionid\":2,\"optionname\":\"Decora\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":24669,\"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\":24669,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":24670,\"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\":24670,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":24671,\"labelname\":\"Price band\",\"value\":null,\"valueid\":null,\"type\":13,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Price band\",\"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\":\"Price band\",\"fieldid\":24671,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":24672,\"labelname\":\"Fabric\",\"value\":null,\"valueid\":null,\"type\":5,\"optionid\":null,\"optionvalue\":[],\"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\":24672,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":24674,\"labelname\":\"Extras\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Extras\",\"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\":\"Extras\",\"fieldid\":24674,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":24675,\"labelname\":\"fff\",\"value\":null,\"valueid\":null,\"type\":4,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"fff\",\"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\":\"fff\",\"fieldid\":24675,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":24676,\"labelname\":\"fg\",\"value\":null,\"valueid\":null,\"type\":29,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"fg\",\"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\":29,\"mandatory\":0,\"fieldname\":\"fg\",\"fieldid\":24676,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Supplier: Decora", "oi_reportdescription": "##Quantity: 1##,##Supplier: Decora##", "oi_reporttitles": "##Quantity:<\/br>##Supplier:", "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}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"0.00\",\"cost_with_discount\":\"0.00\",\"cost_with_markup\":\"0.00\",\"gross_price\":\"0.00\",\"vat_price\":\"0.00\"}", "oi_pricecomesfrom_calculations": "{\"label\":\"Price table cost\",\"unit_type\":\"-\",\"cost_price\":\"0.00\",\"show_hide\":true,\"category\":3}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "0.000", "oi_netprice": "0.000", "oi_pricesfromoperations": null, "oi_vatprice": "0.000", "oi_vatvalue": "9.125", "oi_vatselected": 44, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "0.000", "oi_overrideprice": "0.000", "oi_overridetype": 1, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 0, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "0.000", "oi_endcustomeroverridevatprice": "0.000", "oi_endcustomeroverridegrossprice": "0.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[24667, 24666, 24668, 24669, 24670, 24671, 24672, 24674, 24675, 24676]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "6552", "oi_productiondate": 1743510279, "oi_createdat": 1743510279, "oi_updatedat": 1743490490, "oi_createdby": 37, "oi_updatedby": 37 }, { "oi_id": 6562, "oi_jobid": 2772, "oi_jobtempid": "0", "oi_jobmultiquoteid": 2794, "oi_productid": 18, "oi_recipeid": 18, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 230, "oi_customseq": 1, "oi_productcustomseq": 17, "oi_jsondata": "[{\"id\":15104,\"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\":15104,\"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\":260,\"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\":260,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":261,\"labelname\":\"Supplier\",\"value\":\"2\",\"valueid\":null,\"type\":17,\"optionid\":\"2\",\"optionvalue\":[{\"id\":2,\"optionid\":2,\"optionname\":\"Decora\",\"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\":261,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"2\",\"optionsvalue\":[{\"id\":2,\"optionid\":2,\"optionname\":\"Decora\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":263,\"labelname\":\"Room\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Room\",\"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\":\"Room\",\"fieldid\":263,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":264,\"labelname\":\"Blind or Recess\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Blind or Recess\",\"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\":\"Blind or Recess\",\"fieldid\":264,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":265,\"labelname\":\"Width\",\"value\":\"1000\",\"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\":1,\"fieldname\":\"Width\",\"fieldid\":265,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":266,\"labelname\":\"Drop\",\"value\":\"2000\",\"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\":1,\"fieldname\":\"Drop\",\"fieldid\":266,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":262,\"labelname\":\"Product Type\",\"value\":243,\"valueid\":\"243\",\"type\":13,\"optionid\":243,\"optionvalue\":[{\"id\":243,\"fieldid\":262,\"fieldoptionlinkid\":243,\"optionid\":243,\"mainsupplier\":\"2\",\"blindtypecode\":null,\"optionname\":\"FB Band D\",\"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\":1,\"fieldname\":\"Product Type\",\"fieldid\":262,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":243,\"optionsvalue\":[{\"id\":243,\"fieldid\":262,\"fieldoptionlinkid\":243,\"optionid\":243,\"mainsupplier\":\"2\",\"blindtypecode\":null,\"optionname\":\"FB Band D\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"editruleoverride\":0},{\"id\":1047,\"labelname\":\"Fabric\",\"value\":\"Alta Blackout\",\"valueid\":\"2900\",\"type\":5,\"optionid\":\"2900\",\"optionvalue\":[{\"optionid\":2900,\"optionname\":\"Alta Blackout\",\"optioncode\":\"ROBALBO\",\"optionquantity\":1,\"fieldoptionlinkid\":2900,\"forchildfieldoptionlinkid\":\"5_2_2900_1\",\"optionimage\":null,\"subdatacount\":1,\"fabricmapid\":2900,\"pricegroup\":\"FB Band D\",\"pricegroupid\":243}],\"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\":1047,\"subchild\":[{\"fieldtypeid\":5,\"labelnamecode\":\"Color\",\"fieldid\":3757,\"status\":0,\"fieldname\":\"Color\",\"field_has_sub_option\":1,\"selection\":0,\"seq\":701,\"mandatory\":0,\"fieldlevel\":2,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"fabricorcolor\":2,\"optionsvalue\":[{\"optionid\":8248,\"optionname\":\"Frost\",\"optioncode\":\"FROS\",\"optionquantity\":1,\"fieldoptionlinkid\":8248,\"forchildfieldoptionlinkid\":\"5_3_8248_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0},{\"optionid\":8249,\"optionname\":\"Platinum\",\"optioncode\":\"PLAT\",\"optionquantity\":1,\"fieldoptionlinkid\":8249,\"forchildfieldoptionlinkid\":\"5_3_8249_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0}],\"optionsbackup\":[{\"optionid\":8248,\"optionname\":\"Frost\",\"optioncode\":\"FROS\",\"optionquantity\":1,\"fieldoptionlinkid\":8248,\"forchildfieldoptionlinkid\":\"5_3_8248_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0},{\"optionid\":8249,\"optionname\":\"Platinum\",\"optioncode\":\"PLAT\",\"optionquantity\":1,\"fieldoptionlinkid\":8249,\"forchildfieldoptionlinkid\":\"5_3_8249_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0}],\"editablecolumns\":[],\"subfieldlinkid\":2900,\"forchildsubfieldlinkid\":\"5_2_2900_1\",\"optionsselectedcolumns\":{\"optionid\":\"Option Id\",\"optionname\":\"Color Name\",\"optioncode\":\"Color Code\"},\"optiondefault\":\"8248\",\"value\":null,\"issubfabric\":0,\"masterparentfieldid\":1047,\"hasstock\":1,\"subchild\":[],\"supplierid\":\"0\",\"editruleoverride\":1,\"linktopricegroup\":0,\"dualseq\":1,\"fieldInformation\":null,\"multiseq\":0,\"dumydata\":[],\"blindswidth\":0,\"stock_not_available_err\":false,\"stock_not_available_name_array\":[]}],\"fieldInformation\":null,\"optiondefault\":\"2900\",\"optionsvalue\":[{\"optionid\":2900,\"optionname\":\"Alta Blackout\",\"optioncode\":\"ROBALBO\",\"optionquantity\":1,\"fieldoptionlinkid\":2900,\"forchildfieldoptionlinkid\":\"5_2_2900_1\",\"optionimage\":null,\"subdatacount\":1,\"fabricmapid\":2900,\"pricegroup\":\"FB Band D\",\"pricegroupid\":243}],\"editruleoverride\":1},{\"id\":3757,\"labelname\":\"Color\",\"value\":\"Frost\",\"valueid\":\"8248\",\"type\":5,\"optionid\":\"8248\",\"optionvalue\":[{\"optionid\":8248,\"optionname\":\"Frost\",\"optioncode\":\"FROS\",\"optionquantity\":1,\"fieldoptionlinkid\":8248,\"forchildfieldoptionlinkid\":\"5_3_8248_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0}],\"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\":3757,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"8248\",\"optionsvalue\":[{\"optionid\":8248,\"optionname\":\"Frost\",\"optioncode\":\"FROS\",\"optionquantity\":1,\"fieldoptionlinkid\":8248,\"forchildfieldoptionlinkid\":\"5_3_8248_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0}],\"editruleoverride\":1},{\"id\":267,\"labelname\":\"Scallops\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Scallops\",\"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\":\"Scallops\",\"fieldid\":267,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":268,\"labelname\":\"Control Type\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Control 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\":3,\"mandatory\":0,\"fieldname\":\"Control Type\",\"fieldid\":268,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":269,\"labelname\":\"Control Side\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Control Side\",\"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\":\"Control Side\",\"fieldid\":269,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":270,\"labelname\":\"System Type\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"System 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\":3,\"mandatory\":0,\"fieldname\":\"System Type\",\"fieldid\":270,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":272,\"labelname\":\"Reverse Roll\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Reverse Roll\",\"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\":\"Reverse Roll\",\"fieldid\":272,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":273,\"labelname\":\"Cassette\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Cassette\",\"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\":\"Cassette\",\"fieldid\":273,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":274,\"labelname\":\"Motorization\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Motorization\",\"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\":\"Motorization\",\"fieldid\":274,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":275,\"labelname\":\"Extras\",\"value\":\"Test Tube\",\"valueid\":\"19666\",\"type\":3,\"optionid\":\"4773\",\"optionvalue\":[{\"optionid\":4773,\"optionqty\":\"1\",\"optionname\":\"Test Tube\",\"optioncode\":null,\"description\":null,\"pricegroups\":null,\"unittype\":\"mm\",\"unitcost\":10,\"fieldoptionlinkid\":19666,\"forchildfieldoptionlinkid\":\"3_19666\",\"hasstock\":1,\"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\":\"Extras\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":1,\"fieldname\":\"Extras\",\"fieldid\":275,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"4773\",\"optionsvalue\":[{\"optionid\":4773,\"optionqty\":\"1\",\"optionname\":\"Test Tube\",\"optioncode\":null,\"description\":null,\"pricegroups\":null,\"unittype\":\"mm\",\"unitcost\":10,\"fieldoptionlinkid\":19666,\"forchildfieldoptionlinkid\":\"3_19666\",\"hasstock\":1,\"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\":277,\"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\":277,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Supplier: Decora, Width: 1000, Drop: 2000, Product Type: FB Band D, Fabric: Alta Blackout, Color: Frost, Extras: Test Tube", "oi_reportdescription": "##Quantity: 1##,##Supplier: Decora##,##Width: 1000 mm##,##Drop: 2000 mm##,##Product Type: FB Band D##,##Fabric: Alta Blackout##,##Color: Frost##,##Extras: Test Tube##", "oi_reporttitles": "##Quantity:<\/br>##Supplier:<\/br>##Width:<\/br>##Drop:<\/br>##Product Type:<\/br>##Fabric:<\/br>##Color:<\/br>##Extras:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":1,\"value\":\"2.01\",\"formula\":\"Alloutputunit(Quantity_OptimizedFabricQty)*Quantity\",\"price\":\"40.26\",\"recipeid\":18,\"stockupdate\":0,\"fieldid\":\"8248\",\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"2.01\"},{\"productionoveride\":0,\"id\":1285,\"value\":\"1.00\",\"formula\":\"Width*Quantity\",\"price\":\"10.00\",\"recipeid\":18,\"stockupdate\":0,\"fieldid\":19666,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Test Tube\",\"list_option_name\":\"Test Tube\",\"list_description\":null,\"list_option_code\":null,\"list_unit_type\":\"mm\",\"fractionvalue\":\"1.00\"},{\"productionoveride\":0,\"id\":1286,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":18,\"stockupdate\":0,\"fieldid\":19667,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Tube 2\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":1287,\"value\":null,\"formula\":\"Quantity*Width\",\"price\":null,\"recipeid\":18,\"stockupdate\":0,\"fieldid\":19668,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Tube 3\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":26,\"value\":null,\"formula\":\"\\\"Decora\\\"\",\"price\":null,\"recipeid\":18,\"stockupdate\":0,\"fieldid\":11260,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"optionname79\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":2367,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":18,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":698,\"value\":\"0.990\",\"formula\":\"Width-Alloutputunit(10)\",\"price\":null,\"recipeid\":18,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"0.990\"},{\"productionoveride\":0,\"id\":699,\"value\":\"1.980\",\"formula\":\"Drop-Alloutputunit(20)\",\"price\":null,\"recipeid\":18,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"1.980\"},{\"productionoveride\":0,\"id\":700,\"value\":\"1.00\",\"formula\":\"Quantity\",\"price\":\"-\",\"recipeid\":18,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":\"1.00\"}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[{\"link_id\":186,\"process_id\":116,\"product_id\":18,\"phc_id\":186,\"pd_id\":116,\"name\":\"Assemble\",\"phc_linkstations\":3,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":1,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"12.00\",\"phc_contractsellingprice\":\"12.00\",\"phc_tradesellingprice\":\"12.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"12.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"12.00\",\"Hour\\\/mins\":\"15 mins\",\"phc_processcostid\":1,\"markupprice\":\"12.00\",\"price\":\"0.00\"},{\"link_id\":69,\"process_id\":42,\"product_id\":18,\"phc_id\":69,\"pd_id\":42,\"name\":\"Stock pick\",\"phc_linkstations\":2,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":1,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"12.00\",\"phc_contractsellingprice\":\"12.00\",\"phc_tradesellingprice\":\"12.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"12.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"12.00\",\"Hour\\\/mins\":\"15 mins\",\"phc_processcostid\":1,\"markupprice\":\"12.00\",\"price\":\"0.00\"},{\"link_id\":340,\"process_id\":186,\"product_id\":18,\"phc_id\":340,\"pd_id\":186,\"name\":\"dfsg\",\"phc_linkstations\":33,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"0.00\",\"phc_contractsellingprice\":\"0.00\",\"phc_tradesellingprice\":\"0.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"0.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"0.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"0.00\",\"price\":\"0.00\"},{\"link_id\":184,\"process_id\":114,\"product_id\":18,\"phc_id\":184,\"pd_id\":114,\"name\":\"Fabric cut\",\"phc_linkstations\":18,\"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\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"10.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"10.00\",\"Hour\\\/mins\":\"45 mins\",\"phc_processcostid\":1,\"markupprice\":\"10.00\",\"price\":\"0.00\"},{\"link_id\":185,\"process_id\":115,\"product_id\":18,\"phc_id\":185,\"pd_id\":115,\"name\":\"Tube Cut\",\"phc_linkstations\":19,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":1,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"20.00\",\"phc_contractsellingprice\":\"20.00\",\"phc_tradesellingprice\":\"20.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"20.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"20.00\",\"Hour\\\/mins\":\"50 mins\",\"phc_processcostid\":1,\"markupprice\":\"20.00\",\"price\":\"0.00\"},{\"link_id\":68,\"process_id\":41,\"product_id\":18,\"phc_id\":68,\"pd_id\":41,\"name\":\"Office check\",\"phc_linkstations\":1,\"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\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"10.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"10.00\",\"Hour\\\/mins\":\"30 mins\",\"phc_processcostid\":1,\"markupprice\":\"10.00\",\"price\":\"0.00\"}]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"64.00\",\"cost_with_discount\":\"64.00\",\"cost_with_markup\":\"64.00\",\"gross_price\":\"69.84\",\"vat_price\":\"5.84\"}", "oi_pricecomesfrom_calculations": "[]", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "114.260", "oi_netprice": "114.260", "oi_pricesfromoperations": null, "oi_vatprice": "10.430", "oi_vatvalue": "9.125", "oi_vatselected": 44, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "124.690", "oi_overrideprice": "0.000", "oi_overridetype": 1, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "114.260", "oi_endcustomeroverridevatprice": "10.430", "oi_endcustomeroverridegrossprice": "124.690", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[15104, 260, 261, 263, 264, 265, 266, 262, 1047, 3757, 267, 268, 269, 270, 272, 273, 274, 275, 277]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "6562", "oi_productiondate": 1743514964, "oi_createdat": 1743514964, "oi_updatedat": 1743495202, "oi_createdby": 1, "oi_updatedby": 1 }, { "oi_id": 6565, "oi_jobid": 2774, "oi_jobtempid": "0", "oi_jobmultiquoteid": 2796, "oi_productid": 479, "oi_recipeid": 626, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":20795,\"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\":20795,\"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\":20794,\"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\":20794,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":20796,\"labelname\":\"Supplier\",\"value\":null,\"valueid\":null,\"type\":17,\"optionid\":null,\"optionvalue\":[],\"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\":20796,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":20797,\"labelname\":\"Room\",\"value\":\"8\",\"valueid\":null,\"type\":4,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Room\",\"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\":1,\"fieldname\":\"Room\",\"fieldid\":20797,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Room: 8", "oi_reportdescription": "##Quantity: 1##,##Room: 8##", "oi_reporttitles": "##Quantity:<\/br>##Room:", "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}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"0.00\",\"cost_with_discount\":\"0.00\",\"cost_with_markup\":\"0.00\",\"gross_price\":\"0.00\",\"vat_price\":\"0.00\"}", "oi_pricecomesfrom_calculations": "{\"label\":\"Price table cost\",\"unit_type\":\"-\",\"cost_price\":\"0.00\",\"show_hide\":true,\"category\":3}", "oi_productionstatus": null, "oi_costoverride": 1, "oi_costprice": "500.000", "oi_netprice": "500.000", "oi_pricesfromoperations": null, "oi_vatprice": "45.630", "oi_vatvalue": "9.125", "oi_vatselected": 44, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "545.630", "oi_overrideprice": "0.000", "oi_overridetype": 1, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "500.000", "oi_endcustomeroverridevatprice": "45.630", "oi_endcustomeroverridegrossprice": "545.630", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[20795, 20794, 20796, 20797]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "6565", "oi_productiondate": 1743465600, "oi_createdat": 1743515517, "oi_updatedat": 1743496266, "oi_createdby": 1, "oi_updatedby": 1 }, { "oi_id": 6569, "oi_jobid": 2776, "oi_jobtempid": "0", "oi_jobmultiquoteid": 2798, "oi_productid": 558, "oi_recipeid": 711, "oi_ruleid": 0, "oi_qty": 2, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":24667,\"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\":24666,\"labelname\":\"Quantity\",\"value\":\"2\",\"valueid\":\"\",\"type\":14,\"optionid\":\"1\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":24668,\"labelname\":\"Supplier\",\"value\":\"2\",\"valueid\":\"\",\"type\":17,\"optionid\":\"2\",\"optionvalue\":[{\"id\":2,\"optionid\":2,\"optionname\":\"Decora\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":24669,\"labelname\":\"Width\",\"value\":\"400\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":24670,\"labelname\":\"Drop\",\"value\":\"543\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":24671,\"labelname\":\"Price band\",\"value\":1427,\"valueid\":\"2087\",\"type\":13,\"optionid\":\"1427\",\"optionvalue\":[{\"id\":2087,\"fieldid\":24671,\"fieldoptionlinkid\":2087,\"optionid\":1427,\"mainsupplier\":\"2\",\"blindtypecode\":\"\",\"optionname\":\"PRICE RANGE AAA\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":24672,\"labelname\":\"Fabric\",\"value\":\"sdffd\",\"valueid\":\"6572\",\"type\":5,\"optionid\":\"6572\",\"optionvalue\":[{\"optionid\":6572,\"optionname\":\"sdffd\",\"optioncode\":\"\",\"optionquantity\":1,\"fieldoptionlinkid\":6572,\"forchildfieldoptionlinkid\":\"5_2_6572_1\",\"subdatacount\":1,\"optionimage\":\"\",\"description\":\"\",\"pricegroup\":\"PRICE RANGE AAA\",\"pricegroupid\":1427}],\"fabricorcolor\":1,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":24673,\"labelname\":\"Color\",\"value\":\"REd\",\"valueid\":\"30515\",\"type\":5,\"optionid\":\"30515\",\"optionvalue\":[{\"optionid\":30515,\"optionname\":\"REd\",\"optioncode\":\"\",\"optionquantity\":1,\"fieldoptionlinkid\":30515,\"forchildfieldoptionlinkid\":\"5_30515\",\"minimumdiscount\":\"\",\"maximumdiscount\":\"\",\"subdatacount\":0,\"optionimage\":\"\",\"description\":\"\"}],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":24674,\"labelname\":\"Extras\",\"value\":\" Athracite Grey\",\"valueid\":\"28850\",\"type\":3,\"optionid\":\"4485\",\"optionvalue\":[{\"optionid\":4485,\"optionname\":\" Athracite Grey\",\"description\":\"\",\"optioncode\":\"SLX-CAS-R18\",\"pricegroups\":\"25mm Band A,25mm Band B,25mm Band C,25mm Beadfit Band A,25mm Beadfit Band B,16mm Beadfit Band A,16mm Beadfit Band B,25mm Perforated Beadfit Band C,25mm Wood Effect Beadfit Band C,25mm Textured Beadfit Band C,25mm Perforated Beadfit Band D,25mm Wood Effect Beadfit Band D,25mm Textured Beadfit Band D,25mm Privacy Band A,25mm Privacy Band B,25mm Perforated Privacy Band C,25mm Wood Effect Privacy Band C,25mm Textured Privacy Band C,25mm Perforated Privacy Band D,25mm Wood Effect Privacy Band D,25mm Textured Privacy Band D,16mm Screwfit Band A,16mm Screwfit Band B,25mm Screwfit Band A,25mm Screwfit Band B,25mm Perforated Screwfit Band C,25mm Wood Effect Screwfit Band C,25mm Textured Screwfit Band C,25mm Perforated Screwfit Band D,25mm Wood Effect Screwfit Band D,25mm Textured Screwfit Band D,dr,Sampl Price table\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":28850,\"forchildfieldoptionlinkid\":\"3_28850\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"12.00\",\"fieldid\":28850}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":24675,\"labelname\":\"fff\",\"value\":\"\",\"valueid\":\"\",\"type\":4,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":24676,\"labelname\":\"fg\",\"value\":\"\",\"valueid\":\"\",\"type\":29,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]", "oi_description": "Unit Type: mm, Quantity: 2, Supplier: Decora, Width: 400, Drop: 543, Fabric: sdffd, Color: REd, Extras: Athracite Grey", "oi_reportdescription": "##Quantity: 2##,##Supplier: Decora##,##Width: 400 mm##,##Drop: 543 mm##,##Fabric: sdffd##,##Color: REd##,##Extras: Athracite Grey##", "oi_reporttitles": "##Quantity:##Supplier:##Width:##Drop:##Fabric:##Color:##Extras:", "oi_productionformulajsondata": "[]", "oi_operationstatus": null, "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "[]", "oi_pricecomesfrom_calculations": "{}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "20.000", "oi_netprice": "44.000", "oi_pricesfromoperations": null, "oi_vatprice": "4.020", "oi_vatvalue": "9.125", "oi_vatselected": 44, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "48.020", "oi_overrideprice": "0.000", "oi_overridetype": 1, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "44.000", "oi_endcustomeroverridevatprice": "4.020", "oi_endcustomeroverridegrossprice": "48.020", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[24667, 24666, 24668, 24669, 24670, 24671, 24672, 24673, 24674, 24675, 24676]", "oi_deviceplatform": 2, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "6569", "oi_productiondate": 1743516386, "oi_createdat": 1743516386, "oi_updatedat": 1743507024, "oi_createdby": 1, "oi_updatedby": 1 }, { "oi_id": 6570, "oi_jobid": 2777, "oi_jobtempid": "0", "oi_jobmultiquoteid": 2799, "oi_productid": 56, "oi_recipeid": 57, "oi_ruleid": 0, "oi_qty": 5, "oi_seq": 0, "oi_customseq": 0, "oi_productcustomseq": 0, "oi_jsondata": "[{\"id\":15140,\"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\":7004,\"labelname\":\"Quantity\",\"value\":\"5\",\"valueid\":\"\",\"type\":14,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":7005,\"labelname\":\"Manufacturer\",\"value\":\"2\",\"valueid\":\"\",\"type\":17,\"optionid\":\"2\",\"optionvalue\":[{\"id\":2,\"optionid\":2,\"optionname\":\"Decora\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":7010,\"labelname\":\"Width\",\"value\":\"100\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":7011,\"labelname\":\"Drop\",\"value\":\"100\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":7006,\"labelname\":\"Fabric\",\"value\":\"Lead Fab,Lead Fab\",\"valueid\":\"4634,4634\",\"type\":22,\"optionid\":\"4634\",\"optionvalue\":[{\"optionid\":4634,\"optionname\":\"Lead Fab\",\"optioncode\":\"\",\"optionquantity\":1,\"fieldoptionlinkid\":4634,\"forchildfieldoptionlinkid\":\"22_2_4634_0\",\"optionimage\":\"\",\"subdatacount\":1,\"pricegroup\":\"Curt A\",\"pricegroupid\":650},{\"optionid\":4634,\"optionname\":\"Lead Fab\",\"optioncode\":\"\",\"optionquantity\":1,\"fieldoptionlinkid\":4634,\"forchildfieldoptionlinkid\":\"22_2_4634_0\",\"optionimage\":\"\",\"subdatacount\":1,\"pricegroup\":\"Curt B\",\"pricegroupid\":844}],\"fabricorcolor\":1,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\",\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":13104,\"labelname\":\"Color\",\"value\":\"-\",\"valueid\":\"19268\",\"type\":22,\"optionid\":\"19268\",\"optionvalue\":[{\"optionid\":19268,\"optionname\":\"-\",\"optioncode\":\"\",\"optionquantity\":1,\"fieldoptionlinkid\":19268,\"forchildfieldoptionlinkid\":\"22_3_19268_0\",\"minimumdiscount\":\"\",\"maximumdiscount\":\"\",\"optionimage\":\"\",\"subdatacount\":0}],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":7008,\"labelname\":\"Product Type\",\"value\":650,\"valueid\":\"682\",\"type\":13,\"optionid\":\"650\",\"optionvalue\":[{\"id\":682,\"fieldid\":7008,\"fieldoptionlinkid\":682,\"optionid\":650,\"mainsupplier\":\"2\",\"blindtypecode\":\"\",\"optionname\":\"Curt A\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":7009,\"labelname\":\"Lining\",\"value\":\"One\",\"valueid\":\"11268\",\"type\":2,\"optionid\":\"3437\",\"optionvalue\":[{\"optionid\":3437,\"fieldoptionlinkid\":11268,\"op_filterbypricegroup\":0,\"forchildfieldoptionlinkid\":\"2.0_11268.0\",\"id\":11268,\"subdatacount\":0,\"hasprice\":0,\"fieldtypeid\":2,\"optionimage\":\"\/storage\/attachments\/TESTING2_TEST\/optionImages\/3437_option_304.jpg\",\"optionname\":\"One\",\"liningcode\":\"1\",\"makeupperwidth\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":8276,\"labelname\":\"Sub Field\",\"value\":\"Sub\",\"valueid\":\"12021\",\"type\":3,\"optionid\":\"3808\",\"optionvalue\":[{\"optionid\":3808,\"optionname\":\"Sub\",\"description\":\"\",\"optioncode\":\"15\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":12021,\"forchildfieldoptionlinkid\":\"3_12021\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":1,\"optionimage\":\"\/storage\/attachments\/TESTING2_TEST\/optionImages\/3808_option_290.jpg\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":8277,\"labelname\":\"Sub field 1\",\"value\":\"Sub Sub field 1\",\"valueid\":\"12023\",\"type\":3,\"optionid\":\"3809\",\"optionvalue\":[{\"optionid\":3809,\"optionname\":\"Sub Sub field 1\",\"description\":\"\",\"optioncode\":\"11\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":12023,\"forchildfieldoptionlinkid\":\"3_12023\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":1,\"optionimage\":\"\/storage\/attachments\/TESTING2_TEST\/optionImages\/3809_option_290.jpg\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":8278,\"labelname\":\"Sub field 2\",\"value\":\"Sub Sub Field 2\",\"valueid\":\"12025\",\"type\":3,\"optionid\":\"3810\",\"optionvalue\":[{\"optionid\":3810,\"optionname\":\"Sub Sub Field 2\",\"description\":\"\",\"optioncode\":\"13\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":12025,\"forchildfieldoptionlinkid\":\"3_12025\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":1,\"optionimage\":\"\/storage\/attachments\/TESTING2_TEST\/optionImages\/3810_option_290.jpg\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":8279,\"labelname\":\"Sub field 3\",\"value\":\"Sub Sub filed 3\",\"valueid\":\"12027\",\"type\":3,\"optionid\":\"3811\",\"optionvalue\":[{\"optionid\":3811,\"optionname\":\"Sub Sub filed 3\",\"description\":\"\",\"optioncode\":\"14\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":12027,\"forchildfieldoptionlinkid\":\"3_12027\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\/storage\/attachments\/TESTING2_TEST\/optionImages\/3811_option_290.jpg\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1}]", "oi_description": "Unit Type: mm, Quantity: 5, Manufacturer: Decora, Width: 100, Drop: 100, Fabric: Lead Fab,Lead Fab, Color: -, Product Type: Curt A, Lining: One, Sub Field: Sub, Sub field 1: Sub Sub field 1, Sub field 2: Sub Sub Field 2, Sub field 3: Sub Sub filed 3", "oi_reportdescription": "##Quantity: 5##,##Manufacturer: Decora##,##Width: 100 mm##,##Drop: 100 mm##,##Fabric: Lead Fab,Lead Fab##,##Color: -##,##Product Type: Curt A##,##Lining: One##,##Sub Field: Sub##,##Sub field 1: Sub Sub field 1##,##Sub field 2: Sub Sub Field 2##,##Sub field 3: Sub Sub filed 3##", "oi_reporttitles": "##Quantity:##Manufacturer:##Width:##Drop:##Fabric:##Color:##Product Type:##Lining:##Sub Field:##Sub field 1:##Sub field 2:##Sub field 3:", "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": "252.750", "oi_netprice": "252.750", "oi_pricesfromoperations": null, "oi_vatprice": "23.060", "oi_vatvalue": "9.125", "oi_vatselected": 44, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "275.810", "oi_overrideprice": "0.000", "oi_overridetype": 1, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 0, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "0.000", "oi_endcustomeroverridevatprice": "0.000", "oi_endcustomeroverridegrossprice": "0.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[15140, 7004, 7005, 7010, 7011, 7006, 13104, 7008, 7009, 8276, 8277, 8278, 8279]", "oi_deviceplatform": 1, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "6570", "oi_productiondate": 1743508034, "oi_createdat": 1743508163, "oi_updatedat": null, "oi_createdby": 9, "oi_updatedby": null } ], "updated": [ { "oi_id": 6569, "oi_jobid": 2776, "oi_jobtempid": "0", "oi_jobmultiquoteid": 2798, "oi_productid": 558, "oi_recipeid": 711, "oi_ruleid": 0, "oi_qty": 2, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":24667,\"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\":24666,\"labelname\":\"Quantity\",\"value\":\"2\",\"valueid\":\"\",\"type\":14,\"optionid\":\"1\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":24668,\"labelname\":\"Supplier\",\"value\":\"2\",\"valueid\":\"\",\"type\":17,\"optionid\":\"2\",\"optionvalue\":[{\"id\":2,\"optionid\":2,\"optionname\":\"Decora\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":24669,\"labelname\":\"Width\",\"value\":\"400\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":24670,\"labelname\":\"Drop\",\"value\":\"543\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":24671,\"labelname\":\"Price band\",\"value\":1427,\"valueid\":\"2087\",\"type\":13,\"optionid\":\"1427\",\"optionvalue\":[{\"id\":2087,\"fieldid\":24671,\"fieldoptionlinkid\":2087,\"optionid\":1427,\"mainsupplier\":\"2\",\"blindtypecode\":\"\",\"optionname\":\"PRICE RANGE AAA\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":24672,\"labelname\":\"Fabric\",\"value\":\"sdffd\",\"valueid\":\"6572\",\"type\":5,\"optionid\":\"6572\",\"optionvalue\":[{\"optionid\":6572,\"optionname\":\"sdffd\",\"optioncode\":\"\",\"optionquantity\":1,\"fieldoptionlinkid\":6572,\"forchildfieldoptionlinkid\":\"5_2_6572_1\",\"subdatacount\":1,\"optionimage\":\"\",\"description\":\"\",\"pricegroup\":\"PRICE RANGE AAA\",\"pricegroupid\":1427}],\"fabricorcolor\":1,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":24673,\"labelname\":\"Color\",\"value\":\"REd\",\"valueid\":\"30515\",\"type\":5,\"optionid\":\"30515\",\"optionvalue\":[{\"optionid\":30515,\"optionname\":\"REd\",\"optioncode\":\"\",\"optionquantity\":1,\"fieldoptionlinkid\":30515,\"forchildfieldoptionlinkid\":\"5_30515\",\"minimumdiscount\":\"\",\"maximumdiscount\":\"\",\"subdatacount\":0,\"optionimage\":\"\",\"description\":\"\"}],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":24674,\"labelname\":\"Extras\",\"value\":\" Athracite Grey\",\"valueid\":\"28850\",\"type\":3,\"optionid\":\"4485\",\"optionvalue\":[{\"optionid\":4485,\"optionname\":\" Athracite Grey\",\"description\":\"\",\"optioncode\":\"SLX-CAS-R18\",\"pricegroups\":\"25mm Band A,25mm Band B,25mm Band C,25mm Beadfit Band A,25mm Beadfit Band B,16mm Beadfit Band A,16mm Beadfit Band B,25mm Perforated Beadfit Band C,25mm Wood Effect Beadfit Band C,25mm Textured Beadfit Band C,25mm Perforated Beadfit Band D,25mm Wood Effect Beadfit Band D,25mm Textured Beadfit Band D,25mm Privacy Band A,25mm Privacy Band B,25mm Perforated Privacy Band C,25mm Wood Effect Privacy Band C,25mm Textured Privacy Band C,25mm Perforated Privacy Band D,25mm Wood Effect Privacy Band D,25mm Textured Privacy Band D,16mm Screwfit Band A,16mm Screwfit Band B,25mm Screwfit Band A,25mm Screwfit Band B,25mm Perforated Screwfit Band C,25mm Wood Effect Screwfit Band C,25mm Textured Screwfit Band C,25mm Perforated Screwfit Band D,25mm Wood Effect Screwfit Band D,25mm Textured Screwfit Band D,dr,Sampl Price table\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":28850,\"forchildfieldoptionlinkid\":\"3_28850\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"12.00\",\"fieldid\":28850}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":24675,\"labelname\":\"fff\",\"value\":\"\",\"valueid\":\"\",\"type\":4,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":24676,\"labelname\":\"fg\",\"value\":\"\",\"valueid\":\"\",\"type\":29,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]", "oi_description": "Unit Type: mm, Quantity: 2, Supplier: Decora, Width: 400, Drop: 543, Fabric: sdffd, Color: REd, Extras: Athracite Grey", "oi_reportdescription": "##Quantity: 2##,##Supplier: Decora##,##Width: 400 mm##,##Drop: 543 mm##,##Fabric: sdffd##,##Color: REd##,##Extras: Athracite Grey##", "oi_reporttitles": "##Quantity:##Supplier:##Width:##Drop:##Fabric:##Color:##Extras:", "oi_productionformulajsondata": "[]", "oi_operationstatus": null, "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "[]", "oi_pricecomesfrom_calculations": "{}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "20.000", "oi_netprice": "44.000", "oi_pricesfromoperations": null, "oi_vatprice": "4.020", "oi_vatvalue": "9.125", "oi_vatselected": 44, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "48.020", "oi_overrideprice": "0.000", "oi_overridetype": 1, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "44.000", "oi_endcustomeroverridevatprice": "4.020", "oi_endcustomeroverridegrossprice": "48.020", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[24667, 24666, 24668, 24669, 24670, 24671, 24672, 24673, 24674, 24675, 24676]", "oi_deviceplatform": 2, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "6569", "oi_productiondate": 1743516386, "oi_createdat": 1743516386, "oi_updatedat": 1743507024, "oi_createdby": 1, "oi_updatedby": 1 } ], "deleted": [] }, "bm_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_notelist": { "created": [], "updated": [], "deleted": [] }, "bm_deliveryaddresssetting": { "created": [], "updated": [], "deleted": [] }, "bm_jobchecklist": { "created": [], "updated": [], "deleted": [] }, "bm_Invoice": { "created": [], "updated": [], "deleted": [] }, "bm_InvoiceDetails": { "created": [], "updated": [], "deleted": [] }, "bm_invoice_credit_note": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNote": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNoteDetails": { "created": [], "updated": [], "deleted": [] }, "bm_job_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_OverPayment": { "created": [], "updated": [], "deleted": [] }, "bm_terms": { "created": [], "updated": [], "deleted": [] }, "bm_jobmultiquote": { "created": [ { "jmq_id": 2799, "jmq_jobid": 2777, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "252.75", "jmq_netprice": "252.75", "jmq_vat": "23.06", "jmq_isvaton": 1, "jmq_deliverycost": "0.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 1, "jmq_orderformprice": "0.00", "jmq_editpricebyid": null, "jmq_isroundon": 0, "jmq_grossprice": "275.81", "jmq_grossprofit": "0.00", "jmq_costprice": "252.75", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "275.81", "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": "9.125", "jmq_cdeliveryvatperc": "9.125", "id": "2799", "jmq_duedate": 1743465600, "jmq_sceduleddate": null, "jmq_createdat": "1743503328.000000", "jmq_updatedat": "1743508188.000000", "jmq_createdby": 9, "jmq_updatedby": 9 } ], "updated": [ { "jmq_id": 2799, "jmq_jobid": 2777, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "252.75", "jmq_netprice": "252.75", "jmq_vat": "23.06", "jmq_isvaton": 1, "jmq_deliverycost": "0.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 1, "jmq_orderformprice": "0.00", "jmq_editpricebyid": null, "jmq_isroundon": 0, "jmq_grossprice": "275.81", "jmq_grossprofit": "0.00", "jmq_costprice": "252.75", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "275.81", "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": "9.125", "jmq_cdeliveryvatperc": "9.125", "id": "2799", "jmq_duedate": 1743465600, "jmq_sceduleddate": null, "jmq_createdat": "1743503328.000000", "jmq_updatedat": "1743508188.000000", "jmq_createdby": 9, "jmq_updatedby": 9 } ], "deleted": [] }, "bm_jobstatus_tracks": { "created": [ { "jst_id": 2961, "jst_jobid": 2777, "jst_job_current_status": 3, "id": "2961", "jst_createdat": "1743508187.873291" } ], "updated": [], "deleted": [] }, "bm_customindividuallogs": { "created": [ { "cl_id": 47506, "cl_logname": "default", "cl_type": null, "cl_modulename": "All Jobs", "cl_message": "Quotation report generated by Pruthvi All Jobs", "cl_event": "created", "cl_subjectid": 1419, "cl_subjecttype": "App\\Models\\Reports\\bm_reportactivitylog", "cl_parentid": 2147483647, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 9, "cl_changedfrom": "null", "cl_changedto": "{\"Category: \":\"Quotation\"}", "cl_customproperties": "{\"attributes\":{\"ral_id\":1419,\"ral_jobid\":2147483647,\"ral_reportid\":1,\"ral_categoryid\":1,\"ral_description\":\"Quotation report generated by Pruthvi\",\"ral_attachment\":\"\",\"ral_actionid\":1,\"ral_createdat\":\"2025-04-01T10:50:55.000000Z\",\"ral_updatedat\":\"2025-04-01T10:50:55.000000Z\",\"ral_createdby\":9,\"ral_updatedby\":null}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "47506", "cl_createdat": "1743504655.000000", "cl_updatedat": null }, { "cl_id": 47507, "cl_logname": "default", "cl_type": null, "cl_modulename": "All Jobs", "cl_message": "Quotation report generated by Pruthvi All Jobs", "cl_event": "created", "cl_subjectid": 1420, "cl_subjecttype": "App\\Models\\Reports\\bm_reportactivitylog", "cl_parentid": 2147483647, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 9, "cl_changedfrom": "null", "cl_changedto": "{\"Category: \":\"Quotation\"}", "cl_customproperties": "{\"attributes\":{\"ral_id\":1420,\"ral_jobid\":2147483647,\"ral_reportid\":1,\"ral_categoryid\":1,\"ral_description\":\"Quotation report generated by Pruthvi\",\"ral_attachment\":\"\",\"ral_actionid\":1,\"ral_createdat\":\"2025-04-01T10:51:04.000000Z\",\"ral_updatedat\":\"2025-04-01T10:51:04.000000Z\",\"ral_createdby\":9,\"ral_updatedby\":null}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "47507", "cl_createdat": "1743504664.000000", "cl_updatedat": null }, { "cl_id": 47508, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 2777, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 2777, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 9, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"Blind Design (uk) Ltd\",\"\":2,\"Account Type\":\"Domestic\",\"Source\":\"WEB\",\"Created By\":\"Pruthvi\",\"First Name\":\"Offline@8\",\"Country\":\"USA\",\"Salutation\":\"Mr.\",\"Check Box6\":\"Disabled\",\"Check Box5\":\"Disabled\",\"Assigned to\":9,\"Role\":1,\"Date4\":\"2025-04-01\",\"Additional Contacts\":\"2738\",\"Production Due Date\":\"2025-03-31\",\"Job Ref No\":\"BD2667\",\"Job Status\":\"Quote\",\"Order Status\":\"Ready to Start\",\"Net Price\":\"252.75\",\"VAT Price\":\"23.06\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"Gross Price Amount\":\"275.81\",\"Total CostPrice\":\"252.75\",\"Amount Outstanding\":\"275.81\",\"jd_isonlineorder\":1,\"Delivery Vat Percentage\":\"9.125\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":2777,\"jd_customerid\":1490,\"jd_contactid\":2738,\"jd_additionalcontacts\":\"2738\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"BD2667\\\",\\\"35\\\":\\\"OFFL0010\\\",\\\"36\\\":3,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":23,\\\"40\\\":2,\\\"41\\\":9,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"Offline@8\\\",\\\"46\\\":\\\"\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":35,\\\"285\\\":1,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"470\\\":\\\"\\\",\\\"477\\\":\\\"\\\",\\\"584\\\":\\\"\\\",\\\"605\\\":\\\"\\\",\\\"606\\\":\\\"\\\",\\\"608\\\":9,\\\"633\\\":1,\\\"705\\\":\\\"\\\",\\\"718\\\":1,\\\"757\\\":1}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-04-01\",\"jd_orderdate\":null,\"jd_duedate\":\"2025-03-31\",\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":null,\"jd_jobref\":\"BD2667\",\"jd_jobstatus\":3,\"jd_contactaddid\":0,\"jd_orderstatus\":2,\"jd_accref\":\"OFFL0010\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"252.75\",\"jd_netprice\":\"252.75\",\"jd_vat\":\"23.06\",\"jd_isvaton\":1,\"jd_deliverycost\":\"0.00\",\"jd_deliverycosttypeid\":1,\"jd_overridetypeid\":1,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":null,\"jd_isroundon\":0,\"jd_grossprice\":\"275.81\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"252.75\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"275.81\",\"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\":9,\"jd_createdat\":\"2025-04-01T10:28:48.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-04-01T11:49:47.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\":\"9.125\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"9.125\",\"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": "47508", "cl_createdat": "1743508187.000000", "cl_updatedat": null }, { "cl_id": 47509, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in BD2667", "cl_event": "created", "cl_subjectid": 2799, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 2777, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 9, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":2799,\"jmq_jobid\":2777,\"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\":\"252.75\",\"Net Price\":\"252.75\",\"VAT Price\":\"23.06\",\"VAT\":1,\"jmq_deliverycost\":\"0.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"275.81\",\"Gross Profit\":\"0.00\",\"Total CostPrice\":\"252.75\",\"Amount Outstanding\":\"275.81\",\"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\":\"9.125\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":2799,\"jmq_jobid\":2777,\"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\":\"252.75\",\"jmq_netprice\":\"252.75\",\"jmq_vat\":\"23.06\",\"jmq_isvaton\":1,\"jmq_deliverycost\":\"0.00\",\"jmq_deliverycosttypeid\":1,\"jmq_overridetypeid\":1,\"jmq_orderformprice\":\"0.00\",\"jmq_editpricebyid\":null,\"jmq_isroundon\":0,\"jmq_grossprice\":\"275.81\",\"jmq_grossprofit\":\"0.00\",\"jmq_costprice\":\"252.75\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"275.81\",\"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\":\"9.125\",\"jmq_cdeliveryvatperc\":\"9.125\",\"jmq_createdby\":9,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-04-01T10:28:48.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": "47509", "cl_createdat": "1743508187.000000", "cl_updatedat": null }, { "cl_id": 47510, "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": 2777, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 2777, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 9, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":2799}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":2799},\"old\":{\"jd_jobmultiquoteid\":null}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "47510", "cl_createdat": "1743508187.000000", "cl_updatedat": null }, { "cl_id": 47511, "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 New Curtain", "cl_event": "created", "cl_subjectid": 6570, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 2777, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 9, "cl_changedfrom": "null", "cl_changedto": "{\"Unit Type\":\" mm\",\" Quantity\":\" 5\",\" Manufacturer\":\" Decora\",\" Width\":\" 100\",\" Drop\":\" 100\",\" Fabric\":\" Lead Fab\",\"Lead Fab\":\"Lead Fab\",\" Color\":\" -\",\" Product Type\":\" Curt A\",\" Lining\":\" One\",\" Sub Field\":\" Sub\",\" Sub field 1\":\" Sub Sub field 1\",\" Sub field 2\":\" Sub Sub Field 2\",\" Sub field 3\":\" Sub Sub filed 3\"}", "cl_customproperties": "{\"attributes\":{\"oi_id\":6570,\"oi_jobid\":2777,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":2799,\"oi_credit_id\":0,\"oi_productid\":56,\"oi_recipeid\":57,\"oi_ruleid\":0,\"oi_qty\":5,\"oi_seq\":0,\"oi_customseq\":0,\"oi_productcustomseq\":0,\"oi_jsondata\":\"[{\\\"id\\\":15140,\\\"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\\\":7004,\\\"labelname\\\":\\\"Quantity\\\",\\\"value\\\":\\\"5\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":14,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":7005,\\\"labelname\\\":\\\"Manufacturer\\\",\\\"value\\\":\\\"2\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":17,\\\"optionid\\\":\\\"2\\\",\\\"optionvalue\\\":[{\\\"id\\\":2,\\\"optionid\\\":2,\\\"optionname\\\":\\\"Decora\\\",\\\"deleted\\\":0,\\\"optionquantity\\\":1}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7010,\\\"labelname\\\":\\\"Width\\\",\\\"value\\\":\\\"100\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":11,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":7011,\\\"labelname\\\":\\\"Drop\\\",\\\"value\\\":\\\"100\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":12,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":7006,\\\"labelname\\\":\\\"Fabric\\\",\\\"value\\\":\\\"Lead Fab,Lead Fab\\\",\\\"valueid\\\":\\\"4634,4634\\\",\\\"type\\\":22,\\\"optionid\\\":\\\"4634\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":4634,\\\"optionname\\\":\\\"Lead Fab\\\",\\\"optioncode\\\":\\\"\\\",\\\"optionquantity\\\":1,\\\"fieldoptionlinkid\\\":4634,\\\"forchildfieldoptionlinkid\\\":\\\"22_2_4634_0\\\",\\\"optionimage\\\":\\\"\\\",\\\"subdatacount\\\":1,\\\"pricegroup\\\":\\\"Curt A\\\",\\\"pricegroupid\\\":650},{\\\"optionid\\\":4634,\\\"optionname\\\":\\\"Lead Fab\\\",\\\"optioncode\\\":\\\"\\\",\\\"optionquantity\\\":1,\\\"fieldoptionlinkid\\\":4634,\\\"forchildfieldoptionlinkid\\\":\\\"22_2_4634_0\\\",\\\"optionimage\\\":\\\"\\\",\\\"subdatacount\\\":1,\\\"pricegroup\\\":\\\"Curt B\\\",\\\"pricegroupid\\\":844}],\\\"fabricorcolor\\\":1,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\",\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":13104,\\\"labelname\\\":\\\"Color\\\",\\\"value\\\":\\\"-\\\",\\\"valueid\\\":\\\"19268\\\",\\\"type\\\":22,\\\"optionid\\\":\\\"19268\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":19268,\\\"optionname\\\":\\\"-\\\",\\\"optioncode\\\":\\\"\\\",\\\"optionquantity\\\":1,\\\"fieldoptionlinkid\\\":19268,\\\"forchildfieldoptionlinkid\\\":\\\"22_3_19268_0\\\",\\\"minimumdiscount\\\":\\\"\\\",\\\"maximumdiscount\\\":\\\"\\\",\\\"optionimage\\\":\\\"\\\",\\\"subdatacount\\\":0}],\\\"fabricorcolor\\\":2,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":7008,\\\"labelname\\\":\\\"Product Type\\\",\\\"value\\\":650,\\\"valueid\\\":\\\"682\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"650\\\",\\\"optionvalue\\\":[{\\\"id\\\":682,\\\"fieldid\\\":7008,\\\"fieldoptionlinkid\\\":682,\\\"optionid\\\":650,\\\"mainsupplier\\\":\\\"2\\\",\\\"blindtypecode\\\":\\\"\\\",\\\"optionname\\\":\\\"Curt A\\\",\\\"optionquantity\\\":1,\\\"subcount\\\":0,\\\"status\\\":0,\\\"subdatacount\\\":0}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7009,\\\"labelname\\\":\\\"Lining\\\",\\\"value\\\":\\\"One\\\",\\\"valueid\\\":\\\"11268\\\",\\\"type\\\":2,\\\"optionid\\\":\\\"3437\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":3437,\\\"fieldoptionlinkid\\\":11268,\\\"op_filterbypricegroup\\\":0,\\\"forchildfieldoptionlinkid\\\":\\\"2.0_11268.0\\\",\\\"id\\\":11268,\\\"subdatacount\\\":0,\\\"hasprice\\\":0,\\\"fieldtypeid\\\":2,\\\"optionimage\\\":\\\"\\\/storage\\\/attachments\\\/TESTING2_TEST\\\/optionImages\\\/3437_option_304.jpg\\\",\\\"optionname\\\":\\\"One\\\",\\\"liningcode\\\":\\\"1\\\",\\\"makeupperwidth\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":8276,\\\"labelname\\\":\\\"Sub Field\\\",\\\"value\\\":\\\"Sub\\\",\\\"valueid\\\":\\\"12021\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"3808\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":3808,\\\"optionname\\\":\\\"Sub\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"15\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":12021,\\\"forchildfieldoptionlinkid\\\":\\\"3_12021\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":1,\\\"optionimage\\\":\\\"\\\/storage\\\/attachments\\\/TESTING2_TEST\\\/optionImages\\\/3808_option_290.jpg\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":8277,\\\"labelname\\\":\\\"Sub field 1\\\",\\\"value\\\":\\\"Sub Sub field 1\\\",\\\"valueid\\\":\\\"12023\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"3809\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":3809,\\\"optionname\\\":\\\"Sub Sub field 1\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"11\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":12023,\\\"forchildfieldoptionlinkid\\\":\\\"3_12023\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":1,\\\"optionimage\\\":\\\"\\\/storage\\\/attachments\\\/TESTING2_TEST\\\/optionImages\\\/3809_option_290.jpg\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":8278,\\\"labelname\\\":\\\"Sub field 2\\\",\\\"value\\\":\\\"Sub Sub Field 2\\\",\\\"valueid\\\":\\\"12025\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"3810\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":3810,\\\"optionname\\\":\\\"Sub Sub Field 2\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"13\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":12025,\\\"forchildfieldoptionlinkid\\\":\\\"3_12025\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":1,\\\"optionimage\\\":\\\"\\\/storage\\\/attachments\\\/TESTING2_TEST\\\/optionImages\\\/3810_option_290.jpg\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":8279,\\\"labelname\\\":\\\"Sub field 3\\\",\\\"value\\\":\\\"Sub Sub filed 3\\\",\\\"valueid\\\":\\\"12027\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"3811\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":3811,\\\"optionname\\\":\\\"Sub Sub filed 3\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"14\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":12027,\\\"forchildfieldoptionlinkid\\\":\\\"3_12027\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\/storage\\\/attachments\\\/TESTING2_TEST\\\/optionImages\\\/3811_option_290.jpg\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1}]\",\"oi_description\":\"Unit Type: mm, Quantity: 5, Manufacturer: Decora, Width: 100, Drop: 100, Fabric: Lead Fab,Lead Fab, Color: -, Product Type: Curt A, Lining: One, Sub Field: Sub, Sub field 1: Sub Sub field 1, Sub field 2: Sub Sub Field 2, Sub field 3: Sub Sub filed 3\",\"oi_onlinedescription\":null,\"oi_imagepath\":null,\"oi_reportdescription\":\"##Quantity: 5##,##Manufacturer: Decora##,##Width: 100 mm##,##Drop: 100 mm##,##Fabric: Lead Fab,Lead Fab##,##Color: -##,##Product Type: Curt A##,##Lining: One##,##Sub Field: Sub##,##Sub field 1: Sub Sub field 1##,##Sub field 2: Sub Sub Field 2##,##Sub field 3: Sub Sub filed 3##\",\"oi_onlinereportdescription\":null,\"oi_reporttitles\":\"##Quantity:##Manufacturer:##Width:##Drop:##Fabric:##Color:##Product Type:##Lining:##Sub Field:##Sub field 1:##Sub field 2:##Sub field 3:\",\"oi_onlinereporttitles\":null,\"oi_productionformulajsondata\":\"[]\",\"oi_productiondate\":\"2025-04-01 11:47:14\",\"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\":\"252.750\",\"oi_netprice\":\"252.750\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"23.060\",\"oi_vatvalue\":\"9.125\",\"oi_vatselected\":44,\"oi_vattype\":1,\"oi_vatonoff\":1,\"oi_grossprice\":\"275.810\",\"oi_overrideprice\":\"0.000\",\"oi_overridetype\":1,\"oi_overridevalue\":null,\"oi_overridenetprice\":\"0.000\",\"oi_overridevatprice\":\"0.000\",\"oi_overridegrossprice\":\"0.000\",\"oi_ready\":0,\"oi_onhold\":0,\"oi_platformcreatedfrom\":\"web\",\"oi_platformlastupdatedfrom\":\"web\",\"oi_copiedfrom\":0,\"oi_isonlineorder\":0,\"oi_endcustomervatprice\":null,\"oi_endcustomeroverridetype\":1,\"oi_endcustomeroverridevalue\":null,\"oi_endcustomeroverridenetprice\":\"0.000\",\"oi_endcustomeroverridevatprice\":\"0.000\",\"oi_endcustomeroverridegrossprice\":\"0.000\",\"oi_sage_flag\":0,\"oi_status\":0,\"oi_createdby\":9,\"oi_createdat\":\"2025-04-01T11:49:23.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":null,\"oi_jsondataid\":\"[15140, 7004, 7005, 7010, 7011, 7006, 13104, 7008, 7009, 8276, 8277, 8278, 8279]\",\"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": "47511", "cl_createdat": "1743508187.000000", "cl_updatedat": null }, { "cl_id": 47512, "cl_logname": "model", "cl_type": null, "cl_modulename": "Production Due Date", "cl_message": "Production Due Date has been updated", "cl_event": "modified", "cl_subjectid": 2777, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 2777, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 9, "cl_changedfrom": "{\"Production Due Date\":\"2025-03-31\"}", "cl_changedto": "{\"Production Due Date\":\"2025-04-01\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "47512", "cl_createdat": "1743508188.000000", "cl_updatedat": null } ], "updated": [], "deleted": [] }, "bm_productInfo": { "created": [], "updated": [ { "pi_productid": 23, "pi_productname": "Vertical blinds 1", "pi_pcode": "505", "pi_custpcode": "", "pi_category": 3, "pi_natureofproduct": "resell", "pi_productgroup": 1, "pi_producttype": 0, "pi_qtyperunit": "0.00", "pi_unitprice": "0.00", "pi_weight": "0.00", "pi_packsize": null, "pi_costfactor": null, "pi_commissionrate": "0.000", "pi_commissionmethod": null, "pi_discontinued": null, "pi_usageunit": null, "pi_handler": null, "pi_reorderlevel": null, "pi_website": null, "pi_taxclass": null, "pi_mfrpartno": null, "pi_vendorpartno": null, "pi_serialno": null, "pi_qtyinstock": null, "pi_productsheet": null, "pi_qtyindemand": null, "pi_glacct": null, "pi_supplierid": null, "pi_imagename": null, "pi_currencyid": null, "pi_supplierdefault": null, "pi_productseqno": null, "pi_domesticmarkup": "0.00", "pi_contractmarkup": "0.00", "pi_trademarkup": "0.00", "pi_childsafe": null, "pi_quantyshowhide": null, "pi_compquantyshowhide": null, "pi_stockcontrol": null, "pi_productiontab": null, "pi_fabriccolorcodehide": null, "pi_defaultunitfornewcurtainsorder": null, "pi_costpricecomesfrom": "1", "pi_netpricecomesfrom": "1", "pi_shuttercontract": "0.00", "pi_shuttertrade": "0.00", "pi_shutterdomestic": "0.00", "pi_shutterecommerce": "0.00", "pi_customerdiscount": null, "pi_discountoverridesubwidth": null, "pi_manufacturer_cost": null, "pi_fabrichide": null, "pi_showhiddencolumn": null, "pi_hidecompparameter": null, "pi_factorybarcodeproduct": null, "pi_showhideproductorder": 1, "pi_ecommercestatus": 1, "pi_productdescription": "", "pi_ecomproductdesc": null, "pi_homeimage": null, "pi_galleryimage": null, "pi_innerpageimage": null, "pi_frameimage": "[]", "pi_ecommercecompmarkup": "0.00", "pi_showframeminmax": null, "pi_fabricdefaultdiscount": null, "pi_productstatusmultiple": null, "pi_followproductionseq": 1, "pi_productionformulasheetname": null, "pi_productrules": null, "pi_showexcelfromula": null, "pi_supplierheading": null, "pi_producttypehide": null, "pi_dualproducttypeheading": "Fabric 2", "pi_fabricheading": null, "pi_dualproducttypeenable": 0, "pi_fabricbeforeproducttype": null, "pi_suppliermandatory": null, "pi_showfabric": null, "pi_ecommercesample": "1", "pi_priceavalcheck": null, "pi_showcomponentcode": null, "pi_showmaxarea": null, "pi_recessallowance": null, "pi_deductionname": null, "pi_deductionvalue": "0.00", "pi_stackqty": null, "pi_blindstype": null, "pi_suppliershowhide": null, "pi_pricealert": null, "pi_metatitle": null, "pi_metadescription": null, "pi_metakeyword": null, "pi_canonicaltag": null, "pi_alttexttag": null, "pi_headertag": "H1", "pi_productimage": "[]", "pi_workroom": 1, "pi_mobileapp": 1, "pi_jobtransfer": 1, "pi_seq": 1, "pi_status": 0, "pi_createdby": 1, "pi_createdat": 1675411553, "pi_defaultunittype": 4, "pi_jobfraction": 4, "pi_unittypeseq": "1,2,4,3", "pi_deafultimage": "{\"defaultimage\":{\"framedefault\":\"\",\"productdefault\":\"\",\"backgrounddefault\":\"roller_23.png\",\"bannerdefault\":\"\"}}", "pi_backgroundimage": "[\"\\\/storage\\\/attachments\\\/TESTING2TEST\\\/productbackgroundimages\\\/23\\\/roller_23.png\"]", "pi_discountappliesto": "{\"optionschk\":1,\"operationschk\":1,\"materialchk\":1}", "pi_ecomProductName": null, "pi_productgroupseq": null, "pi_unitypedata": "{\"1\":1,\"2\":1,\"3\":1,\"4\":1}", "id": "23", "pi_salesstartdate": null, "pi_salesenddate": null, "pi_startdate": null, "pi_expirydate": null, "pi_updatedat": 1743506194, "pi_updatedby": 1 }, { "pi_productid": 41, "pi_productname": "Shutter New", "pi_pcode": "SN", "pi_custpcode": "", "pi_category": 5, "pi_natureofproduct": "resell", "pi_productgroup": 0, "pi_producttype": 0, "pi_qtyperunit": "0.00", "pi_unitprice": "0.00", "pi_weight": "0.00", "pi_packsize": null, "pi_costfactor": null, "pi_commissionrate": "0.000", "pi_commissionmethod": null, "pi_discontinued": null, "pi_usageunit": null, "pi_handler": null, "pi_reorderlevel": null, "pi_website": null, "pi_taxclass": null, "pi_mfrpartno": null, "pi_vendorpartno": null, "pi_serialno": null, "pi_qtyinstock": null, "pi_productsheet": null, "pi_qtyindemand": null, "pi_glacct": null, "pi_supplierid": null, "pi_imagename": null, "pi_currencyid": null, "pi_supplierdefault": null, "pi_productseqno": null, "pi_domesticmarkup": "0.00", "pi_contractmarkup": "0.00", "pi_trademarkup": "0.00", "pi_childsafe": null, "pi_quantyshowhide": null, "pi_compquantyshowhide": null, "pi_stockcontrol": null, "pi_productiontab": null, "pi_fabriccolorcodehide": null, "pi_defaultunitfornewcurtainsorder": null, "pi_costpricecomesfrom": "3", "pi_netpricecomesfrom": "3", "pi_shuttercontract": "0.00", "pi_shuttertrade": "0.00", "pi_shutterdomestic": "0.00", "pi_shutterecommerce": "0.00", "pi_customerdiscount": null, "pi_discountoverridesubwidth": null, "pi_manufacturer_cost": null, "pi_fabrichide": null, "pi_showhiddencolumn": null, "pi_hidecompparameter": null, "pi_factorybarcodeproduct": null, "pi_showhideproductorder": 1, "pi_ecommercestatus": 1, "pi_productdescription": "", "pi_ecomproductdesc": null, "pi_homeimage": null, "pi_galleryimage": null, "pi_innerpageimage": null, "pi_frameimage": null, "pi_ecommercecompmarkup": "0.00", "pi_showframeminmax": null, "pi_fabricdefaultdiscount": null, "pi_productstatusmultiple": null, "pi_followproductionseq": 1, "pi_productionformulasheetname": null, "pi_productrules": null, "pi_showexcelfromula": null, "pi_supplierheading": null, "pi_producttypehide": null, "pi_dualproducttypeheading": "Fabric 2", "pi_fabricheading": null, "pi_dualproducttypeenable": 0, "pi_fabricbeforeproducttype": null, "pi_suppliermandatory": null, "pi_showfabric": null, "pi_ecommercesample": "1", "pi_priceavalcheck": null, "pi_showcomponentcode": null, "pi_showmaxarea": null, "pi_recessallowance": null, "pi_deductionname": null, "pi_deductionvalue": "0.00", "pi_stackqty": null, "pi_blindstype": null, "pi_suppliershowhide": null, "pi_pricealert": null, "pi_metatitle": null, "pi_metadescription": null, "pi_metakeyword": null, "pi_canonicaltag": null, "pi_alttexttag": null, "pi_headertag": "H1", "pi_productimage": null, "pi_workroom": 1, "pi_mobileapp": 0, "pi_jobtransfer": 0, "pi_seq": 49, "pi_status": 0, "pi_createdby": 6, "pi_createdat": 1681369942, "pi_defaultunittype": 2, "pi_jobfraction": 2, "pi_unittypeseq": "2,1,4,3", "pi_deafultimage": null, "pi_backgroundimage": "[]", "pi_discountappliesto": "{\"materialchk\": \"1\", \"optionschk\": \"1\", \"operationschk\": \"1\"}", "pi_ecomProductName": null, "pi_productgroupseq": null, "pi_unitypedata": "{\"2\":1,\"1\":1,\"4\":1,\"3\":1}", "id": "41", "pi_salesstartdate": null, "pi_salesenddate": null, "pi_startdate": null, "pi_expirydate": null, "pi_updatedat": 1743505611, "pi_updatedby": 9 }, { "pi_productid": 52, "pi_productname": "Awnings 28", "pi_pcode": "AWcode53", "pi_custpcode": "", "pi_category": 1, "pi_natureofproduct": "resell", "pi_productgroup": 0, "pi_producttype": 0, "pi_qtyperunit": "0.00", "pi_unitprice": "0.00", "pi_weight": "0.00", "pi_packsize": null, "pi_costfactor": null, "pi_commissionrate": "0.000", "pi_commissionmethod": null, "pi_discontinued": null, "pi_usageunit": null, "pi_handler": null, "pi_reorderlevel": null, "pi_website": null, "pi_taxclass": null, "pi_mfrpartno": null, "pi_vendorpartno": null, "pi_serialno": null, "pi_qtyinstock": null, "pi_productsheet": null, "pi_qtyindemand": null, "pi_glacct": null, "pi_supplierid": null, "pi_imagename": null, "pi_currencyid": null, "pi_supplierdefault": null, "pi_productseqno": null, "pi_domesticmarkup": "0.00", "pi_contractmarkup": "0.00", "pi_trademarkup": "0.00", "pi_childsafe": null, "pi_quantyshowhide": null, "pi_compquantyshowhide": null, "pi_stockcontrol": null, "pi_productiontab": null, "pi_fabriccolorcodehide": null, "pi_defaultunitfornewcurtainsorder": null, "pi_costpricecomesfrom": "2", "pi_netpricecomesfrom": "2", "pi_shuttercontract": "0.00", "pi_shuttertrade": "0.00", "pi_shutterdomestic": "0.00", "pi_shutterecommerce": "0.00", "pi_customerdiscount": null, "pi_discountoverridesubwidth": null, "pi_manufacturer_cost": null, "pi_fabrichide": null, "pi_showhiddencolumn": null, "pi_hidecompparameter": null, "pi_factorybarcodeproduct": null, "pi_showhideproductorder": 1, "pi_ecommercestatus": 1, "pi_productdescription": "description", "pi_ecomproductdesc": null, "pi_homeimage": null, "pi_galleryimage": null, "pi_innerpageimage": null, "pi_frameimage": null, "pi_ecommercecompmarkup": "0.00", "pi_showframeminmax": null, "pi_fabricdefaultdiscount": null, "pi_productstatusmultiple": null, "pi_followproductionseq": 1, "pi_productionformulasheetname": null, "pi_productrules": null, "pi_showexcelfromula": null, "pi_supplierheading": null, "pi_producttypehide": null, "pi_dualproducttypeheading": "Fabric 2", "pi_fabricheading": null, "pi_dualproducttypeenable": 0, "pi_fabricbeforeproducttype": null, "pi_suppliermandatory": null, "pi_showfabric": null, "pi_ecommercesample": "1", "pi_priceavalcheck": null, "pi_showcomponentcode": null, "pi_showmaxarea": null, "pi_recessallowance": null, "pi_deductionname": null, "pi_deductionvalue": "0.00", "pi_stackqty": null, "pi_blindstype": null, "pi_suppliershowhide": null, "pi_pricealert": null, "pi_metatitle": null, "pi_metadescription": null, "pi_metakeyword": null, "pi_canonicaltag": null, "pi_alttexttag": null, "pi_headertag": "H1", "pi_productimage": null, "pi_workroom": 1, "pi_mobileapp": 0, "pi_jobtransfer": 0, "pi_seq": 60, "pi_status": 0, "pi_createdby": 1, "pi_createdat": 1693470704, "pi_defaultunittype": 2, "pi_jobfraction": 2, "pi_unittypeseq": "2,1,4,3", "pi_deafultimage": null, "pi_backgroundimage": "[]", "pi_discountappliesto": "{\"optionschk\":1,\"operationschk\":1,\"pricetablechk\":1}", "pi_ecomProductName": null, "pi_productgroupseq": null, "pi_unitypedata": "{\"2\":1,\"1\":1,\"4\":1,\"3\":1}", "id": "52", "pi_salesstartdate": null, "pi_salesenddate": null, "pi_startdate": null, "pi_expirydate": null, "pi_updatedat": 1743503381, "pi_updatedby": 1 } ], "deleted": [] }, "bm_fields": { "created": [ { "fi_fieldId": 24683, "fi_fieldName": "Color", "fi_fieldCode": "", "fi_fieldparamid": "", "fi_productId": 23, "fi_fabricorcolor": 2, "fi_dualseq": 1, "fi_linktopricegroup": 0, "fi_issubfabric": 0, "fi_showFieldOnJob": 1, "fi_showFieldOnEcommerce": 0, "fi_showFieldOnCustomerPortal": 1, "fi_fieldType": 5, "fi_fieldLevel": 2, "fi_isMainField": 1, "fi_hasPrice": 0, "fi_defaultOption": null, "fi_selection": 0, "fi_isMandatory": 0, "fi_displayUnder": null, "fi_showhide": 1, "fi_enabledisableecom": 0, "fi_showhideecom": 0, "fi_ecomeditdetails": "", "fi_textfieldheight": 1, "fi_tag": null, "fi_active": 0, "fi_status": 0, "fi_parent_based_delete": 0, "fi_seq": 37, "fi_supplierid": "0", "fi_edifieldName": "{\"1\":\"Color\",\"234\":\"Color\"}", "fi_edifieldCode": "", "fi_edifieldtag": "", "fi_edienable": "", "id": "24683", "fi_createdDate": 1743506127, "fi_updatedDate": 1743506127, "fi_createdBy": 0, "fi_updatedBy": null } ], "updated": [], "deleted": [] }, "bm_fieldOptionLink": { "created": [ { "fol_fieldOptionLinkId": 28854, "fol_fieldId": 24683, "fol_optionId": 6573, "fol_productId": 23, "fol_masterParentFieldId": 5535, "fol_parentlinkid": 0, "fol_optionpricegroup": "0", "fol_pricegroupsupplier": "'0'", "fol_linkType": 3, "fol_seq": 1, "fol_status": 0, "fol_parent_based_delete": 0, "fol_edifieldName": "", "fol_edifieldCode": "", "fol_edifieldtag": "", "fol_edienable": "", "id": "28854", "fol_createdDate": 1743506127, "fol_updatedDate": 1743506127, "fol_createdBy": 0, "fol_updatedBy": null } ], "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": [ { "ppm_id": 2096, "ppm_grouptypeid": 1430, "ppm_fieldid": 436, "ppm_productid": 23, "ppm_mainsupplier": "1", "ppm_priceincby": 0, "ppm_priceinctype": 0, "ppm_priceinccount": 0, "ppm_domesticmarkup": "0.00", "ppm_domesticmarkuptype": 0, "ppm_trademarkup": "0.00", "ppm_trademarkuptype": 0, "ppm_contractmarkup": "0.00", "ppm_contractmarkuptype": 0, "ppm_ecommercemarkup": "0.00", "ppm_ecommercemarkuptype": 0, "ppm_cusfivemarkup": "0.00", "ppm_cusfivemarkuptype": 0, "ppm_cussixmarkup": "0.00", "ppm_cussixmarkuptype": 0, "ppm_cussevenmarkup": "0.00", "ppm_cussevenmarkuptype": 0, "ppm_cuseightmarkup": "0.00", "ppm_cuseightmarkuptype": 0, "ppm_supplierdiscount": "0.00", "ppm_hidepriceon": 0, "ppm_pricegroupon": "1,2", "ppm_priceinclvat": 0, "ppm_seq": 27, "ppm_status": 0, "ppm_edifieldName": "", "ppm_edifieldCode": "", "ppm_edifieldtag": "", "ppm_edienable": "", "id": "2096", "created_at": 1743506229, "updated_at": 1743506229, "created_by": 1, "updated_by": null } ], "updated": [], "deleted": [ "2095" ] }, "bm_productrecipe": { "created": [], "updated": [], "deleted": [] }, "bm_productrecipemap": { "created": [ { "prm_id": 102723, "prm_recipeid": 23, "prm_fieldtypeid": 5, "prm_fieldvalueid": 107599, "prm_status": 0, "id": "102723", "prm_createdat": 1743506128, "prm_updatedat": 1743506128, "prm_createdby": 0, "prm_updatedby": null } ], "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": [ { "pgd_id": 1430, "pgd_groupname": "TEST SASA", "pgd_blindtypecode": "", "pgd_productcategories": 3, "pgd_status": 0, "pgd_seq": null, "pgd_groupcode": "", "pgd_groupcodedesc": "", "id": "1430", "pgd_createdat": 1743506103, "pgd_updatedat": 1743506103, "pgd_createdby": 1, "pgd_updatedby": null } ], "updated": [], "deleted": [] }, "bm_productgroupmaterialmap": { "created": [ { "pgmm_id": 107599, "pgmm_fabriccolormapid": 30868, "pgmm_productmapid": 23, "pgmm_categoryeditdetails": null, "pgmm_groupmapid": 1430, "pgmm_fabricfieldid": 5535, "pgmm_colorfieldid": 24683, "pgmm_contactid": 0, "pgmm_enabledisable": 1, "pgmm_extraoffer": null, "pgmm_bestselling": null, "pgmm_metatitle": null, "pgmm_metadescription": null, "pgmm_metakeyword": null, "pgmm_canonicalurl": null, "pgmm_alttext": null, "pgmm_customizedcategoryvalue": null, "pgmm_status": 0, "pgmm_seq": 0, "pgmm_fabricseq": 21, "pgmm_colorseq": 1, "pgmm_edifieldNameFabric": "{\"1\":\"DDSS\",\"234\":\"DDSS\"}", "pgmm_edifieldCodeFabric": "", "pgmm_edifieldtagFabric": "", "pgmm_edienableFabric": "", "pgmm_edifieldNameColor": "", "pgmm_edifieldtagColor": "", "pgmm_edienableColor": "", "id": "107599", "pgmm_createdat": 1743506128, "pgmm_updatedat": 1743506128, "pgmm_createdby": 1, "pgmm_updatedby": null } ], "updated": [], "deleted": [] }, "bm_productpricedetails": { "created": [], "updated": [], "deleted": [] }, "bm_fabriccolourmap": { "created": [ { "pfm_id": 30868, "pfm_fabricmapid": 6573, "pfm_colourmapid": 30517, "pfm_jsondata": "{\"133\":\"DDD\",\"134\":\"\",\"135\":\"\",\"136\":\"\",\"137\":\"\",\"138\":\"\",\"139\":\"\",\"140\":\"\",\"141\":3,\"142\":\"\",\"143\":\"\",\"144\":\"\",\"145\":\"\",\"146\":\"\",\"147\":\"\",\"148\":\"\",\"149\":\"\",\"150\":\"\",\"151\":\"\",\"152\":\"\",\"153\":\"\",\"154\":\"\",\"155\":\"\",\"156\":\"\",\"157\":\"\",\"158\":\"\",\"159\":\"\",\"160\":\"\",\"161\":\"\",\"162\":\"\",\"163\":2,\"165\":\"\",\"166\":\"\",\"170\":\"\",\"171\":\"\",\"172\":\"\",\"455\":\"\",\"505\":\"\",\"506\":\"\",\"555\":\"\",\"556\":\"\",\"639\":\"\",\"640\":\"\",\"641\":\"\",\"648\":\"1\",\"683\":\"\",\"684\":\"\",\"685\":\"\",\"686\":\"\",\"710\":\"\",\"746\":\"\",\"747\":\"1\",\"748\":\"\",\"749\":\"1\",\"128\":\"DDSS\",\"129\":\"\",\"130\":1,\"131\":\"\"}", "pfm_status": 0, "pfm_seq": 0, "id": "30868", "pfm_createdat": 1743506113, "pfm_updatedat": 1743506118, "pfm_createdby": 1, "pfm_updatedby": null } ], "updated": [], "deleted": [] }, "bm_fabricdetails": { "created": [ { "fd_id": 6573, "fd_mtrlcategid": 5, "fd_custmzdfabdetails": "{\"128\":\"DDSS\",\"129\":\"\",\"130\":1,\"131\":\"\"}", "fd_hasprice": 0, "fd_status": 0, "fd_seq": 0, "id": "6573", "fd_createdat": 1743506113, "fd_updatedat": 1743506113, "fd_createdby": 1, "fd_updatedby": 1 } ], "updated": [ { "fd_id": 6573, "fd_mtrlcategid": 5, "fd_custmzdfabdetails": "{\"128\":\"DDSS\",\"129\":\"\",\"130\":1,\"131\":\"\"}", "fd_hasprice": 0, "fd_status": 0, "fd_seq": 0, "id": "6573", "fd_createdat": 1743506113, "fd_updatedat": 1743506113, "fd_createdby": 1, "fd_updatedby": 1 } ], "deleted": [] }, "bm_colordetails": { "created": [ { "cd_id": 30517, "cd_fabricmapid": 6573, "cd_mtrlcategid": 5, "cd_custmzdcolrdetails": "{\"133\":\"DDD\",\"134\":\"\",\"139\":\"\",\"140\":\"\",\"141\":3,\"142\":\"\",\"143\":\"\",\"144\":\"\",\"145\":\"\",\"146\":\"\",\"147\":\"\",\"148\":\"\",\"149\":\"\",\"150\":\"\",\"151\":\"\",\"152\":\"\",\"153\":\"\",\"154\":\"\",\"155\":\"\",\"156\":\"\",\"157\":\"\",\"158\":\"\",\"159\":\"\",\"160\":\"\",\"161\":\"\",\"162\":\"\",\"163\":2,\"165\":\"\",\"166\":\"\",\"171\":\"\",\"172\":\"\",\"455\":\"\",\"505\":\"\",\"506\":\"\",\"648\":\"1\",\"683\":\"\",\"684\":\"\",\"685\":\"\",\"686\":\"\",\"710\":\"\",\"746\":\"\",\"747\":\"1\",\"748\":\"\",\"749\":\"1\"}", "cd_colorhasprice": 0, "cd_colorhasstock": 0, "cd_jobform": 1, "cd_onlineportal": 1, "cd_ecommercesite": 0, "cd_domestictype": 1, "cd_contracttype": 1, "cd_tradetype": 1, "cd_ecommercetype": 0, "cd_custtypefive": 0, "cd_custtypesix": 0, "cd_custtypeseven": 0, "cd_custtypeeight": 0, "cd_remainingstock": "0.00", "cd_orderqty": 0, "cd_qty": "0.00", "cd_status": 0, "cd_seq": 0, "id": "30517", "cd_createdat": 1743506113, "cd_updatedat": 1743506118, "cd_createdby": 1, "cd_updatedby": 1 } ], "updated": [ { "cd_id": 30517, "cd_fabricmapid": 6573, "cd_mtrlcategid": 5, "cd_custmzdcolrdetails": "{\"133\":\"DDD\",\"134\":\"\",\"139\":\"\",\"140\":\"\",\"141\":3,\"142\":\"\",\"143\":\"\",\"144\":\"\",\"145\":\"\",\"146\":\"\",\"147\":\"\",\"148\":\"\",\"149\":\"\",\"150\":\"\",\"151\":\"\",\"152\":\"\",\"153\":\"\",\"154\":\"\",\"155\":\"\",\"156\":\"\",\"157\":\"\",\"158\":\"\",\"159\":\"\",\"160\":\"\",\"161\":\"\",\"162\":\"\",\"163\":2,\"165\":\"\",\"166\":\"\",\"171\":\"\",\"172\":\"\",\"455\":\"\",\"505\":\"\",\"506\":\"\",\"648\":\"1\",\"683\":\"\",\"684\":\"\",\"685\":\"\",\"686\":\"\",\"710\":\"\",\"746\":\"\",\"747\":\"1\",\"748\":\"\",\"749\":\"1\"}", "cd_colorhasprice": 0, "cd_colorhasstock": 0, "cd_jobform": 1, "cd_onlineportal": 1, "cd_ecommercesite": 0, "cd_domestictype": 1, "cd_contracttype": 1, "cd_tradetype": 1, "cd_ecommercetype": 0, "cd_custtypefive": 0, "cd_custtypesix": 0, "cd_custtypeseven": 0, "cd_custtypeeight": 0, "cd_remainingstock": "0.00", "cd_orderqty": 0, "cd_qty": "0.00", "cd_status": 0, "cd_seq": 0, "id": "30517", "cd_createdat": 1743506113, "cd_updatedat": 1743506118, "cd_createdby": 1, "cd_updatedby": 1 } ], "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_customercontactinfo": { "51743503328": 2738 }, "bm_customertemplatedata": { "31743503328": 1490 }, "bm_jobdetails": { "41743503328": 2777 }, "bm_jobmultiquote": { "141743503328": 2799 }, "bm_orderitem": { "71743508163": 6570 } }, "timestamp": 1743508187 }