Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 SEQUENCE int   Default = 0
 DATEADDED datetime   Default = getdate()
 DATECHANGED datetime   Default = getdate()
 TS timestamp  
 TSLONG bigint (Computed) CONVERT(bigint, TS)
 RENEWALRECIPIENTCODE tinyint   Default = 1
 FINDERNUMBER bigint   Default = ((0))
 DATE date
 PAYADDITIONALTONEXTINSTALLMENT bit   Default = 0
 PAYADDITIONALMONEYAMOUNT money   Default = 0
 MEMBERSHIPEXPIRESONDATE date
 MEMBERSHIPAMOUNT money   Default = 0
 MEMBERSHIPPLEDGEAMOUNT money   Default = 0
 USEDISCOUNT bit   Default = 0
 PROMOTIONCODE nvarchar(50)   Default = ''
 DONATIONAMOUNT money   Default = 0
 DONATIONGIVENANONYMOUSLY bit   Default = 0
 DONATIONDECLINESGIFTAID bit   Default = 0
 PLEDGEFREQUENCYCODE tinyint   Default = 5
 PLEDGENUMBEROFINSTALLMENTS int   Default = 0
 PLEDGESTARTDATE date
 CHECKDATE UDT_FUZZYDATE   Default = '00000000'
 CHECKNUMBER nvarchar(20)   Default = ''
 REFERENCENUMBER nvarchar(20)   Default = ''
 REFERENCEDATE UDT_FUZZYDATE   Default = '00000000'
 DIRECTDEBITRESULTCODE nvarchar(10)   Default = ''
 REFERENCE nvarchar(255)   Default = ''
 PAYMENTMETHODCODE tinyint   Default = 1
 AUTOMATICALLYRENEWMEMBERSHIP bit   Default = 0
 AUTHORIZATIONCODE nvarchar(20)   Default = ''
 DONOTACKNOWLEDGE bit   Default = 0
 TAXDEDUCTIBLEAMOUNT money   Default = 0
 DONOTRECEIPT bit   Default = 0
 COMMENTS nvarchar(1000)   Default = ''
 NEWEVENTREGISTRATION bit   Default = 0
 EVENTREGISTRATIONTYPECODE tinyint   Default = 0
 EVENTREGISTRATIONTYPE nvarchar(20) (Computed) CASE [EVENTREGISTRATIONTYPECODE] WHEN 0 THEN N'Pre-registration' WHEN 1 THEN N'Walk-up registration' END
 BASEEXCHANGERATEID uniqueidentifier
 ADDDONATION bit   Default = 0
 AUTOPAY bit   Default = 0
 EXCHANGERATE decimal(20, 8)   Default = 0
 TOTALAMOUNT money   Default = 0
 REJECTIONMESSAGE nvarchar(100)   Default = ''
 DUESTYPECODE tinyint   Default = 0
 DUESTYPE nvarchar(35) (Computed) CASE [DUESTYPECODE] WHEN 0 THEN N'Paying for membership' WHEN 1 THEN N'Giving a membership to someone else' WHEN 2 THEN N'Comp a membership' END
 MEMBERSHIPTRANSACTIONTYPECODE tinyint   Default = 0
 MEMBERSHIPTRANSACTIONTYPE nvarchar(16) (Computed) CASE [MEMBERSHIPTRANSACTIONTYPECODE] WHEN 0 THEN N'Add membership' WHEN 1 THEN N'Renew membership' WHEN 2 THEN N'Pay membership' END
 REVENUETYPECODE tinyint   Default = 0
 REVENUETYPE nvarchar(21) (Computed) CASE [REVENUETYPECODE] WHEN 0 THEN N'Pay in full' WHEN 1 THEN N'Pay first installment' WHEN 2 THEN N'Pledge' END
 MEMBERSHIPTRANSACTIONAMOUNT money   Default = 0
 PLEDGEFREQUENCY nvarchar(18) (Computed) CASE [PLEDGEFREQUENCYCODE] 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 7 THEN N'Semi-monthly' WHEN 8 THEN N'Biweekly' END
 SENDPLEDGEREMINDER bit   Default = 1
 TRANSACTIONID uniqueidentifier
 DIRECTDEBITISREJECTED bit   Default = 0
 RENEWALRECIPIENT nvarchar(24) (Computed) CASE [RENEWALRECIPIENTCODE] WHEN 0 THEN N'Giver' WHEN 1 THEN N'Primary member' WHEN 2 THEN N'Giver and primary member' END
 NUMBEROFCHILDREN int   Default = 0
 PAYMENTMETHOD nvarchar(11) (Computed) CASE [PAYMENTMETHODCODE] WHEN 0 THEN N'Cash' WHEN 1 THEN N'Check' WHEN 2 THEN N'Credit card' WHEN 3 THEN N'Debit card' WHEN 10 THEN N'Other' END
 POSTDATE date
 POSTSTATUSCODE tinyint   Default = 1
 POSTSTATUS nvarchar(11) (Computed) CASE [POSTSTATUSCODE] WHEN 1 THEN N'Not posted' WHEN 2 THEN N'Do not post' END
 SOURCECODE nvarchar(50)   Default = ''
 MEMBERSHIPDECLINESGIFTAID bit   Default = 0
 DDISOURCEDATE date
 VENDORID nvarchar(50)   Default = ''

