DELETE SYS_PARAMETERS WHERE ParaKey LIKE 'EXCEPTION_WARE_ACCNO%' INSERT INTO SYS_PARAMETERS (ParaKey, ParaValue, DataType, Description, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT) VALUES ('EXCEPTION_WARE_ACCNO_01AC', N'861201001', 'Chr', N'Chi an chi co gia', '1', NULL, CONVERT(DATETIME, '2023-10-09 11:41:45.000', 121), 'A', NULL, NULL), ('EXCEPTION_WARE_ACCNO_02TE', N'861201003', 'Chr', N'Chi phoi the', '1', NULL, CONVERT(DATETIME, '2023-10-09 11:41:45.000', 121), 'A', NULL, NULL), ('EXCEPTION_WARE_ACCNO_03CT', N'861201003', 'Chr', N'Chi phoi the', '1', NULL, CONVERT(DATETIME, '2023-10-09 11:41:45.000', 121), 'A', NULL, NULL), ('EXCEPTION_WARE_ACCNO_04VT', N'861201004', 'Chr', N'Chi vat lieu the', '1', NULL, CONVERT(DATETIME, '2023-10-09 11:41:45.000', 121), 'A', NULL, NULL), ('EXCEPTION_WARE_ACCNO_05KM', N'866001005', 'Chr', N'Chi khuyen mai co dang ky chuong trinh khuyen mai', '1', NULL, CONVERT(DATETIME, '2023-10-09 11:41:45.000', 121), 'A', NULL, NULL), ('EXCEPTION_WARE_ACCNO_06QT', N'866001006', 'Chr', N'Chi khuyen mai khac khong dang ky chuong trinh khuyen mai', '1', NULL, CONVERT(DATETIME, '2023-10-09 11:41:45.000', 121), 'A', NULL, NULL), ('EXCEPTION_WARE_ACCNO_07TT', N'866001006', 'Chr', N'Chi khuyen mai khac khong dang ky chuong trinh khuyen mai', '1', NULL, CONVERT(DATETIME, '2023-10-09 11:41:45.000', 121), 'A', NULL, NULL), ('EXCEPTION_WARE_ACCNO_08NV', N'866001006', 'Chr', N'Chi khuyen mai khac khong dang ky chuong trinh khuyen mai', '1', NULL, CONVERT(DATETIME, '2023-10-09 11:41:45.000', 121), 'A', NULL, NULL), ('EXCEPTION_WARE_ACCNO_09GT', N'869901008', 'Chr', N'Tài khoản loại trừ chi phí mặc định cho kho quà giao tế', '1', NULL, CONVERT(DATETIME, '2023-10-09 11:41:45.000', 121), 'A', NULL, NULL)