Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References

Page of 404
 
2-292
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
VRU_Currency Table
Related tables:
ICR View (via ICRViewID)
VRU_Currency Table
This table contains a list of currencies supported by VRU micro-applications.
Related tables:
VRU_Defaults (via CurrencyID)
Edit
Indicates whether the View_Column record can be 
modified. Stored as a character: 
Y = yes
N = no
char(1)
NOT NULL
ChangeStamp
Incremented when the record is changed in the central 
database.
int
NOT NULL
Table 2-196 View_Column Table (continued)
Field Name
Description
Data Type
Keys and Null 
Option
Table 2-197 VRU_Currency Table
Field Name
Description
Data Type
Keys and Null 
Option
CurrencyID
A unique identifier.
int
PK, NOT NULL
CurrencyName
Specifies the currency supported by the VRU 
micro-application:
1 = U.S. Dollar (default)
2 = Euro 
3 = Pound Sterling
4 = French franc
5 = Deutschmark
6 = Lira 
7 = Peseta
0 = Other
varchar(10)
AK1, NOT 
NULL
ChangeStamp
Incremented when the record is changed in the central 
database.
int
NOT NULL