DELETE FROM vpos_mt_Report where ScriptUpdateYesNo = 0 or ScriptUpdateYesNo is null
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RD001','Cashier Close Report','','Laci Juruwang','2','',0,0,0,0,'OOXXXXXXXXXX','',0,1,1)
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RE001','End of Day','','Proses Akhir Harian','5','',0,0,0,0,'OOXXXXXXXXXX','',0,0,1)
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RL001','Staff Details','','Butir-Butir Pekerja','4','',0,0,0,0,'OOXXXXXXXXXX','',0,0,1)
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RL002','Staff Attendance','','Kedatangan Pekerja','4','',0,0,0,0,'OOXXXXXXXXXX','',0,0,1)
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RS001','Day Sales Summary','','Jumlah Jualan Harian','1','RptS#001',0,0,0,1,'OOXXXXXXXXXX','',0,1,1)
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RS002','Sales By Hour','','Jumlah Jualan Masa','1','',0,0,0,0,'OOXXXXXXXXXX','',0,1,1)
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RS007','Staff Sales','','Jumlah Jualan Barang Pekerja Bagi','1','',0,0,0,0,'OOXXXXXXXXXX','',0,1,1)
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RS008','Top 10 Item By Amount','','Nilai Jualan Barang yang Paling tinggi','1','10',0,0,0,0,'OOXXXXXXXXXX','',0,1,1)
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RS009','Top 10 Staff Sales By Amount','','Nilai Jualan Pekerja yang Paling tinggi','1','10',0,0,0,0,'OOXXXXXXXXXX','',0,1,1)
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RS011','Summary Bills/Check Listing','','Jumlah Bil','1','',0,0,0,0,'OOXXXXXXXXXX','',0,1,1)
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RS012','Summary Payment By Cashier','','Jumlah Kutipan bagi Juruwang','2','',0,0,0,0,'OOXXXXXXXXXX','',0,0,1)
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RS013','Summary Discount By Cashier','','Jumlah Potongan bagi Juruwang','2','',0,0,0,0,'OOXXXXXXXXXX','',0,0,1)
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RS014','Void Item Audit','','Barangan yang telah padam','1','',0,0,0,0,'OOXXXXXXXXXX','',0,1,1)
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RS015','Item Details','','Barang-Barangan','6','',0,0,0,0,'OOXXXXXXXXXX','',0,0,1)
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RS016','Out of Stock Item','','Baranga yang habis stok','6','',0,0,0,0,'OOXXXXXXXXXX','',0,1,1)
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RS017','Summary Sales By Period','','Jumlah Jualan Masa','1','',0,0,1,0,'OOXXXXXXXXXX','',0,0,1)
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RS018','Tour Agency''s Commission','','Jumlah Komison Bagi Tour Agency','1','',0,0,0,0,'OOXXXXXXXXXX','',0,0,1)
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RS019','Summary Payment By Cashier R2','Summary Payment By Cashier R2','Summary Payment By Cashier R2','2','',0,0,1,0,'OOXXXXXXXXXX','',0,0,1)
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RS020','Scat Report','Scat Report','Scat Report','1','',0,0,1,0,'OOXXXXXXXXXX','',0,0,1)
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RS021','Summary Deposit By Cashier','','KUTIPAN DEPOSIT UNTUK JURUWANG','2','',0,0,0,0,'OOXXXXXXXXXX','',0,0,1)
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RS022','Item Details','','Jumlah Jualan Butir (%) Bagi ','1','',0,0,0,0,'OOXXXXXXXXXX','OXXXXXXXXX',1,1,1)
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RS023','Item Details (Avr)','','Jumlah Jualan Barangan (%) Bagi ','1','',0,0,0,1,'OOXXXXXXXXXX','XXXXXXXXXX',1,1,1)
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RS024','Item Summary','','Jumlah Jualan Butir (%) Bagi ','1','',0,0,0,0,'OOXXXXXXXXXX','XXXXXXXXXX',1,1,1)
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RS025','Item Summary (Avr)','','Jumlah Jualan Barangan (%) Bagi ','1','',0,0,0,0,'OOXXXXXXXXXX','XXXXXXXXXX',1,1,1)
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RS026','Top 10 Item By Quantity','','Nilai Jualan Barang yang Paling tinggi','1','10',0,0,0,0,'OOXXXXXXXXXX','',0,1,1)
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RS027','Day Sales - Terminal','','Jumlah Jualan Harian','1','RptS#001',0,0,0,0,'OOXXXXXXXXXX','',0,0,1)
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RS028','Day Sales - Shift','','Jumlah Jualan Harian','1','RptS#001',0,0,0,0,'OOXXXXXXXXXX','',0,0,1)
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RS029','Foc & Zero Item','','Barangan bernilai kosong','1','',0,0,0,0,'OOXXXXXXXXXX','',0,1,1)
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RV001','Ingredient Usage','','Barang-Barang recipeTerpakai','3','',9,0,1,0,'XOXXXXXXXXXX','',0,0,1)
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RV002','Ingredient Balance','','Jumlah Barang-Barang recipe','3','',9,0,1,0,'XOXXXXXXXXXX','',0,0,1)
INSERT INTO Vpos_mt_Report (RptCode,RptName,RptName1,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo) VALUES('RV003','Stock Balance','','Stok Terkini ','3','',9,0,1,0,'OOXXXXXXXXXX','',0,0,1)