SET QUOTED_IDENTIFIER OFF
GO
CREATE VIEW al_bi_company_view
AS
SELECT     company_uuid,'0x'+UPPER(dbo.hex(company_uuid)) AS company_uuid_display, parent_company_uuid, company_name, inactive, description, company_type, alias,
                      month_fiscal_year_ends, web_address, bbs, creation_user, creation_date, last_update_user, location_uuid, primary_contact_uuid, version_number,
                      last_update_date, exclude_registration, delete_time, authentication_user_name, authentication_password, source_type_id, auto_rep_version,
                      domain_uuid, tenant,'0x'+UPPER(dbo.hex(tenant)) as tenant_display, bsa_flag, siia_flag, fast_flag, user_priority_flag, employee_count, desktop_count, asset_count, authoritative
FROM         ca_company
GO