CURRENCY

This table contains information about currency types.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
NAME	nvarchar(100)		Default = ''	The name of this Currency
ISO4217	nvarchar(3)		Default = ''	ISO4217 abbreviation
DECIMALDIGITS	tinyint		Default = 0	The number of digits after the decimal separator.
INACTIVE	bit		Default = 0	Denotes whether this currency is available for use.
CURRENCYSYMBOL	nvarchar(5)		Default = ''	The currency symbol for this record.
ROUNDINGTYPECODE	tinyint		Default = 0	The rounding method that this currency uses.
ROUNDINGTYPE	nvarchar(44) (Computed)	yes	CASE [ROUNDINGTYPECODE] WHEN 0 THEN N'Half rounds away from zero' WHEN 1 THEN N'Half rounds to nearest even number' WHEN 2 THEN N'Round 1 digit to nearest multiple of 5' WHEN 3 THEN N'Round 2 digits to the nearest multiple of 50' END	Provides a translation for the 'ROUNDINGTYPECODE' field.
ISORGANIZATIONCURRENCY	bit		Default = 0	Indicates whether or not this currency is the organization currency for the system.
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)	yes	CONVERT(bigint, TS)	Numeric representation of the timestamp.
SYMBOLDISPLAYSETTINGCODE	tinyint		Default = 0	Indicates whether this currency's symbol should be displayed with amounts
SYMBOLDISPLAYSETTING	nvarchar(65) (Computed)	yes	CASE [SYMBOLDISPLAYSETTINGCODE] WHEN 0 THEN N'Always display ISO code' WHEN 1 THEN N'Always display symbol' WHEN 2 THEN N'Display symbol if this currency is the region default of the user' END	Provides a translation for the 'SYMBOLDISPLAYSETTINGCODE' field.

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
LOCALEID	uniqueidentifier		LOCALE.ID	Windows locale to be used when formatting the currency
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_CURRENCY_DATEADDED	DATEADDED			yes
IX_CURRENCY_DATECHANGED	DATECHANGED
IX_CURRENCY_ID	ID
IX_CURRENCY_ISO4217_INACTIVE	ISO4217, INACTIVE
IX_CURRENCY_ISORGANIZATIONCURRENCY_ID	ISORGANIZATIONCURRENCY, ID
IX_CURRENCY_LOCALEID	LOCALEID
PK_CURRENCY	ID	yes	yes
UC_CURRENCY_ISO4217	ISO4217	yes
UC_CURRENCY_NAME	NAME	yes

Triggers

Trigger Name	Description
TR_CURRENCY_AUDIT_ETLDELETEDID
TR_CURRENCY_UPDATE_INSTALLATIONINFO
TR_CURRENCY_AUDIT_UPDATE
TR_CURRENCY_AUDIT_DELETE

Referenced by

