Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 SEQUENCE int   Default = 0
 BILLTOCONSTITUENTID uniqueidentifier  
 DATEADDED datetime   Default = getdate()
 DATECHANGED datetime   Default = getdate()
 TS timestamp  
 TSLONG bigint (Computed) CONVERT(bigint, TS)
 MEMBERSHIPRECIPIENTID uniqueidentifier
 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 = ''
 CONSTITUENTACCOUNTID uniqueidentifier
 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
 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
 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 = ''
 MEMBERSHIPTRANSACTIONTYPE nvarchar(18) (Computed) CASE [MEMBERSHIPTRANSACTIONTYPECODE] WHEN 0 THEN N'Add membership' WHEN 1 THEN N'Renew membership' WHEN 2 THEN N'Pay membership' WHEN 3 THEN N'Upgrade membership' END
 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' WHEN 100 THEN N'None' END
 CREDITCARDATTEMPTCOUNT tinyint   Default = 0
 NAMECODE tinyint   Default = 1
 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 alias' END
 SIMILARADDRESSCODE tinyint   Default = 3
 SIMILARADDRESS nvarchar(58) (Computed) CASE [SIMILARADDRESSCODE] WHEN 0 THEN N'Ignore address' WHEN 1 THEN N'Update existing address (old address will not be retained)' WHEN 2 THEN N'Require manual review (generate exception)' WHEN 3 THEN N'Add as new address' END
 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
 NEWADDRESSENDDATE nvarchar(27) (Computed) CASE [NEWADDRESSENDDATECODE] WHEN 0 THEN N'End-date the old address' WHEN 1 THEN N'Keep the old address active' END
 NEWADDRESSPRIMARYCODE tinyint   Default = 1
 NEWADDRESSPRIMARY nvarchar(57) (Computed) CASE [NEWADDRESSPRIMARYCODE] WHEN 0 THEN N'Never' WHEN 1 THEN N'Only if the old primary address had the same address type' WHEN 2 THEN N'Always' END
 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
 DIFFERENTPHONE nvarchar(42) (Computed) CASE [DIFFERENTPHONECODE] WHEN 0 THEN N'Ignore phone number' WHEN 3 THEN N'Add as new phone number' WHEN 2 THEN N'Require manual review (generate exception)' END
 NEWPHONEENDDATECODE tinyint   Default = 0
 NEWPHONEENDDATE nvarchar(25) (Computed) CASE [NEWPHONEENDDATECODE] WHEN 0 THEN N'End-date the old phone' WHEN 1 THEN N'Keep the old phone active' END
 NEWPHONEPRIMARYCODE tinyint   Default = 1
 NEWPHONEPRIMARY nvarchar(53) (Computed) CASE [NEWPHONEPRIMARYCODE] WHEN 0 THEN N'Never' WHEN 1 THEN N'Only if the old primary phone had the same phone type' WHEN 2 THEN N'Always' END
 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
 NEWEMAILENDDATE nvarchar(25) (Computed) CASE [NEWEMAILENDDATECODE] WHEN 0 THEN N'End-date the old email' WHEN 1 THEN N'Keep the old email active' END
 NEWEMAILPRIMARYCODE tinyint   Default = 1
 NEWEMAILPRIMARY nvarchar(61) (Computed) CASE [NEWEMAILPRIMARYCODE] WHEN 0 THEN N'Never' WHEN 1 THEN N'Only if the old primary email address had the same email type' WHEN 2 THEN N'Always' END
 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

Foreign Key Field Type Null Notes Description
 BATCHID uniqueidentifier   BATCH.ID
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID
 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
 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
 BATCHMEMBERSHIPDUESBBNCINFO BATCHMEMBERSHIPDUESID
 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-CHANNELCODE)
Entity-Relationship diagram of this table (CREDITCARD-TRIBUTE)