INSTALLMENTSPLITPAYMENT (4.0)

Contains installment split payment information for a given pledge payment record.

Primary Key
Primary Key Field Type

ID

uniqueidentifier
Foreign Key Fields
Foreign Key Field Type Null Notes Description

PAYMENTID

uniqueidentifier

false

FK to REVENUESPLIT

PLEDGEID

uniqueidentifier

false

FK to REVENUE

INSTALLMENTSPLITID

uniqueidentifier

false

FK to INSTALLMENTPAYMENT table.

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

APPLICATIONCURRENCYID

uniqueidentifier

true

The currency associated with this record's amount, which matches the transaction currency of the installment.

APPLICATIONEXCHANGERATEID

uniqueidentifier

true

The exchange rate used to convert the transaction amount of the payment to the transaction amount of the installment.
Fields
Field Field Type Null Notes Description

AMOUNT

money

false

0

The amount of this application, expressed in the transaction currency of the installment.

DATEADDED

datetime

false

getdate()

Indicates the date this record was added.

DATECHANGED

datetime

false

getdate()

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.

OVERPAYMENTAPPLICATIONTYPECODE

tinyint

false

1

Indicates the overpayment selection made for this payment.

OVERPAYMENTAPPLICATIONTYPE

nvarchar(16) (Computed)

true

Provides a translation for the 'OVERPAYMENTAPPLICATIONTYPECODE' field.
Indexes
Index Name Field(s) Unique Primary Clustered

IX_INSTALLMENTSPLITPAYMENT_APPLICATIONCURRENCYID

APPLICATIONCURRENCYID

False

False

False

IX_INSTALLMENTSPLITPAYMENT_APPLICATIONEXCHANGERATEID

APPLICATIONEXCHANGERATEID

False

False

False

IX_INSTALLMENTSPLITPAYMENT_DATEADDED

DATEADDED

False

False

True

IX_INSTALLMENTSPLITPAYMENT_DATECHANGED

DATECHANGED

False

False

False

IX_INSTALLMENTSPLITPAYMENT_INSTALLMENTSPLITID

INSTALLMENTSPLITID

False

False

False

IX_INSTALLMENTSPLITPAYMENT_PAYMENTID

PAYMENTID

False

False

False

IX_INSTALLMENTSPLITPAYMENT_PLEDGEID

PLEDGEID

False

False

False

PK_INSTALLMENTSPLITPAYMENT

ID

True

True

False
Triggers
Trigger Name Description

TR_INSTALLMENTSPLITPAYMENT_AUDIT_ETLDELETEDID

TR_INSTALLMENTSPLITPAYMENT_INSERTUPDATE_CURRENCY

TR_INSTALLMENTSPLITPAYMENT_AUDIT_UPDATE

TR_INSTALLMENTSPLITPAYMENT_AUDIT_DELETE