Sage EasyPay Data Model

Entity FinColAccumulated

Description of Entity FinColAccumulated

This indicates whether to include the range information together with the title of the report item. Shows the accumulated order in the period / year.

List of all Dependencies of the Entity FinColAccumulated

Relation_1458

Reference

List of Attributes of the Entity FinColAccumulated

FinColAccu Sub Period

FinColAccuSubPeriod

FinColAccu Pay Rec ID Type

FinColAccuPayRecIdType

Entity Attribute FinColAccuSysId of the Entity FinColAccumulated

Card of Attribute FinColAccuSysId of the Entity FinColAccumulated

Name	FinColAccuSysId
Code	FinColAccuSysId
Data Type	integer
Mandatory	Yes

Description of Attribute FinColAccuSysId of the Entity FinColAccumulated

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

Entity Attribute Fin Col Accu Order of the Entity FinColAccumulated

Card of Attribute Fin Col Accu Order of the Entity FinColAccumulated

Name	Fin Col Accu Order
Code	FinColAccuOrder
Data Type	integer
Mandatory	No

Description of Attribute Fin Col Accu Order of the Entity FinColAccumulated

Shows the order of the accumulated finance column.

Entity Attribute FinColAccu Year of the Entity FinColAccumulated

Card of Attribute FinColAccu Year of the Entity FinColAccumulated

Name	FinColAccu Year
Code	FinColAccuYear
Data Type	integer
Mandatory	No

Description of Attribute FinColAccu Year of the Entity FinColAccumulated

Shows the year of the accumulated finance column.
Example: 2013

Entity Attribute FinColAccuMth Period of the Entity FinColAccumulated

Card of Attribute FinColAccuMth Period of the Entity FinColAccumulated

Name	FinColAccuMth Period
Code	FinColAccuMthPeriod
Data Type	integer
Mandatory	No

Description of Attribute FinColAccuMth Period of the Entity FinColAccumulated

Shows the period of the accumulated finance column.
Example: January = "1" / February = "2" / March = "3" etc

Entity Attribute FinColAccu Sub Period of the Entity FinColAccumulated

Card of Attribute FinColAccu Sub Period of the Entity FinColAccumulated

Name	FinColAccu Sub Period
Code	FinColAccuSubPeriod
Data Type	integer
Mandatory	No

Description of Attribute FinColAccu Sub Period of the Entity FinColAccumulated

Shows the sub period of the accumulated finance column.

Example:
Sub period 1 = 1 Payment Group (Hourly, Daily & Monthly rated)
Sub period 2 = 2 Payment Group (Hourly, Daily & Monthly rated)
Sub period 3 = 3 Payment Group (Hourly & Daily rated), divided by 3 and the balance is placed in the last sub-period
Sub Period 4 = 4 Payment Group (Hourly & Daily rated)

Entity Attribute FinColAccu Pay Rec ID Type of the Entity FinColAccumulated

Card of Attribute FinColAccu Pay Rec ID Type of the Entity FinColAccumulated

Name	FinColAccu Pay Rec ID Type
Code	FinColAccuPayRecIdType
Data Type	char(20)
Mandatory	No

Description of Attribute FinColAccu Pay Rec ID Type of the Entity FinColAccumulated

Shows the identity of the pay record type for the accumulated finance column.
Example: Normal / Normal Time Sheet

Home