{ "status": "success", "upcomingorder_list": { "bm_customertemplatedata": { "created": [], "updated": [ { "ctd_id": 2466, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\":1,\"62\":\"TEST1001\",\"63\":\"\",\"64\":25,\"65\":\"\",\"66\":null,\"67\":\"Church Road\",\"68\":\"\",\"69\":\"\",\"70\":\"CR4 3BH\",\"71\":\"Mitcham\",\"72\":19,\"73\":\"\",\"600\":\"25\"}", "ctd_deletedcustokeyvalue": "{}", "ctd_isenablecustspecvatrate": 0, "ctd_custspecvatrate": "0.00", "ctd_vatregnum": null, "ctd_custsurcharge": null, "ctd_defaultdelcost": null, "ctd_defaultapptype": "0", "ctd_defaultstaff": "", "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": 1, "ctd_foronlineisenable": 1, "ctd_enabledproductdesktop": "3,4,6,8,9,10,11,12,13,14,15,18,20,21,23,24,25,27,29,30,31,32,33,34,138,144,146,147,148,150,161,177,183,184,185,188,195,196,197,198,199,200,201,202,203,204,206,207,208,210,213,215,216,217,221,222,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245", "ctd_enabledproductonline": "3,4,6,8,9,10,11,12,13,14,15,18,20,21,23,24,25,27,29,30,31,32,33,34,138,144,146,147,148,150,161,177,183,184,185,188,195,196,197,198,199,200,201,202,203,204,206,207,208,210,213,215,216,217,221,222,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245", "ctd_onlineproductmarkup": null, "ctd_onlineendcustomeruseprefix": null, "ctd_onlineendcustomersequence": "1", "ctd_onlinequotecustomerterms": null, "ctd_onlinequotepaymentterms": null, "ctd_onlineinvoicecustomerterms": null, "ctd_onlineinvoicepaymentterms": null, "ctd_seq": 0, "ctd_status": 0, "id": "2466", "ctd_createdat": 1706525233, "ctd_updatedat": 1747135735, "ctd_createdby": 1, "ctd_updatedby": 1 } ], "deleted": [] }, "bm_customercontactinfo": { "created": [], "updated": [ { "cci_id": 2587, "cci_customerid": 2466, "cci_templateid": 3, "roleid": 2, "cci_customizedarray": "{\"82\":\"\",\"77\":\"Test\",\"79\":\"Test\",\"78\":\"\",\"76\":\"\",\"81\":1,\"75\":1,\"84\":\"TEST1001\",\"83\":1}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"Church Road\",\"89\":\"\",\"90\":19,\"86\":\"\",\"91\":\"Mitcham\",\"88\":\"CR4 3BH\"}", "cci_ismarketingemails": 0, "cci_smsverifystatus": 0, "cci_isdocumentreceived": 0, "cci_receiveddocfor": "[\"null\"]", "cci_isonlineportal": 0, "cci_latitude": null, "cci_longitude": null, "cci_username": "", "cci_password": "", "cci_confirmpassword": "", "cci_seq": 0, "cci_status": 0, "cci_deviceplatform": 0, "cci_mobcustomertempid": 0, "id": "2587", "cci_createdat": 1706525233, "cci_updatedat": 1747135539, "cci_createdby": 1, "cci_updatedby": null } ], "deleted": [] }, "bm_appointment": { "created": [ { "app_eventid": 9945, "app_description": "", "app_summary": "AQ5540-Test Test-Church Road-Surveyor", "app_private": 0, "app_appointmentType": 63, "app_userId": 2, "app_orderId": 5531, "app_customerId": 0, "app_isAllDay": 0, "app_timezone": "Asia\/Calcutta", "app_latitude": null, "app_longitude": null, "app_parentappid": null, "app_recurrencerule": null, "app_userdefinedValue": "[]", "app_recurrenceexception": null, "app_attachment": null, "guid": "", "app_staff": "", "app_appointtype": "", "app_confirmed": 0, "app_travelHour": "0", "app_travelMinute": "0", "app_onsiteHour": "0", "app_onsiteMinute": "0", "app_location": null, "app_traveltime": null, "app_googleid": "0", "app_platform": "web", "app_cal_status": 868, "app_status": 0, "app_markasread": 0, "app_statusInGoogle": 0, "app_runid": null, "app_jobtimehour": "1", "app_jobtimeminute": "0", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": 2587, "id": "9945", "app_sdate": 1747094400, "app_edate": 1747094400, "app_stime": 1747132200, "app_etime": 1747135800, "app_sdatetime": 1747132200, "app_edatetime": 1747135800, "app_until": null, "app_createdAt": 1747135735, "app_updatedAt": 1747135735, "app_createdBy": 2, "app_updatedBy": null }, { "app_eventid": 9946, "app_description": "", "app_summary": "AQ5540-Test Test-Church Road-Surveyor", "app_private": 0, "app_appointmentType": 63, "app_userId": 2, "app_orderId": 5531, "app_customerId": 0, "app_isAllDay": 0, "app_timezone": "Asia\/Calcutta", "app_latitude": null, "app_longitude": null, "app_parentappid": null, "app_recurrencerule": null, "app_userdefinedValue": "[]", "app_recurrenceexception": null, "app_attachment": null, "guid": "", "app_staff": "", "app_appointtype": "", "app_confirmed": 0, "app_travelHour": "0", "app_travelMinute": "0", "app_onsiteHour": "0", "app_onsiteMinute": "0", "app_location": null, "app_traveltime": null, "app_googleid": "0", "app_platform": "web", "app_cal_status": 868, "app_status": 0, "app_markasread": 0, "app_statusInGoogle": 0, "app_runid": null, "app_jobtimehour": "1", "app_jobtimeminute": "0", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": 2587, "id": "9946", "app_sdate": 1747094400, "app_edate": 1747094400, "app_stime": 1747135800, "app_etime": 1747139400, "app_sdatetime": 1747135800, "app_edatetime": 1747139400, "app_until": null, "app_createdAt": 1747136099, "app_updatedAt": 1747136099, "app_createdBy": 2, "app_updatedBy": null }, { "app_eventid": 9947, "app_description": "", "app_summary": "AQ5540-Test Test-Church Road-Surveyor", "app_private": 0, "app_appointmentType": 63, "app_userId": 2, "app_orderId": 5531, "app_customerId": 0, "app_isAllDay": 0, "app_timezone": "Asia\/Calcutta", "app_latitude": null, "app_longitude": null, "app_parentappid": null, "app_recurrencerule": null, "app_userdefinedValue": "[]", "app_recurrenceexception": null, "app_attachment": null, "guid": "", "app_staff": "", "app_appointtype": "", "app_confirmed": 0, "app_travelHour": "0", "app_travelMinute": "0", "app_onsiteHour": "0", "app_onsiteMinute": "0", "app_location": null, "app_traveltime": null, "app_googleid": "0", "app_platform": "web", "app_cal_status": 868, "app_status": 0, "app_markasread": 0, "app_statusInGoogle": 0, "app_runid": null, "app_jobtimehour": "1", "app_jobtimeminute": "0", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": 2587, "id": "9947", "app_sdate": 1747267200, "app_edate": 1747267200, "app_stime": 1747135800, "app_etime": 1747139400, "app_sdatetime": 1747308600, "app_edatetime": 1747312200, "app_until": null, "app_createdAt": 1747136157, "app_updatedAt": 1747136157, "app_createdBy": 2, "app_updatedBy": null } ], "updated": [], "deleted": [] }, "bm_tasklist": { "created": [ { "tl_id": 50, "tl_orderid": 4094, "tl_taskcategory": 0, "tl_taskdate": "2025-05-13", "tl_tasktime": "05:30:00", "tl_taskmethod": "0", "tl_istaskprivate": 0, "tl_userid": "18", "tl_priority": 0, "tl_addjobid": 4094, "tl_desc": "jkjk", "tl_status": 0, "tl_markasread": 0, "tl_taskstatus": 1, "tl_userdefinedfields": "[]", "tl_markcompleted": 0, "tl_jobmode": "contact", "tl_recurrencerule": "", "tl_repeatmaindescription": "0", "tl_repeatmethod": "daily", "tl_starttask": "", "tl_startdata": "", "tl_endtask": "", "tl_enddata": "", "tl_istaskrepeat": 0, "tl_deviceplatform": 0, "id": "50", "tl_createdat": 1747135782, "tl_updatedat": 1747135788, "tl_createdby": 8, "tl_updatedby": 8 } ], "updated": [ { "tl_id": 50, "tl_orderid": 4094, "tl_taskcategory": 0, "tl_taskdate": "2025-05-13", "tl_tasktime": "05:30:00", "tl_taskmethod": "0", "tl_istaskprivate": 0, "tl_userid": "18", "tl_priority": 0, "tl_addjobid": 4094, "tl_desc": "jkjk", "tl_status": 0, "tl_markasread": 0, "tl_taskstatus": 1, "tl_userdefinedfields": "[]", "tl_markcompleted": 0, "tl_jobmode": "contact", "tl_recurrencerule": "", "tl_repeatmaindescription": "0", "tl_repeatmethod": "daily", "tl_starttask": "", "tl_startdata": "", "tl_endtask": "", "tl_enddata": "", "tl_istaskrepeat": 0, "tl_deviceplatform": 0, "id": "50", "tl_createdat": 1747135782, "tl_updatedat": 1747135788, "tl_createdby": 8, "tl_updatedby": 8 } ], "deleted": [] }, "bm_jobdetails": { "created": [ { "jd_id": 5531, "jd_customerid": 2466, "jd_contactid": 2587, "jd_additionalcontacts": "2587", "jd_templateid": 1, "jd_jobmultiquoteid": 5555, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5540", "jd_jobstatus": 4, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "TEST1001", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "0.00", "jd_vat": "0.00", "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": "0.00", "jd_grossprofit": "0.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "0.00", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 2, "jd_updatedby": 2, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "0.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":\"25\",\"37\":1,\"39\":25,\"41\":2,\"44\":\"\",\"45\":\"Test\",\"46\":\"Test\",\"47\":\"\",\"48\":\"\",\"49\":\"Church Road\",\"50\":\"\",\"51\":\"Mitcham\",\"52\":\"\",\"53\":\"CR4 3BH\",\"54\":19,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":2,\"558\":1,\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "0.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5531", "jd_createddate": 1747094400, "jd_orderdate": 1747094400, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1747135539, "jd_updatedat": 1747136158 } ], "updated": [ { "jd_id": 5530, "jd_customerid": 3922, "jd_contactid": 4094, "jd_additionalcontacts": "4094", "jd_templateid": 1, "jd_jobmultiquoteid": 5554, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5539", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "GGRA0001", "jd_invoiceno": "", "jd_listprice": "125.00", "jd_netprice": "125.00", "jd_vat": "5.43", "jd_isvaton": 1, "jd_deliverycost": "70.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "jd_isroundon": 0, "jd_grossprice": "130.43", "jd_grossprofit": "70.00", "jd_costprice": "55.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "130.43", "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": 1, "jd_updatedby": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "22.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5539\",\"35\":\"GGRA0001\",\"36\":1,\"37\":1,\"38\":\"\",\"39\":25,\"40\":13,\"41\":1,\"44\":\"\",\"45\":\"Granna\",\"46\":\"G\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"560099\",\"54\":4,\"285\":2,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"countryText\":\"Australia\",\"adminUser\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "22.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5530", "jd_createddate": 1747094400, "jd_orderdate": null, "jd_duedate": 1747094400, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1747131026, "jd_updatedat": 1747136968 }, { "jd_id": 5531, "jd_customerid": 2466, "jd_contactid": 2587, "jd_additionalcontacts": "2587", "jd_templateid": 1, "jd_jobmultiquoteid": 5555, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5540", "jd_jobstatus": 4, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "TEST1001", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "0.00", "jd_vat": "0.00", "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": "0.00", "jd_grossprofit": "0.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "0.00", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 2, "jd_updatedby": 2, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "0.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":\"25\",\"37\":1,\"39\":25,\"41\":2,\"44\":\"\",\"45\":\"Test\",\"46\":\"Test\",\"47\":\"\",\"48\":\"\",\"49\":\"Church Road\",\"50\":\"\",\"51\":\"Mitcham\",\"52\":\"\",\"53\":\"CR4 3BH\",\"54\":19,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":2,\"558\":1,\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "0.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5531", "jd_createddate": 1747094400, "jd_orderdate": 1747094400, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1747135539, "jd_updatedat": 1747136158 } ], "deleted": [] }, "bm_orderitem": { "created": [ { "oi_id": 31044, "oi_jobid": 5530, "oi_jobtempid": "0", "oi_jobmultiquoteid": 5554, "oi_productid": 8, "oi_recipeid": 8, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":6886,\"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\":6886,\"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\":247,\"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\":247,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":248,\"labelname\":\"Supplier\",\"value\":\"1\",\"valueid\":null,\"type\":17,\"optionid\":\"1\",\"optionvalue\":[{\"id\":1,\"optionid\":1,\"optionname\":\"Markilux\",\"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\":248,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"1\",\"optionsvalue\":[{\"id\":1,\"optionid\":1,\"optionname\":\"Markilux\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":1},{\"id\":250,\"labelname\":\"Room\",\"value\":\"3\",\"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\":250,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":251,\"labelname\":\"Blind or Recess\",\"value\":\"Recess size\",\"valueid\":\"726\",\"type\":3,\"optionid\":\"475\",\"optionvalue\":[{\"optionid\":475,\"optionqty\":\"1\",\"optioncode\":\"jcld\",\"optionname\":\"Recess size\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":726,\"forchildfieldoptionlinkid\":\"3_726\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"issubfabric\":0,\"labelnamecode\":\"Blind or Recess\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Blind or Recess\",\"fieldid\":251,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"475\",\"optionsvalue\":[{\"optionid\":475,\"optionqty\":\"1\",\"optioncode\":\"jcld\",\"optionname\":\"Recess size\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":726,\"forchildfieldoptionlinkid\":\"3_726\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"editruleoverride\":1},{\"id\":252,\"labelname\":\"Width\",\"value\":\"500\",\"valueid\":null,\"type\":11,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Width\",\"fabricorcolor\":0,\"widthfraction\":\"0___0\",\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":11,\"mandatory\":0,\"fieldname\":\"Width\",\"fieldid\":252,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":253,\"labelname\":\"Drop\",\"value\":\"610\",\"valueid\":null,\"type\":12,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Drop\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":\"0___0\",\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":12,\"mandatory\":0,\"fieldname\":\"Drop\",\"fieldid\":253,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":249,\"labelname\":\"Product Type\",\"value\":\"452\",\"valueid\":\"553\",\"type\":13,\"optionid\":\"452\",\"optionvalue\":[{\"id\":553,\"fieldid\":249,\"fieldoptionlinkid\":553,\"optionid\":452,\"mainsupplier\":\"1\",\"blindtypecode\":null,\"optionname\":\"Band AB\",\"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\":0,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":13,\"mandatory\":0,\"fieldname\":\"Product Type\",\"fieldid\":249,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"452\",\"optionsvalue\":[{\"id\":553,\"fieldid\":249,\"fieldoptionlinkid\":553,\"optionid\":452,\"mainsupplier\":\"1\",\"blindtypecode\":null,\"optionname\":\"Band AB\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"editruleoverride\":1},{\"id\":304,\"labelname\":\"Blind Model\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Blind Model\",\"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 Model\",\"fieldid\":304,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":254,\"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\":254,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":255,\"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\":255,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":305,\"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\":305,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":256,\"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\":256,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":257,\"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\":257,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":258,\"labelname\":\"Special Instructions\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Special 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\":\"Special Instructions\",\"fieldid\":258,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Supplier: Markilux, Room: 3, Blind or Recess: Recess size, Width: 500, Drop: 610, Product Type: Band AB", "oi_reportdescription": "##Quantity: 1##,##Supplier: Markilux##,##Room: 3##,##Blind or Recess: Recess size##,##Width: 500 mm##,##Drop: 610 mm##,##Product Type: Band AB##", "oi_reporttitles": "##Quantity:<\/br>##Supplier:<\/br>##Room:<\/br>##Blind or Recess:<\/br>##Width:<\/br>##Drop:<\/br>##Product Type:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":34,\"value\":null,\"formula\":\"5\",\"price\":null,\"recipeid\":8,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":35,\"value\":\"500.00\",\"formula\":\"Width\",\"price\":null,\"recipeid\":8,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"500.00\"},{\"productionoveride\":0,\"id\":36,\"value\":\"610.00\",\"formula\":\"Drop\",\"price\":null,\"recipeid\":8,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"610.00\"},{\"productionoveride\":0,\"id\":38,\"value\":null,\"formula\":\"Quantity\",\"price\":null,\"recipeid\":8,\"stockupdate\":0,\"fieldid\":22394,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Test Option\",\"fractionvalue\":null}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[{\"link_id\":9,\"process_id\":2,\"product_id\":8,\"phc_id\":9,\"pd_id\":2,\"name\":\"Stock Pick\",\"phc_linkstations\":2,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"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\":null,\"phc_contacttype\":null,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"10.00\",\"Hour\\\/mins\":\"10 mins\",\"phc_processcostid\":1,\"markupprice\":\"10.00\",\"price\":\"0.00\"},{\"link_id\":6,\"process_id\":5,\"product_id\":8,\"phc_id\":6,\"pd_id\":5,\"name\":\"Assemble\",\"phc_linkstations\":5,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"15.00\",\"phc_contractsellingprice\":\"15.00\",\"phc_tradesellingprice\":\"15.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"15.00\",\"phc_customers\":null,\"phc_contacttype\":null,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"15.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"15.00\",\"price\":\"0.00\"},{\"link_id\":10,\"process_id\":1,\"product_id\":8,\"phc_id\":10,\"pd_id\":1,\"name\":\"Office Check\",\"phc_linkstations\":1,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"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\":null,\"phc_contacttype\":null,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"10.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"10.00\",\"price\":\"0.00\"},{\"link_id\":7,\"process_id\":4,\"product_id\":8,\"phc_id\":7,\"pd_id\":4,\"name\":\"Tube cut\",\"phc_linkstations\":4,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"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\":null,\"phc_contacttype\":null,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"10.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"10.00\",\"price\":\"0.00\"},{\"link_id\":8,\"process_id\":3,\"product_id\":8,\"phc_id\":8,\"pd_id\":3,\"name\":\"Fabric cut\",\"phc_linkstations\":3,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"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\":null,\"phc_contacttype\":null,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"10.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"10.00\",\"price\":\"0.00\"}]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"55.00\",\"cost_with_discount\":\"55.00\",\"cost_with_markup\":\"55.00\",\"gross_price\":\"55.00\",\"vat_price\":\"0.00\"}", "oi_pricecomesfrom_calculations": "[]", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "55.000", "oi_netprice": "55.000", "oi_pricesfromoperations": null, "oi_vatprice": "0.000", "oi_vatvalue": "0.000", "oi_vatselected": 0, "oi_vattype": 2, "oi_vatonoff": 1, "oi_grossprice": "55.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": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "55.000", "oi_endcustomeroverridevatprice": "0.000", "oi_endcustomeroverridegrossprice": "55.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[6886, 247, 248, 250, 251, 252, 253, 249, 304, 254, 255, 305, 256, 257, 258]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "31044", "oi_productiondate": 1747094400, "oi_createdat": 1747155871, "oi_updatedat": 1747136966, "oi_createdby": 1, "oi_updatedby": 1 } ], "updated": [ { "oi_id": 31044, "oi_jobid": 5530, "oi_jobtempid": "0", "oi_jobmultiquoteid": 5554, "oi_productid": 8, "oi_recipeid": 8, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":6886,\"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\":6886,\"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\":247,\"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\":247,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":248,\"labelname\":\"Supplier\",\"value\":\"1\",\"valueid\":null,\"type\":17,\"optionid\":\"1\",\"optionvalue\":[{\"id\":1,\"optionid\":1,\"optionname\":\"Markilux\",\"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\":248,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"1\",\"optionsvalue\":[{\"id\":1,\"optionid\":1,\"optionname\":\"Markilux\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":1},{\"id\":250,\"labelname\":\"Room\",\"value\":\"3\",\"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\":250,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":251,\"labelname\":\"Blind or Recess\",\"value\":\"Recess size\",\"valueid\":\"726\",\"type\":3,\"optionid\":\"475\",\"optionvalue\":[{\"optionid\":475,\"optionqty\":\"1\",\"optioncode\":\"jcld\",\"optionname\":\"Recess size\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":726,\"forchildfieldoptionlinkid\":\"3_726\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"issubfabric\":0,\"labelnamecode\":\"Blind or Recess\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Blind or Recess\",\"fieldid\":251,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"475\",\"optionsvalue\":[{\"optionid\":475,\"optionqty\":\"1\",\"optioncode\":\"jcld\",\"optionname\":\"Recess size\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":726,\"forchildfieldoptionlinkid\":\"3_726\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"editruleoverride\":1},{\"id\":252,\"labelname\":\"Width\",\"value\":\"500\",\"valueid\":null,\"type\":11,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Width\",\"fabricorcolor\":0,\"widthfraction\":\"0___0\",\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":11,\"mandatory\":0,\"fieldname\":\"Width\",\"fieldid\":252,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":253,\"labelname\":\"Drop\",\"value\":\"610\",\"valueid\":null,\"type\":12,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Drop\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":\"0___0\",\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":12,\"mandatory\":0,\"fieldname\":\"Drop\",\"fieldid\":253,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":249,\"labelname\":\"Product Type\",\"value\":\"452\",\"valueid\":\"553\",\"type\":13,\"optionid\":\"452\",\"optionvalue\":[{\"id\":553,\"fieldid\":249,\"fieldoptionlinkid\":553,\"optionid\":452,\"mainsupplier\":\"1\",\"blindtypecode\":null,\"optionname\":\"Band AB\",\"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\":0,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":13,\"mandatory\":0,\"fieldname\":\"Product Type\",\"fieldid\":249,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"452\",\"optionsvalue\":[{\"id\":553,\"fieldid\":249,\"fieldoptionlinkid\":553,\"optionid\":452,\"mainsupplier\":\"1\",\"blindtypecode\":null,\"optionname\":\"Band AB\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"editruleoverride\":1},{\"id\":304,\"labelname\":\"Blind Model\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Blind Model\",\"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 Model\",\"fieldid\":304,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":254,\"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\":254,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":255,\"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\":255,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":305,\"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\":305,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":256,\"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\":256,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":257,\"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\":257,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":258,\"labelname\":\"Special Instructions\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Special 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\":\"Special Instructions\",\"fieldid\":258,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Supplier: Markilux, Room: 3, Blind or Recess: Recess size, Width: 500, Drop: 610, Product Type: Band AB", "oi_reportdescription": "##Quantity: 1##,##Supplier: Markilux##,##Room: 3##,##Blind or Recess: Recess size##,##Width: 500 mm##,##Drop: 610 mm##,##Product Type: Band AB##", "oi_reporttitles": "##Quantity:<\/br>##Supplier:<\/br>##Room:<\/br>##Blind or Recess:<\/br>##Width:<\/br>##Drop:<\/br>##Product Type:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":34,\"value\":null,\"formula\":\"5\",\"price\":null,\"recipeid\":8,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":35,\"value\":\"500.00\",\"formula\":\"Width\",\"price\":null,\"recipeid\":8,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"500.00\"},{\"productionoveride\":0,\"id\":36,\"value\":\"610.00\",\"formula\":\"Drop\",\"price\":null,\"recipeid\":8,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"610.00\"},{\"productionoveride\":0,\"id\":38,\"value\":null,\"formula\":\"Quantity\",\"price\":null,\"recipeid\":8,\"stockupdate\":0,\"fieldid\":22394,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Test Option\",\"fractionvalue\":null}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[{\"link_id\":9,\"process_id\":2,\"product_id\":8,\"phc_id\":9,\"pd_id\":2,\"name\":\"Stock Pick\",\"phc_linkstations\":2,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"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\":null,\"phc_contacttype\":null,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"10.00\",\"Hour\\\/mins\":\"10 mins\",\"phc_processcostid\":1,\"markupprice\":\"10.00\",\"price\":\"0.00\"},{\"link_id\":6,\"process_id\":5,\"product_id\":8,\"phc_id\":6,\"pd_id\":5,\"name\":\"Assemble\",\"phc_linkstations\":5,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"15.00\",\"phc_contractsellingprice\":\"15.00\",\"phc_tradesellingprice\":\"15.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"15.00\",\"phc_customers\":null,\"phc_contacttype\":null,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"15.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"15.00\",\"price\":\"0.00\"},{\"link_id\":10,\"process_id\":1,\"product_id\":8,\"phc_id\":10,\"pd_id\":1,\"name\":\"Office Check\",\"phc_linkstations\":1,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"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\":null,\"phc_contacttype\":null,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"10.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"10.00\",\"price\":\"0.00\"},{\"link_id\":7,\"process_id\":4,\"product_id\":8,\"phc_id\":7,\"pd_id\":4,\"name\":\"Tube cut\",\"phc_linkstations\":4,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"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\":null,\"phc_contacttype\":null,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"10.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"10.00\",\"price\":\"0.00\"},{\"link_id\":8,\"process_id\":3,\"product_id\":8,\"phc_id\":8,\"pd_id\":3,\"name\":\"Fabric cut\",\"phc_linkstations\":3,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"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\":null,\"phc_contacttype\":null,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"10.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"10.00\",\"price\":\"0.00\"}]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"55.00\",\"cost_with_discount\":\"55.00\",\"cost_with_markup\":\"55.00\",\"gross_price\":\"55.00\",\"vat_price\":\"0.00\"}", "oi_pricecomesfrom_calculations": "[]", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "55.000", "oi_netprice": "55.000", "oi_pricesfromoperations": null, "oi_vatprice": "0.000", "oi_vatvalue": "0.000", "oi_vatselected": 0, "oi_vattype": 2, "oi_vatonoff": 1, "oi_grossprice": "55.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": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "55.000", "oi_endcustomeroverridevatprice": "0.000", "oi_endcustomeroverridegrossprice": "55.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[6886, 247, 248, 250, 251, 252, 253, 249, 304, 254, 255, 305, 256, 257, 258]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "31044", "oi_productiondate": 1747094400, "oi_createdat": 1747155871, "oi_updatedat": 1747136966, "oi_createdby": 1, "oi_updatedby": 1 } ], "deleted": [] }, "bm_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_notelist": { "created": [], "updated": [], "deleted": [] }, "bm_deliveryaddresssetting": { "created": [ { "das_id": 5409, "das_jobid": 5531, "das_appointmentaddress": 2587, "das_invoiceaddress": 2587, "das_invoicedeliveryaddress": 0, "das_purchaseaddress": 0, "das_worksheetaddress": 0, "id": "5409", "das_createdat": 1747135539, "das_updatedat": 1747135539, "das_createdby": 2, "das_updatedby": null } ], "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": [ { "jp_id": 358, "jp_job_id": 5530, "jp_amount": "7.000", "jp_amountoutstanding": "7.000", "jp_paymentmethod": 14, "jp_paymentcategory": 1, "jp_paymenttype": 8, "jp_surchargetype": 2, "jp_surchargemethod": 2, "jp_surchargeamount": "0.000", "jp_surchargevalue": null, "jp_surchargetotal": "7.000", "jp_userid": 1, "jp_decription": "", "jp_deviceplatform": 2, "jp_status": 0, "jp_transfer": 0, "jp_transfer_id": null, "id": "358", "jp_paiddate": 1747094400, "jp_createdat": 1747132795, "jp_updatedat": 1747136984, "jp_createdby": 1, "jp_updatedby": null } ], "updated": [], "deleted": [] }, "bm_OverPayment": { "created": [], "updated": [], "deleted": [] }, "bm_terms": { "created": [ { "termsid": 16006, "orderid": 5531, "jobmultiquoteid": 5555, "isresportshow": 1, "termsCategory": 2, "termsName": "Standard", "termsDescription": "
50% deposit with order and balance due 3 days prior to <\/span>installation.<\/span>
<\/div>
Payments can be made by BACS or credit\/debit card<\/span>
<\/div>
BACS details<\/span>
<\/div>
Account – Aquarius Blinds<\/span>
<\/div>
Account No – 40054837<\/span>
<\/div>
Sort code – 09-06-66<\/span>
<\/div>
Please refer to AQ reference number when making payments<\/span><\/div><\/div>", "status": 0, "seq": 1, "id": "16006", "created_at": 1747135539, "updated_at": 1747135539, "terms_created_at": 1722586185, "created_by": null, "updated_by": null }, { "termsid": 16007, "orderid": 5531, "jobmultiquoteid": 5555, "isresportshow": 1, "termsCategory": 2, "termsName": "Agreed Terms", "termsDescription": "
50% deposit with order with 40% due 3 days prior to installation<\/span>
<\/div>
Final 10% payable to fitters on completion.<\/span>
<\/div>
Payments can be made by BACS or credit\/debit card<\/span>
<\/div>
BACS details<\/span>
<\/div>
Account – Aquarius Blinds<\/span>
<\/div>
Account No – 40054837<\/span>
<\/div>
Sort code – 09-06-66<\/span>
<\/div>
Please refer to AQ reference number when making payments<\/span><\/div>", "status": 0, "seq": 2, "id": "16007", "created_at": 1747135539, "updated_at": 1747135539, "terms_created_at": 1708073527, "created_by": 1, "updated_by": null }, { "termsid": 16008, "orderid": 5531, "jobmultiquoteid": 5555, "isresportshow": 1, "termsCategory": 2, "termsName": "Contract Terms", "termsDescription": "
30 day terms<\/span>
<\/div>
Invoice payment due 30 days from invoice date<\/div>
Payments can be made by BACS or credit\/debit card <\/div>
BACS details Account – Aquarius Blinds Account No – 40054837 Sort code – 09-06-66<\/div><\/div>

<\/div>", "status": 0, "seq": 3, "id": "16008", "created_at": 1747135539, "updated_at": 1747135539, "terms_created_at": 1708073606, "created_by": 1, "updated_by": null }, { "termsid": 16009, "orderid": 5531, "jobmultiquoteid": 5555, "isresportshow": 1, "termsCategory": 2, "termsName": "Special Terms", "termsDescription": "
Payment in full with order. <\/span>
<\/div>
Payments can be made by BACS or credit\/debit card<\/span>
<\/div>
BACS details<\/span>
<\/div>
Account – Aquarius Blinds<\/span>
<\/div>
Account No – 40054837<\/span>
<\/div>
Sort code – 09-06-66<\/span>
<\/div>
Please refer to AQ reference number when making payments<\/span><\/div>", "status": 0, "seq": 4, "id": "16009", "created_at": 1747135539, "updated_at": 1747135539, "terms_created_at": 1708073626, "created_by": 1, "updated_by": null }, { "termsid": 16010, "orderid": 5531, "jobmultiquoteid": 5555, "isresportshow": 1, "termsCategory": 3, "termsName": "Standard", "termsDescription": "
50% deposit with order and balance due 3 days prior to <\/span>installation.<\/span>
<\/div>
Payments can be made by BACS or credit\/debit card<\/span>
<\/div>
BACS details<\/span>
<\/div>
Account – Aquarius Blinds<\/span>
<\/div>
Account No – 40054837<\/span>
<\/div>
Sort code – 09-06-66<\/span>
<\/div>
Please refer to AQ reference number when making payments<\/span><\/div><\/div>", "status": 0, "seq": 1, "id": "16010", "created_at": 1747135539, "updated_at": 1747135539, "terms_created_at": 1722585569, "created_by": null, "updated_by": null }, { "termsid": 16011, "orderid": 5531, "jobmultiquoteid": 5555, "isresportshow": 1, "termsCategory": 3, "termsName": "Agreed Terms", "termsDescription": "
50% deposit with order with 40% due 3 days prior to installation<\/span>
<\/div>
Final 10% payable to fitters on completion.<\/span>
<\/div>
Payments can be made by BACS or credit\/debit card<\/span>
<\/div>
BACS details<\/span>
<\/div>
Account – Aquarius Blinds<\/span>
<\/div>
Account No – 40054837<\/span>
<\/div>
Sort code – 09-06-66<\/span>
<\/div>
Please refer to AQ reference number when making payments<\/span><\/div>", "status": 0, "seq": 2, "id": "16011", "created_at": 1747135539, "updated_at": 1747135539, "terms_created_at": 1722585569, "created_by": 1, "updated_by": null }, { "termsid": 16012, "orderid": 5531, "jobmultiquoteid": 5555, "isresportshow": 1, "termsCategory": 3, "termsName": "Contract Terms", "termsDescription": "
30 day terms<\/span>
<\/div>
Invoice payment due 30 days from invoice date<\/div>
Payments can be made by BACS or credit\/debit card <\/div>
BACS details Account – Aquarius Blinds Account No – 40054837 Sort code – 09-06-66<\/div><\/div>

<\/div>", "status": 0, "seq": 3, "id": "16012", "created_at": 1747135539, "updated_at": 1747135539, "terms_created_at": 1722585569, "created_by": 1, "updated_by": null }, { "termsid": 16013, "orderid": 5531, "jobmultiquoteid": 5555, "isresportshow": 1, "termsCategory": 3, "termsName": "Special Terms", "termsDescription": "
Payment in full with order. <\/span>
<\/div>
Payments can be made by BACS or credit\/debit card<\/span>
<\/div>
BACS details<\/span>
<\/div>
Account – Aquarius Blinds<\/span>
<\/div>
Account No – 40054837<\/span>
<\/div>
Sort code – 09-06-66<\/span>
<\/div>
Please refer to AQ reference number when making payments<\/span><\/div>", "status": 0, "seq": 4, "id": "16013", "created_at": 1747135539, "updated_at": 1747135539, "terms_created_at": 1722585569, "created_by": 1, "updated_by": null }, { "termsid": 16014, "orderid": 5531, "jobmultiquoteid": 5555, "isresportshow": 1, "termsCategory": 4, "termsName": "Standard", "termsDescription": "
50% deposit with order and balance due 3 days prior to <\/span>installation.<\/span>
<\/div>
Payments can be made by BACS or credit\/debit card<\/span>
<\/div>
BACS details<\/span>
<\/div>
Account – Aquarius Blinds<\/span>
<\/div>
Account No – 40054837<\/span>
<\/div>
Sort code – 09-06-66<\/span>
<\/div>
Please refer to AQ reference number when making payments<\/span><\/div><\/div>", "status": 0, "seq": 1, "id": "16014", "created_at": 1747135539, "updated_at": 1747135539, "terms_created_at": 1722585569, "created_by": null, "updated_by": null }, { "termsid": 16015, "orderid": 5531, "jobmultiquoteid": 5555, "isresportshow": 1, "termsCategory": 4, "termsName": "Agreed Terms", "termsDescription": "
50% deposit with order with 40% due 3 days prior to installation<\/span>
<\/div>
Final 10% payable to fitters on completion.<\/span>
<\/div>
Payments can be made by BACS or credit\/debit card<\/span>
<\/div>
BACS details<\/span>
<\/div>
Account – Aquarius Blinds<\/span>
<\/div>
Account No – 40054837<\/span>
<\/div>
Sort code – 09-06-66<\/span>
<\/div>
Please refer to AQ reference number when making payments<\/span><\/div>", "status": 0, "seq": 2, "id": "16015", "created_at": 1747135539, "updated_at": 1747135539, "terms_created_at": 1722585569, "created_by": 1, "updated_by": null }, { "termsid": 16016, "orderid": 5531, "jobmultiquoteid": 5555, "isresportshow": 1, "termsCategory": 4, "termsName": "Contract Terms", "termsDescription": "
30 day terms<\/span>
<\/div>
Invoice payment due 30 days from invoice date<\/div>
Payments can be made by BACS or credit\/debit card <\/div>
BACS details Account – Aquarius Blinds Account No – 40054837 Sort code – 09-06-66<\/div><\/div>

<\/div>", "status": 0, "seq": 3, "id": "16016", "created_at": 1747135539, "updated_at": 1747135539, "terms_created_at": 1722585569, "created_by": 1, "updated_by": null }, { "termsid": 16017, "orderid": 5531, "jobmultiquoteid": 5555, "isresportshow": 1, "termsCategory": 4, "termsName": "Special Terms", "termsDescription": "
Payment in full with order. <\/span>
<\/div>
Payments can be made by BACS or credit\/debit card<\/span>
<\/div>
BACS details<\/span>
<\/div>
Account – Aquarius Blinds<\/span>
<\/div>
Account No – 40054837<\/span>
<\/div>
Sort code – 09-06-66<\/span>
<\/div>
Please refer to AQ reference number when making payments<\/span><\/div>", "status": 0, "seq": 4, "id": "16017", "created_at": 1747135539, "updated_at": 1747135539, "terms_created_at": 1722585569, "created_by": 1, "updated_by": null } ], "updated": [], "deleted": [] }, "bm_jobmultiquote": { "created": [ { "jmq_id": 5555, "jmq_jobid": 5531, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "0.00", "jmq_netprice": "0.00", "jmq_vat": "0.00", "jmq_isvaton": 1, "jmq_deliverycost": "0.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 1, "jmq_orderformprice": "0.00", "jmq_editpricebyid": 0, "jmq_isroundon": 0, "jmq_grossprice": "0.00", "jmq_grossprofit": "0.00", "jmq_costprice": "0.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "0.00", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": null, "jmq_deliverycostid": 0, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 1, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 1, "jmq_endcustomeroverridevalue": null, "jmq_endcustomeroverridenetprice": "0.00", "jmq_endcustomeroverridevatprice": "0.00", "jmq_endcustomeroverridegrossprice": "0.00", "jmq_endcustomerdeliverycost": null, "jmq_endcustomerdeliverycostinclvat": 1, "jmq_endcustomerfittingcost": null, "jmq_endcustomerfittingcostinclvat": 1, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "0.000", "jmq_cdeliveryvatperc": "0.000", "id": "5555", "jmq_duedate": null, "jmq_sceduleddate": null, "jmq_createdat": "1747135539.000000", "jmq_updatedat": "1747135539.000000", "jmq_createdby": 2, "jmq_updatedby": null } ], "updated": [], "deleted": [] }, "bm_jobstatus_tracks": { "created": [ { "jst_id": 6138, "jst_jobid": 5530, "jst_job_current_status": 1, "id": "6138", "jst_createdat": "1747131563.354603" }, { "jst_id": 6139, "jst_jobid": 5531, "jst_job_current_status": 3, "id": "6139", "jst_createdat": "1747135539.451156" }, { "jst_id": 6140, "jst_jobid": 5531, "jst_job_current_status": 1, "id": "6140", "jst_createdat": "1747136144.256948" }, { "jst_id": 6141, "jst_jobid": 5531, "jst_job_current_status": 4, "id": "6141", "jst_createdat": "1747136158.075387" } ], "updated": [], "deleted": [] }, "bm_customindividuallogs": { "created": [ { "cl_id": 52881, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 5531, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5531, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 2, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"Aquarius Blinds\",\"Account Type\":\"Domestic\",\"Source\":\"Google\",\"Created By\":\"Andrew\",\"First Name\":\"Test\",\"Last Name\":\"Test\",\"Address1\":\"Church Road\",\"Town \\\/ City\":\"Mitcham\",\"Zipcode \\\/ Postcode\":\"CR4 3BH\",\"Country\":\"UK\",\"Salutation\":\"Mr.\",\"Assigned to\":2,\"Role\":1,\"Additional Contacts\":\"2587\",\"Job Status\":\"Quote\",\"Order Status\":\"Enquiry\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"jd_isonlineorder\":1,\"End Customer Override Type\":1,\"End Customer Delivery Cost Include Vat\":1,\"End Customer Fitting Cost Include Vat\":1,\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":5531,\"jd_customerid\":2466,\"jd_contactid\":2587,\"jd_additionalcontacts\":\"2587\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"33\\\":\\\"25\\\",\\\"37\\\":1,\\\"39\\\":25,\\\"41\\\":2,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"Test\\\",\\\"46\\\":\\\"Test\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"Church Road\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"Mitcham\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"CR4 3BH\\\",\\\"54\\\":19,\\\"285\\\":1,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":2,\\\"558\\\":1,\\\"559\\\":1,\\\"610\\\":\\\"\\\",\\\"611\\\":\\\"\\\",\\\"612\\\":1}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-05-13\",\"jd_orderdate\":\"0000-00-00\",\"jd_duedate\":\"0000-00-00\",\"jd_sceduleddate\":\"0000-00-00\",\"jd_invoicedate\":\"0000-00-00\",\"jd_completeddate\":\"0000-00-00\",\"jd_jobref\":null,\"jd_jobstatus\":3,\"jd_contactaddid\":0,\"jd_orderstatus\":13,\"jd_accref\":\"TEST1001\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"0.00\",\"jd_netprice\":\"0.00\",\"jd_vat\":\"0.00\",\"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\":\"0.00\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"0.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"0.00\",\"jd_totpaid\":\"0.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":\"\\\"\\\"\",\"jd_deliverycostid\":0,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":1,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":1,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":1,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":null,\"jd_organizationid\":0,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":2,\"jd_createdat\":\"2025-05-13T11:25:39.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-05-13T11:25:39.000000Z\",\"salesorderid\":null,\"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\":\"0.000\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"0.000\",\"jd_commission\":\"[]\",\"jd_commissionprice\":\"0.00\",\"jd_commissionsetting\":0,\"jd_commissionaddedvalue\":\"0.00\",\"jd_onlineprefixseq\":\"\",\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":0,\"jd_rework_count\":0}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "52881", "cl_createdat": "1747135539.000000", "cl_updatedat": null }, { "cl_id": 52897, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment", "cl_message": "new item has been created in Appointment", "cl_event": "created", "cl_subjectid": 9945, "cl_subjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_parentid": 5531, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 2, "cl_changedfrom": "null", "cl_changedto": "{\"Repeat On\":\"yearly on May 13\",\"app_summary\":\"AQ5540-Test Test-Church Road-Surveyor\",\"Appointment Type\":\"Surveyor\",\"Staff\":\"Andrew\",\"Job Ref No\":\"AQ5540\",\"Start Date & Time\":\"2025-05-13 10:30:00\",\"End Date & Time\":\"2025-05-13 11:30:00\",\"Appointment Status\":\"Waiting\",\"app_deliveryaddressid\":2587,\"app_jobtimehour\":\"1\",\"app_products\":\"[]\"}", "cl_customproperties": "{\"attributes\":{\"app_eventid\":9945,\"app_description\":\"\",\"app_summary\":\"AQ5540-Test Test-Church Road-Surveyor\",\"app_private\":0,\"app_appointmentType\":63,\"app_userId\":2,\"app_orderId\":5531,\"app_customerId\":0,\"app_isAllDay\":0,\"app_sdate\":\"2025-05-13\",\"app_edate\":\"2025-05-13\",\"app_stime\":\"10:30:00\",\"app_etime\":\"11:30:00\",\"app_sdatetime\":\"2025-05-13 10:30:00\",\"app_edatetime\":\"2025-05-13 11:30:00\",\"app_timezone\":\"Asia\\\/Calcutta\",\"app_latitude\":null,\"app_longitude\":null,\"app_parentappid\":null,\"app_recurrencerule\":null,\"app_userdefinedValue\":\"[]\",\"app_recurrenceexception\":null,\"app_recurrenceexception_date\":null,\"app_attachment\":null,\"guid\":\"\",\"app_until\":null,\"app_staff\":\"\",\"app_appointtype\":\"\",\"app_confirmed\":0,\"app_coordinates\":\"\",\"app_travelHour\":\"0\",\"app_travelMinute\":\"0\",\"app_onsiteHour\":\"0\",\"app_onsiteMinute\":\"0\",\"app_location\":null,\"app_traveltime\":null,\"app_googleid\":\"0\",\"app_platform\":\"web\",\"app_cal_status\":868,\"app_status\":0,\"app_markasread\":0,\"app_statusInGoogle\":0,\"app_createdBy\":2,\"app_updatedBy\":null,\"app_createdAt\":\"2025-05-13T11:28:55.000000Z\",\"app_updatedAt\":\"2025-05-13T11:28:55.000000Z\",\"app_runid\":null,\"app_deliveryaddressid\":2587,\"app_jobtimehour\":\"1\",\"app_jobtimeminute\":\"0\",\"app_products\":\"[]\",\"app_deviceplatform\":0}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "52897", "cl_createdat": "1747135735.000000", "cl_updatedat": null }, { "cl_id": 52898, "cl_logname": "default", "cl_type": null, "cl_modulename": "Task", "cl_message": "new item has been created in Task", "cl_event": "created", "cl_subjectid": 50, "cl_subjecttype": "App\\Models\\Task\\bm_tasklist", "cl_parentid": 4094, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 8, "cl_changedfrom": "null", "cl_changedto": "{\"Job Ref No\":\"AQ4118\",\"Task Date\":\"2025-05-13\",\"Task Time\":\"00:00:00\",\"Created By\":\"Arun\",\"Description\":\"jkjk\",\"Category\":\"Critical\",\"Repeat Method\":\"daily\",\"tl_subject\":\"hjk\",\"tl_immediate_notification\":1}", "cl_customproperties": "{\"attributes\":{\"tl_id\":50,\"tl_orderid\":4094,\"tl_taskcategory\":0,\"tl_taskdate\":\"2025-05-13\",\"tl_tasktime\":\"00:00:00\",\"tl_taskmethod\":\"0\",\"tl_istaskprivate\":0,\"tl_userid\":\"18\",\"tl_priority\":0,\"tl_addjobid\":4094,\"tl_desc\":\"jkjk\",\"tl_status\":0,\"tl_markasread\":0,\"tl_taskstatus\":1,\"tl_userdefinedfields\":\"[]\",\"tl_markcompleted\":0,\"tl_jobmode\":\"contact\",\"tl_recurrencerule\":\"\",\"tl_repeatmaindescription\":\"\",\"tl_repeatmethod\":\"daily\",\"tl_starttask\":\"\",\"tl_startdata\":\"\",\"tl_endtask\":\"\",\"tl_enddata\":\"\",\"tl_createdat\":\"2025-05-13T11:29:42.000000Z\",\"tl_createdby\":8,\"tl_updatedby\":null,\"tl_updatedat\":\"2025-05-13T11:29:42.000000Z\",\"tl_istaskrepeat\":0,\"tl_deviceplatform\":0,\"tl_subject\":\"hjk\",\"tl_immediate_notification\":1,\"tl_parent_task_id\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "52898", "cl_createdat": "1747135782.000000", "cl_updatedat": null }, { "cl_id": 52899, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment-Notification", "cl_message": "new item has been created in Appointment-Notification", "cl_event": "created", "cl_subjectid": 48, "cl_subjecttype": "App\\Models\\Task\\bm_tasknotification", "cl_parentid": 77, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 8, "cl_changedfrom": "null", "cl_changedto": "{\"tn_id\":48,\"tn_noficationfrom\":\"task\",\"Notification Type\":\"0\",\"Notification Time\":\"00:00:00\",\"created_by\":8,\"created_at\":\"2025-05-13T11:29:42.000000Z\",\"bm_tasklist_tl_id\":50}", "cl_customproperties": "{\"attributes\":{\"tn_id\":48,\"tn_noficationfrom\":\"task\",\"tn_noficationtype\":\"0\",\"tn_noficationtime\":\"00:00:00\",\"tn_templateid\":null,\"tn_status\":0,\"created_by\":8,\"created_at\":\"2025-05-13T11:29:42.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-05-13T11:29:42.000000Z\",\"bm_tasklist_tl_id\":50,\"tn_reminder_value\":null,\"tn_reminder_before\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "52899", "cl_createdat": "1747135782.000000", "cl_updatedat": null }, { "cl_id": 52900, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment-Notification", "cl_message": "new item has been created in Appointment-Notification", "cl_event": "created", "cl_subjectid": 49, "cl_subjecttype": "App\\Models\\Task\\bm_tasknotification", "cl_parentid": 49, "cl_parentsubjecttype": "App\\Models\\Task\\bm_tasknotification", "cl_causerid": 8, "cl_changedfrom": "null", "cl_changedto": "{\"tn_id\":49,\"tn_noficationfrom\":\"task\",\"Notification Type\":\"0\",\"Notification Time\":\"00:00:00\",\"created_by\":8,\"created_at\":\"2025-05-13T11:29:48.000000Z\",\"bm_tasklist_tl_id\":0}", "cl_customproperties": "{\"attributes\":{\"tn_id\":49,\"tn_noficationfrom\":\"task\",\"tn_noficationtype\":\"0\",\"tn_noficationtime\":\"00:00:00\",\"tn_templateid\":null,\"tn_status\":0,\"created_by\":8,\"created_at\":\"2025-05-13T11:29:48.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-05-13T11:29:48.000000Z\",\"bm_tasklist_tl_id\":0,\"tn_reminder_value\":null,\"tn_reminder_before\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "52900", "cl_createdat": "1747135788.000000", "cl_updatedat": null }, { "cl_id": 52901, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment-Notification", "cl_message": "new item has been created in Appointment-Notification", "cl_event": "created", "cl_subjectid": 50, "cl_subjecttype": "App\\Models\\Task\\bm_tasknotification", "cl_parentid": 50, "cl_parentsubjecttype": "App\\Models\\Task\\bm_tasknotification", "cl_causerid": 8, "cl_changedfrom": "null", "cl_changedto": "{\"tn_id\":50,\"tn_noficationfrom\":\"task\",\"Notification Type\":\"0\",\"Notification Time\":\"00:00:00\",\"created_by\":8,\"created_at\":\"2025-05-13T11:30:11.000000Z\",\"bm_tasklist_tl_id\":0}", "cl_customproperties": "{\"attributes\":{\"tn_id\":50,\"tn_noficationfrom\":\"task\",\"tn_noficationtype\":\"0\",\"tn_noficationtime\":\"00:00:00\",\"tn_templateid\":null,\"tn_status\":0,\"created_by\":8,\"created_at\":\"2025-05-13T11:30:11.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-05-13T11:30:11.000000Z\",\"bm_tasklist_tl_id\":0,\"tn_reminder_value\":null,\"tn_reminder_before\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "52901", "cl_createdat": "1747135811.000000", "cl_updatedat": null }, { "cl_id": 52902, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment", "cl_message": "new item has been created in Appointment", "cl_event": "created", "cl_subjectid": 9946, "cl_subjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_parentid": 5531, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 2, "cl_changedfrom": "null", "cl_changedto": "{\"Repeat On\":\"yearly on May 13\",\"app_summary\":\"AQ5540-Test Test-Church Road-Surveyor\",\"Appointment Type\":\"Surveyor\",\"Staff\":\"Andrew\",\"Job Ref No\":\"AQ5540\",\"Start Date & Time\":\"2025-05-13 11:30:00\",\"End Date & Time\":\"2025-05-13 12:30:00\",\"Appointment Status\":\"Waiting\",\"app_deliveryaddressid\":2587,\"app_jobtimehour\":\"1\",\"app_products\":\"[]\"}", "cl_customproperties": "{\"attributes\":{\"app_eventid\":9946,\"app_description\":\"\",\"app_summary\":\"AQ5540-Test Test-Church Road-Surveyor\",\"app_private\":0,\"app_appointmentType\":63,\"app_userId\":2,\"app_orderId\":5531,\"app_customerId\":0,\"app_isAllDay\":0,\"app_sdate\":\"2025-05-13\",\"app_edate\":\"2025-05-13\",\"app_stime\":\"11:30:00\",\"app_etime\":\"12:30:00\",\"app_sdatetime\":\"2025-05-13 11:30:00\",\"app_edatetime\":\"2025-05-13 12:30:00\",\"app_timezone\":\"Asia\\\/Calcutta\",\"app_latitude\":null,\"app_longitude\":null,\"app_parentappid\":null,\"app_recurrencerule\":null,\"app_userdefinedValue\":\"[]\",\"app_recurrenceexception\":null,\"app_recurrenceexception_date\":null,\"app_attachment\":null,\"guid\":\"\",\"app_until\":null,\"app_staff\":\"\",\"app_appointtype\":\"\",\"app_confirmed\":0,\"app_coordinates\":\"\",\"app_travelHour\":\"0\",\"app_travelMinute\":\"0\",\"app_onsiteHour\":\"0\",\"app_onsiteMinute\":\"0\",\"app_location\":null,\"app_traveltime\":null,\"app_googleid\":\"0\",\"app_platform\":\"web\",\"app_cal_status\":868,\"app_status\":0,\"app_markasread\":0,\"app_statusInGoogle\":0,\"app_createdBy\":2,\"app_updatedBy\":null,\"app_createdAt\":\"2025-05-13T11:34:59.000000Z\",\"app_updatedAt\":\"2025-05-13T11:34:59.000000Z\",\"app_runid\":null,\"app_deliveryaddressid\":2587,\"app_jobtimehour\":\"1\",\"app_jobtimeminute\":\"0\",\"app_products\":\"[]\",\"app_deviceplatform\":0}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "52902", "cl_createdat": "1747136099.000000", "cl_updatedat": null }, { "cl_id": 52903, "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 Do not use Pleated blinds", "cl_event": "created", "cl_subjectid": 31044, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 5530, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Supplier\":\" Markilux\",\" Room\":\" 3\",\" Blind or Recess\":\" Recess size\",\" Width\":\" 500\",\" Drop\":\" 610\",\" Product Type\":\" Band AB\"}", "cl_customproperties": "{\"attributes\":{\"oi_id\":31044,\"oi_jobid\":5530,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":5554,\"oi_credit_id\":0,\"oi_productid\":8,\"oi_recipeid\":8,\"oi_ruleid\":0,\"oi_qty\":1,\"oi_seq\":1,\"oi_customseq\":1,\"oi_productcustomseq\":1,\"oi_jsondata\":\"[{\\\"id\\\":6886,\\\"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\\\":6886,\\\"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\\\":247,\\\"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\\\":247,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":248,\\\"labelname\\\":\\\"Supplier\\\",\\\"value\\\":\\\"1\\\",\\\"valueid\\\":null,\\\"type\\\":17,\\\"optionid\\\":\\\"1\\\",\\\"optionvalue\\\":[{\\\"id\\\":1,\\\"optionid\\\":1,\\\"optionname\\\":\\\"Markilux\\\",\\\"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\\\":248,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":\\\"1\\\",\\\"optionsvalue\\\":[{\\\"id\\\":1,\\\"optionid\\\":1,\\\"optionname\\\":\\\"Markilux\\\",\\\"deleted\\\":0,\\\"optionquantity\\\":1}],\\\"editruleoverride\\\":1},{\\\"id\\\":250,\\\"labelname\\\":\\\"Room\\\",\\\"value\\\":\\\"3\\\",\\\"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\\\":250,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":1},{\\\"id\\\":251,\\\"labelname\\\":\\\"Blind or Recess\\\",\\\"value\\\":\\\"Recess size\\\",\\\"valueid\\\":\\\"726\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"475\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":475,\\\"optionqty\\\":\\\"1\\\",\\\"optioncode\\\":\\\"jcld\\\",\\\"optionname\\\":\\\"Recess size\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":726,\\\"forchildfieldoptionlinkid\\\":\\\"3_726\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":null}],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Blind or Recess\\\",\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":null,\\\"widthfractiontext\\\":null,\\\"dropfractiontext\\\":null,\\\"dropfraction\\\":null,\\\"showfieldonjob\\\":1,\\\"showFieldOnCustomerPortal\\\":1,\\\"optionquantity\\\":\\\"1\\\",\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":1,\\\"fieldtypeid\\\":3,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Blind or Recess\\\",\\\"fieldid\\\":251,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":\\\"475\\\",\\\"optionsvalue\\\":[{\\\"optionid\\\":475,\\\"optionqty\\\":\\\"1\\\",\\\"optioncode\\\":\\\"jcld\\\",\\\"optionname\\\":\\\"Recess size\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":726,\\\"forchildfieldoptionlinkid\\\":\\\"3_726\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":null}],\\\"editruleoverride\\\":1},{\\\"id\\\":252,\\\"labelname\\\":\\\"Width\\\",\\\"value\\\":\\\"500\\\",\\\"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\\\":252,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":1},{\\\"id\\\":253,\\\"labelname\\\":\\\"Drop\\\",\\\"value\\\":\\\"610\\\",\\\"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\\\":253,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":1},{\\\"id\\\":249,\\\"labelname\\\":\\\"Product Type\\\",\\\"value\\\":\\\"452\\\",\\\"valueid\\\":\\\"553\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"452\\\",\\\"optionvalue\\\":[{\\\"id\\\":553,\\\"fieldid\\\":249,\\\"fieldoptionlinkid\\\":553,\\\"optionid\\\":452,\\\"mainsupplier\\\":\\\"1\\\",\\\"blindtypecode\\\":null,\\\"optionname\\\":\\\"Band AB\\\",\\\"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\\\":0,\\\"optionquantity\\\":null,\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":1,\\\"fieldtypeid\\\":13,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Product Type\\\",\\\"fieldid\\\":249,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":\\\"452\\\",\\\"optionsvalue\\\":[{\\\"id\\\":553,\\\"fieldid\\\":249,\\\"fieldoptionlinkid\\\":553,\\\"optionid\\\":452,\\\"mainsupplier\\\":\\\"1\\\",\\\"blindtypecode\\\":null,\\\"optionname\\\":\\\"Band AB\\\",\\\"optionquantity\\\":1,\\\"subcount\\\":0,\\\"status\\\":0,\\\"subdatacount\\\":0}],\\\"editruleoverride\\\":1},{\\\"id\\\":259,\\\"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\\\":259,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":304,\\\"labelname\\\":\\\"Blind Model\\\",\\\"value\\\":null,\\\"valueid\\\":null,\\\"type\\\":3,\\\"optionid\\\":null,\\\"optionvalue\\\":[],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Blind Model\\\",\\\"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 Model\\\",\\\"fieldid\\\":304,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":254,\\\"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\\\":254,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":255,\\\"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\\\":255,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":305,\\\"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\\\":305,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":256,\\\"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\\\":256,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":257,\\\"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\\\":257,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":258,\\\"labelname\\\":\\\"Special Instructions\\\",\\\"value\\\":null,\\\"valueid\\\":null,\\\"type\\\":18,\\\"optionid\\\":null,\\\"optionvalue\\\":[],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Special 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\\\":\\\"Special Instructions\\\",\\\"fieldid\\\":258,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0}]\",\"oi_description\":\"Supplier: Markilux, Room: 3, Blind or Recess: Recess size, Width: 500, Drop: 610, Product Type: Band AB\",\"oi_onlinedescription\":\"Unit Type: mm, Quantity: 1, Supplier: Markilux, Room: 3, Blind or Recess: Recess size, Width: 500, Drop: 610\",\"oi_imagepath\":null,\"oi_reportdescription\":\"##Quantity: 1##,##Supplier: Markilux##,##Room: 3##,##Blind or Recess: Recess size##,##Width: 500 mm##,##Drop: 610 mm##,##Product Type: Band AB##\",\"oi_onlinereportdescription\":\"##Quantity: 1##, ##Supplier: Markilux##, ##Room: 3##, ##Blind or Recess: Recess size##, ##Width: 500 mm##, ##Drop: 610 mm##\",\"oi_reporttitles\":\"##Quantity:<\\\/br>##Supplier:<\\\/br>##Room:<\\\/br>##Blind or Recess:<\\\/br>##Width:<\\\/br>##Drop:<\\\/br>##Product Type:\",\"oi_onlinereporttitles\":\"##Quantity:, ##Supplier:, ##Room:, ##Blind or Recess:, ##Width:, ##Drop:\",\"oi_productionformulajsondata\":\"[{\\\"productionoveride\\\":0,\\\"id\\\":34,\\\"value\\\":null,\\\"formula\\\":\\\"5\\\",\\\"price\\\":null,\\\"recipeid\\\":8,\\\"stockupdate\\\":0,\\\"fieldid\\\":null,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":35,\\\"value\\\":\\\"500.00\\\",\\\"formula\\\":\\\"Width\\\",\\\"price\\\":null,\\\"recipeid\\\":8,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":\\\"500.00\\\"},{\\\"productionoveride\\\":0,\\\"id\\\":36,\\\"value\\\":\\\"610.00\\\",\\\"formula\\\":\\\"Drop\\\",\\\"price\\\":null,\\\"recipeid\\\":8,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":\\\"610.00\\\"},{\\\"productionoveride\\\":0,\\\"id\\\":38,\\\"value\\\":null,\\\"formula\\\":\\\"Quantity\\\",\\\"price\\\":null,\\\"recipeid\\\":8,\\\"stockupdate\\\":0,\\\"fieldid\\\":22394,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":3,\\\"option_name\\\":\\\"Test Option\\\",\\\"fractionvalue\\\":null}]\",\"oi_productiondate\":\"2025-05-13 17:04:31\",\"oi_operationstatus\":\"0\",\"oi_scanstatus\":\"\",\"oi_operationworkroom_data\":\"[{\\\"link_id\\\":10,\\\"process_id\\\":1,\\\"product_id\\\":8,\\\"phc_id\\\":10,\\\"pd_id\\\":1,\\\"name\\\":\\\"Office Check\\\",\\\"phc_linkstations\\\":1,\\\"quantity\\\":1,\\\"link_to\\\":\\\"WORKROOM\\\",\\\"phc_processhascost\\\":0,\\\"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\\\":null,\\\"phc_contacttype\\\":null,\\\"phc_hascontacttypeall\\\":1,\\\"phc_hascustomerstypeall\\\":1,\\\"cost_price\\\":\\\"10.00\\\",\\\"Hour\\\\\\\/mins\\\":\\\"5 mins\\\",\\\"phc_processcostid\\\":1,\\\"markupprice\\\":\\\"10.00\\\",\\\"price\\\":\\\"0.00\\\"},{\\\"link_id\\\":7,\\\"process_id\\\":4,\\\"product_id\\\":8,\\\"phc_id\\\":7,\\\"pd_id\\\":4,\\\"name\\\":\\\"Tube cut\\\",\\\"phc_linkstations\\\":4,\\\"quantity\\\":1,\\\"link_to\\\":\\\"WORKROOM\\\",\\\"phc_processhascost\\\":0,\\\"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\\\":null,\\\"phc_contacttype\\\":null,\\\"phc_hascontacttypeall\\\":1,\\\"phc_hascustomerstypeall\\\":1,\\\"cost_price\\\":\\\"10.00\\\",\\\"Hour\\\\\\\/mins\\\":\\\"5 mins\\\",\\\"phc_processcostid\\\":1,\\\"markupprice\\\":\\\"10.00\\\",\\\"price\\\":\\\"0.00\\\"},{\\\"link_id\\\":8,\\\"process_id\\\":3,\\\"product_id\\\":8,\\\"phc_id\\\":8,\\\"pd_id\\\":3,\\\"name\\\":\\\"Fabric cut\\\",\\\"phc_linkstations\\\":3,\\\"quantity\\\":1,\\\"link_to\\\":\\\"WORKROOM\\\",\\\"phc_processhascost\\\":0,\\\"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\\\":null,\\\"phc_contacttype\\\":null,\\\"phc_hascontacttypeall\\\":1,\\\"phc_hascustomerstypeall\\\":1,\\\"cost_price\\\":\\\"10.00\\\",\\\"Hour\\\\\\\/mins\\\":\\\"5 mins\\\",\\\"phc_processcostid\\\":1,\\\"markupprice\\\":\\\"10.00\\\",\\\"price\\\":\\\"0.00\\\"},{\\\"link_id\\\":9,\\\"process_id\\\":2,\\\"product_id\\\":8,\\\"phc_id\\\":9,\\\"pd_id\\\":2,\\\"name\\\":\\\"Stock Pick\\\",\\\"phc_linkstations\\\":2,\\\"quantity\\\":1,\\\"link_to\\\":\\\"WORKROOM\\\",\\\"phc_processhascost\\\":0,\\\"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\\\":null,\\\"phc_contacttype\\\":null,\\\"phc_hascontacttypeall\\\":1,\\\"phc_hascustomerstypeall\\\":1,\\\"cost_price\\\":\\\"10.00\\\",\\\"Hour\\\\\\\/mins\\\":\\\"10 mins\\\",\\\"phc_processcostid\\\":1,\\\"markupprice\\\":\\\"10.00\\\",\\\"price\\\":\\\"0.00\\\"},{\\\"link_id\\\":6,\\\"process_id\\\":5,\\\"product_id\\\":8,\\\"phc_id\\\":6,\\\"pd_id\\\":5,\\\"name\\\":\\\"Assemble\\\",\\\"phc_linkstations\\\":5,\\\"quantity\\\":1,\\\"link_to\\\":\\\"WORKROOM\\\",\\\"phc_processhascost\\\":0,\\\"phc_processhastime\\\":1,\\\"phc_costtype\\\":2,\\\"phc_domesticsellingprice\\\":\\\"15.00\\\",\\\"phc_contractsellingprice\\\":\\\"15.00\\\",\\\"phc_tradesellingprice\\\":\\\"15.00\\\",\\\"phc_dynamiccontact5_sellingprice\\\":\\\"0.00\\\",\\\"phc_dynamiccontact6_sellingprice\\\":\\\"0.00\\\",\\\"phc_dynamiccontact7_sellingprice\\\":\\\"0.00\\\",\\\"phc_dynamiccontact8_sellingprice\\\":\\\"0.00\\\",\\\"phc_ecommercesellingprice\\\":\\\"15.00\\\",\\\"phc_customers\\\":null,\\\"phc_contacttype\\\":null,\\\"phc_hascontacttypeall\\\":1,\\\"phc_hascustomerstypeall\\\":1,\\\"cost_price\\\":\\\"15.00\\\",\\\"Hour\\\\\\\/mins\\\":\\\"5 mins\\\",\\\"phc_processcostid\\\":1,\\\"markupprice\\\":\\\"15.00\\\",\\\"price\\\":\\\"0.00\\\"}]\",\"oi_operationcalender_data\":\"[]\",\"oi_operation_calculations\":\"{\\\"calendar\\\":\\\"0.00\\\",\\\"workroom\\\":\\\"55.00\\\",\\\"cost_with_discount\\\":\\\"55.00\\\",\\\"cost_with_markup\\\":\\\"55.00\\\",\\\"gross_price\\\":\\\"55.00\\\",\\\"vat_price\\\":\\\"0.00\\\"}\",\"oi_pricecomesfrom_calculations\":\"[]\",\"oi_pricetablepriceevenbom\":\"{\\\"sellingPrice\\\":10,\\\"pricetableCostAfterSuppdisc\\\":10,\\\"priceTableCost\\\":10}\",\"oi_productionstatus\":null,\"oi_costoverride\":0,\"oi_costprice\":\"55.000\",\"oi_netprice\":\"55.000\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"0.000\",\"oi_vatvalue\":\"0.000\",\"oi_vatselected\":0,\"oi_vattype\":2,\"oi_vatonoff\":1,\"oi_grossprice\":\"55.000\",\"oi_overrideprice\":\"0.000\",\"oi_overridetype\":1,\"oi_overridevalue\":null,\"oi_overridenetprice\":\"0.000\",\"oi_overridevatprice\":\"0.000\",\"oi_overridegrossprice\":\"0.000\",\"oi_ready\":0,\"oi_onhold\":0,\"oi_platformcreatedfrom\":\"web\",\"oi_platformlastupdatedfrom\":\"web\",\"oi_copiedfrom\":0,\"oi_isonlineorder\":1,\"oi_endcustomervatprice\":null,\"oi_endcustomeroverridetype\":1,\"oi_endcustomeroverridevalue\":null,\"oi_endcustomeroverridenetprice\":\"55.000\",\"oi_endcustomeroverridevatprice\":\"0.000\",\"oi_endcustomeroverridegrossprice\":\"55.000\",\"oi_sage_flag\":0,\"oi_supid\":null,\"oi_status\":0,\"oi_createdby\":1,\"oi_createdat\":\"2025-05-13T17:04:31.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":\"2025-05-13T11:35:05.000000Z\",\"oi_jsondataid\":\"[6886, 247, 248, 250, 251, 252, 253, 249, 259, 304, 254, 255, 305, 256, 257, 258]\",\"oi_deviceplatform\":0,\"oi_custompricefields\":\"\",\"oi_editransfer\":0,\"oi_apisup_orderid\":0,\"lineitem_id\":null,\"oi_commissionprice\":\"0.000\",\"oi_commissionvatprice\":\"0.000\",\"oi_jsondatabackup\":\"\",\"oi_stockdeduct\":0,\"oi_deductedstockdetails\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "52903", "cl_createdat": "1747136105.000000", "cl_updatedat": null }, { "cl_id": 52904, "cl_logname": "model", "cl_type": null, "cl_modulename": "Production Due Date", "cl_message": "Production Due Date has been updated", "cl_event": "modified", "cl_subjectid": 5530, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5530, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "{\"Production Due Date\":\"0000-00-00\"}", "cl_changedto": "{\"Production Due Date\":\"2025-05-13\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "52904", "cl_createdat": "1747136105.000000", "cl_updatedat": null }, { "cl_id": 52905, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the fields Net Price,Gross Price Amount,Gross Profit Percentage,Total CostPrice,Amount Outstanding", "cl_event": "modified", "cl_subjectid": 5530, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5530, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "{\"Net Price\":\"70.00\",\"Gross Price Amount\":\"70.00\",\"Gross Profit Percentage\":\"0.00\",\"Total CostPrice\":\"0.00\",\"Amount Outstanding\":\"70.00\"}", "cl_changedto": "{\"Net Price\":\"125.00\",\"Gross Price Amount\":\"125.00\",\"Gross Profit Percentage\":\"56.00\",\"Total CostPrice\":\"55.00\",\"Amount Outstanding\":\"125.00\"}", "cl_customproperties": "{\"attributes\":{\"jd_listprice\":\"125.00\",\"jd_netprice\":\"125.00\",\"jd_grossprice\":\"125.00\",\"jd_grossprofit_percentage\":\"56.00\",\"jd_costprice\":\"55.00\",\"jd_amountoutstanding\":\"125.00\",\"jd_updatedat\":\"2025-05-13T11:35:07.000000Z\"},\"old\":{\"jd_listprice\":\"0.00\",\"jd_netprice\":\"70.00\",\"jd_grossprice\":\"70.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"0.00\",\"jd_amountoutstanding\":\"70.00\",\"jd_updatedat\":\"2025-05-13T11:35:05.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "52905", "cl_createdat": "1747136107.000000", "cl_updatedat": null }, { "cl_id": 52906, "cl_logname": "model", "cl_type": "QUEUE_11", "cl_modulename": "Job Status", "cl_message": "Job Status has been updated", "cl_event": "modified", "cl_subjectid": 5531, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5531, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 2, "cl_changedfrom": "{\"Job Status\":\"Quote\"}", "cl_changedto": "{\"Job Status\":\"Lead\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "52906", "cl_createdat": "1747136144.000000", "cl_updatedat": null }, { "cl_id": 52907, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment", "cl_message": "new item has been created in Appointment", "cl_event": "created", "cl_subjectid": 9947, "cl_subjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_parentid": 5531, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 2, "cl_changedfrom": "null", "cl_changedto": "{\"Repeat On\":\"yearly on May 13\",\"app_summary\":\"AQ5540-Test Test-Church Road-Surveyor\",\"Appointment Type\":\"Surveyor\",\"Staff\":\"Andrew\",\"Job Ref No\":\"AQ5540\",\"Start Date & Time\":\"2025-05-15 11:30:00\",\"End Date & Time\":\"2025-05-15 12:30:00\",\"Appointment Status\":\"Waiting\",\"app_deliveryaddressid\":2587,\"app_jobtimehour\":\"1\",\"app_products\":\"[]\"}", "cl_customproperties": "{\"attributes\":{\"app_eventid\":9947,\"app_description\":\"\",\"app_summary\":\"AQ5540-Test Test-Church Road-Surveyor\",\"app_private\":0,\"app_appointmentType\":63,\"app_userId\":2,\"app_orderId\":5531,\"app_customerId\":0,\"app_isAllDay\":0,\"app_sdate\":\"2025-05-15\",\"app_edate\":\"2025-05-15\",\"app_stime\":\"11:30:00\",\"app_etime\":\"12:30:00\",\"app_sdatetime\":\"2025-05-15 11:30:00\",\"app_edatetime\":\"2025-05-15 12:30:00\",\"app_timezone\":\"Asia\\\/Calcutta\",\"app_latitude\":null,\"app_longitude\":null,\"app_parentappid\":null,\"app_recurrencerule\":null,\"app_userdefinedValue\":\"[]\",\"app_recurrenceexception\":null,\"app_recurrenceexception_date\":null,\"app_attachment\":null,\"guid\":\"\",\"app_until\":null,\"app_staff\":\"\",\"app_appointtype\":\"\",\"app_confirmed\":0,\"app_coordinates\":\"\",\"app_travelHour\":\"0\",\"app_travelMinute\":\"0\",\"app_onsiteHour\":\"0\",\"app_onsiteMinute\":\"0\",\"app_location\":null,\"app_traveltime\":null,\"app_googleid\":\"0\",\"app_platform\":\"web\",\"app_cal_status\":868,\"app_status\":0,\"app_markasread\":0,\"app_statusInGoogle\":0,\"app_createdBy\":2,\"app_updatedBy\":null,\"app_createdAt\":\"2025-05-13T11:35:57.000000Z\",\"app_updatedAt\":\"2025-05-13T11:35:57.000000Z\",\"app_runid\":null,\"app_deliveryaddressid\":2587,\"app_jobtimehour\":\"1\",\"app_jobtimeminute\":\"0\",\"app_products\":\"[]\",\"app_deviceplatform\":0}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "52907", "cl_createdat": "1747136157.000000", "cl_updatedat": null }, { "cl_id": 52908, "cl_logname": "model", "cl_type": "QUEUE_11", "cl_modulename": "Job Status", "cl_message": "Job Status has been updated", "cl_event": "modified", "cl_subjectid": 5531, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5531, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 2, "cl_changedfrom": "{\"Job Status\":\"Lead\"}", "cl_changedto": "{\"Job Status\":\"Order\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "52908", "cl_createdat": "1747136158.000000", "cl_updatedat": null }, { "cl_id": 52909, "cl_logname": "QUEUE_11", "cl_type": "QUEUE_11", "cl_modulename": "Job", "cl_message": "Job has been updated the field Job Rework Enable", "cl_event": "modified", "cl_subjectid": 5531, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5531, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 2, "cl_changedfrom": "{\"Job Rework Enable\":\"Off\"}", "cl_changedto": "{\"Job Rework Enable\":\"On\"}", "cl_customproperties": "{\"attributes\":{\"jd_jobstatus\":4,\"jd_updatedat\":\"2025-05-13T11:35:58.000000Z\",\"jd_rework_enable\":1},\"old\":{\"jd_jobstatus\":1,\"jd_updatedat\":\"2025-05-13T11:35:44.000000Z\",\"jd_rework_enable\":0}}", "cl_attachment": null, "cl_deviceplatform": "", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "52909", "cl_createdat": "1747136158.000000", "cl_updatedat": null }, { "cl_id": 52910, "cl_logname": "default", "cl_type": null, "cl_modulename": "Line Item", "cl_message": "Q1 - Line Item has been updated the fields Production Date,oi_operationworkroom_data for the product of Do not use Pleated blinds", "cl_event": "modified", "cl_subjectid": 31044, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 5530, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "{\"Production Date\":\"2025-05-13 17:04:31\",\"oi_operationworkroom_data\":\"[{\\\"link_id\\\":10,\\\"process_id\\\":1,\\\"product_id\\\":8,\\\"phc_id\\\":10,\\\"pd_id\\\":1,\\\"name\\\":\\\"Office Check\\\",\\\"phc_linkstations\\\":1,\\\"quantity\\\":1,\\\"link_to\\\":\\\"WORKROOM\\\",\\\"phc_processhascost\\\":0,\\\"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\\\":null,\\\"phc_contacttype\\\":null,\\\"phc_hascontacttypeall\\\":1,\\\"phc_hascustomerstypeall\\\":1,\\\"cost_price\\\":\\\"10.00\\\",\\\"Hour\\\\\\\/mins\\\":\\\"5 mins\\\",\\\"phc_processcostid\\\":1,\\\"markupprice\\\":\\\"10.00\\\",\\\"price\\\":\\\"0.00\\\"},{\\\"link_id\\\":7,\\\"process_id\\\":4,\\\"product_id\\\":8,\\\"phc_id\\\":7,\\\"pd_id\\\":4,\\\"name\\\":\\\"Tube cut\\\",\\\"phc_linkstations\\\":4,\\\"quantity\\\":1,\\\"link_to\\\":\\\"WORKROOM\\\",\\\"phc_processhascost\\\":0,\\\"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\\\":null,\\\"phc_contacttype\\\":null,\\\"phc_hascontacttypeall\\\":1,\\\"phc_hascustomerstypeall\\\":1,\\\"cost_price\\\":\\\"10.00\\\",\\\"Hour\\\\\\\/mins\\\":\\\"5 mins\\\",\\\"phc_processcostid\\\":1,\\\"markupprice\\\":\\\"10.00\\\",\\\"price\\\":\\\"0.00\\\"},{\\\"link_id\\\":8,\\\"process_id\\\":3,\\\"product_id\\\":8,\\\"phc_id\\\":8,\\\"pd_id\\\":3,\\\"name\\\":\\\"Fabric cut\\\",\\\"phc_linkstations\\\":3,\\\"quantity\\\":1,\\\"link_to\\\":\\\"WORKROOM\\\",\\\"phc_processhascost\\\":0,\\\"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\\\":null,\\\"phc_contacttype\\\":null,\\\"phc_hascontacttypeall\\\":1,\\\"phc_hascustomerstypeall\\\":1,\\\"cost_price\\\":\\\"10.00\\\",\\\"Hour\\\\\\\/mins\\\":\\\"5 mins\\\",\\\"phc_processcostid\\\":1,\\\"markupprice\\\":\\\"10.00\\\",\\\"price\\\":\\\"0.00\\\"},{\\\"link_id\\\":9,\\\"process_id\\\":2,\\\"product_id\\\":8,\\\"phc_id\\\":9,\\\"pd_id\\\":2,\\\"name\\\":\\\"Stock Pick\\\",\\\"phc_linkstations\\\":2,\\\"quantity\\\":1,\\\"link_to\\\":\\\"WORKROOM\\\",\\\"phc_processhascost\\\":0,\\\"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\\\":null,\\\"phc_contacttype\\\":null,\\\"phc_hascontacttypeall\\\":1,\\\"phc_hascustomerstypeall\\\":1,\\\"cost_price\\\":\\\"10.00\\\",\\\"Hour\\\\\\\/mins\\\":\\\"10 mins\\\",\\\"phc_processcostid\\\":1,\\\"markupprice\\\":\\\"10.00\\\",\\\"price\\\":\\\"0.00\\\"},{\\\"link_id\\\":6,\\\"process_id\\\":5,\\\"product_id\\\":8,\\\"phc_id\\\":6,\\\"pd_id\\\":5,\\\"name\\\":\\\"Assemble\\\",\\\"phc_linkstations\\\":5,\\\"quantity\\\":1,\\\"link_to\\\":\\\"WORKROOM\\\",\\\"phc_processhascost\\\":0,\\\"phc_processhastime\\\":1,\\\"phc_costtype\\\":2,\\\"phc_domesticsellingprice\\\":\\\"15.00\\\",\\\"phc_contractsellingprice\\\":\\\"15.00\\\",\\\"phc_tradesellingprice\\\":\\\"15.00\\\",\\\"phc_dynamiccontact5_sellingprice\\\":\\\"0.00\\\",\\\"phc_dynamiccontact6_sellingprice\\\":\\\"0.00\\\",\\\"phc_dynamiccontact7_sellingprice\\\":\\\"0.00\\\",\\\"phc_dynamiccontact8_sellingprice\\\":\\\"0.00\\\",\\\"phc_ecommercesellingprice\\\":\\\"15.00\\\",\\\"phc_customers\\\":null,\\\"phc_contacttype\\\":null,\\\"phc_hascontacttypeall\\\":1,\\\"phc_hascustomerstypeall\\\":1,\\\"cost_price\\\":\\\"15.00\\\",\\\"Hour\\\\\\\/mins\\\":\\\"5 mins\\\",\\\"phc_processcostid\\\":1,\\\"markupprice\\\":\\\"15.00\\\",\\\"price\\\":\\\"0.00\\\"}]\"}", "cl_changedto": "{\"Production Date\":\"2025-05-13 00:00:00\",\"oi_operationworkroom_data\":\"[{\\\"link_id\\\":9,\\\"process_id\\\":2,\\\"product_id\\\":8,\\\"phc_id\\\":9,\\\"pd_id\\\":2,\\\"name\\\":\\\"Stock Pick\\\",\\\"phc_linkstations\\\":2,\\\"quantity\\\":1,\\\"link_to\\\":\\\"WORKROOM\\\",\\\"phc_processhascost\\\":0,\\\"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\\\":null,\\\"phc_contacttype\\\":null,\\\"phc_hascontacttypeall\\\":1,\\\"phc_hascustomerstypeall\\\":1,\\\"cost_price\\\":\\\"10.00\\\",\\\"Hour\\\\\\\/mins\\\":\\\"10 mins\\\",\\\"phc_processcostid\\\":1,\\\"markupprice\\\":\\\"10.00\\\",\\\"price\\\":\\\"0.00\\\"},{\\\"link_id\\\":6,\\\"process_id\\\":5,\\\"product_id\\\":8,\\\"phc_id\\\":6,\\\"pd_id\\\":5,\\\"name\\\":\\\"Assemble\\\",\\\"phc_linkstations\\\":5,\\\"quantity\\\":1,\\\"link_to\\\":\\\"WORKROOM\\\",\\\"phc_processhascost\\\":0,\\\"phc_processhastime\\\":1,\\\"phc_costtype\\\":2,\\\"phc_domesticsellingprice\\\":\\\"15.00\\\",\\\"phc_contractsellingprice\\\":\\\"15.00\\\",\\\"phc_tradesellingprice\\\":\\\"15.00\\\",\\\"phc_dynamiccontact5_sellingprice\\\":\\\"0.00\\\",\\\"phc_dynamiccontact6_sellingprice\\\":\\\"0.00\\\",\\\"phc_dynamiccontact7_sellingprice\\\":\\\"0.00\\\",\\\"phc_dynamiccontact8_sellingprice\\\":\\\"0.00\\\",\\\"phc_ecommercesellingprice\\\":\\\"15.00\\\",\\\"phc_customers\\\":null,\\\"phc_contacttype\\\":null,\\\"phc_hascontacttypeall\\\":1,\\\"phc_hascustomerstypeall\\\":1,\\\"cost_price\\\":\\\"15.00\\\",\\\"Hour\\\\\\\/mins\\\":\\\"5 mins\\\",\\\"phc_processcostid\\\":1,\\\"markupprice\\\":\\\"15.00\\\",\\\"price\\\":\\\"0.00\\\"},{\\\"link_id\\\":10,\\\"process_id\\\":1,\\\"product_id\\\":8,\\\"phc_id\\\":10,\\\"pd_id\\\":1,\\\"name\\\":\\\"Office Check\\\",\\\"phc_linkstations\\\":1,\\\"quantity\\\":1,\\\"link_to\\\":\\\"WORKROOM\\\",\\\"phc_processhascost\\\":0,\\\"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\\\":null,\\\"phc_contacttype\\\":null,\\\"phc_hascontacttypeall\\\":1,\\\"phc_hascustomerstypeall\\\":1,\\\"cost_price\\\":\\\"10.00\\\",\\\"Hour\\\\\\\/mins\\\":\\\"5 mins\\\",\\\"phc_processcostid\\\":1,\\\"markupprice\\\":\\\"10.00\\\",\\\"price\\\":\\\"0.00\\\"},{\\\"link_id\\\":7,\\\"process_id\\\":4,\\\"product_id\\\":8,\\\"phc_id\\\":7,\\\"pd_id\\\":4,\\\"name\\\":\\\"Tube cut\\\",\\\"phc_linkstations\\\":4,\\\"quantity\\\":1,\\\"link_to\\\":\\\"WORKROOM\\\",\\\"phc_processhascost\\\":0,\\\"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\\\":null,\\\"phc_contacttype\\\":null,\\\"phc_hascontacttypeall\\\":1,\\\"phc_hascustomerstypeall\\\":1,\\\"cost_price\\\":\\\"10.00\\\",\\\"Hour\\\\\\\/mins\\\":\\\"5 mins\\\",\\\"phc_processcostid\\\":1,\\\"markupprice\\\":\\\"10.00\\\",\\\"price\\\":\\\"0.00\\\"},{\\\"link_id\\\":8,\\\"process_id\\\":3,\\\"product_id\\\":8,\\\"phc_id\\\":8,\\\"pd_id\\\":3,\\\"name\\\":\\\"Fabric cut\\\",\\\"phc_linkstations\\\":3,\\\"quantity\\\":1,\\\"link_to\\\":\\\"WORKROOM\\\",\\\"phc_processhascost\\\":0,\\\"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\\\":null,\\\"phc_contacttype\\\":null,\\\"phc_hascontacttypeall\\\":1,\\\"phc_hascustomerstypeall\\\":1,\\\"cost_price\\\":\\\"10.00\\\",\\\"Hour\\\\\\\/mins\\\":\\\"5 mins\\\",\\\"phc_processcostid\\\":1,\\\"markupprice\\\":\\\"10.00\\\",\\\"price\\\":\\\"0.00\\\"}]\"}", "cl_customproperties": "{\"attributes\":{\"oi_jsondata\":\"[{\\\"id\\\":6886,\\\"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\\\":6886,\\\"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\\\":247,\\\"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\\\":247,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":248,\\\"labelname\\\":\\\"Supplier\\\",\\\"value\\\":\\\"1\\\",\\\"valueid\\\":null,\\\"type\\\":17,\\\"optionid\\\":\\\"1\\\",\\\"optionvalue\\\":[{\\\"id\\\":1,\\\"optionid\\\":1,\\\"optionname\\\":\\\"Markilux\\\",\\\"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\\\":248,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":\\\"1\\\",\\\"optionsvalue\\\":[{\\\"id\\\":1,\\\"optionid\\\":1,\\\"optionname\\\":\\\"Markilux\\\",\\\"deleted\\\":0,\\\"optionquantity\\\":1}],\\\"editruleoverride\\\":1},{\\\"id\\\":250,\\\"labelname\\\":\\\"Room\\\",\\\"value\\\":\\\"3\\\",\\\"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\\\":250,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":1},{\\\"id\\\":251,\\\"labelname\\\":\\\"Blind or Recess\\\",\\\"value\\\":\\\"Recess size\\\",\\\"valueid\\\":\\\"726\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"475\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":475,\\\"optionqty\\\":\\\"1\\\",\\\"optioncode\\\":\\\"jcld\\\",\\\"optionname\\\":\\\"Recess size\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":726,\\\"forchildfieldoptionlinkid\\\":\\\"3_726\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":null}],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Blind or Recess\\\",\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":null,\\\"widthfractiontext\\\":null,\\\"dropfractiontext\\\":null,\\\"dropfraction\\\":null,\\\"showfieldonjob\\\":1,\\\"showFieldOnCustomerPortal\\\":1,\\\"optionquantity\\\":\\\"1\\\",\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":1,\\\"fieldtypeid\\\":3,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Blind or Recess\\\",\\\"fieldid\\\":251,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":\\\"475\\\",\\\"optionsvalue\\\":[{\\\"optionid\\\":475,\\\"optionqty\\\":\\\"1\\\",\\\"optioncode\\\":\\\"jcld\\\",\\\"optionname\\\":\\\"Recess size\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":726,\\\"forchildfieldoptionlinkid\\\":\\\"3_726\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":null}],\\\"editruleoverride\\\":1},{\\\"id\\\":252,\\\"labelname\\\":\\\"Width\\\",\\\"value\\\":\\\"500\\\",\\\"valueid\\\":null,\\\"type\\\":11,\\\"optionid\\\":null,\\\"optionvalue\\\":[],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Width\\\",\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"0___0\\\",\\\"widthfractiontext\\\":null,\\\"dropfractiontext\\\":null,\\\"dropfraction\\\":null,\\\"showfieldonjob\\\":1,\\\"showFieldOnCustomerPortal\\\":1,\\\"optionquantity\\\":null,\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":1,\\\"fieldtypeid\\\":11,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Width\\\",\\\"fieldid\\\":252,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":1},{\\\"id\\\":253,\\\"labelname\\\":\\\"Drop\\\",\\\"value\\\":\\\"610\\\",\\\"valueid\\\":null,\\\"type\\\":12,\\\"optionid\\\":null,\\\"optionvalue\\\":[],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Drop\\\",\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":null,\\\"widthfractiontext\\\":null,\\\"dropfractiontext\\\":null,\\\"dropfraction\\\":\\\"0___0\\\",\\\"showfieldonjob\\\":1,\\\"showFieldOnCustomerPortal\\\":1,\\\"optionquantity\\\":null,\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":1,\\\"fieldtypeid\\\":12,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Drop\\\",\\\"fieldid\\\":253,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":1},{\\\"id\\\":249,\\\"labelname\\\":\\\"Product Type\\\",\\\"value\\\":\\\"452\\\",\\\"valueid\\\":\\\"553\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"452\\\",\\\"optionvalue\\\":[{\\\"id\\\":553,\\\"fieldid\\\":249,\\\"fieldoptionlinkid\\\":553,\\\"optionid\\\":452,\\\"mainsupplier\\\":\\\"1\\\",\\\"blindtypecode\\\":null,\\\"optionname\\\":\\\"Band AB\\\",\\\"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\\\":0,\\\"optionquantity\\\":null,\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":1,\\\"fieldtypeid\\\":13,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Product Type\\\",\\\"fieldid\\\":249,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":\\\"452\\\",\\\"optionsvalue\\\":[{\\\"id\\\":553,\\\"fieldid\\\":249,\\\"fieldoptionlinkid\\\":553,\\\"optionid\\\":452,\\\"mainsupplier\\\":\\\"1\\\",\\\"blindtypecode\\\":null,\\\"optionname\\\":\\\"Band AB\\\",\\\"optionquantity\\\":1,\\\"subcount\\\":0,\\\"status\\\":0,\\\"subdatacount\\\":0}],\\\"editruleoverride\\\":1},{\\\"id\\\":304,\\\"labelname\\\":\\\"Blind Model\\\",\\\"value\\\":null,\\\"valueid\\\":null,\\\"type\\\":3,\\\"optionid\\\":null,\\\"optionvalue\\\":[],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Blind Model\\\",\\\"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 Model\\\",\\\"fieldid\\\":304,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":254,\\\"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\\\":254,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":255,\\\"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\\\":255,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":305,\\\"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\\\":305,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":256,\\\"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\\\":256,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":257,\\\"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\\\":257,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":258,\\\"labelname\\\":\\\"Special Instructions\\\",\\\"value\\\":null,\\\"valueid\\\":null,\\\"type\\\":18,\\\"optionid\\\":null,\\\"optionvalue\\\":[],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Special 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\\\":\\\"Special Instructions\\\",\\\"fieldid\\\":258,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0}]\",\"oi_productiondate\":\"2025-05-13 00:00:00\",\"oi_operationworkroom_data\":\"[{\\\"link_id\\\":9,\\\"process_id\\\":2,\\\"product_id\\\":8,\\\"phc_id\\\":9,\\\"pd_id\\\":2,\\\"name\\\":\\\"Stock Pick\\\",\\\"phc_linkstations\\\":2,\\\"quantity\\\":1,\\\"link_to\\\":\\\"WORKROOM\\\",\\\"phc_processhascost\\\":0,\\\"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\\\":null,\\\"phc_contacttype\\\":null,\\\"phc_hascontacttypeall\\\":1,\\\"phc_hascustomerstypeall\\\":1,\\\"cost_price\\\":\\\"10.00\\\",\\\"Hour\\\\\\\/mins\\\":\\\"10 mins\\\",\\\"phc_processcostid\\\":1,\\\"markupprice\\\":\\\"10.00\\\",\\\"price\\\":\\\"0.00\\\"},{\\\"link_id\\\":6,\\\"process_id\\\":5,\\\"product_id\\\":8,\\\"phc_id\\\":6,\\\"pd_id\\\":5,\\\"name\\\":\\\"Assemble\\\",\\\"phc_linkstations\\\":5,\\\"quantity\\\":1,\\\"link_to\\\":\\\"WORKROOM\\\",\\\"phc_processhascost\\\":0,\\\"phc_processhastime\\\":1,\\\"phc_costtype\\\":2,\\\"phc_domesticsellingprice\\\":\\\"15.00\\\",\\\"phc_contractsellingprice\\\":\\\"15.00\\\",\\\"phc_tradesellingprice\\\":\\\"15.00\\\",\\\"phc_dynamiccontact5_sellingprice\\\":\\\"0.00\\\",\\\"phc_dynamiccontact6_sellingprice\\\":\\\"0.00\\\",\\\"phc_dynamiccontact7_sellingprice\\\":\\\"0.00\\\",\\\"phc_dynamiccontact8_sellingprice\\\":\\\"0.00\\\",\\\"phc_ecommercesellingprice\\\":\\\"15.00\\\",\\\"phc_customers\\\":null,\\\"phc_contacttype\\\":null,\\\"phc_hascontacttypeall\\\":1,\\\"phc_hascustomerstypeall\\\":1,\\\"cost_price\\\":\\\"15.00\\\",\\\"Hour\\\\\\\/mins\\\":\\\"5 mins\\\",\\\"phc_processcostid\\\":1,\\\"markupprice\\\":\\\"15.00\\\",\\\"price\\\":\\\"0.00\\\"},{\\\"link_id\\\":10,\\\"process_id\\\":1,\\\"product_id\\\":8,\\\"phc_id\\\":10,\\\"pd_id\\\":1,\\\"name\\\":\\\"Office Check\\\",\\\"phc_linkstations\\\":1,\\\"quantity\\\":1,\\\"link_to\\\":\\\"WORKROOM\\\",\\\"phc_processhascost\\\":0,\\\"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\\\":null,\\\"phc_contacttype\\\":null,\\\"phc_hascontacttypeall\\\":1,\\\"phc_hascustomerstypeall\\\":1,\\\"cost_price\\\":\\\"10.00\\\",\\\"Hour\\\\\\\/mins\\\":\\\"5 mins\\\",\\\"phc_processcostid\\\":1,\\\"markupprice\\\":\\\"10.00\\\",\\\"price\\\":\\\"0.00\\\"},{\\\"link_id\\\":7,\\\"process_id\\\":4,\\\"product_id\\\":8,\\\"phc_id\\\":7,\\\"pd_id\\\":4,\\\"name\\\":\\\"Tube cut\\\",\\\"phc_linkstations\\\":4,\\\"quantity\\\":1,\\\"link_to\\\":\\\"WORKROOM\\\",\\\"phc_processhascost\\\":0,\\\"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\\\":null,\\\"phc_contacttype\\\":null,\\\"phc_hascontacttypeall\\\":1,\\\"phc_hascustomerstypeall\\\":1,\\\"cost_price\\\":\\\"10.00\\\",\\\"Hour\\\\\\\/mins\\\":\\\"5 mins\\\",\\\"phc_processcostid\\\":1,\\\"markupprice\\\":\\\"10.00\\\",\\\"price\\\":\\\"0.00\\\"},{\\\"link_id\\\":8,\\\"process_id\\\":3,\\\"product_id\\\":8,\\\"phc_id\\\":8,\\\"pd_id\\\":3,\\\"name\\\":\\\"Fabric cut\\\",\\\"phc_linkstations\\\":3,\\\"quantity\\\":1,\\\"link_to\\\":\\\"WORKROOM\\\",\\\"phc_processhascost\\\":0,\\\"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\\\":null,\\\"phc_contacttype\\\":null,\\\"phc_hascontacttypeall\\\":1,\\\"phc_hascustomerstypeall\\\":1,\\\"cost_price\\\":\\\"10.00\\\",\\\"Hour\\\\\\\/mins\\\":\\\"5 mins\\\",\\\"phc_processcostid\\\":1,\\\"markupprice\\\":\\\"10.00\\\",\\\"price\\\":\\\"0.00\\\"}]\",\"oi_updatedby\":1,\"oi_updatedat\":\"2025-05-13T11:49:26.000000Z\",\"oi_jsondataid\":\"[6886, 247, 248, 250, 251, 252, 253, 249, 304, 254, 255, 305, 256, 257, 258]\"},\"old\":{\"oi_jsondata\":\"[{\\\"id\\\":6886,\\\"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\\\":6886,\\\"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\\\":247,\\\"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\\\":247,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":248,\\\"labelname\\\":\\\"Supplier\\\",\\\"value\\\":\\\"1\\\",\\\"valueid\\\":null,\\\"type\\\":17,\\\"optionid\\\":\\\"1\\\",\\\"optionvalue\\\":[{\\\"id\\\":1,\\\"optionid\\\":1,\\\"optionname\\\":\\\"Markilux\\\",\\\"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\\\":248,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":\\\"1\\\",\\\"optionsvalue\\\":[{\\\"id\\\":1,\\\"optionid\\\":1,\\\"optionname\\\":\\\"Markilux\\\",\\\"deleted\\\":0,\\\"optionquantity\\\":1}],\\\"editruleoverride\\\":1},{\\\"id\\\":250,\\\"labelname\\\":\\\"Room\\\",\\\"value\\\":\\\"3\\\",\\\"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\\\":250,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":1},{\\\"id\\\":251,\\\"labelname\\\":\\\"Blind or Recess\\\",\\\"value\\\":\\\"Recess size\\\",\\\"valueid\\\":\\\"726\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"475\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":475,\\\"optionqty\\\":\\\"1\\\",\\\"optioncode\\\":\\\"jcld\\\",\\\"optionname\\\":\\\"Recess size\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":726,\\\"forchildfieldoptionlinkid\\\":\\\"3_726\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":null}],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Blind or Recess\\\",\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":null,\\\"widthfractiontext\\\":null,\\\"dropfractiontext\\\":null,\\\"dropfraction\\\":null,\\\"showfieldonjob\\\":1,\\\"showFieldOnCustomerPortal\\\":1,\\\"optionquantity\\\":\\\"1\\\",\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":1,\\\"fieldtypeid\\\":3,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Blind or Recess\\\",\\\"fieldid\\\":251,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":\\\"475\\\",\\\"optionsvalue\\\":[{\\\"optionid\\\":475,\\\"optionqty\\\":\\\"1\\\",\\\"optioncode\\\":\\\"jcld\\\",\\\"optionname\\\":\\\"Recess size\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":726,\\\"forchildfieldoptionlinkid\\\":\\\"3_726\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":null}],\\\"editruleoverride\\\":1},{\\\"id\\\":252,\\\"labelname\\\":\\\"Width\\\",\\\"value\\\":\\\"500\\\",\\\"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\\\":252,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":1},{\\\"id\\\":253,\\\"labelname\\\":\\\"Drop\\\",\\\"value\\\":\\\"610\\\",\\\"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\\\":253,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":1},{\\\"id\\\":249,\\\"labelname\\\":\\\"Product Type\\\",\\\"value\\\":\\\"452\\\",\\\"valueid\\\":\\\"553\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"452\\\",\\\"optionvalue\\\":[{\\\"id\\\":553,\\\"fieldid\\\":249,\\\"fieldoptionlinkid\\\":553,\\\"optionid\\\":452,\\\"mainsupplier\\\":\\\"1\\\",\\\"blindtypecode\\\":null,\\\"optionname\\\":\\\"Band AB\\\",\\\"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\\\":0,\\\"optionquantity\\\":null,\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":1,\\\"fieldtypeid\\\":13,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Product Type\\\",\\\"fieldid\\\":249,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":\\\"452\\\",\\\"optionsvalue\\\":[{\\\"id\\\":553,\\\"fieldid\\\":249,\\\"fieldoptionlinkid\\\":553,\\\"optionid\\\":452,\\\"mainsupplier\\\":\\\"1\\\",\\\"blindtypecode\\\":null,\\\"optionname\\\":\\\"Band AB\\\",\\\"optionquantity\\\":1,\\\"subcount\\\":0,\\\"status\\\":0,\\\"subdatacount\\\":0}],\\\"editruleoverride\\\":1},{\\\"id\\\":259,\\\"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\\\":259,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":304,\\\"labelname\\\":\\\"Blind Model\\\",\\\"value\\\":null,\\\"valueid\\\":null,\\\"type\\\":3,\\\"optionid\\\":null,\\\"optionvalue\\\":[],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Blind Model\\\",\\\"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 Model\\\",\\\"fieldid\\\":304,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":254,\\\"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\\\":254,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":255,\\\"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\\\":255,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":305,\\\"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\\\":305,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":256,\\\"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\\\":256,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":257,\\\"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\\\":257,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":258,\\\"labelname\\\":\\\"Special Instructions\\\",\\\"value\\\":null,\\\"valueid\\\":null,\\\"type\\\":18,\\\"optionid\\\":null,\\\"optionvalue\\\":[],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Special 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\\\":\\\"Special Instructions\\\",\\\"fieldid\\\":258,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0}]\",\"oi_productiondate\":\"2025-05-13 17:04:31\",\"oi_operationworkroom_data\":\"[{\\\"link_id\\\":10,\\\"process_id\\\":1,\\\"product_id\\\":8,\\\"phc_id\\\":10,\\\"pd_id\\\":1,\\\"name\\\":\\\"Office Check\\\",\\\"phc_linkstations\\\":1,\\\"quantity\\\":1,\\\"link_to\\\":\\\"WORKROOM\\\",\\\"phc_processhascost\\\":0,\\\"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\\\":null,\\\"phc_contacttype\\\":null,\\\"phc_hascontacttypeall\\\":1,\\\"phc_hascustomerstypeall\\\":1,\\\"cost_price\\\":\\\"10.00\\\",\\\"Hour\\\\\\\/mins\\\":\\\"5 mins\\\",\\\"phc_processcostid\\\":1,\\\"markupprice\\\":\\\"10.00\\\",\\\"price\\\":\\\"0.00\\\"},{\\\"link_id\\\":7,\\\"process_id\\\":4,\\\"product_id\\\":8,\\\"phc_id\\\":7,\\\"pd_id\\\":4,\\\"name\\\":\\\"Tube cut\\\",\\\"phc_linkstations\\\":4,\\\"quantity\\\":1,\\\"link_to\\\":\\\"WORKROOM\\\",\\\"phc_processhascost\\\":0,\\\"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\\\":null,\\\"phc_contacttype\\\":null,\\\"phc_hascontacttypeall\\\":1,\\\"phc_hascustomerstypeall\\\":1,\\\"cost_price\\\":\\\"10.00\\\",\\\"Hour\\\\\\\/mins\\\":\\\"5 mins\\\",\\\"phc_processcostid\\\":1,\\\"markupprice\\\":\\\"10.00\\\",\\\"price\\\":\\\"0.00\\\"},{\\\"link_id\\\":8,\\\"process_id\\\":3,\\\"product_id\\\":8,\\\"phc_id\\\":8,\\\"pd_id\\\":3,\\\"name\\\":\\\"Fabric cut\\\",\\\"phc_linkstations\\\":3,\\\"quantity\\\":1,\\\"link_to\\\":\\\"WORKROOM\\\",\\\"phc_processhascost\\\":0,\\\"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\\\":null,\\\"phc_contacttype\\\":null,\\\"phc_hascontacttypeall\\\":1,\\\"phc_hascustomerstypeall\\\":1,\\\"cost_price\\\":\\\"10.00\\\",\\\"Hour\\\\\\\/mins\\\":\\\"5 mins\\\",\\\"phc_processcostid\\\":1,\\\"markupprice\\\":\\\"10.00\\\",\\\"price\\\":\\\"0.00\\\"},{\\\"link_id\\\":9,\\\"process_id\\\":2,\\\"product_id\\\":8,\\\"phc_id\\\":9,\\\"pd_id\\\":2,\\\"name\\\":\\\"Stock Pick\\\",\\\"phc_linkstations\\\":2,\\\"quantity\\\":1,\\\"link_to\\\":\\\"WORKROOM\\\",\\\"phc_processhascost\\\":0,\\\"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\\\":null,\\\"phc_contacttype\\\":null,\\\"phc_hascontacttypeall\\\":1,\\\"phc_hascustomerstypeall\\\":1,\\\"cost_price\\\":\\\"10.00\\\",\\\"Hour\\\\\\\/mins\\\":\\\"10 mins\\\",\\\"phc_processcostid\\\":1,\\\"markupprice\\\":\\\"10.00\\\",\\\"price\\\":\\\"0.00\\\"},{\\\"link_id\\\":6,\\\"process_id\\\":5,\\\"product_id\\\":8,\\\"phc_id\\\":6,\\\"pd_id\\\":5,\\\"name\\\":\\\"Assemble\\\",\\\"phc_linkstations\\\":5,\\\"quantity\\\":1,\\\"link_to\\\":\\\"WORKROOM\\\",\\\"phc_processhascost\\\":0,\\\"phc_processhastime\\\":1,\\\"phc_costtype\\\":2,\\\"phc_domesticsellingprice\\\":\\\"15.00\\\",\\\"phc_contractsellingprice\\\":\\\"15.00\\\",\\\"phc_tradesellingprice\\\":\\\"15.00\\\",\\\"phc_dynamiccontact5_sellingprice\\\":\\\"0.00\\\",\\\"phc_dynamiccontact6_sellingprice\\\":\\\"0.00\\\",\\\"phc_dynamiccontact7_sellingprice\\\":\\\"0.00\\\",\\\"phc_dynamiccontact8_sellingprice\\\":\\\"0.00\\\",\\\"phc_ecommercesellingprice\\\":\\\"15.00\\\",\\\"phc_customers\\\":null,\\\"phc_contacttype\\\":null,\\\"phc_hascontacttypeall\\\":1,\\\"phc_hascustomerstypeall\\\":1,\\\"cost_price\\\":\\\"15.00\\\",\\\"Hour\\\\\\\/mins\\\":\\\"5 mins\\\",\\\"phc_processcostid\\\":1,\\\"markupprice\\\":\\\"15.00\\\",\\\"price\\\":\\\"0.00\\\"}]\",\"oi_updatedby\":null,\"oi_updatedat\":\"2025-05-13T11:35:05.000000Z\",\"oi_jsondataid\":\"[6886, 247, 248, 250, 251, 252, 253, 249, 259, 304, 254, 255, 305, 256, 257, 258]\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "52910", "cl_createdat": "1747136966.000000", "cl_updatedat": null }, { "cl_id": 52911, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the fields VAT Price,Gross Price Amount,Amount Outstanding", "cl_event": "modified", "cl_subjectid": 5530, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5530, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "{\"VAT Price\":\"0.00\",\"Gross Price Amount\":\"125.00\",\"Amount Outstanding\":\"125.00\"}", "cl_changedto": "{\"VAT Price\":\"5.43\",\"Gross Price Amount\":\"130.43\",\"Amount Outstanding\":\"130.43\"}", "cl_customproperties": "{\"attributes\":{\"jd_vat\":\"5.43\",\"jd_grossprice\":\"130.43\",\"jd_amountoutstanding\":\"130.43\",\"jd_updatedat\":\"2025-05-13T11:49:28.000000Z\"},\"old\":{\"jd_vat\":\"0.00\",\"jd_grossprice\":\"125.00\",\"jd_amountoutstanding\":\"125.00\",\"jd_updatedat\":\"2025-05-13T11:49:26.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "52911", "cl_createdat": "1747136968.000000", "cl_updatedat": null } ], "updated": [], "deleted": [] }, "bm_productInfo": { "created": [ { "pi_productid": 273, "pi_productname": "Test Bom", "pi_pcode": "162", "pi_category": 3, "pi_productgroup": 1, "pi_producttype": 0, "pi_qtyperunit": "0.00", "pi_unitprice": "0.00", "pi_costfactor": null, "pi_commissionrate": "0.000", "pi_commissionmethod": null, "pi_reorderlevel": null, "pi_taxclass": null, "pi_serialno": null, "pi_qtyinstock": 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_hidecompparameter": null, "pi_factorybarcodeproduct": null, "pi_showhideproductorder": 1, "pi_ecommercestatus": 0, "pi_productdescription": null, "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": 0, "pi_mobileapp": 1, "pi_jobtransfer": 0, "pi_seq": 223, "pi_status": 0, "pi_createdby": 1, "pi_defaultunittype": 4, "pi_jobfraction": 1, "pi_unittypeseq": "2,3,1,4", "pi_deafultimage": "{\"defaultimage\":{\"framedefault\":\"\",\"productdefault\":\"\",\"backgrounddefault\":\"\",\"bannerdefault\":\"\"}}", "pi_backgroundimage": "[]", "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": "273" } ], "updated": [ { "pi_productid": 273, "pi_productname": "Test Bom", "pi_pcode": "162", "pi_category": 3, "pi_productgroup": 1, "pi_producttype": 0, "pi_qtyperunit": "0.00", "pi_unitprice": "0.00", "pi_costfactor": null, "pi_commissionrate": "0.000", "pi_commissionmethod": null, "pi_reorderlevel": null, "pi_taxclass": null, "pi_serialno": null, "pi_qtyinstock": 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_hidecompparameter": null, "pi_factorybarcodeproduct": null, "pi_showhideproductorder": 1, "pi_ecommercestatus": 0, "pi_productdescription": null, "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": 0, "pi_mobileapp": 1, "pi_jobtransfer": 0, "pi_seq": 223, "pi_status": 0, "pi_createdby": 1, "pi_defaultunittype": 4, "pi_jobfraction": 1, "pi_unittypeseq": "2,3,1,4", "pi_deafultimage": "{\"defaultimage\":{\"framedefault\":\"\",\"productdefault\":\"\",\"backgrounddefault\":\"\",\"bannerdefault\":\"\"}}", "pi_backgroundimage": "[]", "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": "273" } ], "deleted": [] }, "bm_fields": { "created": [ { "fi_fieldId": 7689, "fi_fieldName": "Quantity", "fi_fieldCode": null, "fi_fieldparamid": "", "fi_productId": 273, "fi_fabricorcolor": 0, "fi_dualseq": 0, "fi_linktopricegroup": 0, "fi_issubfabric": 0, "fi_showFieldOnJob": 1, "fi_showFieldOnEcommerce": 0, "fi_showFieldOnCustomerPortal": 1, "fi_fieldType": 14, "fi_fieldLevel": 1, "fi_hasPrice": 0, "fi_defaultOption": "", "fi_selection": 0, "fi_isMandatory": 0, "fi_showhide": 1, "fi_active": 0, "fi_status": 0, "fi_seq": 2, "fi_supplierid": "0", "id": "7689" }, { "fi_fieldId": 7690, "fi_fieldName": "Unit Type", "fi_fieldCode": null, "fi_fieldparamid": "", "fi_productId": 273, "fi_fabricorcolor": 0, "fi_dualseq": 0, "fi_linktopricegroup": 0, "fi_issubfabric": 0, "fi_showFieldOnJob": 1, "fi_showFieldOnEcommerce": 0, "fi_showFieldOnCustomerPortal": 1, "fi_fieldType": 34, "fi_fieldLevel": 1, "fi_hasPrice": 0, "fi_defaultOption": "", "fi_selection": 0, "fi_isMandatory": 0, "fi_showhide": 1, "fi_active": 0, "fi_status": 0, "fi_seq": 1, "fi_supplierid": "0", "id": "7690" }, { "fi_fieldId": 7691, "fi_fieldName": "Supplier", "fi_fieldCode": null, "fi_fieldparamid": "", "fi_productId": 273, "fi_fabricorcolor": 0, "fi_dualseq": 0, "fi_linktopricegroup": 0, "fi_issubfabric": 0, "fi_showFieldOnJob": 1, "fi_showFieldOnEcommerce": 0, "fi_showFieldOnCustomerPortal": 1, "fi_fieldType": 17, "fi_fieldLevel": 1, "fi_hasPrice": 0, "fi_defaultOption": "", "fi_selection": 0, "fi_isMandatory": 0, "fi_showhide": 1, "fi_active": 0, "fi_status": 0, "fi_seq": 3, "fi_supplierid": "0", "id": "7691" }, { "fi_fieldId": 7692, "fi_fieldName": "Extras", "fi_fieldCode": null, "fi_fieldparamid": "95,96,94,433,97", "fi_productId": 273, "fi_fabricorcolor": 0, "fi_dualseq": 0, "fi_linktopricegroup": 0, "fi_issubfabric": 0, "fi_showFieldOnJob": 1, "fi_showFieldOnEcommerce": 0, "fi_showFieldOnCustomerPortal": 1, "fi_fieldType": 3, "fi_fieldLevel": 1, "fi_hasPrice": 0, "fi_defaultOption": "", "fi_selection": 1, "fi_isMandatory": 0, "fi_showhide": 1, "fi_active": 0, "fi_status": 0, "fi_seq": 6, "fi_supplierid": "", "id": "7692" }, { "fi_fieldId": 7693, "fi_fieldName": "Width", "fi_fieldCode": null, "fi_fieldparamid": "", "fi_productId": 273, "fi_fabricorcolor": 0, "fi_dualseq": 0, "fi_linktopricegroup": 0, "fi_issubfabric": 0, "fi_showFieldOnJob": 1, "fi_showFieldOnEcommerce": 0, "fi_showFieldOnCustomerPortal": 1, "fi_fieldType": 11, "fi_fieldLevel": 1, "fi_hasPrice": 0, "fi_defaultOption": "", "fi_selection": 0, "fi_isMandatory": 0, "fi_showhide": 1, "fi_active": 0, "fi_status": 0, "fi_seq": 4, "fi_supplierid": "0", "id": "7693" }, { "fi_fieldId": 7694, "fi_fieldName": "Drop", "fi_fieldCode": null, "fi_fieldparamid": "", "fi_productId": 273, "fi_fabricorcolor": 0, "fi_dualseq": 0, "fi_linktopricegroup": 0, "fi_issubfabric": 0, "fi_showFieldOnJob": 1, "fi_showFieldOnEcommerce": 0, "fi_showFieldOnCustomerPortal": 1, "fi_fieldType": 12, "fi_fieldLevel": 1, "fi_hasPrice": 0, "fi_defaultOption": "", "fi_selection": 0, "fi_isMandatory": 0, "fi_showhide": 1, "fi_active": 0, "fi_status": 0, "fi_seq": 5, "fi_supplierid": "0", "id": "7694" } ], "updated": [ { "fi_fieldId": 7689, "fi_fieldName": "Quantity", "fi_fieldCode": null, "fi_fieldparamid": "", "fi_productId": 273, "fi_fabricorcolor": 0, "fi_dualseq": 0, "fi_linktopricegroup": 0, "fi_issubfabric": 0, "fi_showFieldOnJob": 1, "fi_showFieldOnEcommerce": 0, "fi_showFieldOnCustomerPortal": 1, "fi_fieldType": 14, "fi_fieldLevel": 1, "fi_hasPrice": 0, "fi_defaultOption": "", "fi_selection": 0, "fi_isMandatory": 0, "fi_showhide": 1, "fi_active": 0, "fi_status": 0, "fi_seq": 2, "fi_supplierid": "0", "id": "7689" }, { "fi_fieldId": 7690, "fi_fieldName": "Unit Type", "fi_fieldCode": null, "fi_fieldparamid": "", "fi_productId": 273, "fi_fabricorcolor": 0, "fi_dualseq": 0, "fi_linktopricegroup": 0, "fi_issubfabric": 0, "fi_showFieldOnJob": 1, "fi_showFieldOnEcommerce": 0, "fi_showFieldOnCustomerPortal": 1, "fi_fieldType": 34, "fi_fieldLevel": 1, "fi_hasPrice": 0, "fi_defaultOption": "", "fi_selection": 0, "fi_isMandatory": 0, "fi_showhide": 1, "fi_active": 0, "fi_status": 0, "fi_seq": 1, "fi_supplierid": "0", "id": "7690" }, { "fi_fieldId": 7691, "fi_fieldName": "Supplier", "fi_fieldCode": null, "fi_fieldparamid": "", "fi_productId": 273, "fi_fabricorcolor": 0, "fi_dualseq": 0, "fi_linktopricegroup": 0, "fi_issubfabric": 0, "fi_showFieldOnJob": 1, "fi_showFieldOnEcommerce": 0, "fi_showFieldOnCustomerPortal": 1, "fi_fieldType": 17, "fi_fieldLevel": 1, "fi_hasPrice": 0, "fi_defaultOption": "", "fi_selection": 0, "fi_isMandatory": 0, "fi_showhide": 1, "fi_active": 0, "fi_status": 0, "fi_seq": 3, "fi_supplierid": "0", "id": "7691" }, { "fi_fieldId": 7692, "fi_fieldName": "Extras", "fi_fieldCode": null, "fi_fieldparamid": "95,96,94,433,97", "fi_productId": 273, "fi_fabricorcolor": 0, "fi_dualseq": 0, "fi_linktopricegroup": 0, "fi_issubfabric": 0, "fi_showFieldOnJob": 1, "fi_showFieldOnEcommerce": 0, "fi_showFieldOnCustomerPortal": 1, "fi_fieldType": 3, "fi_fieldLevel": 1, "fi_hasPrice": 0, "fi_defaultOption": "", "fi_selection": 1, "fi_isMandatory": 0, "fi_showhide": 1, "fi_active": 0, "fi_status": 0, "fi_seq": 6, "fi_supplierid": "", "id": "7692" }, { "fi_fieldId": 7693, "fi_fieldName": "Width", "fi_fieldCode": null, "fi_fieldparamid": "", "fi_productId": 273, "fi_fabricorcolor": 0, "fi_dualseq": 0, "fi_linktopricegroup": 0, "fi_issubfabric": 0, "fi_showFieldOnJob": 1, "fi_showFieldOnEcommerce": 0, "fi_showFieldOnCustomerPortal": 1, "fi_fieldType": 11, "fi_fieldLevel": 1, "fi_hasPrice": 0, "fi_defaultOption": "", "fi_selection": 0, "fi_isMandatory": 0, "fi_showhide": 1, "fi_active": 0, "fi_status": 0, "fi_seq": 4, "fi_supplierid": "0", "id": "7693" }, { "fi_fieldId": 7694, "fi_fieldName": "Drop", "fi_fieldCode": null, "fi_fieldparamid": "", "fi_productId": 273, "fi_fabricorcolor": 0, "fi_dualseq": 0, "fi_linktopricegroup": 0, "fi_issubfabric": 0, "fi_showFieldOnJob": 1, "fi_showFieldOnEcommerce": 0, "fi_showFieldOnCustomerPortal": 1, "fi_fieldType": 12, "fi_fieldLevel": 1, "fi_hasPrice": 0, "fi_defaultOption": "", "fi_selection": 0, "fi_isMandatory": 0, "fi_showhide": 1, "fi_active": 0, "fi_status": 0, "fi_seq": 5, "fi_supplierid": "0", "id": "7694" } ], "deleted": [] }, "bm_fieldOptionLink": { "created": [ { "fol_fieldOptionLinkId": 22912, "fol_fieldId": 7692, "fol_optionId": 23, "fol_productId": 273, "fol_masterParentFieldId": 7692, "fol_parentlinkid": 0, "fol_optionpricegroup": "", "fol_pricegroupsupplier": "", "fol_linkType": 1, "fol_seq": 1, "fol_status": 0, "id": "22912" } ], "updated": [ { "fol_fieldOptionLinkId": 22912, "fol_fieldId": 7692, "fol_optionId": 23, "fol_productId": 273, "fol_masterParentFieldId": 7692, "fol_parentlinkid": 0, "fol_optionpricegroup": "", "fol_pricegroupsupplier": "", "fol_linkType": 1, "fol_seq": 1, "fol_status": 0, "id": "22912" } ], "deleted": [] }, "bm_option": { "created": [ { "op_optionId": 23, "op_jobtempid": "0", "op_fieldTypeId": 3, "op_optionType": 1, "op_customerType": "{\"1\":true,\"2\":true,\"3\":true,\"4\":false,\"5\":false,\"6\":false}", "op_customisedformdata": "{\"94\":\"Demo com\",\"95\":\"\",\"96\":\"A6\",\"97\":\"\",\"98\":2,\"101\":\"\",\"102\":265,\"103\":265,\"104\":\"\",\"105\":\"\",\"106\":\"\",\"107\":\"\",\"108\":\"\",\"109\":\"\",\"110\":\"\",\"111\":\"\",\"112\":\"\",\"113\":\"\",\"114\":\"\",\"115\":\"\",\"116\":\"\",\"117\":\"\",\"118\":\"\",\"119\":\"\",\"120\":\"5\",\"123\":\"\",\"127\":1,\"258\":\"\",\"290\":\"\",\"433\":1,\"464\":\"\",\"503\":\"\",\"560\":\"1\",\"583\":\"100\",\"584\":\"\",\"585\":\"\",\"586\":\"\",\"587\":\"\",\"588\":\"\",\"595\":\"\"}", "op_hasprice": 1, "op_hasstock": 1, "op_filterbycontacttype": 0, "op_filterbypricegroup": 0, "op_filterbysupplier": 0, "op_filterbyshuttertype": 0, "op_filterbyshuttersupplier": 0, "op_filterbyminmax": 0, "op_active": 0, "op_status": 0, "id": "23" } ], "updated": [ { "op_optionId": 23, "op_jobtempid": "0", "op_fieldTypeId": 3, "op_optionType": 1, "op_customerType": "{\"1\":true,\"2\":true,\"3\":true,\"4\":false,\"5\":false,\"6\":false}", "op_customisedformdata": "{\"94\":\"Demo com\",\"95\":\"\",\"96\":\"A6\",\"97\":\"\",\"98\":2,\"101\":\"\",\"102\":265,\"103\":265,\"104\":\"\",\"105\":\"\",\"106\":\"\",\"107\":\"\",\"108\":\"\",\"109\":\"\",\"110\":\"\",\"111\":\"\",\"112\":\"\",\"113\":\"\",\"114\":\"\",\"115\":\"\",\"116\":\"\",\"117\":\"\",\"118\":\"\",\"119\":\"\",\"120\":\"5\",\"123\":\"\",\"127\":1,\"258\":\"\",\"290\":\"\",\"433\":1,\"464\":\"\",\"503\":\"\",\"560\":\"1\",\"583\":\"100\",\"584\":\"\",\"585\":\"\",\"586\":\"\",\"587\":\"\",\"588\":\"\",\"595\":\"\"}", "op_hasprice": 1, "op_hasstock": 1, "op_filterbycontacttype": 0, "op_filterbypricegroup": 0, "op_filterbysupplier": 0, "op_filterbyshuttertype": 0, "op_filterbyshuttersupplier": 0, "op_filterbyminmax": 0, "op_active": 0, "op_status": 0, "id": "23" } ], "deleted": [] }, "bm_optionproduct": { "created": [], "updated": [], "deleted": [] }, "bm_linkedfieldswithproduct": { "created": [], "updated": [], "deleted": [] }, "bm_productionstatus": { "created": [], "updated": [], "deleted": [] }, "bm_productpricemap": { "created": [], "updated": [], "deleted": [] }, "bm_productrecipe": { "created": [ { "pr_id": 276, "pr_productid": 273, "pr_recipename": "Standard", "pr_showhide": 1, "pr_status": 0, "pr_default": 1, "pr_defaultrecepie": 1, "id": "276" } ], "updated": [], "deleted": [] }, "bm_productrecipemap": { "created": [ { "prm_id": 71669, "prm_recipeid": 276, "prm_fieldtypeid": 3, "prm_fieldvalueid": 22912, "prm_status": 0, "id": "71669" } ], "updated": [ { "prm_id": 71669, "prm_recipeid": 276, "prm_fieldtypeid": 3, "prm_fieldvalueid": 22912, "prm_status": 0, "id": "71669" } ], "deleted": [] }, "bm_supproductcode": { "created": [], "updated": [], "deleted": [] }, "bm_rulesetup": { "created": [], "updated": [], "deleted": [] }, "bm_formulas": { "created": [ { "fs_id": 61, "fs_recipeid": 276, "fs_bom": 0, "fs_fieldid": 0, "fs_variablename": "Fabric Quantity", "fs_formula": "", "fs_formula_js": "", "fs_formula_jsreplaced": "", "fs_formulatype": 1, "fs_displayonproduction": 1, "fs_displayonquoteformulas": 0, "fs_overidevalue": 0, "fs_deductfromstock": 1, "fs_costprice": 1, "fs_netprice": 1, "fs_unittype": 4, "fs_jobunittype": 4, "fs_issubfabric": 0, "fs_status": 0, "fs_seq": 0, "fs_fabricseq": 1, "id": "61" }, { "fs_id": 62, "fs_recipeid": 276, "fs_bom": 0, "fs_fieldid": 0, "fs_variablename": "Fabric Width", "fs_formula": "Width", "fs_formula_js": "Width", "fs_formula_jsreplaced": "Width\/1", "fs_formulatype": 1, "fs_displayonproduction": 1, "fs_displayonquoteformulas": 0, "fs_overidevalue": 0, "fs_deductfromstock": 1, "fs_costprice": 1, "fs_netprice": 1, "fs_unittype": 2, "fs_jobunittype": 2, "fs_issubfabric": 0, "fs_status": 0, "fs_seq": 0, "fs_fabricseq": 0, "id": "62" }, { "fs_id": 63, "fs_recipeid": 276, "fs_bom": 0, "fs_fieldid": 0, "fs_variablename": "Fabric Drop", "fs_formula": "Drop", "fs_formula_js": "Drop", "fs_formula_jsreplaced": "Drop\/1", "fs_formulatype": 1, "fs_displayonproduction": 1, "fs_displayonquoteformulas": 0, "fs_overidevalue": 0, "fs_deductfromstock": 1, "fs_costprice": 1, "fs_netprice": 1, "fs_unittype": 2, "fs_jobunittype": 2, "fs_issubfabric": 0, "fs_status": 0, "fs_seq": 0, "fs_fabricseq": 0, "id": "63" }, { "fs_id": 64, "fs_recipeid": 276, "fs_bom": 1, "fs_fieldid": 0, "fs_variablename": "Pitch", "fs_formula": "", "fs_formula_js": "", "fs_formula_jsreplaced": "", "fs_formulatype": 1, "fs_displayonproduction": 0, "fs_displayonquoteformulas": 0, "fs_overidevalue": 0, "fs_deductfromstock": 1, "fs_costprice": 0, "fs_netprice": 0, "fs_unittype": null, "fs_jobunittype": null, "fs_issubfabric": 0, "fs_status": 0, "fs_seq": 0, "fs_fabricseq": 0, "id": "64" }, { "fs_id": 66, "fs_recipeid": 276, "fs_bom": 0, "fs_fieldid": 22912, "fs_variablename": "Demo com", "fs_formula": "Extras_Democom_OptionQty*Quantity", "fs_formula_js": "Extras_Democom_OptionQty*Quantity", "fs_formula_jsreplaced": "Extras_Democom_OptionQty*Quantity", "fs_formulatype": 1, "fs_displayonproduction": 1, "fs_displayonquoteformulas": 0, "fs_overidevalue": 0, "fs_deductfromstock": 1, "fs_costprice": 1, "fs_netprice": 1, "fs_unittype": 2, "fs_jobunittype": 2, "fs_issubfabric": 0, "fs_status": 0, "fs_seq": 0, "fs_fabricseq": 0, "id": "66" } ], "updated": [ { "fs_id": 66, "fs_recipeid": 276, "fs_bom": 0, "fs_fieldid": 22912, "fs_variablename": "Demo com", "fs_formula": "Extras_Democom_OptionQty*Quantity", "fs_formula_js": "Extras_Democom_OptionQty*Quantity", "fs_formula_jsreplaced": "Extras_Democom_OptionQty*Quantity", "fs_formulatype": 1, "fs_displayonproduction": 1, "fs_displayonquoteformulas": 0, "fs_overidevalue": 0, "fs_deductfromstock": 1, "fs_costprice": 1, "fs_netprice": 1, "fs_unittype": 2, "fs_jobunittype": 2, "fs_issubfabric": 0, "fs_status": 0, "fs_seq": 0, "fs_fabricseq": 0, "id": "66" } ], "deleted": [ "65" ] }, "bm_customercommission": { "created": [], "updated": [], "deleted": [] }, "bm_productgroupdetails": { "created": [], "updated": [], "deleted": [] }, "bm_productgroupmaterialmap": { "created": [], "updated": [], "deleted": [] }, "bm_productpricedetails": { "created": [], "updated": [], "deleted": [] }, "bm_fabriccolourmap": { "created": [], "updated": [], "deleted": [] }, "bm_fabricdetails": { "created": [], "updated": [], "deleted": [] }, "bm_colordetails": { "created": [], "updated": [], "deleted": [] }, "bm_optiondiscount": { "created": [], "updated": [], "deleted": [] }, "bm_optionpricebook": { "created": [], "updated": [], "deleted": [] }, "bm_allowances": { "created": [], "updated": [], "deleted": [] }, "bm_xyoptionpricedata": { "created": [], "updated": [], "deleted": [] }, "bm_delivery_cost_setup": { "created": [], "updated": [], "deleted": [] }, "bm_organizationdetails": { "created": [], "updated": [ { "organization_id": 25, "organizationname": "Aquarius Blinds", "address": "Unit 1-245", "address2": "Church Road", "addres3": null, "city": "Mitcham", "state": "Surrey", "country": null, "code": "CR4 3BH", "phone": "020 8288 1081", "mobile1": null, "mobile2": "01273 020587", "fax": null, "email3": null, "email1": "santhoshmanokaran@blindmatrix.com", "email2": null, "website": null, "logoname": "aqblinds-logo.png", "logo": "122250-aqblinds-logo.png", "vatnumber": null, "vatrate": null, "settlementdiscount": null, "reportemailbody": null, "domesticpaymentterms": null, "contractpaymentterms": null, "tradepaymentterms": null, "companyterms": "SHADEWELL 1", "countryid": 4, "bankname": "Santander", "comregistrationno": "VAT No : 749 8363 77", "defaultsalestax": 1, "defaultsalestaxlabel": "VAT", "accountnumber": "40054837", "currencyid": 4, "sortcode": "090666", "status": 0, "isdefault": 1, "id": "25", "created_at": 1657091810, "updated_at": 1747136899, "created_by": 1, "updated_by": 1 } ], "deleted": [] }, "bm_applicationSetup": { "created": [], "updated": [], "deleted": [] } }, "synctodelete": { "bm_job_paymentlist": { "81747132795": 358 } }, "timestamp": 1747136984 }