Cisco Cisco IP Contact Center Release 4.6.2 Technical References
Keys and Null Option:
Data Type:
Description:
Field Name:
NULL
DBINT
The number of bit positions to shift the value to the left.
Shift
PK NOT NULL
DBINT
A unique identifier for the column.
ViewColumnID
AK-2 NOT NULL
VNAME32
The name used for the column within the ICM software.
ViewName
Vru_Currency Table
tables. For database rules, click
This table contains a list of currencies supported by VRU micro-applications.
Related table
(via CurrencyID)
Table 218: Indexes for View_Currency Table
index_keys
index_description
index_name
CurrencyName
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Vru_Currency
CurrencyID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKVru_Currency
Fields in Vru_Currency Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
PK NOT NULL
DBINT
A unique identifier.
CurrencyID
AK-1 NOT NULL
varchar(10)
Specifies the currency supported by the VRU micro-application:
CurrencyName
• 1 = U.S. Dollar (default)
• 2 = Euro
• 3 = Pound Sterling
• 4 = French franc
• 5 = Deutschmark
• 6 = Lira
• 7 = Peseta
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
434
Chapter 2: All Tables
Vru_Currency Table