---Update Field
Update Vreport_mt_LoadCombo set LComboListIndex=1 where ComboSelect=42 and LoopFieldName='Staff Code'
Update Vreport_mt_LoadCombo set DisplayNo=1 where ComboSelect=42 and LoopFieldName='Staff Code'
Update Vreport_mt_LoadCombo set LComboListIndex=2 where ComboSelect=42 and LoopFieldName='Terminal Code'
Update Vreport_mt_LoadCombo set DisplayNo=2 where ComboSelect=42 and LoopFieldName='Terminal Code'

Delete From Vreport_mt_LoadCombo where ComboSelect=42 and DisplayNo=0
Insert into Vreport_mt_LoadCombo(ComboSelect, ComboIndex, List2Index, BillType, LoopTableName, LoopFieldCode, LoopFieldName, LComboListIndex, DisplayNo, LinkCombo, 
LinkComboIndex, LinkList2Index, DefaultCombo, ShowLabel, ShowCombo, ShowLabelIndex, ShowComboIndex, ShowSqlFormula, SqlFormulaTable,SqlFormulaField, SymbolFormula, ExecuteFormula, DataType, RptFormulas, RptFormulasName, ShowTitleHeader, RunTemp, TempType)
values(42.000000,0.000000,'','','','','-',0,0.000000,'False','','','','True','True','','','False','','','','','',5,'RGroupBy1','True','False','')

---Insert voucher in default list
Delete from Vreport_rpt_DefaultList where ComboSelect=54

Insert into Vreport_rpt_DefaultList(DefaultModule, DefaultNo, DisplayNo, DefaultName, RptFileName, FlexCol, ComboSelect, ReportType, LayoutCode, Label1Caption, Label2Caption, 
Label3Caption, Label4Caption, SeaDefaultOutletTable, SeaDefaultOutletField, DefaultOutletList2Index, ExecuteTrsDate, TempRptFormula1, 
TempTrsDate1, TempRptFormula2, TempTrsDate2, HousekeepingCode, ShowRptTitle2, ShowOutletRpt, TotalTable, WithDateValue1, WithDateValue2,RunTemp, TempType, RefReport, CheckFixCommission)	
values('TRS2',6.000000,6.000000,'Voucher Details','VPOS_T144.RPT',4.000000,54.000000,'VPOS',3,'Issue Status','Filter [Date]','','','','','','True','4','RGroupBy1','5','RGroupBy3','','True','False',4,'True','True','False','','XOXXXXXXXX','False')

---Insert voucher in default field
Delete From Vreport_rpt_DefaultField where DefaultModule='TRS2' and DefaultNo=6

Insert into Vreport_rpt_DefaultField( DefaultModule, DefaultNo, DisplayNo, DisplayName, DefaultName, DataType, RptTableName, SearchTableName, SearchDefaultCode, 
SearchDefaultName, SearchBillCode, FlexiCol, ReportType, DefaultSeaView, BillType1, BillType1Name, RefReport1)
values('TRS2',6.000000,1.000000,'Trs Date','TrsDate','Date','Vpos_eod_Generaldetails','','','','',8.000000,'VPOS','','','','XOXXXXXXXX')

Insert into Vreport_rpt_DefaultField( DefaultModule, DefaultNo, DisplayNo, DisplayName, DefaultName, DataType, RptTableName, SearchTableName, SearchDefaultCode, 
SearchDefaultName, SearchBillCode, FlexiCol, ReportType, DefaultSeaView, BillType1, BillType1Name, RefReport1)
values('TRS2',6.000000,2.000000,'Voucher Group Code','VoucherGroupCode','Text','Vpos_mt_Voucher','Vpos_mt_VoucherGroup','VoucherGroupCode','VoucherGroupName','',8.000000,'VPOS','','','','XOXXXXXXXX')

Insert into Vreport_rpt_DefaultField( DefaultModule, DefaultNo, DisplayNo, DisplayName, DefaultName, DataType, RptTableName, SearchTableName, SearchDefaultCode, 
SearchDefaultName, SearchBillCode, FlexiCol, ReportType, DefaultSeaView, BillType1, BillType1Name, RefReport1)
values('TRS2',6.000000,3.000000,'Payment Code','PaymentCode','Text','Vpos_mt_Voucher','Vstk_mt_Payment','PaymentCode','PaymentName','',8.000000,'VPOS','','','','XOXXXXXXXX')

---insert vreport_mt_loadcombo
Insert into Vreport_mt_LoadCombo(ComboSelect, ComboIndex, List2Index, BillType, LoopTableName, LoopFieldCode, LoopFieldName, LComboListIndex, DisplayNo, LinkCombo, 
LinkComboIndex, LinkList2Index, DefaultCombo, ShowLabel, ShowCombo, ShowLabelIndex, ShowComboIndex, ShowSqlFormula, SqlFormulaTable,SqlFormulaField, SymbolFormula, ExecuteFormula, DataType, RptFormulas, RptFormulasName, ShowTitleHeader, RunTemp, TempType)
values(54.000000,0.000000,'','','','','True',0,0.000000,'False','','','','False','False','3','1','True','Vpos_mt_Voucher','Status','=','True','Text','6','RGroupBy','False','False','')
	
