{ "status": "success", "upcomingorder_list": { "bm_customertemplatedata": { "created": [ { "ctd_id": 4075, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\": 1, \"600\": 25, \"62\": \"QUOT0037\", \"63\": \"\", \"64\": \"\"}", "ctd_deletedcustokeyvalue": "{}", "ctd_isenablecustspecvatrate": 0, "ctd_custspecvatrate": "0.00", "ctd_vatregnum": null, "ctd_custsurcharge": null, "ctd_defaultdelcost": null, "ctd_defaultapptype": null, "ctd_defaultstaff": null, "ctd_addcredit": "0.00", "ctd_totredeemed": "0.00", "ctd_balance": "0.00", "ctd_creditlimit": "0.00", "ctd_creditavailable": "0.00", "ctd_overdue": 0, "ctd_paymenttermstype": 0, "ctd_paymenttermsvalue": 0, "ctd_paymenttermsdesc": null, "ctd_ishold": 0, "ctd_jobview": 0, "ctd_jobtypeview": 0, "ctd_discount": "0.00", "ctd_language": 0, "ctd_notymsg": 0, "ctd_onlinelogoname": null, "ctd_onlinelogo": null, "ctd_onlinesendemail": 0, "ctd_fordesktopisenable": 0, "ctd_foronlineisenable": 0, "ctd_enabledproductdesktop": "0", "ctd_enabledproductonline": "0", "ctd_onlineproductmarkup": null, "ctd_onlineendcustomeruseprefix": null, "ctd_onlineendcustomersequence": null, "ctd_onlinequotecustomerterms": null, "ctd_onlinequotepaymentterms": null, "ctd_onlineinvoicecustomerterms": null, "ctd_onlineinvoicepaymentterms": null, "ctd_seq": 0, "ctd_status": 0, "id": "4075", "ctd_createdat": 1750662226, "ctd_updatedat": 1750662618, "ctd_createdby": 0, "ctd_updatedby": null } ], "updated": [ { "ctd_id": 3975, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\":1,\"62\":\"MUFASA\",\"63\":\"Jk\",\"64\":25,\"65\":\"\",\"66\":\"\",\"67\":\"\",\"68\":\"\",\"69\":\"\",\"70\":\"\",\"71\":\"\",\"72\":36,\"73\":\"\",\"568\":\"\",\"600\":\"25\",\"617\":1}", "ctd_deletedcustokeyvalue": "{}", "ctd_isenablecustspecvatrate": 0, "ctd_custspecvatrate": "0.00", "ctd_vatregnum": null, "ctd_custsurcharge": null, "ctd_defaultdelcost": null, "ctd_defaultapptype": null, "ctd_defaultstaff": null, "ctd_addcredit": "0.00", "ctd_totredeemed": "0.00", "ctd_balance": "0.00", "ctd_creditlimit": "0.00", "ctd_creditavailable": "0.00", "ctd_overdue": 0, "ctd_paymenttermstype": 0, "ctd_paymenttermsvalue": 0, "ctd_paymenttermsdesc": null, "ctd_ishold": 0, "ctd_jobview": 0, "ctd_jobtypeview": 0, "ctd_discount": "0.00", "ctd_language": 0, "ctd_notymsg": 0, "ctd_onlinelogoname": null, "ctd_onlinelogo": null, "ctd_onlinesendemail": 0, "ctd_fordesktopisenable": 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,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305", "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,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305", "ctd_onlineproductmarkup": null, "ctd_onlineendcustomeruseprefix": null, "ctd_onlineendcustomersequence": "31", "ctd_onlinequotecustomerterms": null, "ctd_onlinequotepaymentterms": null, "ctd_onlineinvoicecustomerterms": null, "ctd_onlineinvoicepaymentterms": null, "ctd_seq": 0, "ctd_status": 0, "id": "3975", "ctd_createdat": 1747739991, "ctd_updatedat": 1750662239, "ctd_createdby": 0, "ctd_updatedby": 1 }, { "ctd_id": 4075, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\": 1, \"600\": 25, \"62\": \"QUOT0037\", \"63\": \"\", \"64\": \"\"}", "ctd_deletedcustokeyvalue": "{}", "ctd_isenablecustspecvatrate": 0, "ctd_custspecvatrate": "0.00", "ctd_vatregnum": null, "ctd_custsurcharge": null, "ctd_defaultdelcost": null, "ctd_defaultapptype": null, "ctd_defaultstaff": null, "ctd_addcredit": "0.00", "ctd_totredeemed": "0.00", "ctd_balance": "0.00", "ctd_creditlimit": "0.00", "ctd_creditavailable": "0.00", "ctd_overdue": 0, "ctd_paymenttermstype": 0, "ctd_paymenttermsvalue": 0, "ctd_paymenttermsdesc": null, "ctd_ishold": 0, "ctd_jobview": 0, "ctd_jobtypeview": 0, "ctd_discount": "0.00", "ctd_language": 0, "ctd_notymsg": 0, "ctd_onlinelogoname": null, "ctd_onlinelogo": null, "ctd_onlinesendemail": 0, "ctd_fordesktopisenable": 0, "ctd_foronlineisenable": 0, "ctd_enabledproductdesktop": "0", "ctd_enabledproductonline": "0", "ctd_onlineproductmarkup": null, "ctd_onlineendcustomeruseprefix": null, "ctd_onlineendcustomersequence": null, "ctd_onlinequotecustomerterms": null, "ctd_onlinequotepaymentterms": null, "ctd_onlineinvoicecustomerterms": null, "ctd_onlineinvoicepaymentterms": null, "ctd_seq": 0, "ctd_status": 0, "id": "4075", "ctd_createdat": 1750662226, "ctd_updatedat": 1750662618, "ctd_createdby": 0, "ctd_updatedby": null } ], "deleted": [] }, "bm_customercontactinfo": { "created": [ { "cci_id": 4261, "cci_customerid": 4075, "cci_templateid": 3, "roleid": 0, "cci_customizedarray": "{\"75\":12,\"79\":\"Quote 38\",\"83\":\"1\",\"82\":\"\",\"77\":\"The\",\"78\":\"\",\"76\":\"\",\"81\":\"\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"Quote 38\",\"90\":36,\"91\":\"Quote 38\",\"89\":\"\",\"86\":\"\",\"88\":\"\"}", "cci_ismarketingemails": 0, "cci_smsverifystatus": 0, "cci_isdocumentreceived": 0, "cci_receiveddocfor": null, "cci_isonlineportal": 0, "cci_latitude": null, "cci_longitude": null, "cci_username": null, "cci_password": null, "cci_confirmpassword": null, "cci_seq": 0, "cci_status": 0, "cci_deviceplatform": 1, "cci_mobcustomertempid": 31750662226, "id": "4261", "cci_createdat": 1750662226, "cci_updatedat": 1750662579, "cci_createdby": 0, "cci_updatedby": null } ], "updated": [ { "cci_id": 4261, "cci_customerid": 4075, "cci_templateid": 3, "roleid": 0, "cci_customizedarray": "{\"75\":12,\"79\":\"Quote 38\",\"83\":\"1\",\"82\":\"\",\"77\":\"The\",\"78\":\"\",\"76\":\"\",\"81\":\"\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"Quote 38\",\"90\":36,\"91\":\"Quote 38\",\"89\":\"\",\"86\":\"\",\"88\":\"\"}", "cci_ismarketingemails": 0, "cci_smsverifystatus": 0, "cci_isdocumentreceived": 0, "cci_receiveddocfor": null, "cci_isonlineportal": 0, "cci_latitude": null, "cci_longitude": null, "cci_username": null, "cci_password": null, "cci_confirmpassword": null, "cci_seq": 0, "cci_status": 0, "cci_deviceplatform": 1, "cci_mobcustomertempid": 31750662226, "id": "4261", "cci_createdat": 1750662226, "cci_updatedat": 1750662579, "cci_createdby": 0, "cci_updatedby": null } ], "deleted": [] }, "bm_appointment": { "created": [ { "app_eventid": 10086, "app_description": "", "app_summary": "AQ5636-Mk' Mk'-Measurer", "app_private": 0, "app_appointmentType": 62, "app_userId": 2, "app_orderId": 5636, "app_customerId": 0, "app_isAllDay": 0, "app_timezone": "Asia\/Calcutta", "app_latitude": null, "app_longitude": null, "app_parentappid": null, "app_recurrencerule": null, "app_userdefinedValue": "{\"5\":\"\"}", "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": 0, "id": "10086", "app_sdate": 1750636800, "app_edate": 1750636800, "app_stime": 1750674600, "app_etime": 1750678200, "app_sdatetime": 1750674600, "app_edatetime": 1750678200, "app_until": null, "app_createdAt": 1750662239, "app_updatedAt": 1750662239, "app_createdBy": 22, "app_updatedBy": null } ], "updated": [], "deleted": [] }, "bm_tasklist": { "created": [], "updated": [], "deleted": [] }, "bm_jobdetails": { "created": [ { "jd_id": 5825, "jd_customerid": 4075, "jd_contactid": 4261, "jd_additionalcontacts": "4261", "jd_templateid": 1, "jd_jobmultiquoteid": 5860, "jd_deletedcustokeyvalue": "{\"32\":\"\",\"34\":\"AQ5822\",\"35\":\"QUOT0037\",\"36\":1,\"38\":\"\",\"40\":13,\"countryText\":\"India\",\"adminUser\":1}", "jd_jobref": "AQ5822", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "QUOT0037", "jd_invoiceno": "", "jd_listprice": "70.00", "jd_netprice": "70.00", "jd_vat": "7.00", "jd_isvaton": 1, "jd_deliverycost": "70.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "77.00", "jd_grossprofit": "0.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "77.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": 0, "jd_endcustomeroverridevalue": "", "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": "", "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": "", "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 1, "jd_updatedby": 22, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 38, "jd_deliveryvatperc": "10.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":\"\",\"41\":1,\"44\":\"\",\"45\":\"The\",\"46\":\"Quote 38\",\"47\":\"\",\"48\":\"\",\"49\":\"Quote 38\",\"50\":\"\",\"51\":\"Quote 38\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":12,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"618\":\"5456\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "10.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5825", "jd_createddate": 1750636800, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1750662226, "jd_updatedat": 1750662618 } ], "updated": [ { "jd_id": 5636, "jd_customerid": 3975, "jd_contactid": 4148, "jd_additionalcontacts": "4148", "jd_templateid": 1, "jd_jobmultiquoteid": 5661, "jd_deletedcustokeyvalue": "{\"62\":[\"\",\"MUFASA\"],\"83\":\"1\",\"65\":\"\",\"66\":\"\",\"67\":\"\",\"68\":\"\",\"69\":\"\",\"70\":\"\",\"71\":\"\",\"72\":36,\"73\":\"\",\"568\":\"\",\"617\":1}", "jd_jobref": "AQ5636", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "MUFASA", "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": 0, "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": "", "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": "", "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": "", "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 1, "jd_updatedby": 22, "jd_deviceplatform": 0, "jd_fromjobref": "11412", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "10.000", "jd_fromdbname": "TESTING3TEST", "jd_jobcustomoizedkeyvalue": "{\"33\":\"25\",\"37\":1,\"39\":25,\"41\":\"1\",\"44\":\"Jk\",\"45\":\"Mk'\",\"46\":\"Mk'\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":12,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":\"1\",\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"618\":\"45\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "10.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5636", "jd_createddate": 1747699200, "jd_orderdate": null, "jd_duedate": 1747699200, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1747742633, "jd_updatedat": 1750662210 }, { "jd_id": 5728, "jd_customerid": 4011, "jd_contactid": 4187, "jd_additionalcontacts": "4187", "jd_templateid": 1, "jd_jobmultiquoteid": 5757, "jd_deletedcustokeyvalue": "{\"32\":\"\",\"34\":\"AQ5725\",\"35\":\"JOHN0007\",\"36\":6,\"38\":\"201749045126\",\"40\":13}", "jd_jobref": "AQ5725", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "JOHN0007", "jd_invoiceno": "Invoice9662", "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": "-55.00", "jd_totpaid": "55.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": 0, "jd_endcustomeroverridevalue": "", "jd_endcustomeroverridenetprice": "92.45", "jd_endcustomeroverridevatprice": "9.25", "jd_endcustomeroverridegrossprice": "101.70", "jd_endcustomerdeliverycost": "", "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": "", "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 1, "jd_updatedby": 22, "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\":22,\"41\":1,\"44\":\"John Smith Pvt Ltd\",\"45\":\"Johny\",\"46\":\"Leo\",\"47\":\"595955848\",\"48\":\"\",\"49\":\"Cit Nagar\",\"50\":\"Nandanam\",\"51\":\"ChennaiChenain\",\"52\":\"India\",\"53\":\"635301\",\"54\":36,\"285\":12,\"286\":\"264945946\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":1,\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"618\":\"87\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "0.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5728", "jd_createddate": 1748995200, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1749044646, "jd_updatedat": 1750662487 }, { "jd_id": 5825, "jd_customerid": 4075, "jd_contactid": 4261, "jd_additionalcontacts": "4261", "jd_templateid": 1, "jd_jobmultiquoteid": 5860, "jd_deletedcustokeyvalue": "{\"32\":\"\",\"34\":\"AQ5822\",\"35\":\"QUOT0037\",\"36\":1,\"38\":\"\",\"40\":13,\"countryText\":\"India\",\"adminUser\":1}", "jd_jobref": "AQ5822", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "QUOT0037", "jd_invoiceno": "", "jd_listprice": "70.00", "jd_netprice": "70.00", "jd_vat": "7.00", "jd_isvaton": 1, "jd_deliverycost": "70.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "77.00", "jd_grossprofit": "0.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "77.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": 0, "jd_endcustomeroverridevalue": "", "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": "", "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": "", "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 1, "jd_updatedby": 22, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 38, "jd_deliveryvatperc": "10.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":\"\",\"41\":1,\"44\":\"\",\"45\":\"The\",\"46\":\"Quote 38\",\"47\":\"\",\"48\":\"\",\"49\":\"Quote 38\",\"50\":\"\",\"51\":\"Quote 38\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":12,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"618\":\"5456\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "10.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5825", "jd_createddate": 1750636800, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1750662226, "jd_updatedat": 1750662618 } ], "deleted": [] }, "bm_orderitem": { "created": [ { "oi_id": 31651, "oi_jobid": 5821, "oi_jobtempid": "0", "oi_jobmultiquoteid": 5856, "oi_productid": 15, "oi_recipeid": 15, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":7231,\"labelname\":\"Location\",\"value\":\"kitchen\",\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Location\",\"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\":1,\"fieldname\":\"Location\",\"fieldid\":7231,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":6893,\"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\":6893,\"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\":4438,\"labelname\":\"Supplier\",\"value\":\"13\",\"valueid\":null,\"type\":17,\"optionid\":\"13\",\"optionvalue\":[{\"id\":3,\"optionid\":3,\"optionname\":\"Decora\",\"deleted\":0,\"optionquantity\":1},{\"id\":13,\"optionid\":13,\"optionname\":\"Drapes UK\",\"deleted\":0,\"optionquantity\":1}],\"issubfabric\":0,\"labelnamecode\":\"SupplierDUK\",\"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\":4438,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"13\",\"optionsvalue\":[{\"id\":3,\"optionid\":3,\"optionname\":\"Decora\",\"deleted\":0,\"optionquantity\":1},{\"id\":13,\"optionid\":13,\"optionname\":\"Drapes UK\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":7242,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":null,\"type\":14,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Quantityiudfh\",\"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\":7242,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4439,\"labelname\":\"Width\",\"value\":\"1000\",\"valueid\":null,\"type\":11,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Width001\",\"fabricorcolor\":0,\"widthfraction\":\"0_mm_3_0\",\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":0,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":11,\"mandatory\":0,\"fieldname\":\"Width\",\"fieldid\":4439,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":4440,\"labelname\":\"Drop\",\"value\":\"1000\",\"valueid\":null,\"type\":12,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Drop002\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":\"0_mm_3_0\",\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":0,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":12,\"mandatory\":0,\"fieldname\":\"Drop\",\"fieldid\":4440,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":4661,\"labelname\":\"Installation height\",\"value\":\"1000\",\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Installation heightIHG\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":6,\"mandatory\":0,\"fieldname\":\"Installation height\",\"fieldid\":4661,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":4442,\"labelname\":\"Measure to\",\"value\":\"Blind\",\"valueid\":\"5556\",\"type\":3,\"optionid\":\"1000\",\"optionvalue\":[{\"optionid\":1000,\"optionqty\":\"1\",\"optioncode\":\"BD\",\"optionname\":\"Blind\",\"unitcost\":null,\"unittype\":null,\"fieldoptionlinkid\":5556,\"forchildfieldoptionlinkid\":\"3_5556\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"issubfabric\":0,\"labelnamecode\":\"Measure toMT\",\"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\":\"Measure to\",\"fieldid\":4442,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"1000\",\"optionsvalue\":[{\"optionid\":1000,\"optionqty\":\"1\",\"optioncode\":\"BD\",\"optionname\":\"Blind\",\"unitcost\":null,\"unittype\":null,\"fieldoptionlinkid\":5556,\"forchildfieldoptionlinkid\":\"3_5556\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"editruleoverride\":1},{\"id\":4444,\"labelname\":\"Fabric choice\",\"value\":\"Alderney\",\"valueid\":\"4258\",\"type\":5,\"optionid\":\"4258\",\"optionvalue\":[{\"optionid\":4258,\"optionname\":\"Alderney\",\"optioncode\":\"Ald\",\"optionquantity\":1,\"fieldoptionlinkid\":4258,\"forchildfieldoptionlinkid\":\"5_2_4258_1\",\"optionimage\":null,\"subdatacount\":1,\"optionid_pricegroupid\":\"4258_380\",\"fabricmapid\":4258,\"pricegroup\":\"Price band 3\",\"pricegroupid\":380}],\"issubfabric\":0,\"labelnamecode\":\"Fabric choice\",\"fabricorcolor\":1,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":0,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":5,\"mandatory\":0,\"fieldname\":\"Fabric choice\",\"fieldid\":4444,\"subchild\":[{\"fieldtypeid\":5,\"labelnamecode\":\"Color\",\"fieldid\":4592,\"status\":0,\"fieldname\":\"Color\",\"field_has_sub_option\":1,\"selection\":0,\"seq\":130,\"mandatory\":0,\"fieldlevel\":2,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"fabricorcolor\":2,\"optionsvalue\":[{\"optionid\":10321,\"optionname\":\"Apple Green\",\"optioncode\":\"App\",\"optionquantity\":1,\"fieldoptionlinkid\":28375,\"forchildfieldoptionlinkid\":\"5_3_28375_0\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":10322,\"optionname\":\"Charlston Grey\",\"optioncode\":\"Chr\",\"optionquantity\":1,\"fieldoptionlinkid\":28376,\"forchildfieldoptionlinkid\":\"5_3_28376_0\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":10323,\"optionname\":\"Duckegg\",\"optioncode\":\"Dog\",\"optionquantity\":1,\"fieldoptionlinkid\":28377,\"forchildfieldoptionlinkid\":\"5_3_28377_0\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":10324,\"optionname\":\"Soft Gold\",\"optioncode\":\"Sof\",\"optionquantity\":1,\"fieldoptionlinkid\":28378,\"forchildfieldoptionlinkid\":\"5_3_28378_0\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":10325,\"optionname\":\"Indigo\",\"optioncode\":\"Ind\",\"optionquantity\":1,\"fieldoptionlinkid\":28379,\"forchildfieldoptionlinkid\":\"5_3_28379_0\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":10326,\"optionname\":\"Soft Pink\",\"optioncode\":\"Sot\",\"optionquantity\":1,\"fieldoptionlinkid\":28380,\"forchildfieldoptionlinkid\":\"5_3_28380_0\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":10327,\"optionname\":\"Red\",\"optioncode\":\"Red\",\"optionquantity\":1,\"fieldoptionlinkid\":28381,\"forchildfieldoptionlinkid\":\"5_3_28381_0\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":10328,\"optionname\":\"Teal\",\"optioncode\":\"Tea\",\"optionquantity\":1,\"fieldoptionlinkid\":28382,\"forchildfieldoptionlinkid\":\"5_3_28382_0\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":10329,\"optionname\":\"Indigo\",\"optioncode\":\"Ing\",\"optionquantity\":1,\"fieldoptionlinkid\":28383,\"forchildfieldoptionlinkid\":\"5_3_28383_0\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null}],\"optionsbackup\":[{\"optionid\":10321,\"optionname\":\"Apple Green\",\"optioncode\":\"App\",\"optionquantity\":1,\"fieldoptionlinkid\":28375,\"forchildfieldoptionlinkid\":\"5_3_28375_0\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":10322,\"optionname\":\"Charlston Grey\",\"optioncode\":\"Chr\",\"optionquantity\":1,\"fieldoptionlinkid\":28376,\"forchildfieldoptionlinkid\":\"5_3_28376_0\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":10323,\"optionname\":\"Duckegg\",\"optioncode\":\"Dog\",\"optionquantity\":1,\"fieldoptionlinkid\":28377,\"forchildfieldoptionlinkid\":\"5_3_28377_0\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":10324,\"optionname\":\"Soft Gold\",\"optioncode\":\"Sof\",\"optionquantity\":1,\"fieldoptionlinkid\":28378,\"forchildfieldoptionlinkid\":\"5_3_28378_0\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":10325,\"optionname\":\"Indigo\",\"optioncode\":\"Ind\",\"optionquantity\":1,\"fieldoptionlinkid\":28379,\"forchildfieldoptionlinkid\":\"5_3_28379_0\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":10326,\"optionname\":\"Soft Pink\",\"optioncode\":\"Sot\",\"optionquantity\":1,\"fieldoptionlinkid\":28380,\"forchildfieldoptionlinkid\":\"5_3_28380_0\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":10327,\"optionname\":\"Red\",\"optioncode\":\"Red\",\"optionquantity\":1,\"fieldoptionlinkid\":28381,\"forchildfieldoptionlinkid\":\"5_3_28381_0\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":10328,\"optionname\":\"Teal\",\"optioncode\":\"Tea\",\"optionquantity\":1,\"fieldoptionlinkid\":28382,\"forchildfieldoptionlinkid\":\"5_3_28382_0\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":10329,\"optionname\":\"Indigo\",\"optioncode\":\"Ing\",\"optionquantity\":1,\"fieldoptionlinkid\":28383,\"forchildfieldoptionlinkid\":\"5_3_28383_0\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null}],\"editablecolumns\":[],\"subfieldlinkid\":4258,\"forchildsubfieldlinkid\":\"5_2_4258_1\",\"optionsselectedcolumns\":{\"optionid\":\"Option Id\",\"optionname\":\"Color Name\",\"optioncode\":\"Color Code\"},\"optiondefault\":null,\"value\":null,\"issubfabric\":0,\"masterparentfieldid\":4444,\"hasstock\":0,\"subchild\":[],\"supplierid\":\"0\",\"editruleoverride\":null,\"linktopricegroup\":0,\"dualseq\":1,\"fieldInformation\":null,\"multiseq\":0,\"dumydata\":[],\"blindswidth\":0}],\"fieldInformation\":null,\"optiondefault\":\"4258\",\"optionsvalue\":[{\"optionid\":4258,\"optionname\":\"Alderney\",\"optioncode\":\"Ald\",\"optionquantity\":1,\"fieldoptionlinkid\":4258,\"forchildfieldoptionlinkid\":\"5_2_4258_1\",\"optionimage\":null,\"subdatacount\":1,\"optionid_pricegroupid\":\"4258_380\",\"fabricmapid\":4258,\"pricegroup\":\"Price band 3\",\"pricegroupid\":380}],\"editruleoverride\":1},{\"id\":4592,\"labelname\":\"Color\",\"value\":null,\"valueid\":null,\"type\":5,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Color\",\"fabricorcolor\":2,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":2,\"fieldtypeid\":5,\"mandatory\":0,\"fieldname\":\"Color\",\"fieldid\":4592,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4446,\"labelname\":\"Control side\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Control sideCS\",\"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\":4446,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4447,\"labelname\":\"Blind Lining\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Blind LiningRL\",\"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 Lining\",\"fieldid\":4447,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4448,\"labelname\":\"Valance pelmet\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Valance pelmetVP\",\"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\":\"Valance pelmet\",\"fieldid\":4448,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4449,\"labelname\":\"Operation\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"OperationOP\",\"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\":\"Operation\",\"fieldid\":4449,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4468,\"labelname\":\"Product Type\",\"value\":380,\"valueid\":\"458\",\"type\":13,\"optionid\":380,\"optionvalue\":[{\"id\":458,\"fieldid\":4468,\"fieldoptionlinkid\":458,\"optionid\":380,\"mainsupplier\":\"13\",\"blindtypecode\":null,\"optionname\":\"Price band 3\",\"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\":4468,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":380,\"optionsvalue\":[{\"id\":458,\"fieldid\":4468,\"fieldoptionlinkid\":458,\"optionid\":380,\"mainsupplier\":\"13\",\"blindtypecode\":null,\"optionname\":\"Price band 3\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"editruleoverride\":0},{\"id\":4652,\"labelname\":\"Headrail\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Headrail\",\"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\":\"Headrail\",\"fieldid\":4652,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4663,\"labelname\":\"Workroom instructions\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Workroom instructionsWIM\",\"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\":\"Workroom instructions\",\"fieldid\":4663,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4664,\"labelname\":\"Fitters instructions\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fitters instructionsFII\",\"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\":\"Fitters instructions\",\"fieldid\":4664,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4665,\"labelname\":\"Special instructions\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Special instructionsSIC\",\"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\":4665,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Location: kitchen, Supplier: Drapes UK, Width: 1000, Drop: 1000, Installation height: 1000, Measure to: Blind, Fabric choice: Alderney, Product Type: Price band 3", "oi_reportdescription": "##Location: kitchen##,##Supplier: Drapes UK##,##Quantity: 1##,##Width: 1000 mm##,##Drop: 1000 mm##,##Installation height: 1000##,##Measure to: Blind##,##Fabric choice: Alderney##,##Product Type: Price band 3##", "oi_reporttitles": "##Location:<\/br>##Supplier:<\/br>##Quantity:<\/br>##Width:<\/br>##Drop:<\/br>##Installation height:<\/br>##Measure to:<\/br>##Fabric choice:<\/br>##Product Type:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":null,\"value\":\"-\",\"formula\":null,\"price\":null,\"recipeid\":null,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":null,\"fieldtype_id\":0,\"fractionvalue\":null}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"0.00\",\"cost_with_discount\":\"0.00\",\"cost_with_markup\":\"0.00\",\"gross_price\":\"0.00\",\"vat_price\":\"0.00\"}", "oi_pricecomesfrom_calculations": "{\"label\":\"Price table cost\",\"unit_type\":\"-\",\"cost_price\":\"87.78\",\"show_hide\":true,\"category\":3}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "87.780", "oi_netprice": "193.120", "oi_pricesfromoperations": null, "oi_vatprice": "19.310", "oi_vatvalue": "10.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "212.430", "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": "193.120", "oi_endcustomeroverridevatprice": "19.310", "oi_endcustomeroverridegrossprice": "212.430", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[7231, 6893, 4438, 7242, 4439, 4440, 4661, 4442, 4444, 4592, 4446, 4447, 4448, 4449, 4468, 4652, 4663, 4664, 4665]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "31651", "oi_productiondate": 1750681110, "oi_createdat": 1750681110, "oi_updatedat": 1750661648, "oi_createdby": 1, "oi_updatedby": null }, { "oi_id": 31652, "oi_jobid": 5821, "oi_jobtempid": "0", "oi_jobmultiquoteid": 5856, "oi_productid": 248, "oi_recipeid": 250, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 2, "oi_customseq": 2, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":6965,\"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\":6965,\"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\":6964,\"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\":6964,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":6966,\"labelname\":\"Supplier\",\"value\":\"18\",\"valueid\":null,\"type\":17,\"optionid\":\"18\",\"optionvalue\":[{\"id\":18,\"optionid\":18,\"optionname\":\"C & P Security\",\"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\":6966,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"18\",\"optionsvalue\":[{\"id\":18,\"optionid\":18,\"optionname\":\"C & P Security\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":1},{\"id\":6967,\"labelname\":\"Room\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Room\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Room\",\"fieldid\":6967,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":6968,\"labelname\":\"Blind or Recess\",\"value\":\"Blind\",\"valueid\":\"21572\",\"type\":3,\"optionid\":\"2484\",\"optionvalue\":[{\"optionid\":2484,\"optionqty\":\"1\",\"optioncode\":null,\"optionname\":\"Blind\",\"unitcost\":null,\"unittype\":null,\"fieldoptionlinkid\":21572,\"forchildfieldoptionlinkid\":\"3_21572\",\"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\":6968,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"2484\",\"optionsvalue\":[{\"optionid\":2484,\"optionqty\":\"1\",\"optioncode\":null,\"optionname\":\"Blind\",\"unitcost\":null,\"unittype\":null,\"fieldoptionlinkid\":21572,\"forchildfieldoptionlinkid\":\"3_21572\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"editruleoverride\":1},{\"id\":6969,\"labelname\":\"Width\",\"value\":\"1000\",\"valueid\":null,\"type\":11,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Width\",\"fabricorcolor\":0,\"widthfraction\":\"0_mm_3_0\",\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":11,\"mandatory\":0,\"fieldname\":\"Width\",\"fieldid\":6969,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":6970,\"labelname\":\"Drop\",\"value\":\"1000\",\"valueid\":null,\"type\":12,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Drop\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":\"0_mm_3_0\",\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":12,\"mandatory\":0,\"fieldname\":\"Drop\",\"fieldid\":6970,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":6979,\"labelname\":\"Product Type\",\"value\":\"523\",\"valueid\":\"951\",\"type\":13,\"optionid\":\"523\",\"optionvalue\":[{\"id\":951,\"fieldid\":6979,\"fieldoptionlinkid\":951,\"optionid\":523,\"mainsupplier\":\"18\",\"blindtypecode\":null,\"optionname\":\"DLF\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"issubfabric\":0,\"labelnamecode\":\"Product Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":13,\"mandatory\":0,\"fieldname\":\"Product Type\",\"fieldid\":6979,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"523\",\"optionsvalue\":[{\"id\":951,\"fieldid\":6979,\"fieldoptionlinkid\":951,\"optionid\":523,\"mainsupplier\":\"18\",\"blindtypecode\":null,\"optionname\":\"DLF\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"editruleoverride\":1},{\"id\":6980,\"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\":6980,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":6973,\"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\":6973,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":6975,\"labelname\":\"Headrail System\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Headrail System\",\"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\":\"Headrail System\",\"fieldid\":6975,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7215,\"labelname\":\"Stacking Options\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Stacking Options\",\"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\":\"Stacking Options\",\"fieldid\":7215,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7216,\"labelname\":\"Manual Control Options\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Manual Control Options\",\"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\":\"Manual Control Options\",\"fieldid\":7216,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7217,\"labelname\":\"CBL Manual Control Options\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"CBL Manual Control Options\",\"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\":\"CBL Manual Control Options\",\"fieldid\":7217,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7218,\"labelname\":\"Motor Options\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Motor Options\",\"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\":\"Motor Options\",\"fieldid\":7218,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7219,\"labelname\":\"CBL Motor Options\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"CBL Motor Options\",\"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\":\"CBL Motor Options\",\"fieldid\":7219,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7220,\"labelname\":\"Fixing Options\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fixing Options\",\"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\":\"Fixing Options\",\"fieldid\":7220,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7221,\"labelname\":\"Hem Pocket Options\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Hem Pocket Options\",\"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\":\"Hem Pocket Options\",\"fieldid\":7221,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":6977,\"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\":6977,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":6978,\"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\":6978,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Supplier: C & P Security, Blind or Recess: Blind, Width: 1000, Drop: 1000, Product Type: DLF", "oi_reportdescription": "##Quantity: 1##,##Supplier: C & P Security##,##Blind or Recess: Blind##,##Width: 1000 mm##,##Drop: 1000 mm##,##Product Type: DLF##", "oi_reporttitles": "##Quantity:<\/br>##Supplier:<\/br>##Blind or Recess:<\/br>##Width:<\/br>##Drop:<\/br>##Product Type:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":null,\"value\":\"-\",\"formula\":null,\"price\":null,\"recipeid\":null,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":null,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":15,\"value\":\"700.00\",\"formula\":\"IF(BlindorRecess=\\\"Recess\\\",Drop-VerticalsDropAllowance-VerticalsRecessAllowance,Drop-VerticalsDropAllowance)\",\"price\":\"-\",\"recipeid\":250,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"700.00\"},{\"productionoveride\":0,\"id\":16,\"value\":\"700.00\",\"formula\":\"Drop-VerticalsDropAllowance\",\"price\":\"-\",\"recipeid\":250,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"700.00\"},{\"productionoveride\":0,\"id\":17,\"value\":\"990.00\",\"formula\":\"Width-HeadrailAllowance\",\"price\":\"-\",\"recipeid\":250,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"990.00\"},{\"productionoveride\":0,\"id\":18,\"value\":null,\"formula\":\"IF(Bunch=\\\"Split\\\",Evn((Round(HeadrailCut\\\/Spacing89mm,0))),Round((HeadrailCut\\\/Spacing89mm),0))\",\"price\":null,\"recipeid\":250,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":19,\"value\":\"950.00\",\"formula\":\"Drop-HemAllowance\",\"price\":\"-\",\"recipeid\":250,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"950.00\"},{\"productionoveride\":0,\"id\":20,\"value\":null,\"formula\":\"Round(IF(BlindorRecess=\\\"Recess\\\",((Drop-FabricAllowance-HemAllowance+PocketSize)*Vanes)\\\/1000,((Drop-HemAllowance+PocketSize)*Vanes)\\\/1000),1)\",\"price\":null,\"recipeid\":250,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"0.00\",\"cost_with_discount\":\"0.00\",\"cost_with_markup\":\"0.00\",\"gross_price\":\"0.00\",\"vat_price\":\"0.00\"}", "oi_pricecomesfrom_calculations": "{\"label\":\"Price table cost\",\"unit_type\":\"-\",\"cost_price\":\"51.00\",\"show_hide\":true,\"category\":3}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "51.000", "oi_netprice": "51.000", "oi_pricesfromoperations": null, "oi_vatprice": "5.100", "oi_vatvalue": "10.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "56.100", "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": "51.000", "oi_endcustomeroverridevatprice": "5.100", "oi_endcustomeroverridegrossprice": "56.100", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[6965, 6964, 6966, 6967, 6968, 6969, 6970, 6979, 6980, 6973, 6975, 7215, 7216, 7217, 7218, 7219, 7220, 7221, 6977, 6978]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "31652", "oi_productiondate": 1750681418, "oi_createdat": 1750681418, "oi_updatedat": 1750661648, "oi_createdby": 1, "oi_updatedby": null } ], "updated": [], "deleted": [] }, "bm_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_notelist": { "created": [ { "nl_id": 105331, "nl_ordertempid": 0, "nl_orderid": 5825, "nl_notescategory": 1, "nl_type": 17, "nl_platform": 1, "nl_desc": "New job has been created in job", "nl_manualNotes": null, "nl_createdby": "1", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 0, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "105331", "nl_endddate": 1750636800, "nl_starttime": 1750662226, "created_at": 1750662226, "updated_at": 1750662233, "created_by": 1, "updated_by": null } ], "updated": [], "deleted": [] }, "bm_deliveryaddresssetting": { "created": [ { "das_id": 5677, "das_jobid": 5825, "das_appointmentaddress": 4261, "das_invoiceaddress": 4261, "das_invoicedeliveryaddress": 4261, "das_purchaseaddress": 0, "das_worksheetaddress": 0, "id": "5677", "das_createdat": 1750662579, "das_updatedat": 1750662579, "das_createdby": 22, "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": [], "updated": [], "deleted": [] }, "bm_OverPayment": { "created": [], "updated": [], "deleted": [] }, "bm_terms": { "created": [ { "termsid": 18731, "orderid": 5636, "jobmultiquoteid": 5661, "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": "18731", "created_at": 1750662239, "updated_at": 1750662239, "terms_created_at": 1722586185, "created_by": null, "updated_by": null }, { "termsid": 18732, "orderid": 5636, "jobmultiquoteid": 5661, "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": "18732", "created_at": 1750662239, "updated_at": 1750662239, "terms_created_at": 1708073527, "created_by": 1, "updated_by": null }, { "termsid": 18733, "orderid": 5636, "jobmultiquoteid": 5661, "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": "18733", "created_at": 1750662239, "updated_at": 1750662239, "terms_created_at": 1708073606, "created_by": 1, "updated_by": null }, { "termsid": 18734, "orderid": 5636, "jobmultiquoteid": 5661, "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": "18734", "created_at": 1750662239, "updated_at": 1750662239, "terms_created_at": 1708073626, "created_by": 1, "updated_by": null }, { "termsid": 18735, "orderid": 5636, "jobmultiquoteid": 5661, "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": "18735", "created_at": 1750662239, "updated_at": 1750662239, "terms_created_at": 1722585569, "created_by": null, "updated_by": null }, { "termsid": 18736, "orderid": 5636, "jobmultiquoteid": 5661, "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": "18736", "created_at": 1750662239, "updated_at": 1750662239, "terms_created_at": 1722585569, "created_by": 1, "updated_by": null }, { "termsid": 18737, "orderid": 5636, "jobmultiquoteid": 5661, "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": "18737", "created_at": 1750662239, "updated_at": 1750662239, "terms_created_at": 1722585569, "created_by": 1, "updated_by": null }, { "termsid": 18738, "orderid": 5636, "jobmultiquoteid": 5661, "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": "18738", "created_at": 1750662239, "updated_at": 1750662239, "terms_created_at": 1722585569, "created_by": 1, "updated_by": null }, { "termsid": 18739, "orderid": 5636, "jobmultiquoteid": 5661, "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": "18739", "created_at": 1750662239, "updated_at": 1750662239, "terms_created_at": 1722585569, "created_by": null, "updated_by": null }, { "termsid": 18740, "orderid": 5636, "jobmultiquoteid": 5661, "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": "18740", "created_at": 1750662239, "updated_at": 1750662239, "terms_created_at": 1722585569, "created_by": 1, "updated_by": null }, { "termsid": 18741, "orderid": 5636, "jobmultiquoteid": 5661, "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": "18741", "created_at": 1750662239, "updated_at": 1750662239, "terms_created_at": 1722585569, "created_by": 1, "updated_by": null }, { "termsid": 18742, "orderid": 5636, "jobmultiquoteid": 5661, "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": "18742", "created_at": 1750662239, "updated_at": 1750662239, "terms_created_at": 1722585569, "created_by": 1, "updated_by": null } ], "updated": [], "deleted": [] }, "bm_jobmultiquote": { "created": [ { "jmq_id": 5860, "jmq_jobid": 5825, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "70.00", "jmq_netprice": "70.00", "jmq_vat": "7.00", "jmq_isvaton": 1, "jmq_deliverycost": "70.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 1, "jmq_orderformprice": "0.00", "jmq_editpricebyid": 0, "jmq_isroundon": 0, "jmq_grossprice": "77.00", "jmq_grossprofit": "0.00", "jmq_costprice": "0.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "77.00", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": "\"\"", "jmq_deliverycostid": 0, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 1, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 0, "jmq_endcustomeroverridevalue": "", "jmq_endcustomeroverridenetprice": "0.00", "jmq_endcustomeroverridevatprice": "0.00", "jmq_endcustomeroverridegrossprice": "0.00", "jmq_endcustomerdeliverycost": "", "jmq_endcustomerdeliverycostinclvat": 0, "jmq_endcustomerfittingcost": "", "jmq_endcustomerfittingcostinclvat": 0, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": 0, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "10.000", "jmq_cdeliveryvatperc": "10.000", "id": "5860", "jmq_duedate": null, "jmq_sceduleddate": null, "jmq_createdat": "1750662226.000000", "jmq_updatedat": "1750662618.000000", "jmq_createdby": 1, "jmq_updatedby": 1 } ], "updated": [ { "jmq_id": 5661, "jmq_jobid": 5636, "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": 0, "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": "\"\"", "jmq_deliverycostid": 0, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 1, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 1, "jmq_endcustomeroverridevalue": "", "jmq_endcustomeroverridenetprice": "0.00", "jmq_endcustomeroverridevatprice": "0.00", "jmq_endcustomeroverridegrossprice": "0.00", "jmq_endcustomerdeliverycost": "", "jmq_endcustomerdeliverycostinclvat": 1, "jmq_endcustomerfittingcost": "", "jmq_endcustomerfittingcostinclvat": 1, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "10.000", "jmq_cdeliveryvatperc": "10.000", "id": "5661", "jmq_duedate": 1747699200, "jmq_sceduleddate": null, "jmq_createdat": "1747742633.000000", "jmq_updatedat": "1750662210.000000", "jmq_createdby": 1, "jmq_updatedby": 1 }, { "jmq_id": 5860, "jmq_jobid": 5825, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "70.00", "jmq_netprice": "70.00", "jmq_vat": "7.00", "jmq_isvaton": 1, "jmq_deliverycost": "70.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 1, "jmq_orderformprice": "0.00", "jmq_editpricebyid": 0, "jmq_isroundon": 0, "jmq_grossprice": "77.00", "jmq_grossprofit": "0.00", "jmq_costprice": "0.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "77.00", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": "\"\"", "jmq_deliverycostid": 0, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 1, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 0, "jmq_endcustomeroverridevalue": "", "jmq_endcustomeroverridenetprice": "0.00", "jmq_endcustomeroverridevatprice": "0.00", "jmq_endcustomeroverridegrossprice": "0.00", "jmq_endcustomerdeliverycost": "", "jmq_endcustomerdeliverycostinclvat": 0, "jmq_endcustomerfittingcost": "", "jmq_endcustomerfittingcostinclvat": 0, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": 0, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "10.000", "jmq_cdeliveryvatperc": "10.000", "id": "5860", "jmq_duedate": null, "jmq_sceduleddate": null, "jmq_createdat": "1750662226.000000", "jmq_updatedat": "1750662618.000000", "jmq_createdby": 1, "jmq_updatedby": 1 } ], "deleted": [] }, "bm_jobstatus_tracks": { "created": [ { "jst_id": 6547, "jst_jobid": 5825, "jst_job_current_status": 1, "id": "6547", "jst_createdat": "1750662233.402413" } ], "updated": [], "deleted": [] }, "bm_customindividuallogs": { "created": [ { "cl_id": 60106, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the fields Number,Delivery Vat Percentage,Commission", "cl_event": "modified", "cl_subjectid": 5636, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5636, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 22, "cl_changedfrom": "{\"Account Ref\":[\"\",\"MUFASA\"],\"Default Contact\":\"1\",\"Commission\":\"\\\"\\\"\"}", "cl_changedto": "{\"Number\":\"45\",\"Delivery Vat Percentage\":\"10.000\",\"Commission\":\"[]\"}", "cl_customproperties": "{\"attributes\":{\"jd_jobcustomoizedkeyvalue\":\"{\\\"33\\\":\\\"25\\\",\\\"37\\\":1,\\\"39\\\":25,\\\"41\\\":\\\"1\\\",\\\"44\\\":\\\"Jk\\\",\\\"45\\\":\\\"Mk'\\\",\\\"46\\\":\\\"Mk'\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":36,\\\"285\\\":12,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":\\\"1\\\",\\\"558\\\":\\\"\\\",\\\"559\\\":1,\\\"610\\\":\\\"\\\",\\\"611\\\":\\\"\\\",\\\"612\\\":1,\\\"618\\\":\\\"45\\\"}\",\"jd_deletedcustokeyvalue\":\"{\\\"62\\\":[\\\"\\\",\\\"MUFASA\\\"],\\\"83\\\":\\\"1\\\",\\\"65\\\":\\\"\\\",\\\"66\\\":\\\"\\\",\\\"67\\\":\\\"\\\",\\\"68\\\":\\\"\\\",\\\"69\\\":\\\"\\\",\\\"70\\\":\\\"\\\",\\\"71\\\":\\\"\\\",\\\"72\\\":36,\\\"73\\\":\\\"\\\",\\\"568\\\":\\\"\\\",\\\"617\\\":1}\",\"jd_endcustomeroverridevalue\":\"\",\"jd_endcustomerdeliverycost\":\"\",\"jd_endcustomerfittingcost\":\"\",\"jd_updatedby\":22,\"jd_updatedat\":\"2025-06-23T07:03:30.000000Z\",\"jd_deliveryvatperc\":\"10.000\",\"jd_cdeliveryvatperc\":\"10.000\",\"jd_commission\":\"[]\"},\"old\":{\"jd_jobcustomoizedkeyvalue\":\"{\\\"62\\\":[\\\"\\\",\\\"MUFASA\\\"],\\\"83\\\":\\\"1\\\",\\\"65\\\":\\\"\\\",\\\"66\\\":\\\"\\\",\\\"67\\\":\\\"\\\",\\\"68\\\":\\\"\\\",\\\"69\\\":\\\"\\\",\\\"70\\\":\\\"\\\",\\\"71\\\":\\\"\\\",\\\"72\\\":36,\\\"73\\\":\\\"\\\",\\\"568\\\":\\\"\\\",\\\"617\\\":1,\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"37\\\":1,\\\"285\\\":12,\\\"33\\\":\\\"25\\\",\\\"45\\\":\\\"Mk'\\\",\\\"44\\\":\\\"Jk\\\",\\\"46\\\":\\\"Mk'\\\",\\\"39\\\":25,\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"54\\\":36,\\\"53\\\":\\\"\\\",\\\"286\\\":\\\"\\\",\\\"47\\\":\\\"\\\",\\\"558\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"41\\\":\\\"1\\\",\\\"551\\\":\\\"1\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_endcustomeroverridevalue\":null,\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerfittingcost\":null,\"jd_updatedby\":1,\"jd_updatedat\":\"2025-05-20T12:03:53.000000Z\",\"jd_deliveryvatperc\":\"0.000\",\"jd_cdeliveryvatperc\":\"0.000\",\"jd_commission\":\"\\\"\\\"\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60106", "cl_createdat": "1750662210.000000", "cl_updatedat": null }, { "cl_id": 60107, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 5825, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5825, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"Aquarius Blinds\",\"\":1,\"Account Type\":\"Domestic\",\"Created By\":\"admin\",\"Last Name\":\"Quote 38\",\"Address1\":\"Quote 38\",\"Town \\\/ City\":\"Quote 38\",\"Country\":\"India\",\"Salutation\":\"Dr\",\"Assigned to\":1,\"Additional Contacts\":\"4261\",\"Job Ref No\":\"AQ5822\",\"Job Status\":\"Lead\",\"Order Status\":\"Enquiry\",\"Net Price\":\"70.00\",\"VAT Price\":\"7.00\",\"VAT\":\"Enabled\",\"DeliveryCost\":\"70.00\",\"Delivery Cost\":\"All Options\",\"Gross Price Amount\":\"77.00\",\"Gross Profit\":\"70.00\",\"Amount Outstanding\":\"77.00\",\"jd_isonlineorder\":1,\"jd_quickquote\":38,\"Delivery Vat Percentage\":\"10.000\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":5825,\"jd_customerid\":4075,\"jd_contactid\":4261,\"jd_additionalcontacts\":\"4261\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"AQ5822\\\",\\\"35\\\":\\\"QUOT0037\\\",\\\"36\\\":1,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":\\\"\\\",\\\"40\\\":13,\\\"41\\\":1,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"\\\",\\\"46\\\":\\\"Quote 38\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"Quote 38\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"Quote 38\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":36,\\\"285\\\":12,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":1,\\\"558\\\":\\\"\\\",\\\"559\\\":1,\\\"610\\\":\\\"\\\",\\\"611\\\":\\\"\\\",\\\"612\\\":1,\\\"618\\\":\\\"\\\",\\\"countryText\\\":\\\"India\\\",\\\"adminUser\\\":1}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-06-23\",\"jd_orderdate\":null,\"jd_duedate\":null,\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":null,\"jd_jobref\":\"AQ5822\",\"jd_jobstatus\":1,\"jd_contactaddid\":0,\"jd_orderstatus\":13,\"jd_accref\":\"QUOT0037\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"0.00\",\"jd_netprice\":\"70.00\",\"jd_vat\":\"7.00\",\"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\":\"77.00\",\"jd_grossprofit\":\"70.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"0.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"77.00\",\"jd_totpaid\":\"0.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":null,\"jd_deliverycostid\":0,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_accountingsoftware_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":0,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":0,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":0,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":0,\"jd_organizationid\":0,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":1,\"jd_createdat\":\"2025-06-23T07:03:46.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-06-23T07:03:53.000000Z\",\"salesorderid\":null,\"jd_deviceplatform\":0,\"jd_fromjobref\":\"\",\"jd_fromdbname\":null,\"jd_importorder\":0,\"jd_quickquote\":38,\"jd_myob_flag\":0,\"jd_myobinvoiceid\":\"\",\"jd_qboflag\":0,\"jd_qboinvoiceid\":0,\"jd_qbodisplayname\":\"\",\"jd_deliveryvatperc\":\"10.000\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"10.000\",\"jd_commission\":\"[]\",\"jd_commissionprice\":\"0.00\",\"jd_commissionsetting\":0,\"jd_commissionaddedvalue\":\"0.00\",\"jd_onlineprefixseq\":null,\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":0,\"jd_rework_count\":0}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60107", "cl_createdat": "1750662233.000000", "cl_updatedat": null }, { "cl_id": 60108, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105331, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 5825, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"Job Created\",\"Platform\":\"All Options\",\"Description\":\"New job has been created in job\",\"Created By\":\"admin\",\"Date\":\"2025-06-23\",\"Time\":\"07:03:46\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105331,\"nl_ordertempid\":0,\"nl_orderid\":5825,\"nl_notescategory\":1,\"nl_type\":17,\"nl_platform\":1,\"nl_desc\":\"New job has been created in job\",\"nl_manualNotes\":null,\"nl_createdby\":\"1\",\"nl_endddate\":\"2025-06-23\",\"nl_starttime\":\"07:03:46\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":1,\"created_at\":\"2025-06-23T07:03:46.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-23T07:03:53.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60108", "cl_createdat": "1750662233.000000", "cl_updatedat": null }, { "cl_id": 60109, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in AQ5822", "cl_event": "created", "cl_subjectid": 5860, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 5825, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":5860,\"jmq_jobid\":5825,\"Quotation Name\":\"Q1\",\"jmq_isdefault\":0,\"Quotation\":\"Accepted\",\"jmq_isdeclined\":0,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"Production Due Date\":\"0000-00-00\",\"List Price\":\"0.00\",\"Net Price\":\"70.00\",\"VAT Price\":\"7.00\",\"VAT\":1,\"jmq_deliverycost\":\"70.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"77.00\",\"Gross Profit\":\"70.00\",\"Total CostPrice\":\"0.00\",\"Amount Outstanding\":\"77.00\",\"Total Paid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_deliverycostid\":0,\"Total Cost Price\":0,\"jmq_isonlineorder\":0,\"Is Online Order Submitted\":0,\"End Customer Override Type\":0,\"End Customer Override Net Price\":\"0.00\",\"End Customer Override Vat Price\":\"0.00\",\"End Customer Override Gross Price\":\"0.00\",\"End Customer Delivery Cost Include Vat\":0,\"End Customer Fitting Cost Include Vat\":0,\"Online Delivery Addreddtype\":0,\"Commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"Delivery Vat Percentage\":\"10.000\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":5860,\"jmq_jobid\":5825,\"jmq_quotationname\":\"Q1\",\"jmq_isdefault\":0,\"jmq_isaccepted\":1,\"jmq_isdeclined\":0,\"jmq_esignflag\":null,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"jmq_duedate\":\"0000-00-00\",\"jmq_sceduleddate\":\"0000-00-00\",\"jmq_listprice\":\"0.00\",\"jmq_netprice\":\"70.00\",\"jmq_vat\":\"7.00\",\"jmq_isvaton\":1,\"jmq_deliverycost\":\"70.00\",\"jmq_deliverycosttypeid\":1,\"jmq_overridetypeid\":1,\"jmq_orderformprice\":\"0.00\",\"jmq_editpricebyid\":null,\"jmq_isroundon\":0,\"jmq_grossprice\":\"77.00\",\"jmq_grossprofit\":\"70.00\",\"jmq_costprice\":\"0.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"77.00\",\"jmq_totpaid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_userdefinedarray\":null,\"jmq_deliverycostid\":0,\"jmq_iscostpriceon\":0,\"jmq_custompricefields\":\"\",\"jmq_isonlineorder\":0,\"jmq_isonlineordersubmitted\":0,\"jmq_endcustomervatprice\":null,\"jmq_endcustomeroverridetype\":0,\"jmq_endcustomeroverridevalue\":null,\"jmq_endcustomeroverridenetprice\":\"0.00\",\"jmq_endcustomeroverridevatprice\":\"0.00\",\"jmq_endcustomeroverridegrossprice\":\"0.00\",\"jmq_endcustomerdeliverycost\":null,\"jmq_endcustomerdeliverycostinclvat\":0,\"jmq_endcustomerfittingcost\":null,\"jmq_endcustomerfittingcostinclvat\":0,\"jmq_onlinedeliveryaddreddtype\":0,\"jmq_onlinedeliveryaddreddid\":null,\"jmq_commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"jmq_deliveryvatperc\":\"10.000\",\"jmq_cdeliveryvatperc\":\"10.000\",\"jmq_createdby\":1,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-06-23T07:03:46.000000Z\",\"jmq_updatedat\":null,\"jmq_grossprofit_percentage\":\"0.00\",\"jmq_ready\":0}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60109", "cl_createdat": "1750662233.000000", "cl_updatedat": null }, { "cl_id": 60110, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the field Multi Quote Id", "cl_event": "modified", "cl_subjectid": 5825, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5825, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":5860}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":5860},\"old\":{\"jd_jobmultiquoteid\":null}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60110", "cl_createdat": "1750662233.000000", "cl_updatedat": null }, { "cl_id": 60111, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment", "cl_message": "new item has been created in Appointment", "cl_event": "created", "cl_subjectid": 10086, "cl_subjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_parentid": 5636, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 22, "cl_changedfrom": "null", "cl_changedto": "{\"Repeat On\":\"yearly on June 23\",\"app_summary\":\"AQ5636-Mk' Mk'-Measurer\",\"Appointment Type\":\"Measurer\",\"Staff\":\"Andrew\",\"Job Ref No\":\"AQ5636\",\"Start Date & Time\":\"2025-06-23 10:30:00\",\"End Date & Time\":\"2025-06-23 11:30:00\",\"Appointment Status\":\"Waiting\",\"app_jobtimehour\":\"1\",\"app_products\":\"[]\"}", "cl_customproperties": "{\"attributes\":{\"app_eventid\":10086,\"app_description\":\"\",\"app_summary\":\"AQ5636-Mk' Mk'-Measurer\",\"app_private\":0,\"app_appointmentType\":62,\"app_userId\":2,\"app_orderId\":5636,\"app_customerId\":0,\"app_isAllDay\":0,\"app_sdate\":\"2025-06-23\",\"app_edate\":\"2025-06-23\",\"app_stime\":\"10:30:00\",\"app_etime\":\"11:30:00\",\"app_sdatetime\":\"2025-06-23 10:30:00\",\"app_edatetime\":\"2025-06-23 11:30:00\",\"app_timezone\":\"Asia\\\/Calcutta\",\"app_latitude\":null,\"app_longitude\":null,\"app_parentappid\":null,\"app_recurrencerule\":null,\"app_userdefinedValue\":\"{\\\"5\\\":\\\"\\\"}\",\"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\":22,\"app_updatedBy\":null,\"app_createdAt\":\"2025-06-23T07:03:59.000000Z\",\"app_updatedAt\":\"2025-06-23T07:03:59.000000Z\",\"app_runid\":null,\"app_deliveryaddressid\":0,\"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": "60111", "cl_createdat": "1750662239.000000", "cl_updatedat": null }, { "cl_id": 60112, "cl_logname": "default", "cl_type": null, "cl_modulename": "Further Info", "cl_message": "new item has been created in Further Info", "cl_event": "created", "cl_subjectid": 18731, "cl_subjecttype": "App\\Models\\Settings\\bm_terms", "cl_parentid": 5636, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 22, "cl_changedfrom": "null", "cl_changedto": "{\"jobmultiquoteid\":5661,\"termsparentid\":1,\"Is Report Show\":\"Checked\",\"termsCategory\":2,\"Terms Name\":\"Standard\",\"Description\":\"
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>\",\"termsdefault\":0,\"termsnameeditable\":0,\"seq\":1,\"terms_created_at\":\"2024-08-02T00:00:00.000000Z\"}", "cl_customproperties": "{\"attributes\":{\"termsid\":18731,\"orderid\":5636,\"jobmultiquoteid\":5661,\"termsparentid\":1,\"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>\",\"termsdefault\":0,\"termsnameeditable\":0,\"status\":0,\"seq\":1,\"created_by\":null,\"created_at\":\"2025-06-23T07:03:59.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-23T07:03:59.000000Z\",\"terms_created_at\":\"2024-08-02T00:00:00.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60112", "cl_createdat": "1750662239.000000", "cl_updatedat": null }, { "cl_id": 60113, "cl_logname": "default", "cl_type": null, "cl_modulename": "Further Info", "cl_message": "new item has been created in Further Info", "cl_event": "created", "cl_subjectid": 18732, "cl_subjecttype": "App\\Models\\Settings\\bm_terms", "cl_parentid": 5636, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 22, "cl_changedfrom": "null", "cl_changedto": "{\"jobmultiquoteid\":5661,\"termsparentid\":4014,\"Is Report Show\":\"Checked\",\"termsCategory\":2,\"Terms Name\":\"Agreed Terms\",\"Description\":\"
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>\",\"termsdefault\":0,\"seq\":2,\"terms_created_at\":\"2024-02-16T00:00:00.000000Z\"}", "cl_customproperties": "{\"attributes\":{\"termsid\":18732,\"orderid\":5636,\"jobmultiquoteid\":5661,\"termsparentid\":4014,\"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>\",\"termsdefault\":0,\"termsnameeditable\":null,\"status\":0,\"seq\":2,\"created_by\":1,\"created_at\":\"2025-06-23T07:03:59.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-23T07:03:59.000000Z\",\"terms_created_at\":\"2024-02-16T00:00:00.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60113", "cl_createdat": "1750662239.000000", "cl_updatedat": null }, { "cl_id": 60114, "cl_logname": "default", "cl_type": null, "cl_modulename": "Further Info", "cl_message": "new item has been created in Further Info", "cl_event": "created", "cl_subjectid": 18733, "cl_subjecttype": "App\\Models\\Settings\\bm_terms", "cl_parentid": 5636, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 22, "cl_changedfrom": "null", "cl_changedto": "{\"jobmultiquoteid\":5661,\"termsparentid\":4015,\"Is Report Show\":\"Checked\",\"termsCategory\":2,\"Terms Name\":\"Contract Terms\",\"Description\":\"
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>\",\"termsdefault\":0,\"seq\":3,\"terms_created_at\":\"2024-02-16T00:00:00.000000Z\"}", "cl_customproperties": "{\"attributes\":{\"termsid\":18733,\"orderid\":5636,\"jobmultiquoteid\":5661,\"termsparentid\":4015,\"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>\",\"termsdefault\":0,\"termsnameeditable\":null,\"status\":0,\"seq\":3,\"created_by\":1,\"created_at\":\"2025-06-23T07:03:59.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-23T07:03:59.000000Z\",\"terms_created_at\":\"2024-02-16T00:00:00.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60114", "cl_createdat": "1750662239.000000", "cl_updatedat": null }, { "cl_id": 60115, "cl_logname": "default", "cl_type": null, "cl_modulename": "Further Info", "cl_message": "new item has been created in Further Info", "cl_event": "created", "cl_subjectid": 18734, "cl_subjecttype": "App\\Models\\Settings\\bm_terms", "cl_parentid": 5636, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 22, "cl_changedfrom": "null", "cl_changedto": "{\"jobmultiquoteid\":5661,\"termsparentid\":4016,\"Is Report Show\":\"Checked\",\"termsCategory\":2,\"Terms Name\":\"Special Terms\",\"Description\":\"
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>\",\"termsdefault\":0,\"seq\":4,\"terms_created_at\":\"2024-02-16T00:00:00.000000Z\"}", "cl_customproperties": "{\"attributes\":{\"termsid\":18734,\"orderid\":5636,\"jobmultiquoteid\":5661,\"termsparentid\":4016,\"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>\",\"termsdefault\":0,\"termsnameeditable\":null,\"status\":0,\"seq\":4,\"created_by\":1,\"created_at\":\"2025-06-23T07:03:59.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-23T07:03:59.000000Z\",\"terms_created_at\":\"2024-02-16T00:00:00.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60115", "cl_createdat": "1750662239.000000", "cl_updatedat": null }, { "cl_id": 60116, "cl_logname": "default", "cl_type": null, "cl_modulename": "Further Info", "cl_message": "new item has been created in Further Info", "cl_event": "created", "cl_subjectid": 18735, "cl_subjecttype": "App\\Models\\Settings\\bm_terms", "cl_parentid": 5636, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 22, "cl_changedfrom": "null", "cl_changedto": "{\"jobmultiquoteid\":5661,\"termsparentid\":8033,\"Is Report Show\":\"Checked\",\"termsCategory\":3,\"Terms Name\":\"Standard\",\"Description\":\"
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>\",\"termsdefault\":0,\"termsnameeditable\":0,\"seq\":1,\"terms_created_at\":\"2024-08-02T00:00:00.000000Z\"}", "cl_customproperties": "{\"attributes\":{\"termsid\":18735,\"orderid\":5636,\"jobmultiquoteid\":5661,\"termsparentid\":8033,\"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>\",\"termsdefault\":0,\"termsnameeditable\":0,\"status\":0,\"seq\":1,\"created_by\":null,\"created_at\":\"2025-06-23T07:03:59.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-23T07:03:59.000000Z\",\"terms_created_at\":\"2024-08-02T00:00:00.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60116", "cl_createdat": "1750662239.000000", "cl_updatedat": null }, { "cl_id": 60117, "cl_logname": "default", "cl_type": null, "cl_modulename": "Further Info", "cl_message": "new item has been created in Further Info", "cl_event": "created", "cl_subjectid": 18736, "cl_subjecttype": "App\\Models\\Settings\\bm_terms", "cl_parentid": 5636, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 22, "cl_changedfrom": "null", "cl_changedto": "{\"jobmultiquoteid\":5661,\"termsparentid\":8034,\"Is Report Show\":\"Checked\",\"termsCategory\":3,\"Terms Name\":\"Agreed Terms\",\"Description\":\"
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>\",\"termsdefault\":0,\"seq\":2,\"terms_created_at\":\"2024-08-02T00:00:00.000000Z\"}", "cl_customproperties": "{\"attributes\":{\"termsid\":18736,\"orderid\":5636,\"jobmultiquoteid\":5661,\"termsparentid\":8034,\"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>\",\"termsdefault\":0,\"termsnameeditable\":null,\"status\":0,\"seq\":2,\"created_by\":1,\"created_at\":\"2025-06-23T07:03:59.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-23T07:03:59.000000Z\",\"terms_created_at\":\"2024-08-02T00:00:00.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60117", "cl_createdat": "1750662239.000000", "cl_updatedat": null }, { "cl_id": 60118, "cl_logname": "default", "cl_type": null, "cl_modulename": "Further Info", "cl_message": "new item has been created in Further Info", "cl_event": "created", "cl_subjectid": 18737, "cl_subjecttype": "App\\Models\\Settings\\bm_terms", "cl_parentid": 5636, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 22, "cl_changedfrom": "null", "cl_changedto": "{\"jobmultiquoteid\":5661,\"termsparentid\":8035,\"Is Report Show\":\"Checked\",\"termsCategory\":3,\"Terms Name\":\"Contract Terms\",\"Description\":\"
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>\",\"termsdefault\":0,\"seq\":3,\"terms_created_at\":\"2024-08-02T00:00:00.000000Z\"}", "cl_customproperties": "{\"attributes\":{\"termsid\":18737,\"orderid\":5636,\"jobmultiquoteid\":5661,\"termsparentid\":8035,\"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>\",\"termsdefault\":0,\"termsnameeditable\":null,\"status\":0,\"seq\":3,\"created_by\":1,\"created_at\":\"2025-06-23T07:03:59.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-23T07:03:59.000000Z\",\"terms_created_at\":\"2024-08-02T00:00:00.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60118", "cl_createdat": "1750662239.000000", "cl_updatedat": null }, { "cl_id": 60119, "cl_logname": "default", "cl_type": null, "cl_modulename": "Further Info", "cl_message": "new item has been created in Further Info", "cl_event": "created", "cl_subjectid": 18738, "cl_subjecttype": "App\\Models\\Settings\\bm_terms", "cl_parentid": 5636, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 22, "cl_changedfrom": "null", "cl_changedto": "{\"jobmultiquoteid\":5661,\"termsparentid\":8036,\"Is Report Show\":\"Checked\",\"termsCategory\":3,\"Terms Name\":\"Special Terms\",\"Description\":\"
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>\",\"termsdefault\":0,\"seq\":4,\"terms_created_at\":\"2024-08-02T00:00:00.000000Z\"}", "cl_customproperties": "{\"attributes\":{\"termsid\":18738,\"orderid\":5636,\"jobmultiquoteid\":5661,\"termsparentid\":8036,\"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>\",\"termsdefault\":0,\"termsnameeditable\":null,\"status\":0,\"seq\":4,\"created_by\":1,\"created_at\":\"2025-06-23T07:03:59.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-23T07:03:59.000000Z\",\"terms_created_at\":\"2024-08-02T00:00:00.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60119", "cl_createdat": "1750662239.000000", "cl_updatedat": null }, { "cl_id": 60120, "cl_logname": "default", "cl_type": null, "cl_modulename": "Further Info", "cl_message": "new item has been created in Further Info", "cl_event": "created", "cl_subjectid": 18739, "cl_subjecttype": "App\\Models\\Settings\\bm_terms", "cl_parentid": 5636, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 22, "cl_changedfrom": "null", "cl_changedto": "{\"jobmultiquoteid\":5661,\"termsparentid\":8041,\"Is Report Show\":\"Checked\",\"termsCategory\":4,\"Terms Name\":\"Standard\",\"Description\":\"
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>\",\"termsdefault\":0,\"termsnameeditable\":0,\"seq\":1,\"terms_created_at\":\"2024-08-02T00:00:00.000000Z\"}", "cl_customproperties": "{\"attributes\":{\"termsid\":18739,\"orderid\":5636,\"jobmultiquoteid\":5661,\"termsparentid\":8041,\"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>\",\"termsdefault\":0,\"termsnameeditable\":0,\"status\":0,\"seq\":1,\"created_by\":null,\"created_at\":\"2025-06-23T07:03:59.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-23T07:03:59.000000Z\",\"terms_created_at\":\"2024-08-02T00:00:00.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60120", "cl_createdat": "1750662239.000000", "cl_updatedat": null }, { "cl_id": 60121, "cl_logname": "default", "cl_type": null, "cl_modulename": "Further Info", "cl_message": "new item has been created in Further Info", "cl_event": "created", "cl_subjectid": 18740, "cl_subjecttype": "App\\Models\\Settings\\bm_terms", "cl_parentid": 5636, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 22, "cl_changedfrom": "null", "cl_changedto": "{\"jobmultiquoteid\":5661,\"termsparentid\":8042,\"Is Report Show\":\"Checked\",\"termsCategory\":4,\"Terms Name\":\"Agreed Terms\",\"Description\":\"
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>\",\"termsdefault\":0,\"seq\":2,\"terms_created_at\":\"2024-08-02T00:00:00.000000Z\"}", "cl_customproperties": "{\"attributes\":{\"termsid\":18740,\"orderid\":5636,\"jobmultiquoteid\":5661,\"termsparentid\":8042,\"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>\",\"termsdefault\":0,\"termsnameeditable\":null,\"status\":0,\"seq\":2,\"created_by\":1,\"created_at\":\"2025-06-23T07:03:59.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-23T07:03:59.000000Z\",\"terms_created_at\":\"2024-08-02T00:00:00.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60121", "cl_createdat": "1750662239.000000", "cl_updatedat": null }, { "cl_id": 60122, "cl_logname": "default", "cl_type": null, "cl_modulename": "Further Info", "cl_message": "new item has been created in Further Info", "cl_event": "created", "cl_subjectid": 18741, "cl_subjecttype": "App\\Models\\Settings\\bm_terms", "cl_parentid": 5636, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 22, "cl_changedfrom": "null", "cl_changedto": "{\"jobmultiquoteid\":5661,\"termsparentid\":8043,\"Is Report Show\":\"Checked\",\"termsCategory\":4,\"Terms Name\":\"Contract Terms\",\"Description\":\"
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>\",\"termsdefault\":0,\"seq\":3,\"terms_created_at\":\"2024-08-02T00:00:00.000000Z\"}", "cl_customproperties": "{\"attributes\":{\"termsid\":18741,\"orderid\":5636,\"jobmultiquoteid\":5661,\"termsparentid\":8043,\"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>\",\"termsdefault\":0,\"termsnameeditable\":null,\"status\":0,\"seq\":3,\"created_by\":1,\"created_at\":\"2025-06-23T07:03:59.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-23T07:03:59.000000Z\",\"terms_created_at\":\"2024-08-02T00:00:00.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60122", "cl_createdat": "1750662239.000000", "cl_updatedat": null }, { "cl_id": 60123, "cl_logname": "default", "cl_type": null, "cl_modulename": "Further Info", "cl_message": "new item has been created in Further Info", "cl_event": "created", "cl_subjectid": 18742, "cl_subjecttype": "App\\Models\\Settings\\bm_terms", "cl_parentid": 5636, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 22, "cl_changedfrom": "null", "cl_changedto": "{\"jobmultiquoteid\":5661,\"termsparentid\":8044,\"Is Report Show\":\"Checked\",\"termsCategory\":4,\"Terms Name\":\"Special Terms\",\"Description\":\"
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>\",\"termsdefault\":0,\"seq\":4,\"terms_created_at\":\"2024-08-02T00:00:00.000000Z\"}", "cl_customproperties": "{\"attributes\":{\"termsid\":18742,\"orderid\":5636,\"jobmultiquoteid\":5661,\"termsparentid\":8044,\"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>\",\"termsdefault\":0,\"termsnameeditable\":null,\"status\":0,\"seq\":4,\"created_by\":1,\"created_at\":\"2025-06-23T07:03:59.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-23T07:03:59.000000Z\",\"terms_created_at\":\"2024-08-02T00:00:00.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60123", "cl_createdat": "1750662239.000000", "cl_updatedat": null }, { "cl_id": 60124, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the field Number", "cl_event": "modified", "cl_subjectid": 5728, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5728, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 22, "cl_changedfrom": "{\"Gross Profit\":\"43.00\",\"Gross Profit Percentage\":\"46.51\"}", "cl_changedto": "{\"Number\":\"87\"}", "cl_customproperties": "{\"attributes\":{\"jd_jobcustomoizedkeyvalue\":\"{\\\"33\\\":25,\\\"37\\\":1,\\\"39\\\":22,\\\"41\\\":1,\\\"44\\\":\\\"John Smith Pvt Ltd\\\",\\\"45\\\":\\\"Johny\\\",\\\"46\\\":\\\"Leo\\\",\\\"47\\\":\\\"595955848\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"Cit Nagar\\\",\\\"50\\\":\\\"Nandanam\\\",\\\"51\\\":\\\"ChennaiChenain\\\",\\\"52\\\":\\\"India\\\",\\\"53\\\":\\\"635301\\\",\\\"54\\\":36,\\\"285\\\":12,\\\"286\\\":\\\"264945946\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":1,\\\"558\\\":1,\\\"559\\\":1,\\\"610\\\":\\\"\\\",\\\"611\\\":\\\"\\\",\\\"612\\\":1,\\\"618\\\":\\\"87\\\"}\",\"jd_orderdate\":\"0000-00-00\",\"jd_duedate\":\"0000-00-00\",\"jd_sceduleddate\":\"0000-00-00\",\"jd_completeddate\":\"0000-00-00\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_endcustomeroverridevalue\":\"\",\"jd_endcustomerdeliverycost\":\"\",\"jd_endcustomerfittingcost\":\"\",\"jd_updatedby\":22,\"jd_updatedat\":\"2025-06-23T07:08:07.000000Z\"},\"old\":{\"jd_jobcustomoizedkeyvalue\":\"{\\\"33\\\":25,\\\"37\\\":1,\\\"39\\\":22,\\\"41\\\":1,\\\"44\\\":\\\"John Smith Pvt Ltd\\\",\\\"45\\\":\\\"Johny\\\",\\\"46\\\":\\\"Leo\\\",\\\"47\\\":\\\"595955848\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"Cit Nagar\\\",\\\"50\\\":\\\"Nandanam\\\",\\\"51\\\":\\\"ChennaiChenain\\\",\\\"52\\\":\\\"India\\\",\\\"53\\\":\\\"635301\\\",\\\"54\\\":36,\\\"285\\\":12,\\\"286\\\":\\\"264945946\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":1,\\\"558\\\":1,\\\"559\\\":1,\\\"610\\\":\\\"\\\",\\\"611\\\":\\\"\\\",\\\"612\\\":1}\",\"jd_orderdate\":null,\"jd_duedate\":null,\"jd_sceduleddate\":null,\"jd_completeddate\":\"1970-01-01\",\"jd_grossprofit\":\"43.00\",\"jd_grossprofit_percentage\":\"46.51\",\"jd_endcustomeroverridevalue\":null,\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerfittingcost\":null,\"jd_updatedby\":1,\"jd_updatedat\":\"2025-06-04T14:14:07.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60124", "cl_createdat": "1750662487.000000", "cl_updatedat": null }, { "cl_id": 60125, "cl_logname": "default", "cl_type": null, "cl_modulename": "Alternative Address", "cl_message": "Alternative Address has been updated the fields Appointments Add,Invoice Add,Invoice Delivery Add,Purchase Add,Worksheet Add", "cl_event": "modified", "cl_subjectid": 5677, "cl_subjecttype": "App\\Models\\Job\\bm_deliveryaddresssetting", "cl_parentid": 5825, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 22, "cl_changedfrom": "null", "cl_changedto": "{\"Appointments Add\":\"Alternative Delivery Address\",\"Invoice Add\":\"Alternative Delivery Address\",\"Invoice Delivery Add\":\"Alternative Delivery Address\",\"Purchase Add\":\"Default(Same as billing add)\",\"Worksheet Add\":\"Default(Same as billing add)\"}", "cl_customproperties": "{\"attributes\":{\"das_id\":5677,\"das_jobid\":5825,\"das_appointmentaddress\":4261,\"das_invoiceaddress\":4261,\"das_invoicedeliveryaddress\":4261,\"das_purchaseaddress\":0,\"das_worksheetaddress\":0,\"das_createdby\":22,\"das_createdat\":\"2025-06-23T07:09:39.000000Z\",\"das_updatedby\":null,\"das_updatedat\":\"2025-06-23T07:09:39.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60125", "cl_createdat": "1750662579.000000", "cl_updatedat": null }, { "cl_id": 60126, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the fields First Name,Number,Gross Profit Percentage", "cl_event": "modified", "cl_subjectid": 5825, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5825, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 22, "cl_changedfrom": "{\"\":1}", "cl_changedto": "{\"First Name\":\"The\",\"Number\":\"5456\",\"Gross Profit Percentage\":\"100.00\"}", "cl_customproperties": "{\"attributes\":{\"jd_jobcustomoizedkeyvalue\":\"{\\\"33\\\":25,\\\"37\\\":1,\\\"39\\\":\\\"\\\",\\\"41\\\":1,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"The\\\",\\\"46\\\":\\\"Quote 38\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"Quote 38\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"Quote 38\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":36,\\\"285\\\":12,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":1,\\\"558\\\":\\\"\\\",\\\"559\\\":1,\\\"610\\\":\\\"\\\",\\\"611\\\":\\\"\\\",\\\"612\\\":1,\\\"618\\\":\\\"5456\\\"}\",\"jd_deletedcustokeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"34\\\":\\\"AQ5822\\\",\\\"35\\\":\\\"QUOT0037\\\",\\\"36\\\":1,\\\"38\\\":\\\"\\\",\\\"40\\\":13,\\\"countryText\\\":\\\"India\\\",\\\"adminUser\\\":1}\",\"jd_orderdate\":\"0000-00-00\",\"jd_duedate\":\"0000-00-00\",\"jd_sceduleddate\":\"0000-00-00\",\"jd_completeddate\":\"0000-00-00\",\"jd_listprice\":\"70.00\",\"jd_editpricebyid\":0,\"jd_grossprofit_percentage\":\"100.00\",\"jd_userdefinedarray\":\"\\\"\\\"\",\"jd_endcustomeroverridevalue\":\"\",\"jd_endcustomerdeliverycost\":\"\",\"jd_endcustomerfittingcost\":\"\",\"jd_updatedby\":22,\"jd_updatedat\":\"2025-06-23T07:09:39.000000Z\"},\"old\":{\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"AQ5822\\\",\\\"35\\\":\\\"QUOT0037\\\",\\\"36\\\":1,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":\\\"\\\",\\\"40\\\":13,\\\"41\\\":1,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"\\\",\\\"46\\\":\\\"Quote 38\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"Quote 38\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"Quote 38\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":36,\\\"285\\\":12,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":1,\\\"558\\\":\\\"\\\",\\\"559\\\":1,\\\"610\\\":\\\"\\\",\\\"611\\\":\\\"\\\",\\\"612\\\":1,\\\"618\\\":\\\"\\\",\\\"countryText\\\":\\\"India\\\",\\\"adminUser\\\":1}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_orderdate\":null,\"jd_duedate\":null,\"jd_sceduleddate\":null,\"jd_completeddate\":null,\"jd_listprice\":\"0.00\",\"jd_editpricebyid\":null,\"jd_grossprofit_percentage\":\"0.00\",\"jd_userdefinedarray\":null,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerfittingcost\":null,\"jd_updatedby\":1,\"jd_updatedat\":\"2025-06-23T07:03:53.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60126", "cl_createdat": "1750662579.000000", "cl_updatedat": null }, { "cl_id": 60127, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the fields Gross Profit,Gross Profit Percentage", "cl_event": "modified", "cl_subjectid": 5825, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5825, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 22, "cl_changedfrom": "{\"Gross Profit\":\"70.00\",\"Gross Profit Percentage\":\"100.00\"}", "cl_changedto": "{\"Gross Profit\":\"0.00\",\"Gross Profit Percentage\":\"0.00\"}", "cl_customproperties": "{\"attributes\":{\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_updatedat\":\"2025-06-23T07:10:18.000000Z\"},\"old\":{\"jd_grossprofit\":\"70.00\",\"jd_grossprofit_percentage\":\"100.00\",\"jd_updatedat\":\"2025-06-23T07:10:16.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60127", "cl_createdat": "1750662618.000000", "cl_updatedat": null } ], "updated": [], "deleted": [] }, "bm_productInfo": { "created": [], "updated": [], "deleted": [] }, "bm_fields": { "created": [], "updated": [], "deleted": [] }, "bm_fieldOptionLink": { "created": [], "updated": [], "deleted": [] }, "bm_option": { "created": [], "updated": [], "deleted": [] }, "bm_optionproduct": { "created": [], "updated": [], "deleted": [] }, "bm_linkedfieldswithproduct": { "created": [], "updated": [], "deleted": [] }, "bm_productionstatus": { "created": [], "updated": [], "deleted": [] }, "bm_productpricemap": { "created": [], "updated": [], "deleted": [] }, "bm_productrecipe": { "created": [], "updated": [], "deleted": [] }, "bm_productrecipemap": { "created": [], "updated": [], "deleted": [] }, "bm_supproductcode": { "created": [], "updated": [], "deleted": [] }, "bm_rulesetup": { "created": [], "updated": [], "deleted": [] }, "bm_formulas": { "created": [], "updated": [], "deleted": [] }, "bm_customercommission": { "created": [], "updated": [], "deleted": [] }, "bm_productgroupdetails": { "created": [], "updated": [], "deleted": [] }, "bm_productgroupmaterialmap": { "created": [], "updated": [], "deleted": [] }, "bm_productpricedetails": { "created": [], "updated": [], "deleted": [] }, "bm_fabriccolourmap": { "created": [], "updated": [], "deleted": [] }, "bm_fabricdetails": { "created": [], "updated": [], "deleted": [] }, "bm_colordetails": { "created": [], "updated": [], "deleted": [] }, "bm_optiondiscount": { "created": [], "updated": [], "deleted": [] }, "bm_optionpricebook": { "created": [], "updated": [], "deleted": [] }, "bm_allowances": { "created": [], "updated": [], "deleted": [] }, "bm_xyoptionpricedata": { "created": [], "updated": [], "deleted": [] }, "bm_delivery_cost_setup": { "created": [], "updated": [], "deleted": [] }, "bm_organizationdetails": { "created": [], "updated": [], "deleted": [] }, "bm_applicationSetup": { "created": [], "updated": [], "deleted": [] }, "bm_calendarsetup": { "created": [], "updated": [], "deleted": [] }, "bm_appointmenttype": { "created": [], "updated": [], "deleted": [] }, "bm_userWorkDay": { "created": [], "updated": [], "deleted": [] }, "bm_users": { "created": [], "updated": [], "deleted": [] }, "custom_fields": { "created": [], "updated": [], "deleted": [] }, "customfieldvalues": { "created": [], "updated": [], "deleted": [] } }, "synctodelete": [], "timestamp": 1750662853 }