Views [dbo].[usm_vw_rate_definition]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created11:14:49 AM Tuesday, March 30, 2010
Last Modified11:14:49 AM Tuesday, March 30, 2010
Columns
Name
item_id
rate_plan_id
base_id
association_id
rate_row
rate_col
code
status
item_text
item_type
is_hidden
notes_id
info_link
currency_1
currency_2
date_available
date_unavailable
effective
changeto_item_id
enum_1
enum_2
enum_3
enum_4
enum_5
enum_6
enum_7
enum_8
enum_9
enum_10
enum_11
enum_12
enum_13
enum_14
numeric_1
numeric_2
text_1
text_2
text_3
text_4
text_5
date_1
date_2
sub_note_control
category
external_id
approval_level
approval_process
category_class
category_subclass
track_as_asset
sd_request_area
enum_15
allowed_cancellation_state
enum_3_char
enum_10_char
Permissions
TypeActionOwning Principal
GrantSelectusmgroup
SQL Script
CREATE view usm_vw_rate_definition as
select *,
     cast(enum_3 as varchar) as enum_3_char,
     cast(enum_10 as varchar) as enum_10_char
from usm_rate_definition
GO
GRANT SELECT ON  [dbo].[usm_vw_rate_definition] TO [usmgroup]
GO
Uses