Insert into Vreport_mt_LoadCombo(ComboSelect, ComboIndex, List2Index, BillType, LoopTableName, LoopFieldCode, LoopFieldName, LComboListIndex, DisplayNo, LinkCombo, 
LinkComboIndex, LinkList2Index, DefaultCombo, ShowLabel, ShowCombo, ShowLabelIndex, ShowComboIndex, ShowSqlFormula, SqlFormulaTable,SqlFormulaField, SymbolFormula, ExecuteFormula, DataType, RptFormulas, RptFormulasName, ShowTitleHeader, RunTemp, TempType)
values(54.000000,0.000000,'','','','','False',1,1.000000,'False','','','','True','True','3','1','True','Vpos_mt_Voucher','Status','=','False','Text','6','RGroupBy','False','False','')

Insert into Vreport_mt_LoadCombo(ComboSelect, ComboIndex, List2Index, BillType, LoopTableName, LoopFieldCode, LoopFieldName, LComboListIndex, DisplayNo, LinkCombo, 
LinkComboIndex, LinkList2Index, DefaultCombo, ShowLabel, ShowCombo, ShowLabelIndex, ShowComboIndex, ShowSqlFormula, SqlFormulaTable,SqlFormulaField, SymbolFormula, ExecuteFormula, DataType, RptFormulas, RptFormulasName, ShowTitleHeader, RunTemp, TempType)
values(54.000000,1.000000,'','','','','Expired',0,2.000000,'False','','','','True','True','','','False','','','','','','7','RGroupBy4','False','False','')

Insert into Vreport_mt_LoadCombo(ComboSelect, ComboIndex, List2Index, BillType, LoopTableName, LoopFieldCode, LoopFieldName, LComboListIndex, DisplayNo, LinkCombo, 
LinkComboIndex, LinkList2Index, DefaultCombo, ShowLabel, ShowCombo, ShowLabelIndex, ShowComboIndex, ShowSqlFormula, SqlFormulaTable,SqlFormulaField, SymbolFormula, ExecuteFormula, DataType, RptFormulas, RptFormulasName, ShowTitleHeader, RunTemp, TempType)
values(54.000000,1.000000,'','','','','Not Expired',1,3.000000,'False','','','','True','True','','','False','','','','','','7','RGroupBy4','False','False','')


----Insert member enquiry
Delete from Vreport_rpt_DefaultList where ComboSelect=55

Insert into Vreport_rpt_DefaultList(DefaultModule, DefaultNo, DisplayNo, DefaultName, RptFileName, FlexCol, ComboSelect, ReportType, LayoutCode, Label1Caption, Label2Caption, 
Label3Caption, Label4Caption, SeaDefaultOutletTable, SeaDefaultOutletField, DefaultOutletList2Index, ExecuteTrsDate, TempRptFormula1, 
TempTrsDate1, TempRptFormula2, TempTrsDate2, HousekeepingCode, ShowRptTitle2, ShowOutletRpt, TotalTable, WithDateValue1, WithDateValue2,RunTemp, TempType, RefReport, CheckFixCommission)
values('TRS',33.000000,33.000000,'Member Inquiry Details','VPOS_T145.RPT',4.000000,55.000000,'VPOS',6,'Group By','','','','Vpos_eod_bills','TrsOutlet',3,'False','','','','','','True','True',5,'True','True','False','','OOXXXXXXXX','False')


Delete from Vreport_rpt_DefaultField where DefaultModule='TRS' and DefaultNo=33

Insert into Vreport_rpt_DefaultField(DefaultModule, DefaultNo, DisplayNo, DisplayName, DefaultName, DataType, RptTableName, SearchTableName, SearchDefaultCode, 
SearchDefaultName, SearchBillCode, FlexiCol, ReportType, DefaultSeaView, BillType1, BillType1Name, RefReport1)
values('TRS',33.000000,1.000000,'Trs Date','TrsDate','Date','Vpos_eod_billdetails','','','','',8.000000,'VPOS','','','','OOXXXXXXXX')


Insert into Vreport_rpt_DefaultField(DefaultModule, DefaultNo, DisplayNo, DisplayName, DefaultName, DataType, RptTableName, SearchTableName, SearchDefaultCode, 
SearchDefaultName, SearchBillCode, FlexiCol, ReportType, DefaultSeaView, BillType1, BillType1Name, RefReport1)
values('TRS',33.000000,2.000000,'Bill No','Bill No','Text','Vpos_eod_billdetails','Vpos_eod_bills','BillNo','','BILL1',8.000000,'VPOS','','','','OOXXXXXXXX')


Insert into Vreport_rpt_DefaultField(DefaultModule, DefaultNo, DisplayNo, DisplayName, DefaultName, DataType, RptTableName, SearchTableName, SearchDefaultCode, 
SearchDefaultName, SearchBillCode, FlexiCol, ReportType, DefaultSeaView, BillType1, BillType1Name, RefReport1)
values('TRS',33.000000,3.000000,'Member Code','MemberCode','Text','Vpos_eod_billdetails','Vloy_mt_member','MemberCode','MemberName','',8.000000,'VPOS','','','','OOXXXXXXXX')


