{ "status": "success", "upcomingorder_list": { "bm_customertemplatedata": { "created": [], "updated": [ { "ctd_id": 598, "ctd_createdfrom": 0, "ctd_templateid": 56, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"62\": \"DFDF0005\", \"63\": \"Dfdfds\", \"61\": 1, \"690\": 25, \"64\": 24}", "ctd_deletedcustokeyvalue": "{}", "ctd_isenablecustspecvatrate": 0, "ctd_custspecvatrate": "0.00", "ctd_vatregnum": null, "ctd_custsurcharge": null, "ctd_defaultdelcost": null, "ctd_defaultapptype": null, "ctd_defaultstaff": null, "ctd_addcredit": "0.00", "ctd_totredeemed": "0.00", "ctd_balance": "0.00", "ctd_creditlimit": "0.00", "ctd_creditavailable": "0.00", "ctd_overdue": 0, "ctd_paymenttermstype": 0, "ctd_paymenttermsvalue": 0, "ctd_paymenttermsdesc": null, "ctd_ishold": 0, "ctd_jobview": 0, "ctd_jobtypeview": 0, "ctd_discount": "0.00", "ctd_language": 0, "ctd_notymsg": 0, "ctd_onlinelogoname": null, "ctd_onlinelogo": null, "ctd_onlinesendemail": 0, "ctd_fordesktopisenable": 1, "ctd_foronlineisenable": 1, "ctd_enabledproductdesktop": "1,2,3,4,5,6,7,9,10,11,12,13,14,15,16,17,19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89", "ctd_enabledproductonline": "1,2,3,4,5,6,7,9,10,11,12,13,14,15,16,17,19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89", "ctd_onlineproductmarkup": null, "ctd_onlineendcustomeruseprefix": null, "ctd_onlineendcustomersequence": "1", "ctd_onlinequotecustomerterms": null, "ctd_onlinequotepaymentterms": null, "ctd_onlineinvoicecustomerterms": null, "ctd_onlineinvoicepaymentterms": null, "ctd_seq": 0, "ctd_status": 0, "id": "598", "ctd_createdat": 1742895955, "ctd_updatedat": 1742895955, "ctd_createdby": 0, "ctd_updatedby": null }, { "ctd_id": 599, "ctd_createdfrom": 0, "ctd_templateid": 56, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"62\": \"AJAY0001\", \"63\": \"\", \"61\": 1, \"690\": 25, \"64\": 24}", "ctd_deletedcustokeyvalue": "{}", "ctd_isenablecustspecvatrate": 0, "ctd_custspecvatrate": "0.00", "ctd_vatregnum": null, "ctd_custsurcharge": null, "ctd_defaultdelcost": null, "ctd_defaultapptype": null, "ctd_defaultstaff": null, "ctd_addcredit": "0.00", "ctd_totredeemed": "0.00", "ctd_balance": "0.00", "ctd_creditlimit": "0.00", "ctd_creditavailable": "0.00", "ctd_overdue": 0, "ctd_paymenttermstype": 0, "ctd_paymenttermsvalue": 0, "ctd_paymenttermsdesc": null, "ctd_ishold": 0, "ctd_jobview": 0, "ctd_jobtypeview": 0, "ctd_discount": "0.00", "ctd_language": 0, "ctd_notymsg": 0, "ctd_onlinelogoname": null, "ctd_onlinelogo": null, "ctd_onlinesendemail": 0, "ctd_fordesktopisenable": 1, "ctd_foronlineisenable": 1, "ctd_enabledproductdesktop": "1,2,3,4,5,6,7,9,10,11,12,13,14,15,16,17,19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89", "ctd_enabledproductonline": "1,2,3,4,5,6,7,9,10,11,12,13,14,15,16,17,19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89", "ctd_onlineproductmarkup": null, "ctd_onlineendcustomeruseprefix": null, "ctd_onlineendcustomersequence": "2", "ctd_onlinequotecustomerterms": null, "ctd_onlinequotepaymentterms": null, "ctd_onlineinvoicecustomerterms": null, "ctd_onlineinvoicepaymentterms": null, "ctd_seq": 0, "ctd_status": 0, "id": "599", "ctd_createdat": 1742897475, "ctd_updatedat": 1742897676, "ctd_createdby": 0, "ctd_updatedby": null }, { "ctd_id": 599, "ctd_createdfrom": 0, "ctd_templateid": 56, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"62\": \"AJAY0001\", \"63\": \"\", \"61\": 1, \"690\": 25, \"64\": 24}", "ctd_deletedcustokeyvalue": "{}", "ctd_isenablecustspecvatrate": 0, "ctd_custspecvatrate": "0.00", "ctd_vatregnum": null, "ctd_custsurcharge": null, "ctd_defaultdelcost": null, "ctd_defaultapptype": null, "ctd_defaultstaff": null, "ctd_addcredit": "0.00", "ctd_totredeemed": "0.00", "ctd_balance": "0.00", "ctd_creditlimit": "0.00", "ctd_creditavailable": "0.00", "ctd_overdue": 0, "ctd_paymenttermstype": 0, "ctd_paymenttermsvalue": 0, "ctd_paymenttermsdesc": null, "ctd_ishold": 0, "ctd_jobview": 0, "ctd_jobtypeview": 0, "ctd_discount": "0.00", "ctd_language": 0, "ctd_notymsg": 0, "ctd_onlinelogoname": null, "ctd_onlinelogo": null, "ctd_onlinesendemail": 0, "ctd_fordesktopisenable": 1, "ctd_foronlineisenable": 1, "ctd_enabledproductdesktop": "1,2,3,4,5,6,7,9,10,11,12,13,14,15,16,17,19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89", "ctd_enabledproductonline": "1,2,3,4,5,6,7,9,10,11,12,13,14,15,16,17,19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89", "ctd_onlineproductmarkup": null, "ctd_onlineendcustomeruseprefix": null, "ctd_onlineendcustomersequence": "2", "ctd_onlinequotecustomerterms": null, "ctd_onlinequotepaymentterms": null, "ctd_onlineinvoicecustomerterms": null, "ctd_onlineinvoicepaymentterms": null, "ctd_seq": 0, "ctd_status": 0, "id": "599", "ctd_createdat": 1742897475, "ctd_updatedat": 1742897676, "ctd_createdby": 0, "ctd_updatedby": null }, { "ctd_id": 600, "ctd_createdfrom": 0, "ctd_templateid": 56, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"62\": \"SDSD0005\", \"63\": \"\", \"61\": 1, \"690\": 25, \"64\": 24}", "ctd_deletedcustokeyvalue": "{}", "ctd_isenablecustspecvatrate": 0, "ctd_custspecvatrate": "0.00", "ctd_vatregnum": null, "ctd_custsurcharge": null, "ctd_defaultdelcost": null, "ctd_defaultapptype": null, "ctd_defaultstaff": null, "ctd_addcredit": "0.00", "ctd_totredeemed": "0.00", "ctd_balance": "0.00", "ctd_creditlimit": "0.00", "ctd_creditavailable": "0.00", "ctd_overdue": 0, "ctd_paymenttermstype": 0, "ctd_paymenttermsvalue": 0, "ctd_paymenttermsdesc": null, "ctd_ishold": 0, "ctd_jobview": 0, "ctd_jobtypeview": 0, "ctd_discount": "0.00", "ctd_language": 0, "ctd_notymsg": 0, "ctd_onlinelogoname": null, "ctd_onlinelogo": null, "ctd_onlinesendemail": 0, "ctd_fordesktopisenable": 1, "ctd_foronlineisenable": 1, "ctd_enabledproductdesktop": "1,2,3,4,5,6,7,9,10,11,12,13,14,15,16,17,19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89", "ctd_enabledproductonline": "1,2,3,4,5,6,7,9,10,11,12,13,14,15,16,17,19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89", "ctd_onlineproductmarkup": null, "ctd_onlineendcustomeruseprefix": null, "ctd_onlineendcustomersequence": "2", "ctd_onlinequotecustomerterms": null, "ctd_onlinequotepaymentterms": null, "ctd_onlineinvoicecustomerterms": null, "ctd_onlineinvoicepaymentterms": null, "ctd_seq": 0, "ctd_status": 0, "id": "600", "ctd_createdat": 1742898301, "ctd_updatedat": 1742898459, "ctd_createdby": 0, "ctd_updatedby": null }, { "ctd_id": 600, "ctd_createdfrom": 0, "ctd_templateid": 56, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"62\": \"SDSD0005\", \"63\": \"\", \"61\": 1, \"690\": 25, \"64\": 24}", "ctd_deletedcustokeyvalue": "{}", "ctd_isenablecustspecvatrate": 0, "ctd_custspecvatrate": "0.00", "ctd_vatregnum": null, "ctd_custsurcharge": null, "ctd_defaultdelcost": null, "ctd_defaultapptype": null, "ctd_defaultstaff": null, "ctd_addcredit": "0.00", "ctd_totredeemed": "0.00", "ctd_balance": "0.00", "ctd_creditlimit": "0.00", "ctd_creditavailable": "0.00", "ctd_overdue": 0, "ctd_paymenttermstype": 0, "ctd_paymenttermsvalue": 0, "ctd_paymenttermsdesc": null, "ctd_ishold": 0, "ctd_jobview": 0, "ctd_jobtypeview": 0, "ctd_discount": "0.00", "ctd_language": 0, "ctd_notymsg": 0, "ctd_onlinelogoname": null, "ctd_onlinelogo": null, "ctd_onlinesendemail": 0, "ctd_fordesktopisenable": 1, "ctd_foronlineisenable": 1, "ctd_enabledproductdesktop": "1,2,3,4,5,6,7,9,10,11,12,13,14,15,16,17,19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89", "ctd_enabledproductonline": "1,2,3,4,5,6,7,9,10,11,12,13,14,15,16,17,19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89", "ctd_onlineproductmarkup": null, "ctd_onlineendcustomeruseprefix": null, "ctd_onlineendcustomersequence": "2", "ctd_onlinequotecustomerterms": null, "ctd_onlinequotepaymentterms": null, "ctd_onlineinvoicecustomerterms": null, "ctd_onlineinvoicepaymentterms": null, "ctd_seq": 0, "ctd_status": 0, "id": "600", "ctd_createdat": 1742898301, "ctd_updatedat": 1742898459, "ctd_createdby": 0, "ctd_updatedby": null } ], "deleted": [] }, "bm_customercontactinfo": { "created": [], "updated": [ { "cci_id": 620, "cci_customerid": 598, "cci_templateid": 52, "roleid": 1, "cci_customizedarray": "{\"62\":\"\",\"82\":\"\",\"77\":\"\",\"79\":\"\",\"78\":\"\",\"76\":\"04564564\",\"81\":2,\"75\":17,\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"\",\"89\":\"\",\"90\":4,\"86\":\"\",\"91\":\"\",\"88\":\"\"}", "cci_ismarketingemails": 0, "cci_smsverifystatus": 0, "cci_isdocumentreceived": 0, "cci_receiveddocfor": null, "cci_isonlineportal": 0, "cci_latitude": null, "cci_longitude": null, "cci_username": null, "cci_password": null, "cci_confirmpassword": null, "cci_seq": 0, "cci_status": 0, "cci_deviceplatform": 0, "cci_mobcustomertempid": 0, "id": "620", "cci_createdat": 1742895955, "cci_updatedat": 1742895955, "cci_createdby": 0, "cci_updatedby": null }, { "cci_id": 621, "cci_customerid": 599, "cci_templateid": 52, "roleid": 1, "cci_customizedarray": "{\"82\":\"\",\"77\":\"Ajay Test\",\"79\":\"\",\"78\":\"\",\"76\":\"0456465\",\"81\":2,\"75\":17,\"62\":\"\",\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"\",\"89\":\"\",\"90\":4,\"86\":\"\",\"91\":\"\",\"88\":\"\"}", "cci_ismarketingemails": 0, "cci_smsverifystatus": 0, "cci_isdocumentreceived": 0, "cci_receiveddocfor": null, "cci_isonlineportal": 0, "cci_latitude": null, "cci_longitude": null, "cci_username": null, "cci_password": null, "cci_confirmpassword": null, "cci_seq": 0, "cci_status": 0, "cci_deviceplatform": 0, "cci_mobcustomertempid": 0, "id": "621", "cci_createdat": 1742897475, "cci_updatedat": 1742897656, "cci_createdby": 0, "cci_updatedby": null }, { "cci_id": 621, "cci_customerid": 599, "cci_templateid": 52, "roleid": 1, "cci_customizedarray": "{\"82\":\"\",\"77\":\"Ajay Test\",\"79\":\"\",\"78\":\"\",\"76\":\"0456465\",\"81\":2,\"75\":17,\"62\":\"\",\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"\",\"89\":\"\",\"90\":4,\"86\":\"\",\"91\":\"\",\"88\":\"\"}", "cci_ismarketingemails": 0, "cci_smsverifystatus": 0, "cci_isdocumentreceived": 0, "cci_receiveddocfor": null, "cci_isonlineportal": 0, "cci_latitude": null, "cci_longitude": null, "cci_username": null, "cci_password": null, "cci_confirmpassword": null, "cci_seq": 0, "cci_status": 0, "cci_deviceplatform": 0, "cci_mobcustomertempid": 0, "id": "621", "cci_createdat": 1742897475, "cci_updatedat": 1742897656, "cci_createdby": 0, "cci_updatedby": null }, { "cci_id": 622, "cci_customerid": 600, "cci_templateid": 52, "roleid": 1, "cci_customizedarray": "{\"82\":\"\",\"77\":\"Sdsdsd\",\"79\":\"Sdsd\",\"78\":\"\",\"76\":\"0465465456\",\"81\":2,\"75\":17,\"62\":\"\",\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"\",\"89\":\"\",\"90\":4,\"86\":\"\",\"91\":\"\",\"88\":\"\"}", "cci_ismarketingemails": 0, "cci_smsverifystatus": 0, "cci_isdocumentreceived": 0, "cci_receiveddocfor": null, "cci_isonlineportal": 0, "cci_latitude": null, "cci_longitude": null, "cci_username": null, "cci_password": null, "cci_confirmpassword": null, "cci_seq": 0, "cci_status": 0, "cci_deviceplatform": 0, "cci_mobcustomertempid": 0, "id": "622", "cci_createdat": 1742898301, "cci_updatedat": 1742898444, "cci_createdby": 0, "cci_updatedby": null }, { "cci_id": 622, "cci_customerid": 600, "cci_templateid": 52, "roleid": 1, "cci_customizedarray": "{\"82\":\"\",\"77\":\"Sdsdsd\",\"79\":\"Sdsd\",\"78\":\"\",\"76\":\"0465465456\",\"81\":2,\"75\":17,\"62\":\"\",\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"\",\"89\":\"\",\"90\":4,\"86\":\"\",\"91\":\"\",\"88\":\"\"}", "cci_ismarketingemails": 0, "cci_smsverifystatus": 0, "cci_isdocumentreceived": 0, "cci_receiveddocfor": null, "cci_isonlineportal": 0, "cci_latitude": null, "cci_longitude": null, "cci_username": null, "cci_password": null, "cci_confirmpassword": null, "cci_seq": 0, "cci_status": 0, "cci_deviceplatform": 0, "cci_mobcustomertempid": 0, "id": "622", "cci_createdat": 1742898301, "cci_updatedat": 1742898444, "cci_createdby": 0, "cci_updatedby": null } ], "deleted": [] }, "bm_appointment": { "created": [], "updated": [], "deleted": [] }, "bm_tasklist": { "created": [ { "tl_id": 99, "tl_orderid": 0, "tl_taskcategory": 1, "tl_taskdate": "2025-03-26", "tl_tasktime": "20:15:24", "tl_taskmethod": "0", "tl_istaskprivate": 1, "tl_userid": "27", "tl_priority": 0, "tl_addjobid": 0, "tl_desc": "Ds", "tl_status": 0, "tl_markasread": 0, "tl_taskstatus": 2, "tl_userdefinedfields": "[{\"id\":\"2\",\"name\":\"jim\",\"key\":\"task_jim\",\"type\":\"textbox\",\"condition\":1,\"idname\":\"task_jim\",\"pattern\":\"^[a-zA-Z ]*$\",\"errormsg\":\"Only Text is allowed\",\"maxlength\":156,\"mandatory\":1,\"_default\":\"\",\"dropdownoptionvalue\":\"\",\"userdefine\":\"Sa\"}]", "tl_markcompleted": 0, "tl_jobmode": null, "tl_recurrencerule": "FREQ=DAILY;INTERVAL=1;COUNT=2;", "tl_repeatmaindescription": null, "tl_repeatmethod": "daily", "tl_starttask": null, "tl_startdata": null, "tl_endtask": null, "tl_enddata": null, "tl_istaskrepeat": 1, "tl_deviceplatform": 2, "id": "99", "tl_createdat": 1743062636, "tl_updatedat": 1743062636, "tl_createdby": 1, "tl_updatedby": null } ], "updated": [], "deleted": [] }, "bm_jobdetails": { "created": [ { "jd_id": 851, "jd_customerid": 598, "jd_contactid": 620, "jd_additionalcontacts": "620", "jd_templateid": 1, "jd_jobmultiquoteid": 874, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "JBN816", "jd_jobstatus": 3, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "DFDF0005", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "0.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 3, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "0.00", "jd_grossprofit": "0.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "0.00", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 1, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 18, "jd_updatedby": 18, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "3.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":24,\"41\":18,\"44\":\"Dfdfds\",\"45\":\"\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":17,\"286\":\"04564564\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"521\":\"\",\"522\":\"\",\"523\":\"\",\"555\":\"\",\"586\":\"\",\"587\":\"\",\"588\":\"\",\"616\":\"\",\"617\":\"\",\"618\":18,\"625\":2,\"633\":\"\",\"634\":\"\",\"666\":\"\",\"667\":\"\",\"700\":\"\",\"701\":\"\",\"702\":1,\"703\":\"\",\"704\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "3.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "851", "jd_createddate": 1742860800, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1742895955, "jd_updatedat": 1742895955 }, { "jd_id": 852, "jd_customerid": 599, "jd_contactid": 621, "jd_additionalcontacts": "621", "jd_templateid": 1, "jd_jobmultiquoteid": 875, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "JBN817", "jd_jobstatus": 4, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "AJAY0001", "jd_invoiceno": "", "jd_listprice": "2264.25", "jd_netprice": "2264.25", "jd_vat": "67.92", "jd_isvaton": 1, "jd_deliverycost": "754.75", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 3, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "2332.17", "jd_grossprofit": "754.75", "jd_costprice": "1509.50", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "2332.17", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 1, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": "", "jd_endcustomeroverridenetprice": "1509.50", "jd_endcustomeroverridevatprice": "45.28", "jd_endcustomeroverridegrossprice": "1554.78", "jd_endcustomerdeliverycost": "", "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": "", "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 18, "jd_updatedby": 18, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "3.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":24,\"41\":18,\"44\":\"\",\"45\":\"Ajay Test\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":17,\"286\":\"0456465\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"521\":\"\",\"522\":\"\",\"523\":\"\",\"555\":\"\",\"586\":\"\",\"587\":\"\",\"588\":\"\",\"616\":\"\",\"617\":\"\",\"618\":18,\"625\":2,\"633\":\"\",\"634\":\"\",\"666\":\"\",\"667\":\"\",\"700\":\"\",\"701\":\"\",\"702\":1,\"703\":\"\",\"704\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "3.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "852", "jd_createddate": 1742860800, "jd_orderdate": 1742860800, "jd_duedate": 1742860800, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1742897475, "jd_updatedat": 1742897506 }, { "jd_id": 853, "jd_customerid": 599, "jd_contactid": 621, "jd_additionalcontacts": "621", "jd_templateid": 1, "jd_jobmultiquoteid": 876, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "JBN818", "jd_jobstatus": 4, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "AJAY0001", "jd_invoiceno": "", "jd_listprice": "2264.25", "jd_netprice": "2264.25", "jd_vat": "67.92", "jd_isvaton": 1, "jd_deliverycost": "754.75", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 3, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "2332.17", "jd_grossprofit": "754.75", "jd_costprice": "1509.50", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "2332.17", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 1, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": "", "jd_endcustomeroverridenetprice": "1509.50", "jd_endcustomeroverridevatprice": "45.28", "jd_endcustomeroverridegrossprice": "1554.78", "jd_endcustomerdeliverycost": "", "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": "", "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 18, "jd_updatedby": 18, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "3.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":24,\"41\":18,\"44\":\"\",\"45\":\"Ajay Test\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":17,\"286\":\"0456465\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"521\":\"\",\"522\":\"\",\"523\":\"\",\"555\":\"\",\"586\":\"\",\"587\":\"\",\"588\":\"\",\"616\":\"\",\"617\":\"\",\"618\":18,\"625\":2,\"633\":\"\",\"634\":\"\",\"666\":\"\",\"667\":\"\",\"700\":\"\",\"701\":\"\",\"702\":1,\"703\":\"\",\"704\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "3.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "853", "jd_createddate": 1742860800, "jd_orderdate": 1742860800, "jd_duedate": 1742860800, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1742897656, "jd_updatedat": 1742897676 }, { "jd_id": 854, "jd_customerid": 600, "jd_contactid": 622, "jd_additionalcontacts": "622", "jd_templateid": 1, "jd_jobmultiquoteid": 877, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "JBN819", "jd_jobstatus": 4, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "SDSD0005", "jd_invoiceno": "", "jd_listprice": "2264.25", "jd_netprice": "2264.25", "jd_vat": "67.92", "jd_isvaton": 1, "jd_deliverycost": "754.75", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 3, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "2332.17", "jd_grossprofit": "754.75", "jd_costprice": "1509.50", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "2332.17", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 1, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": "", "jd_endcustomeroverridenetprice": "1509.50", "jd_endcustomeroverridevatprice": "45.28", "jd_endcustomeroverridegrossprice": "1554.78", "jd_endcustomerdeliverycost": "", "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": "", "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 18, "jd_updatedby": 18, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "3.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":24,\"41\":18,\"44\":\"\",\"45\":\"Sdsdsd\",\"46\":\"Sdsd\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":17,\"286\":\"0465465456\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"521\":\"\",\"522\":\"\",\"523\":\"\",\"555\":\"\",\"586\":\"\",\"587\":\"\",\"588\":\"\",\"616\":\"\",\"617\":\"\",\"618\":18,\"625\":2,\"633\":\"\",\"634\":\"\",\"666\":\"\",\"667\":\"\",\"700\":\"\",\"701\":\"\",\"702\":1,\"703\":\"\",\"704\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "3.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "854", "jd_createddate": 1742860800, "jd_orderdate": 1742860800, "jd_duedate": 1742860800, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1742898301, "jd_updatedat": 1742898355 }, { "jd_id": 855, "jd_customerid": 600, "jd_contactid": 622, "jd_additionalcontacts": "622", "jd_templateid": 1, "jd_jobmultiquoteid": 878, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "JBN820", "jd_jobstatus": 16, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "SDSD0005", "jd_invoiceno": "", "jd_listprice": "2264.25", "jd_netprice": "2264.25", "jd_vat": "67.92", "jd_isvaton": 1, "jd_deliverycost": "754.75", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 3, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "2332.17", "jd_grossprofit": "754.75", "jd_costprice": "1509.50", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "2332.17", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 1, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": "", "jd_endcustomeroverridenetprice": "1509.50", "jd_endcustomeroverridevatprice": "45.28", "jd_endcustomeroverridegrossprice": "1554.78", "jd_endcustomerdeliverycost": "", "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": "", "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 18, "jd_updatedby": 18, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "3.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":24,\"41\":18,\"44\":\"\",\"45\":\"Sdsdsd\",\"46\":\"Sdsd\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":17,\"286\":\"0465465456\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"521\":\"\",\"522\":\"\",\"523\":\"\",\"555\":\"\",\"586\":\"\",\"587\":\"\",\"588\":\"\",\"616\":\"\",\"617\":\"\",\"618\":18,\"625\":2,\"633\":\"\",\"634\":\"\",\"666\":\"\",\"667\":\"\",\"700\":\"\",\"701\":\"\",\"702\":1,\"703\":\"\",\"704\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "3.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "855", "jd_createddate": 1742860800, "jd_orderdate": 1742860800, "jd_duedate": 1742860800, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1742898444, "jd_updatedat": 1742898459 } ], "updated": [ { "jd_id": 851, "jd_customerid": 598, "jd_contactid": 620, "jd_additionalcontacts": "620", "jd_templateid": 1, "jd_jobmultiquoteid": 874, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "JBN816", "jd_jobstatus": 3, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "DFDF0005", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "0.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 3, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "0.00", "jd_grossprofit": "0.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "0.00", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 1, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 18, "jd_updatedby": 18, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "3.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":24,\"41\":18,\"44\":\"Dfdfds\",\"45\":\"\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":17,\"286\":\"04564564\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"521\":\"\",\"522\":\"\",\"523\":\"\",\"555\":\"\",\"586\":\"\",\"587\":\"\",\"588\":\"\",\"616\":\"\",\"617\":\"\",\"618\":18,\"625\":2,\"633\":\"\",\"634\":\"\",\"666\":\"\",\"667\":\"\",\"700\":\"\",\"701\":\"\",\"702\":1,\"703\":\"\",\"704\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "3.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "851", "jd_createddate": 1742860800, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1742895955, "jd_updatedat": 1742895955 }, { "jd_id": 852, "jd_customerid": 599, "jd_contactid": 621, "jd_additionalcontacts": "621", "jd_templateid": 1, "jd_jobmultiquoteid": 875, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "JBN817", "jd_jobstatus": 4, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "AJAY0001", "jd_invoiceno": "", "jd_listprice": "2264.25", "jd_netprice": "2264.25", "jd_vat": "67.92", "jd_isvaton": 1, "jd_deliverycost": "754.75", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 3, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "2332.17", "jd_grossprofit": "754.75", "jd_costprice": "1509.50", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "2332.17", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 1, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": "", "jd_endcustomeroverridenetprice": "1509.50", "jd_endcustomeroverridevatprice": "45.28", "jd_endcustomeroverridegrossprice": "1554.78", "jd_endcustomerdeliverycost": "", "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": "", "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 18, "jd_updatedby": 18, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "3.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":24,\"41\":18,\"44\":\"\",\"45\":\"Ajay Test\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":17,\"286\":\"0456465\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"521\":\"\",\"522\":\"\",\"523\":\"\",\"555\":\"\",\"586\":\"\",\"587\":\"\",\"588\":\"\",\"616\":\"\",\"617\":\"\",\"618\":18,\"625\":2,\"633\":\"\",\"634\":\"\",\"666\":\"\",\"667\":\"\",\"700\":\"\",\"701\":\"\",\"702\":1,\"703\":\"\",\"704\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "3.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "852", "jd_createddate": 1742860800, "jd_orderdate": 1742860800, "jd_duedate": 1742860800, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1742897475, "jd_updatedat": 1742897506 }, { "jd_id": 853, "jd_customerid": 599, "jd_contactid": 621, "jd_additionalcontacts": "621", "jd_templateid": 1, "jd_jobmultiquoteid": 876, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "JBN818", "jd_jobstatus": 4, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "AJAY0001", "jd_invoiceno": "", "jd_listprice": "2264.25", "jd_netprice": "2264.25", "jd_vat": "67.92", "jd_isvaton": 1, "jd_deliverycost": "754.75", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 3, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "2332.17", "jd_grossprofit": "754.75", "jd_costprice": "1509.50", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "2332.17", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 1, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": "", "jd_endcustomeroverridenetprice": "1509.50", "jd_endcustomeroverridevatprice": "45.28", "jd_endcustomeroverridegrossprice": "1554.78", "jd_endcustomerdeliverycost": "", "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": "", "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 18, "jd_updatedby": 18, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "3.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":24,\"41\":18,\"44\":\"\",\"45\":\"Ajay Test\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":17,\"286\":\"0456465\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"521\":\"\",\"522\":\"\",\"523\":\"\",\"555\":\"\",\"586\":\"\",\"587\":\"\",\"588\":\"\",\"616\":\"\",\"617\":\"\",\"618\":18,\"625\":2,\"633\":\"\",\"634\":\"\",\"666\":\"\",\"667\":\"\",\"700\":\"\",\"701\":\"\",\"702\":1,\"703\":\"\",\"704\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "3.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "853", "jd_createddate": 1742860800, "jd_orderdate": 1742860800, "jd_duedate": 1742860800, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1742897656, "jd_updatedat": 1742897676 }, { "jd_id": 854, "jd_customerid": 600, "jd_contactid": 622, "jd_additionalcontacts": "622", "jd_templateid": 1, "jd_jobmultiquoteid": 877, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "JBN819", "jd_jobstatus": 4, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "SDSD0005", "jd_invoiceno": "", "jd_listprice": "2264.25", "jd_netprice": "2264.25", "jd_vat": "67.92", "jd_isvaton": 1, "jd_deliverycost": "754.75", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 3, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "2332.17", "jd_grossprofit": "754.75", "jd_costprice": "1509.50", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "2332.17", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 1, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": "", "jd_endcustomeroverridenetprice": "1509.50", "jd_endcustomeroverridevatprice": "45.28", "jd_endcustomeroverridegrossprice": "1554.78", "jd_endcustomerdeliverycost": "", "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": "", "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 18, "jd_updatedby": 18, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "3.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":24,\"41\":18,\"44\":\"\",\"45\":\"Sdsdsd\",\"46\":\"Sdsd\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":17,\"286\":\"0465465456\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"521\":\"\",\"522\":\"\",\"523\":\"\",\"555\":\"\",\"586\":\"\",\"587\":\"\",\"588\":\"\",\"616\":\"\",\"617\":\"\",\"618\":18,\"625\":2,\"633\":\"\",\"634\":\"\",\"666\":\"\",\"667\":\"\",\"700\":\"\",\"701\":\"\",\"702\":1,\"703\":\"\",\"704\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "3.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "854", "jd_createddate": 1742860800, "jd_orderdate": 1742860800, "jd_duedate": 1742860800, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1742898301, "jd_updatedat": 1742898355 }, { "jd_id": 855, "jd_customerid": 600, "jd_contactid": 622, "jd_additionalcontacts": "622", "jd_templateid": 1, "jd_jobmultiquoteid": 878, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "JBN820", "jd_jobstatus": 16, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "SDSD0005", "jd_invoiceno": "", "jd_listprice": "2264.25", "jd_netprice": "2264.25", "jd_vat": "67.92", "jd_isvaton": 1, "jd_deliverycost": "754.75", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 3, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "2332.17", "jd_grossprofit": "754.75", "jd_costprice": "1509.50", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "2332.17", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 1, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": "", "jd_endcustomeroverridenetprice": "1509.50", "jd_endcustomeroverridevatprice": "45.28", "jd_endcustomeroverridegrossprice": "1554.78", "jd_endcustomerdeliverycost": "", "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": "", "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 18, "jd_updatedby": 18, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "3.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":24,\"41\":18,\"44\":\"\",\"45\":\"Sdsdsd\",\"46\":\"Sdsd\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":17,\"286\":\"0465465456\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"521\":\"\",\"522\":\"\",\"523\":\"\",\"555\":\"\",\"586\":\"\",\"587\":\"\",\"588\":\"\",\"616\":\"\",\"617\":\"\",\"618\":18,\"625\":2,\"633\":\"\",\"634\":\"\",\"666\":\"\",\"667\":\"\",\"700\":\"\",\"701\":\"\",\"702\":1,\"703\":\"\",\"704\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "3.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "855", "jd_createddate": 1742860800, "jd_orderdate": 1742860800, "jd_duedate": 1742860800, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1742898444, "jd_updatedat": 1742898459 } ], "deleted": [] }, "bm_orderitem": { "created": [ { "oi_id": 2138, "oi_jobid": 852, "oi_jobtempid": "0", "oi_jobmultiquoteid": 875, "oi_productid": 38, "oi_recipeid": 38, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":2398,\"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\":2398,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":6493,\"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\":6493,\"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\":2399,\"labelname\":\"Supplier\",\"value\":21,\"valueid\":null,\"type\":17,\"optionid\":21,\"optionvalue\":[{\"id\":21,\"optionid\":21,\"optionname\":\"Live Source\",\"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\":2399,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":21,\"optionsvalue\":[{\"id\":21,\"optionid\":21,\"optionname\":\"Live Source\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":3126,\"labelname\":\"width\",\"value\":1500,\"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\":3126,\"subchild\":[],\"fieldInformation\":null,\"ruleoverride\":0,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3127,\"labelname\":\"drop\",\"value\":2000,\"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\":3127,\"subchild\":[],\"fieldInformation\":null,\"ruleoverride\":0,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2400,\"labelname\":\"Slat Colour\",\"value\":null,\"valueid\":null,\"type\":13,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Slat 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\":13,\"mandatory\":0,\"fieldname\":\"Slat Colour\",\"fieldid\":2400,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3125,\"labelname\":\"Blinds Slat Materials\",\"value\":null,\"valueid\":null,\"type\":20,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Blinds Slat Materials\",\"fabricorcolor\":2,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":20,\"mandatory\":0,\"fieldname\":\"Blinds Slat Materials\",\"fieldid\":3125,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7449,\"labelname\":\"Numeric 01\",\"value\":null,\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Numeric 01\",\"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\":6,\"mandatory\":0,\"fieldname\":\"Numeric 01\",\"fieldid\":7449,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7450,\"labelname\":\"Numeric 02\",\"value\":null,\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Numeric 02\",\"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\":6,\"mandatory\":0,\"fieldname\":\"Numeric 02\",\"fieldid\":7450,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7458,\"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\":0,\"showFieldOnCustomerPortal\":0,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Extras\",\"fieldid\":7458,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Supplier: Live Source, width: 1500, drop: 2000", "oi_reportdescription": "##Quantity: 1##,##Supplier: Live Source##,##width: 1500 mm##,##drop: 2000 mm##", "oi_reporttitles": "##Quantity:<\/br>##Supplier:<\/br>##width:<\/br>##drop:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":592,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":38,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":600,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":38,\"stockupdate\":0,\"fieldid\":9444,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Dimmer Emitter 4 Channels SOURCE\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":560,\"value\":\"1500.00\",\"formula\":\"width\",\"price\":\"1500.00\",\"recipeid\":38,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"1500.00\"}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[{\"link_id\":61,\"process_id\":29,\"product_id\":38,\"phc_id\":61,\"pd_id\":29,\"name\":\"Test\",\"phc_linkstations\":0,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":1,\"phc_domesticsellingprice\":\"9.50\",\"phc_contractsellingprice\":\"9.50\",\"phc_tradesellingprice\":\"9.50\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"9.50\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"9.50\",\"Hour\\\/mins\":\"-\",\"phc_processcostid\":1,\"markupprice\":\"9.50\",\"price\":\"0.00\"}]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"9.50\",\"cost_with_discount\":\"9.50\",\"cost_with_markup\":\"9.50\",\"gross_price\":\"9.79\",\"vat_price\":\"0.28\"}", "oi_pricecomesfrom_calculations": "[]", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "1509.500", "oi_netprice": "1509.500", "oi_pricesfromoperations": null, "oi_vatprice": "45.280", "oi_vatvalue": "3.000", "oi_vatselected": 3, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "1554.790", "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": "1509.500", "oi_endcustomeroverridevatprice": "45.280", "oi_endcustomeroverridegrossprice": "1554.780", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[2398, 6493, 2399, 3126, 3127, 2400, 3125, 7449, 7450, 7458]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "2138", "oi_productiondate": 1742917289, "oi_createdat": 1742917289, "oi_updatedat": 1742897494, "oi_createdby": 18, "oi_updatedby": null }, { "oi_id": 2139, "oi_jobid": 853, "oi_jobtempid": "0", "oi_jobmultiquoteid": 876, "oi_productid": 38, "oi_recipeid": 38, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":2398,\"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\":2398,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":6493,\"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\":6493,\"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\":2399,\"labelname\":\"Supplier\",\"value\":21,\"valueid\":null,\"type\":17,\"optionid\":21,\"optionvalue\":[{\"id\":21,\"optionid\":21,\"optionname\":\"Live Source\",\"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\":2399,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":21,\"optionsvalue\":[{\"id\":21,\"optionid\":21,\"optionname\":\"Live Source\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":3126,\"labelname\":\"width\",\"value\":1500,\"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\":3126,\"subchild\":[],\"fieldInformation\":null,\"ruleoverride\":0,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3127,\"labelname\":\"drop\",\"value\":2000,\"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\":3127,\"subchild\":[],\"fieldInformation\":null,\"ruleoverride\":0,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2400,\"labelname\":\"Slat Colour\",\"value\":null,\"valueid\":null,\"type\":13,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Slat 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\":13,\"mandatory\":0,\"fieldname\":\"Slat Colour\",\"fieldid\":2400,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3125,\"labelname\":\"Blinds Slat Materials\",\"value\":null,\"valueid\":null,\"type\":20,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Blinds Slat Materials\",\"fabricorcolor\":2,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":20,\"mandatory\":0,\"fieldname\":\"Blinds Slat Materials\",\"fieldid\":3125,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7449,\"labelname\":\"Numeric 01\",\"value\":null,\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Numeric 01\",\"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\":6,\"mandatory\":0,\"fieldname\":\"Numeric 01\",\"fieldid\":7449,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7450,\"labelname\":\"Numeric 02\",\"value\":null,\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Numeric 02\",\"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\":6,\"mandatory\":0,\"fieldname\":\"Numeric 02\",\"fieldid\":7450,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7458,\"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\":0,\"showFieldOnCustomerPortal\":0,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Extras\",\"fieldid\":7458,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Supplier: Live Source, width: 1500, drop: 2000", "oi_reportdescription": "##Quantity: 1##,##Supplier: Live Source##,##width: 1500 mm##,##drop: 2000 mm##", "oi_reporttitles": "##Quantity:<\/br>##Supplier:<\/br>##width:<\/br>##drop:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":592,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":38,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":600,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":38,\"stockupdate\":0,\"fieldid\":9444,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Dimmer Emitter 4 Channels SOURCE\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":560,\"value\":\"1500.00\",\"formula\":\"width\",\"price\":\"1500.00\",\"recipeid\":38,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"1500.00\"}]", "oi_operationstatus": "", "oi_scanstatus": "", "oi_operationworkroom_data": "[{\"link_id\":61,\"process_id\":29,\"product_id\":38,\"phc_id\":61,\"pd_id\":29,\"name\":\"Test\",\"phc_linkstations\":0,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":1,\"phc_domesticsellingprice\":\"9.50\",\"phc_contractsellingprice\":\"9.50\",\"phc_tradesellingprice\":\"9.50\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"9.50\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"9.50\",\"Hour\\\/mins\":\"-\",\"phc_processcostid\":1,\"markupprice\":\"9.50\",\"price\":\"0.00\"}]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"9.50\",\"cost_with_discount\":\"9.50\",\"cost_with_markup\":\"9.50\",\"gross_price\":\"9.79\",\"vat_price\":\"0.28\"}", "oi_pricecomesfrom_calculations": "[]", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "1509.500", "oi_netprice": "1509.500", "oi_pricesfromoperations": null, "oi_vatprice": "45.280", "oi_vatvalue": "3.000", "oi_vatselected": 3, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "1554.790", "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": 2138, "oi_isonlineorder": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "1509.500", "oi_endcustomeroverridevatprice": "45.280", "oi_endcustomeroverridegrossprice": "1554.780", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[2398, 6493, 2399, 3126, 3127, 2400, 3125, 7449, 7450, 7458]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "2139", "oi_productiondate": 1742917448, "oi_createdat": 1742917448, "oi_updatedat": 1742897656, "oi_createdby": 18, "oi_updatedby": 18 }, { "oi_id": 2140, "oi_jobid": 854, "oi_jobtempid": "0", "oi_jobmultiquoteid": 877, "oi_productid": 38, "oi_recipeid": 38, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":2398,\"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\":2398,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":6493,\"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\":6493,\"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\":2399,\"labelname\":\"Supplier\",\"value\":21,\"valueid\":null,\"type\":17,\"optionid\":21,\"optionvalue\":[{\"id\":21,\"optionid\":21,\"optionname\":\"Live Source\",\"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\":2399,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":21,\"optionsvalue\":[{\"id\":21,\"optionid\":21,\"optionname\":\"Live Source\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":3126,\"labelname\":\"width\",\"value\":1500,\"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\":3126,\"subchild\":[],\"fieldInformation\":null,\"ruleoverride\":0,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3127,\"labelname\":\"drop\",\"value\":2000,\"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\":3127,\"subchild\":[],\"fieldInformation\":null,\"ruleoverride\":0,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2400,\"labelname\":\"Slat Colour\",\"value\":null,\"valueid\":null,\"type\":13,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Slat 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\":13,\"mandatory\":0,\"fieldname\":\"Slat Colour\",\"fieldid\":2400,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3125,\"labelname\":\"Blinds Slat Materials\",\"value\":null,\"valueid\":null,\"type\":20,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Blinds Slat Materials\",\"fabricorcolor\":2,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":20,\"mandatory\":0,\"fieldname\":\"Blinds Slat Materials\",\"fieldid\":3125,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7449,\"labelname\":\"Numeric 01\",\"value\":null,\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Numeric 01\",\"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\":6,\"mandatory\":0,\"fieldname\":\"Numeric 01\",\"fieldid\":7449,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7450,\"labelname\":\"Numeric 02\",\"value\":null,\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Numeric 02\",\"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\":6,\"mandatory\":0,\"fieldname\":\"Numeric 02\",\"fieldid\":7450,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7458,\"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\":0,\"showFieldOnCustomerPortal\":0,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Extras\",\"fieldid\":7458,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Supplier: Live Source, width: 1500, drop: 2000", "oi_reportdescription": "##Quantity: 1##,##Supplier: Live Source##,##width: 1500 mm##,##drop: 2000 mm##", "oi_reporttitles": "##Quantity:<\/br>##Supplier:<\/br>##width:<\/br>##drop:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":592,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":38,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":600,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":38,\"stockupdate\":0,\"fieldid\":9444,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Dimmer Emitter 4 Channels SOURCE\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":560,\"value\":\"1500.00\",\"formula\":\"width\",\"price\":\"1500.00\",\"recipeid\":38,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"1500.00\"}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[{\"link_id\":61,\"process_id\":29,\"product_id\":38,\"phc_id\":61,\"pd_id\":29,\"name\":\"Test\",\"phc_linkstations\":0,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":1,\"phc_domesticsellingprice\":\"9.50\",\"phc_contractsellingprice\":\"9.50\",\"phc_tradesellingprice\":\"9.50\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"9.50\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"9.50\",\"Hour\\\/mins\":\"-\",\"phc_processcostid\":1,\"markupprice\":\"9.50\",\"price\":\"0.00\"}]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"9.50\",\"cost_with_discount\":\"9.50\",\"cost_with_markup\":\"9.50\",\"gross_price\":\"9.79\",\"vat_price\":\"0.28\"}", "oi_pricecomesfrom_calculations": "[]", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "1509.500", "oi_netprice": "1509.500", "oi_pricesfromoperations": null, "oi_vatprice": "45.280", "oi_vatvalue": "3.000", "oi_vatselected": 3, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "1554.790", "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": "1509.500", "oi_endcustomeroverridevatprice": "45.280", "oi_endcustomeroverridegrossprice": "1554.780", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[2398, 6493, 2399, 3126, 3127, 2400, 3125, 7449, 7450, 7458]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "2140", "oi_productiondate": 1742918111, "oi_createdat": 1742918111, "oi_updatedat": 1742898314, "oi_createdby": 18, "oi_updatedby": null }, { "oi_id": 2141, "oi_jobid": 855, "oi_jobtempid": "0", "oi_jobmultiquoteid": 878, "oi_productid": 38, "oi_recipeid": 38, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":2398,\"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\":2398,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":6493,\"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\":6493,\"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\":2399,\"labelname\":\"Supplier\",\"value\":21,\"valueid\":null,\"type\":17,\"optionid\":21,\"optionvalue\":[{\"id\":21,\"optionid\":21,\"optionname\":\"Live Source\",\"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\":2399,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":21,\"optionsvalue\":[{\"id\":21,\"optionid\":21,\"optionname\":\"Live Source\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":3126,\"labelname\":\"width\",\"value\":1500,\"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\":3126,\"subchild\":[],\"fieldInformation\":null,\"ruleoverride\":0,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3127,\"labelname\":\"drop\",\"value\":2000,\"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\":3127,\"subchild\":[],\"fieldInformation\":null,\"ruleoverride\":0,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2400,\"labelname\":\"Slat Colour\",\"value\":null,\"valueid\":null,\"type\":13,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Slat 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\":13,\"mandatory\":0,\"fieldname\":\"Slat Colour\",\"fieldid\":2400,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3125,\"labelname\":\"Blinds Slat Materials\",\"value\":null,\"valueid\":null,\"type\":20,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Blinds Slat Materials\",\"fabricorcolor\":2,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":20,\"mandatory\":0,\"fieldname\":\"Blinds Slat Materials\",\"fieldid\":3125,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7449,\"labelname\":\"Numeric 01\",\"value\":null,\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Numeric 01\",\"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\":6,\"mandatory\":0,\"fieldname\":\"Numeric 01\",\"fieldid\":7449,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7450,\"labelname\":\"Numeric 02\",\"value\":null,\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Numeric 02\",\"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\":6,\"mandatory\":0,\"fieldname\":\"Numeric 02\",\"fieldid\":7450,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7458,\"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\":0,\"showFieldOnCustomerPortal\":0,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Extras\",\"fieldid\":7458,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Supplier: Live Source, width: 1500, drop: 2000", "oi_reportdescription": "##Quantity: 1##,##Supplier: Live Source##,##width: 1500 mm##,##drop: 2000 mm##", "oi_reporttitles": "##Quantity:<\/br>##Supplier:<\/br>##width:<\/br>##drop:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":592,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":38,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":600,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":38,\"stockupdate\":0,\"fieldid\":9444,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Dimmer Emitter 4 Channels SOURCE\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":560,\"value\":\"1500.00\",\"formula\":\"width\",\"price\":\"1500.00\",\"recipeid\":38,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"1500.00\"}]", "oi_operationstatus": "", "oi_scanstatus": "", "oi_operationworkroom_data": "[{\"link_id\":61,\"process_id\":29,\"product_id\":38,\"phc_id\":61,\"pd_id\":29,\"name\":\"Test\",\"phc_linkstations\":0,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":1,\"phc_domesticsellingprice\":\"9.50\",\"phc_contractsellingprice\":\"9.50\",\"phc_tradesellingprice\":\"9.50\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"9.50\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"9.50\",\"Hour\\\/mins\":\"-\",\"phc_processcostid\":1,\"markupprice\":\"9.50\",\"price\":\"0.00\"}]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"9.50\",\"cost_with_discount\":\"9.50\",\"cost_with_markup\":\"9.50\",\"gross_price\":\"9.79\",\"vat_price\":\"0.28\"}", "oi_pricecomesfrom_calculations": "[]", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "1509.500", "oi_netprice": "1509.500", "oi_pricesfromoperations": null, "oi_vatprice": "45.280", "oi_vatvalue": "3.000", "oi_vatselected": 3, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "1554.790", "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": 2140, "oi_isonlineorder": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "1509.500", "oi_endcustomeroverridevatprice": "45.280", "oi_endcustomeroverridegrossprice": "1554.780", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[2398, 6493, 2399, 3126, 3127, 2400, 3125, 7449, 7450, 7458]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "2141", "oi_productiondate": 1742918238, "oi_createdat": 1742918238, "oi_updatedat": 1742898444, "oi_createdby": 18, "oi_updatedby": 18 } ], "updated": [ { "oi_id": 2139, "oi_jobid": 853, "oi_jobtempid": "0", "oi_jobmultiquoteid": 876, "oi_productid": 38, "oi_recipeid": 38, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":2398,\"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\":2398,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":6493,\"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\":6493,\"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\":2399,\"labelname\":\"Supplier\",\"value\":21,\"valueid\":null,\"type\":17,\"optionid\":21,\"optionvalue\":[{\"id\":21,\"optionid\":21,\"optionname\":\"Live Source\",\"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\":2399,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":21,\"optionsvalue\":[{\"id\":21,\"optionid\":21,\"optionname\":\"Live Source\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":3126,\"labelname\":\"width\",\"value\":1500,\"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\":3126,\"subchild\":[],\"fieldInformation\":null,\"ruleoverride\":0,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3127,\"labelname\":\"drop\",\"value\":2000,\"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\":3127,\"subchild\":[],\"fieldInformation\":null,\"ruleoverride\":0,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2400,\"labelname\":\"Slat Colour\",\"value\":null,\"valueid\":null,\"type\":13,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Slat 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\":13,\"mandatory\":0,\"fieldname\":\"Slat Colour\",\"fieldid\":2400,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3125,\"labelname\":\"Blinds Slat Materials\",\"value\":null,\"valueid\":null,\"type\":20,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Blinds Slat Materials\",\"fabricorcolor\":2,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":20,\"mandatory\":0,\"fieldname\":\"Blinds Slat Materials\",\"fieldid\":3125,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7449,\"labelname\":\"Numeric 01\",\"value\":null,\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Numeric 01\",\"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\":6,\"mandatory\":0,\"fieldname\":\"Numeric 01\",\"fieldid\":7449,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7450,\"labelname\":\"Numeric 02\",\"value\":null,\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Numeric 02\",\"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\":6,\"mandatory\":0,\"fieldname\":\"Numeric 02\",\"fieldid\":7450,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7458,\"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\":0,\"showFieldOnCustomerPortal\":0,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Extras\",\"fieldid\":7458,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Supplier: Live Source, width: 1500, drop: 2000", "oi_reportdescription": "##Quantity: 1##,##Supplier: Live Source##,##width: 1500 mm##,##drop: 2000 mm##", "oi_reporttitles": "##Quantity:<\/br>##Supplier:<\/br>##width:<\/br>##drop:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":592,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":38,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":600,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":38,\"stockupdate\":0,\"fieldid\":9444,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Dimmer Emitter 4 Channels SOURCE\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":560,\"value\":\"1500.00\",\"formula\":\"width\",\"price\":\"1500.00\",\"recipeid\":38,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"1500.00\"}]", "oi_operationstatus": "", "oi_scanstatus": "", "oi_operationworkroom_data": "[{\"link_id\":61,\"process_id\":29,\"product_id\":38,\"phc_id\":61,\"pd_id\":29,\"name\":\"Test\",\"phc_linkstations\":0,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":1,\"phc_domesticsellingprice\":\"9.50\",\"phc_contractsellingprice\":\"9.50\",\"phc_tradesellingprice\":\"9.50\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"9.50\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"9.50\",\"Hour\\\/mins\":\"-\",\"phc_processcostid\":1,\"markupprice\":\"9.50\",\"price\":\"0.00\"}]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"9.50\",\"cost_with_discount\":\"9.50\",\"cost_with_markup\":\"9.50\",\"gross_price\":\"9.79\",\"vat_price\":\"0.28\"}", "oi_pricecomesfrom_calculations": "[]", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "1509.500", "oi_netprice": "1509.500", "oi_pricesfromoperations": null, "oi_vatprice": "45.280", "oi_vatvalue": "3.000", "oi_vatselected": 3, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "1554.790", "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": 2138, "oi_isonlineorder": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "1509.500", "oi_endcustomeroverridevatprice": "45.280", "oi_endcustomeroverridegrossprice": "1554.780", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[2398, 6493, 2399, 3126, 3127, 2400, 3125, 7449, 7450, 7458]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "2139", "oi_productiondate": 1742917448, "oi_createdat": 1742917448, "oi_updatedat": 1742897656, "oi_createdby": 18, "oi_updatedby": 18 }, { "oi_id": 2141, "oi_jobid": 855, "oi_jobtempid": "0", "oi_jobmultiquoteid": 878, "oi_productid": 38, "oi_recipeid": 38, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":2398,\"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\":2398,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":6493,\"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\":6493,\"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\":2399,\"labelname\":\"Supplier\",\"value\":21,\"valueid\":null,\"type\":17,\"optionid\":21,\"optionvalue\":[{\"id\":21,\"optionid\":21,\"optionname\":\"Live Source\",\"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\":2399,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":21,\"optionsvalue\":[{\"id\":21,\"optionid\":21,\"optionname\":\"Live Source\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":3126,\"labelname\":\"width\",\"value\":1500,\"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\":3126,\"subchild\":[],\"fieldInformation\":null,\"ruleoverride\":0,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3127,\"labelname\":\"drop\",\"value\":2000,\"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\":3127,\"subchild\":[],\"fieldInformation\":null,\"ruleoverride\":0,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2400,\"labelname\":\"Slat Colour\",\"value\":null,\"valueid\":null,\"type\":13,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Slat 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\":13,\"mandatory\":0,\"fieldname\":\"Slat Colour\",\"fieldid\":2400,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3125,\"labelname\":\"Blinds Slat Materials\",\"value\":null,\"valueid\":null,\"type\":20,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Blinds Slat Materials\",\"fabricorcolor\":2,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":20,\"mandatory\":0,\"fieldname\":\"Blinds Slat Materials\",\"fieldid\":3125,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7449,\"labelname\":\"Numeric 01\",\"value\":null,\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Numeric 01\",\"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\":6,\"mandatory\":0,\"fieldname\":\"Numeric 01\",\"fieldid\":7449,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7450,\"labelname\":\"Numeric 02\",\"value\":null,\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Numeric 02\",\"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\":6,\"mandatory\":0,\"fieldname\":\"Numeric 02\",\"fieldid\":7450,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7458,\"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\":0,\"showFieldOnCustomerPortal\":0,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Extras\",\"fieldid\":7458,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Supplier: Live Source, width: 1500, drop: 2000", "oi_reportdescription": "##Quantity: 1##,##Supplier: Live Source##,##width: 1500 mm##,##drop: 2000 mm##", "oi_reporttitles": "##Quantity:<\/br>##Supplier:<\/br>##width:<\/br>##drop:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":592,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":38,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":600,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":38,\"stockupdate\":0,\"fieldid\":9444,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Dimmer Emitter 4 Channels SOURCE\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":560,\"value\":\"1500.00\",\"formula\":\"width\",\"price\":\"1500.00\",\"recipeid\":38,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"1500.00\"}]", "oi_operationstatus": "", "oi_scanstatus": "", "oi_operationworkroom_data": "[{\"link_id\":61,\"process_id\":29,\"product_id\":38,\"phc_id\":61,\"pd_id\":29,\"name\":\"Test\",\"phc_linkstations\":0,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":1,\"phc_domesticsellingprice\":\"9.50\",\"phc_contractsellingprice\":\"9.50\",\"phc_tradesellingprice\":\"9.50\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"9.50\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"9.50\",\"Hour\\\/mins\":\"-\",\"phc_processcostid\":1,\"markupprice\":\"9.50\",\"price\":\"0.00\"}]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"9.50\",\"cost_with_discount\":\"9.50\",\"cost_with_markup\":\"9.50\",\"gross_price\":\"9.79\",\"vat_price\":\"0.28\"}", "oi_pricecomesfrom_calculations": "[]", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "1509.500", "oi_netprice": "1509.500", "oi_pricesfromoperations": null, "oi_vatprice": "45.280", "oi_vatvalue": "3.000", "oi_vatselected": 3, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "1554.790", "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": 2140, "oi_isonlineorder": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "1509.500", "oi_endcustomeroverridevatprice": "45.280", "oi_endcustomeroverridegrossprice": "1554.780", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[2398, 6493, 2399, 3126, 3127, 2400, 3125, 7449, 7450, 7458]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "2141", "oi_productiondate": 1742918238, "oi_createdat": 1742918238, "oi_updatedat": 1742898444, "oi_createdby": 18, "oi_updatedby": 18 } ], "deleted": [] }, "bm_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_notelist": { "created": [], "updated": [], "deleted": [] }, "bm_deliveryaddresssetting": { "created": [ { "das_id": 613, "das_jobid": 851, "das_appointmentaddress": 620, "das_invoiceaddress": 620, "das_invoicedeliveryaddress": 0, "das_purchaseaddress": 0, "das_worksheetaddress": 0, "id": "613", "das_createdat": 1742895955, "das_updatedat": 1742895955, "das_createdby": 18, "das_updatedby": null }, { "das_id": 614, "das_jobid": 852, "das_appointmentaddress": 621, "das_invoiceaddress": 621, "das_invoicedeliveryaddress": 0, "das_purchaseaddress": 0, "das_worksheetaddress": 0, "id": "614", "das_createdat": 1742897475, "das_updatedat": 1742897475, "das_createdby": 18, "das_updatedby": null }, { "das_id": 615, "das_jobid": 853, "das_appointmentaddress": 621, "das_invoiceaddress": 621, "das_invoicedeliveryaddress": 0, "das_purchaseaddress": 0, "das_worksheetaddress": 0, "id": "615", "das_createdat": 1742897656, "das_updatedat": 1742897656, "das_createdby": 18, "das_updatedby": null }, { "das_id": 616, "das_jobid": 854, "das_appointmentaddress": 622, "das_invoiceaddress": 622, "das_invoicedeliveryaddress": 0, "das_purchaseaddress": 0, "das_worksheetaddress": 0, "id": "616", "das_createdat": 1742898302, "das_updatedat": 1742898302, "das_createdby": 18, "das_updatedby": null }, { "das_id": 617, "das_jobid": 855, "das_appointmentaddress": 622, "das_invoiceaddress": 622, "das_invoicedeliveryaddress": 0, "das_purchaseaddress": 0, "das_worksheetaddress": 0, "id": "617", "das_createdat": 1742898444, "das_updatedat": 1742898444, "das_createdby": 18, "das_updatedby": null } ], "updated": [], "deleted": [] }, "bm_jobchecklist": { "created": [], "updated": [], "deleted": [] }, "bm_Invoice": { "created": [], "updated": [], "deleted": [] }, "bm_InvoiceDetails": { "created": [], "updated": [], "deleted": [] }, "bm_invoice_credit_note": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNote": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNoteDetails": { "created": [], "updated": [], "deleted": [] }, "bm_job_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_OverPayment": { "created": [], "updated": [], "deleted": [] }, "bm_terms": { "created": [], "updated": [], "deleted": [] }, "bm_jobmultiquote": { "created": [ { "jmq_id": 874, "jmq_jobid": 851, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "0.00", "jmq_netprice": "0.00", "jmq_vat": "0.00", "jmq_isvaton": 1, "jmq_deliverycost": "0.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 3, "jmq_orderformprice": "0.00", "jmq_editpricebyid": 0, "jmq_isroundon": 0, "jmq_grossprice": "0.00", "jmq_grossprofit": "0.00", "jmq_costprice": "0.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "0.00", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": null, "jmq_deliverycostid": 1, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 1, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 1, "jmq_endcustomeroverridevalue": null, "jmq_endcustomeroverridenetprice": "0.00", "jmq_endcustomeroverridevatprice": "0.00", "jmq_endcustomeroverridegrossprice": "0.00", "jmq_endcustomerdeliverycost": null, "jmq_endcustomerdeliverycostinclvat": 1, "jmq_endcustomerfittingcost": null, "jmq_endcustomerfittingcostinclvat": 1, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "3.000", "jmq_cdeliveryvatperc": "3.000", "id": "874", "jmq_duedate": null, "jmq_sceduleddate": null, "jmq_createdat": "1742895955.000000", "jmq_updatedat": "1742895955.000000", "jmq_createdby": 18, "jmq_updatedby": null }, { "jmq_id": 875, "jmq_jobid": 852, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "2264.25", "jmq_netprice": "2264.25", "jmq_vat": "67.92", "jmq_isvaton": 1, "jmq_deliverycost": "754.75", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 3, "jmq_orderformprice": "0.00", "jmq_editpricebyid": 0, "jmq_isroundon": 0, "jmq_grossprice": "2332.17", "jmq_grossprofit": "754.75", "jmq_costprice": "1509.50", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "2332.17", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": "\"\"", "jmq_deliverycostid": 1, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 1, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 1, "jmq_endcustomeroverridevalue": "", "jmq_endcustomeroverridenetprice": "1509.50", "jmq_endcustomeroverridevatprice": "45.28", "jmq_endcustomeroverridegrossprice": "1554.78", "jmq_endcustomerdeliverycost": "", "jmq_endcustomerdeliverycostinclvat": 1, "jmq_endcustomerfittingcost": "", "jmq_endcustomerfittingcostinclvat": 1, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "3.000", "jmq_cdeliveryvatperc": "3.000", "id": "875", "jmq_duedate": 1742860800, "jmq_sceduleddate": null, "jmq_createdat": "1742897475.000000", "jmq_updatedat": "1742897506.000000", "jmq_createdby": 18, "jmq_updatedby": 18 }, { "jmq_id": 876, "jmq_jobid": 853, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "2264.25", "jmq_netprice": "2264.25", "jmq_vat": "67.92", "jmq_isvaton": 1, "jmq_deliverycost": "754.75", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 3, "jmq_orderformprice": "0.00", "jmq_editpricebyid": 0, "jmq_isroundon": 0, "jmq_grossprice": "2332.17", "jmq_grossprofit": "754.75", "jmq_costprice": "1509.50", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "2332.17", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": "\"\"", "jmq_deliverycostid": 1, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 1, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 1, "jmq_endcustomeroverridevalue": "", "jmq_endcustomeroverridenetprice": "1509.50", "jmq_endcustomeroverridevatprice": "45.28", "jmq_endcustomeroverridegrossprice": "1554.78", "jmq_endcustomerdeliverycost": "", "jmq_endcustomerdeliverycostinclvat": 1, "jmq_endcustomerfittingcost": "", "jmq_endcustomerfittingcostinclvat": 1, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "3.000", "jmq_cdeliveryvatperc": "3.000", "id": "876", "jmq_duedate": 1742860800, "jmq_sceduleddate": null, "jmq_createdat": "1742897656.000000", "jmq_updatedat": "1742897676.000000", "jmq_createdby": 18, "jmq_updatedby": 18 }, { "jmq_id": 877, "jmq_jobid": 854, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "2264.25", "jmq_netprice": "2264.25", "jmq_vat": "67.92", "jmq_isvaton": 1, "jmq_deliverycost": "754.75", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 3, "jmq_orderformprice": "0.00", "jmq_editpricebyid": 0, "jmq_isroundon": 0, "jmq_grossprice": "2332.17", "jmq_grossprofit": "754.75", "jmq_costprice": "1509.50", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "2332.17", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": "\"\"", "jmq_deliverycostid": 1, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 1, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 1, "jmq_endcustomeroverridevalue": "", "jmq_endcustomeroverridenetprice": "1509.50", "jmq_endcustomeroverridevatprice": "45.28", "jmq_endcustomeroverridegrossprice": "1554.78", "jmq_endcustomerdeliverycost": "", "jmq_endcustomerdeliverycostinclvat": 1, "jmq_endcustomerfittingcost": "", "jmq_endcustomerfittingcostinclvat": 1, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "3.000", "jmq_cdeliveryvatperc": "3.000", "id": "877", "jmq_duedate": 1742860800, "jmq_sceduleddate": null, "jmq_createdat": "1742898301.000000", "jmq_updatedat": "1742898301.000000", "jmq_createdby": 18, "jmq_updatedby": 18 }, { "jmq_id": 878, "jmq_jobid": 855, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "2264.25", "jmq_netprice": "2264.25", "jmq_vat": "67.92", "jmq_isvaton": 1, "jmq_deliverycost": "754.75", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 3, "jmq_orderformprice": "0.00", "jmq_editpricebyid": 0, "jmq_isroundon": 0, "jmq_grossprice": "2332.17", "jmq_grossprofit": "754.75", "jmq_costprice": "1509.50", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "2332.17", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": "\"\"", "jmq_deliverycostid": 1, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 1, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 1, "jmq_endcustomeroverridevalue": "", "jmq_endcustomeroverridenetprice": "1509.50", "jmq_endcustomeroverridevatprice": "45.28", "jmq_endcustomeroverridegrossprice": "1554.78", "jmq_endcustomerdeliverycost": "", "jmq_endcustomerdeliverycostinclvat": 1, "jmq_endcustomerfittingcost": "", "jmq_endcustomerfittingcostinclvat": 1, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "3.000", "jmq_cdeliveryvatperc": "3.000", "id": "878", "jmq_duedate": 1742860800, "jmq_sceduleddate": null, "jmq_createdat": "1742898444.000000", "jmq_updatedat": "1742898460.000000", "jmq_createdby": 18, "jmq_updatedby": 18 } ], "updated": [ { "jmq_id": 875, "jmq_jobid": 852, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "2264.25", "jmq_netprice": "2264.25", "jmq_vat": "67.92", "jmq_isvaton": 1, "jmq_deliverycost": "754.75", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 3, "jmq_orderformprice": "0.00", "jmq_editpricebyid": 0, "jmq_isroundon": 0, "jmq_grossprice": "2332.17", "jmq_grossprofit": "754.75", "jmq_costprice": "1509.50", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "2332.17", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": "\"\"", "jmq_deliverycostid": 1, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 1, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 1, "jmq_endcustomeroverridevalue": "", "jmq_endcustomeroverridenetprice": "1509.50", "jmq_endcustomeroverridevatprice": "45.28", "jmq_endcustomeroverridegrossprice": "1554.78", "jmq_endcustomerdeliverycost": "", "jmq_endcustomerdeliverycostinclvat": 1, "jmq_endcustomerfittingcost": "", "jmq_endcustomerfittingcostinclvat": 1, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "3.000", "jmq_cdeliveryvatperc": "3.000", "id": "875", "jmq_duedate": 1742860800, "jmq_sceduleddate": null, "jmq_createdat": "1742897475.000000", "jmq_updatedat": "1742897506.000000", "jmq_createdby": 18, "jmq_updatedby": 18 }, { "jmq_id": 876, "jmq_jobid": 853, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "2264.25", "jmq_netprice": "2264.25", "jmq_vat": "67.92", "jmq_isvaton": 1, "jmq_deliverycost": "754.75", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 3, "jmq_orderformprice": "0.00", "jmq_editpricebyid": 0, "jmq_isroundon": 0, "jmq_grossprice": "2332.17", "jmq_grossprofit": "754.75", "jmq_costprice": "1509.50", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "2332.17", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": "\"\"", "jmq_deliverycostid": 1, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 1, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 1, "jmq_endcustomeroverridevalue": "", "jmq_endcustomeroverridenetprice": "1509.50", "jmq_endcustomeroverridevatprice": "45.28", "jmq_endcustomeroverridegrossprice": "1554.78", "jmq_endcustomerdeliverycost": "", "jmq_endcustomerdeliverycostinclvat": 1, "jmq_endcustomerfittingcost": "", "jmq_endcustomerfittingcostinclvat": 1, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "3.000", "jmq_cdeliveryvatperc": "3.000", "id": "876", "jmq_duedate": 1742860800, "jmq_sceduleddate": null, "jmq_createdat": "1742897656.000000", "jmq_updatedat": "1742897676.000000", "jmq_createdby": 18, "jmq_updatedby": 18 }, { "jmq_id": 877, "jmq_jobid": 854, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "2264.25", "jmq_netprice": "2264.25", "jmq_vat": "67.92", "jmq_isvaton": 1, "jmq_deliverycost": "754.75", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 3, "jmq_orderformprice": "0.00", "jmq_editpricebyid": 0, "jmq_isroundon": 0, "jmq_grossprice": "2332.17", "jmq_grossprofit": "754.75", "jmq_costprice": "1509.50", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "2332.17", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": "\"\"", "jmq_deliverycostid": 1, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 1, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 1, "jmq_endcustomeroverridevalue": "", "jmq_endcustomeroverridenetprice": "1509.50", "jmq_endcustomeroverridevatprice": "45.28", "jmq_endcustomeroverridegrossprice": "1554.78", "jmq_endcustomerdeliverycost": "", "jmq_endcustomerdeliverycostinclvat": 1, "jmq_endcustomerfittingcost": "", "jmq_endcustomerfittingcostinclvat": 1, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "3.000", "jmq_cdeliveryvatperc": "3.000", "id": "877", "jmq_duedate": 1742860800, "jmq_sceduleddate": null, "jmq_createdat": "1742898301.000000", "jmq_updatedat": "1742898301.000000", "jmq_createdby": 18, "jmq_updatedby": 18 }, { "jmq_id": 878, "jmq_jobid": 855, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "2264.25", "jmq_netprice": "2264.25", "jmq_vat": "67.92", "jmq_isvaton": 1, "jmq_deliverycost": "754.75", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 3, "jmq_orderformprice": "0.00", "jmq_editpricebyid": 0, "jmq_isroundon": 0, "jmq_grossprice": "2332.17", "jmq_grossprofit": "754.75", "jmq_costprice": "1509.50", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "2332.17", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": "\"\"", "jmq_deliverycostid": 1, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 1, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 1, "jmq_endcustomeroverridevalue": "", "jmq_endcustomeroverridenetprice": "1509.50", "jmq_endcustomeroverridevatprice": "45.28", "jmq_endcustomeroverridegrossprice": "1554.78", "jmq_endcustomerdeliverycost": "", "jmq_endcustomerdeliverycostinclvat": 1, "jmq_endcustomerfittingcost": "", "jmq_endcustomerfittingcostinclvat": 1, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "3.000", "jmq_cdeliveryvatperc": "3.000", "id": "878", "jmq_duedate": 1742860800, "jmq_sceduleddate": null, "jmq_createdat": "1742898444.000000", "jmq_updatedat": "1742898460.000000", "jmq_createdby": 18, "jmq_updatedby": 18 } ], "deleted": [] }, "bm_jobstatus_tracks": { "created": [ { "jst_id": 902, "jst_jobid": 850, "jst_job_current_status": 3, "id": "902", "jst_createdat": "1742895219.341599" }, { "jst_id": 903, "jst_jobid": 851, "jst_job_current_status": 3, "id": "903", "jst_createdat": "1742895955.691613" }, { "jst_id": 904, "jst_jobid": 852, "jst_job_current_status": 3, "id": "904", "jst_createdat": "1742897475.699546" }, { "jst_id": 905, "jst_jobid": 852, "jst_job_current_status": 4, "id": "905", "jst_createdat": "1742897506.571628" }, { "jst_id": 906, "jst_jobid": 853, "jst_job_current_status": 3, "id": "906", "jst_createdat": "1742897656.584679" }, { "jst_id": 907, "jst_jobid": 853, "jst_job_current_status": 4, "id": "907", "jst_createdat": "1742897676.488591" }, { "jst_id": 908, "jst_jobid": 854, "jst_job_current_status": 3, "id": "908", "jst_createdat": "1742898302.277154" }, { "jst_id": 909, "jst_jobid": 854, "jst_job_current_status": 1, "id": "909", "jst_createdat": "1742898331.184091" }, { "jst_id": 910, "jst_jobid": 854, "jst_job_current_status": 4, "id": "910", "jst_createdat": "1742898355.670921" }, { "jst_id": 911, "jst_jobid": 855, "jst_job_current_status": 3, "id": "911", "jst_createdat": "1742898444.253056" }, { "jst_id": 912, "jst_jobid": 855, "jst_job_current_status": 16, "id": "912", "jst_createdat": "1742898459.995683" } ], "updated": [], "deleted": [] }, "bm_customindividuallogs": { "created": [ { "cl_id": 17848, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 851, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 851, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"BlindMatrix\",\"Account Type\":\"Domestic\",\"Source\":\"Linked In\",\"Created By\":\"Leo\",\"Company Name\":\"Dfdfds\",\"Country\":\"Australia\",\"Salutation\":\"Hap\",\"Phone\":\"04564564\",\"Check Box\":\"Disabled\",\"Date & Time1\":\"03-25-2025 09:45:55\",\"Assigned to\":18,\"Role\":2,\"Date1\":\"2025-03-25\",\"Delivery date1\":\"2025-03-25\",\"Rework date\":\"2025-03-25\",\"Additional Contacts\":\"620\",\"Job Status\":\"Quote\",\"Order Status\":\"Order1\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"jd_isonlineorder\":1,\"End Customer Override Type\":1,\"End Customer Delivery Cost Include Vat\":1,\"End Customer Fitting Cost Include Vat\":1,\"Delivery Vat Percentage\":\"3.000\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":851,\"jd_customerid\":598,\"jd_contactid\":620,\"jd_additionalcontacts\":\"620\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"33\\\":25,\\\"37\\\":1,\\\"39\\\":24,\\\"41\\\":18,\\\"44\\\":\\\"Dfdfds\\\",\\\"45\\\":\\\"\\\",\\\"46\\\":\\\"\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":4,\\\"285\\\":17,\\\"286\\\":\\\"04564564\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"521\\\":\\\"\\\",\\\"522\\\":\\\"\\\",\\\"523\\\":\\\"\\\",\\\"555\\\":\\\"\\\",\\\"586\\\":\\\"\\\",\\\"587\\\":\\\"\\\",\\\"588\\\":\\\"\\\",\\\"616\\\":\\\"\\\",\\\"617\\\":\\\"\\\",\\\"618\\\":18,\\\"625\\\":2,\\\"633\\\":\\\"\\\",\\\"634\\\":\\\"\\\",\\\"666\\\":\\\"\\\",\\\"667\\\":\\\"\\\",\\\"700\\\":\\\"\\\",\\\"701\\\":\\\"\\\",\\\"702\\\":1,\\\"703\\\":\\\"\\\",\\\"704\\\":\\\"\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-03-25\",\"jd_orderdate\":\"0000-00-00\",\"jd_duedate\":\"0000-00-00\",\"jd_sceduleddate\":\"0000-00-00\",\"jd_invoicedate\":\"0000-00-00\",\"jd_completeddate\":\"0000-00-00\",\"jd_jobref\":null,\"jd_jobstatus\":3,\"jd_contactaddid\":0,\"jd_orderstatus\":1,\"jd_accref\":\"\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"0.00\",\"jd_netprice\":\"0.00\",\"jd_vat\":\"0.00\",\"jd_isvaton\":1,\"jd_deliverycost\":\"0.00\",\"jd_deliverycosttypeid\":1,\"jd_overridetypeid\":3,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":0,\"jd_isroundon\":0,\"jd_grossprice\":\"0.00\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"0.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"0.00\",\"jd_totpaid\":\"0.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":\"\\\"\\\"\",\"jd_deliverycostid\":1,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":1,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":1,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":1,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":null,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":18,\"jd_createdat\":\"2025-03-25T09:45:55.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-03-25T09:45:55.000000Z\",\"jd_deviceplatform\":0,\"jd_fromjobref\":\"\",\"jd_fromdbname\":null,\"jd_importorder\":0,\"jd_quickquote\":0,\"jd_myob_flag\":0,\"jd_myobinvoiceid\":\"\",\"jd_qboflag\":0,\"jd_qboinvoiceid\":0,\"jd_qbodisplayname\":\"\",\"jd_deliveryvatperc\":\"3.000\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"3.000\",\"jd_commission\":\"[]\",\"jd_commissionprice\":\"0.00\",\"jd_commissionsetting\":0,\"jd_commissionaddedvalue\":\"0.00\",\"jd_onlineprefixseq\":\"\",\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":0,\"jd_rework_count\":0}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17848", "cl_createdat": "1742895955.000000", "cl_updatedat": null }, { "cl_id": 17853, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 852, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 852, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"BlindMatrix Test\",\"Account Type\":\"Domestic\",\"Source\":\"Linked In\",\"Created By\":\"Leo\",\"First Name\":\"Ajay Test\",\"Country\":\"Australia\",\"Salutation\":\"Hap\",\"Phone\":\"0456465\",\"Check Box\":\"Disabled\",\"Date & Time1\":\"03-25-2025 10:11:15\",\"Assigned to\":18,\"Role\":2,\"Date1\":\"2025-03-25\",\"Delivery date1\":\"2025-03-25\",\"Rework date\":\"2025-03-25\",\"Additional Contacts\":\"621\",\"Job Status\":\"Quote\",\"Order Status\":\"Order1\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"jd_isonlineorder\":1,\"End Customer Override Type\":1,\"End Customer Delivery Cost Include Vat\":1,\"End Customer Fitting Cost Include Vat\":1,\"Delivery Vat Percentage\":\"3.000\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":852,\"jd_customerid\":599,\"jd_contactid\":621,\"jd_additionalcontacts\":\"621\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"33\\\":25,\\\"37\\\":1,\\\"39\\\":24,\\\"41\\\":18,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"Ajay Test\\\",\\\"46\\\":\\\"\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":4,\\\"285\\\":17,\\\"286\\\":\\\"0456465\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"521\\\":\\\"\\\",\\\"522\\\":\\\"\\\",\\\"523\\\":\\\"\\\",\\\"555\\\":\\\"\\\",\\\"586\\\":\\\"\\\",\\\"587\\\":\\\"\\\",\\\"588\\\":\\\"\\\",\\\"616\\\":\\\"\\\",\\\"617\\\":\\\"\\\",\\\"618\\\":18,\\\"625\\\":2,\\\"633\\\":\\\"\\\",\\\"634\\\":\\\"\\\",\\\"666\\\":\\\"\\\",\\\"667\\\":\\\"\\\",\\\"700\\\":\\\"\\\",\\\"701\\\":\\\"\\\",\\\"702\\\":1,\\\"703\\\":\\\"\\\",\\\"704\\\":\\\"\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-03-25\",\"jd_orderdate\":\"0000-00-00\",\"jd_duedate\":\"0000-00-00\",\"jd_sceduleddate\":\"0000-00-00\",\"jd_invoicedate\":\"0000-00-00\",\"jd_completeddate\":\"0000-00-00\",\"jd_jobref\":null,\"jd_jobstatus\":3,\"jd_contactaddid\":0,\"jd_orderstatus\":1,\"jd_accref\":\"\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"0.00\",\"jd_netprice\":\"0.00\",\"jd_vat\":\"0.00\",\"jd_isvaton\":1,\"jd_deliverycost\":\"0.00\",\"jd_deliverycosttypeid\":1,\"jd_overridetypeid\":3,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":0,\"jd_isroundon\":0,\"jd_grossprice\":\"0.00\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"0.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"0.00\",\"jd_totpaid\":\"0.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":\"\\\"\\\"\",\"jd_deliverycostid\":1,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":1,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":1,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":1,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":null,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":18,\"jd_createdat\":\"2025-03-25T10:11:15.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-03-25T10:11:15.000000Z\",\"jd_deviceplatform\":0,\"jd_fromjobref\":\"\",\"jd_fromdbname\":null,\"jd_importorder\":0,\"jd_quickquote\":0,\"jd_myob_flag\":0,\"jd_myobinvoiceid\":\"\",\"jd_qboflag\":0,\"jd_qboinvoiceid\":0,\"jd_qbodisplayname\":\"\",\"jd_deliveryvatperc\":\"3.000\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"3.000\",\"jd_commission\":\"[]\",\"jd_commissionprice\":\"0.00\",\"jd_commissionsetting\":0,\"jd_commissionaddedvalue\":\"0.00\",\"jd_onlineprefixseq\":\"\",\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":0,\"jd_rework_count\":0}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17853", "cl_createdat": "1742897475.000000", "cl_updatedat": null }, { "cl_id": 17857, "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 Wooden Venetians", "cl_event": "created", "cl_subjectid": 2138, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 852, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": "null", "cl_changedto": "{\"Supplier\":\" Live Source\",\" width\":\" 1500\",\" drop\":\" 2000\"}", "cl_customproperties": "{\"attributes\":{\"oi_id\":2138,\"oi_jobid\":852,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":875,\"oi_credit_id\":0,\"oi_productid\":38,\"oi_recipeid\":38,\"oi_ruleid\":0,\"oi_qty\":1,\"oi_seq\":1,\"oi_customseq\":1,\"oi_productcustomseq\":1,\"oi_jsondata\":\"[{\\\"id\\\":2398,\\\"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\\\":2398,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":6493,\\\"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\\\":6493,\\\"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\\\":2399,\\\"labelname\\\":\\\"Supplier\\\",\\\"value\\\":21,\\\"valueid\\\":null,\\\"type\\\":17,\\\"optionid\\\":21,\\\"optionvalue\\\":[{\\\"id\\\":21,\\\"optionid\\\":21,\\\"optionname\\\":\\\"Live Source\\\",\\\"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\\\":2399,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":21,\\\"optionsvalue\\\":[{\\\"id\\\":21,\\\"optionid\\\":21,\\\"optionname\\\":\\\"Live Source\\\",\\\"deleted\\\":0,\\\"optionquantity\\\":1}],\\\"editruleoverride\\\":0},{\\\"id\\\":3126,\\\"labelname\\\":\\\"width\\\",\\\"value\\\":1500,\\\"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\\\":3126,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"ruleoverride\\\":0,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":3127,\\\"labelname\\\":\\\"drop\\\",\\\"value\\\":2000,\\\"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\\\":3127,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"ruleoverride\\\":0,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":2400,\\\"labelname\\\":\\\"Slat Colour\\\",\\\"value\\\":null,\\\"valueid\\\":null,\\\"type\\\":13,\\\"optionid\\\":null,\\\"optionvalue\\\":[],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Slat 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\\\":13,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Slat Colour\\\",\\\"fieldid\\\":2400,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":3125,\\\"labelname\\\":\\\"Blinds Slat Materials\\\",\\\"value\\\":null,\\\"valueid\\\":null,\\\"type\\\":20,\\\"optionid\\\":null,\\\"optionvalue\\\":[],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Blinds Slat Materials\\\",\\\"fabricorcolor\\\":2,\\\"widthfraction\\\":null,\\\"widthfractiontext\\\":null,\\\"dropfractiontext\\\":null,\\\"dropfraction\\\":null,\\\"showfieldonjob\\\":1,\\\"showFieldOnCustomerPortal\\\":1,\\\"optionquantity\\\":null,\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":1,\\\"fieldtypeid\\\":20,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Blinds Slat Materials\\\",\\\"fieldid\\\":3125,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":7449,\\\"labelname\\\":\\\"Numeric 01\\\",\\\"value\\\":null,\\\"valueid\\\":null,\\\"type\\\":6,\\\"optionid\\\":null,\\\"optionvalue\\\":[],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Numeric 01\\\",\\\"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\\\":6,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Numeric 01\\\",\\\"fieldid\\\":7449,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":7450,\\\"labelname\\\":\\\"Numeric 02\\\",\\\"value\\\":null,\\\"valueid\\\":null,\\\"type\\\":6,\\\"optionid\\\":null,\\\"optionvalue\\\":[],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Numeric 02\\\",\\\"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\\\":6,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Numeric 02\\\",\\\"fieldid\\\":7450,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":7458,\\\"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\\\":0,\\\"showFieldOnCustomerPortal\\\":0,\\\"optionquantity\\\":null,\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":1,\\\"fieldtypeid\\\":3,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Extras\\\",\\\"fieldid\\\":7458,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0}]\",\"oi_description\":\"Supplier: Live Source, width: 1500, drop: 2000\",\"oi_onlinedescription\":\"Quantity: 1, Unit Type: mm, Supplier: Live Source, width: 1500, drop: 2000\",\"oi_imagepath\":null,\"oi_reportdescription\":\"##Quantity: 1##,##Supplier: Live Source##,##width: 1500 mm##,##drop: 2000 mm##\",\"oi_onlinereportdescription\":\"##Quantity: 1##, ##Supplier: Live Source##, ##width: 1500 mm##, ##drop: 2000 mm##\",\"oi_reporttitles\":\"##Quantity:<\\\/br>##Supplier:<\\\/br>##width:<\\\/br>##drop:\",\"oi_onlinereporttitles\":\"##Quantity:, ##Supplier:, ##width:, ##drop:\",\"oi_productionformulajsondata\":\"[{\\\"productionoveride\\\":0,\\\"id\\\":592,\\\"value\\\":null,\\\"formula\\\":null,\\\"price\\\":null,\\\"recipeid\\\":38,\\\"stockupdate\\\":0,\\\"fieldid\\\":null,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":600,\\\"value\\\":null,\\\"formula\\\":null,\\\"price\\\":null,\\\"recipeid\\\":38,\\\"stockupdate\\\":0,\\\"fieldid\\\":9444,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":3,\\\"option_name\\\":\\\"Dimmer Emitter 4 Channels SOURCE\\\",\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":560,\\\"value\\\":\\\"1500.00\\\",\\\"formula\\\":\\\"width\\\",\\\"price\\\":\\\"1500.00\\\",\\\"recipeid\\\":38,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":\\\"1500.00\\\"}]\",\"oi_productiondate\":\"2025-03-25 15:41:29\",\"oi_operationstatus\":\"0\",\"oi_scanstatus\":\"\",\"oi_operationworkroom_data\":\"[{\\\"link_id\\\":61,\\\"process_id\\\":29,\\\"product_id\\\":38,\\\"phc_id\\\":61,\\\"pd_id\\\":29,\\\"name\\\":\\\"Test\\\",\\\"phc_linkstations\\\":0,\\\"quantity\\\":1,\\\"link_to\\\":\\\"WORKROOM\\\",\\\"phc_processhascost\\\":0,\\\"phc_processhastime\\\":1,\\\"phc_costtype\\\":1,\\\"phc_domesticsellingprice\\\":\\\"9.50\\\",\\\"phc_contractsellingprice\\\":\\\"9.50\\\",\\\"phc_tradesellingprice\\\":\\\"9.50\\\",\\\"phc_dynamiccontact5_sellingprice\\\":\\\"0.00\\\",\\\"phc_dynamiccontact6_sellingprice\\\":\\\"0.00\\\",\\\"phc_dynamiccontact7_sellingprice\\\":\\\"0.00\\\",\\\"phc_dynamiccontact8_sellingprice\\\":\\\"0.00\\\",\\\"phc_ecommercesellingprice\\\":\\\"9.50\\\",\\\"phc_customers\\\":0,\\\"phc_contacttype\\\":0,\\\"phc_hascontacttypeall\\\":1,\\\"phc_hascustomerstypeall\\\":1,\\\"cost_price\\\":\\\"9.50\\\",\\\"Hour\\\\\\\/mins\\\":\\\"-\\\",\\\"phc_processcostid\\\":1,\\\"markupprice\\\":\\\"9.50\\\",\\\"price\\\":\\\"0.00\\\"}]\",\"oi_operationcalender_data\":\"[]\",\"oi_operation_calculations\":\"{\\\"calendar\\\":\\\"0.00\\\",\\\"workroom\\\":\\\"9.50\\\",\\\"cost_with_discount\\\":\\\"9.50\\\",\\\"cost_with_markup\\\":\\\"9.50\\\",\\\"gross_price\\\":\\\"9.79\\\",\\\"vat_price\\\":\\\"0.28\\\"}\",\"oi_pricecomesfrom_calculations\":\"[]\",\"oi_pricetablepriceevenbom\":\"{\\\"sellingPrice\\\":0,\\\"pricetableCostAfterSuppdisc\\\":0,\\\"priceTableCost\\\":0}\",\"oi_productionstatus\":null,\"oi_costoverride\":0,\"oi_costprice\":\"1509.500\",\"oi_netprice\":\"1509.500\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"45.280\",\"oi_vatvalue\":\"3.000\",\"oi_vatselected\":3,\"oi_vattype\":1,\"oi_vatonoff\":1,\"oi_grossprice\":\"1554.790\",\"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\":1,\"oi_endcustomervatprice\":null,\"oi_endcustomeroverridetype\":1,\"oi_endcustomeroverridevalue\":null,\"oi_endcustomeroverridenetprice\":\"1509.500\",\"oi_endcustomeroverridevatprice\":\"45.280\",\"oi_endcustomeroverridegrossprice\":\"1554.780\",\"oi_sage_flag\":0,\"oi_status\":0,\"oi_createdby\":18,\"oi_createdat\":\"2025-03-25T15:41:29.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":\"2025-03-25T10:11:33.000000Z\",\"oi_jsondataid\":\"[2398, 6493, 2399, 3126, 3127, 2400, 3125, 7449, 7450, 7458]\",\"oi_deviceplatform\":0,\"oi_custompricefields\":\"\",\"oi_editransfer\":0,\"oi_apisup_orderid\":0,\"oi_commissionprice\":\"0.000\",\"oi_commissionvatprice\":\"0.000\",\"oi_jsondatabackup\":\"\",\"oi_stockdeduct\":0,\"oi_deductedstockdetails\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17857", "cl_createdat": "1742897493.000000", "cl_updatedat": null }, { "cl_id": 17858, "cl_logname": "model", "cl_type": null, "cl_modulename": "Production Due Date", "cl_message": "Production Due Date has been updated", "cl_event": "modified", "cl_subjectid": 852, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 852, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": "{\"Production Due Date\":\"0000-00-00\"}", "cl_changedto": "{\"Production Due Date\":\"2025-03-25\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17858", "cl_createdat": "1742897494.000000", "cl_updatedat": null }, { "cl_id": 17859, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the fields Net Price,VAT Price,DeliveryCost,Gross Price Amount,Gross Profit,Gross Profit Percentage,Total CostPrice,Amount Outstanding", "cl_event": "modified", "cl_subjectid": 852, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 852, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": "{\"Net Price\":\"0.00\",\"VAT Price\":\"0.00\",\"DeliveryCost\":\"0.00\",\"Gross Price Amount\":\"0.00\",\"Gross Profit\":\"0.00\",\"Gross Profit Percentage\":\"0.00\",\"Total CostPrice\":\"0.00\",\"Amount Outstanding\":\"0.00\"}", "cl_changedto": "{\"Net Price\":\"2264.25\",\"VAT Price\":\"67.92\",\"DeliveryCost\":\"754.75\",\"Gross Price Amount\":\"2332.17\",\"Gross Profit\":\"754.75\",\"Gross Profit Percentage\":\"33.33\",\"Total CostPrice\":\"1509.50\",\"Amount Outstanding\":\"2332.17\"}", "cl_customproperties": "{\"attributes\":{\"jd_listprice\":\"2264.25\",\"jd_netprice\":\"2264.25\",\"jd_vat\":\"67.92\",\"jd_deliverycost\":\"754.75\",\"jd_grossprice\":\"2332.17\",\"jd_grossprofit\":\"754.75\",\"jd_grossprofit_percentage\":\"33.33\",\"jd_costprice\":\"1509.50\",\"jd_amountoutstanding\":\"2332.17\",\"jd_updatedat\":\"2025-03-25T10:11:36.000000Z\"},\"old\":{\"jd_listprice\":\"0.00\",\"jd_netprice\":\"0.00\",\"jd_vat\":\"0.00\",\"jd_deliverycost\":\"0.00\",\"jd_grossprice\":\"0.00\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"0.00\",\"jd_amountoutstanding\":\"0.00\",\"jd_updatedat\":\"2025-03-25T10:11:34.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17859", "cl_createdat": "1742897496.000000", "cl_updatedat": null }, { "cl_id": 17860, "cl_logname": "model", "cl_type": null, "cl_modulename": "Order Date", "cl_message": "Order Date has been updated", "cl_event": "modified", "cl_subjectid": 852, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 852, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": "{\"Order Date\":\"0000-00-00\"}", "cl_changedto": "{\"Order Date\":\"2025-03-25\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17860", "cl_createdat": "1742897506.000000", "cl_updatedat": null }, { "cl_id": 17861, "cl_logname": "model", "cl_type": null, "cl_modulename": "Job Status", "cl_message": "Job Status has been updated", "cl_event": "modified", "cl_subjectid": 852, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 852, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": "{\"Job Status\":\"Quote\"}", "cl_changedto": "{\"Job Status\":\"Order\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17861", "cl_createdat": "1742897506.000000", "cl_updatedat": null }, { "cl_id": 17862, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the fields End Customer Override Net Price,End Customer Override Vat Price,End Customer Override Gross Price,Job Rework Enable", "cl_event": "modified", "cl_subjectid": 852, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 852, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": "{\"End Customer Override Net Price\":\"0.00\",\"End Customer Override Vat Price\":\"0.00\",\"End Customer Override Gross Price\":\"0.00\",\"Job Rework Enable\":\"Off\"}", "cl_changedto": "{\"End Customer Override Net Price\":\"1509.50\",\"End Customer Override Vat Price\":\"45.28\",\"End Customer Override Gross Price\":\"1554.78\",\"Job Rework Enable\":\"On\"}", "cl_customproperties": "{\"attributes\":{\"jd_orderdate\":\"2025-03-25\",\"jd_jobstatus\":4,\"jd_endcustomeroverridenetprice\":\"1509.50\",\"jd_endcustomeroverridevatprice\":\"45.28\",\"jd_endcustomeroverridegrossprice\":\"1554.78\",\"jd_updatedat\":\"2025-03-25T10:11:46.000000Z\",\"jd_rework_enable\":1},\"old\":{\"jd_orderdate\":\"0000-00-00\",\"jd_jobstatus\":3,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_updatedat\":\"2025-03-25T10:11:37.000000Z\",\"jd_rework_enable\":0}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17862", "cl_createdat": "1742897506.000000", "cl_updatedat": null }, { "cl_id": 17863, "cl_logname": "default", "cl_type": "QUEUE_122", "cl_modulename": "EMAIL", "cl_message": "(Email) Sent to rakeshreal91@gmail.com.", "cl_event": "", "cl_subjectid": 852, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 852, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": null, "cl_changedto": null, "cl_customproperties": null, "cl_attachment": null, "cl_deviceplatform": null, "cl_deviceipaddress": null, "cl_devicenameversion": null, "cl_devicelocation": null, "cl_causertype": "", "id": "17863", "cl_createdat": "1742897509.000000", "cl_updatedat": "1742897509.000000" }, { "cl_id": 17865, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 853, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 853, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"BlindMatrix Test\",\"Account Type\":\"Domestic\",\"Source\":\"Linked In\",\"Created By\":\"Leo\",\"First Name\":\"Ajay Test\",\"Country\":\"Australia\",\"Salutation\":\"Hap\",\"Phone\":\"0456465\",\"Check Box\":\"Disabled\",\"Date & Time1\":\"03-25-2025 10:14:16\",\"Assigned to\":18,\"Role\":2,\"Date1\":\"2025-03-25\",\"Delivery date1\":\"2025-03-25\",\"Rework date\":\"2025-03-25\",\"Additional Contacts\":\"621\",\"Job Status\":\"Quote\",\"Order Status\":\"Order1\",\"Net Price\":\"2264.25\",\"VAT Price\":\"67.92\",\"VAT\":\"Enabled\",\"DeliveryCost\":\"754.75\",\"Delivery Cost\":\"All Options\",\"Gross Price Amount\":\"2332.17\",\"Gross Profit\":\"754.75\",\"Gross Profit Percentage\":\"33.33\",\"Total CostPrice\":\"1509.50\",\"Amount Outstanding\":\"2332.17\",\"jd_isonlineorder\":1,\"End Customer Override Type\":1,\"End Customer Delivery Cost Include Vat\":1,\"End Customer Fitting Cost Include Vat\":1,\"Delivery Vat Percentage\":\"3.000\",\"Commission\":\"[]\",\"jd_onlineprefixseq\":\"1\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":853,\"jd_customerid\":599,\"jd_contactid\":621,\"jd_additionalcontacts\":\"621\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"33\\\":25,\\\"37\\\":1,\\\"39\\\":24,\\\"41\\\":18,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"Ajay Test\\\",\\\"46\\\":\\\"\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":4,\\\"285\\\":17,\\\"286\\\":\\\"0456465\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"521\\\":\\\"\\\",\\\"522\\\":\\\"\\\",\\\"523\\\":\\\"\\\",\\\"555\\\":\\\"\\\",\\\"586\\\":\\\"\\\",\\\"587\\\":\\\"\\\",\\\"588\\\":\\\"\\\",\\\"616\\\":\\\"\\\",\\\"617\\\":\\\"\\\",\\\"618\\\":18,\\\"625\\\":2,\\\"633\\\":\\\"\\\",\\\"634\\\":\\\"\\\",\\\"666\\\":\\\"\\\",\\\"667\\\":\\\"\\\",\\\"700\\\":\\\"\\\",\\\"701\\\":\\\"\\\",\\\"702\\\":1,\\\"703\\\":\\\"\\\",\\\"704\\\":\\\"\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-03-25\",\"jd_orderdate\":\"0000-00-00\",\"jd_duedate\":\"0000-00-00\",\"jd_sceduleddate\":\"0000-00-00\",\"jd_invoicedate\":\"0000-00-00\",\"jd_completeddate\":\"0000-00-00\",\"jd_jobref\":null,\"jd_jobstatus\":3,\"jd_contactaddid\":0,\"jd_orderstatus\":1,\"jd_accref\":\",AJAY0001\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"2264.25\",\"jd_netprice\":\"2264.25\",\"jd_vat\":\"67.92\",\"jd_isvaton\":1,\"jd_deliverycost\":\"754.75\",\"jd_deliverycosttypeid\":1,\"jd_overridetypeid\":3,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":0,\"jd_isroundon\":0,\"jd_grossprice\":\"2332.17\",\"jd_grossprofit\":\"754.75\",\"jd_grossprofit_percentage\":\"33.33\",\"jd_costprice\":\"1509.50\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"2332.17\",\"jd_totpaid\":\"0.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":\"\\\"\\\"\",\"jd_deliverycostid\":1,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":1,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":1,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":1,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":null,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":18,\"jd_createdat\":\"2025-03-25T10:14:16.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-03-25T10:14:16.000000Z\",\"jd_deviceplatform\":0,\"jd_fromjobref\":\"\",\"jd_fromdbname\":null,\"jd_importorder\":0,\"jd_quickquote\":0,\"jd_myob_flag\":0,\"jd_myobinvoiceid\":\"\",\"jd_qboflag\":0,\"jd_qboinvoiceid\":0,\"jd_qbodisplayname\":\"\",\"jd_deliveryvatperc\":\"3.000\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"3.000\",\"jd_commission\":\"[]\",\"jd_commissionprice\":\"0.00\",\"jd_commissionsetting\":0,\"jd_commissionaddedvalue\":\"0.00\",\"jd_onlineprefixseq\":\"1\",\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":0,\"jd_rework_count\":0}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17865", "cl_createdat": "1742897656.000000", "cl_updatedat": null }, { "cl_id": 17871, "cl_logname": "model", "cl_type": null, "cl_modulename": "Order Date", "cl_message": "Order Date has been updated", "cl_event": "modified", "cl_subjectid": 853, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 853, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": "{\"Order Date\":\"0000-00-00\"}", "cl_changedto": "{\"Order Date\":\"2025-03-25\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17871", "cl_createdat": "1742897676.000000", "cl_updatedat": null }, { "cl_id": 17872, "cl_logname": "model", "cl_type": null, "cl_modulename": "Job Status", "cl_message": "Job Status has been updated", "cl_event": "modified", "cl_subjectid": 853, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 853, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": "{\"Job Status\":\"Quote\"}", "cl_changedto": "{\"Job Status\":\"Order\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17872", "cl_createdat": "1742897676.000000", "cl_updatedat": null }, { "cl_id": 17873, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the fields End Customer Override Net Price,End Customer Override Vat Price,End Customer Override Gross Price,Job Rework Enable", "cl_event": "modified", "cl_subjectid": 853, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 853, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": "{\"End Customer Override Net Price\":\"0.00\",\"End Customer Override Vat Price\":\"0.00\",\"End Customer Override Gross Price\":\"0.00\",\"Job Rework Enable\":\"Off\"}", "cl_changedto": "{\"End Customer Override Net Price\":\"1509.50\",\"End Customer Override Vat Price\":\"45.28\",\"End Customer Override Gross Price\":\"1554.78\",\"Job Rework Enable\":\"On\"}", "cl_customproperties": "{\"attributes\":{\"jd_orderdate\":\"2025-03-25\",\"jd_jobstatus\":4,\"jd_endcustomeroverridevalue\":\"\",\"jd_endcustomeroverridenetprice\":\"1509.50\",\"jd_endcustomeroverridevatprice\":\"45.28\",\"jd_endcustomeroverridegrossprice\":\"1554.78\",\"jd_endcustomerdeliverycost\":\"\",\"jd_endcustomerfittingcost\":\"\",\"jd_updatedat\":\"2025-03-25T10:14:36.000000Z\",\"jd_rework_enable\":1},\"old\":{\"jd_orderdate\":\"0000-00-00\",\"jd_jobstatus\":3,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerfittingcost\":null,\"jd_updatedat\":\"2025-03-25T10:14:16.000000Z\",\"jd_rework_enable\":0}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17873", "cl_createdat": "1742897676.000000", "cl_updatedat": null }, { "cl_id": 17874, "cl_logname": "default", "cl_type": "QUEUE_122", "cl_modulename": "EMAIL", "cl_message": "(Email) Sent to rakeshreal91@gmail.com.", "cl_event": "", "cl_subjectid": 853, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 853, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": null, "cl_changedto": null, "cl_customproperties": null, "cl_attachment": null, "cl_deviceplatform": null, "cl_deviceipaddress": null, "cl_devicenameversion": null, "cl_devicelocation": null, "cl_causertype": "", "id": "17874", "cl_createdat": "1742897680.000000", "cl_updatedat": "1742897680.000000" }, { "cl_id": 17875, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 854, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 854, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"BlindMatrix Test\",\"Account Type\":\"Domestic\",\"Source\":\"Linked In\",\"Created By\":\"Leo\",\"First Name\":\"Sdsdsd\",\"Last Name\":\"Sdsd\",\"Country\":\"Australia\",\"Salutation\":\"Hap\",\"Phone\":\"0465465456\",\"Check Box\":\"Disabled\",\"Date & Time1\":\"03-25-2025 10:25:01\",\"Assigned to\":18,\"Role\":2,\"Date1\":\"2025-03-25\",\"Delivery date1\":\"2025-03-25\",\"Rework date\":\"2025-03-25\",\"Additional Contacts\":\"622\",\"Job Status\":\"Quote\",\"Order Status\":\"Order1\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"jd_isonlineorder\":1,\"End Customer Override Type\":1,\"End Customer Delivery Cost Include Vat\":1,\"End Customer Fitting Cost Include Vat\":1,\"Delivery Vat Percentage\":\"3.000\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":854,\"jd_customerid\":600,\"jd_contactid\":622,\"jd_additionalcontacts\":\"622\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"33\\\":25,\\\"37\\\":1,\\\"39\\\":24,\\\"41\\\":18,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"Sdsdsd\\\",\\\"46\\\":\\\"Sdsd\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":4,\\\"285\\\":17,\\\"286\\\":\\\"0465465456\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"521\\\":\\\"\\\",\\\"522\\\":\\\"\\\",\\\"523\\\":\\\"\\\",\\\"555\\\":\\\"\\\",\\\"586\\\":\\\"\\\",\\\"587\\\":\\\"\\\",\\\"588\\\":\\\"\\\",\\\"616\\\":\\\"\\\",\\\"617\\\":\\\"\\\",\\\"618\\\":18,\\\"625\\\":2,\\\"633\\\":\\\"\\\",\\\"634\\\":\\\"\\\",\\\"666\\\":\\\"\\\",\\\"667\\\":\\\"\\\",\\\"700\\\":\\\"\\\",\\\"701\\\":\\\"\\\",\\\"702\\\":1,\\\"703\\\":\\\"\\\",\\\"704\\\":\\\"\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-03-25\",\"jd_orderdate\":\"0000-00-00\",\"jd_duedate\":\"0000-00-00\",\"jd_sceduleddate\":\"0000-00-00\",\"jd_invoicedate\":\"0000-00-00\",\"jd_completeddate\":\"0000-00-00\",\"jd_jobref\":null,\"jd_jobstatus\":3,\"jd_contactaddid\":0,\"jd_orderstatus\":1,\"jd_accref\":\"\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"0.00\",\"jd_netprice\":\"0.00\",\"jd_vat\":\"0.00\",\"jd_isvaton\":1,\"jd_deliverycost\":\"0.00\",\"jd_deliverycosttypeid\":1,\"jd_overridetypeid\":3,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":0,\"jd_isroundon\":0,\"jd_grossprice\":\"0.00\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"0.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"0.00\",\"jd_totpaid\":\"0.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":\"\\\"\\\"\",\"jd_deliverycostid\":1,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":1,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":1,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":1,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":null,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":18,\"jd_createdat\":\"2025-03-25T10:25:01.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-03-25T10:25:01.000000Z\",\"jd_deviceplatform\":0,\"jd_fromjobref\":\"\",\"jd_fromdbname\":null,\"jd_importorder\":0,\"jd_quickquote\":0,\"jd_myob_flag\":0,\"jd_myobinvoiceid\":\"\",\"jd_qboflag\":0,\"jd_qboinvoiceid\":0,\"jd_qbodisplayname\":\"\",\"jd_deliveryvatperc\":\"3.000\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"3.000\",\"jd_commission\":\"[]\",\"jd_commissionprice\":\"0.00\",\"jd_commissionsetting\":0,\"jd_commissionaddedvalue\":\"0.00\",\"jd_onlineprefixseq\":\"\",\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":0,\"jd_rework_count\":0}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17875", "cl_createdat": "1742898302.000000", "cl_updatedat": null }, { "cl_id": 17879, "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 Wooden Venetians", "cl_event": "created", "cl_subjectid": 2140, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 854, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": "null", "cl_changedto": "{\"Supplier\":\" Live Source\",\" width\":\" 1500\",\" drop\":\" 2000\"}", "cl_customproperties": "{\"attributes\":{\"oi_id\":2140,\"oi_jobid\":854,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":877,\"oi_credit_id\":0,\"oi_productid\":38,\"oi_recipeid\":38,\"oi_ruleid\":0,\"oi_qty\":1,\"oi_seq\":1,\"oi_customseq\":1,\"oi_productcustomseq\":1,\"oi_jsondata\":\"[{\\\"id\\\":2398,\\\"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\\\":2398,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":6493,\\\"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\\\":6493,\\\"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\\\":2399,\\\"labelname\\\":\\\"Supplier\\\",\\\"value\\\":21,\\\"valueid\\\":null,\\\"type\\\":17,\\\"optionid\\\":21,\\\"optionvalue\\\":[{\\\"id\\\":21,\\\"optionid\\\":21,\\\"optionname\\\":\\\"Live Source\\\",\\\"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\\\":2399,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":21,\\\"optionsvalue\\\":[{\\\"id\\\":21,\\\"optionid\\\":21,\\\"optionname\\\":\\\"Live Source\\\",\\\"deleted\\\":0,\\\"optionquantity\\\":1}],\\\"editruleoverride\\\":0},{\\\"id\\\":3126,\\\"labelname\\\":\\\"width\\\",\\\"value\\\":1500,\\\"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\\\":3126,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"ruleoverride\\\":0,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":3127,\\\"labelname\\\":\\\"drop\\\",\\\"value\\\":2000,\\\"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\\\":3127,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"ruleoverride\\\":0,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":2400,\\\"labelname\\\":\\\"Slat Colour\\\",\\\"value\\\":null,\\\"valueid\\\":null,\\\"type\\\":13,\\\"optionid\\\":null,\\\"optionvalue\\\":[],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Slat 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\\\":13,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Slat Colour\\\",\\\"fieldid\\\":2400,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":3125,\\\"labelname\\\":\\\"Blinds Slat Materials\\\",\\\"value\\\":null,\\\"valueid\\\":null,\\\"type\\\":20,\\\"optionid\\\":null,\\\"optionvalue\\\":[],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Blinds Slat Materials\\\",\\\"fabricorcolor\\\":2,\\\"widthfraction\\\":null,\\\"widthfractiontext\\\":null,\\\"dropfractiontext\\\":null,\\\"dropfraction\\\":null,\\\"showfieldonjob\\\":1,\\\"showFieldOnCustomerPortal\\\":1,\\\"optionquantity\\\":null,\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":1,\\\"fieldtypeid\\\":20,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Blinds Slat Materials\\\",\\\"fieldid\\\":3125,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":7449,\\\"labelname\\\":\\\"Numeric 01\\\",\\\"value\\\":null,\\\"valueid\\\":null,\\\"type\\\":6,\\\"optionid\\\":null,\\\"optionvalue\\\":[],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Numeric 01\\\",\\\"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\\\":6,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Numeric 01\\\",\\\"fieldid\\\":7449,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":7450,\\\"labelname\\\":\\\"Numeric 02\\\",\\\"value\\\":null,\\\"valueid\\\":null,\\\"type\\\":6,\\\"optionid\\\":null,\\\"optionvalue\\\":[],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Numeric 02\\\",\\\"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\\\":6,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Numeric 02\\\",\\\"fieldid\\\":7450,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":7458,\\\"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\\\":0,\\\"showFieldOnCustomerPortal\\\":0,\\\"optionquantity\\\":null,\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":1,\\\"fieldtypeid\\\":3,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Extras\\\",\\\"fieldid\\\":7458,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0}]\",\"oi_description\":\"Supplier: Live Source, width: 1500, drop: 2000\",\"oi_onlinedescription\":\"Quantity: 1, Unit Type: mm, Supplier: Live Source, width: 1500, drop: 2000\",\"oi_imagepath\":null,\"oi_reportdescription\":\"##Quantity: 1##,##Supplier: Live Source##,##width: 1500 mm##,##drop: 2000 mm##\",\"oi_onlinereportdescription\":\"##Quantity: 1##, ##Supplier: Live Source##, ##width: 1500 mm##, ##drop: 2000 mm##\",\"oi_reporttitles\":\"##Quantity:<\\\/br>##Supplier:<\\\/br>##width:<\\\/br>##drop:\",\"oi_onlinereporttitles\":\"##Quantity:, ##Supplier:, ##width:, ##drop:\",\"oi_productionformulajsondata\":\"[{\\\"productionoveride\\\":0,\\\"id\\\":592,\\\"value\\\":null,\\\"formula\\\":null,\\\"price\\\":null,\\\"recipeid\\\":38,\\\"stockupdate\\\":0,\\\"fieldid\\\":null,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":600,\\\"value\\\":null,\\\"formula\\\":null,\\\"price\\\":null,\\\"recipeid\\\":38,\\\"stockupdate\\\":0,\\\"fieldid\\\":9444,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":3,\\\"option_name\\\":\\\"Dimmer Emitter 4 Channels SOURCE\\\",\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":560,\\\"value\\\":\\\"1500.00\\\",\\\"formula\\\":\\\"width\\\",\\\"price\\\":\\\"1500.00\\\",\\\"recipeid\\\":38,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":\\\"1500.00\\\"}]\",\"oi_productiondate\":\"2025-03-25 15:55:11\",\"oi_operationstatus\":\"0\",\"oi_scanstatus\":\"\",\"oi_operationworkroom_data\":\"[{\\\"link_id\\\":61,\\\"process_id\\\":29,\\\"product_id\\\":38,\\\"phc_id\\\":61,\\\"pd_id\\\":29,\\\"name\\\":\\\"Test\\\",\\\"phc_linkstations\\\":0,\\\"quantity\\\":1,\\\"link_to\\\":\\\"WORKROOM\\\",\\\"phc_processhascost\\\":0,\\\"phc_processhastime\\\":1,\\\"phc_costtype\\\":1,\\\"phc_domesticsellingprice\\\":\\\"9.50\\\",\\\"phc_contractsellingprice\\\":\\\"9.50\\\",\\\"phc_tradesellingprice\\\":\\\"9.50\\\",\\\"phc_dynamiccontact5_sellingprice\\\":\\\"0.00\\\",\\\"phc_dynamiccontact6_sellingprice\\\":\\\"0.00\\\",\\\"phc_dynamiccontact7_sellingprice\\\":\\\"0.00\\\",\\\"phc_dynamiccontact8_sellingprice\\\":\\\"0.00\\\",\\\"phc_ecommercesellingprice\\\":\\\"9.50\\\",\\\"phc_customers\\\":0,\\\"phc_contacttype\\\":0,\\\"phc_hascontacttypeall\\\":1,\\\"phc_hascustomerstypeall\\\":1,\\\"cost_price\\\":\\\"9.50\\\",\\\"Hour\\\\\\\/mins\\\":\\\"-\\\",\\\"phc_processcostid\\\":1,\\\"markupprice\\\":\\\"9.50\\\",\\\"price\\\":\\\"0.00\\\"}]\",\"oi_operationcalender_data\":\"[]\",\"oi_operation_calculations\":\"{\\\"calendar\\\":\\\"0.00\\\",\\\"workroom\\\":\\\"9.50\\\",\\\"cost_with_discount\\\":\\\"9.50\\\",\\\"cost_with_markup\\\":\\\"9.50\\\",\\\"gross_price\\\":\\\"9.79\\\",\\\"vat_price\\\":\\\"0.28\\\"}\",\"oi_pricecomesfrom_calculations\":\"[]\",\"oi_pricetablepriceevenbom\":\"{\\\"sellingPrice\\\":0,\\\"pricetableCostAfterSuppdisc\\\":0,\\\"priceTableCost\\\":0}\",\"oi_productionstatus\":null,\"oi_costoverride\":0,\"oi_costprice\":\"1509.500\",\"oi_netprice\":\"1509.500\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"45.280\",\"oi_vatvalue\":\"3.000\",\"oi_vatselected\":3,\"oi_vattype\":1,\"oi_vatonoff\":1,\"oi_grossprice\":\"1554.790\",\"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\":1,\"oi_endcustomervatprice\":null,\"oi_endcustomeroverridetype\":1,\"oi_endcustomeroverridevalue\":null,\"oi_endcustomeroverridenetprice\":\"1509.500\",\"oi_endcustomeroverridevatprice\":\"45.280\",\"oi_endcustomeroverridegrossprice\":\"1554.780\",\"oi_sage_flag\":0,\"oi_status\":0,\"oi_createdby\":18,\"oi_createdat\":\"2025-03-25T15:55:11.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":\"2025-03-25T10:25:14.000000Z\",\"oi_jsondataid\":\"[2398, 6493, 2399, 3126, 3127, 2400, 3125, 7449, 7450, 7458]\",\"oi_deviceplatform\":0,\"oi_custompricefields\":\"\",\"oi_editransfer\":0,\"oi_apisup_orderid\":0,\"oi_commissionprice\":\"0.000\",\"oi_commissionvatprice\":\"0.000\",\"oi_jsondatabackup\":\"\",\"oi_stockdeduct\":0,\"oi_deductedstockdetails\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17879", "cl_createdat": "1742898314.000000", "cl_updatedat": null }, { "cl_id": 17880, "cl_logname": "model", "cl_type": null, "cl_modulename": "Production Due Date", "cl_message": "Production Due Date has been updated", "cl_event": "modified", "cl_subjectid": 854, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 854, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": "{\"Production Due Date\":\"0000-00-00\"}", "cl_changedto": "{\"Production Due Date\":\"2025-03-25\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17880", "cl_createdat": "1742898314.000000", "cl_updatedat": null }, { "cl_id": 17881, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the fields Net Price,VAT Price,DeliveryCost,Gross Price Amount,Total CostPrice,Amount Outstanding", "cl_event": "modified", "cl_subjectid": 854, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 854, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": "{\"Net Price\":\"0.00\",\"VAT Price\":\"0.00\",\"DeliveryCost\":\"0.00\",\"Gross Price Amount\":\"0.00\",\"Total CostPrice\":\"0.00\",\"Amount Outstanding\":\"0.00\"}", "cl_changedto": "{\"Net Price\":\"2264.25\",\"VAT Price\":\"67.92\",\"DeliveryCost\":\"754.75\",\"Gross Price Amount\":\"2332.17\",\"Total CostPrice\":\"1509.50\",\"Amount Outstanding\":\"2332.17\"}", "cl_customproperties": "{\"attributes\":{\"jd_listprice\":\"2264.25\",\"jd_netprice\":\"2264.25\",\"jd_vat\":\"67.92\",\"jd_deliverycost\":\"754.75\",\"jd_grossprice\":\"2332.17\",\"jd_costprice\":\"1509.50\",\"jd_amountoutstanding\":\"2332.17\",\"jd_updatedat\":\"2025-03-25T10:25:16.000000Z\"},\"old\":{\"jd_listprice\":\"0.00\",\"jd_netprice\":\"0.00\",\"jd_vat\":\"0.00\",\"jd_deliverycost\":\"0.00\",\"jd_grossprice\":\"0.00\",\"jd_costprice\":\"0.00\",\"jd_amountoutstanding\":\"0.00\",\"jd_updatedat\":\"2025-03-25T10:25:14.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17881", "cl_createdat": "1742898316.000000", "cl_updatedat": null }, { "cl_id": 17882, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the fields Gross Profit,Gross Profit Percentage", "cl_event": "modified", "cl_subjectid": 854, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 854, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": "{\"Gross Profit\":\"0.00\",\"Gross Profit Percentage\":\"0.00\"}", "cl_changedto": "{\"Gross Profit\":\"754.75\",\"Gross Profit Percentage\":\"33.33\"}", "cl_customproperties": "{\"attributes\":{\"jd_grossprofit\":\"754.75\",\"jd_grossprofit_percentage\":\"33.33\",\"jd_endcustomeroverridevalue\":\"\",\"jd_endcustomerdeliverycost\":\"\",\"jd_endcustomerfittingcost\":\"\",\"jd_updatedat\":\"2025-03-25T10:25:17.000000Z\"},\"old\":{\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_endcustomeroverridevalue\":null,\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerfittingcost\":null,\"jd_updatedat\":\"2025-03-25T10:25:16.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17882", "cl_createdat": "1742898317.000000", "cl_updatedat": null }, { "cl_id": 17883, "cl_logname": "model", "cl_type": null, "cl_modulename": "Job Status", "cl_message": "Job Status has been updated", "cl_event": "modified", "cl_subjectid": 854, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 854, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": "{\"Job Status\":\"Quote\"}", "cl_changedto": "{\"Job Status\":\"Lead\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17883", "cl_createdat": "1742898331.000000", "cl_updatedat": null }, { "cl_id": 17884, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the fields End Customer Override Net Price,End Customer Override Vat Price,End Customer Override Gross Price", "cl_event": "modified", "cl_subjectid": 854, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 854, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": "{\"End Customer Override Net Price\":\"0.00\",\"End Customer Override Vat Price\":\"0.00\",\"End Customer Override Gross Price\":\"0.00\"}", "cl_changedto": "{\"End Customer Override Net Price\":\"1509.50\",\"End Customer Override Vat Price\":\"45.28\",\"End Customer Override Gross Price\":\"1554.78\"}", "cl_customproperties": "{\"attributes\":{\"jd_jobstatus\":1,\"jd_endcustomeroverridenetprice\":\"1509.50\",\"jd_endcustomeroverridevatprice\":\"45.28\",\"jd_endcustomeroverridegrossprice\":\"1554.78\",\"jd_updatedat\":\"2025-03-25T10:25:31.000000Z\"},\"old\":{\"jd_jobstatus\":3,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_updatedat\":\"2025-03-25T10:25:17.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17884", "cl_createdat": "1742898331.000000", "cl_updatedat": null }, { "cl_id": 17885, "cl_logname": "default", "cl_type": "QUEUE_124", "cl_modulename": "EMAIL", "cl_message": "(Email) Sent to rakeshreal91@gmail.com.", "cl_event": "", "cl_subjectid": 854, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 854, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": null, "cl_changedto": null, "cl_customproperties": null, "cl_attachment": null, "cl_deviceplatform": null, "cl_deviceipaddress": null, "cl_devicenameversion": null, "cl_devicelocation": null, "cl_causertype": "", "id": "17885", "cl_createdat": "1742898334.000000", "cl_updatedat": "1742898334.000000" }, { "cl_id": 17886, "cl_logname": "model", "cl_type": null, "cl_modulename": "Order Date", "cl_message": "Order Date has been updated", "cl_event": "modified", "cl_subjectid": 854, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 854, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": "{\"Order Date\":\"0000-00-00\"}", "cl_changedto": "{\"Order Date\":\"2025-03-25\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17886", "cl_createdat": "1742898355.000000", "cl_updatedat": null }, { "cl_id": 17887, "cl_logname": "model", "cl_type": null, "cl_modulename": "Job Status", "cl_message": "Job Status has been updated", "cl_event": "modified", "cl_subjectid": 854, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 854, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": "{\"Job Status\":\"Lead\"}", "cl_changedto": "{\"Job Status\":\"Order\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17887", "cl_createdat": "1742898355.000000", "cl_updatedat": null }, { "cl_id": 17888, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the field Job Rework Enable", "cl_event": "modified", "cl_subjectid": 854, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 854, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": "{\"Job Rework Enable\":\"Off\"}", "cl_changedto": "{\"Job Rework Enable\":\"On\"}", "cl_customproperties": "{\"attributes\":{\"jd_orderdate\":\"2025-03-25\",\"jd_jobstatus\":4,\"jd_updatedat\":\"2025-03-25T10:25:55.000000Z\",\"jd_rework_enable\":1},\"old\":{\"jd_orderdate\":\"0000-00-00\",\"jd_jobstatus\":1,\"jd_updatedat\":\"2025-03-25T10:25:31.000000Z\",\"jd_rework_enable\":0}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17888", "cl_createdat": "1742898355.000000", "cl_updatedat": null }, { "cl_id": 17889, "cl_logname": "default", "cl_type": "QUEUE_124", "cl_modulename": "EMAIL", "cl_message": "(Email) Sent to rakeshreal91@gmail.com.", "cl_event": "", "cl_subjectid": 854, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 854, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": null, "cl_changedto": null, "cl_customproperties": null, "cl_attachment": null, "cl_deviceplatform": null, "cl_deviceipaddress": null, "cl_devicenameversion": null, "cl_devicelocation": null, "cl_causertype": "", "id": "17889", "cl_createdat": "1742898359.000000", "cl_updatedat": "1742898359.000000" }, { "cl_id": 17891, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 855, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 855, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"BlindMatrix Test\",\"Account Type\":\"Domestic\",\"Source\":\"Linked In\",\"Created By\":\"Leo\",\"First Name\":\"Sdsdsd\",\"Last Name\":\"Sdsd\",\"Country\":\"Australia\",\"Salutation\":\"Hap\",\"Phone\":\"0465465456\",\"Check Box\":\"Disabled\",\"Date & Time1\":\"03-25-2025 10:27:24\",\"Assigned to\":18,\"Role\":2,\"Date1\":\"2025-03-25\",\"Delivery date1\":\"2025-03-25\",\"Rework date\":\"2025-03-25\",\"Additional Contacts\":\"622\",\"Job Status\":\"Quote\",\"Order Status\":\"Order1\",\"Net Price\":\"2264.25\",\"VAT Price\":\"67.92\",\"VAT\":\"Enabled\",\"DeliveryCost\":\"754.75\",\"Delivery Cost\":\"All Options\",\"Gross Price Amount\":\"2332.17\",\"Gross Profit\":\"754.75\",\"Gross Profit Percentage\":\"33.33\",\"Total CostPrice\":\"1509.50\",\"Amount Outstanding\":\"2332.17\",\"jd_isonlineorder\":1,\"End Customer Override Type\":1,\"End Customer Delivery Cost Include Vat\":1,\"End Customer Fitting Cost Include Vat\":1,\"Delivery Vat Percentage\":\"3.000\",\"Commission\":\"[]\",\"jd_onlineprefixseq\":\"1\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":855,\"jd_customerid\":600,\"jd_contactid\":622,\"jd_additionalcontacts\":\"622\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"33\\\":25,\\\"37\\\":1,\\\"39\\\":24,\\\"41\\\":18,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"Sdsdsd\\\",\\\"46\\\":\\\"Sdsd\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":4,\\\"285\\\":17,\\\"286\\\":\\\"0465465456\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"521\\\":\\\"\\\",\\\"522\\\":\\\"\\\",\\\"523\\\":\\\"\\\",\\\"555\\\":\\\"\\\",\\\"586\\\":\\\"\\\",\\\"587\\\":\\\"\\\",\\\"588\\\":\\\"\\\",\\\"616\\\":\\\"\\\",\\\"617\\\":\\\"\\\",\\\"618\\\":18,\\\"625\\\":2,\\\"633\\\":\\\"\\\",\\\"634\\\":\\\"\\\",\\\"666\\\":\\\"\\\",\\\"667\\\":\\\"\\\",\\\"700\\\":\\\"\\\",\\\"701\\\":\\\"\\\",\\\"702\\\":1,\\\"703\\\":\\\"\\\",\\\"704\\\":\\\"\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-03-25\",\"jd_orderdate\":\"0000-00-00\",\"jd_duedate\":\"0000-00-00\",\"jd_sceduleddate\":\"0000-00-00\",\"jd_invoicedate\":\"0000-00-00\",\"jd_completeddate\":\"0000-00-00\",\"jd_jobref\":null,\"jd_jobstatus\":3,\"jd_contactaddid\":0,\"jd_orderstatus\":1,\"jd_accref\":\",SDSD0005\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"2264.25\",\"jd_netprice\":\"2264.25\",\"jd_vat\":\"67.92\",\"jd_isvaton\":1,\"jd_deliverycost\":\"754.75\",\"jd_deliverycosttypeid\":1,\"jd_overridetypeid\":3,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":0,\"jd_isroundon\":0,\"jd_grossprice\":\"2332.17\",\"jd_grossprofit\":\"754.75\",\"jd_grossprofit_percentage\":\"33.33\",\"jd_costprice\":\"1509.50\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"2332.17\",\"jd_totpaid\":\"0.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":\"\\\"\\\"\",\"jd_deliverycostid\":1,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":1,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":1,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":1,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":null,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":18,\"jd_createdat\":\"2025-03-25T10:27:24.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-03-25T10:27:24.000000Z\",\"jd_deviceplatform\":0,\"jd_fromjobref\":\"\",\"jd_fromdbname\":null,\"jd_importorder\":0,\"jd_quickquote\":0,\"jd_myob_flag\":0,\"jd_myobinvoiceid\":\"\",\"jd_qboflag\":0,\"jd_qboinvoiceid\":0,\"jd_qbodisplayname\":\"\",\"jd_deliveryvatperc\":\"3.000\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"3.000\",\"jd_commission\":\"[]\",\"jd_commissionprice\":\"0.00\",\"jd_commissionsetting\":0,\"jd_commissionaddedvalue\":\"0.00\",\"jd_onlineprefixseq\":\"1\",\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":0,\"jd_rework_count\":0}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17891", "cl_createdat": "1742898444.000000", "cl_updatedat": null }, { "cl_id": 17897, "cl_logname": "model", "cl_type": null, "cl_modulename": "Order Date", "cl_message": "Order Date has been updated", "cl_event": "modified", "cl_subjectid": 855, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 855, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": "{\"Order Date\":\"0000-00-00\"}", "cl_changedto": "{\"Order Date\":\"2025-03-25\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17897", "cl_createdat": "1742898459.000000", "cl_updatedat": null }, { "cl_id": 17898, "cl_logname": "model", "cl_type": null, "cl_modulename": "Job Status", "cl_message": "Job Status has been updated", "cl_event": "modified", "cl_subjectid": 855, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 855, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": "{\"Job Status\":\"Quote\"}", "cl_changedto": "{\"Job Status\":\"order2\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17898", "cl_createdat": "1742898459.000000", "cl_updatedat": null }, { "cl_id": 17899, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the fields End Customer Override Net Price,End Customer Override Vat Price,End Customer Override Gross Price,Job Rework Enable", "cl_event": "modified", "cl_subjectid": 855, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 855, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": "{\"End Customer Override Net Price\":\"0.00\",\"End Customer Override Vat Price\":\"0.00\",\"End Customer Override Gross Price\":\"0.00\",\"Job Rework Enable\":\"Off\"}", "cl_changedto": "{\"End Customer Override Net Price\":\"1509.50\",\"End Customer Override Vat Price\":\"45.28\",\"End Customer Override Gross Price\":\"1554.78\",\"Job Rework Enable\":\"On\"}", "cl_customproperties": "{\"attributes\":{\"jd_orderdate\":\"2025-03-25\",\"jd_jobstatus\":16,\"jd_endcustomeroverridevalue\":\"\",\"jd_endcustomeroverridenetprice\":\"1509.50\",\"jd_endcustomeroverridevatprice\":\"45.28\",\"jd_endcustomeroverridegrossprice\":\"1554.78\",\"jd_endcustomerdeliverycost\":\"\",\"jd_endcustomerfittingcost\":\"\",\"jd_updatedat\":\"2025-03-25T10:27:39.000000Z\",\"jd_rework_enable\":1},\"old\":{\"jd_orderdate\":\"0000-00-00\",\"jd_jobstatus\":3,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerfittingcost\":null,\"jd_updatedat\":\"2025-03-25T10:27:24.000000Z\",\"jd_rework_enable\":0}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17899", "cl_createdat": "1742898459.000000", "cl_updatedat": null }, { "cl_id": 17900, "cl_logname": "default", "cl_type": "QUEUE_124", "cl_modulename": "EMAIL", "cl_message": "(Email) Sent to rakeshreal91@gmail.com.", "cl_event": "", "cl_subjectid": 855, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 855, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": null, "cl_changedto": null, "cl_customproperties": null, "cl_attachment": null, "cl_deviceplatform": null, "cl_deviceipaddress": null, "cl_devicenameversion": null, "cl_devicelocation": null, "cl_causertype": "", "id": "17900", "cl_createdat": "1742898463.000000", "cl_updatedat": "1742898463.000000" }, { "cl_id": 17901, "cl_logname": "default", "cl_type": null, "cl_modulename": "Task", "cl_message": "new item has been created in Task", "cl_event": "created", "cl_subjectid": 99, "cl_subjecttype": "App\\Models\\Task\\bm_tasklist", "cl_parentid": 99, "cl_parentsubjecttype": "App\\Models\\Task\\bm_tasklist", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Category\":\"High\",\"Task Date\":\"2025-03-26\",\"Task Time\":\"20:15:24\",\"tl_istaskprivate\":1,\"Created By\":\"Siva\",\"Description\":\"Ds\",\"Repeat\":\"yearly on March 27\",\"Repeat Method\":\"daily\",\"tl_deviceplatform\":2}", "cl_customproperties": "{\"attributes\":{\"tl_id\":99,\"tl_orderid\":0,\"tl_taskcategory\":1,\"tl_taskdate\":\"2025-03-26\",\"tl_tasktime\":\"20:15:24\",\"tl_taskmethod\":\"0\",\"tl_istaskprivate\":1,\"tl_userid\":\"27\",\"tl_priority\":0,\"tl_addjobid\":0,\"tl_desc\":\"Ds\",\"tl_status\":0,\"tl_markasread\":0,\"tl_taskstatus\":2,\"tl_userdefinedfields\":\"[{\\\"id\\\":\\\"2\\\",\\\"name\\\":\\\"jim\\\",\\\"key\\\":\\\"task_jim\\\",\\\"type\\\":\\\"textbox\\\",\\\"condition\\\":1,\\\"idname\\\":\\\"task_jim\\\",\\\"pattern\\\":\\\"^[a-zA-Z ]*$\\\",\\\"errormsg\\\":\\\"Only Text is allowed\\\",\\\"maxlength\\\":156,\\\"mandatory\\\":1,\\\"_default\\\":\\\"\\\",\\\"dropdownoptionvalue\\\":\\\"\\\",\\\"userdefine\\\":\\\"Sa\\\"}]\",\"tl_markcompleted\":0,\"tl_jobmode\":null,\"tl_recurrencerule\":\"FREQ=DAILY;INTERVAL=1;COUNT=2;\",\"tl_repeatmaindescription\":null,\"tl_repeatmethod\":\"daily\",\"tl_starttask\":null,\"tl_startdata\":null,\"tl_endtask\":null,\"tl_enddata\":null,\"tl_createdat\":\"2025-03-27T08:03:56.000000Z\",\"tl_createdby\":1,\"tl_updatedby\":null,\"tl_updatedat\":\"2025-03-27T08:03:56.000000Z\",\"tl_istaskrepeat\":1,\"tl_deviceplatform\":2,\"tl_subject\":null,\"tl_immediate_notification\":0,\"tl_parent_task_id\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17901", "cl_createdat": "1743062636.000000", "cl_updatedat": null } ], "updated": [ { "cl_id": 17863, "cl_logname": "default", "cl_type": "QUEUE_122", "cl_modulename": "EMAIL", "cl_message": "(Email) Sent to rakeshreal91@gmail.com.", "cl_event": "", "cl_subjectid": 852, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 852, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": null, "cl_changedto": null, "cl_customproperties": null, "cl_attachment": null, "cl_deviceplatform": null, "cl_deviceipaddress": null, "cl_devicenameversion": null, "cl_devicelocation": null, "cl_causertype": "", "id": "17863", "cl_createdat": "1742897509.000000", "cl_updatedat": "1742897509.000000" }, { "cl_id": 17874, "cl_logname": "default", "cl_type": "QUEUE_122", "cl_modulename": "EMAIL", "cl_message": "(Email) Sent to rakeshreal91@gmail.com.", "cl_event": "", "cl_subjectid": 853, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 853, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": null, "cl_changedto": null, "cl_customproperties": null, "cl_attachment": null, "cl_deviceplatform": null, "cl_deviceipaddress": null, "cl_devicenameversion": null, "cl_devicelocation": null, "cl_causertype": "", "id": "17874", "cl_createdat": "1742897680.000000", "cl_updatedat": "1742897680.000000" }, { "cl_id": 17885, "cl_logname": "default", "cl_type": "QUEUE_124", "cl_modulename": "EMAIL", "cl_message": "(Email) Sent to rakeshreal91@gmail.com.", "cl_event": "", "cl_subjectid": 854, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 854, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": null, "cl_changedto": null, "cl_customproperties": null, "cl_attachment": null, "cl_deviceplatform": null, "cl_deviceipaddress": null, "cl_devicenameversion": null, "cl_devicelocation": null, "cl_causertype": "", "id": "17885", "cl_createdat": "1742898334.000000", "cl_updatedat": "1742898334.000000" }, { "cl_id": 17889, "cl_logname": "default", "cl_type": "QUEUE_124", "cl_modulename": "EMAIL", "cl_message": "(Email) Sent to rakeshreal91@gmail.com.", "cl_event": "", "cl_subjectid": 854, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 854, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": null, "cl_changedto": null, "cl_customproperties": null, "cl_attachment": null, "cl_deviceplatform": null, "cl_deviceipaddress": null, "cl_devicenameversion": null, "cl_devicelocation": null, "cl_causertype": "", "id": "17889", "cl_createdat": "1742898359.000000", "cl_updatedat": "1742898359.000000" }, { "cl_id": 17900, "cl_logname": "default", "cl_type": "QUEUE_124", "cl_modulename": "EMAIL", "cl_message": "(Email) Sent to rakeshreal91@gmail.com.", "cl_event": "", "cl_subjectid": 855, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 855, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 18, "cl_changedfrom": null, "cl_changedto": null, "cl_customproperties": null, "cl_attachment": null, "cl_deviceplatform": null, "cl_deviceipaddress": null, "cl_devicenameversion": null, "cl_devicelocation": null, "cl_causertype": "", "id": "17900", "cl_createdat": "1742898463.000000", "cl_updatedat": "1742898463.000000" } ], "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": [ { "ppm_id": 164, "ppm_grouptypeid": 136, "ppm_fieldid": 2400, "ppm_productid": 38, "ppm_mainsupplier": "21", "ppm_priceincby": 0, "ppm_priceinctype": 0, "ppm_priceinccount": 0, "ppm_domesticmarkup": "0.00", "ppm_domesticmarkuptype": 0, "ppm_trademarkup": "0.00", "ppm_trademarkuptype": 0, "ppm_contractmarkup": "0.00", "ppm_contractmarkuptype": 0, "ppm_ecommercemarkup": "0.00", "ppm_ecommercemarkuptype": 0, "ppm_cusfivemarkup": "0.00", "ppm_cusfivemarkuptype": 0, "ppm_cussixmarkup": "0.00", "ppm_cussixmarkuptype": 0, "ppm_cussevenmarkup": "0.00", "ppm_cussevenmarkuptype": 0, "ppm_cuseightmarkup": "0.00", "ppm_cuseightmarkuptype": 0, "ppm_supplierdiscount": "0.00", "ppm_hidepriceon": 1, "ppm_pricegroupon": "1,2", "ppm_priceinclvat": 0, "ppm_seq": 1, "ppm_status": 0, "ppm_edifieldName": "{\"21\":\"n\"}", "ppm_edifieldCode": "", "ppm_edifieldtag": "", "ppm_edienable": "{\"21\":\"1\"}", "id": "164", "created_at": 1705656362, "updated_at": 1742984549, "created_by": 1, "updated_by": 18 } ], "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": [ { "organization_id": 25, "organizationname": "BlindMatrix Test", "address": "Temple Tower", "address2": "CIT Nagar West", "addres3": "Anna Salai, Nandanam", "city": "Chennai", "state": "Tamilnadu", "country": null, "code": "Tamilnadu", "phone": "9940258697", "mobile1": "6625487895", "mobile2": "6658745879", "fax": "014423", "email3": "test3@blindmatrix.com", "email1": "test1@blindmatrix.com", "email2": "test2@blindmatrix.com", "website": "www.bm.com", "logoname": null, "logo": null, "vatnumber": "dsdsdsa2323232434@##$$%", "vatrate": null, "settlementdiscount": null, "reportemailbody": null, "domesticpaymentterms": null, "contractpaymentterms": null, "tradepaymentterms": null, "companyterms": "Terms", "countryid": 4, "bankname": "SBI", "comregistrationno": "BM0012458", "defaultsalestax": 1, "defaultsalestaxlabel": "GST", "accountnumber": "364583600247", "currencyid": 4, "sortcode": "4545", "status": 0, "isdefault": 1, "id": "25", "created_at": 1657091810, "updated_at": 1742896069, "created_by": 1, "updated_by": 18 } ], "deleted": [] }, "bm_applicationSetup": { "created": [], "updated": [], "deleted": [] } }, "synctodelete": { "bm_tasklist": { "21743000374": 99 } }, "timestamp": 1743062636 }