{ "status": "success", "upcomingorder_list": { "bm_customertemplatedata": { "created": [ { "ctd_id": 176, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\": 1, \"605\": 25, \"62\": \"QUOT0004\"}", "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": "176", "ctd_createdat": 1754584174, "ctd_updatedat": 1754584865, "ctd_createdby": 0, "ctd_updatedby": null }, { "ctd_id": 177, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\": 1, \"605\": 25, \"62\": \"QUOT0005\"}", "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": "177", "ctd_createdat": 1754584252, "ctd_updatedat": 1754584865, "ctd_createdby": 0, "ctd_updatedby": null } ], "updated": [ { "ctd_id": 176, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\": 1, \"605\": 25, \"62\": \"QUOT0004\"}", "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": "176", "ctd_createdat": 1754584174, "ctd_updatedat": 1754584865, "ctd_createdby": 0, "ctd_updatedby": null }, { "ctd_id": 177, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\": 1, \"605\": 25, \"62\": \"QUOT0005\"}", "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": "177", "ctd_createdat": 1754584252, "ctd_updatedat": 1754584865, "ctd_createdby": 0, "ctd_updatedby": null } ], "deleted": [] }, "bm_customercontactinfo": { "created": [ { "cci_id": 194, "cci_customerid": 176, "cci_templateid": 3, "roleid": 0, "cci_customizedarray": "{\"75\":1,\"79\":\"Quote 19\",\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"Quote 19\",\"90\":37,\"91\":\"Quote 19\"}", "cci_ismarketingemails": 0, "cci_smsverifystatus": 0, "cci_isdocumentreceived": 0, "cci_receiveddocfor": null, "cci_isonlineportal": 0, "cci_latitude": null, "cci_longitude": null, "cci_username": null, "cci_password": null, "cci_confirmpassword": null, "cci_seq": 0, "cci_status": 0, "cci_deviceplatform": 1, "cci_mobcustomertempid": 31754584174, "id": "194", "cci_createdat": 1754584174, "cci_updatedat": 1754584865, "cci_createdby": 0, "cci_updatedby": null }, { "cci_id": 195, "cci_customerid": 177, "cci_templateid": 3, "roleid": 0, "cci_customizedarray": "{\"75\":1,\"79\":\"Quote 20\",\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"Quote 20\",\"90\":37,\"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": 1, "cci_mobcustomertempid": 31754584252, "id": "195", "cci_createdat": 1754584252, "cci_updatedat": 1754584865, "cci_createdby": 0, "cci_updatedby": null } ], "updated": [ { "cci_id": 194, "cci_customerid": 176, "cci_templateid": 3, "roleid": 0, "cci_customizedarray": "{\"75\":1,\"79\":\"Quote 19\",\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"Quote 19\",\"90\":37,\"91\":\"Quote 19\"}", "cci_ismarketingemails": 0, "cci_smsverifystatus": 0, "cci_isdocumentreceived": 0, "cci_receiveddocfor": null, "cci_isonlineportal": 0, "cci_latitude": null, "cci_longitude": null, "cci_username": null, "cci_password": null, "cci_confirmpassword": null, "cci_seq": 0, "cci_status": 0, "cci_deviceplatform": 1, "cci_mobcustomertempid": 31754584174, "id": "194", "cci_createdat": 1754584174, "cci_updatedat": 1754584865, "cci_createdby": 0, "cci_updatedby": null }, { "cci_id": 195, "cci_customerid": 177, "cci_templateid": 3, "roleid": 0, "cci_customizedarray": "{\"75\":1,\"79\":\"Quote 20\",\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"Quote 20\",\"90\":37,\"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": 1, "cci_mobcustomertempid": 31754584252, "id": "195", "cci_createdat": 1754584252, "cci_updatedat": 1754584865, "cci_createdby": 0, "cci_updatedby": null } ], "deleted": [] }, "bm_appointment": { "created": [], "updated": [], "deleted": [] }, "bm_tasklist": { "created": [], "updated": [], "deleted": [] }, "bm_jobdetails": { "created": [ { "jd_id": 1003, "jd_customerid": 176, "jd_contactid": 194, "jd_additionalcontacts": "194", "jd_templateid": 1, "jd_jobmultiquoteid": 1007, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "ON2894", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "QUOT0004", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "0.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": 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": 5, "jd_updatedby": 5, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 19, "jd_deliveryvatperc": "7.250", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"ON2894\",\"35\":\"QUOT0004\",\"36\":1,\"37\":1,\"38\":\"\",\"39\":\"\",\"40\":1,\"41\":5,\"44\":\"\",\"45\":\"\",\"46\":\"Quote 19\",\"47\":\"\",\"48\":\"\",\"49\":\"Quote 19\",\"50\":\"\",\"51\":\"Quote 19\",\"52\":\"\",\"53\":\"\",\"54\":37,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":5,\"562\":\"\",\"615\":\"\",\"616\":\"\",\"617\":\"1\",\"618\":\"\",\"countryText\":\"USA\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "7.250", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "jd_organizationid": 25, "id": "1003", "jd_createddate": 1754524800, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1754584174, "jd_updatedat": 1754584865 }, { "jd_id": 1004, "jd_customerid": 177, "jd_contactid": 195, "jd_additionalcontacts": "195", "jd_templateid": 1, "jd_jobmultiquoteid": 1008, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "ON2895", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "QUOT0005", "jd_invoiceno": "", "jd_listprice": "195.00", "jd_netprice": "195.00", "jd_vat": "14.14", "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": "209.14", "jd_grossprofit": "0.00", "jd_costprice": "75.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "209.14", "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": 5, "jd_updatedby": 5, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 20, "jd_deliveryvatperc": "7.250", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"ON2895\",\"35\":\"QUOT0005\",\"36\":1,\"37\":1,\"38\":\"\",\"39\":\"\",\"40\":1,\"41\":5,\"44\":\"\",\"45\":\"\",\"46\":\"Quote 20\",\"47\":\"\",\"48\":\"\",\"49\":\"Quote 20\",\"50\":\"\",\"51\":\"Quote 20\",\"52\":\"\",\"53\":\"\",\"54\":37,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":5,\"562\":\"\",\"615\":\"\",\"616\":\"\",\"617\":\"1\",\"618\":\"\",\"countryText\":\"USA\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "7.250", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "jd_organizationid": 25, "id": "1004", "jd_createddate": 1754524800, "jd_orderdate": null, "jd_duedate": 1754524800, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1754584252, "jd_updatedat": 1754584865 } ], "updated": [ { "jd_id": 1003, "jd_customerid": 176, "jd_contactid": 194, "jd_additionalcontacts": "194", "jd_templateid": 1, "jd_jobmultiquoteid": 1007, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "ON2894", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "QUOT0004", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "0.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": 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": 5, "jd_updatedby": 5, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 19, "jd_deliveryvatperc": "7.250", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"ON2894\",\"35\":\"QUOT0004\",\"36\":1,\"37\":1,\"38\":\"\",\"39\":\"\",\"40\":1,\"41\":5,\"44\":\"\",\"45\":\"\",\"46\":\"Quote 19\",\"47\":\"\",\"48\":\"\",\"49\":\"Quote 19\",\"50\":\"\",\"51\":\"Quote 19\",\"52\":\"\",\"53\":\"\",\"54\":37,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":5,\"562\":\"\",\"615\":\"\",\"616\":\"\",\"617\":\"1\",\"618\":\"\",\"countryText\":\"USA\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "7.250", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "jd_organizationid": 25, "id": "1003", "jd_createddate": 1754524800, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1754584174, "jd_updatedat": 1754584865 }, { "jd_id": 1004, "jd_customerid": 177, "jd_contactid": 195, "jd_additionalcontacts": "195", "jd_templateid": 1, "jd_jobmultiquoteid": 1008, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "ON2895", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "QUOT0005", "jd_invoiceno": "", "jd_listprice": "195.00", "jd_netprice": "195.00", "jd_vat": "14.14", "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": "209.14", "jd_grossprofit": "0.00", "jd_costprice": "75.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "209.14", "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": 5, "jd_updatedby": 5, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 20, "jd_deliveryvatperc": "7.250", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"ON2895\",\"35\":\"QUOT0005\",\"36\":1,\"37\":1,\"38\":\"\",\"39\":\"\",\"40\":1,\"41\":5,\"44\":\"\",\"45\":\"\",\"46\":\"Quote 20\",\"47\":\"\",\"48\":\"\",\"49\":\"Quote 20\",\"50\":\"\",\"51\":\"Quote 20\",\"52\":\"\",\"53\":\"\",\"54\":37,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":5,\"562\":\"\",\"615\":\"\",\"616\":\"\",\"617\":\"1\",\"618\":\"\",\"countryText\":\"USA\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "7.250", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "jd_organizationid": 25, "id": "1004", "jd_createddate": 1754524800, "jd_orderdate": null, "jd_duedate": 1754524800, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1754584252, "jd_updatedat": 1754584865 } ], "deleted": [] }, "bm_orderitem": { "created": [ { "oi_id": 1935, "oi_jobid": 1004, "oi_jobtempid": "0", "oi_jobmultiquoteid": 1008, "oi_productid": 48, "oi_recipeid": 45, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":5807,\"labelname\":\"Unit Type\",\"value\":4,\"valueid\":\"4\",\"type\":34,\"optionid\":\"4\",\"optionvalue\":[{\"optionid\":4,\"optionname\":\"Inches\",\"optioncode\":\"\",\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":4,\"forchildfieldoptionlinkid\":\"34_4\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":4513,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":4514,\"labelname\":\"Supplier\",\"value\":1,\"valueid\":\"\",\"type\":17,\"optionid\":\"1\",\"optionvalue\":[{\"id\":1,\"optionid\":1,\"optionname\":\"My Blinds Company\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":4515,\"labelname\":\"Location\",\"value\":\"Hall\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":4516,\"labelname\":\"Product Type\",\"value\":39,\"valueid\":\"513\",\"type\":13,\"optionid\":\"39\",\"optionvalue\":[{\"id\":513,\"fieldid\":4516,\"fieldoptionlinkid\":513,\"optionid\":39,\"mainsupplier\":1,\"blindtypecode\":\"\",\"optionname\":\"Group BOM\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":4517,\"labelname\":\"Mount\",\"value\":\"Inside\",\"valueid\":\"7664\",\"type\":3,\"optionid\":\"31\",\"optionvalue\":[{\"optionid\":31,\"optionname\":\"Inside\",\"description\":\"\",\"optioncode\":\"IN\",\"pricegroups\":\"Group BOM,category z\",\"unittype\":null,\"optionqty\":1,\"unitcost\":0,\"fieldoptionlinkid\":7664,\"forchildfieldoptionlinkid\":\"3_7664\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":4518,\"labelname\":\"Width\",\"value\":\"75\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"0_Inches_1_0\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":4519,\"labelname\":\"Height\",\"value\":\"72\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"0_Inches_1_0\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":4532,\"labelname\":\"Fabric\",\"value\":\"Amico\",\"valueid\":\"1237\",\"type\":5,\"optionid\":\"1237\",\"optionvalue\":[{\"optionid\":1237,\"optionname\":\"Amico\",\"optioncode\":\"AM5\",\"optionquantity\":1,\"fieldoptionlinkid\":1237,\"forchildfieldoptionlinkid\":\"5_2_1237_1\",\"optionimage\":\"\",\"subdatacount\":1,\"supplier\":\"Decora\",\"pricegroup\":\"Group BOM\",\"pricegroupid\":39}],\"fabricorcolor\":1,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":4574,\"labelname\":\"Color\",\"value\":\"Breva\",\"valueid\":\"7085\",\"type\":5,\"optionid\":\"7085\",\"optionvalue\":[{\"optionid\":7085,\"optionname\":\"Breva\",\"optioncode\":\"RP61206\",\"optionquantity\":1,\"fieldoptionlinkid\":7085,\"forchildfieldoptionlinkid\":\"5_3_7085_1\",\"minimumdiscount\":\"\",\"maximumdiscount\":\"\",\"optionimage\":\"7085_139.jpg\",\"subdatacount\":0}],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":4520,\"labelname\":\"Control Type\",\"value\":\"Motorised\",\"valueid\":\"7665\",\"type\":3,\"optionid\":\"33\",\"optionvalue\":[{\"optionid\":33,\"optionname\":\"Motorised\",\"description\":\"\",\"optioncode\":\"MBOM\",\"pricegroups\":\"Group BOM\",\"unittype\":null,\"optionqty\":\"1\",\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":7665,\"forchildfieldoptionlinkid\":\"3_7665\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":4,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":7665}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":5812,\"labelname\":\"Motor Type\",\"value\":\"Sonesse 30 Wirefree RTS\",\"valueid\":\"8118\",\"type\":3,\"optionid\":\"37\",\"optionvalue\":[{\"optionid\":37,\"optionname\":\"Sonesse 30 Wirefree RTS\",\"description\":\"\",\"optioncode\":\"S30BOM\",\"pricegroups\":\"Group BOM\",\"unittype\":\"Each\",\"optionqty\":1,\"fieldoptionlinkid\":8118,\"forchildfieldoptionlinkid\":\"3_8118\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\/storage\/attachments\/STUTTGART\/optionImages\/37_option_290.png\",\"unitcost\":330,\"reportprice\":\"660.00\",\"fieldid\":8118}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":4523,\"labelname\":\"Remote Control\",\"value\":\"Cruze 4 Channel RTS Remote\",\"valueid\":\"7686\",\"type\":3,\"optionid\":\"52\",\"optionvalue\":[{\"optionid\":52,\"optionname\":\"Cruze 4 Channel RTS Remote\",\"description\":\"\",\"optioncode\":\"CRZBOM\",\"pricegroups\":\"Group BOM\",\"unittype\":\"Each\",\"optionqty\":1,\"fieldoptionlinkid\":7686,\"forchildfieldoptionlinkid\":\"3_7686\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\/storage\/attachments\/STUTTGART\/optionImages\/52_option_290.jpg\",\"unitcost\":28,\"reportprice\":\"56.00\",\"fieldid\":7686}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":5811,\"labelname\":\"Tubes\",\"value\":\"2 inch\",\"valueid\":\"8114\",\"type\":3,\"optionid\":\"2694\",\"optionvalue\":[{\"optionid\":2694,\"optionname\":\"2 inch\",\"description\":\"\",\"optioncode\":\"2IT\",\"pricegroups\":\"Group BOM\",\"unittype\":null,\"optionqty\":\"1\",\"unitcost\":67.5,\"pricingtype\":\"\",\"fieldoptionlinkid\":8114,\"forchildfieldoptionlinkid\":\"3_8114\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"87.75\",\"fieldid\":8114}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":4528,\"labelname\":\"Accessories\",\"value\":\"Bottom Bar,Screws,Brackets,2m Ext for for Charger In,End Caps\",\"valueid\":\"7697,7699,7756,7757,7763\",\"type\":3,\"optionid\":\"499,501,2566,2567,2571\",\"optionvalue\":[{\"optionid\":499,\"optionname\":\"Bottom Bar\",\"description\":\"\",\"optioncode\":\"BBBOM\",\"pricegroups\":\"Group BOM\",\"unittype\":null,\"optionqty\":1,\"unitcost\":7.5,\"fieldoptionlinkid\":7697,\"forchildfieldoptionlinkid\":\"3_7697\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"15.00\",\"fieldid\":7697},{\"optionid\":501,\"optionname\":\"Screws\",\"description\":\"\",\"optioncode\":\"SCBOM\",\"pricegroups\":\"Group BOM\",\"unittype\":\"Each\",\"optionqty\":\"8\",\"unitcost\":0.4,\"fieldoptionlinkid\":7699,\"forchildfieldoptionlinkid\":\"3_7699\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.80\",\"fieldid\":7699},{\"optionid\":2566,\"optionname\":\"Brackets\",\"description\":\"\",\"optioncode\":\"BRBOM\",\"pricegroups\":\"Group BOM\",\"unittype\":\"Each\",\"optionqty\":1,\"unitcost\":3,\"fieldoptionlinkid\":7756,\"forchildfieldoptionlinkid\":\"3_7756\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"6.00\",\"fieldid\":7756},{\"optionid\":2567,\"optionname\":\"2m Ext for for Charger In\",\"description\":\"\",\"optioncode\":\"2MEXT\",\"pricegroups\":\"Group BOM\",\"unittype\":\"Each\",\"optionqty\":1,\"unitcost\":10,\"fieldoptionlinkid\":7757,\"forchildfieldoptionlinkid\":\"3_7757\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"10.00\",\"fieldid\":7757},{\"optionid\":2571,\"optionname\":\"End Caps\",\"description\":\"\",\"optioncode\":\"EC1\",\"pricegroups\":\"Group BOM\",\"unittype\":\"Each\",\"optionqty\":1,\"unitcost\":2,\"fieldoptionlinkid\":7763,\"forchildfieldoptionlinkid\":\"3_7763\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"4.00\",\"fieldid\":7763}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1,8,1,1,1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":4530,\"labelname\":\"Special Instruction\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]", "oi_description": "Supplier: My Blinds Company, Location: Hall, Mount: Inside, Width: 75, Height: 72, Fabric: Amico, Color: Breva, Control Type: Motorised, Motor Type: Sonesse 30 Wirefree RTS, Remote Control: Cruze 4 Channel RTS Remote", "oi_reportdescription": "##Quantity: 1##,##Supplier: My Blinds Company##,##Location: Hall##,##Mount: Inside##,##Width: 75 Inches##,##Height: 72 Inches##,##Fabric: Amico##,##Color: Breva##,##Control Type: Motorised##,##Motor Type: Sonesse 30 Wirefree RTS##,##Remote Control: Cruze 4 Channel RTS Remote##", "oi_reporttitles": "##Quantity:##Supplier:##Location:##Mount:##Width:##Height:##Fabric:##Color:##Control Type:##Motor Type:##Remote Control:", "oi_productionformulajsondata": "[]", "oi_operationstatus": null, "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "[]", "oi_pricecomesfrom_calculations": "{}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "75.000", "oi_netprice": "195.000", "oi_pricesfromoperations": null, "oi_vatprice": "14.140", "oi_vatvalue": "7.250", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "209.140", "oi_overrideprice": "0.000", "oi_overridetype": 1, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 0, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "195.000", "oi_endcustomeroverridevatprice": "14.140", "oi_endcustomeroverridegrossprice": "209.140", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[5807, 4513, 4514, 4515, 4516, 4517, 4518, 4519, 4532, 4574, 4520, 5812, 4523, 5811, 4528, 4530]", "oi_deviceplatform": 1, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "1935", "oi_productiondate": 1754584254, "oi_createdat": 1754584271, "oi_updatedat": 1754584865, "oi_createdby": 5, "oi_updatedby": null } ], "updated": [], "deleted": [] }, "bm_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_notelist": { "created": [], "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": 1007, "jmq_jobid": 1003, "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": "7.250", "jmq_cdeliveryvatperc": "7.250", "id": "1007", "jmq_duedate": null, "jmq_sceduleddate": null, "jmq_createdat": "1754584174.000000", "jmq_updatedat": null, "jmq_createdby": 5, "jmq_updatedby": null }, { "jmq_id": 1008, "jmq_jobid": 1004, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "195.00", "jmq_netprice": "195.00", "jmq_vat": "14.14", "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": "209.14", "jmq_grossprofit": "0.00", "jmq_costprice": "75.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "209.14", "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.250", "jmq_cdeliveryvatperc": "7.250", "id": "1008", "jmq_duedate": 1754524800, "jmq_sceduleddate": null, "jmq_createdat": "1754584252.000000", "jmq_updatedat": "1754584865.000000", "jmq_createdby": 5, "jmq_updatedby": 5 } ], "updated": [ { "jmq_id": 1008, "jmq_jobid": 1004, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "195.00", "jmq_netprice": "195.00", "jmq_vat": "14.14", "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": "209.14", "jmq_grossprofit": "0.00", "jmq_costprice": "75.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "209.14", "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.250", "jmq_cdeliveryvatperc": "7.250", "id": "1008", "jmq_duedate": 1754524800, "jmq_sceduleddate": null, "jmq_createdat": "1754584252.000000", "jmq_updatedat": "1754584865.000000", "jmq_createdby": 5, "jmq_updatedby": 5 } ], "deleted": [] }, "bm_jobstatus_tracks": { "created": [ { "jst_id": 1086, "jst_jobid": 1003, "jst_job_current_status": 1, "id": "1086", "jst_createdat": "1754584865.313022" }, { "jst_id": 1087, "jst_jobid": 1004, "jst_job_current_status": 1, "id": "1087", "jst_createdat": "1754584865.381796" } ], "updated": [], "deleted": [] }, "bm_customindividuallogs": { "created": [ { "cl_id": 34844, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 1003, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 1003, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 5, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"Design 2 View\",\"\":\"USA\",\"Account Type\":\"Domestic\",\"Created By\":\"Ash\",\"Last Name\":\"Quote 19\",\"Address1\":\"Quote 19\",\"Town \\\/ City\":\"Quote 19\",\"Country\":\"USA\",\"Salutation\":\"Mr.\",\"Account manager\":5,\"Additional Contacts\":\"194\",\"Job Ref No\":\"ON2894\",\"Job Status\":\"Lead\",\"Order Status\":\"Order received\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"jd_isonlineorder\":1,\"jd_organizationid\":25,\"jd_quickquote\":19,\"Delivery Vat Percentage\":\"7.250\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":1003,\"jd_customerid\":176,\"jd_contactid\":194,\"jd_additionalcontacts\":\"194\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"ON2894\\\",\\\"35\\\":\\\"QUOT0004\\\",\\\"36\\\":1,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":\\\"\\\",\\\"40\\\":1,\\\"41\\\":5,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"\\\",\\\"46\\\":\\\"Quote 19\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"Quote 19\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"Quote 19\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":37,\\\"285\\\":1,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":5,\\\"562\\\":\\\"\\\",\\\"615\\\":\\\"\\\",\\\"616\\\":\\\"\\\",\\\"617\\\":\\\"1\\\",\\\"618\\\":\\\"\\\",\\\"countryText\\\":\\\"USA\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-08-07\",\"jd_orderdate\":null,\"jd_duedate\":null,\"jd_duedatechangedmanually\":0,\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":null,\"jd_jobref\":\"ON2894\",\"jd_jobstatus\":1,\"jd_contactaddid\":0,\"jd_orderstatus\":1,\"jd_accref\":\"QUOT0004\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"0.00\",\"jd_netprice\":\"0.00\",\"jd_vat\":\"0.00\",\"jd_isvaton\":1,\"jd_deliverycost\":\"0.00\",\"jd_deliverycosttypeid\":1,\"jd_overridetypeid\":1,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":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_accountingsoftware_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":0,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":0,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":0,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":0,\"jd_organizationid\":25,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":5,\"jd_createdat\":\"2025-08-07T16:29:34.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-08-07T16:41:05.000000Z\",\"jd_deviceplatform\":0,\"jd_fromjobref\":\"\",\"jd_fromdbname\":null,\"jd_importorder\":0,\"jd_quickquote\":19,\"jd_myob_flag\":0,\"jd_myobinvoiceid\":\"\",\"jd_qboflag\":0,\"jd_qboinvoiceid\":0,\"jd_qbodisplayname\":\"\",\"jd_deliveryvatperc\":\"7.250\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"7.250\",\"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,\"jd_num_of_payments\":0}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "34844", "cl_createdat": "1754584865.000000", "cl_updatedat": null }, { "cl_id": 34845, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 1004, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 1004, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 5, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"Design 2 View\",\"\":\"USA\",\"Account Type\":\"Domestic\",\"Created By\":\"Ash\",\"Last Name\":\"Quote 20\",\"Address1\":\"Quote 20\",\"Town \\\/ City\":\"Quote 20\",\"Country\":\"USA\",\"Salutation\":\"Mr.\",\"Account manager\":5,\"Additional Contacts\":\"195\",\"Production Due Date\":\"2025-08-07\",\"Job Ref No\":\"ON2895\",\"Job Status\":\"Lead\",\"Order Status\":\"Order received\",\"Net Price\":\"195.00\",\"VAT Price\":\"14.14\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"Gross Price Amount\":\"209.14\",\"Total CostPrice\":\"75.00\",\"Amount Outstanding\":\"209.14\",\"jd_isonlineorder\":1,\"jd_organizationid\":25,\"jd_quickquote\":20,\"Delivery Vat Percentage\":\"7.250\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":1004,\"jd_customerid\":177,\"jd_contactid\":195,\"jd_additionalcontacts\":\"195\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"ON2895\\\",\\\"35\\\":\\\"QUOT0005\\\",\\\"36\\\":1,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":\\\"\\\",\\\"40\\\":1,\\\"41\\\":5,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"\\\",\\\"46\\\":\\\"Quote 20\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"Quote 20\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"Quote 20\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":37,\\\"285\\\":1,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":5,\\\"562\\\":\\\"\\\",\\\"615\\\":\\\"\\\",\\\"616\\\":\\\"\\\",\\\"617\\\":\\\"1\\\",\\\"618\\\":\\\"\\\",\\\"countryText\\\":\\\"USA\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-08-07\",\"jd_orderdate\":null,\"jd_duedate\":\"2025-08-07\",\"jd_duedatechangedmanually\":0,\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":null,\"jd_jobref\":\"ON2895\",\"jd_jobstatus\":1,\"jd_contactaddid\":0,\"jd_orderstatus\":1,\"jd_accref\":\"QUOT0005\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"195.00\",\"jd_netprice\":\"195.00\",\"jd_vat\":\"14.14\",\"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\":\"209.14\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"75.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"209.14\",\"jd_totpaid\":\"0.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":null,\"jd_deliverycostid\":0,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_accountingsoftware_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":0,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":0,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":0,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":0,\"jd_organizationid\":25,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":5,\"jd_createdat\":\"2025-08-07T16:30:52.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-08-07T16:41:05.000000Z\",\"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.250\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"7.250\",\"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,\"jd_num_of_payments\":0}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "34845", "cl_createdat": "1754584865.000000", "cl_updatedat": null }, { "cl_id": 34846, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in ON2894", "cl_event": "created", "cl_subjectid": 1007, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 1003, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 5, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":1007,\"jmq_jobid\":1003,\"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\":\"7.250\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":1007,\"jmq_jobid\":1003,\"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\":\"7.250\",\"jmq_cdeliveryvatperc\":\"7.250\",\"jmq_createdby\":5,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-08-07T16:29:34.000000Z\",\"jmq_updatedat\":null,\"jmq_grossprofit_percentage\":\"0.00\",\"jmq_ready\":0}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "34846", "cl_createdat": "1754584865.000000", "cl_updatedat": null }, { "cl_id": 34847, "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": 1003, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 1003, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 5, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":1007}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":1007},\"old\":{\"jd_jobmultiquoteid\":null}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "34847", "cl_createdat": "1754584865.000000", "cl_updatedat": null }, { "cl_id": 34848, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in ON2895", "cl_event": "created", "cl_subjectid": 1008, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 1004, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 5, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":1008,\"jmq_jobid\":1004,\"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\":\"195.00\",\"Net Price\":\"195.00\",\"VAT Price\":\"14.14\",\"VAT\":1,\"jmq_deliverycost\":\"0.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"209.14\",\"Gross Profit\":\"0.00\",\"Total CostPrice\":\"75.00\",\"Amount Outstanding\":\"209.14\",\"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.250\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":1008,\"jmq_jobid\":1004,\"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\":\"195.00\",\"jmq_netprice\":\"195.00\",\"jmq_vat\":\"14.14\",\"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\":\"209.14\",\"jmq_grossprofit\":\"0.00\",\"jmq_costprice\":\"75.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"209.14\",\"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.250\",\"jmq_cdeliveryvatperc\":\"7.250\",\"jmq_createdby\":5,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-08-07T16:30:52.000000Z\",\"jmq_updatedat\":null,\"jmq_grossprofit_percentage\":\"0.00\",\"jmq_ready\":0}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "34848", "cl_createdat": "1754584865.000000", "cl_updatedat": null }, { "cl_id": 34849, "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": 1004, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 1004, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 5, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":1008}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":1008},\"old\":{\"jd_jobmultiquoteid\":null}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "34849", "cl_createdat": "1754584865.000000", "cl_updatedat": null }, { "cl_id": 34850, "cl_logname": "default", "cl_type": null, "cl_modulename": "Line Item", "cl_message": "Q1 - new item has been created in Line Item for the product of Roller Shade", "cl_event": "created", "cl_subjectid": 1935, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 1004, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 5, "cl_changedfrom": "null", "cl_changedto": "{\"Supplier\":\" My Blinds Company\",\" Location\":\" Hall\",\" Mount\":\" Inside\",\" Width\":\" 75\",\" Height\":\" 72\",\" Fabric\":\" Amico\",\" Color\":\" Breva\",\" Control Type\":\" Motorised\",\" Motor Type\":\" Sonesse 30 Wirefree RTS\",\" Remote Control\":\" Cruze 4 Channel RTS Remote\"}", "cl_customproperties": "{\"attributes\":{\"oi_id\":1935,\"oi_jobid\":1004,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":1008,\"oi_credit_id\":0,\"oi_productid\":48,\"oi_recipeid\":45,\"oi_ruleid\":0,\"oi_qty\":1,\"oi_seq\":1,\"oi_customseq\":1,\"oi_productcustomseq\":1,\"oi_jsondata\":\"[{\\\"id\\\":5807,\\\"labelname\\\":\\\"Unit Type\\\",\\\"value\\\":4,\\\"valueid\\\":\\\"4\\\",\\\"type\\\":34,\\\"optionid\\\":\\\"4\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":4,\\\"optionname\\\":\\\"Inches\\\",\\\"optioncode\\\":\\\"\\\",\\\"optionquantity\\\":1,\\\"unittype\\\":0,\\\"unitcost\\\":0,\\\"pricingtype\\\":0,\\\"fieldoptionlinkid\\\":4,\\\"forchildfieldoptionlinkid\\\":\\\"34_4\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":4513,\\\"labelname\\\":\\\"Quantity\\\",\\\"value\\\":1,\\\"valueid\\\":\\\"\\\",\\\"type\\\":14,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":4514,\\\"labelname\\\":\\\"Supplier\\\",\\\"value\\\":1,\\\"valueid\\\":\\\"\\\",\\\"type\\\":17,\\\"optionid\\\":\\\"1\\\",\\\"optionvalue\\\":[{\\\"id\\\":1,\\\"optionid\\\":1,\\\"optionname\\\":\\\"My Blinds Company\\\",\\\"deleted\\\":0,\\\"optionquantity\\\":1}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":4515,\\\"labelname\\\":\\\"Location\\\",\\\"value\\\":\\\"Hall\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":4516,\\\"labelname\\\":\\\"Product Type\\\",\\\"value\\\":39,\\\"valueid\\\":\\\"513\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"39\\\",\\\"optionvalue\\\":[{\\\"id\\\":513,\\\"fieldid\\\":4516,\\\"fieldoptionlinkid\\\":513,\\\"optionid\\\":39,\\\"mainsupplier\\\":1,\\\"blindtypecode\\\":\\\"\\\",\\\"optionname\\\":\\\"Group BOM\\\",\\\"optionquantity\\\":1,\\\"subcount\\\":0,\\\"status\\\":0,\\\"subdatacount\\\":0}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":4517,\\\"labelname\\\":\\\"Mount\\\",\\\"value\\\":\\\"Inside\\\",\\\"valueid\\\":\\\"7664\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"31\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":31,\\\"optionname\\\":\\\"Inside\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"IN\\\",\\\"pricegroups\\\":\\\"Group BOM,category z\\\",\\\"unittype\\\":null,\\\"optionqty\\\":1,\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":7664,\\\"forchildfieldoptionlinkid\\\":\\\"3_7664\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":4518,\\\"labelname\\\":\\\"Width\\\",\\\"value\\\":\\\"75\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":11,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"0_Inches_1_0\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":4519,\\\"labelname\\\":\\\"Height\\\",\\\"value\\\":\\\"72\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":12,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"0_Inches_1_0\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":4532,\\\"labelname\\\":\\\"Fabric\\\",\\\"value\\\":\\\"Amico\\\",\\\"valueid\\\":\\\"1237\\\",\\\"type\\\":5,\\\"optionid\\\":\\\"1237\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":1237,\\\"optionname\\\":\\\"Amico\\\",\\\"optioncode\\\":\\\"AM5\\\",\\\"optionquantity\\\":1,\\\"fieldoptionlinkid\\\":1237,\\\"forchildfieldoptionlinkid\\\":\\\"5_2_1237_1\\\",\\\"optionimage\\\":\\\"\\\",\\\"subdatacount\\\":1,\\\"supplier\\\":\\\"Decora\\\",\\\"pricegroup\\\":\\\"Group BOM\\\",\\\"pricegroupid\\\":39}],\\\"fabricorcolor\\\":1,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":4574,\\\"labelname\\\":\\\"Color\\\",\\\"value\\\":\\\"Breva\\\",\\\"valueid\\\":\\\"7085\\\",\\\"type\\\":5,\\\"optionid\\\":\\\"7085\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":7085,\\\"optionname\\\":\\\"Breva\\\",\\\"optioncode\\\":\\\"RP61206\\\",\\\"optionquantity\\\":1,\\\"fieldoptionlinkid\\\":7085,\\\"forchildfieldoptionlinkid\\\":\\\"5_3_7085_1\\\",\\\"minimumdiscount\\\":\\\"\\\",\\\"maximumdiscount\\\":\\\"\\\",\\\"optionimage\\\":\\\"7085_139.jpg\\\",\\\"subdatacount\\\":0}],\\\"fabricorcolor\\\":2,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":4520,\\\"labelname\\\":\\\"Control Type\\\",\\\"value\\\":\\\"Motorised\\\",\\\"valueid\\\":\\\"7665\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"33\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":33,\\\"optionname\\\":\\\"Motorised\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"MBOM\\\",\\\"pricegroups\\\":\\\"Group BOM\\\",\\\"unittype\\\":null,\\\"optionqty\\\":\\\"1\\\",\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":7665,\\\"forchildfieldoptionlinkid\\\":\\\"3_7665\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":4,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"0.00\\\",\\\"fieldid\\\":7665}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":5812,\\\"labelname\\\":\\\"Motor Type\\\",\\\"value\\\":\\\"Sonesse 30 Wirefree RTS\\\",\\\"valueid\\\":\\\"8118\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"37\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":37,\\\"optionname\\\":\\\"Sonesse 30 Wirefree RTS\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"S30BOM\\\",\\\"pricegroups\\\":\\\"Group BOM\\\",\\\"unittype\\\":\\\"Each\\\",\\\"optionqty\\\":1,\\\"fieldoptionlinkid\\\":8118,\\\"forchildfieldoptionlinkid\\\":\\\"3_8118\\\",\\\"hasstock\\\":1,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\/storage\\\/attachments\\\/STUTTGART\\\/optionImages\\\/37_option_290.png\\\",\\\"unitcost\\\":330,\\\"reportprice\\\":\\\"660.00\\\",\\\"fieldid\\\":8118}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":4523,\\\"labelname\\\":\\\"Remote Control\\\",\\\"value\\\":\\\"Cruze 4 Channel RTS Remote\\\",\\\"valueid\\\":\\\"7686\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"52\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":52,\\\"optionname\\\":\\\"Cruze 4 Channel RTS Remote\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"CRZBOM\\\",\\\"pricegroups\\\":\\\"Group BOM\\\",\\\"unittype\\\":\\\"Each\\\",\\\"optionqty\\\":1,\\\"fieldoptionlinkid\\\":7686,\\\"forchildfieldoptionlinkid\\\":\\\"3_7686\\\",\\\"hasstock\\\":1,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\/storage\\\/attachments\\\/STUTTGART\\\/optionImages\\\/52_option_290.jpg\\\",\\\"unitcost\\\":28,\\\"reportprice\\\":\\\"56.00\\\",\\\"fieldid\\\":7686}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":5811,\\\"labelname\\\":\\\"Tubes\\\",\\\"value\\\":\\\"2 inch\\\",\\\"valueid\\\":\\\"8114\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"2694\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":2694,\\\"optionname\\\":\\\"2 inch\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"2IT\\\",\\\"pricegroups\\\":\\\"Group BOM\\\",\\\"unittype\\\":null,\\\"optionqty\\\":\\\"1\\\",\\\"unitcost\\\":67.5,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":8114,\\\"forchildfieldoptionlinkid\\\":\\\"3_8114\\\",\\\"hasstock\\\":1,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"87.75\\\",\\\"fieldid\\\":8114}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":4528,\\\"labelname\\\":\\\"Accessories\\\",\\\"value\\\":\\\"Bottom Bar,Screws,Brackets,2m Ext for for Charger In,End Caps\\\",\\\"valueid\\\":\\\"7697,7699,7756,7757,7763\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"499,501,2566,2567,2571\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":499,\\\"optionname\\\":\\\"Bottom Bar\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"BBBOM\\\",\\\"pricegroups\\\":\\\"Group BOM\\\",\\\"unittype\\\":null,\\\"optionqty\\\":1,\\\"unitcost\\\":7.5,\\\"fieldoptionlinkid\\\":7697,\\\"forchildfieldoptionlinkid\\\":\\\"3_7697\\\",\\\"hasstock\\\":1,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"15.00\\\",\\\"fieldid\\\":7697},{\\\"optionid\\\":501,\\\"optionname\\\":\\\"Screws\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"SCBOM\\\",\\\"pricegroups\\\":\\\"Group BOM\\\",\\\"unittype\\\":\\\"Each\\\",\\\"optionqty\\\":\\\"8\\\",\\\"unitcost\\\":0.4,\\\"fieldoptionlinkid\\\":7699,\\\"forchildfieldoptionlinkid\\\":\\\"3_7699\\\",\\\"hasstock\\\":1,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"0.80\\\",\\\"fieldid\\\":7699},{\\\"optionid\\\":2566,\\\"optionname\\\":\\\"Brackets\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"BRBOM\\\",\\\"pricegroups\\\":\\\"Group BOM\\\",\\\"unittype\\\":\\\"Each\\\",\\\"optionqty\\\":1,\\\"unitcost\\\":3,\\\"fieldoptionlinkid\\\":7756,\\\"forchildfieldoptionlinkid\\\":\\\"3_7756\\\",\\\"hasstock\\\":1,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"6.00\\\",\\\"fieldid\\\":7756},{\\\"optionid\\\":2567,\\\"optionname\\\":\\\"2m Ext for for Charger In\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"2MEXT\\\",\\\"pricegroups\\\":\\\"Group BOM\\\",\\\"unittype\\\":\\\"Each\\\",\\\"optionqty\\\":1,\\\"unitcost\\\":10,\\\"fieldoptionlinkid\\\":7757,\\\"forchildfieldoptionlinkid\\\":\\\"3_7757\\\",\\\"hasstock\\\":1,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"10.00\\\",\\\"fieldid\\\":7757},{\\\"optionid\\\":2571,\\\"optionname\\\":\\\"End Caps\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"EC1\\\",\\\"pricegroups\\\":\\\"Group BOM\\\",\\\"unittype\\\":\\\"Each\\\",\\\"optionqty\\\":1,\\\"unitcost\\\":2,\\\"fieldoptionlinkid\\\":7763,\\\"forchildfieldoptionlinkid\\\":\\\"3_7763\\\",\\\"hasstock\\\":1,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"4.00\\\",\\\"fieldid\\\":7763}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1,8,1,1,1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":4530,\\\"labelname\\\":\\\"Special Instruction\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0}]\",\"oi_description\":\"Supplier: My Blinds Company, Location: Hall, Mount: Inside, Width: 75, Height: 72, Fabric: Amico, Color: Breva, Control Type: Motorised, Motor Type: Sonesse 30 Wirefree RTS, Remote Control: Cruze 4 Channel RTS Remote\",\"oi_onlinedescription\":null,\"oi_imagepath\":null,\"oi_reportdescription\":\"##Quantity: 1##,##Supplier: My Blinds Company##,##Location: Hall##,##Mount: Inside##,##Width: 75 Inches##,##Height: 72 Inches##,##Fabric: Amico##,##Color: Breva##,##Control Type: Motorised##,##Motor Type: Sonesse 30 Wirefree RTS##,##Remote Control: Cruze 4 Channel RTS Remote##\",\"oi_onlinereportdescription\":null,\"oi_reporttitles\":\"##Quantity:##Supplier:##Location:##Mount:##Width:##Height:##Fabric:##Color:##Control Type:##Motor Type:##Remote Control:\",\"oi_onlinereporttitles\":null,\"oi_productionformulajsondata\":\"[]\",\"oi_productiondate\":\"2025-08-07 16:30:54\",\"oi_manualduedate\":0,\"oi_operationstatus\":null,\"oi_scanstatus\":\"\",\"oi_operationworkroom_data\":\"[]\",\"oi_operationcalender_data\":\"[]\",\"oi_operation_calculations\":\"[]\",\"oi_pricecomesfrom_calculations\":\"{}\",\"oi_pricetablepriceevenbom\":\"{}\",\"oi_productionstatus\":null,\"oi_costoverride\":0,\"oi_costprice\":\"75.000\",\"oi_netprice\":\"195.000\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"14.140\",\"oi_vatvalue\":\"7.250\",\"oi_vatselected\":1,\"oi_vattype\":1,\"oi_vatonoff\":1,\"oi_grossprice\":\"209.140\",\"oi_overrideprice\":\"0.000\",\"oi_overridetype\":1,\"oi_overridevalue\":null,\"oi_overridenetprice\":\"0.000\",\"oi_overridevatprice\":\"0.000\",\"oi_overridegrossprice\":\"0.000\",\"oi_ready\":0,\"oi_onhold\":0,\"oi_platformcreatedfrom\":\"web\",\"oi_platformlastupdatedfrom\":\"web\",\"oi_copiedfrom\":0,\"oi_isonlineorder\":0,\"oi_endcustomervatprice\":null,\"oi_endcustomeroverridetype\":1,\"oi_endcustomeroverridevalue\":null,\"oi_endcustomeroverridenetprice\":\"195.000\",\"oi_endcustomeroverridevatprice\":\"14.140\",\"oi_endcustomeroverridegrossprice\":\"209.140\",\"oi_sage_flag\":0,\"oi_supid\":null,\"oi_status\":0,\"oi_createdby\":5,\"oi_createdat\":\"2025-08-07T16:31:11.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":null,\"oi_jsondataid\":\"[5807, 4513, 4514, 4515, 4516, 4517, 4518, 4519, 4532, 4574, 4520, 5812, 4523, 5811, 4528, 4530]\",\"oi_deviceplatform\":1,\"oi_custompricefields\":\"\",\"oi_editransfer\":0,\"oi_apisup_orderid\":0,\"oi_commissionprice\":\"0.000\",\"oi_commissionvatprice\":\"0.000\",\"oi_jsondatabackup\":\"\",\"oi_stockdeduct\":0,\"oi_deductedstockdetails\":null}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "34850", "cl_createdat": "1754584865.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": [ { "organization_id": 25, "organizationname": "Design 2 View", "address": "7531 Coldwater Canyon Avenue", "address2": "North Hollywood", "addres3": "California", "city": "Palo Alto", "state": "CA", "country": null, "code": "91605", "phone": "818 503 8300", "mobile1": null, "mobile2": null, "fax": null, "email3": null, "email1": "corwin.castellaw@fabritecdesigns.com", "email2": null, "website": "https:\/\/fabritecdesigns.com", "logoname": "Screenshot_2.png", "logo": "124727-Screenshot_2.png", "vatnumber": "58745874", "vatrate": null, "settlementdiscount": null, "reportemailbody": null, "domesticpaymentterms": null, "contractpaymentterms": null, "tradepaymentterms": null, "companyterms": "Terms", "countryid": 119, "bankname": "HSBC", "comregistrationno": "BM0012345", "defaultsalestax": 1, "defaultsalestaxlabel": "Sales Tax", "accountnumber": "59832614957", "currencyid": 119, "sortcode": "33153", "status": 0, "isdefault": 1, "id": "25", "created_at": 1754584865, "updated_at": 1754584865, "created_by": 1, "updated_by": 5 } ], "updated": [ { "organization_id": 25, "organizationname": "Design 2 View", "address": "7531 Coldwater Canyon Avenue", "address2": "North Hollywood", "addres3": "California", "city": "Palo Alto", "state": "CA", "country": null, "code": "91605", "phone": "818 503 8300", "mobile1": null, "mobile2": null, "fax": null, "email3": null, "email1": "corwin.castellaw@fabritecdesigns.com", "email2": null, "website": "https:\/\/fabritecdesigns.com", "logoname": "Screenshot_2.png", "logo": "124727-Screenshot_2.png", "vatnumber": "58745874", "vatrate": null, "settlementdiscount": null, "reportemailbody": null, "domesticpaymentterms": null, "contractpaymentterms": null, "tradepaymentterms": null, "companyterms": "Terms", "countryid": 119, "bankname": "HSBC", "comregistrationno": "BM0012345", "defaultsalestax": 1, "defaultsalestaxlabel": "Sales Tax", "accountnumber": "59832614957", "currencyid": 119, "sortcode": "33153", "status": 0, "isdefault": 1, "id": "25", "created_at": 1754584865, "updated_at": 1754584865, "created_by": 1, "updated_by": 5 } ], "deleted": [] }, "bm_applicationSetup": { "created": [], "updated": [], "deleted": [] }, "bm_price_setup": { "created": [], "updated": [], "deleted": [] }, "bm_calendarsetup": { "created": [], "updated": [], "deleted": [] }, "bm_appointmenttype": { "created": [], "updated": [], "deleted": [] }, "bm_userWorkDay": { "created": [], "updated": [], "deleted": [] }, "bm_users": { "created": [], "updated": [], "deleted": [] }, "custom_fields": { "created": [], "updated": [], "deleted": [] }, "customfieldvalues": { "created": [], "updated": [], "deleted": [] } }, "synctodelete": { "bm_customercontactinfo": { "51754584174": 194, "51754584252": 195 }, "bm_customertemplatedata": { "31754584174": 176, "31754584252": 177 }, "bm_jobdetails": { "41754584174": 1003, "41754584252": 1004 }, "bm_jobmultiquote": { "141754584174": 1007, "141754584252": 1008 }, "bm_orderitem": { "71754584271": 1935 } }, "timestamp": 1754584865 }