V_QUERY_BBDW_INSTALLMENT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| INSTALLMENTFACTID | int | ||
| INSTALLMENTSPLITSYSTEMID | uniqueidentifier | yes | |
| FINANCIALTRANSACTIONFACTID | int | yes | |
| INSTALLMENTDATE | datetime | yes | |
| INSTALLMENTDATEDIMID | int | yes | |
| INSTALLMENTAMOUNT | money | yes | |
| INSTALLMENTBALANCE | money | yes | |
| CURRENCYSYSTEMID | uniqueidentifier | yes | |
| BASEINSTALLMENTAMOUNT | money | yes | |
| BASECURRENCYSYSTEMID | uniqueidentifier | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_INSTALLMENT] as
select
i.[INSTALLMENTFACTID],
i.[INSTALLMENTSPLITSYSTEMID],
i.[FINANCIALTRANSACTIONFACTID],
i.[INSTALLMENTDATE],
i.[INSTALLMENTDATEDIMID],
i.[INSTALLMENTAMOUNT],
i.[INSTALLMENTBALANCE],
c.[CURRENCYSYSTEMID],
i.[BASEINSTALLMENTAMOUNT],
bc.[CURRENCYSYSTEMID] [BASECURRENCYSYSTEMID]
from BBDW.[FACT_INSTALLMENT] i
left join BBDW.[DIM_CURRENCY] bc on bc.[CURRENCYDIMID] = i.[BASECURRENCYDIMID]
outer apply BBDW.[DIM_CURRENCY] c
where c.[ISORGANIZATIONCURRENCY] = 1