|
1
|
DELETE FROM [CM_GOODSTYPE]
|
|
2
|
|
|
3
|
INSERT [dbo].[CM_GOODSTYPE] ([GD_TYPE_ID], [GD_TYPE_CODE], [GD_TYPE_NAME], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT]) VALUES (N'GOT000000000001', N'KH', N'Khác', N'GOT000000000001', N'1', N'thieuvq', CAST(N'2014-08-29T10:44:08.740' AS DateTime), N'A', N'tscd_cn', CAST(N'2014-08-29T10:44:19.933' AS DateTime))
|
|
4
|
INSERT [dbo].[CM_GOODSTYPE] ([GD_TYPE_ID], [GD_TYPE_CODE], [GD_TYPE_NAME], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT]) VALUES (N'GOT000000000003', N'LT-01', N'Chi phí đặc thù (Ngân sách)', N'GOT000000000003', N'1', N'luctv', CAST(N'2019-10-02T11:59:08.510' AS DateTime), N'U', NULL, NULL)
|
|
5
|
INSERT [dbo].[CM_GOODSTYPE] ([GD_TYPE_ID], [GD_TYPE_CODE], [GD_TYPE_NAME], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT]) VALUES (N'GOT000000000004', N'CE', N'Chi phí Capex', N'GOT000000000004', N'1', N'tscd_hoiso', CAST(N'2019-12-31T00:00:00.000' AS DateTime), N'A', N'tscd_hoiso', CAST(N'2019-12-31T00:00:00.000' AS DateTime))
|
|
6
|
INSERT [dbo].[CM_GOODSTYPE] ([GD_TYPE_ID], [GD_TYPE_CODE], [GD_TYPE_NAME], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT]) VALUES (N'GOT000000000005', N'OE', N'Chi phí Opex', N'GOT000000000005', N'1', N'tscd_hoiso', CAST(N'2019-12-31T00:00:00.000' AS DateTime), N'A', N'tscd_hoiso', CAST(N'2019-12-31T00:00:00.000' AS DateTime))
|
|
7
|
INSERT [dbo].[CM_GOODSTYPE] ([GD_TYPE_ID], [GD_TYPE_CODE], [GD_TYPE_NAME], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT]) VALUES (N'GOT000000000006', N'ST', N'Chi phí nhân viên', N'GOT000000000006', N'1', N'tscd_hoiso', CAST(N'2019-12-31T00:00:00.000' AS DateTime), N'A', N'tscd_hoiso', CAST(N'2019-12-31T00:00:00.000' AS DateTime))
|
|
8
|
INSERT [dbo].[CM_GOODSTYPE] ([GD_TYPE_ID], [GD_TYPE_CODE], [GD_TYPE_NAME], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT]) VALUES (N'GOT000000000007', N'OS', N'Chi phí dịch vụ', N'GOT000000000007', N'1', N'tscd_hoiso', CAST(N'2019-12-31T00:00:00.000' AS DateTime), N'A', N'tscd_hoiso', CAST(N'2019-12-31T00:00:00.000' AS DateTime))
|