|
1
|
DELETE FROM [CM_HANGHOA_GROUP]
|
|
2
|
|
|
3
|
INSERT [dbo].[CM_HANGHOA_GROUP] ([HH_GROUP_ID], [HH_GROUP_CODE], [HH_GROUP_NAME], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT]) VALUES (N'HHG000000000012', N'CNTT', N'Công nghệ Thông tin', N'', N'1', N'tscd_hoiso', CAST(N'2019-12-12T14:22:17.643' AS DateTime), N'A', N'tscd_hoiso', CAST(N'2019-12-12T14:22:17.643' AS DateTime))
|
|
4
|
INSERT [dbo].[CM_HANGHOA_GROUP] ([HH_GROUP_ID], [HH_GROUP_CODE], [HH_GROUP_NAME], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT]) VALUES (N'HHG000000000013', N'DV', N'Dịch vụ Khác', N'', N'1', N'tscd_hoiso', CAST(N'2019-12-12T14:22:17.653' AS DateTime), N'A', N'tscd_hoiso', CAST(N'2019-12-12T14:22:17.653' AS DateTime))
|
|
5
|
INSERT [dbo].[CM_HANGHOA_GROUP] ([HH_GROUP_ID], [HH_GROUP_CODE], [HH_GROUP_NAME], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT]) VALUES (N'HHG000000000014', N'DVHHDT', N'Dịch vụ & hàng hóa Đào tạo', N'', N'1', N'tscd_hoiso', CAST(N'2019-12-12T14:22:17.653' AS DateTime), N'A', N'tscd_hoiso', CAST(N'2019-12-12T14:22:17.653' AS DateTime))
|
|
6
|
INSERT [dbo].[CM_HANGHOA_GROUP] ([HH_GROUP_ID], [HH_GROUP_CODE], [HH_GROUP_NAME], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT]) VALUES (N'HHG000000000015', N'DVKT', N'Dịch vụ kế toán', N'', N'1', N'tscd_hoiso', CAST(N'2019-12-12T14:22:17.653' AS DateTime), N'A', N'tscd_hoiso', CAST(N'2019-12-12T14:22:17.653' AS DateTime))
|
|
7
|
INSERT [dbo].[CM_HANGHOA_GROUP] ([HH_GROUP_ID], [HH_GROUP_CODE], [HH_GROUP_NAME], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT]) VALUES (N'HHG000000000016', N'DVM', N'Dịch vụ Marketing', N'', N'1', N'tscd_hoiso', CAST(N'2019-12-12T14:22:17.653' AS DateTime), N'A', N'tscd_hoiso', CAST(N'2019-12-12T14:22:17.653' AS DateTime))
|
|
8
|
INSERT [dbo].[CM_HANGHOA_GROUP] ([HH_GROUP_ID], [HH_GROUP_CODE], [HH_GROUP_NAME], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT]) VALUES (N'HHG000000000017', N'DVNS', N'Dịch vụ Nhân sự', N'', N'1', N'tscd_hoiso', CAST(N'2019-12-12T14:22:17.657' AS DateTime), N'A', N'tscd_hoiso', CAST(N'2019-12-12T14:22:17.657' AS DateTime))
|
|
9
|
INSERT [dbo].[CM_HANGHOA_GROUP] ([HH_GROUP_ID], [HH_GROUP_CODE], [HH_GROUP_NAME], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT]) VALUES (N'HHG000000000018', N'DVPL', N'DV Pháp lý-Kiểm toán', N'', N'1', N'tscd_hoiso', CAST(N'2019-12-12T14:22:17.657' AS DateTime), N'A', N'tscd_hoiso', CAST(N'2019-12-12T14:22:17.657' AS DateTime))
|
|
10
|
INSERT [dbo].[CM_HANGHOA_GROUP] ([HH_GROUP_ID], [HH_GROUP_CODE], [HH_GROUP_NAME], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT]) VALUES (N'HHG000000000019', N'HCQT', N'Hành chánh Quản trị', N'', N'1', N'tscd_hoiso', CAST(N'2019-12-12T14:22:17.657' AS DateTime), N'A', N'tscd_hoiso', CAST(N'2019-12-12T14:22:17.657' AS DateTime))
|
|
11
|
INSERT [dbo].[CM_HANGHOA_GROUP] ([HH_GROUP_ID], [HH_GROUP_CODE], [HH_GROUP_NAME], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT]) VALUES (N'HHG000000000020', N'SPDV', N'Sản phẩm, dịch vụ TTT', N'', N'1', N'tscd_hoiso', CAST(N'2019-12-12T14:22:17.657' AS DateTime), N'A', N'tscd_hoiso', CAST(N'2019-12-12T14:22:17.657' AS DateTime))
|
|
12
|
INSERT [dbo].[CM_HANGHOA_GROUP] ([HH_GROUP_ID], [HH_GROUP_CODE], [HH_GROUP_NAME], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT]) VALUES (N'HHG000000000021', N'XDPTML', N'Xây dựng cơ bản & Phát triển mạng lưới', N'', N'1', N'tscd_hoiso', CAST(N'2019-12-12T14:22:17.660' AS DateTime), N'A', N'tscd_hoiso', CAST(N'2019-12-12T14:22:17.660' AS DateTime))
|