{ "status": "success", "upcomingorder_list": { "bm_customertemplatedata": { "created": [ { "ctd_id": 4084, "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\": \"QUOT0042\"}", "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": "4084", "ctd_createdat": 1750749136, "ctd_updatedat": 1750749267, "ctd_createdby": 0, "ctd_updatedby": null }, { "ctd_id": 4085, "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\": \"QUOT0043\"}", "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": "4085", "ctd_createdat": 1750749217, "ctd_updatedat": 1750749267, "ctd_createdby": 0, "ctd_updatedby": null } ], "updated": [ { "ctd_id": 4084, "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\": \"QUOT0042\"}", "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": "4084", "ctd_createdat": 1750749136, "ctd_updatedat": 1750749267, "ctd_createdby": 0, "ctd_updatedby": null }, { "ctd_id": 4085, "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\": \"QUOT0043\"}", "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": "4085", "ctd_createdat": 1750749217, "ctd_updatedat": 1750749267, "ctd_createdby": 0, "ctd_updatedby": null } ], "deleted": [] }, "bm_customercontactinfo": { "created": [ { "cci_id": 4271, "cci_customerid": 4084, "cci_templateid": 3, "roleid": 0, "cci_customizedarray": "{\"75\":12,\"79\":\"Quote 43\",\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"Quote 43\",\"90\":36,\"91\":\"Quote 43\"}", "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": 31750749136, "id": "4271", "cci_createdat": 1750749136, "cci_updatedat": 1750749267, "cci_createdby": 0, "cci_updatedby": null }, { "cci_id": 4272, "cci_customerid": 4085, "cci_templateid": 3, "roleid": 0, "cci_customizedarray": "{\"75\":12,\"79\":\"Quote 44\",\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"Quote 44\",\"90\":36,\"91\":\"Quote 44\"}", "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": 31750749217, "id": "4272", "cci_createdat": 1750749217, "cci_updatedat": 1750749268, "cci_createdby": 0, "cci_updatedby": null } ], "updated": [ { "cci_id": 4271, "cci_customerid": 4084, "cci_templateid": 3, "roleid": 0, "cci_customizedarray": "{\"75\":12,\"79\":\"Quote 43\",\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"Quote 43\",\"90\":36,\"91\":\"Quote 43\"}", "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": 31750749136, "id": "4271", "cci_createdat": 1750749136, "cci_updatedat": 1750749267, "cci_createdby": 0, "cci_updatedby": null }, { "cci_id": 4272, "cci_customerid": 4085, "cci_templateid": 3, "roleid": 0, "cci_customizedarray": "{\"75\":12,\"79\":\"Quote 44\",\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"Quote 44\",\"90\":36,\"91\":\"Quote 44\"}", "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": 31750749217, "id": "4272", "cci_createdat": 1750749217, "cci_updatedat": 1750749268, "cci_createdby": 0, "cci_updatedby": null } ], "deleted": [] }, "bm_appointment": { "created": [], "updated": [], "deleted": [] }, "bm_tasklist": { "created": [], "updated": [], "deleted": [] }, "bm_jobdetails": { "created": [ { "jd_id": 5837, "jd_customerid": 4084, "jd_contactid": 4271, "jd_additionalcontacts": "4271", "jd_templateid": 1, "jd_jobmultiquoteid": 5874, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5834", "jd_jobstatus": 6, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "QUOT0042", "jd_invoiceno": "Invoice9687", "jd_listprice": "400.00", "jd_netprice": "470.00", "jd_vat": "47.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": "517.00", "jd_grossprofit": "70.00", "jd_costprice": "400.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "467.00", "jd_totpaid": "50.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": 43, "jd_deliveryvatperc": "10.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5834\",\"35\":\"QUOT0042\",\"36\":6,\"37\":1,\"38\":\"\",\"39\":\"\",\"40\":13,\"41\":1,\"44\":\"\",\"45\":\"\",\"46\":\"Quote 43\",\"47\":\"\",\"48\":\"\",\"49\":\"Quote 43\",\"50\":\"\",\"51\":\"Quote 43\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":12,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"618\":\"5\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "10.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5837", "jd_createddate": 1750723200, "jd_orderdate": 1750723200, "jd_duedate": 1750723200, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1750749136, "jd_updatedat": 1750749268 }, { "jd_id": 5838, "jd_customerid": 4085, "jd_contactid": 4272, "jd_additionalcontacts": "4272", "jd_templateid": 1, "jd_jobmultiquoteid": 5875, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5835", "jd_jobstatus": 6, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "QUOT0043", "jd_invoiceno": "Invoice9688", "jd_listprice": "400.00", "jd_netprice": "470.00", "jd_vat": "47.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": "517.00", "jd_grossprofit": "70.00", "jd_costprice": "400.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "517.00", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": null, "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 1, "jd_updatedby": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 44, "jd_deliveryvatperc": "10.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5835\",\"35\":\"QUOT0043\",\"36\":6,\"37\":1,\"38\":\"\",\"39\":\"\",\"40\":13,\"41\":1,\"44\":\"\",\"45\":\"\",\"46\":\"Quote 44\",\"47\":\"\",\"48\":\"\",\"49\":\"Quote 44\",\"50\":\"\",\"51\":\"Quote 44\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":12,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"618\":\"6\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "10.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5838", "jd_createddate": 1750723200, "jd_orderdate": 1750723200, "jd_duedate": 1750723200, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1750749217, "jd_updatedat": 1750749268 } ], "updated": [ { "jd_id": 5825, "jd_customerid": 4075, "jd_contactid": 4261, "jd_additionalcontacts": "4261", "jd_templateid": 1, "jd_jobmultiquoteid": 5860, "jd_deletedcustokeyvalue": "{\"32\":\"\",\"34\":\"AQ5822\",\"35\":\"QUOT0037\",\"36\":1,\"38\":\"\",\"40\":13,\"countryText\":\"India\",\"adminUser\":1}", "jd_jobref": "AQ5822", "jd_jobstatus": 6, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "QUOT0037", "jd_invoiceno": "", "jd_listprice": "61.60", "jd_netprice": "131.60", "jd_vat": "13.16", "jd_isvaton": 1, "jd_deliverycost": "70.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "144.76", "jd_grossprofit": "131.60", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "144.76", "jd_totpaid": "0.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": 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": 38, "jd_deliveryvatperc": "10.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5822\",\"35\":\"QUOT0037\",\"36\":6,\"37\":1,\"38\":\"\",\"39\":\"\",\"40\":13,\"41\":1,\"44\":\"\",\"45\":\"The\",\"46\":\"Quote 38\",\"47\":\"\",\"48\":\"\",\"49\":\"Quote 38\",\"50\":\"\",\"51\":\"Quote 38\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":12,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"618\":\"5456\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "10.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5825", "jd_createddate": 1750636800, "jd_orderdate": 1750723200, "jd_duedate": 1750723200, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1750662226, "jd_updatedat": 1750748777 }, { "jd_id": 5836, "jd_customerid": 4083, "jd_contactid": 4270, "jd_additionalcontacts": "4270", "jd_templateid": 1, "jd_jobmultiquoteid": 5873, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5833", "jd_jobstatus": 6, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "QUOT0041", "jd_invoiceno": "", "jd_listprice": "400.00", "jd_netprice": "470.00", "jd_vat": "47.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": "517.00", "jd_grossprofit": "70.00", "jd_costprice": "400.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "517.00", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": null, "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 1, "jd_updatedby": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 42, "jd_deliveryvatperc": "10.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5833\",\"35\":\"QUOT0041\",\"36\":6,\"37\":1,\"38\":\"\",\"39\":\"\",\"40\":13,\"41\":1,\"44\":\"\",\"45\":\"\",\"46\":\"Quote 42\",\"47\":\"\",\"48\":\"\",\"49\":\"Quote 42\",\"50\":\"\",\"51\":\"Quote 42\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":12,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"618\":\"66\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "10.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5836", "jd_createddate": 1750723200, "jd_orderdate": 1750723200, "jd_duedate": 1750723200, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1750748548, "jd_updatedat": 1750748843 }, { "jd_id": 5837, "jd_customerid": 4084, "jd_contactid": 4271, "jd_additionalcontacts": "4271", "jd_templateid": 1, "jd_jobmultiquoteid": 5874, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5834", "jd_jobstatus": 6, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "QUOT0042", "jd_invoiceno": "Invoice9687", "jd_listprice": "400.00", "jd_netprice": "470.00", "jd_vat": "47.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": "517.00", "jd_grossprofit": "70.00", "jd_costprice": "400.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "467.00", "jd_totpaid": "50.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": 43, "jd_deliveryvatperc": "10.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5834\",\"35\":\"QUOT0042\",\"36\":6,\"37\":1,\"38\":\"\",\"39\":\"\",\"40\":13,\"41\":1,\"44\":\"\",\"45\":\"\",\"46\":\"Quote 43\",\"47\":\"\",\"48\":\"\",\"49\":\"Quote 43\",\"50\":\"\",\"51\":\"Quote 43\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":12,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"618\":\"5\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "10.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5837", "jd_createddate": 1750723200, "jd_orderdate": 1750723200, "jd_duedate": 1750723200, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1750749136, "jd_updatedat": 1750749268 }, { "jd_id": 5838, "jd_customerid": 4085, "jd_contactid": 4272, "jd_additionalcontacts": "4272", "jd_templateid": 1, "jd_jobmultiquoteid": 5875, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5835", "jd_jobstatus": 6, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "QUOT0043", "jd_invoiceno": "Invoice9688", "jd_listprice": "400.00", "jd_netprice": "470.00", "jd_vat": "47.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": "517.00", "jd_grossprofit": "70.00", "jd_costprice": "400.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "517.00", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": null, "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 1, "jd_updatedby": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 44, "jd_deliveryvatperc": "10.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5835\",\"35\":\"QUOT0043\",\"36\":6,\"37\":1,\"38\":\"\",\"39\":\"\",\"40\":13,\"41\":1,\"44\":\"\",\"45\":\"\",\"46\":\"Quote 44\",\"47\":\"\",\"48\":\"\",\"49\":\"Quote 44\",\"50\":\"\",\"51\":\"Quote 44\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":12,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"618\":\"6\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "10.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5838", "jd_createddate": 1750723200, "jd_orderdate": 1750723200, "jd_duedate": 1750723200, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1750749217, "jd_updatedat": 1750749268 } ], "deleted": [] }, "bm_orderitem": { "created": [ { "oi_id": 31667, "oi_jobid": 5835, "oi_jobtempid": "0", "oi_jobmultiquoteid": 5872, "oi_productid": 9, "oi_recipeid": 9, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":6887,\"labelname\":\"Unit Type\",\"value\":2,\"valueid\":\"2\",\"type\":34,\"optionid\":2,\"optionvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"issubfabric\":0,\"labelnamecode\":\"Unit Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":34,\"mandatory\":0,\"fieldname\":\"Unit Type\",\"fieldid\":6887,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":2,\"optionsvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"editruleoverride\":0},{\"id\":319,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":null,\"type\":14,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Quantity\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":14,\"mandatory\":0,\"fieldname\":\"Quantity\",\"fieldid\":319,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":320,\"labelname\":\"Supplier\",\"value\":\"11\",\"valueid\":null,\"type\":17,\"optionid\":\"11\",\"optionvalue\":[{\"id\":1,\"optionid\":1,\"optionname\":\"Markilux\",\"deleted\":0,\"optionquantity\":1},{\"id\":11,\"optionid\":11,\"optionname\":\"Arena\",\"deleted\":0,\"optionquantity\":1}],\"issubfabric\":0,\"labelnamecode\":\"Supplier\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":17,\"mandatory\":0,\"fieldname\":\"Supplier\",\"fieldid\":320,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"11\",\"optionsvalue\":[{\"id\":1,\"optionid\":1,\"optionname\":\"Markilux\",\"deleted\":0,\"optionquantity\":1},{\"id\":11,\"optionid\":11,\"optionname\":\"Arena\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":1},{\"id\":322,\"labelname\":\"Room\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Room\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Room\",\"fieldid\":322,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":323,\"labelname\":\"Width\",\"value\":\"1000\",\"valueid\":null,\"type\":11,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Width\",\"fabricorcolor\":0,\"widthfraction\":\"0_mm_3_0\",\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":11,\"mandatory\":0,\"fieldname\":\"Width\",\"fieldid\":323,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":324,\"labelname\":\"Drop\",\"value\":\"1000\",\"valueid\":null,\"type\":12,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Drop\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":\"0_mm_3_0\",\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":12,\"mandatory\":0,\"fieldname\":\"Drop\",\"fieldid\":324,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":321,\"labelname\":\"Product Type\",\"value\":\"508\",\"valueid\":\"865\",\"type\":13,\"optionid\":\"508\",\"optionvalue\":[{\"id\":865,\"fieldid\":321,\"fieldoptionlinkid\":865,\"optionid\":508,\"mainsupplier\":\"11\",\"blindtypecode\":null,\"optionname\":\"yrtd mh 111\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"issubfabric\":0,\"labelnamecode\":\"Product Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":13,\"mandatory\":0,\"fieldname\":\"Product Type\",\"fieldid\":321,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"508\",\"optionsvalue\":[{\"id\":865,\"fieldid\":321,\"fieldoptionlinkid\":865,\"optionid\":508,\"mainsupplier\":\"11\",\"blindtypecode\":null,\"optionname\":\"yrtd mh 111\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"editruleoverride\":1},{\"id\":355,\"labelname\":\"Fabric\",\"value\":null,\"valueid\":null,\"type\":5,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fabric\",\"fabricorcolor\":1,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":5,\"mandatory\":0,\"fieldname\":\"Fabric\",\"fieldid\":355,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":325,\"labelname\":\"Vision Panel Size\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Vision Panel Size\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Vision Panel Size\",\"fieldid\":325,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":326,\"labelname\":\"Measure To\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Measure To\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Measure To\",\"fieldid\":326,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":327,\"labelname\":\"Controls\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Controls\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Controls\",\"fieldid\":327,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":328,\"labelname\":\"Brackets\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Brackets\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Brackets\",\"fieldid\":328,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":329,\"labelname\":\"Chain Colour\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Chain Colour\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Chain Colour\",\"fieldid\":329,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":330,\"labelname\":\"Roll\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Roll\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Roll\",\"fieldid\":330,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":331,\"labelname\":\"System Type\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"System Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"System Type\",\"fieldid\":331,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":332,\"labelname\":\"Tube Size\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Tube Size\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Tube Size\",\"fieldid\":332,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":335,\"labelname\":\"Control Type\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Control Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Control Type\",\"fieldid\":335,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":333,\"labelname\":\"Motorisation\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Motorisation\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Motorisation\",\"fieldid\":333,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":336,\"labelname\":\"Fixing\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fixing\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Fixing\",\"fieldid\":336,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":337,\"labelname\":\"Extras\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Extras\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Extras\",\"fieldid\":337,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7270,\"labelname\":\"Product Type\",\"value\":null,\"valueid\":null,\"type\":13,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Product TypeDual\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":13,\"mandatory\":0,\"fieldname\":\"Product Type\",\"fieldid\":7270,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7269,\"labelname\":\"Dual\",\"value\":null,\"valueid\":null,\"type\":5,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Dual\",\"fabricorcolor\":1,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":5,\"mandatory\":0,\"fieldname\":\"Dual\",\"fieldid\":7269,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Supplier: Arena, Width: 1000, Drop: 1000, Product Type: yrtd mh 111", "oi_reportdescription": "##Quantity: 1##,##Supplier: Arena##,##Width: 1000 mm##,##Drop: 1000 mm##,##Product Type: yrtd mh 111##", "oi_reporttitles": "##Quantity:<\/br>##Supplier:<\/br>##Width:<\/br>##Drop:<\/br>##Product Type:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":null,\"value\":\"-\",\"formula\":null,\"price\":null,\"recipeid\":null,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":null,\"fieldtype_id\":0,\"fractionvalue\":null}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[{\"link_id\":4,\"process_id\":4,\"product_id\":9,\"phc_id\":4,\"pd_id\":4,\"name\":\"Tube cut\",\"phc_linkstations\":4,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"10.00\",\"phc_contractsellingprice\":\"10.00\",\"phc_tradesellingprice\":\"10.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"10.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"10.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"10.00\",\"price\":\"0.00\"},{\"link_id\":1,\"process_id\":1,\"product_id\":9,\"phc_id\":1,\"pd_id\":1,\"name\":\"Office Check\",\"phc_linkstations\":1,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"10.00\",\"phc_contractsellingprice\":\"10.00\",\"phc_tradesellingprice\":\"10.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"10.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"10.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"10.00\",\"price\":\"0.00\"},{\"link_id\":5,\"process_id\":5,\"product_id\":9,\"phc_id\":5,\"pd_id\":5,\"name\":\"Assemble\",\"phc_linkstations\":5,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"15.00\",\"phc_contractsellingprice\":\"15.00\",\"phc_tradesellingprice\":\"15.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"15.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"15.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"15.00\",\"price\":\"0.00\"},{\"link_id\":2,\"process_id\":2,\"product_id\":9,\"phc_id\":2,\"pd_id\":2,\"name\":\"Stock Pick\",\"phc_linkstations\":2,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"10.00\",\"phc_contractsellingprice\":\"10.00\",\"phc_tradesellingprice\":\"10.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"10.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"10.00\",\"Hour\\\/mins\":\"10 mins\",\"phc_processcostid\":1,\"markupprice\":\"10.00\",\"price\":\"0.00\"},{\"link_id\":3,\"process_id\":3,\"product_id\":9,\"phc_id\":3,\"pd_id\":3,\"name\":\"Fabric cut\",\"phc_linkstations\":3,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"10.00\",\"phc_contractsellingprice\":\"10.00\",\"phc_tradesellingprice\":\"10.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"10.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"10.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"10.00\",\"price\":\"0.00\"}]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"55.00\",\"cost_with_discount\":\"55.00\",\"cost_with_markup\":\"55.00\",\"gross_price\":\"60.50\",\"vat_price\":\"5.50\"}", "oi_pricecomesfrom_calculations": "{\"label\":\"Price table cost\",\"unit_type\":\"-\",\"cost_price\":\"36.00\",\"show_hide\":true,\"category\":3}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "91.000", "oi_netprice": "81.000", "oi_pricesfromoperations": null, "oi_vatprice": "8.100", "oi_vatvalue": "10.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "89.100", "oi_overrideprice": "0.000", "oi_overridetype": 1, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "81.000", "oi_endcustomeroverridevatprice": "8.100", "oi_endcustomeroverridegrossprice": "89.100", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[6887, 319, 320, 322, 323, 324, 321, 355, 325, 326, 327, 328, 329, 330, 331, 332, 335, 333, 336, 337, 7270, 7269]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "31667", "oi_productiondate": 1750767043, "oi_createdat": 1750767043, "oi_updatedat": 1750747361, "oi_createdby": 15, "oi_updatedby": null }, { "oi_id": 31670, "oi_jobid": 5837, "oi_jobtempid": "0", "oi_jobmultiquoteid": 5874, "oi_productid": 9, "oi_recipeid": 9, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 1, "oi_customseq": 0, "oi_productcustomseq": 0, "oi_jsondata": "[{\"id\":6887,\"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\":319,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":320,\"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\":322,\"labelname\":\"Room\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":323,\"labelname\":\"Width\",\"value\":\"125\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":324,\"labelname\":\"Drop\",\"value\":\"125\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":321,\"labelname\":\"Product Type\",\"value\":474,\"valueid\":\"621\",\"type\":13,\"optionid\":\"474\",\"optionvalue\":[{\"id\":621,\"fieldid\":321,\"fieldoptionlinkid\":621,\"optionid\":474,\"mainsupplier\":1,\"blindtypecode\":\"101\",\"optionname\":\"band z\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":355,\"labelname\":\"Fabric\",\"value\":\"127mm _ Banlight Duo RD FR\",\"valueid\":\"4868\",\"type\":5,\"optionid\":\"4868\",\"optionvalue\":[{\"optionid\":4868,\"optionname\":\"127mm _ Banlight Duo RD FR\",\"optioncode\":\"VEF95\",\"optionquantity\":1,\"fieldoptionlinkid\":4868,\"forchildfieldoptionlinkid\":\"5_2_4868_1\",\"optionimage\":\"\",\"subdatacount\":1,\"pricegroup\":\"band z\",\"pricegroupid\":474}],\"fabricorcolor\":1,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":8291,\"labelname\":\"Color\",\"value\":\"\",\"valueid\":\"\",\"type\":5,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":325,\"labelname\":\"Vision Panel Size\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":326,\"labelname\":\"Measure To\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":327,\"labelname\":\"Controls\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":328,\"labelname\":\"Brackets\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":329,\"labelname\":\"Chain Colour\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":330,\"labelname\":\"Roll\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":331,\"labelname\":\"System Type\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":332,\"labelname\":\"Tube Size\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":335,\"labelname\":\"Control Type\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":333,\"labelname\":\"Motorisation\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":336,\"labelname\":\"Fixing\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":337,\"labelname\":\"Extras\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":7270,\"labelname\":\"Product Type\",\"value\":\"\",\"valueid\":\"\",\"type\":13,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":7269,\"labelname\":\"Dual\",\"value\":\"\",\"valueid\":\"\",\"type\":5,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":1,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]", "oi_description": "Supplier: Markilux, Width: 125, Drop: 125, Product Type: band z, Fabric: 127mm _ Banlight Duo RD FR", "oi_reportdescription": "##Quantity: 1##,##Supplier: Markilux##,##Width: 125 mm##,##Drop: 125 mm##,##Product Type: band z##,##Fabric: 127mm _ Banlight Duo RD FR##", "oi_reporttitles": "##Quantity:##Supplier:##Width:##Drop:##Product Type:##Fabric:", "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": "400.000", "oi_netprice": "400.000", "oi_pricesfromoperations": null, "oi_vatprice": "40.000", "oi_vatvalue": "10.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "440.000", "oi_overrideprice": "0.000", "oi_overridetype": 1, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 31668, "oi_isonlineorder": 0, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "400.000", "oi_endcustomeroverridevatprice": "40.000", "oi_endcustomeroverridegrossprice": "440.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[6887, 319, 320, 322, 323, 324, 321, 355, 8291, 325, 326, 327, 328, 329, 330, 331, 332, 335, 333, 336, 337, 7270, 7269]", "oi_deviceplatform": 2, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "31670", "oi_productiondate": 1750748587, "oi_createdat": 1750749141, "oi_updatedat": 1750749268, "oi_createdby": 1, "oi_updatedby": null }, { "oi_id": 31671, "oi_jobid": 5838, "oi_jobtempid": "0", "oi_jobmultiquoteid": 5875, "oi_productid": 9, "oi_recipeid": 9, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 1, "oi_customseq": 0, "oi_productcustomseq": 0, "oi_jsondata": "[{\"id\":6887,\"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\":319,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":320,\"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\":322,\"labelname\":\"Room\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":323,\"labelname\":\"Width\",\"value\":\"125\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":324,\"labelname\":\"Drop\",\"value\":\"125\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":321,\"labelname\":\"Product Type\",\"value\":474,\"valueid\":\"621\",\"type\":13,\"optionid\":\"474\",\"optionvalue\":[{\"id\":621,\"fieldid\":321,\"fieldoptionlinkid\":621,\"optionid\":474,\"mainsupplier\":1,\"blindtypecode\":\"101\",\"optionname\":\"band z\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":355,\"labelname\":\"Fabric\",\"value\":\"127mm _ Banlight Duo RD FR\",\"valueid\":\"4868\",\"type\":5,\"optionid\":\"4868\",\"optionvalue\":[{\"optionid\":4868,\"optionname\":\"127mm _ Banlight Duo RD FR\",\"optioncode\":\"VEF95\",\"optionquantity\":1,\"fieldoptionlinkid\":4868,\"forchildfieldoptionlinkid\":\"5_2_4868_1\",\"optionimage\":\"\",\"subdatacount\":1,\"pricegroup\":\"band z\",\"pricegroupid\":474}],\"fabricorcolor\":1,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":8291,\"labelname\":\"Color\",\"value\":\"\",\"valueid\":\"\",\"type\":5,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":325,\"labelname\":\"Vision Panel Size\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":326,\"labelname\":\"Measure To\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":327,\"labelname\":\"Controls\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":328,\"labelname\":\"Brackets\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":329,\"labelname\":\"Chain Colour\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":330,\"labelname\":\"Roll\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":331,\"labelname\":\"System Type\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":332,\"labelname\":\"Tube Size\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":335,\"labelname\":\"Control Type\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":333,\"labelname\":\"Motorisation\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":336,\"labelname\":\"Fixing\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":337,\"labelname\":\"Extras\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":7270,\"labelname\":\"Product Type\",\"value\":\"\",\"valueid\":\"\",\"type\":13,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":7269,\"labelname\":\"Dual\",\"value\":\"\",\"valueid\":\"\",\"type\":5,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":1,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]", "oi_description": "Supplier: Markilux, Width: 125, Drop: 125, Product Type: band z, Fabric: 127mm _ Banlight Duo RD FR", "oi_reportdescription": "##Quantity: 1##,##Supplier: Markilux##,##Width: 125 mm##,##Drop: 125 mm##,##Product Type: band z##,##Fabric: 127mm _ Banlight Duo RD FR##", "oi_reporttitles": "##Quantity:##Supplier:##Width:##Drop:##Product Type:##Fabric:", "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": "400.000", "oi_netprice": "400.000", "oi_pricesfromoperations": null, "oi_vatprice": "40.000", "oi_vatvalue": "10.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "440.000", "oi_overrideprice": "0.000", "oi_overridetype": 1, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 31668, "oi_isonlineorder": 0, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "400.000", "oi_endcustomeroverridevatprice": "40.000", "oi_endcustomeroverridegrossprice": "440.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[6887, 319, 320, 322, 323, 324, 321, 355, 8291, 325, 326, 327, 328, 329, 330, 331, 332, 335, 333, 336, 337, 7270, 7269]", "oi_deviceplatform": 2, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "31671", "oi_productiondate": 1750748587, "oi_createdat": 1750749222, "oi_updatedat": 1750749268, "oi_createdby": 1, "oi_updatedby": null } ], "updated": [], "deleted": [] }, "bm_paymentlist": { "created": [ { "pl_id": 4089, "pl_orderid": null, "pl_invoice_id": 2627, "pl_customer_id": 4084, "pl_overpayment_id": 0, "pl_jobpayment_id": 2147483647, "pl_amount": "50.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": "500.00", "pl_userid": "1", "pl_decription": null, "pl_paymentinvoice": null, "pl_paymentstatus": 0, "pl_seq": 0, "pl_status": 0, "pl_refundtype": null, "pl_deviceplatform": 2, "id": "4089", "pl_paiddate": 1750723200, "created_at": 1750749199, "updated_at": null, "created_by": 1, "updated_by": null } ], "updated": [], "deleted": [] }, "bm_notelist": { "created": [ { "nl_id": 105355, "nl_ordertempid": null, "nl_orderid": 5825, "nl_notescategory": 1, "nl_type": 26, "nl_platform": 3, "nl_desc": "Invoice Deleted (Invoice9686)", "nl_manualNotes": "", "nl_createdby": "1", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 1, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "105355", "nl_endddate": 1750723200, "nl_starttime": 1750784777, "created_at": 1750748777, "updated_at": 1750748777, "created_by": 1, "updated_by": null }, { "nl_id": 105356, "nl_ordertempid": null, "nl_orderid": 5836, "nl_notescategory": 1, "nl_type": 26, "nl_platform": 3, "nl_desc": "Invoice Deleted (Invoice9685)", "nl_manualNotes": "", "nl_createdby": "11", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 1, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "105356", "nl_endddate": 1750723200, "nl_starttime": 1750784843, "created_at": 1750748843, "updated_at": 1750748843, "created_by": 11, "updated_by": null }, { "nl_id": 105357, "nl_ordertempid": 0, "nl_orderid": 5837, "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": "105357", "nl_endddate": 1750723200, "nl_starttime": 1750749136, "created_at": 1750749136, "updated_at": 1750749268, "created_by": 1, "updated_by": null }, { "nl_id": 105358, "nl_ordertempid": 0, "nl_orderid": 5837, "nl_notescategory": 1, "nl_type": 26, "nl_platform": 2, "nl_desc": "Invoice Created (Invoice9687)", "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": "105358", "nl_endddate": 1750723200, "nl_starttime": 1750749199, "created_at": 1750749199, "updated_at": 1750749268, "created_by": 1, "updated_by": null }, { "nl_id": 105359, "nl_ordertempid": 0, "nl_orderid": 5837, "nl_notescategory": 1, "nl_type": 26, "nl_platform": 2, "nl_desc": "payment added against invoice no ('Invoice9687') amount ('50')", "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": "105359", "nl_endddate": 1750723200, "nl_starttime": 1750749199, "created_at": 1750749199, "updated_at": 1750749268, "created_by": 1, "updated_by": null }, { "nl_id": 105360, "nl_ordertempid": 0, "nl_orderid": 5838, "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": "105360", "nl_endddate": 1750723200, "nl_starttime": 1750749217, "created_at": 1750749217, "updated_at": 1750749268, "created_by": 1, "updated_by": null }, { "nl_id": 105361, "nl_ordertempid": 0, "nl_orderid": 5838, "nl_notescategory": 1, "nl_type": 26, "nl_platform": 2, "nl_desc": "Invoice Created (Invoice9688)", "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": "105361", "nl_endddate": 1750723200, "nl_starttime": 1750749242, "created_at": 1750749242, "updated_at": 1750749268, "created_by": 1, "updated_by": null }, { "nl_id": 105362, "nl_ordertempid": 0, "nl_orderid": 5838, "nl_notescategory": 1, "nl_type": 26, "nl_platform": 2, "nl_desc": "payment added against invoice no ('Invoice9688') amount ('50')", "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": "105362", "nl_endddate": 1750723200, "nl_starttime": 1750749249, "created_at": 1750749249, "updated_at": 1750749268, "created_by": 1, "updated_by": null }, { "nl_id": 105363, "nl_ordertempid": 0, "nl_orderid": 5838, "nl_notescategory": 1, "nl_type": 26, "nl_platform": 2, "nl_desc": "Payment deleted for this invoice ('Invoice9688') amount ('50')", "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": "105363", "nl_endddate": 1750723200, "nl_starttime": 1750749253, "created_at": 1750749253, "updated_at": 1750749268, "created_by": 1, "updated_by": null } ], "updated": [], "deleted": [] }, "bm_deliveryaddresssetting": { "created": [ { "das_id": 5684, "das_jobid": 5836, "das_appointmentaddress": 4270, "das_invoiceaddress": 4270, "das_invoicedeliveryaddress": 4270, "das_purchaseaddress": 0, "das_worksheetaddress": 0, "id": "5684", "das_createdat": 1750748699, "das_updatedat": 1750748699, "das_createdby": 1, "das_updatedby": null }, { "das_id": 5685, "das_jobid": 5837, "das_appointmentaddress": 4271, "das_invoiceaddress": 4271, "das_invoicedeliveryaddress": 4271, "das_purchaseaddress": 0, "das_worksheetaddress": 0, "id": "5685", "das_createdat": 1750749269, "das_updatedat": 1750749269, "das_createdby": 1, "das_updatedby": null }, { "das_id": 5686, "das_jobid": 5838, "das_appointmentaddress": 4272, "das_invoiceaddress": 4272, "das_invoicedeliveryaddress": 4272, "das_purchaseaddress": 0, "das_worksheetaddress": 0, "id": "5686", "das_createdat": 1750749269, "das_updatedat": 1750749269, "das_createdby": 1, "das_updatedby": null } ], "updated": [], "deleted": [] }, "bm_jobchecklist": { "created": [], "updated": [], "deleted": [] }, "bm_Invoice": { "created": [ { "invoice_id": 2627, "job_id": 5837, "customer_id": 4084, "ref_no": "Invoice9687", "invoice_type": 1, "invoice_split_type": 0, "invoice_split_cal": 0, "invoice_split_cal_value": null, "net_amount": "470.000", "vat_amount": "47.000", "gross_amount": "517.000", "delivery_amount": "70.000", "delivery": 0, "commission_amount": "0.000", "commission": 0, "total_amount": "517.000", "split_net_amount": null, "split_vat_amount": null, "outstanding_amount": "467.000", "paid_amount": "50.000", "paid_status": 2, "status": 0, "transfer": 0, "transfer_id": null, "id": "2627", "paymentDueDate": 1750723200, "invoiceDate": 1750723200, "transferDate": null, "createdat": 1750749199, "updatedat": 1750749268, "createdby": 1, "updatedby": null }, { "invoice_id": 2628, "job_id": 5838, "customer_id": 4085, "ref_no": "Invoice9688", "invoice_type": 1, "invoice_split_type": 0, "invoice_split_cal": 0, "invoice_split_cal_value": null, "net_amount": "470.000", "vat_amount": "47.000", "gross_amount": "517.000", "delivery_amount": "70.000", "delivery": 0, "commission_amount": "0.000", "commission": 0, "total_amount": "517.000", "split_net_amount": null, "split_vat_amount": null, "outstanding_amount": "517.000", "paid_amount": "0.000", "paid_status": 1, "status": 0, "transfer": 0, "transfer_id": null, "id": "2628", "paymentDueDate": 1750723200, "invoiceDate": 1750723200, "transferDate": null, "createdat": 1750749242, "updatedat": 1750749268, "createdby": 1, "updatedby": null } ], "updated": [], "deleted": [ "2625", "2626" ] }, "bm_InvoiceDetails": { "created": [ { "ind_id": 15413, "ind_invoice_id": 2627, "ind_order_id": 31670, "ind_qty": 1, "ind_net_amount": "400.000", "ind_vat_amount": "40.000", "ind_gross_amount": "440.000", "ind_status": 0, "id": "15413", "ind_createdat": 1750749199, "ind_updatedat": 1750749199, "ind_createdby": 1, "ind_updatedby": null }, { "ind_id": 15414, "ind_invoice_id": 2628, "ind_order_id": 31671, "ind_qty": 1, "ind_net_amount": "400.000", "ind_vat_amount": "40.000", "ind_gross_amount": "440.000", "ind_status": 0, "id": "15414", "ind_createdat": 1750749242, "ind_updatedat": 1750749242, "ind_createdby": 1, "ind_updatedby": null } ], "updated": [], "deleted": [ "15411", "15412" ] }, "bm_invoice_credit_note": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNote": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNoteDetails": { "created": [], "updated": [], "deleted": [] }, "bm_job_paymentlist": { "created": [ { "jp_id": 411, "jp_job_id": 5837, "jp_amount": "50.000", "jp_amountoutstanding": "0.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": "50.000", "jp_userid": 1, "jp_decription": "", "jp_deviceplatform": 2, "jp_status": 0, "jp_transfer": 0, "jp_transfer_id": null, "id": "411", "jp_paiddate": 1750723200, "jp_createdat": 1750749161, "jp_updatedat": 1750749269, "jp_createdby": 1, "jp_updatedby": null } ], "updated": [], "deleted": [] }, "bm_OverPayment": { "created": [], "updated": [], "deleted": [] }, "bm_terms": { "created": [], "updated": [], "deleted": [] }, "bm_jobmultiquote": { "created": [ { "jmq_id": 5874, "jmq_jobid": 5837, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "400.00", "jmq_netprice": "470.00", "jmq_vat": "47.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": "517.00", "jmq_grossprofit": "70.00", "jmq_costprice": "400.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "467.00", "jmq_totpaid": "50.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": "5874", "jmq_duedate": 1750723200, "jmq_sceduleddate": null, "jmq_createdat": "1750749136.000000", "jmq_updatedat": "1750749268.000000", "jmq_createdby": 1, "jmq_updatedby": 1 }, { "jmq_id": 5875, "jmq_jobid": 5838, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "400.00", "jmq_netprice": "470.00", "jmq_vat": "47.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": "517.00", "jmq_grossprofit": "70.00", "jmq_costprice": "400.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "517.00", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": null, "jmq_deliverycostid": 0, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 0, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 0, "jmq_endcustomeroverridevalue": null, "jmq_endcustomeroverridenetprice": "0.00", "jmq_endcustomeroverridevatprice": "0.00", "jmq_endcustomeroverridegrossprice": "0.00", "jmq_endcustomerdeliverycost": null, "jmq_endcustomerdeliverycostinclvat": 0, "jmq_endcustomerfittingcost": null, "jmq_endcustomerfittingcostinclvat": 0, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "10.000", "jmq_cdeliveryvatperc": "10.000", "id": "5875", "jmq_duedate": 1750723200, "jmq_sceduleddate": null, "jmq_createdat": "1750749217.000000", "jmq_updatedat": "1750749268.000000", "jmq_createdby": 1, "jmq_updatedby": 1 } ], "updated": [ { "jmq_id": 5860, "jmq_jobid": 5825, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "61.60", "jmq_netprice": "131.60", "jmq_vat": "13.16", "jmq_isvaton": 1, "jmq_deliverycost": "70.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 1, "jmq_orderformprice": "0.00", "jmq_editpricebyid": 0, "jmq_isroundon": 0, "jmq_grossprice": "144.76", "jmq_grossprofit": "0.00", "jmq_costprice": "0.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "144.76", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": "\"\"", "jmq_deliverycostid": 0, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 1, "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": 0, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "10.000", "jmq_cdeliveryvatperc": "10.000", "id": "5860", "jmq_duedate": 1750723200, "jmq_sceduleddate": null, "jmq_createdat": "0.000000", "jmq_updatedat": "1750748699.000000", "jmq_createdby": 1, "jmq_updatedby": 1 }, { "jmq_id": 5873, "jmq_jobid": 5836, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "400.00", "jmq_netprice": "470.00", "jmq_vat": "47.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": "517.00", "jmq_grossprofit": "70.00", "jmq_costprice": "400.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "517.00", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": null, "jmq_deliverycostid": 0, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 0, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 0, "jmq_endcustomeroverridevalue": null, "jmq_endcustomeroverridenetprice": "0.00", "jmq_endcustomeroverridevatprice": "0.00", "jmq_endcustomeroverridegrossprice": "0.00", "jmq_endcustomerdeliverycost": null, "jmq_endcustomerdeliverycostinclvat": 0, "jmq_endcustomerfittingcost": null, "jmq_endcustomerfittingcostinclvat": 0, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "10.000", "jmq_cdeliveryvatperc": "10.000", "id": "5873", "jmq_duedate": 1750723200, "jmq_sceduleddate": null, "jmq_createdat": "1750748548.000000", "jmq_updatedat": "1750748699.000000", "jmq_createdby": 1, "jmq_updatedby": 1 }, { "jmq_id": 5874, "jmq_jobid": 5837, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "400.00", "jmq_netprice": "470.00", "jmq_vat": "47.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": "517.00", "jmq_grossprofit": "70.00", "jmq_costprice": "400.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "467.00", "jmq_totpaid": "50.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": "5874", "jmq_duedate": 1750723200, "jmq_sceduleddate": null, "jmq_createdat": "1750749136.000000", "jmq_updatedat": "1750749268.000000", "jmq_createdby": 1, "jmq_updatedby": 1 }, { "jmq_id": 5875, "jmq_jobid": 5838, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "400.00", "jmq_netprice": "470.00", "jmq_vat": "47.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": "517.00", "jmq_grossprofit": "70.00", "jmq_costprice": "400.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "517.00", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": null, "jmq_deliverycostid": 0, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 0, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 0, "jmq_endcustomeroverridevalue": null, "jmq_endcustomeroverridenetprice": "0.00", "jmq_endcustomeroverridevatprice": "0.00", "jmq_endcustomeroverridegrossprice": "0.00", "jmq_endcustomerdeliverycost": null, "jmq_endcustomerdeliverycostinclvat": 0, "jmq_endcustomerfittingcost": null, "jmq_endcustomerfittingcostinclvat": 0, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "10.000", "jmq_cdeliveryvatperc": "10.000", "id": "5875", "jmq_duedate": 1750723200, "jmq_sceduleddate": null, "jmq_createdat": "1750749217.000000", "jmq_updatedat": "1750749268.000000", "jmq_createdby": 1, "jmq_updatedby": 1 } ], "deleted": [] }, "bm_jobstatus_tracks": { "created": [ { "jst_id": 6560, "jst_jobid": 5836, "jst_job_current_status": 6, "id": "6560", "jst_createdat": "1750748699.319707" }, { "jst_id": 6561, "jst_jobid": 5837, "jst_job_current_status": 6, "id": "6561", "jst_createdat": "1750749267.999568" }, { "jst_id": 6562, "jst_jobid": 5838, "jst_job_current_status": 6, "id": "6562", "jst_createdat": "1750749268.145329" } ], "updated": [], "deleted": [] }, "bm_customindividuallogs": { "created": [ { "cl_id": 60360, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 5836, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5836, "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\",\"Last Name\":\"Quote 42\",\"Address1\":\"Quote 42\",\"Town \\\/ City\":\"Quote 42\",\"Country\":\"India\",\"Salutation\":\"Dr\",\"Assigned to\":1,\"Number\":\"66\",\"Additional Contacts\":\"4270\",\"Order Date\":\"2025-06-24\",\"Production Due Date\":\"2025-06-24\",\"Job Ref No\":\"AQ5833\",\"Job Status\":\"Invoiced\",\"Order Status\":\"Enquiry\",\"Net Price\":\"470.00\",\"VAT Price\":\"47.00\",\"VAT\":\"Enabled\",\"DeliveryCost\":\"70.00\",\"Delivery Cost\":\"All Options\",\"Gross Price Amount\":\"517.00\",\"Gross Profit\":\"70.00\",\"Total CostPrice\":\"400.00\",\"Amount Outstanding\":\"517.00\",\"jd_isonlineorder\":1,\"jd_quickquote\":42,\"Delivery Vat Percentage\":\"10.000\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\",\"Job Rework Enable\":\"On\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":5836,\"jd_customerid\":4083,\"jd_contactid\":4270,\"jd_additionalcontacts\":\"4270\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"AQ5833\\\",\\\"35\\\":\\\"QUOT0041\\\",\\\"36\\\":6,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":\\\"\\\",\\\"40\\\":13,\\\"41\\\":1,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"\\\",\\\"46\\\":\\\"Quote 42\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"Quote 42\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"Quote 42\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":36,\\\"285\\\":12,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":1,\\\"558\\\":\\\"\\\",\\\"559\\\":1,\\\"610\\\":\\\"\\\",\\\"611\\\":\\\"\\\",\\\"612\\\":1,\\\"618\\\":\\\"66\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-06-24\",\"jd_orderdate\":\"2025-06-24\",\"jd_duedate\":\"2025-06-24\",\"jd_sceduleddate\":null,\"jd_invoicedate\":\"0000-00-00\",\"jd_completeddate\":null,\"jd_jobref\":\"AQ5833\",\"jd_jobstatus\":6,\"jd_contactaddid\":0,\"jd_orderstatus\":13,\"jd_accref\":\"QUOT0041\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"400.00\",\"jd_netprice\":\"470.00\",\"jd_vat\":\"47.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\":\"517.00\",\"jd_grossprofit\":\"70.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"400.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"517.00\",\"jd_totpaid\":\"0.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":null,\"jd_deliverycostid\":0,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_accountingsoftware_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":0,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":0,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":0,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":0,\"jd_organizationid\":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-24T07:02:28.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-06-24T07:04:59.000000Z\",\"salesorderid\":null,\"jd_deviceplatform\":0,\"jd_fromjobref\":\"\",\"jd_fromdbname\":null,\"jd_importorder\":0,\"jd_quickquote\":42,\"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": "60360", "cl_createdat": "1750748699.000000", "cl_updatedat": null }, { "cl_id": 60361, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105352, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 5836, "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-24\",\"Time\":\"07:02:28\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105352,\"nl_ordertempid\":0,\"nl_orderid\":5836,\"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-24\",\"nl_starttime\":\"07:02:28\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":1,\"created_at\":\"2025-06-24T07:02:28.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-24T07:04:59.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60361", "cl_createdat": "1750748699.000000", "cl_updatedat": null }, { "cl_id": 60362, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105353, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 5836, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Trade\",\"Description\":\"Invoice Created (201750748636)\",\"Created By\":\"admin\",\"Date\":\"2025-06-24\",\"Time\":\"07:03:56\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105353,\"nl_ordertempid\":0,\"nl_orderid\":5836,\"nl_notescategory\":1,\"nl_type\":26,\"nl_platform\":2,\"nl_desc\":\"Invoice Created (201750748636)\",\"nl_manualNotes\":null,\"nl_createdby\":\"1\",\"nl_endddate\":\"2025-06-24\",\"nl_starttime\":\"07:03:56\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":1,\"created_at\":\"2025-06-24T07:03:56.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-24T07:04:59.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60362", "cl_createdat": "1750748699.000000", "cl_updatedat": null }, { "cl_id": 60363, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105354, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 5825, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Trade\",\"Description\":\"Invoice Created (201750748685)\",\"Created By\":\"admin\",\"Date\":\"2025-06-24\",\"Time\":\"07:04:45\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105354,\"nl_ordertempid\":0,\"nl_orderid\":5825,\"nl_notescategory\":1,\"nl_type\":26,\"nl_platform\":2,\"nl_desc\":\"Invoice Created (201750748685)\",\"nl_manualNotes\":null,\"nl_createdby\":\"1\",\"nl_endddate\":\"2025-06-24\",\"nl_starttime\":\"07:04:45\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":1,\"created_at\":\"2025-06-24T07:04:45.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-24T07:04:59.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60363", "cl_createdat": "1750748699.000000", "cl_updatedat": null }, { "cl_id": 60364, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in AQ5833", "cl_event": "created", "cl_subjectid": 5873, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 5836, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":5873,\"jmq_jobid\":5836,\"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\":\"400.00\",\"Net Price\":\"470.00\",\"VAT Price\":\"47.00\",\"VAT\":1,\"jmq_deliverycost\":\"70.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"517.00\",\"Gross Profit\":\"70.00\",\"Total CostPrice\":\"400.00\",\"Amount Outstanding\":\"517.00\",\"Total Paid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_deliverycostid\":0,\"Total Cost Price\":0,\"jmq_isonlineorder\":0,\"Is Online Order Submitted\":0,\"End Customer Override Type\":0,\"End Customer Override Net Price\":\"0.00\",\"End Customer Override Vat Price\":\"0.00\",\"End Customer Override Gross Price\":\"0.00\",\"End Customer Delivery Cost Include Vat\":0,\"End Customer Fitting Cost Include Vat\":0,\"Online Delivery Addreddtype\":0,\"Commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"Delivery Vat Percentage\":\"10.000\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":5873,\"jmq_jobid\":5836,\"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\":\"400.00\",\"jmq_netprice\":\"470.00\",\"jmq_vat\":\"47.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\":\"517.00\",\"jmq_grossprofit\":\"70.00\",\"jmq_costprice\":\"400.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"517.00\",\"jmq_totpaid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_userdefinedarray\":null,\"jmq_deliverycostid\":0,\"jmq_iscostpriceon\":0,\"jmq_custompricefields\":\"\",\"jmq_isonlineorder\":0,\"jmq_isonlineordersubmitted\":0,\"jmq_endcustomervatprice\":null,\"jmq_endcustomeroverridetype\":0,\"jmq_endcustomeroverridevalue\":null,\"jmq_endcustomeroverridenetprice\":\"0.00\",\"jmq_endcustomeroverridevatprice\":\"0.00\",\"jmq_endcustomeroverridegrossprice\":\"0.00\",\"jmq_endcustomerdeliverycost\":null,\"jmq_endcustomerdeliverycostinclvat\":0,\"jmq_endcustomerfittingcost\":null,\"jmq_endcustomerfittingcostinclvat\":0,\"jmq_onlinedeliveryaddreddtype\":0,\"jmq_onlinedeliveryaddreddid\":null,\"jmq_commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"jmq_deliveryvatperc\":\"10.000\",\"jmq_cdeliveryvatperc\":\"10.000\",\"jmq_createdby\":1,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-06-24T07:02:28.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": "60364", "cl_createdat": "1750748699.000000", "cl_updatedat": null }, { "cl_id": 60365, "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": 5836, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5836, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":5873}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":5873},\"old\":{\"jd_jobmultiquoteid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60365", "cl_createdat": "1750748699.000000", "cl_updatedat": null }, { "cl_id": 60366, "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 Vision Blinds", "cl_event": "created", "cl_subjectid": 31668, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 5836, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Supplier\":\" Markilux\",\" Width\":\" 125\",\" Drop\":\" 125\",\" Product Type\":\" band z\",\" Fabric\":\" 127mm _ Banlight Duo RD FR\"}", "cl_customproperties": "{\"attributes\":{\"oi_id\":31668,\"oi_jobid\":5836,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":5873,\"oi_credit_id\":0,\"oi_productid\":9,\"oi_recipeid\":9,\"oi_ruleid\":0,\"oi_qty\":1,\"oi_seq\":0,\"oi_customseq\":0,\"oi_productcustomseq\":0,\"oi_jsondata\":\"[{\\\"id\\\":6887,\\\"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\\\":319,\\\"labelname\\\":\\\"Quantity\\\",\\\"value\\\":1,\\\"valueid\\\":\\\"\\\",\\\"type\\\":14,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":320,\\\"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\\\":322,\\\"labelname\\\":\\\"Room\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":323,\\\"labelname\\\":\\\"Width\\\",\\\"value\\\":\\\"125\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":11,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":324,\\\"labelname\\\":\\\"Drop\\\",\\\"value\\\":\\\"125\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":12,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":321,\\\"labelname\\\":\\\"Product Type\\\",\\\"value\\\":474,\\\"valueid\\\":\\\"621\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"474\\\",\\\"optionvalue\\\":[{\\\"id\\\":621,\\\"fieldid\\\":321,\\\"fieldoptionlinkid\\\":621,\\\"optionid\\\":474,\\\"mainsupplier\\\":1,\\\"blindtypecode\\\":\\\"101\\\",\\\"optionname\\\":\\\"band z\\\",\\\"optionquantity\\\":1,\\\"subcount\\\":0,\\\"status\\\":0,\\\"subdatacount\\\":0}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":355,\\\"labelname\\\":\\\"Fabric\\\",\\\"value\\\":\\\"127mm _ Banlight Duo RD FR\\\",\\\"valueid\\\":\\\"4868\\\",\\\"type\\\":5,\\\"optionid\\\":\\\"4868\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":4868,\\\"optionname\\\":\\\"127mm _ Banlight Duo RD FR\\\",\\\"optioncode\\\":\\\"VEF95\\\",\\\"optionquantity\\\":1,\\\"fieldoptionlinkid\\\":4868,\\\"forchildfieldoptionlinkid\\\":\\\"5_2_4868_1\\\",\\\"optionimage\\\":\\\"\\\",\\\"subdatacount\\\":1,\\\"pricegroup\\\":\\\"band z\\\",\\\"pricegroupid\\\":474}],\\\"fabricorcolor\\\":1,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":8291,\\\"labelname\\\":\\\"Color\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":5,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":2,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":325,\\\"labelname\\\":\\\"Vision Panel Size\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":326,\\\"labelname\\\":\\\"Measure To\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":327,\\\"labelname\\\":\\\"Controls\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":328,\\\"labelname\\\":\\\"Brackets\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":329,\\\"labelname\\\":\\\"Chain Colour\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":330,\\\"labelname\\\":\\\"Roll\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":331,\\\"labelname\\\":\\\"System Type\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":332,\\\"labelname\\\":\\\"Tube Size\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":335,\\\"labelname\\\":\\\"Control Type\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":333,\\\"labelname\\\":\\\"Motorisation\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":336,\\\"labelname\\\":\\\"Fixing\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":337,\\\"labelname\\\":\\\"Extras\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7270,\\\"labelname\\\":\\\"Product Type\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7269,\\\"labelname\\\":\\\"Dual\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":5,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":1,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0}]\",\"oi_description\":\"Supplier: Markilux, Width: 125, Drop: 125, Product Type: band z, Fabric: 127mm _ Banlight Duo RD FR\",\"oi_onlinedescription\":null,\"oi_imagepath\":null,\"oi_reportdescription\":\"##Quantity: 1##,##Supplier: Markilux##,##Width: 125 mm##,##Drop: 125 mm##,##Product Type: band z##,##Fabric: 127mm _ Banlight Duo RD FR##\",\"oi_onlinereportdescription\":null,\"oi_reporttitles\":\"##Quantity:##Supplier:##Width:##Drop:##Product Type:##Fabric:\",\"oi_onlinereporttitles\":null,\"oi_productionformulajsondata\":\"[]\",\"oi_productiondate\":\"2025-06-24 07:03:07\",\"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\":\"400.000\",\"oi_netprice\":\"400.000\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"40.000\",\"oi_vatvalue\":\"10.000\",\"oi_vatselected\":1,\"oi_vattype\":1,\"oi_vatonoff\":1,\"oi_grossprice\":\"440.000\",\"oi_overrideprice\":\"0.000\",\"oi_overridetype\":1,\"oi_overridevalue\":null,\"oi_overridenetprice\":\"0.000\",\"oi_overridevatprice\":\"0.000\",\"oi_overridegrossprice\":\"0.000\",\"oi_ready\":0,\"oi_onhold\":0,\"oi_platformcreatedfrom\":\"web\",\"oi_platformlastupdatedfrom\":\"web\",\"oi_copiedfrom\":0,\"oi_isonlineorder\":0,\"oi_endcustomervatprice\":null,\"oi_endcustomeroverridetype\":1,\"oi_endcustomeroverridevalue\":null,\"oi_endcustomeroverridenetprice\":\"400.000\",\"oi_endcustomeroverridevatprice\":\"40.000\",\"oi_endcustomeroverridegrossprice\":\"440.000\",\"oi_sage_flag\":0,\"oi_supid\":null,\"oi_status\":0,\"oi_createdby\":1,\"oi_createdat\":\"2025-06-24T07:03:30.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":null,\"oi_jsondataid\":\"[6887, 319, 320, 322, 323, 324, 321, 355, 8291, 325, 326, 327, 328, 329, 330, 331, 332, 335, 333, 336, 337, 7270, 7269]\",\"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": "60366", "cl_createdat": "1750748699.000000", "cl_updatedat": null }, { "cl_id": 60367, "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 MUFASA", "cl_event": "created", "cl_subjectid": 31669, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 5825, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Supplier\":\" AQ Blinds\",\" Width\":\" 125\",\" Drop\":\" 125\",\" Product Type\":\" Price group B fabric\",\" Fabric Roll\":\" Standard Roll Fabric\",\" Fitting\":\" Face Fit Blind\",\" Operation side\":\" Right Hand\",\" Roller tube\":\" White 40mm Components And Steel Coated Brackets\",\" Bottom Bars\":\" Sewn In Bottom Bar\"}", "cl_customproperties": "{\"attributes\":{\"oi_id\":31669,\"oi_jobid\":5825,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":5860,\"oi_credit_id\":0,\"oi_productid\":276,\"oi_recipeid\":279,\"oi_ruleid\":0,\"oi_qty\":1,\"oi_seq\":0,\"oi_customseq\":0,\"oi_productcustomseq\":0,\"oi_jsondata\":\"[{\\\"id\\\":8121,\\\"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\\\":7702,\\\"labelname\\\":\\\"Quantity\\\",\\\"value\\\":1,\\\"valueid\\\":\\\"\\\",\\\"type\\\":14,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7703,\\\"labelname\\\":\\\"Supplier\\\",\\\"value\\\":14,\\\"valueid\\\":\\\"\\\",\\\"type\\\":17,\\\"optionid\\\":\\\"14\\\",\\\"optionvalue\\\":[{\\\"id\\\":14,\\\"optionid\\\":14,\\\"optionname\\\":\\\"AQ Blinds\\\",\\\"deleted\\\":0,\\\"optionquantity\\\":1}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7704,\\\"labelname\\\":\\\"Location\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7705,\\\"labelname\\\":\\\"Width\\\",\\\"value\\\":\\\"125\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":11,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":7706,\\\"labelname\\\":\\\"Drop\\\",\\\"value\\\":\\\"125\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":12,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":8120,\\\"labelname\\\":\\\"Fitting height\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":6,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7707,\\\"labelname\\\":\\\"Product Type\\\",\\\"value\\\":387,\\\"valueid\\\":\\\"649\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"387\\\",\\\"optionvalue\\\":[{\\\"id\\\":649,\\\"fieldid\\\":7707,\\\"fieldoptionlinkid\\\":649,\\\"optionid\\\":387,\\\"mainsupplier\\\":14,\\\"blindtypecode\\\":\\\"\\\",\\\"optionname\\\":\\\"Price group B fabric\\\",\\\"optionquantity\\\":1,\\\"subcount\\\":0,\\\"status\\\":0,\\\"subdatacount\\\":0}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":7719,\\\"labelname\\\":\\\"Fabric\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":5,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":1,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7708,\\\"labelname\\\":\\\"Fabric Roll\\\",\\\"value\\\":\\\"Standard Roll Fabric\\\",\\\"valueid\\\":\\\"23315\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"1133\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":1133,\\\"optionname\\\":\\\"Standard Roll Fabric\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"AQR01\\\",\\\"pricegroups\\\":\\\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\\\",\\\"optionqty\\\":1,\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":23315,\\\"forchildfieldoptionlinkid\\\":\\\"3_23315\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7709,\\\"labelname\\\":\\\"Fitting\\\",\\\"value\\\":\\\"Face Fit Blind\\\",\\\"valueid\\\":\\\"23317\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"1135\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":1135,\\\"optionname\\\":\\\"Face Fit Blind\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"AQR03\\\",\\\"pricegroups\\\":\\\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\\\",\\\"optionqty\\\":1,\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":23317,\\\"forchildfieldoptionlinkid\\\":\\\"3_23317\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"0.00\\\",\\\"fieldid\\\":23317}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7710,\\\"labelname\\\":\\\"Operation side\\\",\\\"value\\\":\\\"Right Hand\\\",\\\"valueid\\\":\\\"23319\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"1137\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":1137,\\\"optionname\\\":\\\"Right Hand\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"AQR05\\\",\\\"pricegroups\\\":\\\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\\\",\\\"optionqty\\\":1,\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":23319,\\\"forchildfieldoptionlinkid\\\":\\\"3_23319\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7711,\\\"labelname\\\":\\\"Roller tube\\\",\\\"value\\\":\\\"White 40mm Components And Steel Coated Brackets\\\",\\\"valueid\\\":\\\"23321\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"1139\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":1139,\\\"optionname\\\":\\\"White 40mm Components And Steel Coated Brackets\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"AQR07\\\",\\\"pricegroups\\\":\\\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\\\",\\\"optionqty\\\":1,\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":23321,\\\"forchildfieldoptionlinkid\\\":\\\"3_23321\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7712,\\\"labelname\\\":\\\"Chain Colour\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7713,\\\"labelname\\\":\\\"Fixing Plate\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7714,\\\"labelname\\\":\\\"Fascia\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7715,\\\"labelname\\\":\\\"Bottom Bars\\\",\\\"value\\\":\\\"Sewn In Bottom Bar\\\",\\\"valueid\\\":\\\"23361\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"1179\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":1179,\\\"optionname\\\":\\\"Sewn In Bottom Bar\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"AQR47\\\",\\\"pricegroups\\\":\\\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\\\",\\\"optionqty\\\":1,\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":23361,\\\"forchildfieldoptionlinkid\\\":\\\"3_23361\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7716,\\\"labelname\\\":\\\"Motor\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7717,\\\"labelname\\\":\\\"Special options\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7718,\\\"labelname\\\":\\\"Special Instructions\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":8123,\\\"labelname\\\":\\\"Crank control\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0}]\",\"oi_description\":\"Supplier: AQ Blinds, Width: 125, Drop: 125, Product Type: Price group B fabric, Fabric Roll: Standard Roll Fabric, Fitting: Face Fit Blind, Operation side: Right Hand, Roller tube: White 40mm Components And Steel Coated Brackets, Bottom Bars: Sewn In Bottom Bar\",\"oi_onlinedescription\":null,\"oi_imagepath\":null,\"oi_reportdescription\":\"##Quantity: 1##,##Supplier: AQ Blinds##,##Width: 125 mm##,##Drop: 125 mm##,##Product Type: Price group B fabric##,##Fabric Roll: Standard Roll Fabric##,##Fitting: Face Fit Blind##,##Operation side: Right Hand##,##Roller tube: White 40mm Components And Steel Coated Brackets##,##Bottom Bars: Sewn In Bottom Bar##\",\"oi_onlinereportdescription\":null,\"oi_reporttitles\":\"##Quantity:##Supplier:##Width:##Drop:##Product Type:##Fabric Roll:##Fitting:##Operation side:##Roller tube:##Bottom Bars:\",\"oi_onlinereporttitles\":null,\"oi_productionformulajsondata\":\"[]\",\"oi_productiondate\":\"2025-06-24 07:04:17\",\"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\":\"0.000\",\"oi_netprice\":\"61.600\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"6.160\",\"oi_vatvalue\":\"10.000\",\"oi_vatselected\":1,\"oi_vattype\":1,\"oi_vatonoff\":1,\"oi_grossprice\":\"67.760\",\"oi_overrideprice\":\"0.000\",\"oi_overridetype\":1,\"oi_overridevalue\":null,\"oi_overridenetprice\":\"0.000\",\"oi_overridevatprice\":\"0.000\",\"oi_overridegrossprice\":\"0.000\",\"oi_ready\":0,\"oi_onhold\":0,\"oi_platformcreatedfrom\":\"web\",\"oi_platformlastupdatedfrom\":\"web\",\"oi_copiedfrom\":0,\"oi_isonlineorder\":0,\"oi_endcustomervatprice\":null,\"oi_endcustomeroverridetype\":1,\"oi_endcustomeroverridevalue\":null,\"oi_endcustomeroverridenetprice\":\"61.600\",\"oi_endcustomeroverridevatprice\":\"6.160\",\"oi_endcustomeroverridegrossprice\":\"67.760\",\"oi_sage_flag\":0,\"oi_supid\":null,\"oi_status\":0,\"oi_createdby\":1,\"oi_createdat\":\"2025-06-24T07:04:30.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":null,\"oi_jsondataid\":\"[8121, 7702, 7703, 7704, 7705, 7706, 8120, 7707, 7719, 7708, 7709, 7710, 7711, 7712, 7713, 7714, 7715, 7716, 7717, 7718, 8123]\",\"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": "60367", "cl_createdat": "1750748699.000000", "cl_updatedat": null }, { "cl_id": 60368, "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": 5684, "cl_subjecttype": "App\\Models\\Job\\bm_deliveryaddresssetting", "cl_parentid": 5836, "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\":5684,\"das_jobid\":5836,\"das_appointmentaddress\":4270,\"das_invoiceaddress\":4270,\"das_invoicedeliveryaddress\":4270,\"das_purchaseaddress\":0,\"das_worksheetaddress\":0,\"das_createdby\":1,\"das_createdat\":\"2025-06-24T07:04:59.000000Z\",\"das_updatedby\":null,\"das_updatedat\":\"2025-06-24T07:04:59.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60368", "cl_createdat": "1750748699.000000", "cl_updatedat": null }, { "cl_id": 60369, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the field ", "cl_event": "modified", "cl_subjectid": 5825, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5825, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "{\"Invoice No\":\"Invoice9686\"}", "cl_changedto": "[]", "cl_customproperties": "{\"attributes\":{\"jd_invoiceno\":\"\",\"jd_updatedat\":\"2025-06-24T07:06:17.000000Z\"},\"old\":{\"jd_invoiceno\":\"Invoice9686\",\"jd_updatedat\":\"2025-06-24T07:04:59.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60369", "cl_createdat": "1750748777.000000", "cl_updatedat": null }, { "cl_id": 60370, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105355, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 5825, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Ecommerce\",\"Description\":\"Invoice Deleted (Invoice9686)\",\"Created By\":\"admin\",\"Date\":\"2025-06-24\",\"Time\":\"17:06:17\",\"Is online note\":\"Yes\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105355,\"nl_ordertempid\":null,\"nl_orderid\":5825,\"nl_notescategory\":1,\"nl_type\":26,\"nl_platform\":3,\"nl_desc\":\"Invoice Deleted (Invoice9686)\",\"nl_manualNotes\":\"\",\"nl_createdby\":\"1\",\"nl_endddate\":\"2025-06-24\",\"nl_starttime\":\"17:06:17\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":1,\"nl_seq\":0,\"nl_status\":0,\"created_by\":1,\"created_at\":\"2025-06-24T07:06:17.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-24T07:06:17.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60370", "cl_createdat": "1750748777.000000", "cl_updatedat": null }, { "cl_id": 60371, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the field ", "cl_event": "modified", "cl_subjectid": 5836, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5836, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 11, "cl_changedfrom": "{\"Invoice No\":\"Invoice9685\"}", "cl_changedto": "[]", "cl_customproperties": "{\"attributes\":{\"jd_invoiceno\":\"\",\"jd_updatedat\":\"2025-06-24T07:07:22.000000Z\"},\"old\":{\"jd_invoiceno\":\"Invoice9685\",\"jd_updatedat\":\"2025-06-24T07:04:59.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60371", "cl_createdat": "1750748842.000000", "cl_updatedat": null }, { "cl_id": 60372, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105356, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 5836, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 11, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Ecommerce\",\"Description\":\"Invoice Deleted (Invoice9685)\",\"Created By\":\"Kishore\",\"Date\":\"2025-06-24\",\"Time\":\"17:07:23\",\"Is online note\":\"Yes\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105356,\"nl_ordertempid\":null,\"nl_orderid\":5836,\"nl_notescategory\":1,\"nl_type\":26,\"nl_platform\":3,\"nl_desc\":\"Invoice Deleted (Invoice9685)\",\"nl_manualNotes\":\"\",\"nl_createdby\":\"11\",\"nl_endddate\":\"2025-06-24\",\"nl_starttime\":\"17:07:23\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":1,\"nl_seq\":0,\"nl_status\":0,\"created_by\":11,\"created_at\":\"2025-06-24T07:07:23.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-24T07:07:23.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60372", "cl_createdat": "1750748843.000000", "cl_updatedat": null }, { "cl_id": 60373, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 5837, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5837, "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\",\"Last Name\":\"Quote 43\",\"Address1\":\"Quote 43\",\"Town \\\/ City\":\"Quote 43\",\"Country\":\"India\",\"Salutation\":\"Dr\",\"Assigned to\":1,\"Number\":\"5\",\"Additional Contacts\":\"4271\",\"Order Date\":\"2025-06-24\",\"Job Ref No\":\"AQ5834\",\"Job Status\":\"Invoiced\",\"Order Status\":\"Enquiry\",\"Net Price\":\"470.00\",\"VAT Price\":\"47.00\",\"VAT\":\"Enabled\",\"DeliveryCost\":\"70.00\",\"Delivery Cost\":\"All Options\",\"Gross Price Amount\":\"517.00\",\"Gross Profit\":\"70.00\",\"Total CostPrice\":\"400.00\",\"Amount Outstanding\":\"467.00\",\"Total Paid\":\"50.00\",\"jd_isonlineorder\":1,\"jd_quickquote\":43,\"Delivery Vat Percentage\":\"10.000\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\",\"Job Rework Enable\":\"On\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":5837,\"jd_customerid\":4084,\"jd_contactid\":4271,\"jd_additionalcontacts\":\"4271\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"AQ5834\\\",\\\"35\\\":\\\"QUOT0042\\\",\\\"36\\\":6,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":\\\"\\\",\\\"40\\\":13,\\\"41\\\":1,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"\\\",\\\"46\\\":\\\"Quote 43\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"Quote 43\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"Quote 43\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":36,\\\"285\\\":12,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":1,\\\"558\\\":\\\"\\\",\\\"559\\\":1,\\\"610\\\":\\\"\\\",\\\"611\\\":\\\"\\\",\\\"612\\\":1,\\\"618\\\":\\\"5\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-06-24\",\"jd_orderdate\":\"2025-06-24\",\"jd_duedate\":null,\"jd_sceduleddate\":null,\"jd_invoicedate\":\"0000-00-00\",\"jd_completeddate\":null,\"jd_jobref\":\"AQ5834\",\"jd_jobstatus\":6,\"jd_contactaddid\":0,\"jd_orderstatus\":13,\"jd_accref\":\"QUOT0042\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"400.00\",\"jd_netprice\":\"470.00\",\"jd_vat\":\"47.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\":\"517.00\",\"jd_grossprofit\":\"70.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"400.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"467.00\",\"jd_totpaid\":\"50.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":null,\"jd_deliverycostid\":0,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_accountingsoftware_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":0,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":0,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":0,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":0,\"jd_organizationid\":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-24T07:12:16.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-06-24T07:14:27.000000Z\",\"salesorderid\":null,\"jd_deviceplatform\":0,\"jd_fromjobref\":\"\",\"jd_fromdbname\":null,\"jd_importorder\":0,\"jd_quickquote\":43,\"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": "60373", "cl_createdat": "1750749267.000000", "cl_updatedat": null }, { "cl_id": 60374, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 5838, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5838, "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\",\"Last Name\":\"Quote 44\",\"Address1\":\"Quote 44\",\"Town \\\/ City\":\"Quote 44\",\"Country\":\"India\",\"Salutation\":\"Dr\",\"Assigned to\":1,\"Number\":\"6\",\"Additional Contacts\":\"4272\",\"Order Date\":\"2025-06-24\",\"Job Ref No\":\"AQ5835\",\"Job Status\":\"Invoiced\",\"Order Status\":\"Enquiry\",\"Net Price\":\"470.00\",\"VAT Price\":\"47.00\",\"VAT\":\"Enabled\",\"DeliveryCost\":\"70.00\",\"Delivery Cost\":\"All Options\",\"Gross Price Amount\":\"517.00\",\"Gross Profit\":\"70.00\",\"Total CostPrice\":\"400.00\",\"Amount Outstanding\":\"517.00\",\"jd_isonlineorder\":1,\"jd_quickquote\":44,\"Delivery Vat Percentage\":\"10.000\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\",\"Job Rework Enable\":\"On\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":5838,\"jd_customerid\":4085,\"jd_contactid\":4272,\"jd_additionalcontacts\":\"4272\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"AQ5835\\\",\\\"35\\\":\\\"QUOT0043\\\",\\\"36\\\":6,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":\\\"\\\",\\\"40\\\":13,\\\"41\\\":1,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"\\\",\\\"46\\\":\\\"Quote 44\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"Quote 44\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"Quote 44\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":36,\\\"285\\\":12,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":1,\\\"558\\\":\\\"\\\",\\\"559\\\":1,\\\"610\\\":\\\"\\\",\\\"611\\\":\\\"\\\",\\\"612\\\":1,\\\"618\\\":\\\"6\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-06-24\",\"jd_orderdate\":\"2025-06-24\",\"jd_duedate\":null,\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":null,\"jd_jobref\":\"AQ5835\",\"jd_jobstatus\":6,\"jd_contactaddid\":0,\"jd_orderstatus\":13,\"jd_accref\":\"QUOT0043\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"400.00\",\"jd_netprice\":\"470.00\",\"jd_vat\":\"47.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\":\"517.00\",\"jd_grossprofit\":\"70.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"400.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"517.00\",\"jd_totpaid\":\"0.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":null,\"jd_deliverycostid\":0,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_accountingsoftware_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":0,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":0,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":0,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":0,\"jd_organizationid\":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-24T07:13:37.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-06-24T07:14:28.000000Z\",\"salesorderid\":null,\"jd_deviceplatform\":0,\"jd_fromjobref\":\"\",\"jd_fromdbname\":null,\"jd_importorder\":0,\"jd_quickquote\":44,\"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": "60374", "cl_createdat": "1750749268.000000", "cl_updatedat": null }, { "cl_id": 60375, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105357, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 5837, "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-24\",\"Time\":\"07:12:16\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105357,\"nl_ordertempid\":0,\"nl_orderid\":5837,\"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-24\",\"nl_starttime\":\"07:12:16\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":1,\"created_at\":\"2025-06-24T07:12:16.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-24T07:14:28.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60375", "cl_createdat": "1750749268.000000", "cl_updatedat": null }, { "cl_id": 60376, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105358, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 5837, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Trade\",\"Description\":\"Invoice Created (201750749199)\",\"Created By\":\"admin\",\"Date\":\"2025-06-24\",\"Time\":\"07:13:19\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105358,\"nl_ordertempid\":0,\"nl_orderid\":5837,\"nl_notescategory\":1,\"nl_type\":26,\"nl_platform\":2,\"nl_desc\":\"Invoice Created (201750749199)\",\"nl_manualNotes\":null,\"nl_createdby\":\"1\",\"nl_endddate\":\"2025-06-24\",\"nl_starttime\":\"07:13:19\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":1,\"created_at\":\"2025-06-24T07:13:19.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-24T07:14:28.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60376", "cl_createdat": "1750749268.000000", "cl_updatedat": null }, { "cl_id": 60377, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105359, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 5837, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Trade\",\"Description\":\"payment added against invoice no ('201750749199') amount ('50')\",\"Created By\":\"admin\",\"Date\":\"2025-06-24\",\"Time\":\"07:13:19\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105359,\"nl_ordertempid\":0,\"nl_orderid\":5837,\"nl_notescategory\":1,\"nl_type\":26,\"nl_platform\":2,\"nl_desc\":\"payment added against invoice no ('201750749199') amount ('50')\",\"nl_manualNotes\":null,\"nl_createdby\":\"1\",\"nl_endddate\":\"2025-06-24\",\"nl_starttime\":\"07:13:19\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":1,\"created_at\":\"2025-06-24T07:13:19.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-24T07:14:28.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60377", "cl_createdat": "1750749268.000000", "cl_updatedat": null }, { "cl_id": 60378, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105360, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 5838, "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-24\",\"Time\":\"07:13:37\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105360,\"nl_ordertempid\":0,\"nl_orderid\":5838,\"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-24\",\"nl_starttime\":\"07:13:37\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":1,\"created_at\":\"2025-06-24T07:13:37.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-24T07:14:28.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60378", "cl_createdat": "1750749268.000000", "cl_updatedat": null }, { "cl_id": 60379, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105361, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 5838, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Trade\",\"Description\":\"Invoice Created (201750749242)\",\"Created By\":\"admin\",\"Date\":\"2025-06-24\",\"Time\":\"07:14:02\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105361,\"nl_ordertempid\":0,\"nl_orderid\":5838,\"nl_notescategory\":1,\"nl_type\":26,\"nl_platform\":2,\"nl_desc\":\"Invoice Created (201750749242)\",\"nl_manualNotes\":null,\"nl_createdby\":\"1\",\"nl_endddate\":\"2025-06-24\",\"nl_starttime\":\"07:14:02\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":1,\"created_at\":\"2025-06-24T07:14:02.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-24T07:14:28.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60379", "cl_createdat": "1750749268.000000", "cl_updatedat": null }, { "cl_id": 60380, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105362, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 5838, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Trade\",\"Description\":\"payment added against invoice no ('201750749242') amount ('50')\",\"Created By\":\"admin\",\"Date\":\"2025-06-24\",\"Time\":\"07:14:09\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105362,\"nl_ordertempid\":0,\"nl_orderid\":5838,\"nl_notescategory\":1,\"nl_type\":26,\"nl_platform\":2,\"nl_desc\":\"payment added against invoice no ('201750749242') amount ('50')\",\"nl_manualNotes\":null,\"nl_createdby\":\"1\",\"nl_endddate\":\"2025-06-24\",\"nl_starttime\":\"07:14:09\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":1,\"created_at\":\"2025-06-24T07:14:09.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-24T07:14:28.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60380", "cl_createdat": "1750749268.000000", "cl_updatedat": null }, { "cl_id": 60381, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105363, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 5838, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Trade\",\"Description\":\"Payment deleted for this invoice ('201750749242') amount ('50')\",\"Created By\":\"admin\",\"Date\":\"2025-06-24\",\"Time\":\"07:14:13\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105363,\"nl_ordertempid\":0,\"nl_orderid\":5838,\"nl_notescategory\":1,\"nl_type\":26,\"nl_platform\":2,\"nl_desc\":\"Payment deleted for this invoice ('201750749242') amount ('50')\",\"nl_manualNotes\":null,\"nl_createdby\":\"1\",\"nl_endddate\":\"2025-06-24\",\"nl_starttime\":\"07:14:13\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":1,\"created_at\":\"2025-06-24T07:14:13.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-06-24T07:14:28.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60381", "cl_createdat": "1750749268.000000", "cl_updatedat": null }, { "cl_id": 60382, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in AQ5834", "cl_event": "created", "cl_subjectid": 5874, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 5837, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":5874,\"jmq_jobid\":5837,\"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\":\"400.00\",\"Net Price\":\"470.00\",\"VAT Price\":\"47.00\",\"VAT\":1,\"jmq_deliverycost\":\"70.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"517.00\",\"Gross Profit\":\"70.00\",\"Total CostPrice\":\"400.00\",\"Amount Outstanding\":\"467.00\",\"Total Paid\":\"50.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\":5874,\"jmq_jobid\":5837,\"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\":\"400.00\",\"jmq_netprice\":\"470.00\",\"jmq_vat\":\"47.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\":\"517.00\",\"jmq_grossprofit\":\"70.00\",\"jmq_costprice\":\"400.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"467.00\",\"jmq_totpaid\":\"50.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-24T07:12:16.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": "60382", "cl_createdat": "1750749268.000000", "cl_updatedat": null }, { "cl_id": 60383, "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": 5837, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5837, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":5874}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":5874,\"jd_updatedat\":\"2025-06-24T07:14:28.000000Z\"},\"old\":{\"jd_jobmultiquoteid\":null,\"jd_updatedat\":\"2025-06-24T07:14:27.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60383", "cl_createdat": "1750749268.000000", "cl_updatedat": null }, { "cl_id": 60384, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in AQ5835", "cl_event": "created", "cl_subjectid": 5875, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 5838, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":5875,\"jmq_jobid\":5838,\"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\":\"400.00\",\"Net Price\":\"470.00\",\"VAT Price\":\"47.00\",\"VAT\":1,\"jmq_deliverycost\":\"70.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"517.00\",\"Gross Profit\":\"70.00\",\"Total CostPrice\":\"400.00\",\"Amount Outstanding\":\"517.00\",\"Total Paid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_deliverycostid\":0,\"Total Cost Price\":0,\"jmq_isonlineorder\":0,\"Is Online Order Submitted\":0,\"End Customer Override Type\":0,\"End Customer Override Net Price\":\"0.00\",\"End Customer Override Vat Price\":\"0.00\",\"End Customer Override Gross Price\":\"0.00\",\"End Customer Delivery Cost Include Vat\":0,\"End Customer Fitting Cost Include Vat\":0,\"Online Delivery Addreddtype\":0,\"Commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"Delivery Vat Percentage\":\"10.000\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":5875,\"jmq_jobid\":5838,\"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\":\"400.00\",\"jmq_netprice\":\"470.00\",\"jmq_vat\":\"47.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\":\"517.00\",\"jmq_grossprofit\":\"70.00\",\"jmq_costprice\":\"400.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"517.00\",\"jmq_totpaid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_userdefinedarray\":null,\"jmq_deliverycostid\":0,\"jmq_iscostpriceon\":0,\"jmq_custompricefields\":\"\",\"jmq_isonlineorder\":0,\"jmq_isonlineordersubmitted\":0,\"jmq_endcustomervatprice\":null,\"jmq_endcustomeroverridetype\":0,\"jmq_endcustomeroverridevalue\":null,\"jmq_endcustomeroverridenetprice\":\"0.00\",\"jmq_endcustomeroverridevatprice\":\"0.00\",\"jmq_endcustomeroverridegrossprice\":\"0.00\",\"jmq_endcustomerdeliverycost\":null,\"jmq_endcustomerdeliverycostinclvat\":0,\"jmq_endcustomerfittingcost\":null,\"jmq_endcustomerfittingcostinclvat\":0,\"jmq_onlinedeliveryaddreddtype\":0,\"jmq_onlinedeliveryaddreddid\":null,\"jmq_commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"jmq_deliveryvatperc\":\"10.000\",\"jmq_cdeliveryvatperc\":\"10.000\",\"jmq_createdby\":1,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-06-24T07:13:37.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": "60384", "cl_createdat": "1750749268.000000", "cl_updatedat": null }, { "cl_id": 60385, "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": 5838, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5838, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":5875}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":5875},\"old\":{\"jd_jobmultiquoteid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60385", "cl_createdat": "1750749268.000000", "cl_updatedat": null }, { "cl_id": 60386, "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 Vision Blinds", "cl_event": "created", "cl_subjectid": 31670, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 5837, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Supplier\":\" Markilux\",\" Width\":\" 125\",\" Drop\":\" 125\",\" Product Type\":\" band z\",\" Fabric\":\" 127mm _ Banlight Duo RD FR\"}", "cl_customproperties": "{\"attributes\":{\"oi_id\":31670,\"oi_jobid\":5837,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":5874,\"oi_credit_id\":0,\"oi_productid\":9,\"oi_recipeid\":9,\"oi_ruleid\":0,\"oi_qty\":1,\"oi_seq\":1,\"oi_customseq\":0,\"oi_productcustomseq\":0,\"oi_jsondata\":\"[{\\\"id\\\":6887,\\\"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\\\":319,\\\"labelname\\\":\\\"Quantity\\\",\\\"value\\\":1,\\\"valueid\\\":\\\"\\\",\\\"type\\\":14,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":320,\\\"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\\\":322,\\\"labelname\\\":\\\"Room\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":323,\\\"labelname\\\":\\\"Width\\\",\\\"value\\\":\\\"125\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":11,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":324,\\\"labelname\\\":\\\"Drop\\\",\\\"value\\\":\\\"125\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":12,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":321,\\\"labelname\\\":\\\"Product Type\\\",\\\"value\\\":474,\\\"valueid\\\":\\\"621\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"474\\\",\\\"optionvalue\\\":[{\\\"id\\\":621,\\\"fieldid\\\":321,\\\"fieldoptionlinkid\\\":621,\\\"optionid\\\":474,\\\"mainsupplier\\\":1,\\\"blindtypecode\\\":\\\"101\\\",\\\"optionname\\\":\\\"band z\\\",\\\"optionquantity\\\":1,\\\"subcount\\\":0,\\\"status\\\":0,\\\"subdatacount\\\":0}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":355,\\\"labelname\\\":\\\"Fabric\\\",\\\"value\\\":\\\"127mm _ Banlight Duo RD FR\\\",\\\"valueid\\\":\\\"4868\\\",\\\"type\\\":5,\\\"optionid\\\":\\\"4868\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":4868,\\\"optionname\\\":\\\"127mm _ Banlight Duo RD FR\\\",\\\"optioncode\\\":\\\"VEF95\\\",\\\"optionquantity\\\":1,\\\"fieldoptionlinkid\\\":4868,\\\"forchildfieldoptionlinkid\\\":\\\"5_2_4868_1\\\",\\\"optionimage\\\":\\\"\\\",\\\"subdatacount\\\":1,\\\"pricegroup\\\":\\\"band z\\\",\\\"pricegroupid\\\":474}],\\\"fabricorcolor\\\":1,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":8291,\\\"labelname\\\":\\\"Color\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":5,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":2,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":325,\\\"labelname\\\":\\\"Vision Panel Size\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":326,\\\"labelname\\\":\\\"Measure To\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":327,\\\"labelname\\\":\\\"Controls\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":328,\\\"labelname\\\":\\\"Brackets\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":329,\\\"labelname\\\":\\\"Chain Colour\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":330,\\\"labelname\\\":\\\"Roll\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":331,\\\"labelname\\\":\\\"System Type\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":332,\\\"labelname\\\":\\\"Tube Size\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":335,\\\"labelname\\\":\\\"Control Type\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":333,\\\"labelname\\\":\\\"Motorisation\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":336,\\\"labelname\\\":\\\"Fixing\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":337,\\\"labelname\\\":\\\"Extras\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7270,\\\"labelname\\\":\\\"Product Type\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7269,\\\"labelname\\\":\\\"Dual\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":5,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":1,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0}]\",\"oi_description\":\"Supplier: Markilux, Width: 125, Drop: 125, Product Type: band z, Fabric: 127mm _ Banlight Duo RD FR\",\"oi_onlinedescription\":null,\"oi_imagepath\":null,\"oi_reportdescription\":\"##Quantity: 1##,##Supplier: Markilux##,##Width: 125 mm##,##Drop: 125 mm##,##Product Type: band z##,##Fabric: 127mm _ Banlight Duo RD FR##\",\"oi_onlinereportdescription\":null,\"oi_reporttitles\":\"##Quantity:##Supplier:##Width:##Drop:##Product Type:##Fabric:\",\"oi_onlinereporttitles\":null,\"oi_productionformulajsondata\":\"[]\",\"oi_productiondate\":\"2025-06-24 07:03:07\",\"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\":\"400.000\",\"oi_netprice\":\"400.000\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"40.000\",\"oi_vatvalue\":\"10.000\",\"oi_vatselected\":1,\"oi_vattype\":1,\"oi_vatonoff\":1,\"oi_grossprice\":\"440.000\",\"oi_overrideprice\":\"0.000\",\"oi_overridetype\":1,\"oi_overridevalue\":null,\"oi_overridenetprice\":\"0.000\",\"oi_overridevatprice\":\"0.000\",\"oi_overridegrossprice\":\"0.000\",\"oi_ready\":0,\"oi_onhold\":0,\"oi_platformcreatedfrom\":\"web\",\"oi_platformlastupdatedfrom\":\"web\",\"oi_copiedfrom\":31668,\"oi_isonlineorder\":0,\"oi_endcustomervatprice\":null,\"oi_endcustomeroverridetype\":1,\"oi_endcustomeroverridevalue\":null,\"oi_endcustomeroverridenetprice\":\"400.000\",\"oi_endcustomeroverridevatprice\":\"40.000\",\"oi_endcustomeroverridegrossprice\":\"440.000\",\"oi_sage_flag\":0,\"oi_supid\":null,\"oi_status\":0,\"oi_createdby\":1,\"oi_createdat\":\"2025-06-24T07:12:21.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":null,\"oi_jsondataid\":\"[6887, 319, 320, 322, 323, 324, 321, 355, 8291, 325, 326, 327, 328, 329, 330, 331, 332, 335, 333, 336, 337, 7270, 7269]\",\"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": "60386", "cl_createdat": "1750749268.000000", "cl_updatedat": null }, { "cl_id": 60387, "cl_logname": "model", "cl_type": null, "cl_modulename": "Production Due Date", "cl_message": "Production Due Date has been updated", "cl_event": "modified", "cl_subjectid": 5837, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5837, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "{\"Production Due Date\":\"0000-00-00\"}", "cl_changedto": "{\"Production Due Date\":\"2025-06-24\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60387", "cl_createdat": "1750749268.000000", "cl_updatedat": null }, { "cl_id": 60388, "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 Vision Blinds", "cl_event": "created", "cl_subjectid": 31671, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 5838, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Supplier\":\" Markilux\",\" Width\":\" 125\",\" Drop\":\" 125\",\" Product Type\":\" band z\",\" Fabric\":\" 127mm _ Banlight Duo RD FR\"}", "cl_customproperties": "{\"attributes\":{\"oi_id\":31671,\"oi_jobid\":5838,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":5875,\"oi_credit_id\":0,\"oi_productid\":9,\"oi_recipeid\":9,\"oi_ruleid\":0,\"oi_qty\":1,\"oi_seq\":1,\"oi_customseq\":0,\"oi_productcustomseq\":0,\"oi_jsondata\":\"[{\\\"id\\\":6887,\\\"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\\\":319,\\\"labelname\\\":\\\"Quantity\\\",\\\"value\\\":1,\\\"valueid\\\":\\\"\\\",\\\"type\\\":14,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":320,\\\"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\\\":322,\\\"labelname\\\":\\\"Room\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":323,\\\"labelname\\\":\\\"Width\\\",\\\"value\\\":\\\"125\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":11,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":324,\\\"labelname\\\":\\\"Drop\\\",\\\"value\\\":\\\"125\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":12,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":321,\\\"labelname\\\":\\\"Product Type\\\",\\\"value\\\":474,\\\"valueid\\\":\\\"621\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"474\\\",\\\"optionvalue\\\":[{\\\"id\\\":621,\\\"fieldid\\\":321,\\\"fieldoptionlinkid\\\":621,\\\"optionid\\\":474,\\\"mainsupplier\\\":1,\\\"blindtypecode\\\":\\\"101\\\",\\\"optionname\\\":\\\"band z\\\",\\\"optionquantity\\\":1,\\\"subcount\\\":0,\\\"status\\\":0,\\\"subdatacount\\\":0}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":355,\\\"labelname\\\":\\\"Fabric\\\",\\\"value\\\":\\\"127mm _ Banlight Duo RD FR\\\",\\\"valueid\\\":\\\"4868\\\",\\\"type\\\":5,\\\"optionid\\\":\\\"4868\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":4868,\\\"optionname\\\":\\\"127mm _ Banlight Duo RD FR\\\",\\\"optioncode\\\":\\\"VEF95\\\",\\\"optionquantity\\\":1,\\\"fieldoptionlinkid\\\":4868,\\\"forchildfieldoptionlinkid\\\":\\\"5_2_4868_1\\\",\\\"optionimage\\\":\\\"\\\",\\\"subdatacount\\\":1,\\\"pricegroup\\\":\\\"band z\\\",\\\"pricegroupid\\\":474}],\\\"fabricorcolor\\\":1,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":8291,\\\"labelname\\\":\\\"Color\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":5,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":2,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":325,\\\"labelname\\\":\\\"Vision Panel Size\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":326,\\\"labelname\\\":\\\"Measure To\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":327,\\\"labelname\\\":\\\"Controls\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":328,\\\"labelname\\\":\\\"Brackets\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":329,\\\"labelname\\\":\\\"Chain Colour\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":330,\\\"labelname\\\":\\\"Roll\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":331,\\\"labelname\\\":\\\"System Type\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":332,\\\"labelname\\\":\\\"Tube Size\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":335,\\\"labelname\\\":\\\"Control Type\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":333,\\\"labelname\\\":\\\"Motorisation\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":336,\\\"labelname\\\":\\\"Fixing\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":337,\\\"labelname\\\":\\\"Extras\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7270,\\\"labelname\\\":\\\"Product Type\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7269,\\\"labelname\\\":\\\"Dual\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":5,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":1,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0}]\",\"oi_description\":\"Supplier: Markilux, Width: 125, Drop: 125, Product Type: band z, Fabric: 127mm _ Banlight Duo RD FR\",\"oi_onlinedescription\":null,\"oi_imagepath\":null,\"oi_reportdescription\":\"##Quantity: 1##,##Supplier: Markilux##,##Width: 125 mm##,##Drop: 125 mm##,##Product Type: band z##,##Fabric: 127mm _ Banlight Duo RD FR##\",\"oi_onlinereportdescription\":null,\"oi_reporttitles\":\"##Quantity:##Supplier:##Width:##Drop:##Product Type:##Fabric:\",\"oi_onlinereporttitles\":null,\"oi_productionformulajsondata\":\"[]\",\"oi_productiondate\":\"2025-06-24 07:03:07\",\"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\":\"400.000\",\"oi_netprice\":\"400.000\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"40.000\",\"oi_vatvalue\":\"10.000\",\"oi_vatselected\":1,\"oi_vattype\":1,\"oi_vatonoff\":1,\"oi_grossprice\":\"440.000\",\"oi_overrideprice\":\"0.000\",\"oi_overridetype\":1,\"oi_overridevalue\":null,\"oi_overridenetprice\":\"0.000\",\"oi_overridevatprice\":\"0.000\",\"oi_overridegrossprice\":\"0.000\",\"oi_ready\":0,\"oi_onhold\":0,\"oi_platformcreatedfrom\":\"web\",\"oi_platformlastupdatedfrom\":\"web\",\"oi_copiedfrom\":31668,\"oi_isonlineorder\":0,\"oi_endcustomervatprice\":null,\"oi_endcustomeroverridetype\":1,\"oi_endcustomeroverridevalue\":null,\"oi_endcustomeroverridenetprice\":\"400.000\",\"oi_endcustomeroverridevatprice\":\"40.000\",\"oi_endcustomeroverridegrossprice\":\"440.000\",\"oi_sage_flag\":0,\"oi_supid\":null,\"oi_status\":0,\"oi_createdby\":1,\"oi_createdat\":\"2025-06-24T07:13:42.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":null,\"oi_jsondataid\":\"[6887, 319, 320, 322, 323, 324, 321, 355, 8291, 325, 326, 327, 328, 329, 330, 331, 332, 335, 333, 336, 337, 7270, 7269]\",\"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": "60388", "cl_createdat": "1750749268.000000", "cl_updatedat": null }, { "cl_id": 60389, "cl_logname": "model", "cl_type": null, "cl_modulename": "Production Due Date", "cl_message": "Production Due Date has been updated", "cl_event": "modified", "cl_subjectid": 5838, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 5838, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "{\"Production Due Date\":\"0000-00-00\"}", "cl_changedto": "{\"Production Due Date\":\"2025-06-24\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60389", "cl_createdat": "1750749268.000000", "cl_updatedat": null }, { "cl_id": 60390, "cl_logname": "default", "cl_type": null, "cl_modulename": "Payments", "cl_message": "new item has been created in Payments", "cl_event": "created", "cl_subjectid": 4089, "cl_subjecttype": "App\\Models\\Payment\\bm_paymentlist", "cl_parentid": 4089, "cl_parentsubjecttype": "App\\Models\\Payment\\bm_paymentlist", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"pl_invoice_id\":2627,\"pl_customer_id\":4084,\"pl_overpayment_id\":0,\"pl_jobpayment_id\":2147483647,\"Amount\":\"50.00\",\"Payment Method\":\"stripe\",\"Payment Type\":\"Deposit\",\"pl_surchargetype\":2,\"pl_surchargemethod\":2,\"pl_surchargeamount\":\"0.00\",\"pl_surchargevalue\":\"0.00\",\"pl_surchargetotal\":\"500.00\",\"User Entered\":\"admin\",\"Paid Date\":\"2025-06-24\",\"pl_myob_flag\":0,\"pl_qbo_flag\":0}", "cl_customproperties": "{\"attributes\":{\"pl_id\":4089,\"pl_orderid\":null,\"pl_invoice_id\":2627,\"pl_customer_id\":4084,\"pl_overpayment_id\":0,\"pl_jobpayment_id\":2147483647,\"pl_amount\":\"50.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\":\"500.00\",\"pl_userid\":\"1\",\"pl_paiddate\":\"2025-06-24\",\"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-24T07:13:19.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": "60390", "cl_createdat": "1750749269.000000", "cl_updatedat": null }, { "cl_id": 60391, "cl_logname": "default", "cl_type": null, "cl_modulename": "Payments", "cl_message": "new item has been created in Payments", "cl_event": "created", "cl_subjectid": 4090, "cl_subjecttype": "App\\Models\\Payment\\bm_paymentlist", "cl_parentid": 4090, "cl_parentsubjecttype": "App\\Models\\Payment\\bm_paymentlist", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"pl_invoice_id\":2628,\"pl_customer_id\":4085,\"pl_overpayment_id\":0,\"pl_jobpayment_id\":0,\"Amount\":\"50.00\",\"Payment Method\":\"stripe\",\"Payment Type\":\"Deposit\",\"pl_surchargetype\":2,\"pl_surchargemethod\":2,\"pl_surchargeamount\":\"0.00\",\"pl_surchargevalue\":\"0.00\",\"pl_surchargetotal\":\"50.00\",\"User Entered\":\"admin\",\"Paid Date\":\"2025-06-24\",\"pl_myob_flag\":0,\"pl_qbo_flag\":0}", "cl_customproperties": "{\"attributes\":{\"pl_id\":4090,\"pl_orderid\":null,\"pl_invoice_id\":2628,\"pl_customer_id\":4085,\"pl_overpayment_id\":0,\"pl_jobpayment_id\":0,\"pl_amount\":\"50.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\":\"50.00\",\"pl_userid\":\"1\",\"pl_paiddate\":\"2025-06-24\",\"pl_decription\":null,\"pl_paymentinvoice\":null,\"pl_paymentstatus\":0,\"pl_xero_flag\":0,\"pl_xerooverpaymentid\":null,\"pl_seq\":0,\"pl_status\":1,\"pl_refundtype\":null,\"created_by\":1,\"created_at\":\"2025-06-24T07:14:09.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": "60391", "cl_createdat": "1750749269.000000", "cl_updatedat": null }, { "cl_id": 60392, "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": 5685, "cl_subjecttype": "App\\Models\\Job\\bm_deliveryaddresssetting", "cl_parentid": 5837, "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\":5685,\"das_jobid\":5837,\"das_appointmentaddress\":4271,\"das_invoiceaddress\":4271,\"das_invoicedeliveryaddress\":4271,\"das_purchaseaddress\":0,\"das_worksheetaddress\":0,\"das_createdby\":1,\"das_createdat\":\"2025-06-24T07:14:29.000000Z\",\"das_updatedby\":null,\"das_updatedat\":\"2025-06-24T07:14:29.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60392", "cl_createdat": "1750749269.000000", "cl_updatedat": null }, { "cl_id": 60393, "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": 5686, "cl_subjecttype": "App\\Models\\Job\\bm_deliveryaddresssetting", "cl_parentid": 5838, "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\":5686,\"das_jobid\":5838,\"das_appointmentaddress\":4272,\"das_invoiceaddress\":4272,\"das_invoicedeliveryaddress\":4272,\"das_purchaseaddress\":0,\"das_worksheetaddress\":0,\"das_createdby\":1,\"das_createdat\":\"2025-06-24T07:14:29.000000Z\",\"das_updatedby\":null,\"das_updatedat\":\"2025-06-24T07:14:29.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "60393", "cl_createdat": "1750749269.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": [] }, "bm_calendarsetup": { "created": [], "updated": [], "deleted": [] }, "bm_appointmenttype": { "created": [], "updated": [], "deleted": [] }, "bm_userWorkDay": { "created": [], "updated": [], "deleted": [] }, "bm_users": { "created": [], "updated": [], "deleted": [] }, "custom_fields": { "created": [], "updated": [], "deleted": [] }, "customfieldvalues": { "created": [], "updated": [], "deleted": [] } }, "synctodelete": { "bm_customercontactinfo": { "51750749136": 4271, "51750749217": 4272 }, "bm_customertemplatedata": { "31750749136": 4084, "31750749217": 4085 }, "bm_jobdetails": { "41750749136": 5837, "41750749217": 5838 }, "bm_notelist": { "61750749137": 105357, "61750749138": 105358, "61750749139": 105359, "61750749140": 105360, "61750749141": 105361, "61750749142": 105362, "61750749143": 105363 }, "bm_jobmultiquote": { "141750749136": 5874, "141750749217": 5875 }, "bm_orderitem": { "71750749141": 31670, "71750749222": 31671 }, "bm_Invoice": { "121750749199": 2627, "121750749242": 2628 }, "bm_InvoiceDetails": { "101750749199": 15413, "101750749242": 15414 }, "bm_paymentlist": { "81750749199": 4089, "81750749249": 4090 }, "bm_job_paymentlist": { "81750749161": 411 }, "bm_deliveryaddresssetting": { "161750749182": 5685, "161750749235": 5686 } }, "timestamp": 1750749267 }