Sage EasyPay Data Model

Entity PhTaxRecord

Description of Entity PhTaxRecord

This entity is for the Philippines Payroll.

List of all Dependencies of the Entity PhTaxRecord

Relation_919935

Relation_919935

Reference

Relation_919942

Relation_919942

Reference

Relation_920008

Relation_920008

Reference

Relation_1089070

Relation_1089070

Reference

Relation_915320

Relation_915320

Reference

Relation_919940

Relation_919940

Reference

Relation_965073

Relation_965073

Reference

List of Attributes of the Entity PhTaxRecord

PhWifeClaimAddEx

PhWifeClaimAddEx

PhOtherDepRelation

PhOtherDepRelation

PhGovtFundContri

PhGovtFundContri

PhTotalNonTaxable

PhTotalNonTaxable

PhRepresentation

PhRepresentation

PhRegularOthers

PhRegularOthers

PhSupplementOthers

PhSupplementOthers

PhTotalExemption

PhTotalExemption

PhActualTaxable

PhActualTaxable

PhPreviousERTax

PhPreviousERTax

PhCTCPlaceIssue

PhCTCPlaceIssue

PhBasicSalaryMWE

PhBasicSalaryMWE

PhHolidayPayMWE

PhHolidayPayMWE

PhOvertimePayMWE

PhOvertimePayMWE

PhNightShiftMWE

PhNightShiftMWE

Entity Attribute PersonalSysId of the Entity PhTaxRecord

Card of Attribute PersonalSysId of the Entity PhTaxRecord

Name	PersonalSysId
Code	PersonalSysId
Data Type	integer
Mandatory	Yes

Description of Attribute PersonalSysId of the Entity PhTaxRecord

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 PhTaxYear of the Entity PhTaxRecord

Card of Attribute PhTaxYear of the Entity PhTaxRecord

Name	PhTaxYear
Code	PhTaxYear
Data Type	integer
Mandatory	Yes

Entity Attribute PhFromPeriod of the Entity PhTaxRecord

Card of Attribute PhFromPeriod of the Entity PhTaxRecord

Name	PhFromPeriod
Code	PhFromPeriod
Data Type	date
Mandatory	No

Entity Attribute PhToPeriod of the Entity PhTaxRecord

Card of Attribute PhToPeriod of the Entity PhTaxRecord

Name	PhToPeriod
Code	PhToPeriod
Data Type	date
Mandatory	No

Entity Attribute PhExemption of the Entity PhTaxRecord

Card of Attribute PhExemption of the Entity PhTaxRecord

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

Entity Attribute PhDependentNo of the Entity PhTaxRecord

Card of Attribute PhDependentNo of the Entity PhTaxRecord

Name	PhDependentNo
Code	PhDependentNo
Data Type	integer
Mandatory	No

Entity Attribute PhWifeClaimAddEx of the Entity PhTaxRecord

Card of Attribute PhWifeClaimAddEx of the Entity PhTaxRecord

Name	PhWifeClaimAddEx
Code	PhWifeClaimAddEx
Data Type	smallint
Mandatory	No

Entity Attribute PhOtherDepName of the Entity PhTaxRecord

Card of Attribute PhOtherDepName of the Entity PhTaxRecord

Name	PhOtherDepName
Code	PhOtherDepName
Data Type	char(150)
Mandatory	No

Entity Attribute PhOtherDepRelation of the Entity PhTaxRecord

Card of Attribute PhOtherDepRelation of the Entity PhTaxRecord

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

Entity Attribute PhOtherDepDOB of the Entity PhTaxRecord

Card of Attribute PhOtherDepDOB of the Entity PhTaxRecord

Name	PhOtherDepDOB
Code	PhOtherDepDOB
Data Type	date
Mandatory	No

Entity Attribute PhPresERMainER of the Entity PhTaxRecord

Card of Attribute PhPresERMainER of the Entity PhTaxRecord

Name	PhPresERMainER
Code	PhPresERMainER
Data Type	smallint
Mandatory	No

Entity Attribute PhNonTaxBonus of the Entity PhTaxRecord

Card of Attribute PhNonTaxBonus of the Entity PhTaxRecord

Name	PhNonTaxBonus
Code	PhNonTaxBonus
Data Type	double
Mandatory	No

Entity Attribute PhGovtFundContri of the Entity PhTaxRecord

Card of Attribute PhGovtFundContri of the Entity PhTaxRecord

Name	PhGovtFundContri
Code	PhGovtFundContri
Data Type	double
Mandatory	No

