| FINANCIALTRANSACTIONSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[FINANCIALTRANSACTION].[ID] |
| FINANCIALTRANSACTIONSEQUENCEID |
int |
yes |
|
dbo.[FINANCIALTRANSACTION].[SEQUENCEGENERATORID] |
| FINANCIALTRANSACTIONLOOKUPID |
nvarchar(100) |
yes |
|
dbo.[FINANCIALTRANSACTION].[USERDEFINEDID] |
| REVENUECODEDIMID |
int |
yes |
|
BBDW.[DIM_REVENUECODE].[REVENUECODEDIMID] |
| REVENUEFLAGDIMID |
int |
yes |
|
Reference key to the revenue code dimension, derived from the codes on dbo.[FINANCIALTRANSACTION], dbo.[REVENUE_EXT] and dbo.[REVENUEPAYMENTMETHOD] |
| REVENUECHANNELDIMID |
int |
yes |
|
Reference key to the appeal dimension, derived from dbo.[REVENUE_EXT].[CHANNELCODEID] |
| FINANCIALTRANSACTIONDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[FINANCIALTRANSACTION].[DATE] |
| FINANCIALTRANSACTIONDATE |
datetime |
yes |
|
dbo.[FINANCIALTRANSACTION].[DATE] cast as datetime |
| FINANCIALTRANSACTIONDATETIMEOFFSET |
datetimeoffset |
yes |
|
dbo.[FINANCIALTRANSACTION].[DATE] |
| POSTDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[FINANCIALTRANSACTION].[POSTDATE] |
| POSTDATE |
datetime |
yes |
|
dbo.[FINANCIALTRANSACTION].[POSTDATE] |
| CONSTITUENTDIMID |
int |
yes |
|
Reference key to the constituent dimension, derived from dbo.[FINANCIALTRANSACTION].[CONSTITUENTID] |
| CONSTITUENTSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[FINANCIALTRANSACTION].[CONSTITUENTID] |
| APPEALDIMID |
int |
yes |
|
Reference key to the appeal dimension, derived from dbo.[REVENUE_EXT].[APPEALID] |
| MARKETINGSEGMENTDIMID |
int |
yes |
|
Reference key to the marketing segment dimension, derived from dbo.[REVENUESEGMENT].[SEGMENTID] and dbo.[REVENUESEGMENT].[TESTSEGMENTID] |
| MARKETINGSOURCECODEDIMID |
int |
yes |
|
Reference key to the marketing source code dimension, derived from dbo.[REVENUESEGMENT].[SOURCECODEMAPID] |
| MARKETINGCONSTITUENTFACTID |
bigint |
yes |
|
Reference key to the marketing constituent fact, derived from dbo.[FINANCIALTRANSACTION].[CONSTITUENTID], dbo.[REVENUESEGMENT].[SEGMENTID] and dbo.[REVENUESEGMENT].[TESTSEGMENTID] |
| BASECURRENCYDIMID |
int |
yes |
|
Reference key to the currency dimension, derived from dbo.[PDACCOUNTSYSTEM].[CURRENCYID] |
| AMOUNT |
money |
yes |
|
dbo.[FINANCIALTRANSACTION].[ORGAMOUNT] |
| BASEAMOUNT |
money |
yes |
|
dbo.[FINANCIALTRANSACTION].[BASEAMOUNT] |
| RECEIPTAMOUNT |
money |
yes |
|
dbo.[REVENUE_EXT].[RECEIPTAMOUNT] |
| CHANGEDDATE |
datetime |
yes |
|
dbo.[FINANCIALTRANSACTION].[DATECHANGED] |
| CHANGEDDATEDIMID |
int |
yes |
|
Reference key to date dimension, derived from [dbo].[REVENUE].[DATECHANGED] |
| APPUSERDIMID |
int |
yes |
|
Reference key to appuser dimension, derived from [dbo].[APPUSER][ID] |
| CHECKNUMBER |
nvarchar(50) |
yes |
|
dbo.[CHECKPAYMENTMETHODDETAIL].[CHECKNUMBER] |
| CHECKFUZZYDATE |
char(8) |
yes |
|
dbo.[CHECKPAYMENTMETHODDETAIL].[CHECKDATE] |
| CREDITCARDTYPEDIMID |
int |
yes |
|
Reference key to creditcardtype dimension, derived from [dbo].[CREDITCARDTYPE][ID] |
| ACCOUNTSYSTEMDIMID |
int |
yes |
|
Reference key to the account system dimension, derived from dbo.[FINANCIALTRANSACTION].[PDACCOUNTSYSTEMID] |
| ISINCLUDED |
bit |
yes |
|
Flag indicating when data should be included in results. |
| SOURCEDIMID |
int |
yes |
|
Source system used. |
| ETLCONTROLID |
int |
yes |
|
ID generated through the ETL process. |
| BATCHNUMBER |
nvarchar(100) |
yes |
|
dbo.[REVENUE_EXT].[BATCHNUMBER] |
| TRANSACTIONBALANCE |
money |
yes |
|
Calculated pledge balance, (Pledge amount - Writeoffs - Payments) |
| TRANSACTIONCURRENCYDIMID |
int |
yes |
|
Reference key to the currency dimension, derived from dbo.[FINANCIALTRANSACTION].[TRANSACTIONCURRENCYID] |
| MARKETINGSEGMENTATIONDIMID |
int |
yes |
|
Reference key to the marketing effort dimension, derived from dbo.[MKTSEGMENTATION].[ID] |
| REVENUESCHEDULEDIMID |
int |
yes |
|
Reference key to the revenue schedule dimension, derived using the combination flags and codes on [dbo].[REVENUESCHEDULE] |
| ADDEDDATE |
datetime |
yes |
|
[dbo].[FINANCIALTRANSACTION].[DATEADDED] |
| ADDEDDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived using [dbo].[FINANCIALTRANSACTION].[DATEADDED] |
| OTHERPAYMENTMETHODDIMID |
int |
yes |
|
Reference key to other payment method dimension, derived from [dbo].[OTHERPAYMENTMETHODDETAIL].[OTHERPAYMENTMETHODCODEID] |
| DESIGNATIONLIST |
nvarchar(4000) |
yes |
|
Comma delimited list of designations based on dbo.[REVENUESPLIT_EXT].[DESIGNATIONID] |
| CREDITCARDEXPIRESON |
UDT_FUZZYDATE |
yes |
|
[dbo].[FINANCIALTRANSACTION].[DATEADDED] |
| TOTALPAIDAMOUNT |
money |
yes |
|
Total amount paid for pledges and recurring gifts |
| PASTDUEAMOUNT |
money |
yes |
|
Past due amount for pledges and recurring gifts |
| TOTALINSTALLMENTCOUNT |
int |
yes |
|
Total number of installments for pledges and recurring gifts |