V_QUERY_BBDW_WRITEOFF
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| INSTALLMENTWRITEOFFFACTID | int | ||
| INSTALLMENTSPLITWRITEOFFSYSTEMID | uniqueidentifier | yes | |
| WRITEOFFDATE | datetime | yes | |
| WRITEOFFDATEDIMID | int | yes | |
| WRITEOFFPOSTDATE | datetime | yes | |
| WRITEOFFPOSTDATEDIMID | int | yes | |
| INSTALLMENTWRITEOFFAMOUNT | money | ||
| WRITEOFFREASONCODE | nvarchar(12) | yes | |
| WRITEOFFREASONDESCRIPTION | nvarchar(50) | yes | |
| WRITEOFFPOSTSTATUS | nvarchar(50) | yes | |
| FINANCIALTRANSACTIONFACTID | int | yes | |
| BASEINSTALLMENTWRITEOFFAMOUNT | money | yes | |
| BASECURRENCYSYSTEMID | uniqueidentifier | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_WRITEOFF] as
select
iw.[INSTALLMENTWRITEOFFFACTID],
iw.[INSTALLMENTSPLITWRITEOFFSYSTEMID],
iw.[WRITEOFFDATE],
iw.[WRITEOFFDATEDIMID],
iw.[WRITEOFFPOSTDATE],
iw.[WRITEOFFPOSTDATEDIMID],
iw.[INSTALLMENTWRITEOFFAMOUNT],
w.[WRITEOFFREASONCODE],
w.[WRITEOFFREASONDESCRIPTION],
w.[WRITEOFFPOSTSTATUS],
i.[FINANCIALTRANSACTIONFACTID],
iw.[BASEINSTALLMENTWRITEOFFAMOUNT],
bc.[CURRENCYSYSTEMID] [BASECURRENCYSYSTEMID]
from BBDW.[FACT_INSTALLMENTWRITEOFF] iw
left join BBDW.[DIM_WRITEOFF] w on iw.[WRITEOFFDIMID] = w.[WRITEOFFDIMID]
left join BBDW.[FACT_INSTALLMENT] i on i.[INSTALLMENTFACTID] = iw.[INSTALLMENTFACTID]
left join BBDW.[DIM_CURRENCY] bc on bc.[CURRENCYDIMID] = iw.[BASECURRENCYDIMID]