v_DIM_ACCOUNTSYSTEM
Contains information about account systems.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ACCOUNTSYSTEMDIMID | int | BBDW.[DIM_ACCOUNTSYSTEM].[ACCOUNTSYSTEMDIMID] | |
| ACCOUNTSYSTEMSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_ACCOUNTSYSTEM].[ACCOUNTSYSTEMSYSTEMID] |
| ACCOUNTSYSTEMNAME | nvarchar(50) | yes | BBDW.[DIM_ACCOUNTSYSTEM].[ACCOUNTSYSTEMNAME] |
| ACCOUNTSYSTEMDESCRIPTION | nvarchar(255) | yes | BBDW.[DIM_ACCOUNTSYSTEM].[ACCOUNTSYSTEMDESCRIPTION] |
| ISDEFAULT | bit | yes | BBDW.[DIM_ACCOUNTSYSTEM].[ISDEFAULT] |
Definition
Copy
create view [BBDW].[v_DIM_ACCOUNTSYSTEM] as
select
s.[ACCOUNTSYSTEMDIMID],
s.[ACCOUNTSYSTEMSYSTEMID],
s.[ACCOUNTSYSTEMNAME],
s.[ACCOUNTSYSTEMDESCRIPTION],
s.[ISDEFAULT]
from BBDW.[DIM_ACCOUNTSYSTEM] s;