CREATE TABLE [dbo].[DM_ORGANIZATION_NEW](
	[ORGANIZATION_ID] [nvarchar](20) NOT NULL,
	[ORGANIZATION_NAME] [nvarchar](100) NOT NULL,
	[PARENT_ORGANIZATION_D] [nvarchar](20) NOT NULL,
	[OLD_ORGANIZATION_ID1] [nvarchar](20) NOT NULL,
 CONSTRAINT [PK_DM_ORGANIZATION_NEW] PRIMARY KEY CLUSTERED 
(
	[ORGANIZATION_ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
CREATE INDEX ORGANIZATION_NEW1 ON DM_ORGANIZATION_NEW(OLD_ORGANIZATION_ID1)
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '000000',N'Tổng công ty Gas Petrolimex (Tổng hợp)','','000000')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '100000',N'Tổng công ty Gas Petrolimex (Cty mẹ)','000000','100000')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111000',N'Văn phòng Tổng công ty Gas Petrolimex ','100000','101000')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111001',N'Hội đồng quản trị, Ban kiểm soát, Kiểm soát viên','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111002',N'Ban Tổng giám đốc','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111003',N'Ban Tổng hợp','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111004',N'Phòng Kế toán tài chính','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111005',N'Phòng tổ chức hành chính','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111006',N'Phòng công nghệ đầu tư, quản lý kĩ thuật dịch vụ','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111007',N'Phòng công nghệ thông tin','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111008',N'Phòng xuất nhập khẩu tổng hợp','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111009',N'Phòng kinh doanh Gas công nghiệp','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111010',N'Phòng kinh doanh gas dân dụng thương mại','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111011',N'Phòng kinh doanh đại lý','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111012',N'Phòng kinh doanh bán lẻ','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111013',N'Phòng kinh doanh trực tiếp','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111014',N'Bộ phận bán hàng','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111019',N'Quản lý chung và các đối tượng khác','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111100',N'Kho đầu mối','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111101',N'Kho Gas Đình Vũ','111000','101102')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111102',N'Kho Gas Thượng Lý','111000','101103')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111103',N'Kho Gas X50','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111104',N'Kho Gas Nại Hiên','111000','101104')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111105',N'Kho Gas Thọ Quang','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111106',N'Kho Gas Nhà Bè','111000','101105')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111107',N'Kho Gas Trà Nóc','111000','101106')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111200',N'Kho chiết nạp tuyến sau','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111201',N'Kho Gas Đức Giang','111000','101101')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111300',N'Kho trung chuyển, kho chuyển thẳng','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111301',N'Kho chuyển thẳng','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111400',N'Đội vận tải Gas rời','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111401',N'Xe 15C-05097','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111402',N'Xe 29X-5114','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111403',N'Xe 16L-0830','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111404',N'Xe 16L-0843','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111405',N'Xe 16K-6407','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111406',N'Xe 16K-4328','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111407',N'Xe 29C-00078','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111408',N'Xe Wagon 29L-0632','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111499',N'Bộ phận quản lý trực tiếp Đội vận tải gas rời','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111500',N'Đội vận tải Gas bình','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111501',N'Xe biển số: …………………..','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111502',N'Xe biển số: …………………..','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111503',N'Xe biển số: …………………..','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111599',N'Bộ phận quản lý trực tiếp Đội vận tải gas bình','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111600',N'Tổ dịch vụ','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111601',N'Tổ dịch vụ','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111700',N'Trung tâm tư vấn khách hàng','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111701',N'Trung tâm tư vấn khách hàng','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111800',N'Trung tâm bán hàng','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111801',N'Trung tâm bán hàng số ……','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111900',N'Các Cửa hàng Gas','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '111901',N'Cửa hàng Gas số ….','111000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '112000',N'Chi nhánh Tổng công ty Gas Petrolimex tại Phú Thọ','111000','101200')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '112001',N'Cửa hàng 01 (Phú Thọ)','112000','101201')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '112002',N'Cửa hàng 02 (Phú Thọ)','112000','101202')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '112097',N'Xe 30L - 1711 (xe 5.2 tấn)','112000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '112098',N'Trạm chiết Chi nhánh Gas petrolimex phú thọ','112000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '112099',N'Văn phòng Chi nhánh Gas petrolimex phú thọ','112000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '112100',N'Chi nhánh Tổng công ty Gas Petrolimex tại Bắc Ninh','111000','101300')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '112101',N'Cửa hàng 01 (Bắc Ninh)','112100','101301')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '112102',N'Cửa hàng 02 (Bắc Ninh)','112100','101302')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '112199',N'Văn phòng Chi nhánh Gas petrolimex Bắc Ninh','112100','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121000',N'Chi nhánh Tổng công ty Gas Petrolimex tại Hà Nội','111000','102000')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121002',N'Ban giám đốc','121000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121004',N'Phòng Kế toán tài chính','121000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121005',N'Phòng tổ chức hành chính','121000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121006',N'Phòng Quản lý kĩ thuật dịch vụ','121000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121010',N'Phòng kinh doanh gas ','121000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121014',N'Bộ phận bán hàng','121000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121300',N'Kho trung chuyển, kho chuyển thẳng','121000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121301',N'Kho chuyển thẳng','121000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121302',N'Kho trung chuyển số….','121000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121400',N'Đội vận tải Gas rời','121000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121401',N'Xe biển số: …………………..','121000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121402',N'Xe biển số: …………………..','121000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121403',N'Xe biển số: …………………..','121000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121499',N'Bộ phận quản lý trực tiếp Đội vận tải gas rời','121000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121500',N'Đội vận tải Gas bình','121000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121501',N'Xe biển số 30L 5736 (1.25 tấn)','121000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121599',N'Bộ phận quản lý trực tiếp Đội vận tải gas bình','121000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121600',N'Tổ dịch vụ','121000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121601',N'Tổ dịch vụ','121000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121700',N'Trung tâm tư vấn khách hàng','121000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121701',N'Trung tâm tư vấn khách hàng Hà Nội','121000','102135')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121800',N'Trung tâm phân phối, Trung tâm bán hàng','121000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121801',N'Trung tâm pân phối Hà Nội','121000','102001')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121802',N'Trung tâm bán hàng số ……','121000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121900',N'Các Cửa hàng Gas','121000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121901',N'Cửa hàng 01 (Hà Nội)','121000','102101')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121902',N'Cửa hàng 02 (Hà Nội)','121000','102102')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121903',N'Cửa hàng 03 (Hà Nội)','121000','102103')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121904',N'Cửa hàng 04 (Hà Nội)','121000','102104')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121905',N'Cửa hàng 05 (Hà Nội)','121000','102105')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121906',N'Cửa hàng 06 (Hà Nội)','121000','102106')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121907',N'Cửa hàng 07 (Hà Nội)','121000','102107')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121908',N'Cửa hàng 08 (Hà Nội)','121000','102108')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121909',N'Cửa hàng 09 (Hà Nội)','121000','102109')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121910',N'Cửa hàng 10 (Hà Nội)','121000','102110')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121911',N'Cửa hàng 11 (Hà Nội)','121000','102111')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121912',N'Cửa hàng 12 (Hà Nội)','121000','102112')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121913',N'Cửa hàng 13 (Hà Nội)','121000','102113')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121914',N'Cửa hàng 14 (Hà Nội)','121000','102114')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121915',N'Cửa hàng 15 (Hà Nội)','121000','102115')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121916',N'Cửa hàng 16 (Hà Nội)','121000','102116')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121917',N'Cửa hàng 17 (Hà Nội)','121000','102117')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121918',N'Cửa hàng 18 (Hà Nội)','121000','102118')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121919',N'Cửa hàng 19 (Hà Nội)','121000','102119')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121920',N'Cửa hàng 20 (Hà Nội)','121000','102120')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121921',N'Cửa hàng 21 (Hà Nội)','121000','102121')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121922',N'Cửa hàng 22 (Hà Nội)','121000','102122')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121923',N'Cửa hàng 23 (Hà Nội)','121000','102123')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121924',N'Cửa hàng 24 (Hà Nội)','121000','102124')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121925',N'Cửa hàng 25 (Hà Nội)','121000','102125')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121926',N'Cửa hàng 26 (Hà Nội)','121000','102126')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121927',N'Cửa hàng 27 (Hà Nội)','121000','102127')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121928',N'Cửa hàng 28 (Hà Nội)','121000','102128')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121929',N'Cửa hàng 29 (Hà Nội)','121000','102129')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121930',N'Cửa hàng 30 (Hà Nội)','121000','102130')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121931',N'Cửa hàng 31 (Hà Nội)','121000','102131')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121932',N'Cửa hàng 32 (Hà Nội)','121000','102132')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121933',N'Cửa hàng 33 (Hà Nội)','121000','102133')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '121934',N'Cửa hàng 34 (Hà Nội)','121000','102134')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '300000',N'Công ty TNHH Gas Petrolimex Hải Phòng','000000','300000')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311000',N'Văn phòng Công ty TNHH Gas Petrolimex Hải Phòng','300000','301000')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311001',N'Chủ tịch công ty, kiểm soát viên','311000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311002',N'Ban giám đốc','311000','301005')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311004',N'Phòng Kế toán tài chính','311000','301009')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311005',N'Phòng tổ chức hành chính','311000','301006')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311006',N'Phòng công nghệ đầu tư, quản lý kĩ thuật dịch vụ','311000','301008')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311007',N'Phòng công nghệ thông tin','311000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311009',N'Phòng kinh doanh Gas công nghiệp','311000','301007')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311010',N'Phòng kinh doanh gas dân dụng thương mại','311000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311014',N'Bộ phận bán hàng','311000','301004')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311019',N'Quản lý chung và các đối tượng khác','311000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311300',N'Kho trung chuyển, kho chuyển thẳng','311000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311301',N'Kho chuyển thẳng','311000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311400',N'Đội vận tải Gas rời','311000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311401',N'Xe biển số: …………………..','311000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311402',N'Xe biển số: …………………..','311000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311403',N'Xe biển số: …………………..','311000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311499',N'Bộ phận quản lý trực tiếp Đội vận tải gas rời','311000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311500',N'Đội vận tải Gas bình','311000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311501',N'Xe 16H - 8462','311000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311502',N'Xe 16L - 6267','311000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311503',N'Xe 16L- 2231','311000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311504',N'Xe 16M - 4045','311000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311505',N'Xe 16N - 3027','311000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311599',N'Bộ phận quản lý trực tiếp Đội vận tải gas bình','311000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311600',N'Tổ dịch vụ','311000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311601',N'Tổ dịch vụ','311000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311700',N'Trung tâm tư vấn khách hàng','311000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311701',N'Trung tâm tư vấn khách hàng','311000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311800',N'Trung tâm phân phối, Trung tâm bán hàng','311000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311801',N'Trung tâm phân phối 01 (Hải Phòng)','311000','301001')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311802',N'Trung tâm phân phối 02  (Hải Phòng)','311000','301002')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311803',N'Trung tâm phân phối 03  (Hải Phòng)','311000','301003')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311900',N'Các Cửa hàng Gas','311000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311901',N'Cửa hàng 01 (Hải Phòng)','311000','301101')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311902',N'Cửa hàng 02  (Hải Phòng)','311000','301102')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311903',N'Cửa hàng 03  (Hải Phòng)','311000','301103')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311904',N'Cửa hàng 04  (Hải Phòng)','311000','301104')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311905',N'Cửa hàng 05  (Hải Phòng)','311000','301105')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311906',N'Cửa hàng 06  (Hải Phòng)','311000','301106')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311907',N'Cửa hàng 07  (Hải Phòng)','311000','301107')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '311908',N'Cửa hàng 08 (Hải Phòng)','311000','301108')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312000',N'Chi nhánh Gas Petrolimex Hải Dương','311000','301200')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312001',N'Cửa hàng 01 (Hải Dương)','312000','301201')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312002',N'Cửa hàng 02 (Hải Dương)','312000','301202')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312098',N'Xe 16L-0534','312000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312099',N'Văn phòng Chi nhánh Gas petrolimex Hải Dương','312000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312100',N'Chi nhánh Gas Petrolimex Quảng Ninh','311000','301400')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312101',N'Cửa hàng 01 (Quảng Ninh)','312100','301401')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312102',N'Cửa hàng 02  (Quảng Ninh)','312100','301402')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312103',N'Cửa hàng 03  (Quảng Ninh)','312100','301403')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312104',N'Cửa hàng 04  (Quảng Ninh)','312100','301404')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312105',N'Cửa hàng 05  (Quảng Ninh)','312100','301405')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312106',N'Cửa hàng 06  (Quảng Ninh)','312100','301406')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312108',N'Cửa hàng 08  (Quảng Ninh)','312100','301408')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312196',N'Xe 16L - 1349','312100','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312197',N'Xe 30L - 1287','312100','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312198',N'Trạm chiết Chi nhánh Gas petrolimex Quảng Ninh','312100','301420')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312199',N'Văn phòng Chi nhánh Gas petrolimex Quảng Ninh','312100','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312200',N'Chi nhánh Gas Petrolimex Hà Nam','311000','301500')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312201',N'Cửa hàng 01 (Hà Nam)','312200','301501')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312299',N'Văn phòng Chi nhánh Gas petrolimex Hà Nam','312200','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312300',N'Chi nhánh Gas Petrolimex Nam Định','311000','301600')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312301',N'Cửa hàng 01 (Nam Định)','312300','301601')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312302',N'Cửa hàng 02 (Nam Định)','312300','301602')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312399',N'Văn phòng Chi nhánh Gas petrolimex Nam Định','312300','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312400',N'Chi nhánh Gas Petrolimex Ninh Bình','311000','301700')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312401',N'Cửa hàng 01 (Ninh Bình)','312400','301701')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312402',N'Cửa hàng 02 (Ninh Bình)','312400','301702')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312403',N'Cửa hàng 03 (Ninh Bình)','312400','301703')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312497',N'Xe 16L - 8530','312400','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312498',N'Trạm chiết Chi nhánh Gas petrolimex Ninh Bình','312400','301706')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312499',N'Văn phòng Chi nhánh Gas petrolimex Ninh Bình','312400','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312500',N'Chi nhánh Gas Petrolimex Nghệ An','311000','301800')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312501',N'Cửa hàng 01 (Nghệ An)','312500','301801')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312598',N'Trạm chiết Chi nhánh Gas petrolimex Nghệ An','312500','301802')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312599',N'Văn phòng Chi nhánh Gas petrolimex Nghệ An','312500','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312600',N'Chi nhánh Gas Petrolimex Thái Bình','311000','301900')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312601',N'Cửa hàng 01 (Thái Bình)','312600','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312699',N'Văn phòng Chi nhánh Gas petrolimex Thái Bình','312600','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312700',N'Chi nhánh Gas Petrolimex Hưng Yên','311000','302000')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312701',N'Cửa hàng 01 (Hưng Yên)','312700','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '312799',N'Văn phòng Chi nhánh Gas petrolimex Hưng Yên','312700','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '400000',N'Công ty TNHH Gas Petrolimex Hà Nội','000000','400000')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411000',N'Văn phòng Công ty TNHH Gas Petrolimex Hà Nội','400000','401000')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411001',N'Chủ tịch công ty, kiểm soát viên','411000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411002',N'Ban giám đốc','411000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411004',N'Phòng Kế toán tài chính','411000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411005',N'Phòng tổ chức hành chính','411000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411006',N'Phòng Quản lý kĩ thuật dịch vụ','411000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411010',N'Phòng kinh doanh gas ','411000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411014',N'Bộ phận bán hàng','411000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411019',N'Quản lý chung và các đối tượng khác','411000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411300',N'Kho trung chuyển, kho chuyển thẳng','411000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411301',N'Kho chuyển thẳng','411000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411302',N'Kho trung chuyển số….','411000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411400',N'Đội vận tải Gas rời','411000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411401',N'Xe biển số: …………………..','411000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411402',N'Xe biển số: …………………..','411000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411403',N'Xe biển số: …………………..','411000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411499',N'Bộ phận quản lý trực tiếp Đội vận tải gas rời','411000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411500',N'Đội vận tải Gas bình','411000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411501',N'Xe biển số 30L 5736 (1.25 tấn)','411000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411502',N'Xe biển số: …………………..','411000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411503',N'Xe biển số: …………………..','411000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411599',N'Bộ phận quản lý trực tiếp Đội vận tải gas bình','411000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411600',N'Tổ dịch vụ','411000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411601',N'Tổ dịch vụ','411000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411700',N'Trung tâm tư vấn khách hàng','411000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411701',N'Trung tâm tư vấn khách hàng Hà Nội','411000','401135')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411800',N'Trung tâm phân phối, Trung tâm bán hàng','411000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411801',N'Trung tâm pân phối Hà Nội','411000','401001')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411802',N'Trung tâm bán hàng số ……','411000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411900',N'Các Cửa hàng Gas','411000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411901',N'Cửa hàng 01 (Hà Nội)','411000','401101')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411902',N'Cửa hàng 02 (Hà Nội)','411000','401102')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411903',N'Cửa hàng 03 (Hà Nội)','411000','401103')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411904',N'Cửa hàng 04 (Hà Nội)','411000','401104')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411905',N'Cửa hàng 05 (Hà Nội)','411000','401105')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411906',N'Cửa hàng 06 (Hà Nội)','411000','401106')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411907',N'Cửa hàng 07 (Hà Nội)','411000','401107')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411908',N'Cửa hàng 08 (Hà Nội)','411000','401108')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411909',N'Cửa hàng 09 (Hà Nội)','411000','401109')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411910',N'Cửa hàng 10 (Hà Nội)','411000','401110')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411911',N'Cửa hàng 11 (Hà Nội)','411000','401111')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411912',N'Cửa hàng 12 (Hà Nội)','411000','401112')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411913',N'Cửa hàng 13 (Hà Nội)','411000','401113')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411914',N'Cửa hàng 14 (Hà Nội)','411000','401114')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411915',N'Cửa hàng 15 (Hà Nội)','411000','401115')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411916',N'Cửa hàng 16 (Hà Nội)','411000','401116')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411917',N'Cửa hàng 17 (Hà Nội)','411000','401117')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411918',N'Cửa hàng 18 (Hà Nội)','411000','401118')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411919',N'Cửa hàng 19 (Hà Nội)','411000','401119')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411920',N'Cửa hàng 20 (Hà Nội)','411000','401120')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411921',N'Cửa hàng 21 (Hà Nội)','411000','401121')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411922',N'Cửa hàng 22 (Hà Nội)','411000','401122')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411923',N'Cửa hàng 23 (Hà Nội)','411000','401123')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411924',N'Cửa hàng 24 (Hà Nội)','411000','401124')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411925',N'Cửa hàng 25 (Hà Nội)','411000','401125')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411926',N'Cửa hàng 26 (Hà Nội)','411000','401126')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411927',N'Cửa hàng 27 (Hà Nội)','411000','401127')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411928',N'Cửa hàng 28 (Hà Nội)','411000','401128')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411929',N'Cửa hàng 29 (Hà Nội)','411000','401129')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411930',N'Cửa hàng 30 (Hà Nội)','411000','401130')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411931',N'Cửa hàng 31 (Hà Nội)','411000','401131')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411932',N'Cửa hàng 32 (Hà Nội)','411000','401132')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411933',N'Cửa hàng 33 (Hà Nội)','411000','401133')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '411934',N'Cửa hàng 34 (Hà Nội)','411000','401134')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '500000',N'Công ty TNHH Gas Petrolimex Đà Nẵng','000000','500000')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511000',N'Văn phòng Công ty TNHH Gas Petrolimex Đà Nẵng','500000','501000')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511001',N'Chủ tịch công ty, kiểm soát viên','511000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511002',N'Ban giám đốc','511000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511004',N'Phòng Kế toán tài chính','511000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511005',N'Phòng tổ chức hành chính','511000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511006',N'Phòng công nghệ đầu tư, quản lý kĩ thuật dịch vụ','511000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511007',N'Phòng công nghệ thông tin','511000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511009',N'Phòng kinh doanh Gas công nghiệp','511000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511010',N'Phòng kinh doanh gas dân dụng thương mại','511000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511014',N'Bộ phận bán hàng','511000','501001')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511019',N'Quản lý chung và các đối tượng khác','511000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511300',N'Kho trung chuyển, kho chuyển thẳng','511000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511301',N'Kho chuyển thẳng','511000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511400',N'Đội vận tải Gas rời','511000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511401',N'Xe biển số 43K -7817','511000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511499',N'Bộ phận quản lý trực tiếp Đội vận tải gas rời','511000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511500',N'Đội vận tải Gas bình','511000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511501',N'Xe biển số 43H - 4865','511000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511502',N'Xe biển số 43H - 4871','511000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511503',N'Xe biển số 43X - 3547','511000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511599',N'Bộ phận quản lý trực tiếp Đội vận tải gas bình','511000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511600',N'Tổ dịch vụ','511000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511601',N'Tổ dịch vụ','511000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511700',N'Trung tâm tư vấn khách hàng','511000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511701',N'Trung tâm tư vấn khách hàng','511000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511800',N'Trung tâm phân phối, Trung tâm bán hàng','511000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511900',N'Các Cửa hàng Gas','511000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511901',N'Cửa hàng 01 (Đà Nẵng)','511000','501101')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511902',N'Cửa hàng Ngô Quyền (Đà Nẵng)','511000','501110')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511903',N'Cửa hàng Thuận Phước (Đà Nẵng)','511000','501111')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511904',N'Cửa hàng Ngã Năm (Đà Nẵng)','511000','501105')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511905',N'Cửa hàng 05 (Đà Nẵng)','511000','501112')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511906',N'Cửa hàng Hòa Khánh (Đà Nẵng)','511000','501113')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511907',N'Cửa hàng 07 (Đà Nẵng)','511000','501107')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511908',N'Cửa hàng 08 (Đà Nẵng)','511000','501108')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '511909',N'Cửa hàng 09 (Đà Nẵng)','511000','501109')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '512000',N'Chi nhánh Gas Petrolimex Thừa Thiên Huế','511000','501200')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '512001',N'Cửa hàng 01 (Huế)','512000','501201')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '512002',N'Cửa hàng 02 (Huế)','512000','501202')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '512096',N'Xe biển số 43X - 4433','512000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '512097',N'Xe biển số 43K- 6419','512000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '512098',N'Trạm chiết Chi nhánh Gas petrolimex Huế','512000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '512099',N'Văn phòng Chi nhánh Gas petrolimex Huế','512000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '512100',N'Chi nhánh Gas Petrolimex Quảng Bình','511000','501300')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '512106',N'Cửa hàng 06 (Quảng Bình)','512100','501301')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '512197',N'Xe biển số 43C 03467','512100','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '512198',N'Trạm chiết Chi nhánh Gas petrolimex Quảng Bình','512100','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '512199',N'Văn phòng Chi nhánh Gas petrolimex Quảng Bình','512100','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '512200',N'Chi nhánh Gas Petrolimex Bình Định','511000','501400')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '512201',N'Cửa hàng 01 (Bình Định)','512200','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '512298',N'Xe biển số 43X - 4406','512200','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '512299',N'Văn phòng Chi nhánh Gas petrolimex Bình Định','512200','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '512300',N'Chi nhánh Gas Petrolimex Khánh Hòa','511000','501500')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '512301',N'Cửa hàng 01 (Khánh Hòa)','512300','501501')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '512302',N'Trạm chiết Chi nhánh Gas petrolimex Khánh Hòa','512300','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '512398',N'Xe biển số 43X - 0512','512300','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '512399',N'Văn phòng Chi nhánh Gas petrolimex Khánh Hòa','512300','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '700000',N'Công ty TNHH Gas Petrolimex Cần Thơ','000000','700000')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711000',N'Văn phòng Công ty TNHH Gas Petrolimex Cần Thơ','700000','701000')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711001',N'Chủ tịch công ty, kiểm soát viên','711000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711002',N'Ban giám đốc','711000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711004',N'Phòng Kế toán tài chính','711000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711005',N'Phòng tổ chức hành chính','711000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711006',N'Phòng công nghệ đầu tư, quản lý kĩ thuật dịch vụ','711000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711007',N'Phòng công nghệ thông tin','711000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711009',N'Phòng kinh doanh Gas công nghiệp','711000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711010',N'Phòng kinh doanh gas dân dụng thương mại','711000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711014',N'Bộ phận bán hàng','711000','701001')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711019',N'Quản lý chung và các đối tượng khác','711000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711300',N'Kho trung chuyển, kho chuyển thẳng','711000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711301',N'Kho chuyển thẳng','711000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711400',N'Đội vận tải Gas rời','711000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711401',N'Xe biển số 65N - 0845','711000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711499',N'Bộ phận quản lý trực tiếp Đội vận tải gas rời','711000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711500',N'Đội vận tải Gas bình','711000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711501',N'Xe biển số 65M - 2010','711000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711502',N'Xe biển số 65M - 2352','711000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711503',N'Xe biển số 65M - 2837','711000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711504',N'Xe biển số 65C - 01879','711000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711599',N'Bộ phận quản lý trực tiếp Đội vận tải gas bình','711000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711600',N'Tổ dịch vụ','711000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711601',N'Tổ dịch vụ','711000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711700',N'Trung tâm tư vấn khách hàng','711000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711701',N'Trung tâm tư vấn khách hàng','711000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711800',N'Trung tâm phân phối, Trung tâm bán hàng','711000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711900',N'Các Cửa hàng Gas','711000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711901',N'Cửa hàng 01 (Cần Thơ)','711000','701101')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711902',N'Cửa hàng 02 (Cần Thơ)','711000','701102')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711903',N'Cửa hàng 03 (Cần Thơ)','711000','701103')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711905',N'Cửa hàng 05 (Cần Thơ)','711000','701105')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711906',N'Cửa hàng Rạch Giá (Kiên Giang)','711000','701108')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711907',N'Cửa hàng Vị Thanh (Hậu Giang)','711000','701109')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711908',N'Cửa hàng Bạc Liêu (Bạc Liêu)','711000','701110')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711909',N'Cửa hàng Sóc Trăng (Sóc Trăng)','711000','701111')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711910',N'Cửa hàng Vĩnh Long (Vĩnh Long)','711000','701112')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '711911',N'Cửa hàng An Giang (An Giang)','711000','701113')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '712000',N'Chi nhánh Gas Petrolimex Phú Quốc','711000','701200')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '712001',N'Cửa hàng 01 (Phú Quốc)','712000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '712098',N'Xe biển số 65M - 2195','712000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '712099',N'Văn phòng Chi nhánh Gas petrolimex Phú Quốc','712000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '800000',N'Công ty TNHH Gas Petrolimex Sài Gòn','000000','800000')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811000',N'Văn phòng Công ty TNHH Gas Petrolimex Sài Gòn','800000','801000')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811001',N'Chủ tịch công ty, kiểm soát viên','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811002',N'Ban giám đốc','811000','801002')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811004',N'Phòng Kế toán tài chính','811000','801008')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811005',N'Phòng tổ chức hành chính','811000','801003')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811006',N'Phòng công nghệ đầu tư, quản lý kĩ thuật dịch vụ','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811007',N'Phòng công nghệ thông tin','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811008',N'Phòng DV-KT_BH Cty TNHH Gas Petrolimex Sài Gòn','811000','801004')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811009',N'Phòng kinh doanh Gas công nghiệp','811000','801007')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811010',N'Phòng kinh doanh gas dân dụng thương mại','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811011',N'Phòng Kinh doanh Đại lý Cty TNHH Gas Petrolimex Sài Gòn','811000','801005')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811012',N'Phòng Kinh doanh Trực tiếp Cty TNHH Gas Petrolimex Sài Gòn','811000','801006')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811014',N'Bộ phận bán hàng','811000','801001')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811019',N'Quản lý chung và các đối tượng khác','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811300',N'Kho trung chuyển, kho chuyển thẳng','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811301',N'Kho chuyển thẳng','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811302',N'Kho trung chuyển số …..','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811400',N'Đội vận tải Gas rời','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811401',N'Xe biển số 57K - 0087','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811402',N'Xe biển số 57K - 2410','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811403',N'Xe biển số 57K - 8543','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811404',N'Xe biển số 57K - 9889','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811405',N'Xe biển số 57K - 3178','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811499',N'Bộ phận quản lý trực tiếp Đội vận tải gas rời','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811500',N'Đội vận tải Gas bình','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811501',N'Xe biển số 54T - 6614','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811502',N'Xe biển số 54V-1413','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811503',N'Xe biển số 54V - 7281','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811504',N'Xe biển số  54Y - 4923','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811505',N'Xe biển số 54Z - 5098','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811506',N'Xe biển số 51C-086.34(4.7LW)','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811507',N'Xe biển số 54Y - 5258','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811508',N'Xe biển số 54Z-8486','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811509',N'Xe biển số 54Z - 8390','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811510',N'Xe biển số 54U - 1339','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811599',N'Bộ phận quản lý trực tiếp Đội vận tải gas bình','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811600',N'Tổ dịch vụ','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811601',N'Tổ dịch vụ','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811700',N'Trung tâm tư vấn khách hàng','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811701',N'Trung tâm tư vấn khách hàng','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811800',N'Trung tâm phân phối, Trung tâm bán hàng','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811801',N'Cửa hàng trung tâm số 01 (TPHCM)','811000','801101')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811802',N'Cửa hàng trung tâm số 02 (TPHCM)','811000','801102')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811900',N'Các Cửa hàng Gas','811000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811902',N'Cửa hàng 02 (TPHCM)','811000','801103')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811907',N'Cửa hàng 07 (TPHCM)','811000','801107')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811908',N'Cửa hàng 08 (TPHCM)','811000','801108')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811913',N'Cửa hàng 13 (TPHCM)','811000','801113')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811918',N'Cửa hàng 18 (TPHCM)','811000','801118')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811922',N'Cửa hàng 22 (TPHCM)','811000','801122')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811926',N'Cửa hàng 26 (TPHCM)','811000','801126')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811931',N'Cửa hàng 31 (TPHCM)','811000','801131')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811939',N'Cửa hàng 39 (TPHCM)','811000','801139')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '811948',N'Cửa hàng 48 (TPHCM)','811000','801148')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '812000',N'Chi nhánh Gas Petrolimex Bình Dương','811000','801200')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '812001',N'Cửa hàng 01 (Bình Dương)','812000','801201')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '812099',N'Văn phòng Chi nhánh Gas petrolimex Bình Dương','812000','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '812100',N'Chi nhánh Gas Petrolimex Tiền Giang','811000','801300')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '812101',N'Cửa hàng 01 (Tiền Giang)','812100','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '812102',N'Cửa hàng 02 (Tiền Giang)','812100','801301')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '812197',N'Xe biển số 63C - 011.30','812100','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '812198',N'Trạm chiết Chi nhánh Gas petrolimex Tiền Giang','812100','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '812199',N'Văn phòng Chi nhánh Gas petrolimex Tiền Giang','812100','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '812200',N'Chi nhánh Gas Petrolimex Vũng Tàu','811000','801400')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '812201',N'Cửa hàng 01 (Vũng Tàu)','812200','801401')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '812202',N'Cửa hàng 02 (Vũng Tàu)','812200','801402')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '812203',N'Cửa hàng 03 (Vũng Tàu)','812200','801403')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '812204',N'Cửa hàng 04 (Bình Thuận)','811000','801500')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '812297',N'Xe biển số 51C - 067.43','812200','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '812298',N'Trạm chiết Chi nhánh Gas petrolimex Vũng Tàu','812200','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '812299',N'Văn phòng Chi nhánh Gas petrolimex Vũng Tàu','812200','')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '812300',N'Chi nhánh Gas Petrolimex Lâm Đồng','811000','801600')
GO
INSERT INTO [DBO].[DM_ORGANIZATION_NEW]([ORGANIZATION_ID],[ORGANIZATION_NAME],[PARENT_ORGANIZATION_D],[OLD_ORGANIZATION_ID1]) Values( '812399',N'Văn phòng Chi nhánh Gas petrolimex Lâm Đồng','812300','')
GO
UPDATE DM_ORGANIZATION_NEW SET OLD_ORGANIZATION_ID1 = OLD_ORGANIZATION_ID1+'X' WHERE OLD_ORGANIZATION_ID1 <> '' AND OLD_ORGANIZATION_ID1 NOT LIKE '%X%'
GO