Referenced by	Field
ADDOPPORTUNITIESPROCESS	TRANSACTIONCURRENCYID
ADDOPPORTUNITIESPROCESSOPPORTUNITYDESIGNATION	TRANSACTIONCURRENCYID
ADDPROSPECTPLANSPROCESS	OPPORTUNITYTRANSACTIONCURRENCYID
ADJUSTMENT	TRANSACTIONCURRENCYID
ADJUSTMENT	BASECURRENCYID
ADJUSTMENTHISTORYDETAIL	BASECURRENCYID
ADJUSTMENTHISTORYDETAIL	TRANSACTIONCURRENCYID
ADJUSTMENTHISTORYDISTRIBUTION	BASECURRENCYID
ADJUSTMENTHISTORYDISTRIBUTION	TRANSACTIONCURRENCYID
ADJUSTMENTHISTORYDISTRIBUTIONSNAPSHOT	BASECURRENCYID
ADJUSTMENTHISTORYDISTRIBUTIONSNAPSHOT	TRANSACTIONCURRENCYID
ADJUSTMENTHISTORYGIFTINKINDDISTRIBUTION	BASECURRENCYID
ADJUSTMENTHISTORYGIFTINKINDDISTRIBUTION	TRANSACTIONCURRENCYID
ADJUSTMENTHISTORYGIFTINKINDDISTRIBUTIONSNAPSHOT	BASECURRENCYID
ADJUSTMENTHISTORYGIFTINKINDDISTRIBUTIONSNAPSHOT	TRANSACTIONCURRENCYID
ADJUSTMENTHISTORYGIFTINKINDPAYMENTMETHODDETAIL	BASECURRENCYID
ADJUSTMENTHISTORYGIFTINKINDPAYMENTMETHODDETAIL	TRANSACTIONCURRENCYID
ADJUSTMENTHISTORYGIFTINKINDPAYMENTMETHODDETAILSNAPSHOT	BASECURRENCYID
ADJUSTMENTHISTORYGIFTINKINDPAYMENTMETHODDETAILSNAPSHOT	TRANSACTIONCURRENCYID
ADJUSTMENTHISTORYPROPERTYDETAIL	BASECURRENCYID
ADJUSTMENTHISTORYPROPERTYDETAIL	TRANSACTIONCURRENCYID
ADJUSTMENTHISTORYPROPERTYDISTRIBUTION	BASECURRENCYID
ADJUSTMENTHISTORYPROPERTYDISTRIBUTION	TRANSACTIONCURRENCYID
ADJUSTMENTHISTORYPROPERTYDISTRIBUTIONSNAPSHOT	BASECURRENCYID
ADJUSTMENTHISTORYPROPERTYDISTRIBUTIONSNAPSHOT	TRANSACTIONCURRENCYID
ADJUSTMENTHISTORYPROPERTYSNAPSHOT	BASECURRENCYID
ADJUSTMENTHISTORYPROPERTYSNAPSHOT	TRANSACTIONCURRENCYID
ADJUSTMENTHISTORYSTOCKDETAIL	BASECURRENCYID
ADJUSTMENTHISTORYSTOCKDETAIL	TRANSACTIONCURRENCYID
ADJUSTMENTHISTORYSTOCKDISTRIBUTION	BASECURRENCYID
ADJUSTMENTHISTORYSTOCKDISTRIBUTION	TRANSACTIONCURRENCYID
ADJUSTMENTHISTORYSTOCKDISTRIBUTIONSNAPSHOT	BASECURRENCYID
ADJUSTMENTHISTORYSTOCKDISTRIBUTIONSNAPSHOT	TRANSACTIONCURRENCYID
ADJUSTMENTHISTORYSTOCKSNAPSHOT	BASECURRENCYID
ADJUSTMENTHISTORYSTOCKSNAPSHOT	TRANSACTIONCURRENCYID
ADJUSTMENTHISTORYWRITEOFFDETAIL	BASECURRENCYID
ADJUSTMENTHISTORYWRITEOFFDETAIL	TRANSACTIONCURRENCYID
ADJUSTMENTHISTORYWRITEOFFDISTRIBUTION	BASECURRENCYID
ADJUSTMENTHISTORYWRITEOFFDISTRIBUTION	TRANSACTIONCURRENCYID
ADJUSTMENTHISTORYWRITEOFFDISTRIBUTIONSNAPSHOT	BASECURRENCYID
ADJUSTMENTHISTORYWRITEOFFDISTRIBUTIONSNAPSHOT	TRANSACTIONCURRENCYID
APPEAL	BASECURRENCYID
APPEALBENEFIT	BASECURRENCYID
APPEALBENEFITDETAIL	BASECURRENCYID
AUCTIONITEM	BASECURRENCYID
AUCTIONITEM	TRANSACTIONCURRENCYID
AUCTIONPURCHASEADJUSTMENT	BASECURRENCYID
AUCTIONPURCHASEADJUSTMENT	TRANSACTIONCURRENCYID
BANKACCOUNT	TRANSACTIONCURRENCYID
BANKACCOUNTDEPOSIT	TRANSACTIONCURRENCYID
BATCHAUCTIONITEM	BASECURRENCYID
BATCHAUCTIONITEM	TRANSACTIONCURRENCYID
BATCHBBNCDONATION	ATTRIBUTECURRENCYID
BATCHBBNCEVENTREGISTRATION	ATTRIBUTECURRENCYID
BATCHBBNCPROFILE	ATTRIBUTECURRENCYID
BATCHBBNCSIGNUP	ATTRIBUTECURRENCYID
BATCHCURRENCYEXCHANGERATE	FROMCURRENCYID
BATCHCURRENCYEXCHANGERATE	TOCURRENCYID
BATCHDESIGNATIONLEVELFINANCIALINFO	BASECURRENCYID
BATCHDIRECTMARKETINGEFFORT	BASECURRENCYID
BATCHDIRECTMARKETINGEFFORTPACKAGE	BASECURRENCYID
BATCHDIRECTMARKETINGEFFORTTESTSEGMENT	BASECURRENCYID
BATCHEVENT	BASECURRENCYID
BATCHMEMBERSHIPDUES	BASECURRENCYID
BATCHMEMBERSHIPDUES	TRANSACTIONCURRENCYID
BATCHMEMBERSHIPDUESMEMBERSHIPRECOGNITION	APPLICATIONCURRENCYID
BATCHMEMBERSHIPDUESPLEDGEINSTALLMENT	TRANSACTIONCURRENCYID
BATCHREVENUE	BASECURRENCYID
BATCHREVENUE	TRANSACTIONCURRENCYID
BATCHREVENUEAPPLICATIONPLEDGEBENEFIT	BENEFITCURRENCYID
BATCHREVENUEBENEFIT	BENEFITCURRENCYID
BATCHREVENUEENHANCEDMATCHINGGIFTS	TRANSACTIONCURRENCYID
BATCHREVENUEUNAPPLIEDMATCHINGGIFTSPLIT	BASECURRENCYID
BATCHREVENUEUNAPPLIEDMATCHINGGIFTSPLIT	TRANSACTIONCURRENCYID
BATCHSPONSORSHIP	BASECURRENCYID
BATCHSPONSORSHIP	TRANSACTIONCURRENCYID
BENEFIT	BASECURRENCYID
BENEFITADJUSTMENT	TRANSACTIONCURRENCYID
BENEFITADJUSTMENT	BASECURRENCYID
CAMPAIGN	BASECURRENCYID
CONSTITUENTRECOGNITION	BASECURRENCYID
CONSTITUENTRECOGNITIONBENEFIT	BASECURRENCYID
CONSTITUENTRECOGNITIONREVENUE	BASECURRENCYID
CREDITCARDPROCESSINGMERCHANTACCOUNT	CURRENCYID
CURRENCYDENOMINATION	CURRENCYID
CURRENCYEXCHANGERATE	FROMCURRENCYID
CURRENCYEXCHANGERATE	TOCURRENCYID
CURRENCYEXCHANGERATEDOWNLOADPROCESSRATE	FROMCURRENCYID
CURRENCYEXCHANGERATEDOWNLOADPROCESSRATE	TOCURRENCYID
CURRENCYSET	BASECURRENCYID
CURRENCYSETTRANSACTIONCURRENCY	CURRENCYID
DESIGNATION	BASECURRENCYID
DESIGNATIONGOAL	BASECURRENCYID
DESIGNATIONLEVEL	BASECURRENCYID
DESIGNATIONLEVELDECAPITALIZATION	BASECURRENCYID
DESIGNATIONLEVELDISBURSEMENT	BASECURRENCYID
DESIGNATIONLEVELFINANCIALINFO	BASECURRENCYID
DESIGNATIONLEVELGIFTFEESTRUCTURE	BASECURRENCYID
DESIGNATIONLEVELGOAL	BASECURRENCYID
DESIGNATIONLEVELRECIPIENT	BASECURRENCYID
DONORCHALLENGE	BASECURRENCYID
DONORCHALLENGEENCUMBERED	BASECURRENCYID
DONORCHALLENGESPLIT	BASECURRENCYID
EVENT	BASECURRENCYID
EVENTEXPENSE	BASECURRENCYID
EVENTPRICEBENEFIT	BASECURRENCYID
EVENTREGISTRANTPAYMENT	APPLICATIONCURRENCYID
FINANCIALTRANSACTION	TRANSACTIONCURRENCYID
FUNDINGPLAN	BASECURRENCYID
FUNDINGREQUEST	BASECURRENCYID
FUNDINGREQUEST	TRANSACTIONCURRENCYID
GIFTFEEADJUSTMENT	TRANSACTIONCURRENCYID
GIFTFEEADJUSTMENT	BASECURRENCYID
GIFTFEESTRUCTURE	BASECURRENCYID
GIFTINKINDAPPRAISAL	BASECURRENCYID
GIFTINKINDAPPRAISAL	TRANSACTIONCURRENCYID
GIFTINKINDPAYMENTMETHODDETAIL	BASECURRENCYID
GIFTINKINDPAYMENTMETHODDETAIL	TRANSACTIONCURRENCYID
GIFTINKINDSALEADJUSTMENT	BASECURRENCYID
GIFTINKINDSALEADJUSTMENT	TRANSACTIONCURRENCYID
GRANTS	BASECURRENCYID
GRANTS	TRANSACTIONCURRENCYID
GROUPGOAL	BASECURRENCYID
INSTALLMENT	BASECURRENCYID
INSTALLMENT	TRANSACTIONCURRENCYID
INSTALLMENTSPLIT	BASECURRENCYID
INSTALLMENTSPLIT	TRANSACTIONCURRENCYID
INSTALLMENTSPLITPAYMENT	APPLICATIONCURRENCYID
INSTALLMENTSPLITWRITEOFF	BASECURRENCYID
INSTALLMENTSPLITWRITEOFF	TRANSACTIONCURRENCYID
JOB	BASECURRENCYID
JOBOCCURRENCE	BASECURRENCYID
JOURNALENTRY	TRANSACTIONCURRENCYID
MATCHINGGIFTCONDITION	BASECURRENCYID
MEMBERSHIPADDON	TRANSACTIONCURRENCYID
MEMBERSHIPADDON	BASECURRENCYID
MEMBERSHIPINSTALLMENTPLANORIGINALAMOUNT	BASECURRENCYID
MEMBERSHIPINSTALLMENTPLANORIGINALAMOUNT	TRANSACTIONCURRENCYID
MEMBERSHIPLEVEL	BASECURRENCYID
MEMBERSHIPLEVELBENEFIT	BASECURRENCYID
MEMBERSHIPLEVELTERM	BASECURRENCYID
MEMBERSHIPPROGRAM	BASECURRENCYID
MEMBERSHIPPROGRAMADDON	BASECURRENCYID
MEMBERSHIPPROGRAMADDON	TRANSACTIONCURRENCYID
MEMBERSHIPPROMO	BASECURRENCYID
MKTACKNOWLEDGEMENTMAILINGTEMPLATE	BASECURRENCYID
MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE	BASECURRENCYID
MKTASKLADDER	BASECURRENCYID
MKTASKLADDERITEM	BASECURRENCYID
MKTCOMMUNICATIONTEMPLATE	BASECURRENCYID
MKTCREATIVE	BASECURRENCYID
MKTDOCUMENT	BASECURRENCYID
MKTEXPENSE	BASECURRENCYID
MKTLIST	BASECURRENCYID
MKTMARKETINGPLAN	BASECURRENCYID
MKTMARKETINGPLANBRIEF	BASECURRENCYID
MKTMARKETINGPLANITEM	BASECURRENCYID
MKTMARKETINGPLANITEMEXPENSE	BASECURRENCYID
MKTMATERIAL	BASECURRENCYID
MKTMEMBERSHIPMAILINGACTIVE	BASECURRENCYID
MKTMEMBERSHIPMAILINGSEGMENTACTIVE	BASECURRENCYID
MKTMEMBERSHIPMAILINGTEMPLATE	BASECURRENCYID
MKTMEMBERSHIPMAILINGTEMPLATERULE	BASECURRENCYID
MKTPACKAGE	BASECURRENCYID
MKTSEGMENT	BASECURRENCYID
MKTSEGMENTATION	BASECURRENCYID
MKTSEGMENTATIONACTIVE	BASECURRENCYID
MKTSEGMENTATIONBUDGET	BASECURRENCYID
MKTSEGMENTATIONLISTACTIVE	BASECURRENCYID
MKTSEGMENTATIONPACKAGE	BASECURRENCYID
MKTSEGMENTATIONSEGMENT	BASECURRENCYID
MKTSEGMENTATIONSEGMENTACTIVE	BASECURRENCYID
MKTSEGMENTATIONSEGMENTLIST	BASECURRENCYID
MKTSEGMENTATIONTESTSEGMENT	BASECURRENCYID
MKTSEGMENTGROUP	BASECURRENCYID
MKTSEGMENTLIST	BASECURRENCYID
MKTSEGMENTLISTHISTORICAL	BASECURRENCYID
MKTSEGMENTWHITEMAILCACHE	BASECURRENCYID
MKTSPONSORSHIPMAILINGTEMPLATE	BASECURRENCYID
MKTSPONSORSHIPMAILINGTEMPLATERULE	BASECURRENCYID
NAMINGOPPORTUNITY	BASECURRENCYID
NAMINGOPPORTUNITYRECOGNITION	BASECURRENCYID
NETCOMMUNITYMAPPINGRULE	ATTRIBUTECURRENCYID
OPPORTUNITY	BASECURRENCYID
OPPORTUNITY	TRANSACTIONCURRENCYID
OPPORTUNITYAMOUNTBRACKET	BASECURRENCYID
OPPORTUNITYAMOUNTBRACKETGROUP	BASECURRENCYID
OPPORTUNITYDESIGNATION	BASECURRENCYID
OPPORTUNITYDESIGNATION	TRANSACTIONCURRENCYID
PAYMENTORIGINALAMOUNT	BASECURRENCYID
PAYMENTORIGINALAMOUNT	TRANSACTIONCURRENCYID
PLANNEDGIFT	BASECURRENCYID
PLANNEDGIFT	TRANSACTIONCURRENCYID
PLANNEDGIFTADDITION	BASECURRENCYID
PLANNEDGIFTADDITION	TRANSACTIONCURRENCYID
PLANNEDGIFTADDITIONASSET	BASECURRENCYID
PLANNEDGIFTADDITIONASSET	TRANSACTIONCURRENCYID
PLANNEDGIFTADDITIONDESIGNATION	BASECURRENCYID
PLANNEDGIFTADDITIONDESIGNATION	TRANSACTIONCURRENCYID
PLANNEDGIFTASSET	BASECURRENCYID
PLANNEDGIFTASSET	TRANSACTIONCURRENCYID
PLANNEDGIFTDESIGNATION	BASECURRENCYID
PLANNEDGIFTDESIGNATION	TRANSACTIONCURRENCYID
PLANNEDGIFTPAYOUTADJUSTMENT	TRANSACTIONCURRENCYID
PLANNEDGIFTPAYOUTADJUSTMENT	BASECURRENCYID
PLANNEDGIFTRECONCILE	BASECURRENCYID
PLANNEDGIFTRECONCILE	TRANSACTIONCURRENCYID
PLEDGEORIGINALAMOUNT	BASECURRENCYID
PLEDGEORIGINALAMOUNT	TRANSACTIONCURRENCYID
PLEDGEREMINDERSENT	BASECURRENCYID
PROCESSORTRANSACTIONSETTLEMENTIMPORTROW	CURRENCYID
PROPERTYDETAILADJUSTMENT	BASECURRENCYID
PROPERTYDETAILADJUSTMENT	TRANSACTIONCURRENCYID
PROSPECTPLAN	BASECURRENCYID
RECOGNITIONCREDIT	BASECURRENCYID
RECOGNITIONLEVEL	BASECURRENCYID
RECOGNITIONLEVELAMOUNT	BASECURRENCYID
RECOGNITIONLEVELBENEFIT	BASECURRENCYID
RECOGNITIONPROGRAM	BASECURRENCYID
RECURRINGGIFTACTIVITY	APPLICATIONCURRENCYID
RECURRINGGIFTAMENDMENT	TRANSACTIONCURRENCYID
RECURRINGGIFTAMENDMENT	BASECURRENCYID
RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY	BASECURRENCYID
RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY	TRANSACTIONCURRENCYID
RECURRINGGIFTINSTALLMENT	BASECURRENCYID
RECURRINGGIFTINSTALLMENT	TRANSACTIONCURRENCYID
RECURRINGGIFTINSTALLMENTEVENT	CURRENCYID
RECURRINGGIFTINSTALLMENTPAYMENT	APPLICATIONCURRENCYID
RECURRINGGIFTINSTALLMENTWRITEOFF	BASECURRENCYID
RECURRINGGIFTINSTALLMENTWRITEOFF	TRANSACTIONCURRENCYID
REGISTRANTBENEFIT	BASECURRENCYID
REVENUE_EXT	NONPOSTABLEBASECURRENCYID
REVENUERECOGNITION	BASECURRENCYID
REVENUESOLICITOR	BASECURRENCYID
REVENUESPLITBUSINESSUNIT	BASECURRENCYID
REVENUESPLITGIFTAID	TRANSACTIONCURRENCYID
REVENUESPLITGIFTAID	BASECURRENCYID
REVENUESPLITGIFTAIDAMOUNTS	TRANSACTIONCURRENCYID
REVENUESPLITGIFTAIDAMOUNTS	BASECURRENCYID
REVENUESPLITGIFTAIDAMOUNTS	REVENUETRANSACTIONCURRENCYID
REVENUESPLITGIFTAIDAMOUNTS	REVENUEBASECURRENCYID
REVENUESPLITGIFTAIDREFUND	ORIGINALTRANSACTIONCURRENCYID
REVENUESPLITGIFTAIDREFUND	ORIGINALBASECURRENCYID
REVENUESPLITGIFTFEE	BASECURRENCYID
REVENUESPLITGIFTFEE	TRANSACTIONCURRENCYID
REVENUETRIBUTE	BASECURRENCYID
REVENUETRIBUTETAXCLAIMAMOUNT	BASECURRENCYID
REVENUEVAT	BASECURRENCYID
REVENUEVAT	TRANSACTIONCURRENCYID
SALESDEPOSITTEMPLATECURRENCY	CURRENCYID
SALESORDERITEMMEMBERSHIPITEMPROMOTION	BASECURRENCYID
SMARTFIELD	CURRENCYID
SPONSORBENEFITEXTENSION	BASECURRENCYID
SPONSORSHIPOPPORTUNITYPROJECT	BASECURRENCYID
SPONSORSHIPPROGRAM	BASECURRENCYID
STEWARDSHIPPLAN	BASECURRENCYID
STOCKDETAIL	BASECURRENCYID
STOCKDETAIL	TRANSACTIONCURRENCYID
STOCKSALEADJUSTMENT	BASECURRENCYID
STOCKSALEADJUSTMENT	TRANSACTIONCURRENCYID
TEAMFUNDRAISER	BASECURRENCYID
TEAMFUNDRAISINGTEAM	BASECURRENCYID
UNREALIZEDGAINLOSSADJUSTMENT	TRANSACTIONCURRENCYID
UNREALIZEDGAINLOSSADJUSTMENT	BASECURRENCYID
UNSETTLEDCREDITCARDTRANSACTION	CURRENCYID
WRITEOFFADJUSTMENT	BASECURRENCYID
WRITEOFFADJUSTMENT	TRANSACTIONCURRENCYID