---Update Field
Update Vreport_rpt_DefaultField set DefaultSeaView='' where DefaultModule='TRS9' and DefaultNo=9 and DisplayNo=3

---Add record
---defaultlist
Delete from Vreport_rpt_DefaultList where DefaultModule='TRS9' and DefaultNo=10

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('TRS9',10.000000,10.000000,'Lot No [Expired Date]','VPOS_T161.RPT',4.000000,97.000000,'VPOS',4,'Status [Date]','','','In Days','Vstk_trs_bills','TrsOutlet',3,'True',5,'RGroupBy1',6,'RGroupBy3','','True','True',5,'True','True','False','','OXXXXXXXXX','False')

----defaultfield
Delete from Vreport_rpt_DefaultField where DefaultModule='TRS9' 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('TRS9',10.000000,1.000000,'Date','TrsDate','Date','Vstk_trs_bills','','','','',8.000000,'VPOS','','','','OXXXXXXXXX')

Insert into Vreport_rpt_DefaultField(DefaultModule, DefaultNo, DisplayNo, DisplayName, DefaultName, DataType, RptTableName, SearchTableName, SearchDefaultCode,SearchDefaultName, SearchBillCode, FlexiCol, ReportType, DefaultSeaView, BillType1, BillType1Name, RefReport1)
values('TRS9',10.000000,2.000000,'Class Type Code','ClassTypeCode','Numeric','Vstk_mt_ClassType','Vstk_mt_ClassType','ClassTypeCode','ClassTypeName','',8.000000,'VPOS','','','','OXXXXXXXXX')

Insert into Vreport_rpt_DefaultField(DefaultModule, DefaultNo, DisplayNo, DisplayName, DefaultName, DataType, RptTableName, SearchTableName, SearchDefaultCode,SearchDefaultName, SearchBillCode, FlexiCol, ReportType, DefaultSeaView, BillType1, BillType1Name, RefReport1)
values('TRS9',10.000000,3.000000,'Class Code','ClassCode','Text','Vstk_mt_Class','Vstk_mt_Class','ClassCode','ClassName','',8.000000,'VPOS','','','','OXXXXXXXXX')


Insert into Vreport_rpt_DefaultField(DefaultModule, DefaultNo, DisplayNo, DisplayName, DefaultName, DataType, RptTableName, SearchTableName, SearchDefaultCode,SearchDefaultName, SearchBillCode, FlexiCol, ReportType, DefaultSeaView, BillType1, BillType1Name, RefReport1)
values('TRS9',10.000000,4.000000,'Item Code','ItemCode','Text','Vstk_trs_billdetails','Vstk_mt_Item','ItemCode','ItemName','',8.000000,'VPOS','','','','OXXXXXXXXX')

---load combo
Delete from Vreport_mt_LoadCombo where ComboSelect=97

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(97.000000,0.000000,'','','','','Expired',0,0.000000,'False','','','','True','True','','','False','','','','','',7,'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(97.000000,0.000000,'','','','','Not Expired',1,1.000000,'False','','','','True','True','','','False','','','','','',7,'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(97.000000,3.000000,'','','','','0-30',0,2.000000,'False','','','','True','True','','','False','','','','','',8,'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(97.000000,3.000000,'','','','','31-60',1,3.000000,'False','','','','True','True','','','False','','','','','',8,'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(97.000000,3.000000,'','','','','61-90',2,4.000000,'False','','','','True','True','','','False','','','','','',8,'RGroupBy4','False','False','')	
		


---Add keep until record
---defaultlist
Delete from Vreport_rpt_DefaultList where DefaultModule='TRS9' and DefaultNo=11

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('TRS9',11.000000,11.000000,'Lot No [Keep Until Date]','VPOS_T162.RPT',4.000000,97.000000,'VPOS',4,'Status [Date]','','','In Days','Vstk_trs_bills','TrsOutlet',3,'True',5,'RGroupBy1',6,'RGroupBy3','','True','True',5,'True','True','False','','OXXXXXXXXX','False')

----defaultfield
Delete from Vreport_rpt_DefaultField where DefaultModule='TRS9' and DefaultNo=11

Insert into Vreport_rpt_DefaultField(DefaultModule, DefaultNo, DisplayNo, DisplayName, DefaultName, DataType, RptTableName, SearchTableName, SearchDefaultCode,SearchDefaultName, SearchBillCode, FlexiCol, ReportType, DefaultSeaView, BillType1, BillType1Name, RefReport1)
values('TRS9',11.000000,1.000000,'Date','TrsDate','Date','Vstk_trs_bills','','','','',8.000000,'VPOS','','','','OXXXXXXXXX')

Insert into Vreport_rpt_DefaultField(DefaultModule, DefaultNo, DisplayNo, DisplayName, DefaultName, DataType, RptTableName, SearchTableName, SearchDefaultCode,SearchDefaultName, SearchBillCode, FlexiCol, ReportType, DefaultSeaView, BillType1, BillType1Name, RefReport1)
values('TRS9',11.000000,2.000000,'Class Type Code','ClassTypeCode','Numeric','Vstk_mt_ClassType','Vstk_mt_ClassType','ClassTypeCode','ClassTypeName','',8.000000,'VPOS','','','','OXXXXXXXXX')

Insert into Vreport_rpt_DefaultField(DefaultModule, DefaultNo, DisplayNo, DisplayName, DefaultName, DataType, RptTableName, SearchTableName, SearchDefaultCode,SearchDefaultName, SearchBillCode, FlexiCol, ReportType, DefaultSeaView, BillType1, BillType1Name, RefReport1)
values('TRS9',11.000000,3.000000,'Class Code','ClassCode','Text','Vstk_mt_Class','Vstk_mt_Class','ClassCode','ClassName','',8.000000,'VPOS','','','','OXXXXXXXXX')


Insert into Vreport_rpt_DefaultField(DefaultModule, DefaultNo, DisplayNo, DisplayName, DefaultName, DataType, RptTableName, SearchTableName, SearchDefaultCode,SearchDefaultName, SearchBillCode, FlexiCol, ReportType, DefaultSeaView, BillType1, BillType1Name, RefReport1)
values('TRS9',11.000000,4.000000,'Item Code','ItemCode','Text','Vstk_trs_billdetails','Vstk_mt_Item','ItemCode','ItemName','',8.000000,'VPOS','','','','OXXXXXXXXX')