---add field
Alter table Vreport_rpt_DefaultList add CheckFixCommission bit
Go

---uPDATE FIELD
Update Vreport_rpt_DefaultList set CheckFixCommission='False'

---Insert staff commission Summary record

Delete from Vreport_rpt_DefaultList where ReportType='VPOS' and DefaultModule='TRS' and DefaultNo=31

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,25.000000,'Agent Commission Summary By Date','VPOS_T143.RPT',4.000000,51.000000,'VPOS',5,'','','','','Vpos_eod_billdetails','TrsOutlet',3,'False','','','','','','True','True',6,'True','True','False','','OOXXXXXXXX','True')

Delete from Vreport_rpt_DefaultField where ReportType='VPOS' and DefaultModule='TRS' and DefaultNo=31

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_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',31.000000,2.000000,'Bill No','BillNo','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',31.000000,3.000000,'Staff Code','StaffCode','Text','Vpos_eod_billdetails','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,'Item Code','ItemCode','Text','Vpos_eod_billdetails','Vstk_mt_Item','ItemCode','ItemName','',8.000000,'VPOS','','','','OOXXXXXXXX')

----Insert agent commission detail

Delete From Vreport_rpt_DefaultList where ReportType='VPOS' and DefaultModule='TRS' and DefaultNo=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',32.000000,26.000000,'Agent Commission Details By Item','VPOS_T142.RPT',4.000000,52.000000,'VPOS',4,'Group By [Class Type]','','','Group By [Class]','Vpos_eod_billdetails','TrsOutlet',3,'False','','','','','','True','True',6,'True','True','False','','OOXXXXXXXX','True')


Delete from Vreport_rpt_DefaultField where ReportType='VPOS' and DefaultModule='TRS' and DefaultNo=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',32.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',32.000000,2.000000,'Bill No','BillNo','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',32.000000,3.000000,'Staff Code','StaffCode','Text','Vpos_eod_billdetails','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,'Item Code','ItemCode','Text','Vpos_eod_billdetails','Vstk_mt_Item','ItemCode','ItemName','',8.000000,'VPOS','','','','OOXXXXXXXX')

Delete from Vreport_mt_LoadCombo where ComboSelect=52
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(52.000000,0.000000,0,'','Vstk_mt_ClassType','ClassTypeCode','ClassTypeName',0,0.000000,'True',3,'','','True','True','','','True','Vstk_mt_ClassType','ClassTypeCode','=','','Numeric',5,'RGroupBy1','True','False','')

Delete from Vreport_mt_ComboClick where ComboSelect=52
Insert into Vreport_mt_ComboClick(ComboSelect, LComboIndex, LList2Index, LLComboListIndex, LLoopTableName, LLoopFieldCode, LLoopFieldName, ComboListIndex, 
LDefaultCombo, DataType1, ShowSqlFormula1, SqlFormulaTable1, SqlFormulaField1, SymbolFormula1, ExecuteFormula1, BillType1)
values(52.000000,3.000000,1,'','Vstk_mt_Class','ClassCode','ClassName',0,'All','Text','True','','','','','')