Sage EasyPay Data Model

Entity DeMinimisGranted

Description of Entity DeMinimisGranted

This entity is for the Philippines Income Tax.

List of all Dependencies of the Entity DeMinimisGranted

Relationship_745

Relationship_745

Reference

List of Attributes of the Entity DeMinimisGranted

DMBPayrollPeriod

DMBPayrollPeriod

DMBExceedingAmt

DMBExceedingAmt

Entity Attribute PersonalSysId of the Entity DeMinimisGranted

Card of Attribute PersonalSysId of the Entity DeMinimisGranted

Name	PersonalSysId
Code	PersonalSysId
Data Type	integer
Mandatory	Yes

Description of Attribute PersonalSysId of the Entity DeMinimisGranted

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 DMBGrantSysId of the Entity DeMinimisGranted

Card of Attribute DMBGrantSysId of the Entity DeMinimisGranted

Name	DMBGrantSysId
Code	DMBGrantSysId
Data Type	integer
Mandatory	Yes

Entity Attribute DMB Property of the Entity DeMinimisGranted

Card of Attribute DMB Property of the Entity DeMinimisGranted

Name	DMB Property
Code	DMBProperty
Data Type	char(20)
Mandatory	Yes

Description of Attribute DMB Property of the Entity DeMinimisGranted

Shows the property of the DMB property.

Entity Attribute DMBPayrollYear of the Entity DeMinimisGranted

Card of Attribute DMBPayrollYear of the Entity DeMinimisGranted

Name	DMBPayrollYear
Code	DMBPayrollYear
Data Type	integer
Mandatory	No

Entity Attribute DMBPayrollPeriod of the Entity DeMinimisGranted

Card of Attribute DMBPayrollPeriod of the Entity DeMinimisGranted

Name	DMBPayrollPeriod
Code	DMBPayrollPeriod
Data Type	integer
Mandatory	No

Entity Attribute DMBGrantedAmt of the Entity DeMinimisGranted

Card of Attribute DMBGrantedAmt of the Entity DeMinimisGranted

Name	DMBGrantedAmt
Code	DMBGrantedAmt
Data Type	double
Mandatory	No

Entity Attribute DMBExceedingAmt of the Entity DeMinimisGranted

Card of Attribute DMBExceedingAmt of the Entity DeMinimisGranted

Name	DMBExceedingAmt
Code	DMBExceedingAmt
Data Type	double
Mandatory	No

Entity Attribute Created By of the Entity DeMinimisGranted

Card of Attribute Created By of the Entity DeMinimisGranted

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

Description of Attribute Created By of the Entity DeMinimisGranted

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