PAYMENTORIGINALAMOUNT

Holds the original amount for a payment.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

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

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_PAYMENTORIGINALAMOUNT_BASECURRENCYID	BASECURRENCYID
IX_PAYMENTORIGINALAMOUNT_BASEEXCHANGERATEID	BASEEXCHANGERATEID
IX_PAYMENTORIGINALAMOUNT_DATEADDED	DATEADDED			yes
IX_PAYMENTORIGINALAMOUNT_DATECHANGED	DATECHANGED
IX_PAYMENTORIGINALAMOUNT_ORGANIZATIONEXCHANGERATEID	ORGANIZATIONEXCHANGERATEID
IX_PAYMENTORIGINALAMOUNT_TRANSACTIONCURRENCYID	TRANSACTIONCURRENCYID
PK_PAYMENTORIGINALAMOUNT	ID	yes	yes

Triggers

Trigger Name	Description
TR_PAYMENTORIGINALAMOUNT_INSERTUPDATE_CURRENCY
TR_PAYMENTORIGINALAMOUNT_AUDIT_UPDATE
TR_PAYMENTORIGINALAMOUNT_AUDIT_DELETE