{ "status": "success", "upcomingorder_list": { "bm_customertemplatedata": { "created": [], "updated": [ { "ctd_id": 29, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"62\":\"QUOT0004\",\"63\":\"\",\"61\":1,\"598\":25,\"64\":21}", "ctd_deletedcustokeyvalue": "{}", "ctd_isenablecustspecvatrate": 0, "ctd_custspecvatrate": "0.00", "ctd_vatregnum": null, "ctd_custsurcharge": null, "ctd_defaultdelcost": null, "ctd_defaultapptype": null, "ctd_defaultstaff": null, "ctd_addcredit": "0.00", "ctd_totredeemed": "0.00", "ctd_balance": "0.00", "ctd_creditlimit": "0.00", "ctd_creditavailable": "0.00", "ctd_overdue": 0, "ctd_paymenttermstype": 0, "ctd_paymenttermsvalue": 0, "ctd_paymenttermsdesc": null, "ctd_ishold": 0, "ctd_jobview": 0, "ctd_jobtypeview": 0, "ctd_discount": "0.00", "ctd_language": 0, "ctd_notymsg": 0, "ctd_onlinelogoname": null, "ctd_onlinelogo": null, "ctd_onlinesendemail": 0, "ctd_fordesktopisenable": 1, "ctd_foronlineisenable": 1, "ctd_enabledproductdesktop": "1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,35,36,39,40,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,60,62,64,65,66,67,68,69,70,71,72,73,74,75,77,78,79,80,81,82,83,84,85,86,87,88,91,92,93", "ctd_enabledproductonline": "1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,35,36,39,40,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,60,62,64,65,66,67,68,69,70,71,72,73,74,75,77,78,79,80,81,82,83,84,85,86,87,88,91,92,93", "ctd_onlineproductmarkup": null, "ctd_onlineendcustomeruseprefix": null, "ctd_onlineendcustomersequence": "4", "ctd_onlinequotecustomerterms": null, "ctd_onlinequotepaymentterms": null, "ctd_onlineinvoicecustomerterms": null, "ctd_onlineinvoicepaymentterms": null, "ctd_seq": 0, "ctd_status": 0, "id": "29", "ctd_createdat": 1744407499, "ctd_updatedat": 1748433844, "ctd_createdby": 0, "ctd_updatedby": null } ], "deleted": [] }, "bm_customercontactinfo": { "created": [], "updated": [ { "cci_id": 453, "cci_customerid": 29, "cci_templateid": 3, "roleid": 1, "cci_customizedarray": "{\"82\":\"simpson_aj@me.com\",\"77\":\"Andrew\",\"79\":\"Simpson\",\"78\":\"07736308961\",\"76\":\"07736308961\",\"81\":1,\"75\":1,\"62\":\"\",\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"12 Tulip Grove\",\"89\":\"Apley\",\"90\":19,\"86\":\"\",\"91\":\"Telford\",\"88\":\"TF16BA\"}", "cci_ismarketingemails": 0, "cci_smsverifystatus": 0, "cci_isdocumentreceived": 0, "cci_receiveddocfor": null, "cci_isonlineportal": 0, "cci_latitude": "52.7183396", "cci_longitude": "-2.5209353", "cci_username": null, "cci_password": null, "cci_confirmpassword": null, "cci_seq": 0, "cci_status": 0, "cci_deviceplatform": 0, "cci_mobcustomertempid": 0, "id": "453", "cci_createdat": 1744407499, "cci_updatedat": 1747042535, "cci_createdby": 0, "cci_updatedby": null } ], "deleted": [] }, "bm_appointment": { "created": [ { "app_eventid": 146, "app_description": "", "app_summary": "107-Andrew Simpson-12 Tulip Grove-07736308961-Measure", "app_private": 0, "app_appointmentType": 62, "app_userId": 2, "app_orderId": 107, "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": "15", "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": "1", "app_jobtimeminute": "0", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": 453, "id": "146", "app_sdate": 1748390400, "app_edate": 1748390400, "app_stime": 1748422800, "app_etime": 1748426400, "app_sdatetime": 1748422800, "app_edatetime": 1748426400, "app_until": null, "app_createdAt": 1748423596, "app_updatedAt": 1748423596, "app_createdBy": 2, "app_updatedBy": null }, { "app_eventid": 147, "app_description": "", "app_summary": "107-Andrew Simpson-12 Tulip Grove-07736308961-Fitting", "app_private": 0, "app_appointmentType": 64, "app_userId": 2, "app_orderId": 107, "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": "15", "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": "1", "app_jobtimeminute": "0", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": 453, "id": "147", "app_sdate": 1748390400, "app_edate": 1748390400, "app_stime": 1748422800, "app_etime": 1748426400, "app_sdatetime": 1748422800, "app_edatetime": 1748426400, "app_until": null, "app_createdAt": 1748423643, "app_updatedAt": 1748423643, "app_createdBy": 2, "app_updatedBy": null }, { "app_eventid": 148, "app_description": "", "app_summary": "107-Andrew Simpson-12 Tulip Grove-07736308961-Measure", "app_private": 0, "app_appointmentType": 62, "app_userId": 2, "app_orderId": 107, "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": "15", "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": "1", "app_jobtimeminute": "0", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": 453, "id": "148", "app_sdate": 1748390400, "app_edate": 1748390400, "app_stime": 1748422800, "app_etime": 1748426400, "app_sdatetime": 1748422800, "app_edatetime": 1748426400, "app_until": null, "app_createdAt": 1748423780, "app_updatedAt": 1748423780, "app_createdBy": 2, "app_updatedBy": null }, { "app_eventid": 149, "app_description": null, "app_summary": "107-Andrew Simpson-12 Tulip Grove-07736308961-Fitting", "app_private": 0, "app_appointmentType": 64, "app_userId": 2, "app_orderId": 107, "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": "15", "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": "1", "app_jobtimeminute": "0", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": 453, "id": "149", "app_sdate": 1748390400, "app_edate": 1748390400, "app_stime": 1748423700, "app_etime": 1748427300, "app_sdatetime": 1748423700, "app_edatetime": 1748427300, "app_until": null, "app_createdAt": 1748423814, "app_updatedAt": 1748433584, "app_createdBy": 2, "app_updatedBy": 4 }, { "app_eventid": 150, "app_description": "", "app_summary": "68-Louise Bbbbb-Orchard View-Fitting", "app_private": 0, "app_appointmentType": 64, "app_userId": 2, "app_orderId": 68, "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": "15", "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": "1", "app_jobtimeminute": "0", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": 489, "id": "150", "app_sdate": 1749513600, "app_edate": 1749513600, "app_stime": 1748426400, "app_etime": 1748430000, "app_sdatetime": 1749549600, "app_edatetime": 1749553200, "app_until": null, "app_createdAt": 1748431510, "app_updatedAt": 1748431510, "app_createdBy": 4, "app_updatedBy": null }, { "app_eventid": 151, "app_description": "", "app_summary": "166-Andrew Simpson-12 Tulip Grove-07736308961-Fitting", "app_private": 0, "app_appointmentType": 64, "app_userId": 2, "app_orderId": 167, "app_customerId": 453, "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": "15", "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": "1", "app_jobtimeminute": "0", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": 453, "id": "151", "app_sdate": 1748390400, "app_edate": 1748390400, "app_stime": 1748433600, "app_etime": 1748437200, "app_sdatetime": 1748433600, "app_edatetime": 1748437200, "app_until": null, "app_createdAt": 1748433724, "app_updatedAt": 1748433724, "app_createdBy": 4, "app_updatedBy": null }, { "app_eventid": 152, "app_description": "", "app_summary": "107-Andrew Simpson-12 Tulip Grove-07736308961-Fitting", "app_private": 0, "app_appointmentType": 64, "app_userId": 2, "app_orderId": 107, "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": "15", "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": "1", "app_jobtimeminute": "0", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": 453, "id": "152", "app_sdate": 1748390400, "app_edate": 1748390400, "app_stime": 1748433600, "app_etime": 1748437200, "app_sdatetime": 1748433600, "app_edatetime": 1748437200, "app_until": null, "app_createdAt": 1748433844, "app_updatedAt": 1748433844, "app_createdBy": 2, "app_updatedBy": null }, { "app_eventid": 153, "app_description": "", "app_summary": "107-Andrew Simpson-12 Tulip Grove-07736308961-Fitting", "app_private": 0, "app_appointmentType": 64, "app_userId": 2, "app_orderId": 107, "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": "15", "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": "1", "app_jobtimeminute": "0", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": 453, "id": "153", "app_sdate": 1748390400, "app_edate": 1748390400, "app_stime": 1748433600, "app_etime": 1748437200, "app_sdatetime": 1748433600, "app_edatetime": 1748437200, "app_until": null, "app_createdAt": 1748433929, "app_updatedAt": 1748433929, "app_createdBy": 2, "app_updatedBy": null } ], "updated": [ { "app_eventid": 113, "app_description": "to be confirmed", "app_summary": "118-Tina Patel-34 Hall Meadow-07817203312-Fitting", "app_private": 0, "app_appointmentType": 64, "app_userId": 2, "app_orderId": 119, "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": "15", "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": 1, "app_statusInGoogle": 0, "app_runid": null, "app_jobtimehour": "3", "app_jobtimeminute": "0", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": 12, "id": "113", "app_sdate": 1748995200, "app_edate": 1748995200, "app_stime": 1748426400, "app_etime": 1748437200, "app_sdatetime": 1749031200, "app_edatetime": 1749042000, "app_until": null, "app_createdAt": 1747733399, "app_updatedAt": 1748422367, "app_createdBy": 4, "app_updatedBy": 2 }, { "app_eventid": 114, "app_description": null, "app_summary": "119-M Jacobs-Fitting", "app_private": 0, "app_appointmentType": 64, "app_userId": 2, "app_orderId": 120, "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": "15", "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": 1, "app_statusInGoogle": 0, "app_runid": 0, "app_jobtimehour": "0", "app_jobtimeminute": "45", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": 535, "id": "114", "app_sdate": 1748995200, "app_edate": 1748995200, "app_stime": 1748442600, "app_etime": 1748445300, "app_sdatetime": 1749047400, "app_edatetime": 1749050100, "app_until": null, "app_createdAt": 1747735422, "app_updatedAt": 1748422274, "app_createdBy": 4, "app_updatedBy": 2 }, { "app_eventid": 116, "app_description": null, "app_summary": "121-Linda Hart-22 Chockleys Drive-07809905797-Fitting", "app_private": 0, "app_appointmentType": 64, "app_userId": 2, "app_orderId": 122, "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": "15", "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": 1, "app_statusInGoogle": 0, "app_runid": null, "app_jobtimehour": "0", "app_jobtimeminute": "45", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": 11, "id": "116", "app_sdate": 1748476800, "app_edate": 1748476800, "app_stime": 1748444400, "app_etime": 1748447100, "app_sdatetime": 1748530800, "app_edatetime": 1748533500, "app_until": null, "app_createdAt": 1747738750, "app_updatedAt": 1748433568, "app_createdBy": 2, "app_updatedBy": 4 }, { "app_eventid": 122, "app_description": "140", "app_summary": "127-Mason-70 Victoria Avenue-Fitting", "app_private": 0, "app_appointmentType": 64, "app_userId": 2, "app_orderId": 128, "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": "15", "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": 1, "app_statusInGoogle": 0, "app_runid": null, "app_jobtimehour": "1", "app_jobtimeminute": "0", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": 542, "id": "122", "app_sdate": 1748995200, "app_edate": 1748995200, "app_stime": 1748433600, "app_etime": 1748437200, "app_sdatetime": 1749038400, "app_edatetime": 1749042000, "app_until": null, "app_createdAt": 1747756154, "app_updatedAt": 1748422324, "app_createdBy": 4, "app_updatedBy": 2 }, { "app_eventid": 126, "app_description": "fit track", "app_summary": "143-Y Taiwo-2 Betjeman Way-Fitting", "app_private": 0, "app_appointmentType": 64, "app_userId": 2, "app_orderId": 144, "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": "15", "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": 1, "app_statusInGoogle": 0, "app_runid": null, "app_jobtimehour": "1", "app_jobtimeminute": "15", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": 495, "id": "126", "app_sdate": 1748995200, "app_edate": 1748995200, "app_stime": 1748446200, "app_etime": 1748450700, "app_sdatetime": 1749051000, "app_edatetime": 1749055500, "app_until": null, "app_createdAt": 1747916958, "app_updatedAt": 1748422229, "app_createdBy": 4, "app_updatedBy": 2 }, { "app_eventid": 127, "app_description": null, "app_summary": "144-Mrs J Parkyn-43 Leegomery Road-Fitting", "app_private": 0, "app_appointmentType": 64, "app_userId": 2, "app_orderId": 145, "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": "15", "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": 1, "app_statusInGoogle": 0, "app_runid": null, "app_jobtimehour": "1", "app_jobtimeminute": "15", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": 553, "id": "127", "app_sdate": 1748995200, "app_edate": 1748995200, "app_stime": 1748438100, "app_etime": 1748442600, "app_sdatetime": 1749042900, "app_edatetime": 1749047400, "app_until": null, "app_createdAt": 1747922728, "app_updatedAt": 1748429583, "app_createdBy": 4, "app_updatedBy": 4 }, { "app_eventid": 149, "app_description": null, "app_summary": "107-Andrew Simpson-12 Tulip Grove-07736308961-Fitting", "app_private": 0, "app_appointmentType": 64, "app_userId": 2, "app_orderId": 107, "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": "15", "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": "1", "app_jobtimeminute": "0", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": 453, "id": "149", "app_sdate": 1748390400, "app_edate": 1748390400, "app_stime": 1748423700, "app_etime": 1748427300, "app_sdatetime": 1748423700, "app_edatetime": 1748427300, "app_until": null, "app_createdAt": 1748423814, "app_updatedAt": 1748433584, "app_createdBy": 2, "app_updatedBy": 4 } ], "deleted": [] }, "bm_tasklist": { "created": [], "updated": [], "deleted": [] }, "bm_jobdetails": { "created": [ { "jd_id": 167, "jd_customerid": 29, "jd_contactid": 453, "jd_additionalcontacts": "453", "jd_templateid": 1, "jd_jobmultiquoteid": 167, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "166", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 12, "jd_accref": "QUOT0004", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "0.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "0.00", "jd_grossprofit": "0.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "0.00", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 1, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 4, "jd_updatedby": 4, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "0.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":21,\"41\":\"4\",\"44\":\"\",\"45\":\"Andrew\",\"46\":\"Simpson\",\"47\":\"07736308961\",\"48\":\"simpson_aj@me.com\",\"49\":\"12 Tulip Grove\",\"50\":\"Apley\",\"51\":\"Telford\",\"52\":\"\",\"53\":\"TF16BA\",\"54\":19,\"285\":1,\"286\":\"07736308961\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":4,\"558\":1,\"608\":\"\",\"609\":\"\",\"610\":1,\"611\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "0.000", "jd_commission": "\"\"", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "167", "jd_createddate": 1748390400, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1748433723, "jd_updatedat": 1748433724 } ], "updated": [ { "jd_id": 68, "jd_customerid": 65, "jd_contactid": 489, "jd_additionalcontacts": "489", "jd_templateid": 1, "jd_jobmultiquoteid": 68, "jd_deletedcustokeyvalue": "{\"32\":\"\",\"34\":\"68\",\"35\":\"BBBB0001\",\"36\":6,\"38\":\"INV254005\",\"40\":1}", "jd_jobref": "68", "jd_jobstatus": 6, "jd_contactaddid": 0, "jd_orderstatus": 3, "jd_accref": "BBBB0001", "jd_invoiceno": "INV254005", "jd_listprice": "426.00", "jd_netprice": "468.60", "jd_vat": "93.72", "jd_isvaton": 1, "jd_deliverycost": "42.60", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "562.32", "jd_grossprofit": "255.60", "jd_costprice": "213.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "32.32", "jd_totpaid": "530.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 1, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": "", "jd_endcustomeroverridenetprice": "426.00", "jd_endcustomeroverridevatprice": "85.20", "jd_endcustomeroverridegrossprice": "511.20", "jd_endcustomerdeliverycost": "", "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": "", "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 4, "jd_updatedby": 4, "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\":21,\"41\":4,\"44\":\"\",\"45\":\"Louise\",\"46\":\"Bbbbb\",\"47\":\"\",\"48\":\"\",\"49\":\"Orchard View\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":19,\"285\":2,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":4,\"558\":\"\",\"608\":\"\",\"609\":\"\",\"610\":1,\"611\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "20.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "68", "jd_createddate": 1747094400, "jd_orderdate": 1747353600, "jd_duedate": 1747353600, "jd_sceduleddate": null, "jd_invoicedate": 1747353600, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1747137978, "jd_updatedat": 1748431452 }, { "jd_id": 167, "jd_customerid": 29, "jd_contactid": 453, "jd_additionalcontacts": "453", "jd_templateid": 1, "jd_jobmultiquoteid": 167, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "166", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 12, "jd_accref": "QUOT0004", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "0.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "0.00", "jd_grossprofit": "0.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "0.00", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 1, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 4, "jd_updatedby": 4, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "0.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":21,\"41\":\"4\",\"44\":\"\",\"45\":\"Andrew\",\"46\":\"Simpson\",\"47\":\"07736308961\",\"48\":\"simpson_aj@me.com\",\"49\":\"12 Tulip Grove\",\"50\":\"Apley\",\"51\":\"Telford\",\"52\":\"\",\"53\":\"TF16BA\",\"54\":19,\"285\":1,\"286\":\"07736308961\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":4,\"558\":1,\"608\":\"\",\"609\":\"\",\"610\":1,\"611\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "0.000", "jd_commission": "\"\"", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "167", "jd_createddate": 1748390400, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1748433723, "jd_updatedat": 1748433724 } ], "deleted": [] }, "bm_orderitem": { "created": [], "updated": [], "deleted": [] }, "bm_paymentlist": { "created": [ { "pl_id": 10, "pl_orderid": "0", "pl_invoice_id": 5, "pl_customer_id": 65, "pl_overpayment_id": 0, "pl_jobpayment_id": 0, "pl_amount": "320.00", "pl_paymentmethod": 1, "pl_paymentcategory": 1, "pl_paymenttype": 8, "pl_surchargetype": 0, "pl_surchargemethod": 0, "pl_surchargeamount": "0.00", "pl_surchargevalue": "0.00", "pl_surchargetotal": "320.00", "pl_userid": "4", "pl_decription": "", "pl_paymentinvoice": null, "pl_paymentstatus": 0, "pl_seq": 0, "pl_status": 0, "pl_refundtype": null, "pl_deviceplatform": 0, "id": "10", "pl_paiddate": 1748390400, "created_at": 1748431452, "updated_at": null, "created_by": 4, "updated_by": null } ], "updated": [], "deleted": [] }, "bm_notelist": { "created": [ { "nl_id": 79, "nl_ordertempid": null, "nl_orderid": 68, "nl_notescategory": 1, "nl_type": 4, "nl_platform": 3, "nl_desc": "payment added against invoice no (INV254005) amount (320.00)", "nl_manualNotes": "", "nl_createdby": "4", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 1, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "79", "nl_endddate": 1748390400, "nl_starttime": 1748435052, "created_at": 1748431452, "updated_at": 1748431452, "created_by": 4, "updated_by": null } ], "updated": [], "deleted": [] }, "bm_deliveryaddresssetting": { "created": [ { "das_id": 166, "das_jobid": 167, "das_appointmentaddress": 453, "das_invoiceaddress": 453, "das_invoicedeliveryaddress": 0, "das_purchaseaddress": 0, "das_worksheetaddress": 0, "id": "166", "das_createdat": 1748433724, "das_updatedat": 1748433724, "das_createdby": 4, "das_updatedby": null } ], "updated": [], "deleted": [] }, "bm_jobchecklist": { "created": [], "updated": [], "deleted": [] }, "bm_Invoice": { "created": [], "updated": [ { "invoice_id": 5, "job_id": 68, "customer_id": 65, "ref_no": "INV254005", "invoice_type": 1, "invoice_split_type": 0, "invoice_split_cal": 0, "invoice_split_cal_value": "0.000", "net_amount": "468.600", "vat_amount": "93.720", "gross_amount": "562.320", "delivery_amount": "42.600", "delivery": 0, "commission_amount": "0.000", "commission": 0, "total_amount": "562.320", "split_net_amount": "0.000", "split_vat_amount": "0.000", "outstanding_amount": "32.320", "paid_amount": "530.000", "paid_status": 2, "status": 0, "transfer": 0, "transfer_id": null, "id": "5", "paymentDueDate": 1747353600, "invoiceDate": 1747353600, "transferDate": null, "createdat": 1747398236, "updatedat": 1748431452, "createdby": 4, "updatedby": 4 } ], "deleted": [] }, "bm_InvoiceDetails": { "created": [], "updated": [], "deleted": [] }, "bm_invoice_credit_note": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNote": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNoteDetails": { "created": [], "updated": [], "deleted": [] }, "bm_job_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_OverPayment": { "created": [], "updated": [], "deleted": [] }, "bm_terms": { "created": [ { "termsid": 630, "orderid": 107, "jobmultiquoteid": 107, "isresportshow": 1, "termsCategory": 1, "termsName": "1", "termsDescription": "