---Insert record
Delete from Vreport_rpt_DefaultList where DefaultModule='TRS' and DefaultNo between 31 and 32

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',31.000000,30.000000,'Bill Summary- Format 2','VPOS_T137-A.RPT',4.000000,117.000000,'VPOS',3,'Group By','Void [Status]','','','Vstk_trs_bills','TrsOutlet',3,'False','','','','','','True','True',10,'True','True','False','','OOXXXXXXXX','False')

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',32.000000,31.000000,'Bill Details- Format 2','VPOS_T138-A.RPT',4.000000,118.000000,'VPOS',3,'Group By','Void [Status]','','','Vstk_trs_bills','TrsOutlet',3,'False','','','','','','True','True',10,'True','True','False','','OOXXXXXXXX','False')

---defaultfield
Delete from Vreport_rpt_DefaultField where DefaultModule='TRS' and DefaultNo between 31 and 32

Insert into Vreport_rpt_DefaultField(DefaultModule, DefaultNo, DisplayNo, DisplayName, DefaultName, DataType, RptTableName, SearchTableName, SearchDefaultCode,SearchDefaultName, SearchBillCode, FlexiCol, ReportType, DefaultSeaView, BillType1, BillType1Name, RefReport1)
values('TRS',31.000000,1.000000,'Trs Date','TrsDate','Date','Vpos_eod_bills','','','','',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',31.000000,2.000000,'Bill No','BillNo','Text','Vpos_eod_bills','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',31.000000,3.000000,'Staff Code','StaffCode','Text','Vpos_eod_bills','Vpay_mt_Staff','StaffCode','StaffName','',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',31.000000,4.000000,'Terminal No','TerminalNo','Text','Vpos_eod_bills','Vpos_mt_terminal','TerminalCode','TerminalName','',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',31.000000,5.000000,'Payment Type','GeneralCode','Text','Vpos_eod_generaldetails','Vstk_mt_Payment','PaymentCode','PaymentName','',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',31.000000,6.000000,'Member Code','MemberCode','Text','Vpos_eod_bills','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',32.000000,1.000000,'Trs Date','TrsDate','Date','Vpos_eod_bills','','','','',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',32.000000,2.000000,'Bill No','BillNo','Text','Vpos_eod_bills','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',32.000000,3.000000,'Staff Code','StaffCode','Text','Vpos_eod_bills','Vpay_mt_Staff','StaffCode','StaffName','',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',32.000000,4.000000,'Terminal No','TerminalNo','Text','Vpos_eod_bills','Vpos_mt_terminal','TerminalCode','TerminalName','',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',32.000000,5.000000,'Member Code','MemberCode','Text','Vpos_eod_bills','Vloy_mt_member','MemberCode','MemberName','',8.000000,'VPOS','','','','OOXXXXXXXX')


----Update Field
Update Vreport_rpt_DefaultList set DefaultName='Agent Commission Summary By Date [Front End]'
where DefaultModule='TRS9' and DefaultNo=3

Update Vreport_rpt_DefaultList set DefaultName='Agent Commission Details By Item [Front End]'
where DefaultModule='TRS9' and DefaultNo=4