Update Vreport_mt_LoadCombo set LinkComboIndex=1 where comboselect=88
Update Vreport_rpt_DefaultList set TotalTable=1 where ReportType='VPOS' and DefaultModule='TRS3' and DefaultNo between 8 and 10
Update Vreport_rpt_DefaultList set TotalTable=5 where ReportType='VPOS' and DefaultModule='TRS5' and DefaultNo=4
Update Vreport_rpt_DefaultList set TotalTable=7 where ReportType='VPOS' and DefaultModule='TRS5' and DefaultNo=5
Update Vreport_rpt_DefaultList set TotalTable=5 where ReportType='VPOS' and DefaultModule='TRS5' and DefaultNo=6
Update Vreport_rpt_DefaultList set TotalTable=7 where ReportType='VPOS' and DefaultModule='TRS5' and DefaultNo=7
Update Vreport_rpt_DefaultList set TotalTable=5 where ReportType='VPOS' and DefaultModule='TRS5' and DefaultNo=13
Update Vreport_rpt_DefaultList set TotalTable=7 where ReportType='VPOS' and DefaultModule='TRS5' and DefaultNo=14


Delete Vreport_rpt_DefaultField where ReportType='VPOS' AND DefaultModule='TRS1' AND DefaultNo=2

Insert Into Vreport_rpt_DefaultField(DefaultModule, DefaultNo, DisplayNo, DisplayName, DefaultName, DataType, RptTableName, SearchTableName, SearchDefaultCode, 
SearchDefaultName, SearchBillCode, FlexiCol, ReportType, DefaultSeaView)
values('TRS1',2,1,'Trs Date','TrsDate','Date','Vstk_trs_bills','','','','',8.000000,'VPOS','')

Insert Into Vreport_rpt_DefaultField(DefaultModule, DefaultNo, DisplayNo, DisplayName, DefaultName, DataType, RptTableName, SearchTableName, SearchDefaultCode, 
SearchDefaultName, SearchBillCode, FlexiCol, ReportType, DefaultSeaView)
values('TRS1',2,2,'Item Code','ItemCode','Text','Vstk_trs_billdetails','Vstk_mt_item','ItemCode','ItemName','',	8.000000,'VPOS','')

	
Insert Into Vreport_rpt_DefaultField(DefaultModule, DefaultNo, DisplayNo, DisplayName, DefaultName, DataType, RptTableName, SearchTableName, SearchDefaultCode, 
SearchDefaultName, SearchBillCode, FlexiCol, ReportType, DefaultSeaView)
values('TRS1',2,3,'Unit Price','UnitPrice','Numeric','Vstk_trs_billdetails','','','','',8.000000,'VPOS','')

Insert Into Vreport_rpt_DefaultField(DefaultModule, DefaultNo, DisplayNo, DisplayName, DefaultName, DataType, RptTableName, SearchTableName, SearchDefaultCode, 
SearchDefaultName, SearchBillCode, FlexiCol, ReportType, DefaultSeaView)
values('TRS1',2,4,'Bill No','BillNo','Text','Vstk_trs_bills','Vstk_trs_billls','BillNo','','BILL2',8.000000,'VPOS','')

Update Vreport_mt_LoadCombo set ExecuteFormula='"X"' where Comboselect=10 and comboindex=1 and LComboListIndex=0
Update Vreport_mt_LoadCombo set ExecuteFormula='"X"' where Comboselect=10 and comboindex=0 and LComboListIndex=0
Update Vreport_mt_LoadCombo set ExecuteFormula='"D"' where Comboselect=10 and comboindex=0 and LComboListIndex=1
Update Vreport_mt_LoadCombo set ExecuteFormula='"X"' where Comboselect=10 and comboindex=2 and LComboListIndex=1
Update Vreport_mt_LoadCombo set ExecuteFormula='"P"' where Comboselect=10 and comboindex=2 and LComboListIndex=2
Update Vreport_mt_LoadCombo set ExecuteFormula='"I"' where Comboselect=10 and comboindex=2 and LComboListIndex=3
Update Vreport_mt_LoadCombo set ExecuteFormula=' ["X","P","I","S"]' where Comboselect=10 and comboindex=2 and LComboListIndex=0

Update Vreport_rpt_DefaultList set TotalTable=2 where ReportType='VPOS' and DefaultModule='TRS3' and DefaultNo=9