v_DIM_TRIBUTE
Contains information about tributes associated with revenues.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| TRIBUTEDIMID | int | [BBDW].[DIM_TRIBUTE].[TRIBUTEDIMID] | |
| TRIBUTESYSTEMID | uniqueidentifier | yes | [BBDW].[DIM_TRIBUTE].[TRIBUTESYSTEMID] |
| TRIBUTEECONSTITUENTSYSTEMID | uniqueidentifier | yes | [BBDW].[DIM_TRIBUTE] |
| TRIBUTEECONSTITUENTDIMID | int | yes | [BBDW].[DIM_TRIBUTE].[TRIBUTEECONSTITUENTSYSTEMID] |
| TRIBUTETEXT | nvarchar(520) | yes | [BBDW].[DIM_TRIBUTE].[TRIBUTETEXT] |
| TRIBUTETYPE | nvarchar(200) | yes | [BBDW].[DIM_TRIBUTE].[TRIBUTETYPE] |
| DESIGNATIONDIMID | int | yes | [BBDW].[DIM_TRIBUTE].[DESIGNATIONDIMID] |
Definition
Copy
create view [BBDW].[v_DIM_TRIBUTE] as
select
t.[TRIBUTEDIMID],
t.[TRIBUTESYSTEMID],
t.[TRIBUTEECONSTITUENTSYSTEMID],
t.[TRIBUTEECONSTITUENTDIMID],
t.[TRIBUTETEXT],
t.[TRIBUTETYPE],
t.[DESIGNATIONDIMID]
from BBDW.[DIM_TRIBUTE] t;