Sage EasyPay Data Model

Entity RebateClaim

Description of Entity RebateClaim

This entity is for the Malaysia Income Tax.

List of all Dependencies of the Entity RebateClaim

Relationship_726

Reference

Relationship_729

Reference

List of Attributes of the Entity RebateClaim

Entity Attribute PersonalSysId of the Entity RebateClaim

Card of Attribute PersonalSysId of the Entity RebateClaim

Name	PersonalSysId
Code	PersonalSysId
Data Type	integer
Mandatory	Yes

Description of Attribute PersonalSysId of the Entity RebateClaim

This attribute is the system generated identifier. It is blind to the user. It also holds the primary key for the Personal table.

Entity Attribute RebateSysId of the Entity RebateClaim

Card of Attribute RebateSysId of the Entity RebateClaim

Name	RebateSysId
Code	RebateSysId
Data Type	integer
Mandatory	Yes

Description of Attribute RebateSysId of the Entity RebateClaim

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

Entity Attribute Rebate Date of the Entity RebateClaim

Card of Attribute Rebate Date of the Entity RebateClaim

Name	Rebate Date
Code	RebateDate
Data Type	date
Mandatory	No

Description of Attribute Rebate Date of the Entity RebateClaim

Shows the rebate date.
It is in the format: DD-MM-YYYY.

Entity Attribute Status of the Entity RebateClaim

Card of Attribute Status of the Entity RebateClaim

Name	Status
Code	ePortalStatus
Data Type	char(20)
Mandatory	No

Description of Attribute Status of the Entity RebateClaim

Displays the ePortal status.

Entity Attribute Created By of the Entity RebateClaim

Card of Attribute Created By of the Entity RebateClaim

Name	Created By
Code	CreatedBy
Data Type	char(20)
Mandatory	No

Description of Attribute Created By of the Entity RebateClaim

Shows who was the creator.
Example: "S" which stands for System, i.e. it was system generated.

Entity Attribute Processed On of the Entity RebateClaim

Card of Attribute Processed On of the Entity RebateClaim

Name	Processed On
Code	PayrollProcessDate
Data Type	date
Mandatory	No

Description of Attribute Processed On of the Entity RebateClaim

Shows when the payment was processed.
It is usually in the format: DD-MM-YYYY.

Entity Attribute Year of the Entity RebateClaim

Card of Attribute Year of the Entity RebateClaim

Name	Year
Code	PayrollYear
Data Type	integer
Mandatory	No

Description of Attribute Year of the Entity RebateClaim

Shows the year for the payroll.
Example: 2013

Entity Attribute Period of the Entity RebateClaim

Card of Attribute Period of the Entity RebateClaim

Name	Period
Code	PayrollPeriod
Data Type	integer
Mandatory	No

Description of Attribute Period of the Entity RebateClaim

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

Home