DELETE FROM STA_GOODS_GROUP; DELETE FROM STA_GOODS; DELETE FROm STA_GOODS_TYPE; DELETE FROM CM_PRICE_BANK DECLARE @l_CONTRACT_VPP_ID VARCHAR(20) = 'TRC000000265960' --- ID của TRC Văn phòng phẩm DECLARE @l_CONTRACT_MI_ID VARCHAR(20) = 'TRC000000265960' --- ID của TRC Mực in CREATE TABLE #STA_GOODS_GROUP ( STA_GOODS_GROUP_NAME NVARCHAR(100) NOT NULL ) INSERT INTO #STA_GOODS_GROUP (STA_GOODS_GROUP_NAME) VALUES (N'Giấy mực in'), (N'Văn phòng phẩm'), (N'Vật tư kho quỹ'), (N'Vật liệu khác'), (N'Nhu yếu phẩm khác'); -- Khai báo biến DECLARE @GROUP_NAME NVARCHAR(100) -- Khai báo cursor DECLARE group_cursor CURSOR FOR SELECT STA_GOODS_GROUP_NAME FROM #STA_GOODS_GROUP -- Mở cursor OPEN group_cursor -- Lấy dòng đầu tiên FETCH NEXT FROM group_cursor INTO @GROUP_NAME -- Vòng lặp duyệt từng dòng WHILE @@FETCH_STATUS = 0 BEGIN -- Xử lý tại đây DECLARE @l_STA_GOODS_GROUP_ID VARCHAR(15), @P_STA_GOODS_GROUP_CODE VARCHAR(15) EXEC SYS_CodeMasters_Gen 'STA_GOODS_GROUP', @l_STA_GOODS_GROUP_ID out -- Tạo mã nhóm hàng hóa EXEC STA_GOODS_GROUP_NO_Gen @P_STA_GOODS_GROUP_CODE OUT; INSERT INTO [dbo].[STA_GOODS_GROUP] ([STA_GOODS_GROUP_ID] ,[STA_GOODS_GROUP_CODE] ,[STA_GOODS_GROUP_NAME] ,[NOTES] ,[RECORD_STATUS] ,[AUTH_STATUS] ,[MAKER_ID] ,[CREATE_DT] ,[CHECKER_ID] ,[APPROVE_DT] ,[BRANCH_ID] ,[DEP_ID]) VALUES ( @l_STA_GOODS_GROUP_ID, @P_STA_GOODS_GROUP_CODE, @GROUP_NAME, '', '1', 'A', 'admin', CONVERT(DATETIME, GETDATE(), 103), NULL, NULL, NULL, NULL ) -- Lấy dòng tiếp theo FETCH NEXT FROM group_cursor INTO @GROUP_NAME END -- Đóng và giải phóng cursor CLOSE group_cursor DEALLOCATE group_cursor CREATE TABLE #CM_PRICE_BANK ( STT VARCHAR(15) NULL, PRICE_BANK_NAME NVARCHAR(MAX) NULL, DVT NVARCHAR(15) NULL, REFERENCE_PRICE DECIMAL(18, 2) NULL, PRICE_STT_PARENT VARCHAR(15) NULL, NOTES NVARCHAR(MAX) NULL, VAT DECIMAL(18,2) NULL ) INSERT INTO #CM_PRICE_BANK (STT, PRICE_BANK_NAME) VALUES (N'I', N'GIẤY IN'); INSERT INTO #CM_PRICE_BANK (STT, PRICE_BANK_NAME) VALUES (N'II', N'VĂN PHÒNG PHẨM'); INSERT INTO #CM_PRICE_BANK (STT, PRICE_BANK_NAME) VALUES (N'III', N'VẬT TƯ KHO QUỸ'); INSERT INTO #CM_PRICE_BANK (STT, PRICE_BANK_NAME) VALUES (N'IV', N'VẬT LIỆU KHÁC'); INSERT INTO #CM_PRICE_BANK (STT, PRICE_BANK_NAME) VALUES (N'V', N'NHU YẾU PHẨM'); INSERT INTO #CM_PRICE_BANK (STT, PRICE_BANK_NAME) VALUES (N'VI', N'Mực in mua mới'); INSERT INTO #CM_PRICE_BANK (STT, PRICE_BANK_NAME) VALUES (N'VII', N'Nạp mực'); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'1', N'Giấy A1 100 gsm', N'Tờ', 2250, N'I',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'2', N'Giấy A1 80 gsm', N'Tờ', 2200, N'I',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'3', N'Giấy Excel A3 80 gsm', N'Ream', 118000, N'I',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'4', N'Giấy Excel A4 70 gsm', N'Ream', 54000, N'I',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'5', N'Giấy Excel A4 80 gsm', N'Ream', 62000, N'I',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'6', N'Giấy Excel A5 80 gsm', N'Ream', 31500, N'I',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'7', N'Giấy Fort màu A4 82 gsm', N'Ream', 77000, N'I',N'Hồng',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'8', N'Giấy Fort màu A4 82 gsm', N'Ream', 77000, N'I',N'Vàng',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'9', N'Giấy Fort màu A4 82 gsm', N'Ream', 77000, N'I',N'Xanh lá',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'10', N'Giấy Fort màu A4 82 gsm', N'Ream', 77000, N'I',N'Xanh dương',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'11', N'Giấy Fort màu A4 82 gsm', N'Ream', 77000, N'I',N'Cam',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'12', N'Giấy Fort màu A5 82 gsm', N'Ream', 38500, N'I',N'Hồng',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'13', N'Giấy Fort màu A5 82 gsm', N'Ream', 38500, N'I',N'Vàng',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'14', N'Giấy Fort màu A5 82 gsm', N'Ream', 38500, N'I',N'Xanh lá',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'15', N'Giấy Fort màu A5 82 gsm', N'Ream', 38500, N'I',N'Xanh dương',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'16', N'Giấy Fort màu A5 82 gsm', N'Ream', 38500, N'I',N'Cam',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'17', N'Giấy Natural A4 70 gsm', N'Ream', 65000, N'I',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'18', N'Giấy Natural A4 80 gsm', N'Ream', 75000, N'I',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'19', N'Giấy Natural A5 70 gsm', N'Ream', 33000, N'I',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'20', N'Giấy Paper One A4 70 gsm', N'Ream', 72000, N'I',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'21', N'Giấy Paper One A4 80 gsm', N'Ream', 82000, N'I',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'22', N'Giấy Paper One A5 70 gsm', N'Ream', 37000, N'I',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'23', N'Accord nhựa Ageless', N'Hộp', 13500, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'24', N'Accord nhựa UNC', N'Hộp', 14000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'25', N'Bấm kim Eagle No.3 - 207', N'Cái', 35000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'26', N'Bấm kim Plus No.10 (chính hãng)', N'Cái', 27000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'27', N'Bấm kim W.Trio 50-SA', N'Cái', 135500, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'28', N'Bấm lỗ Eagle 837', N'Cái', 35000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'29', N'Bấm lỗ Kw.Trio 978', N'Cái', 58000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'30', N'Băng keo trong văn phòng 1.8P', N'Cuộn', 2300, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'31', N'Bao tập Thiên Long có hình', N'Cái', 2000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'32', N'Bút bi Thiên Long TL-027', N'Cây', 3500, N'II',N'Đen',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'33', N'Bút bi Thiên Long TL-027', N'Cây', 3500, N'II',N'Đỏ',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'34', N'Bút bi Thiên Long TL-027', N'Cây', 3500, N'II',N'Xanh',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'35', N'Bút bi Thiên Long TL-031', N'Cây', 7900, N'II',N'Xanh',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'36', N'Bút bi Thiên Long TL-08', N'Cây', 3500, N'II',N'Xanh',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'37', N'Bút chì 2B Gstar', N'Cây', 2000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'38', N'Bút chì bấm Pentel AX.105 (có tem)', N'Cây', 7500, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'39', N'Bút chì bấm Pentel AX.125T (có tem)', N'Cây', 7500, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'40', N'Bút chì chuốt Steadtler 134 Germany', N'Cây', 3800, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'41', N'Bút dạ quang TOYO', N'Cây', 5300, N'II',N'Vàng',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'42', N'Bút dạ quang TOYO', N'Cây', 5300, N'II',N'Xanh lá',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'43', N'Bút dạ quang TOYO', N'Cây', 5300, N'II',N'Hồng',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'44', N'Bút dạ quang TOYO', N'Cây', 5300, N'II',N'Cam',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'45', N'Bút dạ quang Thiên Long HL-03', N'Cây', 6500, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'46', N'Bút lông bảng Thiên Long WB-03', N'Cây', 6500, N'II',N'Đen',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'47', N'Bút lông bảng Thiên Long WB-03', N'Cây', 6500, N'II',N'Đỏ',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'48', N'Bút lông bảng Thiên Long WB-03', N'Cây', 6500, N'II',N'Xanh',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'49', N'Bút lông dầu Pilot', N'Cây', 4500, N'II',N'Đen',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'50', N'Bút lông dầu Pilot', N'Cây', 4500, N'II',N'Đỏ',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'51', N'Bút lông dầu Pilot', N'Cây', 4500, N'II',N'Xanh',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'52', N'Bút lông dầu Thiên Long PM-04', N'Cây', 8000, N'II',N'Đen',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'53', N'Bút lông dầu Thiên Long PM-04', N'Cây', 8000, N'II',N'Đỏ',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'54', N'Bút lông dầu Thiên Long PM-04', N'Cây', 8000, N'II',N'Xanh',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'55', N'Bút lông dầu Thiên Long PM-09', N'Cây', 8300, N'II',N'Đen',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'56', N'Bút lông dầu Thiên Long PM-09', N'Cây', 8300, N'II',N'Đỏ',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'57', N'Bút lông dầu Thiên Long PM-09', N'Cây', 8300, N'II',N'Xanh',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'58', N'Bút lông dầu Zebra Mo.120', N'Cây', 2500, N'II',N'Xanh',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'59', N'Bút lông màu Thiên Long FP-01 (12 màu)', N'Vỉ', 20000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'60', N'Bút mực nước M&G', N'Cây', 13500, N'II',N'Xanh',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'61', N'Bút Thiên Long GEL-011', N'Cây', 5900, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'62', N'Bút Thiên Long GEL-B01 Master', N'Cây', 6000, N'II',N'Xanh',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'63', N'Bút Uniball UB 150 (chính hãng)', N'Cây', 32000, N'II',N'Xanh',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'64', N'Bút Uniball UB 150 (chính hãng)', N'Cây', 32000, N'II',N'Đỏ',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'65', N'Bút Uniball UB 150 (có tem)', N'Cây', 8800, N'II',N'Xanh',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'66', N'Bút Uniball UB 150 (có tem)', N'Cây', 8800, N'II',N'Đỏ',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'67', N'Bút xóa nước Thiên Long CP-02', N'Cây', 19000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'68', N'Chổi quét vi tính màu loại tốt', N'Cây', 28000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'69', N'Chuốt chì SDI', N'Cái', 5000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'70', N'Cọ quét sơn dẹp (5cm)', N'Cây', 8500, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'71', N'Dao rọc giấy SDI lớn 0423', N'Cây', 13000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'72', N'Dao rọc giấy SDI nhỏ 0404', N'Cây', 9500, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'73', N'Dây đeo dù móc xoay lớn', N'Cái', 1850, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'74', N'Dây đeo thẻ nút inox chuỗi si móc xoay XD', N'Sợi', 3000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'75', N'Giấy decal đế xanh', N'Xấp', 63000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'76', N'Giấy decal TOMY', N'Xấp', 13000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'77', N'Giấy decal TOMY hộp', N'Hộp', 130000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'78', N'Giấy note 4 màu dạ quang', N'Xấp', 9500, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'79', N'Giấy note 5 màu film Neon', N'Xấp', 10000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'80', N'Giấy note 5 màu giấy Pronoti', N'Xấp', 10000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'81', N'Giấy note Pronoti 1.5 * 2', N'Xấp', 4200, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'82', N'Giấy note Pronoti 3 * 2', N'Xấp', 5500, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'83', N'Giấy note Pronoti 3 * 3', N'Xấp', 8000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'84', N'Giấy note Pronoti 3 * 4', N'Xấp', 9000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'85', N'Giấy note Pronoti 3 * 5', N'Xấp', 11000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'86', N'Giấy note trình ký PLEASE SIGN', N'Xấp', 22000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'87', N'Giấy note trình ký SIGN HERE', N'Xấp', 37000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'88', N'Giấy note UNC vàng 3 * 2', N'Xấp', 4000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'89', N'Giấy note UNC vàng 3 * 3', N'Xấp', 5800, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'90', N'Giấy note UNC vàng 3 * 4', N'Xấp', 7500, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'91', N'Giấy note UNC vàng 3 * 5', N'Xấp', 8000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'92', N'Giấy than G-Star A4 - Loại 1', N'Xấp', 55000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'93', N'Gỡ kim Trio 508B', N'Cái', 8000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'94', N'Gôm Pelikan BR80', N'Cục', 5000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'95', N'Gôm Pentel H.03', N'Cục', 2800, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'96', N'Gôm Pentel H.05', N'Cục', 3500, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'97', N'Gôm Steadtler 526-BT40', N'Cục', 5000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'98', N'Hồ dán nước Bến Nghé GL-202', N'Chai', 6300, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'99', N'Hồ dán WinQ', N'Chai', 3000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'100', N'Hồ khô Thiên Long G-011/DO', N'Chai', 7000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'101', N'Hồ nước Queen', N'Chai', 5000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'102', N'Hồ nước Quốc Toàn', N'Chai', 2500, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'103', N'Hồ nước Thiên Long G-08', N'Chai', 3000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'104', N'Hộp cắm bút No.168', N'Cái', 33000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'105', N'Hộp cắm bút No.170', N'Cái', 39000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'106', N'Kéo hoa hồng', N'Cây', 13000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'107', N'Kéo trung S.180', N'Cây', 11000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'108', N'Kéo văn phòng nhỏ S.120', N'Cây', 10000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'109', N'Kéo VP S100', N'Cây', 18000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'110', N'Kẹp bướm Slecho 15 mm', N'Hộp', 4800, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'111', N'Kẹp bướm Slecho 19 mm', N'Hộp', 5100, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'112', N'Kẹp bướm Slecho 25 mm', N'Hộp', 8000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'113', N'Kẹp bướm Slecho 32 mm', N'Hộp', 11000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'114', N'Kẹp bướm Slecho 41 mm', N'Hộp', 17000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'115', N'Kẹp bướm Slecho 51 mm', N'Hộp', 24500, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'116', N'Kẹp giấy C.62 "A"', N'Hộp', 3000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'117', N'Kim bấm 23/6 Việt Đức', N'Hộp', 5900, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'118', N'Kim bấm Kw.Trio 23/10', N'Hộp', 12000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'119', N'Kim bấm Kw.Trio 23/13', N'Hộp', 13000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'120', N'Kim bấm Kw.Trio 23/15', N'Hộp', 19000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'121', N'Kim bấm Kw.Trio 23/20', N'Hộp', 20000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'122', N'Kim bấm Kw.Trio 23/8', N'Hộp', 10800, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'123', N'Kim bấm Plus No.10', N'Hộp', 3200, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'124', N'Kim bấm W.Trio No.3 (chính hãng)', N'Hộp', 6200, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'125', N'Kim may bao 16cm', N'Cái', 8000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'126', N'Lưỡi dao rọc giấy SDI lớn 1404', N'Vỉ', 1000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'127', N'Lưỡi dao rọc giấy SDI nhỏ 1403', N'Vỉ', 7000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'128', N'Móc dán tường 3 cái', N'Vỉ', 19000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'129', N'Móc dán tường đôi', N'Vỉ', 19000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'130', N'Móc dán tường đơn', N'Vỉ', 18000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'131', N'Mực dấu Horse (có tem)', N'Chai', 12000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'132', N'Rổ xéo nhựa 3 ngăn', N'Cái', 27500, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'133', N'Ruột chì MonAmi', N'Hộp', 12500, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'134', N'Ruột xóa kéo Plus lớn', N'Cây', 16500, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'135', N'Thẻ tên dẻo đứng', N'Cái', 5000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'136', N'Thẻ tên dẻo ngang', N'Cái', 5000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'137', N'Thước cứng KN 30 cm', N'Cây', 4700, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'138', N'Thước cứng KN 50 cm', N'Cây', 12000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'139', N'Thước dẻo Win 20 cm', N'Cây', 3000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'140', N'Thước dẻo Win 30 cm', N'Cây', 4500, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'141', N'Thước Thiên Long 30 cm SR-03', N'', 5500, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'142', N'Xóa kéo Plus 105T lớn', N'Cây', 18500, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'143', N'Xóa kéo Plus mini', N'Cây', 13000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'144', N'Băng keo 2 mặt 1.2P', N'Cuộn', 2000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'145', N'Băng keo 2 mặt 2.5P', N'Cuộn', 4000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'146', N'Băng keo 2 mặt 5P', N'Cuộn', 7000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'147', N'Băng keo điện Nano 10Y', N'Cuộn', 5500, N'II',N'Đen',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'148', N'Băng keo giấy 2.5P', N'Cuộn', 6000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'149', N'Băng keo giấy 5P', N'Cuộn', 9000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'150', N'Băng keo si 3.5P', N'Cuộn', 7300, N'II',N'Đỏ',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'151', N'Băng keo si 3.5P', N'Cuộn', 7300, N'II',N'Vàng',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'152', N'Băng keo si 3.5P', N'Cuộn', 7300, N'II',N'Xanh Dương',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'153', N'Băng keo si 3.5P', N'Cuộn', 7300, N'II',N'Xanh Lá',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'154', N'Băng keo si 5P', N'Cuộn', 9200, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'155', N'Băng keo trong 1.2P vòng lớn 80 yard', N'Cuộn', 4500, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'156', N'Băng keo trong 2.5P vòng lớn 80 yard', N'Cuộn', 7000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'157', N'Băng keo trong 5P - 100 yard', N'Cuộn', 13000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'158', N'Băng keo vàng đục 5P - 100 yard', N'Cuộn', 14000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'159', N'Băng keo xốp 2.5P', N'Cuộn', 9000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'160', N'Bao thư 12 * 22 có keo (không có logo BVBank)', N'Xấp', 22000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'161', N'Bao thư bưu điện tốt (không có logo BVBank)', N'Xấp', 8000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'162', N'Bao thư vàng A4 100 gsm (không có logo BVBank)', N'Xấp', 68000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'163', N'Bao thư vàng A5 (không có logo BVBank)', N'Xấp', 39000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'164', N'Bìa 1 kẹp A4 - nhựa trong', N'Cái', 23000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'165', N'Bìa 2 kẹp A4 - nhựa trong', N'Cái', 25000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'166', N'Bìa 3 dây 10P (hàng thường)', N'Cái', 7500, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'167', N'Bìa accord nhựa Thiên Long', N'Cái', 6300, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'168', N'Bìa cây trong cao cấp Q324', N'Cái', 4200, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'169', N'Bìa cây trong, dày, gáy lớn Q310A', N'Cái', 2700, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'170', N'Bìa còng ABBA 3.5P 2 mặt si', N'Cái', 20000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'171', N'Bìa còng ABBA 5P 2 mặt si (loại 1)', N'Cái', 34000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'172', N'Bìa còng ABBA 7P 2 mặt si (loại 1)', N'Cái', 34000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'173', N'Bìa còng PLUS 5P A4/F4', N'Cái', 42000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'174', N'Bìa còng PLUS 7P A4/F4', N'Cái', 42000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'175', N'Bìa còng PLUS 9P A4/F4', N'Cái', 57000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'176', N'Bìa còng SUMO 10P', N'Cái', 54000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'177', N'Bìa CS-A289', N'Cái', 19000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'178', N'Bìa CS-E340', N'Cái', 4000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'179', N'Bìa F4 quấn dây', N'Cái', 4800, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'180', N'Bìa hộp si 10P', N'Cái', 28000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'181', N'Bìa hộp si 20P', N'Cái', 40000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'182', N'Bìa hộp si 7P', N'Cái', 25000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'183', N'Bìa kiếng A4 1.2', N'Xấp', 55000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'184', N'Bìa kiếng A4 1.5', N'Xấp', 60000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'185', N'Bìa lá Plus A4', N'Cái', 2000, N'II',N'dày 0,15 mm',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'186', N'Bìa lá Plus F4', N'Cái', 2100, N'II',N'dày 0,15 mm',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'187', N'Bìa lỗ 4 lạng', N'Xấp', 35000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'188', N'Bìa lỗ 5.0 lạng', N'Xấp', 47000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'189', N'Bìa lỗ Thiên Long A4 không viền FO-CS02', N'Xấp', 56000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'190', N'Bìa màu Mỹ A3 (100 tờ/xấp)', N'Xấp', 190000, N'II',N'HỒNG',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'191', N'Bìa màu Mỹ A3 (100 tờ/xấp)', N'Xấp', 190000, N'II',N'VÀNG',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'192', N'Bìa màu Mỹ A3 (100 tờ/xấp)', N'Xấp', 190000, N'II',N'TÍM',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'193', N'Bìa màu Mỹ A3 (100 tờ/xấp)', N'Xấp', 190000, N'II',N'XANH',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'194', N'Bìa màu Mỹ A3 (100 tờ/xấp)', N'Xấp', 190000, N'II',N'ĐỎ',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'195', N'Bìa màu Mỹ A3 (100 tờ/xấp)', N'Xấp', 190000, N'II',N'CAM',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'196', N'Bìa màu Mỹ A4 (100 tờ/xấp)', N'Xấp', 95000, N'II',N'HỒNG',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'197', N'Bìa màu Mỹ A4 (100 tờ/xấp)', N'Xấp', 95000, N'II',N'VÀNG',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'198', N'Bìa màu Mỹ A4 (100 tờ/xấp)', N'Xấp', 95000, N'II',N'TÍM',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'199', N'Bìa màu Mỹ A4 (100 tờ/xấp)', N'Xấp', 95000, N'II',N'XANH',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'200', N'Bìa màu Mỹ A4 (100 tờ/xấp)', N'Xấp', 95000, N'II',N'ĐỎ',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'201', N'Bìa màu Mỹ A4 (100 tờ/xấp)', N'Xấp', 95000, N'II',N'CAM',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'202', N'Bìa nhựa Thiên Long 60 lá (loại 1)', N'Quyển', 53000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'203', N'Bìa nhựa Thiên Long 80 lá (loại 1)', N'Quyển', 67000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'204', N'Bìa nút A4 My Clear', N'Cái', 3100, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'205', N'Bìa nút A5 (không in)', N'Cái', 2000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'206', N'Bìa nút F4 My Clear', N'Cái', 3200, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'207', N'Bìa phân trang giấy 12 số', N'Xấp', 9000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'208', N'Bìa phân trang nhựa 12 số', N'Xấp', 9000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'209', N'Bìa phân trang nhựa 24 số', N'Xấp', 18000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'210', N'Bìa phân trang nhựa 31 số', N'Xấp', 25000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'211', N'Bìa Thái Lan A3 160 gsm', N'Xấp', 64000, N'II',N'Xanh',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'212', N'Bìa Thái Lan A4 160 gsm', N'Xấp', 32000, N'II',N'Hồng',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'213', N'Bìa xi măng', N'Xấp', 200000, N'II',N'100 cái/ xấp',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'214', N'CK10 - (21 * 30cm) dày', N'Quyển', 39000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'215', N'Đồ cắt keo No.2001', N'Cái', 14000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'216', N'Đồ cắt keo No.2004', N'Cái', 40000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'217', N'Đồ lau bảng BP-02', N'Cái', 12000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'218', N'Gáy lò xo nhựa 14mm', N'Hộp', 135000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'219', N'Gáy lò xo nhựa 20mm', N'Hộp', 164000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'220', N'Gáy lò xo nhựa 32mm', N'Hộp', 200000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'221', N'Gáy lò xo nhựa 8mm', N'Hộp', 90000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'222', N'Giấy niêm phong (perluya)', N'Xấp', 15500, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'223', N'Kệ 2 tầng mica No.169.2', N'Cái', 105000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'224', N'Kệ 3 tầng mica No.169.3', N'Cái', 140000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'225', N'Khẩu trang y tế', N'Hộp', 35000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'226', N'Khung menu A4 Xukiva 191', N'Cái', 65000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'227', N'Mực dấu Shiny S.62/S.63', N'Chai', 35000, N'II',N'đỏ/xanh',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'228', N'Nước lau bảng Ziper', N'Chai', 38000, N'II',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'229', N'Pin 2A Energizer', N'Cặp', 17000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'230', N'Pin 2A Maxell', N'Cặp', 6000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'231', N'Pin 3A Energizer', N'Cặp', 17000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'232', N'Pin 3A Maxell', N'Cặp', 6000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'233', N'Pin vuông 9V Energizer', N'Viên', 53000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'234', N'Pin vuông 9V Panasonic', N'Viên', 15000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'235', N'Sổ caro 25 * 33 dày (216 trang)', N'Quyển', 42000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'236', N'Sổ caro 30 * 40 dày (200 trang)', N'Quyển', 52000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'237', N'Sổ lò xo A4 -dày 100', N'Quyển', 35000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'238', N'Sổ lò xo A5 -dày 100', N'Quyển', 23000, N'II',N'200 trang',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'239', N'Sổ lò xo B5 - dày 100', N'Quyển', 24700, N'II',N'200 trang',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'240', N'Sổ name card 160', N'Quyển', 30000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'241', N'Sổ name card 320', N'Quyển', 42000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'242', N'Tập CAMPUS 200 trang khổ lớn kẻ ngang', N'Quyển', 22000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'243', N'Tập DANA BOOK 100 trang (loại tốt)', N'Quyển', 6000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'244', N'Tập DANA BOOK 200 trang (loại tốt)', N'Quyển', 12500, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'245', N'Tập Tiến Phát 100 trang ĐL 100 gsm', N'Quyển', 8500, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'246', N'Tập Tiến Phát 200 trang', N'Quyển', 12500, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'247', N'Trình ký đôi simili trơn A4', N'Cái', 12000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'248', N'Trình ký đơn simili trơn A4', N'Cái', 11000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'249', N'Dây thun xuất khẩu 333', N'Bịch', 38000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'250', N'Dây thun con ó', N'Bịch', 57000, N'II',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'251', N'Dây đóng chứng từ', N'Cuộn', 270000, N'III',N'Cuộn 3 kg',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'252', N'Bao vải đựng tiền', N'Cái', 23000, N'III',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'253', N'Dây chỉ cột tiền', N'Kg', 85000, N'III',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'254', N'Dây thun xuất khẩu 333', N'Bịch', 38000, N'III',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'255', N'Dây thun con ó', N'Bịch', 57000, N'III',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'256', N'Giấy bó tiền bằng máy', N'Cuộn', 34000, N'III',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'257', N'Giấy bó tiền bằng tay', N'Xấp', 39000, N'III',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'258', N'Giấy lót tiền', N'Bộ', 210, N'III',N'50',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'259', N'Giấy lót tiền', N'Bộ', 210, N'III',N'100',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'260', N'Giấy lót tiền', N'Bộ', 210, N'III',N'200',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'261', N'Giấy lót tiền', N'Bộ', 210, N'III',N'500',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'262', N'Sáp đếm tiền', N'Hộp', 4000, N'III',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'263', N'Sổ ra vào kho', N'Quyển', 35000, N'III',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'264', N'Dấu Shiny PET-300/309 (Mini Dater)', N'Con', 110000, N'IV',N'Dấu ngày tháng',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'265', N'Dấu Shiny PET-400/409/414', N'Con', 145000, N'IV',N'Dấu ngày tháng',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'266', N'Dấu Shiny S-852', N'Con', 60000, N'IV',N'1 dòng',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'267', N'Dấu Shiny S-853', N'Con', 90000, N'IV',N'2 dòng',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'268', N'Dấu Shiny S-854', N'Con', 120000, N'IV',N'3 dòng',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'269', N'Đầu chia line điện thoại (1 vào - 2 ra)', N'Cái', 17000, N'IV',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'270', N'Dây nylon loại 1kg', N'Cuộn', 38000, N'IV',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'271', N'Đĩa CD lốc 50', N'Cái', 5000, N'IV',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'272', N'Điện thoại Panasonic (chính hãng)', N'Cái', 340000, N'IV',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'273', N'Máy tính Casio AX-120B (chính hãng)', N'Cái', 319000, N'IV',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'274', N'Máy tính Casio GX-16B (chính hãng)', N'Cái', 440000, N'IV',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'275', N'Máy tính Casio HL-122TV (chính hãng)', N'Cái', 282000, N'IV',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'276', N'Máy tính Casio JS-120L (thường)', N'Cái', 85000, N'IV',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'277', N'Máy tính Casio JS-40V (thường)', N'Cái', 120000, N'IV',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'278', N'Máy tính Casio MJ-120D Plus (chính hãng)', N'Cái', 282000, N'IV',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'279', N'Máy tính Casio MJ-120T (chính hãng)', N'Cái', 282000, N'IV',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'280', N'Mũi khoan máy đóng chứng từ DS', N'Cái', 20000, N'IV',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'281', N'Băng keo dán tiền 3M', N'Cuộn', 46000, N'IV',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'282', N'Bàn chải nhựa có tay cầm bàn ủi', N'Cái', 14000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'283', N'Bao rác 3 cuộn (loại tốt)', N'Kg', 35000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'284', N'Bao tải xác rắn 60x90/95 cm dày ĐL 90', N'Cái', 5500, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'285', N'Bao tải xác rắn 60x95 cm dày ĐL 130', N'Cái', 5500, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'286', N'Bao tay nylon Diệu Thương FY', N'Hộp', 25000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'287', N'Bao tay xốp Hộp Hưng Thông', N'Hộp', 35000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'288', N'Bịch rác Diệu Thương FY 43*56', N'Cuộn', 34000, N'V',N'Đỏ',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'289', N'Bịch rác Diệu Thương FY 53*63', N'Cuộn', 34000, N'V',N'Xanh',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'290', N'Bịch rác Diệu Thương FY 63*72', N'Cuộn', 34000, N'V',N'Vàng',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'291', N'Bịch rác Diệu Thương FY 65*80', N'Cuộn', 34000, N'V',N'Cam',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'292', N'Bình tưới cây Đức Đạt SR01A - 1 lít', N'Cái', 55000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'293', N'Bình tưới cây Đức Đạt SR021A - 2 lít', N'Cái', 63000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'294', N'Bình xịt bóng sơn con rùa Turtle Wax 473', N'Chai', 195000, N'V',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'295', N'Bình xịt tưới cây 0.5 lít', N'Cái', 42000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'296', N'Bộ lau nhà 360 độ HM', N'Bộ', 270000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'297', N'Bộ lau nhà Mega 360 độ (thường)', N'Bộ', 270000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'298', N'Bộ rổ thau nhựa 320', N'Bộ', 55000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'299', N'Bột banking soda', N'Hộp', 45000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'300', N'Bột giặt Surf 550 g', N'Bịch', 28000, N'V',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'301', N'Ca nhựa đựng nước có nắp (2 lít)', N'Cái', 26000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'302', N'Cây gắp đá inox', N'Cái', 29000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'303', N'Cây lau CN Home Inno Cotton xoắn-Loop 40cm', N'Cây', 130000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'304', N'Cây lau kiếng', N'Cây', 125000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'305', N'Cây lau mạng nhện 3 chức năng HM', N'Cây', 135000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'306', N'Cây lau nhà bằng mút Trần Thức 30cm', N'Cây', 90000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'307', N'Cây lau nhà Dân Hưng', N'Cây', 85000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'308', N'Cây lau nhà kẹp cán mũ Đại Phát 2T4', N'Cây', 110000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'309', N'Cây lau nhà kẹp cán inox Đại Phát 2T4', N'Cây', 120000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'310', N'Cây lau nhà kẹp Innox Home Inno Hi2008', N'Cây', 135000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'311', N'Cây lau nhà Mega 360 độ', N'Cây', 117000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'312', N'Cây lau nhà Mỹ Phong loại C', N'Cây', 87000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'313', N'Cây lau nhà Mỹ Phong xoắn', N'Cây', 95000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'314', N'Cây lau nhà Trần Thức', N'Cây', 3000, N'V',N'Xanh dương',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'315', N'Cây lau nhà Trần Thức tròn', N'Cây', 83000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'316', N'Cây lau nhà Trần Thức vuông', N'Cây', 83000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'317', N'Chai xịt muỗi Raid 600ml', N'Chai', 63000, N'V',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'318', N'Chai xịt muỗi ARS', N'Chai', 68000, N'V',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'319', N'Chai xịt phòng Ami Lavender 280ml', N'Chai', 45000, N'V',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'320', N'Chổi cỏ cán cỏ', N'Cây', 26000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'321', N'Chổi cỏ cán nhựa', N'Cây', 26000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'322', N'Chổi lông gà lớn', N'Cây', 25000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'323', N'Chổi lông gà nhỏ', N'Cây', 15000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'324', N'Chổi lông gà trống', N'Cây', 45000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'325', N'Chổi quét nhà nhựa các màu', N'Cây', 33000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'326', N'Chổi tàu cau lớn', N'Cây', 28000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'327', N'Dầu bôi bảo dưỡng cao su Moly No.1538 500ml', N'Bình', 180000, N'V',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'328', N'Dầu bóng xe car polish Shine 1L', N'Chai', 160000, N'V',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'329', N'Găng tay cao su Tulip', N'Đôi', 28000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'330', N'Găng tay cao su cầu vồng', N'Đôi', 27000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'331', N'Găng tay cao su Hàn Quốc', N'Đôi', 21000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'332', N'Găng tay cao su Nam Long size M', N'Đôi', 40000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'333', N'Giấy cuộn Pulppy', N'Cuộn', 8800, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'334', N'Giẻ cây lau nhà công nghiệp', N'Miếng', 65000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'335', N'Giẻ cây lau nhà HI-2008', N'Miếng', 35000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'336', N'Keo dán chuột', N'Miếng', 10000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'337', N'Khăn giấy An An 330x330mm (100 tờ/bịch)', N'Bịch', 10700, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'338', N'Khăn giấy lau tay K24 VT01424', N'Xấp', 15500, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'339', N'Khăn hộp Pulppy', N'Hộp', 21000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'340', N'Khăn lau đa năng Magic Cleaner 30*40 (loại mịn)', N'Cái', 22000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'341', N'Khăn nhung KT 0.5x0.7 m', N'Cái', 30000, N'V',N'Đỏ',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'342', N'Khăn vuông lau bàn', N'Cái', 4500, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'343', N'Khay mica Melamin Fataco có quai', N'Cái', 39000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'344', N'Khay úp ly chữ nhật 350mm', N'Cái', 42000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'345', N'Ky hốt rác cán dài', N'Cái', 16400, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'346', N'Ly giấy 6.5oz', N'Cái', 770, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'347', N'Ly nhựa 499', N'Cây', 12000, N'V',N'50 cái/cây',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'348', N'Ly uống nước thủy tinh Ocean Fine 380ml', N'Cái', 28000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'349', N'Mâm inox 35x50cm', N'Cái', 65000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'350', N'Mâm inox 40x60cm', N'Cái', 80000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'351', N'Mâm mica trắng 30x40cm', N'Cái', 97000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'352', N'Mâm nhựa trắng 30x40cm', N'Cái', 40000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'353', N'Mâm tròn chống trượt 30cm', N'Cái', 60000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'354', N'Mâm tròn chống trượt 35cm', N'Cái', 65000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'355', N'Màng bọc thực phẩm 30x2000cm', N'Cuộn', 10000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'356', N'Màng bọc thực phẩm 30x4500cm', N'Cuộn', 179000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'357', N'Màng bọc thực phẩm 30x6500cm', N'Cuộn', 245000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'358', N'Màng bọc thực phẩm 0,3x300M', N'Cuộn', 155000, N'V',N'Coop',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'359', N'Màng bọc thực phẩm 0,3x500M', N'Cuộn', 235000, N'V',N'Coop',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'360', N'Miếng lau nhà 360 độ (Trắng)', N'Cái', 28000, N'V',N'Trắng',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'361', N'Miếng lau nhà 360 độ (Sọc rằng)', N'Cái', 30000, N'V',N'Sọc rằng',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'362', N'Miếng rửa chén kim tuyến', N'Miếng', 4500, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'363', N'Miếng rửa chén xanh', N'Miếng', 4000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'364', N'Muỗng nhựa cán ngắn', N'Bịch', 48000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'365', N'Nước lau kiếng Gift 800 ml', N'Chai', 22500, N'V',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'366', N'Nước lau sàn Gift 4 L', N'Chai', 70500, N'V',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'367', N'Nước lau sàn Sunlight 1 L', N'Chai', 31000, N'V',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'368', N'Nước lau sàn Sunlight 4 L', N'Chai', 92000, N'V',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'369', N'Nước quét vỏ xe', N'Chai', 170000, N'V',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'370', N'Nước rửa chén Sunlight 4 L', N'Chai', 105000, N'V',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'371', N'Nước rửa chén Sunlight 750 ml (chanh)', N'Chai', 24000, N'V',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'372', N'Nước rửa chén Sunlight 750 ml trà xanh', N'Chai', 30000, N'V',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'373', N'Nước rửa tay Lifebuoy 500ml', N'Chai', 69000, N'V',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'374', N'Nước tẩy bồn cầu con vịt 500ml', N'Chai', 27000, N'V',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'375', N'Nước tẩy Gift 900ml', N'Chai', 31000, N'V',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'376', N'Nước tẩy Javel 1L', N'Chai', 25000, N'V',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'377', N'Nước tẩy nhà tắm con vịt 900ml', N'Chai', 35000, N'V',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'378', N'Rổ nhựa Duy Tân (34.5x26x10cm)', N'Cái', 36000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'379', N'Rổ nhựa giả mây chữ nhật 10x20', N'Cái', 28000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'380', N'Rổ nhựa giả mây size 18', N'Cái', 25000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'381', N'Rổ nhựa giả mây vuông 13x13', N'Cái', 30000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'382', N'Rổ nhựa Tân Lập Thành 383x260x90cm', N'Cái', 24000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'383', N'Sọt rác đại ovan Duy Tân (41x41x45cm)', N'Cái', 58000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'384', N'Sọt rác Duy Tân (35x35x38cm)', N'Cái', 47000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'385', N'Sọt rác nhỏ ovan Duy Tân (31x31x33cm)', N'Cái', 29000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'386', N'Sọt rác TLT tròn nhỏ 28x28x29.5cm', N'Cái', 29000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'387', N'Sọt rác TLT vuông', N'Cái', 50000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'388', N'Sọt rác TLT vuông đại', N'Cái', 60000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'389', N'Sọt rác TLT vuông nhỏ', N'Cái', 32000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'390', N'Sọt rác TLT vuông trung', N'Cái', 39000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'391', N'Tẩy bồn cầu Vim 900 ml', N'Chai', 35000, N'V',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'392', N'Tẩy Sumo 700g', N'Chai', 48000, N'V',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'393', N'Thảm đinh thấm nước lớn', N'Cái', 365000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'394', N'Thảm oval hình hột xoài 40x60cm', N'Cái', 35000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'395', N'Thảm Wellcom 40 * 60 cm', N'Cái', 60000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'396', N'Thùng rác đạp vuông lớn (Duy Tân)', N'Cái', 160000, N'V',N'34.5 x 34 x 44 cm',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'397', N'Thùng rác đạp vuông nhỏ (Duy Tân)', N'Cái', 70000, N'V',N' 25 x 23.5 x 29.5 cm',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'398', N'Thùng rác đạp vuông trung (Duy Tân)', N'Cái', 115000, N'V',N'30.5 x 26 x 36 cm',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'399', N'Thùng rác lật lớn', N'Cái', 145000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'400', N'Túi PP', N'Kg', 60000, N'V',N'Túi hột xoài dẻo nhiều kích thước',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'401', N'Túi PP (thường)', N'Kg', 41000, N'V',N'Túi hột xoài',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'402', N'Xà bông cục Lifebuoy', N'Cục', 13000, N'V',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'403', N'Xà bông Omo 400 g', N'Bịch', 22000, N'V',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'404', N'Xà bông Omo 800 g', N'Bịch', 37500, N'V',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'405', N'Xà bông Viso 550 g', N'Bịch', 25000, N'V',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'406', N'Xô đựng nước 10 lít có nắp Tân Lập Thành', N'Cái', 35000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'407', N'Xô đựng nước 20 lít không nắp Tân Lập Thành', N'Cái', 37000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'408', N'Xô đựng nước 6 lít không nắp Tân Lập Thành', N'Cái', 16000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'409', N'Màng bọc thực phẩm Ringo 612', N'hộp', 345000, N'V',N'',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'410', N'Tampon dấu 222', N'Cái', 34000, N'V',N'màu xanh',8); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'411', N'Hộp mực Q2612A ', N'Hộp', 240909, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'412', N'Hộp mực PX-9 ', N'Hộp', 240909, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'413', N'Hộp mực CB435A', N'Hộp', 272727, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'414', N'Hộp mực CE285A', N'Hộp', 272727, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'415', N'Hộp mực 308- Q5949A', N'Hộp', 327273, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'416', N'Hộp mực CE505A ', N'Hộp', 436364, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'417', N'Hộp mực 328', N'Hộp', 380000, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'418', N'Mực canon 316C', N'Hộp', 436364, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'419', N'Mực canon 316M', N'Hộp', 436364, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'420', N'Mực canon 316Y', N'Hộp', 436364, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'421', N'Mực canon 316B (K)', N'Hộp', 436364, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'422', N'Mực KX-FA 83', N'Hộp', 127273, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'423', N'Cụm Drum KX- FA84E', N'Hộp', 770000, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'424', N'Mực KX-FA 88', N'Hộp', 127273, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'425', N'Cụm Drum KX-FA89E', N'Hộp', 770000, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'426', N'Film fax 57E', N'Hộp', 50000, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'427', N'Film fax FO 6CR', N'Hộp', 50000, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'428', N'MP 2500', N'Hộp', 236364, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'429', N'1230D', N'Hộp', 236364, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'430', N'PR2', N'Hộp', 81818, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'431', N'LQ 2180', N'Hộp', 100000, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'432', N'Mực in C407S', N'Hộp', 1363636, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'433', N'Mực in M407S', N'Hộp', 1363636, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'434', N'Mực in Y407S', N'Hộp', 1363636, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'435', N'Mực in K407S', N'Hộp', 1454545, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'436', N'960Black', N'Hộp', 230000, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'437', N'960C/M/Y', N'Hộp', 230000, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'438', N'T122100', N'Hộp', 220000, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'439', N'T122200', N'Hộp', 220000, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'440', N'T122300', N'Hộp', 220000, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'441', N'T122400', N'Hộp', 220000, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'442', N'T122500', N'Hộp', 220000, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'443', N'T122600', N'Hộp', 220000, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'444', N'Hộp mực Canon 045 BK', N'Hộp', 1420000, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'445', N'Hộp mực Canon 045 (M/Y/C)', N'Hộp', 1620000, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'446', N'Hộp mực CF226A ', N'Hộp', 800000, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'447', N'Hộp mực 55A', N'Hộp', 900000, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'448', N'Hộp mực 041', N'Hộp', 2000000, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'449', N'Hộp mực 76A ', N'Hộp', 2000000, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'450', N'Hộp mực 337 ', N'Hộp', 380000, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'451', N'HP Color LaserJet M255dw 206A W2110A (Đen)', N'Hộp', 1600000, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'452', N'HP Color LaserJet M255dw 206A W2111A (Xanh)', N'Hộp', 1900000, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'453', N'HP Color LaserJet M255dw 206A W2112A (Vàng)', N'Hộp', 1900000, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'454', N'HP Color LaserJet M255dw 206A W2113A (Đỏ)', N'Hộp', 1900000, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'455', N'HP Color LaserJet Pro M252n 201A CF400A (Đen) ', N'Hộp', 2000000, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'456', N'HP Color LaserJet Pro M252n 201A CF401A (Xanh)', N'Hộp', 2400000, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'457', N'HP Color LaserJet Pro M252n 201A CF402A (Vàng)', N'Hộp', 2400000, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'458', N'HP Color LaserJet Pro M252n 201A CF403A (Đỏ)', N'Hộp', 2400000, N'VI',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'459', N'Hộp mực Q2612A ', N'Lần', 59000, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'460', N'Hộp mực PX-9 ', N'Lần', 59000, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'461', N'Hộp mực CB435A', N'Lần', 59000, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'462', N'Hộp mực CE285A', N'Lần', 59000, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'463', N'Hộp mực 308- Q5949A', N'Lần', 59000, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'464', N'Hộp mực CE505A ', N'Lần', 59000, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'465', N'Hộp mực 328', N'Lần', 59000, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'466', N'Mực canon 316C', N'Lần', 230000, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'467', N'Mực canon 316M', N'Lần', 230000, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'468', N'Mực canon 316Y', N'Lần', 230000, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'469', N'Mực canon 316B (K)', N'Lần', 230000, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'470', N'Mực KX-FA 83', N'Lần', 92727, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'471', N'Cụm Drum KX- FA84E', N'Lần', 0, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'472', N'Mực KX-FA 88', N'Lần', 100000, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'473', N'Cụm Drum KX-FA89E', N'Lần', 0, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'474', N'Film fax 57E', N'Lần', 0, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'475', N'Film fax FO 6CR', N'Lần', 0, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'476', N'MP 2500', N'Lần', 0, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'477', N'1230D', N'Lần', 0, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'478', N'PR2', N'Lần', 0, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'479', N'LQ 2180', N'Lần', 0, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'480', N'Mực in C407S', N'Lần', 0, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'481', N'Mực in M407S', N'Lần', 0, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'482', N'Mực in Y407S', N'Lần', 0, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'483', N'Mực in K407S', N'Lần', 0, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'484', N'960Black', N'Lần', 0, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'485', N'960C/M/Y', N'Lần', 0, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'486', N'T122100', N'Lần', 0, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'487', N'T122200', N'Lần', 0, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'488', N'T122300', N'Lần', 0, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'489', N'T122400', N'Lần', 0, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'490', N'T122500', N'Lần', 0, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'491', N'T122600', N'Lần', 0, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'492', N'Hộp mực Canon 045 BK', N'Lần', 0, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'493', N'Hộp mực Canon 045 (M/Y/C)', N'Lần', 0, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'494', N'Hộp mực CF226A ', N'Lần', 59000, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'495', N'Hộp mực 55A', N'Lần', 118000, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'496', N'Hộp mực 041', N'Lần', 118000, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'497', N'Hộp mực 76A ', N'Lần', 59000, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'498', N'Hộp mực 337 ', N'Lần', 59000, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'499', N'HP Color LaserJet M255dw 206A W2110A (Đen)', N'Lần', 0, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'500', N'HP Color LaserJet M255dw 206A W2111A (Xanh)', N'Lần', 0, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'501', N'HP Color LaserJet M255dw 206A W2112A (Vàng)', N'Lần', 0, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'502', N'HP Color LaserJet M255dw 206A W2113A (Đỏ)', N'Lần', 0, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'503', N'HP Color LaserJet Pro M252n 201A CF400A (Đen) ', N'Lần', 0, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'504', N'HP Color LaserJet Pro M252n 201A CF401A (Xanh)', N'Lần', 0, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'505', N'HP Color LaserJet Pro M252n 201A CF402A (Vàng)', N'Lần', 0, N'VII',N'',10); INSERT INTO #CM_PRICE_BANK(STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES,VAT) VALUES (N'506', N'HP Color LaserJet Pro M252n 201A CF403A (Đỏ)', N'Lần', 0, N'VII',N'',10); -- Giả sử bảng đã có dữ liệu -- Tạo CURSOR để duyệt từng dòng DECLARE @STT VARCHAR(15), @PRICE_BANK_NAME NVARCHAR(MAX), @DVT NVARCHAR(15), @REFERENCE_PRICE DECIMAL(18, 2), @PRICE_STT_PARENT VARCHAR(15), @NOTES NVARCHAR(MAX), @VAT DECIMAL(18,2) DECLARE @l_PRICE_BANK_ID VARCHAR(15), @l_PRICE_BANK_CODE NVARCHAR(50) = NULL, @l_HH_ID VARCHAR(15), @l_FATHER_ID VARCHAR(15), @l_UNIT_ID VARCHAR(15) = NULL, @CD_ID VARCHAR(15) = NULL, @l_STA_GOODS_TYPE_ID VARCHAR(15), @l_STA_GOODS_ID VARCHAR(15), @p_STA_GOODS_TYPE_CODE VARCHAR(15), @STA_GOODS_GROUP_CODE VARCHAR(15) DECLARE price_cursor CURSOR FOR SELECT STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES, VAT FROM #CM_PRICE_BANK OPEN price_cursor FETCH NEXT FROM price_cursor INTO @STT, @PRICE_BANK_NAME, @DVT, @REFERENCE_PRICE, @PRICE_STT_PARENT, @NOTES,@VAT WHILE @@FETCH_STATUS = 0 BEGIN ---------------- INS NGÂN HÀNG GIÁ ----------------------------------------------------------------------- EXEC SYS_CodeMasters_Gen 'CM_PRICE_BANK', @l_PRICE_BANK_ID out IF(@STT = 'VI' OR @STT = 'VII' OR @PRICE_STT_PARENT = 'VI' OR @PRICE_STT_PARENT = 'VII') BEGIN SET @l_HH_ID = ( SELECT HH_ID FROM CM_HANGHOA WHERE HH_NAME = N'Mực in' ) END ELSE BEGIN SET @l_HH_ID = ( SELECT HH_ID FROM CM_HANGHOA WHERE HH_NAME = N'Văn phòng phẩm' ) END IF(@PRICE_STT_PARENT IS NOT NULL AND @PRICE_STT_PARENT <> '') BEGIN SET @l_FATHER_ID = (SELECT cpb.PRICE_BANK_ID FROM CM_PRICE_BANK cpb WHERE cpb.NOTES = @PRICE_STT_PARENT) END ELSE BEGIN IF(@PRICE_STT_PARENT = 'I' OR @STT = 'I' OR @PRICE_STT_PARENT = 'VI' OR @STT = 'VI' OR @PRICE_STT_PARENT = 'VII' OR @STT = 'VII') BEGIN SET @l_STA_GOODS_GROUP_ID = (SELECT sgt.STA_GOODS_GROUP_ID FROM STA_GOODS_GROUP sgt WHERE sgt.STA_GOODS_GROUP_NAME = N'Giấy mực in') SET @STA_GOODS_GROUP_CODE = (SELECT sgt.STA_GOODS_GROUP_CODE FROM STA_GOODS_GROUP sgt WHERE sgt.STA_GOODS_GROUP_NAME = N'Giấy mực in') END ELSE IF (@PRICE_STT_PARENT = 'II' OR @STT = 'II') BEGIN SET @l_STA_GOODS_GROUP_ID = (SELECT STA_GOODS_GROUP_ID FROM STA_GOODS_GROUP sgt WHERE sgt.STA_GOODS_GROUP_NAME = N'Văn phòng phẩm') SET @STA_GOODS_GROUP_CODE = (SELECT sgt.STA_GOODS_GROUP_CODE FROM STA_GOODS_GROUP sgt WHERE sgt.STA_GOODS_GROUP_NAME = N'Văn phòng phẩm') END ELSE IF (@PRICE_STT_PARENT = 'III' OR @STT = 'III') BEGIN SET @l_STA_GOODS_GROUP_ID = (SELECT STA_GOODS_GROUP_ID FROM STA_GOODS_GROUP sgt WHERE sgt.STA_GOODS_GROUP_NAME = N'Vật tư kho quỹ') SET @STA_GOODS_GROUP_CODE = (SELECT sgt.STA_GOODS_GROUP_CODE FROM STA_GOODS_GROUP sgt WHERE sgt.STA_GOODS_GROUP_NAME = N'Vật tư kho quỹ') END ELSE IF (@PRICE_STT_PARENT = 'IV' OR @STT = 'IV') BEGIN SET @l_STA_GOODS_GROUP_ID = (SELECT STA_GOODS_GROUP_ID FROM STA_GOODS_GROUP sgt WHERE sgt.STA_GOODS_GROUP_NAME = N'Vật liệu khác') SET @STA_GOODS_GROUP_CODE = (SELECT sgt.STA_GOODS_GROUP_CODE FROM STA_GOODS_GROUP sgt WHERE sgt.STA_GOODS_GROUP_NAME = N'Vật liệu khác') END ELSE IF (@PRICE_STT_PARENT = 'V' OR @STT = 'V') BEGIN SET @l_STA_GOODS_GROUP_ID = (SELECT STA_GOODS_GROUP_ID FROM STA_GOODS_GROUP sgt WHERE sgt.STA_GOODS_GROUP_NAME = N'Nhu yếu phẩm khác') SET @STA_GOODS_GROUP_CODE = (SELECT sgt.STA_GOODS_GROUP_CODE FROM STA_GOODS_GROUP sgt WHERE sgt.STA_GOODS_GROUP_NAME =N'Nhu yếu phẩm khác') END EXEC SYS_CodeMasters_Gen 'STA_GOODS_TYPE', @l_STA_GOODS_TYPE_ID OUT -- Tạo mã nhóm hàng hóa EXEC STA_GOODS_TYPE_NO_Gen @STA_GOODS_GROUP_CODE, @p_STA_GOODS_TYPE_CODE OUT; PRINT @STA_GOODS_GROUP_CODE SET @NOTES = @PRICE_STT_PARENT INSERT INTO [dbo].[STA_GOODS_TYPE] ([STA_GOODS_TYPE_ID] ,[STA_GOODS_TYPE_CODE] ,[STA_GOODS_TYPE_NAME] ,[STA_GOODS_GROUP_ID] ,[NOTES] ,[RECORD_STATUS] ,[AUTH_STATUS] ,[MAKER_ID] ,[CREATE_DT] ,[CHECKER_ID] ,[APPROVE_DT] ,[BRANCH_ID] ,[DEP_ID]) VALUES ( @l_STA_GOODS_TYPE_ID, @p_STA_GOODS_TYPE_CODE, @PRICE_BANK_NAME, @l_STA_GOODS_GROUP_ID, '', '1', 'A', 'admin', CONVERT(DATETIME, GETDATE(), 103), NULL, NULL, NULL, NULL ) END SELECT @l_UNIT_ID = cu.UNIT_ID FROM CM_UNIT cu WHERE cu.UNIT_NAME = @DVT IF(@l_UNIT_ID is null OR @l_UNIT_ID = '') BEGIN EXEC SYS_CodeMasters_Gen 'CM_UNIT', @l_UNIT_ID OUT INSERT INTO CM_UNIT([UNIT_ID],[UNIT_CODE],[UNIT_NAME],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT]) VALUES(@l_UNIT_ID ,'' ,@DVT ,'IMPORT' ,'1' ,'admin' ,CONVERT(DATETIME, GETDATE(), 103) ,'A' ,'admin' ,CONVERT(DATETIME, GETDATE(), 103) ) END IF @PRICE_STT_PARENT IS NULL OR @PRICE_STT_PARENT = '' BEGIN SET @NOTES = @STT END -- Tạo mã code ngân hàng giá SET @l_PRICE_BANK_CODE = 'NHG' + RIGHT(@l_PRICE_BANK_ID, 7) -- Thực hiện xử lý với từng dòng ở đây INSERT INTO [dbo].[CM_PRICE_BANK] ([PRICE_BANK_ID] ,[PRICE_BANK_CODE] ,[PRICE_BANK_NAME] ,[HH_ID] ,[FATHER_ID] ,[REFERENCE_PRICE] ,[UNIT_ID] ,[IS_STATIONERY] ,[NOTES] ,[RECORD_STATUS] ,[MAKER_ID] ,[CREATE_DT] ,[CHECKER_ID] ,[APPROVE_DT] ,[AUTH_STATUS]) VALUES ( @l_PRICE_BANK_ID, @l_PRICE_BANK_CODE, @PRICE_BANK_NAME, @l_HH_ID, @l_FATHER_ID, @REFERENCE_PRICE, @l_UNIT_ID, '1', @NOTES, '1', 'admin', CONVERT(DATETIME, GETDATE(), 103), 'admin', CONVERT(DATETIME, GETDATE(), 103), 'A' ) IF(@PRICE_STT_PARENT = 'I' OR @STT = 'I') BEGIN SET @l_STA_GOODS_TYPE_ID = (SELECT sgt.STA_GOODS_TYPE_ID FROM STA_GOODS_TYPE sgt WHERE sgt.STA_GOODS_TYPE_NAME = N'GIẤY IN') END ELSE IF (@PRICE_STT_PARENT = 'II' OR @STT = 'II') BEGIN SET @l_STA_GOODS_TYPE_ID = (SELECT STA_GOODS_TYPE_ID FROM STA_GOODS_TYPE sgt WHERE sgt.STA_GOODS_TYPE_NAME = N'VĂN PHÒNG PHẨM') END ELSE IF (@PRICE_STT_PARENT = 'III' OR @STT = 'III') BEGIN SET @l_STA_GOODS_TYPE_ID = (SELECT STA_GOODS_TYPE_ID FROM STA_GOODS_TYPE sgt WHERE sgt.STA_GOODS_TYPE_NAME = N'VẬT TƯ KHO QUỸ') END ELSE IF (@PRICE_STT_PARENT = 'IV' OR @STT = 'IV') BEGIN SET @l_STA_GOODS_TYPE_ID = (SELECT STA_GOODS_TYPE_ID FROM STA_GOODS_TYPE sgt WHERE sgt.STA_GOODS_TYPE_NAME = N'VẬT LIỆU KHÁC') END ELSE IF (@PRICE_STT_PARENT = 'V' OR @STT = 'V') BEGIN SET @l_STA_GOODS_TYPE_ID = (SELECT STA_GOODS_TYPE_ID FROM STA_GOODS_TYPE sgt WHERE sgt.STA_GOODS_TYPE_NAME = N'NHU YẾU PHẨM') END ELSE IF (@PRICE_STT_PARENT = 'VI' OR @STT = 'VI') BEGIN SET @l_STA_GOODS_TYPE_ID = (SELECT STA_GOODS_TYPE_ID FROM STA_GOODS_TYPE sgt WHERE sgt.STA_GOODS_TYPE_NAME = N'Mực in mua mới') END ELSE IF (@PRICE_STT_PARENT = 'VII' OR @STT = 'VII') BEGIN SET @l_STA_GOODS_TYPE_ID = (SELECT STA_GOODS_TYPE_ID FROM STA_GOODS_TYPE sgt WHERE sgt.STA_GOODS_TYPE_NAME = N'Nạp mực') END --------- Insert VPP vào TRC ----- IF(@PRICE_STT_PARENT = 'VII' OR @STT = 'VII' OR @PRICE_STT_PARENT = 'VI' OR @STT = 'VI') BEGIN SELECT @l_HH_ID = HH_ID FROM CM_HANGHOA WHERE HH_NAME = N'Mực in' EXEC SYS_CodeMasters_Gen 'TR_CONTRACT_DT', @CD_ID out --EXEC TR_CONTRACT_DT_Ins @P_CONTRACT_ID,@GOODS_ID,@UNIT_ID,@QUANTITY,@PRICE,@NOTES,@p_RECORD_STATUS, --@p_MAKER_ID,@p_CREATE_DT,@p_AUTH_STATUS,@p_CHECKER_ID,@p_APPROVE_DT --ELSE INSERT INTO TR_CONTRACT_DT([CD_ID],[CONTRACT_ID],[GOODS_ID],[UNIT_ID],[QUANTITY],[PRICE],TOTAL_VAT,PRICE_VAT,VAT,[NOTES], [RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_NAME_REAL],RECURRING,UNIT_NAME_REAL, RENT_PRICE,BUILDING_ID,HH_DT_ID,REQ_DOC_ID) VALUES(@CD_ID ,@l_CONTRACT_MI_ID, @l_HH_ID , @l_UNIT_ID , 1 , @REFERENCE_PRICE ,@REFERENCE_PRICE + @REFERENCE_PRICE*@VAT/100,@REFERENCE_PRICE*@VAT/100,@VAT, 'IMPORT' ,'1' ,'admin' ,CONVERT(DATETIME, GETDATE(), 103) ,'A' ,'admin' ,CONVERT(DATETIME, GETDATE(), 103),@PRICE_BANK_NAME,'',@l_UNIT_ID, NULL, null,@l_PRICE_BANK_ID,null) END ELSE BEGIN SELECT @l_HH_ID = HH_ID, @l_UNIT_ID = UNIT_ID FROM CM_HANGHOA WHERE HH_NAME = N'Văn phòng phẩm' EXEC SYS_CodeMasters_Gen 'TR_CONTRACT_DT', @CD_ID out INSERT INTO TR_CONTRACT_DT([CD_ID],[CONTRACT_ID],[GOODS_ID],[UNIT_ID],[QUANTITY],[PRICE],TOTAL_VAT,PRICE_VAT,VAT,[NOTES], [RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_NAME_REAL],RECURRING,UNIT_NAME_REAL, RENT_PRICE,BUILDING_ID,HH_DT_ID,REQ_DOC_ID) VALUES(@CD_ID ,@l_CONTRACT_VPP_ID, @l_HH_ID , @l_UNIT_ID , 1 , @REFERENCE_PRICE ,@REFERENCE_PRICE + @REFERENCE_PRICE*@VAT/100,@REFERENCE_PRICE*@VAT/100,@VAT, 'IMPORT' ,'1' ,'admin' ,CONVERT(DATETIME, GETDATE(), 103) ,'A' ,'admin' ,CONVERT(DATETIME, GETDATE(), 103),@PRICE_BANK_NAME,'',@l_UNIT_ID, NULL, null,@l_PRICE_BANK_ID,null) END --------- Insert VPP vào TRC ----- -------------------------- INSERT vào DT loại hàng hóa --------------------------------- EXEC SYS_CodeMasters_Gen 'STA_GOODS', @l_STA_GOODS_ID OUT INSERT INTO [dbo].[STA_GOODS] ([STA_GOODS_ID] ,[STA_GOODS_TYPE_ID] ,[GOODS_ID]) VALUES (@l_STA_GOODS_ID, @l_STA_GOODS_TYPE_ID, @l_PRICE_BANK_ID ) -------------------------- INSERT vào DT loại hàng hóa --------------------------------- -- FETCH dòng tiếp theo FETCH NEXT FROM price_cursor INTO @STT, @PRICE_BANK_NAME, @DVT, @REFERENCE_PRICE, @PRICE_STT_PARENT, @NOTES,@VAT ---------------- INS NGÂN HÀNG GIÁ ----------------------------------------------------------------------- END CLOSE price_cursor DEALLOCATE price_cursor DROP TABLE #CM_PRICE_BANK DROP TABLE #STA_GOODS_GROUP