Sage EasyPay Data Model

Entity PHICRF1ME5Summary

List of all Dependencies of the Entity PHICRF1ME5Summary

Relation_1683319

Relation_1683319

Reference

List of Attributes of the Entity PHICRF1ME5Summary

ME5SumMonthKeyWord

ME5SumMonthKeyWord

ME5SumME5ReconNo

ME5SumME5ReconNo

Entity Attribute ME5SumSysId of the Entity PHICRF1ME5Summary

Card of Attribute ME5SumSysId of the Entity PHICRF1ME5Summary

Name	ME5SumSysId
Code	ME5SumSysId
Data Type	integer
Mandatory	Yes

Description of Attribute ME5SumSysId of the Entity PHICRF1ME5Summary

A system generated identity. It is blind to the user. This is the primary key for the PHICRF1ME5Summary table.

Entity Attribute ME5SumYear of the Entity PHICRF1ME5Summary

Card of Attribute ME5SumYear of the Entity PHICRF1ME5Summary

Name	ME5SumYear
Code	ME5SumYear
Data Type	integer
Mandatory	Yes

Description of Attribute ME5SumYear of the Entity PHICRF1ME5Summary

Shows the year for the ME5 summary.
Example: 2013

Entity Attribute ME5SumMonthKeyWord of the Entity PHICRF1ME5Summary

Card of Attribute ME5SumMonthKeyWord of the Entity PHICRF1ME5Summary

Name	ME5SumMonthKeyWord
Code	ME5SumMonthKeyWord
Data Type	char(20)
Mandatory	Yes

Description of Attribute ME5SumMonthKeyWord of the Entity PHICRF1ME5Summary

Shows the month for the ME5 summary.
Example: January = "1" / February = "2" / March = "3" etc

Entity Attribute ME5SumDatePaid of the Entity PHICRF1ME5Summary

Card of Attribute ME5SumDatePaid of the Entity PHICRF1ME5Summary

Name	ME5SumDatePaid
Code	ME5SumDatePaid
Data Type	date
Mandatory	No

Description of Attribute ME5SumDatePaid of the Entity PHICRF1ME5Summary

Shows the paid date for the ME5 summary.
It is in the format: DD-MM-YYYY.

Entity Attribute ME5SumME5ReconNo of the Entity PHICRF1ME5Summary

Card of Attribute ME5SumME5ReconNo of the Entity PHICRF1ME5Summary

Name	ME5SumME5ReconNo
Code	ME5SumME5ReconNo
Data Type	char(20)
Mandatory	No