Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 DATE datetime  
 BATCHNUMBER nvarchar(100)   Default = ''
 POSTDATE datetime The date to use when posting the revenue record.
 DONOTPOST bit   Default = 0 Indicates whether the revenue should not be posted.
 DONOTRECEIPT bit   Default = 0 Indicates that this record should not be receipted.
 RECEIPTAMOUNT money   Default = 0 The amount to include for this gift in a receipt.
 AMOUNT money   Default = 0 Amount of gift
 SOURCECODE nvarchar(50)   Default = '' The direct marketing source code for this record.
 FINDERNUMBER bigint   Default = ((0)) The direct marketing finder number for this record.
 GIVENANONYMOUSLY bit   Default = 0 Indicates if this revenue was given anonymously.
 DONOTACKNOWLEDGE bit   Default = 0 Indicates that this record should not be acknowledged.
 BENEFITSWAIVED bit   Default = 0 Indicates if the benefits for this record were waived by the user.
 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) CONVERT(bigint, TS) Numeric representation of the timestamp.
 RECEIPTTYPECODE tinyint   Default = 0 The preference with which to receipt this revenue record.
 NEEDSRERECEIPT bit   Default = 0 Designates whether or not this revenue record needs to be re-receipted.
 TRANSACTIONTYPECODE tinyint   Default = 0 The type of revenue.
 DESCRIPTION nvarchar(700) (Computed) dbo.UFN_PAYMENT_GETDESCRIPTION(ID) Provides a translation field for the revenue record
 RECEIPTTYPE nvarchar(12) (Computed) CASE [RECEIPTTYPECODE] WHEN 0 THEN N'Per payment' WHEN 1 THEN N'Consolidated' END Provides a translation for the 'RECEIPTTYPECODE' field.
 ELIGIBLEFORMATCHINGGIFTCLAIM bit   Default = 0 If true, when this record was added, there was a problem auto-generating matching gift claims and the record may require attention.
 CUSTOMIDENTIFIER nvarchar(100)   Default = '' User-definable custom identifier.
 SEQUENCEID int   Identity column used to increment the default lookupid.
 LOOKUPID nvarchar(100) (Computed) (CASE LEN(CUSTOMIDENTIFIER) WHEN 0 THEN 'rev-' + CAST(SEQUENCEID AS nvarchar(20)) ELSE CUSTOMIDENTIFIER END) Unique identifer that supports user defined values as well as system generated values.
 ISREIMBURSABLE bit   Default = 0 Designates whether or not this record is reimbursable. True only valid for grant awards.
 ORGANIZATIONAMOUNT money   Default = 0 The amount of the revenue in organization currency.
 TRANSACTIONAMOUNT money   Default = 0 The amount of the revenue in transaction currency.
 TRANSACTIONTYPE nvarchar(21) (Computed) CASE [TRANSACTIONTYPECODE] WHEN 0 THEN N'Payment' WHEN 1 THEN N'Pledge' WHEN 2 THEN N'Recurring gift' WHEN 3 THEN N'Matching gift claim' WHEN 4 THEN N'Planned gift' WHEN 5 THEN N'Order' WHEN 6 THEN N'Grant award' WHEN 7 THEN N'Auction donation' WHEN 8 THEN N'Donor challenge claim' WHEN 9 THEN N'Pending gift' END Provides a translation for the 'TRANSACTIONTYPECODE' field.

Foreign Key Field Type Null Notes Description
 CONSTITUENTID uniqueidentifier CONSTITUENT.LOCALID FK to Constituent table.
 APPEALID uniqueidentifier APPEAL.LOCALID The appeal for this record.
 MAILINGID uniqueidentifier MKTSEGMENTATION.ID The mailing for this record.
 CHANNELCODEID uniqueidentifier CHANNELCODE.ID The channel for this record.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 BASECURRENCYID uniqueidentifier CURRENCY.ID The base currency associated with this revenue.
 TRANSACTIONCURRENCYID uniqueidentifier CURRENCY.ID The transaction currency associated with this revenue.
 ORGANIZATIONEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to convert to organization amount.
 BASEEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to convert from transaction amount to amount.

Index Name Field(s) Unique Primary Clustered
 IX_REVENUE_AMOUNT AMOUNT      
 IX_REVENUE_APPEALID_ID_MAILINGID_TRANSACTIONTYPECODE_CONSTITUENTID APPEALID, ID, MAILINGID, TRANSACTIONTYPECODE, CONSTITUENTID      
 IX_REVENUE_APPEALID_MAILINGID_TRANSACTIONTYPECODE_CONSTITUENTID APPEALID, MAILINGID, TRANSACTIONTYPECODE, CONSTITUENTID      
 IX_REVENUE_APPEALID_TRANSACTIONTYPECODE APPEALID, TRANSACTIONTYPECODE      
 IX_REVENUE_BASECURRENCYID BASECURRENCYID      
 IX_REVENUE_BASEEXCHANGERATEID BASEEXCHANGERATEID      
 IX_REVENUE_BATCHNUMBER BATCHNUMBER      
 IX_REVENUE_CONSTITUENTID_TRANSACTIONTYPECODE_DATE CONSTITUENTID, TRANSACTIONTYPECODE, DATE      
 IX_REVENUE_DATE DATE      
 IX_REVENUE_DATEADDED DATEADDED    
 IX_REVENUE_DATECHANGED DATECHANGED      
 IX_REVENUE_FINDERNUMBER FINDERNUMBER      
 IX_REVENUE_ID ID      
 IX_REVENUE_MAILINGID MAILINGID      
 IX_REVENUE_ORGANIZATIONEXCHANGERATEID ORGANIZATIONEXCHANGERATEID      
 IX_REVENUE_POSTDATE POSTDATE      
 IX_REVENUE_TRANSACTIONCURRENCYID TRANSACTIONCURRENCYID      
 IX_REVENUE_TRANSACTIONTYPECODE_DONOTRECEIPT TRANSACTIONTYPECODE, DONOTRECEIPT      
 PK_REVENUE ID  
 UC_REVENUE_LOOKUPID LOOKUPID    

