Entity Item

Description of Entity Item

This keeps track of items issued to an employee as part of the job, e.g. access keys, tools etc. This feature is configured primarily for physical objects, however you are not restricted to using it as such, as the minimum required information is the Item ID.


List of all Dependencies of the Entity Item

Name

Code

Class Name

Relation_385697

Relation_385697

Reference

Relation_389007

Relation_389007

Reference

Relation_534085

Relation_534085

Reference

Relation_389005

Relation_389005

Reference

Relation_389014

Relation_389014

Reference


List of Attributes of the Entity Item

Name

Code

Organisation Code

OrganisationCode

Item ID

ItemId

Name

ItemName

Per Unit Measure

PerUnitMeasure

Remarks

Remarks

Unit Amount

UnitAmt

Default Assign Qty

DefAssignQty

Model No

ModelNo


Entity Attribute Organisation Code of the Entity Item

Card of Attribute Organisation Code of the Entity Item

Name

Organisation Code

Code

OrganisationCode

Data Type

char(20)

Mandatory

No


Description of Attribute Organisation Code of the Entity Item

Shows the organisation code. This code is the same as the reference number. It is also the primary key for the Organisation table.


Entity Attribute Item ID of the Entity Item

Card of Attribute Item ID of the Entity Item

Name

Item ID

Code

ItemId

Data Type

char(20)

Mandatory

Yes


Description of Attribute Item ID of the Entity Item

Shows the identity of the item. This also holds the primary key for the Item table.


Entity Attribute Name of the Entity Item

Card of Attribute Name of the Entity Item

Name

Name

Code

ItemName

Data Type

char(100)

Mandatory

No


Description of Attribute Name of the Entity Item

Shows the name of the item.


Entity Attribute Per Unit Measure of the Entity Item

Card of Attribute Per Unit Measure of the Entity Item

Name

Per Unit Measure

Code

PerUnitMeasure

Data Type

char(20)

Mandatory

No


Description of Attribute Per Unit Measure of the Entity Item

Stores the measurements for every unit.


Entity Attribute Remarks of the Entity Item

Card of Attribute Remarks of the Entity Item

Name

Remarks

Code

Remarks

Data Type

char(100)

Mandatory

No


Description of Attribute Remarks of the Entity Item

Store remarks.


Entity Attribute Unit Amount of the Entity Item

Card of Attribute Unit Amount of the Entity Item

Name

Unit Amount

Code

UnitAmt

Data Type

double

Mandatory

No


Description of Attribute Unit Amount of the Entity Item

Stores the unit amount for the item.


Entity Attribute Default Assign Qty of the Entity Item

Card of Attribute Default Assign Qty of the Entity Item

Name

Default Assign Qty

Code

DefAssignQty

Data Type

integer

Mandatory

No


Description of Attribute Default Assign Qty of the Entity Item

Shows the default assigned quantity of the item.


Entity Attribute Model No of the Entity Item

Card of Attribute Model No of the Entity Item

Name

Model No

Code

ModelNo

Data Type

char(20)

Mandatory

No


Description of Attribute Model No of the Entity Item

Shows the model number of the item.