Sage EasyPay Data Model

Entity TmplVariables

Description of Entity TmplVariables

Templates are generally faster to use when creating variations of standard reports. You can use these variables in your queries. You can also define these variables and not use them, however, if you have referenced a custom variable from within the queries, you will need to assign a value else the Report Designer will substitute a zero or blank value accordingly. This means that your queries may be executed successfully but the results are not correct because of the substitution.

List of all Dependencies of the Entity TmplVariables

Relationship_756

Relationship_757

Reference

List of Attributes of the Entity TmplVariables

Keyword1DefValue

Keyword1DefValue

Keyword2DefValue

Keyword2DefValue

Keyword3DefValue

Keyword3DefValue

Keyword4DefValue

Keyword4DefValue

Keyword5DefValue

Keyword5DefValue

StrVar1DefValue

StrVar1DefValue

StrVar2DefValue

StrVar2DefValue

StrVar3DefValue

StrVar3DefValue

StrVar4DefValue

StrVar4DefValue

StrVar5DefValue

StrVar5DefValue

NumVar1DefValue

NumVar1DefValue

NumVar2DefValue

NumVar2DefValue

NumVar3DefValue

NumVar3DefValue

NumVar4DefValue

NumVar4DefValue

NumVar5DefValue

NumVar5DefValue

DateVar1DefValue

DateVar1DefValue

DateVar2DefValue

DateVar2DefValue

Entity Attribute Keyword1Id of the Entity TmplVariables

Card of Attribute Keyword1Id of the Entity TmplVariables

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

Description of Attribute Keyword1Id of the Entity TmplVariables

Shows the identity of the keyword for the variables.

Entity Attribute Keyword2Id of the Entity TmplVariables

Card of Attribute Keyword2Id of the Entity TmplVariables

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

Description of Attribute Keyword2Id of the Entity TmplVariables

Shows the identity of the keyword for the variables.

Entity Attribute Keyword3Id of the Entity TmplVariables

Card of Attribute Keyword3Id of the Entity TmplVariables

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

Description of Attribute Keyword3Id of the Entity TmplVariables

Shows the identity of the keyword for the variables.

Entity Attribute Keyword4Id of the Entity TmplVariables

Card of Attribute Keyword4Id of the Entity TmplVariables

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

Description of Attribute Keyword4Id of the Entity TmplVariables

Shows the identity of the keyword for the variables.

Entity Attribute Keyword5Id of the Entity TmplVariables

Card of Attribute Keyword5Id of the Entity TmplVariables

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

Description of Attribute Keyword5Id of the Entity TmplVariables

Shows the identity of the keyword for the variables.

Entity Attribute Keyword1Desc of the Entity TmplVariables

Card of Attribute Keyword1Desc of the Entity TmplVariables

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

Description of Attribute Keyword1Desc of the Entity TmplVariables

Stores a description about the keyword for the template variables.

Entity Attribute Keyword2Desc of the Entity TmplVariables

Card of Attribute Keyword2Desc of the Entity TmplVariables

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

Description of Attribute Keyword2Desc of the Entity TmplVariables

Stores a description about the keyword for the template variables.

Entity Attribute Keyword3Desc of the Entity TmplVariables

Card of Attribute Keyword3Desc of the Entity TmplVariables

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

Description of Attribute Keyword3Desc of the Entity TmplVariables

Stores a description about the keyword for the template variables.

Entity Attribute Keyword4Desc of the Entity TmplVariables

Card of Attribute Keyword4Desc of the Entity TmplVariables

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

Description of Attribute Keyword4Desc of the Entity TmplVariables

Stores a description about the keyword for the template variables.

Entity Attribute Keyword5Desc of the Entity TmplVariables

Card of Attribute Keyword5Desc of the Entity TmplVariables

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

Description of Attribute Keyword5Desc of the Entity TmplVariables

Stores a description about the keyword for the template variables.