Entity Attribute PhNonTaxSalary of the Entity PhTaxRecord

Card of Attribute PhNonTaxSalary of the Entity PhTaxRecord

Name	PhNonTaxSalary
Code	PhNonTaxSalary
Data Type	double
Mandatory	No

Entity Attribute PhTotalNonTaxable of the Entity PhTaxRecord

Card of Attribute PhTotalNonTaxable of the Entity PhTaxRecord

Name	PhTotalNonTaxable
Code	PhTotalNonTaxable
Data Type	double
Mandatory	No

Entity Attribute PhTaxSalary of the Entity PhTaxRecord

Card of Attribute PhTaxSalary of the Entity PhTaxRecord

Name	PhTaxSalary
Code	PhTaxSalary
Data Type	double
Mandatory	No

Entity Attribute PhRepresentation of the Entity PhTaxRecord

Card of Attribute PhRepresentation of the Entity PhTaxRecord

Name	PhRepresentation
Code	PhRepresentation
Data Type	double
Mandatory	No

Entity Attribute PhTransport of the Entity PhTaxRecord

Card of Attribute PhTransport of the Entity PhTaxRecord

Name	PhTransport
Code	PhTransport
Data Type	double
Mandatory	No

Entity Attribute PhCostLiving of the Entity PhTaxRecord

Card of Attribute PhCostLiving of the Entity PhTaxRecord

Name	PhCostLiving
Code	PhCostLiving
Data Type	double
Mandatory	No

Entity Attribute PhHousing of the Entity PhTaxRecord

Card of Attribute PhHousing of the Entity PhTaxRecord

Name	PhHousing
Code	PhHousing
Data Type	double
Mandatory	No

Entity Attribute PhRegOTShift of the Entity PhTaxRecord

Card of Attribute PhRegOTShift of the Entity PhTaxRecord

Name	PhRegOTShift
Code	PhRegOTShift
Data Type	double
Mandatory	No

Entity Attribute PhRegularOthers of the Entity PhTaxRecord

Card of Attribute PhRegularOthers of the Entity PhTaxRecord

Name	PhRegularOthers
Code	PhRegularOthers
Data Type	double
Mandatory	No

Entity Attribute PhCommission of the Entity PhTaxRecord

Card of Attribute PhCommission of the Entity PhTaxRecord

Name	PhCommission
Code	PhCommission
Data Type	double
Mandatory	No

Entity Attribute PhProfitShare of the Entity PhTaxRecord

Card of Attribute PhProfitShare of the Entity PhTaxRecord

Name	PhProfitShare
Code	PhProfitShare
Data Type	double
Mandatory	No

Entity Attribute PhFees of the Entity PhTaxRecord

Card of Attribute PhFees of the Entity PhTaxRecord

Name	PhFees
Code	PhFees
Data Type	double
Mandatory	No

Entity Attribute PhTaxBonus of the Entity PhTaxRecord

Card of Attribute PhTaxBonus of the Entity PhTaxRecord

Name	PhTaxBonus
Code	PhTaxBonus
Data Type	double
Mandatory	No

Entity Attribute PhHazardPay of the Entity PhTaxRecord

Card of Attribute PhHazardPay of the Entity PhTaxRecord

Name	PhHazardPay
Code	PhHazardPay
Data Type	double
Mandatory	No

Entity Attribute PhSupplementOthers of the Entity PhTaxRecord

Card of Attribute PhSupplementOthers of the Entity PhTaxRecord

Name	PhSupplementOthers
Code	PhSupplementOthers
Data Type	double
Mandatory	No

Entity Attribute PhPresTaxable of the Entity PhTaxRecord

Card of Attribute PhPresTaxable of the Entity PhTaxRecord

Name	PhPresTaxable
Code	PhPresTaxable
Data Type	double
Mandatory	No

Entity Attribute PhPrevTaxable of the Entity PhTaxRecord

Card of Attribute PhPrevTaxable of the Entity PhTaxRecord

Name	PhPrevTaxable
Code	PhPrevTaxable
Data Type	double
Mandatory	No

Entity Attribute PhTotalExemption of the Entity PhTaxRecord

Card of Attribute PhTotalExemption of the Entity PhTaxRecord

Name	PhTotalExemption
Code	PhTotalExemption
Data Type	double
Mandatory	No

Entity Attribute PhInsurance of the Entity PhTaxRecord

Card of Attribute PhInsurance of the Entity PhTaxRecord

Name	PhInsurance
Code	PhInsurance
Data Type	double
Mandatory	No

