Sage EasyPay Data Model

Entity RebateGranted

Description of Entity RebateGranted

This entity is for the Malaysia Income Tax.

List of all Dependencies of the Entity RebateGranted

Relationship_727

Reference

Relationship_728

Reference

List of Attributes of the Entity RebateGranted

Entity Attribute PersonalSysId of the Entity RebateGranted

Card of Attribute PersonalSysId of the Entity RebateGranted

Name	PersonalSysId
Code	PersonalSysId
Data Type	integer
Mandatory	Yes

Description of Attribute PersonalSysId of the Entity RebateGranted

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 RebateGrantSysId of the Entity RebateGranted

Card of Attribute RebateGrantSysId of the Entity RebateGranted

Name	RebateGrantSysId
Code	RebateGrantSysId
Data Type	integer
Mandatory	Yes

Description of Attribute RebateGrantSysId of the Entity RebateGranted

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

Entity Attribute Rebate Payroll Year of the Entity RebateGranted

Card of Attribute Rebate Payroll Year of the Entity RebateGranted

Name	Rebate Payroll Year
Code	RebatePayrollYear
Data Type	integer
Mandatory	No

Description of Attribute Rebate Payroll Year of the Entity RebateGranted

Shows the year for the payroll.
Example: 2013

Entity Attribute Rebate Payroll Period of the Entity RebateGranted

Card of Attribute Rebate Payroll Period of the Entity RebateGranted

Name	Rebate Payroll Period
Code	RebatePayrollPeriod
Data Type	integer
Mandatory	No

Description of Attribute Rebate Payroll Period of the Entity RebateGranted

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

Entity Attribute Rebate Declared Year of the Entity RebateGranted

Card of Attribute Rebate Declared Year of the Entity RebateGranted

Name	Rebate Declared Year
Code	RebateDeclaredYear
Data Type	integer
Mandatory	No

Description of Attribute Rebate Declared Year of the Entity RebateGranted

Shows the declared year of the rebate.

Entity Attribute Rebate Amount of the Entity RebateGranted

Card of Attribute Rebate Amount of the Entity RebateGranted

Name	Rebate Amount
Code	RebateAmt
Data Type	double
Mandatory	No

Description of Attribute Rebate Amount of the Entity RebateGranted

Shows the rebate amount.

Entity Attribute Taxable Amount of the Entity RebateGranted

Card of Attribute Taxable Amount of the Entity RebateGranted

Name	Taxable Amount
Code	TaxableAmt
Data Type	double
Mandatory	No

Description of Attribute Taxable Amount of the Entity RebateGranted

Shows the taxable amount.

Entity Attribute Add Taxable Amount of the Entity RebateGranted

Card of Attribute Add Taxable Amount of the Entity RebateGranted

Name	Add Taxable Amount
Code	AddTaxableAmt
Data Type	double
Mandatory	No

Description of Attribute Add Taxable Amount of the Entity RebateGranted

Shows the additional taxable amount.

Entity Attribute LPAmt of the Entity RebateGranted

Card of Attribute LPAmt of the Entity RebateGranted

Name	LPAmt
Code	LPAmt
Data Type	double
Mandatory	No

Description of Attribute LPAmt of the Entity RebateGranted

Shows the LP amount.

Entity Attribute Rebate Payment Count of the Entity RebateGranted

Card of Attribute Rebate Payment Count of the Entity RebateGranted

Name	Rebate Payment Count
Code	RebatePaymentCount
Data Type	integer
Mandatory	No

Description of Attribute Rebate Payment Count of the Entity RebateGranted

Shows the payment count for the rebate.

Entity Attribute Created By of the Entity RebateGranted

Card of Attribute Created By of the Entity RebateGranted

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

Description of Attribute Created By of the Entity RebateGranted

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

Entity Attribute TRebateAmt of the Entity RebateGranted

Card of Attribute TRebateAmt of the Entity RebateGranted

Name	TRebateAmt
Code	TRebateAmt
Data Type	double
Mandatory	No

Description of Attribute TRebateAmt of the Entity RebateGranted

Shows the rebate amount.

Entity Attribute TLP Amount of the Entity RebateGranted

Card of Attribute TLP Amount of the Entity RebateGranted

Name	TLP Amount
Code	TLPAmt
Data Type	double
Mandatory	No

Description of Attribute TLP Amount of the Entity RebateGranted

Shows the LP amount.

Entity Attribute TEmployeeSysId of the Entity RebateGranted

Card of Attribute TEmployeeSysId of the Entity RebateGranted

Name	TEmployeeSysId
Code	TEmployeeSysId
Data Type	integer
Mandatory	No

Description of Attribute TEmployeeSysId of the Entity RebateGranted

A system generated identity. Shows the identity of the employee.

Entity Attribute PrevEmployerSysId of the Entity RebateGranted

Card of Attribute PrevEmployerSysId of the Entity RebateGranted

Name	PrevEmployerSysId
Code	PrevEmployerSysId
Data Type	integer
Mandatory	No

Description of Attribute PrevEmployerSysId of the Entity RebateGranted

A system generated identity. Shows the identity of the previous employer.

Home