V_QUERY_BBDW_PLANNEDGIFTADDITION
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| PLANNEDGIFTADDITIONSYSTEMID | uniqueidentifier | yes | |
| PLANNEDGIFTDIMID | int | yes | |
| FINANCIALTRANSACTIONFACTID | int | yes | |
| GIFTAMOUNT | money | yes | |
| RECOGNITIONAMOUNT | money | yes | |
| GIFTDATE | datetime | yes | |
| GIFTDATEDIMID | int | yes | |
| CURRENCYSYSTEMID | uniqueidentifier | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_PLANNEDGIFTADDITION] as
select
pga.[PLANNEDGIFTADDITIONSYSTEMID],
pga.[PLANNEDGIFTDIMID],
pga.[FINANCIALTRANSACTIONFACTID],
pga.[GIFTAMOUNT],
pga.[RECOGNITIONAMOUNT],
pga.[GIFTDATE],
pga.[GIFTDATEDIMID],
c.[CURRENCYSYSTEMID]
from BBDW.[FACT_PLANNEDGIFTADDITION] pga
outer apply BBDW.[DIM_CURRENCY] c
where c.[ISORGANIZATIONCURRENCY] = 1