{ "status": "success", "upcomingorder_list": { "bm_customertemplatedata": { "created": [], "updated": [], "deleted": [] }, "bm_customercontactinfo": { "created": [], "updated": [], "deleted": [] }, "bm_appointment": { "created": [ { "app_eventid": 2308, "app_description": null, "app_summary": "BD2610-Offline@2", "app_private": 0, "app_appointmentType": 62, "app_userId": 9, "app_orderId": 2714, "app_customerId": 0, "app_isAllDay": 0, "app_timezone": "Asia\/Kolkata", "app_latitude": 0, "app_longitude": 0, "app_parentappid": null, "app_recurrencerule": null, "app_userdefinedValue": "[]", "app_recurrenceexception": null, "app_attachment": "[]", "guid": "", "app_staff": "", "app_appointtype": "", "app_confirmed": 0, "app_travelHour": "0", "app_travelMinute": "0", "app_onsiteHour": null, "app_onsiteMinute": null, "app_location": null, "app_traveltime": null, "app_googleid": "0", "app_platform": "web", "app_cal_status": 808, "app_status": 0, "app_markasread": 0, "app_statusInGoogle": 0, "app_runid": null, "app_jobtimehour": "0", "app_jobtimeminute": "30", "app_products": null, "app_deviceplatform": 1, "app_recurrenceexception_date": null, "app_deliveryaddressid": null, "id": "2308", "app_sdate": 1742774400, "app_edate": 1742774400, "app_stime": 1742808636, "app_etime": 1742810436, "app_sdatetime": 1742808636, "app_edatetime": 1742810436, "app_until": null, "app_createdAt": 1742811106, "app_updatedAt": 1742811106, "app_createdBy": 52, "app_updatedBy": null } ], "updated": [], "deleted": [] }, "bm_tasklist": { "created": [ { "tl_id": 306, "tl_orderid": 2714, "tl_taskcategory": 1, "tl_taskdate": "2025-03-24", "tl_tasktime": "15:41:50", "tl_taskmethod": "0", "tl_istaskprivate": 0, "tl_userid": "52", "tl_priority": 0, "tl_addjobid": 2714, "tl_desc": "Offline Testing", "tl_status": 0, "tl_markasread": 0, "tl_taskstatus": 2, "tl_userdefinedfields": "[]", "tl_markcompleted": 0, "tl_jobmode": "job", "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": 1, "id": "306", "tl_createdat": 1742811148, "tl_updatedat": 1742811148, "tl_createdby": 52, "tl_updatedby": null } ], "updated": [], "deleted": [] }, "bm_jobdetails": { "created": [], "updated": [ { "jd_id": 2714, "jd_customerid": 1444, "jd_contactid": 2694, "jd_additionalcontacts": "2694", "jd_templateid": 1, "jd_jobmultiquoteid": 2732, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "BD2610", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 2, "jd_accref": "OFFL0002", "jd_invoiceno": "", "jd_listprice": "40.32", "jd_netprice": "40.32", "jd_vat": "3.68", "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": "44.00", "jd_grossprofit": "0.00", "jd_costprice": "40.32", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "0.00", "jd_totpaid": "44.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": 52, "jd_updatedby": 52, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "9.125", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"BD2610\",\"35\":\"OFFL0002\",\"36\":1,\"37\":1,\"38\":\"\",\"39\":23,\"40\":2,\"41\":52,\"44\":\"\",\"45\":\"Offline@2\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":35,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"470\":\"\",\"477\":\"\",\"584\":\"\",\"605\":\"\",\"606\":\"\",\"608\":52,\"633\":1,\"705\":\"\",\"718\":1,\"757\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "9.125", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "2714", "jd_createddate": 1742774400, "jd_orderdate": null, "jd_duedate": 1742774400, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1742810458, "jd_updatedat": 1742811148 } ], "deleted": [] }, "bm_orderitem": { "created": [ { "oi_id": 6496, "oi_jobid": 2714, "oi_jobtempid": "0", "oi_jobmultiquoteid": 2732, "oi_productid": 557, "oi_recipeid": 710, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 0, "oi_customseq": 0, "oi_productcustomseq": 0, "oi_jsondata": "[{\"id\":24531,\"labelname\":\"Unit Type\",\"value\":1,\"valueid\":\"1\",\"type\":34,\"optionid\":\"1\",\"optionvalue\":[{\"optionid\":1,\"optionname\":\"cm\",\"optioncode\":\"\",\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":1,\"forchildfieldoptionlinkid\":\"34_1\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":24428,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":24429,\"labelname\":\"Supplier\",\"value\":\"234\",\"valueid\":\"\",\"type\":17,\"optionid\":\"234\",\"optionvalue\":[{\"id\":234,\"optionid\":234,\"optionname\":\"Perfa\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":24515,\"labelname\":\"Room\",\"value\":\"\",\"valueid\":\"\",\"type\":29,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":24430,\"labelname\":\"Pricing Band\",\"value\":1419,\"valueid\":\"2077\",\"type\":13,\"optionid\":\"1419\",\"optionvalue\":[{\"id\":2077,\"fieldid\":24430,\"fieldoptionlinkid\":2077,\"optionid\":1419,\"mainsupplier\":\"234\",\"blindtypecode\":\"\",\"optionname\":\"Louvolite Vertical Price 2025 Group A\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":24516,\"labelname\":\"Blind Size or Recess\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":24517,\"labelname\":\"Width\",\"value\":\"50\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":24518,\"labelname\":\"Drop\",\"value\":\"50\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":24520,\"labelname\":\"Steering System\",\"value\":\"Rod\",\"valueid\":\"28685\",\"type\":3,\"optionid\":\"5533\",\"optionvalue\":[{\"optionid\":5533,\"optionname\":\"Rod\",\"description\":\"\",\"optioncode\":\"V-04\",\"pricegroups\":\"calnova Manual,calnova Motorised,Zenith Manual,Zenith Motorised,Dickson Manual,Intu C,Intu Pleated C,Intu Roller Band A,Intu Roller Band B,Intu Roller Band C\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":28685,\"forchildfieldoptionlinkid\":\"3_28685\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":24521,\"labelname\":\"Control Side\",\"value\":\"Right\",\"valueid\":\"28687\",\"type\":3,\"optionid\":\"5273\",\"optionvalue\":[{\"optionid\":5273,\"optionname\":\"Right\",\"description\":\"\",\"optioncode\":\"RT\",\"pricegroups\":\"25mm Textured,25mm Premium Metallic,16mm Prime,35mm Prime,50mm Prime,J Series FH Bottom Up Band A,J Series FH Bottom Up Band B,J Series FH Bottom Up Band C,J Series FH Bottom Up Band D,J Series FH Bottom Up Band E,J Series Tensioned Bottom Up Band A,J Series Tensioned Bottom Up Band B,J Series Tensioned Bottom Up Band C,J Series Tensioned Bottom Up Band D,J Series Tensioned Bottom Up Band E,J Series FH Top Down Bottom Up Band A,J Series FH Top Down Bottom Up Band B,J Series FH Top Down Bottom Up Band C,J Series FH Top Down Bottom Up Band D,J Series FH Top Down Bottom Up Band E,J Series Tensioned Top Down Bottom Up Band A\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":28687,\"forchildfieldoptionlinkid\":\"3_28687\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":24522,\"labelname\":\"Rod Chain Drop Size\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":24523,\"labelname\":\"Stack Option\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":24519,\"labelname\":\"Order Type\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":24524,\"labelname\":\"Profile Colour\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":24525,\"labelname\":\"Fixing Type\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":24526,\"labelname\":\"Bottom Weight\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":24664,\"labelname\":\"Operating Chain\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":24527,\"labelname\":\"Installation Height\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":24528,\"labelname\":\"Special Instructions\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]", "oi_description": "Unit Type: cm, Supplier: Perfa, Pricing Band: Louvolite Vertical Price 2025 Group A, Width: 50, Drop: 50, Steering System: Rod, Control Side: Right", "oi_reportdescription": "##Supplier: Perfa##,##Pricing Band: Louvolite Vertical Price 2025 Group A##,##Width: 50 cm##,##Drop: 50 cm##,##Steering System: Rod##,##Control Side: Right##", "oi_reporttitles": "##Supplier:##Pricing Band:##Width:##Drop:##Steering System:##Control Side:", "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": "40.320", "oi_netprice": "40.320", "oi_pricesfromoperations": null, "oi_vatprice": "3.680", "oi_vatvalue": "9.125", "oi_vatselected": 44, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "44.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": 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": "[24531, 24428, 24429, 24515, 24430, 24516, 24517, 24518, 24520, 24521, 24522, 24523, 24519, 24524, 24525, 24526, 24664, 24527, 24528]", "oi_deviceplatform": 1, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "6496", "oi_productiondate": 1742811038, "oi_createdat": 1742811085, "oi_updatedat": null, "oi_createdby": 52, "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": [ { "jp_id": 316, "jp_job_id": 2714, "jp_amount": "44.000", "jp_amountoutstanding": "44.000", "jp_paymentmethod": 14, "jp_paymentcategory": 1, "jp_paymenttype": 8, "jp_surchargetype": 2, "jp_surchargemethod": 2, "jp_surchargeamount": "0.000", "jp_surchargevalue": null, "jp_surchargetotal": "44.000", "jp_userid": 52, "jp_decription": "", "jp_deviceplatform": 1, "jp_status": 0, "jp_transfer": 0, "jp_transfer_id": null, "id": "316", "jp_paiddate": 1742688000, "jp_createdat": 1742811122, "jp_updatedat": 1742811148, "jp_createdby": 52, "jp_updatedby": null } ], "updated": [], "deleted": [] }, "bm_OverPayment": { "created": [], "updated": [], "deleted": [] }, "bm_terms": { "created": [], "updated": [], "deleted": [] }, "bm_jobmultiquote": { "created": [], "updated": [ { "jmq_id": 2732, "jmq_jobid": 2714, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "40.32", "jmq_netprice": "40.32", "jmq_vat": "3.68", "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": "44.00", "jmq_grossprofit": "0.00", "jmq_costprice": "40.32", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "0.00", "jmq_totpaid": "44.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": "9.125", "jmq_cdeliveryvatperc": "9.125", "id": "2732", "jmq_duedate": 1742774400, "jmq_sceduleddate": null, "jmq_createdat": "0.000000", "jmq_updatedat": "1742811148.000000", "jmq_createdby": 52, "jmq_updatedby": 52 } ], "deleted": [] }, "bm_jobstatus_tracks": { "created": [], "updated": [], "deleted": [] }, "bm_customindividuallogs": { "created": [ { "cl_id": 45999, "cl_logname": "default", "cl_type": null, "cl_modulename": "All Jobs", "cl_message": "Product Image Quote report generated by Krish All Jobs", "cl_event": "created", "cl_subjectid": 1384, "cl_subjecttype": "App\\Models\\Reports\\bm_reportactivitylog", "cl_parentid": 2714, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 52, "cl_changedfrom": "null", "cl_changedto": "{\"Category: \":\"Quotation\"}", "cl_customproperties": "{\"attributes\":{\"ral_id\":1384,\"ral_jobid\":2714,\"ral_reportid\":31,\"ral_categoryid\":1,\"ral_description\":\"Product Image Quote report generated by Krish\",\"ral_attachment\":\"\",\"ral_actionid\":1,\"ral_createdat\":\"2025-03-24T10:12:10.000000Z\",\"ral_updatedat\":\"2025-03-24T10:12:10.000000Z\",\"ral_createdby\":52,\"ral_updatedby\":null}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "45999", "cl_createdat": "1742811130.000000", "cl_updatedat": null }, { "cl_id": 46000, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment", "cl_message": "new item has been created in Appointment", "cl_event": "created", "cl_subjectid": 2308, "cl_subjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_parentid": 2714, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 52, "cl_changedfrom": "null", "cl_changedto": "{\"Repeat On\":\"yearly on March 24\",\"app_summary\":\"BD2610-Offline@2\",\"Appointment Type\":\"Measurer\",\"Staff\":\"Pruthvi\",\"Job Ref No\":\"BD2610\",\"Start Date & Time\":\"2025-03-24 09:30:36\",\"End Date & Time\":\"2025-03-24 10:00:36\",\"Uploaded Attachment\":\"[]\",\"Appointment Status\":\"Confirmed\",\"app_jobtimeminute\":\"30\",\"app_deviceplatform\":1}", "cl_customproperties": "{\"attributes\":{\"app_eventid\":2308,\"app_description\":null,\"app_summary\":\"BD2610-Offline@2\",\"app_private\":0,\"app_appointmentType\":62,\"app_userId\":9,\"app_orderId\":2714,\"app_customerId\":0,\"app_isAllDay\":0,\"app_sdate\":\"2025-03-24\",\"app_edate\":\"2025-03-24\",\"app_stime\":\"09:30:36\",\"app_etime\":\"10:00:36\",\"app_sdatetime\":\"2025-03-24 09:30:36\",\"app_edatetime\":\"2025-03-24 10:00:36\",\"app_timezone\":\"Asia\\\/Kolkata\",\"app_latitude\":0,\"app_longitude\":0,\"app_parentappid\":null,\"app_recurrencerule\":null,\"app_userdefinedValue\":\"[]\",\"app_recurrenceexception\":null,\"app_recurrenceexception_date\":null,\"app_attachment\":\"[]\",\"guid\":\"\",\"app_until\":null,\"app_staff\":\"\",\"app_appointtype\":\"\",\"app_confirmed\":0,\"app_coordinates\":\"\",\"app_travelHour\":\"0\",\"app_travelMinute\":\"0\",\"app_onsiteHour\":null,\"app_onsiteMinute\":null,\"app_location\":null,\"app_traveltime\":null,\"app_googleid\":\"0\",\"app_platform\":\"web\",\"app_cal_status\":808,\"app_status\":0,\"app_markasread\":0,\"app_statusInGoogle\":0,\"app_createdBy\":52,\"app_updatedBy\":null,\"app_createdAt\":\"2025-03-24T10:11:46.000000Z\",\"app_updatedAt\":\"2025-03-24T10:11:46.000000Z\",\"app_runid\":null,\"app_deliveryaddressid\":null,\"app_jobtimehour\":\"0\",\"app_jobtimeminute\":\"30\",\"app_products\":null,\"app_deviceplatform\":1}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "46000", "cl_createdat": "1742811148.000000", "cl_updatedat": null }, { "cl_id": 46001, "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 Vertical Blinds", "cl_event": "created", "cl_subjectid": 6496, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 2714, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 52, "cl_changedfrom": "null", "cl_changedto": "{\"Unit Type\":\" cm\",\" Supplier\":\" Perfa\",\" Pricing Band\":\" Louvolite Vertical Price 2025 Group A\",\" Width\":\" 50\",\" Drop\":\" 50\",\" Steering System\":\" Rod\",\" Control Side\":\" Right\"}", "cl_customproperties": "{\"attributes\":{\"oi_id\":6496,\"oi_jobid\":2714,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":2732,\"oi_credit_id\":0,\"oi_productid\":557,\"oi_recipeid\":710,\"oi_ruleid\":0,\"oi_qty\":1,\"oi_seq\":0,\"oi_customseq\":0,\"oi_productcustomseq\":0,\"oi_jsondata\":\"[{\\\"id\\\":24531,\\\"labelname\\\":\\\"Unit Type\\\",\\\"value\\\":1,\\\"valueid\\\":\\\"1\\\",\\\"type\\\":34,\\\"optionid\\\":\\\"1\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":1,\\\"optionname\\\":\\\"cm\\\",\\\"optioncode\\\":\\\"\\\",\\\"optionquantity\\\":1,\\\"unittype\\\":0,\\\"unitcost\\\":0,\\\"pricingtype\\\":0,\\\"fieldoptionlinkid\\\":1,\\\"forchildfieldoptionlinkid\\\":\\\"34_1\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":24428,\\\"labelname\\\":\\\"Quantity\\\",\\\"value\\\":1,\\\"valueid\\\":\\\"\\\",\\\"type\\\":14,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":24429,\\\"labelname\\\":\\\"Supplier\\\",\\\"value\\\":\\\"234\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":17,\\\"optionid\\\":\\\"234\\\",\\\"optionvalue\\\":[{\\\"id\\\":234,\\\"optionid\\\":234,\\\"optionname\\\":\\\"Perfa\\\",\\\"deleted\\\":0,\\\"optionquantity\\\":1}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":24515,\\\"labelname\\\":\\\"Room\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":29,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":24430,\\\"labelname\\\":\\\"Pricing Band\\\",\\\"value\\\":1419,\\\"valueid\\\":\\\"2077\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"1419\\\",\\\"optionvalue\\\":[{\\\"id\\\":2077,\\\"fieldid\\\":24430,\\\"fieldoptionlinkid\\\":2077,\\\"optionid\\\":1419,\\\"mainsupplier\\\":\\\"234\\\",\\\"blindtypecode\\\":\\\"\\\",\\\"optionname\\\":\\\"Louvolite Vertical Price 2025 Group A\\\",\\\"optionquantity\\\":1,\\\"subcount\\\":0,\\\"status\\\":0,\\\"subdatacount\\\":0}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":24516,\\\"labelname\\\":\\\"Blind Size or Recess\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":24517,\\\"labelname\\\":\\\"Width\\\",\\\"value\\\":\\\"50\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":11,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":24518,\\\"labelname\\\":\\\"Drop\\\",\\\"value\\\":\\\"50\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":12,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":24520,\\\"labelname\\\":\\\"Steering System\\\",\\\"value\\\":\\\"Rod\\\",\\\"valueid\\\":\\\"28685\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"5533\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":5533,\\\"optionname\\\":\\\"Rod\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"V-04\\\",\\\"pricegroups\\\":\\\"calnova Manual,calnova Motorised,Zenith Manual,Zenith Motorised,Dickson Manual,Intu C,Intu Pleated C,Intu Roller Band A,Intu Roller Band B,Intu Roller Band C\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":null,\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":28685,\\\"forchildfieldoptionlinkid\\\":\\\"3_28685\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":24521,\\\"labelname\\\":\\\"Control Side\\\",\\\"value\\\":\\\"Right\\\",\\\"valueid\\\":\\\"28687\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"5273\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":5273,\\\"optionname\\\":\\\"Right\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"RT\\\",\\\"pricegroups\\\":\\\"25mm Textured,25mm Premium Metallic,16mm Prime,35mm Prime,50mm Prime,J Series FH Bottom Up Band A,J Series FH Bottom Up Band B,J Series FH Bottom Up Band C,J Series FH Bottom Up Band D,J Series FH Bottom Up Band E,J Series Tensioned Bottom Up Band A,J Series Tensioned Bottom Up Band B,J Series Tensioned Bottom Up Band C,J Series Tensioned Bottom Up Band D,J Series Tensioned Bottom Up Band E,J Series FH Top Down Bottom Up Band A,J Series FH Top Down Bottom Up Band B,J Series FH Top Down Bottom Up Band C,J Series FH Top Down Bottom Up Band D,J Series FH Top Down Bottom Up Band E,J Series Tensioned Top Down Bottom Up Band A\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":null,\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":28687,\\\"forchildfieldoptionlinkid\\\":\\\"3_28687\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":24522,\\\"labelname\\\":\\\"Rod Chain Drop Size\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":24523,\\\"labelname\\\":\\\"Stack Option\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":24519,\\\"labelname\\\":\\\"Order Type\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":24524,\\\"labelname\\\":\\\"Profile Colour\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":24525,\\\"labelname\\\":\\\"Fixing Type\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":24526,\\\"labelname\\\":\\\"Bottom Weight\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":24664,\\\"labelname\\\":\\\"Operating Chain\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":24527,\\\"labelname\\\":\\\"Installation Height\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":24528,\\\"labelname\\\":\\\"Special Instructions\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0}]\",\"oi_description\":\"Unit Type: cm, Supplier: Perfa, Pricing Band: Louvolite Vertical Price 2025 Group A, Width: 50, Drop: 50, Steering System: Rod, Control Side: Right\",\"oi_onlinedescription\":null,\"oi_imagepath\":null,\"oi_reportdescription\":\"##Supplier: Perfa##,##Pricing Band: Louvolite Vertical Price 2025 Group A##,##Width: 50 cm##,##Drop: 50 cm##,##Steering System: Rod##,##Control Side: Right##\",\"oi_onlinereportdescription\":null,\"oi_reporttitles\":\"##Supplier:##Pricing Band:##Width:##Drop:##Steering System:##Control Side:\",\"oi_onlinereporttitles\":null,\"oi_productionformulajsondata\":\"[]\",\"oi_productiondate\":\"2025-03-24 10:10:38\",\"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\":\"40.320\",\"oi_netprice\":\"40.320\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"3.680\",\"oi_vatvalue\":\"9.125\",\"oi_vatselected\":44,\"oi_vattype\":1,\"oi_vatonoff\":1,\"oi_grossprice\":\"44.000\",\"oi_overrideprice\":\"0.000\",\"oi_overridetype\":1,\"oi_overridevalue\":null,\"oi_overridenetprice\":\"0.000\",\"oi_overridevatprice\":\"0.000\",\"oi_overridegrossprice\":\"0.000\",\"oi_ready\":0,\"oi_onhold\":0,\"oi_platformcreatedfrom\":\"web\",\"oi_platformlastupdatedfrom\":\"web\",\"oi_copiedfrom\":0,\"oi_isonlineorder\":0,\"oi_endcustomervatprice\":null,\"oi_endcustomeroverridetype\":1,\"oi_endcustomeroverridevalue\":null,\"oi_endcustomeroverridenetprice\":\"0.000\",\"oi_endcustomeroverridevatprice\":\"0.000\",\"oi_endcustomeroverridegrossprice\":\"0.000\",\"oi_sage_flag\":0,\"oi_status\":0,\"oi_createdby\":52,\"oi_createdat\":\"2025-03-24T10:11:25.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":null,\"oi_jsondataid\":\"[24531, 24428, 24429, 24515, 24430, 24516, 24517, 24518, 24520, 24521, 24522, 24523, 24519, 24524, 24525, 24526, 24664, 24527, 24528]\",\"oi_deviceplatform\":1,\"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": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "46001", "cl_createdat": "1742811148.000000", "cl_updatedat": null }, { "cl_id": 46002, "cl_logname": "model", "cl_type": null, "cl_modulename": "Production Due Date", "cl_message": "Production Due Date has been updated", "cl_event": "modified", "cl_subjectid": 2714, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 2714, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 52, "cl_changedfrom": "{\"Production Due Date\":\"2025-03-23\"}", "cl_changedto": "{\"Production Due Date\":\"2025-03-24\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "46002", "cl_createdat": "1742811148.000000", "cl_updatedat": null }, { "cl_id": 46003, "cl_logname": "default", "cl_type": null, "cl_modulename": "Task", "cl_message": "new item has been created in Task", "cl_event": "created", "cl_subjectid": 306, "cl_subjecttype": "App\\Models\\Task\\bm_tasklist", "cl_parentid": 2714, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 52, "cl_changedfrom": "null", "cl_changedto": "{\"Job Ref No\":\"BD2610\",\"Category\":\"High\",\"Task Date\":\"2025-03-24\",\"Task Time\":\"10:11:50\",\"Created By\":\"Krish\",\"Description\":\"Offline Testing\",\"Repeat Method\":\"daily\",\"tl_deviceplatform\":1}", "cl_customproperties": "{\"attributes\":{\"tl_id\":306,\"tl_orderid\":2714,\"tl_taskcategory\":1,\"tl_taskdate\":\"2025-03-24\",\"tl_tasktime\":\"10:11:50\",\"tl_taskmethod\":\"0\",\"tl_istaskprivate\":0,\"tl_userid\":\"52\",\"tl_priority\":0,\"tl_addjobid\":2714,\"tl_desc\":\"Offline Testing\",\"tl_status\":0,\"tl_markasread\":0,\"tl_taskstatus\":2,\"tl_userdefinedfields\":\"[]\",\"tl_markcompleted\":0,\"tl_jobmode\":\"job\",\"tl_recurrencerule\":null,\"tl_repeatmaindescription\":null,\"tl_repeatmethod\":\"daily\",\"tl_starttask\":null,\"tl_startdata\":null,\"tl_endtask\":null,\"tl_enddata\":null,\"tl_createdat\":\"2025-03-24T10:12:28.000000Z\",\"tl_createdby\":52,\"tl_updatedby\":null,\"tl_updatedat\":\"2025-03-24T10:12:28.000000Z\",\"tl_istaskrepeat\":0,\"tl_deviceplatform\":1,\"tl_subject\":null,\"tl_immediate_notification\":0,\"tl_parent_task_id\":null}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "46003", "cl_createdat": "1742811148.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_appointment": { "151742811106": 2308 }, "bm_orderitem": { "71742811085": 6496 }, "bm_tasklist": { "21742811117": 306 }, "bm_job_paymentlist": { "81742811122": 316 } }, "timestamp": 1742811148 }