{ "status": "success", "upcomingorder_list": { "bm_customertemplatedata": { "created": [], "updated": [ { "ctd_id": 4038, "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\": \"KKAV0003\"}", "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": "4038", "ctd_createdat": 1749045735, "ctd_updatedat": 1749046242, "ctd_createdby": 0, "ctd_updatedby": null }, { "ctd_id": 4039, "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\": \"GGEO0001\"}", "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": "4039", "ctd_createdat": 1749045880, "ctd_updatedat": 1749046242, "ctd_createdby": 0, "ctd_updatedby": null } ], "deleted": [] }, "bm_customercontactinfo": { "created": [], "updated": [ { "cci_id": 4219, "cci_customerid": 4038, "cci_templateid": 3, "roleid": 0, "cci_customizedarray": "{\"75\":12,\"77\":\"Kavin K \",\"78\":\"76456888\",\"79\":\"K \",\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"90\":36}", "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": 31749045735, "id": "4219", "cci_createdat": 1749045735, "cci_updatedat": 1749046242, "cci_createdby": 0, "cci_updatedby": null }, { "cci_id": 4220, "cci_customerid": 4039, "cci_templateid": 3, "roleid": 0, "cci_customizedarray": "{\"75\":12,\"77\":\"George \",\"79\":\"G \",\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"90\":36}", "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": 31749045880, "id": "4220", "cci_createdat": 1749045880, "cci_updatedat": 1749046242, "cci_createdby": 0, "cci_updatedby": null } ], "deleted": [] }, "bm_appointment": { "created": [], "updated": [], "deleted": [] }, "bm_tasklist": { "created": [], "updated": [], "deleted": [] }, "bm_jobdetails": { "created": [ { "jd_id": 5729, "jd_customerid": 4038, "jd_contactid": 4219, "jd_additionalcontacts": "4219", "jd_templateid": 1, "jd_jobmultiquoteid": 5758, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5726", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "KKAV0003", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "70.00", "jd_vat": "7.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": "77.00", "jd_grossprofit": "70.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "-23.00", "jd_totpaid": "100.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": null, "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 1, "jd_updatedby": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "10.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5726\",\"35\":\"KKAV0003\",\"36\":1,\"37\":1,\"38\":\"\",\"39\":\"\",\"40\":13,\"41\":1,\"44\":\"\",\"45\":\"Kavin K \",\"46\":\"K \",\"47\":\"76456888\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":12,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "10.000", "jd_commission": null, "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5729", "jd_createddate": 1748995200, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": 0, "jd_sageexportdate": null, "jd_createdat": 1749045735, "jd_updatedat": 1749046242 }, { "jd_id": 5730, "jd_customerid": 4039, "jd_contactid": 4220, "jd_additionalcontacts": "4220", "jd_templateid": 1, "jd_jobmultiquoteid": 5759, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5727", "jd_jobstatus": 6, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "GGEO0001", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "70.00", "jd_vat": "7.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": "77.00", "jd_grossprofit": "70.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "-923.00", "jd_totpaid": "1000.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": null, "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 1, "jd_updatedby": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "10.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5727\",\"35\":\"GGEO0001\",\"36\":6,\"37\":1,\"38\":\"\",\"39\":\"\",\"40\":13,\"41\":1,\"44\":\"\",\"45\":\"George \",\"46\":\"G \",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":12,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "10.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5730", "jd_createddate": 1748995200, "jd_orderdate": 1748995200, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": 0, "jd_sageexportdate": null, "jd_createdat": 1749045880, "jd_updatedat": 1749046242 } ], "updated": [ { "jd_id": 5728, "jd_customerid": 4011, "jd_contactid": 4187, "jd_additionalcontacts": "4187", "jd_templateid": 1, "jd_jobmultiquoteid": 5757, "jd_deletedcustokeyvalue": "{\"32\":\"\",\"34\":\"AQ5725\",\"35\":\"JOHN0007\",\"36\":6,\"38\":\"201749045126\",\"40\":13}", "jd_jobref": "AQ5725", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "JOHN0007", "jd_invoiceno": "Invoice9662", "jd_listprice": "92.45", "jd_netprice": "92.45", "jd_vat": "9.25", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "101.70", "jd_grossprofit": "43.00", "jd_costprice": "49.45", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "46.70", "jd_totpaid": "55.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": "", "jd_endcustomeroverridenetprice": "92.45", "jd_endcustomeroverridevatprice": "9.25", "jd_endcustomeroverridegrossprice": "101.70", "jd_endcustomerdeliverycost": "", "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": "", "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 1, "jd_updatedby": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "0.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":22,\"41\":1,\"44\":\"John Smith Pvt Ltd\",\"45\":\"Johny\",\"46\":\"Leo\",\"47\":\"595955848\",\"48\":\"\",\"49\":\"Cit Nagar\",\"50\":\"Nandanam\",\"51\":\"ChennaiChenain\",\"52\":\"India\",\"53\":\"635301\",\"54\":36,\"285\":12,\"286\":\"264945946\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":1,\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "0.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5728", "jd_createddate": 1748995200, "jd_orderdate": null, "jd_duedate": 1748995200, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1749044646, "jd_updatedat": 1749045675 }, { "jd_id": 5729, "jd_customerid": 4038, "jd_contactid": 4219, "jd_additionalcontacts": "4219", "jd_templateid": 1, "jd_jobmultiquoteid": 5758, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5726", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "KKAV0003", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "70.00", "jd_vat": "7.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": "77.00", "jd_grossprofit": "70.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "-23.00", "jd_totpaid": "100.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": null, "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 1, "jd_updatedby": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "10.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5726\",\"35\":\"KKAV0003\",\"36\":1,\"37\":1,\"38\":\"\",\"39\":\"\",\"40\":13,\"41\":1,\"44\":\"\",\"45\":\"Kavin K \",\"46\":\"K \",\"47\":\"76456888\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":12,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "10.000", "jd_commission": null, "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5729", "jd_createddate": 1748995200, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": 0, "jd_sageexportdate": null, "jd_createdat": 1749045735, "jd_updatedat": 1749046242 }, { "jd_id": 5730, "jd_customerid": 4039, "jd_contactid": 4220, "jd_additionalcontacts": "4220", "jd_templateid": 1, "jd_jobmultiquoteid": 5759, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5727", "jd_jobstatus": 6, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "GGEO0001", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "70.00", "jd_vat": "7.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": "77.00", "jd_grossprofit": "70.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "-923.00", "jd_totpaid": "1000.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": null, "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 1, "jd_updatedby": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "10.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5727\",\"35\":\"GGEO0001\",\"36\":6,\"37\":1,\"38\":\"\",\"39\":\"\",\"40\":13,\"41\":1,\"44\":\"\",\"45\":\"George \",\"46\":\"G \",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":12,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "10.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5730", "jd_createddate": 1748995200, "jd_orderdate": 1748995200, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": 0, "jd_sageexportdate": null, "jd_createdat": 1749045880, "jd_updatedat": 1749046242 } ], "deleted": [] }, "bm_orderitem": { "created": [ { "oi_id": 31347, "oi_jobid": 5729, "oi_jobtempid": "0", "oi_jobmultiquoteid": null, "oi_productid": 12, "oi_recipeid": 12, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 0, "oi_customseq": 0, "oi_productcustomseq": 0, "oi_jsondata": "[{\"id\":6890,\"labelname\":\"Unit Type\",\"value\":2,\"valueid\":\"2\",\"type\":34,\"optionid\":\"2\",\"optionvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":\"\",\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":4407,\"labelname\":\"Location\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":469,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":470,\"labelname\":\"Supplier\",\"value\":4,\"valueid\":\"\",\"type\":17,\"optionid\":\"4\",\"optionvalue\":[{\"id\":4,\"optionid\":4,\"optionname\":\"Master Blinds\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":662,\"labelname\":\"Width\",\"value\":\"566\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":663,\"labelname\":\"Drop\",\"value\":\"899\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":4386,\"labelname\":\"Blind Model\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":661,\"labelname\":\"Price Chart\",\"value\":94,\"valueid\":\"187,290\",\"type\":13,\"optionid\":\"94\",\"optionvalue\":[{\"id\":187,\"fieldid\":661,\"fieldoptionlinkid\":187,\"optionid\":94,\"mainsupplier\":4,\"blindtypecode\":\"\",\"optionname\":\"Window Group 2 Band C\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0},{\"id\":290,\"fieldid\":661,\"fieldoptionlinkid\":290,\"optionid\":94,\"mainsupplier\":4,\"blindtypecode\":\"\",\"optionname\":\"Window Group 2 Band C\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\",\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":665,\"labelname\":\"Fabric\",\"value\":\"25mm Elan DuoTone RD\",\"valueid\":\"4088\",\"type\":5,\"optionid\":\"4088\",\"optionvalue\":[{\"optionid\":4088,\"optionname\":\"25mm Elan DuoTone RD\",\"optioncode\":\"HDF49\",\"optionquantity\":1,\"fieldoptionlinkid\":4088,\"forchildfieldoptionlinkid\":\"5_2_4088_1\",\"optionimage\":\"\",\"subdatacount\":1,\"pricegroup\":\"Window Group 2 Band C\",\"pricegroupid\":94}],\"fabricorcolor\":1,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":4346,\"labelname\":\"Color\",\"value\":\"AgateGrey 0987\",\"valueid\":\"8673\",\"type\":5,\"optionid\":\"8673\",\"optionvalue\":[{\"optionid\":8673,\"optionname\":\"AgateGrey 0987\",\"optioncode\":\"HDC019\",\"optionquantity\":1,\"fieldoptionlinkid\":8673,\"forchildfieldoptionlinkid\":\"5_3_8673_1\",\"minimumdiscount\":\"\",\"maximumdiscount\":\"\",\"optionimage\":\"\",\"subdatacount\":0}],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":664,\"labelname\":\"Blind or Recess\",\"value\":\"Recess size\",\"valueid\":\"5443\",\"type\":3,\"optionid\":\"475\",\"optionvalue\":[{\"optionid\":475,\"optionname\":\"Recess size\",\"optioncode\":\"jcld\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":5443,\"forchildfieldoptionlinkid\":\"3_5443\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":4387,\"labelname\":\"Brackets\",\"value\":\"Extension L Bracket 20_40 10mm Clearance\",\"valueid\":\"5300\",\"type\":3,\"optionid\":\"922\",\"optionvalue\":[{\"optionid\":922,\"optionname\":\"Extension L Bracket 20_40 10mm Clearance\",\"optioncode\":\"CBC002\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":1.03,\"pricingtype\":\"\",\"fieldoptionlinkid\":5300,\"forchildfieldoptionlinkid\":\"3_5300\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":1,\"optionimage\":\"\",\"reportprice\":\"1.03\",\"fieldid\":5300}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":4398,\"labelname\":\"Bracket 10mm Clearance Color Options\",\"value\":\"Brown\",\"valueid\":\"5366\",\"type\":3,\"optionid\":\"616\",\"optionvalue\":[{\"optionid\":616,\"optionname\":\"Brown\",\"optioncode\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":5366,\"forchildfieldoptionlinkid\":\"3_5366\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":4388,\"labelname\":\"Installation Height mm\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":4389,\"labelname\":\"Hardware Colours\",\"value\":\"Anthracite Grey\",\"valueid\":\"5440\",\"type\":3,\"optionid\":\"981\",\"optionvalue\":[{\"optionid\":981,\"optionname\":\"Anthracite Grey\",\"optioncode\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":5440,\"forchildfieldoptionlinkid\":\"3_5440\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":4461,\"labelname\":\"Motorization\",\"value\":\"240V Sonesse 40 RTS Motor,Somfy 12v Tilt and Lift RTS Motor\",\"valueid\":\"5580,5581\",\"type\":3,\"optionid\":\"1018,1019\",\"optionvalue\":[{\"optionid\":1018,\"optionname\":\"240V Sonesse 40 RTS Motor\",\"optioncode\":\"CBC019\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":5580,\"forchildfieldoptionlinkid\":\"3_5580\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":1,\"optionimage\":\"\"},{\"optionid\":1019,\"optionname\":\"Somfy 12v Tilt and Lift RTS Motor\",\"optioncode\":\"CBC020\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":5581,\"forchildfieldoptionlinkid\":\"3_5581\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":1,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1,1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":4463,\"labelname\":\"Main Motor Accessories\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":4464,\"labelname\":\"Motor Options 12v\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":4390,\"labelname\":\"Extras\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":4391,\"labelname\":\"Special Instructions\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]", "oi_description": "Supplier: Master Blinds, Width: 566, Drop: 899, Price Chart: Window Group 2 Band C, Fabric: 25mm Elan DuoTone RD, Color: AgateGrey 0987, Blind or Recess: Recess size, Brackets: Extension L Bracket 20_40 10mm Clearance, Bracket 10mm Clearance Color Options: Brown, Hardware Colours: Anthracite Grey, Motorization: 240V Sonesse 40 RTS Motor,Somfy 12v Tilt and Lift RTS Motor", "oi_reportdescription": "##Quantity: 1##,##Supplier: Master Blinds##,##Width: 566 mm##,##Drop: 899 mm##,##Price Chart: Window Group 2 Band C##,##Fabric: 25mm Elan DuoTone RD##,##Color: AgateGrey 0987##,##Blind or Recess: Recess size##,##Brackets: Extension L Bracket 20_40 10mm Clearance##,##Bracket 10mm Clearance Color Options: Brown##,##Hardware Colours: Anthracite Grey##,##Motorization: 240V Sonesse 40 RTS Motor,Somfy 12v Tilt and Lift RTS Motor##", "oi_reporttitles": "##Quantity:##Supplier:##Width:##Drop:##Price Chart:##Fabric:##Color:##Blind or Recess:##Brackets:##Bracket 10mm Clearance Color Options:##Hardware Colours:##Motorization:", "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": "97.030", "oi_netprice": "97.030", "oi_pricesfromoperations": null, "oi_vatprice": "9.700", "oi_vatvalue": "10.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "106.730", "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": 1, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 0, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "0.000", "oi_endcustomeroverridevatprice": "0.000", "oi_endcustomeroverridegrossprice": "0.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[6890, 4407, 469, 470, 662, 663, 4386, 661, 665, 4346, 664, 4387, 4398, 4388, 4389, 4461, 4463, 4464, 4390, 4391]", "oi_deviceplatform": 2, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "31347", "oi_productiondate": 1749045777, "oi_createdat": 1749045827, "oi_updatedat": 1749046242, "oi_createdby": 1, "oi_updatedby": null }, { "oi_id": 31348, "oi_jobid": 5730, "oi_jobtempid": "0", "oi_jobmultiquoteid": 5759, "oi_productid": 23, "oi_recipeid": 24, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 0, "oi_customseq": 0, "oi_productcustomseq": 0, "oi_jsondata": "[{\"id\":6897,\"labelname\":\"Unit Type\",\"value\":2,\"valueid\":\"2\",\"type\":34,\"optionid\":\"2\",\"optionvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":\"\",\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":5163,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":5164,\"labelname\":\"Supplier\",\"value\":1,\"valueid\":\"\",\"type\":17,\"optionid\":\"1\",\"optionvalue\":[{\"id\":1,\"optionid\":1,\"optionname\":\"Markilux\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":5585,\"labelname\":\"Location\",\"value\":\"\",\"valueid\":\"\",\"type\":29,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":5235,\"labelname\":\"System\",\"value\":1,\"valueid\":\"500\",\"type\":13,\"optionid\":\"1\",\"optionvalue\":[{\"id\":500,\"fieldid\":5235,\"fieldoptionlinkid\":500,\"optionid\":1,\"mainsupplier\":1,\"blindtypecode\":\"\",\"optionname\":\"Markilux 990 deluxe full cassette awning\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":5578,\"labelname\":\"Color\",\"value\":\"301 02 Sunvas\",\"valueid\":\"13964\",\"type\":20,\"optionid\":\"13964\",\"optionvalue\":[{\"optionid\":13964,\"optionname\":\"301 02 Sunvas\",\"optioncode\":\"AMC250\",\"optionquantity\":1,\"fieldoptionlinkid\":13964,\"forchildfieldoptionlinkid\":\"20_3_13964_1\",\"minimumdiscount\":\"\",\"maximumdiscount\":\"\",\"optionimage\":\"\",\"subdatacount\":0,\"pricegroup\":\"Markilux 990 deluxe full cassette awning\",\"pricegroupid\":1}],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":5586,\"labelname\":\"Width\",\"value\":\"567\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":5587,\"labelname\":\"Projection\",\"value\":\"899\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":5588,\"labelname\":\"Operation side\",\"value\":\"Right Hand Operation\",\"valueid\":\"6974\",\"type\":3,\"optionid\":\"1003\",\"optionvalue\":[{\"optionid\":1003,\"optionname\":\"Right Hand Operation\",\"optioncode\":\"RH\",\"optionqty\":1,\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":6974,\"forchildfieldoptionlinkid\":\"3_6974\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":5589,\"labelname\":\"Special Fabrics\",\"value\":\"Soltis\",\"valueid\":\"7109\",\"type\":3,\"optionid\":\"1504\",\"optionvalue\":[{\"optionid\":1504,\"optionname\":\"Soltis\",\"optioncode\":\"AWM137\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":10.51,\"pricingtype\":\"\",\"fieldoptionlinkid\":7109,\"forchildfieldoptionlinkid\":\"3_7109\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"10.51\",\"fieldid\":7109}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":5590,\"labelname\":\"Special Non Standard Brackets\",\"value\":\"Face Fixture Incl Spreader Plate A\",\"valueid\":\"6977\",\"type\":3,\"optionid\":\"1372\",\"optionvalue\":[{\"optionid\":1372,\"optionname\":\"Face Fixture Incl Spreader Plate A\",\"optioncode\":\"AWM03\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":228,\"pricingtype\":\"\",\"fieldoptionlinkid\":6977,\"forchildfieldoptionlinkid\":\"3_6977\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"228.00\",\"fieldid\":6977}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":5591,\"labelname\":\"Frame Colour\",\"value\":\"Frame Finish In 5204 Anthracite\",\"valueid\":\"6992\",\"type\":3,\"optionid\":\"1387\",\"optionvalue\":[{\"optionid\":1387,\"optionname\":\"Frame Finish In 5204 Anthracite\",\"optioncode\":\"AWM18\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":6992,\"forchildfieldoptionlinkid\":\"3_6992\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":5592,\"labelname\":\"Control Options\",\"value\":\"Your Awning Will Be Standard Gear Operated With Winding Handle,Your Awning Will Be Mains Powered With A Radio Controled RTS Motor 433 MHZ\",\"valueid\":\"7019,7020\",\"type\":3,\"optionid\":\"1414,1415\",\"optionvalue\":[{\"optionid\":1414,\"optionname\":\"Your Awning Will Be Standard Gear Operated With Winding Handle\",\"optioncode\":\"AWM45\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":7019,\"forchildfieldoptionlinkid\":\"3_7019\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"},{\"optionid\":1415,\"optionname\":\"Your Awning Will Be Mains Powered With A Radio Controled RTS Motor 433 MHZ\",\"optioncode\":\"AWM46\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":399,\"pricingtype\":\"\",\"fieldoptionlinkid\":7020,\"forchildfieldoptionlinkid\":\"3_7020\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"399.00\",\"fieldid\":7020}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1,1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":5595,\"labelname\":\"Frame End Cap Insert and Styling Panel Colour\",\"value\":\"Metallic Aluminium Ral9006\",\"valueid\":\"7005\",\"type\":3,\"optionid\":\"1400\",\"optionvalue\":[{\"optionid\":1400,\"optionname\":\"Metallic Aluminium Ral9006\",\"optioncode\":\"AWM31\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":7005,\"forchildfieldoptionlinkid\":\"3_7005\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":5596,\"labelname\":\"Fixture Method\",\"value\":\"Top Fix Bracket Left 71625 Pair,Face Fix Brackets 300mm 70617 Left\",\"valueid\":\"7069,7070\",\"type\":3,\"optionid\":\"1464,1465\",\"optionvalue\":[{\"optionid\":1464,\"optionname\":\"Top Fix Bracket Left 71625 Pair\",\"optioncode\":\"AWM97\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":68.8,\"pricingtype\":\"\",\"fieldoptionlinkid\":7069,\"forchildfieldoptionlinkid\":\"3_7069\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"68.80\",\"fieldid\":7069},{\"optionid\":1465,\"optionname\":\"Face Fix Brackets 300mm 70617 Left\",\"optioncode\":\"AWM98\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":58.5,\"pricingtype\":\"\",\"fieldoptionlinkid\":7070,\"forchildfieldoptionlinkid\":\"3_7070\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"58.50\",\"fieldid\":7070}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1,1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":5593,\"labelname\":\"Extras\",\"value\":\"RTS Somfy Motor,Upgrade Bionic Tendon Arms\",\"valueid\":\"7026,7027\",\"type\":3,\"optionid\":\"1422,1421\",\"optionvalue\":[{\"optionid\":1421,\"optionname\":\"RTS Somfy Motor\",\"optioncode\":\"AWM52\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":425,\"pricingtype\":\"\",\"fieldoptionlinkid\":7026,\"forchildfieldoptionlinkid\":\"3_7026\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"425.00\",\"fieldid\":7026},{\"optionid\":1422,\"optionname\":\"Upgrade Bionic Tendon Arms\",\"optioncode\":\"AWM53\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":78,\"pricingtype\":\"\",\"fieldoptionlinkid\":7027,\"forchildfieldoptionlinkid\":\"3_7027\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"78.00\",\"fieldid\":7027}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1,1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":5594,\"labelname\":\"Special Instructions\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]", "oi_description": "Supplier: Markilux, System: Markilux 990 deluxe full cassette awning, Color: 301 02 Sunvas, Width: 567, Projection: 899, Operation side: Right Hand Operation, Special Fabrics: Soltis, Special Non Standard Brackets: Face Fixture Incl Spreader Plate A, Frame Colour: Frame Finish In 5204 Anthracite, Control Options: Your Awning Will Be Standard Gear Operated With Winding Handle,Your Awning Will Be Mains Powered With A Radio Controled RTS Motor 433 MHZ, Frame End Cap Insert and Styling Panel Colour: Metallic Aluminium Ral9006, Fixture Method: Top Fix Bracket Left 71625 Pair,Face Fix Brackets 300mm 70617 Left, Extras: RTS Somfy Motor,Upgrade Bionic Tendon Arms", "oi_reportdescription": "##Quantity: 1##,##Supplier: Markilux##,##System: Markilux 990 deluxe full cassette awning##,##Color: 301 02 Sunvas##,##Width: 567 mm##,##Projection: 899 mm##,##Operation side: Right Hand Operation##,##Special Fabrics: Soltis##,##Special Non Standard Brackets: Face Fixture Incl Spreader Plate A##,##Frame Colour: Frame Finish In 5204 Anthracite##,##Control Options: Your Awning Will Be Standard Gear Operated With Winding Handle,Your Awning Will Be Mains Powered With A Radio Controled RTS Motor 433 MHZ##,##Frame End Cap Insert and Styling Panel Colour: Metallic Aluminium Ral9006##,##Fixture Method: Top Fix Bracket Left 71625 Pair,Face Fix Brackets 300mm 70617 Left##,##Extras: RTS Somfy Motor,Upgrade Bionic Tendon Arms##", "oi_reporttitles": "##Quantity:##Supplier:##System:##Color:##Width:##Projection:##Operation side:##Special Fabrics:##Special Non Standard Brackets:##Frame Colour:##Control Options:##Frame End Cap Insert and Styling Panel Colour:##Fixture Method:##Extras:", "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": "2142.470", "oi_netprice": "3017.130", "oi_pricesfromoperations": null, "oi_vatprice": "301.710", "oi_vatvalue": "10.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "3318.840", "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": 1, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 0, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "0.000", "oi_endcustomeroverridevatprice": "0.000", "oi_endcustomeroverridegrossprice": "0.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[6897, 5163, 5164, 5585, 5235, 5578, 5586, 5587, 5588, 5589, 5590, 5591, 5592, 5595, 5596, 5593, 5594]", "oi_deviceplatform": 2, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "31348", "oi_productiondate": 1749045933, "oi_createdat": 1749045970, "oi_updatedat": 1749046242, "oi_createdby": 1, "oi_updatedby": null } ], "updated": [], "deleted": [] }, "bm_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_notelist": { "created": [ { "nl_id": 105230, "nl_ordertempid": 0, "nl_orderid": 5729, "nl_notescategory": 1, "nl_type": 17, "nl_platform": 2, "nl_desc": "New job has been created in job", "nl_manualNotes": null, "nl_createdby": "1", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 0, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "105230", "nl_endddate": 1748995200, "nl_starttime": 1749045735, "created_at": 1749045735, "updated_at": 1749046242, "created_by": 1, "updated_by": null }, { "nl_id": 105231, "nl_ordertempid": 0, "nl_orderid": 5730, "nl_notescategory": 1, "nl_type": 17, "nl_platform": 2, "nl_desc": "New job has been created in job", "nl_manualNotes": null, "nl_createdby": "1", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 0, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "105231", "nl_endddate": 1748995200, "nl_starttime": 1749045880, "created_at": 1749045880, "updated_at": 1749046242, "created_by": 1, "updated_by": null } ], "updated": [], "deleted": [] }, "bm_deliveryaddresssetting": { "created": [ { "das_id": 5585, "das_jobid": 5728, "das_appointmentaddress": 4187, "das_invoiceaddress": 4187, "das_invoicedeliveryaddress": 4187, "das_purchaseaddress": 0, "das_worksheetaddress": 0, "id": "5585", "das_createdat": 1749045625, "das_updatedat": 1749045625, "das_createdby": 1, "das_updatedby": null }, { "das_id": 5586, "das_jobid": 5729, "das_appointmentaddress": 4219, "das_invoiceaddress": 4219, "das_invoicedeliveryaddress": 4219, "das_purchaseaddress": 0, "das_worksheetaddress": 0, "id": "5586", "das_createdat": 1749046242, "das_updatedat": 1749046242, "das_createdby": 1, "das_updatedby": null }, { "das_id": 5587, "das_jobid": 5730, "das_appointmentaddress": 4220, "das_invoiceaddress": 4220, "das_invoicedeliveryaddress": 4220, "das_purchaseaddress": 0, "das_worksheetaddress": 0, "id": "5587", "das_createdat": 1749046243, "das_updatedat": 1749046243, "das_createdby": 1, "das_updatedby": null } ], "updated": [], "deleted": [] }, "bm_jobchecklist": { "created": [], "updated": [], "deleted": [] }, "bm_Invoice": { "created": [], "updated": [], "deleted": [] }, "bm_InvoiceDetails": { "created": [], "updated": [], "deleted": [] }, "bm_invoice_credit_note": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNote": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNoteDetails": { "created": [], "updated": [], "deleted": [] }, "bm_job_paymentlist": { "created": [ { "jp_id": 394, "jp_job_id": 5729, "jp_amount": "100.000", "jp_amountoutstanding": "100.000", "jp_paymentmethod": 14, "jp_paymentcategory": 1, "jp_paymenttype": 8, "jp_surchargetype": 2, "jp_surchargemethod": 2, "jp_surchargeamount": "0.000", "jp_surchargevalue": null, "jp_surchargetotal": "100.000", "jp_userid": 1, "jp_decription": "", "jp_deviceplatform": 2, "jp_status": 0, "jp_transfer": 0, "jp_transfer_id": null, "id": "394", "jp_paiddate": 1748995200, "jp_createdat": 1749045839, "jp_updatedat": 1749046242, "jp_createdby": 1, "jp_updatedby": null }, { "jp_id": 395, "jp_job_id": 5730, "jp_amount": "1000.000", "jp_amountoutstanding": "1000.000", "jp_paymentmethod": 14, "jp_paymentcategory": 1, "jp_paymenttype": 8, "jp_surchargetype": 2, "jp_surchargemethod": 2, "jp_surchargeamount": "0.000", "jp_surchargevalue": null, "jp_surchargetotal": "1000.000", "jp_userid": 1, "jp_decription": "", "jp_deviceplatform": 2, "jp_status": 0, "jp_transfer": 0, "jp_transfer_id": null, "id": "395", "jp_paiddate": 1748995200, "jp_createdat": 1749045986, "jp_updatedat": 1749046242, "jp_createdby": 1, "jp_updatedby": null } ], "updated": [], "deleted": [] }, "bm_OverPayment": { "created": [], "updated": [], "deleted": [] }, "bm_terms": { "created": [], "updated": [], "deleted": [] }, "bm_jobmultiquote": { "created": [ { "jmq_id": 5758, "jmq_jobid": 5729, "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": "7.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": "77.00", "jmq_grossprofit": "70.00", "jmq_costprice": "0.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "-23.00", "jmq_totpaid": "100.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": "10.000", "jmq_cdeliveryvatperc": "10.000", "id": "5758", "jmq_duedate": null, "jmq_sceduleddate": null, "jmq_createdat": "1749045735.000000", "jmq_updatedat": null, "jmq_createdby": 1, "jmq_updatedby": null }, { "jmq_id": 5759, "jmq_jobid": 5730, "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": "7.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": "77.00", "jmq_grossprofit": "70.00", "jmq_costprice": "0.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "-923.00", "jmq_totpaid": "1000.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": "10.000", "jmq_cdeliveryvatperc": "10.000", "id": "5759", "jmq_duedate": null, "jmq_sceduleddate": null, "jmq_createdat": "1749045880.000000", "jmq_updatedat": null, "jmq_createdby": 1, "jmq_updatedby": 1 } ], "updated": [], "deleted": [] }, "bm_jobstatus_tracks": { "created": [ { "jst_id": 6419, "jst_jobid": 5728, "jst_job_current_status": 1, "id": "6419", "jst_createdat": "1749045675.042906" }, { "jst_id": 6420, "jst_jobid": 5729, "jst_job_current_status": 1, "id": "6420", "jst_createdat": "1749046242.392085" }, { "jst_id": 6421, "jst_jobid": 5730, "jst_job_current_status": 6, "id": "6421", "jst_createdat": "1749046242.580908" } ], "updated": [], "deleted": [] }, "bm_customindividuallogs": { "created": [ { "cl_id": 57728, "cl_logname": "default", "cl_type": null, "cl_modulename": "Payments", "cl_message": "new item has been created in Payments", "cl_event": "created", "cl_subjectid": 4075, "cl_subjecttype": "App\\Models\\Payment\\bm_paymentlist", "cl_parentid": 4075, "cl_parentsubjecttype": "App\\Models\\Payment\\bm_paymentlist", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"pl_invoice_id\":2603,\"pl_customer_id\":4011,\"pl_overpayment_id\":0,\"pl_jobpayment_id\":0,\"Amount\":\"55.00\",\"Payment Method\":\"stripe\",\"Payment Type\":\"Deposit\",\"pl_surchargetype\":2,\"pl_surchargemethod\":2,\"pl_surchargeamount\":\"0.00\",\"pl_surchargevalue\":\"0.00\",\"pl_surchargetotal\":\"55.00\",\"User Entered\":\"admin\",\"Paid Date\":\"2025-06-04\",\"pl_myob_flag\":0,\"pl_qbo_flag\":0}", "cl_customproperties": "{\"attributes\":{\"pl_id\":4075,\"pl_orderid\":null,\"pl_invoice_id\":2603,\"pl_customer_id\":4011,\"pl_overpayment_id\":0,\"pl_jobpayment_id\":0,\"pl_amount\":\"55.00\",\"pl_paymentmethod\":14,\"pl_paymentcategory\":1,\"pl_paymenttype\":8,\"pl_surchargetype\":2,\"pl_surchargemethod\":2,\"pl_surchargeamount\":\"0.00\",\"pl_surchargevalue\":\"0.00\",\"pl_surchargetotal\":\"55.00\",\"pl_userid\":\"1\",\"pl_paiddate\":\"2025-06-04\",\"pl_decription\":null,\"pl_paymentinvoice\":null,\"pl_paymentstatus\":0,\"pl_xero_flag\":0,\"pl_xerooverpaymentid\":null,\"pl_seq\":0,\"pl_status\":0,\"pl_refundtype\":null,\"created_by\":1,\"created_at\":\"2025-06-04T13:52:43.000000Z\",\"updated_by\":null,\"updated_at\":null,\"pl_deviceplatform\":2,\"pl_myob_flag\":0,\"pl_qbo_flag\":0}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "57728", "cl_createdat": "1749045625.000000", "cl_updatedat": null }, { "cl_id": 57729, "cl_logname": "default", "cl_type": null, "cl_modulename": "Alternative Address", "cl_message": "Alternative Address has been updated the fields Appointments Add,Invoice Add,Invoice Delivery Add,Purchase Add,Worksheet Add", "cl_event": "modified", "cl_subjectid": 5585, "cl_subjecttype": "App\\Models\\Job\\bm_deliveryaddresssetting", "cl_parentid": 5728, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Appointments Add\":\"Alternative Delivery Address\",\"Invoice Add\":\"Alternative Delivery Address\",\"Invoice Delivery Add\":\"Alternative Delivery Address\",\"Purchase Add\":\"Default(Same as billing add)\",\"Worksheet Add\":\"Default(Same as billing add)\"}", "cl_customproperties": "{\"attributes\":{\"das_id\":5585,\"das_jobid\":5728,\"das_appointmentaddress\":4187,\"das_invoiceaddress\":4187,\"das_invoicedeliveryaddress\":4187,\"das_purchaseaddress\":0,\"das_worksheetaddress\":0,\"das_createdby\":1,\"das_createdat\":\"2025-06-04T14:00:25.000000Z\",\"das_updatedby\":null,\"das_updatedat\":\"2025-06-04T14:00:25.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "57729", "cl_createdat": "1749045625.000000", "cl_updatedat": null }, { "cl_id": 57733, "cl_logname": "model", "cl_type": null, "cl_modulename": "Job Status", "cl_message": "Job Status has been updated", "cl_event": "modified", "cl_subjectid": 5728, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5728, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "{\"Job Status\":\"Invoiced\"}", "cl_changedto": "{\"Job Status\":\"Lead\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "57733", "cl_createdat": "1749045675.000000", "cl_updatedat": null }, { "cl_id": 57734, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the fields Gross Profit,Gross Profit Percentage,End Customer Override Net Price,End Customer Override Vat Price,End Customer Override Gross Price", "cl_event": "modified", "cl_subjectid": 5728, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5728, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "{\"\":13}", "cl_changedto": "{\"Gross Profit\":\"43.00\",\"Gross Profit Percentage\":\"46.51\",\"End Customer Override Net Price\":\"92.45\",\"End Customer Override Vat Price\":\"9.25\",\"End Customer Override Gross Price\":\"101.70\"}", "cl_customproperties": "{\"attributes\":{\"jd_jobcustomoizedkeyvalue\":\"{\\\"33\\\":25,\\\"37\\\":1,\\\"39\\\":22,\\\"41\\\":1,\\\"44\\\":\\\"John Smith Pvt Ltd\\\",\\\"45\\\":\\\"Johny\\\",\\\"46\\\":\\\"Leo\\\",\\\"47\\\":\\\"595955848\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"Cit Nagar\\\",\\\"50\\\":\\\"Nandanam\\\",\\\"51\\\":\\\"ChennaiChenain\\\",\\\"52\\\":\\\"India\\\",\\\"53\\\":\\\"635301\\\",\\\"54\\\":36,\\\"285\\\":12,\\\"286\\\":\\\"264945946\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":1,\\\"558\\\":1,\\\"559\\\":1,\\\"610\\\":\\\"\\\",\\\"611\\\":\\\"\\\",\\\"612\\\":1}\",\"jd_deletedcustokeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"34\\\":\\\"AQ5725\\\",\\\"35\\\":\\\"JOHN0007\\\",\\\"36\\\":6,\\\"38\\\":\\\"201749045126\\\",\\\"40\\\":13}\",\"jd_orderdate\":\"0000-00-00\",\"jd_sceduleddate\":\"0000-00-00\",\"jd_jobstatus\":1,\"jd_editpricebyid\":0,\"jd_grossprofit\":\"43.00\",\"jd_grossprofit_percentage\":\"46.51\",\"jd_userdefinedarray\":\"\\\"\\\"\",\"jd_deliverycostid\":0,\"jd_endcustomeroverridevalue\":\"\",\"jd_endcustomeroverridenetprice\":\"92.45\",\"jd_endcustomeroverridevatprice\":\"9.25\",\"jd_endcustomeroverridegrossprice\":\"101.70\",\"jd_endcustomerdeliverycost\":\"\",\"jd_endcustomerfittingcost\":\"\",\"jd_updatedat\":\"2025-06-04T14:01:14.000000Z\"},\"old\":{\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"AQ5725\\\",\\\"35\\\":\\\"JOHN0007\\\",\\\"36\\\":6,\\\"37\\\":1,\\\"38\\\":\\\"201749045126\\\",\\\"39\\\":22,\\\"40\\\":13,\\\"41\\\":1,\\\"44\\\":\\\"John Smith Pvt Ltd\\\",\\\"45\\\":\\\"Johny\\\",\\\"46\\\":\\\"Leo\\\",\\\"47\\\":\\\"595955848\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"Cit Nagar\\\",\\\"50\\\":\\\"Nandanam\\\",\\\"51\\\":\\\"ChennaiChenain\\\",\\\"52\\\":\\\"India\\\",\\\"53\\\":\\\"635301\\\",\\\"54\\\":36,\\\"285\\\":12,\\\"286\\\":\\\"264945946\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":1,\\\"558\\\":1,\\\"559\\\":\\\"\\\",\\\"610\\\":\\\"\\\",\\\"611\\\":\\\"\\\",\\\"612\\\":\\\"\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_orderdate\":\"2025-06-04\",\"jd_sceduleddate\":null,\"jd_jobstatus\":6,\"jd_editpricebyid\":null,\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_userdefinedarray\":null,\"jd_deliverycostid\":null,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerfittingcost\":null,\"jd_updatedat\":\"2025-06-04T14:00:24.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "57734", "cl_createdat": "1749045675.000000", "cl_updatedat": null }, { "cl_id": 57735, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the field jd_qbodisplayname", "cl_event": "modified", "cl_subjectid": 5728, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5728, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "[]", "cl_changedto": "{\"jd_qbodisplayname\":\"John Smith Pvt Ltd\"}", "cl_customproperties": "{\"attributes\":{\"jd_qbodisplayname\":\"John Smith Pvt Ltd\"},\"old\":{\"jd_qbodisplayname\":\"\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "57735", "cl_createdat": "1749045675.000000", "cl_updatedat": null }, { "cl_id": 57739, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 5729, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5729, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"Aquarius Blinds\",\"\":13,\"Account Type\":\"Domestic\",\"Created By\":\"admin\",\"First Name\":\"Kavin K \",\"Last Name\":\"K \",\"Mobile\":\"76456888\",\"Country\":\"India\",\"Salutation\":\"Dr\",\"Assigned to\":1,\"Additional Contacts\":\"4219\",\"Completed Date\":\"1970-01-01\",\"Job Ref No\":\"AQ5726\",\"Job Status\":\"Lead\",\"Order Status\":\"Enquiry\",\"Net Price\":\"70.00\",\"VAT Price\":\"7.00\",\"VAT\":\"Enabled\",\"DeliveryCost\":\"70.00\",\"Delivery Cost\":\"All Options\",\"Gross Price Amount\":\"77.00\",\"Gross Profit\":\"70.00\",\"Amount Outstanding\":\"-23.00\",\"Total Paid\":\"100.00\",\"jd_isonlineorder\":1,\"Delivery Vat Percentage\":\"10.000\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":5729,\"jd_customerid\":4038,\"jd_contactid\":4219,\"jd_additionalcontacts\":\"4219\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"AQ5726\\\",\\\"35\\\":\\\"KKAV0003\\\",\\\"36\\\":1,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":\\\"\\\",\\\"40\\\":13,\\\"41\\\":1,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"Kavin K \\\",\\\"46\\\":\\\"K \\\",\\\"47\\\":\\\"76456888\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":36,\\\"285\\\":12,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":1,\\\"558\\\":\\\"\\\",\\\"559\\\":1,\\\"610\\\":\\\"\\\",\\\"611\\\":\\\"\\\",\\\"612\\\":1}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-06-04\",\"jd_orderdate\":null,\"jd_duedate\":null,\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":\"1970-01-01\",\"jd_jobref\":\"AQ5726\",\"jd_jobstatus\":1,\"jd_contactaddid\":0,\"jd_orderstatus\":13,\"jd_accref\":\"KKAV0003\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"0.00\",\"jd_netprice\":\"70.00\",\"jd_vat\":\"7.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\":\"77.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\":\"-23.00\",\"jd_totpaid\":\"100.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\":1,\"jd_createdat\":\"2025-06-04T14:02:15.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-06-04T14:10:42.000000Z\",\"salesorderid\":null,\"jd_deviceplatform\":0,\"jd_fromjobref\":\"\",\"jd_fromdbname\":null,\"jd_importorder\":0,\"jd_quickquote\":0,\"jd_myob_flag\":0,\"jd_myobinvoiceid\":\"\",\"jd_qboflag\":0,\"jd_qboinvoiceid\":0,\"jd_qbodisplayname\":\"\",\"jd_deliveryvatperc\":\"10.000\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"10.000\",\"jd_commission\":null,\"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": "57739", "cl_createdat": "1749046242.000000", "cl_updatedat": null }, { "cl_id": 57740, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 5730, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5730, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"Aquarius Blinds\",\"\":13,\"Account Type\":\"Domestic\",\"Created By\":\"admin\",\"First Name\":\"George \",\"Last Name\":\"G \",\"Country\":\"India\",\"Salutation\":\"Dr\",\"Assigned to\":1,\"Additional Contacts\":\"4220\",\"Order Date\":\"2025-06-04\",\"Completed Date\":\"1970-01-01\",\"Job Ref No\":\"AQ5727\",\"Job Status\":\"Invoiced\",\"Order Status\":\"Enquiry\",\"Net Price\":\"70.00\",\"VAT Price\":\"7.00\",\"VAT\":\"Enabled\",\"DeliveryCost\":\"70.00\",\"Delivery Cost\":\"All Options\",\"Gross Price Amount\":\"77.00\",\"Gross Profit\":\"70.00\",\"Amount Outstanding\":\"-923.00\",\"Total Paid\":\"1000.00\",\"jd_isonlineorder\":1,\"Delivery Vat Percentage\":\"10.000\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\",\"Job Rework Enable\":\"On\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":5730,\"jd_customerid\":4039,\"jd_contactid\":4220,\"jd_additionalcontacts\":\"4220\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"AQ5727\\\",\\\"35\\\":\\\"GGEO0001\\\",\\\"36\\\":6,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":\\\"\\\",\\\"40\\\":13,\\\"41\\\":1,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"George \\\",\\\"46\\\":\\\"G \\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":36,\\\"285\\\":12,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":1,\\\"558\\\":\\\"\\\",\\\"559\\\":1,\\\"610\\\":\\\"\\\",\\\"611\\\":\\\"\\\",\\\"612\\\":1}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-06-04\",\"jd_orderdate\":\"2025-06-04\",\"jd_duedate\":null,\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":\"1970-01-01\",\"jd_jobref\":\"AQ5727\",\"jd_jobstatus\":6,\"jd_contactaddid\":0,\"jd_orderstatus\":13,\"jd_accref\":\"GGEO0001\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"0.00\",\"jd_netprice\":\"70.00\",\"jd_vat\":\"7.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\":\"77.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\":\"-923.00\",\"jd_totpaid\":\"1000.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\":1,\"jd_createdat\":\"2025-06-04T14:04:40.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-06-04T14:10:42.000000Z\",\"salesorderid\":null,\"jd_deviceplatform\":0,\"jd_fromjobref\":\"\",\"jd_fromdbname\":null,\"jd_importorder\":0,\"jd_quickquote\":0,\"jd_myob_flag\":0,\"jd_myobinvoiceid\":\"\",\"jd_qboflag\":0,\"jd_qboinvoiceid\":0,\"jd_qbodisplayname\":\"\",\"jd_deliveryvatperc\":\"10.000\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"10.000\",\"jd_commission\":\"[]\",\"jd_commissionprice\":\"0.00\",\"jd_commissionsetting\":0,\"jd_commissionaddedvalue\":\"0.00\",\"jd_onlineprefixseq\":null,\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":1,\"jd_rework_count\":0}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "57740", "cl_createdat": "1749046242.000000", "cl_updatedat": null }, { "cl_id": 57741, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105230, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 5729, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"Job Created\",\"Platform\":\"Trade\",\"Description\":\"New job has been created in job\",\"Created By\":\"admin\",\"Date\":\"2025-06-04\",\"Time\":\"14:02:15\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105230,\"nl_ordertempid\":0,\"nl_orderid\":5729,\"nl_notescategory\":1,\"nl_type\":17,\"nl_platform\":2,\"nl_desc\":\"New job has been created in job\",\"nl_manualNotes\":null,\"nl_createdby\":\"1\",\"nl_endddate\":\"2025-06-04\",\"nl_starttime\":\"14:02:15\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":1,\"created_at\":\"2025-06-04T14:02:15.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-04T14:10:42.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "57741", "cl_createdat": "1749046242.000000", "cl_updatedat": null }, { "cl_id": 57742, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105231, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 5730, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"Job Created\",\"Platform\":\"Trade\",\"Description\":\"New job has been created in job\",\"Created By\":\"admin\",\"Date\":\"2025-06-04\",\"Time\":\"14:04:40\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105231,\"nl_ordertempid\":0,\"nl_orderid\":5730,\"nl_notescategory\":1,\"nl_type\":17,\"nl_platform\":2,\"nl_desc\":\"New job has been created in job\",\"nl_manualNotes\":null,\"nl_createdby\":\"1\",\"nl_endddate\":\"2025-06-04\",\"nl_starttime\":\"14:04:40\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":1,\"created_at\":\"2025-06-04T14:04:40.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-04T14:10:42.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "57742", "cl_createdat": "1749046242.000000", "cl_updatedat": null }, { "cl_id": 57743, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in AQ5726", "cl_event": "created", "cl_subjectid": 5758, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 5729, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":5758,\"jmq_jobid\":5729,\"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\":\"7.00\",\"VAT\":1,\"jmq_deliverycost\":\"70.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"77.00\",\"Gross Profit\":\"70.00\",\"Total CostPrice\":\"0.00\",\"Amount Outstanding\":\"-23.00\",\"Total Paid\":\"100.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\":\"10.000\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":5758,\"jmq_jobid\":5729,\"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\":\"7.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\":\"77.00\",\"jmq_grossprofit\":\"70.00\",\"jmq_costprice\":\"0.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"-23.00\",\"jmq_totpaid\":\"100.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\":\"10.000\",\"jmq_cdeliveryvatperc\":\"10.000\",\"jmq_createdby\":1,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-06-04T14:02:15.000000Z\",\"jmq_updatedat\":null,\"jmq_grossprofit_percentage\":\"0.00\",\"jmq_ready\":0}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "57743", "cl_createdat": "1749046242.000000", "cl_updatedat": null }, { "cl_id": 57744, "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": 5729, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5729, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":5758}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":5758},\"old\":{\"jd_jobmultiquoteid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "57744", "cl_createdat": "1749046242.000000", "cl_updatedat": null }, { "cl_id": 57745, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in AQ5727", "cl_event": "created", "cl_subjectid": 5759, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 5730, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":5759,\"jmq_jobid\":5730,\"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\":\"7.00\",\"VAT\":1,\"jmq_deliverycost\":\"70.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"77.00\",\"Gross Profit\":\"70.00\",\"Total CostPrice\":\"0.00\",\"Amount Outstanding\":\"-923.00\",\"Total Paid\":\"1000.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\":\"10.000\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":5759,\"jmq_jobid\":5730,\"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\":\"7.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\":\"77.00\",\"jmq_grossprofit\":\"70.00\",\"jmq_costprice\":\"0.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"-923.00\",\"jmq_totpaid\":\"1000.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\":\"10.000\",\"jmq_cdeliveryvatperc\":\"10.000\",\"jmq_createdby\":1,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-06-04T14:04:40.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": "57745", "cl_createdat": "1749046242.000000", "cl_updatedat": null }, { "cl_id": 57746, "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": 5730, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5730, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":5759}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":5759},\"old\":{\"jd_jobmultiquoteid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "57746", "cl_createdat": "1749046242.000000", "cl_updatedat": null }, { "cl_id": 57747, "cl_logname": "default", "cl_type": null, "cl_modulename": "Line Item", "cl_message": "new item has been created in Line Item for the product of Cellular Blinds @12", "cl_event": "created", "cl_subjectid": 31347, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 5729, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Supplier\":\" Master Blinds\",\" Width\":\" 566\",\" Drop\":\" 899\",\" Price Chart\":\" Window Group 2 Band C\",\" Fabric\":\" 25mm Elan DuoTone RD\",\" Color\":\" AgateGrey 0987\",\" Blind or Recess\":\" Recess size\",\" Brackets\":\" Extension L Bracket 20_40 10mm Clearance\",\" Bracket 10mm Clearance Color Options\":\" Brown\",\" Hardware Colours\":\" Anthracite Grey\",\" Motorization\":\" 240V Sonesse 40 RTS Motor\",\"Somfy 12v Tilt and Lift RTS Motor\":\"Somfy 12v Tilt and Lift RTS Motor\"}", "cl_customproperties": "{\"attributes\":{\"oi_id\":31347,\"oi_jobid\":5729,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":null,\"oi_credit_id\":0,\"oi_productid\":12,\"oi_recipeid\":12,\"oi_ruleid\":0,\"oi_qty\":1,\"oi_seq\":0,\"oi_customseq\":0,\"oi_productcustomseq\":0,\"oi_jsondata\":\"[{\\\"id\\\":6890,\\\"labelname\\\":\\\"Unit Type\\\",\\\"value\\\":2,\\\"valueid\\\":\\\"2\\\",\\\"type\\\":34,\\\"optionid\\\":\\\"2\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":2,\\\"optionname\\\":\\\"mm\\\",\\\"optioncode\\\":\\\"\\\",\\\"optionquantity\\\":1,\\\"unittype\\\":0,\\\"unitcost\\\":0,\\\"pricingtype\\\":0,\\\"fieldoptionlinkid\\\":2,\\\"forchildfieldoptionlinkid\\\":\\\"34_2\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":4407,\\\"labelname\\\":\\\"Location\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":469,\\\"labelname\\\":\\\"Quantity\\\",\\\"value\\\":1,\\\"valueid\\\":\\\"\\\",\\\"type\\\":14,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":470,\\\"labelname\\\":\\\"Supplier\\\",\\\"value\\\":4,\\\"valueid\\\":\\\"\\\",\\\"type\\\":17,\\\"optionid\\\":\\\"4\\\",\\\"optionvalue\\\":[{\\\"id\\\":4,\\\"optionid\\\":4,\\\"optionname\\\":\\\"Master Blinds\\\",\\\"deleted\\\":0,\\\"optionquantity\\\":1}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":662,\\\"labelname\\\":\\\"Width\\\",\\\"value\\\":\\\"566\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":11,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":663,\\\"labelname\\\":\\\"Drop\\\",\\\"value\\\":\\\"899\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":12,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":4386,\\\"labelname\\\":\\\"Blind Model\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":661,\\\"labelname\\\":\\\"Price Chart\\\",\\\"value\\\":94,\\\"valueid\\\":\\\"187,290\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"94\\\",\\\"optionvalue\\\":[{\\\"id\\\":187,\\\"fieldid\\\":661,\\\"fieldoptionlinkid\\\":187,\\\"optionid\\\":94,\\\"mainsupplier\\\":4,\\\"blindtypecode\\\":\\\"\\\",\\\"optionname\\\":\\\"Window Group 2 Band C\\\",\\\"optionquantity\\\":1,\\\"subcount\\\":0,\\\"status\\\":0,\\\"subdatacount\\\":0},{\\\"id\\\":290,\\\"fieldid\\\":661,\\\"fieldoptionlinkid\\\":290,\\\"optionid\\\":94,\\\"mainsupplier\\\":4,\\\"blindtypecode\\\":\\\"\\\",\\\"optionname\\\":\\\"Window Group 2 Band C\\\",\\\"optionquantity\\\":1,\\\"subcount\\\":0,\\\"status\\\":0,\\\"subdatacount\\\":0}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\",\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":665,\\\"labelname\\\":\\\"Fabric\\\",\\\"value\\\":\\\"25mm Elan DuoTone RD\\\",\\\"valueid\\\":\\\"4088\\\",\\\"type\\\":5,\\\"optionid\\\":\\\"4088\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":4088,\\\"optionname\\\":\\\"25mm Elan DuoTone RD\\\",\\\"optioncode\\\":\\\"HDF49\\\",\\\"optionquantity\\\":1,\\\"fieldoptionlinkid\\\":4088,\\\"forchildfieldoptionlinkid\\\":\\\"5_2_4088_1\\\",\\\"optionimage\\\":\\\"\\\",\\\"subdatacount\\\":1,\\\"pricegroup\\\":\\\"Window Group 2 Band C\\\",\\\"pricegroupid\\\":94}],\\\"fabricorcolor\\\":1,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":4346,\\\"labelname\\\":\\\"Color\\\",\\\"value\\\":\\\"AgateGrey 0987\\\",\\\"valueid\\\":\\\"8673\\\",\\\"type\\\":5,\\\"optionid\\\":\\\"8673\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":8673,\\\"optionname\\\":\\\"AgateGrey 0987\\\",\\\"optioncode\\\":\\\"HDC019\\\",\\\"optionquantity\\\":1,\\\"fieldoptionlinkid\\\":8673,\\\"forchildfieldoptionlinkid\\\":\\\"5_3_8673_1\\\",\\\"minimumdiscount\\\":\\\"\\\",\\\"maximumdiscount\\\":\\\"\\\",\\\"optionimage\\\":\\\"\\\",\\\"subdatacount\\\":0}],\\\"fabricorcolor\\\":2,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":664,\\\"labelname\\\":\\\"Blind or Recess\\\",\\\"value\\\":\\\"Recess size\\\",\\\"valueid\\\":\\\"5443\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"475\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":475,\\\"optionname\\\":\\\"Recess size\\\",\\\"optioncode\\\":\\\"jcld\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":5443,\\\"forchildfieldoptionlinkid\\\":\\\"3_5443\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":4387,\\\"labelname\\\":\\\"Brackets\\\",\\\"value\\\":\\\"Extension L Bracket 20_40 10mm Clearance\\\",\\\"valueid\\\":\\\"5300\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"922\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":922,\\\"optionname\\\":\\\"Extension L Bracket 20_40 10mm Clearance\\\",\\\"optioncode\\\":\\\"CBC002\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":null,\\\"unitcost\\\":1.03,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":5300,\\\"forchildfieldoptionlinkid\\\":\\\"3_5300\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":1,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"1.03\\\",\\\"fieldid\\\":5300}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":4398,\\\"labelname\\\":\\\"Bracket 10mm Clearance Color Options\\\",\\\"value\\\":\\\"Brown\\\",\\\"valueid\\\":\\\"5366\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"616\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":616,\\\"optionname\\\":\\\"Brown\\\",\\\"optioncode\\\":\\\"\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":5366,\\\"forchildfieldoptionlinkid\\\":\\\"3_5366\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":4388,\\\"labelname\\\":\\\"Installation Height mm\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":4389,\\\"labelname\\\":\\\"Hardware Colours\\\",\\\"value\\\":\\\"Anthracite Grey\\\",\\\"valueid\\\":\\\"5440\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"981\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":981,\\\"optionname\\\":\\\"Anthracite Grey\\\",\\\"optioncode\\\":\\\"\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":5440,\\\"forchildfieldoptionlinkid\\\":\\\"3_5440\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":4461,\\\"labelname\\\":\\\"Motorization\\\",\\\"value\\\":\\\"240V Sonesse 40 RTS Motor,Somfy 12v Tilt and Lift RTS Motor\\\",\\\"valueid\\\":\\\"5580,5581\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"1018,1019\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":1018,\\\"optionname\\\":\\\"240V Sonesse 40 RTS Motor\\\",\\\"optioncode\\\":\\\"CBC019\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":5580,\\\"forchildfieldoptionlinkid\\\":\\\"3_5580\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":1,\\\"optionimage\\\":\\\"\\\"},{\\\"optionid\\\":1019,\\\"optionname\\\":\\\"Somfy 12v Tilt and Lift RTS Motor\\\",\\\"optioncode\\\":\\\"CBC020\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":5581,\\\"forchildfieldoptionlinkid\\\":\\\"3_5581\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":1,\\\"optionimage\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1,1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":4463,\\\"labelname\\\":\\\"Main Motor Accessories\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":4464,\\\"labelname\\\":\\\"Motor Options 12v\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":4390,\\\"labelname\\\":\\\"Extras\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":4391,\\\"labelname\\\":\\\"Special Instructions\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0}]\",\"oi_description\":\"Supplier: Master Blinds, Width: 566, Drop: 899, Price Chart: Window Group 2 Band C, Fabric: 25mm Elan DuoTone RD, Color: AgateGrey 0987, Blind or Recess: Recess size, Brackets: Extension L Bracket 20_40 10mm Clearance, Bracket 10mm Clearance Color Options: Brown, Hardware Colours: Anthracite Grey, Motorization: 240V Sonesse 40 RTS Motor,Somfy 12v Tilt and Lift RTS Motor\",\"oi_onlinedescription\":null,\"oi_imagepath\":null,\"oi_reportdescription\":\"##Quantity: 1##,##Supplier: Master Blinds##,##Width: 566 mm##,##Drop: 899 mm##,##Price Chart: Window Group 2 Band C##,##Fabric: 25mm Elan DuoTone RD##,##Color: AgateGrey 0987##,##Blind or Recess: Recess size##,##Brackets: Extension L Bracket 20_40 10mm Clearance##,##Bracket 10mm Clearance Color Options: Brown##,##Hardware Colours: Anthracite Grey##,##Motorization: 240V Sonesse 40 RTS Motor,Somfy 12v Tilt and Lift RTS Motor##\",\"oi_onlinereportdescription\":null,\"oi_reporttitles\":\"##Quantity:##Supplier:##Width:##Drop:##Price Chart:##Fabric:##Color:##Blind or Recess:##Brackets:##Bracket 10mm Clearance Color Options:##Hardware Colours:##Motorization:\",\"oi_onlinereporttitles\":null,\"oi_productionformulajsondata\":\"[]\",\"oi_productiondate\":\"2025-06-04 14:02:57\",\"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\":\"97.030\",\"oi_netprice\":\"97.030\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"9.700\",\"oi_vatvalue\":\"10.000\",\"oi_vatselected\":1,\"oi_vattype\":1,\"oi_vatonoff\":1,\"oi_grossprice\":\"106.730\",\"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\":1,\"oi_platformcreatedfrom\":\"web\",\"oi_platformlastupdatedfrom\":\"web\",\"oi_copiedfrom\":0,\"oi_isonlineorder\":0,\"oi_endcustomervatprice\":null,\"oi_endcustomeroverridetype\":1,\"oi_endcustomeroverridevalue\":null,\"oi_endcustomeroverridenetprice\":\"0.000\",\"oi_endcustomeroverridevatprice\":\"0.000\",\"oi_endcustomeroverridegrossprice\":\"0.000\",\"oi_sage_flag\":0,\"oi_supid\":null,\"oi_status\":0,\"oi_createdby\":1,\"oi_createdat\":\"2025-06-04T14:03:47.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":null,\"oi_jsondataid\":\"[6890, 4407, 469, 470, 662, 663, 4386, 661, 665, 4346, 664, 4387, 4398, 4388, 4389, 4461, 4463, 4464, 4390, 4391]\",\"oi_deviceplatform\":2,\"oi_custompricefields\":\"\",\"oi_editransfer\":0,\"oi_apisup_orderid\":0,\"lineitem_id\":null,\"oi_commissionprice\":\"0.000\",\"oi_commissionvatprice\":\"0.000\",\"oi_jsondatabackup\":\"\",\"oi_stockdeduct\":0,\"oi_deductedstockdetails\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "57747", "cl_createdat": "1749046242.000000", "cl_updatedat": null }, { "cl_id": 57748, "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 Awnings", "cl_event": "created", "cl_subjectid": 31348, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 5730, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Supplier\":\" Markilux\",\" System\":\" Markilux 990 deluxe full cassette awning\",\" Color\":\" 301 02 Sunvas\",\" Width\":\" 567\",\" Projection\":\" 899\",\" Operation side\":\" Right Hand Operation\",\" Special Fabrics\":\" Soltis\",\" Special Non Standard Brackets\":\" Face Fixture Incl Spreader Plate A\",\" Frame Colour\":\" Frame Finish In 5204 Anthracite\",\" Control Options\":\" Your Awning Will Be Standard Gear Operated With Winding Handle\",\"Your Awning Will Be Mains Powered With A Radio Controled RTS Motor 433 MHZ\":\"Your Awning Will Be Mains Powered With A Radio Controled RTS Motor 433 MHZ\",\" Frame End Cap Insert and Styling Panel Colour\":\" Metallic Aluminium Ral9006\",\" Fixture Method\":\" Top Fix Bracket Left 71625 Pair\",\"Face Fix Brackets 300mm 70617 Left\":\"Face Fix Brackets 300mm 70617 Left\",\" Extras\":\" RTS Somfy Motor\",\"Upgrade Bionic Tendon Arms\":\"Upgrade Bionic Tendon Arms\"}", "cl_customproperties": "{\"attributes\":{\"oi_id\":31348,\"oi_jobid\":5730,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":5759,\"oi_credit_id\":0,\"oi_productid\":23,\"oi_recipeid\":24,\"oi_ruleid\":0,\"oi_qty\":1,\"oi_seq\":0,\"oi_customseq\":0,\"oi_productcustomseq\":0,\"oi_jsondata\":\"[{\\\"id\\\":6897,\\\"labelname\\\":\\\"Unit Type\\\",\\\"value\\\":2,\\\"valueid\\\":\\\"2\\\",\\\"type\\\":34,\\\"optionid\\\":\\\"2\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":2,\\\"optionname\\\":\\\"mm\\\",\\\"optioncode\\\":\\\"\\\",\\\"optionquantity\\\":1,\\\"unittype\\\":0,\\\"unitcost\\\":0,\\\"pricingtype\\\":0,\\\"fieldoptionlinkid\\\":2,\\\"forchildfieldoptionlinkid\\\":\\\"34_2\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":5163,\\\"labelname\\\":\\\"Quantity\\\",\\\"value\\\":1,\\\"valueid\\\":\\\"\\\",\\\"type\\\":14,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":5164,\\\"labelname\\\":\\\"Supplier\\\",\\\"value\\\":1,\\\"valueid\\\":\\\"\\\",\\\"type\\\":17,\\\"optionid\\\":\\\"1\\\",\\\"optionvalue\\\":[{\\\"id\\\":1,\\\"optionid\\\":1,\\\"optionname\\\":\\\"Markilux\\\",\\\"deleted\\\":0,\\\"optionquantity\\\":1}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":5585,\\\"labelname\\\":\\\"Location\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":29,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":5235,\\\"labelname\\\":\\\"System\\\",\\\"value\\\":1,\\\"valueid\\\":\\\"500\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"1\\\",\\\"optionvalue\\\":[{\\\"id\\\":500,\\\"fieldid\\\":5235,\\\"fieldoptionlinkid\\\":500,\\\"optionid\\\":1,\\\"mainsupplier\\\":1,\\\"blindtypecode\\\":\\\"\\\",\\\"optionname\\\":\\\"Markilux 990 deluxe full cassette awning\\\",\\\"optionquantity\\\":1,\\\"subcount\\\":0,\\\"status\\\":0,\\\"subdatacount\\\":0}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":5578,\\\"labelname\\\":\\\"Color\\\",\\\"value\\\":\\\"301 02 Sunvas\\\",\\\"valueid\\\":\\\"13964\\\",\\\"type\\\":20,\\\"optionid\\\":\\\"13964\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":13964,\\\"optionname\\\":\\\"301 02 Sunvas\\\",\\\"optioncode\\\":\\\"AMC250\\\",\\\"optionquantity\\\":1,\\\"fieldoptionlinkid\\\":13964,\\\"forchildfieldoptionlinkid\\\":\\\"20_3_13964_1\\\",\\\"minimumdiscount\\\":\\\"\\\",\\\"maximumdiscount\\\":\\\"\\\",\\\"optionimage\\\":\\\"\\\",\\\"subdatacount\\\":0,\\\"pricegroup\\\":\\\"Markilux 990 deluxe full cassette awning\\\",\\\"pricegroupid\\\":1}],\\\"fabricorcolor\\\":2,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":5586,\\\"labelname\\\":\\\"Width\\\",\\\"value\\\":\\\"567\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":11,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":5587,\\\"labelname\\\":\\\"Projection\\\",\\\"value\\\":\\\"899\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":12,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":5588,\\\"labelname\\\":\\\"Operation side\\\",\\\"value\\\":\\\"Right Hand Operation\\\",\\\"valueid\\\":\\\"6974\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"1003\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":1003,\\\"optionname\\\":\\\"Right Hand Operation\\\",\\\"optioncode\\\":\\\"RH\\\",\\\"optionqty\\\":1,\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":6974,\\\"forchildfieldoptionlinkid\\\":\\\"3_6974\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":5589,\\\"labelname\\\":\\\"Special Fabrics\\\",\\\"value\\\":\\\"Soltis\\\",\\\"valueid\\\":\\\"7109\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"1504\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":1504,\\\"optionname\\\":\\\"Soltis\\\",\\\"optioncode\\\":\\\"AWM137\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":null,\\\"unitcost\\\":10.51,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":7109,\\\"forchildfieldoptionlinkid\\\":\\\"3_7109\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"10.51\\\",\\\"fieldid\\\":7109}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":5590,\\\"labelname\\\":\\\"Special Non Standard Brackets\\\",\\\"value\\\":\\\"Face Fixture Incl Spreader Plate A\\\",\\\"valueid\\\":\\\"6977\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"1372\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":1372,\\\"optionname\\\":\\\"Face Fixture Incl Spreader Plate A\\\",\\\"optioncode\\\":\\\"AWM03\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":null,\\\"unitcost\\\":228,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":6977,\\\"forchildfieldoptionlinkid\\\":\\\"3_6977\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"228.00\\\",\\\"fieldid\\\":6977}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":5591,\\\"labelname\\\":\\\"Frame Colour\\\",\\\"value\\\":\\\"Frame Finish In 5204 Anthracite\\\",\\\"valueid\\\":\\\"6992\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"1387\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":1387,\\\"optionname\\\":\\\"Frame Finish In 5204 Anthracite\\\",\\\"optioncode\\\":\\\"AWM18\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":null,\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":6992,\\\"forchildfieldoptionlinkid\\\":\\\"3_6992\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":5592,\\\"labelname\\\":\\\"Control Options\\\",\\\"value\\\":\\\"Your Awning Will Be Standard Gear Operated With Winding Handle,Your Awning Will Be Mains Powered With A Radio Controled RTS Motor 433 MHZ\\\",\\\"valueid\\\":\\\"7019,7020\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"1414,1415\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":1414,\\\"optionname\\\":\\\"Your Awning Will Be Standard Gear Operated With Winding Handle\\\",\\\"optioncode\\\":\\\"AWM45\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":null,\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":7019,\\\"forchildfieldoptionlinkid\\\":\\\"3_7019\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"},{\\\"optionid\\\":1415,\\\"optionname\\\":\\\"Your Awning Will Be Mains Powered With A Radio Controled RTS Motor 433 MHZ\\\",\\\"optioncode\\\":\\\"AWM46\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":null,\\\"unitcost\\\":399,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":7020,\\\"forchildfieldoptionlinkid\\\":\\\"3_7020\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"399.00\\\",\\\"fieldid\\\":7020}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1,1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":5595,\\\"labelname\\\":\\\"Frame End Cap Insert and Styling Panel Colour\\\",\\\"value\\\":\\\"Metallic Aluminium Ral9006\\\",\\\"valueid\\\":\\\"7005\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"1400\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":1400,\\\"optionname\\\":\\\"Metallic Aluminium Ral9006\\\",\\\"optioncode\\\":\\\"AWM31\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":null,\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":7005,\\\"forchildfieldoptionlinkid\\\":\\\"3_7005\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":5596,\\\"labelname\\\":\\\"Fixture Method\\\",\\\"value\\\":\\\"Top Fix Bracket Left 71625 Pair,Face Fix Brackets 300mm 70617 Left\\\",\\\"valueid\\\":\\\"7069,7070\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"1464,1465\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":1464,\\\"optionname\\\":\\\"Top Fix Bracket Left 71625 Pair\\\",\\\"optioncode\\\":\\\"AWM97\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":null,\\\"unitcost\\\":68.8,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":7069,\\\"forchildfieldoptionlinkid\\\":\\\"3_7069\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"68.80\\\",\\\"fieldid\\\":7069},{\\\"optionid\\\":1465,\\\"optionname\\\":\\\"Face Fix Brackets 300mm 70617 Left\\\",\\\"optioncode\\\":\\\"AWM98\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":null,\\\"unitcost\\\":58.5,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":7070,\\\"forchildfieldoptionlinkid\\\":\\\"3_7070\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"58.50\\\",\\\"fieldid\\\":7070}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1,1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":5593,\\\"labelname\\\":\\\"Extras\\\",\\\"value\\\":\\\"RTS Somfy Motor,Upgrade Bionic Tendon Arms\\\",\\\"valueid\\\":\\\"7026,7027\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"1422,1421\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":1421,\\\"optionname\\\":\\\"RTS Somfy Motor\\\",\\\"optioncode\\\":\\\"AWM52\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":null,\\\"unitcost\\\":425,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":7026,\\\"forchildfieldoptionlinkid\\\":\\\"3_7026\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"425.00\\\",\\\"fieldid\\\":7026},{\\\"optionid\\\":1422,\\\"optionname\\\":\\\"Upgrade Bionic Tendon Arms\\\",\\\"optioncode\\\":\\\"AWM53\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":null,\\\"unitcost\\\":78,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":7027,\\\"forchildfieldoptionlinkid\\\":\\\"3_7027\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"78.00\\\",\\\"fieldid\\\":7027}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1,1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":5594,\\\"labelname\\\":\\\"Special Instructions\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0}]\",\"oi_description\":\"Supplier: Markilux, System: Markilux 990 deluxe full cassette awning, Color: 301 02 Sunvas, Width: 567, Projection: 899, Operation side: Right Hand Operation, Special Fabrics: Soltis, Special Non Standard Brackets: Face Fixture Incl Spreader Plate A, Frame Colour: Frame Finish In 5204 Anthracite, Control Options: Your Awning Will Be Standard Gear Operated With Winding Handle,Your Awning Will Be Mains Powered With A Radio Controled RTS Motor 433 MHZ, Frame End Cap Insert and Styling Panel Colour: Metallic Aluminium Ral9006, Fixture Method: Top Fix Bracket Left 71625 Pair,Face Fix Brackets 300mm 70617 Left, Extras: RTS Somfy Motor,Upgrade Bionic Tendon Arms\",\"oi_onlinedescription\":null,\"oi_imagepath\":null,\"oi_reportdescription\":\"##Quantity: 1##,##Supplier: Markilux##,##System: Markilux 990 deluxe full cassette awning##,##Color: 301 02 Sunvas##,##Width: 567 mm##,##Projection: 899 mm##,##Operation side: Right Hand Operation##,##Special Fabrics: Soltis##,##Special Non Standard Brackets: Face Fixture Incl Spreader Plate A##,##Frame Colour: Frame Finish In 5204 Anthracite##,##Control Options: Your Awning Will Be Standard Gear Operated With Winding Handle,Your Awning Will Be Mains Powered With A Radio Controled RTS Motor 433 MHZ##,##Frame End Cap Insert and Styling Panel Colour: Metallic Aluminium Ral9006##,##Fixture Method: Top Fix Bracket Left 71625 Pair,Face Fix Brackets 300mm 70617 Left##,##Extras: RTS Somfy Motor,Upgrade Bionic Tendon Arms##\",\"oi_onlinereportdescription\":null,\"oi_reporttitles\":\"##Quantity:##Supplier:##System:##Color:##Width:##Projection:##Operation side:##Special Fabrics:##Special Non Standard Brackets:##Frame Colour:##Control Options:##Frame End Cap Insert and Styling Panel Colour:##Fixture Method:##Extras:\",\"oi_onlinereporttitles\":null,\"oi_productionformulajsondata\":\"[]\",\"oi_productiondate\":\"2025-06-04 14:05:33\",\"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\":\"2142.470\",\"oi_netprice\":\"3017.130\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"301.710\",\"oi_vatvalue\":\"10.000\",\"oi_vatselected\":1,\"oi_vattype\":1,\"oi_vatonoff\":1,\"oi_grossprice\":\"3318.840\",\"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\":1,\"oi_platformcreatedfrom\":\"web\",\"oi_platformlastupdatedfrom\":\"web\",\"oi_copiedfrom\":0,\"oi_isonlineorder\":0,\"oi_endcustomervatprice\":null,\"oi_endcustomeroverridetype\":1,\"oi_endcustomeroverridevalue\":null,\"oi_endcustomeroverridenetprice\":\"0.000\",\"oi_endcustomeroverridevatprice\":\"0.000\",\"oi_endcustomeroverridegrossprice\":\"0.000\",\"oi_sage_flag\":0,\"oi_supid\":null,\"oi_status\":0,\"oi_createdby\":1,\"oi_createdat\":\"2025-06-04T14:06:10.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":null,\"oi_jsondataid\":\"[6897, 5163, 5164, 5585, 5235, 5578, 5586, 5587, 5588, 5589, 5590, 5591, 5592, 5595, 5596, 5593, 5594]\",\"oi_deviceplatform\":2,\"oi_custompricefields\":\"\",\"oi_editransfer\":0,\"oi_apisup_orderid\":0,\"lineitem_id\":null,\"oi_commissionprice\":\"0.000\",\"oi_commissionvatprice\":\"0.000\",\"oi_jsondatabackup\":\"\",\"oi_stockdeduct\":0,\"oi_deductedstockdetails\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "57748", "cl_createdat": "1749046242.000000", "cl_updatedat": null }, { "cl_id": 57749, "cl_logname": "default", "cl_type": null, "cl_modulename": "Alternative Address", "cl_message": "Alternative Address has been updated the fields Appointments Add,Invoice Add,Invoice Delivery Add,Purchase Add,Worksheet Add", "cl_event": "modified", "cl_subjectid": 5586, "cl_subjecttype": "App\\Models\\Job\\bm_deliveryaddresssetting", "cl_parentid": 5729, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Appointments Add\":\"Alternative Delivery Address\",\"Invoice Add\":\"Alternative Delivery Address\",\"Invoice Delivery Add\":\"Alternative Delivery Address\",\"Purchase Add\":\"Default(Same as billing add)\",\"Worksheet Add\":\"Default(Same as billing add)\"}", "cl_customproperties": "{\"attributes\":{\"das_id\":5586,\"das_jobid\":5729,\"das_appointmentaddress\":4219,\"das_invoiceaddress\":4219,\"das_invoicedeliveryaddress\":4219,\"das_purchaseaddress\":0,\"das_worksheetaddress\":0,\"das_createdby\":1,\"das_createdat\":\"2025-06-04T14:10:42.000000Z\",\"das_updatedby\":null,\"das_updatedat\":\"2025-06-04T14:10:42.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "57749", "cl_createdat": "1749046243.000000", "cl_updatedat": null }, { "cl_id": 57750, "cl_logname": "default", "cl_type": null, "cl_modulename": "Alternative Address", "cl_message": "Alternative Address has been updated the fields Appointments Add,Invoice Add,Invoice Delivery Add,Purchase Add,Worksheet Add", "cl_event": "modified", "cl_subjectid": 5587, "cl_subjecttype": "App\\Models\\Job\\bm_deliveryaddresssetting", "cl_parentid": 5730, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Appointments Add\":\"Alternative Delivery Address\",\"Invoice Add\":\"Alternative Delivery Address\",\"Invoice Delivery Add\":\"Alternative Delivery Address\",\"Purchase Add\":\"Default(Same as billing add)\",\"Worksheet Add\":\"Default(Same as billing add)\"}", "cl_customproperties": "{\"attributes\":{\"das_id\":5587,\"das_jobid\":5730,\"das_appointmentaddress\":4220,\"das_invoiceaddress\":4220,\"das_invoicedeliveryaddress\":4220,\"das_purchaseaddress\":0,\"das_worksheetaddress\":0,\"das_createdby\":1,\"das_createdat\":\"2025-06-04T14:10:43.000000Z\",\"das_updatedby\":null,\"das_updatedat\":\"2025-06-04T14:10:43.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "57750", "cl_createdat": "1749046243.000000", "cl_updatedat": null } ], "updated": [], "deleted": [] }, "bm_productInfo": { "created": [], "updated": [], "deleted": [] }, "bm_fields": { "created": [], "updated": [], "deleted": [] }, "bm_fieldOptionLink": { "created": [], "updated": [], "deleted": [] }, "bm_option": { "created": [], "updated": [], "deleted": [] }, "bm_optionproduct": { "created": [], "updated": [], "deleted": [] }, "bm_linkedfieldswithproduct": { "created": [], "updated": [], "deleted": [] }, "bm_productionstatus": { "created": [], "updated": [], "deleted": [] }, "bm_productpricemap": { "created": [], "updated": [], "deleted": [] }, "bm_productrecipe": { "created": [], "updated": [], "deleted": [] }, "bm_productrecipemap": { "created": [], "updated": [], "deleted": [] }, "bm_supproductcode": { "created": [], "updated": [], "deleted": [] }, "bm_rulesetup": { "created": [], "updated": [], "deleted": [] }, "bm_formulas": { "created": [], "updated": [], "deleted": [] }, "bm_customercommission": { "created": [], "updated": [], "deleted": [] }, "bm_productgroupdetails": { "created": [], "updated": [], "deleted": [] }, "bm_productgroupmaterialmap": { "created": [], "updated": [], "deleted": [] }, "bm_productpricedetails": { "created": [], "updated": [], "deleted": [] }, "bm_fabriccolourmap": { "created": [], "updated": [], "deleted": [] }, "bm_fabricdetails": { "created": [], "updated": [], "deleted": [] }, "bm_colordetails": { "created": [], "updated": [], "deleted": [] }, "bm_optiondiscount": { "created": [], "updated": [], "deleted": [] }, "bm_optionpricebook": { "created": [], "updated": [], "deleted": [] }, "bm_allowances": { "created": [], "updated": [], "deleted": [] }, "bm_xyoptionpricedata": { "created": [], "updated": [], "deleted": [] }, "bm_delivery_cost_setup": { "created": [], "updated": [], "deleted": [] }, "bm_organizationdetails": { "created": [], "updated": [], "deleted": [] }, "bm_applicationSetup": { "created": [], "updated": [], "deleted": [] } }, "synctodelete": { "bm_customercontactinfo": { "51749045735": 4219, "51749045880": 4220 }, "bm_customertemplatedata": { "31749045735": 4038, "31749045880": 4039 }, "bm_jobdetails": { "41749045735": 5729, "41749045880": 5730 }, "bm_notelist": { "61749045735": 105230, "61749045736": 105231 }, "bm_jobmultiquote": { "141749045735": 5758, "141749045880": 5759 }, "bm_orderitem": { "71749045827": 31347, "71749045970": 31348 }, "bm_job_paymentlist": { "81749045839": 394, "81749045986": 395 }, "bm_deliveryaddresssetting": { "161749045852": 5586, "161749046013": 5587 } }, "timestamp": 1749046242 }