{ "status": "success", "upcomingorder_list": { "bm_customertemplatedata": { "created": [], "updated": [ { "ctd_id": 2896, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\": 2, \"64\": 10, \"598\": 25, \"62\": \"KROH0001\"}", "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": "2896", "ctd_createdat": 1743173562, "ctd_updatedat": 1743401228, "ctd_createdby": 0, "ctd_updatedby": null }, { "ctd_id": 2897, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\": 1, \"64\": 10, \"598\": 25, \"62\": \"QUOT0001\"}", "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": "2897", "ctd_createdat": 1743173595, "ctd_updatedat": 1743401228, "ctd_createdby": 0, "ctd_updatedby": null }, { "ctd_id": 2898, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\": 1, \"64\": 10, \"598\": 25, \"62\": \"QUOT0002\"}", "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": "2898", "ctd_createdat": 1743173809, "ctd_updatedat": 1743401228, "ctd_createdby": 0, "ctd_updatedby": null } ], "deleted": [] }, "bm_customercontactinfo": { "created": [], "updated": [ { "cci_id": 4170, "cci_customerid": 2896, "cci_templateid": 3, "roleid": 0, "cci_customizedarray": "{\"75\":1,\"76\":\"4578999\",\"77\":\"Rohit \",\"79\":\"K\",\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"90\":19}", "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": 2, "cci_mobcustomertempid": 31743173562, "id": "4170", "cci_createdat": 1743173562, "cci_updatedat": 1743401228, "cci_createdby": 0, "cci_updatedby": null }, { "cci_id": 4171, "cci_customerid": 2897, "cci_templateid": 3, "roleid": 0, "cci_customizedarray": "{\"75\":1,\"79\":\"Quote 1\",\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"Quote 1\",\"90\":19,\"91\":\"Quote 1\"}", "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": 2, "cci_mobcustomertempid": 31743173595, "id": "4171", "cci_createdat": 1743173595, "cci_updatedat": 1743401229, "cci_createdby": 0, "cci_updatedby": null }, { "cci_id": 4172, "cci_customerid": 2898, "cci_templateid": 3, "roleid": 0, "cci_customizedarray": "{\"75\":1,\"79\":\"Quote 2\",\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"Quote 2\",\"90\":19,\"91\":\"Quote 2\"}", "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": 2, "cci_mobcustomertempid": 31743173809, "id": "4172", "cci_createdat": 1743173809, "cci_updatedat": 1743401231, "cci_createdby": 0, "cci_updatedby": null } ], "deleted": [] }, "bm_appointment": { "created": [ { "app_eventid": 7846, "app_description": "PLEASE CALL ON ROUTE - TRACK ", "app_summary": "ON27910-Steve McLachlan-70 Maurice Avenue-Fitting", "app_private": 0, "app_appointmentType": 3, "app_userId": 23, "app_orderId": 28018, "app_customerId": 0, "app_isAllDay": 0, "app_timezone": "Europe\/London", "app_latitude": null, "app_longitude": null, "app_parentappid": null, "app_recurrencerule": null, "app_userdefinedValue": "[]", "app_recurrenceexception": null, "app_attachment": null, "guid": "", "app_staff": "", "app_appointtype": "", "app_confirmed": 0, "app_travelHour": "0", "app_travelMinute": "00", "app_onsiteHour": "0", "app_onsiteMinute": "0", "app_location": null, "app_traveltime": null, "app_googleid": "0", "app_platform": "web", "app_cal_status": 844, "app_status": 0, "app_markasread": 0, "app_statusInGoogle": 0, "app_runid": null, "app_jobtimehour": "3", "app_jobtimeminute": "0", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": 3861, "id": "7846", "app_sdate": 1744156800, "app_edate": 1744156800, "app_stime": 1743408000, "app_etime": 1743418800, "app_sdatetime": 1744185600, "app_edatetime": 1744196400, "app_until": null, "app_createdAt": 1743175247, "app_updatedAt": 1743175247, "app_createdBy": 28, "app_updatedBy": null }, { "app_eventid": 7847, "app_description": "CALL @ RAINBOW ", "app_summary": "Administrator", "app_private": 1, "app_appointmentType": 1, "app_userId": 57, "app_orderId": 0, "app_customerId": 0, "app_isAllDay": 0, "app_timezone": "Europe\/London", "app_latitude": null, "app_longitude": null, "app_parentappid": null, "app_recurrencerule": null, "app_userdefinedValue": "[]", "app_recurrenceexception": null, "app_attachment": null, "guid": "", "app_staff": "", "app_appointtype": "", "app_confirmed": 0, "app_travelHour": "0", "app_travelMinute": "00", "app_onsiteHour": "0", "app_onsiteMinute": "0", "app_location": null, "app_traveltime": null, "app_googleid": "0", "app_platform": "web", "app_cal_status": 844, "app_status": 0, "app_markasread": 0, "app_statusInGoogle": 0, "app_runid": 0, "app_jobtimehour": "3", "app_jobtimeminute": "0", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": null, "id": "7847", "app_sdate": 1743465600, "app_edate": 1743465600, "app_stime": 1743408000, "app_etime": 1743418800, "app_sdatetime": 1743494400, "app_edatetime": 1743505200, "app_until": null, "app_createdAt": 1743180338, "app_updatedAt": 1743180338, "app_createdBy": 28, "app_updatedBy": null } ], "updated": [ { "app_eventid": 7712, "app_description": "PLEASE CALL ON ROUTE -", "app_summary": "ON27879-LAURA BOYLE-55 Hillview Crescent-Sales", "app_private": 0, "app_appointmentType": 6, "app_userId": 57, "app_orderId": 27976, "app_customerId": 0, "app_isAllDay": 0, "app_timezone": "Europe\/London", "app_latitude": null, "app_longitude": null, "app_parentappid": null, "app_recurrencerule": null, "app_userdefinedValue": "[]", "app_recurrenceexception": null, "app_attachment": null, "guid": "", "app_staff": "", "app_appointtype": "", "app_confirmed": 0, "app_travelHour": "0", "app_travelMinute": "00", "app_onsiteHour": "0", "app_onsiteMinute": "0", "app_location": null, "app_traveltime": null, "app_googleid": "0", "app_platform": "web", "app_cal_status": 844, "app_status": 0, "app_markasread": 0, "app_statusInGoogle": 0, "app_runid": null, "app_jobtimehour": "3", "app_jobtimeminute": "0", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": 4129, "id": "7712", "app_sdate": 1741219200, "app_edate": 1741219200, "app_stime": 1743411600, "app_etime": 1743422400, "app_sdatetime": 1741251600, "app_edatetime": 1741262400, "app_until": null, "app_createdAt": 1740997217, "app_updatedAt": 1743179181, "app_createdBy": 28, "app_updatedBy": 16 } ], "deleted": [ "7835" ] }, "bm_tasklist": { "created": [], "updated": [], "deleted": [] }, "bm_jobdetails": { "created": [ { "jd_id": 28061, "jd_customerid": 2896, "jd_contactid": 4170, "jd_additionalcontacts": "4170", "jd_templateid": 1, "jd_jobmultiquoteid": 28035, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "ON27945", "jd_jobstatus": 9, "jd_contactaddid": 0, "jd_orderstatus": 10, "jd_accref": "KROH0001", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "0.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "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": null, "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 1, "jd_updatedby": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "20.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"ON27945\",\"35\":\"KROH0001\",\"36\":9,\"37\":2,\"38\":\"\",\"39\":10,\"40\":10,\"41\":1,\"44\":\"\",\"45\":\"Rohit \",\"46\":\"K\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":19,\"285\":1,\"286\":\"4578999\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"600\":\"\",\"601\":\"\",\"602\":\"\",\"603\":\"\",\"604\":\"\",\"605\":\"\",\"606\":\"\",\"607\":\"\",\"608\":\"\",\"617\":\"\",\"618\":\"\",\"619\":\"\",\"620\":\"\",\"622\":\"\",\"623\":\"\",\"625\":\"\",\"countryText\":\"UK\",\"adminUser\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "20.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "28061", "jd_createddate": 1743120000, "jd_orderdate": null, "jd_duedate": 1743120000, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1743173562, "jd_updatedat": 1743401231 }, { "jd_id": 28062, "jd_customerid": 2897, "jd_contactid": 4171, "jd_additionalcontacts": "4171", "jd_templateid": 1, "jd_jobmultiquoteid": 28036, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "ON27946", "jd_jobstatus": 9, "jd_contactaddid": 0, "jd_orderstatus": 10, "jd_accref": "QUOT0001", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "0.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "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": null, "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 1, "jd_updatedby": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 1, "jd_deliveryvatperc": "20.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"ON27946\",\"35\":\"QUOT0001\",\"36\":9,\"37\":1,\"38\":\"\",\"39\":10,\"40\":10,\"41\":1,\"44\":\"\",\"45\":\"\",\"46\":\"Quote 1\",\"47\":\"\",\"48\":\"\",\"49\":\"Quote 1\",\"50\":\"\",\"51\":\"Quote 1\",\"52\":\"\",\"53\":\"\",\"54\":19,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"600\":\"\",\"601\":\"\",\"602\":\"\",\"603\":\"\",\"604\":\"\",\"605\":\"\",\"606\":\"\",\"607\":\"\",\"608\":\"\",\"617\":\"\",\"618\":\"\",\"619\":\"\",\"620\":\"\",\"622\":\"\",\"623\":\"\",\"625\":\"\",\"countryText\":\"UK\",\"adminUser\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "20.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "28062", "jd_createddate": 1743120000, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1743173595, "jd_updatedat": 1743401231 }, { "jd_id": 28063, "jd_customerid": 2898, "jd_contactid": 4172, "jd_additionalcontacts": "4172", "jd_templateid": 1, "jd_jobmultiquoteid": 28037, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "ON27947", "jd_jobstatus": 9, "jd_contactaddid": 0, "jd_orderstatus": 10, "jd_accref": "QUOT0002", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "0.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "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": null, "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 1, "jd_updatedby": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 2, "jd_deliveryvatperc": "20.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"ON27947\",\"35\":\"QUOT0002\",\"36\":9,\"37\":1,\"38\":\"\",\"39\":10,\"40\":10,\"41\":1,\"44\":\"\",\"45\":\"\",\"46\":\"Quote 2\",\"47\":\"\",\"48\":\"\",\"49\":\"Quote 2\",\"50\":\"\",\"51\":\"Quote 2\",\"52\":\"\",\"53\":\"\",\"54\":19,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"600\":\"\",\"601\":\"\",\"602\":\"\",\"603\":\"\",\"604\":\"\",\"605\":\"\",\"606\":\"\",\"607\":\"\",\"608\":\"\",\"617\":\"\",\"618\":\"\",\"619\":\"\",\"620\":\"\",\"622\":\"\",\"623\":\"\",\"625\":\"\",\"countryText\":\"UK\",\"adminUser\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "20.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "28063", "jd_createddate": 1743120000, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1743173809, "jd_updatedat": 1743401231 } ], "updated": [ { "jd_id": 27811, "jd_customerid": 2710, "jd_contactid": 3817, "jd_additionalcontacts": "3817", "jd_templateid": 1, "jd_jobmultiquoteid": 27811, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "ON027742", "jd_jobstatus": 7, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "SHIE1002", "jd_invoiceno": "22318", "jd_listprice": "0.00", "jd_netprice": "1237.50", "jd_vat": "247.50", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 2, "jd_orderformprice": "1485.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "1485.00", "jd_grossprofit": "1237.50", "jd_costprice": "0.00", "jd_overrideprice": "1485.00", "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "0.00", "jd_totpaid": "1485.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": 28, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "20.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":1,\"41\":57,\"44\":\"\",\"45\":\"Karen\",\"46\":\"Shields\",\"47\":\"07789961720\",\"48\":\"\",\"49\":\"57 Gambeson Crescent\",\"50\":\"\",\"51\":\"Stirling\",\"52\":\"\",\"53\":\"FK7 7XG\",\"54\":19,\"285\":12,\"286\":\"\",\"287\":\"GC 7731 SHIELDS\",\"288\":\"\",\"289\":\"CONTAINER 25 DUE AT RAINBOW W\/C 24\/02\",\"551\":1,\"558\":\"\",\"600\":\"\",\"601\":\"\",\"602\":\"\",\"603\":\"\",\"604\":\"\",\"605\":\"\",\"606\":\"\",\"607\":\"\",\"608\":\"\",\"617\":\"\",\"618\":\"\",\"619\":\"\",\"620\":\"\",\"622\":\"\",\"623\":\"\",\"625\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "20.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "27811", "jd_createddate": 1731369600, "jd_orderdate": 1731369600, "jd_duedate": 1740614400, "jd_sceduleddate": 1731456000, "jd_invoicedate": 1743120000, "jd_completeddate": 1743120000, "jd_sageexportdate": null, "jd_createdat": 1739555014, "jd_updatedat": 1743179457 }, { "jd_id": 27855, "jd_customerid": 2688, "jd_contactid": 3796, "jd_additionalcontacts": "3796", "jd_templateid": 1, "jd_jobmultiquoteid": 27855, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "ON027779", "jd_jobstatus": 7, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "BROW1019", "jd_invoiceno": "22317", "jd_listprice": "1295.42", "jd_netprice": "1036.67", "jd_vat": "207.33", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 2, "jd_orderformprice": "1244.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "1244.00", "jd_grossprofit": "-258.75", "jd_costprice": "1295.42", "jd_overrideprice": "1244.00", "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "0.00", "jd_totpaid": "1244.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": 13, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "20.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":4,\"41\":54,\"44\":\"\",\"45\":\"Barbara\",\"46\":\"Brown\",\"47\":\"07780642369\",\"48\":\"\",\"49\":\"22 Ochiltree \",\"50\":\" \",\"51\":\"Dunblane \",\"52\":\" \",\"53\":\"FK15 0DF\",\"54\":19,\"285\":2,\"286\":\"\",\"287\":\"GC 7688 BROWN \",\"288\":\"\",\"289\":\"FITTING 06\/02\",\"551\":1,\"558\":\"\",\"600\":\"\",\"601\":\"\",\"602\":\"\",\"603\":\"\",\"604\":\"\",\"605\":\"\",\"606\":\"\",\"607\":\"\",\"608\":\"\",\"617\":\"\",\"618\":\"\",\"619\":\"\",\"620\":\"\",\"622\":\"\",\"623\":\"\",\"625\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "20.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "27855", "jd_createddate": 1733702400, "jd_orderdate": 1736294400, "jd_duedate": 1738800000, "jd_sceduleddate": 1733702400, "jd_invoicedate": 1743120000, "jd_completeddate": 1743120000, "jd_sageexportdate": null, "jd_createdat": 1739555044, "jd_updatedat": 1743179334 }, { "jd_id": 27878, "jd_customerid": 2688, "jd_contactid": 3796, "jd_additionalcontacts": "3796", "jd_templateid": 1, "jd_jobmultiquoteid": 27878, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "ON027794", "jd_jobstatus": 4, "jd_contactaddid": 0, "jd_orderstatus": 3, "jd_accref": "BROW1019", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "901.67", "jd_vat": "180.33", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 2, "jd_orderformprice": "1082.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "1082.00", "jd_grossprofit": "901.67", "jd_costprice": "0.00", "jd_overrideprice": "1082.00", "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "541.00", "jd_totpaid": "541.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": 13, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "20.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":4,\"41\":28,\"44\":\"\",\"45\":\"Barbara\",\"46\":\"Brown\",\"47\":\"07780642369\",\"48\":\"\",\"49\":\"22 Ochiltree \",\"50\":\" \",\"51\":\"Dunblane \",\"52\":\" \",\"53\":\"FK15 0DF\",\"54\":19,\"285\":2,\"286\":\"\",\"287\":\"GC 7689 BROWN \",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"600\":\"\",\"601\":\"\",\"602\":\"\",\"603\":\"\",\"604\":\"\",\"605\":\"\",\"606\":\"\",\"607\":\"\",\"608\":\"\",\"617\":\"\",\"618\":\"\",\"619\":\"\",\"620\":\"\",\"622\":\"\",\"623\":\"\",\"625\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "20.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "27878", "jd_createddate": 1736294400, "jd_orderdate": 1736294400, "jd_duedate": 1745452800, "jd_sceduleddate": 1736380800, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1739555055, "jd_updatedat": 1743178941 }, { "jd_id": 27892, "jd_customerid": 2761, "jd_contactid": 3868, "jd_additionalcontacts": "3868", "jd_templateid": 1, "jd_jobmultiquoteid": 27892, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "ON027806", "jd_jobstatus": 7, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "RUTH1004", "jd_invoiceno": "22319", "jd_listprice": "608.02", "jd_netprice": "528.63", "jd_vat": "105.73", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 2, "jd_orderformprice": "634.36", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "634.36", "jd_grossprofit": "-79.39", "jd_costprice": "608.02", "jd_overrideprice": "634.36", "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "0.00", "jd_totpaid": "634.36", "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": "608.02", "jd_endcustomeroverridevatprice": "121.61", "jd_endcustomeroverridegrossprice": "729.63", "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": 28, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "20.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":3,\"41\":56,\"44\":\"\",\"45\":\"Irene\",\"46\":\"Rutherford\",\"47\":\"07704049415\",\"48\":\"\",\"49\":\"Glebe House, Manse Road\",\"50\":\"Caputh\",\"51\":\"Perth\",\"52\":\"\",\"53\":\"PH1 4JH\",\"54\":19,\"285\":2,\"286\":\"\",\"287\":\"GC 7497 RUTHERFORD\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"600\":\"\",\"601\":\"\",\"602\":\"\",\"603\":\"\",\"604\":\"\",\"605\":\"\",\"606\":\"\",\"607\":\"\",\"608\":\"\",\"617\":\"\",\"618\":\"\",\"619\":\"\",\"620\":\"\",\"622\":\"\",\"623\":\"\",\"625\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "20.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "27892", "jd_createddate": 1737072000, "jd_orderdate": 1740355200, "jd_duedate": 1740355200, "jd_sceduleddate": 1737072000, "jd_invoicedate": 1743120000, "jd_completeddate": 1743120000, "jd_sageexportdate": null, "jd_createdat": 1739555063, "jd_updatedat": 1743179500 }, { "jd_id": 28018, "jd_customerid": 2754, "jd_contactid": 3861, "jd_additionalcontacts": "3861", "jd_templateid": 1, "jd_jobmultiquoteid": 28000, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "ON27910", "jd_jobstatus": 5, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "MCLA1014", "jd_invoiceno": "", "jd_listprice": "747.35", "jd_netprice": "0.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 2, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "0.00", "jd_grossprofit": "-747.35", "jd_costprice": "747.35", "jd_overrideprice": "0.00", "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": "747.35", "jd_endcustomeroverridevatprice": "149.47", "jd_endcustomeroverridegrossprice": "896.82", "jd_endcustomerdeliverycost": "", "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": "", "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 28, "jd_updatedby": 28, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "20.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":1,\"41\":28,\"44\":\"\",\"45\":\"Steve\",\"46\":\"McLachlan\",\"47\":\"07912256639\",\"48\":\"mintythehammer@gmail.com\",\"49\":\"70 Maurice Avenue\",\"50\":\"\",\"51\":\"Stirling\",\"52\":\"\",\"53\":\"FK7 7UD\",\"54\":19,\"285\":1,\"286\":\"\",\"287\":\"SB 7590 MCLACHLAN \/ R\",\"288\":\"\",\"289\":\"\",\"551\":28,\"558\":\"0\",\"600\":\"\",\"601\":\"\",\"602\":\"\",\"603\":\"\",\"604\":\"\",\"605\":\"5\",\"606\":\"\",\"607\":\"CURVED TRACK DAMAGED\",\"608\":\"\",\"617\":\"\",\"618\":\"\",\"619\":\"\",\"620\":\"\",\"622\":\"\",\"623\":\"\",\"625\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "20.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "28018", "jd_createddate": 1741824000, "jd_orderdate": 1741824000, "jd_duedate": 1743033600, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1741879057, "jd_updatedat": 1743175175 }, { "jd_id": 28021, "jd_customerid": 2761, "jd_contactid": 3868, "jd_additionalcontacts": "3868", "jd_templateid": 1, "jd_jobmultiquoteid": 28003, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "ON27913", "jd_jobstatus": 7, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "RUTH1004", "jd_invoiceno": "", "jd_listprice": "259.88", "jd_netprice": "0.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 2, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "0.00", "jd_grossprofit": "-259.88", "jd_costprice": "259.88", "jd_overrideprice": "0.00", "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": "259.88", "jd_endcustomeroverridevatprice": "51.98", "jd_endcustomeroverridegrossprice": "311.86", "jd_endcustomerdeliverycost": "", "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": "", "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 28, "jd_updatedby": 28, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "20.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":3,\"41\":28,\"44\":\"\",\"45\":\"Irene\",\"46\":\"Rutherford\",\"47\":\"07704049415\",\"48\":\"\",\"49\":\"Glebe House, Manse Road\",\"50\":\"Caputh\",\"51\":\"Perth\",\"52\":\"\",\"53\":\"PH1 4JH\",\"54\":19,\"285\":2,\"286\":\"\",\"287\":\"GC 7497 RUTHERFOLD \/ R\",\"288\":\"\",\"289\":\"\",\"551\":28,\"558\":\"0\",\"600\":\"\",\"601\":\"\",\"602\":\"\",\"603\":\"\",\"604\":\"\",\"605\":\"2\",\"606\":\"\",\"607\":\"FRONT DOOR PANELS MISSLEASURED\",\"608\":\"\",\"617\":\"\",\"618\":\"\",\"619\":\"\",\"620\":\"\",\"622\":\"\",\"623\":\"\",\"625\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "20.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "28021", "jd_createddate": 1741910400, "jd_orderdate": 1741910400, "jd_duedate": 1742428800, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": 1743120000, "jd_sageexportdate": null, "jd_createdat": 1741960658, "jd_updatedat": 1743179510 }, { "jd_id": 28046, "jd_customerid": 2885, "jd_contactid": 4159, "jd_additionalcontacts": "4159", "jd_templateid": 1, "jd_jobmultiquoteid": 28020, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "ON27930", "jd_jobstatus": 4, "jd_contactaddid": 0, "jd_orderstatus": 3, "jd_accref": "HALE0001", "jd_invoiceno": "", "jd_listprice": "3530.68", "jd_netprice": "2700.00", "jd_vat": "540.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 2, "jd_orderformprice": "3240.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "3240.00", "jd_grossprofit": "-830.68", "jd_costprice": "3530.68", "jd_overrideprice": "3240.00", "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "3240.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": "3530.68", "jd_endcustomeroverridevatprice": "706.12", "jd_endcustomeroverridegrossprice": "4236.80", "jd_endcustomerdeliverycost": "", "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": "", "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 28, "jd_updatedby": 13, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "20.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":10,\"41\":28,\"44\":\"\",\"45\":\"Tony\",\"46\":\"Hale\",\"47\":\"\",\"48\":\"zoechat022@yahoo.com\",\"49\":\"55 Wedgewood Drive\",\"50\":\"Bearsden\",\"51\":\"Glasgow\",\"52\":\"\",\"53\":\"G61 4BX\",\"54\":19,\"285\":1,\"286\":\"07855 352855\",\"287\":\"GC 7780 HALE\",\"288\":\"\",\"289\":\"\",\"551\":28,\"558\":\"\",\"600\":\"\",\"601\":\"\",\"602\":\"\",\"603\":\"\",\"604\":\"\",\"605\":\"\",\"606\":\"\",\"607\":\"\",\"608\":\"\",\"617\":\"\",\"618\":\"\",\"619\":\"\",\"620\":\"\",\"622\":\"\",\"623\":\"\",\"625\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "20.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "28046", "jd_createddate": 1742256000, "jd_orderdate": 1743120000, "jd_duedate": 1744848000, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1742312740, "jd_updatedat": 1743178660 }, { "jd_id": 28053, "jd_customerid": 2832, "jd_contactid": 4106, "jd_additionalcontacts": "4106", "jd_templateid": 1, "jd_jobmultiquoteid": 28027, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "ON27937", "jd_jobstatus": 7, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "BECC0001", "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": 2, "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": 28, "jd_updatedby": 28, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "20.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":10,\"41\":28,\"44\":\"\",\"45\":\"\",\"46\":\"BECCI\",\"47\":\"07773785385\",\"48\":\"\",\"49\":\"21 Park Terrace\",\"50\":\"STIRLING\",\"51\":\"Stirling\",\"52\":\"\",\"53\":\"FK8 2JT\",\"54\":19,\"285\":2,\"286\":\"01786 470262\",\"287\":\"GC 7494 BECCI \/ R\",\"288\":\"\",\"289\":\"\",\"551\":28,\"558\":\"0\",\"600\":\"\",\"601\":\"\",\"602\":\"\",\"603\":\"\",\"604\":\"\",\"605\":\"4\",\"606\":\"\",\"607\":\"WAND TOO SHOTRT\",\"608\":\"\",\"617\":\"\",\"618\":\"\",\"619\":\"\",\"620\":\"\",\"622\":\"\",\"623\":\"\",\"625\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "20.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "28053", "jd_createddate": 1742515200, "jd_orderdate": 1742515200, "jd_duedate": 1742515200, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": 1743120000, "jd_sageexportdate": null, "jd_createdat": 1742558129, "jd_updatedat": 1743179570 }, { "jd_id": 28055, "jd_customerid": 2891, "jd_contactid": 4165, "jd_additionalcontacts": "4165", "jd_templateid": 1, "jd_jobmultiquoteid": 28029, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "ON27939", "jd_jobstatus": 4, "jd_contactaddid": 0, "jd_orderstatus": 3, "jd_accref": "BROW0001", "jd_invoiceno": "", "jd_listprice": "111.06", "jd_netprice": "88.33", "jd_vat": "17.67", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 2, "jd_orderformprice": "106.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "106.00", "jd_grossprofit": "-22.73", "jd_costprice": "111.06", "jd_overrideprice": "106.00", "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "0.00", "jd_totpaid": "106.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": "111.06", "jd_endcustomeroverridevatprice": "22.21", "jd_endcustomeroverridegrossprice": "133.27", "jd_endcustomerdeliverycost": "", "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": "", "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 13, "jd_updatedby": 13, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "20.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":4,\"41\":13,\"44\":\"\",\"45\":\"\",\"46\":\"Brown\",\"47\":\"\",\"48\":\"\",\"49\":\"33 Grendon Court\",\"50\":\"STIRLING\",\"51\":\"Stirling\",\"52\":\"\",\"53\":\"FK82JX\",\"54\":19,\"285\":1,\"286\":\"07368294608\",\"287\":\"GC 7787 BROWN\",\"288\":\"\",\"289\":\"\",\"551\":13,\"558\":\"\",\"600\":\"\",\"601\":\"\",\"602\":\"\",\"603\":\"\",\"604\":\"\",\"605\":\"\",\"606\":\"\",\"607\":\"\",\"608\":\"\",\"617\":\"\",\"618\":\"\",\"619\":\"\",\"620\":\"\",\"622\":\"\",\"623\":\"\",\"625\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "20.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "28055", "jd_createddate": 1742774400, "jd_orderdate": 1742947200, "jd_duedate": 1743638400, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1742824764, "jd_updatedat": 1743179055 }, { "jd_id": 28061, "jd_customerid": 2896, "jd_contactid": 4170, "jd_additionalcontacts": "4170", "jd_templateid": 1, "jd_jobmultiquoteid": 28035, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "ON27945", "jd_jobstatus": 9, "jd_contactaddid": 0, "jd_orderstatus": 10, "jd_accref": "KROH0001", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "0.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "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": null, "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 1, "jd_updatedby": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "20.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"ON27945\",\"35\":\"KROH0001\",\"36\":9,\"37\":2,\"38\":\"\",\"39\":10,\"40\":10,\"41\":1,\"44\":\"\",\"45\":\"Rohit \",\"46\":\"K\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":19,\"285\":1,\"286\":\"4578999\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"600\":\"\",\"601\":\"\",\"602\":\"\",\"603\":\"\",\"604\":\"\",\"605\":\"\",\"606\":\"\",\"607\":\"\",\"608\":\"\",\"617\":\"\",\"618\":\"\",\"619\":\"\",\"620\":\"\",\"622\":\"\",\"623\":\"\",\"625\":\"\",\"countryText\":\"UK\",\"adminUser\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "20.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "28061", "jd_createddate": 1743120000, "jd_orderdate": null, "jd_duedate": 1743120000, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1743173562, "jd_updatedat": 1743401231 }, { "jd_id": 28062, "jd_customerid": 2897, "jd_contactid": 4171, "jd_additionalcontacts": "4171", "jd_templateid": 1, "jd_jobmultiquoteid": 28036, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "ON27946", "jd_jobstatus": 9, "jd_contactaddid": 0, "jd_orderstatus": 10, "jd_accref": "QUOT0001", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "0.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "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": null, "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 1, "jd_updatedby": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 1, "jd_deliveryvatperc": "20.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"ON27946\",\"35\":\"QUOT0001\",\"36\":9,\"37\":1,\"38\":\"\",\"39\":10,\"40\":10,\"41\":1,\"44\":\"\",\"45\":\"\",\"46\":\"Quote 1\",\"47\":\"\",\"48\":\"\",\"49\":\"Quote 1\",\"50\":\"\",\"51\":\"Quote 1\",\"52\":\"\",\"53\":\"\",\"54\":19,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"600\":\"\",\"601\":\"\",\"602\":\"\",\"603\":\"\",\"604\":\"\",\"605\":\"\",\"606\":\"\",\"607\":\"\",\"608\":\"\",\"617\":\"\",\"618\":\"\",\"619\":\"\",\"620\":\"\",\"622\":\"\",\"623\":\"\",\"625\":\"\",\"countryText\":\"UK\",\"adminUser\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "20.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "28062", "jd_createddate": 1743120000, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1743173595, "jd_updatedat": 1743401231 }, { "jd_id": 28063, "jd_customerid": 2898, "jd_contactid": 4172, "jd_additionalcontacts": "4172", "jd_templateid": 1, "jd_jobmultiquoteid": 28037, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "ON27947", "jd_jobstatus": 9, "jd_contactaddid": 0, "jd_orderstatus": 10, "jd_accref": "QUOT0002", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "0.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "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": null, "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 1, "jd_updatedby": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 2, "jd_deliveryvatperc": "20.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"ON27947\",\"35\":\"QUOT0002\",\"36\":9,\"37\":1,\"38\":\"\",\"39\":10,\"40\":10,\"41\":1,\"44\":\"\",\"45\":\"\",\"46\":\"Quote 2\",\"47\":\"\",\"48\":\"\",\"49\":\"Quote 2\",\"50\":\"\",\"51\":\"Quote 2\",\"52\":\"\",\"53\":\"\",\"54\":19,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"600\":\"\",\"601\":\"\",\"602\":\"\",\"603\":\"\",\"604\":\"\",\"605\":\"\",\"606\":\"\",\"607\":\"\",\"608\":\"\",\"617\":\"\",\"618\":\"\",\"619\":\"\",\"620\":\"\",\"622\":\"\",\"623\":\"\",\"625\":\"\",\"countryText\":\"UK\",\"adminUser\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "20.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "28063", "jd_createddate": 1743120000, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1743173809, "jd_updatedat": 1743401231 } ], "deleted": [] }, "bm_orderitem": { "created": [ { "oi_id": 84506, "oi_jobid": 28061, "oi_jobtempid": "0", "oi_jobmultiquoteid": 28035, "oi_productid": 72, "oi_recipeid": 72, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 0, "oi_customseq": 0, "oi_productcustomseq": 0, "oi_jsondata": "[{\"id\":13793,\"labelname\":\"Unit Type\",\"value\":2,\"valueid\":\"2\",\"type\":34,\"optionid\":\"2\",\"optionvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":\"\",\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":13792,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":13794,\"labelname\":\"Supplier\",\"value\":\"11\",\"valueid\":\"\",\"type\":17,\"optionid\":\"11\",\"optionvalue\":[{\"id\":11,\"optionid\":11,\"optionname\":\"Velux\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":13795,\"labelname\":\"Product Type\",\"value\":601,\"valueid\":\"601\",\"type\":13,\"optionid\":\"601\",\"optionvalue\":[{\"id\":601,\"fieldid\":13795,\"fieldoptionlinkid\":601,\"optionid\":601,\"mainsupplier\":\"11\",\"blindtypecode\":\"\",\"optionname\":\"-V\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":13796,\"labelname\":\"Width\",\"value\":\"588\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":13797,\"labelname\":\"Drop\",\"value\":\"36\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":13798,\"labelname\":\"Fabric\",\"value\":\"-\",\"valueid\":\"12842\",\"type\":5,\"optionid\":\"12842\",\"optionvalue\":[{\"optionid\":12842,\"optionname\":\"-\",\"optioncode\":118924,\"optionquantity\":1,\"fieldoptionlinkid\":12842,\"forchildfieldoptionlinkid\":\"5_2_12842_1\",\"optionimage\":\"\",\"subdatacount\":1,\"description\":\"\",\"pricegroup\":\"-V\",\"pricegroupid\":601}],\"fabricorcolor\":1,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":13799,\"labelname\":\"Color\",\"value\":\"White\",\"valueid\":\"64501\",\"type\":5,\"optionid\":\"64501\",\"optionvalue\":[{\"optionid\":64501,\"optionname\":\"White\",\"optioncode\":475770,\"optionquantity\":1,\"fieldoptionlinkid\":64501,\"forchildfieldoptionlinkid\":\"5_3_64501_1\",\"minimumdiscount\":\"\",\"maximumdiscount\":\"\",\"optionimage\":\"\",\"subdatacount\":0,\"description\":\"\"}],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":13800,\"labelname\":\"Location\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":13801,\"labelname\":\"Window Code\",\"value\":\"GGL\",\"valueid\":\"16168\",\"type\":3,\"optionid\":\"3175\",\"optionvalue\":[{\"optionid\":3175,\"optionname\":\"GGL\",\"description\":\"\",\"optioncode\":990,\"pricegroups\":\"-V\",\"optionqty\":1,\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":16168,\"forchildfieldoptionlinkid\":\"3_16168\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":28269,\"labelname\":\"Fitting Height\",\"value\":\"\",\"valueid\":\"\",\"type\":6,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":13802,\"labelname\":\"Further Instructions\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]", "oi_description": "Unit Type: mm, Quantity: 1, Supplier: Velux, Product Type: -V, Width: 588, Drop: 36, Fabric: -, Color: White, Window Code: GGL", "oi_reportdescription": "##Quantity: 1##,##Supplier: Velux##,##Product Type: -V##,##Width: 588 mm##,##Drop: 36 mm##,##Fabric: -##,##Color: White##,##Window Code: GGL##", "oi_reporttitles": "##Quantity:##Supplier:##Product Type:##Width:##Drop:##Fabric:##Color:##Window Code:", "oi_productionformulajsondata": "[]", "oi_operationstatus": null, "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "[]", "oi_pricecomesfrom_calculations": "{}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "0.000", "oi_netprice": "0.000", "oi_pricesfromoperations": null, "oi_vatprice": "0.000", "oi_vatvalue": "20.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "0.000", "oi_overrideprice": "0.000", "oi_overridetype": 2, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 0, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 2, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "0.000", "oi_endcustomeroverridevatprice": "0.000", "oi_endcustomeroverridegrossprice": "0.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[13793, 13792, 13794, 13795, 13796, 13797, 13798, 13799, 13800, 13801, 28269, 13802]", "oi_deviceplatform": 2, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "84506", "oi_productiondate": 1743173565, "oi_createdat": 1743173590, "oi_updatedat": null, "oi_createdby": 1, "oi_updatedby": null } ], "updated": [ { "oi_id": 84142, "oi_jobid": 27855, "oi_jobtempid": "0", "oi_jobmultiquoteid": 27855, "oi_productid": 135, "oi_recipeid": 135, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 2, "oi_customseq": 2, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":27364,\"labelname\":\"Quantity\",\"labelnamecode\":\"Quantity\",\"value\":1,\"valueid\":null,\"type\":14,\"optionid\":null,\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27365,\"labelname\":\"Unit Type\",\"value\":2,\"valueid\":2,\"type\":34,\"optionid\":2,\"optionvalue\":[{\"optionid\":1,\"optionname\":\"cm\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":1,\"forchildfieldoptionlinkid\":\"0_1\"},{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"0_2\"},{\"optionid\":3,\"optionname\":\"m\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":3,\"forchildfieldoptionlinkid\":\"0_3\"},{\"optionid\":4,\"optionname\":\"inch\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":4,\"forchildfieldoptionlinkid\":\"0_4\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27366,\"labelname\":\"Supplier\",\"labelnamecode\":\"Supplier\",\"value\":2,\"valueid\":null,\"type\":17,\"optionid\":2,\"optionvalue\":[{\"id\":2,\"optionid\":2,\"optionname\":\"Arena\",\"optionquantity\":1,\"deleted\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27367,\"labelname\":\"Product Type\",\"labelnamecode\":\"Product Type1743\",\"value\":1143,\"valueid\":1143,\"type\":13,\"optionid\":1143,\"optionvalue\":[{\"id\":1143,\"fieldid\":27367,\"fieldoptionlinkid\":1143,\"optionid\":1143,\"mainsupplier\":2,\"blindtypecode\":\"\",\"optionname\":\"Eyelet Band C_Arena_166996\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27368,\"labelname\":\"Curtain Ref Location\",\"labelnamecode\":\"Curtain Ref Location1746\",\"value\":\"BACK ROOM\",\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27369,\"labelname\":\"Single Pair\",\"labelnamecode\":\"Single Pair1762\",\"value\":\"Pair\",\"valueid\":\"39607\",\"type\":3,\"optionid\":\"14016\",\"optionvalue\":[{\"optionid\":14016,\"optionqty\":\"1\",\"description\":\"\",\"optioncode\":\"6128\",\"optionname\":\"Pair\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":39607,\"forchildfieldoptionlinkid\":\"3_39607\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"0.00\",\"costprice\":0,\"costwithdiscount\":0,\"customersellingprice\":0,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":\"1\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27370,\"labelname\":\"No of Widths\",\"labelnamecode\":\"No of Widths1747\",\"value\":\"\",\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27371,\"labelname\":\"Width\",\"labelnamecode\":\"Width1749\",\"value\":\"2100\",\"valueid\":null,\"type\":11,\"optionid\":null,\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27372,\"labelname\":\"Drop\",\"labelnamecode\":\"Drop1750\",\"value\":\"1360\",\"valueid\":null,\"type\":12,\"optionid\":null,\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27373,\"labelname\":\"Fabric\",\"labelnamecode\":\"Fabric1743\",\"value\":\"Newcombe\",\"valueid\":\"24521\",\"type\":5,\"optionid\":\"24521\",\"optionvalue\":[{\"optionid\":24521,\"optionname\":\"Newcombe\",\"optioncode\":\"156992\",\"optionquantity\":1,\"fieldoptionlinkid\":24521,\"forchildfieldoptionlinkid\":\"5_2_24521_1\",\"optionimage\":null,\"subdatacount\":0,\"description\":\"\",\"pricegroup\":\"Eyelet Band C_Arena_166996\",\"pricegroupid\":1143}],\"fabricorcolor\":1,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27545,\"labelname\":\"Color\",\"labelnamecode\":\"Color\",\"value\":\"Thistle\",\"valueid\":\"125047\",\"type\":5,\"optionid\":\"125047\",\"optionvalue\":[{\"optionid\":125047,\"optionname\":\"Thistle\",\"optioncode\":\"663012\",\"optionquantity\":1,\"fieldoptionlinkid\":125047,\"forchildfieldoptionlinkid\":\"\",\"optionimage\":null,\"subdatacount\":0,\"description\":\" \",\"pricegroup\":\"Eyelet Band C_Arena_166996\",\"pricegroupid\":1143}],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27572,\"labelname\":\"Pattern Repeat\",\"labelnamecode\":\"Pattern Repeat1745\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27573,\"labelname\":\"Hook Position\",\"labelnamecode\":\"Hook Position1744\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27574,\"labelname\":\"Lining\",\"labelnamecode\":\"Lining1758\",\"value\":\"Standard\",\"valueid\":\"39811\",\"type\":3,\"optionid\":\"14022\",\"optionvalue\":[{\"optionid\":14022,\"optionqty\":\"1\",\"description\":\"\",\"optioncode\":\"5944\",\"optionname\":\"Standard\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":39811,\"forchildfieldoptionlinkid\":\"3_39811\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"0.00\",\"costprice\":0,\"costwithdiscount\":0,\"customersellingprice\":0,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":\"1\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27575,\"labelname\":\"Standard Lining Colours\",\"labelnamecode\":\"Standard Lining Colours3362\",\"value\":\"Ivory\",\"valueid\":\"39814\",\"type\":3,\"optionid\":\"14024\",\"optionvalue\":[{\"optionid\":14024,\"id\":39814,\"fieldtypeid\":3,\"description\":\"\",\"liningcode\":\"27147\",\"optionname\":\"Ivory\",\"fieldoptionlinkid\":39814,\"forchildfieldoptionlinkid\":\"3_39814\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27578,\"labelname\":\"Tiebacks\",\"labelnamecode\":\"Tiebacks1759\",\"value\":\"No\",\"valueid\":\"39831\",\"type\":3,\"optionid\":\"14039\",\"optionvalue\":[{\"optionid\":14039,\"optionqty\":\"1\",\"description\":\"\",\"optioncode\":\"5947\",\"optionname\":\"No\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":39831,\"forchildfieldoptionlinkid\":\"3_39831\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"0.00\",\"costprice\":0,\"costwithdiscount\":0,\"customersellingprice\":0,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":\"1\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27582,\"labelname\":\"Holdbacks Hooks\",\"labelnamecode\":\"Holdbacks Hooks1763\",\"value\":\"\",\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27583,\"labelname\":\"Pole Type\",\"labelnamecode\":\"Pole Type1760\",\"value\":\"\",\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27584,\"labelname\":\"Extras\",\"labelnamecode\":\"Extras1761\",\"value\":\"\",\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27585,\"labelname\":\"Further Instructions\",\"labelnamecode\":\"Further Instructions1748\",\"value\":\"HEM TO HEM SIZE\",\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1}]", "oi_description": "Quantity: 1, Unit Type: mm, Supplier: Arena, Product Type: Eyelet Band C_Arena_166996, Curtain Ref Location: BACK ROOM, Single Pair: Pair, Width: 2100, Drop: 1360, Fabric: Newcombe, Color: Thistle, Lining: Standard, Standard Lining Colours: Ivory, Tiebacks: No, Further Instructions: HEM TO HEM SIZE", "oi_reportdescription": "##Quantity: 1##,##Supplier: Arena##,##Product Type: Eyelet Band C_Arena_166996##,##Curtain Ref Location: BACK ROOM##,##Single Pair: Pair##,##Width: 2100 mm##,##Drop: 1360 mm##,##Fabric: Newcombe##,##Color: Thistle##,##Lining: Standard##,##Standard Lining Colours: Ivory##,##Tiebacks: No##,##Further Instructions: HEM TO HEM SIZE##", "oi_reporttitles": "##Quantity:<\/br>##Supplier:<\/br>##Product Type:<\/br>##Curtain Ref Location:<\/br>##Single Pair:<\/br>##Width:<\/br>##Drop:<\/br>##Fabric:<\/br>##Color:<\/br>##Lining:<\/br>##Standard Lining Colours:<\/br>##Tiebacks:<\/br>##Further Instructions:", "oi_productionformulajsondata": "[]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "[]", "oi_pricecomesfrom_calculations": "{\"label\": \"Price table cost\", \"unit_type\": \"-\", \"cost_price\": 554.400, \"show_hide\": true, \"category\": 3}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "554.400", "oi_netprice": "554.400", "oi_pricesfromoperations": null, "oi_vatprice": "110.880", "oi_vatvalue": "20.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "665.280", "oi_overrideprice": "665.280", "oi_overridetype": 2, "oi_overridevalue": "665.28", "oi_overridenetprice": "554.400", "oi_overridevatprice": "110.880", "oi_overridegrossprice": "665.280", "oi_ready": 1, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 1, "oi_endcustomervatprice": "0.000", "oi_endcustomeroverridetype": 0, "oi_endcustomeroverridevalue": "0", "oi_endcustomeroverridenetprice": "0.000", "oi_endcustomeroverridevatprice": "0.000", "oi_endcustomeroverridegrossprice": "0.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[27364, 27365, 27366, 27367, 27368, 27369, 27370, 27371, 27372, 27373, 27545, 27572, 27573, 27574, 27575, 27578, 27582, 27583, 27584, 27585]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "84142", "oi_productiondate": 1737158400, "oi_createdat": 1736775217, "oi_updatedat": 1743178858, "oi_createdby": 1, "oi_updatedby": 13 }, { "oi_id": 84143, "oi_jobid": 27855, "oi_jobtempid": "0", "oi_jobmultiquoteid": 27855, "oi_productid": 135, "oi_recipeid": 135, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 3, "oi_customseq": 3, "oi_productcustomseq": 2, "oi_jsondata": "[{\"id\":27364,\"labelname\":\"Quantity\",\"labelnamecode\":\"Quantity\",\"value\":1,\"valueid\":null,\"type\":14,\"optionid\":null,\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27365,\"labelname\":\"Unit Type\",\"value\":2,\"valueid\":2,\"type\":34,\"optionid\":2,\"optionvalue\":[{\"optionid\":1,\"optionname\":\"cm\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":1,\"forchildfieldoptionlinkid\":\"0_1\"},{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"0_2\"},{\"optionid\":3,\"optionname\":\"m\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":3,\"forchildfieldoptionlinkid\":\"0_3\"},{\"optionid\":4,\"optionname\":\"inch\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":4,\"forchildfieldoptionlinkid\":\"0_4\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27366,\"labelname\":\"Supplier\",\"labelnamecode\":\"Supplier\",\"value\":2,\"valueid\":null,\"type\":17,\"optionid\":2,\"optionvalue\":[{\"id\":2,\"optionid\":2,\"optionname\":\"Arena\",\"optionquantity\":1,\"deleted\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27367,\"labelname\":\"Product Type\",\"labelnamecode\":\"Product Type1743\",\"value\":1143,\"valueid\":1143,\"type\":13,\"optionid\":1143,\"optionvalue\":[{\"id\":1143,\"fieldid\":27367,\"fieldoptionlinkid\":1143,\"optionid\":1143,\"mainsupplier\":2,\"blindtypecode\":\"\",\"optionname\":\"Eyelet Band C_Arena_166996\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27368,\"labelname\":\"Curtain Ref Location\",\"labelnamecode\":\"Curtain Ref Location1746\",\"value\":\"FRONT ROOM\",\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27369,\"labelname\":\"Single Pair\",\"labelnamecode\":\"Single Pair1762\",\"value\":\"Pair\",\"valueid\":\"39607\",\"type\":3,\"optionid\":\"14016\",\"optionvalue\":[{\"optionid\":14016,\"optionqty\":\"1\",\"description\":\"\",\"optioncode\":\"6128\",\"optionname\":\"Pair\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":39607,\"forchildfieldoptionlinkid\":\"3_39607\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"0.00\",\"costprice\":0,\"costwithdiscount\":0,\"customersellingprice\":0,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":\"1\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27370,\"labelname\":\"No of Widths\",\"labelnamecode\":\"No of Widths1747\",\"value\":\"\",\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27371,\"labelname\":\"Width\",\"labelnamecode\":\"Width1749\",\"value\":\"2100\",\"valueid\":null,\"type\":11,\"optionid\":null,\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27372,\"labelname\":\"Drop\",\"labelnamecode\":\"Drop1750\",\"value\":\"1370\",\"valueid\":null,\"type\":12,\"optionid\":null,\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27373,\"labelname\":\"Fabric\",\"labelnamecode\":\"Fabric1743\",\"value\":\"Newcombe\",\"valueid\":\"24521\",\"type\":5,\"optionid\":\"24521\",\"optionvalue\":[{\"optionid\":24521,\"optionname\":\"Newcombe\",\"optioncode\":\"156992\",\"optionquantity\":1,\"fieldoptionlinkid\":24521,\"forchildfieldoptionlinkid\":\"5_2_24521_1\",\"optionimage\":null,\"subdatacount\":0,\"description\":\"\",\"pricegroup\":\"Eyelet Band C_Arena_166996\",\"pricegroupid\":1143}],\"fabricorcolor\":1,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27545,\"labelname\":\"Color\",\"labelnamecode\":\"Color\",\"value\":\"Teal\",\"valueid\":\"125046\",\"type\":5,\"optionid\":\"125046\",\"optionvalue\":[{\"optionid\":125046,\"optionname\":\"Teal\",\"optioncode\":\"663011\",\"optionquantity\":1,\"fieldoptionlinkid\":125046,\"forchildfieldoptionlinkid\":\"\",\"optionimage\":null,\"subdatacount\":0,\"description\":\" \",\"pricegroup\":\"Eyelet Band C_Arena_166996\",\"pricegroupid\":1143}],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27572,\"labelname\":\"Pattern Repeat\",\"labelnamecode\":\"Pattern Repeat1745\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27573,\"labelname\":\"Hook Position\",\"labelnamecode\":\"Hook Position1744\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27574,\"labelname\":\"Lining\",\"labelnamecode\":\"Lining1758\",\"value\":\"Standard\",\"valueid\":\"39811\",\"type\":3,\"optionid\":\"14022\",\"optionvalue\":[{\"optionid\":14022,\"optionqty\":\"1\",\"description\":\"\",\"optioncode\":\"5944\",\"optionname\":\"Standard\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":39811,\"forchildfieldoptionlinkid\":\"3_39811\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"0.00\",\"costprice\":0,\"costwithdiscount\":0,\"customersellingprice\":0,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":\"1\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27575,\"labelname\":\"Standard Lining Colours\",\"labelnamecode\":\"Standard Lining Colours3362\",\"value\":\"Ivory\",\"valueid\":\"39814\",\"type\":3,\"optionid\":\"14024\",\"optionvalue\":[{\"optionid\":14024,\"id\":39814,\"fieldtypeid\":3,\"description\":\"\",\"liningcode\":\"27147\",\"optionname\":\"Ivory\",\"fieldoptionlinkid\":39814,\"forchildfieldoptionlinkid\":\"3_39814\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27578,\"labelname\":\"Tiebacks\",\"labelnamecode\":\"Tiebacks1759\",\"value\":\"No\",\"valueid\":\"39831\",\"type\":3,\"optionid\":\"14039\",\"optionvalue\":[{\"optionid\":14039,\"optionqty\":\"1\",\"description\":\"\",\"optioncode\":\"5947\",\"optionname\":\"No\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":39831,\"forchildfieldoptionlinkid\":\"3_39831\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"0.00\",\"costprice\":0,\"costwithdiscount\":0,\"customersellingprice\":0,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":\"1\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27582,\"labelname\":\"Holdbacks Hooks\",\"labelnamecode\":\"Holdbacks Hooks1763\",\"value\":\"\",\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27583,\"labelname\":\"Pole Type\",\"labelnamecode\":\"Pole Type1760\",\"value\":\"\",\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27584,\"labelname\":\"Extras\",\"labelnamecode\":\"Extras1761\",\"value\":\"\",\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1},{\"id\":27585,\"labelname\":\"Further Instructions\",\"labelnamecode\":\"Further Instructions1748\",\"value\":\"HEM TO HEM SIZE\",\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfractiontext\":\"\",\"dropfraction\":\"\",\"editruleoverride\":0,\"showfieldonjob\":1,\"optionquantity\":null,\"globaledit\":false,\"issubfabric\":0,\"showFieldOnCustomerPortal\":1}]", "oi_description": "Quantity: 1, Unit Type: mm, Supplier: Arena, Product Type: Eyelet Band C_Arena_166996, Curtain Ref Location: FRONT ROOM, Single Pair: Pair, Width: 2100, Drop: 1370, Fabric: Newcombe, Color: Teal, Lining: Standard, Standard Lining Colours: Ivory, Tiebacks: No, Further Instructions: HEM TO HEM SIZE", "oi_reportdescription": "##Quantity: 1##,##Supplier: Arena##,##Product Type: Eyelet Band C_Arena_166996##,##Curtain Ref Location: FRONT ROOM##,##Single Pair: Pair##,##Width: 2100 mm##,##Drop: 1370 mm##,##Fabric: Newcombe##,##Color: Teal##,##Lining: Standard##,##Standard Lining Colours: Ivory##,##Tiebacks: No##,##Further Instructions: HEM TO HEM SIZE##", "oi_reporttitles": "##Quantity:<\/br>##Supplier:<\/br>##Product Type:<\/br>##Curtain Ref Location:<\/br>##Single Pair:<\/br>##Width:<\/br>##Drop:<\/br>##Fabric:<\/br>##Color:<\/br>##Lining:<\/br>##Standard Lining Colours:<\/br>##Tiebacks:<\/br>##Further Instructions:", "oi_productionformulajsondata": "[]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "[]", "oi_pricecomesfrom_calculations": "{\"label\": \"Price table cost\", \"unit_type\": \"-\", \"cost_price\": 554.400, \"show_hide\": true, \"category\": 3}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "554.400", "oi_netprice": "554.400", "oi_pricesfromoperations": null, "oi_vatprice": "110.880", "oi_vatvalue": "20.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "665.280", "oi_overrideprice": "665.280", "oi_overridetype": 2, "oi_overridevalue": "665.28", "oi_overridenetprice": "554.400", "oi_overridevatprice": "110.880", "oi_overridegrossprice": "665.280", "oi_ready": 1, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 1, "oi_endcustomervatprice": "0.000", "oi_endcustomeroverridetype": 0, "oi_endcustomeroverridevalue": "0", "oi_endcustomeroverridenetprice": "0.000", "oi_endcustomeroverridevatprice": "0.000", "oi_endcustomeroverridegrossprice": "0.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[27364, 27365, 27366, 27367, 27368, 27369, 27370, 27371, 27372, 27373, 27545, 27572, 27573, 27574, 27575, 27578, 27582, 27583, 27584, 27585]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "84143", "oi_productiondate": 1737158400, "oi_createdat": 1736775248, "oi_updatedat": 1743178867, "oi_createdby": 1, "oi_updatedby": 13 } ], "deleted": [] }, "bm_paymentlist": { "created": [ { "pl_id": 2856, "pl_orderid": "0", "pl_invoice_id": 22347, "pl_customer_id": 2688, "pl_overpayment_id": 0, "pl_jobpayment_id": 34, "pl_amount": "622.00", "pl_paymentmethod": 16, "pl_paymentcategory": 1, "pl_paymenttype": 8, "pl_surchargetype": 0, "pl_surchargemethod": 0, "pl_surchargeamount": "0.00", "pl_surchargevalue": "0.00", "pl_surchargetotal": "622.00", "pl_userid": "28", "pl_decription": "", "pl_paymentinvoice": null, "pl_paymentstatus": 0, "pl_seq": 0, "pl_status": 0, "pl_refundtype": null, "pl_deviceplatform": 0, "id": "2856", "pl_paiddate": 1736208000, "created_at": 1743179334, "updated_at": null, "created_by": 13, "updated_by": null }, { "pl_id": 2857, "pl_orderid": "0", "pl_invoice_id": 22347, "pl_customer_id": 2688, "pl_overpayment_id": 0, "pl_jobpayment_id": 35, "pl_amount": "622.00", "pl_paymentmethod": 16, "pl_paymentcategory": 1, "pl_paymenttype": 21, "pl_surchargetype": 0, "pl_surchargemethod": 0, "pl_surchargeamount": "0.00", "pl_surchargevalue": "0.00", "pl_surchargetotal": "622.00", "pl_userid": "28", "pl_decription": "", "pl_paymentinvoice": null, "pl_paymentstatus": 0, "pl_seq": 0, "pl_status": 0, "pl_refundtype": null, "pl_deviceplatform": 0, "id": "2857", "pl_paiddate": 1738713600, "created_at": 1743179334, "updated_at": null, "created_by": 13, "updated_by": null }, { "pl_id": 2858, "pl_orderid": "0", "pl_invoice_id": 22348, "pl_customer_id": 2710, "pl_overpayment_id": 0, "pl_jobpayment_id": 28, "pl_amount": "742.50", "pl_paymentmethod": 5, "pl_paymentcategory": 1, "pl_paymenttype": 8, "pl_surchargetype": 0, "pl_surchargemethod": 0, "pl_surchargeamount": "0.00", "pl_surchargevalue": "0.00", "pl_surchargetotal": "742.50", "pl_userid": "57", "pl_decription": "", "pl_paymentinvoice": null, "pl_paymentstatus": 0, "pl_seq": 0, "pl_status": 0, "pl_refundtype": null, "pl_deviceplatform": 0, "id": "2858", "pl_paiddate": 1731369600, "created_at": 1743179458, "updated_at": null, "created_by": 28, "updated_by": null }, { "pl_id": 2859, "pl_orderid": "0", "pl_invoice_id": 22348, "pl_customer_id": 2710, "pl_overpayment_id": 0, "pl_jobpayment_id": 101, "pl_amount": "742.50", "pl_paymentmethod": 14, "pl_paymentcategory": 1, "pl_paymenttype": 21, "pl_surchargetype": 0, "pl_surchargemethod": 0, "pl_surchargeamount": "0.00", "pl_surchargevalue": "0.00", "pl_surchargetotal": "742.50", "pl_userid": "28", "pl_decription": "", "pl_paymentinvoice": null, "pl_paymentstatus": 0, "pl_seq": 0, "pl_status": 0, "pl_refundtype": null, "pl_deviceplatform": 0, "id": "2859", "pl_paiddate": 1740700800, "created_at": 1743179458, "updated_at": null, "created_by": 28, "updated_by": null }, { "pl_id": 2860, "pl_orderid": "0", "pl_invoice_id": 22349, "pl_customer_id": 2761, "pl_overpayment_id": 0, "pl_jobpayment_id": 86, "pl_amount": "322.50", "pl_paymentmethod": 5, "pl_paymentcategory": 1, "pl_paymenttype": 8, "pl_surchargetype": 0, "pl_surchargemethod": 0, "pl_surchargeamount": "0.00", "pl_surchargevalue": "0.00", "pl_surchargetotal": "322.50", "pl_userid": "57", "pl_decription": "", "pl_paymentinvoice": null, "pl_paymentstatus": 0, "pl_seq": 0, "pl_status": 0, "pl_refundtype": null, "pl_deviceplatform": 0, "id": "2860", "pl_paiddate": 1740355200, "created_at": 1743179500, "updated_at": null, "created_by": 28, "updated_by": null }, { "pl_id": 2861, "pl_orderid": "0", "pl_invoice_id": 22349, "pl_customer_id": 2761, "pl_overpayment_id": 0, "pl_jobpayment_id": 139, "pl_amount": "311.86", "pl_paymentmethod": 16, "pl_paymentcategory": 1, "pl_paymenttype": 10, "pl_surchargetype": 0, "pl_surchargemethod": 0, "pl_surchargeamount": "0.00", "pl_surchargevalue": "0.00", "pl_surchargetotal": "311.86", "pl_userid": "16", "pl_decription": "", "pl_paymentinvoice": null, "pl_paymentstatus": 0, "pl_seq": 0, "pl_status": 0, "pl_refundtype": null, "pl_deviceplatform": 0, "id": "2861", "pl_paiddate": 1743033600, "created_at": 1743179500, "updated_at": null, "created_by": 28, "updated_by": null } ], "updated": [], "deleted": [] }, "bm_notelist": { "created": [ { "nl_id": 96324, "nl_ordertempid": null, "nl_orderid": 27855, "nl_notescategory": 1, "nl_type": 4, "nl_platform": 3, "nl_desc": "Invoice Created (22317)", "nl_manualNotes": "", "nl_createdby": "13", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 1, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "96324", "nl_endddate": 1743120000, "nl_starttime": 1743438534, "created_at": 1743179334, "updated_at": 1743179334, "created_by": 13, "updated_by": null }, { "nl_id": 96325, "nl_ordertempid": null, "nl_orderid": 27855, "nl_notescategory": 1, "nl_type": 4, "nl_platform": 3, "nl_desc": "payment added against invoice no (22317) amount (622.000)", "nl_manualNotes": "", "nl_createdby": "13", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 1, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "96325", "nl_endddate": 1743120000, "nl_starttime": 1743438534, "created_at": 1743179334, "updated_at": 1743179334, "created_by": 13, "updated_by": null }, { "nl_id": 96326, "nl_ordertempid": null, "nl_orderid": 27855, "nl_notescategory": 1, "nl_type": 4, "nl_platform": 3, "nl_desc": "payment added against invoice no (22317) amount (622)", "nl_manualNotes": "", "nl_createdby": "13", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 1, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "96326", "nl_endddate": 1743120000, "nl_starttime": 1743438534, "created_at": 1743179334, "updated_at": 1743179334, "created_by": 13, "updated_by": null }, { "nl_id": 96327, "nl_ordertempid": null, "nl_orderid": 27811, "nl_notescategory": 1, "nl_type": 4, "nl_platform": 3, "nl_desc": "Invoice Created (22318)", "nl_manualNotes": "", "nl_createdby": "28", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 1, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "96327", "nl_endddate": 1743120000, "nl_starttime": 1743438657, "created_at": 1743179457, "updated_at": 1743179457, "created_by": 28, "updated_by": null }, { "nl_id": 96328, "nl_ordertempid": null, "nl_orderid": 27811, "nl_notescategory": 1, "nl_type": 4, "nl_platform": 3, "nl_desc": "payment added against invoice no (22318) amount (742.500)", "nl_manualNotes": "", "nl_createdby": "28", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 1, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "96328", "nl_endddate": 1743120000, "nl_starttime": 1743438658, "created_at": 1743179458, "updated_at": 1743179458, "created_by": 28, "updated_by": null }, { "nl_id": 96329, "nl_ordertempid": null, "nl_orderid": 27811, "nl_notescategory": 1, "nl_type": 4, "nl_platform": 3, "nl_desc": "payment added against invoice no (22318) amount (742.5)", "nl_manualNotes": "", "nl_createdby": "28", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 1, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "96329", "nl_endddate": 1743120000, "nl_starttime": 1743438658, "created_at": 1743179458, "updated_at": 1743179458, "created_by": 28, "updated_by": null }, { "nl_id": 96330, "nl_ordertempid": null, "nl_orderid": 27892, "nl_notescategory": 1, "nl_type": 4, "nl_platform": 3, "nl_desc": "Invoice Created (22319)", "nl_manualNotes": "", "nl_createdby": "28", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 1, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "96330", "nl_endddate": 1743120000, "nl_starttime": 1743438700, "created_at": 1743179500, "updated_at": 1743179500, "created_by": 28, "updated_by": null }, { "nl_id": 96331, "nl_ordertempid": null, "nl_orderid": 27892, "nl_notescategory": 1, "nl_type": 4, "nl_platform": 3, "nl_desc": "payment added against invoice no (22319) amount (322.500)", "nl_manualNotes": "", "nl_createdby": "28", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 1, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "96331", "nl_endddate": 1743120000, "nl_starttime": 1743438700, "created_at": 1743179500, "updated_at": 1743179500, "created_by": 28, "updated_by": null }, { "nl_id": 96332, "nl_ordertempid": null, "nl_orderid": 27892, "nl_notescategory": 1, "nl_type": 4, "nl_platform": 3, "nl_desc": "payment added against invoice no (22319) amount (311.86)", "nl_manualNotes": "", "nl_createdby": "28", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 1, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "96332", "nl_endddate": 1743120000, "nl_starttime": 1743438700, "created_at": 1743179500, "updated_at": 1743179500, "created_by": 28, "updated_by": null }, { "nl_id": 96333, "nl_ordertempid": 0, "nl_orderid": 28061, "nl_notescategory": 1, "nl_type": 16, "nl_platform": 2, "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": "96333", "nl_endddate": 1743120000, "nl_starttime": 1743432762, "created_at": 1743173562, "updated_at": 1743401231, "created_by": 1, "updated_by": null }, { "nl_id": 96334, "nl_ordertempid": 0, "nl_orderid": 28062, "nl_notescategory": 1, "nl_type": 16, "nl_platform": 2, "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": "96334", "nl_endddate": 1743120000, "nl_starttime": 1743432795, "created_at": 1743173595, "updated_at": 1743401231, "created_by": 1, "updated_by": null }, { "nl_id": 96335, "nl_ordertempid": 0, "nl_orderid": 28063, "nl_notescategory": 1, "nl_type": 16, "nl_platform": 2, "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": "96335", "nl_endddate": 1743120000, "nl_starttime": 1743433009, "created_at": 1743173809, "updated_at": 1743401231, "created_by": 1, "updated_by": null } ], "updated": [], "deleted": [] }, "bm_deliveryaddresssetting": { "created": [], "updated": [], "deleted": [] }, "bm_jobchecklist": { "created": [], "updated": [], "deleted": [] }, "bm_Invoice": { "created": [ { "invoice_id": 22347, "job_id": 27855, "customer_id": 2688, "ref_no": "22317", "invoice_type": 1, "invoice_split_type": 0, "invoice_split_cal": 0, "invoice_split_cal_value": "0.000", "net_amount": "1036.670", "vat_amount": "207.330", "gross_amount": "1244.000", "delivery_amount": "0.000", "delivery": 0, "commission_amount": "0.000", "commission": 0, "total_amount": "1244.000", "split_net_amount": "0.000", "split_vat_amount": "0.000", "outstanding_amount": "0.000", "paid_amount": "1244.000", "paid_status": 3, "status": 0, "transfer": 0, "transfer_id": null, "id": "22347", "paymentDueDate": 1743120000, "invoiceDate": 1743120000, "transferDate": null, "createdat": 1743179334, "updatedat": 1743179334, "createdby": 13, "updatedby": 13 }, { "invoice_id": 22348, "job_id": 27811, "customer_id": 2710, "ref_no": "22318", "invoice_type": 1, "invoice_split_type": 0, "invoice_split_cal": 0, "invoice_split_cal_value": "0.000", "net_amount": "1237.500", "vat_amount": "247.500", "gross_amount": "1485.000", "delivery_amount": "0.000", "delivery": 0, "commission_amount": "0.000", "commission": 0, "total_amount": "1485.000", "split_net_amount": "0.000", "split_vat_amount": "0.000", "outstanding_amount": "0.000", "paid_amount": "1485.000", "paid_status": 3, "status": 0, "transfer": 0, "transfer_id": null, "id": "22348", "paymentDueDate": 1743120000, "invoiceDate": 1743120000, "transferDate": null, "createdat": 1743179457, "updatedat": 1743179458, "createdby": 28, "updatedby": 28 }, { "invoice_id": 22349, "job_id": 27892, "customer_id": 2761, "ref_no": "22319", "invoice_type": 1, "invoice_split_type": 0, "invoice_split_cal": 0, "invoice_split_cal_value": "0.000", "net_amount": "528.630", "vat_amount": "105.730", "gross_amount": "634.360", "delivery_amount": "0.000", "delivery": 0, "commission_amount": "0.000", "commission": 0, "total_amount": "634.360", "split_net_amount": "0.000", "split_vat_amount": "0.000", "outstanding_amount": "0.000", "paid_amount": "634.360", "paid_status": 3, "status": 0, "transfer": 0, "transfer_id": null, "id": "22349", "paymentDueDate": 1743120000, "invoiceDate": 1743120000, "transferDate": null, "createdat": 1743179500, "updatedat": 1743179500, "createdby": 28, "updatedby": 28 } ], "updated": [ { "invoice_id": 22347, "job_id": 27855, "customer_id": 2688, "ref_no": "22317", "invoice_type": 1, "invoice_split_type": 0, "invoice_split_cal": 0, "invoice_split_cal_value": "0.000", "net_amount": "1036.670", "vat_amount": "207.330", "gross_amount": "1244.000", "delivery_amount": "0.000", "delivery": 0, "commission_amount": "0.000", "commission": 0, "total_amount": "1244.000", "split_net_amount": "0.000", "split_vat_amount": "0.000", "outstanding_amount": "0.000", "paid_amount": "1244.000", "paid_status": 3, "status": 0, "transfer": 0, "transfer_id": null, "id": "22347", "paymentDueDate": 1743120000, "invoiceDate": 1743120000, "transferDate": null, "createdat": 1743179334, "updatedat": 1743179334, "createdby": 13, "updatedby": 13 }, { "invoice_id": 22348, "job_id": 27811, "customer_id": 2710, "ref_no": "22318", "invoice_type": 1, "invoice_split_type": 0, "invoice_split_cal": 0, "invoice_split_cal_value": "0.000", "net_amount": "1237.500", "vat_amount": "247.500", "gross_amount": "1485.000", "delivery_amount": "0.000", "delivery": 0, "commission_amount": "0.000", "commission": 0, "total_amount": "1485.000", "split_net_amount": "0.000", "split_vat_amount": "0.000", "outstanding_amount": "0.000", "paid_amount": "1485.000", "paid_status": 3, "status": 0, "transfer": 0, "transfer_id": null, "id": "22348", "paymentDueDate": 1743120000, "invoiceDate": 1743120000, "transferDate": null, "createdat": 1743179457, "updatedat": 1743179458, "createdby": 28, "updatedby": 28 }, { "invoice_id": 22349, "job_id": 27892, "customer_id": 2761, "ref_no": "22319", "invoice_type": 1, "invoice_split_type": 0, "invoice_split_cal": 0, "invoice_split_cal_value": "0.000", "net_amount": "528.630", "vat_amount": "105.730", "gross_amount": "634.360", "delivery_amount": "0.000", "delivery": 0, "commission_amount": "0.000", "commission": 0, "total_amount": "634.360", "split_net_amount": "0.000", "split_vat_amount": "0.000", "outstanding_amount": "0.000", "paid_amount": "634.360", "paid_status": 3, "status": 0, "transfer": 0, "transfer_id": null, "id": "22349", "paymentDueDate": 1743120000, "invoiceDate": 1743120000, "transferDate": null, "createdat": 1743179500, "updatedat": 1743179500, "createdby": 28, "updatedby": 28 } ], "deleted": [] }, "bm_InvoiceDetails": { "created": [ { "ind_id": 71681, "ind_invoice_id": 22347, "ind_order_id": 84141, "ind_qty": 1, "ind_net_amount": "186.620", "ind_vat_amount": "37.320", "ind_gross_amount": "223.940", "ind_status": 0, "id": "71681", "ind_createdat": 1743179334, "ind_updatedat": 1743179334, "ind_createdby": 13, "ind_updatedby": null }, { "ind_id": 71682, "ind_invoice_id": 22347, "ind_order_id": 84142, "ind_qty": 1, "ind_net_amount": "554.400", "ind_vat_amount": "110.880", "ind_gross_amount": "665.280", "ind_status": 0, "id": "71682", "ind_createdat": 1743179334, "ind_updatedat": 1743179334, "ind_createdby": 13, "ind_updatedby": null }, { "ind_id": 71683, "ind_invoice_id": 22347, "ind_order_id": 84143, "ind_qty": 1, "ind_net_amount": "554.400", "ind_vat_amount": "110.880", "ind_gross_amount": "665.280", "ind_status": 0, "id": "71683", "ind_createdat": 1743179334, "ind_updatedat": 1743179334, "ind_createdby": 13, "ind_updatedby": null }, { "ind_id": 71684, "ind_invoice_id": 22348, "ind_order_id": 83996, "ind_qty": 1, "ind_net_amount": "0.000", "ind_vat_amount": "0.000", "ind_gross_amount": "0.000", "ind_status": 0, "id": "71684", "ind_createdat": 1743179457, "ind_updatedat": 1743179457, "ind_createdby": 28, "ind_updatedby": null }, { "ind_id": 71685, "ind_invoice_id": 22348, "ind_order_id": 83997, "ind_qty": 1, "ind_net_amount": "0.000", "ind_vat_amount": "0.000", "ind_gross_amount": "0.000", "ind_status": 0, "id": "71685", "ind_createdat": 1743179457, "ind_updatedat": 1743179457, "ind_createdby": 28, "ind_updatedby": null }, { "ind_id": 71686, "ind_invoice_id": 22348, "ind_order_id": 83998, "ind_qty": 1, "ind_net_amount": "0.000", "ind_vat_amount": "0.000", "ind_gross_amount": "0.000", "ind_status": 0, "id": "71686", "ind_createdat": 1743179458, "ind_updatedat": 1743179458, "ind_createdby": 28, "ind_updatedby": null }, { "ind_id": 71687, "ind_invoice_id": 22349, "ind_order_id": 84360, "ind_qty": 1, "ind_net_amount": "129.940", "ind_vat_amount": "25.990", "ind_gross_amount": "155.930", "ind_status": 0, "id": "71687", "ind_createdat": 1743179500, "ind_updatedat": 1743179500, "ind_createdby": 28, "ind_updatedby": null }, { "ind_id": 71688, "ind_invoice_id": 22349, "ind_order_id": 84361, "ind_qty": 1, "ind_net_amount": "129.940", "ind_vat_amount": "25.990", "ind_gross_amount": "155.930", "ind_status": 0, "id": "71688", "ind_createdat": 1743179500, "ind_updatedat": 1743179500, "ind_createdby": 28, "ind_updatedby": null }, { "ind_id": 71689, "ind_invoice_id": 22349, "ind_order_id": 84362, "ind_qty": 1, "ind_net_amount": "199.990", "ind_vat_amount": "40.000", "ind_gross_amount": "239.990", "ind_status": 0, "id": "71689", "ind_createdat": 1743179500, "ind_updatedat": 1743179500, "ind_createdby": 28, "ind_updatedby": null }, { "ind_id": 71690, "ind_invoice_id": 22349, "ind_order_id": 84363, "ind_qty": 1, "ind_net_amount": "148.150", "ind_vat_amount": "29.630", "ind_gross_amount": "177.780", "ind_status": 0, "id": "71690", "ind_createdat": 1743179500, "ind_updatedat": 1743179500, "ind_createdby": 28, "ind_updatedby": null } ], "updated": [], "deleted": [] }, "bm_invoice_credit_note": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNote": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNoteDetails": { "created": [], "updated": [], "deleted": [] }, "bm_job_paymentlist": { "created": [], "updated": [ { "jp_id": 28, "jp_job_id": 27811, "jp_amount": "742.500", "jp_amountoutstanding": "0.000", "jp_paymentmethod": 5, "jp_paymentcategory": 1, "jp_paymenttype": 8, "jp_surchargetype": 0, "jp_surchargemethod": 0, "jp_surchargeamount": "0.000", "jp_surchargevalue": "0.000", "jp_surchargetotal": "0.000", "jp_userid": 57, "jp_decription": "", "jp_deviceplatform": 0, "jp_status": 0, "jp_transfer": 0, "jp_transfer_id": null, "id": "28", "jp_paiddate": 1731369600, "jp_createdat": 1739555014, "jp_updatedat": 1743179458, "jp_createdby": 1, "jp_updatedby": 28 }, { "jp_id": 34, "jp_job_id": 27855, "jp_amount": "622.000", "jp_amountoutstanding": "0.000", "jp_paymentmethod": 16, "jp_paymentcategory": 1, "jp_paymenttype": 8, "jp_surchargetype": 0, "jp_surchargemethod": 0, "jp_surchargeamount": "0.000", "jp_surchargevalue": "0.000", "jp_surchargetotal": "0.000", "jp_userid": 28, "jp_decription": "", "jp_deviceplatform": 0, "jp_status": 0, "jp_transfer": 0, "jp_transfer_id": null, "id": "34", "jp_paiddate": 1736208000, "jp_createdat": 1739555044, "jp_updatedat": 1743179334, "jp_createdby": 1, "jp_updatedby": 13 }, { "jp_id": 35, "jp_job_id": 27855, "jp_amount": "622.000", "jp_amountoutstanding": "0.000", "jp_paymentmethod": 16, "jp_paymentcategory": 1, "jp_paymenttype": 21, "jp_surchargetype": 0, "jp_surchargemethod": 0, "jp_surchargeamount": "0.000", "jp_surchargevalue": "0.000", "jp_surchargetotal": "0.000", "jp_userid": 28, "jp_decription": "", "jp_deviceplatform": 0, "jp_status": 0, "jp_transfer": 0, "jp_transfer_id": null, "id": "35", "jp_paiddate": 1738713600, "jp_createdat": 1739555044, "jp_updatedat": 1743179335, "jp_createdby": 1, "jp_updatedby": 13 }, { "jp_id": 86, "jp_job_id": 27892, "jp_amount": "322.500", "jp_amountoutstanding": "0.000", "jp_paymentmethod": 5, "jp_paymentcategory": 1, "jp_paymenttype": 8, "jp_surchargetype": 0, "jp_surchargemethod": 0, "jp_surchargeamount": "0.000", "jp_surchargevalue": "0.000", "jp_surchargetotal": "322.500", "jp_userid": 57, "jp_decription": "", "jp_deviceplatform": 0, "jp_status": 0, "jp_transfer": 0, "jp_transfer_id": null, "id": "86", "jp_paiddate": 1740355200, "jp_createdat": 1740411939, "jp_updatedat": 1743179500, "jp_createdby": 57, "jp_updatedby": 28 }, { "jp_id": 101, "jp_job_id": 27811, "jp_amount": "742.500", "jp_amountoutstanding": "0.000", "jp_paymentmethod": 14, "jp_paymentcategory": 1, "jp_paymenttype": 21, "jp_surchargetype": 0, "jp_surchargemethod": 0, "jp_surchargeamount": "0.000", "jp_surchargevalue": "0.000", "jp_surchargetotal": "742.500", "jp_userid": 28, "jp_decription": "", "jp_deviceplatform": 0, "jp_status": 0, "jp_transfer": 0, "jp_transfer_id": null, "id": "101", "jp_paiddate": 1740700800, "jp_createdat": 1740734278, "jp_updatedat": 1743179458, "jp_createdby": 28, "jp_updatedby": 28 }, { "jp_id": 139, "jp_job_id": 27892, "jp_amount": "311.860", "jp_amountoutstanding": "0.000", "jp_paymentmethod": 16, "jp_paymentcategory": 1, "jp_paymenttype": 10, "jp_surchargetype": 0, "jp_surchargemethod": 0, "jp_surchargeamount": "0.000", "jp_surchargevalue": "0.000", "jp_surchargetotal": "311.860", "jp_userid": 16, "jp_decription": "", "jp_deviceplatform": 0, "jp_status": 0, "jp_transfer": 0, "jp_transfer_id": null, "id": "139", "jp_paiddate": 1743033600, "jp_createdat": 1743083810, "jp_updatedat": 1743179500, "jp_createdby": 16, "jp_updatedby": 28 } ], "deleted": [] }, "bm_OverPayment": { "created": [], "updated": [], "deleted": [] }, "bm_terms": { "created": [], "updated": [], "deleted": [] }, "bm_jobmultiquote": { "created": [ { "jmq_id": 28035, "jmq_jobid": 28061, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "0.00", "jmq_netprice": "0.00", "jmq_vat": "0.00", "jmq_isvaton": 1, "jmq_deliverycost": "0.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 1, "jmq_orderformprice": "0.00", "jmq_editpricebyid": null, "jmq_isroundon": 0, "jmq_grossprice": "0.00", "jmq_grossprofit": "0.00", "jmq_costprice": "0.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "0.00", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": null, "jmq_deliverycostid": 0, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 0, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 0, "jmq_endcustomeroverridevalue": null, "jmq_endcustomeroverridenetprice": "0.00", "jmq_endcustomeroverridevatprice": "0.00", "jmq_endcustomeroverridegrossprice": "0.00", "jmq_endcustomerdeliverycost": null, "jmq_endcustomerdeliverycostinclvat": 0, "jmq_endcustomerfittingcost": null, "jmq_endcustomerfittingcostinclvat": 0, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "20.000", "jmq_cdeliveryvatperc": "20.000", "id": "28035", "jmq_duedate": 1743120000, "jmq_sceduleddate": null, "jmq_createdat": "1743173562.000000", "jmq_updatedat": "1743401231.000000", "jmq_createdby": 1, "jmq_updatedby": 1 }, { "jmq_id": 28036, "jmq_jobid": 28062, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "0.00", "jmq_netprice": "0.00", "jmq_vat": "0.00", "jmq_isvaton": 1, "jmq_deliverycost": "0.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 1, "jmq_orderformprice": "0.00", "jmq_editpricebyid": null, "jmq_isroundon": 0, "jmq_grossprice": "0.00", "jmq_grossprofit": "0.00", "jmq_costprice": "0.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "0.00", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": null, "jmq_deliverycostid": 0, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 0, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 0, "jmq_endcustomeroverridevalue": null, "jmq_endcustomeroverridenetprice": "0.00", "jmq_endcustomeroverridevatprice": "0.00", "jmq_endcustomeroverridegrossprice": "0.00", "jmq_endcustomerdeliverycost": null, "jmq_endcustomerdeliverycostinclvat": 0, "jmq_endcustomerfittingcost": null, "jmq_endcustomerfittingcostinclvat": 0, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "20.000", "jmq_cdeliveryvatperc": "20.000", "id": "28036", "jmq_duedate": null, "jmq_sceduleddate": null, "jmq_createdat": "1743173595.000000", "jmq_updatedat": null, "jmq_createdby": 1, "jmq_updatedby": null }, { "jmq_id": 28037, "jmq_jobid": 28063, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "0.00", "jmq_netprice": "0.00", "jmq_vat": "0.00", "jmq_isvaton": 1, "jmq_deliverycost": "0.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 1, "jmq_orderformprice": "0.00", "jmq_editpricebyid": null, "jmq_isroundon": 0, "jmq_grossprice": "0.00", "jmq_grossprofit": "0.00", "jmq_costprice": "0.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "0.00", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": null, "jmq_deliverycostid": 0, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 0, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 0, "jmq_endcustomeroverridevalue": null, "jmq_endcustomeroverridenetprice": "0.00", "jmq_endcustomeroverridevatprice": "0.00", "jmq_endcustomeroverridegrossprice": "0.00", "jmq_endcustomerdeliverycost": null, "jmq_endcustomerdeliverycostinclvat": 0, "jmq_endcustomerfittingcost": null, "jmq_endcustomerfittingcostinclvat": 0, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "20.000", "jmq_cdeliveryvatperc": "20.000", "id": "28037", "jmq_duedate": null, "jmq_sceduleddate": null, "jmq_createdat": "1743173809.000000", "jmq_updatedat": null, "jmq_createdby": 1, "jmq_updatedby": null } ], "updated": [ { "jmq_id": 28020, "jmq_jobid": 28046, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "3530.68", "jmq_netprice": "2700.00", "jmq_vat": "540.00", "jmq_isvaton": 1, "jmq_deliverycost": "0.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 2, "jmq_orderformprice": "3240.00", "jmq_editpricebyid": 0, "jmq_isroundon": 0, "jmq_grossprice": "3240.00", "jmq_grossprofit": "-830.68", "jmq_costprice": "3530.68", "jmq_overrideprice": "3240.00", "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "3240.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": "3530.68", "jmq_endcustomeroverridevatprice": "706.12", "jmq_endcustomeroverridegrossprice": "4236.80", "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": "20.000", "jmq_cdeliveryvatperc": "20.000", "id": "28020", "jmq_duedate": 1744848000, "jmq_sceduleddate": null, "jmq_createdat": "1742312740.000000", "jmq_updatedat": "1743178660.000000", "jmq_createdby": 28, "jmq_updatedby": 28 }, { "jmq_id": 28029, "jmq_jobid": 28055, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "111.06", "jmq_netprice": "88.33", "jmq_vat": "17.67", "jmq_isvaton": 1, "jmq_deliverycost": "0.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 2, "jmq_orderformprice": "106.00", "jmq_editpricebyid": 0, "jmq_isroundon": 0, "jmq_grossprice": "106.00", "jmq_grossprofit": "-22.73", "jmq_costprice": "111.06", "jmq_overrideprice": "106.00", "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "0.00", "jmq_totpaid": "106.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": "111.06", "jmq_endcustomeroverridevatprice": "22.21", "jmq_endcustomeroverridegrossprice": "133.27", "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": "20.000", "jmq_cdeliveryvatperc": "20.000", "id": "28029", "jmq_duedate": 1743638400, "jmq_sceduleddate": null, "jmq_createdat": "1742824764.000000", "jmq_updatedat": "1743179055.000000", "jmq_createdby": 13, "jmq_updatedby": 13 }, { "jmq_id": 28035, "jmq_jobid": 28061, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "0.00", "jmq_netprice": "0.00", "jmq_vat": "0.00", "jmq_isvaton": 1, "jmq_deliverycost": "0.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 1, "jmq_orderformprice": "0.00", "jmq_editpricebyid": null, "jmq_isroundon": 0, "jmq_grossprice": "0.00", "jmq_grossprofit": "0.00", "jmq_costprice": "0.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "0.00", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": null, "jmq_deliverycostid": 0, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 0, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 0, "jmq_endcustomeroverridevalue": null, "jmq_endcustomeroverridenetprice": "0.00", "jmq_endcustomeroverridevatprice": "0.00", "jmq_endcustomeroverridegrossprice": "0.00", "jmq_endcustomerdeliverycost": null, "jmq_endcustomerdeliverycostinclvat": 0, "jmq_endcustomerfittingcost": null, "jmq_endcustomerfittingcostinclvat": 0, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "20.000", "jmq_cdeliveryvatperc": "20.000", "id": "28035", "jmq_duedate": 1743120000, "jmq_sceduleddate": null, "jmq_createdat": "1743173562.000000", "jmq_updatedat": "1743401231.000000", "jmq_createdby": 1, "jmq_updatedby": 1 } ], "deleted": [] }, "bm_jobstatus_tracks": { "created": [ { "jst_id": 28171, "jst_jobid": 27855, "jst_job_current_status": 7, "id": "28171", "jst_createdat": "1743179331.715470" }, { "jst_id": 28172, "jst_jobid": 27811, "jst_job_current_status": 7, "id": "28172", "jst_createdat": "1743179456.197875" }, { "jst_id": 28173, "jst_jobid": 27892, "jst_job_current_status": 7, "id": "28173", "jst_createdat": "1743179498.869400" }, { "jst_id": 28174, "jst_jobid": 28021, "jst_job_current_status": 7, "id": "28174", "jst_createdat": "1743179510.549923" }, { "jst_id": 28175, "jst_jobid": 28053, "jst_job_current_status": 7, "id": "28175", "jst_createdat": "1743179570.943919" }, { "jst_id": 28176, "jst_jobid": 28061, "jst_job_current_status": 9, "id": "28176", "jst_createdat": "1743401228.740657" }, { "jst_id": 28177, "jst_jobid": 28062, "jst_job_current_status": 9, "id": "28177", "jst_createdat": "1743401229.668915" }, { "jst_id": 28178, "jst_jobid": 28063, "jst_job_current_status": 9, "id": "28178", "jst_createdat": "1743401231.381697" } ], "updated": [], "deleted": [] }, "bm_customindividuallogs": { "created": [ { "cl_id": 3406, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the fields Net Price,VAT Price,Gross Price Amount,Gross Profit,Override Price,Amount Outstanding", "cl_event": "modified", "cl_subjectid": 28018, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 28018, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 28, "cl_changedfrom": "{\"Net Price\":\"747.35\",\"VAT Price\":\"149.47\",\"Gross Price Amount\":\"896.82\",\"Gross Profit\":\"0.00\",\"Amount Outstanding\":\"896.82\"}", "cl_changedto": "{\"Net Price\":\"0.00\",\"VAT Price\":\"0.00\",\"Gross Price Amount\":\"0.00\",\"Gross Profit\":\"-747.35\",\"Override Price\":\"0.00\",\"Amount Outstanding\":\"0.00\"}", "cl_customproperties": "{\"attributes\":{\"jd_netprice\":\"0.00\",\"jd_vat\":\"0.00\",\"jd_grossprice\":\"0.00\",\"jd_grossprofit\":\"-747.35\",\"jd_overrideprice\":\"0.00\",\"jd_amountoutstanding\":\"0.00\",\"jd_updatedby\":28,\"jd_updatedat\":\"2025-03-28T15:19:26.000000Z\"},\"old\":{\"jd_netprice\":\"747.35\",\"jd_vat\":\"149.47\",\"jd_grossprice\":\"896.82\",\"jd_grossprofit\":\"0.00\",\"jd_overrideprice\":null,\"jd_amountoutstanding\":\"896.82\",\"jd_updatedby\":13,\"jd_updatedat\":\"2025-03-25T16:33:05.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3406", "cl_createdat": "1743175166.000000", "cl_updatedat": null }, { "cl_id": 3407, "cl_logname": "model", "cl_type": null, "cl_modulename": "Order Status", "cl_message": "Order Status has been updated", "cl_event": "modified", "cl_subjectid": 28018, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 28018, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 28, "cl_changedfrom": "{\"Order Status\":\"Call for Fitting\"}", "cl_changedto": "{\"Order Status\":\"Appointment Confirmed\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3407", "cl_createdat": "1743175175.000000", "cl_updatedat": null }, { "cl_id": 3408, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment", "cl_message": "new item has been created in Appointment", "cl_event": "created", "cl_subjectid": 7846, "cl_subjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_parentid": 28018, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 28, "cl_changedfrom": "null", "cl_changedto": "{\"Repeat On\":\"yearly on March 28\",\"Description\":\"PLEASE CALL ON ROUTE - TRACK \",\"app_summary\":\"ON27910-Steve McLachlan-70 Maurice Avenue-Fitting\",\"Appointment Type\":\"Fitting\",\"Staff\":\"DavidH\",\"Job Ref No\":\"ON27910\",\"Start Date & Time\":\"2025-04-09 08:00:00\",\"End Date & Time\":\"2025-04-09 11:00:00\",\"Appointment Status\":\"Ready\",\"app_deliveryaddressid\":3861,\"app_jobtimehour\":\"3\",\"app_products\":\"[]\"}", "cl_customproperties": "{\"attributes\":{\"app_eventid\":7846,\"app_description\":\"PLEASE CALL ON ROUTE - TRACK \",\"app_summary\":\"ON27910-Steve McLachlan-70 Maurice Avenue-Fitting\",\"app_private\":0,\"app_appointmentType\":3,\"app_userId\":23,\"app_orderId\":28018,\"app_customerId\":0,\"app_isAllDay\":0,\"app_sdate\":\"2025-04-09\",\"app_edate\":\"2025-04-09\",\"app_stime\":\"08:00:00\",\"app_etime\":\"11:00:00\",\"app_sdatetime\":\"2025-04-09 08:00:00\",\"app_edatetime\":\"2025-04-09 11:00:00\",\"app_timezone\":\"Europe\\\/London\",\"app_latitude\":null,\"app_longitude\":null,\"app_parentappid\":null,\"app_recurrencerule\":null,\"app_userdefinedValue\":\"[]\",\"app_recurrenceexception\":null,\"app_recurrenceexception_date\":null,\"app_attachment\":null,\"guid\":\"\",\"app_until\":null,\"app_staff\":\"\",\"app_appointtype\":\"\",\"app_confirmed\":0,\"app_coordinates\":\"\",\"app_travelHour\":\"0\",\"app_travelMinute\":\"00\",\"app_onsiteHour\":\"0\",\"app_onsiteMinute\":\"0\",\"app_location\":null,\"app_traveltime\":null,\"app_googleid\":\"0\",\"app_platform\":\"web\",\"app_cal_status\":844,\"app_status\":0,\"app_markasread\":0,\"app_statusInGoogle\":0,\"app_createdBy\":28,\"app_updatedBy\":null,\"app_createdAt\":\"2025-03-28T15:20:47.000000Z\",\"app_updatedAt\":\"2025-03-28T15:20:47.000000Z\",\"app_runid\":null,\"app_deliveryaddressid\":3861,\"app_jobtimehour\":\"3\",\"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": "3408", "cl_createdat": "1743175247.000000", "cl_updatedat": null }, { "cl_id": 3409, "cl_logname": "default", "cl_type": "QUEUE_3", "cl_modulename": "SMS", "cl_message": "(Fitting Appointment) Sent to 07912256639.", "cl_event": "", "cl_subjectid": 7846, "cl_subjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_parentid": 28018, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 28, "cl_changedfrom": null, "cl_changedto": null, "cl_customproperties": null, "cl_attachment": null, "cl_deviceplatform": null, "cl_deviceipaddress": null, "cl_devicenameversion": null, "cl_devicelocation": null, "cl_causertype": "", "id": "3409", "cl_createdat": "1743175248.000000", "cl_updatedat": "1743175248.000000" }, { "cl_id": 3410, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment", "cl_message": "Appointment is deleted ", "cl_event": "deleted", "cl_subjectid": 7835, "cl_subjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_parentid": 7835, "cl_parentsubjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_causerid": 13, "cl_changedfrom": "{\"app_status\":0}", "cl_changedto": "{\"app_status\":1}", "cl_customproperties": "{\"attributes\":{\"app_status\":1,\"app_updatedBy\":13,\"app_updatedAt\":\"2025-03-28T16:07:10.000000Z\"},\"old\":{\"app_status\":0,\"app_updatedBy\":null,\"app_updatedAt\":\"2025-03-27T10:49:32.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3410", "cl_createdat": "1743178030.000000", "cl_updatedat": null }, { "cl_id": 3411, "cl_logname": "model", "cl_type": null, "cl_modulename": "Production Due Date", "cl_message": "Production Due Date has been updated", "cl_event": "modified", "cl_subjectid": 28046, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 28046, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 13, "cl_changedfrom": "{\"Production Due Date\":\"2025-04-10\"}", "cl_changedto": "{\"Production Due Date\":\"2025-04-17\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3411", "cl_createdat": "1743178660.000000", "cl_updatedat": null }, { "cl_id": 3412, "cl_logname": "model", "cl_type": null, "cl_modulename": "Order Status", "cl_message": "Order Status has been updated", "cl_event": "modified", "cl_subjectid": 28046, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 28046, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 13, "cl_changedfrom": "{\"Order Status\":\"-\"}", "cl_changedto": "{\"Order Status\":\"Ordered In\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3412", "cl_createdat": "1743178660.000000", "cl_updatedat": null }, { "cl_id": 3413, "cl_logname": "default", "cl_type": null, "cl_modulename": "Line Item", "cl_message": "Q1 - Line Item has been updated the field Status for the product of Curtain (Arena Fabric)", "cl_event": "modified", "cl_subjectid": 84142, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 27855, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 13, "cl_changedfrom": "{\"Status\":\"Not Ready\"}", "cl_changedto": "{\"Status\":\"Ready\"}", "cl_customproperties": "{\"attributes\":{\"oi_ready\":1,\"oi_updatedby\":13,\"oi_updatedat\":\"2025-03-28T16:20:58.000000Z\"},\"old\":{\"oi_ready\":0,\"oi_updatedby\":null,\"oi_updatedat\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3413", "cl_createdat": "1743178858.000000", "cl_updatedat": null }, { "cl_id": 3414, "cl_logname": "default", "cl_type": null, "cl_modulename": "Line Item", "cl_message": "Q1 - Line Item has been updated the field Status for the product of Curtain (Arena Fabric)", "cl_event": "modified", "cl_subjectid": 84143, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 27855, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 13, "cl_changedfrom": "{\"Status\":\"Not Ready\"}", "cl_changedto": "{\"Status\":\"Ready\"}", "cl_customproperties": "{\"attributes\":{\"oi_ready\":1,\"oi_updatedby\":13,\"oi_updatedat\":\"2025-03-28T16:21:07.000000Z\"},\"old\":{\"oi_ready\":0,\"oi_updatedby\":null,\"oi_updatedat\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3414", "cl_createdat": "1743178867.000000", "cl_updatedat": null }, { "cl_id": 3415, "cl_logname": "model", "cl_type": null, "cl_modulename": "Order Status", "cl_message": "Order Status has been updated", "cl_event": "modified", "cl_subjectid": 27855, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 27855, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 13, "cl_changedfrom": "{\"Order Status\":\"Part Order\"}", "cl_changedto": "{\"Order Status\":\"Appointment Confirmed\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3415", "cl_createdat": "1743178872.000000", "cl_updatedat": null }, { "cl_id": 3416, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the fields Assigned to,Gross Profit,Gross Profit Percentage", "cl_event": "modified", "cl_subjectid": 27855, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 27855, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 13, "cl_changedfrom": "[]", "cl_changedto": "{\"Assigned to\":1,\"Gross Profit\":\"-258.75\",\"Gross Profit Percentage\":\"-24.96\"}", "cl_customproperties": "{\"attributes\":{\"jd_jobcustomoizedkeyvalue\":\"{\\\"33\\\":25,\\\"37\\\":1,\\\"39\\\":4,\\\"41\\\":54,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"Barbara\\\",\\\"46\\\":\\\"Brown\\\",\\\"47\\\":\\\"07780642369\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"22 Ochiltree \\\",\\\"50\\\":\\\" \\\",\\\"51\\\":\\\"Dunblane \\\",\\\"52\\\":\\\" \\\",\\\"53\\\":\\\"FK15 0DF\\\",\\\"54\\\":19,\\\"285\\\":2,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"GC 7688 BROWN \\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"FITTING 06\\\/02\\\",\\\"551\\\":1,\\\"558\\\":\\\"\\\",\\\"600\\\":\\\"\\\",\\\"601\\\":\\\"\\\",\\\"602\\\":\\\"\\\",\\\"603\\\":\\\"\\\",\\\"604\\\":\\\"\\\",\\\"605\\\":\\\"\\\",\\\"606\\\":\\\"\\\",\\\"607\\\":\\\"\\\",\\\"608\\\":\\\"\\\",\\\"617\\\":\\\"\\\",\\\"618\\\":\\\"\\\",\\\"619\\\":\\\"\\\",\\\"620\\\":\\\"\\\",\\\"622\\\":\\\"\\\",\\\"623\\\":\\\"\\\",\\\"625\\\":\\\"\\\"}\",\"jd_orderstatus\":1,\"jd_listprice\":\"1295.42\",\"jd_grossprofit\":\"-258.75\",\"jd_grossprofit_percentage\":\"-24.96\",\"jd_endcustomeroverridevalue\":\"\",\"jd_endcustomerdeliverycost\":\"\",\"jd_endcustomerfittingcost\":\"\",\"jd_updatedat\":\"2025-03-28T16:21:12.000000Z\"},\"old\":{\"jd_jobcustomoizedkeyvalue\":\"{\\\"33\\\":25,\\\"37\\\":1,\\\"39\\\":4,\\\"41\\\":54,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"Barbara\\\",\\\"46\\\":\\\"Brown\\\",\\\"47\\\":\\\"07780642369\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"22 Ochiltree \\\",\\\"50\\\":\\\" \\\",\\\"51\\\":\\\"Dunblane \\\",\\\"52\\\":\\\" \\\",\\\"53\\\":\\\"FK15 0DF\\\",\\\"54\\\":19,\\\"285\\\":2,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"GC 7688 BROWN \\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"FITTING 06\\\\\\\/02\\\"}\",\"jd_orderstatus\":6,\"jd_listprice\":\"0.00\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_endcustomeroverridevalue\":null,\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerfittingcost\":null,\"jd_updatedat\":\"2025-03-28T16:21:07.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3416", "cl_createdat": "1743178872.000000", "cl_updatedat": null }, { "cl_id": 3417, "cl_logname": "model", "cl_type": null, "cl_modulename": "Production Due Date", "cl_message": "Production Due Date has been updated", "cl_event": "modified", "cl_subjectid": 27878, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 27878, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 13, "cl_changedfrom": "{\"Production Due Date\":\"2025-03-20\"}", "cl_changedto": "{\"Production Due Date\":\"2025-04-24\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3417", "cl_createdat": "1743178941.000000", "cl_updatedat": null }, { "cl_id": 3418, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the fields Assigned to,Gross Profit,Gross Profit Percentage", "cl_event": "modified", "cl_subjectid": 27878, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 27878, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 13, "cl_changedfrom": "[]", "cl_changedto": "{\"Assigned to\":1,\"Gross Profit\":\"901.67\",\"Gross Profit Percentage\":\"100.00\"}", "cl_customproperties": "{\"attributes\":{\"jd_jobcustomoizedkeyvalue\":\"{\\\"33\\\":25,\\\"37\\\":1,\\\"39\\\":4,\\\"41\\\":28,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"Barbara\\\",\\\"46\\\":\\\"Brown\\\",\\\"47\\\":\\\"07780642369\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"22 Ochiltree \\\",\\\"50\\\":\\\" \\\",\\\"51\\\":\\\"Dunblane \\\",\\\"52\\\":\\\" \\\",\\\"53\\\":\\\"FK15 0DF\\\",\\\"54\\\":19,\\\"285\\\":2,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"GC 7689 BROWN \\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":1,\\\"558\\\":\\\"\\\",\\\"600\\\":\\\"\\\",\\\"601\\\":\\\"\\\",\\\"602\\\":\\\"\\\",\\\"603\\\":\\\"\\\",\\\"604\\\":\\\"\\\",\\\"605\\\":\\\"\\\",\\\"606\\\":\\\"\\\",\\\"607\\\":\\\"\\\",\\\"608\\\":\\\"\\\",\\\"617\\\":\\\"\\\",\\\"618\\\":\\\"\\\",\\\"619\\\":\\\"\\\",\\\"620\\\":\\\"\\\",\\\"622\\\":\\\"\\\",\\\"623\\\":\\\"\\\",\\\"625\\\":\\\"\\\"}\",\"jd_duedate\":\"2025-04-24\",\"jd_grossprofit\":\"901.67\",\"jd_grossprofit_percentage\":\"100.00\",\"jd_endcustomeroverridevalue\":\"\",\"jd_endcustomerdeliverycost\":\"\",\"jd_endcustomerfittingcost\":\"\",\"jd_updatedby\":13,\"jd_updatedat\":\"2025-03-28T16:22:20.000000Z\"},\"old\":{\"jd_jobcustomoizedkeyvalue\":\"{\\\"33\\\":25,\\\"37\\\":1,\\\"39\\\":4,\\\"41\\\":28,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"Barbara\\\",\\\"46\\\":\\\"Brown\\\",\\\"47\\\":\\\"07780642369\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"22 Ochiltree \\\",\\\"50\\\":\\\" \\\",\\\"51\\\":\\\"Dunblane \\\",\\\"52\\\":\\\" \\\",\\\"53\\\":\\\"FK15 0DF\\\",\\\"54\\\":19,\\\"285\\\":2,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"GC 7689 BROWN \\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\"}\",\"jd_duedate\":\"2025-03-20\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_endcustomeroverridevalue\":null,\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerfittingcost\":null,\"jd_updatedby\":null,\"jd_updatedat\":\"2025-03-06T08:21:43.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3418", "cl_createdat": "1743178941.000000", "cl_updatedat": null }, { "cl_id": 3419, "cl_logname": "model", "cl_type": null, "cl_modulename": "Production Due Date", "cl_message": "Production Due Date has been updated", "cl_event": "modified", "cl_subjectid": 28055, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 28055, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 13, "cl_changedfrom": "{\"Production Due Date\":\"2025-03-26\"}", "cl_changedto": "{\"Production Due Date\":\"2025-04-03\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3419", "cl_createdat": "1743179055.000000", "cl_updatedat": null }, { "cl_id": 3420, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment", "cl_message": "Appointment has been updated the fields app_summary,Appointment Type", "cl_event": "modified", "cl_subjectid": 7712, "cl_subjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_parentid": 27976, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 16, "cl_changedfrom": "{\"app_summary\":\"ON27879-LAURA BOYLE-55 Hillview Crescent-Administrator\",\"Appointment Type\":\"Administrator\"}", "cl_changedto": "{\"app_summary\":\"ON27879-LAURA BOYLE-55 Hillview Crescent-Sales\",\"Appointment Type\":\"Sales\"}", "cl_customproperties": "{\"attributes\":{\"app_summary\":\"ON27879-LAURA BOYLE-55 Hillview Crescent-Sales\",\"app_appointmentType\":6,\"app_updatedBy\":16,\"app_updatedAt\":\"2025-03-28T16:26:21.000000Z\"},\"old\":{\"app_summary\":\"ON27879-LAURA BOYLE-55 Hillview Crescent-Administrator\",\"app_appointmentType\":1,\"app_updatedBy\":28,\"app_updatedAt\":\"2025-03-03T10:32:55.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3420", "cl_createdat": "1743179181.000000", "cl_updatedat": null }, { "cl_id": 3421, "cl_logname": "default", "cl_type": "QUEUE_1", "cl_modulename": "SMS", "cl_message": "(Sales Appointment) Sent to 07801366264.", "cl_event": "", "cl_subjectid": 7712, "cl_subjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_parentid": 27976, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 16, "cl_changedfrom": null, "cl_changedto": null, "cl_customproperties": null, "cl_attachment": null, "cl_deviceplatform": null, "cl_deviceipaddress": null, "cl_devicenameversion": null, "cl_devicelocation": null, "cl_causertype": "", "id": "3421", "cl_createdat": "1743179182.000000", "cl_updatedat": "1743179182.000000" }, { "cl_id": 3422, "cl_logname": "model", "cl_type": null, "cl_modulename": "Completed Date", "cl_message": "Completed Date has been updated", "cl_event": "modified", "cl_subjectid": 27855, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 27855, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 13, "cl_changedfrom": "{\"Completed Date\":\"0000-00-00\"}", "cl_changedto": "{\"Completed Date\":\"2025-03-28\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3422", "cl_createdat": "1743179331.000000", "cl_updatedat": null }, { "cl_id": 3423, "cl_logname": "model", "cl_type": null, "cl_modulename": "Job Status", "cl_message": "Job Status has been updated", "cl_event": "modified", "cl_subjectid": 27855, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 27855, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 13, "cl_changedfrom": "{\"Job Status\":\"Order\"}", "cl_changedto": "{\"Job Status\":\"Completed\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3423", "cl_createdat": "1743179331.000000", "cl_updatedat": null }, { "cl_id": 3424, "cl_logname": "model", "cl_type": null, "cl_modulename": "Invoice Date", "cl_message": "Invoice Date has been updated", "cl_event": "modified", "cl_subjectid": 27855, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 27855, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 13, "cl_changedfrom": "{\"Invoice Date\":\"0000-00-00\"}", "cl_changedto": "{\"Invoice Date\":\"2025-03-28\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3424", "cl_createdat": "1743179334.000000", "cl_updatedat": null }, { "cl_id": 3425, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the field Invoice No", "cl_event": "modified", "cl_subjectid": 27855, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 27855, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 13, "cl_changedfrom": "[]", "cl_changedto": "{\"Invoice No\":\"22317\"}", "cl_customproperties": "{\"attributes\":{\"jd_invoicedate\":\"2025-03-28\",\"jd_invoiceno\":\"22317\",\"jd_updatedat\":\"2025-03-28T16:28:54.000000Z\"},\"old\":{\"jd_invoicedate\":\"0000-00-00\",\"jd_invoiceno\":\"\",\"jd_updatedat\":\"2025-03-28T16:28:51.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3425", "cl_createdat": "1743179334.000000", "cl_updatedat": null }, { "cl_id": 3426, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 96324, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 27855, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 13, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Ecommerce\",\"Description\":\"Invoice Created (22317)\",\"Created By\":\"Graeme\",\"Date\":\"2025-03-28\",\"Time\":\"16:28:54\",\"Is online note\":\"Yes\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":96324,\"nl_ordertempid\":null,\"nl_orderid\":27855,\"nl_notescategory\":1,\"nl_type\":4,\"nl_platform\":3,\"nl_desc\":\"Invoice Created (22317)\",\"nl_manualNotes\":\"\",\"nl_createdby\":\"13\",\"nl_endddate\":\"2025-03-28\",\"nl_starttime\":\"16:28:54\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":1,\"nl_seq\":0,\"nl_status\":0,\"created_by\":13,\"created_at\":\"2025-03-28T16:28:54.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-03-28T16:28:54.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3426", "cl_createdat": "1743179334.000000", "cl_updatedat": null }, { "cl_id": 3427, "cl_logname": "default", "cl_type": null, "cl_modulename": "Payments", "cl_message": "new item has been created in Payments", "cl_event": "created", "cl_subjectid": 2856, "cl_subjecttype": "App\\Models\\Payment\\bm_paymentlist", "cl_parentid": 2856, "cl_parentsubjecttype": "App\\Models\\Payment\\bm_paymentlist", "cl_causerid": 13, "cl_changedfrom": "null", "cl_changedto": "{\"Order Id\":\"0\",\"pl_invoice_id\":22347,\"pl_customer_id\":2688,\"pl_overpayment_id\":0,\"pl_jobpayment_id\":34,\"Amount\":\"622.00\",\"Payment Method\":\"Visa\",\"Payment Type\":\"Deposit\",\"pl_surchargetype\":0,\"pl_surchargemethod\":0,\"pl_surchargeamount\":\"0.00\",\"pl_surchargevalue\":\"0.00\",\"pl_surchargetotal\":\"622.00\",\"User Entered\":\"DebbieY\",\"Paid Date\":\"2025-01-07\",\"pl_myob_flag\":0,\"pl_qbo_flag\":0}", "cl_customproperties": "{\"attributes\":{\"pl_id\":2856,\"pl_orderid\":\"0\",\"pl_invoice_id\":22347,\"pl_customer_id\":2688,\"pl_overpayment_id\":0,\"pl_jobpayment_id\":34,\"pl_amount\":\"622.00\",\"pl_paymentmethod\":16,\"pl_paymentcategory\":1,\"pl_paymenttype\":8,\"pl_surchargetype\":0,\"pl_surchargemethod\":0,\"pl_surchargeamount\":\"0.00\",\"pl_surchargevalue\":\"0.00\",\"pl_surchargetotal\":\"622.00\",\"pl_userid\":\"28\",\"pl_paiddate\":\"2025-01-07\",\"pl_decription\":\"\",\"pl_paymentinvoice\":null,\"pl_paymentstatus\":0,\"pl_xero_flag\":0,\"pl_xerooverpaymentid\":\"\",\"pl_seq\":0,\"pl_status\":0,\"pl_refundtype\":null,\"created_by\":13,\"created_at\":\"2025-03-28T16:28:54.000000Z\",\"updated_by\":null,\"updated_at\":null,\"pl_deviceplatform\":0,\"pl_myob_flag\":0,\"pl_qbo_flag\":0}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3427", "cl_createdat": "1743179334.000000", "cl_updatedat": null }, { "cl_id": 3428, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 96325, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 27855, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 13, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Ecommerce\",\"Description\":\"payment added against invoice no (22317) amount (622.000)\",\"Created By\":\"Graeme\",\"Date\":\"2025-03-28\",\"Time\":\"16:28:54\",\"Is online note\":\"Yes\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":96325,\"nl_ordertempid\":null,\"nl_orderid\":27855,\"nl_notescategory\":1,\"nl_type\":4,\"nl_platform\":3,\"nl_desc\":\"payment added against invoice no (22317) amount (622.000)\",\"nl_manualNotes\":\"\",\"nl_createdby\":\"13\",\"nl_endddate\":\"2025-03-28\",\"nl_starttime\":\"16:28:54\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":1,\"nl_seq\":0,\"nl_status\":0,\"created_by\":13,\"created_at\":\"2025-03-28T16:28:54.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-03-28T16:28:54.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3428", "cl_createdat": "1743179334.000000", "cl_updatedat": null }, { "cl_id": 3429, "cl_logname": "default", "cl_type": null, "cl_modulename": "Payments", "cl_message": "new item has been created in Payments", "cl_event": "created", "cl_subjectid": 2857, "cl_subjecttype": "App\\Models\\Payment\\bm_paymentlist", "cl_parentid": 2857, "cl_parentsubjecttype": "App\\Models\\Payment\\bm_paymentlist", "cl_causerid": 13, "cl_changedfrom": "null", "cl_changedto": "{\"Order Id\":\"0\",\"pl_invoice_id\":22347,\"pl_customer_id\":2688,\"pl_overpayment_id\":0,\"pl_jobpayment_id\":35,\"Amount\":\"622.00\",\"Payment Method\":\"Visa\",\"Payment Type\":\"Pre Paid\",\"pl_surchargetype\":0,\"pl_surchargemethod\":0,\"pl_surchargeamount\":\"0.00\",\"pl_surchargevalue\":\"0.00\",\"pl_surchargetotal\":\"622.00\",\"User Entered\":\"DebbieY\",\"Paid Date\":\"2025-02-05\",\"pl_myob_flag\":0,\"pl_qbo_flag\":0}", "cl_customproperties": "{\"attributes\":{\"pl_id\":2857,\"pl_orderid\":\"0\",\"pl_invoice_id\":22347,\"pl_customer_id\":2688,\"pl_overpayment_id\":0,\"pl_jobpayment_id\":35,\"pl_amount\":\"622.00\",\"pl_paymentmethod\":16,\"pl_paymentcategory\":1,\"pl_paymenttype\":21,\"pl_surchargetype\":0,\"pl_surchargemethod\":0,\"pl_surchargeamount\":\"0.00\",\"pl_surchargevalue\":\"0.00\",\"pl_surchargetotal\":\"622.00\",\"pl_userid\":\"28\",\"pl_paiddate\":\"2025-02-05\",\"pl_decription\":\"\",\"pl_paymentinvoice\":null,\"pl_paymentstatus\":0,\"pl_xero_flag\":0,\"pl_xerooverpaymentid\":\"\",\"pl_seq\":0,\"pl_status\":0,\"pl_refundtype\":null,\"created_by\":13,\"created_at\":\"2025-03-28T16:28:54.000000Z\",\"updated_by\":null,\"updated_at\":null,\"pl_deviceplatform\":0,\"pl_myob_flag\":0,\"pl_qbo_flag\":0}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3429", "cl_createdat": "1743179334.000000", "cl_updatedat": null }, { "cl_id": 3430, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 96326, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 27855, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 13, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Ecommerce\",\"Description\":\"payment added against invoice no (22317) amount (622)\",\"Created By\":\"Graeme\",\"Date\":\"2025-03-28\",\"Time\":\"16:28:54\",\"Is online note\":\"Yes\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":96326,\"nl_ordertempid\":null,\"nl_orderid\":27855,\"nl_notescategory\":1,\"nl_type\":4,\"nl_platform\":3,\"nl_desc\":\"payment added against invoice no (22317) amount (622)\",\"nl_manualNotes\":\"\",\"nl_createdby\":\"13\",\"nl_endddate\":\"2025-03-28\",\"nl_starttime\":\"16:28:54\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":1,\"nl_seq\":0,\"nl_status\":0,\"created_by\":13,\"created_at\":\"2025-03-28T16:28:54.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-03-28T16:28:54.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3430", "cl_createdat": "1743179335.000000", "cl_updatedat": null }, { "cl_id": 3431, "cl_logname": "default", "cl_type": "Manual", "cl_modulename": "SMS", "cl_message": "SMS Sent to 07789961720.", "cl_event": "", "cl_subjectid": 27811, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 27811, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 28, "cl_changedfrom": null, "cl_changedto": null, "cl_customproperties": null, "cl_attachment": null, "cl_deviceplatform": null, "cl_deviceipaddress": null, "cl_devicenameversion": null, "cl_devicelocation": null, "cl_causertype": "", "id": "3431", "cl_createdat": "1743179450.000000", "cl_updatedat": "1743179450.000000" }, { "cl_id": 3432, "cl_logname": "model", "cl_type": null, "cl_modulename": "Completed Date", "cl_message": "Completed Date has been updated", "cl_event": "modified", "cl_subjectid": 27811, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 27811, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 28, "cl_changedfrom": "{\"Completed Date\":\"0000-00-00\"}", "cl_changedto": "{\"Completed Date\":\"2025-03-28\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3432", "cl_createdat": "1743179456.000000", "cl_updatedat": null }, { "cl_id": 3433, "cl_logname": "model", "cl_type": null, "cl_modulename": "Job Status", "cl_message": "Job Status has been updated", "cl_event": "modified", "cl_subjectid": 27811, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 27811, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 28, "cl_changedfrom": "{\"Job Status\":\"Order\"}", "cl_changedto": "{\"Job Status\":\"Completed\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3433", "cl_createdat": "1743179456.000000", "cl_updatedat": null }, { "cl_id": 3434, "cl_logname": "model", "cl_type": null, "cl_modulename": "Invoice Date", "cl_message": "Invoice Date has been updated", "cl_event": "modified", "cl_subjectid": 27811, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 27811, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 28, "cl_changedfrom": "{\"Invoice Date\":\"0000-00-00\"}", "cl_changedto": "{\"Invoice Date\":\"2025-03-28\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3434", "cl_createdat": "1743179457.000000", "cl_updatedat": null }, { "cl_id": 3435, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the field Invoice No", "cl_event": "modified", "cl_subjectid": 27811, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 27811, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 28, "cl_changedfrom": "[]", "cl_changedto": "{\"Invoice No\":\"22318\"}", "cl_customproperties": "{\"attributes\":{\"jd_invoicedate\":\"2025-03-28\",\"jd_invoiceno\":\"22318\",\"jd_updatedat\":\"2025-03-28T16:30:57.000000Z\"},\"old\":{\"jd_invoicedate\":\"0000-00-00\",\"jd_invoiceno\":\"\",\"jd_updatedat\":\"2025-03-28T16:30:56.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3435", "cl_createdat": "1743179457.000000", "cl_updatedat": null }, { "cl_id": 3436, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 96327, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 27811, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 28, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Ecommerce\",\"Description\":\"Invoice Created (22318)\",\"Created By\":\"DebbieY\",\"Date\":\"2025-03-28\",\"Time\":\"16:30:57\",\"Is online note\":\"Yes\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":96327,\"nl_ordertempid\":null,\"nl_orderid\":27811,\"nl_notescategory\":1,\"nl_type\":4,\"nl_platform\":3,\"nl_desc\":\"Invoice Created (22318)\",\"nl_manualNotes\":\"\",\"nl_createdby\":\"28\",\"nl_endddate\":\"2025-03-28\",\"nl_starttime\":\"16:30:57\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":1,\"nl_seq\":0,\"nl_status\":0,\"created_by\":28,\"created_at\":\"2025-03-28T16:30:57.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-03-28T16:30:57.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3436", "cl_createdat": "1743179457.000000", "cl_updatedat": null }, { "cl_id": 3437, "cl_logname": "default", "cl_type": null, "cl_modulename": "Payments", "cl_message": "new item has been created in Payments", "cl_event": "created", "cl_subjectid": 2858, "cl_subjecttype": "App\\Models\\Payment\\bm_paymentlist", "cl_parentid": 2858, "cl_parentsubjecttype": "App\\Models\\Payment\\bm_paymentlist", "cl_causerid": 28, "cl_changedfrom": "null", "cl_changedto": "{\"Order Id\":\"0\",\"pl_invoice_id\":22348,\"pl_customer_id\":2710,\"pl_overpayment_id\":0,\"pl_jobpayment_id\":28,\"Amount\":\"742.50\",\"Payment Method\":\"Credit Card\",\"Payment Type\":\"Deposit\",\"pl_surchargetype\":0,\"pl_surchargemethod\":0,\"pl_surchargeamount\":\"0.00\",\"pl_surchargevalue\":\"0.00\",\"pl_surchargetotal\":\"742.50\",\"User Entered\":\"RonnieB\",\"Paid Date\":\"2024-11-12\",\"pl_myob_flag\":0,\"pl_qbo_flag\":0}", "cl_customproperties": "{\"attributes\":{\"pl_id\":2858,\"pl_orderid\":\"0\",\"pl_invoice_id\":22348,\"pl_customer_id\":2710,\"pl_overpayment_id\":0,\"pl_jobpayment_id\":28,\"pl_amount\":\"742.50\",\"pl_paymentmethod\":5,\"pl_paymentcategory\":1,\"pl_paymenttype\":8,\"pl_surchargetype\":0,\"pl_surchargemethod\":0,\"pl_surchargeamount\":\"0.00\",\"pl_surchargevalue\":\"0.00\",\"pl_surchargetotal\":\"742.50\",\"pl_userid\":\"57\",\"pl_paiddate\":\"2024-11-12\",\"pl_decription\":\"\",\"pl_paymentinvoice\":null,\"pl_paymentstatus\":0,\"pl_xero_flag\":0,\"pl_xerooverpaymentid\":\"\",\"pl_seq\":0,\"pl_status\":0,\"pl_refundtype\":null,\"created_by\":28,\"created_at\":\"2025-03-28T16:30:58.000000Z\",\"updated_by\":null,\"updated_at\":null,\"pl_deviceplatform\":0,\"pl_myob_flag\":0,\"pl_qbo_flag\":0}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3437", "cl_createdat": "1743179458.000000", "cl_updatedat": null }, { "cl_id": 3438, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 96328, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 27811, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 28, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Ecommerce\",\"Description\":\"payment added against invoice no (22318) amount (742.500)\",\"Created By\":\"DebbieY\",\"Date\":\"2025-03-28\",\"Time\":\"16:30:58\",\"Is online note\":\"Yes\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":96328,\"nl_ordertempid\":null,\"nl_orderid\":27811,\"nl_notescategory\":1,\"nl_type\":4,\"nl_platform\":3,\"nl_desc\":\"payment added against invoice no (22318) amount (742.500)\",\"nl_manualNotes\":\"\",\"nl_createdby\":\"28\",\"nl_endddate\":\"2025-03-28\",\"nl_starttime\":\"16:30:58\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":1,\"nl_seq\":0,\"nl_status\":0,\"created_by\":28,\"created_at\":\"2025-03-28T16:30:58.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-03-28T16:30:58.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3438", "cl_createdat": "1743179458.000000", "cl_updatedat": null }, { "cl_id": 3439, "cl_logname": "default", "cl_type": null, "cl_modulename": "Payments", "cl_message": "new item has been created in Payments", "cl_event": "created", "cl_subjectid": 2859, "cl_subjecttype": "App\\Models\\Payment\\bm_paymentlist", "cl_parentid": 2859, "cl_parentsubjecttype": "App\\Models\\Payment\\bm_paymentlist", "cl_causerid": 28, "cl_changedfrom": "null", "cl_changedto": "{\"Order Id\":\"0\",\"pl_invoice_id\":22348,\"pl_customer_id\":2710,\"pl_overpayment_id\":0,\"pl_jobpayment_id\":101,\"Amount\":\"742.50\",\"Payment Method\":\"stripe\",\"Payment Type\":\"Pre Paid\",\"pl_surchargetype\":0,\"pl_surchargemethod\":0,\"pl_surchargeamount\":\"0.00\",\"pl_surchargevalue\":\"0.00\",\"pl_surchargetotal\":\"742.50\",\"User Entered\":\"DebbieY\",\"Paid Date\":\"2025-02-28\",\"pl_myob_flag\":0,\"pl_qbo_flag\":0}", "cl_customproperties": "{\"attributes\":{\"pl_id\":2859,\"pl_orderid\":\"0\",\"pl_invoice_id\":22348,\"pl_customer_id\":2710,\"pl_overpayment_id\":0,\"pl_jobpayment_id\":101,\"pl_amount\":\"742.50\",\"pl_paymentmethod\":14,\"pl_paymentcategory\":1,\"pl_paymenttype\":21,\"pl_surchargetype\":0,\"pl_surchargemethod\":0,\"pl_surchargeamount\":\"0.00\",\"pl_surchargevalue\":\"0.00\",\"pl_surchargetotal\":\"742.50\",\"pl_userid\":\"28\",\"pl_paiddate\":\"2025-02-28\",\"pl_decription\":\"\",\"pl_paymentinvoice\":null,\"pl_paymentstatus\":0,\"pl_xero_flag\":0,\"pl_xerooverpaymentid\":\"\",\"pl_seq\":0,\"pl_status\":0,\"pl_refundtype\":null,\"created_by\":28,\"created_at\":\"2025-03-28T16:30:58.000000Z\",\"updated_by\":null,\"updated_at\":null,\"pl_deviceplatform\":0,\"pl_myob_flag\":0,\"pl_qbo_flag\":0}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3439", "cl_createdat": "1743179458.000000", "cl_updatedat": null }, { "cl_id": 3440, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 96329, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 27811, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 28, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Ecommerce\",\"Description\":\"payment added against invoice no (22318) amount (742.5)\",\"Created By\":\"DebbieY\",\"Date\":\"2025-03-28\",\"Time\":\"16:30:58\",\"Is online note\":\"Yes\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":96329,\"nl_ordertempid\":null,\"nl_orderid\":27811,\"nl_notescategory\":1,\"nl_type\":4,\"nl_platform\":3,\"nl_desc\":\"payment added against invoice no (22318) amount (742.5)\",\"nl_manualNotes\":\"\",\"nl_createdby\":\"28\",\"nl_endddate\":\"2025-03-28\",\"nl_starttime\":\"16:30:58\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":1,\"nl_seq\":0,\"nl_status\":0,\"created_by\":28,\"created_at\":\"2025-03-28T16:30:58.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-03-28T16:30:58.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3440", "cl_createdat": "1743179458.000000", "cl_updatedat": null }, { "cl_id": 3441, "cl_logname": "model", "cl_type": null, "cl_modulename": "Completed Date", "cl_message": "Completed Date has been updated", "cl_event": "modified", "cl_subjectid": 27892, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 27892, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 28, "cl_changedfrom": "{\"Completed Date\":\"0000-00-00\"}", "cl_changedto": "{\"Completed Date\":\"2025-03-28\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3441", "cl_createdat": "1743179498.000000", "cl_updatedat": null }, { "cl_id": 3442, "cl_logname": "model", "cl_type": null, "cl_modulename": "Job Status", "cl_message": "Job Status has been updated", "cl_event": "modified", "cl_subjectid": 27892, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 27892, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 28, "cl_changedfrom": "{\"Job Status\":\"Order\"}", "cl_changedto": "{\"Job Status\":\"Completed\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3442", "cl_createdat": "1743179498.000000", "cl_updatedat": null }, { "cl_id": 3443, "cl_logname": "model", "cl_type": null, "cl_modulename": "Invoice Date", "cl_message": "Invoice Date has been updated", "cl_event": "modified", "cl_subjectid": 27892, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 27892, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 28, "cl_changedfrom": "{\"Invoice Date\":\"0000-00-00\"}", "cl_changedto": "{\"Invoice Date\":\"2025-03-28\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3443", "cl_createdat": "1743179500.000000", "cl_updatedat": null }, { "cl_id": 3444, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the field Invoice No", "cl_event": "modified", "cl_subjectid": 27892, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 27892, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 28, "cl_changedfrom": "[]", "cl_changedto": "{\"Invoice No\":\"22319\"}", "cl_customproperties": "{\"attributes\":{\"jd_invoicedate\":\"2025-03-28\",\"jd_invoiceno\":\"22319\",\"jd_updatedat\":\"2025-03-28T16:31:40.000000Z\"},\"old\":{\"jd_invoicedate\":\"0000-00-00\",\"jd_invoiceno\":\"\",\"jd_updatedat\":\"2025-03-28T16:31:38.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3444", "cl_createdat": "1743179500.000000", "cl_updatedat": null }, { "cl_id": 3445, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 96330, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 27892, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 28, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Ecommerce\",\"Description\":\"Invoice Created (22319)\",\"Created By\":\"DebbieY\",\"Date\":\"2025-03-28\",\"Time\":\"16:31:40\",\"Is online note\":\"Yes\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":96330,\"nl_ordertempid\":null,\"nl_orderid\":27892,\"nl_notescategory\":1,\"nl_type\":4,\"nl_platform\":3,\"nl_desc\":\"Invoice Created (22319)\",\"nl_manualNotes\":\"\",\"nl_createdby\":\"28\",\"nl_endddate\":\"2025-03-28\",\"nl_starttime\":\"16:31:40\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":1,\"nl_seq\":0,\"nl_status\":0,\"created_by\":28,\"created_at\":\"2025-03-28T16:31:40.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-03-28T16:31:40.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3445", "cl_createdat": "1743179500.000000", "cl_updatedat": null }, { "cl_id": 3446, "cl_logname": "default", "cl_type": null, "cl_modulename": "Payments", "cl_message": "new item has been created in Payments", "cl_event": "created", "cl_subjectid": 2860, "cl_subjecttype": "App\\Models\\Payment\\bm_paymentlist", "cl_parentid": 2860, "cl_parentsubjecttype": "App\\Models\\Payment\\bm_paymentlist", "cl_causerid": 28, "cl_changedfrom": "null", "cl_changedto": "{\"Order Id\":\"0\",\"pl_invoice_id\":22349,\"pl_customer_id\":2761,\"pl_overpayment_id\":0,\"pl_jobpayment_id\":86,\"Amount\":\"322.50\",\"Payment Method\":\"Credit Card\",\"Payment Type\":\"Deposit\",\"pl_surchargetype\":0,\"pl_surchargemethod\":0,\"pl_surchargeamount\":\"0.00\",\"pl_surchargevalue\":\"0.00\",\"pl_surchargetotal\":\"322.50\",\"User Entered\":\"RonnieB\",\"Paid Date\":\"2025-02-24\",\"pl_myob_flag\":0,\"pl_qbo_flag\":0}", "cl_customproperties": "{\"attributes\":{\"pl_id\":2860,\"pl_orderid\":\"0\",\"pl_invoice_id\":22349,\"pl_customer_id\":2761,\"pl_overpayment_id\":0,\"pl_jobpayment_id\":86,\"pl_amount\":\"322.50\",\"pl_paymentmethod\":5,\"pl_paymentcategory\":1,\"pl_paymenttype\":8,\"pl_surchargetype\":0,\"pl_surchargemethod\":0,\"pl_surchargeamount\":\"0.00\",\"pl_surchargevalue\":\"0.00\",\"pl_surchargetotal\":\"322.50\",\"pl_userid\":\"57\",\"pl_paiddate\":\"2025-02-24\",\"pl_decription\":\"\",\"pl_paymentinvoice\":null,\"pl_paymentstatus\":0,\"pl_xero_flag\":0,\"pl_xerooverpaymentid\":\"\",\"pl_seq\":0,\"pl_status\":0,\"pl_refundtype\":null,\"created_by\":28,\"created_at\":\"2025-03-28T16:31:40.000000Z\",\"updated_by\":null,\"updated_at\":null,\"pl_deviceplatform\":0,\"pl_myob_flag\":0,\"pl_qbo_flag\":0}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3446", "cl_createdat": "1743179500.000000", "cl_updatedat": null }, { "cl_id": 3447, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 96331, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 27892, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 28, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Ecommerce\",\"Description\":\"payment added against invoice no (22319) amount (322.500)\",\"Created By\":\"DebbieY\",\"Date\":\"2025-03-28\",\"Time\":\"16:31:40\",\"Is online note\":\"Yes\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":96331,\"nl_ordertempid\":null,\"nl_orderid\":27892,\"nl_notescategory\":1,\"nl_type\":4,\"nl_platform\":3,\"nl_desc\":\"payment added against invoice no (22319) amount (322.500)\",\"nl_manualNotes\":\"\",\"nl_createdby\":\"28\",\"nl_endddate\":\"2025-03-28\",\"nl_starttime\":\"16:31:40\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":1,\"nl_seq\":0,\"nl_status\":0,\"created_by\":28,\"created_at\":\"2025-03-28T16:31:40.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-03-28T16:31:40.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3447", "cl_createdat": "1743179500.000000", "cl_updatedat": null }, { "cl_id": 3448, "cl_logname": "default", "cl_type": null, "cl_modulename": "Payments", "cl_message": "new item has been created in Payments", "cl_event": "created", "cl_subjectid": 2861, "cl_subjecttype": "App\\Models\\Payment\\bm_paymentlist", "cl_parentid": 2861, "cl_parentsubjecttype": "App\\Models\\Payment\\bm_paymentlist", "cl_causerid": 28, "cl_changedfrom": "null", "cl_changedto": "{\"Order Id\":\"0\",\"pl_invoice_id\":22349,\"pl_customer_id\":2761,\"pl_overpayment_id\":0,\"pl_jobpayment_id\":139,\"Amount\":\"311.86\",\"Payment Method\":\"Visa\",\"Payment Type\":\"Final\",\"pl_surchargetype\":0,\"pl_surchargemethod\":0,\"pl_surchargeamount\":\"0.00\",\"pl_surchargevalue\":\"0.00\",\"pl_surchargetotal\":\"311.86\",\"User Entered\":\"Sarah\",\"Paid Date\":\"2025-03-27\",\"pl_myob_flag\":0,\"pl_qbo_flag\":0}", "cl_customproperties": "{\"attributes\":{\"pl_id\":2861,\"pl_orderid\":\"0\",\"pl_invoice_id\":22349,\"pl_customer_id\":2761,\"pl_overpayment_id\":0,\"pl_jobpayment_id\":139,\"pl_amount\":\"311.86\",\"pl_paymentmethod\":16,\"pl_paymentcategory\":1,\"pl_paymenttype\":10,\"pl_surchargetype\":0,\"pl_surchargemethod\":0,\"pl_surchargeamount\":\"0.00\",\"pl_surchargevalue\":\"0.00\",\"pl_surchargetotal\":\"311.86\",\"pl_userid\":\"16\",\"pl_paiddate\":\"2025-03-27\",\"pl_decription\":\"\",\"pl_paymentinvoice\":null,\"pl_paymentstatus\":0,\"pl_xero_flag\":0,\"pl_xerooverpaymentid\":\"\",\"pl_seq\":0,\"pl_status\":0,\"pl_refundtype\":null,\"created_by\":28,\"created_at\":\"2025-03-28T16:31:40.000000Z\",\"updated_by\":null,\"updated_at\":null,\"pl_deviceplatform\":0,\"pl_myob_flag\":0,\"pl_qbo_flag\":0}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3448", "cl_createdat": "1743179500.000000", "cl_updatedat": null }, { "cl_id": 3449, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 96332, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 27892, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 28, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Ecommerce\",\"Description\":\"payment added against invoice no (22319) amount (311.86)\",\"Created By\":\"DebbieY\",\"Date\":\"2025-03-28\",\"Time\":\"16:31:40\",\"Is online note\":\"Yes\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":96332,\"nl_ordertempid\":null,\"nl_orderid\":27892,\"nl_notescategory\":1,\"nl_type\":4,\"nl_platform\":3,\"nl_desc\":\"payment added against invoice no (22319) amount (311.86)\",\"nl_manualNotes\":\"\",\"nl_createdby\":\"28\",\"nl_endddate\":\"2025-03-28\",\"nl_starttime\":\"16:31:40\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":1,\"nl_seq\":0,\"nl_status\":0,\"created_by\":28,\"created_at\":\"2025-03-28T16:31:40.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-03-28T16:31:40.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3449", "cl_createdat": "1743179500.000000", "cl_updatedat": null }, { "cl_id": 3450, "cl_logname": "model", "cl_type": null, "cl_modulename": "Completed Date", "cl_message": "Completed Date has been updated", "cl_event": "modified", "cl_subjectid": 28021, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 28021, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 28, "cl_changedfrom": "{\"Completed Date\":\"0000-00-00\"}", "cl_changedto": "{\"Completed Date\":\"2025-03-28\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3450", "cl_createdat": "1743179510.000000", "cl_updatedat": null }, { "cl_id": 3451, "cl_logname": "model", "cl_type": null, "cl_modulename": "Job Status", "cl_message": "Job Status has been updated", "cl_event": "modified", "cl_subjectid": 28021, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 28021, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 28, "cl_changedfrom": "{\"Job Status\":\"Rework\"}", "cl_changedto": "{\"Job Status\":\"Completed\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3451", "cl_createdat": "1743179510.000000", "cl_updatedat": null }, { "cl_id": 3452, "cl_logname": "model", "cl_type": null, "cl_modulename": "Completed Date", "cl_message": "Completed Date has been updated", "cl_event": "modified", "cl_subjectid": 28053, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 28053, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 28, "cl_changedfrom": "{\"Completed Date\":\"0000-00-00\"}", "cl_changedto": "{\"Completed Date\":\"2025-03-28\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3452", "cl_createdat": "1743179570.000000", "cl_updatedat": null }, { "cl_id": 3453, "cl_logname": "model", "cl_type": null, "cl_modulename": "Job Status", "cl_message": "Job Status has been updated", "cl_event": "modified", "cl_subjectid": 28053, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 28053, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 28, "cl_changedfrom": "{\"Job Status\":\"Rework\"}", "cl_changedto": "{\"Job Status\":\"Completed\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3453", "cl_createdat": "1743179570.000000", "cl_updatedat": null }, { "cl_id": 3454, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment", "cl_message": "new item has been created in Appointment", "cl_event": "created", "cl_subjectid": 7847, "cl_subjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_parentid": 7847, "cl_parentsubjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_causerid": 28, "cl_changedfrom": "null", "cl_changedto": "{\"Repeat On\":\"yearly on March 28\",\"Description\":\"CALL @ RAINBOW \",\"app_summary\":\"Administrator\",\"Private\":\"enabled\",\"Appointment Type\":\"Administrator\",\"Staff\":\"RonnieB\",\"Start Date & Time\":\"2025-04-01 08:00:00\",\"End Date & Time\":\"2025-04-01 11:00:00\",\"Appointment Status\":\"Ready\",\"app_jobtimehour\":\"3\",\"app_products\":\"[]\"}", "cl_customproperties": "{\"attributes\":{\"app_eventid\":7847,\"app_description\":\"CALL @ RAINBOW \",\"app_summary\":\"Administrator\",\"app_private\":1,\"app_appointmentType\":1,\"app_userId\":57,\"app_orderId\":0,\"app_customerId\":0,\"app_isAllDay\":0,\"app_sdate\":\"2025-04-01\",\"app_edate\":\"2025-04-01\",\"app_stime\":\"08:00:00\",\"app_etime\":\"11:00:00\",\"app_sdatetime\":\"2025-04-01 08:00:00\",\"app_edatetime\":\"2025-04-01 11:00:00\",\"app_timezone\":\"Europe\\\/London\",\"app_latitude\":null,\"app_longitude\":null,\"app_parentappid\":null,\"app_recurrencerule\":null,\"app_userdefinedValue\":\"[]\",\"app_recurrenceexception\":null,\"app_recurrenceexception_date\":null,\"app_attachment\":null,\"guid\":\"\",\"app_until\":null,\"app_staff\":\"\",\"app_appointtype\":\"\",\"app_confirmed\":0,\"app_coordinates\":\"\",\"app_travelHour\":\"0\",\"app_travelMinute\":\"00\",\"app_onsiteHour\":\"0\",\"app_onsiteMinute\":\"0\",\"app_location\":null,\"app_traveltime\":null,\"app_googleid\":\"0\",\"app_platform\":\"web\",\"app_cal_status\":844,\"app_status\":0,\"app_markasread\":0,\"app_statusInGoogle\":0,\"app_createdBy\":28,\"app_updatedBy\":null,\"app_createdAt\":\"2025-03-28T16:45:38.000000Z\",\"app_updatedAt\":\"2025-03-28T16:45:38.000000Z\",\"app_runid\":0,\"app_deliveryaddressid\":null,\"app_jobtimehour\":\"3\",\"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": "3454", "cl_createdat": "1743180339.000000", "cl_updatedat": null }, { "cl_id": 3455, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 28061, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 28061, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"Goldcrest Blinds\",\"\":1,\"Account Type\":\"Contract\",\"Source\":\"User Not Chosen\",\"Created By\":\"admin\",\"First Name\":\"Rohit \",\"Last Name\":\"K\",\"Country\":\"UK\",\"Salutation\":\"Mr.\",\"Phone\":\"4578999\",\"Assigned to\":1,\"Additional Contacts\":\"4170\",\"Production Due Date\":\"2025-03-28\",\"Job Ref No\":\"ON27945\",\"Job Status\":\"N\\\/A\",\"Order Status\":\"-\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"jd_isonlineorder\":1,\"Delivery Vat Percentage\":\"20.000\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":28061,\"jd_customerid\":2896,\"jd_contactid\":4170,\"jd_additionalcontacts\":\"4170\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"ON27945\\\",\\\"35\\\":\\\"KROH0001\\\",\\\"36\\\":9,\\\"37\\\":2,\\\"38\\\":\\\"\\\",\\\"39\\\":10,\\\"40\\\":10,\\\"41\\\":1,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"Rohit \\\",\\\"46\\\":\\\"K\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":19,\\\"285\\\":1,\\\"286\\\":\\\"4578999\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":1,\\\"558\\\":\\\"\\\",\\\"600\\\":\\\"\\\",\\\"601\\\":\\\"\\\",\\\"602\\\":\\\"\\\",\\\"603\\\":\\\"\\\",\\\"604\\\":\\\"\\\",\\\"605\\\":\\\"\\\",\\\"606\\\":\\\"\\\",\\\"607\\\":\\\"\\\",\\\"608\\\":\\\"\\\",\\\"617\\\":\\\"\\\",\\\"618\\\":\\\"\\\",\\\"619\\\":\\\"\\\",\\\"620\\\":\\\"\\\",\\\"622\\\":\\\"\\\",\\\"623\\\":\\\"\\\",\\\"625\\\":\\\"\\\",\\\"countryText\\\":\\\"UK\\\",\\\"adminUser\\\":1}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-03-28\",\"jd_orderdate\":null,\"jd_duedate\":\"2025-03-28\",\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":null,\"jd_jobref\":\"ON27945\",\"jd_jobstatus\":9,\"jd_contactaddid\":0,\"jd_orderstatus\":10,\"jd_accref\":\"KROH0001\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"0.00\",\"jd_netprice\":\"0.00\",\"jd_vat\":\"0.00\",\"jd_isvaton\":1,\"jd_deliverycost\":\"0.00\",\"jd_deliverycosttypeid\":1,\"jd_overridetypeid\":1,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":null,\"jd_isroundon\":0,\"jd_grossprice\":\"0.00\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"0.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"0.00\",\"jd_totpaid\":\"0.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":null,\"jd_deliverycostid\":0,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":0,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":0,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":0,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":0,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":1,\"jd_createdat\":\"2025-03-28T14:52:42.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-03-31T06:07:08.000000Z\",\"jd_deviceplatform\":0,\"jd_fromjobref\":\"\",\"jd_fromdbname\":null,\"jd_importorder\":0,\"jd_quickquote\":0,\"jd_myob_flag\":0,\"jd_myobinvoiceid\":\"\",\"jd_qboflag\":0,\"jd_qboinvoiceid\":0,\"jd_qbodisplayname\":\"\",\"jd_deliveryvatperc\":\"20.000\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"20.000\",\"jd_commission\":\"[]\",\"jd_commissionprice\":\"0.00\",\"jd_commissionsetting\":0,\"jd_commissionaddedvalue\":\"0.00\",\"jd_onlineprefixseq\":null,\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":0,\"jd_rework_count\":0,\"salesorderid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3455", "cl_createdat": "1743401228.000000", "cl_updatedat": null }, { "cl_id": 3456, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 28062, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 28062, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"Goldcrest Blinds\",\"\":1,\"Account Type\":\"Domestic\",\"Source\":\"User Not Chosen\",\"Created By\":\"admin\",\"Last Name\":\"Quote 1\",\"Address1\":\"Quote 1\",\"Town \\\/ City\":\"Quote 1\",\"Country\":\"UK\",\"Salutation\":\"Mr.\",\"Assigned to\":1,\"Additional Contacts\":\"4171\",\"Job Ref No\":\"ON27946\",\"Job Status\":\"N\\\/A\",\"Order Status\":\"-\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"jd_isonlineorder\":1,\"jd_quickquote\":1,\"Delivery Vat Percentage\":\"20.000\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":28062,\"jd_customerid\":2897,\"jd_contactid\":4171,\"jd_additionalcontacts\":\"4171\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"ON27946\\\",\\\"35\\\":\\\"QUOT0001\\\",\\\"36\\\":9,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":10,\\\"40\\\":10,\\\"41\\\":1,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"\\\",\\\"46\\\":\\\"Quote 1\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"Quote 1\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"Quote 1\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":19,\\\"285\\\":1,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":1,\\\"558\\\":\\\"\\\",\\\"600\\\":\\\"\\\",\\\"601\\\":\\\"\\\",\\\"602\\\":\\\"\\\",\\\"603\\\":\\\"\\\",\\\"604\\\":\\\"\\\",\\\"605\\\":\\\"\\\",\\\"606\\\":\\\"\\\",\\\"607\\\":\\\"\\\",\\\"608\\\":\\\"\\\",\\\"617\\\":\\\"\\\",\\\"618\\\":\\\"\\\",\\\"619\\\":\\\"\\\",\\\"620\\\":\\\"\\\",\\\"622\\\":\\\"\\\",\\\"623\\\":\\\"\\\",\\\"625\\\":\\\"\\\",\\\"countryText\\\":\\\"UK\\\",\\\"adminUser\\\":1}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-03-28\",\"jd_orderdate\":null,\"jd_duedate\":null,\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":null,\"jd_jobref\":\"ON27946\",\"jd_jobstatus\":9,\"jd_contactaddid\":0,\"jd_orderstatus\":10,\"jd_accref\":\"QUOT0001\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"0.00\",\"jd_netprice\":\"0.00\",\"jd_vat\":\"0.00\",\"jd_isvaton\":1,\"jd_deliverycost\":\"0.00\",\"jd_deliverycosttypeid\":1,\"jd_overridetypeid\":1,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":null,\"jd_isroundon\":0,\"jd_grossprice\":\"0.00\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"0.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"0.00\",\"jd_totpaid\":\"0.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":null,\"jd_deliverycostid\":0,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":0,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":0,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":0,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":0,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":1,\"jd_createdat\":\"2025-03-28T14:53:15.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-03-31T06:07:09.000000Z\",\"jd_deviceplatform\":0,\"jd_fromjobref\":\"\",\"jd_fromdbname\":null,\"jd_importorder\":0,\"jd_quickquote\":1,\"jd_myob_flag\":0,\"jd_myobinvoiceid\":\"\",\"jd_qboflag\":0,\"jd_qboinvoiceid\":0,\"jd_qbodisplayname\":\"\",\"jd_deliveryvatperc\":\"20.000\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"20.000\",\"jd_commission\":\"[]\",\"jd_commissionprice\":\"0.00\",\"jd_commissionsetting\":0,\"jd_commissionaddedvalue\":\"0.00\",\"jd_onlineprefixseq\":null,\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":0,\"jd_rework_count\":0,\"salesorderid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3456", "cl_createdat": "1743401229.000000", "cl_updatedat": null }, { "cl_id": 3457, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 28063, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 28063, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"Goldcrest Blinds\",\"\":1,\"Account Type\":\"Domestic\",\"Source\":\"User Not Chosen\",\"Created By\":\"admin\",\"Last Name\":\"Quote 2\",\"Address1\":\"Quote 2\",\"Town \\\/ City\":\"Quote 2\",\"Country\":\"UK\",\"Salutation\":\"Mr.\",\"Assigned to\":1,\"Additional Contacts\":\"4172\",\"Job Ref No\":\"ON27947\",\"Job Status\":\"N\\\/A\",\"Order Status\":\"-\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"jd_isonlineorder\":1,\"jd_quickquote\":2,\"Delivery Vat Percentage\":\"20.000\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":28063,\"jd_customerid\":2898,\"jd_contactid\":4172,\"jd_additionalcontacts\":\"4172\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"ON27947\\\",\\\"35\\\":\\\"QUOT0002\\\",\\\"36\\\":9,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":10,\\\"40\\\":10,\\\"41\\\":1,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"\\\",\\\"46\\\":\\\"Quote 2\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"Quote 2\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"Quote 2\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":19,\\\"285\\\":1,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":1,\\\"558\\\":\\\"\\\",\\\"600\\\":\\\"\\\",\\\"601\\\":\\\"\\\",\\\"602\\\":\\\"\\\",\\\"603\\\":\\\"\\\",\\\"604\\\":\\\"\\\",\\\"605\\\":\\\"\\\",\\\"606\\\":\\\"\\\",\\\"607\\\":\\\"\\\",\\\"608\\\":\\\"\\\",\\\"617\\\":\\\"\\\",\\\"618\\\":\\\"\\\",\\\"619\\\":\\\"\\\",\\\"620\\\":\\\"\\\",\\\"622\\\":\\\"\\\",\\\"623\\\":\\\"\\\",\\\"625\\\":\\\"\\\",\\\"countryText\\\":\\\"UK\\\",\\\"adminUser\\\":1}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-03-28\",\"jd_orderdate\":null,\"jd_duedate\":null,\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":null,\"jd_jobref\":\"ON27947\",\"jd_jobstatus\":9,\"jd_contactaddid\":0,\"jd_orderstatus\":10,\"jd_accref\":\"QUOT0002\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"0.00\",\"jd_netprice\":\"0.00\",\"jd_vat\":\"0.00\",\"jd_isvaton\":1,\"jd_deliverycost\":\"0.00\",\"jd_deliverycosttypeid\":1,\"jd_overridetypeid\":1,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":null,\"jd_isroundon\":0,\"jd_grossprice\":\"0.00\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"0.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"0.00\",\"jd_totpaid\":\"0.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":null,\"jd_deliverycostid\":0,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":0,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":0,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":0,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":0,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":1,\"jd_createdat\":\"2025-03-28T14:56:49.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-03-31T06:07:11.000000Z\",\"jd_deviceplatform\":0,\"jd_fromjobref\":\"\",\"jd_fromdbname\":null,\"jd_importorder\":0,\"jd_quickquote\":2,\"jd_myob_flag\":0,\"jd_myobinvoiceid\":\"\",\"jd_qboflag\":0,\"jd_qboinvoiceid\":0,\"jd_qbodisplayname\":\"\",\"jd_deliveryvatperc\":\"20.000\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"20.000\",\"jd_commission\":\"[]\",\"jd_commissionprice\":\"0.00\",\"jd_commissionsetting\":0,\"jd_commissionaddedvalue\":\"0.00\",\"jd_onlineprefixseq\":null,\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":0,\"jd_rework_count\":0,\"salesorderid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3457", "cl_createdat": "1743401231.000000", "cl_updatedat": null }, { "cl_id": 3458, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 96333, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 28061, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"Job Created\",\"Platform\":\"Trade\",\"Description\":\"New job has been created in job\",\"Created By\":\"admin\",\"Date\":\"2025-03-28\",\"Time\":\"14:52:42\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":96333,\"nl_ordertempid\":0,\"nl_orderid\":28061,\"nl_notescategory\":1,\"nl_type\":16,\"nl_platform\":2,\"nl_desc\":\"New job has been created in job\",\"nl_manualNotes\":null,\"nl_createdby\":\"1\",\"nl_endddate\":\"2025-03-28\",\"nl_starttime\":\"14:52:42\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":1,\"created_at\":\"2025-03-28T14:52:42.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-03-31T06:07:11.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3458", "cl_createdat": "1743401231.000000", "cl_updatedat": null }, { "cl_id": 3459, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 96334, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 28062, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"Job Created\",\"Platform\":\"Trade\",\"Description\":\"New job has been created in job\",\"Created By\":\"admin\",\"Date\":\"2025-03-28\",\"Time\":\"14:53:15\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":96334,\"nl_ordertempid\":0,\"nl_orderid\":28062,\"nl_notescategory\":1,\"nl_type\":16,\"nl_platform\":2,\"nl_desc\":\"New job has been created in job\",\"nl_manualNotes\":null,\"nl_createdby\":\"1\",\"nl_endddate\":\"2025-03-28\",\"nl_starttime\":\"14:53:15\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":1,\"created_at\":\"2025-03-28T14:53:15.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-03-31T06:07:11.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3459", "cl_createdat": "1743401231.000000", "cl_updatedat": null }, { "cl_id": 3460, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 96335, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 28063, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"Job Created\",\"Platform\":\"Trade\",\"Description\":\"New job has been created in job\",\"Created By\":\"admin\",\"Date\":\"2025-03-28\",\"Time\":\"14:56:49\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":96335,\"nl_ordertempid\":0,\"nl_orderid\":28063,\"nl_notescategory\":1,\"nl_type\":16,\"nl_platform\":2,\"nl_desc\":\"New job has been created in job\",\"nl_manualNotes\":null,\"nl_createdby\":\"1\",\"nl_endddate\":\"2025-03-28\",\"nl_starttime\":\"14:56:49\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":1,\"created_at\":\"2025-03-28T14:56:49.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-03-31T06:07:11.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3460", "cl_createdat": "1743401231.000000", "cl_updatedat": null }, { "cl_id": 3461, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in ON27945", "cl_event": "created", "cl_subjectid": 28035, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 28061, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":28035,\"jmq_jobid\":28061,\"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\":\"0.00\",\"VAT Price\":\"0.00\",\"VAT\":1,\"jmq_deliverycost\":\"0.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"0.00\",\"Gross Profit\":\"0.00\",\"Total CostPrice\":\"0.00\",\"Amount Outstanding\":\"0.00\",\"Total Paid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_deliverycostid\":0,\"Total Cost Price\":0,\"jmq_isonlineorder\":0,\"Is Online Order Submitted\":0,\"End Customer Override Type\":0,\"End Customer Override Net Price\":\"0.00\",\"End Customer Override Vat Price\":\"0.00\",\"End Customer Override Gross Price\":\"0.00\",\"End Customer Delivery Cost Include Vat\":0,\"End Customer Fitting Cost Include Vat\":0,\"Online Delivery Addreddtype\":0,\"Commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"Delivery Vat Percentage\":\"20.000\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":28035,\"jmq_jobid\":28061,\"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\":\"0.00\",\"jmq_vat\":\"0.00\",\"jmq_isvaton\":1,\"jmq_deliverycost\":\"0.00\",\"jmq_deliverycosttypeid\":1,\"jmq_overridetypeid\":1,\"jmq_orderformprice\":\"0.00\",\"jmq_editpricebyid\":null,\"jmq_isroundon\":0,\"jmq_grossprice\":\"0.00\",\"jmq_grossprofit\":\"0.00\",\"jmq_costprice\":\"0.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"0.00\",\"jmq_totpaid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_userdefinedarray\":null,\"jmq_deliverycostid\":0,\"jmq_iscostpriceon\":0,\"jmq_custompricefields\":\"\",\"jmq_isonlineorder\":0,\"jmq_isonlineordersubmitted\":0,\"jmq_endcustomervatprice\":null,\"jmq_endcustomeroverridetype\":0,\"jmq_endcustomeroverridevalue\":null,\"jmq_endcustomeroverridenetprice\":\"0.00\",\"jmq_endcustomeroverridevatprice\":\"0.00\",\"jmq_endcustomeroverridegrossprice\":\"0.00\",\"jmq_endcustomerdeliverycost\":null,\"jmq_endcustomerdeliverycostinclvat\":0,\"jmq_endcustomerfittingcost\":null,\"jmq_endcustomerfittingcostinclvat\":0,\"jmq_onlinedeliveryaddreddtype\":0,\"jmq_onlinedeliveryaddreddid\":null,\"jmq_commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"jmq_deliveryvatperc\":\"20.000\",\"jmq_cdeliveryvatperc\":\"20.000\",\"jmq_createdby\":1,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-03-28T14:52:42.000000Z\",\"jmq_updatedat\":null,\"jmq_grossprofit_percentage\":\"0.00\",\"jmq_ready\":0}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3461", "cl_createdat": "1743401231.000000", "cl_updatedat": null }, { "cl_id": 3462, "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": 28061, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 28061, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":28035}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":28035,\"jd_updatedat\":\"2025-03-31T06:07:11.000000Z\"},\"old\":{\"jd_jobmultiquoteid\":null,\"jd_updatedat\":\"2025-03-31T06:07:08.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3462", "cl_createdat": "1743401231.000000", "cl_updatedat": null }, { "cl_id": 3463, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in ON27946", "cl_event": "created", "cl_subjectid": 28036, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 28062, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":28036,\"jmq_jobid\":28062,\"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\":\"0.00\",\"VAT Price\":\"0.00\",\"VAT\":1,\"jmq_deliverycost\":\"0.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"0.00\",\"Gross Profit\":\"0.00\",\"Total CostPrice\":\"0.00\",\"Amount Outstanding\":\"0.00\",\"Total Paid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_deliverycostid\":0,\"Total Cost Price\":0,\"jmq_isonlineorder\":0,\"Is Online Order Submitted\":0,\"End Customer Override Type\":0,\"End Customer Override Net Price\":\"0.00\",\"End Customer Override Vat Price\":\"0.00\",\"End Customer Override Gross Price\":\"0.00\",\"End Customer Delivery Cost Include Vat\":0,\"End Customer Fitting Cost Include Vat\":0,\"Online Delivery Addreddtype\":0,\"Commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"Delivery Vat Percentage\":\"20.000\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":28036,\"jmq_jobid\":28062,\"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\":\"0.00\",\"jmq_vat\":\"0.00\",\"jmq_isvaton\":1,\"jmq_deliverycost\":\"0.00\",\"jmq_deliverycosttypeid\":1,\"jmq_overridetypeid\":1,\"jmq_orderformprice\":\"0.00\",\"jmq_editpricebyid\":null,\"jmq_isroundon\":0,\"jmq_grossprice\":\"0.00\",\"jmq_grossprofit\":\"0.00\",\"jmq_costprice\":\"0.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"0.00\",\"jmq_totpaid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_userdefinedarray\":null,\"jmq_deliverycostid\":0,\"jmq_iscostpriceon\":0,\"jmq_custompricefields\":\"\",\"jmq_isonlineorder\":0,\"jmq_isonlineordersubmitted\":0,\"jmq_endcustomervatprice\":null,\"jmq_endcustomeroverridetype\":0,\"jmq_endcustomeroverridevalue\":null,\"jmq_endcustomeroverridenetprice\":\"0.00\",\"jmq_endcustomeroverridevatprice\":\"0.00\",\"jmq_endcustomeroverridegrossprice\":\"0.00\",\"jmq_endcustomerdeliverycost\":null,\"jmq_endcustomerdeliverycostinclvat\":0,\"jmq_endcustomerfittingcost\":null,\"jmq_endcustomerfittingcostinclvat\":0,\"jmq_onlinedeliveryaddreddtype\":0,\"jmq_onlinedeliveryaddreddid\":null,\"jmq_commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"jmq_deliveryvatperc\":\"20.000\",\"jmq_cdeliveryvatperc\":\"20.000\",\"jmq_createdby\":1,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-03-28T14:53:15.000000Z\",\"jmq_updatedat\":null,\"jmq_grossprofit_percentage\":\"0.00\",\"jmq_ready\":0}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3463", "cl_createdat": "1743401231.000000", "cl_updatedat": null }, { "cl_id": 3464, "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": 28062, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 28062, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":28036}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":28036,\"jd_updatedat\":\"2025-03-31T06:07:11.000000Z\"},\"old\":{\"jd_jobmultiquoteid\":null,\"jd_updatedat\":\"2025-03-31T06:07:09.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3464", "cl_createdat": "1743401231.000000", "cl_updatedat": null }, { "cl_id": 3465, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in ON27947", "cl_event": "created", "cl_subjectid": 28037, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 28063, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":28037,\"jmq_jobid\":28063,\"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\":\"0.00\",\"VAT Price\":\"0.00\",\"VAT\":1,\"jmq_deliverycost\":\"0.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"0.00\",\"Gross Profit\":\"0.00\",\"Total CostPrice\":\"0.00\",\"Amount Outstanding\":\"0.00\",\"Total Paid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_deliverycostid\":0,\"Total Cost Price\":0,\"jmq_isonlineorder\":0,\"Is Online Order Submitted\":0,\"End Customer Override Type\":0,\"End Customer Override Net Price\":\"0.00\",\"End Customer Override Vat Price\":\"0.00\",\"End Customer Override Gross Price\":\"0.00\",\"End Customer Delivery Cost Include Vat\":0,\"End Customer Fitting Cost Include Vat\":0,\"Online Delivery Addreddtype\":0,\"Commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"Delivery Vat Percentage\":\"20.000\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":28037,\"jmq_jobid\":28063,\"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\":\"0.00\",\"jmq_vat\":\"0.00\",\"jmq_isvaton\":1,\"jmq_deliverycost\":\"0.00\",\"jmq_deliverycosttypeid\":1,\"jmq_overridetypeid\":1,\"jmq_orderformprice\":\"0.00\",\"jmq_editpricebyid\":null,\"jmq_isroundon\":0,\"jmq_grossprice\":\"0.00\",\"jmq_grossprofit\":\"0.00\",\"jmq_costprice\":\"0.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"0.00\",\"jmq_totpaid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_userdefinedarray\":null,\"jmq_deliverycostid\":0,\"jmq_iscostpriceon\":0,\"jmq_custompricefields\":\"\",\"jmq_isonlineorder\":0,\"jmq_isonlineordersubmitted\":0,\"jmq_endcustomervatprice\":null,\"jmq_endcustomeroverridetype\":0,\"jmq_endcustomeroverridevalue\":null,\"jmq_endcustomeroverridenetprice\":\"0.00\",\"jmq_endcustomeroverridevatprice\":\"0.00\",\"jmq_endcustomeroverridegrossprice\":\"0.00\",\"jmq_endcustomerdeliverycost\":null,\"jmq_endcustomerdeliverycostinclvat\":0,\"jmq_endcustomerfittingcost\":null,\"jmq_endcustomerfittingcostinclvat\":0,\"jmq_onlinedeliveryaddreddtype\":0,\"jmq_onlinedeliveryaddreddid\":null,\"jmq_commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"jmq_deliveryvatperc\":\"20.000\",\"jmq_cdeliveryvatperc\":\"20.000\",\"jmq_createdby\":1,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-03-28T14:56:49.000000Z\",\"jmq_updatedat\":null,\"jmq_grossprofit_percentage\":\"0.00\",\"jmq_ready\":0}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3465", "cl_createdat": "1743401231.000000", "cl_updatedat": null }, { "cl_id": 3466, "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": 28063, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 28063, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":28037}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":28037},\"old\":{\"jd_jobmultiquoteid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3466", "cl_createdat": "1743401231.000000", "cl_updatedat": null }, { "cl_id": 3467, "cl_logname": "default", "cl_type": null, "cl_modulename": "Line Item", "cl_message": "Q1 - new item has been created in Line Item for the product of Velux Bloc Blind", "cl_event": "created", "cl_subjectid": 84506, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 28061, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Unit Type\":\" mm\",\" Quantity\":\" 1\",\" Supplier\":\" Velux\",\" Product Type\":\" -V\",\" Width\":\" 588\",\" Drop\":\" 36\",\" Fabric\":\" -\",\" Color\":\" White\",\" Window Code\":\" GGL\"}", "cl_customproperties": "{\"attributes\":{\"oi_id\":84506,\"oi_jobid\":28061,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":28035,\"oi_credit_id\":0,\"oi_productid\":72,\"oi_recipeid\":72,\"oi_ruleid\":0,\"oi_qty\":1,\"oi_seq\":0,\"oi_customseq\":0,\"oi_productcustomseq\":0,\"oi_jsondata\":\"[{\\\"id\\\":13793,\\\"labelname\\\":\\\"Unit Type\\\",\\\"value\\\":2,\\\"valueid\\\":\\\"2\\\",\\\"type\\\":34,\\\"optionid\\\":\\\"2\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":2,\\\"optionname\\\":\\\"mm\\\",\\\"optioncode\\\":\\\"\\\",\\\"optionquantity\\\":1,\\\"unittype\\\":0,\\\"unitcost\\\":0,\\\"pricingtype\\\":0,\\\"fieldoptionlinkid\\\":2,\\\"forchildfieldoptionlinkid\\\":\\\"34_2\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":13792,\\\"labelname\\\":\\\"Quantity\\\",\\\"value\\\":1,\\\"valueid\\\":\\\"\\\",\\\"type\\\":14,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":13794,\\\"labelname\\\":\\\"Supplier\\\",\\\"value\\\":\\\"11\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":17,\\\"optionid\\\":\\\"11\\\",\\\"optionvalue\\\":[{\\\"id\\\":11,\\\"optionid\\\":11,\\\"optionname\\\":\\\"Velux\\\",\\\"deleted\\\":0,\\\"optionquantity\\\":1}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":13795,\\\"labelname\\\":\\\"Product Type\\\",\\\"value\\\":601,\\\"valueid\\\":\\\"601\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"601\\\",\\\"optionvalue\\\":[{\\\"id\\\":601,\\\"fieldid\\\":13795,\\\"fieldoptionlinkid\\\":601,\\\"optionid\\\":601,\\\"mainsupplier\\\":\\\"11\\\",\\\"blindtypecode\\\":\\\"\\\",\\\"optionname\\\":\\\"-V\\\",\\\"optionquantity\\\":1,\\\"subcount\\\":0,\\\"status\\\":0,\\\"subdatacount\\\":0}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":13796,\\\"labelname\\\":\\\"Width\\\",\\\"value\\\":\\\"588\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":11,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":13797,\\\"labelname\\\":\\\"Drop\\\",\\\"value\\\":\\\"36\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":12,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":13798,\\\"labelname\\\":\\\"Fabric\\\",\\\"value\\\":\\\"-\\\",\\\"valueid\\\":\\\"12842\\\",\\\"type\\\":5,\\\"optionid\\\":\\\"12842\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":12842,\\\"optionname\\\":\\\"-\\\",\\\"optioncode\\\":118924,\\\"optionquantity\\\":1,\\\"fieldoptionlinkid\\\":12842,\\\"forchildfieldoptionlinkid\\\":\\\"5_2_12842_1\\\",\\\"optionimage\\\":\\\"\\\",\\\"subdatacount\\\":1,\\\"description\\\":\\\"\\\",\\\"pricegroup\\\":\\\"-V\\\",\\\"pricegroupid\\\":601}],\\\"fabricorcolor\\\":1,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":13799,\\\"labelname\\\":\\\"Color\\\",\\\"value\\\":\\\"White\\\",\\\"valueid\\\":\\\"64501\\\",\\\"type\\\":5,\\\"optionid\\\":\\\"64501\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":64501,\\\"optionname\\\":\\\"White\\\",\\\"optioncode\\\":475770,\\\"optionquantity\\\":1,\\\"fieldoptionlinkid\\\":64501,\\\"forchildfieldoptionlinkid\\\":\\\"5_3_64501_1\\\",\\\"minimumdiscount\\\":\\\"\\\",\\\"maximumdiscount\\\":\\\"\\\",\\\"optionimage\\\":\\\"\\\",\\\"subdatacount\\\":0,\\\"description\\\":\\\"\\\"}],\\\"fabricorcolor\\\":2,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":13800,\\\"labelname\\\":\\\"Location\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":13801,\\\"labelname\\\":\\\"Window Code\\\",\\\"value\\\":\\\"GGL\\\",\\\"valueid\\\":\\\"16168\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"3175\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":3175,\\\"optionname\\\":\\\"GGL\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":990,\\\"pricegroups\\\":\\\"-V\\\",\\\"optionqty\\\":1,\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":16168,\\\"forchildfieldoptionlinkid\\\":\\\"3_16168\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":28269,\\\"labelname\\\":\\\"Fitting Height\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":6,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":13802,\\\"labelname\\\":\\\"Further Instructions\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0}]\",\"oi_description\":\"Unit Type: mm, Quantity: 1, Supplier: Velux, Product Type: -V, Width: 588, Drop: 36, Fabric: -, Color: White, Window Code: GGL\",\"oi_onlinedescription\":null,\"oi_imagepath\":null,\"oi_reportdescription\":\"##Quantity: 1##,##Supplier: Velux##,##Product Type: -V##,##Width: 588 mm##,##Drop: 36 mm##,##Fabric: -##,##Color: White##,##Window Code: GGL##\",\"oi_onlinereportdescription\":null,\"oi_reporttitles\":\"##Quantity:##Supplier:##Product Type:##Width:##Drop:##Fabric:##Color:##Window Code:\",\"oi_onlinereporttitles\":null,\"oi_productionformulajsondata\":\"[]\",\"oi_productiondate\":\"2025-03-28 14:52:45\",\"oi_operationstatus\":null,\"oi_scanstatus\":\"\",\"oi_operationworkroom_data\":\"[]\",\"oi_operationcalender_data\":\"[]\",\"oi_operation_calculations\":\"[]\",\"oi_pricecomesfrom_calculations\":\"{}\",\"oi_pricetablepriceevenbom\":\"{}\",\"oi_productionstatus\":null,\"oi_costoverride\":0,\"oi_costprice\":\"0.000\",\"oi_netprice\":\"0.000\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"0.000\",\"oi_vatvalue\":\"20.000\",\"oi_vatselected\":1,\"oi_vattype\":1,\"oi_vatonoff\":1,\"oi_grossprice\":\"0.000\",\"oi_overrideprice\":\"0.000\",\"oi_overridetype\":2,\"oi_overridevalue\":null,\"oi_overridenetprice\":\"0.000\",\"oi_overridevatprice\":\"0.000\",\"oi_overridegrossprice\":\"0.000\",\"oi_ready\":0,\"oi_onhold\":0,\"oi_platformcreatedfrom\":\"web\",\"oi_platformlastupdatedfrom\":\"web\",\"oi_copiedfrom\":0,\"oi_isonlineorder\":0,\"oi_endcustomervatprice\":null,\"oi_endcustomeroverridetype\":2,\"oi_endcustomeroverridevalue\":null,\"oi_endcustomeroverridenetprice\":\"0.000\",\"oi_endcustomeroverridevatprice\":\"0.000\",\"oi_endcustomeroverridegrossprice\":\"0.000\",\"oi_sage_flag\":0,\"oi_status\":0,\"oi_createdby\":1,\"oi_createdat\":\"2025-03-28T14:53:10.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":null,\"oi_jsondataid\":\"[13793, 13792, 13794, 13795, 13796, 13797, 13798, 13799, 13800, 13801, 28269, 13802]\",\"oi_deviceplatform\":2,\"oi_custompricefields\":\"\",\"oi_editransfer\":0,\"oi_apisup_orderid\":0,\"oi_commissionprice\":\"0.000\",\"oi_commissionvatprice\":\"0.000\",\"oi_jsondatabackup\":\"\",\"oi_stockdeduct\":0,\"oi_deductedstockdetails\":null,\"lineitem_id\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "3467", "cl_createdat": "1743401231.000000", "cl_updatedat": null } ], "updated": [ { "cl_id": 3409, "cl_logname": "default", "cl_type": "QUEUE_3", "cl_modulename": "SMS", "cl_message": "(Fitting Appointment) Sent to 07912256639.", "cl_event": "", "cl_subjectid": 7846, "cl_subjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_parentid": 28018, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 28, "cl_changedfrom": null, "cl_changedto": null, "cl_customproperties": null, "cl_attachment": null, "cl_deviceplatform": null, "cl_deviceipaddress": null, "cl_devicenameversion": null, "cl_devicelocation": null, "cl_causertype": "", "id": "3409", "cl_createdat": "1743175248.000000", "cl_updatedat": "1743175248.000000" }, { "cl_id": 3421, "cl_logname": "default", "cl_type": "QUEUE_1", "cl_modulename": "SMS", "cl_message": "(Sales Appointment) Sent to 07801366264.", "cl_event": "", "cl_subjectid": 7712, "cl_subjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_parentid": 27976, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 16, "cl_changedfrom": null, "cl_changedto": null, "cl_customproperties": null, "cl_attachment": null, "cl_deviceplatform": null, "cl_deviceipaddress": null, "cl_devicenameversion": null, "cl_devicelocation": null, "cl_causertype": "", "id": "3421", "cl_createdat": "1743179182.000000", "cl_updatedat": "1743179182.000000" }, { "cl_id": 3431, "cl_logname": "default", "cl_type": "Manual", "cl_modulename": "SMS", "cl_message": "SMS Sent to 07789961720.", "cl_event": "", "cl_subjectid": 27811, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 27811, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 28, "cl_changedfrom": null, "cl_changedto": null, "cl_customproperties": null, "cl_attachment": null, "cl_deviceplatform": null, "cl_deviceipaddress": null, "cl_devicenameversion": null, "cl_devicelocation": null, "cl_causertype": "", "id": "3431", "cl_createdat": "1743179450.000000", "cl_updatedat": "1743179450.000000" } ], "deleted": [] }, "bm_productInfo": { "created": [], "updated": [], "deleted": [] }, "bm_fields": { "created": [], "updated": [], "deleted": [] }, "bm_fieldOptionLink": { "created": [], "updated": [], "deleted": [] }, "bm_option": { "created": [], "updated": [], "deleted": [] }, "bm_optionproduct": { "created": [], "updated": [], "deleted": [] }, "bm_linkedfieldswithproduct": { "created": [], "updated": [], "deleted": [] }, "bm_productionstatus": { "created": [], "updated": [], "deleted": [] }, "bm_productpricemap": { "created": [], "updated": [], "deleted": [] }, "bm_productrecipe": { "created": [], "updated": [], "deleted": [] }, "bm_productrecipemap": { "created": [], "updated": [], "deleted": [] }, "bm_supproductcode": { "created": [], "updated": [], "deleted": [] }, "bm_rulesetup": { "created": [], "updated": [], "deleted": [] }, "bm_formulas": { "created": [], "updated": [], "deleted": [] }, "bm_customercommission": { "created": [], "updated": [], "deleted": [] }, "bm_productgroupdetails": { "created": [], "updated": [], "deleted": [] }, "bm_productgroupmaterialmap": { "created": [], "updated": [], "deleted": [] }, "bm_productpricedetails": { "created": [], "updated": [], "deleted": [] }, "bm_fabriccolourmap": { "created": [], "updated": [], "deleted": [] }, "bm_fabricdetails": { "created": [], "updated": [], "deleted": [] }, "bm_colordetails": { "created": [], "updated": [], "deleted": [] }, "bm_optiondiscount": { "created": [], "updated": [], "deleted": [] }, "bm_optionpricebook": { "created": [], "updated": [], "deleted": [] }, "bm_allowances": { "created": [], "updated": [], "deleted": [] }, "bm_xyoptionpricedata": { "created": [], "updated": [], "deleted": [] }, "bm_delivery_cost_setup": { "created": [], "updated": [], "deleted": [] }, "bm_organizationdetails": { "created": [], "updated": [], "deleted": [] }, "bm_applicationSetup": { "created": [], "updated": [], "deleted": [] } }, "synctodelete": { "bm_customercontactinfo": { "51743173562": 4170, "51743173595": 4171, "51743173809": 4172 }, "bm_customertemplatedata": { "31743173562": 2896, "31743173595": 2897, "31743173809": 2898 }, "bm_jobdetails": { "41743173562": 28061, "41743173595": 28062, "41743173809": 28063 }, "bm_notelist": { "61743173562": 96333, "61743173596": 96334, "61743173809": 96335 }, "bm_jobmultiquote": { "141743173562": 28035, "141743173595": 28036, "141743173809": 28037 }, "bm_orderitem": { "71743173590": 84506 } }, "timestamp": 1743401228 }