[dbo].[al_bi_legaldef

[dbo].[al_bi_legaldef_view]

(local) > mdb > Views > dbo.al_bi_legaldef_view

Properties
Columns
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	10:33:18 PM Thursday, February 10, 2011
Last Modified	10:33:18 PM Thursday, February 10, 2011

Columns

Name
LGID
LGTYPE
LGPROT
CREATION_USER
CREATION_DATE
LAST_UPDATE_USER
LAST_UPDATE_DATE
VERSION_NUMBER
SOURCE_TYPE_ID
TENANT
TENANT_DISPLAY

SQL Script

CREATE VIEW [dbo].[al_bi_legaldef_view]
AS
SELECT     LGID, LGTYPE, LGPROT, CREATION_USER, CREATION_DATE, LAST_UPDATE_USER, LAST_UPDATE_DATE, VERSION_NUMBER, SOURCE_TYPE_ID,
                      TENANT,dbo.al_bi_bintohexstr(TENANT) AS TENANT_DISPLAY
FROM         dbo.ARG_LEGALDEF
GO

Uses

[dbo].[arg_legaldef]
[dbo].[al_bi_bintohexstr]
dbo