|
1
|
DELETE FROM CM_ALLCODE
|
|
2
|
|
|
3
|
SET IDENTITY_INSERT CM_ALLCODE ON
|
|
4
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1,N'TRTYPE',N'0',N'Trong KH',N'TR',NULL)
|
|
5
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(2,N'TRTYPE',N'1',N'Ngoài KH',N'TR',NULL)
|
|
6
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(5,N'STATUS',N'N',N'Nhập mới',N'PL',NULL)
|
|
7
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(6,N'STATUS',N'P',N'Đã gửi',N'PL',NULL)
|
|
8
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(7,N'STATUS',N'U',N'Chờ duyệt',N'PL',NULL)
|
|
9
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(8,N'STATUS',N'A',N'Đã duyệt',N'PL',NULL)
|
|
10
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(9,N'FORM',N'DT',N'Đấu thầu',N'TR',NULL)
|
|
11
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(10,N'FORM',N'CD',N'Chỉ định',N'TR',NULL)
|
|
12
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(11,N'FORM',N'C',N'Tiền mặt',N'CONT',NULL)
|
|
13
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(12,N'FORM',N'L',N'Chứng thư',N'CONT',NULL)
|
|
14
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(13,N'PAYMENT_STATUS',N'TT',N'Thanh toán',N'TR',NULL)
|
|
15
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(14,N'PAYMENT_STATUS',N'CTT',N'Chưa thanh toán',N'TR',NULL)
|
|
16
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(15,N'PAYMENT_STATUS',N'TT1P',N'Thanh toán 1 phần',N'TR',NULL)
|
|
17
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(28,N'CONSTRUCT_TYPE',N'XM',N'Xây mới',N'CON',NULL)
|
|
18
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(29,N'CONSTRUCT_TYPE',N'SC',N'Sửa chữa',N'CON',NULL)
|
|
19
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(31,N'INSU_TYPE',N'BHVC',N'Bảo hiểm vật chất',N'CAR',NULL)
|
|
20
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(32,N'CHARG_TYPE',N'PDB',N'Phí đường bộ',N'CAR',NULL)
|
|
21
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(33,N'CHARG_TYPE',N'PHK',N'Phí hàng không',N'CAR',NULL)
|
|
22
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(34,N'DIVISION_REP_DI',N'SCB',N'Sacombank',N'CAR',NULL)
|
|
23
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(35,N'DIVISION_REP_DI',N'ACB',N'ACB',N'CAR',NULL)
|
|
24
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(36,N'OFFER_PERSON',N'GD',N'Giam Doc',N'CAR',NULL)
|
|
25
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(37,N'OFFER_PERSON',N'TP',N'Truong Phong',N'CAR',NULL)
|
|
26
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(38,N'OFFER_PERSON',N'PGD',N'Pho Giam Doc',N'CAR',NULL)
|
|
27
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(39,N'MAINT_PROVIDER',N'SCB',N'INNOVA',N'CAR',NULL)
|
|
28
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(40,N'MAINT_PROVIDER',N'JUP',N'TOYOTA',N'CAR',NULL)
|
|
29
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(41,N'RET_TYPE',N'N',N'Nhà',N'RET',NULL)
|
|
30
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(42,N'RET_TYPE',N'D',N'Đất',N'RET',NULL)
|
|
31
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(43,N'LIQUI_TYPE',N'1',N'Thanh lý toàn bộ',N'ASS',NULL)
|
|
32
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(44,N'LIQUI_TYPE',N'0',N'Thanh lý một phần',N'ASS',NULL)
|
|
33
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(45,N'DISCIPLINES',N'CAR',N'Xe',N'SUP',NULL)
|
|
34
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(46,N'DISCIPLINES',N'CON',N'Xây dựng',N'SUP',NULL)
|
|
35
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(47,N'DISCIPLINES',N'VLXD',N'Vật liệu xây dựng',N'SUP',NULL)
|
|
36
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(48,N'DISCIPLINES',N'TBVP',N'Thiết bị văn phòng',N'SUP',NULL)
|
|
37
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(49,N'DISCIPLINES',N'TBMT',N'Thiết bị máy tính',N'SUP',NULL)
|
|
38
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(50,N'ASS_CAT',N'CAR',N'Xe',N'ASS_GROUP',NULL)
|
|
39
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(51,N'ASS_CAT',N'NORM',N'TSCD/CCLD',N'ASS_GROUP',NULL)
|
|
40
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(52,N'ASS_CAT',N'RET',N'BĐS',N'ASS_GROUP',NULL)
|
|
41
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(53,N'ASS_CAT',N'SOFT',N'Bản quyền phần mềm',N'ASS_GROUP',NULL)
|
|
42
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(55,N'RET_STATUS',N'DHT',N'Đã hoàn công',N'RET',NULL)
|
|
43
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(56,N'RET_STATUS',N'CHT',N'Chưa hoàn công',N'RET',NULL)
|
|
44
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(57,N'RET_PURPOSE',N'DV',N'Đất vườn',N'RET',NULL)
|
|
45
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(58,N'RET_PURPOSE',N'TC',N'Thổ cư',N'RET',NULL)
|
|
46
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(61,N'USE_STATUS',N'D',N'Đã sử dụng',N'RET',NULL)
|
|
47
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(62,N'USE_STATUS',N'C',N'Chưa sử dụng',N'RET',NULL)
|
|
48
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(63,N'DISCIPLINES',N'OTHER',N'Khác',N'SUP',NULL)
|
|
49
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(66,N'CONST_STATUS',N'XD',N'Xây dựng',N'RET',NULL)
|
|
50
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(67,N'CONST_STATUS',N'SC',N'Sửa chữa',N'RET',NULL)
|
|
51
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(68,N'CONST_STATUS',N'XD/SC',N'Đang XD/SC',N'RET',NULL)
|
|
52
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(69,N'OWNER_TYPE',N'M',N'Mua',N'RET',NULL)
|
|
53
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(71,N'CAR_PURPOSE',N'Chuyendung',N'Chuyen dung',N'CAR',0)
|
|
54
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(72,N'DATA_TYPE',N'Chr',N'CHARACTER',N'PARA',NULL)
|
|
55
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(73,N'DATA_TYPE',N'Num',N'NUMBER',N'PARA',NULL)
|
|
56
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(74,N'RECORD_STATUS',N'0',N'Không hoạt động',NULL,NULL)
|
|
57
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(75,N'RECORD_STATUS',N'1',N'Hoạt động',NULL,NULL)
|
|
58
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(76,N'RET_PURPOSE',N'DKD',N'Đất kinh doanh',N'RET',NULL)
|
|
59
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(77,N'RET_PURPOSE',N'KH',N'Khác',N'RET',NULL)
|
|
60
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(79,N'PRODUCT_COUNTRY',N'HOAKY',N'HOA KY',N'CAR',0)
|
|
61
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(80,N'ISVALID',N'HL',N'Hợp lệ',N'BID',NULL)
|
|
62
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(81,N'ISVALID',N'KHL',N'Không hợp lệ',N'BID',NULL)
|
|
63
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(84,N'CAR_PURPOSE',N'Vanchuyentien',N'Van chuyen tien',N'CAR',0)
|
|
64
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(85,N'PRODUCT_COUNTRY',N'HANQUOC',N'HAN QUOC',N'CAR',0)
|
|
65
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(86,N'CONST_PURPOSE',N'PGD',N' XD/SC phòng giao dịch',N'CON',NULL)
|
|
66
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(87,N'CONST_PURPOSE',N'CN',N' XD/SC chi nhánh',N'CON',NULL)
|
|
67
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(88,N'CONST_PURPOSE',N'CT',N' XD/SC cho thuê',N'CON',NULL)
|
|
68
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(90,N'INSU_TYPE',N'BHBB',N'Bảo hiểm bắt buộc',N'CAR',NULL)
|
|
69
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(92,N'CAR_PURPOSE',N'PhucvuLD',N'Phuc vu LD',N'CAR',0)
|
|
70
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(93,N'FUELSTYPE',N'Xang',N'Xang',N'CAR',0)
|
|
71
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(94,N'CAR_PURPOSE',N'Congvu',N'Cong vu',N'CAR',0)
|
|
72
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(95,N'GEARBOX_TYPE',N'Sosan',N'So san',N'CAR',0)
|
|
73
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(98,N'GEARBOX_TYPE',N'Sotudong',N'So tu dong',N'CAR',0)
|
|
74
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(99,N'PRODUCT_COUNTRY',N'VIETNAM',N'VIET NAM',N'CAR',0)
|
|
75
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(104,N'PRODUCT_COUNTRY',N'NHATBAN',N'NHAT BAN',N'CAR',0)
|
|
76
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(107,N'FUELSTYPE',N'Dau',N'Dau',N'CAR',0)
|
|
77
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(108,N'PRODUCT_COUNTRY',N'THAILAN',N'THAI LAN',N'CAR',0)
|
|
78
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(113,N'CAR_PURPOSE',N'Khac',N'Khac',N'CAR',0)
|
|
79
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(115,N'GEARBOX_TYPE',N'S?sàn',N'Số sàn',N'CAR',0)
|
|
80
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(116,N'GEARBOX_TYPE',N'S?t?d?ng',N'Số tự động',N'CAR',0)
|
|
81
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(117,N'CONTRACT_STATUS',N'C',N'Hết hiệu lực',N'CONTRACT',0)
|
|
82
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(118,N'CONTRACT_STATUS',N'N',N'Đang hiệu lực',N'CONTRACT',0)
|
|
83
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(119,N'BUSINESS_TYPE',N'BT01',N'Loại hình kinh doanh 1',N'CUSTOMER',0)
|
|
84
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(120,N'BUSINESS_TYPE',N'BT02',N'Loại hình kinh doanh 2',N'CUSTOMER',0)
|
|
85
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(121,N'BUSINESS_TYPE',N'BT03',N'Loại hình kinh doanh 3',N'CUSTOMER',0)
|
|
86
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(122,N'BUSINESS_TYPE',N'BT04',N'Loại hình kinh doanh 4',N'CUSTOMER',0)
|
|
87
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(123,N'AssType',N'TSCD',N'C Tài sản cố định',N'',0)
|
|
88
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(124,N'AssType',N'CCLD',N'C Công cụ lao động',N'',0)
|
|
89
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(125,N'LOGIN_METHOD',N'Normal',N'Mặc định',N'LOGIN_METHOD',0)
|
|
90
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(126,N'LOGIN_METHOD',N'Ldap',N'Đăng nhập theo Ldap',N'LOGIN_METHOD',0)
|
|
91
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(127,N'LOGIN_METHOD',N'Adfs',N'Đăng nhập theo Adfs',N'LOGIN_METHOD',0)
|
|
92
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(128,N'AUTH_STATUS',N'A',N'Đã duyệt',N'AUTH_STATUS',NULL)
|
|
93
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(129,N'AUTH_STATUS',N'U',N'Chờ duyệt',N'AUTH_STATUS',NULL)
|
|
94
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(130,N'BRANCH_TYPE',N'HS',N'HS Hội sở',NULL,NULL)
|
|
95
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(131,N'BRANCH_TYPE',N'KV',N'KV Khu vực',NULL,NULL)
|
|
96
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(132,N'BRANCH_TYPE',N'CN',N'CN Chi nhánh',NULL,NULL)
|
|
97
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(133,N'BRANCH_TYPE',N'PGD',N'PGD Phòng giao dịch',NULL,NULL)
|
|
98
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(135,N'PARAM_DATATYPE',N'Chr',N'CHARACTER',N'CM',NULL)
|
|
99
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(136,N'PARAM_DATATYPE',N'Num',N'NUMBER',N'CM',NULL)
|
|
100
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(137,N'PARAM_DATATYPE',N'Var',N'VARIABLE',N'CM',NULL)
|
|
101
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(143,N'PAGE_SIZE',N'A2',N'Khổ in A2',N'PG',NULL)
|
|
102
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(144,N'PAGE_SIZE',N'A3',N'Khổ in A3',N'PG',NULL)
|
|
103
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(145,N'PAGE_SIZE',N'A4',N'Khổ in A4',N'PG',NULL)
|
|
104
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(146,N'PAGE_SIZE',N'K80',N'Khổ in K80',N'PG',NULL)
|
|
105
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(147,N'PO_BRANCH_TYPE',N'HO',N'PO Hội sở',N'TR',NULL)
|
|
106
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(148,N'PO_BRANCH_TYPE',N'CN',N'PO Đơn vị',N'TR',NULL)
|
|
107
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(149,N'PO_BRANCH_TYPE',N'ALL',N'--Tất cả--',N'TR',NULL)
|
|
108
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(150,N'REPORT_STATUS',N'F,I',N'Đã xuất',N'RPT_STATUS',NULL)
|
|
109
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(151,N'REPORT_STATUS',N'N,E',N'Chưa xuất',N'RPT_STATUS',NULL)
|
|
110
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(152,N'ASS_TYPE',N'CCLD',N'C Công cụ lao động',N'ASS',NULL)
|
|
111
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(153,N'ASS_TYPE',N'TSCD',N'T Tài sản cố định',N'ASS',NULL)
|
|
112
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(154,NULL,NULL,NULL,NULL,NULL)
|
|
113
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(155,N'KT_DO',N'Y',N'Đã cập nhật',N'ASS_MASTER',NULL)
|
|
114
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(156,N'KT_DO',N'N',N'Chưa cập nhật',N'ASS_MASTER',NULL)
|
|
115
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(157,N'DELIVERY_STATUS',N'1',N'Đã giao hàng',N'REPORT',NULL)
|
|
116
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(158,N'DELIVERY_STATUS',N'0',N'Chưa giao hàng',N'REPORT',NULL)
|
|
117
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(159,N'PAYMENT_STATUS',N'DTT',N'Đã thanh toán',N'REPORT',NULL)
|
|
118
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(160,N'PAYMENT_STATUS',N'CTT',N'Chưa thanh toán',N'REPORT',NULL)
|
|
119
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(163,N'REQ_BUDGET',N'0',N'XDCB',N'CON',NULL)
|
|
120
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(164,N'REQ_BUDGET',N'1',N'VPKV',N'CON',NULL)
|
|
121
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(165,N'REQ_BUDGET',N'2',N'CN',N'CON',NULL)
|
|
122
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(166,N'REQ_HQ_TYPE',N'0',N'TSNH',N'CON',NULL)
|
|
123
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(167,N'REQ_HQ_TYPE',N'1',N'Thuê',N'CON',NULL)
|
|
124
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(168,N'CUS_REG_TYPE',N'PC',N'KH Cá nhân',N'CON',NULL)
|
|
125
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(169,N'CUS_REG_TYPE',N'IC',N'KH Doanh nghiệp',N'CON',NULL)
|
|
126
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(170,N'REPORT_STATUS',N'F,E',N'Đã xuất',N'RPT_WAREHOUSE',NULL)
|
|
127
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(171,N'REPORT_STATUS',N'N,I',N'Chưa xuất',N'RPT_WAREHOUSE',NULL)
|
|
128
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(175,N'MANUFACTURER',N'Toyota',N'Toyota',N'CAR',0)
|
|
129
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(176,N'MANUFACTURER',N'Isuzu',N'Isuzu',N'CAR',0)
|
|
130
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(177,N'MANUFACTURER',N'Mitsubishi',N'Mitsubishi',N'CAR',0)
|
|
131
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(178,N'MANUFACTURER',N'Mercedes',N'Mercedes',N'CAR',0)
|
|
132
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(180,N'MANUFACTURER',N'Huyndai',N'Huyndai',N'CAR',0)
|
|
133
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(181,N'MANUFACTURER',N'RollsRoyce',N'Rolls Royce',N'CAR',0)
|
|
134
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(182,N'MANUFACTURER',N'Honda',N'Honda',N'CAR',0)
|
|
135
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(183,N'MANUFACTURER',N'Chevrolet',N'Chevrolet',N'CAR',0)
|
|
136
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(184,N'MANUFACTURER',N'Ford',N'Ford',N'CAR',0)
|
|
137
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(187,N'PO_KIND',N'PO',N'PO thường',N'PO',NULL)
|
|
138
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(188,N'PO_KIND',N'POSC',N'PO sửa chữa',N'PO',NULL)
|
|
139
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(191,N'INSU_TYPE',N'BHDS',N'Bảo hiểm dân sự',N'CAR',NULL)
|
|
140
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(193,N'EXPORT_FORM',N'DCL',N'Điều chuyển luôn',N'WH',NULL)
|
|
141
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(194,N'EXPORT_FORM',N'DCCM',N'Điều chuyển cho mượn/ theo dự án',N'WH',NULL)
|
|
142
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1193,N'RAT_SUP',N'A',N'Rất tốt',N'CRITERIA',NULL)
|
|
143
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1194,N'RAT_SUP',N'B',N'Khá/Tốt',N'CRITERIA',NULL)
|
|
144
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1195,N'RAT_SUP',N'C',N'Trung bình',N'CRITERIA',NULL)
|
|
145
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1196,N'RAT_SUP',N'D',N'Yếu/Kém',N'CRITERIA',NULL)
|
|
146
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1197,N'BUD_REG_ORDER',N'MVA',N'Trống nhiều nhất',N'REPORT',NULL)
|
|
147
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1198,N'BUD_REG_ORDER',N'LVA',N'Trống ít nhất',N'REPORT',NULL)
|
|
148
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1199,N'BUD_REG_ORDER',N'MAR',N'Thuê nhiều nhất',N'REPORT',NULL)
|
|
149
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1200,N'BUD_REG_ORDER',N'LAR',N'Thuê ít nhất',N'REPORT',NULL)
|
|
150
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1201,N'BUD_REG_ORDER',N'MA',N'Thu nhập tốt nhất',N'REPORT',NULL)
|
|
151
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1202,N'BUD_REG_ORDER',N'LA',N'Thu nhập thấp nhất',N'REPORT',NULL)
|
|
152
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1203,N'BUD_REG_ORDER',N'MP',N'Đơn giá cao nhất',N'REPORT',NULL)
|
|
153
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1204,N'BUD_REG_ORDER',N'LP',N'Đơn giá thấp nhất',N'REPORT',NULL)
|
|
154
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1205,N'OWNER_TYPE',N'TCTH',N'Thuê có thời hạn',N'RET',NULL)
|
|
155
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1206,N'USE_FORM',N'R',N'Riêng',N'RET',NULL)
|
|
156
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1207,N'USE_FORM',N'C',N'Chung',N'RET',NULL)
|
|
157
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1208,N'OWNER_TYPE',N'K',N'Khác',N'RET',NULL)
|
|
158
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1209,N'USE_FORM',N'K',N'Khác',N'RET',NULL)
|
|
159
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1210,N'KT_IS_DO',N'N',N'Chưa cập nhật',N'ASS',NULL)
|
|
160
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1211,N'KT_IS_DO',N'Y',N'Đã cập nhật',N'ASS',NULL)
|
|
161
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1212,N'CONTRACT_TYPE',N'MS',N'Hợp đồng mua sắm',N'CONTRACT',NULL)
|
|
162
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1213,N'CONTRACT_TYPE',N'NT',N'Hợp đồng nguyên tắc',N'CONTRACT',NULL)
|
|
163
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1214,N'DRIVE_AMT_TYPE',N'GAS',N'Xăng',N'CAR',NULL)
|
|
164
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1215,N'DRIVE_AMT_TYPE',N'ROAD',N'Cầu đường',N'CAR',NULL)
|
|
165
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1216,N'REQ_CON_TYPE',N'SC',N'Sửa chữa',N'CON',NULL)
|
|
166
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1217,N'REQ_CON_TYPE',N'XM',N'Xây mới',N'CON',NULL)
|
|
167
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1218,N'WHStorage',N'1',N'Cho mượn',N'WHHcqt',NULL)
|
|
168
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1219,N'WHStorage',N'0',N'Tồn kho',N'WHHcqt',NULL)
|
|
169
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1220,N'Goods',N'NS',N'Ngân sách',N'Goods',NULL)
|
|
170
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1221,N'Goods',N'CP',N'Chi phí',N'Goods',NULL)
|
|
171
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1222,N'TRAN_TYPE',N'CDT',N'Chỉ định thầu',N'TRAN_TYPE',NULL)
|
|
172
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1223,N'TRAN_TYPE',N'VCCB',N'Theo quy định VCCB',N'TRAN_TYPE',NULL)
|
|
173
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1224,N'ASS_ADD_AUTH',N'A',N'Đã duyệt',N'ASS_ADDNEW',1)
|
|
174
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1225,N'ASS_ADD_AUTH',N'U',N'Chờ duyệt',N'ASS_ADDNEW',1)
|
|
175
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1226,N'ASS_ADD_AUTH',N'R',N'Từ chối',N'ASS_ADDNEW',1)
|
|
176
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1227,N'ASS_ADD_AUTH',N'D',N'Phiếu bị hủy',N'ASS_ADDNEW',1)
|
|
177
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1228,N'LIMIT',N'ADV_PAY',N'Tạm ứng nội bộ',N'ROLE',0)
|
|
178
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1229,N'MW_CAT',N'GTIN',N'GIẤY TỜ IN - ẤN CHỈ, MẪU BIỂU',N'MW_GROUP',NULL)
|
|
179
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1230,N'MW_CAT',N'TT',N'THẺ',N'MW_GROUP',NULL)
|
|
180
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1231,N'MW_CAT',N'VLTKKHAC',N'VẬT LIỆU TỒN KHO KHÁC',N'MW_GROUP',NULL)
|
|
181
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1232,N'MW_AUTH',N'A',N'Đã duyệt',N'MW',NULL)
|
|
182
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1233,N'MW_AUTH',N'U',N'Chờ duyệt',N'MW',NULL)
|
|
183
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1234,N'MW_AUTH',N'R',N'Từ chối',N'MW',NULL)
|
|
184
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1236,N'WARE_HOUSE_IN',N'HC',N'Hành chính',N'MW_IN',0)
|
|
185
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1237,N'WARE_HOUSE_IN',N'TT',N'Trung tâm thẻ',N'MW_IN',0)
|
|
186
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1238,N'WARE_HOUSE_OUT',N'Y',N'Đã cập nhật',N'MW_OUT',NULL)
|
|
187
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1239,N'WARE_HOUSE_OUT',N'N',N'Chưa cập nhật',N'MW_OUT',NULL)
|
|
188
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1240,N'WARE_HOUSE_TRAN',N'Y',N'Đã xác nhận',N'MW_TRAN',NULL)
|
|
189
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1241,N'WARE_HOUSE_TRAN',N'N',N'Chưa xác nhận',N'MW_TRAN',NULL)
|
|
190
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1242,N'ASS_STATUS',N'1',N'00 Bình Thường',N'ASS_STATUS',1)
|
|
191
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1243,N'ASS_STATUS',N'2',N'01 Hư hỏng',N'ASS_STATUS',2)
|
|
192
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1244,N'ASS_STATUS',N'5',N'99 Khác',N'ASS_STATUS',3)
|
|
193
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1245,N'ASS_STATUS',N'6',N'05 Thừa so với sao kê',N'ASS_STATUS',4)
|
|
194
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1246,N'ASS_STATUS',N'7',N'06 Thiếu so với sao kê',N'ASS_STATUS',5)
|
|
195
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1247,N'REQ_TYPE',N'I',N'Tạm ứng nội bộ',N'REQ_TYPE',1)
|
|
196
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1248,N'REQ_TYPE',N'P',N'Tạm ứng thanh toán',N'REQ_TYPE',2)
|
|
197
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1249,N'REQ_TYPE',N'D',N'Tạm ứng xử lý nợ',N'REQ_TYPE',3)
|
|
198
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1250,N'REQ_INVOICE_TYP',N'I',N'Thanh toán tạm ứng',N'REQ_INVOICE_TYP',1)
|
|
199
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1251,N'REQ_INVOICE_TYP',N'P',N'Thanh toán nhà cung cấp',N'REQ_INVOICE_TYP',2)
|
|
200
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1252,N'REQ_INVOICE_TYP',N'D',N'Thanh toán khác',N'REQ_INVOICE_TYP',3)
|
|
201
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1257,N'ASS_TRANSFER',N'A',N'Đã duyệt',N'ASS_TRANSFER',1)
|
|
202
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1258,N'ASS_TRANSFER',N'U',N'Chờ duyệt',N'ASS_TRANSFER',2)
|
|
203
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1259,N'ASS_TRANSFER',N'R',N'Từ chối',N'ASS_TRANSFER',3)
|
|
204
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1260,N'ASS_TRANSFER',N'D',N'Phiếu bị hủy',N'ASS_TRANSFER',4)
|
|
205
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1261,N'TR_REQ',N'I',N'Tạm ứng nội bộ',N'TR_REQ',NULL)
|
|
206
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1262,N'TR_REQ',N'P',N'Tạm ứng thanh toán',N'TR_REQ',NULL)
|
|
207
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1263,N'TR_REQ',N'D',N'Tạm ứng xử lý nợ',N'TR_REQ',NULL)
|
|
208
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1264,N'TR_REQ',N'I',N'Thanh toán hoàn tạm ứng',N'TR_REQ',NULL)
|
|
209
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1265,N'TR_REQ',N'P',N'Thanh toán nhà cung cấp',N'TR_REQ',NULL)
|
|
210
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1266,N'TR_REQ',N'D',N'Thanh toán khác',N'TR_REQ',NULL)
|
|
211
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1270,N'PLAN_ROLE',N'KS',N'Kiểm soát viên',N'KS',NULL)
|
|
212
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1271,N'PLAN_ROLE',N'XL',N'Xứ lý phiếu',N'XL',NULL)
|
|
213
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1272,N'JOB_TYPE',N'KS',N'Kiểm soát viên',N'REQ',1)
|
|
214
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1273,N'JOB_TYPE',N'XL',N'Xử lý phiếu',N'REQ',2)
|
|
215
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1274,N'JOB_TYPE',N'TP',N'Trưởng đơn vị',N'REQ',3)
|
|
216
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1275,N'PL_TRANSFER',N'Y',N'Đã điều phối',N'PL',NULL)
|
|
217
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1276,N'PL_TRANSFER',N'N',N'Chưa điều phối',N'PL',NULL)
|
|
218
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1277,N'HMNS_TYPE',N'CP',N'Chi phí',N'HMNS_TYPE',1)
|
|
219
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1278,N'HMNS_TYPE',N'NS',N'Ngân sách',N'HMNS_TYPE',1)
|
|
220
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1279,N'PL_REQUEST_DOC',N'E',N'Lưu nháp',N'PL',NULL)
|
|
221
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1280,N'PL_REQUEST_DOC',N'W',N'Chờ phê duyệt trung gian',N'PL',NULL)
|
|
222
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1281,N'PL_REQUEST_DOC',N'G',N'Đã phê duyệt trung gian',N'PL',NULL)
|
|
223
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1282,N'PL_REQUEST_DOC',N'R',N'Bị từ chối',N'PL',NULL)
|
|
224
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1283,N'PL_REQUEST_DOC',N'A',N'Đã duyệt',N'PL',NULL)
|
|
225
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1284,N'PL_REQUEST_DOC',N'U',N'Chờ duyệt',N'PL',NULL)
|
|
226
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1285,N'PROCESS_ID',N'GDDV',N'Trưởng đơn vị',N'REQ',NULL)
|
|
227
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1286,N'PROCESS_ID',N'DVCM',N'Trưởng đơn vị',N'REQ',NULL)
|
|
228
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1287,N'PROCESS_ID',N'DVDM',N'Trưởng đơn vị',N'REQ',NULL)
|
|
229
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1288,N'PROCESS_ID',N'TC',N'Trưởng đơn vị',N'REQ',NULL)
|
|
230
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1289,N'PROCESS_ID',N'GDK',N'Trưởng đơn vị',N'REQ',NULL)
|
|
231
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1290,N'PROCESS_ID',N'PTGD',N'Trưởng đơn vị',N'REQ',NULL)
|
|
232
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1291,N'PROCESS_ID',N'TGD',N'Trưởng đơn vị',N'REQ',NULL)
|
|
233
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1292,N'PROCESS_ID',N'HDQT',N'Trưởng đơn vị',N'REQ',NULL)
|
|
234
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1293,N'PROCESS_ID',N'KT',N'Trưởng đơn vị',N'REQ',NULL)
|
|
235
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1294,N'PROSTATUSTC',N'DMMS',N'Chuyển về đơn vị mua sắm',N'PROSTATUSTC',NULL)
|
|
236
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1295,N'PROSTATUSTC',N'DVCM',N'Đơn vị đầu mối cho ý kiến',N'PROSTATUSTC',NULL)
|
|
237
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1296,N'PROSTATUSTC',N'DVDM_U',N'Đơn vị đầu mối cho ý kiến',N'PROSTATUSTC',NULL)
|
|
238
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1297,N'PROSTATUSTC',N'LDYC',N'Phê duyệt phiếu yêu cầu',N'PROSTATUSTC',NULL)
|
|
239
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1298,N'PROSTATUSTC',N'PDHT',N'Phê duyệt hình thức mua sắm',N'PROSTATUSTC',NULL)
|
|
240
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1299,N'PROSTATUSTC',N'PDHT_U',N'Phê duyệt hình thức mua sắm',N'PROSTATUSTC',NULL)
|
|
241
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1300,N'PROSTATUSTC',N'PDYC',N'Phê duyệt phiếu yêu cầu',N'PROSTATUSTC',NULL)
|
|
242
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1301,N'PROSTATUSTC',N'REJECT',N'Trả về',N'PROSTATUSTC',NULL)
|
|
243
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1302,N'AUTH_STATUSTC',N'W',N'Chờ phê duyệt trung gian',N'AUTH_STATUSTC',NULL)
|
|
244
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1303,N'AUTH_STATUSTC',N'E',N'Đã phê duyệt trung gian',N'AUTH_STATUSTC',NULL)
|
|
245
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1304,N'AUTH_STATUSTC',N'R',N'Bị từ chối',N'AUTH_STATUSTC',NULL)
|
|
246
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1305,N'AUTH_STATUSTC',N'A',N'Đã duyệt',N'',NULL)
|
|
247
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1306,N'AUTH_STATUSTC',N'U',N'Chờ duyệt',N'',NULL)
|
|
248
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1307,N'AUTH_STATUSTC',N'',N'Tất cả',N'AUTH_STATUSTC',NULL)
|
|
249
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1308,N'actionData',N'KS',N'Kiểm soát viên',N'REQ',1)
|
|
250
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1309,N'actionData',N'XL',N'Xử lý phiếu',N'REQ',2)
|
|
251
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1310,N'iS_TRANSFER',N'1',N'Đã điều phối',N'TRANSFER',NULL)
|
|
252
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1311,N'iS_TRANSFER',N'0',N'Chưa điều phối',N'TRANSFER',NULL)
|
|
253
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1312,N'iS_TRANSFER',N'',N'Tất cả',N'TRANSFER',NULL)
|
|
254
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1313,N'KhuVuc',N'1',N'KV khác',N'REQ',0)
|
|
255
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1314,N'KhuVuc',N'2',N'KV Tổng',N'REQ',1)
|
|
256
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1315,N'AUTH_STATUSTC',N'W',N'Chờ phê duyệt trung gian',N'AUTH_STATUSTC',NULL)
|
|
257
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1316,N'AUTH_STATUSTC',N'E',N'Đã phê duyệt trung gian',N'AUTH_STATUSTC',NULL)
|
|
258
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1317,N'AUTH_STATUSTC',N'R',N'Bị từ chối',N'AUTH_STATUSTC',NULL)
|
|
259
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1318,N'AUTH_STATUSTC',N'',N'A',N'Ðã duy?t',NULL)
|
|
260
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1319,N'AUTH_STATUSTC',N'',N'u',N'Ch? duy?t',NULL)
|
|
261
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1320,N'AUTH_STATUSTC',N'',N'',N'AUTH_STATUSTC',NULL)
|
|
262
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1321,N'PROSTATUSTC',N'DMMS',N'Chuyển về đơn vị mua sắm',N'PROSTATUSTC',NULL)
|
|
263
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1322,N'PROSTATUSTC',N'DVCM',N'Đơn vị đầu mối cho ý kiến',N'PROSTATUSTC',NULL)
|
|
264
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1323,N'PROSTATUSTC',N'DVDM_U',N'Đơn vị đầu mối cho ý kiến',N'PROSTATUSTC',NULL)
|
|
265
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1324,N'PROSTATUSTC',N'LDYC',N'Phê duyệt phiếu yêu cầu',N'PROSTATUSTC',NULL)
|
|
266
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1325,N'PROSTATUSTC',N'PDHT',N'Phê duyệt hình thức mua sắm',N'PROSTATUSTC',NULL)
|
|
267
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1326,N'PROSTATUSTC',N'PDHT_U',N'Phê duyệt hình thức mua sắm',N'PROSTATUSTC',NULL)
|
|
268
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1327,N'PROSTATUSTC',N'PDYC',N'Phê duyệt phiếu yêu cầu',N'PROSTATUSTC',NULL)
|
|
269
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1328,N'PROSTATUSTC',N'REJECT',N'Trả về',N'PROSTATUSTC',NULL)
|
|
270
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1329,N'AUTH_STATUSTC',N'A',N'Đã duyệt',N'',NULL)
|
|
271
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1330,N'AUTH_STATUSTC',N'U',N'Chờ duyệt',N'',NULL)
|
|
272
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1331,N'AUTH_STATUSTC',N'',N'Tất cả',N'AUTH_STATUSTC',NULL)
|
|
273
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1332,N'proSTATUS',N'KS',N'Chờ kiểm soát viên phê duyệt',N'REQ',1)
|
|
274
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1333,N'proSTATUS',N'TP',N'Chờ trưởng phòng',N'REQ',2)
|
|
275
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1334,N'proSTATUS',N'XL',N'Chờ nhân viên xử lý phiếu',N'REQ',2)
|
|
276
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1335,N'YEAR',NULL,NULL,NULL,NULL)
|
|
277
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1336,N'STATUSPYCMS',N'E',N'Lưu nháp',N'PYCMS',NULL)
|
|
278
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1337,N'STATUSPYCMS',N'W',N'Chờ phê duyệt trung gian',N'PYCMS',NULL)
|
|
279
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1338,N'STATUSPYCMS',N'G',N'Đã phê duyệt trung gian',N'PYCMS',NULL)
|
|
280
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1339,N'STATUSPYCMS',N'R',N'Bị từ chối',N'PYCMS',NULL)
|
|
281
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1340,N'STATUSPYCMS',N'A',N'Đã duyệt',N'PYCMS',NULL)
|
|
282
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1341,N'STATUSPYCMS',N'U',N'Chờ duyệt',N'PYCMS',NULL)
|
|
283
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1342,N'GOODSTYPE',N'CE',N'Chi phí Capex',N'CE',NULL)
|
|
284
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1343,N'GOODSTYPE',N'OE',N'Chi phí Opex',N'OE',NULL)
|
|
285
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1344,N'GOODSTYPE',N'ST',N'Chi phí nhân viên',N'ST',NULL)
|
|
286
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1345,N'GOODSTYPE',N'OS',N'Chi phí dich vụ',N'OS',NULL)
|
|
287
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1346,N'GOODSTYPE',N'KH',N'Khác',N'KH',NULL)
|
|
288
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1347,N'Top',N'300',N'300',N'Top',1)
|
|
289
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1348,N'Top',N'500',N'500',N'Top',2)
|
|
290
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1349,N'Top',N'600',N'600',N'Top',3)
|
|
291
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1350,N'Top',N'700',N'700',N'Top',4)
|
|
292
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1351,N'Top',N'800',N'800',N'Top',5)
|
|
293
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1352,N'Top',N'900',N'900',N'Top',6)
|
|
294
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1353,N'Top',N'1000',N'1000',N'Top',7)
|
|
295
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1354,N'Top',N'2000',N'2000',N'Top',8)
|
|
296
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1355,N'Top',N'3000',N'3000',N'Top',9)
|
|
297
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1356,N'Top',N'5000',N'5000',N'Top',10)
|
|
298
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1357,N'REQ_FORM_TYPE',N'0',N'Phiếu đề nghị tạm ứng',N'TR_REQ_PAY',NULL)
|
|
299
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1358,N'REQ_FORM_TYPE',N'1',N'Phiếu đề nghị thanh toán',N'TR_REQ_PAY',NULL)
|
|
300
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1359,N'REQ_PAY_TYPE',N'1',N'Thanh toán tiền mặt',N'REQ',NULL)
|
|
301
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1360,N'REQ_PAY_TYPE',N'0',N'Thanh toán khác',N'REQ',NULL)
|
|
302
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1361,N'LEVEL',N'UNIT',N'Đơn vị độc lập',N'LEVEL',NULL)
|
|
303
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1362,N'LEVEL',N'ALL',N'Tất cả đơn vị',N'LEVEL',NULL)
|
|
304
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1363,N'BUDGET',N'CP',N'Chi phí',N'BUDGET',NULL)
|
|
305
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1364,N'BUDGET',N'NS',N'Ngân sách',N'BUDGET',NULL)
|
|
306
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1365,N'DEDUCTION_FORM',N'0',N'Khấu trừ 100%',N'REQ_INVOICE',0)
|
|
307
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1366,N'DEDUCTION_FORM',N'1',N'Khấu trừ theo tỉ lệ',N'REQ_INVOICE',0)
|
|
308
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1367,N'proSDVCM',N'CTPDP',N'Chờ TP điều phối',N'PYCMS',NULL)
|
|
309
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1368,N'proSDVCM',N'CKSVDP',N'Chờ KSV điều phối',NULL,1)
|
|
310
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1369,N'proSDVCM',N'CNVXL',N'Chờ NV xử lý',NULL,2)
|
|
311
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1370,N'proSDVCM',N'NVXLD',N'NV xử lý gửi duyêt',NULL,3)
|
|
312
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1371,N'proSDVCM',N'KSVD',N'KSV duyệt',NULL,4)
|
|
313
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1372,N'proSDVCM',N'TPD',N'TP đã duyệt',NULL,5)
|
|
314
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1373,N'PROPYCMS',N'DMMS_DP',N'Chờ ĐMMS điều phối',N'PYCMS',1)
|
|
315
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1374,N'PROPYCMS',N'DMMS_XL',N'Chờ ĐMMS xử lý phiếu',N'PYCMS',2)
|
|
316
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1375,N'PROPYCMS',N'DMMS_PD',N'Chờ ĐMMS phê duyệt phiếu',N'PYCMS',3)
|
|
317
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1376,N'PROPYCMS',N'DVCM_DP',N'Chờ DVCM điều phối điều phối',N'PYCMS',4)
|
|
318
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1377,N'PROPYCMS',N'DVCM_XL',N'Chờ DVCM xử lý phiếu',N'PYCMS',5)
|
|
319
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1378,N'PROPYCMS',N'DVCM_PD',N'Chờ DVCM phê duyệt phiếu',N'PYCMS',6)
|
|
320
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1379,N'PROPYCMS',N'GDK_PD',N'Chờ GĐK hỗ trợ phê duyệt phiếu',N'PYCMS',7)
|
|
321
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1380,N'PROPYCMS',N'APPROVE',N'Hoàn tất phiếu',N'PYCMS',8)
|
|
322
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1381,N'PAY_TYPE',N'I',N'Thanh toán hoàn tạm ứng',N'REQ',0)
|
|
323
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1382,N'PAY_TYPE',N'P',N'PThanh toán nhà cung cấp',N'REQ',0)
|
|
324
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1383,N'PAY_TYPE',N'D',N'Thanh toán khác',N'REQ',0)
|
|
325
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1384,N'CURRENCY',N'VND',N'VND',N'REQ',0)
|
|
326
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1385,N'CURRENCY',N'USD',N'USD',N'REQ',0)
|
|
327
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1386,N'CURRENCY',N'EURO',N'EURO',N'REQ',0)
|
|
328
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1387,N'PL_SEARCH',N'NS',N'Ngân sách',N'PL',0)
|
|
329
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1388,N'PL_SEARCH',N'CP',N'Chi phí',N'PL',0)
|
|
330
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1389,N'TYPE_TRANSFER',N'R',N'Trích từ tài khoản',N'REQ_PAY_METHOD',0)
|
|
331
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1390,N'TYPE_TRANSFER',N'A',N'Thanh toán',N'REQ_PAY_METHOD',0)
|
|
332
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1391,N'CHECK_IN',N'I',N'Trong hệ thống',N'REQ_PAY_METHOD',0)
|
|
333
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1392,N'CHECK_IN',N'O',N'Ngoài hệ thống',N'REQ_PAY_METHOD',0)
|
|
334
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1393,N'REQ_PAY_TYPE',N'1',N'Thanh toán tiền mặt',N'REQ_PAY_METHOD',0)
|
|
335
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1394,N'REQ_PAY_TYPE',N'0',N'Thanh toán chuyển khoản',N'REQ_PAY_METHOD',0)
|
|
336
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1395,N'REQ_PAY_TYPE',N'2',N'Phương thức thanh toán khác',N'REQ_PAY_METHOD',0)
|
|
337
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1396,N'PAY_STATUS',N'1',N'Thanh toán',N'PO_CONTRACT',0)
|
|
338
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1397,N'PO_TYPE',N'-1',N'------Tất Cả-----',N'PO',0)
|
|
339
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1398,N'PO_TYPE',N'1',N'Trong KH',N'PO',0)
|
|
340
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1399,N'PO_TYPE',N'0',N'Ngoài KH',N'PO',0)
|
|
341
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1400,N'CONTRUCT_CODE',N'Y',N'Còn hiệu lực',N'TR_CONTRACT',0)
|
|
342
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1401,N'CONTRUCT_CODE',N'N',N'Hết hiệu lực',N'TR_CONTRACT',0)
|
|
343
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1402,N'REQ_TYPE',N'I',N'Nội bộ',N'REQ_PAY_ADVANCE',0)
|
|
344
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1403,N'REQ_TYPE',N'P',N'Thanh toán',N'REQ_PAY_ADVANCE',0)
|
|
345
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1404,N'REQ_TYPE',N'D',N'Xử lý nợ',N'REQ_PAY_ADVANCE',0)
|
|
346
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1405,N'TRANSFER_STATUS',N'Y',N'Đã điều phối',N'TR_REQ',0)
|
|
347
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1406,N'TRANSFER_STATUS',N'N',N'Chưa điều phối',N'TR_REQ',0)
|
|
348
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1407,N'REQ_PAY_TYPE',N'0',N'Thanh toán tiền mặt',N'REQ_TRANSFER',0)
|
|
349
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1408,N'REQ_PAY_TYPE',N'1',N'Thanh toán chuyển khoản',N'REQ_TRANSFER',0)
|
|
350
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1409,N'ADVANCE_STATUS',N'E',N'Lưu nháp',N'REQ_ADVANCE',0)
|
|
351
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1410,N'ADVANCE_STATUS',N'A',N'Hoàn tất',N'REQ_ADVANCE',0)
|
|
352
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1411,N'ADVANCE_STATUS',N'CHU',N'Chưa hoàn ứng',N'REQ_ADVANCE',0)
|
|
353
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1412,N'ADVANCE_STATUS',N'DHU',N'Đã hoàn ứng',N'REQ_ADVANCE',0)
|
|
354
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1413,N'ROLE',N'KS',N'Kiểm soát phiếu',N'REQ_TRANSFER',0)
|
|
355
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1414,N'ROLE',N'XL',N'Xử lý phiếu',N'REQ_TRANSFER',0)
|
|
356
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1415,N'AUTH_STATUS',N'A',N'Đã duyệt',N'TR_REQ_PAYMENT',0)
|
|
357
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1416,N'AUTH_STATUS',N'E',N'Lưu nháp',N'TR_REQ_PAYMENT',0)
|
|
358
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1417,N'AUTH_STATUS',N'G',N'Đã phê duyệt trung gian',N'TR_REQ_PAYMENT',0)
|
|
359
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1418,N'AUTH_STATUS',N'W',N'Chờ phê duyệt trung gian',N'TR_REQ_PAYMENT',0)
|
|
360
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1419,N'AUTH_STATUS',N'U',N'Chờ duyệt',N'TR_REQ_PAYMENT',0)
|
|
361
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1420,N'AUTH_STATUS',N'R',N'Từ chối',N'TR_REQ_PAYMENT',0)
|
|
362
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1421,N'AUTH_STATUS',N'D',N'Phiếu bị hủy',N'TR_REQ_PAYMENT',0)
|
|
363
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1422,N'AUTH_STATUS_KT',N'A',N'Đã duyệt',N'TR_REQ_PAYMENT',0)
|
|
364
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1423,N'AUTH_STATUS_KT',N'P',N'Đang xử lý',N'TR_REQ_PAYMENT',0)
|
|
365
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1424,N'AUTH_STATUS_KT',N'U',N'Chờ duyệt',N'TR_REQ_PAYMENT',0)
|
|
366
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1425,N'AUTH_STATUS_KT',N'R',N'Từ chối',N'TR_REQ_PAYMENT',0)
|
|
367
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1426,N'AUTH_STATUS_KT',N'D',N'Phiếu bị hủy',N'TR_REQ_PAYMENT',0)
|
|
368
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1429,N'DR_CR',N'D',N'Nợ',N'REQ_PAY_ENTRIES',0)
|
|
369
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1430,N'DR_CR',N'C',N'Có',N'REQ_PAY_ENTRIES',0)
|
|
370
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1431,N'PL_REQUEST_TYPE',N'TTMS',N'Tờ trình mua sắm',N'PL_REQUEST_TYPE',NULL)
|
|
371
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1432,N'PL_REQUEST_TYPE',N'TTDC',N'Tờ trình điều chuyển',N'PL_REQUEST_TYPE',NULL)
|
|
372
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1433,N'ASS_INVENTORY',N'A',N'Đã duyệt',N'ASS_INVENTORY',NULL)
|
|
373
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1434,N'ASS_INVENTORY',N'U',N'Chờ duyệt',N'ASS_INVENTORY',NULL)
|
|
374
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1435,N'ASS_INVENTORY',N'E',N'Lưu nháp',N'ASS_INVENTORY',NULL)
|
|
375
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1436,N'SSGLTYPE',N'CDT',N'Chỉ định thầu',N'SSGLTYPE',NULL)
|
|
376
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1437,N'SSGLTYPE',N'TTCT',N'Theo quy định TTCT',N'SSGLTYPE',NULL)
|
|
377
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(2436,N'REVIEW',N'G',N'Tốt',N'REVIEW',NULL)
|
|
378
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(2437,N'REVIEW',N'D',N'Đạt',N'REVIEW',NULL)
|
|
379
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(2438,N'REVIEW',N'KD',N'Không đạt',N'REVIEW',NULL)
|
|
380
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(3436,N'OWNER_OR_RENT',N'O',N'Tài sản ngân hàng',N'BM',NULL)
|
|
381
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(3437,N'OWNER_OR_RENT',N'U',N'Tài sản thuê',N'BM',NULL)
|
|
382
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(3438,N'AUTH_STATUS_BC',N'A',N'Đã duyệt',N'AUTH_STATUS_BC',NULL)
|
|
383
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(3439,N'AUTH_STATUS_BC',N'U',N'Chờ duyệt',N'AUTH_STATUS_BC',NULL)
|
|
384
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(3440,N'AUTH_STATUS_BC',N'R',N'Từ chối',N'AUTH_STATUS_BC',NULL)
|
|
385
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4436,N'PAY_TYPE',N'I',N'Nội bộ',N'REQ_TEMP',1)
|
|
386
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4437,N'PAY_TYPE',N'P',N'Thanh toán',N'REQ_TEMP',2)
|
|
387
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4438,N'PAY_TYPE',N'D',N'Xử lý nợ',N'REQ_TEMP',3)
|
|
388
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4439,N'CONTRACT_TYPE',N'DK',N'Hợp đồng định kì',N'CONTRACT',NULL)
|
|
389
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4440,NULL,NULL,N'Hợp đồng nguyên tắc',NULL,NULL)
|
|
390
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4441,N'CONTRACT_TYPE',N'KT',N'Hợp đồng cho khách thuê',N'CONTRACT',NULL)
|
|
391
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4442,N'CONTRACT_STATUS',N'C',N'Còn hiệu lực',N'TR_CONTRACT',NULL)
|
|
392
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4443,N'CONTRACT_STATUS',N'H',N'Hết hiệu lực',N'TR_CONTRACT',NULL)
|
|
393
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4444,N'AUTH_STATUS',N'A',N'Đã duyệt',N'CONTRACT',NULL)
|
|
394
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4445,N'AUTH_STATUS',N'U',N'Chờ duyệt',N'CONTRACT',NULL)
|
|
395
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4446,N'AUTH_STATUS',N'E',N'Lưu nháp',N'CONTRACT',NULL)
|
|
396
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4447,N'AUTH_STATUS',N'R',N'Từ chối',N'CONTRACT',NULL)
|
|
397
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4448,N'AUTH_STATUS',N'D',N'Phiếu bị hủy',N'CONTRACT',NULL)
|
|
398
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4449,N'PERIOD',N'M',N'Hàng tháng',N'CONTRACT',NULL)
|
|
399
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4450,N'PERIOD',N'Y',N'Hàng năm',N'CONTRACT',NULL)
|
|
400
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4451,N'PERIOD',N'Q',N'Hàng quý',N'CONTRACT',NULL)
|
|
401
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4452,N'PERIOD',N'6T',N'6 tháng',N'CONTRACT',NULL)
|
|
402
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4453,N'PERIOD',N'4T',N'4 tháng',N'CONTRACT',NULL)
|
|
403
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4454,N'PERIOD',N'5T',N'5 tháng',N'CONTRACT',NULL)
|
|
404
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4455,N'PERIOD',N'24T',N'24 tháng',N'CONTRACT',NULL)
|
|
405
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4456,N'PERIOD',N'18T',N'18 tháng',N'CONTRACT',NULL)
|
|
406
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4457,N'PAYMENT_STATUS',N'TTX',N'Thanh toán xong',N'TR',NULL)
|
|
407
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4458,N'AUTH_STATUS',N'A',N'Đã duyệt',N'TR_PO',NULL)
|
|
408
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4459,N'AUTH_STATUS',N'U',N'Chờ duyệt',N'TR_PO',NULL)
|
|
409
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4460,N'AUTH_STATUS',N'E',N'Lưu nháp',N'TR_PO',NULL)
|
|
410
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4461,N'AUTH_STATUS',N'R',N'Từ chối',N'TR_PO',NULL)
|
|
411
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4462,N'AUTH_STATUS_RET',N'U',N'Chờ duyệt',N'RET',NULL)
|
|
412
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4463,N'AUTH_STATUS_RET',N'A',N'Đã duyệt',N'RET',NULL)
|
|
413
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4464,N'AUTH_STATUS_RET',N'R',N'Từ chối',N'RET',NULL)
|
|
414
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4465,N'RET_TYPE',N'ND',N'Nhà + Đất',N'RET',NULL)
|
|
415
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4466,N'RET_TYPE',N'TSGN',N'Tài sản gán nợ',N'RET',NULL)
|
|
416
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4467,N'RET_TYPE',N'TSTL',N'Tài sản hình thành trong tương lai',N'RET',NULL)
|
|
417
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4468,N'GROUP_ID',N'O',N'Khách hàng cũ',N'CUSTOMER',NULL)
|
|
418
|
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4469,N'GROUP_ID',N'N',N'Khách hàng mới',N'CUSTOMER',NULL)
|
|
419
|
SET IDENTITY_INSERT CM_ALLCODE OFF
|