Sage EasyPay Data Model

Entity ItemAttrValue

Description of Entity ItemAttrValue

Each attribute can have more than 1 value and these values can be selected accordingly for the employee/ However each attribute can be only of 1 type: plain text (String), numbers (numeric) or date.
If there is more than 1 kind of this item, e.g. different models, you can either set it up as 1 type but with different models stored as attributes.

List of all Dependencies of the Entity ItemAttrValue

Relation_389002

Reference

Relation_389007

Reference

List of Attributes of the Entity ItemAttrValue

Entity Attribute ItemAttrValueSysId of the Entity ItemAttrValue

Card of Attribute ItemAttrValueSysId of the Entity ItemAttrValue

Name	ItemAttrValueSysId
Code	ItemAttrValueSysId
Data Type	integer
Mandatory	Yes

Description of Attribute ItemAttrValueSysId of the Entity ItemAttrValue

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

Entity Attribute Type of the Entity ItemAttrValue

Card of Attribute Type of the Entity ItemAttrValue

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

Description of Attribute Type of the Entity ItemAttrValue

Shows the attribute type of the item.

Entity Attribute ItemAttrStrValue of the Entity ItemAttrValue

Card of Attribute ItemAttrStrValue of the Entity ItemAttrValue

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

Description of Attribute ItemAttrStrValue of the Entity ItemAttrValue

Shows the item value of the string attribute. String is a data type which includes letters, digits and special characters. It is a sequence of characters.