Entity Attribute StrVar1 of the Entity TmplVariables

Card of Attribute StrVar1 of the Entity TmplVariables

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

Description of Attribute StrVar1 of the Entity TmplVariables

Stores the string variable for the template.

Entity Attribute StrVar2 of the Entity TmplVariables

Card of Attribute StrVar2 of the Entity TmplVariables

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

Description of Attribute StrVar2 of the Entity TmplVariables

Stores the string variable for the template.

Entity Attribute StrVar3 of the Entity TmplVariables

Card of Attribute StrVar3 of the Entity TmplVariables

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

Description of Attribute StrVar3 of the Entity TmplVariables

Stores the string variable for the template.

Entity Attribute StrVar4 of the Entity TmplVariables

Card of Attribute StrVar4 of the Entity TmplVariables

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

Description of Attribute StrVar4 of the Entity TmplVariables

Stores the string variable for the template.

Entity Attribute StrVar5 of the Entity TmplVariables

Card of Attribute StrVar5 of the Entity TmplVariables

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

Description of Attribute StrVar5 of the Entity TmplVariables

Stores the string variable for the template.

Entity Attribute NumVar1 of the Entity TmplVariables

Card of Attribute NumVar1 of the Entity TmplVariables

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

Description of Attribute NumVar1 of the Entity TmplVariables

Stores the number variable for the template.

Entity Attribute NumVar2 of the Entity TmplVariables

Card of Attribute NumVar2 of the Entity TmplVariables

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

Description of Attribute NumVar2 of the Entity TmplVariables

Stores the number variable for the template.

Entity Attribute NumVar3 of the Entity TmplVariables

Card of Attribute NumVar3 of the Entity TmplVariables

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

Description of Attribute NumVar3 of the Entity TmplVariables

Stores the number variable for the template.

Entity Attribute NumVar4 of the Entity TmplVariables

Card of Attribute NumVar4 of the Entity TmplVariables

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

Description of Attribute NumVar4 of the Entity TmplVariables

Stores the number variable for the template.

Entity Attribute NumVar5 of the Entity TmplVariables

Card of Attribute NumVar5 of the Entity TmplVariables

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

Description of Attribute NumVar5 of the Entity TmplVariables

Stores the number variable for the template.

Entity Attribute DateVar1 of the Entity TmplVariables

Card of Attribute DateVar1 of the Entity TmplVariables

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

Description of Attribute DateVar1 of the Entity TmplVariables

Stores the date variable for the template.

Entity Attribute DateVar2 of the Entity TmplVariables

Card of Attribute DateVar2 of the Entity TmplVariables

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

Description of Attribute DateVar2 of the Entity TmplVariables

Stores the date variable for the template.

Entity Attribute Keyword1DefValue of the Entity TmplVariables

Card of Attribute Keyword1DefValue of the Entity TmplVariables

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

Description of Attribute Keyword1DefValue of the Entity TmplVariables

Shows the value of the keyword for the variables.

Entity Attribute Keyword2DefValue of the Entity TmplVariables

Card of Attribute Keyword2DefValue of the Entity TmplVariables

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

Description of Attribute Keyword2DefValue of the Entity TmplVariables

Shows the value of the keyword for the variables.

Entity Attribute Keyword3DefValue of the Entity TmplVariables

Card of Attribute Keyword3DefValue of the Entity TmplVariables

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

Description of Attribute Keyword3DefValue of the Entity TmplVariables

Shows the value of the keyword for the variables.

Entity Attribute Keyword4DefValue of the Entity TmplVariables

Card of Attribute Keyword4DefValue of the Entity TmplVariables

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

Description of Attribute Keyword4DefValue of the Entity TmplVariables

Shows the value of the keyword for the variables.

Entity Attribute Keyword5DefValue of the Entity TmplVariables

Card of Attribute Keyword5DefValue of the Entity TmplVariables

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

Description of Attribute Keyword5DefValue of the Entity TmplVariables

