V_QUERY_BBDW_DESIGNATION
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| DESIGNATIONSYSTEMID | uniqueidentifier | yes | |
| DESIGNATIONDIMID | int | ||
| PURPOSELEVEL1DIMID | int | yes | |
| PURPOSELEVEL2DIMID | int | yes | |
| PURPOSELEVEL3DIMID | int | yes | |
| PURPOSELEVEL4DIMID | int | yes | |
| PURPOSELEVEL5DIMID | int | yes | |
| DESIGNATIONNAME | nvarchar(512) | yes | |
| DESIGNATIONPUBLICNAME | nvarchar(512) | yes | |
| DESIGNATIONLOOKUPID | nvarchar(512) | yes | |
| DESIGNATIONPROJECTCODE | nvarchar(100) | yes | |
| REPORTCODE1NAME | nvarchar(100) | yes | |
| REPORTCODE2NAME | nvarchar(100) | yes | |
| VSECATEGORY | nvarchar(70) | yes | |
| VSESUBCATEGORY | nvarchar(100) | yes | |
| DESIGNATIONUSE | nvarchar(100) | yes | |
| DESIGNATIONSTARTDATE | datetime | yes | |
| DESIGNATIONSTARTDATEDIMID | int | yes | |
| DESIGNATIONENDDATE | datetime | yes | |
| DESIGNATIONENDDATEDIMID | int | yes | |
| DESIGNATIONISACTIVE | bit | yes | |
| DESIGNATIONGLACCOUNTNUMBER | nvarchar(512) | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_DESIGNATION] as
select
[DESIGNATIONSYSTEMID],
[DESIGNATIONDIMID],
[PURPOSELEVEL1DIMID],
[PURPOSELEVEL2DIMID],
[PURPOSELEVEL3DIMID],
[PURPOSELEVEL4DIMID],
[PURPOSELEVEL5DIMID],
[DESIGNATIONNAME],
[DESIGNATIONPUBLICNAME],
[DESIGNATIONLOOKUPID],
[DESIGNATIONPROJECTCODE],
[DESIGNATIONREPORT1CODE] [REPORTCODE1NAME],
[DESIGNATIONREPORT2CODE] [REPORTCODE2NAME],
[VSECATEGORY],
[VSESUBCATEGORY],
[DESIGNATIONUSE],
[DESIGNATIONSTARTDATE],
[DESIGNATIONSTARTDATEDIMID],
[DESIGNATIONENDDATE],
[DESIGNATIONENDDATEDIMID],
[DESIGNATIONISACTIVE],
[DESIGNATIONGLACCOUNTNUMBER]
from BBDW.[DIM_DESIGNATION]
where [DESIGNATIONDIMID] > 0