CREATE VIEW [dbo].[al_bi_legaldoc_view]
AS
SELECT     LELGID, EXTERNAL_COMPANY_UUID, INTERNAL_COMPANY_UUID, LEDOCIDN, NEGOTIATOR_CONTACT_UUID, LEDESC, LEEFFDT, LETERMDT,
                      LEDOCLOC, LEELELOC, LEINACT, LESTATDT, LESTATUS, REQUESTOR_CONTACT_UUID, VENDOR_CONTACT_UUID, LECNUSED, GL_CODE,
                      COST_CENTER, CREATION_USER, CREATION_DATE, LAST_UPDATE_USER, LAST_UPDATE_DATE, VERSION_NUMBER, ORGANIZATION_UUID,
                      MANAGER_UUID, OWNER_UUID, COST_APPROVER_UUID, LEGALDOC_UUID,dbo.al_bi_bintohexstr(LEGALDOC_UUID) AS LEGALDOC_UUID_DISPLAY,
                      TENANT,dbo.al_bi_bintohexstr(TENANT) AS TENANT_DISPLAY
FROM         dbo.ARG_LEGALDOC
GO