----Update Field (payment Type-1) Update Vreport_rpt_DefaultList set HousekeepingCode='' where ReportType='VPOS' and DefaultModule='TRS2' and DefaultNo=4 ----Insert staff sales details (vpos) Delete from Vreport_rpt_DefaultList where ReportType='VPOS' and DefaultModule='TRS' and DefaultNo=8 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) values('TRS',8.000000,10.000000,'Staff Sales Details','VPOS_T130.RPT',4.000000,16.000000,'VPOS',3,'Group By [Class Type]','Group By [Class]','','','Vstk_trs_bills','TrsOutlet',3,'False','','','','','','True','True',5,'True','True','False','','OOXXXXXXXX') ----defaultfield Delete From Vreport_rpt_DefaultField where ReportType='VPOS' and DefaultModule='TRS' and DefaultNo=8 Insert Into Vreport_rpt_DefaultField(DefaultModule, DefaultNo, DisplayNo, DisplayName, DefaultName, DataType, RptTableName, SearchTableName, SearchDefaultCode, SearchDefaultName, SearchBillCode, FlexiCol, ReportType, DefaultSeaView, BillType1, BillType1Name, RefReport1) values('TRS',8.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',8.000000,2.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',8.000000,3.000000,'Item Code','ItemCode','Text','Vpos_eod_billdetails','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('TRS',8.000000,4.000000,'UOM Code','BasedMeasure','Text','Vpos_eod_billdetails','Vstk_mt_UOM','UOMCode','UOMName','',8.000000,'VPOS','','','','OOXXXXXXXX') ----LOADCOMBO Delete from Vreport_mt_LoadCombo where ComboSelect=16 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(16.000000,0.000000,0,'','Vstk_mt_ClassType','ClassTypeCode','ClassTypeName',0,0.000000,'True',1,'','All','True','True','','','True','Vstk_mt_ClassType','ClassTypeCode','=','','Numeric',5,'RGroupBy1','True','False','') ---comboclick Delete from Vreport_mt_ComboClick where ComboSelect=16 Insert into Vreport_mt_ComboClick( ComboSelect, LComboIndex, LList2Index, LLComboListIndex, LLoopTableName, LLoopFieldCode, LLoopFieldName, ComboListIndex, LDefaultCombo, DataType1, ShowSqlFormula1, SqlFormulaTable1, SqlFormulaField1, SymbolFormula1, ExecuteFormula1, BillType1) values(16.000000,1.000000,1,'','Vstk_mt_Class','ClassCode','ClassName',0,'All','Text','True','','','','','') ---Insert Physical count Delete from Vreport_rpt_DefaultList WHERE ReportType='VPOS' and DefaultModule='TRS5' and DefaultNo=25 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) values('TRS5',25.000000,25.000000,'Physical Count','VPOS_T126.RPT',4.000000,17.000000,'VPOS',3,'Group By [Class Type]', 'Group By [Class]','','','Vstk_trs_PhysicalCount','TrsOutlet',3,'False','','','','','','True','True',5,'True','True','False','','OOXXXXXXXX') ---DefaultField Delete from Vreport_rpt_DefaultField where ReportType='VPOS' and DefaultModule='TRS5' and DefaultNo=25 Insert Into Vreport_rpt_DefaultField(DefaultModule, DefaultNo, DisplayNo, DisplayName, DefaultName, DataType, RptTableName, SearchTableName, SearchDefaultCode, SearchDefaultName, SearchBillCode, FlexiCol, ReportType, DefaultSeaView, BillType1, BillType1Name, RefReport1) values('TRS5',25.000000,1.000000,'Item Code','ItemCode','Text','Vstk_trs_PhysicalCount','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('TRS5',25.000000,2.000000,'Creditor Code','DefCreditorCode','Text','Vstk_mt_Item','Vacc_mt_Creditor','CreditorCode','CreditorName','',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('TRS5',25.000000,3.000000,'UOM Code','BasedMeasure','Text','Vstk_mt_Item','Vstk_mt_UOM','UOMCode','UOMName','',8.000000,'VPOS','','','','OOXXXXXXXX') ---LOADCOMBO Delete from Vreport_mt_LoadCombo where ComboSelect=17 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(17.000000,0.000000,0,'','Vstk_mt_ClassType','ClassTypeCode','ClassTypeName',0,0.000000,'True',1,'','All','True','True','','','True','Vstk_mt_ClassType','ClassTypeCode','=','','Numeric',5,'RGroupBy4','True','False','') ----comboclick Delete from Vreport_mt_ComboClick where ComboSelect=17 Insert into Vreport_mt_ComboClick(ComboSelect, LComboIndex, LList2Index, LLComboListIndex, LLoopTableName, LLoopFieldCode, LLoopFieldName, ComboListIndex, LDefaultCombo, DataType1, ShowSqlFormula1, SqlFormulaTable1, SqlFormulaField1, SymbolFormula1, ExecuteFormula1, BillType1) values(17.000000,1.000000,1,'','Vstk_mt_Class','ClassCode','ClassName',0,'All','Text','True','','','','','') ---Insert (void item summary) Delete from Vreport_rpt_DefaultList where ReportType='VPOS' and DefaultModule='TRS6' and DefaultNo=4 Update Vreport_rpt_DefaultList set DisplayNo=2 where ReportType='VPOS' and DefaultModule='TRS6' and DefaultNo=1 Update Vreport_rpt_DefaultList set DisplayNo=3 where ReportType='VPOS' and DefaultModule='TRS6' and DefaultNo=2 Update Vreport_rpt_DefaultList set DisplayNo=4 where ReportType='VPOS' and DefaultModule='TRS6' and DefaultNo=3 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) values('TRS6',4.000000,1.000000,'Void Item Summary','VPOS_T127.RPT',4.000000,20.000000,'VPOS',5,'','','','','Vstk_trs_bills','TrsOutlet',3,'False','','','','','','True','True',3,'True','True','False','','OOXXXXXXXX') ---DefaultField Delete from Vreport_rpt_DefaultField where ReportType='VPOS' and DefaultModule='TRS6' and DefaultNo=4 Insert Into Vreport_rpt_DefaultField(DefaultModule, DefaultNo, DisplayNo, DisplayName, DefaultName, DataType, RptTableName, SearchTableName, SearchDefaultCode, SearchDefaultName, SearchBillCode, FlexiCol, ReportType, DefaultSeaView, BillType1, BillType1Name, RefReport1) values('TRS6',4.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('TRS6',4.000000,2.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('TRS6',4.000000,3.000000,'Item Code','ItemCode','Text','Vpos_eod_billdetails','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('TRS6',4.000000,4.000000,'UOM Code','BasedMeasure','Text','Vpos_eod_billdetails','Vstk_mt_UOM','UOMCode','UOMName','',8.000000,'VPOS','','','','OOXXXXXXXX') ----Insert (Top Purchase) Delete from Vreport_rpt_DefaultList where ReportType='VPOS' and DefaultModule='TRS1' and DefaultNo=5 Update Vreport_rpt_DefaultList set DisplayNo=3 where ReportType='VPOS' and DefaultModule='TRS1' and DefaultNo=2 Update Vreport_rpt_DefaultList set DisplayNo=4 where ReportType='VPOS' and DefaultModule='TRS1' and DefaultNo=3 Update Vreport_rpt_DefaultList set DisplayNo=5 where ReportType='VPOS' and DefaultModule='TRS1' and DefaultNo=4 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) values('TRS1',5.000000,2.000000,'Top Item Purchase By Amount','VPOS_T129.RPT',4.000000,31.000000,'VPOS',6,'Bill Type','','','','Vstk_trs_bills','TrsOutlet',3,'False','','','','','','True','True',5,'True','True','False','','OOXXXXXXXX') ---defaultfield Delete from Vreport_rpt_DefaultField where ReportType='VPOS' and DefaultModule='TRS1' and DefaultNo=5 Insert Into Vreport_rpt_DefaultField(DefaultModule, DefaultNo, DisplayNo, DisplayName, DefaultName, DataType, RptTableName, SearchTableName, SearchDefaultCode, SearchDefaultName, SearchBillCode, FlexiCol, ReportType, DefaultSeaView, BillType1, BillType1Name, RefReport1) values('TRS1',5.000000,1.000000,'Item Code','ItemCode','Text','Vstk_trs_billdetails','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('TRS1',5.000000,2.000000,'UOM Code','UnitMeasure','Text','Vstk_trs_billdetails','Vstk_mt_UOM','UOMCode','UOMName','',8.000000,'VPOS','','','','OOXXXXXXXX') ---LoadCombo Delete from Vreport_mt_LoadCombo where ComboSelect=31 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(31.000000,0.000000,'','','','','All',0,0.000000,'False','','','','True','True','','','True','Vstk_trs_bills','BillType','In', '["PUR","GRN"]','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(31.000000,0.000000,'','','','','Purchase Received Note',1,1.000000,'False','','','','True','True','','','True','Vstk_trs_bills','BillType','=', '"PUR"','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(31.000000,0.000000,'','','','','Goods Received Note',2,2.000000,'False','','','','True','True','','','True','Vstk_trs_bills','BillType','=', '"GRN"','Text','','','False','False','') ----Insert (Chart by payment type) Delete from Vreport_rpt_DefaultList where ReportType='VPOS' and DefaultModule='TRS3' 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) values('TRS3',12.000000,12.000000,'Payment Type By Amount','VPOS_T128.RPT',4.000000,32.000000,'VPOS',5,'','','','','Vpos_eod_generaldetails','TrsOutlet',3,'False','','','','','','True','True',1,'True','True','False','','OOXXXXXXXX') ---Defaultfield Delete from Vreport_rpt_DefaultField where ReportType='VPOS' and DefaultModule='TRS3' 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('TRS3',12.000000,1.000000,'Trs Date','TrsDate','Date','Vpos_eod_generaldetails','','','','',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('TRS3',12.000000,2.000000,'Staff Code','StaffCode','Text','Vpos_eod_generaldetails','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('TRS3',12.000000,3.000000,'Payment Code','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('TRS3',12.000000,4.000000,'Terminal Code','TerminalCode','Text','Vpos_eod_generaldetails','Vpos_mt_Terminal','TerminalCode','TerminalName','',8.000000,'VPOS','','','','OOXXXXXXXX') ---Update reporttype='vstk' Update Vreport_rpt_DefaultList set DefaultModule='TRS5' where ReportType='VSTK' Update Vreport_rpt_DefaultList set RefReport='OOXXXXXXXX' where ReportType='VSTK' Update Vreport_rpt_DefaultList set DefaultNo=26 where ReportType='VSTK' and ComboSelect=72 Update Vreport_rpt_DefaultList set DisplayNo=26 where ReportType='VSTK' and ComboSelect=72 Update Vreport_rpt_DefaultList set DefaultNo=27 where ReportType='VSTK' and ComboSelect=73 Update Vreport_rpt_DefaultList set DisplayNo=27 where ReportType='VSTK' and ComboSelect=73 Update Vreport_rpt_DefaultList set DefaultNo=28 where ReportType='VSTK' and ComboSelect=62 Update Vreport_rpt_DefaultList set DisplayNo=28 where ReportType='VSTK' and ComboSelect=62 Update Vreport_rpt_DefaultList set DefaultNo=29 where ReportType='VSTK' and ComboSelect=53 Update Vreport_rpt_DefaultList set DisplayNo=29 where ReportType='VSTK' and ComboSelect=53 Update Vreport_rpt_DefaultList set DefaultNo=30 where ReportType='VSTK' and ComboSelect=60 Update Vreport_rpt_DefaultList set DisplayNo=30 where ReportType='VSTK' and ComboSelect=60 Update Vreport_rpt_DefaultList set DefaultNo=31 where ReportType='VSTK' and ComboSelect=59 AND RptFileName='VSTK_T016.RPT' Update Vreport_rpt_DefaultList set DisplayNo=31 where ReportType='VSTK' and ComboSelect=59 AND RptFileName='VSTK_T016.RPT' Update Vreport_rpt_DefaultList set DefaultNo=32 where ReportType='VSTK' and ComboSelect=59 AND RptFileName='VSTK_T017.RPT' Update Vreport_rpt_DefaultList set DisplayNo=32 where ReportType='VSTK' and ComboSelect=59 AND RptFileName='VSTK_T017.RPT' Update Vreport_rpt_DefaultList set DefaultNo=33 where ReportType='VSTK' and ComboSelect=61 Update Vreport_rpt_DefaultList set DisplayNo=33 where ReportType='VSTK' and ComboSelect=61 ---DefaultField Delete from Vreport_rpt_DefaultField where ReportType='VSTK' and DefaultNo=25 Update Vreport_rpt_DefaultField set RefReport1='OOXXXXXXXX' where ReportType='VSTK' Update Vreport_rpt_DefaultField set DefaultModule='TRS5' where ReportType='VSTK' Update Vreport_rpt_DefaultField set DefaultNo='26' where ReportType='VSTK' and DefaultNo=2 Update Vreport_rpt_DefaultField set DefaultNo='27' where ReportType='VSTK' and DefaultNo=3 Update Vreport_rpt_DefaultField set DefaultNo='28' where ReportType='VSTK' and DefaultNo=4 Update Vreport_rpt_DefaultField set DefaultNo='29' where ReportType='VSTK' and DefaultNo=8 Update Vreport_rpt_DefaultField set DefaultNo='30' where ReportType='VSTK' and DefaultNo=16 Update Vreport_rpt_DefaultField set DefaultNo='31' where ReportType='VSTK' and DefaultNo=17 Update Vreport_rpt_DefaultField set DefaultNo='32' where ReportType='VSTK' and DefaultNo=18 Update Vreport_rpt_DefaultField set DefaultNo='33' where ReportType='VSTK' and DefaultNo=19 ---Update Acc top analysis Update Vreport_rpt_DefaultList set DefaultModule='TRS1' where ReportType='VSTK' and comboselect=56 Update Vreport_rpt_DefaultList set DefaultNo=6 where ReportType='VSTK' and comboselect=56 Update Vreport_rpt_DefaultList set DisplayNo=6 where ReportType='VSTK' and comboselect=56 ---defaultfield Update Vreport_rpt_DefaultField set DefaultModule='TRS1' where ReportType='VSTK' And DefaultNo=12 Update Vreport_rpt_DefaultField set DefaultNo=6 where ReportType='VSTK' And DefaultNo=12