v_FACT_SPONSORSHIPRECURRINGADDITIONALGIFT
Stores information about sponsorship transactions
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SPONSORSHIPRECURRINGADDITIONALGIFTFACTID | int | BBDW.[FACT_SPONSORSHIPRECURRINGADDITIONALGIFT].[SPONSORSHIPRECURRINGADDITIONALGIFTDIMID] | |
| SPONSORSHIPRECURRINGADDITIONALGIFTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_SPONSORSHIPRECURRINGADDITIONALGIFT].[SPONSORSHIPRECURRINGADDITIONALGIFTSYSTEMID] |
| SPONSORSHIPDIMID | int | yes | BBDW.[FACT_SPONSORSHIPRECURRINGADDITIONALGIFT].[SPONSORSHIPDIMID] |
| FINANCIALTRANSACTIONFACTID | int | yes | BBDW.[FACT_SPONSORSHIPRECURRINGADDITIONALGIFT].[FINANCIALTRANSACTIONFACTID] |
Definition
Copy
create view [BBDW].[v_FACT_SPONSORSHIPRECURRINGADDITIONALGIFT] as
select
[SPONSORSHIPRECURRINGADDITIONALGIFTFACTID],
[SPONSORSHIPRECURRINGADDITIONALGIFTSYSTEMID],
[SPONSORSHIPDIMID],
[FINANCIALTRANSACTIONFACTID]
from [BBDW].[FACT_SPONSORSHIPRECURRINGADDITIONALGIFT];