v_DIM_GLREVENUECATEGORY
The GL revenue category dimension contains information about GL revenue categories.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| GLREVENUECATEGORYDIMID | int | BBDW.[DIM_GLREVENUECATEGORY].[GLREVENUECATEGORYDIMID] | |
| GLREVENUECATEGORYSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_GLREVENUECATEGORY].[GLREVENUECATEGORYSYSTEMID] |
| GLREVENUECATEGORYACCOUNTCODE | nvarchar(100) | yes | BBDW.[DIM_GLREVENUECATEGORY].[GLREVENUECATEGORYACCOUNTCODE] |
| GLREVENUECATEGORYNAME | nvarchar(100) | yes | BBDW.[DIM_GLREVENUECATEGORY].[GLREVENUECATEGORYNAME] |
Definition
Copy
CREATE view [BBDW].[v_DIM_GLREVENUECATEGORY] as
select
[GLREVENUECATEGORYDIMID],
[GLREVENUECATEGORYSYSTEMID],
[GLREVENUECATEGORYACCOUNTCODE],
[GLREVENUECATEGORYNAME]
from BBDW.[DIM_GLREVENUECATEGORY]