Sage EasyPay Data Model

Entity PhTaxATC

Description of Entity PhTaxATC

This entity is for the Philippines Payroll.

List of all Dependencies of the Entity PhTaxATC

Relation_1089070

Relation_1089070

Reference

Relation_1089071

Relation_1089071

Reference

List of Attributes of the Entity PhTaxATC

PhTaxATCEESysId

PhTaxATCEESysId

PhTaxATCSGSPGenId

PhTaxATCSGSPGenId

PhATCHistFactor

PhATCHistFactor

Entity Attribute PersonalSysId of the Entity PhTaxATC

Card of Attribute PersonalSysId of the Entity PhTaxATC

Name	PersonalSysId
Code	PersonalSysId
Data Type	integer
Mandatory	Yes

Description of Attribute PersonalSysId of the Entity PhTaxATC

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 PhTaxATCSysId of the Entity PhTaxATC

Card of Attribute PhTaxATCSysId of the Entity PhTaxATC

Name	PhTaxATCSysId
Code	PhTaxATCSysId
Data Type	integer
Mandatory	Yes

Entity Attribute PhTaxATCEESysId of the Entity PhTaxATC

Card of Attribute PhTaxATCEESysId of the Entity PhTaxATC

Name	PhTaxATCEESysId
Code	PhTaxATCEESysId
Data Type	integer
Mandatory	Yes

Entity Attribute PhTaxATCSGSPGenId of the Entity PhTaxATC

Card of Attribute PhTaxATCSGSPGenId of the Entity PhTaxATC

Name	PhTaxATCSGSPGenId
Code	PhTaxATCSGSPGenId
Data Type	char(30)
Mandatory	Yes

Entity Attribute PhATCTaxAmt of the Entity PhTaxATC

Card of Attribute PhATCTaxAmt of the Entity PhTaxATC

Name	PhATCTaxAmt
Code	PhATCTaxAmt
Data Type	double
Mandatory	No

Entity Attribute PhATCHistRate of the Entity PhTaxATC

Card of Attribute PhATCHistRate of the Entity PhTaxATC

Name	PhATCHistRate
Code	PhATCHistRate
Data Type	double
Mandatory	No

Entity Attribute PhATCHistFactor of the Entity PhTaxATC

Card of Attribute PhATCHistFactor of the Entity PhTaxATC

Name	PhATCHistFactor
Code	PhATCHistFactor
Data Type	double
Mandatory	No