CREATE VIEW [dbo].[al_bi_tenant_view]
AS
SELECT     id,dbo.al_bi_bintohexstr(id) AS id_display, name, tenant_number, service_provider, contact, logo, description, phone_number, fax_number, alt_phone, location,
                      inactive, version_number, creation_user, creation_date, last_update_user, last_update_date, tenant, ldap_tenant_group, parent, fkey_group,
                      subtenants_ok, subtenant_group, supertenant_group, relatedtenant_group, tenant_depth, auto_rep_version, tou_id
FROM         dbo.ca_tenant
GO