Entity Attribute PhActualTaxable of the Entity PhTaxRecord

Card of Attribute PhActualTaxable of the Entity PhTaxRecord

Name	PhActualTaxable
Code	PhActualTaxable
Data Type	double
Mandatory	No

Entity Attribute PhTaxDue of the Entity PhTaxRecord

Card of Attribute PhTaxDue of the Entity PhTaxRecord

Name	PhTaxDue
Code	PhTaxDue
Data Type	double
Mandatory	No

Entity Attribute PhPresentERTax of the Entity PhTaxRecord

Card of Attribute PhPresentERTax of the Entity PhTaxRecord

Name	PhPresentERTax
Code	PhPresentERTax
Data Type	double
Mandatory	No

Entity Attribute PhPreviousERTax of the Entity PhTaxRecord

Card of Attribute PhPreviousERTax of the Entity PhTaxRecord

Name	PhPreviousERTax
Code	PhPreviousERTax
Data Type	double
Mandatory	No

Entity Attribute PhTaxWithheld of the Entity PhTaxRecord

Card of Attribute PhTaxWithheld of the Entity PhTaxRecord

Name	PhTaxWithheld
Code	PhTaxWithheld
Data Type	double
Mandatory	No

Entity Attribute PhCTCNo of the Entity PhTaxRecord

Card of Attribute PhCTCNo of the Entity PhTaxRecord

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

Entity Attribute PhCTCPlaceIssue of the Entity PhTaxRecord

Card of Attribute PhCTCPlaceIssue of the Entity PhTaxRecord

Name	PhCTCPlaceIssue
Code	PhCTCPlaceIssue
Data Type	char(50)
Mandatory	No

Entity Attribute PhCTCDateIssue of the Entity PhTaxRecord

Card of Attribute PhCTCDateIssue of the Entity PhTaxRecord

Name	PhCTCDateIssue
Code	PhCTCDateIssue
Data Type	date
Mandatory	No

Entity Attribute PhCTCPaidAmt of the Entity PhTaxRecord

Card of Attribute PhCTCPaidAmt of the Entity PhTaxRecord

Name	PhCTCPaidAmt
Code	PhCTCPaidAmt
Data Type	double
Mandatory	No

Entity Attribute PhSMWPerDay of the Entity PhTaxRecord

Card of Attribute PhSMWPerDay of the Entity PhTaxRecord

Name	PhSMWPerDay
Code	PhSMWPerDay
Data Type	double
Mandatory	No

Entity Attribute PhSMWPerMonth of the Entity PhTaxRecord

Card of Attribute PhSMWPerMonth of the Entity PhTaxRecord

Name	PhSMWPerMonth
Code	PhSMWPerMonth
Data Type	double
Mandatory	No

Entity Attribute PhMWEOption of the Entity PhTaxRecord

Card of Attribute PhMWEOption of the Entity PhTaxRecord

Name	PhMWEOption
Code	PhMWEOption
Data Type	smallint
Mandatory	No

Entity Attribute PhBasicSalaryMWE of the Entity PhTaxRecord

Card of Attribute PhBasicSalaryMWE of the Entity PhTaxRecord

Name	PhBasicSalaryMWE
Code	PhBasicSalaryMWE
Data Type	double
Mandatory	No

Entity Attribute PhHolidayPayMWE of the Entity PhTaxRecord

Card of Attribute PhHolidayPayMWE of the Entity PhTaxRecord

Name	PhHolidayPayMWE
Code	PhHolidayPayMWE
Data Type	double
Mandatory	No

Entity Attribute PhOvertimePayMWE of the Entity PhTaxRecord

Card of Attribute PhOvertimePayMWE of the Entity PhTaxRecord

Name	PhOvertimePayMWE
Code	PhOvertimePayMWE
Data Type	double
Mandatory	No

Entity Attribute PhNightShiftMWE of the Entity PhTaxRecord

Card of Attribute PhNightShiftMWE of the Entity PhTaxRecord

Name	PhNightShiftMWE
Code	PhNightShiftMWE
Data Type	double
Mandatory	No

Entity Attribute PhHazardPayMWE of the Entity PhTaxRecord

Card of Attribute PhHazardPayMWE of the Entity PhTaxRecord

Name	PhHazardPayMWE
Code	PhHazardPayMWE
Data Type	double
Mandatory	No

Entity Attribute PhDeMinimis of the Entity PhTaxRecord

Card of Attribute PhDeMinimis of the Entity PhTaxRecord

Name	PhDeMinimis
Code	PhDeMinimis
Data Type	double
Mandatory	No