Foreign Key Field Type Null Notes Description
 BATCHID uniqueidentifier   BATCH.ID
 BILLTOCONSTITUENTID uniqueidentifier   CONSTITUENT.LOCALID
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID
 MEMBERSHIPRECIPIENTID uniqueidentifier CONSTITUENT.LOCALID
 APPEALID uniqueidentifier APPEAL.LOCALID
 EFFORTID uniqueidentifier MKTSEGMENTATION.ID
 MEMBERSHIPPROGRAMID uniqueidentifier   MEMBERSHIPPROGRAM.ID
 MEMBERSHIPLEVELID uniqueidentifier   MEMBERSHIPLEVEL.ID
 MEMBERSHIPLEVELTERMID uniqueidentifier   MEMBERSHIPLEVELTERM.ID
 EXISTINGMEMBERSHIPID uniqueidentifier MEMBERSHIP.ID
 MEMBERSHIPPROMOID uniqueidentifier MEMBERSHIPPROMO.ID
 APPLIEDDISCOUNTID uniqueidentifier MEMBERSHIPPROMO.ID
 DONATIONOPPORTUNITYID uniqueidentifier OPPORTUNITY.ID
 DONATIONSINGLEDESIGNATIONID uniqueidentifier DESIGNATION.ID
 DONATIONCATEGORYCODEID uniqueidentifier GLREVENUECATEGORYMAPPING.ID
 CONSTITUENTACCOUNTID uniqueidentifier CONSTITUENTACCOUNT.ID
 CREDITCARDID uniqueidentifier CREDITCARD.ID
 TRIBUTEID uniqueidentifier TRIBUTE.LOCALID
 EVENTID uniqueidentifier EVENT.ID
 PDACCOUNTSYSTEMID uniqueidentifier PDACCOUNTSYSTEM.ID
 BASECURRENCYID uniqueidentifier CURRENCY.ID
 TRANSACTIONCURRENCYID uniqueidentifier CURRENCY.ID
 CONTRIBUTORYDESIGNATIONID uniqueidentifier DESIGNATION.ID
 LETTERCODEID uniqueidentifier LETTERCODE.LOCALID
 CHANNELCODEID uniqueidentifier CHANNELCODE.ID
 OTHERPAYMENTMETHODCODEID uniqueidentifier OTHERPAYMENTMETHODCODE.ID
 DDISOURCECODEID uniqueidentifier DDISOURCECODE.ID
 MEMBERSHIPLEVELTYPECODEID uniqueidentifier MEMBERSHIPLEVELTYPECODE.ID

Index Name Field(s) Unique Primary Clustered
 IX_BATCHMEMBERSHIPDUES_BATCHID BATCHID      
 IX_BATCHMEMBERSHIPDUES_BILLTOCONSTITUENTID BILLTOCONSTITUENTID      
 IX_BATCHMEMBERSHIPDUES_DATEADDED DATEADDED    
 IX_BATCHMEMBERSHIPDUES_DATECHANGED DATECHANGED      
 IX_BATCHMEMBERSHIPDUES_MEMBERSHIPRECIPIENTID MEMBERSHIPRECIPIENTID      
 PK_BATCHMEMBERSHIPDUES ID  

Trigger Name Description
 TR_BATCHMEMBERSHIPDUES_AUDIT_UPDATE
 TR_BATCHMEMBERSHIPDUES_AUDIT_DELETE
 TR_BATCHMEMBERSHIPDUES_INSERTUPDATE_CURRENCY

Referenced by Field
 BATCHMEMBERSHIPDUESBATCHSYSTEMMESSAGES BATCHMEMBERSHIPDUESID
 BATCHMEMBERSHIPDUESBATCHUSERMESSAGE ID
 BATCHMEMBERSHIPDUESBENEFIT BATCHMEMBERSHIPDUESID
 BATCHMEMBERSHIPDUESCAMPAIGN BATCHMEMBERSHIPDUESID
 BATCHMEMBERSHIPDUESDONATIONDESIGNATION BATCHMEMBERSHIPDUESID
 BATCHMEMBERSHIPDUESDONATIONRECOGNITION BATCHMEMBERSHIPDUESID
 BATCHMEMBERSHIPDUESDONATIONSOLICITOR BATCHMEMBERSHIPDUESID
 BATCHMEMBERSHIPDUESMEMBER BATCHMEMBERSHIPDUESID
 BATCHMEMBERSHIPDUESMEMBERSHIPCARD BATCHMEMBERSHIPDUESID
 BATCHMEMBERSHIPDUESMEMBERSHIPRECOGNITION BATCHMEMBERSHIPDUESID
 BATCHMEMBERSHIPDUESMEMBERSHIPROGRAMADDON BATCHMEMBERSHIPDUESID
 BATCHMEMBERSHIPDUESPERCENTAGEBENEFIT BATCHMEMBERSHIPDUESID
 BATCHMEMBERSHIPDUESPLEDGEINSTALLMENT BATCHMEMBERSHIPDUESID

Entity-Relationship diagram of this table (APPEAL-CONSTITUENT)
Entity-Relationship diagram of this table (CONSTITUENTACCOUNT-TRIBUTE)