V_QUERY_BBDW_REVENUESOLICITOR
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| REVENUEFUNDRAISERSYSTEMID | uniqueidentifier | yes | |
| FINANCIALTRANSACTIONLINEITEMFACTID | int | yes | |
| REVENUEFUNDRAISERAMOUNT | money | yes | |
| CONSTITUENTDIMID | int | yes | |
| BASEREVENUEFUNDRAISERAMOUNT | money | yes | |
| BASECURRENCYSYSTEMID | uniqueidentifier | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_REVENUESOLICITOR] as
select
rf.[REVENUEFUNDRAISERSYSTEMID],
rf.[FINANCIALTRANSACTIONLINEITEMFACTID],
rf.[REVENUEFUNDRAISERAMOUNT],
rf.[FUNDRAISERCONSTITUENTDIMID] AS [CONSTITUENTDIMID],
rf.[BASEREVENUEFUNDRAISERAMOUNT],
bc.[CURRENCYSYSTEMID] [BASECURRENCYSYSTEMID]
from BBDW.[FACT_REVENUEFUNDRAISER] rf
left join BBDW.[DIM_CURRENCY] bc on bc.[CURRENCYDIMID] = rf.[BASECURRENCYDIMID]