Sage EasyPay Data Model

Entity ThTaxRecord

Description of Entity ThTaxRecord

This entity is for the Thailand Income Tax.

List of all Dependencies of the Entity ThTaxRecord

Reference

Reference

Reference

Reference

List of Attributes of the Entity ThTaxRecord

Entity Attribute PersonalSysId of the Entity ThTaxRecord

Card of Attribute PersonalSysId of the Entity ThTaxRecord

Name	PersonalSysId
Code	PersonalSysId
Data Type	integer
Mandatory	Yes

Description of Attribute PersonalSysId of the Entity ThTaxRecord

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 ThTaxationYear of the Entity ThTaxRecord

Card of Attribute ThTaxationYear of the Entity ThTaxRecord

Name	ThTaxationYear
Code	ThTaxationYear
Data Type	integer
Mandatory	Yes

Entity Attribute ThPeriodFrom of the Entity ThTaxRecord

Card of Attribute ThPeriodFrom of the Entity ThTaxRecord

Name	ThPeriodFrom
Code	ThPeriodFrom
Data Type	date
Mandatory	No

Entity Attribute ThPeriodTo of the Entity ThTaxRecord

Card of Attribute ThPeriodTo of the Entity ThTaxRecord

Name	ThPeriodTo
Code	ThPeriodTo
Data Type	date
Mandatory	No

Entity Attribute ThB_PFExceed of the Entity ThTaxRecord

Card of Attribute ThB_PFExceed of the Entity ThTaxRecord

Name	ThB_PFExceed
Code	ThB_PFExceed
Data Type	double
Mandatory	No

Entity Attribute ThB_GovtPension of the Entity ThTaxRecord

Card of Attribute ThB_GovtPension of the Entity ThTaxRecord

Name	ThB_GovtPension
Code	ThB_GovtPension
Data Type	double
Mandatory	No

Entity Attribute ThB_SchoolFund of the Entity ThTaxRecord

Card of Attribute ThB_SchoolFund of the Entity ThTaxRecord

Name	ThB_SchoolFund
Code	ThB_SchoolFund
Data Type	double
Mandatory	No

Entity Attribute ThB_SeverancePay of the Entity ThTaxRecord

Card of Attribute ThB_SeverancePay of the Entity ThTaxRecord

Name	ThB_SeverancePay
Code	ThB_SeverancePay
Data Type	double
Mandatory	No

Entity Attribute ThC_Taxpayer of the Entity ThTaxRecord

Card of Attribute ThC_Taxpayer of the Entity ThTaxRecord

Name	ThC_Taxpayer
Code	ThC_Taxpayer
Data Type	double
Mandatory	No

Entity Attribute ThC_Spouse of the Entity ThTaxRecord

Card of Attribute ThC_Spouse of the Entity ThTaxRecord

Name	ThC_Spouse
Code	ThC_Spouse
Data Type	double
Mandatory	No

Entity Attribute ThC_NoChildNoStudy of the Entity ThTaxRecord

Card of Attribute ThC_NoChildNoStudy of the Entity ThTaxRecord

Name	ThC_NoChildNoStudy
Code	ThC_NoChildNoStudy
Data Type	double
Mandatory	No

Entity Attribute ThC_NoChildStudy of the Entity ThTaxRecord

Card of Attribute ThC_NoChildStudy of the Entity ThTaxRecord

Name	ThC_NoChildStudy
Code	ThC_NoChildStudy
Data Type	double
Mandatory	No

Entity Attribute ThC_ChildNoStudyAmt of the Entity ThTaxRecord

Card of Attribute ThC_ChildNoStudyAmt of the Entity ThTaxRecord

Name	ThC_ChildNoStudyAmt
Code	ThC_ChildNoStudyAmt
Data Type	double
Mandatory	No

Entity Attribute ThC_ChildStudyAmt of the Entity ThTaxRecord

Card of Attribute ThC_ChildStudyAmt of the Entity ThTaxRecord

Name	ThC_ChildStudyAmt
Code	ThC_ChildStudyAmt
Data Type	double
Mandatory	No

Entity Attribute ThC_OldAgeAmt of the Entity ThTaxRecord

Card of Attribute ThC_OldAgeAmt of the Entity ThTaxRecord

Name	ThC_OldAgeAmt
Code	ThC_OldAgeAmt
Data Type	double
Mandatory	No

Entity Attribute ThC_Insurance of the Entity ThTaxRecord

Card of Attribute ThC_Insurance of the Entity ThTaxRecord

Name	ThC_Insurance
Code	ThC_Insurance
Data Type	double
Mandatory	No

Entity Attribute ThC_ProvidentFund of the Entity ThTaxRecord

Card of Attribute ThC_ProvidentFund of the Entity ThTaxRecord

Name	ThC_ProvidentFund
Code	ThC_ProvidentFund
Data Type	double
Mandatory	No

Entity Attribute ThC_RetirementShare of the Entity ThTaxRecord

Card of Attribute ThC_RetirementShare of the Entity ThTaxRecord

Name	ThC_RetirementShare
Code	ThC_RetirementShare
Data Type	double
Mandatory	No

Entity Attribute ThC_EquityFund of the Entity ThTaxRecord

