  
  CREATE VIEW dbo.ApiCustomerPersonsView as
  select KnO_KnOId Id, KnO_KnOId [CustPersonId], KnO_KntId [CustId],KnO_KntId [CustCustId],  0 [CustLocId],0 [CustLocLocId], 
  KnO_KntId ErpId, KnO_Nazwisko LastName, '' Name, KnO_Tytul [Position], KnO_Telefon Phone, KnO_GSM Phone2, KnO_Email Email, 
  '' Notes, 0 [VendorId], KnO_TS_Mod [TS], 0 SaveTS ,'' [DeviceUid], 0 [State],0 [CustErpId], 0 [CustLocErpId], 0 NotyficationType  from CDN.KntOsoby
