|
1
|
INSERT INTO CM_UNIT (UNIT_ID, UNIT_CODE, UNIT_NAME, NOTES, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT) VALUES
|
|
2
|
('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)),
|
|
3
|
('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)),
|
|
4
|
('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)),
|
|
5
|
('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)),
|
|
6
|
('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)),
|
|
7
|
('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)),
|
|
8
|
('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)),
|
|
9
|
('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)),
|
|
10
|
('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)),
|
|
11
|
('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)),
|
|
12
|
('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))
|
|
13
|
GO
|
|
14
|
UPDATE SYS_CODEMASTERS SET CurValue = 59 WHERE Prefix = 'CMU'
|
|
15
|
GO
|
|
16
|
DELETE ENTRIES_POST_ACCNO_MW
|
|
17
|
INSERT INTO ENTRIES_POST_ACCNO_MW (ACC_TYPE, ACC_NO, GROUP_ID, AC_CCY, NOTES, IS_SUM, WARE_CODE) VALUES
|
|
18
|
('PAY_VL01', '852001001', 'MWG000000042011', NULL, N'Chi trang phuc giao dich', NULL, NULL),
|
|
19
|
('PAY_VL03', '861101001', 'MWG000000042012', NULL, N'Chi van phong pham', NULL, NULL),
|
|
20
|
('PAY_VL04', '861101003', 'MWG000000042013', NULL, N'Chi vat dung van phong khac', NULL, NULL),
|
|
21
|
('PAY_VL05', '861201005', 'MWG000000042014', NULL, N'Giay to in van phong', NULL, NULL),
|
|
22
|
('PAY_VL06', '861201002', 'MWG000000042015', NULL, N'Chi an chi thong thuong, bieu mau, bia thu', NULL, NULL),
|
|
23
|
('PAY_VL07', '861201001', 'MWG000000042016', NULL, N'Chi an chi co gia', 1, NULL),
|
|
24
|
('PAY_VL08', '861201002', 'MWG000000042017', NULL, N'Chi an chi thong thuong, bieu mau, bia thu', NULL, NULL),
|
|
25
|
('PAY_VL10', '861901003', 'MWG000000042018', NULL, N'Chi vat tu thiet bi tin hoc', NULL, NULL),
|
|
26
|
('PAY_VL12', '866001001', 'MWG000000042019', NULL, N'Chi in an tai lieu quang cao', NULL, NULL),
|
|
27
|
('PAY_VL14', '861101002', 'MWG000000042020', NULL, N'Chi muc in, muc photo', NULL, NULL),
|
|
28
|
('PAY_VL15', NULL, 'MWG000000042021', NULL, NULL, NULL, NULL),
|
|
29
|
('PAY_VL16', '861201004', 'MWG000000042022', NULL, N'Chi vat lieu the', NULL, NULL),
|
|
30
|
('PAY_VL17', '861201003', 'MWG000000042023', NULL, N'Chi phoi the', NULL, NULL),
|
|
31
|
('PAY_VL18', '861201003', 'MWG000000042024', NULL, N'Chi phoi the', NULL, NULL),
|
|
32
|
('TRANS_01AC', '313001002', NULL, NULL, N'Tai khoan chuyen Kho an chi quan trong', 1, '01AC'),
|
|
33
|
('TRANS_02TE', '313002002', NULL, NULL, N'Tai khoan chuyen Kho phoi the trang', 1, '02TE'),
|
|
34
|
('TRANS_03CT', '313002002', NULL, NULL, N'Tai khoan chuyen Kho phoi the ca the hoa', 1, '03CT'),
|
|
35
|
('TRANS_04VT', '313003002', NULL, NULL, N'Tai khoan chuyen Kho vat lieu the', 1, '04VT'),
|
|
36
|
('TRANS_05KM', '313004002', NULL, NULL, N'Tai khoan chuyen Kho qua tang khuyen mai', 1, '05KM'),
|
|
37
|
('TRANS_06QT', '313004002', NULL, NULL, N'Tai khoan chuyen Kho qua tang khach hang', 1, '06QT'),
|
|
38
|
('TRANS_07TT', '313004002', NULL, NULL, N'Tai khoan chuyen Kho qua tang tiep thi', 1, '07TT'),
|
|
39
|
('TRANS_08NV', '313004002', NULL, NULL, N'Tai khoan chuyen Kho qua tang nhan vien', 1, '08NV'),
|
|
40
|
('TRANS_09GT', '313004002', NULL, NULL, N'Tai khoan chuyen Kho qua giao te', 1, '09GT'),
|
|
41
|
('TRANS_10AP', '313005002', NULL, NULL, N'Tai khoan chuyen Kho an pham, an chi thong thuong', 1, '10AP'),
|
|
42
|
('TRANS_11VL', '313005002', NULL, NULL, N'Tai khoan chuyen Kho vat lieu khac', 1, '11VL'),
|
|
43
|
('WAR_01AC', '313001001', NULL, NULL, N'Tai khoan Kho an chi quan trong', 1, '01AC'),
|
|
44
|
('WAR_02TE', '313002001', NULL, NULL, N'Tai khoan Kho phoi the trang', 1, '02TE'),
|
|
45
|
('WAR_03CT', '313002001', NULL, NULL, N'Tai khoan Kho phoi the ca the hoa', 1, '03CT'),
|
|
46
|
('WAR_04VT', '313003001', NULL, NULL, N'Tai khoan Kho vat lieu the', 1, '04VT'),
|
|
47
|
('WAR_05KM', '313004001', NULL, NULL, N'Tai khoan Kho qua tang khuyen mai', 1, '05KM'),
|
|
48
|
('WAR_06QT', '313004001', NULL, NULL, N'Tai khoan Kho qua tang khach hang', 1, '06QT'),
|
|
49
|
('WAR_07TT', '313004001', NULL, NULL, N'Tai khoan Kho qua tang tiep thi', 1, '07TT'),
|
|
50
|
('WAR_08NV', '313004001', NULL, NULL, N'Tai khoan Kho qua tang nhan vien', 1, '08NV'),
|
|
51
|
('WAR_09GT', '313004001', NULL, NULL, N'Tai khoan Kho qua giao te', 1, '09GT'),
|
|
52
|
('WAR_10AP', '313005001', NULL, NULL, N'Tai khoan Kho an pham, an chi thong thuong', 1, '10AP'),
|
|
53
|
('WAR_11VL', '313005001', NULL, NULL, N'Tai khoan Kho vat lieu khac', 1, '11VL'),
|
|
54
|
('ACC_VAT_NEC', '453101001', '', 'LCY', N'Thue gia tri gia tang phai nop', 1, NULL),
|
|
55
|
('ACC_VAT_PROMO_NEC', '453101002', '', 'LCY', N'Thue gia tri gia tang phai nop qua tang khuyen mai', 1, NULL),
|
|
56
|
('ASSET_CCLD_N', '519901001', '', 'LCY', N'Dieu chuyen von', 1, NULL),
|
|
57
|
('ACC_VAT_NEC', '452101001', '', 'LCY', N'Phai tra nguoi ban', 1, NULL),
|
|
58
|
('ACC_VAT_PROMO_NEC', '452101002', '', 'LCY', N'Thue gia tri gia tang phai nop qua tang khuyen mai', 1, NULL),
|
|
59
|
('KSV_OUT', '361902001', NULL, 'LCY', N'Cac khoan phai thu CBNV lien quan den qua tang', 1, NULL),
|
|
60
|
('PAY_EXCEP', '89901008', NULL, 'LCY', N'Chi phi loai tru', 1, NULL),
|
|
61
|
('PAY_EXCEP', '869901008', NULL, 'LCY', N'Chi phi khong duoc khau tru thue', 1, NULL),
|
|
62
|
('PAY_VL11', '866001006', NULL, 'LCY', N'Chi khuyen mai khac khong dang ky chuong trinh khuyen mai', 1, NULL),
|
|
63
|
('SYNC_QLQT', '866001005', NULL, 'LCY', N'Chi khuyen mai co dang ky chuong trinh khuyen mai', 1, '05KM'),
|
|
64
|
('PAY_HS', '466201001', '', 'LCY', N'Cac khoan phai tra Hoi so chinh', 1, NULL),
|
|
65
|
('LIQ_EXP', '790001003', NULL, NULL, N'Thu thanh ly vat lieu', 1, NULL),
|
|
66
|
('LIQ', '899001003', NULL, NULL, N'Chi thanh ly vat lieu', 1, NULL)
|
|
67
|
|