Project

General

Profile

UPDATE_HANGHOA.txt

Truong Nguyen Vu, 08/18/2020 12:01 PM

 
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'HH0000000103521',N'THQHCC-003-000011',N'Voucher',N'HHT000000000032',N'',NULL,N'',N'',NULL,N'',N'',N'1',N'admin',N'Aug 17 2020 11:41PM',N'A',N'admin',N'Aug 17 2020 11:41PM',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'HH0000000103522',N'THQHCC-003-000010',N'Decal',N'HHT000000000032',N'',NULL,N'',N'',NULL,N'',N'',N'1',N'admin',N'Aug 17 2020 11:42PM',N'A',N'admin',N'Aug 17 2020 11:42PM',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'HH0000000103523',N'THQHCC-003-000012',N'Sticker',N'HHT000000000032',N'',NULL,N'',N'',NULL,N'',N'',N'1',N'admin',N'Aug 17 2020 11:42PM',N'A',N'admin',N'Aug 17 2020 11:42PM',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'HH0000000103524',N'HCQT-003-000031',N'Dịch vụ phòng cháy chữa cháy',N'HHT000000000022',N'',NULL,N'',N'',NULL,N'',N'',N'1',N'admin',N'Aug 17 2020 11:43PM',N'A',N'admin',N'Aug 17 2020 11:43PM',N'')
5
INSERT INTO [SYS_HH_GROUP_LIMIT] ([HH_ID],[GROUP_LIMIT_ID],[TYPE_LIMIT])VALUES(N'HH0000000103521',N'SGL000000000019',N'TTCT')
6
INSERT INTO [SYS_HH_GROUP_LIMIT] ([HH_ID],[GROUP_LIMIT_ID],[TYPE_LIMIT])VALUES(N'HH0000000103522',N'SGL000000000019',N'TTCT')
7
INSERT INTO [SYS_HH_GROUP_LIMIT] ([HH_ID],[GROUP_LIMIT_ID],[TYPE_LIMIT])VALUES(N'HH0000000103523',N'SGL000000000019',N'TTCT')
8
INSERT INTO [SYS_HH_GROUP_LIMIT] ([HH_ID],[GROUP_LIMIT_ID],[TYPE_LIMIT])VALUES(N'HH0000000103521',N'SGL000000000099',N'CDT')
9
INSERT INTO [SYS_HH_GROUP_LIMIT] ([HH_ID],[GROUP_LIMIT_ID],[TYPE_LIMIT])VALUES(N'HH0000000103522',N'SGL000000000099',N'CDT')
10
INSERT INTO [SYS_HH_GROUP_LIMIT] ([HH_ID],[GROUP_LIMIT_ID],[TYPE_LIMIT])VALUES(N'HH0000000103523',N'SGL000000000099',N'CDT')
11
INSERT INTO [SYS_HH_GROUP_LIMIT] ([HH_ID],[GROUP_LIMIT_ID],[TYPE_LIMIT])VALUES(N'HH0000000103524',N'SGL000000000101',N'CDT')
12
INSERT INTO [SYS_HH_GROUP_LIMIT] ([HH_ID],[GROUP_LIMIT_ID],[TYPE_LIMIT])VALUES(N'HH0000000103524',N'SGL000000000014',N'TTCT')