---Insert record
---Defaultlist

Delete From Vreport_rpt_DefaultList where DefaultModule='TRS9' and DefaultNo=12

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',12.000000,12.000000,'Inquiry By Serial No','VPOS_T163.RPT',4.000000,105.000000,'VPOS',6,'Status','','','','Vstk_trs_bills','TrsOutlet',3,'False','','','','','','True','True',10,'True','True','False','','OOXXXXXXXX','False')

---Defaultfield
Delete From Vreport_rpt_DefaultField where DefaultModule='TRS9' and DefaultNo=12

Insert into Vreport_rpt_DefaultField(DefaultModule, DefaultNo, DisplayNo, DisplayName, DefaultName, DataType, RptTableName, SearchTableName, SearchDefaultCode,SearchDefaultName, SearchBillCode, FlexiCol, ReportType, DefaultSeaView, BillType1, BillType1Name, RefReport1)
values('TRS9',12.000000,1.000000,'Item Code','ItemCode','Text','Vrma_trs_Master','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('TRS9',12.000000,2.000000,'Class Type Code','ClassTypeCode','Numeric','Vstk_mt_ClassType','','','','',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('TRS9',12.000000,3.000000,'Class Code','ClassCode','Text','Vstk_mt_Class','Vstk_mt_Class','ClassCode','ClassName','',8.000000,'VPOS','','','','OOXXXXXXXX')

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

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(105.000000,0.000000,'','','','','False',0,0.000000,'False','','','','True','True','','','True','Vrma_trs_Master','Status','=','False','Text','','','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(105.000000,0.000000,'','','','','True',1,1.000000,'False','','','','True','True','','','True','Vrma_trs_Master','Status','=','True','Text','','','False','False','')


---Update inquiry details
Update Vreport_rpt_DefaultList set TotalTable=10 where DefaultModule='TRS9' and DefaultNo=6


---Insert record
Delete From Vreport_mt_LoadCombo Where ComboSelect=61 and DisplayNo between 6 and 7

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(61.000000,0.000000,'','','','','Item Group',2,6.000000,'False','','','','True','True','','','False','','','','','',5,'RGroupBy','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(61.000000,0.000000,'','','','','Location',3,7.000000,'False','','','','True','True','','','False','','','','','',5,'RGroupBy','True','False','')