Project

General

Profile

UPDATE_HANGHOA.txt

Truong Nguyen Vu, 08/28/2020 08:29 AM

 
1
INSERT INTO [CM_HANGHOA] ([HH_ID],[HH_CODE],[HH_NAME],[HH_TYPE_ID],[USE_BRANCH],[AMORT_RATE],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_ID])VALUES(N'HH0000001058473',N'CNTT-010-000010',N'Phí khởi tạo/duy trì',N'HHT000000000010',N'',NULL,N'',N'',NULL,N'CMU000000000051',N'',N'1',N'cuongvd',N'Aug 26 2020  3:16PM',N'A',N'vanpt2',N'Aug 26 2020  3:16PM',N'')
2
INSERT INTO [CM_HANGHOA] ([HH_ID],[HH_CODE],[HH_NAME],[HH_TYPE_ID],[USE_BRANCH],[AMORT_RATE],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_ID])VALUES(N'HH0000001058474',N'CNTT-010-000011',N'Dịch vụ bảo mật',N'HHT000000000010',N'',NULL,N'',N'',NULL,N'CMU000000000051',N'',N'1',N'cuongvd',N'Aug 26 2020  3:16PM',N'A',N'vanpt2',N'Aug 26 2020  3:16PM',N'')
3
INSERT INTO [CM_HANGHOA] ([HH_ID],[HH_CODE],[HH_NAME],[HH_TYPE_ID],[USE_BRANCH],[AMORT_RATE],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_ID])VALUES(N'HH0000001058475',N'DVNS-001-000004',N'Dịch vụ đăng tuyển dụng (chi khác)',N'HHT000000000015',N'',NULL,N'',N'',NULL,N'CMU000000000051',N'',N'1',N'cuongvd',N'Aug 26 2020  3:16PM',N'A',N'vanpt2',N'Aug 26 2020  3:16PM',N'')
4
INSERT INTO [CM_HANGHOA] ([HH_ID],[HH_CODE],[HH_NAME],[HH_TYPE_ID],[USE_BRANCH],[AMORT_RATE],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_ID])VALUES(N'HH0000001058476',N'HCQT-002-000035',N'Bao thư',N'HHT000000000021',N'',NULL,N'',N'',NULL,N'CMU000000000047',N'',N'1',N'cuongvd',N'Aug 26 2020  3:16PM',N'A',N'vanpt2',N'Aug 26 2020  3:16PM',N'')
5
INSERT INTO [CM_HANGHOA] ([HH_ID],[HH_CODE],[HH_NAME],[HH_TYPE_ID],[USE_BRANCH],[AMORT_RATE],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_ID])VALUES(N'HH0000001058477',N'HCQT-002-000036',N'Giấy tiêu đề',N'HHT000000000021',N'',NULL,N'',N'',NULL,N'CMU000000000047',N'',N'1',N'cuongvd',N'Aug 26 2020  3:16PM',N'A',N'vanpt2',N'Aug 26 2020  3:16PM',N'')
6
INSERT INTO [CM_HANGHOA] ([HH_ID],[HH_CODE],[HH_NAME],[HH_TYPE_ID],[USE_BRANCH],[AMORT_RATE],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_ID])VALUES(N'HH0000001058478',N'HCQT-002-000037',N'Bìa trình ký',N'HHT000000000021',N'',NULL,N'',N'',NULL,N'CMU000000000047',N'',N'1',N'cuongvd',N'Aug 26 2020  3:16PM',N'A',N'vanpt2',N'Aug 26 2020  3:16PM',N'')
7
INSERT INTO [CM_HANGHOA] ([HH_ID],[HH_CODE],[HH_NAME],[HH_TYPE_ID],[USE_BRANCH],[AMORT_RATE],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_ID])VALUES(N'HH0000001058479',N'HCQT-002-000038',N'Bìa hồ sơ cấp tín dụng',N'HHT000000000021',N'',NULL,N'',N'',NULL,N'CMU000000000046',N'',N'1',N'cuongvd',N'Aug 26 2020  3:16PM',N'A',N'vanpt2',N'Aug 26 2020  3:16PM',N'')
8
INSERT INTO [CM_HANGHOA] ([HH_ID],[HH_CODE],[HH_NAME],[HH_TYPE_ID],[USE_BRANCH],[AMORT_RATE],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_ID])VALUES(N'HH0000001058480',N'HCQT-002-000039',N'Kệ mica',N'HHT000000000021',N'',NULL,N'',N'',NULL,N'CMU000000000047',N'',N'1',N'cuongvd',N'Aug 26 2020  3:16PM',N'A',N'vanpt2',N'Aug 26 2020  3:16PM',N'')
9
INSERT INTO [CM_HANGHOA] ([HH_ID],[HH_CODE],[HH_NAME],[HH_TYPE_ID],[USE_BRANCH],[AMORT_RATE],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_ID])VALUES(N'HH0000001058481',N'HCQT-002-000040',N'Hộp mica',N'HHT000000000021',N'',NULL,N'',N'',NULL,N'CMU000000000047',N'',N'1',N'cuongvd',N'Aug 26 2020  3:16PM',N'A',N'vanpt2',N'Aug 26 2020  3:16PM',N'')
10
INSERT INTO [CM_HANGHOA] ([HH_ID],[HH_CODE],[HH_NAME],[HH_TYPE_ID],[USE_BRANCH],[AMORT_RATE],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_ID])VALUES(N'HH0000001058482',N'HCQT-002-000041',N'Túi PE',N'HHT000000000021',N'',NULL,N'',N'',NULL,N'CMU000000000047',N'',N'1',N'cuongvd',N'Aug 26 2020  3:16PM',N'A',N'vanpt2',N'Aug 26 2020  3:16PM',N'')
11
INSERT INTO [CM_HANGHOA] ([HH_ID],[HH_CODE],[HH_NAME],[HH_TYPE_ID],[USE_BRANCH],[AMORT_RATE],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_ID])VALUES(N'HH0000001058483',N'HCQT-002-000042',N'Ly giấy',N'HHT000000000021',N'',NULL,N'',N'',NULL,N'CMU000000000047',N'',N'1',N'cuongvd',N'Aug 26 2020  3:16PM',N'A',N'vanpt2',N'Aug 26 2020  3:16PM',N'')
12
INSERT INTO [CM_HANGHOA] ([HH_ID],[HH_CODE],[HH_NAME],[HH_TYPE_ID],[USE_BRANCH],[AMORT_RATE],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_ID])VALUES(N'HH0000001058484',N'HCQT-002-000043',N'Hộp khăn giấy',N'HHT000000000021',N'',NULL,N'',N'',NULL,N'CMU000000000052',N'',N'1',N'cuongvd',N'Aug 26 2020  3:16PM',N'A',N'vanpt2',N'Aug 26 2020  3:16PM',N'')
13
INSERT INTO [CM_HANGHOA] ([HH_ID],[HH_CODE],[HH_NAME],[HH_TYPE_ID],[USE_BRANCH],[AMORT_RATE],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_ID])VALUES(N'HH0000001058485',N'HCQT-003-000031',N'Dịch vụ phòng cháy chữa cháy',N'HHT000000000022',N'',NULL,N'',N'',NULL,N'CMU000000000051',N'',N'1',N'cuongvd',N'Aug 26 2020  3:16PM',N'A',N'vanpt2',N'Aug 26 2020  3:16PM',N'')
14
INSERT INTO [CM_HANGHOA] ([HH_ID],[HH_CODE],[HH_NAME],[HH_TYPE_ID],[USE_BRANCH],[AMORT_RATE],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_ID])VALUES(N'HH0000001058486',N'HCQT-003-000032',N'Rửa xe',N'HHT000000000022',N'',NULL,N'',N'',NULL,N'CMU000000000051',N'',N'1',N'cuongvd',N'Aug 26 2020  3:16PM',N'A',N'vanpt2',N'Aug 26 2020  3:16PM',N'')
15
INSERT INTO [CM_HANGHOA] ([HH_ID],[HH_CODE],[HH_NAME],[HH_TYPE_ID],[USE_BRANCH],[AMORT_RATE],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_ID])VALUES(N'HH0000001058487',N'HCQT-003-000033',N'Công tác phí',N'HHT000000000022',N'',NULL,N'',N'',NULL,N'CMU000000000051',N'',N'1',N'cuongvd',N'Aug 26 2020  3:16PM',N'A',N'vanpt2',N'Aug 26 2020  3:16PM',N'')
16
INSERT INTO [CM_HANGHOA] ([HH_ID],[HH_CODE],[HH_NAME],[HH_TYPE_ID],[USE_BRANCH],[AMORT_RATE],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_ID])VALUES(N'HH0000001058488',N'HCQT-003-000034',N'Ấn phẩm Tết',N'HHT000000000022',N'',NULL,N'',N'',NULL,N'CMU000000000051',N'',N'1',N'cuongvd',N'Aug 26 2020  3:16PM',N'A',N'vanpt2',N'Aug 26 2020  3:16PM',N'')
17
INSERT INTO [CM_HANGHOA] ([HH_ID],[HH_CODE],[HH_NAME],[HH_TYPE_ID],[USE_BRANCH],[AMORT_RATE],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_ID])VALUES(N'HH0000001058489',N'SPMKT-001-000004',N'Vàng',N'HHT000000000024',N'',NULL,N'',N'',NULL,NULL,N'',N'1',N'cuongvd',N'Aug 26 2020  3:16PM',N'A',N'vanpt2',N'Aug 26 2020  3:16PM',N'')
18
INSERT INTO [CM_HANGHOA] ([HH_ID],[HH_CODE],[HH_NAME],[HH_TYPE_ID],[USE_BRANCH],[AMORT_RATE],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_ID])VALUES(N'HH0000001058490',N'SPMKT-001-000005',N'Bộ tách trà',N'HHT000000000024',N'',NULL,N'',N'',NULL,NULL,N'',N'1',N'cuongvd',N'Aug 26 2020  3:16PM',N'A',N'vanpt2',N'Aug 26 2020  3:16PM',N'')
19
INSERT INTO [CM_HANGHOA] ([HH_ID],[HH_CODE],[HH_NAME],[HH_TYPE_ID],[USE_BRANCH],[AMORT_RATE],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_ID])VALUES(N'HH0000001058491',N'SPMKT-001-000006',N'Ly',N'HHT000000000024',N'',NULL,N'',N'',NULL,NULL,N'',N'1',N'cuongvd',N'Aug 26 2020  3:16PM',N'A',N'vanpt2',N'Aug 26 2020  3:16PM',N'')
20
INSERT INTO [CM_HANGHOA] ([HH_ID],[HH_CODE],[HH_NAME],[HH_TYPE_ID],[USE_BRANCH],[AMORT_RATE],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_ID])VALUES(N'HH0000001058492',N'THQHCC-002-000006',N'Tổ chức hội nghị sơ kết, tổng kết (ĐVKD, Khối, Trung tâm, Phòng ban HS)',N'HHT000000000031',N'',NULL,N'',N'',NULL,N'CMU000000000051',N'',N'1',N'cuongvd',N'Aug 26 2020  3:16PM',N'A',N'vanpt2',N'Aug 26 2020  3:16PM',N'')
21
INSERT INTO [CM_HANGHOA] ([HH_ID],[HH_CODE],[HH_NAME],[HH_TYPE_ID],[USE_BRANCH],[AMORT_RATE],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_ID])VALUES(N'HH0000001058493',N'THQHCC-003-000010',N'Decal',N'HHT000000000030',N'',NULL,N'',N'',NULL,N'CMU000000000051',N'',N'1',N'cuongvd',N'Aug 26 2020  3:16PM',N'A',N'vanpt2',N'Aug 26 2020  3:16PM',N'')
22
INSERT INTO [CM_HANGHOA] ([HH_ID],[HH_CODE],[HH_NAME],[HH_TYPE_ID],[USE_BRANCH],[AMORT_RATE],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_ID])VALUES(N'HH0000001058494',N'THQHCC-003-000011',N'Voucher',N'HHT000000000030',N'',NULL,N'',N'',NULL,N'CMU000000000051',N'',N'1',N'cuongvd',N'Aug 26 2020  3:16PM',N'A',N'vanpt2',N'Aug 26 2020  3:16PM',N'')
23
INSERT INTO [CM_HANGHOA] ([HH_ID],[HH_CODE],[HH_NAME],[HH_TYPE_ID],[USE_BRANCH],[AMORT_RATE],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_ID])VALUES(N'HH0000001058495',N'THQHCC-003-000012',N'Sticker',N'HHT000000000030',N'',NULL,N'',N'',NULL,N'CMU000000000051',N'',N'1',N'cuongvd',N'Aug 26 2020  3:16PM',N'A',N'vanpt2',N'Aug 26 2020  3:16PM',N'')
24
INSERT INTO [CM_HANGHOA] ([HH_ID],[HH_CODE],[HH_NAME],[HH_TYPE_ID],[USE_BRANCH],[AMORT_RATE],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_ID])VALUES(N'HHI000000000001',N'HCQT-003-000035',N'Sửa chữa',N'HHT000000000022',N'',NULL,N'',N'',NULL,N'',N'',N'1',N'admin',N'Aug 28 2020 12:15AM',N'A',N'admin',N'Aug 28 2020 12:15AM',N'')
25
INSERT INTO [CM_HANGHOA] ([HH_ID],[HH_CODE],[HH_NAME],[HH_TYPE_ID],[USE_BRANCH],[AMORT_RATE],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_ID])VALUES(N'HHI000000000002',N'HCQT-003-000036',N'Bảo trì máy móc',N'HHT000000000022',N'',NULL,N'',N'',NULL,N'',N'',N'1',N'admin',N'Aug 28 2020 12:15AM',N'A',N'admin',N'Aug 28 2020 12:15AM',N'')
26
INSERT INTO [CM_HANGHOA] ([HH_ID],[HH_CODE],[HH_NAME],[HH_TYPE_ID],[USE_BRANCH],[AMORT_RATE],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_ID])VALUES(N'HHI000000000003',N'HCQT-003-000037',N'Bơm bình chữa cháy',N'HHT000000000022',N'',NULL,N'',N'',NULL,N'',N'',N'1',N'admin',N'Aug 28 2020 12:16AM',N'A',N'admin',N'Aug 28 2020 12:16AM',N'')
27
INSERT INTO [CM_HANGHOA] ([HH_ID],[HH_CODE],[HH_NAME],[HH_TYPE_ID],[USE_BRANCH],[AMORT_RATE],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_ID])VALUES(N'HHI000000000004',N'HCQT-003-000038',N'Bột khô bình chữa cháy',N'HHT000000000022',N'',NULL,N'',N'',NULL,N'',N'',N'1',N'admin',N'Aug 28 2020 12:16AM',N'A',N'admin',N'Aug 28 2020 12:16AM',N'')