Trigger Name Description
 TR_REVENUE_DELETE_BBNCREVENUEIDMAP
 TR_REVENUE_INSERT_BBNCREVENUEIDMAP
 TR_REVENUE_INSERT_PDACCOUNTSYSTEMID
 TR_REVENUE_AUDIT_UPDATE
 TR_REVENUE_AUDIT_DELETE
 TR_REVENUE_DELETE_DEPOSITLINK
 TR_REVENUE_MARKASCONSTITUENT
 TR_REVENUE_INSERTUPDATE_CURRENCY

Referenced by Field
 ADJUSTMENT REVENUEID
 AUCTIONITEMREVENUEPURCHASE REVENUEPURCHASEID
 AUCTIONPURCHASEADJUSTMENT REVENUEID
 AUCTIONPURCHASEGLDISTRIBUTION REVENUEID
 BATCHBBNCDONATIONGIFTAPPLICATION APPLICATIONID
 BATCHREVENUE PAYINGPENDINGREVENUEID
 BATCHREVENUE REVENUEID
 BATCHREVENUEAPPLICATION REVENUEID
 BENEFITADJUSTMENT REVENUEID
 CONSTITUENTORIGINATION REVENUEID
 CREDITORDERPAYMENTMAP ORDERPAYMENTID
 CREDITPAYMENT REVENUEID
 DESIGNATIONLEVELREVENUEINFORMATION REVENUEID
 DONORCHALLENGE LUMPSUMMATCHREVENUEID
 DONORCHALLENGEENCUMBERED MATCHEDREVENUEID
 EMAILJOBEXTENSION REVENUEID
 FAFEVENTCOMMUNICATIONCHANNELREVENUE REVENUEID
 GIFTFEEADJUSTMENT REVENUEID
 GLREVERSAL REVENUEID
 INSTALLMENT REVENUEID
 INSTALLMENTSPLIT PLEDGEID
 INSTALLMENTSPLITPAYMENT PLEDGEID
 MISCELLANEOUSPAYMENT ID
 PAYMENTGIFTFEEOVERRIDE ID
 PAYMENTORIGINALAMOUNT ID
 PDACCOUNTSYSTEMFORREVENUE ID
 PLANNEDGIFTADDITIONREVENUE REVENUEID
 PLANNEDGIFTPAYOUT REVENUEID
 PLANNEDGIFTPAYOUTADJUSTMENT REVENUEID
 PLANNEDGIFTPAYOUTSPLIT REVENUEID
 PLANNEDGIFTRECONCILE REVENUEID
 PLANNEDGIFTREVENUE REVENUEID
 PLEDGEGIFTFEEOVERRIDE ID
 PLEDGEORIGINALAMOUNT ID
 PLEDGEREMINDERSENT REVENUEID
 RE7MAPGIFT ID
 RECURRINGGIFTACTIVITY SOURCEREVENUEID
 RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY REVENUEID
 RECURRINGGIFTINSTALLMENT REVENUEID
 RECURRINGGIFTINSTALLMENTPAYMENT PAYMENTID
 RECURRINGGIFTWRITEOFF REVENUEID
 RESERVATIONSECURITYDEPOSITPAYMENT PAYMENTID
 REVENUEATTACHMENT REVENUEID
 REVENUEAUCTIONDONATION ID
 REVENUEBBNC ID
 REVENUEBENEFIT REVENUEID
 REVENUECOMMITMENTREVALUATION REVENUEID
 REVENUEDEVELOPMENTFUNCTION REVENUEID
 REVENUEFUNDINGREQUEST ID
 REVENUEGLDISTRIBUTION REVENUEID
 REVENUELETTER REVENUEID
 REVENUELOCKBOX ID
 REVENUEMATCHINGGIFT ID
 REVENUEMATCHINGGIFT MGSOURCEREVENUEID
 REVENUEMEDIALINK REVENUEID
 REVENUENOTE REVENUEID
 REVENUEOFFLINEDONATION ID
 REVENUEPAYMENTMETHOD REVENUEID
 REVENUEPOSTED ID
 REVENUERECEIPT REVENUEID
 REVENUEREFERENCE ID
 REVENUESCHEDULE ID
 REVENUESEGMENT REVENUEID
 REVENUESPLIT REVENUEID
 REVENUESTANDINGORDER ID
 REVENUETRIBUTE REVENUEID
 REVENUEVAT ID
 SALESORDER REVENUEID
 SALESORDERPAYMENT PAYMENTID
 UNREALIZEDGAINLOSSADJUSTMENT REVENUEID
 UNREALIZEDGAINLOSSGLDISTRIBUTION REVENUEID
 WRITEOFF REVENUEID

Entity-Relationship diagram of this table (ADJUSTMENT-DONORCHALLENGEENCUMBERED)
Entity-Relationship diagram of this table (EMAILJOBEXTENSION-PLEDGEGIFTFEEOVERRIDE)
Entity-Relationship diagram of this table (PLEDGEORIGINALAMOUNT-REVENUELOCKBOX)
Entity-Relationship diagram of this table (REVENUEMATCHINGGIFT-WRITEOFF)