import VPP.sql
| 1 |
DELETE FROM STA_GOODS_GROUP; |
|---|---|
| 2 |
DELETE FROM STA_GOODS; |
| 3 |
DELETE FROm STA_GOODS_TYPE; |
| 4 |
DELETE FROM CM_PRICE_BANK |
| 5 |
|
| 6 |
DECLARE @l_CONTRACT_VPP_ID VARCHAR(20) = 'TRC000000265960' --- ID của TRC Văn phòng phẩm |
| 7 |
DECLARE @l_CONTRACT_MI_ID VARCHAR(20) = 'TRC000000265960' --- ID của TRC Mực in |
| 8 |
|
| 9 |
CREATE TABLE #STA_GOODS_GROUP ( |
| 10 |
STA_GOODS_GROUP_NAME NVARCHAR(100) NOT NULL |
| 11 |
) |
| 12 |
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'); |
| 13 |
|
| 14 |
|
| 15 |
|
| 16 |
-- Khai báo biến
|
| 17 |
DECLARE @GROUP_NAME NVARCHAR(100) |
| 18 |
|
| 19 |
-- Khai báo cursor
|
| 20 |
DECLARE group_cursor CURSOR FOR
|
| 21 |
SELECT STA_GOODS_GROUP_NAME
|
| 22 |
FROM #STA_GOODS_GROUP |
| 23 |
|
| 24 |
-- Mở cursor
|
| 25 |
OPEN group_cursor |
| 26 |
|
| 27 |
-- Lấy dòng đầu tiên
|
| 28 |
FETCH NEXT FROM group_cursor INTO @GROUP_NAME |
| 29 |
|
| 30 |
-- Vòng lặp duyệt từng dòng
|
| 31 |
WHILE @@FETCH_STATUS = 0 |
| 32 |
BEGIN
|
| 33 |
-- Xử lý tại đây
|
| 34 |
DECLARE @l_STA_GOODS_GROUP_ID VARCHAR(15), |
| 35 |
@P_STA_GOODS_GROUP_CODE VARCHAR(15) |
| 36 |
|
| 37 |
EXEC SYS_CodeMasters_Gen 'STA_GOODS_GROUP', @l_STA_GOODS_GROUP_ID out |
| 38 |
|
| 39 |
|
| 40 |
-- Tạo mã nhóm hàng hóa
|
| 41 |
EXEC STA_GOODS_GROUP_NO_Gen @P_STA_GOODS_GROUP_CODE OUT;
|
| 42 |
|
| 43 |
|
| 44 |
INSERT INTO [dbo].[STA_GOODS_GROUP] |
| 45 |
([STA_GOODS_GROUP_ID] |
| 46 |
,[STA_GOODS_GROUP_CODE] |
| 47 |
,[STA_GOODS_GROUP_NAME] |
| 48 |
,[NOTES] |
| 49 |
,[RECORD_STATUS] |
| 50 |
,[AUTH_STATUS] |
| 51 |
,[MAKER_ID] |
| 52 |
,[CREATE_DT] |
| 53 |
,[CHECKER_ID] |
| 54 |
,[APPROVE_DT] |
| 55 |
,[BRANCH_ID] |
| 56 |
,[DEP_ID]) |
| 57 |
VALUES
|
| 58 |
( |
| 59 |
@l_STA_GOODS_GROUP_ID,
|
| 60 |
@P_STA_GOODS_GROUP_CODE,
|
| 61 |
@GROUP_NAME,
|
| 62 |
'',
|
| 63 |
'1',
|
| 64 |
'A',
|
| 65 |
'admin',
|
| 66 |
CONVERT(DATETIME, GETDATE(), 103), |
| 67 |
NULL,
|
| 68 |
NULL,
|
| 69 |
NULL,
|
| 70 |
NULL
|
| 71 |
) |
| 72 |
|
| 73 |
-- Lấy dòng tiếp theo
|
| 74 |
FETCH NEXT FROM group_cursor INTO @GROUP_NAME |
| 75 |
END
|
| 76 |
|
| 77 |
-- Đóng và giải phóng cursor
|
| 78 |
CLOSE group_cursor |
| 79 |
DEALLOCATE group_cursor |
| 80 |
|
| 81 |
|
| 82 |
|
| 83 |
|
| 84 |
|
| 85 |
CREATE TABLE #CM_PRICE_BANK ( |
| 86 |
STT VARCHAR(15) NULL, |
| 87 |
PRICE_BANK_NAME NVARCHAR(MAX) NULL, |
| 88 |
DVT NVARCHAR(15) NULL, |
| 89 |
REFERENCE_PRICE DECIMAL(18, 2) NULL, |
| 90 |
PRICE_STT_PARENT VARCHAR(15) NULL, |
| 91 |
NOTES NVARCHAR(MAX) NULL, |
| 92 |
VAT DECIMAL(18,2) NULL |
| 93 |
) |
| 94 |
|
| 95 |
INSERT INTO #CM_PRICE_BANK (STT, PRICE_BANK_NAME) VALUES (N'I', N'GIẤY IN'); |
| 96 |
INSERT INTO #CM_PRICE_BANK (STT, PRICE_BANK_NAME) VALUES (N'II', N'VĂN PHÒNG PHẨM'); |
| 97 |
INSERT INTO #CM_PRICE_BANK (STT, PRICE_BANK_NAME) VALUES (N'III', N'VẬT TƯ KHO QUỸ'); |
| 98 |
INSERT INTO #CM_PRICE_BANK (STT, PRICE_BANK_NAME) VALUES (N'IV', N'VẬT LIỆU KHÁC'); |
| 99 |
INSERT INTO #CM_PRICE_BANK (STT, PRICE_BANK_NAME) VALUES (N'V', N'NHU YẾU PHẨM'); |
| 100 |
INSERT INTO #CM_PRICE_BANK (STT, PRICE_BANK_NAME) VALUES (N'VI', N'Mực in mua mới'); |
| 101 |
INSERT INTO #CM_PRICE_BANK (STT, PRICE_BANK_NAME) VALUES (N'VII', N'Nạp mực'); |
| 102 |
|
| 103 |
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); |
| 104 |
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); |
| 105 |
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); |
| 106 |
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); |
| 107 |
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); |
| 108 |
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); |
| 109 |
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); |
| 110 |
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); |
| 111 |
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); |
| 112 |
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); |
| 113 |
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); |
| 114 |
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); |
| 115 |
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); |
| 116 |
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); |
| 117 |
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); |
| 118 |
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); |
| 119 |
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); |
| 120 |
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); |
| 121 |
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); |
| 122 |
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); |
| 123 |
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); |
| 124 |
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); |
| 125 |
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); |
| 126 |
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); |
| 127 |
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); |
| 128 |
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); |
| 129 |
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); |
| 130 |
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); |
| 131 |
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); |
| 132 |
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); |
| 133 |
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); |
| 134 |
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); |
| 135 |
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); |
| 136 |
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); |
| 137 |
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); |
| 138 |
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); |
| 139 |
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); |
| 140 |
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); |
| 141 |
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); |
| 142 |
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); |
| 143 |
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); |
| 144 |
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); |
| 145 |
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); |
| 146 |
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); |
| 147 |
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); |
| 148 |
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); |
| 149 |
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); |
| 150 |
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); |
| 151 |
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); |
| 152 |
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); |
| 153 |
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); |
| 154 |
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); |
| 155 |
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); |
| 156 |
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); |
| 157 |
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); |
| 158 |
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); |
| 159 |
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); |
| 160 |
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); |
| 161 |
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); |
| 162 |
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); |
| 163 |
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); |
| 164 |
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); |
| 165 |
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); |
| 166 |
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); |
| 167 |
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); |
| 168 |
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); |
| 169 |
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); |
| 170 |
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); |
| 171 |
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); |
| 172 |
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); |
| 173 |
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); |
| 174 |
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); |
| 175 |
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); |
| 176 |
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); |
| 177 |
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); |
| 178 |
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); |
| 179 |
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); |
| 180 |
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); |
| 181 |
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); |
| 182 |
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); |
| 183 |
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); |
| 184 |
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); |
| 185 |
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); |
| 186 |
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); |
| 187 |
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); |
| 188 |
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); |
| 189 |
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); |
| 190 |
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); |
| 191 |
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); |
| 192 |
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); |
| 193 |
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); |
| 194 |
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); |
| 195 |
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); |
| 196 |
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); |
| 197 |
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); |
| 198 |
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); |
| 199 |
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); |
| 200 |
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); |
| 201 |
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); |
| 202 |
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); |
| 203 |
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); |
| 204 |
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); |
| 205 |
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); |
| 206 |
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); |
| 207 |
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); |
| 208 |
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); |
| 209 |
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); |
| 210 |
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); |
| 211 |
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); |
| 212 |
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); |
| 213 |
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); |
| 214 |
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); |
| 215 |
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); |
| 216 |
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); |
| 217 |
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); |
| 218 |
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); |
| 219 |
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); |
| 220 |
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); |
| 221 |
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); |
| 222 |
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); |
| 223 |
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); |
| 224 |
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); |
| 225 |
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); |
| 226 |
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); |
| 227 |
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); |
| 228 |
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); |
| 229 |
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); |
| 230 |
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); |
| 231 |
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); |
| 232 |
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); |
| 233 |
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); |
| 234 |
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); |
| 235 |
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); |
| 236 |
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); |
| 237 |
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); |
| 238 |
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); |
| 239 |
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); |
| 240 |
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); |
| 241 |
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); |
| 242 |
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); |
| 243 |
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); |
| 244 |
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); |
| 245 |
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); |
| 246 |
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); |
| 247 |
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); |
| 248 |
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); |
| 249 |
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); |
| 250 |
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); |
| 251 |
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); |
| 252 |
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); |
| 253 |
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); |
| 254 |
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); |
| 255 |
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); |
| 256 |
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); |
| 257 |
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); |
| 258 |
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); |
| 259 |
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); |
| 260 |
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); |
| 261 |
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); |
| 262 |
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); |
| 263 |
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); |
| 264 |
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); |
| 265 |
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); |
| 266 |
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); |
| 267 |
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); |
| 268 |
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); |
| 269 |
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); |
| 270 |
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); |
| 271 |
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); |
| 272 |
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); |
| 273 |
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); |
| 274 |
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); |
| 275 |
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); |
| 276 |
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); |
| 277 |
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); |
| 278 |
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); |
| 279 |
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); |
| 280 |
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); |
| 281 |
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); |
| 282 |
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); |
| 283 |
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); |
| 284 |
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); |
| 285 |
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); |
| 286 |
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); |
| 287 |
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); |
| 288 |
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); |
| 289 |
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); |
| 290 |
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); |
| 291 |
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); |
| 292 |
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); |
| 293 |
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); |
| 294 |
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); |
| 295 |
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); |
| 296 |
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); |
| 297 |
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); |
| 298 |
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); |
| 299 |
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); |
| 300 |
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); |
| 301 |
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); |
| 302 |
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); |
| 303 |
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); |
| 304 |
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); |
| 305 |
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); |
| 306 |
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); |
| 307 |
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); |
| 308 |
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); |
| 309 |
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); |
| 310 |
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); |
| 311 |
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); |
| 312 |
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); |
| 313 |
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); |
| 314 |
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); |
| 315 |
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); |
| 316 |
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); |
| 317 |
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); |
| 318 |
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); |
| 319 |
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); |
| 320 |
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); |
| 321 |
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); |
| 322 |
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); |
| 323 |
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); |
| 324 |
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); |
| 325 |
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); |
| 326 |
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); |
| 327 |
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); |
| 328 |
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); |
| 329 |
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); |
| 330 |
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); |
| 331 |
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); |
| 332 |
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); |
| 333 |
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); |
| 334 |
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); |
| 335 |
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); |
| 336 |
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); |
| 337 |
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); |
| 338 |
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); |
| 339 |
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); |
| 340 |
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); |
| 341 |
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); |
| 342 |
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); |
| 343 |
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); |
| 344 |
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); |
| 345 |
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); |
| 346 |
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); |
| 347 |
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); |
| 348 |
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); |
| 349 |
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); |
| 350 |
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); |
| 351 |
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); |
| 352 |
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); |
| 353 |
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); |
| 354 |
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); |
| 355 |
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); |
| 356 |
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); |
| 357 |
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); |
| 358 |
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); |
| 359 |
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); |
| 360 |
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); |
| 361 |
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); |
| 362 |
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); |
| 363 |
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); |
| 364 |
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); |
| 365 |
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); |
| 366 |
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); |
| 367 |
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); |
| 368 |
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); |
| 369 |
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); |
| 370 |
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); |
| 371 |
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); |
| 372 |
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); |
| 373 |
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); |
| 374 |
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); |
| 375 |
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); |
| 376 |
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); |
| 377 |
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); |
| 378 |
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); |
| 379 |
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); |
| 380 |
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); |
| 381 |
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); |
| 382 |
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); |
| 383 |
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); |
| 384 |
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); |
| 385 |
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); |
| 386 |
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); |
| 387 |
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); |
| 388 |
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); |
| 389 |
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); |
| 390 |
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); |
| 391 |
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); |
| 392 |
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); |
| 393 |
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); |
| 394 |
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); |
| 395 |
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); |
| 396 |
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); |
| 397 |
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); |
| 398 |
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); |
| 399 |
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); |
| 400 |
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); |
| 401 |
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); |
| 402 |
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); |
| 403 |
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); |
| 404 |
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); |
| 405 |
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); |
| 406 |
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); |
| 407 |
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); |
| 408 |
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); |
| 409 |
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); |
| 410 |
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); |
| 411 |
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); |
| 412 |
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); |
| 413 |
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); |
| 414 |
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); |
| 415 |
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); |
| 416 |
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); |
| 417 |
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); |
| 418 |
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); |
| 419 |
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); |
| 420 |
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); |
| 421 |
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); |
| 422 |
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); |
| 423 |
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); |
| 424 |
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); |
| 425 |
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); |
| 426 |
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); |
| 427 |
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); |
| 428 |
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); |
| 429 |
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); |
| 430 |
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); |
| 431 |
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); |
| 432 |
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); |
| 433 |
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); |
| 434 |
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); |
| 435 |
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); |
| 436 |
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); |
| 437 |
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); |
| 438 |
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); |
| 439 |
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); |
| 440 |
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); |
| 441 |
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); |
| 442 |
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); |
| 443 |
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); |
| 444 |
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); |
| 445 |
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); |
| 446 |
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); |
| 447 |
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); |
| 448 |
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); |
| 449 |
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); |
| 450 |
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); |
| 451 |
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); |
| 452 |
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); |
| 453 |
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); |
| 454 |
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); |
| 455 |
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); |
| 456 |
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); |
| 457 |
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); |
| 458 |
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); |
| 459 |
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); |
| 460 |
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); |
| 461 |
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); |
| 462 |
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); |
| 463 |
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); |
| 464 |
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); |
| 465 |
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); |
| 466 |
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); |
| 467 |
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); |
| 468 |
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); |
| 469 |
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); |
| 470 |
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); |
| 471 |
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); |
| 472 |
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); |
| 473 |
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); |
| 474 |
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); |
| 475 |
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); |
| 476 |
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); |
| 477 |
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); |
| 478 |
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); |
| 479 |
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); |
| 480 |
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); |
| 481 |
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); |
| 482 |
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); |
| 483 |
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); |
| 484 |
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); |
| 485 |
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); |
| 486 |
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); |
| 487 |
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); |
| 488 |
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); |
| 489 |
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); |
| 490 |
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); |
| 491 |
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); |
| 492 |
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); |
| 493 |
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); |
| 494 |
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); |
| 495 |
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); |
| 496 |
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); |
| 497 |
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); |
| 498 |
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); |
| 499 |
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); |
| 500 |
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); |
| 501 |
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); |
| 502 |
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); |
| 503 |
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); |
| 504 |
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); |
| 505 |
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); |
| 506 |
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); |
| 507 |
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); |
| 508 |
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); |
| 509 |
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); |
| 510 |
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); |
| 511 |
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); |
| 512 |
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); |
| 513 |
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); |
| 514 |
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); |
| 515 |
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); |
| 516 |
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); |
| 517 |
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); |
| 518 |
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); |
| 519 |
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); |
| 520 |
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); |
| 521 |
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); |
| 522 |
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); |
| 523 |
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); |
| 524 |
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); |
| 525 |
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); |
| 526 |
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); |
| 527 |
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); |
| 528 |
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); |
| 529 |
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); |
| 530 |
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); |
| 531 |
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); |
| 532 |
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); |
| 533 |
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); |
| 534 |
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); |
| 535 |
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); |
| 536 |
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); |
| 537 |
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); |
| 538 |
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); |
| 539 |
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); |
| 540 |
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); |
| 541 |
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); |
| 542 |
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); |
| 543 |
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); |
| 544 |
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); |
| 545 |
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); |
| 546 |
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); |
| 547 |
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); |
| 548 |
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); |
| 549 |
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); |
| 550 |
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); |
| 551 |
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); |
| 552 |
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); |
| 553 |
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); |
| 554 |
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); |
| 555 |
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); |
| 556 |
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); |
| 557 |
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); |
| 558 |
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); |
| 559 |
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); |
| 560 |
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); |
| 561 |
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); |
| 562 |
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); |
| 563 |
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); |
| 564 |
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); |
| 565 |
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); |
| 566 |
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); |
| 567 |
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); |
| 568 |
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); |
| 569 |
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); |
| 570 |
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); |
| 571 |
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); |
| 572 |
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); |
| 573 |
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); |
| 574 |
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); |
| 575 |
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); |
| 576 |
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); |
| 577 |
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); |
| 578 |
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); |
| 579 |
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); |
| 580 |
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); |
| 581 |
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); |
| 582 |
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); |
| 583 |
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); |
| 584 |
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); |
| 585 |
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); |
| 586 |
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); |
| 587 |
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); |
| 588 |
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); |
| 589 |
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); |
| 590 |
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); |
| 591 |
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); |
| 592 |
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); |
| 593 |
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); |
| 594 |
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); |
| 595 |
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); |
| 596 |
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); |
| 597 |
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); |
| 598 |
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); |
| 599 |
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); |
| 600 |
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); |
| 601 |
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); |
| 602 |
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); |
| 603 |
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); |
| 604 |
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); |
| 605 |
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); |
| 606 |
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); |
| 607 |
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); |
| 608 |
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); |
| 609 |
|
| 610 |
|
| 611 |
|
| 612 |
|
| 613 |
-- Giả sử bảng đã có dữ liệu
|
| 614 |
-- Tạo CURSOR để duyệt từng dòng
|
| 615 |
DECLARE @STT VARCHAR(15), |
| 616 |
@PRICE_BANK_NAME NVARCHAR(MAX), |
| 617 |
@DVT NVARCHAR(15), |
| 618 |
@REFERENCE_PRICE DECIMAL(18, 2), |
| 619 |
@PRICE_STT_PARENT VARCHAR(15), |
| 620 |
@NOTES NVARCHAR(MAX), |
| 621 |
@VAT DECIMAL(18,2) |
| 622 |
|
| 623 |
DECLARE @l_PRICE_BANK_ID VARCHAR(15), |
| 624 |
@l_PRICE_BANK_CODE NVARCHAR(50) = NULL, |
| 625 |
@l_HH_ID VARCHAR(15), |
| 626 |
@l_FATHER_ID VARCHAR(15), |
| 627 |
@l_UNIT_ID VARCHAR(15) = NULL, |
| 628 |
@CD_ID VARCHAR(15) = NULL, |
| 629 |
@l_STA_GOODS_TYPE_ID VARCHAR(15), |
| 630 |
@l_STA_GOODS_ID VARCHAR(15), |
| 631 |
@p_STA_GOODS_TYPE_CODE VARCHAR(15), |
| 632 |
@STA_GOODS_GROUP_CODE VARCHAR(15) |
| 633 |
|
| 634 |
|
| 635 |
|
| 636 |
|
| 637 |
DECLARE price_cursor CURSOR FOR
|
| 638 |
SELECT STT, PRICE_BANK_NAME, DVT, REFERENCE_PRICE, PRICE_STT_PARENT, NOTES, VAT
|
| 639 |
FROM #CM_PRICE_BANK |
| 640 |
|
| 641 |
OPEN price_cursor |
| 642 |
FETCH NEXT FROM price_cursor INTO @STT, @PRICE_BANK_NAME, @DVT, @REFERENCE_PRICE, @PRICE_STT_PARENT, @NOTES,@VAT |
| 643 |
|
| 644 |
WHILE @@FETCH_STATUS = 0 |
| 645 |
BEGIN
|
| 646 |
|
| 647 |
|
| 648 |
---------------- INS NGÂN HÀNG GIÁ -----------------------------------------------------------------------
|
| 649 |
EXEC SYS_CodeMasters_Gen 'CM_PRICE_BANK', @l_PRICE_BANK_ID out |
| 650 |
|
| 651 |
|
| 652 |
IF(@STT = 'VI' OR @STT = 'VII' OR @PRICE_STT_PARENT = 'VI' OR @PRICE_STT_PARENT = 'VII') |
| 653 |
BEGIN
|
| 654 |
SET @l_HH_ID = ( SELECT HH_ID FROM CM_HANGHOA WHERE HH_NAME = N'Mực in' ) |
| 655 |
END
|
| 656 |
ELSE
|
| 657 |
BEGIN
|
| 658 |
SET @l_HH_ID = ( SELECT HH_ID FROM CM_HANGHOA WHERE HH_NAME = N'Văn phòng phẩm' ) |
| 659 |
END
|
| 660 |
|
| 661 |
|
| 662 |
IF(@PRICE_STT_PARENT IS NOT NULL AND @PRICE_STT_PARENT <> '') |
| 663 |
BEGIN
|
| 664 |
SET @l_FATHER_ID = (SELECT cpb.PRICE_BANK_ID FROM CM_PRICE_BANK cpb WHERE cpb.NOTES = @PRICE_STT_PARENT) |
| 665 |
END
|
| 666 |
ELSE
|
| 667 |
BEGIN
|
| 668 |
IF(@PRICE_STT_PARENT = 'I' OR @STT = 'I' OR @PRICE_STT_PARENT = 'VI' OR @STT = 'VI' OR @PRICE_STT_PARENT = 'VII' OR @STT = 'VII') |
| 669 |
BEGIN
|
| 670 |
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') |
| 671 |
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') |
| 672 |
END
|
| 673 |
ELSE IF (@PRICE_STT_PARENT = 'II' OR @STT = 'II') |
| 674 |
BEGIN
|
| 675 |
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') |
| 676 |
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') |
| 677 |
END
|
| 678 |
ELSE IF (@PRICE_STT_PARENT = 'III' OR @STT = 'III') |
| 679 |
BEGIN
|
| 680 |
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ỹ') |
| 681 |
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ỹ') |
| 682 |
END
|
| 683 |
ELSE IF (@PRICE_STT_PARENT = 'IV' OR @STT = 'IV') |
| 684 |
BEGIN
|
| 685 |
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') |
| 686 |
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') |
| 687 |
END
|
| 688 |
ELSE IF (@PRICE_STT_PARENT = 'V' OR @STT = 'V') |
| 689 |
BEGIN
|
| 690 |
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') |
| 691 |
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') |
| 692 |
END
|
| 693 |
|
| 694 |
|
| 695 |
EXEC SYS_CodeMasters_Gen 'STA_GOODS_TYPE', @l_STA_GOODS_TYPE_ID OUT |
| 696 |
|
| 697 |
-- Tạo mã nhóm hàng hóa
|
| 698 |
EXEC STA_GOODS_TYPE_NO_Gen @STA_GOODS_GROUP_CODE, @p_STA_GOODS_TYPE_CODE OUT; |
| 699 |
PRINT @STA_GOODS_GROUP_CODE
|
| 700 |
|
| 701 |
SET @NOTES = @PRICE_STT_PARENT |
| 702 |
INSERT INTO [dbo].[STA_GOODS_TYPE] |
| 703 |
([STA_GOODS_TYPE_ID] |
| 704 |
,[STA_GOODS_TYPE_CODE] |
| 705 |
,[STA_GOODS_TYPE_NAME] |
| 706 |
,[STA_GOODS_GROUP_ID] |
| 707 |
,[NOTES] |
| 708 |
,[RECORD_STATUS] |
| 709 |
,[AUTH_STATUS] |
| 710 |
,[MAKER_ID] |
| 711 |
,[CREATE_DT] |
| 712 |
,[CHECKER_ID] |
| 713 |
,[APPROVE_DT] |
| 714 |
,[BRANCH_ID] |
| 715 |
,[DEP_ID]) |
| 716 |
VALUES
|
| 717 |
( |
| 718 |
@l_STA_GOODS_TYPE_ID,
|
| 719 |
@p_STA_GOODS_TYPE_CODE,
|
| 720 |
@PRICE_BANK_NAME,
|
| 721 |
@l_STA_GOODS_GROUP_ID,
|
| 722 |
'',
|
| 723 |
'1',
|
| 724 |
'A',
|
| 725 |
'admin',
|
| 726 |
CONVERT(DATETIME, GETDATE(), 103), |
| 727 |
NULL,
|
| 728 |
NULL,
|
| 729 |
NULL,
|
| 730 |
NULL
|
| 731 |
) |
| 732 |
END
|
| 733 |
|
| 734 |
SELECT @l_UNIT_ID = cu.UNIT_ID FROM CM_UNIT cu WHERE cu.UNIT_NAME = @DVT |
| 735 |
IF(@l_UNIT_ID is null OR @l_UNIT_ID = '') |
| 736 |
BEGIN
|
| 737 |
|
| 738 |
EXEC SYS_CodeMasters_Gen 'CM_UNIT', @l_UNIT_ID OUT |
| 739 |
|
| 740 |
INSERT INTO CM_UNIT([UNIT_ID],[UNIT_CODE],[UNIT_NAME],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT]) |
| 741 |
VALUES(@l_UNIT_ID ,'' ,@DVT ,'IMPORT' ,'1' ,'admin' ,CONVERT(DATETIME, GETDATE(), 103) ,'A' ,'admin' ,CONVERT(DATETIME, GETDATE(), 103) ) |
| 742 |
END
|
| 743 |
IF @PRICE_STT_PARENT IS NULL OR @PRICE_STT_PARENT = '' |
| 744 |
BEGIN
|
| 745 |
SET @NOTES = @STT |
| 746 |
END
|
| 747 |
-- Tạo mã code ngân hàng giá
|
| 748 |
SET @l_PRICE_BANK_CODE = 'NHG' + RIGHT(@l_PRICE_BANK_ID, 7) |
| 749 |
-- Thực hiện xử lý với từng dòng ở đây
|
| 750 |
INSERT INTO [dbo].[CM_PRICE_BANK] |
| 751 |
([PRICE_BANK_ID] |
| 752 |
,[PRICE_BANK_CODE] |
| 753 |
,[PRICE_BANK_NAME] |
| 754 |
,[HH_ID] |
| 755 |
,[FATHER_ID] |
| 756 |
,[REFERENCE_PRICE] |
| 757 |
,[UNIT_ID] |
| 758 |
,[IS_STATIONERY] |
| 759 |
,[NOTES] |
| 760 |
,[RECORD_STATUS] |
| 761 |
,[MAKER_ID] |
| 762 |
,[CREATE_DT] |
| 763 |
,[CHECKER_ID] |
| 764 |
,[APPROVE_DT] |
| 765 |
,[AUTH_STATUS]) |
| 766 |
VALUES
|
| 767 |
( |
| 768 |
@l_PRICE_BANK_ID,
|
| 769 |
@l_PRICE_BANK_CODE,
|
| 770 |
@PRICE_BANK_NAME,
|
| 771 |
@l_HH_ID,
|
| 772 |
@l_FATHER_ID,
|
| 773 |
@REFERENCE_PRICE,
|
| 774 |
@l_UNIT_ID,
|
| 775 |
'1',
|
| 776 |
@NOTES,
|
| 777 |
'1',
|
| 778 |
'admin',
|
| 779 |
CONVERT(DATETIME, GETDATE(), 103), |
| 780 |
'admin',
|
| 781 |
CONVERT(DATETIME, GETDATE(), 103), |
| 782 |
'A'
|
| 783 |
) |
| 784 |
|
| 785 |
|
| 786 |
IF(@PRICE_STT_PARENT = 'I' OR @STT = 'I') |
| 787 |
BEGIN
|
| 788 |
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') |
| 789 |
END
|
| 790 |
ELSE IF (@PRICE_STT_PARENT = 'II' OR @STT = 'II') |
| 791 |
BEGIN
|
| 792 |
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') |
| 793 |
END
|
| 794 |
ELSE IF (@PRICE_STT_PARENT = 'III' OR @STT = 'III') |
| 795 |
BEGIN
|
| 796 |
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Ỹ') |
| 797 |
END
|
| 798 |
ELSE IF (@PRICE_STT_PARENT = 'IV' OR @STT = 'IV') |
| 799 |
BEGIN
|
| 800 |
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') |
| 801 |
END
|
| 802 |
ELSE IF (@PRICE_STT_PARENT = 'V' OR @STT = 'V') |
| 803 |
BEGIN
|
| 804 |
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') |
| 805 |
END
|
| 806 |
ELSE IF (@PRICE_STT_PARENT = 'VI' OR @STT = 'VI') |
| 807 |
BEGIN
|
| 808 |
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') |
| 809 |
END
|
| 810 |
ELSE IF (@PRICE_STT_PARENT = 'VII' OR @STT = 'VII') |
| 811 |
BEGIN
|
| 812 |
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') |
| 813 |
END
|
| 814 |
|
| 815 |
|
| 816 |
|
| 817 |
|
| 818 |
--------- Insert VPP vào TRC -----
|
| 819 |
IF(@PRICE_STT_PARENT = 'VII' OR @STT = 'VII' OR @PRICE_STT_PARENT = 'VI' OR @STT = 'VI') |
| 820 |
BEGIN
|
| 821 |
SELECT @l_HH_ID = HH_ID FROM CM_HANGHOA WHERE HH_NAME = N'Mực in' |
| 822 |
EXEC SYS_CodeMasters_Gen 'TR_CONTRACT_DT', @CD_ID out |
| 823 |
|
| 824 |
--EXEC TR_CONTRACT_DT_Ins @P_CONTRACT_ID,@GOODS_ID,@UNIT_ID,@QUANTITY,@PRICE,@NOTES,@p_RECORD_STATUS,
|
| 825 |
--@p_MAKER_ID,@p_CREATE_DT,@p_AUTH_STATUS,@p_CHECKER_ID,@p_APPROVE_DT
|
| 826 |
--ELSE
|
| 827 |
INSERT INTO TR_CONTRACT_DT([CD_ID],[CONTRACT_ID],[GOODS_ID],[UNIT_ID],[QUANTITY],[PRICE],TOTAL_VAT,PRICE_VAT,VAT,[NOTES], |
| 828 |
[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) |
| 829 |
VALUES(@CD_ID ,@l_CONTRACT_MI_ID, |
| 830 |
@l_HH_ID ,
|
| 831 |
@l_UNIT_ID ,
|
| 832 |
1 ,
|
| 833 |
@REFERENCE_PRICE ,@REFERENCE_PRICE + @REFERENCE_PRICE*@VAT/100,@REFERENCE_PRICE*@VAT/100,@VAT, |
| 834 |
'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) |
| 835 |
|
| 836 |
END
|
| 837 |
ELSE
|
| 838 |
BEGIN
|
| 839 |
SELECT @l_HH_ID = HH_ID, @l_UNIT_ID = UNIT_ID FROM CM_HANGHOA WHERE HH_NAME = N'Văn phòng phẩm' |
| 840 |
EXEC SYS_CodeMasters_Gen 'TR_CONTRACT_DT', @CD_ID out |
| 841 |
INSERT INTO TR_CONTRACT_DT([CD_ID],[CONTRACT_ID],[GOODS_ID],[UNIT_ID],[QUANTITY],[PRICE],TOTAL_VAT,PRICE_VAT,VAT,[NOTES], |
| 842 |
[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) |
| 843 |
VALUES(@CD_ID ,@l_CONTRACT_VPP_ID, |
| 844 |
@l_HH_ID ,
|
| 845 |
@l_UNIT_ID ,
|
| 846 |
1 ,
|
| 847 |
@REFERENCE_PRICE ,@REFERENCE_PRICE + @REFERENCE_PRICE*@VAT/100,@REFERENCE_PRICE*@VAT/100,@VAT, |
| 848 |
'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) |
| 849 |
END
|
| 850 |
|
| 851 |
|
| 852 |
--------- Insert VPP vào TRC -----
|
| 853 |
|
| 854 |
-------------------------- INSERT vào DT loại hàng hóa ---------------------------------
|
| 855 |
EXEC SYS_CodeMasters_Gen 'STA_GOODS', @l_STA_GOODS_ID OUT |
| 856 |
|
| 857 |
|
| 858 |
INSERT INTO [dbo].[STA_GOODS] |
| 859 |
([STA_GOODS_ID] |
| 860 |
,[STA_GOODS_TYPE_ID] |
| 861 |
,[GOODS_ID]) |
| 862 |
VALUES (@l_STA_GOODS_ID, |
| 863 |
@l_STA_GOODS_TYPE_ID,
|
| 864 |
@l_PRICE_BANK_ID
|
| 865 |
|
| 866 |
) |
| 867 |
-------------------------- INSERT vào DT loại hàng hóa ---------------------------------
|
| 868 |
-- FETCH dòng tiếp theo
|
| 869 |
FETCH NEXT FROM price_cursor INTO @STT, @PRICE_BANK_NAME, @DVT, @REFERENCE_PRICE, @PRICE_STT_PARENT, @NOTES,@VAT |
| 870 |
---------------- INS NGÂN HÀNG GIÁ -----------------------------------------------------------------------
|
| 871 |
|
| 872 |
|
| 873 |
|
| 874 |
END
|
| 875 |
|
| 876 |
CLOSE price_cursor |
| 877 |
DEALLOCATE price_cursor |
| 878 |
DROP TABLE #CM_PRICE_BANK |
| 879 |
DROP TABLE #STA_GOODS_GROUP |