{ "status": "success", "upcomingorder_list": { "bm_customertemplatedata": { "created": [], "updated": [ { "ctd_id": 4014, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\": 1, \"600\": 25, \"62\": \"QUOT0019\"}", "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": "4014", "ctd_createdat": 1748859392, "ctd_updatedat": 1748859484, "ctd_createdby": 0, "ctd_updatedby": null }, { "ctd_id": 4015, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\": 1, \"600\": 25, \"62\": \"QUOT0020\"}", "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": "4015", "ctd_createdat": 1748859399, "ctd_updatedat": 1748859485, "ctd_createdby": 0, "ctd_updatedby": null } ], "deleted": [] }, "bm_customercontactinfo": { "created": [], "updated": [ { "cci_id": 4192, "cci_customerid": 4014, "cci_templateid": 3, "roleid": 0, "cci_customizedarray": "{\"75\":12,\"79\":\"Quote 20\",\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"Quote 20\",\"90\":36,\"91\":\"Quote 20\"}", "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": 31748859392, "id": "4192", "cci_createdat": 1748859392, "cci_updatedat": 1748859485, "cci_createdby": 0, "cci_updatedby": null }, { "cci_id": 4193, "cci_customerid": 4015, "cci_templateid": 3, "roleid": 0, "cci_customizedarray": "{\"75\":12,\"79\":\"Quote 21\",\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"Quote 21\",\"90\":36,\"91\":\"Quote 21\"}", "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": 31748859399, "id": "4193", "cci_createdat": 1748859399, "cci_updatedat": 1748859485, "cci_createdby": 0, "cci_updatedby": null } ], "deleted": [] }, "bm_appointment": { "created": [], "updated": [], "deleted": [] }, "bm_tasklist": { "created": [ { "tl_id": 94, "tl_orderid": 5676, "tl_taskcategory": 1, "tl_taskdate": "2025-06-02", "tl_tasktime": "15:47:03", "tl_taskmethod": "0", "tl_istaskprivate": 0, "tl_userid": "8", "tl_priority": 0, "tl_addjobid": 5676, "tl_desc": "Task for jai @123456", "tl_status": 0, "tl_markasread": 0, "tl_taskstatus": 2, "tl_userdefinedfields": "[{\"id\":\"1\",\"name\":\"text\",\"key\":\"task_text\",\"type\":\"textbox\",\"condition\":1,\"idname\":\"task_text\",\"pattern\":\"^[a-zA-Z ]*$\",\"errormsg\":\"Only Text is allowed\",\"maxlength\":156,\"mandatory\":0,\"_default\":\"\",\"dropdownoptionvalue\":\"\",\"userdefine\":\"Test \"},{\"id\":\"2\",\"name\":\"data\",\"key\":\"task_data\",\"type\":\"dropdown\",\"condition\":0,\"idname\":\"task_data\",\"pattern\":\"\",\"errormsg\":\"\",\"maxlength\":0,\"mandatory\":1,\"_default\":\"sample\",\"dropdownoptionvalue\":[{\"key\":\"1\",\"value\":\"1\"},{\"key\":\"2\",\"value\":\"2\"}],\"userdefine\":\"1\"},{\"id\":\"3\",\"name\":\"hap 1\",\"key\":\"task_hap1\",\"type\":\"date\",\"condition\":7,\"idname\":\"task_hap1\",\"pattern\":\"\",\"errormsg\":\"\",\"maxlength\":0,\"mandatory\":1,\"_default\":\"\",\"dropdownoptionvalue\":\"\",\"userdefine\":\"2025-06-13T10:17:00.000Z\"}]", "tl_markcompleted": 0, "tl_jobmode": "job", "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": "94", "tl_createdat": 1748859485, "tl_updatedat": 1748859485, "tl_createdby": 21, "tl_updatedby": null } ], "updated": [], "deleted": [] }, "bm_jobdetails": { "created": [ { "jd_id": 5700, "jd_customerid": 4014, "jd_contactid": 4192, "jd_additionalcontacts": "4192", "jd_templateid": 1, "jd_jobmultiquoteid": 5728, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5697", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "QUOT0019", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "70.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "70.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "jd_isroundon": 0, "jd_grossprice": "70.00", "jd_grossprofit": "70.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "70.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": 21, "jd_updatedby": 21, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 20, "jd_deliveryvatperc": "7.750", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5697\",\"35\":\"QUOT0019\",\"36\":1,\"37\":1,\"38\":\"\",\"39\":\"\",\"40\":13,\"41\":21,\"44\":\"\",\"45\":\"\",\"46\":\"Quote 20\",\"47\":\"\",\"48\":\"\",\"49\":\"Quote 20\",\"50\":\"\",\"51\":\"Quote 20\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":12,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":21,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"countryText\":\"India\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "7.750", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5700", "jd_createddate": 1748822400, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1748859392, "jd_updatedat": 1748859485 }, { "jd_id": 5701, "jd_customerid": 4015, "jd_contactid": 4193, "jd_additionalcontacts": "4193", "jd_templateid": 1, "jd_jobmultiquoteid": 5729, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5698", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "QUOT0020", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "70.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "70.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "jd_isroundon": 0, "jd_grossprice": "70.00", "jd_grossprofit": "70.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "70.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": 21, "jd_updatedby": 21, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 21, "jd_deliveryvatperc": "7.750", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5698\",\"35\":\"QUOT0020\",\"36\":1,\"37\":1,\"38\":\"\",\"39\":\"\",\"40\":13,\"41\":21,\"44\":\"\",\"45\":\"\",\"46\":\"Quote 21\",\"47\":\"\",\"48\":\"\",\"49\":\"Quote 21\",\"50\":\"\",\"51\":\"Quote 21\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":12,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":21,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"countryText\":\"India\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "7.750", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5701", "jd_createddate": 1748822400, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1748859399, "jd_updatedat": 1748859485 } ], "updated": [ { "jd_id": 5700, "jd_customerid": 4014, "jd_contactid": 4192, "jd_additionalcontacts": "4192", "jd_templateid": 1, "jd_jobmultiquoteid": 5728, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5697", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "QUOT0019", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "70.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "70.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "jd_isroundon": 0, "jd_grossprice": "70.00", "jd_grossprofit": "70.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "70.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": 21, "jd_updatedby": 21, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 20, "jd_deliveryvatperc": "7.750", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5697\",\"35\":\"QUOT0019\",\"36\":1,\"37\":1,\"38\":\"\",\"39\":\"\",\"40\":13,\"41\":21,\"44\":\"\",\"45\":\"\",\"46\":\"Quote 20\",\"47\":\"\",\"48\":\"\",\"49\":\"Quote 20\",\"50\":\"\",\"51\":\"Quote 20\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":12,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":21,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"countryText\":\"India\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "7.750", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5700", "jd_createddate": 1748822400, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1748859392, "jd_updatedat": 1748859485 }, { "jd_id": 5701, "jd_customerid": 4015, "jd_contactid": 4193, "jd_additionalcontacts": "4193", "jd_templateid": 1, "jd_jobmultiquoteid": 5729, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5698", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "QUOT0020", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "70.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "70.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "jd_isroundon": 0, "jd_grossprice": "70.00", "jd_grossprofit": "70.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "70.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": 21, "jd_updatedby": 21, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 21, "jd_deliveryvatperc": "7.750", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5698\",\"35\":\"QUOT0020\",\"36\":1,\"37\":1,\"38\":\"\",\"39\":\"\",\"40\":13,\"41\":21,\"44\":\"\",\"45\":\"\",\"46\":\"Quote 21\",\"47\":\"\",\"48\":\"\",\"49\":\"Quote 21\",\"50\":\"\",\"51\":\"Quote 21\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":12,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":21,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"countryText\":\"India\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "7.750", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5701", "jd_createddate": 1748822400, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1748859399, "jd_updatedat": 1748859485 } ], "deleted": [] }, "bm_orderitem": { "created": [], "updated": [], "deleted": [] }, "bm_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_notelist": { "created": [ { "nl_id": 105171, "nl_ordertempid": 0, "nl_orderid": 5700, "nl_notescategory": 1, "nl_type": 17, "nl_platform": 2, "nl_desc": "New job has been created in job", "nl_manualNotes": null, "nl_createdby": "21", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 0, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "105171", "nl_endddate": 1748822400, "nl_starttime": 1748859392, "created_at": 1748859392, "updated_at": 1748859485, "created_by": 21, "updated_by": null }, { "nl_id": 105172, "nl_ordertempid": 0, "nl_orderid": 5701, "nl_notescategory": 1, "nl_type": 17, "nl_platform": 2, "nl_desc": "New job has been created in job", "nl_manualNotes": null, "nl_createdby": "21", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 0, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "105172", "nl_endddate": 1748822400, "nl_starttime": 1748859399, "created_at": 1748859399, "updated_at": 1748859485, "created_by": 21, "updated_by": null } ], "updated": [], "deleted": [] }, "bm_deliveryaddresssetting": { "created": [], "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": 5728, "jmq_jobid": 5700, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "0.00", "jmq_netprice": "70.00", "jmq_vat": "0.00", "jmq_isvaton": 1, "jmq_deliverycost": "70.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 1, "jmq_orderformprice": "0.00", "jmq_editpricebyid": null, "jmq_isroundon": 0, "jmq_grossprice": "70.00", "jmq_grossprofit": "70.00", "jmq_costprice": "0.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "70.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": "7.750", "jmq_cdeliveryvatperc": "7.750", "id": "5728", "jmq_duedate": null, "jmq_sceduleddate": null, "jmq_createdat": "1748859392.000000", "jmq_updatedat": null, "jmq_createdby": 21, "jmq_updatedby": null }, { "jmq_id": 5729, "jmq_jobid": 5701, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "0.00", "jmq_netprice": "70.00", "jmq_vat": "0.00", "jmq_isvaton": 1, "jmq_deliverycost": "70.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 1, "jmq_orderformprice": "0.00", "jmq_editpricebyid": null, "jmq_isroundon": 0, "jmq_grossprice": "70.00", "jmq_grossprofit": "70.00", "jmq_costprice": "0.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "70.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": "7.750", "jmq_cdeliveryvatperc": "7.750", "id": "5729", "jmq_duedate": null, "jmq_sceduleddate": null, "jmq_createdat": "1748859399.000000", "jmq_updatedat": null, "jmq_createdby": 21, "jmq_updatedby": null } ], "updated": [], "deleted": [] }, "bm_jobstatus_tracks": { "created": [ { "jst_id": 6384, "jst_jobid": 5700, "jst_job_current_status": 1, "id": "6384", "jst_createdat": "1748859485.410182" }, { "jst_id": 6385, "jst_jobid": 5701, "jst_job_current_status": 1, "id": "6385", "jst_createdat": "1748859485.537335" } ], "updated": [], "deleted": [] }, "bm_customindividuallogs": { "created": [ { "cl_id": 57241, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 5700, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5700, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 21, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"Aquarius Blinds\",\"\":\"India\",\"Account Type\":\"Domestic\",\"Created By\":\"Bharani\",\"Last Name\":\"Quote 20\",\"Address1\":\"Quote 20\",\"Town \\\/ City\":\"Quote 20\",\"Country\":\"India\",\"Salutation\":\"Dr\",\"Assigned to\":21,\"Additional Contacts\":\"4192\",\"Job Ref No\":\"AQ5697\",\"Job Status\":\"Lead\",\"Order Status\":\"Enquiry\",\"Net Price\":\"70.00\",\"VAT\":\"Enabled\",\"DeliveryCost\":\"70.00\",\"Delivery Cost\":\"All Options\",\"Gross Price Amount\":\"70.00\",\"Gross Profit\":\"70.00\",\"Amount Outstanding\":\"70.00\",\"jd_isonlineorder\":1,\"jd_quickquote\":20,\"Delivery Vat Percentage\":\"7.750\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":5700,\"jd_customerid\":4014,\"jd_contactid\":4192,\"jd_additionalcontacts\":\"4192\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"AQ5697\\\",\\\"35\\\":\\\"QUOT0019\\\",\\\"36\\\":1,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":\\\"\\\",\\\"40\\\":13,\\\"41\\\":21,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"\\\",\\\"46\\\":\\\"Quote 20\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"Quote 20\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"Quote 20\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":36,\\\"285\\\":12,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":21,\\\"558\\\":\\\"\\\",\\\"559\\\":1,\\\"610\\\":\\\"\\\",\\\"611\\\":\\\"\\\",\\\"612\\\":1,\\\"countryText\\\":\\\"India\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-06-02\",\"jd_orderdate\":null,\"jd_duedate\":null,\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":null,\"jd_jobref\":\"AQ5697\",\"jd_jobstatus\":1,\"jd_contactaddid\":0,\"jd_orderstatus\":13,\"jd_accref\":\"QUOT0019\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"0.00\",\"jd_netprice\":\"70.00\",\"jd_vat\":\"0.00\",\"jd_isvaton\":1,\"jd_deliverycost\":\"70.00\",\"jd_deliverycosttypeid\":1,\"jd_overridetypeid\":1,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":null,\"jd_isroundon\":0,\"jd_grossprice\":\"70.00\",\"jd_grossprofit\":\"70.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"0.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"70.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_organizationid\":0,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":21,\"jd_createdat\":\"2025-06-02T10:16:32.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-06-02T10:18:05.000000Z\",\"salesorderid\":null,\"jd_deviceplatform\":0,\"jd_fromjobref\":\"\",\"jd_fromdbname\":null,\"jd_importorder\":0,\"jd_quickquote\":20,\"jd_myob_flag\":0,\"jd_myobinvoiceid\":\"\",\"jd_qboflag\":0,\"jd_qboinvoiceid\":0,\"jd_qbodisplayname\":\"\",\"jd_deliveryvatperc\":\"7.750\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"7.750\",\"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": "57241", "cl_createdat": "1748859485.000000", "cl_updatedat": null }, { "cl_id": 57242, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 5701, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5701, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 21, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"Aquarius Blinds\",\"\":\"India\",\"Account Type\":\"Domestic\",\"Created By\":\"Bharani\",\"Last Name\":\"Quote 21\",\"Address1\":\"Quote 21\",\"Town \\\/ City\":\"Quote 21\",\"Country\":\"India\",\"Salutation\":\"Dr\",\"Assigned to\":21,\"Additional Contacts\":\"4193\",\"Job Ref No\":\"AQ5698\",\"Job Status\":\"Lead\",\"Order Status\":\"Enquiry\",\"Net Price\":\"70.00\",\"VAT\":\"Enabled\",\"DeliveryCost\":\"70.00\",\"Delivery Cost\":\"All Options\",\"Gross Price Amount\":\"70.00\",\"Gross Profit\":\"70.00\",\"Amount Outstanding\":\"70.00\",\"jd_isonlineorder\":1,\"jd_quickquote\":21,\"Delivery Vat Percentage\":\"7.750\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":5701,\"jd_customerid\":4015,\"jd_contactid\":4193,\"jd_additionalcontacts\":\"4193\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"AQ5698\\\",\\\"35\\\":\\\"QUOT0020\\\",\\\"36\\\":1,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":\\\"\\\",\\\"40\\\":13,\\\"41\\\":21,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"\\\",\\\"46\\\":\\\"Quote 21\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"Quote 21\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"Quote 21\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":36,\\\"285\\\":12,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":21,\\\"558\\\":\\\"\\\",\\\"559\\\":1,\\\"610\\\":\\\"\\\",\\\"611\\\":\\\"\\\",\\\"612\\\":1,\\\"countryText\\\":\\\"India\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-06-02\",\"jd_orderdate\":null,\"jd_duedate\":null,\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":null,\"jd_jobref\":\"AQ5698\",\"jd_jobstatus\":1,\"jd_contactaddid\":0,\"jd_orderstatus\":13,\"jd_accref\":\"QUOT0020\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"0.00\",\"jd_netprice\":\"70.00\",\"jd_vat\":\"0.00\",\"jd_isvaton\":1,\"jd_deliverycost\":\"70.00\",\"jd_deliverycosttypeid\":1,\"jd_overridetypeid\":1,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":null,\"jd_isroundon\":0,\"jd_grossprice\":\"70.00\",\"jd_grossprofit\":\"70.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"0.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"70.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_organizationid\":0,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":21,\"jd_createdat\":\"2025-06-02T10:16:39.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-06-02T10:18:05.000000Z\",\"salesorderid\":null,\"jd_deviceplatform\":0,\"jd_fromjobref\":\"\",\"jd_fromdbname\":null,\"jd_importorder\":0,\"jd_quickquote\":21,\"jd_myob_flag\":0,\"jd_myobinvoiceid\":\"\",\"jd_qboflag\":0,\"jd_qboinvoiceid\":0,\"jd_qbodisplayname\":\"\",\"jd_deliveryvatperc\":\"7.750\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"7.750\",\"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": "57242", "cl_createdat": "1748859485.000000", "cl_updatedat": null }, { "cl_id": 57243, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105171, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 5700, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 21, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"Job Created\",\"Platform\":\"Trade\",\"Description\":\"New job has been created in job\",\"Created By\":\"Bharani\",\"Date\":\"2025-06-02\",\"Time\":\"10:16:32\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105171,\"nl_ordertempid\":0,\"nl_orderid\":5700,\"nl_notescategory\":1,\"nl_type\":17,\"nl_platform\":2,\"nl_desc\":\"New job has been created in job\",\"nl_manualNotes\":null,\"nl_createdby\":\"21\",\"nl_endddate\":\"2025-06-02\",\"nl_starttime\":\"10:16:32\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":21,\"created_at\":\"2025-06-02T10:16:32.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-02T10:18:05.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "57243", "cl_createdat": "1748859485.000000", "cl_updatedat": null }, { "cl_id": 57244, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105172, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 5701, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 21, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"Job Created\",\"Platform\":\"Trade\",\"Description\":\"New job has been created in job\",\"Created By\":\"Bharani\",\"Date\":\"2025-06-02\",\"Time\":\"10:16:39\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105172,\"nl_ordertempid\":0,\"nl_orderid\":5701,\"nl_notescategory\":1,\"nl_type\":17,\"nl_platform\":2,\"nl_desc\":\"New job has been created in job\",\"nl_manualNotes\":null,\"nl_createdby\":\"21\",\"nl_endddate\":\"2025-06-02\",\"nl_starttime\":\"10:16:39\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":21,\"created_at\":\"2025-06-02T10:16:39.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-02T10:18:05.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "57244", "cl_createdat": "1748859485.000000", "cl_updatedat": null }, { "cl_id": 57245, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in AQ5697", "cl_event": "created", "cl_subjectid": 5728, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 5700, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 21, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":5728,\"jmq_jobid\":5700,\"Quotation Name\":\"Q1\",\"jmq_isdefault\":0,\"Quotation\":\"Accepted\",\"jmq_isdeclined\":0,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"Production Due Date\":\"0000-00-00\",\"List Price\":\"0.00\",\"Net Price\":\"70.00\",\"VAT Price\":\"0.00\",\"VAT\":1,\"jmq_deliverycost\":\"70.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"70.00\",\"Gross Profit\":\"70.00\",\"Total CostPrice\":\"0.00\",\"Amount Outstanding\":\"70.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\":\"7.750\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":5728,\"jmq_jobid\":5700,\"jmq_quotationname\":\"Q1\",\"jmq_isdefault\":0,\"jmq_isaccepted\":1,\"jmq_isdeclined\":0,\"jmq_esignflag\":null,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"jmq_duedate\":\"0000-00-00\",\"jmq_sceduleddate\":\"0000-00-00\",\"jmq_listprice\":\"0.00\",\"jmq_netprice\":\"70.00\",\"jmq_vat\":\"0.00\",\"jmq_isvaton\":1,\"jmq_deliverycost\":\"70.00\",\"jmq_deliverycosttypeid\":1,\"jmq_overridetypeid\":1,\"jmq_orderformprice\":\"0.00\",\"jmq_editpricebyid\":null,\"jmq_isroundon\":0,\"jmq_grossprice\":\"70.00\",\"jmq_grossprofit\":\"70.00\",\"jmq_costprice\":\"0.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"70.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\":\"7.750\",\"jmq_cdeliveryvatperc\":\"7.750\",\"jmq_createdby\":21,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-06-02T10:16:32.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": "57245", "cl_createdat": "1748859485.000000", "cl_updatedat": null }, { "cl_id": 57246, "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": 5700, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5700, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 21, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":5728}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":5728},\"old\":{\"jd_jobmultiquoteid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "57246", "cl_createdat": "1748859485.000000", "cl_updatedat": null }, { "cl_id": 57247, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in AQ5698", "cl_event": "created", "cl_subjectid": 5729, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 5701, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 21, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":5729,\"jmq_jobid\":5701,\"Quotation Name\":\"Q1\",\"jmq_isdefault\":0,\"Quotation\":\"Accepted\",\"jmq_isdeclined\":0,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"Production Due Date\":\"0000-00-00\",\"List Price\":\"0.00\",\"Net Price\":\"70.00\",\"VAT Price\":\"0.00\",\"VAT\":1,\"jmq_deliverycost\":\"70.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"70.00\",\"Gross Profit\":\"70.00\",\"Total CostPrice\":\"0.00\",\"Amount Outstanding\":\"70.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\":\"7.750\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":5729,\"jmq_jobid\":5701,\"jmq_quotationname\":\"Q1\",\"jmq_isdefault\":0,\"jmq_isaccepted\":1,\"jmq_isdeclined\":0,\"jmq_esignflag\":null,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"jmq_duedate\":\"0000-00-00\",\"jmq_sceduleddate\":\"0000-00-00\",\"jmq_listprice\":\"0.00\",\"jmq_netprice\":\"70.00\",\"jmq_vat\":\"0.00\",\"jmq_isvaton\":1,\"jmq_deliverycost\":\"70.00\",\"jmq_deliverycosttypeid\":1,\"jmq_overridetypeid\":1,\"jmq_orderformprice\":\"0.00\",\"jmq_editpricebyid\":null,\"jmq_isroundon\":0,\"jmq_grossprice\":\"70.00\",\"jmq_grossprofit\":\"70.00\",\"jmq_costprice\":\"0.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"70.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\":\"7.750\",\"jmq_cdeliveryvatperc\":\"7.750\",\"jmq_createdby\":21,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-06-02T10:16:39.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": "57247", "cl_createdat": "1748859485.000000", "cl_updatedat": null }, { "cl_id": 57248, "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": 5701, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5701, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 21, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":5729}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":5729},\"old\":{\"jd_jobmultiquoteid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "57248", "cl_createdat": "1748859485.000000", "cl_updatedat": null }, { "cl_id": 57249, "cl_logname": "default", "cl_type": null, "cl_modulename": "Task", "cl_message": "new item has been created in Task", "cl_event": "created", "cl_subjectid": 94, "cl_subjecttype": "App\\Models\\Task\\bm_tasklist", "cl_parentid": 5676, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 21, "cl_changedfrom": "null", "cl_changedto": "{\"\":\"1\",\"text\":\"2\",\"Job Ref No\":\"AQ5675\",\"Category\":\"High\",\"Task Date\":\"2025-06-02\",\"Task Time\":\"12:47:03\",\"Created By\":\"Jai\",\"Description\":\"Task for jai @123456\",\"Repeat Method\":\"daily\",\"tl_deviceplatform\":2}", "cl_customproperties": "{\"attributes\":{\"tl_id\":94,\"tl_orderid\":5676,\"tl_taskcategory\":1,\"tl_taskdate\":\"2025-06-02\",\"tl_tasktime\":\"12:47:03\",\"tl_taskmethod\":\"0\",\"tl_istaskprivate\":0,\"tl_userid\":\"8\",\"tl_priority\":0,\"tl_addjobid\":5676,\"tl_desc\":\"Task for jai @123456\",\"tl_status\":0,\"tl_markasread\":0,\"tl_taskstatus\":2,\"tl_userdefinedfields\":\"[{\\\"id\\\":\\\"1\\\",\\\"name\\\":\\\"text\\\",\\\"key\\\":\\\"task_text\\\",\\\"type\\\":\\\"textbox\\\",\\\"condition\\\":1,\\\"idname\\\":\\\"task_text\\\",\\\"pattern\\\":\\\"^[a-zA-Z ]*$\\\",\\\"errormsg\\\":\\\"Only Text is allowed\\\",\\\"maxlength\\\":156,\\\"mandatory\\\":0,\\\"_default\\\":\\\"\\\",\\\"dropdownoptionvalue\\\":\\\"\\\",\\\"userdefine\\\":\\\"Test \\\"},{\\\"id\\\":\\\"2\\\",\\\"name\\\":\\\"data\\\",\\\"key\\\":\\\"task_data\\\",\\\"type\\\":\\\"dropdown\\\",\\\"condition\\\":0,\\\"idname\\\":\\\"task_data\\\",\\\"pattern\\\":\\\"\\\",\\\"errormsg\\\":\\\"\\\",\\\"maxlength\\\":0,\\\"mandatory\\\":1,\\\"_default\\\":\\\"sample\\\",\\\"dropdownoptionvalue\\\":[{\\\"key\\\":\\\"1\\\",\\\"value\\\":\\\"1\\\"},{\\\"key\\\":\\\"2\\\",\\\"value\\\":\\\"2\\\"}],\\\"userdefine\\\":\\\"1\\\"},{\\\"id\\\":\\\"3\\\",\\\"name\\\":\\\"hap 1\\\",\\\"key\\\":\\\"task_hap1\\\",\\\"type\\\":\\\"date\\\",\\\"condition\\\":7,\\\"idname\\\":\\\"task_hap1\\\",\\\"pattern\\\":\\\"\\\",\\\"errormsg\\\":\\\"\\\",\\\"maxlength\\\":0,\\\"mandatory\\\":1,\\\"_default\\\":\\\"\\\",\\\"dropdownoptionvalue\\\":\\\"\\\",\\\"userdefine\\\":\\\"2025-06-13T10:17:00.000Z\\\"}]\",\"tl_markcompleted\":0,\"tl_jobmode\":\"job\",\"tl_recurrencerule\":null,\"tl_repeatmaindescription\":null,\"tl_repeatmethod\":\"daily\",\"tl_starttask\":null,\"tl_startdata\":null,\"tl_endtask\":null,\"tl_enddata\":null,\"tl_createdat\":\"2025-06-02T10:18:05.000000Z\",\"tl_createdby\":21,\"tl_updatedby\":null,\"tl_updatedat\":\"2025-06-02T10:18:05.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": "57249", "cl_createdat": "1748859485.000000", "cl_updatedat": null } ], "updated": [], "deleted": [] }, "bm_productInfo": { "created": [], "updated": [ { "pi_productid": 9, "pi_productname": "Vision Blinds", "pi_pcode": "121", "pi_category": 3, "pi_productgroup": 1, "pi_producttype": 0, "pi_qtyperunit": "0.00", "pi_unitprice": "0.00", "pi_costfactor": null, "pi_commissionrate": "0.000", "pi_commissionmethod": null, "pi_reorderlevel": null, "pi_taxclass": null, "pi_serialno": null, "pi_qtyinstock": null, "pi_supplierid": null, "pi_imagename": null, "pi_currencyid": null, "pi_supplierdefault": null, "pi_productseqno": null, "pi_domesticmarkup": "0.00", "pi_contractmarkup": "0.00", "pi_trademarkup": "0.00", "pi_childsafe": null, "pi_quantyshowhide": null, "pi_compquantyshowhide": null, "pi_stockcontrol": null, "pi_productiontab": null, "pi_fabriccolorcodehide": null, "pi_defaultunitfornewcurtainsorder": null, "pi_costpricecomesfrom": "2", "pi_netpricecomesfrom": "2", "pi_shuttercontract": "0.00", "pi_shuttertrade": "0.00", "pi_shutterdomestic": "0.00", "pi_shutterecommerce": "0.00", "pi_customerdiscount": null, "pi_discountoverridesubwidth": null, "pi_manufacturer_cost": null, "pi_fabrichide": null, "pi_hidecompparameter": null, "pi_factorybarcodeproduct": null, "pi_showhideproductorder": 1, "pi_ecommercestatus": 0, "pi_productdescription": "", "pi_ecomproductdesc": null, "pi_homeimage": null, "pi_galleryimage": null, "pi_innerpageimage": null, "pi_frameimage": "[]", "pi_ecommercecompmarkup": "0.00", "pi_showframeminmax": null, "pi_fabricdefaultdiscount": null, "pi_productstatusmultiple": null, "pi_followproductionseq": 1, "pi_productionformulasheetname": null, "pi_productrules": null, "pi_showexcelfromula": null, "pi_supplierheading": null, "pi_producttypehide": null, "pi_dualproducttypeheading": "Fabric 2", "pi_fabricheading": null, "pi_dualproducttypeenable": 0, "pi_fabricbeforeproducttype": null, "pi_suppliermandatory": null, "pi_showfabric": null, "pi_ecommercesample": "1", "pi_priceavalcheck": null, "pi_showcomponentcode": null, "pi_showmaxarea": null, "pi_recessallowance": null, "pi_deductionname": null, "pi_deductionvalue": "0.00", "pi_stackqty": null, "pi_blindstype": null, "pi_suppliershowhide": null, "pi_pricealert": null, "pi_metatitle": null, "pi_metadescription": null, "pi_metakeyword": null, "pi_canonicaltag": null, "pi_alttexttag": null, "pi_headertag": "H1", "pi_productimage": "[]", "pi_workroom": 1, "pi_mobileapp": 1, "pi_jobtransfer": 0, "pi_seq": 7, "pi_status": 0, "pi_createdby": 1, "pi_defaultunittype": 2, "pi_jobfraction": 1, "pi_unittypeseq": "2,3,1,4", "pi_deafultimage": "{\"defaultimage\":{\"framedefault\":\"\",\"productdefault\":\"\",\"backgrounddefault\":\"\",\"bannerdefault\":\"\"}}", "pi_backgroundimage": "[]", "pi_discountappliesto": "{\"optionschk\":1,\"operationschk\":1,\"pricetablechk\":1}", "pi_ecomProductName": null, "pi_productgroupseq": null, "pi_unitypedata": "{\"1\":1,\"2\":1,\"3\":1,\"4\":1}", "id": "9" } ], "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": { "51748859392": 4192, "51748859399": 4193 }, "bm_customertemplatedata": { "31748859392": 4014, "31748859399": 4015 }, "bm_jobdetails": { "41748859392": 5700, "41748859399": 5701 }, "bm_notelist": { "61748859392": 105171, "61748859399": 105172 }, "bm_jobmultiquote": { "141748859392": 5728, "141748859399": 5729 }, "bm_tasklist": { "21748859478": 94 } }, "timestamp": 1748859484 }