Shows the value of the keyword for the variables.

Entity Attribute StrVar1DefValue of the Entity TmplVariables

Card of Attribute StrVar1DefValue of the Entity TmplVariables

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

Description of Attribute StrVar1DefValue of the Entity TmplVariables

Shows the value of the string variable for the template.

Entity Attribute StrVar2DefValue of the Entity TmplVariables

Card of Attribute StrVar2DefValue of the Entity TmplVariables

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

Description of Attribute StrVar2DefValue of the Entity TmplVariables

Shows the value of the string variable for the template.

Entity Attribute StrVar3DefValue of the Entity TmplVariables

Card of Attribute StrVar3DefValue of the Entity TmplVariables

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

Description of Attribute StrVar3DefValue of the Entity TmplVariables

Shows the value of the string variable for the template.

Entity Attribute StrVar4DefValue of the Entity TmplVariables

Card of Attribute StrVar4DefValue of the Entity TmplVariables

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

Description of Attribute StrVar4DefValue of the Entity TmplVariables

Shows the value of the string variable for the template.

Entity Attribute StrVar5DefValue of the Entity TmplVariables

Card of Attribute StrVar5DefValue of the Entity TmplVariables

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

Description of Attribute StrVar5DefValue of the Entity TmplVariables

Shows the value of the string variable for the template.

Entity Attribute NumVar1DefValue of the Entity TmplVariables

Card of Attribute NumVar1DefValue of the Entity TmplVariables

Name	NumVar1DefValue
Code	NumVar1DefValue
Data Type	double
Mandatory	No

Description of Attribute NumVar1DefValue of the Entity TmplVariables

Shows the value of the number variable for the template.

Entity Attribute NumVar2DefValue of the Entity TmplVariables

Card of Attribute NumVar2DefValue of the Entity TmplVariables

Name	NumVar2DefValue
Code	NumVar2DefValue
Data Type	double
Mandatory	No

Description of Attribute NumVar2DefValue of the Entity TmplVariables

Shows the value of the number variable for the template.

Entity Attribute NumVar3DefValue of the Entity TmplVariables

Card of Attribute NumVar3DefValue of the Entity TmplVariables

Name	NumVar3DefValue
Code	NumVar3DefValue
Data Type	double
Mandatory	No

Description of Attribute NumVar3DefValue of the Entity TmplVariables

Shows the value of the number variable for the template.

Entity Attribute NumVar4DefValue of the Entity TmplVariables

Card of Attribute NumVar4DefValue of the Entity TmplVariables

Name	NumVar4DefValue
Code	NumVar4DefValue
Data Type	double
Mandatory	No

Description of Attribute NumVar4DefValue of the Entity TmplVariables

Shows the value of the number variable for the template.

Entity Attribute NumVar5DefValue of the Entity TmplVariables

Card of Attribute NumVar5DefValue of the Entity TmplVariables

Name	NumVar5DefValue
Code	NumVar5DefValue
Data Type	double
Mandatory	No

Description of Attribute NumVar5DefValue of the Entity TmplVariables

Shows the value of the number variable for the template.

Entity Attribute DateVar1DefValue of the Entity TmplVariables

Card of Attribute DateVar1DefValue of the Entity TmplVariables

Name	DateVar1DefValue
Code	DateVar1DefValue
Data Type	date
Mandatory	No

Description of Attribute DateVar1DefValue of the Entity TmplVariables

Shows the value of the variable for the template.
It is usually in the format: DD-MM-YYYY.

Entity Attribute DateVar2DefValue of the Entity TmplVariables

Card of Attribute DateVar2DefValue of the Entity TmplVariables

Name	DateVar2DefValue
Code	DateVar2DefValue
Data Type	date
Mandatory	No

Description of Attribute DateVar2DefValue of the Entity TmplVariables

Shows the value of the variable for the template.
It is usually in the format: DD-MM-YYYY.