Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 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 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 The date that the gift was receipted.
 APPLYTOSHOWNFORCONSTITUENTID uniqueidentifier 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 The start date for the schedule.
 INSTALLMENTENDDATE datetime 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 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 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 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 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
 MGAMOUNT money   Default = 0
 MGDONOTACKNOWLEDGE bit   Default = 0
 MGPOSTDATE datetime
 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 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) 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 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(250)   Default = '' The reason the credit card couldn't be authorized.
 STANDINGORDERSETUP bit   Default = 0 Indicates whether the standing order has been setup.
 STANDINGORDERSETUPDATE datetime Date the standing order was setup.
 TRANSACTIONID uniqueidentifier The BBPS transaction ID for a card not present transaction.
 DECLINESGIFTAID bit   Default = 0 Indicates whether the single designation declines Gift Aid.
 DDISOURCEDATE date UK only paperless mandates DDI source date.
 ISCOVENANT bit   Default = 0 Indicates whether a pledge is a covenant gift.
 PAYMENTMETHOD nvarchar(14) (Computed) 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' END Provides a translation for the 'PAYMENTMETHODCODE' field.
 TYPE nvarchar(14) (Computed) 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.
 INSTALLMENTFREQUENCY nvarchar(18) (Computed) 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 255 THEN N'None' END Provides a translation for the 'INSTALLMENTFREQUENCYCODE' field.
 POSTSTATUS nvarchar(11) (Computed) 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) 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) 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) 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) 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) 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 Split id for revenue update batch.
 ISADJUSTMENT bit   Default = 0 used by revenue update batch to determine adjustments.
 ADJUSTMENTDATE datetime The date of the adjustment to the revenue record.
 ADJUSTMENTPOSTDATE datetime 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) 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 overriden
 ORIGINALAPPLICATIONINFO nvarchar(60)   Default = '' Application ID, type and amount for the orginal single application used by revenue update batch.
 BASEEXCHANGERATEID uniqueidentifier 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) 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 Seed date used to build installment schedule on a recurring gift.
 APPLYBYPERCENT bit   Default = 0
 MERCHANTACCOUNTID uniqueidentifier
 ADJPAYMENT_DATE datetime
 ADJPAYMENT_POSTDATE datetime
 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) 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 = 0
 BIRTHDATERULE nvarchar(17) (Computed) CASE [BIRTHDATERULECODE] WHEN 0 THEN N'Ignore birth date' WHEN 1 THEN N'Update birth date' END
 DIFFERENTPHONECODE tinyint   Default = 3
 NEWPHONEENDDATECODE tinyint   Default = 0
 NEWPHONEPRIMARYCODE tinyint   Default = 1
 DIFFERENTEMAILCODE tinyint   Default = 3
 DIFFERENTEMAIL nvarchar(42) (Computed) 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) CASE [CREATEHISTORICALNAMECODE] WHEN 0 THEN N'No' WHEN 1 THEN N'Yes' END
 NAME nvarchar(42) (Computed) 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) 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) CASE [NEWADDRESSENDDATECODE] WHEN 0 THEN N'Make existing address inactive' WHEN 1 THEN N'Keep existing address active' END
 NEWADDRESSPRIMARY nvarchar(61) (Computed) 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) 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) CASE [NEWPHONEENDDATECODE] WHEN 0 THEN N'Make existing phone inactive' WHEN 1 THEN N'Keep existing phone active' END
 NEWPHONEPRIMARY nvarchar(57) (Computed) 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) 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) 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

