V_QUERY_BBDW_RECURRINGGIFTWRITEOFF
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| RECURRINGGIFTINSTALLMENTWRITEOFFFACTID | int | ||
| RECURRINGGIFTINSTALLMENTWRITEOFFSYSTEMID | uniqueidentifier | yes | |
| WRITEOFFDATE | datetime | yes | |
| WRITEOFFDATEDIMID | int | yes | |
| WRITEOFFAMOUNT | money | ||
| WRITEOFFREASONCODE | nvarchar(12) | yes | |
| WRITEOFFREASONDESCRIPTION | nvarchar(50) | yes | |
| WRITEOFFPOSTSTATUS | nvarchar(50) | yes | |
| FINANCIALTRANSACTIONFACTID | int | yes | |
| BASEWRITEOFFAMOUNT | money | yes | |
| BASECURRENCYSYSTEMID | uniqueidentifier | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_RECURRINGGIFTWRITEOFF] as
select
iw.[RECURRINGGIFTINSTALLMENTWRITEOFFFACTID],
iw.[RECURRINGGIFTINSTALLMENTWRITEOFFSYSTEMID],
iw.[WRITEOFFDATE],
iw.[WRITEOFFDATEDIMID],
iw.[WRITEOFFAMOUNT],
w.[WRITEOFFREASONCODE],
w.[WRITEOFFREASONDESCRIPTION],
w.[WRITEOFFPOSTSTATUS],
i.[FINANCIALTRANSACTIONFACTID],
iw.[BASEWRITEOFFAMOUNT],
bc.[CURRENCYSYSTEMID] [BASECURRENCYSYSTEMID]
from BBDW.[FACT_RECURRINGGIFTINSTALLMENTWRITEOFF] iw
left join BBDW.[DIM_WRITEOFF] w on iw.[WRITEOFFDIMID] = w.[WRITEOFFDIMID]
left join BBDW.[FACT_RECURRINGGIFTINSTALLMENT] i on i.[RECURRINGGIFTINSTALLMENTFACTID] = iw.[RECURRINGGIFTINSTALLMENTFACTID]
left join BBDW.[DIM_CURRENCY] bc on bc.[CURRENCYDIMID] = iw.[BASECURRENCYDIMID]