PLEDGEORIGINALAMOUNT

Holds the original amount for a pledge.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
ORIGINALAMOUNT	money		Default = 0	The original amount of a pledge.
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.
TRANSACTIONAMOUNT	money		Default = 0	The original amount of a pledge in the transaction currency.
ORGANIZATIONAMOUNT	money		Default = 0	The original amount of a pledge in the organization currency.

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
ID	uniqueidentifier		FINANCIALTRANSACTION.ID	Primary Key.
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
BASECURRENCYID	uniqueidentifier	yes	CURRENCY.ID	The base currency associated with this record.
ORGANIZATIONEXCHANGERATEID	uniqueidentifier	yes	CURRENCYEXCHANGERATE.ID	The exchange rate used to convert to the organization amount.
TRANSACTIONCURRENCYID	uniqueidentifier	yes	CURRENCY.ID	The transaction currency associated with this record.
BASEEXCHANGERATEID	uniqueidentifier	yes	CURRENCYEXCHANGERATE.ID	The exchange rate used to calculate the base amount.

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_PLEDGEORIGINALAMOUNT_BASECURRENCYID	BASECURRENCYID
IX_PLEDGEORIGINALAMOUNT_BASEEXCHANGERATEID	BASEEXCHANGERATEID
IX_PLEDGEORIGINALAMOUNT_DATEADDED	DATEADDED			yes
IX_PLEDGEORIGINALAMOUNT_DATECHANGED	DATECHANGED
IX_PLEDGEORIGINALAMOUNT_ORGANIZATIONEXCHANGERATEID	ORGANIZATIONEXCHANGERATEID
IX_PLEDGEORIGINALAMOUNT_TRANSACTIONCURRENCYID	TRANSACTIONCURRENCYID
PK_PLEDGEORIGINALAMOUNT	ID	yes	yes

Triggers

Trigger Name	Description
TR_PLEDGEORIGINALAMOUNT_AUDIT_UPDATE
TR_PLEDGEORIGINALAMOUNT_AUDIT_DELETE
TR_PLEDGEORIGINALAMOUNT_INSERTUPDATE_CURRENCY