

/****** Object:  View [dbo].[ApiOfficesView]    Script Date: 13.09.2021 14:31:45 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE VIEW [dbo].[ApiOfficesView] as 
select Urz_UrzId Id, Urz_Akronim Code, RTRIM(Urz_Nazwa1 + ' '+ Urz_Nazwa2) Name, 
cast(Urz_TypUrzedu as int) OfficeType, '' Descritption,
Urz_KodPocztowy AdrrZip, Urz_Miasto AdrrCity, Urz_Ulica AdrrStreet, Urz_NrDomu AdrrNumber,   Urz_NrLokalu AdrrAppNumber, Urz_Kraj AdrrCountry,
Urz_Telefon Phone, Urz_TelefonSms Phone2, Urz_Email Email, 0 as Type
from CDN.Urzedy
GO


