V_QUERY_BBDW_APPEALS
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| APPEALDIMID | int | ||
| APPEALSYSTEMID | uniqueidentifier | yes | |
| APPEALNAME | nvarchar(100) | yes | |
| APPEALSTARTDATEDIMID | int | yes | |
| APPEALSTARTDATE | datetime | yes | |
| APPEALENDDATEDIMID | int | yes | |
| APPEALENDDATE | datetime | yes | |
| APPEALCATEGORY | nvarchar(100) | yes | |
| APPEALDESCRIPTION | nvarchar(300) | yes | |
| APPEALGOAL | money | yes | |
| CURRENCYSYSTEMID | uniqueidentifier | yes | |
| APPEALREPORTCODE | nvarchar(100) | yes | |
| APPEALISACTIVE | bit | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_APPEALS] as
select
a.[APPEALDIMID],
a.[APPEALSYSTEMID],
a.[APPEALNAME],
a.[APPEALSTARTDATEDIMID],
a.[APPEALSTARTDATE],
a.[APPEALENDDATEDIMID],
a.[APPEALENDDATE],
a.[APPEALCATEGORY],
a.[APPEALDESCRIPTION],
a.[APPEALGOAL],
c.[CURRENCYSYSTEMID],
a.[APPEALREPORTCODE],
a.[APPEALISACTIVE]
from BBDW.[DIM_APPEAL] a
outer apply BBDW.[DIM_CURRENCY] c
where c.[ISORGANIZATIONCURRENCY] = 1