Sage EasyPay Data Model

Entity LoanFrom

Description of Entity LoanFrom

Keeps track of loans issued through the company. These loans may be from the company or from a government body.

List of all Dependencies of the Entity LoanFrom

Relation_1228382

Reference

List of Attributes of the Entity LoanFrom

LoanOtherBoolean1Desc

LoanOtherBoolean2Desc

LoanOtherBoolean3Desc

LoanOtherDate1Desc

LoanOtherDate2Desc

LoanOtherDate3Desc

LoanOtherInteger1Desc

LoanOtherInteger2Desc

LoanOtherInteger3Desc

LoanOtherNumeric1Desc

LoanOtherNumeric2Desc

LoanOtherNumeric3Desc

Entity Attribute Loan From of the Entity LoanFrom

Card of Attribute Loan From of the Entity LoanFrom

Name	Loan From
Code	LoanFromId
Data Type	char(20)
Mandatory	Yes

Description of Attribute Loan From of the Entity LoanFrom

Shows the identity of who/where the loan is from. This also acts as a primary key for the LoanFrom table.

Entity Attribute Description of the Entity LoanFrom

Card of Attribute Description of the Entity LoanFrom

Name	Description
Code	LoanFromDesc
Data Type	char(100)
Mandatory	No

Description of Attribute Description of the Entity LoanFrom

Shows the description of who/where the loan was taken from.

Entity Attribute LoanFromGovt of the Entity LoanFrom

Card of Attribute LoanFromGovt of the Entity LoanFrom

Name	LoanFromGovt
Code	LoanFromGovt
Data Type	smallint
Mandatory	No

Description of Attribute LoanFromGovt of the Entity LoanFrom

Shows if the employee has made a loan from the government.

Entity Attribute LoanOtherBoolean1Desc of the Entity LoanFrom

Card of Attribute LoanOtherBoolean1Desc of the Entity LoanFrom

Name	LoanOtherBoolean1Desc
Code	LoanOtherBoolean1Desc
Data Type	char(100)
Mandatory	No

Description of Attribute LoanOtherBoolean1Desc of the Entity LoanFrom

Shows the loan that is available in a form of a checkbox and its description.

Entity Attribute LoanOtherBoolean2Desc of the Entity LoanFrom

Card of Attribute LoanOtherBoolean2Desc of the Entity LoanFrom

Name	LoanOtherBoolean2Desc
Code	LoanOtherBoolean2Desc
Data Type	char(100)
Mandatory	No

Description of Attribute LoanOtherBoolean2Desc of the Entity LoanFrom

Shows the loan that is available in a form of a checkbox and its description.

Entity Attribute LoanOtherBoolean3Desc of the Entity LoanFrom

Card of Attribute LoanOtherBoolean3Desc of the Entity LoanFrom

Name	LoanOtherBoolean3Desc
Code	LoanOtherBoolean3Desc
Data Type	char(100)
Mandatory	No

Description of Attribute LoanOtherBoolean3Desc of the Entity LoanFrom

Shows the loan that is available in a form of a checkbox and its description.

Entity Attribute LoanOtherDate1Desc of the Entity LoanFrom

Card of Attribute LoanOtherDate1Desc of the Entity LoanFrom

Name	LoanOtherDate1Desc
Code	LoanOtherDate1Desc
Data Type	char(100)
Mandatory	No

Description of Attribute LoanOtherDate1Desc of the Entity LoanFrom

Shows the date of the loan and its description.

Entity Attribute LoanOtherDate2Desc of the Entity LoanFrom

Card of Attribute LoanOtherDate2Desc of the Entity LoanFrom

Name	LoanOtherDate2Desc
Code	LoanOtherDate2Desc
Data Type	char(100)
Mandatory	No

Description of Attribute LoanOtherDate2Desc of the Entity LoanFrom

Shows the date of the loan and its description.

Entity Attribute LoanOtherDate3Desc of the Entity LoanFrom

Card of Attribute LoanOtherDate3Desc of the Entity LoanFrom

Name	LoanOtherDate3Desc
Code	LoanOtherDate3Desc
Data Type	char(100)
Mandatory	No

Description of Attribute LoanOtherDate3Desc of the Entity LoanFrom

Shows the date of the loan and its description.

Entity Attribute LoanOtherInteger1Desc of the Entity LoanFrom

Card of Attribute LoanOtherInteger1Desc of the Entity LoanFrom