Foreign Key Field Type Null Notes Description
 BATCHID uniqueidentifier   BATCH.ID FK to BATCH
 PROPERTYSUBTYPECODEID uniqueidentifier PROPERTYSUBTYPECODE.ID Property subtype
 GIFTINKINDSUBTYPECODEID uniqueidentifier GIFTINKINDSUBTYPECODE.ID Gift-in-kind subtype
 SINGLEDESIGNATIONID uniqueidentifier DESIGNATION.ID Stores the designation if there is only one.
 APPEALID uniqueidentifier APPEAL.LOCALID The appeal for the record.
 NOTEAUTHORID uniqueidentifier CONSTITUENT.LOCALID The author of the note
 NOTETYPECODEID uniqueidentifier REVENUENOTETYPECODE.ID Indicates the user-defined type of this note.
 MGMATCHINGCONSTITUENTID uniqueidentifier CONSTITUENT.LOCALID FK to CONSTITUENT
 MGCONDITIONID uniqueidentifier MATCHINGGIFTCONDITION.ID FK to MATCHINGGIFTCONDITION
 PLEDGESUBTYPEID uniqueidentifier PLEDGESUBTYPE.LOCALID Indicates the optional subtype for pledges.
 REJECTIONCODEID uniqueidentifier REJECTIONCODE.ID Indicates the reason this row was rejected.
 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.
 MGRELATIONSHIPID uniqueidentifier RELATIONSHIP.ID The relationship that applies for a matching gift claim.
 OTHERPAYMENTMETHODCODEID uniqueidentifier OTHERPAYMENTMETHODCODE.ID The other type of payment method used.
 LETTERCODEID uniqueidentifier LETTERCODE.LOCALID The letter associated with this revenue record.
 GLREVENUECATEGORYMAPPINGID uniqueidentifier GLREVENUECATEGORYMAPPING.ID Foreign key to the GLREVENUECATEGORYMAPPING table.
 ACKNOWLEDGEEID uniqueidentifier CONSTITUENT.LOCALID The recipient of the acknowledgement letter.
 OTHERTYPECODEID uniqueidentifier REVENUEOTHERTYPECODE.ID FK to REVENUEOTHERTYPECODE
 OPPORTUNITYID uniqueidentifier OPPORTUNITY.ID An opportunity associated with this revenue record.
 CREDITCARDID uniqueidentifier CREDITCARD.ID Stores the credit card details.
 DDISOURCECODEID uniqueidentifier DDISOURCECODE.ID UK only paperless mandates DDI source.
 VATTAXRATEID uniqueidentifier VATTAXRATE.ID Value added tax rate to used.
 PAYINGPENDINGREVENUEID uniqueidentifier FINANCIALTRANSACTION.ID Indicates which commitment this batch row was paying if it was generated by a generate payments business process.
 LOCKBOXID uniqueidentifier LOCKBOX.ID Lockbox
 PDACCOUNTSYSTEMID uniqueidentifier PDACCOUNTSYSTEM.ID FK to PDACCOUNTSYSTEM
 REVENUEID uniqueidentifier FINANCIALTRANSACTION.ID FK to REVENUE
 ADJUSTMENTREASONCODEID uniqueidentifier ADJUSTMENTREASONCODE.ID Indicates the reason this adjustment was made.
 REVENUESPLITBUSINESSUNITOVERRIDECODEID uniqueidentifier REVENUESPLITBUSINESSUNITOVERRIDECODE.ID Stores the reason for overriding business units on this revenue split record.
 REVENUEDEVELOPMENTFUNCTIONCODEID uniqueidentifier REVENUEDEVELOPMENTFUNCTIONCODE.ID Indicates a revenue function for the revenue update batch.
 BASECURRENCYID uniqueidentifier CURRENCY.ID The base currency associated with this revenue.
 TRANSACTIONCURRENCYID uniqueidentifier CURRENCY.ID The transaction currency associated with this revenue.
 ADJPAYMENT_REASONCODEID uniqueidentifier ADJUSTMENTREASONCODE.ID

Index Name Field(s) Unique Primary Clustered
 IX_BATCHREVENUE_ACKNOWLEDGEEID ACKNOWLEDGEEID      
 IX_BATCHREVENUE_BASECURRENCYID BASECURRENCYID      
 IX_BATCHREVENUE_BASEEXCHANGERATEID BASEEXCHANGERATEID      
 IX_BATCHREVENUE_BATCHID BATCHID      
 IX_BATCHREVENUE_CONSTITUENTID CONSTITUENTID      
 IX_BATCHREVENUE_DATEADDED DATEADDED    
 IX_BATCHREVENUE_DATECHANGED DATECHANGED      
 IX_BATCHREVENUE_ID ID      
 IX_BATCHREVENUE_MGMATCHINGCONSTITUENTID MGMATCHINGCONSTITUENTID      
 IX_BATCHREVENUE_NOTEAUTHORID NOTEAUTHORID      
 IX_BATCHREVENUE_PAYINGPENDINGREVENUEID PAYINGPENDINGREVENUEID      
 IX_BATCHREVENUE_REVENUEID REVENUEID      
 IX_BATCHREVENUE_TRANSACTIONCURRENCYID TRANSACTIONCURRENCYID      
 PK_BATCHREVENUE ID  

Trigger Name Description
 TR_BATCHREVENUE_AUDIT_UPDATE
 TR_BATCHREVENUE_AUDIT_DELETE
 TR_BATCHREVENUE_INSERTUPDATE_CURRENCY

Referenced by Field
 BATCHREVENUEADDITIONALAPPLICATIONS BATCHREVENUEID
 BATCHREVENUEAPPLICATION BATCHREVENUEID
 BATCHREVENUEBATCHSYSTEMMESSAGES BATCHREVENUEID
 BATCHREVENUEBATCHUSERMESSAGE ID
 BATCHREVENUEBBNCINFO BATCHREVENUEID
 BATCHREVENUEBENEFIT BATCHREVENUEID
 BATCHREVENUEBENEFITPCT BATCHREVENUEID
 BATCHREVENUEBUSINESSUNIT BATCHREVENUEID
 BATCHREVENUEENHANCEDMATCHINGGIFTS BATCHREVENUEID
 BATCHREVENUEINSTALLMENT BATCHREVENUEID
 BATCHREVENUELETTER BATCHREVENUEID
 BATCHREVENUEMATCHINGGIFTSPLIT BATCHREVENUEID
 BATCHREVENUENOTE BATCHREVENUEID
 BATCHREVENUERECOGNITION BATCHREVENUEID
 BATCHREVENUESOLICITOR BATCHREVENUEID
 BATCHREVENUESPLIT BATCHREVENUEID
 BATCHREVENUETAXDECLARATION BATCHREVENUEID
 BATCHREVENUETRIBUTE BATCHREVENUEID
 BATCHREVENUEUNAPPLIEDMATCHINGGIFTSPLIT BATCHREVENUEID

Entity-Relationship diagram of this table (ADJUSTMENTREASONCODE-BATCHREVENUENOTE)
Entity-Relationship diagram of this table (BATCHREVENUERECOGNITION-LETTERCODE)
Entity-Relationship diagram of this table (LOCKBOX-VATTAXRATE)