Sage EasyPay Data Model

Entity AccrItemBasis

Description of Entity AccrItemBasis

This table will contain the different ranges for each FormulaId and each range can have its own set of formulas.

C1 - C5 are the constants
K1 - K10 are the keywords where the values will be supplied by the system.
U1 - U5 are the user defined keywords where the user will supply the values.

List of all Dependencies of the Entity AccrItemBasis

Relation_1124861

Relation_1124861

Reference

Relation_1104260

Relation_1104260

Reference

Relation_1104259

Relation_1104259

Reference

List of Attributes of the Entity AccrItemBasis

AccrFormulaDesc

AccrUserDefinedValue1

AccrUserDefinedValue1

AccrUserDefinedValue2

AccrUserDefinedValue2

AccrUserDefinedValue3

AccrUserDefinedValue3

AccrUserDefinedValue4

AccrUserDefinedValue4

AccrUserDefinedValue5

AccrUserDefinedValue5

Entity Attribute Formula of the Entity AccrItemBasis

Card of Attribute Formula of the Entity AccrItemBasis

Name	Formula
Code	Formula
Data Type	char(255)
Mandatory	No

Description of Attribute Formula of the Entity AccrItemBasis

Shows the formula for the entity.

Entity Attribute Description of the Entity AccrItemBasis

Card of Attribute Description of the Entity AccrItemBasis

Name	Description
Code	AccrFormulaDesc
Data Type	char(100)
Mandatory	No

Description of Attribute Description of the Entity AccrItemBasis

Stores a description about the accrual formula.

Entity Attribute AccrUserDefinedValue1 of the Entity AccrItemBasis

Card of Attribute AccrUserDefinedValue1 of the Entity AccrItemBasis

Name	AccrUserDefinedValue1
Code	AccrUserDefinedValue1
Data Type	double
Mandatory	No

Description of Attribute AccrUserDefinedValue1 of the Entity AccrItemBasis

A user defined value for the accrual item basis.

Entity Attribute AccrUserDefinedValue2 of the Entity AccrItemBasis

Card of Attribute AccrUserDefinedValue2 of the Entity AccrItemBasis

Name	AccrUserDefinedValue2
Code	AccrUserDefinedValue2
Data Type	double
Mandatory	No

Description of Attribute AccrUserDefinedValue2 of the Entity AccrItemBasis

A user defined value for the accrual item basis.

Entity Attribute AccrUserDefinedValue3 of the Entity AccrItemBasis

Card of Attribute AccrUserDefinedValue3 of the Entity AccrItemBasis

Name	AccrUserDefinedValue3
Code	AccrUserDefinedValue3
Data Type	double
Mandatory	No

Description of Attribute AccrUserDefinedValue3 of the Entity AccrItemBasis

A user defined value for the accrual item basis.

Entity Attribute AccrUserDefinedValue4 of the Entity AccrItemBasis

Card of Attribute AccrUserDefinedValue4 of the Entity AccrItemBasis

Name	AccrUserDefinedValue4
Code	AccrUserDefinedValue4
Data Type	double
Mandatory	No

Description of Attribute AccrUserDefinedValue4 of the Entity AccrItemBasis

A user defined value for the accrual item basis.

Entity Attribute AccrUserDefinedValue5 of the Entity AccrItemBasis

Card of Attribute AccrUserDefinedValue5 of the Entity AccrItemBasis

Name	AccrUserDefinedValue5
Code	AccrUserDefinedValue5
Data Type	double
Mandatory	No

Description of Attribute AccrUserDefinedValue5 of the Entity AccrItemBasis

A user defined value for the accrual item basis.