Sage EasyPay Data Model

Entity CustomKeyword

Description of Entity CustomKeyword

The keyword variables are <K1> to <K5> and these values are extracted from the database and are presented as a list during execution.

List of Attributes of the Entity CustomKeyword

Entity Attribute CustomKeyword ID of the Entity CustomKeyword

Card of Attribute CustomKeyword ID of the Entity CustomKeyword

Name	CustomKeyword ID
Code	CustomKeywordId
Data Type	char(20)
Mandatory	Yes

Description of Attribute CustomKeyword ID of the Entity CustomKeyword

Shows the identity of the custom keyword. It is also the primary key for the CustomKeyword table.

Entity Attribute KeyWord Category of the Entity CustomKeyword

Card of Attribute KeyWord Category of the Entity CustomKeyword

Name	KeyWord Category
Code	KeyWordCategory
Data Type	char(20)
Mandatory	No

Description of Attribute KeyWord Category of the Entity CustomKeyword

Shows which category the keyword belongs to.

Entity Attribute KeyWord Default Name of the Entity CustomKeyword

Card of Attribute KeyWord Default Name of the Entity CustomKeyword

Name	KeyWord Default Name
Code	KeyWordDefaultName
Data Type	char(100)
Mandatory	No

Description of Attribute KeyWord Default Name of the Entity CustomKeyword

This is the original name where the software will reference to. The user is not able to make amendments to this attribute.

Entity Attribute KeyWord User Defined Name of the Entity CustomKeyword

Card of Attribute KeyWord User Defined Name of the Entity CustomKeyword

Name	KeyWord User Defined Name
Code	KeyWordUserDefinedName
Data Type	char(100)
Mandatory	No

Description of Attribute KeyWord User Defined Name of the Entity CustomKeyword

This is the user defined name which can be amended from Code Setup in the Core Module.

Entity Attribute Description of the Entity CustomKeyword

Card of Attribute Description of the Entity CustomKeyword

Name	Description
Code	KeyWordDesc
Data Type	char(200)
Mandatory	No

Description of Attribute Description of the Entity CustomKeyword

Shows the description for the keyword.

Entity Attribute KeywordProperty1 of the Entity CustomKeyword

Card of Attribute KeywordProperty1 of the Entity CustomKeyword

Name	KeywordProperty1
Code	KeywordProperty1
Data Type	char(100)
Mandatory	No

Description of Attribute KeywordProperty1 of the Entity CustomKeyword

A property for the keyword. It can be a query / date field etc

Entity Attribute KeywordProperty2 of the Entity CustomKeyword

Card of Attribute KeywordProperty2 of the Entity CustomKeyword

Name	KeywordProperty2
Code	KeywordProperty2
Data Type	char(100)
Mandatory	No

Description of Attribute KeywordProperty2 of the Entity CustomKeyword

A property for the keyword. It can be a query / date field etc

Entity Attribute KeywordProperty3 of the Entity CustomKeyword

Card of Attribute KeywordProperty3 of the Entity CustomKeyword

Name	KeywordProperty3
Code	KeywordProperty3
Data Type	integer
Mandatory	No

Description of Attribute KeywordProperty3 of the Entity CustomKeyword

A property for the keyword. It can be a query / date field etc

Entity Attribute KeywordProperty4 of the Entity CustomKeyword

Card of Attribute KeywordProperty4 of the Entity CustomKeyword

Name	KeywordProperty4
Code	KeywordProperty4
Data Type	double
Mandatory	No

Description of Attribute KeywordProperty4 of the Entity CustomKeyword

A property for the keyword. It can be a query / date field etc

Entity Attribute KeywprdProperty5 of the Entity CustomKeyword

Card of Attribute KeywprdProperty5 of the Entity CustomKeyword

Name	KeywprdProperty5
Code	KeywprdProperty5
Data Type	date
Mandatory	No

Description of Attribute KeywprdProperty5 of the Entity CustomKeyword

A property for the keyword. It can be a query / date field etc