﻿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