Insert into Vreport_rpt_DefaultField(DefaultModule, DefaultNo, DisplayNo, DisplayName, DefaultName, DataType, RptTableName, SearchTableName, SearchDefaultCode, 
SearchDefaultName, SearchBillCode, FlexiCol, ReportType, DefaultSeaView, BillType1, BillType1Name, RefReport1)
values('TRS',33.000000,4.000000,'UOM Code','BasedMeasure','Text','Vpos_eod_billdetails','Vstk_mt_UOM','UOMCode','UOMName','',8.000000,'VPOS','','','','OOXXXXXXXX')

Delete from Vreport_mt_LoadCombo where ComboSelect=55

Insert into Vreport_mt_LoadCombo(ComboSelect, ComboIndex, List2Index, BillType, LoopTableName, LoopFieldCode, LoopFieldName, LComboListIndex, DisplayNo, LinkCombo, 
LinkComboIndex, LinkList2Index, DefaultCombo, ShowLabel, ShowCombo, ShowLabelIndex, ShowComboIndex, ShowSqlFormula, SqlFormulaTable,SqlFormulaField, SymbolFormula, ExecuteFormula, DataType, RptFormulas, RptFormulasName, ShowTitleHeader, RunTemp, TempType)
values(55.000000,0.000000,'','','','','-',0,0.000000,'False','','','','True','True','','','False','','','','','',5,'RGroupBy1','True','False','')

Insert into Vreport_mt_LoadCombo(ComboSelect, ComboIndex, List2Index, BillType, LoopTableName, LoopFieldCode, LoopFieldName, LComboListIndex, DisplayNo, LinkCombo, 
LinkComboIndex, LinkList2Index, DefaultCombo, ShowLabel, ShowCombo, ShowLabelIndex, ShowComboIndex, ShowSqlFormula, SqlFormulaTable,SqlFormulaField, SymbolFormula, ExecuteFormula, DataType, RptFormulas, RptFormulasName, ShowTitleHeader, RunTemp, TempType)
values(55.000000,0.000000,'','','','','Staff Code',1,1.000000,'False','','','','True','True','','','False','','','','','',5,'RGroupBy1','True','False','')

-----Update field		
Update Vreport_rpt_DefaultList set DefaultModule='MAINT-I' where ComboSelect=37
Update Vreport_rpt_DefaultList set DefaultNo=59 where ComboSelect=37
Update Vreport_rpt_DefaultList set DisplayNo=17 where ComboSelect=37

Delete from Vreport_rpt_DefaultField where DefaultModule='TRS5' and DefaultNo=10

Insert into Vreport_rpt_DefaultField(DefaultModule, DefaultNo, DisplayNo, DisplayName, DefaultName, DataType, RptTableName, SearchTableName, SearchDefaultCode, 
SearchDefaultName, SearchBillCode, FlexiCol, ReportType, DefaultSeaView, BillType1, BillType1Name, RefReport1)
values('MAINT-I',59.000000,1.000000,'Item Code','ItemCode','Text','Vstk_mt_BOM','Vstk_mt_Item','ItemCode','ItemName','',8.000000,'VPOS','','','','OOXXXXXXXX')

Insert into Vreport_rpt_DefaultField(DefaultModule, DefaultNo, DisplayNo, DisplayName, DefaultName, DataType, RptTableName, SearchTableName, SearchDefaultCode, 
SearchDefaultName, SearchBillCode, FlexiCol, ReportType, DefaultSeaView, BillType1, BillType1Name, RefReport1)
values('MAINT-I',59.000000,2.000000,'Bom Group Code','BomGroupCode','Text','Vstk_mt_BOM','Vstk_mt_BOMGroup','BomGroupCode','BomGroupName','',8.000000,'VPOS','','','','OOXXXXXXXX')


Insert into Vreport_rpt_DefaultField(DefaultModule, DefaultNo, DisplayNo, DisplayName, DefaultName, DataType, RptTableName, SearchTableName, SearchDefaultCode, 
SearchDefaultName, SearchBillCode, FlexiCol, ReportType, DefaultSeaView, BillType1, BillType1Name, RefReport1)
values('MAINT-I',59.000000,3.000000,'Unit Price','BasedUnitPrice','Numeric','Vstk_mt_Item_1','','','','',8.000000,'VPOS','','','','OOXXXXXXXX')

Insert into Vreport_rpt_DefaultField(DefaultModule, DefaultNo, DisplayNo, DisplayName, DefaultName, DataType, RptTableName, SearchTableName, SearchDefaultCode, 
SearchDefaultName, SearchBillCode, FlexiCol, ReportType, DefaultSeaView, BillType1, BillType1Name, RefReport1)
values('MAINT-I',59.000000,4.000000,'UOM Code','BasedMeasure','Text','Vstk_mt_Item_1','Vstk_mt_UOM','UOMCode','UOMName','',8.000000,'VPOS','','','','OOXXXXXXXX')