Sage EasyPay Data Model

Entity LoanPenalty

Description of Entity LoanPenalty

Details about the loan penalty.

List of all Dependencies of the Entity LoanPenalty

Relation_1815495

Relation_1815495

Reference

List of Attributes of the Entity LoanPenalty

LoanPenaltySysId

LoanPenaltySysId

Entity Attribute LoanPenaltySysId of the Entity LoanPenalty

Card of Attribute LoanPenaltySysId of the Entity LoanPenalty

Name	LoanPenaltySysId
Code	LoanPenaltySysId
Data Type	integer
Mandatory	Yes

Description of Attribute LoanPenaltySysId of the Entity LoanPenalty

A system generated identity for the loan penalty. It is blind to the user. It also acts as a primary key for the LoanPenalty table.

Entity Attribute Year of the Entity LoanPenalty

Card of Attribute Year of the Entity LoanPenalty

Name	Year
Code	Year
Data Type	integer
Mandatory	No

Description of Attribute Year of the Entity LoanPenalty

Shows the year.
Example: 2013

Entity Attribute Period of the Entity LoanPenalty

Card of Attribute Period of the Entity LoanPenalty

Name	Period
Code	Period
Data Type	integer
Mandatory	No

Description of Attribute Period of the Entity LoanPenalty

Shows the period of the loan penalty.
Example: January ="1" / February = "2" / March = "3" etc

Entity Attribute Penalty of the Entity LoanPenalty

Card of Attribute Penalty of the Entity LoanPenalty

Name	Penalty
Code	Penalty
Data Type	double
Mandatory	No

Description of Attribute Penalty of the Entity LoanPenalty

States the penalty amount.