{ "status": "success", "upcomingorder_list": { "bm_customertemplatedata": { "created": [], "updated": [ { "ctd_id": 596, "ctd_createdfrom": 0, "ctd_templateid": 56, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"62\": \"MARY0001\", \"63\": \"\", \"61\": 1, \"690\": 25, \"64\": 24}", "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,9,10,11,12,13,14,15,16,17,19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89", "ctd_enabledproductonline": "1,2,3,4,5,6,7,9,10,11,12,13,14,15,16,17,19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89", "ctd_onlineproductmarkup": null, "ctd_onlineendcustomeruseprefix": null, "ctd_onlineendcustomersequence": "1", "ctd_onlinequotecustomerterms": null, "ctd_onlinequotepaymentterms": null, "ctd_onlineinvoicecustomerterms": null, "ctd_onlineinvoicepaymentterms": null, "ctd_seq": 0, "ctd_status": 0, "id": "596", "ctd_createdat": 1742887350, "ctd_updatedat": 1742887350, "ctd_createdby": 0, "ctd_updatedby": null }, { "ctd_id": 597, "ctd_createdfrom": 0, "ctd_templateid": 56, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\": 1, \"64\": 24, \"690\": 25, \"62\": \"U0000001\"}", "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": "597", "ctd_createdat": 1742885332, "ctd_updatedat": 1742895219, "ctd_createdby": 0, "ctd_updatedby": null } ], "deleted": [] }, "bm_customercontactinfo": { "created": [], "updated": [ { "cci_id": 618, "cci_customerid": 596, "cci_templateid": 52, "roleid": 1, "cci_customizedarray": "{\"62\":\"\",\"82\":\"\",\"77\":\"MARY\",\"79\":\"\",\"78\":\"\",\"76\":\"9360456778\",\"81\":2,\"75\":17,\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"\",\"89\":\"\",\"90\":4,\"86\":\"\",\"91\":\"\",\"88\":\"\"}", "cci_ismarketingemails": 0, "cci_smsverifystatus": 0, "cci_isdocumentreceived": 0, "cci_receiveddocfor": null, "cci_isonlineportal": 0, "cci_latitude": null, "cci_longitude": null, "cci_username": null, "cci_password": null, "cci_confirmpassword": null, "cci_seq": 0, "cci_status": 0, "cci_deviceplatform": 0, "cci_mobcustomertempid": 0, "id": "618", "cci_createdat": 1742887350, "cci_updatedat": 1742887350, "cci_createdby": 0, "cci_updatedby": null }, { "cci_id": 619, "cci_customerid": 597, "cci_templateid": 52, "roleid": 0, "cci_customizedarray": "{\"75\":17,\"76\":\"34\",\"77\":\"U\",\"81\":2,\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"90\":4}", "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": 31742885332, "id": "619", "cci_createdat": 1742885332, "cci_updatedat": 1742895219, "cci_createdby": 0, "cci_updatedby": null } ], "deleted": [] }, "bm_appointment": { "created": [ { "app_eventid": 460, "app_description": "Arun appointment", "app_summary": "JBN809-Virat-85-Fitting", "app_private": 0, "app_appointmentType": 64, "app_userId": 3, "app_orderId": 844, "app_customerId": 0, "app_isAllDay": 0, "app_timezone": "Asia\/Kolkata", "app_latitude": null, "app_longitude": null, "app_parentappid": null, "app_recurrencerule": null, "app_userdefinedValue": "[]", "app_recurrenceexception": null, "app_attachment": "[]", "guid": "", "app_staff": "", "app_appointtype": "", "app_confirmed": 0, "app_travelHour": "0", "app_travelMinute": "0", "app_onsiteHour": "0", "app_onsiteMinute": "0", "app_location": null, "app_traveltime": null, "app_googleid": "0", "app_platform": "web", "app_cal_status": 811, "app_status": 0, "app_markasread": 0, "app_statusInGoogle": 0, "app_runid": 0, "app_jobtimehour": "1", "app_jobtimeminute": "0", "app_products": null, "app_deviceplatform": 2, "app_recurrenceexception_date": null, "app_deliveryaddressid": null, "id": "460", "app_sdate": 1742860800, "app_edate": 1742860800, "app_stime": 1742887827, "app_etime": 1742891427, "app_sdatetime": 1742887827, "app_edatetime": 1742891427, "app_until": null, "app_createdAt": 1742887860, "app_updatedAt": 1742887865, "app_createdBy": 27, "app_updatedBy": null } ], "updated": [], "deleted": [] }, "bm_tasklist": { "created": [ { "tl_id": 98, "tl_orderid": 2147483647, "tl_taskcategory": 1, "tl_taskdate": "2025-03-25", "tl_tasktime": "15:03:01", "tl_taskmethod": "0", "tl_istaskprivate": 0, "tl_userid": "6", "tl_priority": 0, "tl_addjobid": 2147483647, "tl_desc": "A", "tl_status": 0, "tl_markasread": 0, "tl_taskstatus": 1, "tl_userdefinedfields": "[{\"id\":\"2\",\"name\":\"jim\",\"key\":\"task_jim\",\"type\":\"textbox\",\"condition\":1,\"idname\":\"task_jim\",\"pattern\":\"^[a-zA-Z ]*$\",\"errormsg\":\"Only Text is allowed\",\"maxlength\":156,\"mandatory\":1,\"_default\":\"\",\"dropdownoptionvalue\":\"\",\"userdefine\":\"A\"}]", "tl_markcompleted": 0, "tl_jobmode": "contact", "tl_recurrencerule": null, "tl_repeatmaindescription": null, "tl_repeatmethod": "daily", "tl_starttask": null, "tl_startdata": null, "tl_endtask": null, "tl_enddata": null, "tl_istaskrepeat": 0, "tl_deviceplatform": 2, "id": "98", "tl_createdat": 1742895219, "tl_updatedat": 1742895219, "tl_createdby": 1, "tl_updatedby": null } ], "updated": [], "deleted": [] }, "bm_jobdetails": { "created": [ { "jd_id": 849, "jd_customerid": 596, "jd_contactid": 618, "jd_additionalcontacts": "618", "jd_templateid": 1, "jd_jobmultiquoteid": 872, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "JBN814", "jd_jobstatus": 3, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "MARY0001", "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": 3, "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": 1, "jd_updatedby": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "3.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":24,\"41\":1,\"44\":\"\",\"45\":\"MARY\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":17,\"286\":\"9360456778\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"521\":\"\",\"522\":\"\",\"523\":\"\",\"555\":\"\",\"586\":\"\",\"587\":\"\",\"588\":\"\",\"616\":\"\",\"617\":\"\",\"618\":1,\"625\":2,\"633\":\"\",\"634\":\"\",\"666\":\"\",\"667\":\"\",\"700\":\"\",\"701\":\"\",\"702\":1,\"703\":\"\",\"704\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "3.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "849", "jd_createddate": 1742860800, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1742887350, "jd_updatedat": 1742887350 }, { "jd_id": 850, "jd_customerid": 597, "jd_contactid": 619, "jd_additionalcontacts": "619", "jd_templateid": 1, "jd_jobmultiquoteid": 873, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "JBN815", "jd_jobstatus": 3, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "U0000001", "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": "3.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"JBN815\",\"35\":\"U0000001\",\"36\":3,\"37\":1,\"38\":\"\",\"39\":24,\"40\":1,\"41\":1,\"44\":\"\",\"45\":\"U\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":17,\"286\":\"34\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"521\":\"\",\"522\":\"\",\"523\":\"\",\"555\":\"\",\"586\":\"\",\"587\":\"\",\"588\":\"\",\"616\":\"\",\"617\":\"\",\"618\":1,\"625\":2,\"633\":\"\",\"634\":\"\",\"666\":\"\",\"667\":\"\",\"700\":\"\",\"701\":\"\",\"702\":1,\"703\":\"\",\"704\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "3.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "850", "jd_createddate": 1742860800, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1742885332, "jd_updatedat": 1742895219 } ], "updated": [ { "jd_id": 849, "jd_customerid": 596, "jd_contactid": 618, "jd_additionalcontacts": "618", "jd_templateid": 1, "jd_jobmultiquoteid": 872, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "JBN814", "jd_jobstatus": 3, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "MARY0001", "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": 3, "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": 1, "jd_updatedby": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "3.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":24,\"41\":1,\"44\":\"\",\"45\":\"MARY\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":17,\"286\":\"9360456778\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"521\":\"\",\"522\":\"\",\"523\":\"\",\"555\":\"\",\"586\":\"\",\"587\":\"\",\"588\":\"\",\"616\":\"\",\"617\":\"\",\"618\":1,\"625\":2,\"633\":\"\",\"634\":\"\",\"666\":\"\",\"667\":\"\",\"700\":\"\",\"701\":\"\",\"702\":1,\"703\":\"\",\"704\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "3.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "849", "jd_createddate": 1742860800, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1742887350, "jd_updatedat": 1742887350 }, { "jd_id": 850, "jd_customerid": 597, "jd_contactid": 619, "jd_additionalcontacts": "619", "jd_templateid": 1, "jd_jobmultiquoteid": 873, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "JBN815", "jd_jobstatus": 3, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "U0000001", "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": "3.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"JBN815\",\"35\":\"U0000001\",\"36\":3,\"37\":1,\"38\":\"\",\"39\":24,\"40\":1,\"41\":1,\"44\":\"\",\"45\":\"U\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":17,\"286\":\"34\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"521\":\"\",\"522\":\"\",\"523\":\"\",\"555\":\"\",\"586\":\"\",\"587\":\"\",\"588\":\"\",\"616\":\"\",\"617\":\"\",\"618\":1,\"625\":2,\"633\":\"\",\"634\":\"\",\"666\":\"\",\"667\":\"\",\"700\":\"\",\"701\":\"\",\"702\":1,\"703\":\"\",\"704\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "3.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "850", "jd_createddate": 1742860800, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1742885332, "jd_updatedat": 1742895219 } ], "deleted": [] }, "bm_orderitem": { "created": [], "updated": [], "deleted": [] }, "bm_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_notelist": { "created": [], "updated": [], "deleted": [] }, "bm_deliveryaddresssetting": { "created": [ { "das_id": 612, "das_jobid": 849, "das_appointmentaddress": 618, "das_invoiceaddress": 618, "das_invoicedeliveryaddress": 0, "das_purchaseaddress": 0, "das_worksheetaddress": 0, "id": "612", "das_createdat": 1742887350, "das_updatedat": 1742887350, "das_createdby": 1, "das_updatedby": null } ], "updated": [], "deleted": [] }, "bm_jobchecklist": { "created": [], "updated": [], "deleted": [] }, "bm_Invoice": { "created": [], "updated": [], "deleted": [] }, "bm_InvoiceDetails": { "created": [], "updated": [], "deleted": [] }, "bm_invoice_credit_note": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNote": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNoteDetails": { "created": [], "updated": [], "deleted": [] }, "bm_job_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_OverPayment": { "created": [], "updated": [], "deleted": [] }, "bm_terms": { "created": [], "updated": [], "deleted": [] }, "bm_jobmultiquote": { "created": [ { "jmq_id": 872, "jmq_jobid": 849, "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": 3, "jmq_orderformprice": "0.00", "jmq_editpricebyid": 0, "jmq_isroundon": 0, "jmq_grossprice": "0.00", "jmq_grossprofit": "0.00", "jmq_costprice": "0.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "0.00", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": null, "jmq_deliverycostid": 1, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 1, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 1, "jmq_endcustomeroverridevalue": null, "jmq_endcustomeroverridenetprice": "0.00", "jmq_endcustomeroverridevatprice": "0.00", "jmq_endcustomeroverridegrossprice": "0.00", "jmq_endcustomerdeliverycost": null, "jmq_endcustomerdeliverycostinclvat": 1, "jmq_endcustomerfittingcost": null, "jmq_endcustomerfittingcostinclvat": 1, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "3.000", "jmq_cdeliveryvatperc": "3.000", "id": "872", "jmq_duedate": null, "jmq_sceduleddate": null, "jmq_createdat": "1742887350.000000", "jmq_updatedat": "1742887350.000000", "jmq_createdby": 1, "jmq_updatedby": null }, { "jmq_id": 873, "jmq_jobid": 850, "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": "3.000", "jmq_cdeliveryvatperc": "3.000", "id": "873", "jmq_duedate": null, "jmq_sceduleddate": null, "jmq_createdat": "1742885332.000000", "jmq_updatedat": null, "jmq_createdby": 1, "jmq_updatedby": null } ], "updated": [], "deleted": [] }, "bm_jobstatus_tracks": { "created": [ { "jst_id": 900, "jst_jobid": 848, "jst_job_current_status": 3, "id": "900", "jst_createdat": "1742885167.647351" }, { "jst_id": 901, "jst_jobid": 849, "jst_job_current_status": 3, "id": "901", "jst_createdat": "1742887350.609082" }, { "jst_id": 902, "jst_jobid": 850, "jst_job_current_status": 3, "id": "902", "jst_createdat": "1742895219.341599" } ], "updated": [], "deleted": [] }, "bm_customindividuallogs": { "created": [ { "cl_id": 17837, "cl_logname": "default", "cl_type": null, "cl_modulename": "All Jobs", "cl_message": "view report generated by admin All Jobs", "cl_event": "created", "cl_subjectid": 537, "cl_subjecttype": "App\\Models\\Reports\\bm_reportactivitylog", "cl_parentid": 2147483647, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Category: \":\"Quotation\"}", "cl_customproperties": "{\"attributes\":{\"ral_id\":537,\"ral_jobid\":2147483647,\"ral_reportid\":16,\"ral_categoryid\":1,\"ral_description\":\"view report generated by admin\",\"ral_attachment\":\"\",\"ral_actionid\":1,\"ral_createdat\":\"2025-03-25T06:49:23.000000Z\",\"ral_updatedat\":\"2025-03-25T06:49:23.000000Z\",\"ral_createdby\":1,\"ral_updatedby\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17837", "cl_createdat": "1742885363.000000", "cl_updatedat": null }, { "cl_id": 17838, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 849, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 849, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"BlindMatrix\",\"Account Type\":\"Domestic\",\"Source\":\"Linked In\",\"Created By\":\"admin\",\"First Name\":\"MARY\",\"Country\":\"Australia\",\"Salutation\":\"Hap\",\"Phone\":\"9360456778\",\"Check Box\":\"Disabled\",\"Date & Time1\":\"03-25-2025 07:22:30\",\"Assigned to\":1,\"Role\":2,\"Date1\":\"2025-03-25\",\"Delivery date1\":\"2025-03-25\",\"Rework date\":\"2025-03-25\",\"Additional Contacts\":\"618\",\"Job Status\":\"Quote\",\"Order Status\":\"Order1\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"jd_isonlineorder\":1,\"End Customer Override Type\":1,\"End Customer Delivery Cost Include Vat\":1,\"End Customer Fitting Cost Include Vat\":1,\"Delivery Vat Percentage\":\"3.000\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":849,\"jd_customerid\":596,\"jd_contactid\":618,\"jd_additionalcontacts\":\"618\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"33\\\":25,\\\"37\\\":1,\\\"39\\\":24,\\\"41\\\":1,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"MARY\\\",\\\"46\\\":\\\"\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":4,\\\"285\\\":17,\\\"286\\\":\\\"9360456778\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"521\\\":\\\"\\\",\\\"522\\\":\\\"\\\",\\\"523\\\":\\\"\\\",\\\"555\\\":\\\"\\\",\\\"586\\\":\\\"\\\",\\\"587\\\":\\\"\\\",\\\"588\\\":\\\"\\\",\\\"616\\\":\\\"\\\",\\\"617\\\":\\\"\\\",\\\"618\\\":1,\\\"625\\\":2,\\\"633\\\":\\\"\\\",\\\"634\\\":\\\"\\\",\\\"666\\\":\\\"\\\",\\\"667\\\":\\\"\\\",\\\"700\\\":\\\"\\\",\\\"701\\\":\\\"\\\",\\\"702\\\":1,\\\"703\\\":\\\"\\\",\\\"704\\\":\\\"\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-03-25\",\"jd_orderdate\":\"0000-00-00\",\"jd_duedate\":\"0000-00-00\",\"jd_sceduleddate\":\"0000-00-00\",\"jd_invoicedate\":\"0000-00-00\",\"jd_completeddate\":\"0000-00-00\",\"jd_jobref\":null,\"jd_jobstatus\":3,\"jd_contactaddid\":0,\"jd_orderstatus\":1,\"jd_accref\":\"\",\"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\":3,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":0,\"jd_isroundon\":0,\"jd_grossprice\":\"0.00\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"0.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"0.00\",\"jd_totpaid\":\"0.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":\"\\\"\\\"\",\"jd_deliverycostid\":1,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":1,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":1,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":1,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":null,\"jd_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-25T07:22:30.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-03-25T07:22:30.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\":\"3.000\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"3.000\",\"jd_commission\":\"[]\",\"jd_commissionprice\":\"0.00\",\"jd_commissionsetting\":0,\"jd_commissionaddedvalue\":\"0.00\",\"jd_onlineprefixseq\":\"\",\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":0,\"jd_rework_count\":0}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17838", "cl_createdat": "1742887350.000000", "cl_updatedat": null }, { "cl_id": 17842, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment", "cl_message": "new item has been created in Appointment", "cl_event": "created", "cl_subjectid": 460, "cl_subjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_parentid": 844, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "null", "cl_changedto": "{\"Repeat On\":\"yearly on March 25\",\"Description\":\"Arun appointment\",\"app_summary\":\"JBN809-Virat-85-Fitting\",\"Appointment Type\":\"Fitting\",\"Staff\":\"Kishore\",\"Job Ref No\":\"JBN809\",\"Start Date & Time\":\"2025-03-25 07:30:27\",\"End Date & Time\":\"2025-03-25 08:30:27\",\"Appointment Status\":\"sdsd33\",\"app_jobtimehour\":\"1\",\"app_deviceplatform\":2}", "cl_customproperties": "{\"attributes\":{\"app_eventid\":460,\"app_description\":\"Arun appointment\",\"app_summary\":\"JBN809-Virat-85-Fitting\",\"app_private\":0,\"app_appointmentType\":64,\"app_userId\":3,\"app_orderId\":844,\"app_customerId\":0,\"app_isAllDay\":0,\"app_sdate\":\"2025-03-25\",\"app_edate\":\"2025-03-25\",\"app_stime\":\"07:30:27\",\"app_etime\":\"08:30:27\",\"app_sdatetime\":\"2025-03-25 07:30:27\",\"app_edatetime\":\"2025-03-25 08:30:27\",\"app_timezone\":\"Asia\\\/Kolkata\",\"app_latitude\":null,\"app_longitude\":null,\"app_parentappid\":null,\"app_recurrencerule\":null,\"app_userdefinedValue\":\"[]\",\"app_recurrenceexception\":null,\"app_recurrenceexception_date\":null,\"app_attachment\":null,\"guid\":\"\",\"app_until\":null,\"app_staff\":\"\",\"app_appointtype\":\"\",\"app_confirmed\":0,\"app_coordinates\":\"\",\"app_travelHour\":\"0\",\"app_travelMinute\":\"0\",\"app_onsiteHour\":\"0\",\"app_onsiteMinute\":\"0\",\"app_location\":null,\"app_traveltime\":null,\"app_googleid\":\"0\",\"app_platform\":\"web\",\"app_cal_status\":811,\"app_status\":0,\"app_markasread\":0,\"app_statusInGoogle\":0,\"app_createdBy\":27,\"app_updatedBy\":null,\"app_createdAt\":\"2025-03-25T07:31:00.000000Z\",\"app_updatedAt\":\"2025-03-25T07:31:00.000000Z\",\"app_runid\":0,\"app_deliveryaddressid\":null,\"app_jobtimehour\":\"1\",\"app_jobtimeminute\":\"0\",\"app_products\":null,\"app_deviceplatform\":2}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17842", "cl_createdat": "1742887860.000000", "cl_updatedat": null }, { "cl_id": 17843, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment", "cl_message": "Appointment has been updated the field Uploaded Attachment", "cl_event": "modified", "cl_subjectid": 460, "cl_subjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_parentid": 844, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "[]", "cl_changedto": "{\"Uploaded Attachment\":\"[]\"}", "cl_customproperties": "{\"attributes\":{\"app_attachment\":\"[]\",\"app_updatedAt\":\"2025-03-25T07:31:05.000000Z\"},\"old\":{\"app_attachment\":null,\"app_updatedAt\":\"2025-03-25T07:31:00.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17843", "cl_createdat": "1742887865.000000", "cl_updatedat": null }, { "cl_id": 17844, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 850, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 850, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"BlindMatrix\",\"\":1,\"Account Type\":\"Domestic\",\"Source\":\"Linked In\",\"Created By\":\"admin\",\"First Name\":\"U\",\"Country\":\"Australia\",\"Salutation\":\"Hap\",\"Phone\":\"34\",\"Check Box\":\"Disabled\",\"Date & Time1\":\"03-25-2025 09:33:39\",\"Assigned to\":1,\"Role\":2,\"Date1\":\"2025-03-25\",\"Delivery date1\":\"2025-03-25\",\"Rework date\":\"2025-03-25\",\"Additional Contacts\":\"619\",\"Job Ref No\":\"JBN815\",\"Job Status\":\"Quote\",\"Order Status\":\"Order1\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"jd_isonlineorder\":1,\"Delivery Vat Percentage\":\"3.000\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":850,\"jd_customerid\":597,\"jd_contactid\":619,\"jd_additionalcontacts\":\"619\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"JBN815\\\",\\\"35\\\":\\\"U0000001\\\",\\\"36\\\":3,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":24,\\\"40\\\":1,\\\"41\\\":1,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"U\\\",\\\"46\\\":\\\"\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":4,\\\"285\\\":17,\\\"286\\\":\\\"34\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"521\\\":\\\"\\\",\\\"522\\\":\\\"\\\",\\\"523\\\":\\\"\\\",\\\"555\\\":\\\"\\\",\\\"586\\\":\\\"\\\",\\\"587\\\":\\\"\\\",\\\"588\\\":\\\"\\\",\\\"616\\\":\\\"\\\",\\\"617\\\":\\\"\\\",\\\"618\\\":1,\\\"625\\\":2,\\\"633\\\":\\\"\\\",\\\"634\\\":\\\"\\\",\\\"666\\\":\\\"\\\",\\\"667\\\":\\\"\\\",\\\"700\\\":\\\"\\\",\\\"701\\\":\\\"\\\",\\\"702\\\":1,\\\"703\\\":\\\"\\\",\\\"704\\\":\\\"\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-03-25\",\"jd_orderdate\":null,\"jd_duedate\":null,\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":null,\"jd_jobref\":\"JBN815\",\"jd_jobstatus\":3,\"jd_contactaddid\":0,\"jd_orderstatus\":1,\"jd_accref\":\"U0000001\",\"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-25T06:48:52.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-03-25T09:33:39.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\":\"3.000\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"3.000\",\"jd_commission\":\"[]\",\"jd_commissionprice\":\"0.00\",\"jd_commissionsetting\":0,\"jd_commissionaddedvalue\":\"0.00\",\"jd_onlineprefixseq\":null,\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":0,\"jd_rework_count\":0}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17844", "cl_createdat": "1742895219.000000", "cl_updatedat": null }, { "cl_id": 17845, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in JBN815", "cl_event": "created", "cl_subjectid": 873, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 850, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":873,\"jmq_jobid\":850,\"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\":\"3.000\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":873,\"jmq_jobid\":850,\"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\":\"3.000\",\"jmq_cdeliveryvatperc\":\"3.000\",\"jmq_createdby\":1,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-03-25T06:48:52.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": "17845", "cl_createdat": "1742895219.000000", "cl_updatedat": null }, { "cl_id": 17846, "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": 850, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 850, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":873}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":873},\"old\":{\"jd_jobmultiquoteid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17846", "cl_createdat": "1742895219.000000", "cl_updatedat": null }, { "cl_id": 17847, "cl_logname": "default", "cl_type": null, "cl_modulename": "Task", "cl_message": "new item has been created in Task", "cl_event": "created", "cl_subjectid": 98, "cl_subjecttype": "App\\Models\\Task\\bm_tasklist", "cl_parentid": 2147483647, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Job Ref No\":null,\"Category\":\"Critical\",\"Task Date\":\"2025-03-25\",\"Task Time\":\"15:03:01\",\"Created By\":\"santhosh\",\"Description\":\"A\",\"Repeat Method\":\"daily\",\"tl_deviceplatform\":2}", "cl_customproperties": "{\"attributes\":{\"tl_id\":98,\"tl_orderid\":2147483647,\"tl_taskcategory\":1,\"tl_taskdate\":\"2025-03-25\",\"tl_tasktime\":\"15:03:01\",\"tl_taskmethod\":\"0\",\"tl_istaskprivate\":0,\"tl_userid\":\"6\",\"tl_priority\":0,\"tl_addjobid\":2147483647,\"tl_desc\":\"A\",\"tl_status\":0,\"tl_markasread\":0,\"tl_taskstatus\":1,\"tl_userdefinedfields\":\"[{\\\"id\\\":\\\"2\\\",\\\"name\\\":\\\"jim\\\",\\\"key\\\":\\\"task_jim\\\",\\\"type\\\":\\\"textbox\\\",\\\"condition\\\":1,\\\"idname\\\":\\\"task_jim\\\",\\\"pattern\\\":\\\"^[a-zA-Z ]*$\\\",\\\"errormsg\\\":\\\"Only Text is allowed\\\",\\\"maxlength\\\":156,\\\"mandatory\\\":1,\\\"_default\\\":\\\"\\\",\\\"dropdownoptionvalue\\\":\\\"\\\",\\\"userdefine\\\":\\\"A\\\"}]\",\"tl_markcompleted\":0,\"tl_jobmode\":\"contact\",\"tl_recurrencerule\":null,\"tl_repeatmaindescription\":null,\"tl_repeatmethod\":\"daily\",\"tl_starttask\":null,\"tl_startdata\":null,\"tl_endtask\":null,\"tl_enddata\":null,\"tl_createdat\":\"2025-03-25T09:33:39.000000Z\",\"tl_createdby\":1,\"tl_updatedby\":null,\"tl_updatedat\":\"2025-03-25T09:33:39.000000Z\",\"tl_istaskrepeat\":0,\"tl_deviceplatform\":2,\"tl_subject\":null,\"tl_immediate_notification\":0,\"tl_parent_task_id\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17847", "cl_createdat": "1742895219.000000", "cl_updatedat": null } ], "updated": [], "deleted": [] }, "bm_productInfo": { "created": [], "updated": [], "deleted": [] }, "bm_fields": { "created": [], "updated": [], "deleted": [] }, "bm_fieldOptionLink": { "created": [], "updated": [], "deleted": [] }, "bm_option": { "created": [], "updated": [], "deleted": [] }, "bm_optionproduct": { "created": [], "updated": [], "deleted": [] }, "bm_linkedfieldswithproduct": { "created": [], "updated": [], "deleted": [] }, "bm_productionstatus": { "created": [], "updated": [], "deleted": [] }, "bm_productpricemap": { "created": [], "updated": [], "deleted": [] }, "bm_productrecipe": { "created": [], "updated": [], "deleted": [] }, "bm_productrecipemap": { "created": [], "updated": [], "deleted": [] }, "bm_supproductcode": { "created": [], "updated": [], "deleted": [] }, "bm_rulesetup": { "created": [], "updated": [], "deleted": [] }, "bm_formulas": { "created": [], "updated": [], "deleted": [] }, "bm_customercommission": { "created": [], "updated": [], "deleted": [] }, "bm_productgroupdetails": { "created": [], "updated": [], "deleted": [] }, "bm_productgroupmaterialmap": { "created": [], "updated": [], "deleted": [] }, "bm_productpricedetails": { "created": [], "updated": [], "deleted": [] }, "bm_fabriccolourmap": { "created": [], "updated": [], "deleted": [] }, "bm_fabricdetails": { "created": [], "updated": [], "deleted": [] }, "bm_colordetails": { "created": [], "updated": [], "deleted": [] }, "bm_optiondiscount": { "created": [], "updated": [], "deleted": [] }, "bm_optionpricebook": { "created": [], "updated": [], "deleted": [] }, "bm_allowances": { "created": [], "updated": [], "deleted": [] }, "bm_xyoptionpricedata": { "created": [], "updated": [], "deleted": [] }, "bm_delivery_cost_setup": { "created": [], "updated": [], "deleted": [] }, "bm_organizationdetails": { "created": [], "updated": [], "deleted": [] }, "bm_applicationSetup": { "created": [], "updated": [], "deleted": [] } }, "synctodelete": { "bm_customercontactinfo": { "51742885332": 619 }, "bm_customertemplatedata": { "31742885332": 597 }, "bm_jobdetails": { "41742885332": 850 }, "bm_jobmultiquote": { "141742885332": 873 }, "bm_tasklist": { "21742895211": 98 } }, "timestamp": 1742895219 }