{ "status": "success", "upcomingorder_list": { "bm_customertemplatedata": { "created": [], "updated": [ { "ctd_id": 575, "ctd_createdfrom": 0, "ctd_templateid": 56, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\":1,\"62\":\"SIVA0004\",\"63\":\"\",\"64\":24,\"690\":25}", "ctd_deletedcustokeyvalue": "{}", "ctd_isenablecustspecvatrate": 0, "ctd_custspecvatrate": "0.00", "ctd_vatregnum": null, "ctd_custsurcharge": null, "ctd_defaultdelcost": null, "ctd_defaultapptype": null, "ctd_defaultstaff": null, "ctd_addcredit": "0.00", "ctd_totredeemed": "0.00", "ctd_balance": "0.00", "ctd_creditlimit": "0.00", "ctd_creditavailable": "0.00", "ctd_overdue": 0, "ctd_paymenttermstype": 0, "ctd_paymenttermsvalue": 0, "ctd_paymenttermsdesc": null, "ctd_ishold": 0, "ctd_jobview": 0, "ctd_jobtypeview": 0, "ctd_discount": "0.00", "ctd_language": 0, "ctd_notymsg": 0, "ctd_onlinelogoname": null, "ctd_onlinelogo": null, "ctd_onlinesendemail": 0, "ctd_fordesktopisenable": 0, "ctd_foronlineisenable": 0, "ctd_enabledproductdesktop": "0", "ctd_enabledproductonline": "0", "ctd_onlineproductmarkup": null, "ctd_onlineendcustomeruseprefix": null, "ctd_onlineendcustomersequence": null, "ctd_onlinequotecustomerterms": null, "ctd_onlinequotepaymentterms": null, "ctd_onlineinvoicecustomerterms": null, "ctd_onlineinvoicepaymentterms": null, "ctd_seq": 0, "ctd_status": 0, "id": "575", "ctd_createdat": 1742277783, "ctd_updatedat": 1743074676, "ctd_createdby": 0, "ctd_updatedby": null } ], "deleted": [] }, "bm_customercontactinfo": { "created": [], "updated": [ { "cci_id": 597, "cci_customerid": 575, "cci_templateid": 52, "roleid": 0, "cci_customizedarray": "{\"75\":17,\"76\":\"963852\",\"77\":\"Siva\",\"78\":\"\",\"79\":\"\",\"81\":2,\"82\":\"\",\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"86\":\"\",\"87\":\"\",\"88\":\"\",\"89\":\"\",\"90\":19,\"91\":\"\"}", "cci_ismarketingemails": 0, "cci_smsverifystatus": 0, "cci_isdocumentreceived": 0, "cci_receiveddocfor": null, "cci_isonlineportal": 0, "cci_latitude": null, "cci_longitude": null, "cci_username": null, "cci_password": null, "cci_confirmpassword": null, "cci_seq": 0, "cci_status": 0, "cci_deviceplatform": 1, "cci_mobcustomertempid": 31742277783, "id": "597", "cci_createdat": 1742277783, "cci_updatedat": 1742803154, "cci_createdby": 0, "cci_updatedby": null } ], "deleted": [] }, "bm_appointment": { "created": [], "updated": [], "deleted": [] }, "bm_tasklist": { "created": [], "updated": [], "deleted": [] }, "bm_jobdetails": { "created": [ { "jd_id": 873, "jd_customerid": 575, "jd_contactid": 597, "jd_additionalcontacts": "597", "jd_templateid": 1, "jd_jobmultiquoteid": 896, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "JBN838", "jd_jobstatus": 3, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "SIVA0004", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "0.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "jd_isroundon": 0, "jd_grossprice": "0.00", "jd_grossprofit": "0.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "0.00", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": null, "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 27, "jd_updatedby": 27, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "3.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"JBN838\",\"35\":\"SIVA0004\",\"36\":3,\"37\":1,\"38\":\"\",\"39\":24,\"40\":1,\"41\":27,\"44\":\"\",\"45\":\"Siva\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":19,\"285\":17,\"286\":\"963852\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"521\":\"\",\"522\":\"\",\"523\":\"\",\"555\":\"\",\"586\":\"\",\"587\":\"\",\"588\":\"\",\"616\":\"\",\"617\":\"\",\"618\":27,\"625\":2,\"633\":\"\",\"634\":\"\",\"666\":\"\",\"667\":\"\",\"700\":\"\",\"701\":\"\",\"702\":1,\"703\":\"\",\"704\":\"\",\"countryText\":\"Australia\",\"customerid\":575,\"contactid\":597}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "3.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "873", "jd_createddate": 1743033600, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1743073596, "jd_updatedat": 1743074677 } ], "updated": [ { "jd_id": 866, "jd_customerid": 162, "jd_contactid": 180, "jd_additionalcontacts": "180", "jd_templateid": 1, "jd_jobmultiquoteid": 889, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "JBN831", "jd_jobstatus": 3, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "TESTING2DB", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "0.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "jd_isroundon": 0, "jd_grossprice": "0.00", "jd_grossprofit": "0.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "0.00", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": null, "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 27, "jd_updatedby": 27, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "3.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":\"25\",\"34\":\"JBN831\",\"35\":\"TESTING2DB\",\"36\":3,\"37\":1,\"38\":\"\",\"39\":21,\"40\":1,\"41\":27,\"44\":\"BlindMatrix\",\"45\":\"Rex John Paul\",\"46\":\"Sivaraj\",\"47\":\"919952916364\",\"48\":\"rexjohnpaul@blindmatrix.com\",\"49\":\"Nandhanam\",\"50\":\"Temple Towers\",\"51\":\"Chennai\",\"52\":\"Tamil Nadu\",\"53\":\"600035\",\"54\":36,\"285\":1,\"286\":\"04424321542\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"521\":\"\",\"522\":\"\",\"523\":\"\",\"555\":\"\",\"586\":\"\",\"587\":\"\",\"588\":\"\",\"616\":\"\",\"617\":\"\",\"618\":27,\"625\":2,\"633\":\"\",\"634\":\"\",\"666\":\"\",\"667\":\"\",\"700\":\"\",\"701\":\"\",\"702\":1,\"703\":\"\",\"704\":\"\",\"countryText\":\"Australia\",\"customerid\":162,\"contactid\":180}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "3.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "866", "jd_createddate": 1743033600, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1743072475, "jd_updatedat": 1743073158 }, { "jd_id": 867, "jd_customerid": 601, "jd_contactid": 623, "jd_additionalcontacts": "623", "jd_templateid": 1, "jd_jobmultiquoteid": 890, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "JBN832", "jd_jobstatus": 3, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "VA4POFGF", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "0.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "jd_isroundon": 0, "jd_grossprice": "0.00", "jd_grossprofit": "0.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "0.00", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": null, "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 27, "jd_updatedby": 27, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "3.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"JBN832\",\"35\":\"VA4POFGF\",\"36\":3,\"37\":1,\"38\":\"\",\"39\":24,\"40\":1,\"41\":27,\"44\":\"\",\"45\":\"\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":17,\"286\":\"04545\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"521\":\"\",\"522\":\"\",\"523\":\"\",\"555\":\"\",\"586\":\"\",\"587\":\"\",\"588\":\"\",\"616\":\"\",\"617\":\"\",\"618\":27,\"625\":2,\"633\":\"\",\"634\":\"\",\"666\":\"\",\"667\":\"\",\"700\":\"\",\"701\":\"\",\"702\":1,\"703\":\"\",\"704\":\"\",\"countryText\":\"Australia\",\"customerid\":601,\"contactid\":623}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "3.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "867", "jd_createddate": 1743033600, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1743072526, "jd_updatedat": 1743073158 }, { "jd_id": 868, "jd_customerid": 162, "jd_contactid": 180, "jd_additionalcontacts": "180", "jd_templateid": 1, "jd_jobmultiquoteid": 891, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "JBN833", "jd_jobstatus": 3, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "TESTING2DB", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "0.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "jd_isroundon": 0, "jd_grossprice": "0.00", "jd_grossprofit": "0.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "0.00", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": null, "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 27, "jd_updatedby": 27, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "3.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":\"25\",\"34\":\"JBN833\",\"35\":\"TESTING2DB\",\"36\":3,\"37\":1,\"38\":\"\",\"39\":21,\"40\":1,\"41\":27,\"44\":\"BlindMatrix\",\"45\":\"Rex John Paul\",\"46\":\"Sivaraj\",\"47\":\"919952916364\",\"48\":\"rexjohnpaul@blindmatrix.com\",\"49\":\"Nandhanam\",\"50\":\"Temple Towers\",\"51\":\"Chennai\",\"52\":\"Tamil Nadu\",\"53\":\"600035\",\"54\":36,\"285\":1,\"286\":\"04424321542\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"521\":\"\",\"522\":\"\",\"523\":\"\",\"555\":\"\",\"586\":\"\",\"587\":\"\",\"588\":\"\",\"616\":\"\",\"617\":\"\",\"618\":27,\"625\":2,\"633\":\"\",\"634\":\"\",\"666\":\"\",\"667\":\"\",\"700\":\"\",\"701\":\"\",\"702\":1,\"703\":\"\",\"704\":\"\",\"countryText\":\"Australia\",\"customerid\":162,\"contactid\":180}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "3.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "868", "jd_createddate": 1743033600, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1743072565, "jd_updatedat": 1743073158 }, { "jd_id": 869, "jd_customerid": 162, "jd_contactid": 180, "jd_additionalcontacts": "180", "jd_templateid": 1, "jd_jobmultiquoteid": 892, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "JBN834", "jd_jobstatus": 3, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "TESTING2DB", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "0.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "jd_isroundon": 0, "jd_grossprice": "0.00", "jd_grossprofit": "0.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "0.00", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": null, "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 27, "jd_updatedby": 27, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "0.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":\"25\",\"34\":\"JBN834\",\"35\":\"TESTING2DB\",\"36\":3,\"37\":1,\"38\":\"\",\"39\":21,\"40\":1,\"41\":27,\"44\":\"BlindMatrix\",\"45\":\"Rex John Paul\",\"46\":\"Sivaraj\",\"47\":\"919952916364\",\"48\":\"rexjohnpaul@blindmatrix.com\",\"49\":\"Nandhanam\",\"50\":\"Temple Towers\",\"51\":\"Chennai\",\"52\":\"Tamil Nadu\",\"53\":\"600035\",\"54\":36,\"285\":1,\"286\":\"04424321542\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"521\":\"\",\"522\":\"\",\"523\":\"\",\"555\":\"\",\"586\":\"\",\"587\":\"\",\"588\":\"\",\"616\":\"\",\"617\":\"\",\"618\":27,\"625\":2,\"633\":\"\",\"634\":\"\",\"666\":\"\",\"667\":\"\",\"700\":\"\",\"701\":\"\",\"702\":1,\"703\":\"\",\"704\":\"\",\"countryText\":\"Australia\",\"customerid\":162,\"contactid\":180}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "0.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "869", "jd_createddate": 1743033600, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1743072588, "jd_updatedat": 1743073159 }, { "jd_id": 870, "jd_customerid": 598, "jd_contactid": 620, "jd_additionalcontacts": "620", "jd_templateid": 1, "jd_jobmultiquoteid": 893, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "JBN835", "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": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "jd_isroundon": 0, "jd_grossprice": "0.00", "jd_grossprofit": "0.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "0.00", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": null, "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 27, "jd_updatedby": 27, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "3.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"JBN835\",\"35\":\"DFDF0005\",\"36\":3,\"37\":1,\"38\":\"\",\"39\":24,\"40\":1,\"41\":27,\"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\":27,\"625\":2,\"633\":\"\",\"634\":\"\",\"666\":\"\",\"667\":\"\",\"700\":\"\",\"701\":\"\",\"702\":1,\"703\":\"\",\"704\":\"\",\"countryText\":\"Australia\",\"customerid\":598,\"contactid\":620}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "3.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "870", "jd_createddate": 1743033600, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1743072619, "jd_updatedat": 1743073159 }, { "jd_id": 871, "jd_customerid": 583, "jd_contactid": 605, "jd_additionalcontacts": "605", "jd_templateid": 1, "jd_jobmultiquoteid": 894, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "JBN836", "jd_jobstatus": 3, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "PRAK0001", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "0.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "jd_isroundon": 0, "jd_grossprice": "0.00", "jd_grossprofit": "0.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "0.00", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": null, "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 27, "jd_updatedby": 27, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "3.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"JBN836\",\"35\":\"PRAK0001\",\"36\":3,\"37\":1,\"38\":\"\",\"39\":24,\"40\":1,\"41\":27,\"44\":\"\",\"45\":\"Apk\",\"46\":\"Prakash\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":17,\"286\":\"7092559688\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"521\":\"\",\"522\":\"\",\"523\":\"\",\"555\":\"\",\"586\":\"\",\"587\":\"\",\"588\":\"\",\"616\":\"\",\"617\":\"\",\"618\":27,\"625\":2,\"633\":\"\",\"634\":\"\",\"666\":\"\",\"667\":\"\",\"700\":\"\",\"701\":\"\",\"702\":1,\"703\":\"\",\"704\":\"\",\"countryText\":\"Australia\",\"customerid\":583,\"contactid\":605}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "3.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "871", "jd_createddate": 1743033600, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1743072980, "jd_updatedat": 1743073159 }, { "jd_id": 872, "jd_customerid": 599, "jd_contactid": 621, "jd_additionalcontacts": "621", "jd_templateid": 1, "jd_jobmultiquoteid": 895, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "JBN837", "jd_jobstatus": 3, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "AJAY0001", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "0.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "jd_isroundon": 0, "jd_grossprice": "0.00", "jd_grossprofit": "0.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "0.00", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": null, "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 27, "jd_updatedby": 27, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "3.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"JBN837\",\"35\":\"AJAY0001\",\"36\":3,\"37\":1,\"38\":\"\",\"39\":24,\"40\":1,\"41\":27,\"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\":27,\"625\":2,\"633\":\"\",\"634\":\"\",\"666\":\"\",\"667\":\"\",\"700\":\"\",\"701\":\"\",\"702\":1,\"703\":\"\",\"704\":\"\",\"countryText\":\"Australia\",\"customerid\":599,\"contactid\":621}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "3.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "872", "jd_createddate": 1743033600, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1743073062, "jd_updatedat": 1743073159 }, { "jd_id": 873, "jd_customerid": 575, "jd_contactid": 597, "jd_additionalcontacts": "597", "jd_templateid": 1, "jd_jobmultiquoteid": 896, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "JBN838", "jd_jobstatus": 3, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "SIVA0004", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "0.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "jd_isroundon": 0, "jd_grossprice": "0.00", "jd_grossprofit": "0.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "0.00", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": null, "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 27, "jd_updatedby": 27, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "3.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"JBN838\",\"35\":\"SIVA0004\",\"36\":3,\"37\":1,\"38\":\"\",\"39\":24,\"40\":1,\"41\":27,\"44\":\"\",\"45\":\"Siva\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":19,\"285\":17,\"286\":\"963852\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"521\":\"\",\"522\":\"\",\"523\":\"\",\"555\":\"\",\"586\":\"\",\"587\":\"\",\"588\":\"\",\"616\":\"\",\"617\":\"\",\"618\":27,\"625\":2,\"633\":\"\",\"634\":\"\",\"666\":\"\",\"667\":\"\",\"700\":\"\",\"701\":\"\",\"702\":1,\"703\":\"\",\"704\":\"\",\"countryText\":\"Australia\",\"customerid\":575,\"contactid\":597}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "3.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "873", "jd_createddate": 1743033600, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1743073596, "jd_updatedat": 1743074677 } ], "deleted": [] }, "bm_orderitem": { "created": [ { "oi_id": 2142, "oi_jobid": 0, "oi_jobtempid": "a8daa718", "oi_jobmultiquoteid": null, "oi_productid": 59, "oi_recipeid": 64, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 59, "oi_customseq": 1, "oi_productcustomseq": 2, "oi_jsondata": "[{\"id\":6514,\"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\":6514,\"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\":4675,\"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\":4675,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4676,\"labelname\":\"Supplier\",\"value\":null,\"valueid\":null,\"type\":17,\"optionid\":null,\"optionvalue\":[],\"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\":4676,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4678,\"labelname\":\"Room\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Room\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Room\",\"fieldid\":4678,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4680,\"labelname\":\"Width\",\"value\":null,\"valueid\":null,\"type\":11,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Width2222\",\"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\":4680,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":5339,\"labelname\":\"Drop\",\"value\":null,\"valueid\":null,\"type\":12,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Drop3333\",\"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\":5339,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4679,\"labelname\":\"Blind or Recess\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Blind or Recess\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Blind or Recess\",\"fieldid\":4679,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4677,\"labelname\":\"Product Type\",\"value\":null,\"valueid\":null,\"type\":13,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Product Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":13,\"mandatory\":0,\"fieldname\":\"Product Type\",\"fieldid\":4677,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4683,\"labelname\":\"Control Type\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Control Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Control Type\",\"fieldid\":4683,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4684,\"labelname\":\"Control Side\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Control Side\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Control Side\",\"fieldid\":4684,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4682,\"labelname\":\"Bunch\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Bunch\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Bunch\",\"fieldid\":4682,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4685,\"labelname\":\"Headrail System\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Headrail System\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Headrail System\",\"fieldid\":4685,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4686,\"labelname\":\"Headrail Colour\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Headrail Colour\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Headrail Colour\",\"fieldid\":4686,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4687,\"labelname\":\"Extras\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Extras\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Extras\",\"fieldid\":4687,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":5251,\"labelname\":\"Brackets\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Brackets\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Brackets\",\"fieldid\":5251,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4688,\"labelname\":\"Special Instructions\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Special Instructions\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Special Instructions\",\"fieldid\":4688,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":5340,\"labelname\":\"Numeric 1\",\"value\":null,\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Numeric 1\",\"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 1\",\"fieldid\":5340,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":5341,\"labelname\":\"Location_List\",\"value\":null,\"valueid\":null,\"type\":4,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Location_List\",\"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\":4,\"mandatory\":0,\"fieldname\":\"Location_List\",\"fieldid\":5341,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":5342,\"labelname\":\"Location_Text\",\"value\":null,\"valueid\":null,\"type\":29,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Location_Text\",\"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\":29,\"mandatory\":0,\"fieldname\":\"Location_Text\",\"fieldid\":5342,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":5347,\"labelname\":\"Test\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Test\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Test\",\"fieldid\":5347,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7545,\"labelname\":\"bigheight\",\"value\":null,\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"bigheight\",\"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\":\"bigheight\",\"fieldid\":7545,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7546,\"labelname\":\"smallheight\",\"value\":null,\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"smallheight\",\"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\":\"smallheight\",\"fieldid\":7546,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "", "oi_reportdescription": "##Quantity: 1##", "oi_reporttitles": "##Quantity:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":null,\"value\":\"-\",\"formula\":null,\"price\":null,\"recipeid\":null,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":null,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":599,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":64,\"stockupdate\":0,\"fieldid\":9442,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Dimmer Emitter 4 Channels SOURCE\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":1177,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":64,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":437,\"value\":null,\"formula\":\"Quantity\",\"price\":null,\"recipeid\":64,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":438,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":64,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":439,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":64,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":440,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":64,\"stockupdate\":0,\"fieldid\":5590,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Dimmer Emitter 4 Channels SOURCE\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":441,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":64,\"stockupdate\":0,\"fieldid\":5606,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Casstte tube\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":442,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":64,\"stockupdate\":0,\"fieldid\":5607,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"100Banna2\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":443,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":64,\"stockupdate\":0,\"fieldid\":5608,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"100Banna3\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":444,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":64,\"stockupdate\":0,\"fieldid\":5609,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"100W 24V Transformer IP65\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":445,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":64,\"stockupdate\":0,\"fieldid\":5611,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"100W 24V Transformer IP65 SOURCE\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":446,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":64,\"stockupdate\":0,\"fieldid\":5626,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"1500mm arms LIVE\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":447,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":64,\"stockupdate\":0,\"fieldid\":5627,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"1500mm arms SOURCE\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":1178,\"value\":null,\"formula\":\"Atan((bigheight-smallheight)\\\/Width2222)\",\"price\":\"NaN\",\"recipeid\":64,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":1179,\"value\":\"25.00\",\"formula\":\"Power(5,2)\",\"price\":\"25.00\",\"recipeid\":64,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"25.00\"},{\"productionoveride\":0,\"id\":1180,\"value\":\"0.84\",\"formula\":\"Sin(1)\",\"price\":\"0.84\",\"recipeid\":64,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"0.84\"}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"0.00\",\"cost_with_discount\":\"0.00\",\"cost_with_markup\":\"0.00\",\"gross_price\":\"0.00\",\"vat_price\":\"0.00\"}", "oi_pricecomesfrom_calculations": "{\"label\":\"Price table cost\",\"unit_type\":\"-\",\"cost_price\":\"0.00\",\"show_hide\":true,\"category\":3}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "25.840", "oi_netprice": "25.840", "oi_pricesfromoperations": null, "oi_vatprice": "0.780", "oi_vatvalue": "3.000", "oi_vatselected": 3, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "26.620", "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": "25.840", "oi_endcustomeroverridevatprice": "0.780", "oi_endcustomeroverridegrossprice": "26.620", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[6514, 4675, 4676, 4678, 4680, 5339, 4679, 4677, 4683, 4684, 4682, 4685, 4686, 4687, 5251, 4688, 5340, 5341, 5342, 5347, 7545, 7546]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "2142", "oi_productiondate": 1743083790, "oi_createdat": 1743083790, "oi_updatedat": 1743064023, "oi_createdby": 18, "oi_updatedby": null }, { "oi_id": 2143, "oi_jobid": 0, "oi_jobtempid": "a8daa718", "oi_jobmultiquoteid": null, "oi_productid": 59, "oi_recipeid": 64, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 60, "oi_customseq": 2, "oi_productcustomseq": 3, "oi_jsondata": "[{\"id\":6514,\"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\":6514,\"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\":4675,\"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\":4675,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4676,\"labelname\":\"Supplier\",\"value\":null,\"valueid\":null,\"type\":17,\"optionid\":null,\"optionvalue\":[],\"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\":4676,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4678,\"labelname\":\"Room\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Room\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Room\",\"fieldid\":4678,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4680,\"labelname\":\"Width\",\"value\":null,\"valueid\":null,\"type\":11,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Width2222\",\"fabricorcolor\":0,\"widthfraction\":\"0___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\":4680,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":5339,\"labelname\":\"Drop\",\"value\":null,\"valueid\":null,\"type\":12,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Drop3333\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":\"0___0\",\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":12,\"mandatory\":0,\"fieldname\":\"Drop\",\"fieldid\":5339,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4679,\"labelname\":\"Blind or Recess\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Blind or Recess\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Blind or Recess\",\"fieldid\":4679,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4677,\"labelname\":\"Product Type\",\"value\":null,\"valueid\":null,\"type\":13,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Product Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":13,\"mandatory\":0,\"fieldname\":\"Product Type\",\"fieldid\":4677,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4683,\"labelname\":\"Control Type\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Control Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Control Type\",\"fieldid\":4683,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4684,\"labelname\":\"Control Side\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Control Side\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Control Side\",\"fieldid\":4684,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4682,\"labelname\":\"Bunch\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Bunch\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Bunch\",\"fieldid\":4682,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4685,\"labelname\":\"Headrail System\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Headrail System\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Headrail System\",\"fieldid\":4685,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4686,\"labelname\":\"Headrail Colour\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Headrail Colour\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Headrail Colour\",\"fieldid\":4686,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4687,\"labelname\":\"Extras\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Extras\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Extras\",\"fieldid\":4687,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":5251,\"labelname\":\"Brackets\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Brackets\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Brackets\",\"fieldid\":5251,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4688,\"labelname\":\"Special Instructions\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Special Instructions\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Special Instructions\",\"fieldid\":4688,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":5340,\"labelname\":\"Numeric 1\",\"value\":null,\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Numeric 1\",\"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 1\",\"fieldid\":5340,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":5341,\"labelname\":\"Location_List\",\"value\":null,\"valueid\":null,\"type\":4,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Location_List\",\"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\":4,\"mandatory\":0,\"fieldname\":\"Location_List\",\"fieldid\":5341,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":5342,\"labelname\":\"Location_Text\",\"value\":null,\"valueid\":null,\"type\":29,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Location_Text\",\"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\":29,\"mandatory\":0,\"fieldname\":\"Location_Text\",\"fieldid\":5342,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":5347,\"labelname\":\"Test\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Test\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Test\",\"fieldid\":5347,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7545,\"labelname\":\"bigheight\",\"value\":null,\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"bigheight\",\"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\":\"bigheight\",\"fieldid\":7545,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7546,\"labelname\":\"smallheight\",\"value\":null,\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"smallheight\",\"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\":\"smallheight\",\"fieldid\":7546,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "", "oi_reportdescription": "##Quantity: 1##", "oi_reporttitles": "##Quantity:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":null,\"value\":\"-\",\"formula\":null,\"price\":null,\"recipeid\":null,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":null,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":599,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":64,\"stockupdate\":0,\"fieldid\":9442,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Dimmer Emitter 4 Channels SOURCE\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":1177,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":64,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":437,\"value\":null,\"formula\":\"Quantity\",\"price\":null,\"recipeid\":64,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":438,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":64,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":439,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":64,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":440,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":64,\"stockupdate\":0,\"fieldid\":5590,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Dimmer Emitter 4 Channels SOURCE\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":441,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":64,\"stockupdate\":0,\"fieldid\":5606,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Casstte tube\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":442,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":64,\"stockupdate\":0,\"fieldid\":5607,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"100Banna2\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":443,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":64,\"stockupdate\":0,\"fieldid\":5608,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"100Banna3\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":444,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":64,\"stockupdate\":0,\"fieldid\":5609,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"100W 24V Transformer IP65\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":445,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":64,\"stockupdate\":0,\"fieldid\":5611,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"100W 24V Transformer IP65 SOURCE\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":446,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":64,\"stockupdate\":0,\"fieldid\":5626,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"1500mm arms LIVE\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":447,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":64,\"stockupdate\":0,\"fieldid\":5627,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"1500mm arms SOURCE\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":1178,\"value\":null,\"formula\":\"Atan((bigheight-smallheight)\\\/Width2222)\",\"price\":\"NaN\",\"recipeid\":64,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":1179,\"value\":\"25.00\",\"formula\":\"Power(5,2)\",\"price\":\"25.00\",\"recipeid\":64,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"25.00\"},{\"productionoveride\":0,\"id\":1180,\"value\":\"0.84\",\"formula\":\"Sin(1)\",\"price\":\"0.84\",\"recipeid\":64,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"0.84\"}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"0.00\",\"cost_with_discount\":\"0.00\",\"cost_with_markup\":\"0.00\",\"gross_price\":\"0.00\",\"vat_price\":\"0.00\"}", "oi_pricecomesfrom_calculations": "{\"label\":\"Price table cost\",\"unit_type\":\"-\",\"cost_price\":\"0.00\",\"show_hide\":true,\"category\":3}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "25.840", "oi_netprice": "25.840", "oi_pricesfromoperations": null, "oi_vatprice": "0.780", "oi_vatvalue": "3.000", "oi_vatselected": 3, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "26.620", "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": "25.840", "oi_endcustomeroverridevatprice": "0.780", "oi_endcustomeroverridegrossprice": "26.620", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[6514, 4675, 4676, 4678, 4680, 5339, 4679, 4677, 4683, 4684, 4682, 4685, 4686, 4687, 5251, 4688, 5340, 5341, 5342, 5347, 7545, 7546]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "2143", "oi_productiondate": 1743083802, "oi_createdat": 1743083802, "oi_updatedat": 1743064023, "oi_createdby": 18, "oi_updatedby": null }, { "oi_id": 2144, "oi_jobid": 0, "oi_jobtempid": "a8daa718", "oi_jobmultiquoteid": null, "oi_productid": 39, "oi_recipeid": 39, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 61, "oi_customseq": 3, "oi_productcustomseq": 3, "oi_jsondata": "[{\"id\":6494,\"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\":6494,\"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\":2444,\"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\":2444,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2445,\"labelname\":\"Supplier\",\"value\":23,\"valueid\":null,\"type\":17,\"optionid\":23,\"optionvalue\":[{\"id\":23,\"optionid\":23,\"optionname\":\"Decora\",\"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\":2445,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":23,\"optionsvalue\":[{\"id\":23,\"optionid\":23,\"optionname\":\"Decora\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":2447,\"labelname\":\"Room\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Room\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Room\",\"fieldid\":2447,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2448,\"labelname\":\"Width\",\"value\":null,\"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\":2448,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2449,\"labelname\":\"Drop\",\"value\":null,\"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\":2449,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2446,\"labelname\":\"Product Type\",\"value\":null,\"valueid\":null,\"type\":13,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Product Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":13,\"mandatory\":0,\"fieldname\":\"Product Type\",\"fieldid\":2446,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2452,\"labelname\":\"Fabric\",\"value\":null,\"valueid\":null,\"type\":5,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fabric\",\"fabricorcolor\":1,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":5,\"mandatory\":0,\"fieldname\":\"Fabric\",\"fieldid\":2452,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2450,\"labelname\":\"Extras\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Extras\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Extras\",\"fieldid\":2450,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2451,\"labelname\":\"Special Instructions\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Special Instructions\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Special Instructions\",\"fieldid\":2451,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Supplier: Decora", "oi_reportdescription": "##Quantity: 1##,##Supplier: Decora##", "oi_reporttitles": "##Quantity:<\/br>##Supplier:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":null,\"value\":\"-\",\"formula\":null,\"price\":null,\"recipeid\":null,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":null,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":1193,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":39,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":506,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":39,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":507,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":39,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":508,\"value\":null,\"formula\":\"Width\",\"price\":\"-\",\"recipeid\":39,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":509,\"value\":null,\"formula\":\"Drop\",\"price\":\"-\",\"recipeid\":39,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":510,\"value\":null,\"formula\":\"Width+Drop\",\"price\":\"-\",\"recipeid\":39,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[{\"link_id\":57,\"process_id\":25,\"product_id\":39,\"phc_id\":57,\"pd_id\":25,\"name\":\"Process 1\",\"phc_linkstations\":1,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":1,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"10.00\",\"phc_contractsellingprice\":\"10.00\",\"phc_tradesellingprice\":\"10.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"10.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"10.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"10.00\",\"price\":\"0.00\"},{\"link_id\":58,\"process_id\":26,\"product_id\":39,\"phc_id\":58,\"pd_id\":26,\"name\":\"Process 2\",\"phc_linkstations\":2,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":1,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"15.00\",\"phc_contractsellingprice\":\"15.00\",\"phc_tradesellingprice\":\"15.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"15.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"15.00\",\"Hour\\\/mins\":\"10 mins\",\"phc_processcostid\":1,\"markupprice\":\"15.00\",\"price\":\"0.00\"}]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"25.00\",\"cost_with_discount\":\"25.00\",\"cost_with_markup\":\"25.00\",\"gross_price\":\"25.75\",\"vat_price\":\"0.75\"}", "oi_pricecomesfrom_calculations": "{\"label\":\"Price table cost\",\"unit_type\":\"-\",\"cost_price\":\"0.00\",\"show_hide\":true,\"category\":3}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "25.000", "oi_netprice": "25.000", "oi_pricesfromoperations": null, "oi_vatprice": "0.750", "oi_vatvalue": "3.000", "oi_vatselected": 3, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "25.750", "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": "25.000", "oi_endcustomeroverridevatprice": "0.750", "oi_endcustomeroverridegrossprice": "25.750", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[6494, 2444, 2445, 2447, 2448, 2449, 2446, 2452, 2450, 2451]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "2144", "oi_productiondate": 1743083815, "oi_createdat": 1743083815, "oi_updatedat": 1743064023, "oi_createdby": 18, "oi_updatedby": null }, { "oi_id": 2145, "oi_jobid": 852, "oi_jobtempid": "0", "oi_jobmultiquoteid": 875, "oi_productid": 39, "oi_recipeid": 39, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 2, "oi_customseq": 2, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":6494,\"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\":6494,\"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\":2444,\"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\":2444,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2445,\"labelname\":\"Supplier\",\"value\":23,\"valueid\":null,\"type\":17,\"optionid\":23,\"optionvalue\":[{\"id\":23,\"optionid\":23,\"optionname\":\"Decora\",\"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\":2445,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":23,\"optionsvalue\":[{\"id\":23,\"optionid\":23,\"optionname\":\"Decora\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":2447,\"labelname\":\"Room\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Room\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Room\",\"fieldid\":2447,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2448,\"labelname\":\"Width\",\"value\":null,\"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\":2448,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2449,\"labelname\":\"Drop\",\"value\":null,\"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\":2449,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2446,\"labelname\":\"Product Type\",\"value\":null,\"valueid\":null,\"type\":13,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Product Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":13,\"mandatory\":0,\"fieldname\":\"Product Type\",\"fieldid\":2446,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2452,\"labelname\":\"Fabric\",\"value\":null,\"valueid\":null,\"type\":5,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fabric\",\"fabricorcolor\":1,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":5,\"mandatory\":0,\"fieldname\":\"Fabric\",\"fieldid\":2452,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2450,\"labelname\":\"Extras\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Extras\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Extras\",\"fieldid\":2450,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2451,\"labelname\":\"Special Instructions\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Special Instructions\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Special Instructions\",\"fieldid\":2451,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Supplier: Decora", "oi_reportdescription": "##Quantity: 1##,##Supplier: Decora##", "oi_reporttitles": "##Quantity:<\/br>##Supplier:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":null,\"value\":\"-\",\"formula\":null,\"price\":null,\"recipeid\":null,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":null,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":1193,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":39,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":506,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":39,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":507,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":39,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":508,\"value\":null,\"formula\":\"Width\",\"price\":\"-\",\"recipeid\":39,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":509,\"value\":null,\"formula\":\"Drop\",\"price\":\"-\",\"recipeid\":39,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":510,\"value\":null,\"formula\":\"Width+Drop\",\"price\":\"-\",\"recipeid\":39,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[{\"link_id\":58,\"process_id\":26,\"product_id\":39,\"phc_id\":58,\"pd_id\":26,\"name\":\"Process 2\",\"phc_linkstations\":2,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":1,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"15.00\",\"phc_contractsellingprice\":\"15.00\",\"phc_tradesellingprice\":\"15.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"15.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"15.00\",\"Hour\\\/mins\":\"10 mins\",\"phc_processcostid\":1,\"markupprice\":\"15.00\",\"price\":\"0.00\"},{\"link_id\":57,\"process_id\":25,\"product_id\":39,\"phc_id\":57,\"pd_id\":25,\"name\":\"Process 1\",\"phc_linkstations\":1,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":1,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"10.00\",\"phc_contractsellingprice\":\"10.00\",\"phc_tradesellingprice\":\"10.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"10.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"10.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"10.00\",\"price\":\"0.00\"}]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"25.00\",\"cost_with_discount\":\"25.00\",\"cost_with_markup\":\"25.00\",\"gross_price\":\"25.75\",\"vat_price\":\"0.75\"}", "oi_pricecomesfrom_calculations": "{\"label\":\"Price table cost\",\"unit_type\":\"-\",\"cost_price\":\"0.00\",\"show_hide\":true,\"category\":3}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "25.000", "oi_netprice": "25.000", "oi_pricesfromoperations": null, "oi_vatprice": "0.750", "oi_vatvalue": "3.000", "oi_vatselected": 3, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "25.750", "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": "25.000", "oi_endcustomeroverridevatprice": "0.750", "oi_endcustomeroverridegrossprice": "25.750", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[6494, 2444, 2445, 2447, 2448, 2449, 2446, 2452, 2450, 2451]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "2145", "oi_productiondate": 1743083893, "oi_createdat": 1743083893, "oi_updatedat": 1743064105, "oi_createdby": 18, "oi_updatedby": null }, { "oi_id": 2146, "oi_jobid": 0, "oi_jobtempid": "61b68962", "oi_jobmultiquoteid": null, "oi_productid": 38, "oi_recipeid": 38, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 62, "oi_customseq": 1, "oi_productcustomseq": 9, "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": "2146", "oi_productiondate": 1743084249, "oi_createdat": 1743084249, "oi_updatedat": 1743064458, "oi_createdby": 18, "oi_updatedby": null }, { "oi_id": 2147, "oi_jobid": 856, "oi_jobtempid": "0", "oi_jobmultiquoteid": 879, "oi_productid": 3, "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\":null,\"valueid\":null,\"type\":17,\"optionid\":null,\"optionvalue\":[],\"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\":null,\"optionsvalue\":[],\"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": "width: 1500, drop: 2000", "oi_reportdescription": "##Quantity: 1##,##width: 1500 mm##,##drop: 2000 mm##", "oi_reporttitles": "##Quantity:<\/br>##width:<\/br>##drop:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":null,\"value\":\"-\",\"formula\":null,\"price\":null,\"recipeid\":null,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":null,\"fieldtype_id\":0,\"fractionvalue\":null},{\"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\":null,\"formula\":\"width\",\"price\":null,\"recipeid\":38,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"0.00\",\"cost_with_discount\":\"0.00\",\"cost_with_markup\":\"0.00\",\"gross_price\":\"0.00\",\"vat_price\":\"0.00\"}", "oi_pricecomesfrom_calculations": "{\"label\":\"Price table cost\",\"unit_type\":\"-\",\"cost_price\":\"0.00\",\"show_hide\":true,\"category\":3}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "1500.000", "oi_netprice": "1500.000", "oi_pricesfromoperations": null, "oi_vatprice": "45.000", "oi_vatvalue": "3.000", "oi_vatselected": 3, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "1545.000", "oi_overrideprice": "0.000", "oi_overridetype": 1, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "1500.000", "oi_endcustomeroverridevatprice": "45.000", "oi_endcustomeroverridegrossprice": "1545.000", "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": "2147", "oi_productiondate": 1743085402, "oi_createdat": 1743085402, "oi_updatedat": 1743065619, "oi_createdby": 18, "oi_updatedby": null }, { "oi_id": 2148, "oi_jobid": 0, "oi_jobtempid": "650bc391", "oi_jobmultiquoteid": null, "oi_productid": 3, "oi_recipeid": 3, "oi_ruleid": 0, "oi_qty": 0, "oi_seq": 63, "oi_customseq": 1, "oi_productcustomseq": 9, "oi_jsondata": "[{\"id\":6461,\"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\":6461,\"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\":18,\"labelname\":\"Supplier\",\"value\":\"3\",\"valueid\":null,\"type\":17,\"optionid\":\"3\",\"optionvalue\":[{\"id\":3,\"optionid\":3,\"optionname\":\"PRODUCT SUPPLIER\",\"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\":18,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"3\",\"optionsvalue\":[{\"id\":3,\"optionid\":3,\"optionname\":\"PRODUCT SUPPLIER\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":20,\"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\":20,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":21,\"labelname\":\"Drop\",\"value\":\"1500\",\"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\":21,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":19,\"labelname\":\"Product Type\",\"value\":\"34\",\"valueid\":\"37\",\"type\":13,\"optionid\":\"34\",\"optionvalue\":[{\"id\":37,\"fieldid\":19,\"fieldoptionlinkid\":37,\"optionid\":34,\"mainsupplier\":\"3\",\"blindtypecode\":null,\"optionname\":\"Verna 06\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"issubfabric\":0,\"labelnamecode\":\"Product Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":13,\"mandatory\":0,\"fieldname\":\"Product Type\",\"fieldid\":19,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"34\",\"optionsvalue\":[{\"id\":37,\"fieldid\":19,\"fieldoptionlinkid\":37,\"optionid\":34,\"mainsupplier\":\"3\",\"blindtypecode\":null,\"optionname\":\"Verna 06\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"editruleoverride\":1},{\"id\":22,\"labelname\":\"Extras\",\"value\":\"Cable Kit for Led in Front Profile LIVE,LED Strip 7mtr LIVE,Zeep,One\",\"valueid\":\"263,264,266,262\",\"type\":3,\"optionid\":\"174,173,181,43\",\"optionvalue\":[{\"optionid\":174,\"optionqty\":\"1\",\"optionname\":\"Cable Kit for Led in Front Profile LIVE\",\"optioncode\":\"95 002 013 000_Panther\",\"description\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":263,\"forchildfieldoptionlinkid\":\"3_263\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":173,\"optionqty\":\"1\",\"optionname\":\"LED Strip 7mtr LIVE\",\"optioncode\":\"43 010 001 000_Panther\",\"description\":null,\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":264,\"forchildfieldoptionlinkid\":\"3_264\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":181,\"optionqty\":\"1\",\"optionname\":\"Zeep\",\"optioncode\":\"Zs001\",\"description\":\"des\",\"unittype\":\"Each\",\"unitcost\":20.17,\"fieldoptionlinkid\":266,\"forchildfieldoptionlinkid\":\"3_266\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"40.34\",\"costprice\":20.17,\"costwithdiscount\":20.17,\"customersellingprice\":40.34,\"customermarkupvalue\":2,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":20.17},{\"optionid\":43,\"optionqty\":\"1\",\"optionname\":\"One\",\"optioncode\":\"ON0025\",\"description\":\"des\",\"unittype\":\"Each\",\"unitcost\":26.759999999999998,\"fieldoptionlinkid\":262,\"forchildfieldoptionlinkid\":\"3_262\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"133.80\",\"costprice\":26.76,\"costwithdiscount\":26.76,\"customersellingprice\":133.8,\"customermarkupvalue\":5,\"optiontype\":2,\"quantity\":1,\"optionnetprice\":26.759999999999998}],\"issubfabric\":0,\"labelnamecode\":\"Extras\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1,1,1,1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Extras\",\"fieldid\":22,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"174,173,181,43\",\"optionsvalue\":[{\"optionid\":174,\"optionqty\":\"1\",\"optionname\":\"Cable Kit for Led in Front Profile LIVE\",\"optioncode\":\"95 002 013 000_Panther\",\"description\":null,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":263,\"forchildfieldoptionlinkid\":\"3_263\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":173,\"optionqty\":\"1\",\"optionname\":\"LED Strip 7mtr LIVE\",\"optioncode\":\"43 010 001 000_Panther\",\"description\":null,\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":264,\"forchildfieldoptionlinkid\":\"3_264\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":181,\"optionqty\":\"1\",\"optionname\":\"Zeep\",\"optioncode\":\"Zs001\",\"description\":\"des\",\"unittype\":\"Each\",\"unitcost\":20.17,\"fieldoptionlinkid\":266,\"forchildfieldoptionlinkid\":\"3_266\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"40.34\",\"costprice\":20.17,\"costwithdiscount\":20.17,\"customersellingprice\":40.34,\"customermarkupvalue\":2,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":20.17},{\"optionid\":43,\"optionqty\":\"1\",\"optionname\":\"One\",\"optioncode\":\"ON0025\",\"description\":\"des\",\"unittype\":\"Each\",\"unitcost\":26.759999999999998,\"fieldoptionlinkid\":262,\"forchildfieldoptionlinkid\":\"3_262\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"133.80\",\"costprice\":26.76,\"costwithdiscount\":26.76,\"customersellingprice\":133.8,\"customermarkupvalue\":5,\"optiontype\":2,\"quantity\":1,\"optionnetprice\":26.759999999999998}],\"editruleoverride\":0},{\"id\":23,\"labelname\":\"Fabric\",\"value\":null,\"valueid\":null,\"type\":5,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fabric\",\"fabricorcolor\":1,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":5,\"mandatory\":0,\"fieldname\":\"Fabric\",\"fieldid\":23,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2213,\"labelname\":\"Test3fgfgf\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Test3fgfgf\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Test3fgfgf\",\"fieldid\":2213,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2209,\"labelname\":\"Test3\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Test3\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Test3\",\"fieldid\":2209,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2210,\"labelname\":\"Extra\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"ExtraTest03\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Extra\",\"fieldid\":2210,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2211,\"labelname\":\"tess\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"tess\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"tess\",\"fieldid\":2211,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2223,\"labelname\":\"Text\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Text\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Text\",\"fieldid\":2223,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2224,\"labelname\":\"Number\",\"value\":null,\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Number\",\"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\":\"Number\",\"fieldid\":2224,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2292,\"labelname\":\"HHH\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"HHH\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"HHH\",\"fieldid\":2292,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7505,\"labelname\":\"Product Type2\",\"value\":null,\"valueid\":null,\"type\":13,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Product Type2PG2\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":13,\"mandatory\":0,\"fieldname\":\"Product Type2\",\"fieldid\":7505,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Supplier: PRODUCT SUPPLIER, Width: 1500, Drop: 1500, Product Type: Verna 06, Extras: Cable Kit for Led in Front Profile LIVE,LED Strip 7mtr LIVE,Zeep,One", "oi_reportdescription": "##Supplier: PRODUCT SUPPLIER##,##Width: 1500 mm##,##Drop: 1500 mm##,##Product Type: Verna 06##,##Extras: Cable Kit for Led in Front Profile LIVE,LED Strip 7mtr LIVE,Zeep,One##", "oi_reporttitles": "##Supplier:<\/br>##Width:<\/br>##Drop:<\/br>##Product Type:<\/br>##Extras:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":null,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":null,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":null,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":156,\"value\":null,\"formula\":\"Quantity\",\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":191,\"value\":\"4.00\",\"formula\":\"Extras_OptionQty\",\"price\":\"107.04\",\"recipeid\":3,\"stockupdate\":0,\"fieldid\":262,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"One\",\"list_option_name\":\"One\",\"list_description\":\"des\",\"list_option_code\":\"ON0025\",\"list_unit_type\":\"Each\",\"fractionvalue\":\"4.00\"},{\"productionoveride\":0,\"id\":192,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":266,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Zeep\",\"list_option_name\":\"Zeep\",\"list_description\":\"des\",\"list_option_code\":\"Zs001\",\"list_unit_type\":\"Each\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":194,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1278,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear1\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":195,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1279,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear2\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":196,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1280,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear3\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":197,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1281,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear4\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":198,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1282,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear5\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":199,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1283,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear6\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":200,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1284,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear7\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":201,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1285,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear8\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":202,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1286,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear9\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":203,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1287,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear10\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":204,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1288,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear11\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":205,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1289,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear12\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":206,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1290,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear13\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":207,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1291,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear14\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":208,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1292,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear15\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":209,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1293,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear16\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":210,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1294,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear17\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":211,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1295,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear18\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":212,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1296,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear19\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":213,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1297,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear20\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":214,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1298,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear21\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":215,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1299,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear22\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":216,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1300,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear23\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":217,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1301,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear24\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":218,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1302,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear25\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":219,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1303,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear26\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":220,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1304,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear27\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":221,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1305,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear28\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":222,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1306,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear29\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":223,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1307,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear30\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":224,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1308,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear31\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":225,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1309,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear32\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":226,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1310,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear33\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":227,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1311,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear34\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":228,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1312,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear35\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":229,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1313,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear36\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":230,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1314,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear37\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":231,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1315,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear38\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":232,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1316,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear39\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":233,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1317,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear40\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":234,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1318,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear41\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":235,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1319,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear42\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":236,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1320,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear43\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":237,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1321,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear44\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":238,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1322,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear45\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":239,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1323,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear46\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":240,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1324,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear47\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":241,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1325,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear48\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":242,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1326,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear49\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":243,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1327,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear50\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":244,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1328,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear51\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":245,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1329,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear52\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":246,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":1330,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Gear53\",\"fractionvalue\":null}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"0.00\",\"cost_with_discount\":\"0.00\",\"cost_with_markup\":\"0.00\",\"gross_price\":\"0.00\",\"vat_price\":\"0.00\"}", "oi_pricecomesfrom_calculations": "{\"label\":\"Price table cost\",\"unit_type\":\"-\",\"cost_price\":\"104.44\",\"show_hide\":true,\"category\":3}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "151.370", "oi_netprice": "591.900", "oi_pricesfromoperations": null, "oi_vatprice": "17.760", "oi_vatvalue": "3.000", "oi_vatselected": 3, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "609.660", "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": "591.900", "oi_endcustomeroverridevatprice": "17.760", "oi_endcustomeroverridegrossprice": "609.660", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[6461, 18, 20, 21, 19, 22, 23, 2213, 2209, 2210, 2211, 2223, 2224, 2292, 7505]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "2148", "oi_productiondate": 1743085345, "oi_createdat": 1743085345, "oi_updatedat": 1743065708, "oi_createdby": 18, "oi_updatedby": null } ], "updated": [], "deleted": [] }, "bm_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_notelist": { "created": [], "updated": [], "deleted": [] }, "bm_deliveryaddresssetting": { "created": [], "updated": [], "deleted": [] }, "bm_jobchecklist": { "created": [], "updated": [], "deleted": [] }, "bm_Invoice": { "created": [], "updated": [], "deleted": [] }, "bm_InvoiceDetails": { "created": [], "updated": [], "deleted": [] }, "bm_invoice_credit_note": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNote": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNoteDetails": { "created": [], "updated": [], "deleted": [] }, "bm_job_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_OverPayment": { "created": [], "updated": [], "deleted": [] }, "bm_terms": { "created": [], "updated": [], "deleted": [] }, "bm_jobmultiquote": { "created": [ { "jmq_id": 896, "jmq_jobid": 873, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "0.00", "jmq_netprice": "0.00", "jmq_vat": "0.00", "jmq_isvaton": 1, "jmq_deliverycost": "0.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 1, "jmq_orderformprice": "0.00", "jmq_editpricebyid": null, "jmq_isroundon": 0, "jmq_grossprice": "0.00", "jmq_grossprofit": "0.00", "jmq_costprice": "0.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "0.00", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": null, "jmq_deliverycostid": 0, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 0, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 0, "jmq_endcustomeroverridevalue": null, "jmq_endcustomeroverridenetprice": "0.00", "jmq_endcustomeroverridevatprice": "0.00", "jmq_endcustomeroverridegrossprice": "0.00", "jmq_endcustomerdeliverycost": null, "jmq_endcustomerdeliverycostinclvat": 0, "jmq_endcustomerfittingcost": null, "jmq_endcustomerfittingcostinclvat": 0, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "3.000", "jmq_cdeliveryvatperc": "3.000", "id": "896", "jmq_duedate": null, "jmq_sceduleddate": null, "jmq_createdat": "1743073596.000000", "jmq_updatedat": null, "jmq_createdby": 27, "jmq_updatedby": null } ], "updated": [], "deleted": [] }, "bm_jobstatus_tracks": { "created": [ { "jst_id": 923, "jst_jobid": 866, "jst_job_current_status": 3, "id": "923", "jst_createdat": "1743073157.734235" }, { "jst_id": 924, "jst_jobid": 867, "jst_job_current_status": 3, "id": "924", "jst_createdat": "1743073157.915048" }, { "jst_id": 925, "jst_jobid": 868, "jst_job_current_status": 3, "id": "925", "jst_createdat": "1743073158.082490" }, { "jst_id": 926, "jst_jobid": 869, "jst_job_current_status": 3, "id": "926", "jst_createdat": "1743073158.316070" }, { "jst_id": 927, "jst_jobid": 870, "jst_job_current_status": 3, "id": "927", "jst_createdat": "1743073158.475291" }, { "jst_id": 928, "jst_jobid": 871, "jst_job_current_status": 3, "id": "928", "jst_createdat": "1743073158.640296" }, { "jst_id": 929, "jst_jobid": 872, "jst_job_current_status": 3, "id": "929", "jst_createdat": "1743073158.810359" }, { "jst_id": 930, "jst_jobid": 873, "jst_job_current_status": 3, "id": "930", "jst_createdat": "1743074677.149791" } ], "updated": [], "deleted": [] }, "bm_customindividuallogs": { "created": [ { "cl_id": 17949, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 868, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 868, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"BlindMatrix Test\",\"\":180,\"Account Type\":\"Domestic\",\"Source\":\"FB\",\"Created By\":\"Siva\",\"Company Name\":\"BlindMatrix\",\"First Name\":\"Rex John Paul\",\"Last Name\":\"Sivaraj\",\"Mobile\":\"919952916364\",\"Email\":\"rexjohnpaul@blindmatrix.com\",\"Address1\":\"Nandhanam\",\"Address2\":\"Temple Towers\",\"Town \\\/ City\":\"Chennai\",\"State \\\/ County\":\"Tamil Nadu\",\"Zipcode \\\/ Postcode\":\"600035\",\"Country\":\"India\",\"Salutation\":\"Mr.\",\"Phone\":\"04424321542\",\"Check Box\":\"Disabled\",\"Date & Time1\":\"03-27-2025 10:59:17\",\"Assigned to\":27,\"Role\":2,\"Date1\":\"2025-03-27\",\"Delivery date1\":\"2025-03-27\",\"Rework date\":\"2025-03-27\",\"Additional Contacts\":\"180\",\"Job Ref No\":\"JBN833\",\"Job Status\":\"Quote\",\"Order Status\":\"Order1\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"jd_isonlineorder\":1,\"Delivery Vat Percentage\":\"3.000\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":868,\"jd_customerid\":162,\"jd_contactid\":180,\"jd_additionalcontacts\":\"180\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":\\\"25\\\",\\\"34\\\":\\\"JBN833\\\",\\\"35\\\":\\\"TESTING2DB\\\",\\\"36\\\":3,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":21,\\\"40\\\":1,\\\"41\\\":27,\\\"44\\\":\\\"BlindMatrix\\\",\\\"45\\\":\\\"Rex John Paul\\\",\\\"46\\\":\\\"Sivaraj\\\",\\\"47\\\":\\\"919952916364\\\",\\\"48\\\":\\\"rexjohnpaul@blindmatrix.com\\\",\\\"49\\\":\\\"Nandhanam\\\",\\\"50\\\":\\\"Temple Towers\\\",\\\"51\\\":\\\"Chennai\\\",\\\"52\\\":\\\"Tamil Nadu\\\",\\\"53\\\":\\\"600035\\\",\\\"54\\\":36,\\\"285\\\":1,\\\"286\\\":\\\"04424321542\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"521\\\":\\\"\\\",\\\"522\\\":\\\"\\\",\\\"523\\\":\\\"\\\",\\\"555\\\":\\\"\\\",\\\"586\\\":\\\"\\\",\\\"587\\\":\\\"\\\",\\\"588\\\":\\\"\\\",\\\"616\\\":\\\"\\\",\\\"617\\\":\\\"\\\",\\\"618\\\":27,\\\"625\\\":2,\\\"633\\\":\\\"\\\",\\\"634\\\":\\\"\\\",\\\"666\\\":\\\"\\\",\\\"667\\\":\\\"\\\",\\\"700\\\":\\\"\\\",\\\"701\\\":\\\"\\\",\\\"702\\\":1,\\\"703\\\":\\\"\\\",\\\"704\\\":\\\"\\\",\\\"countryText\\\":\\\"Australia\\\",\\\"customerid\\\":162,\\\"contactid\\\":180}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-03-27\",\"jd_orderdate\":null,\"jd_duedate\":null,\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":null,\"jd_jobref\":\"JBN833\",\"jd_jobstatus\":3,\"jd_contactaddid\":0,\"jd_orderstatus\":1,\"jd_accref\":\"TESTING2DB\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"0.00\",\"jd_netprice\":\"0.00\",\"jd_vat\":\"0.00\",\"jd_isvaton\":1,\"jd_deliverycost\":\"0.00\",\"jd_deliverycosttypeid\":1,\"jd_overridetypeid\":1,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":null,\"jd_isroundon\":0,\"jd_grossprice\":\"0.00\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"0.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"0.00\",\"jd_totpaid\":\"0.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":null,\"jd_deliverycostid\":0,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":0,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":0,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":0,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":0,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":27,\"jd_createdat\":\"2025-03-27T10:49:25.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-03-27T10:59:17.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\":null,\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":0,\"jd_rework_count\":0}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17949", "cl_createdat": "1743073158.000000", "cl_updatedat": null }, { "cl_id": 17950, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 869, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 869, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"BlindMatrix Test\",\"\":180,\"Account Type\":\"Domestic\",\"Source\":\"FB\",\"Created By\":\"Siva\",\"Company Name\":\"BlindMatrix\",\"First Name\":\"Rex John Paul\",\"Last Name\":\"Sivaraj\",\"Mobile\":\"919952916364\",\"Email\":\"rexjohnpaul@blindmatrix.com\",\"Address1\":\"Nandhanam\",\"Address2\":\"Temple Towers\",\"Town \\\/ City\":\"Chennai\",\"State \\\/ County\":\"Tamil Nadu\",\"Zipcode \\\/ Postcode\":\"600035\",\"Country\":\"India\",\"Salutation\":\"Mr.\",\"Phone\":\"04424321542\",\"Check Box\":\"Disabled\",\"Date & Time1\":\"03-27-2025 10:59:18\",\"Assigned to\":27,\"Role\":2,\"Date1\":\"2025-03-27\",\"Delivery date1\":\"2025-03-27\",\"Rework date\":\"2025-03-27\",\"Additional Contacts\":\"180\",\"Job Ref No\":\"JBN834\",\"Job Status\":\"Quote\",\"Order Status\":\"Order1\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"jd_isonlineorder\":1,\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":869,\"jd_customerid\":162,\"jd_contactid\":180,\"jd_additionalcontacts\":\"180\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":\\\"25\\\",\\\"34\\\":\\\"JBN834\\\",\\\"35\\\":\\\"TESTING2DB\\\",\\\"36\\\":3,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":21,\\\"40\\\":1,\\\"41\\\":27,\\\"44\\\":\\\"BlindMatrix\\\",\\\"45\\\":\\\"Rex John Paul\\\",\\\"46\\\":\\\"Sivaraj\\\",\\\"47\\\":\\\"919952916364\\\",\\\"48\\\":\\\"rexjohnpaul@blindmatrix.com\\\",\\\"49\\\":\\\"Nandhanam\\\",\\\"50\\\":\\\"Temple Towers\\\",\\\"51\\\":\\\"Chennai\\\",\\\"52\\\":\\\"Tamil Nadu\\\",\\\"53\\\":\\\"600035\\\",\\\"54\\\":36,\\\"285\\\":1,\\\"286\\\":\\\"04424321542\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"521\\\":\\\"\\\",\\\"522\\\":\\\"\\\",\\\"523\\\":\\\"\\\",\\\"555\\\":\\\"\\\",\\\"586\\\":\\\"\\\",\\\"587\\\":\\\"\\\",\\\"588\\\":\\\"\\\",\\\"616\\\":\\\"\\\",\\\"617\\\":\\\"\\\",\\\"618\\\":27,\\\"625\\\":2,\\\"633\\\":\\\"\\\",\\\"634\\\":\\\"\\\",\\\"666\\\":\\\"\\\",\\\"667\\\":\\\"\\\",\\\"700\\\":\\\"\\\",\\\"701\\\":\\\"\\\",\\\"702\\\":1,\\\"703\\\":\\\"\\\",\\\"704\\\":\\\"\\\",\\\"countryText\\\":\\\"Australia\\\",\\\"customerid\\\":162,\\\"contactid\\\":180}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-03-27\",\"jd_orderdate\":null,\"jd_duedate\":null,\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":null,\"jd_jobref\":\"JBN834\",\"jd_jobstatus\":3,\"jd_contactaddid\":0,\"jd_orderstatus\":1,\"jd_accref\":\"TESTING2DB\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"0.00\",\"jd_netprice\":\"0.00\",\"jd_vat\":\"0.00\",\"jd_isvaton\":1,\"jd_deliverycost\":\"0.00\",\"jd_deliverycosttypeid\":1,\"jd_overridetypeid\":1,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":null,\"jd_isroundon\":0,\"jd_grossprice\":\"0.00\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"0.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"0.00\",\"jd_totpaid\":\"0.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":null,\"jd_deliverycostid\":0,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":0,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":0,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":0,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":0,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":27,\"jd_createdat\":\"2025-03-27T10:49:48.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-03-27T10:59:18.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\":\"0.000\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"0.000\",\"jd_commission\":\"[]\",\"jd_commissionprice\":\"0.00\",\"jd_commissionsetting\":0,\"jd_commissionaddedvalue\":\"0.00\",\"jd_onlineprefixseq\":null,\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":0,\"jd_rework_count\":0}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17950", "cl_createdat": "1743073158.000000", "cl_updatedat": null }, { "cl_id": 17951, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 870, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 870, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"BlindMatrix Test\",\"\":620,\"Account Type\":\"Domestic\",\"Source\":\"Linked In\",\"Created By\":\"Siva\",\"Company Name\":\"Dfdfds\",\"Country\":\"Australia\",\"Salutation\":\"Hap\",\"Phone\":\"04564564\",\"Check Box\":\"Disabled\",\"Date & Time1\":\"03-27-2025 10:59:18\",\"Assigned to\":27,\"Role\":2,\"Date1\":\"2025-03-27\",\"Delivery date1\":\"2025-03-27\",\"Rework date\":\"2025-03-27\",\"Additional Contacts\":\"620\",\"Job Ref No\":\"JBN835\",\"Job Status\":\"Quote\",\"Order Status\":\"Order1\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"jd_isonlineorder\":1,\"Delivery Vat Percentage\":\"3.000\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":870,\"jd_customerid\":598,\"jd_contactid\":620,\"jd_additionalcontacts\":\"620\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"JBN835\\\",\\\"35\\\":\\\"DFDF0005\\\",\\\"36\\\":3,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":24,\\\"40\\\":1,\\\"41\\\":27,\\\"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\\\":27,\\\"625\\\":2,\\\"633\\\":\\\"\\\",\\\"634\\\":\\\"\\\",\\\"666\\\":\\\"\\\",\\\"667\\\":\\\"\\\",\\\"700\\\":\\\"\\\",\\\"701\\\":\\\"\\\",\\\"702\\\":1,\\\"703\\\":\\\"\\\",\\\"704\\\":\\\"\\\",\\\"countryText\\\":\\\"Australia\\\",\\\"customerid\\\":598,\\\"contactid\\\":620}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-03-27\",\"jd_orderdate\":null,\"jd_duedate\":null,\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":null,\"jd_jobref\":\"JBN835\",\"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\":1,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":null,\"jd_isroundon\":0,\"jd_grossprice\":\"0.00\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"0.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"0.00\",\"jd_totpaid\":\"0.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":null,\"jd_deliverycostid\":0,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":0,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":0,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":0,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":0,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":27,\"jd_createdat\":\"2025-03-27T10:50:19.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-03-27T10:59:18.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\":null,\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":0,\"jd_rework_count\":0}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17951", "cl_createdat": "1743073158.000000", "cl_updatedat": null }, { "cl_id": 17952, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 871, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 871, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"BlindMatrix Test\",\"\":605,\"Account Type\":\"Domestic\",\"Source\":\"Linked In\",\"Created By\":\"Siva\",\"First Name\":\"Apk\",\"Last Name\":\"Prakash\",\"Country\":\"Australia\",\"Salutation\":\"Hap\",\"Phone\":\"7092559688\",\"Check Box\":\"Disabled\",\"Date & Time1\":\"03-27-2025 10:59:18\",\"Assigned to\":27,\"Role\":2,\"Date1\":\"2025-03-27\",\"Delivery date1\":\"2025-03-27\",\"Rework date\":\"2025-03-27\",\"Additional Contacts\":\"605\",\"Job Ref No\":\"JBN836\",\"Job Status\":\"Quote\",\"Order Status\":\"Order1\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"jd_isonlineorder\":1,\"Delivery Vat Percentage\":\"3.000\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":871,\"jd_customerid\":583,\"jd_contactid\":605,\"jd_additionalcontacts\":\"605\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"JBN836\\\",\\\"35\\\":\\\"PRAK0001\\\",\\\"36\\\":3,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":24,\\\"40\\\":1,\\\"41\\\":27,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"Apk\\\",\\\"46\\\":\\\"Prakash\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":4,\\\"285\\\":17,\\\"286\\\":\\\"7092559688\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"521\\\":\\\"\\\",\\\"522\\\":\\\"\\\",\\\"523\\\":\\\"\\\",\\\"555\\\":\\\"\\\",\\\"586\\\":\\\"\\\",\\\"587\\\":\\\"\\\",\\\"588\\\":\\\"\\\",\\\"616\\\":\\\"\\\",\\\"617\\\":\\\"\\\",\\\"618\\\":27,\\\"625\\\":2,\\\"633\\\":\\\"\\\",\\\"634\\\":\\\"\\\",\\\"666\\\":\\\"\\\",\\\"667\\\":\\\"\\\",\\\"700\\\":\\\"\\\",\\\"701\\\":\\\"\\\",\\\"702\\\":1,\\\"703\\\":\\\"\\\",\\\"704\\\":\\\"\\\",\\\"countryText\\\":\\\"Australia\\\",\\\"customerid\\\":583,\\\"contactid\\\":605}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-03-27\",\"jd_orderdate\":null,\"jd_duedate\":null,\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":null,\"jd_jobref\":\"JBN836\",\"jd_jobstatus\":3,\"jd_contactaddid\":0,\"jd_orderstatus\":1,\"jd_accref\":\"PRAK0001\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"0.00\",\"jd_netprice\":\"0.00\",\"jd_vat\":\"0.00\",\"jd_isvaton\":1,\"jd_deliverycost\":\"0.00\",\"jd_deliverycosttypeid\":1,\"jd_overridetypeid\":1,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":null,\"jd_isroundon\":0,\"jd_grossprice\":\"0.00\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"0.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"0.00\",\"jd_totpaid\":\"0.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":null,\"jd_deliverycostid\":0,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":0,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":0,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":0,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":0,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":27,\"jd_createdat\":\"2025-03-27T10:56:20.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-03-27T10:59:18.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\":null,\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":0,\"jd_rework_count\":0}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17952", "cl_createdat": "1743073158.000000", "cl_updatedat": null }, { "cl_id": 17953, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 872, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 872, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"BlindMatrix Test\",\"\":621,\"Account Type\":\"Domestic\",\"Source\":\"Linked In\",\"Created By\":\"Siva\",\"First Name\":\"Ajay Test\",\"Country\":\"Australia\",\"Salutation\":\"Hap\",\"Phone\":\"0456465\",\"Check Box\":\"Disabled\",\"Date & Time1\":\"03-27-2025 10:59:18\",\"Assigned to\":27,\"Role\":2,\"Date1\":\"2025-03-27\",\"Delivery date1\":\"2025-03-27\",\"Rework date\":\"2025-03-27\",\"Additional Contacts\":\"621\",\"Job Ref No\":\"JBN837\",\"Job Status\":\"Quote\",\"Order Status\":\"Order1\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"jd_isonlineorder\":1,\"Delivery Vat Percentage\":\"3.000\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":872,\"jd_customerid\":599,\"jd_contactid\":621,\"jd_additionalcontacts\":\"621\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"JBN837\\\",\\\"35\\\":\\\"AJAY0001\\\",\\\"36\\\":3,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":24,\\\"40\\\":1,\\\"41\\\":27,\\\"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\\\":27,\\\"625\\\":2,\\\"633\\\":\\\"\\\",\\\"634\\\":\\\"\\\",\\\"666\\\":\\\"\\\",\\\"667\\\":\\\"\\\",\\\"700\\\":\\\"\\\",\\\"701\\\":\\\"\\\",\\\"702\\\":1,\\\"703\\\":\\\"\\\",\\\"704\\\":\\\"\\\",\\\"countryText\\\":\\\"Australia\\\",\\\"customerid\\\":599,\\\"contactid\\\":621}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-03-27\",\"jd_orderdate\":null,\"jd_duedate\":null,\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":null,\"jd_jobref\":\"JBN837\",\"jd_jobstatus\":3,\"jd_contactaddid\":0,\"jd_orderstatus\":1,\"jd_accref\":\"AJAY0001\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"0.00\",\"jd_netprice\":\"0.00\",\"jd_vat\":\"0.00\",\"jd_isvaton\":1,\"jd_deliverycost\":\"0.00\",\"jd_deliverycosttypeid\":1,\"jd_overridetypeid\":1,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":null,\"jd_isroundon\":0,\"jd_grossprice\":\"0.00\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"0.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"0.00\",\"jd_totpaid\":\"0.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":null,\"jd_deliverycostid\":0,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":0,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":0,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":0,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":0,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":27,\"jd_createdat\":\"2025-03-27T10:57:42.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-03-27T10:59:18.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\":null,\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":0,\"jd_rework_count\":0}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17953", "cl_createdat": "1743073158.000000", "cl_updatedat": null }, { "cl_id": 17954, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in JBN831", "cl_event": "created", "cl_subjectid": 889, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 866, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":889,\"jmq_jobid\":866,\"Quotation Name\":\"Q1\",\"jmq_isdefault\":0,\"Quotation\":\"Accepted\",\"jmq_isdeclined\":0,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"Production Due Date\":\"0000-00-00\",\"List Price\":\"0.00\",\"Net Price\":\"0.00\",\"VAT Price\":\"0.00\",\"VAT\":1,\"jmq_deliverycost\":\"0.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"0.00\",\"Gross Profit\":\"0.00\",\"Total CostPrice\":\"0.00\",\"Amount Outstanding\":\"0.00\",\"Total Paid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_deliverycostid\":0,\"Total Cost Price\":0,\"jmq_isonlineorder\":0,\"Is Online Order Submitted\":0,\"End Customer Override Type\":0,\"End Customer Override Net Price\":\"0.00\",\"End Customer Override Vat Price\":\"0.00\",\"End Customer Override Gross Price\":\"0.00\",\"End Customer Delivery Cost Include Vat\":0,\"End Customer Fitting Cost Include Vat\":0,\"Online Delivery Addreddtype\":0,\"Commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"Delivery Vat Percentage\":\"3.000\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":889,\"jmq_jobid\":866,\"jmq_quotationname\":\"Q1\",\"jmq_isdefault\":0,\"jmq_isaccepted\":1,\"jmq_isdeclined\":0,\"jmq_esignflag\":null,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"jmq_duedate\":\"0000-00-00\",\"jmq_sceduleddate\":\"0000-00-00\",\"jmq_listprice\":\"0.00\",\"jmq_netprice\":\"0.00\",\"jmq_vat\":\"0.00\",\"jmq_isvaton\":1,\"jmq_deliverycost\":\"0.00\",\"jmq_deliverycosttypeid\":1,\"jmq_overridetypeid\":1,\"jmq_orderformprice\":\"0.00\",\"jmq_editpricebyid\":null,\"jmq_isroundon\":0,\"jmq_grossprice\":\"0.00\",\"jmq_grossprofit\":\"0.00\",\"jmq_costprice\":\"0.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"0.00\",\"jmq_totpaid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_userdefinedarray\":null,\"jmq_deliverycostid\":0,\"jmq_iscostpriceon\":0,\"jmq_custompricefields\":\"\",\"jmq_isonlineorder\":0,\"jmq_isonlineordersubmitted\":0,\"jmq_endcustomervatprice\":null,\"jmq_endcustomeroverridetype\":0,\"jmq_endcustomeroverridevalue\":null,\"jmq_endcustomeroverridenetprice\":\"0.00\",\"jmq_endcustomeroverridevatprice\":\"0.00\",\"jmq_endcustomeroverridegrossprice\":\"0.00\",\"jmq_endcustomerdeliverycost\":null,\"jmq_endcustomerdeliverycostinclvat\":0,\"jmq_endcustomerfittingcost\":null,\"jmq_endcustomerfittingcostinclvat\":0,\"jmq_onlinedeliveryaddreddtype\":0,\"jmq_onlinedeliveryaddreddid\":null,\"jmq_commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"jmq_deliveryvatperc\":\"3.000\",\"jmq_cdeliveryvatperc\":\"3.000\",\"jmq_createdby\":27,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-03-27T10:47:55.000000Z\",\"jmq_updatedat\":null,\"jmq_grossprofit_percentage\":\"0.00\",\"jmq_ready\":0}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17954", "cl_createdat": "1743073158.000000", "cl_updatedat": null }, { "cl_id": 17955, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the field Multi Quote Id", "cl_event": "modified", "cl_subjectid": 866, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 866, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":889}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":889,\"jd_updatedat\":\"2025-03-27T10:59:18.000000Z\"},\"old\":{\"jd_jobmultiquoteid\":null,\"jd_updatedat\":\"2025-03-27T10:59:17.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17955", "cl_createdat": "1743073158.000000", "cl_updatedat": null }, { "cl_id": 17956, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in JBN832", "cl_event": "created", "cl_subjectid": 890, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 867, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":890,\"jmq_jobid\":867,\"Quotation Name\":\"Q1\",\"jmq_isdefault\":0,\"Quotation\":\"Accepted\",\"jmq_isdeclined\":0,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"Production Due Date\":\"0000-00-00\",\"List Price\":\"0.00\",\"Net Price\":\"0.00\",\"VAT Price\":\"0.00\",\"VAT\":1,\"jmq_deliverycost\":\"0.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"0.00\",\"Gross Profit\":\"0.00\",\"Total CostPrice\":\"0.00\",\"Amount Outstanding\":\"0.00\",\"Total Paid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_deliverycostid\":0,\"Total Cost Price\":0,\"jmq_isonlineorder\":0,\"Is Online Order Submitted\":0,\"End Customer Override Type\":0,\"End Customer Override Net Price\":\"0.00\",\"End Customer Override Vat Price\":\"0.00\",\"End Customer Override Gross Price\":\"0.00\",\"End Customer Delivery Cost Include Vat\":0,\"End Customer Fitting Cost Include Vat\":0,\"Online Delivery Addreddtype\":0,\"Commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"Delivery Vat Percentage\":\"3.000\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":890,\"jmq_jobid\":867,\"jmq_quotationname\":\"Q1\",\"jmq_isdefault\":0,\"jmq_isaccepted\":1,\"jmq_isdeclined\":0,\"jmq_esignflag\":null,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"jmq_duedate\":\"0000-00-00\",\"jmq_sceduleddate\":\"0000-00-00\",\"jmq_listprice\":\"0.00\",\"jmq_netprice\":\"0.00\",\"jmq_vat\":\"0.00\",\"jmq_isvaton\":1,\"jmq_deliverycost\":\"0.00\",\"jmq_deliverycosttypeid\":1,\"jmq_overridetypeid\":1,\"jmq_orderformprice\":\"0.00\",\"jmq_editpricebyid\":null,\"jmq_isroundon\":0,\"jmq_grossprice\":\"0.00\",\"jmq_grossprofit\":\"0.00\",\"jmq_costprice\":\"0.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"0.00\",\"jmq_totpaid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_userdefinedarray\":null,\"jmq_deliverycostid\":0,\"jmq_iscostpriceon\":0,\"jmq_custompricefields\":\"\",\"jmq_isonlineorder\":0,\"jmq_isonlineordersubmitted\":0,\"jmq_endcustomervatprice\":null,\"jmq_endcustomeroverridetype\":0,\"jmq_endcustomeroverridevalue\":null,\"jmq_endcustomeroverridenetprice\":\"0.00\",\"jmq_endcustomeroverridevatprice\":\"0.00\",\"jmq_endcustomeroverridegrossprice\":\"0.00\",\"jmq_endcustomerdeliverycost\":null,\"jmq_endcustomerdeliverycostinclvat\":0,\"jmq_endcustomerfittingcost\":null,\"jmq_endcustomerfittingcostinclvat\":0,\"jmq_onlinedeliveryaddreddtype\":0,\"jmq_onlinedeliveryaddreddid\":null,\"jmq_commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"jmq_deliveryvatperc\":\"3.000\",\"jmq_cdeliveryvatperc\":\"3.000\",\"jmq_createdby\":27,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-03-27T10:48:46.000000Z\",\"jmq_updatedat\":null,\"jmq_grossprofit_percentage\":\"0.00\",\"jmq_ready\":0}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17956", "cl_createdat": "1743073158.000000", "cl_updatedat": null }, { "cl_id": 17957, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the field Multi Quote Id", "cl_event": "modified", "cl_subjectid": 867, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 867, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":890}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":890,\"jd_updatedat\":\"2025-03-27T10:59:18.000000Z\"},\"old\":{\"jd_jobmultiquoteid\":null,\"jd_updatedat\":\"2025-03-27T10:59:17.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17957", "cl_createdat": "1743073158.000000", "cl_updatedat": null }, { "cl_id": 17958, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in JBN833", "cl_event": "created", "cl_subjectid": 891, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 868, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":891,\"jmq_jobid\":868,\"Quotation Name\":\"Q1\",\"jmq_isdefault\":0,\"Quotation\":\"Accepted\",\"jmq_isdeclined\":0,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"Production Due Date\":\"0000-00-00\",\"List Price\":\"0.00\",\"Net Price\":\"0.00\",\"VAT Price\":\"0.00\",\"VAT\":1,\"jmq_deliverycost\":\"0.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"0.00\",\"Gross Profit\":\"0.00\",\"Total CostPrice\":\"0.00\",\"Amount Outstanding\":\"0.00\",\"Total Paid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_deliverycostid\":0,\"Total Cost Price\":0,\"jmq_isonlineorder\":0,\"Is Online Order Submitted\":0,\"End Customer Override Type\":0,\"End Customer Override Net Price\":\"0.00\",\"End Customer Override Vat Price\":\"0.00\",\"End Customer Override Gross Price\":\"0.00\",\"End Customer Delivery Cost Include Vat\":0,\"End Customer Fitting Cost Include Vat\":0,\"Online Delivery Addreddtype\":0,\"Commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"Delivery Vat Percentage\":\"3.000\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":891,\"jmq_jobid\":868,\"jmq_quotationname\":\"Q1\",\"jmq_isdefault\":0,\"jmq_isaccepted\":1,\"jmq_isdeclined\":0,\"jmq_esignflag\":null,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"jmq_duedate\":\"0000-00-00\",\"jmq_sceduleddate\":\"0000-00-00\",\"jmq_listprice\":\"0.00\",\"jmq_netprice\":\"0.00\",\"jmq_vat\":\"0.00\",\"jmq_isvaton\":1,\"jmq_deliverycost\":\"0.00\",\"jmq_deliverycosttypeid\":1,\"jmq_overridetypeid\":1,\"jmq_orderformprice\":\"0.00\",\"jmq_editpricebyid\":null,\"jmq_isroundon\":0,\"jmq_grossprice\":\"0.00\",\"jmq_grossprofit\":\"0.00\",\"jmq_costprice\":\"0.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"0.00\",\"jmq_totpaid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_userdefinedarray\":null,\"jmq_deliverycostid\":0,\"jmq_iscostpriceon\":0,\"jmq_custompricefields\":\"\",\"jmq_isonlineorder\":0,\"jmq_isonlineordersubmitted\":0,\"jmq_endcustomervatprice\":null,\"jmq_endcustomeroverridetype\":0,\"jmq_endcustomeroverridevalue\":null,\"jmq_endcustomeroverridenetprice\":\"0.00\",\"jmq_endcustomeroverridevatprice\":\"0.00\",\"jmq_endcustomeroverridegrossprice\":\"0.00\",\"jmq_endcustomerdeliverycost\":null,\"jmq_endcustomerdeliverycostinclvat\":0,\"jmq_endcustomerfittingcost\":null,\"jmq_endcustomerfittingcostinclvat\":0,\"jmq_onlinedeliveryaddreddtype\":0,\"jmq_onlinedeliveryaddreddid\":null,\"jmq_commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"jmq_deliveryvatperc\":\"3.000\",\"jmq_cdeliveryvatperc\":\"3.000\",\"jmq_createdby\":27,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-03-27T10:49:25.000000Z\",\"jmq_updatedat\":null,\"jmq_grossprofit_percentage\":\"0.00\",\"jmq_ready\":0}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17958", "cl_createdat": "1743073158.000000", "cl_updatedat": null }, { "cl_id": 17959, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the field Multi Quote Id", "cl_event": "modified", "cl_subjectid": 868, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 868, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":891}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":891},\"old\":{\"jd_jobmultiquoteid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17959", "cl_createdat": "1743073158.000000", "cl_updatedat": null }, { "cl_id": 17960, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in JBN834", "cl_event": "created", "cl_subjectid": 892, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 869, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":892,\"jmq_jobid\":869,\"Quotation Name\":\"Q1\",\"jmq_isdefault\":0,\"Quotation\":\"Accepted\",\"jmq_isdeclined\":0,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"Production Due Date\":\"0000-00-00\",\"List Price\":\"0.00\",\"Net Price\":\"0.00\",\"VAT Price\":\"0.00\",\"VAT\":1,\"jmq_deliverycost\":\"0.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"0.00\",\"Gross Profit\":\"0.00\",\"Total CostPrice\":\"0.00\",\"Amount Outstanding\":\"0.00\",\"Total Paid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_deliverycostid\":0,\"Total Cost Price\":0,\"jmq_isonlineorder\":0,\"Is Online Order Submitted\":0,\"End Customer Override Type\":0,\"End Customer Override Net Price\":\"0.00\",\"End Customer Override Vat Price\":\"0.00\",\"End Customer Override Gross Price\":\"0.00\",\"End Customer Delivery Cost Include Vat\":0,\"End Customer Fitting Cost Include Vat\":0,\"Online Delivery Addreddtype\":0,\"Commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"Delivery Vat Percentage\":\"0.000\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":892,\"jmq_jobid\":869,\"jmq_quotationname\":\"Q1\",\"jmq_isdefault\":0,\"jmq_isaccepted\":1,\"jmq_isdeclined\":0,\"jmq_esignflag\":null,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"jmq_duedate\":\"0000-00-00\",\"jmq_sceduleddate\":\"0000-00-00\",\"jmq_listprice\":\"0.00\",\"jmq_netprice\":\"0.00\",\"jmq_vat\":\"0.00\",\"jmq_isvaton\":1,\"jmq_deliverycost\":\"0.00\",\"jmq_deliverycosttypeid\":1,\"jmq_overridetypeid\":1,\"jmq_orderformprice\":\"0.00\",\"jmq_editpricebyid\":null,\"jmq_isroundon\":0,\"jmq_grossprice\":\"0.00\",\"jmq_grossprofit\":\"0.00\",\"jmq_costprice\":\"0.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"0.00\",\"jmq_totpaid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_userdefinedarray\":null,\"jmq_deliverycostid\":0,\"jmq_iscostpriceon\":0,\"jmq_custompricefields\":\"\",\"jmq_isonlineorder\":0,\"jmq_isonlineordersubmitted\":0,\"jmq_endcustomervatprice\":null,\"jmq_endcustomeroverridetype\":0,\"jmq_endcustomeroverridevalue\":null,\"jmq_endcustomeroverridenetprice\":\"0.00\",\"jmq_endcustomeroverridevatprice\":\"0.00\",\"jmq_endcustomeroverridegrossprice\":\"0.00\",\"jmq_endcustomerdeliverycost\":null,\"jmq_endcustomerdeliverycostinclvat\":0,\"jmq_endcustomerfittingcost\":null,\"jmq_endcustomerfittingcostinclvat\":0,\"jmq_onlinedeliveryaddreddtype\":0,\"jmq_onlinedeliveryaddreddid\":null,\"jmq_commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"jmq_deliveryvatperc\":\"0.000\",\"jmq_cdeliveryvatperc\":\"0.000\",\"jmq_createdby\":27,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-03-27T10:49:48.000000Z\",\"jmq_updatedat\":null,\"jmq_grossprofit_percentage\":\"0.00\",\"jmq_ready\":0}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17960", "cl_createdat": "1743073159.000000", "cl_updatedat": null }, { "cl_id": 17961, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the field Multi Quote Id", "cl_event": "modified", "cl_subjectid": 869, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 869, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":892}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":892,\"jd_updatedat\":\"2025-03-27T10:59:19.000000Z\"},\"old\":{\"jd_jobmultiquoteid\":null,\"jd_updatedat\":\"2025-03-27T10:59:18.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17961", "cl_createdat": "1743073159.000000", "cl_updatedat": null }, { "cl_id": 17962, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in JBN835", "cl_event": "created", "cl_subjectid": 893, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 870, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":893,\"jmq_jobid\":870,\"Quotation Name\":\"Q1\",\"jmq_isdefault\":0,\"Quotation\":\"Accepted\",\"jmq_isdeclined\":0,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"Production Due Date\":\"0000-00-00\",\"List Price\":\"0.00\",\"Net Price\":\"0.00\",\"VAT Price\":\"0.00\",\"VAT\":1,\"jmq_deliverycost\":\"0.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"0.00\",\"Gross Profit\":\"0.00\",\"Total CostPrice\":\"0.00\",\"Amount Outstanding\":\"0.00\",\"Total Paid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_deliverycostid\":0,\"Total Cost Price\":0,\"jmq_isonlineorder\":0,\"Is Online Order Submitted\":0,\"End Customer Override Type\":0,\"End Customer Override Net Price\":\"0.00\",\"End Customer Override Vat Price\":\"0.00\",\"End Customer Override Gross Price\":\"0.00\",\"End Customer Delivery Cost Include Vat\":0,\"End Customer Fitting Cost Include Vat\":0,\"Online Delivery Addreddtype\":0,\"Commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"Delivery Vat Percentage\":\"3.000\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":893,\"jmq_jobid\":870,\"jmq_quotationname\":\"Q1\",\"jmq_isdefault\":0,\"jmq_isaccepted\":1,\"jmq_isdeclined\":0,\"jmq_esignflag\":null,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"jmq_duedate\":\"0000-00-00\",\"jmq_sceduleddate\":\"0000-00-00\",\"jmq_listprice\":\"0.00\",\"jmq_netprice\":\"0.00\",\"jmq_vat\":\"0.00\",\"jmq_isvaton\":1,\"jmq_deliverycost\":\"0.00\",\"jmq_deliverycosttypeid\":1,\"jmq_overridetypeid\":1,\"jmq_orderformprice\":\"0.00\",\"jmq_editpricebyid\":null,\"jmq_isroundon\":0,\"jmq_grossprice\":\"0.00\",\"jmq_grossprofit\":\"0.00\",\"jmq_costprice\":\"0.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"0.00\",\"jmq_totpaid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_userdefinedarray\":null,\"jmq_deliverycostid\":0,\"jmq_iscostpriceon\":0,\"jmq_custompricefields\":\"\",\"jmq_isonlineorder\":0,\"jmq_isonlineordersubmitted\":0,\"jmq_endcustomervatprice\":null,\"jmq_endcustomeroverridetype\":0,\"jmq_endcustomeroverridevalue\":null,\"jmq_endcustomeroverridenetprice\":\"0.00\",\"jmq_endcustomeroverridevatprice\":\"0.00\",\"jmq_endcustomeroverridegrossprice\":\"0.00\",\"jmq_endcustomerdeliverycost\":null,\"jmq_endcustomerdeliverycostinclvat\":0,\"jmq_endcustomerfittingcost\":null,\"jmq_endcustomerfittingcostinclvat\":0,\"jmq_onlinedeliveryaddreddtype\":0,\"jmq_onlinedeliveryaddreddid\":null,\"jmq_commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"jmq_deliveryvatperc\":\"3.000\",\"jmq_cdeliveryvatperc\":\"3.000\",\"jmq_createdby\":27,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-03-27T10:50:19.000000Z\",\"jmq_updatedat\":null,\"jmq_grossprofit_percentage\":\"0.00\",\"jmq_ready\":0}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17962", "cl_createdat": "1743073159.000000", "cl_updatedat": null }, { "cl_id": 17963, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the field Multi Quote Id", "cl_event": "modified", "cl_subjectid": 870, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 870, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":893}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":893,\"jd_updatedat\":\"2025-03-27T10:59:19.000000Z\"},\"old\":{\"jd_jobmultiquoteid\":null,\"jd_updatedat\":\"2025-03-27T10:59:18.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17963", "cl_createdat": "1743073159.000000", "cl_updatedat": null }, { "cl_id": 17964, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in JBN836", "cl_event": "created", "cl_subjectid": 894, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 871, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":894,\"jmq_jobid\":871,\"Quotation Name\":\"Q1\",\"jmq_isdefault\":0,\"Quotation\":\"Accepted\",\"jmq_isdeclined\":0,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"Production Due Date\":\"0000-00-00\",\"List Price\":\"0.00\",\"Net Price\":\"0.00\",\"VAT Price\":\"0.00\",\"VAT\":1,\"jmq_deliverycost\":\"0.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"0.00\",\"Gross Profit\":\"0.00\",\"Total CostPrice\":\"0.00\",\"Amount Outstanding\":\"0.00\",\"Total Paid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_deliverycostid\":0,\"Total Cost Price\":0,\"jmq_isonlineorder\":0,\"Is Online Order Submitted\":0,\"End Customer Override Type\":0,\"End Customer Override Net Price\":\"0.00\",\"End Customer Override Vat Price\":\"0.00\",\"End Customer Override Gross Price\":\"0.00\",\"End Customer Delivery Cost Include Vat\":0,\"End Customer Fitting Cost Include Vat\":0,\"Online Delivery Addreddtype\":0,\"Commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"Delivery Vat Percentage\":\"3.000\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":894,\"jmq_jobid\":871,\"jmq_quotationname\":\"Q1\",\"jmq_isdefault\":0,\"jmq_isaccepted\":1,\"jmq_isdeclined\":0,\"jmq_esignflag\":null,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"jmq_duedate\":\"0000-00-00\",\"jmq_sceduleddate\":\"0000-00-00\",\"jmq_listprice\":\"0.00\",\"jmq_netprice\":\"0.00\",\"jmq_vat\":\"0.00\",\"jmq_isvaton\":1,\"jmq_deliverycost\":\"0.00\",\"jmq_deliverycosttypeid\":1,\"jmq_overridetypeid\":1,\"jmq_orderformprice\":\"0.00\",\"jmq_editpricebyid\":null,\"jmq_isroundon\":0,\"jmq_grossprice\":\"0.00\",\"jmq_grossprofit\":\"0.00\",\"jmq_costprice\":\"0.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"0.00\",\"jmq_totpaid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_userdefinedarray\":null,\"jmq_deliverycostid\":0,\"jmq_iscostpriceon\":0,\"jmq_custompricefields\":\"\",\"jmq_isonlineorder\":0,\"jmq_isonlineordersubmitted\":0,\"jmq_endcustomervatprice\":null,\"jmq_endcustomeroverridetype\":0,\"jmq_endcustomeroverridevalue\":null,\"jmq_endcustomeroverridenetprice\":\"0.00\",\"jmq_endcustomeroverridevatprice\":\"0.00\",\"jmq_endcustomeroverridegrossprice\":\"0.00\",\"jmq_endcustomerdeliverycost\":null,\"jmq_endcustomerdeliverycostinclvat\":0,\"jmq_endcustomerfittingcost\":null,\"jmq_endcustomerfittingcostinclvat\":0,\"jmq_onlinedeliveryaddreddtype\":0,\"jmq_onlinedeliveryaddreddid\":null,\"jmq_commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"jmq_deliveryvatperc\":\"3.000\",\"jmq_cdeliveryvatperc\":\"3.000\",\"jmq_createdby\":27,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-03-27T10:56:20.000000Z\",\"jmq_updatedat\":null,\"jmq_grossprofit_percentage\":\"0.00\",\"jmq_ready\":0}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17964", "cl_createdat": "1743073159.000000", "cl_updatedat": null }, { "cl_id": 17965, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the field Multi Quote Id", "cl_event": "modified", "cl_subjectid": 871, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 871, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":894}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":894,\"jd_updatedat\":\"2025-03-27T10:59:19.000000Z\"},\"old\":{\"jd_jobmultiquoteid\":null,\"jd_updatedat\":\"2025-03-27T10:59:18.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17965", "cl_createdat": "1743073159.000000", "cl_updatedat": null }, { "cl_id": 17966, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in JBN837", "cl_event": "created", "cl_subjectid": 895, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 872, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":895,\"jmq_jobid\":872,\"Quotation Name\":\"Q1\",\"jmq_isdefault\":0,\"Quotation\":\"Accepted\",\"jmq_isdeclined\":0,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"Production Due Date\":\"0000-00-00\",\"List Price\":\"0.00\",\"Net Price\":\"0.00\",\"VAT Price\":\"0.00\",\"VAT\":1,\"jmq_deliverycost\":\"0.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"0.00\",\"Gross Profit\":\"0.00\",\"Total CostPrice\":\"0.00\",\"Amount Outstanding\":\"0.00\",\"Total Paid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_deliverycostid\":0,\"Total Cost Price\":0,\"jmq_isonlineorder\":0,\"Is Online Order Submitted\":0,\"End Customer Override Type\":0,\"End Customer Override Net Price\":\"0.00\",\"End Customer Override Vat Price\":\"0.00\",\"End Customer Override Gross Price\":\"0.00\",\"End Customer Delivery Cost Include Vat\":0,\"End Customer Fitting Cost Include Vat\":0,\"Online Delivery Addreddtype\":0,\"Commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"Delivery Vat Percentage\":\"3.000\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":895,\"jmq_jobid\":872,\"jmq_quotationname\":\"Q1\",\"jmq_isdefault\":0,\"jmq_isaccepted\":1,\"jmq_isdeclined\":0,\"jmq_esignflag\":null,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"jmq_duedate\":\"0000-00-00\",\"jmq_sceduleddate\":\"0000-00-00\",\"jmq_listprice\":\"0.00\",\"jmq_netprice\":\"0.00\",\"jmq_vat\":\"0.00\",\"jmq_isvaton\":1,\"jmq_deliverycost\":\"0.00\",\"jmq_deliverycosttypeid\":1,\"jmq_overridetypeid\":1,\"jmq_orderformprice\":\"0.00\",\"jmq_editpricebyid\":null,\"jmq_isroundon\":0,\"jmq_grossprice\":\"0.00\",\"jmq_grossprofit\":\"0.00\",\"jmq_costprice\":\"0.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"0.00\",\"jmq_totpaid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_userdefinedarray\":null,\"jmq_deliverycostid\":0,\"jmq_iscostpriceon\":0,\"jmq_custompricefields\":\"\",\"jmq_isonlineorder\":0,\"jmq_isonlineordersubmitted\":0,\"jmq_endcustomervatprice\":null,\"jmq_endcustomeroverridetype\":0,\"jmq_endcustomeroverridevalue\":null,\"jmq_endcustomeroverridenetprice\":\"0.00\",\"jmq_endcustomeroverridevatprice\":\"0.00\",\"jmq_endcustomeroverridegrossprice\":\"0.00\",\"jmq_endcustomerdeliverycost\":null,\"jmq_endcustomerdeliverycostinclvat\":0,\"jmq_endcustomerfittingcost\":null,\"jmq_endcustomerfittingcostinclvat\":0,\"jmq_onlinedeliveryaddreddtype\":0,\"jmq_onlinedeliveryaddreddid\":null,\"jmq_commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"jmq_deliveryvatperc\":\"3.000\",\"jmq_cdeliveryvatperc\":\"3.000\",\"jmq_createdby\":27,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-03-27T10:57:42.000000Z\",\"jmq_updatedat\":null,\"jmq_grossprofit_percentage\":\"0.00\",\"jmq_ready\":0}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17966", "cl_createdat": "1743073159.000000", "cl_updatedat": null }, { "cl_id": 17967, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the field Multi Quote Id", "cl_event": "modified", "cl_subjectid": 872, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 872, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":895}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":895,\"jd_updatedat\":\"2025-03-27T10:59:19.000000Z\"},\"old\":{\"jd_jobmultiquoteid\":null,\"jd_updatedat\":\"2025-03-27T10:59:18.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17967", "cl_createdat": "1743073159.000000", "cl_updatedat": null }, { "cl_id": 17968, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 873, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 873, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"BlindMatrix Test\",\"\":597,\"Account Type\":\"Domestic\",\"Source\":\"Linked In\",\"Created By\":\"Siva\",\"First Name\":\"Siva\",\"Country\":\"UK\",\"Salutation\":\"Hap\",\"Phone\":\"963852\",\"Check Box\":\"Disabled\",\"Date & Time1\":\"03-27-2025 11:24:36\",\"Assigned to\":27,\"Role\":2,\"Date1\":\"2025-03-27\",\"Delivery date1\":\"2025-03-27\",\"Rework date\":\"2025-03-27\",\"Additional Contacts\":\"597\",\"Job Ref No\":\"JBN838\",\"Job Status\":\"Quote\",\"Order Status\":\"Order1\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"jd_isonlineorder\":1,\"Delivery Vat Percentage\":\"3.000\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":873,\"jd_customerid\":575,\"jd_contactid\":597,\"jd_additionalcontacts\":\"597\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"JBN838\\\",\\\"35\\\":\\\"SIVA0004\\\",\\\"36\\\":3,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":24,\\\"40\\\":1,\\\"41\\\":27,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"Siva\\\",\\\"46\\\":\\\"\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":19,\\\"285\\\":17,\\\"286\\\":\\\"963852\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"521\\\":\\\"\\\",\\\"522\\\":\\\"\\\",\\\"523\\\":\\\"\\\",\\\"555\\\":\\\"\\\",\\\"586\\\":\\\"\\\",\\\"587\\\":\\\"\\\",\\\"588\\\":\\\"\\\",\\\"616\\\":\\\"\\\",\\\"617\\\":\\\"\\\",\\\"618\\\":27,\\\"625\\\":2,\\\"633\\\":\\\"\\\",\\\"634\\\":\\\"\\\",\\\"666\\\":\\\"\\\",\\\"667\\\":\\\"\\\",\\\"700\\\":\\\"\\\",\\\"701\\\":\\\"\\\",\\\"702\\\":1,\\\"703\\\":\\\"\\\",\\\"704\\\":\\\"\\\",\\\"countryText\\\":\\\"Australia\\\",\\\"customerid\\\":575,\\\"contactid\\\":597}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-03-27\",\"jd_orderdate\":null,\"jd_duedate\":null,\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":null,\"jd_jobref\":\"JBN838\",\"jd_jobstatus\":3,\"jd_contactaddid\":0,\"jd_orderstatus\":1,\"jd_accref\":\"SIVA0004\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"0.00\",\"jd_netprice\":\"0.00\",\"jd_vat\":\"0.00\",\"jd_isvaton\":1,\"jd_deliverycost\":\"0.00\",\"jd_deliverycosttypeid\":1,\"jd_overridetypeid\":1,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":null,\"jd_isroundon\":0,\"jd_grossprice\":\"0.00\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"0.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"0.00\",\"jd_totpaid\":\"0.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":null,\"jd_deliverycostid\":0,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":0,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":0,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":0,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":0,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":27,\"jd_createdat\":\"2025-03-27T11:06:36.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-03-27T11:24:36.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\":null,\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":0,\"jd_rework_count\":0}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17968", "cl_createdat": "1743074677.000000", "cl_updatedat": null }, { "cl_id": 17969, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in JBN838", "cl_event": "created", "cl_subjectid": 896, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 873, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":896,\"jmq_jobid\":873,\"Quotation Name\":\"Q1\",\"jmq_isdefault\":0,\"Quotation\":\"Accepted\",\"jmq_isdeclined\":0,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"Production Due Date\":\"0000-00-00\",\"List Price\":\"0.00\",\"Net Price\":\"0.00\",\"VAT Price\":\"0.00\",\"VAT\":1,\"jmq_deliverycost\":\"0.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"0.00\",\"Gross Profit\":\"0.00\",\"Total CostPrice\":\"0.00\",\"Amount Outstanding\":\"0.00\",\"Total Paid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_deliverycostid\":0,\"Total Cost Price\":0,\"jmq_isonlineorder\":0,\"Is Online Order Submitted\":0,\"End Customer Override Type\":0,\"End Customer Override Net Price\":\"0.00\",\"End Customer Override Vat Price\":\"0.00\",\"End Customer Override Gross Price\":\"0.00\",\"End Customer Delivery Cost Include Vat\":0,\"End Customer Fitting Cost Include Vat\":0,\"Online Delivery Addreddtype\":0,\"Commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"Delivery Vat Percentage\":\"3.000\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":896,\"jmq_jobid\":873,\"jmq_quotationname\":\"Q1\",\"jmq_isdefault\":0,\"jmq_isaccepted\":1,\"jmq_isdeclined\":0,\"jmq_esignflag\":null,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"jmq_duedate\":\"0000-00-00\",\"jmq_sceduleddate\":\"0000-00-00\",\"jmq_listprice\":\"0.00\",\"jmq_netprice\":\"0.00\",\"jmq_vat\":\"0.00\",\"jmq_isvaton\":1,\"jmq_deliverycost\":\"0.00\",\"jmq_deliverycosttypeid\":1,\"jmq_overridetypeid\":1,\"jmq_orderformprice\":\"0.00\",\"jmq_editpricebyid\":null,\"jmq_isroundon\":0,\"jmq_grossprice\":\"0.00\",\"jmq_grossprofit\":\"0.00\",\"jmq_costprice\":\"0.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"0.00\",\"jmq_totpaid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_userdefinedarray\":null,\"jmq_deliverycostid\":0,\"jmq_iscostpriceon\":0,\"jmq_custompricefields\":\"\",\"jmq_isonlineorder\":0,\"jmq_isonlineordersubmitted\":0,\"jmq_endcustomervatprice\":null,\"jmq_endcustomeroverridetype\":0,\"jmq_endcustomeroverridevalue\":null,\"jmq_endcustomeroverridenetprice\":\"0.00\",\"jmq_endcustomeroverridevatprice\":\"0.00\",\"jmq_endcustomeroverridegrossprice\":\"0.00\",\"jmq_endcustomerdeliverycost\":null,\"jmq_endcustomerdeliverycostinclvat\":0,\"jmq_endcustomerfittingcost\":null,\"jmq_endcustomerfittingcostinclvat\":0,\"jmq_onlinedeliveryaddreddtype\":0,\"jmq_onlinedeliveryaddreddid\":null,\"jmq_commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"jmq_deliveryvatperc\":\"3.000\",\"jmq_cdeliveryvatperc\":\"3.000\",\"jmq_createdby\":27,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-03-27T11:06:36.000000Z\",\"jmq_updatedat\":null,\"jmq_grossprofit_percentage\":\"0.00\",\"jmq_ready\":0}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17969", "cl_createdat": "1743074677.000000", "cl_updatedat": null }, { "cl_id": 17970, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the field Multi Quote Id", "cl_event": "modified", "cl_subjectid": 873, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 873, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":896}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":896},\"old\":{\"jd_jobmultiquoteid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17970", "cl_createdat": "1743074677.000000", "cl_updatedat": null } ], "updated": [], "deleted": [] }, "bm_productInfo": { "created": [], "updated": [], "deleted": [] }, "bm_fields": { "created": [], "updated": [], "deleted": [] }, "bm_fieldOptionLink": { "created": [], "updated": [], "deleted": [] }, "bm_option": { "created": [], "updated": [], "deleted": [] }, "bm_optionproduct": { "created": [], "updated": [], "deleted": [] }, "bm_linkedfieldswithproduct": { "created": [], "updated": [], "deleted": [] }, "bm_productionstatus": { "created": [], "updated": [], "deleted": [] }, "bm_productpricemap": { "created": [], "updated": [], "deleted": [] }, "bm_productrecipe": { "created": [], "updated": [], "deleted": [] }, "bm_productrecipemap": { "created": [], "updated": [], "deleted": [] }, "bm_supproductcode": { "created": [], "updated": [], "deleted": [] }, "bm_rulesetup": { "created": [], "updated": [], "deleted": [] }, "bm_formulas": { "created": [], "updated": [], "deleted": [] }, "bm_customercommission": { "created": [], "updated": [], "deleted": [] }, "bm_productgroupdetails": { "created": [], "updated": [], "deleted": [] }, "bm_productgroupmaterialmap": { "created": [], "updated": [], "deleted": [] }, "bm_productpricedetails": { "created": [], "updated": [], "deleted": [] }, "bm_fabriccolourmap": { "created": [], "updated": [], "deleted": [] }, "bm_fabricdetails": { "created": [], "updated": [], "deleted": [] }, "bm_colordetails": { "created": [], "updated": [], "deleted": [] }, "bm_optiondiscount": { "created": [], "updated": [], "deleted": [] }, "bm_optionpricebook": { "created": [], "updated": [], "deleted": [] }, "bm_allowances": { "created": [], "updated": [], "deleted": [] }, "bm_xyoptionpricedata": { "created": [], "updated": [], "deleted": [] }, "bm_delivery_cost_setup": { "created": [], "updated": [], "deleted": [] }, "bm_organizationdetails": { "created": [], "updated": [], "deleted": [] }, "bm_applicationSetup": { "created": [], "updated": [], "deleted": [] } }, "synctodelete": { "bm_jobdetails": { "41743073596": 873 }, "bm_jobmultiquote": { "141743073596": 896 } }, "timestamp": 1743074676 }