| CONSTITUENTID |
uniqueidentifier |
|
|
FK to CONSTITUENT |
| DATE |
datetime |
|
|
|
| PAYMENTMETHODCODE |
tinyint |
|
Default = 0 |
The method of payment in which the revenue was received. |
| DONOTACKNOWLEDGE |
bit |
|
Default = 0 |
Indicates that the revenue should not be acknowledged. |
| CHECKDATE |
UDT_FUZZYDATE |
|
Default = '00000000' |
Check date |
| CHECKNUMBER |
nvarchar(20) |
|
Default = '' |
Check number |
| REFERENCEDATE |
UDT_FUZZYDATE |
|
Default = '00000000' |
The date that the reference was made. |
| REFERENCENUMBER |
nvarchar(20) |
|
Default = '' |
|
| AUTHORIZATIONCODE |
nvarchar(20) |
|
Default = '' |
The authorization code for a credit card payment, if applicable. |
| CONSTITUENTACCOUNTID |
uniqueidentifier |
yes |
|
FK to CONSTITUENTACCOUNT |
| AMOUNT |
money |
|
Default = 0 |
|
| TYPECODE |
tinyint |
|
Default = 0 |
The type of the revenue. |
| RECEIPTAMOUNT |
money |
|
Default = 0 |
The amount to include for this gift in a receipt. |
| DONOTRECEIPT |
bit |
|
Default = 0 |
Indicates that the revenue should not be receipted. |
| RECEIPTNUMBER |
int |
|
Default = 0 |
The number for the receipt given for this gift. |
| RECEIPTDATE |
datetime |
yes |
|
The date that the gift was receipted. |
| APPLYTOSHOWNFORCONSTITUENTID |
uniqueidentifier |
yes |
|
If the Apply To window was displayed for this batch row, indicate the constituent for whom it was shown. |
| SEQUENCE |
int |
|
Default = 0 |
|
| INSTALLMENTSTARTDATE |
datetime |
yes |
|
The start date for the schedule. |
| INSTALLMENTENDDATE |
datetime |
yes |
|
The end date for the schedule. |
| NUMBEROFINSTALLMENTS |
int |
|
Default = 0 |
The number of the schedule. |
| INSTALLMENTFREQUENCYCODE |
tinyint |
|
Default = 5 |
Indicates the frequency of the installment. |
| FINDERNUMBER |
bigint |
|
Default = ((0)) |
The finder number for the record. |
| SOURCECODE |
nvarchar(60) |
|
Default = '' |
The source code for the record. |
| FINDERNUMBERISVALID |
bit |
|
Default = 0 |
Indicates if the FINDERNUMBER field was valid at the time the row was saved. |
| USERMODIFIEDBENEFITS |
bit |
|
Default = 0 |
Indicates if the user set the BENEFITS field or if the system set it. |
| BENEFITSWAIVED |
bit |
|
Default = 0 |
Indicates if the user has waived BENEFITS for this gift. |
| POSTDATE |
datetime |
yes |
|
The date to use when posting the revenue record. |
| POSTSTATUSCODE |
tinyint |
|
Default = 1 |
Flag used to indicate whether revenue has been posted, should be posted or needs to be posted. |
| SENDPLEDGEREMINDER |
bit |
|
Default = 0 |
Send pledge reminders |
| SALEDATE |
datetime |
yes |
|
The sale date of stock or property |
| SALEAMOUNT |
money |
|
Default = 0 |
The sale amount of stock or property |
| BROKERFEE |
money |
|
Default = 0 |
The fees of sold stock or property |
| SALEPOSTSTATUSCODE |
tinyint |
|
Default = 1 |
Flag used to indicate whether sold stock property should be posted or needs to be posted. |
| SALEPOSTDATE |
datetime |
yes |
|
The post date of sold stock or property |
| ISSUER |
nvarchar(100) |
|
Default = '' |
|
| NUMBEROFUNITS |
decimal(20, 3) |
|
Default = 0 |
|
| SYMBOL |
nvarchar(25) |
|
Default = '' |
|
| MEDIANPRICE |
decimal(19, 4) |
|
Default = 0 |
|
| NOTEDATEENTERED |
datetime |
yes |
|
The date the note was entered. |
| NOTETITLE |
nvarchar(50) |
|
Default = '' |
The title of the note. |
| NOTETEXTNOTE |
nvarchar(max) |
|
Default = '' |
The text that comprises this note. |
| MGDATE |
datetime |
yes |
|
|
| MGAMOUNT |
money |
|
Default = 0 |
|
| MGDONOTACKNOWLEDGE |
bit |
|
Default = 0 |
|
| MGPOSTDATE |
datetime |
yes |
|
|
| MGPOSTSTATUSCODE |
tinyint |
|
Default = 1 |
1=Not posted, 2=Do not post |
| GIVENANONYMOUSLY |
bit |
|
Default = 0 |
Indicates if the donation or pledge was given anonymously. |
| GIVENANONYMOUSLYDEFAULTEDFORCONSTITUENTID |
uniqueidentifier |
yes |
|
Indicates which constituent we've used to default the given anonymously flag. |
| USERMODIFIEDRECEIPTAMOUNT |
bit |
|
Default = 0 |
Indicates if the user set the RECEIPTAMOUNT field or if the system set it. |
| DATEADDED |
datetime |
|
Default = getdate() |
Indicates the date this record was added. |
| DATECHANGED |
datetime |
|
Default = getdate() |
Indicates the date this record was last changed. |
| TS |
timestamp |
|
|
Timestamp. |
| TSLONG |
bigint (Computed) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| PAYMENTFORPLEDGEAMOUNT |
money |
|
Default = 0 |
The amount of a payment to apply to this record if it is a pledge. |
| RECEIPTTYPECODE |
tinyint |
|
Default = 0 |
The preference with which to receipt this revenue record. |
| ACKNOWLEDGEDATE |
datetime |
yes |
|
The date that the letter was sent. |
| REFERENCE |
nvarchar(255) |
|
Default = '' |
Comments specific to this revenue record. |
| APPLICATIONCODE |
tinyint |
|
Default = 0 |
0=Donation, 1=Other, 2=Unapplied matching gift claim, 3=Sponsorship additional donation, 255=Not specified |
| DIRECTDEBITRESULTCODE |
nvarchar(10) |
|
Default = '' |
The result code from a direct debit return file. |
| LOWPRICE |
decimal(19, 4) |
|
Default = 0 |
|
| HIGHPRICE |
decimal(19, 4) |
|
Default = 0 |
|
| NUMBEROFUNITSSOLD |
decimal(20, 3) |
|
Default = 0 |
|
| USERMODIFIEDNUMBEROFUNITSSOLD |
bit |
|
Default = 0 |
Indicates if the user set the NUMBEROFUNITSSOLD field or if the system set it. |
| REJECTIONMESSAGE |
nvarchar(500) |
|
Default = '' |
The reason the credit card couldn't be authorized. |
| STANDINGORDERSETUP |
bit |
|
Default = 0 |
Indicates whether the standing order has been setup. |
| STANDINGORDERSETUPDATE |
datetime |
yes |
|
Date the standing order was setup. |
| TRANSACTIONID |
uniqueidentifier |
yes |
|
The BBPS transaction ID for a card not present transaction. |
| DECLINESGIFTAID |
bit |
|
Default = 0 |
Indicates whether the single designation declines Gift Aid. |
| DDISOURCEDATE |
date |
yes |
|
UK only paperless mandates DDI source date. |
| ISCOVENANT |
bit |
|
Default = 0 |
Indicates whether a pledge is a covenant gift. |
| TYPE |
nvarchar(14) (Computed) |
yes |
CASE [TYPECODE] WHEN 0 THEN N'Payment' WHEN 1 THEN N'Pledge' WHEN 3 THEN N'Recurring gift' END |
Provides a translation for the 'TYPECODE' field. |
| POSTSTATUS |
nvarchar(11) (Computed) |
yes |
CASE [POSTSTATUSCODE] WHEN 1 THEN N'Not posted' WHEN 2 THEN N'Do not post' WHEN 255 THEN N'None' END |
Provides a translation for the 'POSTSTATUSCODE' field. |
| SALEPOSTSTATUS |
nvarchar(11) (Computed) |
yes |
CASE [SALEPOSTSTATUSCODE] WHEN 1 THEN N'Not posted' WHEN 2 THEN N'Do not post' WHEN 255 THEN N'None' END |
Provides a translation for the 'SALEPOSTSTATUSCODE' field. |
| MGPOSTSTATUS |
nvarchar(11) (Computed) |
yes |
CASE [MGPOSTSTATUSCODE] WHEN 1 THEN N'Not posted' WHEN 2 THEN N'Do not post' END |
Provides a translation for the 'MGPOSTSTATUSCODE' field. |
| RECEIPTTYPE |
nvarchar(12) (Computed) |
yes |
CASE [RECEIPTTYPECODE] WHEN 0 THEN N'Per payment' WHEN 1 THEN N'Consolidated' WHEN 255 THEN N'None' END |
Provides a translation for the 'RECEIPTTYPECODE' field. |
| AMOUNTFORVAT |
money |
|
Default = 0 |
Amount subject to value added tax. |
| VATAMOUNT |
money |
|
Default = 0 |
Amount of value added tax. |
| APPLICATIONINFO |
nvarchar(60) |
|
Default = '' |
Application ID, type and amount for a single application. |
| REVENUELOOKUPID |
nvarchar(100) |
|
Default = '' |
The lookupID that will be assigned to this revenue record. |
| MGGENERATED |
bit |
|
Default = 0 |
Indicates whether or not matching gift claims have been generated for this batch transaction. |
| MGALTERED |
bit |
|
Default = 0 |
Indicates whether or not matching gift claims have been manually altered causing claims not to be automatically generated in the future. |
| GIFTINKINDITEMNAME |
nvarchar(100) |
|
Default = '' |
Stores the name of the item |
| GIFTINKINDDISPOSITIONCODE |
tinyint |
|
Default = 0 |
Whether the item is designated for sale or use |
| GIFTINKINDDISPOSITION |
nvarchar(7) (Computed) |
yes |
CASE [GIFTINKINDDISPOSITIONCODE] WHEN 0 THEN N'To use' WHEN 1 THEN N'To sell' END |
Provides a translation for the 'GIFTINKINDDISPOSITIONCODE' field. |
| GIFTINKINDNUMBEROFUNITS |
int |
|
Default = 0 |
The number of units of the item issued. |
| GIFTINKINDFAIRMARKETVALUE |
money |
|
Default = 0 |
The value assessed to each unit of the item |
| DIRECTDEBITISREJECTED |
bit |
|
Default = 0 |
Indicates if the direct debit payment has been rejected. |
| APPLICATION |
nvarchar(31) (Computed) |
yes |
CASE [APPLICATIONCODE] WHEN 0 THEN N'Donation' WHEN 1 THEN N'Other' WHEN 2 THEN N'Unapplied matching gift claim' WHEN 3 THEN N'Sponsorship additional donation' WHEN 255 THEN N'Not specified' END |
Provides a translation for the 'APPLICATIONCODE' field. |
| ISGIFTAIDSPONSORSHIP |
bit |
|
Default = 0 |
Indicates if the single designation is a Gift Aid sponsorship. |
| LOCKBOXBATCHNUMBER |
nvarchar(100) |
|
Default = '' |
Batch number |
| LOCKBOXBATCHSEQUENCE |
int |
|
Default = 0 |
Batch sequence |
| REVENUESPLITID |
uniqueidentifier |
yes |
|
Split id for revenue update batch. |
| ISADJUSTMENT |
bit |
|
Default = 0 |
used by revenue update batch to determine adjustments. |
| ADJUSTMENTDATE |
datetime |
yes |
|
The date of the adjustment to the revenue record. |
| ADJUSTMENTPOSTDATE |
datetime |
yes |
|
The date to use when posting the adjustment to the revenue record. |
| ADJUSTMENTPOSTSTATUSCODE |
tinyint |
|
Default = 1 |
Flag used to indicate if the adjustment has been posted. |
| ADJUSTMENTPOSTSTATUS |
nvarchar(11) (Computed) |
yes |
CASE [ADJUSTMENTPOSTSTATUSCODE] WHEN 0 THEN N'Posted' WHEN 1 THEN N'Not Posted' WHEN 2 THEN N'Do Not Post' END |
Provides a translation for the 'ADJUSTMENTPOSTSTATUSCODE' field. |
| ADJUSTMENTREASON |
nvarchar(300) |
|
Default = '' |
Gives further details for why this adjustment was made. |
| OVERRIDEBUSINESSUNITS |
bit |
|
Default = 0 |
Boolean value to tell whether business units attached to the application/payment were overridden |
| ORIGINALAPPLICATIONINFO |
nvarchar(60) |
|
Default = '' |
Application ID, type and amount for the original single application used by revenue update batch. |
| BASEEXCHANGERATEID |
uniqueidentifier |
yes |
|
The exchange rate used to convert from transaction amount to amount. |
| RELOADRECOGNITION |
bit |
|
Default = 0 |
Indicates the reload of recognition credit when changing constituent on revenue update batch. |
| RELOADSOLICITORS |
bit |
|
Default = 0 |
Indicates the reload of solicitors when changing constituent on revenue update batch. |
| EXCHANGERATE |
decimal(20, 8) |
|
Default = 0 |
The rate to use when adding a spot rate. |
| USESYSTEMGENERATEDREFERENCENUMBER |
bit |
|
Default = 1 |
If true, use the system-generated reference number. |
| STANDINGORDERREFERENCENUMBER |
nvarchar(18) |
|
Default = '' |
The user-defined reference number for this standing order. |
| UPDATEMATCHINGGIFTCLAIMSCODE |
tinyint |
|
Default = 0 |
0 - Do not adjust, 1 - Adjust proportionally, 2 - Adjust based on current constituent defaults. |
| UPDATEMATCHINGGIFTCLAIMS |
nvarchar(44) (Computed) |
yes |
CASE [UPDATEMATCHINGGIFTCLAIMSCODE] WHEN 0 THEN N'Do not adjust' WHEN 1 THEN N'Adjust proportionally' WHEN 2 THEN N'Adjust based on current constituent defaults' END |
Provides a translation for the 'UPDATEMATCHINGGIFTCLAIMSCODE' field. |
| UPDATEGIFTFEES |
bit |
|
Default = 0 |
Indicates whether gift fees should be updated. |
| UPDATETRIBUTES |
bit |
|
Default = 0 |
Indicates whether tributes should be updated for a revenue update batch row. |
| INSTALLMENTSCHEDULESEEDDATE |
datetime |
yes |
|
Seed date used to build installment schedule on a recurring gift. |
| APPLYBYPERCENT |
bit |
|
Default = 0 |
Apply the amounts by percentage (for Batch UI) |
| MERCHANTACCOUNTID |
uniqueidentifier |
yes |
|
Indicates the merchant account to use for processing the credit card transactions. |
| ADJPAYMENT_DATE |
datetime |
yes |
|
|
| ADJPAYMENT_POSTDATE |
datetime |
yes |
|
|
| ADJPAYMENT_DETAILS |
nvarchar(255) |
|
Default = '' |
|
| SALE_LOWPRICE |
decimal(19, 4) |
|
Default = 0 |
|
| SALE_MEDIANPRICE |
decimal(19, 4) |
|
Default = 0 |
|
| SALE_HIGHPRICE |
decimal(19, 4) |
|
Default = 0 |
|
| CREDITCARDATTEMPTCOUNT |
tinyint |
|
Default = 0 |
|
| VENDORID |
nvarchar(50) |
|
Default = '' |
|
| CLIENTAPPLICENSEID |
nvarchar(100) |
|
Default = '' |
|
| RECEIPTSTACKSHORTNAME |
nvarchar(20) |
|
Default = '' |
|
| NAMECODE |
tinyint |
|
Default = 1 |
|
| SIMILARADDRESSCODE |
tinyint |
|
Default = 3 |
|
| UNSIMILARADDRESSCODE |
tinyint |
|
Default = 3 |
|
| UNSIMILARADDRESS |
nvarchar(42) (Computed) |
yes |
CASE [UNSIMILARADDRESSCODE] WHEN 0 THEN N'Ignore address' WHEN 3 THEN N'Add as new address' WHEN 2 THEN N'Require manual review (generate exception)' END |
|
| NEWADDRESSENDDATECODE |
tinyint |
|
Default = 0 |
|
| NEWADDRESSPRIMARYCODE |
tinyint |
|
Default = 1 |
|
| BIRTHDATERULECODE |
tinyint |
|
Default = 1 |
|
| DIFFERENTPHONECODE |
tinyint |
|
Default = 3 |
|
| NEWPHONEENDDATECODE |
tinyint |
|
Default = 0 |
|
| NEWPHONEPRIMARYCODE |
tinyint |
|
Default = 1 |
|
| DIFFERENTEMAILCODE |
tinyint |
|
Default = 3 |
|
| DIFFERENTEMAIL |
nvarchar(42) (Computed) |
yes |
CASE [DIFFERENTEMAILCODE] WHEN 0 THEN N'Ignore email address' WHEN 3 THEN N'Add as new email address' WHEN 2 THEN N'Require manual review (generate exception)' END |
|
| NEWEMAILENDDATECODE |
tinyint |
|
Default = 0 |
|
| NEWEMAILPRIMARYCODE |
tinyint |
|
Default = 1 |
|
| USEGLOBALSETTINGS |
bit |
|
Default = 1 |
|
| CREATEHISTORICALNAMECODE |
tinyint |
|
Default = 1 |
|
| CREATEHISTORICALNAME |
nvarchar(3) (Computed) |
yes |
CASE [CREATEHISTORICALNAMECODE] WHEN 0 THEN N'No' WHEN 1 THEN N'Yes' END |
|
| NAME |
nvarchar(42) (Computed) |
yes |
CASE [NAMECODE] WHEN 0 THEN N'Ignore name' WHEN 1 THEN N'Update name' WHEN 2 THEN N'Require manual review (generate exception)' WHEN 3 THEN N'Add name as an alias' END |
|
| SIMILARADDRESS |
nvarchar(63) (Computed) |
yes |
CASE [SIMILARADDRESSCODE] WHEN 0 THEN N'Ignore address' WHEN 1 THEN N'Update existing address (old address data will not be retained)' WHEN 2 THEN N'Require manual review (generate exception)' WHEN 3 THEN N'Add as new address' END |
|
| NEWADDRESSENDDATE |
nvarchar(30) (Computed) |
yes |
CASE [NEWADDRESSENDDATECODE] WHEN 0 THEN N'Make existing address inactive' WHEN 1 THEN N'Keep existing address active' END |
|
| NEWADDRESSPRIMARY |
nvarchar(61) (Computed) |
yes |
CASE [NEWADDRESSPRIMARYCODE] WHEN 0 THEN N'Never' WHEN 1 THEN N'Only if the current primary address has the same address type' WHEN 2 THEN N'Always' END |
|
| DIFFERENTPHONE |
nvarchar(42) (Computed) |
yes |
CASE [DIFFERENTPHONECODE] WHEN 0 THEN N'Ignore phone' WHEN 3 THEN N'Add as new phone' WHEN 2 THEN N'Require manual review (generate exception)' END |
|
| NEWPHONEENDDATE |
nvarchar(28) (Computed) |
yes |
CASE [NEWPHONEENDDATECODE] WHEN 0 THEN N'Make existing phone inactive' WHEN 1 THEN N'Keep existing phone active' END |
|
| NEWPHONEPRIMARY |
nvarchar(57) (Computed) |
yes |
CASE [NEWPHONEPRIMARYCODE] WHEN 0 THEN N'Never' WHEN 1 THEN N'Only if the current primary phone has the same phone type' WHEN 2 THEN N'Always' END |
|
| NEWEMAILENDDATE |
nvarchar(36) (Computed) |
yes |
CASE [NEWEMAILENDDATECODE] WHEN 0 THEN N'Make existing email address inactive' WHEN 1 THEN N'Keep existing email address active' END |
|
| NEWEMAILPRIMARY |
nvarchar(65) (Computed) |
yes |
CASE [NEWEMAILPRIMARYCODE] WHEN 0 THEN N'Never' WHEN 1 THEN N'Only if the current primary email address has the same email type' WHEN 2 THEN N'Always' END |
|
| PAYMENTFORPLEDGERECEIPTAMOUNT |
money |
|
Default = 0 |
|
| INSTALLMENTAMOUNT |
money |
yes |
Default = 0 |
|
| SPLITSCHEDULEOPTIONCODE |
tinyint |
|
Default = 0 |
|
| SPLITSCHEDULEOPTION |
nvarchar(17) (Computed) |
yes |
CASE [SPLITSCHEDULEOPTIONCODE] WHEN 0 THEN N'Distribute evenly' WHEN 1 THEN N'Priority order' WHEN 2 THEN N'Custom' END |
|
| BIRTHDATERULE |
nvarchar(17) (Computed) |
yes |
CASE [BIRTHDATERULECODE] WHEN 0 THEN N'Ignore birth date' WHEN 1 THEN N'Update birth date' END |
|
| REQUIRECREDITCARDPROCESSING |
bit |
|
Default = 0 |
|
| NOTEHTMLNOTE |
nvarchar(max) |
|
Default = '' |
|
| CARDHOLDERNAME |
nvarchar(255) |
|
Default = '' |
|
| CREDITCARDPARTIALNUMBER |
nvarchar(4) |
|
Default = '' |
|
| EXPIRESON |
UDT_FUZZYDATE |
|
Default = '00000000' |
|
| INSTALLMENTFREQUENCY |
nvarchar(18) (Computed) |
yes |
CASE [INSTALLMENTFREQUENCYCODE] WHEN 0 THEN N'Annually' WHEN 1 THEN N'Semi-annually' WHEN 2 THEN N'Quarterly' WHEN 3 THEN N'Monthly' WHEN 4 THEN N'Irregular' WHEN 5 THEN N'Single Installment' WHEN 6 THEN N'Bimonthly' WHEN 7 THEN N'Semi-Monthly' WHEN 8 THEN N'Biweekly' WHEN 9 THEN N'Weekly' WHEN 10 THEN N'Every 4 weeks' WHEN 255 THEN N'None' END |
|
| PAYMENTMETHOD |
nvarchar(47) (Computed) |
yes |
CASE [PAYMENTMETHODCODE] WHEN 255 THEN N'Not Specified' WHEN 0 THEN N'Cash' WHEN 1 THEN N'Check' WHEN 2 THEN N'Credit Card' WHEN 3 THEN N'Direct Debit' WHEN 4 THEN N'Stock' WHEN 5 THEN N'Property' WHEN 6 THEN N'Gift-in-kind' WHEN 9 THEN N'None' WHEN 10 THEN N'Other' WHEN 11 THEN N'Standing Order' WHEN 98 THEN N'Credit card - store last 4 digits for reference' WHEN 101 THEN N'PayPal' WHEN 102 THEN N'Venmo' END |
|