Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 AMOUNT money   Default = 0
 DATE date  
 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) CONVERT(bigint, TS) Numeric representation of the timestamp.
 ORGANIZATIONAMOUNT money   Default = 0 The amount of the installment in organization currency.
 TRANSACTIONAMOUNT money   Default = 0 The amount of the installment in transaction currency.

Foreign Key Field Type Null Notes Description
 REVENUEID uniqueidentifier   FINANCIALTRANSACTION.ID FK to REVENUE
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 BASECURRENCYID uniqueidentifier CURRENCY.ID The base currency associated with this installment.
 ORGANIZATIONEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to convert from amount to organization amount.
 TRANSACTIONCURRENCYID uniqueidentifier CURRENCY.ID The transaction currency associated with this installment.
 BASEEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to convert from transaction amount to amount.

Index Name Field(s) Unique Primary Clustered
 IX_RECURRINGGIFTINSTALLMENT_BASECURRENCYID BASECURRENCYID      
 IX_RECURRINGGIFTINSTALLMENT_BASEEXCHANGERATEID BASEEXCHANGERATEID      
 IX_RECURRINGGIFTINSTALLMENT_DATEADDED DATEADDED    
 IX_RECURRINGGIFTINSTALLMENT_DATECHANGED DATECHANGED      
 IX_RECURRINGGIFTINSTALLMENT_ORGANIZATIONEXCHANGERATEID ORGANIZATIONEXCHANGERATEID      
 IX_RECURRINGGIFTINSTALLMENT_REVENUEID_DATE REVENUEID, DATE      
 IX_RECURRINGGIFTINSTALLMENT_TRANSACTIONCURRENCYID TRANSACTIONCURRENCYID      
 PK_RECURRINGGIFTINSTALLMENT ID  

Trigger Name Description
 TR_RECURRINGGIFTINSTALLMENT_AUDIT_UPDATE
 TR_RECURRINGGIFTINSTALLMENT_AUDIT_DELETE
 TR_RECURRINGGIFTINSTALLMENT_AUDIT_ETLDELETEDID
 TR_RECURRINGGIFTINSTALLMENT_INSERTUPDATE_CURRENCY

Referenced by Field
 RECURRINGGIFTINSTALLMENTPAYMENT RECURRINGGIFTINSTALLMENTID
 RECURRINGGIFTINSTALLMENTWRITEOFF RECURRINGGIFTINSTALLMENTID

Entity-Relationship diagram of this table