Name	LoanOtherInteger1Desc
Code	LoanOtherInteger1Desc
Data Type	char(100)
Mandatory	No

Description of Attribute LoanOtherInteger1Desc of the Entity LoanFrom

Shows the loan amount and its description. Only whole numbers are to be entered.

Entity Attribute LoanOtherInteger2Desc of the Entity LoanFrom

Card of Attribute LoanOtherInteger2Desc of the Entity LoanFrom

Name	LoanOtherInteger2Desc
Code	LoanOtherInteger2Desc
Data Type	char(100)
Mandatory	No

Description of Attribute LoanOtherInteger2Desc of the Entity LoanFrom

Shows the loan amount and its description. Only whole numbers are to be entered.

Entity Attribute LoanOtherInteger3Desc of the Entity LoanFrom

Card of Attribute LoanOtherInteger3Desc of the Entity LoanFrom

Name	LoanOtherInteger3Desc
Code	LoanOtherInteger3Desc
Data Type	char(100)
Mandatory	No

Description of Attribute LoanOtherInteger3Desc of the Entity LoanFrom

Shows the loan amount and its description. Only whole numbers are to be entered.

Entity Attribute LoanOtherNumeric1Desc of the Entity LoanFrom

Card of Attribute LoanOtherNumeric1Desc of the Entity LoanFrom

Name	LoanOtherNumeric1Desc
Code	LoanOtherNumeric1Desc
Data Type	char(100)
Mandatory	No

Description of Attribute LoanOtherNumeric1Desc of the Entity LoanFrom

Shows the exact loan amount and its description.

Entity Attribute LoanOtherNumeric2Desc of the Entity LoanFrom

Card of Attribute LoanOtherNumeric2Desc of the Entity LoanFrom

Name	LoanOtherNumeric2Desc
Code	LoanOtherNumeric2Desc
Data Type	char(100)
Mandatory	No

Description of Attribute LoanOtherNumeric2Desc of the Entity LoanFrom

Shows the exact loan amount and its description.

Entity Attribute LoanOtherNumeric3Desc of the Entity LoanFrom

Card of Attribute LoanOtherNumeric3Desc of the Entity LoanFrom

Name	LoanOtherNumeric3Desc
Code	LoanOtherNumeric3Desc
Data Type	char(100)
Mandatory	No

Description of Attribute LoanOtherNumeric3Desc of the Entity LoanFrom

Shows the exact loan amount and its description.

Entity Attribute LoanOtherString1Desc of the Entity LoanFrom

Card of Attribute LoanOtherString1Desc of the Entity LoanFrom

Name	LoanOtherString1Desc
Code	LoanOtherString1Desc
Data Type	char(100)
Mandatory	No

Description of Attribute LoanOtherString1Desc of the Entity LoanFrom

Shows the loan amount and its description. String is a data type which includes letters, digits and special characters. It is a sequence of characters.

Entity Attribute LoanOtherString2Desc of the Entity LoanFrom

Card of Attribute LoanOtherString2Desc of the Entity LoanFrom

Name	LoanOtherString2Desc
Code	LoanOtherString2Desc
Data Type	char(100)
Mandatory	No

Description of Attribute LoanOtherString2Desc of the Entity LoanFrom

Shows the loan amount and its description. String is a data type which includes letters, digits and special characters. It is a sequence of characters.

Entity Attribute LoanOtherString3Desc of the Entity LoanFrom

Card of Attribute LoanOtherString3Desc of the Entity LoanFrom

Name	LoanOtherString3Desc
Code	LoanOtherString3Desc
Data Type	char(100)
Mandatory	No

Description of Attribute LoanOtherString3Desc of the Entity LoanFrom

Shows the loan amount and its description. String is a data type which includes letters, digits and special characters. It is a sequence of characters.

Entity Attribute LoanOtherString4Desc of the Entity LoanFrom

Card of Attribute LoanOtherString4Desc of the Entity LoanFrom

Name	LoanOtherString4Desc
Code	LoanOtherString4Desc
Data Type	char(100)
Mandatory	No

Name	LoanOtherString5Desc
Code	LoanOtherString5Desc
Data Type	char(100)
Mandatory	No

Description of Attribute LoanOtherString5Desc of the Entity LoanFrom

Shows the loan amount and its description. String is a data type which includes letters, digits and special characters. It is a sequence of characters.

Home