INSERT INTO CM_UNIT (UNIT_ID, UNIT_CODE, UNIT_NAME, NOTES, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT) VALUES
('CMU000000000045', '45', N'Cuốn', N'', '1', 'admin', CONVERT(DATETIME, '2015-01-20 11:18:58.207', 121), 'A', 'admin', CONVERT(DATETIME, '2015-01-20 11:18:58.207', 121)),
('CMU000000000046', '46', N'Cuộn', N'', '1', 'admin', CONVERT(DATETIME, '2015-01-20 11:18:58.207', 121), 'A', 'admin', CONVERT(DATETIME, '2015-01-20 11:18:58.207', 121)),
('CMU000000000047', '47', N'Ream', N'', '1', 'admin', CONVERT(DATETIME, '2015-01-20 11:18:58.207', 121), 'A', 'admin', CONVERT(DATETIME, '2015-01-20 11:18:58.207', 121)),
('CMU000000000048', '48', N'Hộp', N'', '1', 'admin', CONVERT(DATETIME, '2015-01-20 11:18:58.207', 121), 'A', 'admin', CONVERT(DATETIME, '2015-01-20 11:18:58.207', 121)),
('CMU000000000049', '49', N'Tờ', N'', '1', 'admin', CONVERT(DATETIME, '2015-01-20 11:18:58.207', 121), 'A', 'admin', CONVERT(DATETIME, '2015-01-20 11:18:58.207', 121)),
('CMU000000000050', '50', N'Cây', N'', '1', 'admin', CONVERT(DATETIME, '2015-01-20 11:18:58.207', 121), 'A', 'admin', CONVERT(DATETIME, '2015-01-20 11:18:58.207', 121)),
('CMU000000000051', '51', N'Bao', N'', '1', 'admin', CONVERT(DATETIME, '2015-01-20 11:18:58.207', 121), 'A', 'admin', CONVERT(DATETIME, '2015-01-20 11:18:58.207', 121)),
('CMU000000000052', '52', N'Bộ trà cao cấp DONGHWA', N'', '1', 'admin', CONVERT(DATETIME, '2015-01-20 11:18:58.207', 121), 'A', 'admin', CONVERT(DATETIME, '2015-01-20 11:18:58.207', 121)),
('CMU000000000057', '57', N'Dây', NULL, '1', 'nghianh', CONVERT(DATETIME, '2023-11-01 10:33:25.000', 121), 'A', 'bichnn0500', CONVERT(DATETIME, '2023-11-01 10:33:44.000', 121)),
('CMU000000000058', '58', N'Kg', N'kilogram', '1', 'nghianh', CONVERT(DATETIME, '2023-11-01 10:36:36.000', 121), 'A', 'bichnn0500', CONVERT(DATETIME, '2023-11-01 10:36:40.000', 121)),
('CMU000000000059', '59', N'Thẻ', N'thẻ', '1', 'nghianh', CONVERT(DATETIME, '2023-11-01 10:39:10.000', 121), 'A', 'bichnn0500', CONVERT(DATETIME, '2023-11-01 10:39:14.000', 121))
GO
UPDATE SYS_CODEMASTERS SET CurValue = 59 WHERE Prefix = 'CMU'
GO
DELETE ENTRIES_POST_ACCNO_MW
INSERT INTO ENTRIES_POST_ACCNO_MW (ACC_TYPE, ACC_NO, GROUP_ID, AC_CCY, NOTES, IS_SUM, WARE_CODE) VALUES
('PAY_VL01', '852001001', 'MWG000000042011', NULL, N'Chi trang phuc giao dich', NULL, NULL),
('PAY_VL03', '861101001', 'MWG000000042012', NULL, N'Chi van phong pham', NULL, NULL),
('PAY_VL04', '861101003', 'MWG000000042013', NULL, N'Chi vat dung van phong khac', NULL, NULL),
('PAY_VL05', '861201005', 'MWG000000042014', NULL, N'Giay to in van phong', NULL, NULL),
('PAY_VL06', '861201002', 'MWG000000042015', NULL, N'Chi an chi thong thuong, bieu mau, bia thu', NULL, NULL),
('PAY_VL07', '861201001', 'MWG000000042016', NULL, N'Chi an chi co gia', 1, NULL),
('PAY_VL08', '861201002', 'MWG000000042017', NULL, N'Chi an chi thong thuong, bieu mau, bia thu', NULL, NULL),
('PAY_VL10', '861901003', 'MWG000000042018', NULL, N'Chi vat tu thiet bi tin hoc', NULL, NULL),
('PAY_VL12', '866001001', 'MWG000000042019', NULL, N'Chi in an tai lieu quang cao', NULL, NULL),
('PAY_VL14', '861101002', 'MWG000000042020', NULL, N'Chi muc in, muc photo', NULL, NULL),
('PAY_VL15', NULL, 'MWG000000042021', NULL, NULL, NULL, NULL),
('PAY_VL16', '861201004', 'MWG000000042022', NULL, N'Chi vat lieu the', NULL, NULL),
('PAY_VL17', '861201003', 'MWG000000042023', NULL, N'Chi phoi the', NULL, NULL),
('PAY_VL18', '861201003', 'MWG000000042024', NULL, N'Chi phoi the', NULL, NULL),
('TRANS_01AC', '313001002', NULL, NULL, N'Tai khoan chuyen Kho an chi quan trong', 1, '01AC'),
('TRANS_02TE', '313002002', NULL, NULL, N'Tai khoan chuyen Kho phoi the trang', 1, '02TE'),
('TRANS_03CT', '313002002', NULL, NULL, N'Tai khoan chuyen Kho phoi the ca the hoa', 1, '03CT'),
('TRANS_04VT', '313003002', NULL, NULL, N'Tai khoan chuyen Kho vat lieu the', 1, '04VT'),
('TRANS_05KM', '313004002', NULL, NULL, N'Tai khoan chuyen Kho qua tang khuyen mai', 1, '05KM'),
('TRANS_06QT', '313004002', NULL, NULL, N'Tai khoan chuyen Kho qua tang khach hang', 1, '06QT'),
('TRANS_07TT', '313004002', NULL, NULL, N'Tai khoan chuyen Kho qua tang tiep thi', 1, '07TT'),
('TRANS_08NV', '313004002', NULL, NULL, N'Tai khoan chuyen Kho qua tang nhan vien', 1, '08NV'),
('TRANS_09GT', '313004002', NULL, NULL, N'Tai khoan chuyen Kho qua giao te', 1, '09GT'),
('TRANS_10AP', '313005002', NULL, NULL, N'Tai khoan chuyen Kho an pham, an chi thong thuong', 1, '10AP'),
('TRANS_11VL', '313005002', NULL, NULL, N'Tai khoan chuyen Kho vat lieu khac', 1, '11VL'),
('WAR_01AC', '313001001', NULL, NULL, N'Tai khoan Kho an chi quan trong', 1, '01AC'),
('WAR_02TE', '313002001', NULL, NULL, N'Tai khoan Kho phoi the trang', 1, '02TE'),
('WAR_03CT', '313002001', NULL, NULL, N'Tai khoan Kho phoi the ca the hoa', 1, '03CT'),
('WAR_04VT', '313003001', NULL, NULL, N'Tai khoan Kho vat lieu the', 1, '04VT'),
('WAR_05KM', '313004001', NULL, NULL, N'Tai khoan Kho qua tang khuyen mai', 1, '05KM'),
('WAR_06QT', '313004001', NULL, NULL, N'Tai khoan Kho qua tang khach hang', 1, '06QT'),
('WAR_07TT', '313004001', NULL, NULL, N'Tai khoan Kho qua tang tiep thi', 1, '07TT'),
('WAR_08NV', '313004001', NULL, NULL, N'Tai khoan Kho qua tang nhan vien', 1, '08NV'),
('WAR_09GT', '313004001', NULL, NULL, N'Tai khoan Kho qua giao te', 1, '09GT'),
('WAR_10AP', '313005001', NULL, NULL, N'Tai khoan Kho an pham, an chi thong thuong', 1, '10AP'),
('WAR_11VL', '313005001', NULL, NULL, N'Tai khoan Kho vat lieu khac', 1, '11VL'),
('ACC_VAT_NEC', '453101001', '', 'LCY', N'Thue gia tri gia tang phai nop', 1, NULL),
('ACC_VAT_PROMO_NEC', '453101002', '', 'LCY', N'Thue gia tri gia tang phai nop qua tang khuyen mai', 1, NULL),
('ASSET_CCLD_N', '519901001', '', 'LCY', N'Dieu chuyen von', 1, NULL),
('ACC_VAT_NEC', '452101001', '', 'LCY', N'Phai tra nguoi ban', 1, NULL),
('ACC_VAT_PROMO_NEC', '452101002', '', 'LCY', N'Thue gia tri gia tang phai nop qua tang khuyen mai', 1, NULL),
('KSV_OUT', '361902001', NULL, 'LCY', N'Cac khoan phai thu CBNV lien quan den qua tang', 1, NULL),
('PAY_EXCEP', '89901008', NULL, 'LCY', N'Chi phi loai tru', 1, NULL),
('PAY_EXCEP', '869901008', NULL, 'LCY', N'Chi phi khong duoc khau tru thue', 1, NULL),
('PAY_VL11', '866001006', NULL, 'LCY', N'Chi khuyen mai khac khong dang ky chuong trinh khuyen mai', 1, NULL),
('SYNC_QLQT', '866001005', NULL, 'LCY', N'Chi  khuyen mai co dang ky chuong trinh khuyen mai', 1, '05KM'),
('PAY_HS', '466201001', '', 'LCY', N'Cac khoan phai tra Hoi so chinh', 1, NULL),
('LIQ_EXP', '790001003', NULL, NULL, N'Thu thanh ly vat lieu', 1, NULL),
('LIQ', '899001003', NULL, NULL, N'Chi thanh ly vat lieu', 1, NULL)