v_DIM_CURRENCY
The currency dimension contains information about currencies.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CURRENCYDIMID | int | BBDW.[DIM_CURRENCY].[CURRENCYDIMID] | |
| CURRENCYSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_CURRENCY].[CURRENCYSYSTEMID] |
| CURRENCYNAME | nvarchar(100) | yes | BBDW.[DIM_CURRENCY].[CURRENCYNAME] |
| ISO4217 | nvarchar(3) | yes | BBDW.[DIM_CURRENCY].[ISO4217] |
| ISORGANIZATIONCURRENCY | bit | yes | BBDW.[DIM_CURRENCY].[ISORGANIZATIONCURRENCY] |
| DECIMALDIGITS | tinyint | yes | BBDW.[DIM_CURRENCY].[DECIMALDIGITS] |
| INACTIVE | bit | yes | BBDW.[DIM_CURRENCY].[INACTIVE] |
| CURRENCYSYMBOL | nvarchar(5) | yes | BBDW.[DIM_CURRENCY].[CURRENCYSYMBOL] |
| ROUNDINGTYPECODE | tinyint | yes | BBDW.[DIM_CURRENCY].[ROUNDINGTYPECODE] |
| ROUNDINGTYPE | nvarchar(44) | yes | BBDW.[DIM_CURRENCY].[ROUNDINGTYPE] |
| SYMBOLDISPLAYSETTING | nvarchar(65) | yes | BBDW.[DIM_CURRENCY].[SYMBOLDISPLAYSETTING] |
| SYMBOLDISPLAYSETTINGCODE | tinyint | yes | BBDW.[DIM_CURRENCY].[SYMBOLDISPLAYSETTINGCODE] |
Definition
Copy
CREATE view [BBDW].[v_DIM_CURRENCY] as
select
[CURRENCYDIMID],
[CURRENCYSYSTEMID],
[CURRENCYNAME],
[ISO4217],
[ISORGANIZATIONCURRENCY],
[DECIMALDIGITS],
[INACTIVE],
[CURRENCYSYMBOL],
[ROUNDINGTYPECODE],
[ROUNDINGTYPE],
[SYMBOLDISPLAYSETTING],
[SYMBOLDISPLAYSETTINGCODE]
from BBDW.[DIM_CURRENCY];