V_QUERY_BBDW_MEMBERSHIPTRANSACTION
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| MEMBERSHIPTRANSACTIONFACTID | int | ||
| MEMBERSHIPTRANSACTIONSYSTEMID | uniqueidentifier | yes | |
| MEMBERSHIPDIMID | int | yes | |
| FINANCIALTRANSACTIONLINEITEMFACTID | int | yes | |
| MEMBERSHIPTRANSACTIONDATEDIMID | int | yes | |
| MEMBERSHIPTRANSACTIONDATE | datetime | yes | |
| MEMBERSHIPEXPIRATIONDATEDIMID | int | yes | |
| MEMBERSHIPEXPIRATIONDATE | datetime | yes | |
| NEXTMEMBERSHIPTRANSACTIONDATEDIMID | int | yes | |
| NEXTMEMBERSHIPTRANSACTIONDATE | datetime | yes | |
| MEMBERSHIPACTION | nvarchar(50) | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_MEMBERSHIPTRANSACTION] as
select
mt.[MEMBERSHIPTRANSACTIONFACTID],
mt.[MEMBERSHIPTRANSACTIONSYSTEMID],
mt.[MEMBERSHIPDIMID],
mt.[FINANCIALTRANSACTIONLINEITEMFACTID],
mt.[MEMBERSHIPTRANSACTIONDATEDIMID],
mt.[MEMBERSHIPTRANSACTIONDATE],
mt.[MEMBERSHIPEXPIRATIONDATEDIMID],
mt.[MEMBERSHIPEXPIRATIONDATE],
mt.[NEXTMEMBERSHIPTRANSACTIONDATEDIMID],
mt.[NEXTMEMBERSHIPTRANSACTIONDATE],
ma.[MEMBERSHIPACTION]
from BBDW.[FACT_MEMBERSHIPTRANSACTION] mt
left join BBDW.[DIM_MEMBERSHIPACTION] ma on mt.[MEMBERSHIPACTIONDIMID] = ma.[MEMBERSHIPACTIONDIMID] and mt.[MEMBERSHIPACTIONDIMID] <> 0