v_FACT_RECURRINGGIFTAMENDMENTDESIGNATIONS
Stores information about recurring gift amendment designations.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| RECURRINGGIFTAMENDMENTDESIGNATIONSFACTID | int | BBDW.[FACT_RECURRINGGIFTAMENDMENTDESIGNATIONS].[RECURRINGGIFTAMENDMENTDESIGNATIONSFACTID] | |
| RECURRINGGIFTAMENDMENTFACTID | int | yes | BBDW.[FACT_RECURRINGGIFTAMENDMENTDESIGNATIONS].[RECURRINGGIFTAMENDMENTFACTID] |
| RECURRINGGIFTAMENDMENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_RECURRINGGIFTAMENDMENTDESIGNATIONS].[RECURRINGGIFTAMENDMENTSYSTEMID] |
| DESIGNATIONDIMID | int | yes | BBDW.[FACT_RECURRINGGIFTAMENDMENTDESIGNATIONS].[DESIGNATIONDIMID] |
| OLDAMOUNT | money | yes | BBDW.[FACT_RECURRINGGIFTAMENDMENTDESIGNATIONS].[OLDAMOUNT] |
| NEWAMOUNT | money | yes | BBDW.[FACT_RECURRINGGIFTAMENDMENTDESIGNATIONS].[NEWAMOUNT] |
| TRANSACTIONCURRENCYDIMID | int | yes | BBDW.[FACT_RECURRINGGIFTAMENDMENTDESIGNATIONS].[TRANSACTIONCURRENCYDIMID] |
Definition
Copy
create view [BBDW].[v_FACT_RECURRINGGIFTAMENDMENTDESIGNATIONS] as
select
[RECURRINGGIFTAMENDMENTDESIGNATIONSFACTID],
[RECURRINGGIFTAMENDMENTFACTID],
[RECURRINGGIFTAMENDMENTSYSTEMID],
[DESIGNATIONDIMID],
[OLDAMOUNT],
[NEWAMOUNT],
[TRANSACTIONCURRENCYDIMID]
from [BBDW].[FACT_RECURRINGGIFTAMENDMENTDESIGNATIONS];