Card of Attribute ThC_EquityFund of the Entity ThTaxRecord

Name	ThC_EquityFund
Code	ThC_EquityFund
Data Type	double
Mandatory	No

Entity Attribute ThC_Residence of the Entity ThTaxRecord

Card of Attribute ThC_Residence of the Entity ThTaxRecord

Name	ThC_Residence
Code	ThC_Residence
Data Type	double
Mandatory	No

Entity Attribute ThC_SocialSecurity of the Entity ThTaxRecord

Card of Attribute ThC_SocialSecurity of the Entity ThTaxRecord

Name	ThC_SocialSecurity
Code	ThC_SocialSecurity
Data Type	double
Mandatory	No

Entity Attribute ThA_Salary of the Entity ThTaxRecord

Card of Attribute ThA_Salary of the Entity ThTaxRecord

Name	ThA_Salary
Code	ThA_Salary
Data Type	double
Mandatory	No

Entity Attribute ThA_TotalExempted of the Entity ThTaxRecord

Card of Attribute ThA_TotalExempted of the Entity ThTaxRecord

Name	ThA_TotalExempted
Code	ThA_TotalExempted
Data Type	double
Mandatory	No

Entity Attribute ThA_Expense of the Entity ThTaxRecord

Card of Attribute ThA_Expense of the Entity ThTaxRecord

Name	ThA_Expense
Code	ThA_Expense
Data Type	double
Mandatory	No

Entity Attribute ThA_TotalAllowances of the Entity ThTaxRecord

Card of Attribute ThA_TotalAllowances of the Entity ThTaxRecord

Name	ThA_TotalAllowances
Code	ThA_TotalAllowances
Data Type	double
Mandatory	No

Entity Attribute ThA_Education of the Entity ThTaxRecord

Card of Attribute ThA_Education of the Entity ThTaxRecord

Name	ThA_Education
Code	ThA_Education
Data Type	double
Mandatory	No

Entity Attribute ThA_Donation of the Entity ThTaxRecord

Card of Attribute ThA_Donation of the Entity ThTaxRecord

Name	ThA_Donation
Code	ThA_Donation
Data Type	double
Mandatory	No

Entity Attribute Th_Taxable of the Entity ThTaxRecord

Card of Attribute Th_Taxable of the Entity ThTaxRecord

Name	Th_Taxable
Code	Th_Taxable
Data Type	double
Mandatory	No

Entity Attribute Th_TaxAmt of the Entity ThTaxRecord

Card of Attribute Th_TaxAmt of the Entity ThTaxRecord

Name	Th_TaxAmt
Code	Th_TaxAmt
Data Type	double
Mandatory	No

Entity Attribute Th_TaxWithheld of the Entity ThTaxRecord

Card of Attribute Th_TaxWithheld of the Entity ThTaxRecord

Name	Th_TaxWithheld
Code	Th_TaxWithheld
Data Type	double
Mandatory	No

Entity Attribute Th_TaxExcess of the Entity ThTaxRecord

Card of Attribute Th_TaxExcess of the Entity ThTaxRecord

Name	Th_TaxExcess
Code	Th_TaxExcess
Data Type	double
Mandatory	No

Entity Attribute ThA_Sport of the Entity ThTaxRecord

Card of Attribute ThA_Sport of the Entity ThTaxRecord

Name	ThA_Sport
Code	ThA_Sport
Data Type	double
Mandatory	No

Entity Attribute ThB_OldAgeAmtSpouse of the Entity ThTaxRecord

Card of Attribute ThB_OldAgeAmtSpouse of the Entity ThTaxRecord

Name	ThB_OldAgeAmtSpouse
Code	ThB_OldAgeAmtSpouse
Data Type	double
Mandatory	No

Entity Attribute ThC_FatherAmt of the Entity ThTaxRecord

Card of Attribute ThC_FatherAmt of the Entity ThTaxRecord

Name	ThC_FatherAmt
Code	ThC_FatherAmt
Data Type	double
Mandatory	No

Entity Attribute ThC_MotherAmt of the Entity ThTaxRecord

Card of Attribute ThC_MotherAmt of the Entity ThTaxRecord

Name	ThC_MotherAmt
Code	ThC_MotherAmt
Data Type	double
Mandatory	No

Entity Attribute ThC_FatherSpouseAmt of the Entity ThTaxRecord

Card of Attribute ThC_FatherSpouseAmt of the Entity ThTaxRecord

Name	ThC_FatherSpouseAmt
Code	ThC_FatherSpouseAmt
Data Type	double
Mandatory	No

Entity Attribute ThC_MotherSpouseAmt of the Entity ThTaxRecord

Card of Attribute ThC_MotherSpouseAmt of the Entity ThTaxRecord

Name	ThC_MotherSpouseAmt
Code	ThC_MotherSpouseAmt
Data Type	double
Mandatory	No

Entity Attribute ThC_HealthInsurance of the Entity ThTaxRecord

Card of Attribute ThC_HealthInsurance of the Entity ThTaxRecord

Name	ThC_HealthInsurance
Code	ThC_HealthInsurance
Data Type	double
Mandatory	No

Home