V_QUERY_BBDW_TRIBUTE
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| REVENUETRIBUTESYSTEMID | uniqueidentifier | yes | |
| FINANCIALTRANSACTIONFACTID | int | yes | |
| AMOUNT | money | yes | |
| TRIBUTETYPE | nvarchar(200) | yes | |
| TRIBUTETEXT | nvarchar(520) | yes | |
| CURRENCYSYSTEMID | uniqueidentifier | yes | |
| BASEAMOUNT | money | yes | |
| BASECURRENCYSYSTEMID | uniqueidentifier | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_TRIBUTE] as
select
rt.[REVENUETRIBUTESYSTEMID],
rt.[FINANCIALTRANSACTIONFACTID],
rt.[AMOUNT],
t.[TRIBUTETYPE],
t.[TRIBUTETEXT],
c.[CURRENCYSYSTEMID],
rt.[BASEAMOUNT],
bc.[CURRENCYSYSTEMID] [BASECURRENCYSYSTEMID]
from BBDW.[FACT_REVENUETRIBUTE] rt
left join BBDW.[DIM_TRIBUTE] t on t.[TRIBUTEDIMID] = rt.[TRIBUTEDIMID] and rt.[TRIBUTEDIMID] <> 0
left join BBDW.[DIM_CURRENCY] bc on bc.[CURRENCYDIMID] = rt.[BASECURRENCYDIMID]
outer apply BBDW.[DIM_CURRENCY] c
where c.[ISORGANIZATIONCURRENCY] = 1