Sage EasyPay Data Model

Entity ItemAssignAttr

Description of Entity ItemAssignAttr

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 ItemAssignAttr

Relation_385696

Reference

Relation_389010

Reference

List of Attributes of the Entity ItemAssignAttr

Entity Attribute ItemAssignAttrSysId of the Entity ItemAssignAttr

Card of Attribute ItemAssignAttrSysId of the Entity ItemAssignAttr

Name	ItemAssignAttrSysId
Code	ItemAssignAttrSysId
Data Type	integer
Mandatory	Yes

Description of Attribute ItemAssignAttrSysId of the Entity ItemAssignAttr

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

Entity Attribute Type of the Entity ItemAssignAttr

Card of Attribute Type of the Entity ItemAssignAttr

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

Description of Attribute Type of the Entity ItemAssignAttr

Shows the attribute type of the item.

Entity Attribute ItemAttrStrValue of the Entity ItemAssignAttr

Card of Attribute ItemAttrStrValue of the Entity ItemAssignAttr

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

Description of Attribute ItemAttrStrValue of the Entity ItemAssignAttr

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.