[dbo].[al_bi_capacity_unit

[dbo].[al_bi_capacity_unit_view]

(local) > mdb > Views > dbo.al_bi_capacity_unit_view

Properties
Columns
SQL Script
Uses

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

Columns

Name
id
inactive
name
creation_user
creation_date
last_update_user
last_update_date
version_number
description
exclude_registration
delete_time
tenant
TENANT_DISPLAY

SQL Script

CREATE VIEW [dbo].[al_bi_capacity_unit_view]
AS
SELECT     id, inactive, name, creation_user, creation_date, last_update_user, last_update_date, version_number, description, exclude_registration, delete_time,
                      tenant,dbo.al_bi_bintohexstr(tenant) AS TENANT_DISPLAY
FROM         dbo.ca_capacity_unit
GO

Uses

[dbo].[ca_capacity_unit]
[dbo].[al_bi_bintohexstr]
dbo