INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1,N'TRTYPE',N'0',N'Trong KH',N'TR',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(2,N'TRTYPE',N'1',N'Ngoài KH',N'TR',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(5,N'STATUS',N'N',N'Nhập mới',N'PL',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(6,N'STATUS',N'P',N'Đã gửi',N'PL',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(7,N'STATUS',N'U',N'Chờ duyệt',N'PL',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(8,N'STATUS',N'A',N'Đã duyệt',N'PL',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(9,N'FORM',N'DT',N'Đấu thầu',N'TR',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(10,N'FORM',N'CD',N'Chỉ định',N'TR',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(11,N'FORM',N'C',N'Tiền mặt',N'CONT',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(12,N'FORM',N'L',N'Chứng thư',N'CONT',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(13,N'PAYMENT_STATUS',N'TT',N'Thanh toán',N'TR',NULL)
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)
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)
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)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(32,N'CHARG_TYPE',N'PDB',N'Phí đường bộ',N'CAR',NULL)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(34,N'DIVISION_REP_DI',N'SCB',N'Sacombank',N'CAR',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(35,N'DIVISION_REP_DI',N'ACB',N'ACB',N'CAR',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(36,N'OFFER_PERSON',N'GD',N'Giam Doc',N'CAR',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(37,N'OFFER_PERSON',N'TP',N'Truong Phong',N'CAR',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(38,N'OFFER_PERSON',N'PGD',N'Pho Giam Doc',N'CAR',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(39,N'MAINT_PROVIDER',N'SCB',N'INNOVA',N'CAR',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(40,N'MAINT_PROVIDER',N'JUP',N'TOYOTA',N'CAR',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(41,N'RET_TYPE',N'N',N'Nhà',N'RET',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(42,N'RET_TYPE',N'D',N'Đất',N'RET',NULL)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(45,N'DISCIPLINES',N'CAR',N'Xe',N'SUP',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(46,N'DISCIPLINES',N'CON',N'Xây dựng',N'SUP',NULL)
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)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(50,N'ASS_CAT',N'CAR',N'Xe',N'ASS_GROUP',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(51,N'ASS_CAT',N'NORM',N'TSCD/CCLD',N'ASS_GROUP',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(52,N'ASS_CAT',N'RET',N'BĐS',N'ASS_GROUP',NULL)
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)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(57,N'RET_PURPOSE',N'DV',N'Đất vườn',N'RET',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(58,N'RET_PURPOSE',N'TC',N'Thổ cư',N'RET',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(61,N'USE_STATUS',N'D',N'Đã sử dụng',N'RET',NULL)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(63,N'DISCIPLINES',N'OTHER',N'Khác',N'SUP',NULL)
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)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(69,N'OWNER_TYPE',N'M',N'Mua',N'RET',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(71,N'CAR_PURPOSE',N'Chuyendung',N'Chuyen dung',N'CAR',0)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(72,N'DATA_TYPE',N'Chr',N'CHARACTER',N'PARA',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(73,N'DATA_TYPE',N'Num',N'NUMBER',N'PARA',NULL)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(75,N'RECORD_STATUS',N'1',N'Hoạt động',NULL,NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(76,N'RET_PURPOSE',N'DKD',N'Đất kinh doanh',N'RET',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(77,N'RET_PURPOSE',N'KH',N'Khác',N'RET',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(79,N'PRODUCT_COUNTRY',N'HOAKY',N'HOA KY',N'CAR',0)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(80,N'ISVALID',N'HL',N'Hợp lệ',N'BID',NULL)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(84,N'CAR_PURPOSE',N'Vanchuyentien',N'Van chuyen tien',N'CAR',0)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(85,N'PRODUCT_COUNTRY',N'HANQUOC',N'HAN QUOC',N'CAR',0)
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)
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)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(92,N'CAR_PURPOSE',N'PhucvuLD',N'Phuc vu LD',N'CAR',0)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(93,N'FUELSTYPE',N'Xang',N'Xang',N'CAR',0)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(94,N'CAR_PURPOSE',N'Congvu',N'Cong vu',N'CAR',0)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(95,N'GEARBOX_TYPE',N'Sosan',N'So san',N'CAR',0)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(98,N'GEARBOX_TYPE',N'Sotudong',N'So tu dong',N'CAR',0)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(99,N'PRODUCT_COUNTRY',N'VIETNAM',N'VIET NAM',N'CAR',0)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(104,N'PRODUCT_COUNTRY',N'NHATBAN',N'NHAT BAN',N'CAR',0)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(107,N'FUELSTYPE',N'Dau',N'Dau',N'CAR',0)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(108,N'PRODUCT_COUNTRY',N'THAILAN',N'THAI LAN',N'CAR',0)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(113,N'CAR_PURPOSE',N'Khac',N'Khac',N'CAR',0)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(128,N'AUTH_STATUS',N'A',N'Đã duyệt',N'AUTH_STATUS',NULL)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(130,N'BRANCH_TYPE',N'HS',N'HS Hội sở',NULL,NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(131,N'BRANCH_TYPE',N'KV',N'KV Khu vực',NULL,NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(132,N'BRANCH_TYPE',N'CN',N'CN Chi nhánh',NULL,NULL)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(135,N'PARAM_DATATYPE',N'Chr',N'CHARACTER',N'CM',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(136,N'PARAM_DATATYPE',N'Num',N'NUMBER',N'CM',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(137,N'PARAM_DATATYPE',N'Var',N'VARIABLE',N'CM',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(143,N'PAGE_SIZE',N'A2',N'Khổ in A2',N'PG',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(144,N'PAGE_SIZE',N'A3',N'Khổ in A3',N'PG',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(145,N'PAGE_SIZE',N'A4',N'Khổ in A4',N'PG',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(146,N'PAGE_SIZE',N'K80',N'Khổ in K80',N'PG',NULL)
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)
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)
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)
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)
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)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(154,NULL,NULL,NULL,NULL,NULL)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(157,N'DELIVERY_STATUS',N'1',N'Đã giao hàng',N'REPORT',NULL)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(159,N'PAYMENT_STATUS',N'DTT',N'Đã thanh toán',N'REPORT',NULL)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(163,N'REQ_BUDGET',N'0',N'XDCB',N'CON',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(164,N'REQ_BUDGET',N'1',N'VPKV',N'CON',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(165,N'REQ_BUDGET',N'2',N'CN',N'CON',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(166,N'REQ_HQ_TYPE',N'0',N'TSNH',N'CON',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(167,N'REQ_HQ_TYPE',N'1',N'Thuê',N'CON',NULL)
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)
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)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(175,N'MANUFACTURER',N'Toyota',N'Toyota',N'CAR',0)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(176,N'MANUFACTURER',N'Isuzu',N'Isuzu',N'CAR',0)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(177,N'MANUFACTURER',N'Mitsubishi',N'Mitsubishi',N'CAR',0)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(178,N'MANUFACTURER',N'Mercedes',N'Mercedes',N'CAR',0)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(180,N'MANUFACTURER',N'Huyndai',N'Huyndai',N'CAR',0)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(181,N'MANUFACTURER',N'RollsRoyce',N'Rolls Royce',N'CAR',0)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(182,N'MANUFACTURER',N'Honda',N'Honda',N'CAR',0)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(183,N'MANUFACTURER',N'Chevrolet',N'Chevrolet',N'CAR',0)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(184,N'MANUFACTURER',N'Ford',N'Ford',N'CAR',0)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(187,N'PO_KIND',N'PO',N'PO thường',N'PO',NULL)
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)
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)
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)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1194,N'RAT_SUP',N'B',N'Khá/Tốt',N'CRITERIA',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1195,N'RAT_SUP',N'C',N'Trung bình',N'CRITERIA',NULL)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1206,N'USE_FORM',N'R',N'Riêng',N'RET',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1207,N'USE_FORM',N'C',N'Chung',N'RET',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1208,N'OWNER_TYPE',N'K',N'Khác',N'RET',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1209,N'USE_FORM',N'K',N'Khác',N'RET',NULL)
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)
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)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1214,N'DRIVE_AMT_TYPE',N'GAS',N'Xăng',N'CAR',NULL)
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)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1218,N'WHStorage',N'1',N'Cho mượn',N'WHHcqt',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1219,N'WHStorage',N'0',N'Tồn kho',N'WHHcqt',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1220,N'Goods',N'NS',N'Ngân sách',N'Goods',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1221,N'Goods',N'CP',N'Chi phí',N'Goods',NULL)
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)
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)
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)
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)
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)
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)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1230,N'MW_CAT',N'TT',N'THẺ',N'MW_GROUP',NULL)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1232,N'MW_AUTH',N'A',N'Đã duyệt',N'MW',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1233,N'MW_AUTH',N'U',N'Chờ duyệt',N'MW',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1234,N'MW_AUTH',N'R',N'Từ chối',N'MW',NULL)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1257,N'ASS_TRANSFER',N'A',N'Đã duyệt',N'ASS_TRANSFER',1)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1277,N'HMNS_TYPE',N'CP',N'Chi phí',N'HMNS_TYPE',1)
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)
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)
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)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1283,N'PL_REQUEST_DOC',N'A',N'Đã duyệt',N'PL',NULL)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1301,N'PROSTATUSTC',N'REJECT',N'Trả về',N'PROSTATUSTC',NULL)
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)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1305,N'AUTH_STATUSTC',N'A',N'Đã duyệt',N'',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1306,N'AUTH_STATUSTC',N'U',N'Chờ duyệt',N'',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1307,N'AUTH_STATUSTC',N'',N'Tất cả',N'AUTH_STATUSTC',NULL)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1309,N'actionData',N'XL',N'Xử lý phiếu',N'REQ',2)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1312,N'iS_TRANSFER',N'',N'Tất cả',N'TRANSFER',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1313,N'KhuVuc',N'1',N'KV khác',N'REQ',0)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1314,N'KhuVuc',N'2',N'KV Tổng',N'REQ',1)
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)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1318,N'AUTH_STATUSTC',N'',N'A',N'Ðã duy?t',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1319,N'AUTH_STATUSTC',N'',N'u',N'Ch? duy?t',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1320,N'AUTH_STATUSTC',N'',N'',N'AUTH_STATUSTC',NULL)
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)
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)
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)
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)
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)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1328,N'PROSTATUSTC',N'REJECT',N'Trả về',N'PROSTATUSTC',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1329,N'AUTH_STATUSTC',N'A',N'Đã duyệt',N'',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1330,N'AUTH_STATUSTC',N'U',N'Chờ duyệt',N'',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1331,N'AUTH_STATUSTC',N'',N'Tất cả',N'AUTH_STATUSTC',NULL)
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)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1335,N'YEAR',NULL,NULL,NULL,NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1336,N'STATUSPYCMS',N'E',N'Lưu nháp',N'PYCMS',NULL)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1339,N'STATUSPYCMS',N'R',N'Bị từ chối',N'PYCMS',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1340,N'STATUSPYCMS',N'A',N'Đã duyệt',N'PYCMS',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1341,N'STATUSPYCMS',N'U',N'Chờ duyệt',N'PYCMS',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1342,N'GOODSTYPE',N'CE',N'Chi phí Capex',N'CE',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1343,N'GOODSTYPE',N'OE',N'Chi phí Opex',N'OE',NULL)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1345,N'GOODSTYPE',N'OS',N'Chi phí dich vụ',N'OS',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1346,N'GOODSTYPE',N'KH',N'Khác',N'KH',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1347,N'Top',N'300',N'300',N'Top',1)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1348,N'Top',N'500',N'500',N'Top',2)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1349,N'Top',N'600',N'600',N'Top',3)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1350,N'Top',N'700',N'700',N'Top',4)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1351,N'Top',N'800',N'800',N'Top',5)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1352,N'Top',N'900',N'900',N'Top',6)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1353,N'Top',N'1000',N'1000',N'Top',7)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1354,N'Top',N'2000',N'2000',N'Top',8)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1355,N'Top',N'3000',N'3000',N'Top',9)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1356,N'Top',N'5000',N'5000',N'Top',10)
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)
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)
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)
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)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1363,N'BUDGET',N'CP',N'Chi phí',N'BUDGET',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1364,N'BUDGET',N'NS',N'Ngân sách',N'BUDGET',NULL)
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)
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)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1369,N'proSDVCM',N'CNVXL',N'Chờ NV xử lý',NULL,2)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1371,N'proSDVCM',N'KSVD',N'KSV duyệt',NULL,4)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1372,N'proSDVCM',N'TPD',N'TP đã duyệt',NULL,5)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1384,N'CURRENCY',N'VND',N'VND',N'REQ',0)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1385,N'CURRENCY',N'USD',N'USD',N'REQ',0)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1386,N'CURRENCY',N'EURO',N'EURO',N'REQ',0)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1388,N'PL_SEARCH',N'CP',N'Chi phí',N'PL',0)
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)
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)
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)
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)
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)
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)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1397,N'PO_TYPE',N'-1',N'------Tất Cả-----',N'PO',0)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1398,N'PO_TYPE',N'1',N'Trong KH',N'PO',0)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1399,N'PO_TYPE',N'0',N'Ngoài KH',N'PO',0)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1429,N'DR_CR',N'D',N'Nợ',N'REQ_PAY_ENTRIES',0)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1430,N'DR_CR',N'C',N'Có',N'REQ_PAY_ENTRIES',0)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1433,N'ASS_INVENTORY',N'A',N'Đã duyệt',N'ASS_INVENTORY',NULL)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1436,N'SSGLTYPE',N'CDT',N'Chỉ định thầu',N'SSGLTYPE',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(1437,N'SSGLTYPE',N'TTCT',N'Theo quy định TTCT',N'SSGLTYPE',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(2436,N'REVIEW',N'G',N'Tốt',N'REVIEW',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(2437,N'REVIEW',N'D',N'Đạt',N'REVIEW',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(2438,N'REVIEW',N'KD',N'Không đạt',N'REVIEW',NULL)
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)
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)
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)
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)
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)
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)
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)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4440,NULL,NULL,N'Hợp đồng nguyên tắc',NULL,NULL)
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)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4444,N'AUTH_STATUS',N'A',N'Đã duyệt',N'CONTRACT',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4445,N'AUTH_STATUS',N'U',N'Chờ duyệt',N'CONTRACT',NULL)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4447,N'AUTH_STATUS',N'R',N'Từ chối',N'CONTRACT',NULL)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4449,N'PERIOD',N'M',N'Hàng tháng',N'CONTRACT',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4450,N'PERIOD',N'Y',N'Hàng năm',N'CONTRACT',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4451,N'PERIOD',N'Q',N'Hàng quý',N'CONTRACT',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4452,N'PERIOD',N'6T',N'6 tháng',N'CONTRACT',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4453,N'PERIOD',N'4T',N'4 tháng',N'CONTRACT',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4454,N'PERIOD',N'5T',N'5 tháng',N'CONTRACT',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4455,N'PERIOD',N'24T',N'24 tháng',N'CONTRACT',NULL)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4456,N'PERIOD',N'18T',N'18 tháng',N'CONTRACT',NULL)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4458,N'AUTH_STATUS',N'A',N'Đã duyệt',N'TR_PO',NULL)
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)
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)
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)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4463,N'AUTH_STATUS_RET',N'A',N'Đã duyệt',N'RET',NULL)
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)
INSERT INTO [CM_ALLCODE] ([ID],[CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(4465,N'RET_TYPE',N'ND',N'Nhà + Đất',N'RET',NULL)
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)
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)
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)
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)