V_QUERY_BBDW_RECURRINGGIFTINSTALLMENT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| RECURRINGGIFTINSTALLMENTFACTID | int | ||
| RECURRINGGIFTINSTALLMENTSYSTEMID | uniqueidentifier | yes | |
| FINANCIALTRANSACTIONFACTID | int | yes | |
| RECURRINGGIFTINSTALLMENTDATE | datetime | yes | |
| RECURRINGGIFTINSTALLMENTDATEDIMID | int | yes | |
| RECURRINGGIFTINSTALLMENTAMOUNT | money | yes | |
| CURRENCYSYSTEMID | uniqueidentifier | yes | |
| BASERECURRINGGIFTINSTALLMENTAMOUNT | money | yes | |
| BASECURRENCYSYSTEMID | uniqueidentifier | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_RECURRINGGIFTINSTALLMENT] as
select
ri.[RECURRINGGIFTINSTALLMENTFACTID],
ri.[RECURRINGGIFTINSTALLMENTSYSTEMID],
ri.[FINANCIALTRANSACTIONFACTID],
ri.[RECURRINGGIFTINSTALLMENTDATE],
ri.[RECURRINGGIFTINSTALLMENTDATEDIMID],
ri.[RECURRINGGIFTINSTALLMENTAMOUNT],
c.[CURRENCYSYSTEMID],
ri.[BASERECURRINGGIFTINSTALLMENTAMOUNT],
bc.[CURRENCYSYSTEMID] [BASECURRENCYSYSTEMID]
from BBDW.[FACT_RECURRINGGIFTINSTALLMENT] ri
left join BBDW.[DIM_CURRENCY] bc on bc.[CURRENCYDIMID] = ri.[BASECURRENCYDIMID]
outer apply BBDW.[DIM_CURRENCY] c
where c.[ISORGANIZATIONCURRENCY] = 1