{ "status": "success", "upcomingorder_list": { "bm_customertemplatedata": { "created": [], "updated": [ { "ctd_id": 583, "ctd_createdfrom": 0, "ctd_templateid": 56, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\": 1, \"64\": 24, \"690\": 25, \"62\": \"PRAK0001\"}", "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": "583", "ctd_createdat": 1742464673, "ctd_updatedat": 1742464878, "ctd_createdby": 0, "ctd_updatedby": null } ], "deleted": [] }, "bm_customercontactinfo": { "created": [], "updated": [ { "cci_id": 605, "cci_customerid": 583, "cci_templateid": 52, "roleid": 0, "cci_customizedarray": "{\"75\":17,\"76\":\"7092559688\",\"77\":\"Apk\",\"79\":\"Prakash\",\"81\":2,\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"90\":4}", "cci_ismarketingemails": 0, "cci_smsverifystatus": 0, "cci_isdocumentreceived": 0, "cci_receiveddocfor": null, "cci_isonlineportal": 0, "cci_latitude": null, "cci_longitude": null, "cci_username": null, "cci_password": null, "cci_confirmpassword": null, "cci_seq": 0, "cci_status": 0, "cci_deviceplatform": 2, "cci_mobcustomertempid": 31742464673, "id": "605", "cci_createdat": 1742464673, "cci_updatedat": 1742464878, "cci_createdby": 0, "cci_updatedby": null } ], "deleted": [] }, "bm_appointment": { "created": [], "updated": [], "deleted": [] }, "bm_tasklist": { "created": [], "updated": [ { "tl_id": 90, "tl_orderid": 0, "tl_taskcategory": 1, "tl_taskdate": "2025-03-18", "tl_tasktime": "05:10:41", "tl_taskmethod": "0", "tl_istaskprivate": 1, "tl_userid": "27", "tl_priority": 0, "tl_addjobid": 0, "tl_desc": "I", "tl_status": 0, "tl_markasread": 0, "tl_taskstatus": 2, "tl_userdefinedfields": "[]", "tl_markcompleted": 0, "tl_jobmode": "0", "tl_recurrencerule": null, "tl_repeatmaindescription": null, "tl_repeatmethod": "daily", "tl_starttask": null, "tl_startdata": null, "tl_endtask": null, "tl_enddata": null, "tl_istaskrepeat": 0, "tl_deviceplatform": 2, "id": "90", "tl_createdat": 1742298055, "tl_updatedat": 1742464879, "tl_createdby": 27, "tl_updatedby": 27 } ], "deleted": [] }, "bm_jobdetails": { "created": [ { "jd_id": 834, "jd_customerid": 583, "jd_contactid": 605, "jd_additionalcontacts": "605", "jd_templateid": 1, "jd_jobmultiquoteid": 857, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "JBN799", "jd_jobstatus": 3, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "PRAK0001", "jd_invoiceno": "", "jd_listprice": "1509.50", "jd_netprice": "1509.50", "jd_vat": "45.28", "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": "1554.78", "jd_grossprofit": "0.00", "jd_costprice": "1509.50", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "1554.78", "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\":\"JBN799\",\"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\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "3.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "834", "jd_createddate": 1742428800, "jd_orderdate": null, "jd_duedate": 1742428800, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1742464673, "jd_updatedat": 1742464879 } ], "updated": [ { "jd_id": 834, "jd_customerid": 583, "jd_contactid": 605, "jd_additionalcontacts": "605", "jd_templateid": 1, "jd_jobmultiquoteid": 857, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "JBN799", "jd_jobstatus": 3, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "PRAK0001", "jd_invoiceno": "", "jd_listprice": "1509.50", "jd_netprice": "1509.50", "jd_vat": "45.28", "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": "1554.78", "jd_grossprofit": "0.00", "jd_costprice": "1509.50", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "1554.78", "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\":\"JBN799\",\"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\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "3.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "834", "jd_createddate": 1742428800, "jd_orderdate": null, "jd_duedate": 1742428800, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1742464673, "jd_updatedat": 1742464879 } ], "deleted": [] }, "bm_orderitem": { "created": [ { "oi_id": 2127, "oi_jobid": 833, "oi_jobtempid": "0", "oi_jobmultiquoteid": 856, "oi_productid": 3, "oi_recipeid": 3, "oi_ruleid": 0, "oi_qty": 0, "oi_seq": 59, "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\":\"1000\",\"valueid\":null,\"type\":11,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Width\",\"fabricorcolor\":0,\"widthfraction\":\"0_mm_3_0\",\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":11,\"mandatory\":0,\"fieldname\":\"Width\",\"fieldid\":20,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":21,\"labelname\":\"Drop\",\"value\":\"1010\",\"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\":18,\"valueid\":\"19\",\"type\":13,\"optionid\":18,\"optionvalue\":[{\"id\":19,\"fieldid\":19,\"fieldoptionlinkid\":19,\"optionid\":18,\"mainsupplier\":\"3\",\"blindtypecode\":null,\"optionname\":\"Eclipse A\",\"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\":18,\"optionsvalue\":[{\"id\":19,\"fieldid\":19,\"fieldoptionlinkid\":19,\"optionid\":18,\"mainsupplier\":\"3\",\"blindtypecode\":null,\"optionname\":\"Eclipse A\",\"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\":32.51,\"fieldoptionlinkid\":262,\"forchildfieldoptionlinkid\":\"3_262\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"162.55\",\"costprice\":32.51,\"costwithdiscount\":32.51,\"customersellingprice\":162.55,\"customermarkupvalue\":5,\"optiontype\":2,\"quantity\":1,\"optionnetprice\":32.51}],\"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\":32.51,\"fieldoptionlinkid\":262,\"forchildfieldoptionlinkid\":\"3_262\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"162.55\",\"costprice\":32.51,\"costwithdiscount\":32.51,\"customersellingprice\":162.55,\"customermarkupvalue\":5,\"optiontype\":2,\"quantity\":1,\"optionnetprice\":32.51}],\"editruleoverride\":0},{\"id\":23,\"labelname\":\"Fabric\",\"value\":\"10% Cream\",\"valueid\":\"1318\",\"type\":5,\"optionid\":\"1318\",\"optionvalue\":[{\"optionid\":1318,\"optionname\":\"10% Cream\",\"optioncode\":\"DIFF-10%\",\"optionquantity\":1,\"fieldoptionlinkid\":1318,\"forchildfieldoptionlinkid\":\"5_2_1318_1\",\"optionimage\":null,\"subdatacount\":1,\"fabricmapid\":1318,\"pricegroup\":\"Eclipse A\",\"pricegroupid\":18}],\"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\":[{\"fieldtypeid\":5,\"labelnamecode\":\"Color\",\"fieldid\":7538,\"status\":0,\"fieldname\":\"Color\",\"field_has_sub_option\":1,\"selection\":0,\"seq\":1012,\"mandatory\":0,\"fieldlevel\":2,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"fabricorcolor\":2,\"optionsvalue\":[{\"optionid\":3360,\"optionname\":\"Red\",\"optioncode\":\"DIFF-CO-164\",\"optionquantity\":1,\"fieldoptionlinkid\":3360,\"forchildfieldoptionlinkid\":\"5_3_3360_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0}],\"optionsbackup\":[{\"optionid\":3360,\"optionname\":\"Red\",\"optioncode\":\"DIFF-CO-164\",\"optionquantity\":1,\"fieldoptionlinkid\":3360,\"forchildfieldoptionlinkid\":\"5_3_3360_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0}],\"editablecolumns\":[],\"subfieldlinkid\":1318,\"forchildsubfieldlinkid\":\"5_2_1318_1\",\"optionsselectedcolumns\":{\"optionid\":\"Option Id\",\"optionname\":\"Color Name\",\"optioncode\":\"Color Code\"},\"optiondefault\":\"3360\",\"value\":null,\"issubfabric\":0,\"masterparentfieldid\":23,\"hasstock\":1,\"subchild\":[],\"supplierid\":\"0\",\"editruleoverride\":1,\"linktopricegroup\":0,\"dualseq\":1,\"fieldInformation\":null,\"multiseq\":0,\"dumydata\":[],\"blindswidth\":0}],\"fieldInformation\":null,\"optiondefault\":\"1318\",\"optionsvalue\":[{\"optionid\":1318,\"optionname\":\"10% Cream\",\"optioncode\":\"DIFF-10%\",\"optionquantity\":1,\"fieldoptionlinkid\":1318,\"forchildfieldoptionlinkid\":\"5_2_1318_1\",\"optionimage\":null,\"subdatacount\":1,\"fabricmapid\":1318,\"pricegroup\":\"Eclipse A\",\"pricegroupid\":18}],\"editruleoverride\":1},{\"id\":7538,\"labelname\":\"Color\",\"value\":\"Red\",\"valueid\":\"3360\",\"type\":5,\"optionid\":\"3360\",\"optionvalue\":[{\"optionid\":3360,\"optionname\":\"Red\",\"optioncode\":\"DIFF-CO-164\",\"optionquantity\":1,\"fieldoptionlinkid\":3360,\"forchildfieldoptionlinkid\":\"5_3_3360_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0}],\"issubfabric\":0,\"labelnamecode\":\"Color\",\"fabricorcolor\":2,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":2,\"fieldtypeid\":5,\"mandatory\":0,\"fieldname\":\"Color\",\"fieldid\":7538,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"3360\",\"optionsvalue\":[{\"optionid\":3360,\"optionname\":\"Red\",\"optioncode\":\"DIFF-CO-164\",\"optionquantity\":1,\"fieldoptionlinkid\":3360,\"forchildfieldoptionlinkid\":\"5_3_3360_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0}],\"editruleoverride\":1},{\"id\":2213,\"labelname\":\"Test3fgfgf\",\"value\":\"test\",\"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\":1},{\"id\":2209,\"labelname\":\"Test3\",\"value\":\"test\",\"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\":1},{\"id\":2210,\"labelname\":\"Extra\",\"value\":\"test\",\"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\":1},{\"id\":2211,\"labelname\":\"tess\",\"value\":\"test\",\"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\":1},{\"id\":2223,\"labelname\":\"Text\",\"value\":\"estset\",\"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\":1},{\"id\":2224,\"labelname\":\"Number\",\"value\":\"4324\",\"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\":1},{\"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\":\"18\",\"valueid\":\"581\",\"type\":13,\"optionid\":\"18\",\"optionvalue\":[{\"id\":581,\"fieldid\":7505,\"fieldoptionlinkid\":581,\"optionid\":18,\"mainsupplier\":\"3\",\"blindtypecode\":null,\"optionname\":\"Eclipse A\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"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\":\"18\",\"optionsvalue\":[{\"id\":581,\"fieldid\":7505,\"fieldoptionlinkid\":581,\"optionid\":18,\"mainsupplier\":\"3\",\"blindtypecode\":null,\"optionname\":\"Eclipse A\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"editruleoverride\":1}]", "oi_description": "Supplier: PRODUCT SUPPLIER, Width: 1000, Drop: 1010, Product Type: Eclipse A, Extras: Cable Kit for Led in Front Profile LIVE,LED Strip 7mtr LIVE,Zeep,One, Fabric: 10% Cream, Color: Red, Test3fgfgf: test, Test3: test, Extra: test, tess: test, Text: estset, Number: 4324, Product Type2: Eclipse A", "oi_reportdescription": "##Supplier: PRODUCT SUPPLIER##,##Width: 1000 mm##,##Drop: 1010 mm##,##Product Type: Eclipse A##,##Extras: Cable Kit for Led in Front Profile LIVE,LED Strip 7mtr LIVE,Zeep,One##,##Fabric: 10% Cream##,##Color: Red##,##Test3fgfgf: test##,##Test3: test##,##Extra: test##,##tess: test##,##Text: estset##,##Number: 4324##,##Product Type2: Eclipse A##", "oi_reporttitles": "##Supplier:<\/br>##Width:<\/br>##Drop:<\/br>##Product Type:<\/br>##Extras:<\/br>##Fabric:<\/br>##Color:<\/br>##Test3fgfgf:<\/br>##Test3:<\/br>##Extra:<\/br>##tess:<\/br>##Text:<\/br>##Number:<\/br>##Product Type2:", "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\":156,\"value\":null,\"formula\":\"Quantity\",\"price\":null,\"recipeid\":3,\"stockupdate\":0,\"fieldid\":\"3360\",\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":191,\"value\":\"4.00\",\"formula\":\"Extras_OptionQty\",\"price\":\"130.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\":\"141.26\",\"show_hide\":true,\"category\":3}", "oi_productionstatus": null, "oi_costoverride": 1, "oi_costprice": "2000.000", "oi_netprice": "2000.000", "oi_pricesfromoperations": null, "oi_vatprice": "60.000", "oi_vatvalue": "3.000", "oi_vatselected": 3, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "2060.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": "2000.000", "oi_endcustomeroverridevatprice": "60.000", "oi_endcustomeroverridegrossprice": "2060.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[6461, 18, 20, 21, 19, 22, 23, 7538, 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": "2127", "oi_productiondate": 1742482761, "oi_createdat": 1742482761, "oi_updatedat": 1742463113, "oi_createdby": 16, "oi_updatedby": 16 }, { "oi_id": 2128, "oi_jobid": 834, "oi_jobtempid": "0", "oi_jobmultiquoteid": 857, "oi_productid": 38, "oi_recipeid": 38, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 0, "oi_customseq": 0, "oi_productcustomseq": 0, "oi_jsondata": "[{\"id\":2398,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":6493,\"labelname\":\"Unit Type\",\"value\":2,\"valueid\":\"2\",\"type\":34,\"optionid\":\"2\",\"optionvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":\"\",\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":2399,\"labelname\":\"Supplier\",\"value\":21,\"valueid\":\"\",\"type\":17,\"optionid\":\"21\",\"optionvalue\":[{\"id\":21,\"optionid\":21,\"optionname\":\"Live Source\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3126,\"labelname\":\"width\",\"value\":1500,\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3127,\"labelname\":\"drop\",\"value\":2000,\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":2400,\"labelname\":\"Slat Colour\",\"value\":\"\",\"valueid\":\"\",\"type\":13,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":3125,\"labelname\":\"Blinds Slat Materials\",\"value\":\"\",\"valueid\":\"\",\"type\":20,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":7449,\"labelname\":\"Numeric 01\",\"value\":\"\",\"valueid\":\"\",\"type\":6,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":7450,\"labelname\":\"Numeric 02\",\"value\":\"\",\"valueid\":\"\",\"type\":6,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":7458,\"labelname\":\"Extras\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]", "oi_description": "Quantity: 1, Unit Type: mm, Supplier: Live Source, width: 1500, drop: 2000", "oi_reportdescription": "##Quantity: 1##,##Supplier: Live Source##,##width: 1500 mm##,##drop: 2000 mm##", "oi_reporttitles": "##Quantity:##Supplier:##width:##drop:", "oi_productionformulajsondata": "[]", "oi_operationstatus": null, "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "[]", "oi_pricecomesfrom_calculations": "{}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "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": 0, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "0.000", "oi_endcustomeroverridevatprice": "0.000", "oi_endcustomeroverridegrossprice": "0.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[2398, 6493, 2399, 3126, 3127, 2400, 3125, 7449, 7450, 7458]", "oi_deviceplatform": 2, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "2128", "oi_productiondate": 1742464806, "oi_createdat": 1742464812, "oi_updatedat": null, "oi_createdby": 27, "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": 857, "jmq_jobid": 834, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "1509.50", "jmq_netprice": "1509.50", "jmq_vat": "45.28", "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": "1554.78", "jmq_grossprofit": "0.00", "jmq_costprice": "1509.50", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "1554.78", "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": "857", "jmq_duedate": 1742428800, "jmq_sceduleddate": null, "jmq_createdat": "1742464673.000000", "jmq_updatedat": "1742464879.000000", "jmq_createdby": 27, "jmq_updatedby": 27 } ], "updated": [ { "jmq_id": 857, "jmq_jobid": 834, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "1509.50", "jmq_netprice": "1509.50", "jmq_vat": "45.28", "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": "1554.78", "jmq_grossprofit": "0.00", "jmq_costprice": "1509.50", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "1554.78", "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": "857", "jmq_duedate": 1742428800, "jmq_sceduleddate": null, "jmq_createdat": "1742464673.000000", "jmq_updatedat": "1742464879.000000", "jmq_createdby": 27, "jmq_updatedby": 27 } ], "deleted": [] }, "bm_jobstatus_tracks": { "created": [ { "jst_id": 884, "jst_jobid": 834, "jst_job_current_status": 3, "id": "884", "jst_createdat": "1742464879.027088" } ], "updated": [], "deleted": [] }, "bm_customindividuallogs": { "created": [ { "cl_id": 17708, "cl_logname": "default", "cl_type": null, "cl_modulename": "All Jobs", "cl_message": "Invoice Report report generated by Rex All Jobs", "cl_event": "created", "cl_subjectid": 525, "cl_subjecttype": "App\\Models\\Reports\\bm_reportactivitylog", "cl_parentid": 833, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 16, "cl_changedfrom": "null", "cl_changedto": "{\"Invoice no: \":\"IN386\",\"Category: \":\"Invoice\"}", "cl_customproperties": "{\"attributes\":{\"ral_id\":525,\"ral_jobid\":833,\"ral_reportid\":22,\"ral_categoryid\":2,\"ral_description\":\"Invoice Report report generated by Rex\",\"ral_attachment\":\"\",\"ral_actionid\":1,\"ral_createdat\":\"2025-03-20T09:54:44.000000Z\",\"ral_updatedat\":\"2025-03-20T09:54:44.000000Z\",\"ral_createdby\":16,\"ral_updatedby\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17708", "cl_createdat": "1742464484.000000", "cl_updatedat": null }, { "cl_id": 17709, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 834, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 834, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"BlindMatrix\",\"\":\"Australia\",\"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-20-2025 10:01:18\",\"Assigned to\":27,\"Role\":2,\"Date1\":\"2025-03-20\",\"Delivery date1\":\"2025-03-20\",\"Rework date\":\"2025-03-20\",\"jd_additionalcontacts\":\"605\",\"Production Due Date\":\"2025-03-20\",\"Job Ref No\":\"JBN799\",\"Job Status\":\"Quote\",\"Order Status\":\"Order1\",\"Net Price\":\"1509.50\",\"VAT Price\":\"45.28\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"Gross Price Amount\":\"1554.78\",\"Total CostPrice\":\"1509.50\",\"Amount Outstanding\":\"1554.78\",\"jd_isonlineorder\":1,\"Delivery Vat Percentage\":\"3.000\",\"jd_cdeliveryvatperc\":\"3.000\",\"jd_commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":834,\"jd_customerid\":583,\"jd_contactid\":605,\"jd_additionalcontacts\":\"605\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"JBN799\\\",\\\"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\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-03-20\",\"jd_orderdate\":null,\"jd_duedate\":\"2025-03-20\",\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":null,\"jd_jobref\":\"JBN799\",\"jd_jobstatus\":3,\"jd_contactaddid\":0,\"jd_orderstatus\":1,\"jd_accref\":\"PRAK0001\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"1509.50\",\"jd_netprice\":\"1509.50\",\"jd_vat\":\"45.28\",\"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\":\"1554.78\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"1509.50\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"1554.78\",\"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_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":27,\"jd_createdat\":\"2025-03-20T09:57:53.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-03-20T10:01: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": "17709", "cl_createdat": "1742464878.000000", "cl_updatedat": null }, { "cl_id": 17710, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in JBN799", "cl_event": "created", "cl_subjectid": 857, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 834, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":857,\"jmq_jobid\":834,\"Quotation Name\":\"Q1\",\"jmq_isdefault\":0,\"Quotation\":\"Accepted\",\"jmq_isdeclined\":0,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"Production Due Date\":\"0000-00-00\",\"jmq_listprice\":\"1509.50\",\"Net Price\":\"1509.50\",\"VAT Price\":\"45.28\",\"VAT\":1,\"jmq_deliverycost\":\"0.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"1554.78\",\"Gross Profit\":\"0.00\",\"Total CostPrice\":\"1509.50\",\"Amount Outstanding\":\"1554.78\",\"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,\"jmq_commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"Delivery Vat Percentage\":\"3.000\",\"jmq_cdeliveryvatperc\":\"3.000\",\"jmq_grossprofit_percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":857,\"jmq_jobid\":834,\"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\":\"1509.50\",\"jmq_netprice\":\"1509.50\",\"jmq_vat\":\"45.28\",\"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\":\"1554.78\",\"jmq_grossprofit\":\"0.00\",\"jmq_costprice\":\"1509.50\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"1554.78\",\"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-20T09:57:53.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": "17710", "cl_createdat": "1742464879.000000", "cl_updatedat": null }, { "cl_id": 17711, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the field jd_jobmultiquoteid", "cl_event": "modified", "cl_subjectid": 834, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 834, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "[]", "cl_changedto": "{\"jd_jobmultiquoteid\":857}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":857},\"old\":{\"jd_jobmultiquoteid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17711", "cl_createdat": "1742464879.000000", "cl_updatedat": null }, { "cl_id": 17712, "cl_logname": "default", "cl_type": null, "cl_modulename": "Line Item", "cl_message": "Q1 - new item has been created in Line Item for the product of Wooden Venetians", "cl_event": "created", "cl_subjectid": 2128, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 834, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "null", "cl_changedto": "{\"Quantity\":\" 1\",\" Unit Type\":\" mm\",\" Supplier\":\" Live Source\",\" width\":\" 1500\",\" drop\":\" 2000\"}", "cl_customproperties": "{\"attributes\":{\"oi_id\":2128,\"oi_jobid\":834,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":857,\"oi_credit_id\":0,\"oi_productid\":38,\"oi_recipeid\":38,\"oi_ruleid\":0,\"oi_qty\":1,\"oi_seq\":0,\"oi_customseq\":0,\"oi_productcustomseq\":0,\"oi_jsondata\":\"[{\\\"id\\\":2398,\\\"labelname\\\":\\\"Quantity\\\",\\\"value\\\":1,\\\"valueid\\\":\\\"\\\",\\\"type\\\":14,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":6493,\\\"labelname\\\":\\\"Unit Type\\\",\\\"value\\\":2,\\\"valueid\\\":\\\"2\\\",\\\"type\\\":34,\\\"optionid\\\":\\\"2\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":2,\\\"optionname\\\":\\\"mm\\\",\\\"optioncode\\\":\\\"\\\",\\\"optionquantity\\\":1,\\\"unittype\\\":0,\\\"unitcost\\\":0,\\\"pricingtype\\\":0,\\\"fieldoptionlinkid\\\":2,\\\"forchildfieldoptionlinkid\\\":\\\"34_2\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":2399,\\\"labelname\\\":\\\"Supplier\\\",\\\"value\\\":21,\\\"valueid\\\":\\\"\\\",\\\"type\\\":17,\\\"optionid\\\":\\\"21\\\",\\\"optionvalue\\\":[{\\\"id\\\":21,\\\"optionid\\\":21,\\\"optionname\\\":\\\"Live Source\\\",\\\"deleted\\\":0,\\\"optionquantity\\\":1}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":3126,\\\"labelname\\\":\\\"width\\\",\\\"value\\\":1500,\\\"valueid\\\":\\\"\\\",\\\"type\\\":11,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":3127,\\\"labelname\\\":\\\"drop\\\",\\\"value\\\":2000,\\\"valueid\\\":\\\"\\\",\\\"type\\\":12,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":2400,\\\"labelname\\\":\\\"Slat Colour\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":3125,\\\"labelname\\\":\\\"Blinds Slat Materials\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":20,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":2,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7449,\\\"labelname\\\":\\\"Numeric 01\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":6,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7450,\\\"labelname\\\":\\\"Numeric 02\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":6,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":7458,\\\"labelname\\\":\\\"Extras\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0}]\",\"oi_description\":\"Quantity: 1, Unit Type: mm, Supplier: Live Source, width: 1500, drop: 2000\",\"oi_onlinedescription\":null,\"oi_imagepath\":null,\"oi_reportdescription\":\"##Quantity: 1##,##Supplier: Live Source##,##width: 1500 mm##,##drop: 2000 mm##\",\"oi_onlinereportdescription\":null,\"oi_reporttitles\":\"##Quantity:##Supplier:##width:##drop:\",\"oi_onlinereporttitles\":null,\"oi_productionformulajsondata\":\"[]\",\"oi_productiondate\":\"2025-03-20 10:00:06\",\"oi_operationstatus\":null,\"oi_scanstatus\":\"\",\"oi_operationworkroom_data\":\"[]\",\"oi_operationcalender_data\":\"[]\",\"oi_operation_calculations\":\"[]\",\"oi_pricecomesfrom_calculations\":\"{}\",\"oi_pricetablepriceevenbom\":\"{}\",\"oi_productionstatus\":null,\"oi_costoverride\":0,\"oi_costprice\":\"1509.500\",\"oi_netprice\":\"1509.500\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"45.280\",\"oi_vatvalue\":\"3.000\",\"oi_vatselected\":3,\"oi_vattype\":1,\"oi_vatonoff\":1,\"oi_grossprice\":\"1554.790\",\"oi_overrideprice\":\"0.000\",\"oi_overridetype\":1,\"oi_overridevalue\":null,\"oi_overridenetprice\":\"0.000\",\"oi_overridevatprice\":\"0.000\",\"oi_overridegrossprice\":\"0.000\",\"oi_ready\":0,\"oi_onhold\":0,\"oi_platformcreatedfrom\":\"web\",\"oi_platformlastupdatedfrom\":\"web\",\"oi_copiedfrom\":0,\"oi_isonlineorder\":0,\"oi_endcustomervatprice\":null,\"oi_endcustomeroverridetype\":1,\"oi_endcustomeroverridevalue\":null,\"oi_endcustomeroverridenetprice\":\"0.000\",\"oi_endcustomeroverridevatprice\":\"0.000\",\"oi_endcustomeroverridegrossprice\":\"0.000\",\"oi_sage_flag\":0,\"oi_status\":0,\"oi_createdby\":27,\"oi_createdat\":\"2025-03-20T10:00:12.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":null,\"oi_jsondataid\":\"[2398, 6493, 2399, 3126, 3127, 2400, 3125, 7449, 7450, 7458]\",\"oi_deviceplatform\":2,\"oi_custompricefields\":\"\",\"oi_editransfer\":0,\"oi_apisup_orderid\":0,\"oi_commissionprice\":\"0.000\",\"oi_commissionvatprice\":\"0.000\",\"oi_jsondatabackup\":\"\",\"oi_stockdeduct\":0,\"oi_deductedstockdetails\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17712", "cl_createdat": "1742464879.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_terms": {}, "bm_Invoice": {}, "bm_notelist": {}, "bm_tasklist": {}, "bm_orderitem": { "71742464812": 2128 }, "bm_CreditNote": {}, "bm_jobdetails": { "41742464673": 834 }, "bm_paymentlist": {}, "bm_OverPayment": {}, "bm_appointment": {}, "bm_jobmultiquote": { "141742464673": 857 }, "bm_InvoiceDetails": {}, "bm_job_paymentlist": {}, "bm_CreditNoteDetails": {}, "bm_customercontactinfo": { "51742464673": 605 }, "bm_invoice_credit_note": {}, "bm_customertemplatedata": { "31742464673": 583 } }, "timestamp": 1742464878 }