v_FACT_REVENUEATTRIBUTE
The revenue attribute fact table relates revenue to their attributes.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| REVENUEATTRIBUTEFACTID | bigint | BBDW.[FACT_REVENUEATTRIBUTE].[REVENUEATTRIBUTEFACTID] | |
| ATTRIBUTEDIMID | int | yes | BBDW.[FACT_REVENUEATTRIBUTE].[ATTRIBUTEDIMID] |
| REVENUEFACTID | int | yes | BBDW.[FACT_REVENUEATTRIBUTE].[REVENUEFACTID] |
| REVENUESYSTEMID | uniqueidentifier | yes | BBDW.[FACT_REVENUEATTRIBUTE].[REVENUESYSTEMID] |
| ATTRIBUTESTARTDATEDIMID | int | yes | BBDW.[FACT_REVENUEATTRIBUTE].[ATTRIBUTESTARTDATEDIMID] |
| ATTRIBUTESTARTDATE | datetime | yes | BBDW.[FACT_REVENUEATTRIBUTE].[ATTRIBUTESTARTDATE] |
| ATTRIBUTEENDDATEDIMID | int | yes | BBDW.[FACT_REVENUEATTRIBUTE].[ATTRIBUTEENDDATEDIMID] |
| ATTRIBUTEENDDATE | datetime | yes | BBDW.[FACT_REVENUEATTRIBUTE].[ATTRIBUTEENDDATE] |
| ATTRIBUTEVALUE | nvarchar(255) | yes | BBDW.[FACT_REVENUEATTRIBUTE].[ATTRIBUTEVALUE] |
| ATTRIBUTEISCURRENT | bit | yes | BBDW.[FACT_REVENUEATTRIBUTE].[ATTRIBUTEISCURRENT] |
| ATTRIBUTECOMMENT | nvarchar(255) | yes | BBDW.[FACT_REVENUEATTRIBUTE].[ATTRIBUTECOMMENT] |
| FINANCIALTRANSACTIONFACTID | int | yes | BBDW.[FACT_REVENUEATTRIBUTE].[FINANCIALTRANSACTIONFACTID] |
| FINANCIALTRANSACTIONLINEITEMFACTID | int | yes | BBDW.[FACT_REVENUEATTRIBUTE].[FINANCIALTRANSACTIONLINEITEMFACTID] |
Definition
Copy
CREATE view [BBDW].[v_FACT_REVENUEATTRIBUTE] as
select
ra.[REVENUEATTRIBUTEFACTID],
ra.[ATTRIBUTEDIMID],
ra.[REVENUEFACTID],
ra.[REVENUESYSTEMID],
ra.[ATTRIBUTESTARTDATEDIMID],
ra.[ATTRIBUTESTARTDATE],
ra.[ATTRIBUTEENDDATEDIMID],
ra.[ATTRIBUTEENDDATE],
ra.[ATTRIBUTEVALUE],
ra.[ATTRIBUTEISCURRENT],
ra.[ATTRIBUTECOMMENT],
ra.[FINANCIALTRANSACTIONFACTID],
ra.[FINANCIALTRANSACTIONLINEITEMFACTID]
from
BBDW.[FACT_REVENUEATTRIBUTE] ra
left join BBDW.[DIM_ATTRIBUTE] a on ra.[ATTRIBUTEDIMID] = a.[ATTRIBUTEDIMID]
where (a.[ATTRIBUTEHASCODETABLE] = 1);