Views [dbo].[al_bi_legaldet_view]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created10:33:18 PM Thursday, February 10, 2011
Last Modified10:33:18 PM Thursday, February 10, 2011
Columns
Name
LTTDID
LTSTRTDT
LTENDDT
LTCOMMNT
LTINCLTC
LTSECTN
CREATION_USER
CREATION_DATE
LAST_UPDATE_USER
LAST_UPDATE_DATE
VERSION_NUMBER
LEGALDOC_UUID
LEGALDOC_UUID_DISPLAY
TENANT
TENANT_DISPLAY
SQL Script
CREATE VIEW [dbo].[al_bi_legaldet_view]
AS
SELECT     LTTDID, LTSTRTDT, LTENDDT, LTCOMMNT, LTINCLTC, LTSECTN, CREATION_USER, CREATION_DATE, LAST_UPDATE_USER, LAST_UPDATE_DATE,
                      VERSION_NUMBER, LEGALDOC_UUID,dbo.al_bi_bintohexstr(LEGALDOC_UUID) AS LEGALDOC_UUID_DISPLAY, TENANT,dbo.al_bi_bintohexstr(TENANT) AS TENANT_DISPLAY
FROM         dbo.ARG_LEGALDET
GO
Uses