{ "status": "success", "upcomingorder_list": { "bm_customertemplatedata": { "created": [ { "ctd_id": 271, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\": 3, \"764\": 25, \"62\": \"TEST0004\"}", "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": "271", "ctd_createdat": 1754982775, "ctd_updatedat": 1754983468, "ctd_createdby": 0, "ctd_updatedby": null } ], "updated": [ { "ctd_id": 271, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\": 3, \"764\": 25, \"62\": \"TEST0004\"}", "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": "271", "ctd_createdat": 1754982775, "ctd_updatedat": 1754983468, "ctd_createdby": 0, "ctd_updatedby": null } ], "deleted": [] }, "bm_customercontactinfo": { "created": [ { "cci_id": 283, "cci_customerid": 271, "cci_templateid": 3, "roleid": 0, "cci_customizedarray": "{\"75\":1,\"77\":\"Test321\",\"81\":3,\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"90\":35}", "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": 31754982775, "id": "283", "cci_createdat": 1754982775, "cci_updatedat": 1754983468, "cci_createdby": 0, "cci_updatedby": null } ], "updated": [ { "cci_id": 283, "cci_customerid": 271, "cci_templateid": 3, "roleid": 0, "cci_customizedarray": "{\"75\":1,\"77\":\"Test321\",\"81\":3,\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"90\":35}", "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": 31754982775, "id": "283", "cci_createdat": 1754982775, "cci_updatedat": 1754983468, "cci_createdby": 0, "cci_updatedby": null } ], "deleted": [] }, "bm_appointment": { "created": [], "updated": [], "deleted": [] }, "bm_tasklist": { "created": [], "updated": [], "deleted": [] }, "bm_jobdetails": { "created": [ { "jd_id": 444, "jd_customerid": 271, "jd_contactid": 283, "jd_additionalcontacts": "283", "jd_templateid": 1, "jd_jobmultiquoteid": 447, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "JBN441", "jd_jobstatus": 6, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "TEST0004", "jd_invoiceno": "IN255", "jd_listprice": "200.00", "jd_netprice": "200.00", "jd_vat": "20.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": "220.00", "jd_grossprofit": "0.00", "jd_costprice": "200.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "220.00", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": null, "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 1, "jd_updatedby": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "10.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"JBN441\",\"35\":\"TEST0004\",\"36\":6,\"37\":3,\"38\":\"\",\"39\":\"\",\"40\":1,\"41\":1,\"44\":\"\",\"45\":\"Test321\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":35,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"558\":\"\",\"559\":\"\",\"561\":\"\",\"614\":1,\"630\":3,\"677\":\"\",\"678\":\"\",\"695\":\"\",\"697\":\"\",\"698\":\"\",\"700\":\"\",\"701\":\"\",\"719\":\"\",\"720\":\"\",\"721\":\"\",\"722\":\"\",\"725\":\"\",\"729\":\"\",\"730\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "10.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "jd_organizationid": 25, "id": "444", "jd_createddate": 1754956800, "jd_orderdate": 1754956800, "jd_duedate": 1754956800, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1754982775, "jd_updatedat": 1754983468 } ], "updated": [ { "jd_id": 444, "jd_customerid": 271, "jd_contactid": 283, "jd_additionalcontacts": "283", "jd_templateid": 1, "jd_jobmultiquoteid": 447, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "JBN441", "jd_jobstatus": 6, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "TEST0004", "jd_invoiceno": "IN255", "jd_listprice": "200.00", "jd_netprice": "200.00", "jd_vat": "20.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": "220.00", "jd_grossprofit": "0.00", "jd_costprice": "200.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "220.00", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": null, "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 1, "jd_updatedby": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "10.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"JBN441\",\"35\":\"TEST0004\",\"36\":6,\"37\":3,\"38\":\"\",\"39\":\"\",\"40\":1,\"41\":1,\"44\":\"\",\"45\":\"Test321\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":35,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"558\":\"\",\"559\":\"\",\"561\":\"\",\"614\":1,\"630\":3,\"677\":\"\",\"678\":\"\",\"695\":\"\",\"697\":\"\",\"698\":\"\",\"700\":\"\",\"701\":\"\",\"719\":\"\",\"720\":\"\",\"721\":\"\",\"722\":\"\",\"725\":\"\",\"729\":\"\",\"730\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "10.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "jd_organizationid": 25, "id": "444", "jd_createddate": 1754956800, "jd_orderdate": 1754956800, "jd_duedate": 1754956800, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1754982775, "jd_updatedat": 1754983468 } ], "deleted": [] }, "bm_orderitem": { "created": [ { "oi_id": 2177, "oi_jobid": 444, "oi_jobtempid": "0", "oi_jobmultiquoteid": 447, "oi_productid": 117, "oi_recipeid": 141, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":9156,\"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\":9155,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":9157,\"labelname\":\"Supplier\",\"value\":null,\"valueid\":null,\"type\":17,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":9158,\"labelname\":\"Width\",\"value\":\"\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":9159,\"labelname\":\"Drop\",\"value\":\"150\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":9161,\"labelname\":\"Product Type\",\"value\":\"\",\"valueid\":\"\",\"type\":13,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":9162,\"labelname\":\"Multilist\",\"value\":\"Multi Option o613\",\"valueid\":\"8317\",\"type\":3,\"optionid\":\"1320\",\"optionvalue\":[{\"optionid\":1320,\"optionname\":\"Multi Option o613\",\"description\":\"description040\",\"optioncode\":\"codeu547\",\"pricegroups\":\"\",\"optionqty\":1,\"unittype\":\"mm\",\"unitcost\":100,\"fieldoptionlinkid\":8317,\"forchildfieldoptionlinkid\":\"3_8317\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"100.00\",\"fieldid\":8317}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":9163,\"labelname\":\"Singlelist\",\"value\":\"Single Option d661\",\"valueid\":\"8320\",\"type\":3,\"optionid\":\"1322\",\"optionvalue\":[{\"optionid\":1322,\"optionname\":\"Single Option d661\",\"description\":\"description040\",\"optioncode\":\"coden858\",\"pricegroups\":\"\",\"optionqty\":1,\"unittype\":\"mm\",\"unitcost\":100,\"fieldoptionlinkid\":8320,\"forchildfieldoptionlinkid\":\"3_8320\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"100.00\",\"fieldid\":8320}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":9164,\"labelname\":\"Text Field\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":9165,\"labelname\":\"Location List\",\"value\":\"\",\"valueid\":\"\",\"type\":4,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":9166,\"labelname\":\"Numeric Field\",\"value\":\"\",\"valueid\":\"\",\"type\":6,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]", "oi_description": "Drop: 150, Multilist: Multi Option o613, Singlelist: Single Option d661", "oi_reportdescription": "##Quantity: 1##,##Drop: 150 mm##,##Multilist: Multi Option o613##,##Singlelist: Single Option d661##", "oi_reporttitles": "##Quantity:##Drop:##Multilist:##Singlelist:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":9,\"formula\":\"Width*Drop\",\"price\":\"\",\"recipeid\":1,\"stockupdate\":0,\"fieldid\":\"\",\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0},{\"productionoveride\":0,\"id\":10,\"formula\":\"Quantity*NewTest_HH4_OptionQty\",\"price\":\"\",\"recipeid\":1,\"stockupdate\":0,\"fieldid\":26,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3},{\"productionoveride\":0,\"id\":11,\"formula\":\"Quantity\",\"price\":\"\",\"recipeid\":1,\"stockupdate\":0,\"fieldid\":27,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3},{\"productionoveride\":0,\"id\":15,\"formula\":\"Quantity*NewTest_HH4_OptionQty\",\"price\":\"\",\"recipeid\":1,\"stockupdate\":0,\"fieldid\":28,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3},{\"productionoveride\":0,\"id\":16,\"formula\":\"Quantity\",\"price\":\"\",\"recipeid\":1,\"stockupdate\":0,\"fieldid\":29,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3},{\"productionoveride\":0,\"id\":22,\"formula\":\"10\",\"price\":\"\",\"recipeid\":1,\"stockupdate\":0,\"fieldid\":40,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3},{\"productionoveride\":0,\"id\":53,\"formula\":\"10\",\"price\":\"\",\"recipeid\":1,\"stockupdate\":0,\"fieldid\":59,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3},{\"productionoveride\":0,\"id\":349,\"formula\":\"Width\",\"price\":\"\",\"recipeid\":1,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0},{\"productionoveride\":0,\"id\":350,\"formula\":\"Drop\",\"price\":\"\",\"recipeid\":1,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0},{\"productionoveride\":0,\"id\":443,\"formula\":\"Drop\",\"price\":\"\",\"recipeid\":1,\"stockupdate\":0,\"fieldid\":7945,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3},{\"productionoveride\":0,\"id\":444,\"formula\":\"IF(ControlType=\\\"Chain\\\",Quantity,0)\",\"price\":\"\",\"recipeid\":1,\"stockupdate\":0,\"fieldid\":7946,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3},{\"productionoveride\":0,\"id\":17,\"formula\":\"Quantity\",\"price\":\"\",\"recipeid\":1,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0},{\"productionoveride\":0,\"id\":23,\"formula\":\"Quantity\",\"price\":\"\",\"recipeid\":1,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0},{\"productionoveride\":0,\"id\":57,\"formula\":\"Width\",\"price\":\"\",\"recipeid\":1,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0},{\"productionoveride\":0,\"id\":351,\"formula\":\"Quantity\",\"price\":\"\",\"recipeid\":1,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0}]", "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": "200.000", "oi_netprice": "200.000", "oi_pricesfromoperations": null, "oi_vatprice": "20.000", "oi_vatvalue": "10.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "220.000", "oi_overrideprice": "0.000", "oi_overridetype": 3, "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": 3, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "200.000", "oi_endcustomeroverridevatprice": "20.000", "oi_endcustomeroverridegrossprice": "220.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[9156, 9155, 9157, 9158, 9159, 9161, 9162, 9163, 9164, 9165, 9166]", "oi_deviceplatform": 2, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "2177", "oi_productiondate": 1754982783, "oi_createdat": 1754982804, "oi_updatedat": 1754983468, "oi_createdby": 1, "oi_updatedby": null } ], "updated": [], "deleted": [] }, "bm_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_notelist": { "created": [ { "nl_id": 268, "nl_ordertempid": 0, "nl_orderid": 444, "nl_notescategory": 1, "nl_type": 10, "nl_platform": 2, "nl_desc": "Invoice Created (IN255)", "nl_manualNotes": null, "nl_createdby": "1", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 0, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "268", "nl_endddate": 1754956800, "nl_starttime": 1754983136, "created_at": 1754983136, "updated_at": 1754983468, "created_by": 1, "updated_by": null } ], "updated": [], "deleted": [] }, "bm_deliveryaddresssetting": { "created": [ { "das_id": 257, "das_jobid": 444, "das_appointmentaddress": 283, "das_invoiceaddress": 283, "das_invoicedeliveryaddress": 283, "das_purchaseaddress": 0, "das_worksheetaddress": 0, "id": "257", "das_createdat": 1754983468, "das_updatedat": 1754983468, "das_createdby": 1, "das_updatedby": null } ], "updated": [], "deleted": [] }, "bm_jobchecklist": { "created": [], "updated": [], "deleted": [] }, "bm_Invoice": { "created": [ { "invoice_id": 152, "job_id": 444, "customer_id": 271, "ref_no": "IN255", "invoice_type": 1, "invoice_split_type": 0, "invoice_split_cal": 0, "invoice_split_cal_value": null, "net_amount": "200.000", "vat_amount": "20.000", "gross_amount": "220.000", "delivery_amount": "0.000", "delivery": 0, "commission_amount": "0.000", "commission": 0, "total_amount": "220.000", "split_net_amount": null, "split_vat_amount": null, "outstanding_amount": "220.000", "paid_amount": "0.000", "paid_status": 0, "status": 0, "transfer": 0, "transfer_id": null, "id": "152", "paymentDueDate": 1754956800, "invoiceDate": 1754956800, "transferDate": null, "createdat": 1754983136, "updatedat": 1754983468, "createdby": 1, "updatedby": null } ], "updated": [], "deleted": [] }, "bm_InvoiceDetails": { "created": [ { "ind_id": 1406, "ind_invoice_id": 152, "ind_order_id": 2177, "ind_qty": 1, "ind_net_amount": "200.000", "ind_vat_amount": "20.000", "ind_gross_amount": "220.000", "ind_status": 0, "id": "1406", "ind_createdat": 1754983136, "ind_updatedat": 1754983136, "ind_createdby": 1, "ind_updatedby": null } ], "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": 447, "jmq_jobid": 444, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "200.00", "jmq_netprice": "200.00", "jmq_vat": "20.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": "220.00", "jmq_grossprofit": "0.00", "jmq_costprice": "200.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "220.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", "id": "447", "jmq_duedate": 1754956800, "jmq_sceduleddate": null, "jmq_createdat": "1754982775.000000", "jmq_updatedat": "1754983468.000000", "jmq_createdby": 1, "jmq_updatedby": 1 } ], "updated": [ { "jmq_id": 447, "jmq_jobid": 444, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "200.00", "jmq_netprice": "200.00", "jmq_vat": "20.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": "220.00", "jmq_grossprofit": "0.00", "jmq_costprice": "200.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "220.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", "id": "447", "jmq_duedate": 1754956800, "jmq_sceduleddate": null, "jmq_createdat": "1754982775.000000", "jmq_updatedat": "1754983468.000000", "jmq_createdby": 1, "jmq_updatedby": 1 } ], "deleted": [] }, "bm_jobstatus_tracks": { "created": [ { "jst_id": 464, "jst_jobid": 444, "jst_job_current_status": 6, "id": "464", "jst_createdat": "1754983468.191214" } ], "updated": [], "deleted": [] }, "bm_customindividuallogs": { "created": [ { "cl_id": 8500, "cl_logname": "default", "cl_type": null, "cl_modulename": "All Jobs", "cl_message": "Order Confirmation 2 report generated by admin All Jobs", "cl_event": "created", "cl_subjectid": 209, "cl_subjecttype": "App\\Models\\Reports\\bm_reportactivitylog", "cl_parentid": 2147483647, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Category: \":\"Order Confirmation\"}", "cl_customproperties": "{\"attributes\":{\"ral_id\":209,\"ral_jobid\":2147483647,\"ral_reportid\":20,\"ral_categoryid\":3,\"ral_description\":\"Order Confirmation 2 report generated by admin\",\"ral_attachment\":\"\",\"ral_actionid\":1,\"ral_createdat\":\"2025-08-12T07:13:48.000000Z\",\"ral_updatedat\":\"2025-08-12T07:13:48.000000Z\",\"ral_createdby\":1,\"ral_updatedby\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "8500", "cl_createdat": "1754982828.000000", "cl_updatedat": null }, { "cl_id": 8501, "cl_logname": "default", "cl_type": null, "cl_modulename": "All Jobs", "cl_message": "Order Confirmation 2 report generated by admin All Jobs", "cl_event": "created", "cl_subjectid": 210, "cl_subjecttype": "App\\Models\\Reports\\bm_reportactivitylog", "cl_parentid": 2147483647, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Category: \":\"Order Confirmation\"}", "cl_customproperties": "{\"attributes\":{\"ral_id\":210,\"ral_jobid\":2147483647,\"ral_reportid\":20,\"ral_categoryid\":3,\"ral_description\":\"Order Confirmation 2 report generated by admin\",\"ral_attachment\":\"\",\"ral_actionid\":1,\"ral_createdat\":\"2025-08-12T07:13:56.000000Z\",\"ral_updatedat\":\"2025-08-12T07:13:56.000000Z\",\"ral_createdby\":1,\"ral_updatedby\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "8501", "cl_createdat": "1754982836.000000", "cl_updatedat": null }, { "cl_id": 8502, "cl_logname": "default", "cl_type": null, "cl_modulename": "All Jobs", "cl_message": "Quotation report generated by admin All Jobs", "cl_event": "created", "cl_subjectid": 211, "cl_subjecttype": "App\\Models\\Reports\\bm_reportactivitylog", "cl_parentid": 2147483647, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Category: \":\"Quotation\"}", "cl_customproperties": "{\"attributes\":{\"ral_id\":211,\"ral_jobid\":2147483647,\"ral_reportid\":1,\"ral_categoryid\":1,\"ral_description\":\"Quotation report generated by admin\",\"ral_attachment\":\"\",\"ral_actionid\":1,\"ral_createdat\":\"2025-08-12T07:14:00.000000Z\",\"ral_updatedat\":\"2025-08-12T07:14:00.000000Z\",\"ral_createdby\":1,\"ral_updatedby\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "8502", "cl_createdat": "1754982840.000000", "cl_updatedat": null }, { "cl_id": 8503, "cl_logname": "default", "cl_type": null, "cl_modulename": "All Jobs", "cl_message": "Order Confirmation 2 report generated by admin All Jobs", "cl_event": "created", "cl_subjectid": 212, "cl_subjecttype": "App\\Models\\Reports\\bm_reportactivitylog", "cl_parentid": 2147483647, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Category: \":\"Order Confirmation\"}", "cl_customproperties": "{\"attributes\":{\"ral_id\":212,\"ral_jobid\":2147483647,\"ral_reportid\":20,\"ral_categoryid\":3,\"ral_description\":\"Order Confirmation 2 report generated by admin\",\"ral_attachment\":\"\",\"ral_actionid\":1,\"ral_createdat\":\"2025-08-12T07:23:28.000000Z\",\"ral_updatedat\":\"2025-08-12T07:23:28.000000Z\",\"ral_createdby\":1,\"ral_updatedby\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "8503", "cl_createdat": "1754983408.000000", "cl_updatedat": null }, { "cl_id": 8504, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 444, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 444, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"BlindMatrix\",\"\":1,\"Account Type\":\"Trade\",\"Created By\":\"admin\",\"First Name\":\"Test321\",\"Country\":\"India\",\"Salutation\":\"Mr.\",\"Account manager\":1,\"Role\":3,\"Check Box7\":\"Disabled\",\"Date & Time5\":\"12-08-2025 03:24:28\",\"Date & Time4\":\"12-08-2025 03:24:28\",\"Date\":\"2025-08-12\",\"Additional Contacts\":\"283\",\"Order Date\":\"2025-08-12\",\"Production Due Date\":\"2025-08-11\",\"Job Ref No\":\"JBN441\",\"Job Status\":\"Invoiced\",\"Order Status\":\"New order\",\"Net Price\":\"200.00\",\"VAT Price\":\"20.00\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"Gross Price Amount\":\"220.00\",\"Total CostPrice\":\"200.00\",\"Amount Outstanding\":\"220.00\",\"jd_isonlineorder\":1,\"jd_organizationid\":25,\"Delivery Vat Percentage\":\"10.000\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\",\"Job Rework Enable\":\"On\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":444,\"jd_customerid\":271,\"jd_contactid\":283,\"jd_additionalcontacts\":\"283\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"JBN441\\\",\\\"35\\\":\\\"TEST0004\\\",\\\"36\\\":6,\\\"37\\\":3,\\\"38\\\":\\\"\\\",\\\"39\\\":\\\"\\\",\\\"40\\\":1,\\\"41\\\":1,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"Test321\\\",\\\"46\\\":\\\"\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":35,\\\"285\\\":1,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"558\\\":\\\"\\\",\\\"559\\\":\\\"\\\",\\\"561\\\":\\\"\\\",\\\"614\\\":1,\\\"630\\\":3,\\\"677\\\":\\\"\\\",\\\"678\\\":\\\"\\\",\\\"695\\\":\\\"\\\",\\\"697\\\":\\\"\\\",\\\"698\\\":\\\"\\\",\\\"700\\\":\\\"\\\",\\\"701\\\":\\\"\\\",\\\"719\\\":\\\"\\\",\\\"720\\\":\\\"\\\",\\\"721\\\":\\\"\\\",\\\"722\\\":\\\"\\\",\\\"725\\\":\\\"\\\",\\\"729\\\":\\\"\\\",\\\"730\\\":\\\"\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-08-12\",\"jd_orderdate\":\"2025-08-12\",\"jd_duedate\":\"2025-08-11\",\"jd_duedatechangedmanually\":0,\"jd_sceduleddate\":null,\"jd_invoicedate\":\"0000-00-00\",\"jd_completeddate\":null,\"jd_jobref\":\"JBN441\",\"jd_jobstatus\":6,\"jd_contactaddid\":0,\"jd_orderstatus\":1,\"jd_accref\":\"TEST0004\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"200.00\",\"jd_netprice\":\"200.00\",\"jd_vat\":\"20.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\":\"220.00\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"200.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"220.00\",\"jd_totpaid\":\"0.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":null,\"jd_deliverycostid\":0,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_accountingsoftware_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":0,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":0,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":0,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":0,\"jd_organizationid\":25,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":1,\"jd_createdat\":\"2025-08-12T07:12:55.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-08-12T07:24:28.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\":\"10.000\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"10.000\",\"jd_commission\":\"[]\",\"jd_commissionprice\":\"0.00\",\"jd_commissionsetting\":0,\"jd_commissionaddedvalue\":\"0.00\",\"jd_onlineprefixseq\":null,\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":1,\"jd_rework_count\":0,\"jd_num_of_payments\":0}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "8504", "cl_createdat": "1754983468.000000", "cl_updatedat": null }, { "cl_id": 8505, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 268, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 444, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Trade\",\"Description\":\"Invoice Created (201754983136)\",\"Created By\":\"admin\",\"Date\":\"2025-08-12\",\"Time\":\"07:18:56\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":268,\"nl_ordertempid\":0,\"nl_orderid\":444,\"nl_notescategory\":1,\"nl_type\":10,\"nl_platform\":2,\"nl_desc\":\"Invoice Created (201754983136)\",\"nl_manualNotes\":null,\"nl_createdby\":\"1\",\"nl_endddate\":\"2025-08-12\",\"nl_starttime\":\"07:18:56\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":1,\"created_at\":\"2025-08-12T07:18:56.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-08-12T07:24:28.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "8505", "cl_createdat": "1754983468.000000", "cl_updatedat": null }, { "cl_id": 8506, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in JBN441", "cl_event": "created", "cl_subjectid": 447, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 444, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":447,\"jmq_jobid\":444,\"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\":\"200.00\",\"Net Price\":\"200.00\",\"VAT Price\":\"20.00\",\"VAT\":1,\"jmq_deliverycost\":\"0.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"220.00\",\"Gross Profit\":\"0.00\",\"Total CostPrice\":\"200.00\",\"Amount Outstanding\":\"220.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\":447,\"jmq_jobid\":444,\"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\":\"200.00\",\"jmq_netprice\":\"200.00\",\"jmq_vat\":\"20.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\":\"220.00\",\"jmq_grossprofit\":\"0.00\",\"jmq_costprice\":\"200.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"220.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\":1,\"jmq_updatedby\":1,\"jmq_createdat\":\"2025-08-12T07:12: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": "8506", "cl_createdat": "1754983468.000000", "cl_updatedat": null }, { "cl_id": 8507, "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": 444, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 444, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":447}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":447},\"old\":{\"jd_jobmultiquoteid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "8507", "cl_createdat": "1754983468.000000", "cl_updatedat": null }, { "cl_id": 8508, "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 Blind fabric4819", "cl_event": "created", "cl_subjectid": 2177, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 444, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Drop\":\" 150\",\" Multilist\":\" Multi Option o613\",\" Singlelist\":\" Single Option d661\"}", "cl_customproperties": "{\"attributes\":{\"oi_id\":2177,\"oi_jobid\":444,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":447,\"oi_credit_id\":0,\"oi_productid\":117,\"oi_recipeid\":141,\"oi_ruleid\":0,\"oi_qty\":1,\"oi_seq\":1,\"oi_customseq\":1,\"oi_productcustomseq\":1,\"oi_jsondata\":\"[{\\\"id\\\":9156,\\\"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\\\":9155,\\\"labelname\\\":\\\"Quantity\\\",\\\"value\\\":1,\\\"valueid\\\":\\\"\\\",\\\"type\\\":14,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":9157,\\\"labelname\\\":\\\"Supplier\\\",\\\"value\\\":null,\\\"valueid\\\":null,\\\"type\\\":17,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":9158,\\\"labelname\\\":\\\"Width\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":11,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":9159,\\\"labelname\\\":\\\"Drop\\\",\\\"value\\\":\\\"150\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":12,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":9161,\\\"labelname\\\":\\\"Product Type\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":9162,\\\"labelname\\\":\\\"Multilist\\\",\\\"value\\\":\\\"Multi Option o613\\\",\\\"valueid\\\":\\\"8317\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"1320\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":1320,\\\"optionname\\\":\\\"Multi Option o613\\\",\\\"description\\\":\\\"description040\\\",\\\"optioncode\\\":\\\"codeu547\\\",\\\"pricegroups\\\":\\\"\\\",\\\"optionqty\\\":1,\\\"unittype\\\":\\\"mm\\\",\\\"unitcost\\\":100,\\\"fieldoptionlinkid\\\":8317,\\\"forchildfieldoptionlinkid\\\":\\\"3_8317\\\",\\\"hasstock\\\":1,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"100.00\\\",\\\"fieldid\\\":8317}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":9163,\\\"labelname\\\":\\\"Singlelist\\\",\\\"value\\\":\\\"Single Option d661\\\",\\\"valueid\\\":\\\"8320\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"1322\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":1322,\\\"optionname\\\":\\\"Single Option d661\\\",\\\"description\\\":\\\"description040\\\",\\\"optioncode\\\":\\\"coden858\\\",\\\"pricegroups\\\":\\\"\\\",\\\"optionqty\\\":1,\\\"unittype\\\":\\\"mm\\\",\\\"unitcost\\\":100,\\\"fieldoptionlinkid\\\":8320,\\\"forchildfieldoptionlinkid\\\":\\\"3_8320\\\",\\\"hasstock\\\":1,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"100.00\\\",\\\"fieldid\\\":8320}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":9164,\\\"labelname\\\":\\\"Text Field\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":9165,\\\"labelname\\\":\\\"Location List\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":4,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":9166,\\\"labelname\\\":\\\"Numeric Field\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":6,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0}]\",\"oi_description\":\"Drop: 150, Multilist: Multi Option o613, Singlelist: Single Option d661\",\"oi_onlinedescription\":null,\"oi_imagepath\":null,\"oi_reportdescription\":\"##Quantity: 1##,##Drop: 150 mm##,##Multilist: Multi Option o613##,##Singlelist: Single Option d661##\",\"oi_onlinereportdescription\":null,\"oi_reporttitles\":\"##Quantity:##Drop:##Multilist:##Singlelist:\",\"oi_onlinereporttitles\":null,\"oi_productionformulajsondata\":\"[{\\\"productionoveride\\\":0,\\\"id\\\":9,\\\"formula\\\":\\\"Width*Drop\\\",\\\"price\\\":\\\"\\\",\\\"recipeid\\\":1,\\\"stockupdate\\\":0,\\\"fieldid\\\":\\\"\\\",\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0},{\\\"productionoveride\\\":0,\\\"id\\\":10,\\\"formula\\\":\\\"Quantity*NewTest_HH4_OptionQty\\\",\\\"price\\\":\\\"\\\",\\\"recipeid\\\":1,\\\"stockupdate\\\":0,\\\"fieldid\\\":26,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":3},{\\\"productionoveride\\\":0,\\\"id\\\":11,\\\"formula\\\":\\\"Quantity\\\",\\\"price\\\":\\\"\\\",\\\"recipeid\\\":1,\\\"stockupdate\\\":0,\\\"fieldid\\\":27,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":3},{\\\"productionoveride\\\":0,\\\"id\\\":15,\\\"formula\\\":\\\"Quantity*NewTest_HH4_OptionQty\\\",\\\"price\\\":\\\"\\\",\\\"recipeid\\\":1,\\\"stockupdate\\\":0,\\\"fieldid\\\":28,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":3},{\\\"productionoveride\\\":0,\\\"id\\\":16,\\\"formula\\\":\\\"Quantity\\\",\\\"price\\\":\\\"\\\",\\\"recipeid\\\":1,\\\"stockupdate\\\":0,\\\"fieldid\\\":29,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":3},{\\\"productionoveride\\\":0,\\\"id\\\":22,\\\"formula\\\":\\\"10\\\",\\\"price\\\":\\\"\\\",\\\"recipeid\\\":1,\\\"stockupdate\\\":0,\\\"fieldid\\\":40,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":3},{\\\"productionoveride\\\":0,\\\"id\\\":53,\\\"formula\\\":\\\"10\\\",\\\"price\\\":\\\"\\\",\\\"recipeid\\\":1,\\\"stockupdate\\\":0,\\\"fieldid\\\":59,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":3},{\\\"productionoveride\\\":0,\\\"id\\\":349,\\\"formula\\\":\\\"Width\\\",\\\"price\\\":\\\"\\\",\\\"recipeid\\\":1,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0},{\\\"productionoveride\\\":0,\\\"id\\\":350,\\\"formula\\\":\\\"Drop\\\",\\\"price\\\":\\\"\\\",\\\"recipeid\\\":1,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0},{\\\"productionoveride\\\":0,\\\"id\\\":443,\\\"formula\\\":\\\"Drop\\\",\\\"price\\\":\\\"\\\",\\\"recipeid\\\":1,\\\"stockupdate\\\":0,\\\"fieldid\\\":7945,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":3},{\\\"productionoveride\\\":0,\\\"id\\\":444,\\\"formula\\\":\\\"IF(ControlType=\\\\\\\"Chain\\\\\\\",Quantity,0)\\\",\\\"price\\\":\\\"\\\",\\\"recipeid\\\":1,\\\"stockupdate\\\":0,\\\"fieldid\\\":7946,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":3},{\\\"productionoveride\\\":0,\\\"id\\\":17,\\\"formula\\\":\\\"Quantity\\\",\\\"price\\\":\\\"\\\",\\\"recipeid\\\":1,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":0,\\\"fieldtype_id\\\":0},{\\\"productionoveride\\\":0,\\\"id\\\":23,\\\"formula\\\":\\\"Quantity\\\",\\\"price\\\":\\\"\\\",\\\"recipeid\\\":1,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":0,\\\"fieldtype_id\\\":0},{\\\"productionoveride\\\":0,\\\"id\\\":57,\\\"formula\\\":\\\"Width\\\",\\\"price\\\":\\\"\\\",\\\"recipeid\\\":1,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":0,\\\"fieldtype_id\\\":0},{\\\"productionoveride\\\":0,\\\"id\\\":351,\\\"formula\\\":\\\"Quantity\\\",\\\"price\\\":\\\"\\\",\\\"recipeid\\\":1,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":0,\\\"fieldtype_id\\\":0}]\",\"oi_productiondate\":\"2025-08-12 07:13:03\",\"oi_manualduedate\":0,\"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\":\"200.000\",\"oi_netprice\":\"200.000\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"20.000\",\"oi_vatvalue\":\"10.000\",\"oi_vatselected\":1,\"oi_vattype\":1,\"oi_vatonoff\":1,\"oi_grossprice\":\"220.000\",\"oi_overrideprice\":\"0.000\",\"oi_overridetype\":3,\"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\":3,\"oi_endcustomeroverridevalue\":null,\"oi_endcustomeroverridenetprice\":\"200.000\",\"oi_endcustomeroverridevatprice\":\"20.000\",\"oi_endcustomeroverridegrossprice\":\"220.000\",\"oi_sage_flag\":0,\"oi_supid\":null,\"oi_status\":0,\"oi_createdby\":1,\"oi_createdat\":\"2025-08-12T07:13:24.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":null,\"oi_jsondataid\":\"[9156, 9155, 9157, 9158, 9159, 9161, 9162, 9163, 9164, 9165, 9166]\",\"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": "8508", "cl_createdat": "1754983468.000000", "cl_updatedat": null }, { "cl_id": 8509, "cl_logname": "model", "cl_type": null, "cl_modulename": "Production Due Date", "cl_message": "Production Due Date has been updated", "cl_event": "modified", "cl_subjectid": 444, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 444, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "{\"Production Due Date\":\"2025-08-11\"}", "cl_changedto": "{\"Production Due Date\":\"2025-08-12\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "8509", "cl_createdat": "1754983468.000000", "cl_updatedat": null }, { "cl_id": 8510, "cl_logname": "default", "cl_type": null, "cl_modulename": "Alternative Address", "cl_message": "Alternative Address has been updated the fields Appointments Add,Invoice Add,Invoice Delivery Add,Purchase Add,Worksheet Add", "cl_event": "modified", "cl_subjectid": 257, "cl_subjecttype": "App\\Models\\Job\\bm_deliveryaddresssetting", "cl_parentid": 444, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Appointments Add\":\"Alternative Delivery Address\",\"Invoice Add\":\"Alternative Delivery Address\",\"Invoice Delivery Add\":\"Alternative Delivery Address\",\"Purchase Add\":\"Default(Same as billing add)\",\"Worksheet Add\":\"Default(Same as billing add)\"}", "cl_customproperties": "{\"attributes\":{\"das_id\":257,\"das_jobid\":444,\"das_appointmentaddress\":283,\"das_invoiceaddress\":283,\"das_invoicedeliveryaddress\":283,\"das_purchaseaddress\":0,\"das_worksheetaddress\":0,\"das_createdby\":1,\"das_createdat\":\"2025-08-12T07:24:28.000000Z\",\"das_updatedby\":null,\"das_updatedat\":\"2025-08-12T07:24:28.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "8510", "cl_createdat": "1754983468.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": [ { "organization_id": 25, "organizationname": "BlindMatrix", "address": "Temple Tower", "address2": "CIT Nagar West", "addres3": "Anna Salai, Nandanam", "city": "Chennai", "state": "Tamilnadu", "country": null, "code": "600035", "phone": "9940258697", "mobile1": "6625487895", "mobile2": "6658745879", "fax": "014423", "email3": "test3@blindmatrix.com", "email1": "test1@blindmatrix.com", "email2": "test2@blindmatrix.com", "website": "www.bm.com", "logoname": "Logo__Side_lock_up__white.png", "logo": "103232-Logo__Side_lock_up__white.png", "vatnumber": null, "vatrate": null, "settlementdiscount": null, "reportemailbody": null, "domesticpaymentterms": null, "contractpaymentterms": null, "tradepaymentterms": null, "companyterms": "Terms", "countryid": 48, "bankname": "SBI", "comregistrationno": "BM0012458", "defaultsalestax": 1, "defaultsalestaxlabel": "GST", "accountnumber": "364583600247", "currencyid": 48, "sortcode": "4545", "status": 0, "isdefault": 1, "id": "25", "created_at": 1754983468, "updated_at": 1754983468, "created_by": 1, "updated_by": 1 }, { "organization_id": 29, "organizationname": "Arts", "address": "null", "address2": "null", "addres3": "null", "city": "null", "state": "null", "country": null, "code": "null", "phone": "null", "mobile1": "null", "mobile2": "null", "fax": "null", "email3": "null", "email1": "null", "email2": "null", "website": "null", "logoname": null, "logo": null, "vatnumber": "null", "vatrate": null, "settlementdiscount": null, "reportemailbody": null, "domesticpaymentterms": null, "contractpaymentterms": null, "tradepaymentterms": null, "companyterms": "null", "countryid": 48, "bankname": "null", "comregistrationno": "null", "defaultsalestax": 1, "defaultsalestaxlabel": "GST", "accountnumber": "null", "currencyid": 48, "sortcode": "null", "status": 0, "isdefault": 0, "id": "29", "created_at": 1754983468, "updated_at": 1754983468, "created_by": 24, "updated_by": null } ], "updated": [ { "organization_id": 25, "organizationname": "BlindMatrix", "address": "Temple Tower", "address2": "CIT Nagar West", "addres3": "Anna Salai, Nandanam", "city": "Chennai", "state": "Tamilnadu", "country": null, "code": "600035", "phone": "9940258697", "mobile1": "6625487895", "mobile2": "6658745879", "fax": "014423", "email3": "test3@blindmatrix.com", "email1": "test1@blindmatrix.com", "email2": "test2@blindmatrix.com", "website": "www.bm.com", "logoname": "Logo__Side_lock_up__white.png", "logo": "103232-Logo__Side_lock_up__white.png", "vatnumber": null, "vatrate": null, "settlementdiscount": null, "reportemailbody": null, "domesticpaymentterms": null, "contractpaymentterms": null, "tradepaymentterms": null, "companyterms": "Terms", "countryid": 48, "bankname": "SBI", "comregistrationno": "BM0012458", "defaultsalestax": 1, "defaultsalestaxlabel": "GST", "accountnumber": "364583600247", "currencyid": 48, "sortcode": "4545", "status": 0, "isdefault": 1, "id": "25", "created_at": 1754983468, "updated_at": 1754983468, "created_by": 1, "updated_by": 1 } ], "deleted": [] }, "bm_applicationSetup": { "created": [], "updated": [], "deleted": [] }, "bm_price_setup": { "created": [], "updated": [], "deleted": [] }, "bm_calendarsetup": { "created": [], "updated": [], "deleted": [] }, "bm_appointmenttype": { "created": [], "updated": [], "deleted": [] }, "bm_userWorkDay": { "created": [], "updated": [], "deleted": [] }, "bm_users": { "created": [], "updated": [], "deleted": [] }, "custom_fields": { "created": [], "updated": [], "deleted": [] }, "customfieldvalues": { "created": [], "updated": [], "deleted": [] } }, "synctodelete": { "bm_customercontactinfo": { "51754982775": 283 }, "bm_customertemplatedata": { "31754982775": 271 }, "bm_jobdetails": { "41754982775": 444 }, "bm_notelist": { "61754983136": 268 }, "bm_jobmultiquote": { "141754982775": 447 }, "bm_orderitem": { "71754982804": 2177 }, "bm_Invoice": { "121754983136": 152 }, "bm_InvoiceDetails": { "101754983136": 1406 }, "bm_deliveryaddresssetting": { "161754982809": 257 } }, "timestamp": 1754983468 }