| SEQUENCE |
int |
|
Default = 0 |
|
| BILLTOCONSTITUENTID |
uniqueidentifier |
|
|
|
| DATEADDED |
datetime |
|
Default = getdate() |
|
| DATECHANGED |
datetime |
|
Default = getdate() |
|
| TS |
timestamp |
|
|
|
| TSLONG |
bigint (Computed) |
yes |
CONVERT(bigint, TS) |
|
| MEMBERSHIPRECIPIENTID |
uniqueidentifier |
yes |
|
|
| RENEWALRECIPIENTCODE |
tinyint |
|
Default = 1 |
|
| FINDERNUMBER |
bigint |
|
Default = ((0)) |
|
| DATE |
date |
yes |
|
|
| PAYADDITIONALTONEXTINSTALLMENT |
bit |
|
Default = 0 |
|
| PAYADDITIONALMONEYAMOUNT |
money |
|
Default = 0 |
|
| MEMBERSHIPEXPIRESONDATE |
date |
yes |
|
|
| 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 |
yes |
|
|
| 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 |
yes |
|
|
| 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) |
yes |
CASE [EVENTREGISTRATIONTYPECODE] WHEN 0 THEN N'Pre-registration' WHEN 1 THEN N'Walk-up registration' END |
|
| BASEEXCHANGERATEID |
uniqueidentifier |
yes |
|
|
| ADDDONATION |
bit |
|
Default = 0 |
|
| AUTOPAY |
bit |
|
Default = 0 |
|
| EXCHANGERATE |
decimal(20, 8) |
|
Default = 0 |
|
| TOTALAMOUNT |
money |
|
Default = 0 |
|
| REJECTIONMESSAGE |
nvarchar(500) |
|
Default = '' |
|
| DUESTYPECODE |
tinyint |
|
Default = 0 |
|
| DUESTYPE |
nvarchar(35) (Computed) |
yes |
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 |
|
| MEMBERSHIPTRANSACTIONAMOUNT |
money |
|
Default = 0 |
|
| PLEDGEFREQUENCY |
nvarchar(18) (Computed) |
yes |
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 |
yes |
|
|
| DIRECTDEBITISREJECTED |
bit |
|
Default = 0 |
|
| RENEWALRECIPIENT |
nvarchar(24) (Computed) |
yes |
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 |
yes |
|
|
| POSTSTATUSCODE |
tinyint |
|
Default = 1 |
|
| POSTSTATUS |
nvarchar(11) (Computed) |
yes |
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 |
yes |
|
|
| VENDORID |
nvarchar(50) |
|
Default = '' |
|
| MEMBERSHIPTRANSACTIONTYPE |
nvarchar(18) (Computed) |
yes |
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 |
|
| CREDITCARDATTEMPTCOUNT |
tinyint |
|
Default = 0 |
|
| NAMECODE |
tinyint |
|
Default = 1 |
|
| 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 alias' END |
|
| SIMILARADDRESSCODE |
tinyint |
|
Default = 3 |
|
| SIMILARADDRESS |
nvarchar(58) (Computed) |
yes |
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) |
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 |
|
| NEWADDRESSENDDATE |
nvarchar(27) (Computed) |
yes |
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) |
yes |
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) |
yes |
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) |
yes |
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) |
yes |
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) |
yes |
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) |
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 |
|
| NEWEMAILENDDATE |
nvarchar(25) (Computed) |
yes |
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) |
yes |
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) |
yes |
CASE [CREATEHISTORICALNAMECODE] WHEN 0 THEN N'No' WHEN 1 THEN N'Yes' END |
|
| REQUIRECREDITCARDPROCESSING |
bit |
|
Default = 0 |
|
| REVENUETYPE |
nvarchar(21) (Computed) |
yes |
CASE [REVENUETYPECODE] WHEN 0 THEN N'Pay in full' WHEN 1 THEN N'Pay first installment' WHEN 2 THEN N'Pledge' WHEN 3 THEN N'Pay other amount' END |
|
| ISGENERATEDPAYMENT |
bit |
|
Default = 0 |
|
| PAYMENTMETHOD |
nvarchar(11) (Computed) |
yes |
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 101 THEN N'PayPal' WHEN 102 THEN N'Venmo' WHEN 10 THEN N'Other' WHEN 100 THEN N'None' END |
|