Sage EasyPay Data Model

Entity ItemAssignItem

Description of Entity ItemAssignItem

This manages the records of items issued to an employee.

List of all Dependencies of the Entity ItemAssignItem

Relation_385696

Reference

Relation_385697

Reference

Relation_439747

Reference

List of Attributes of the Entity ItemAssignItem

Entity Attribute PersonalSysId of the Entity ItemAssignItem

Card of Attribute PersonalSysId of the Entity ItemAssignItem

Name	PersonalSysId
Code	PersonalSysId
Data Type	integer
Mandatory	No

Description of Attribute PersonalSysId of the Entity ItemAssignItem

This attribute is the system generated identifier. It is blind to the user. It also holds the primary key for the Personal table.

Entity Attribute ItemAssignItemSysId of the Entity ItemAssignItem

Card of Attribute ItemAssignItemSysId of the Entity ItemAssignItem

Name	ItemAssignItemSysId
Code	ItemAssignItemSysId
Data Type	integer
Mandatory	Yes

Description of Attribute ItemAssignItemSysId of the Entity ItemAssignItem

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

Entity Attribute Qty of the Entity ItemAssignItem

Card of Attribute Qty of the Entity ItemAssignItem

Name	Qty
Code	AssignQty
Data Type	integer
Mandatory	No

Description of Attribute Qty of the Entity ItemAssignItem

Shows the quantity of the item batch.

Entity Attribute Unit Amount of the Entity ItemAssignItem

Card of Attribute Unit Amount of the Entity ItemAssignItem

Name	Unit Amount
Code	AssignUnitAmt
Data Type	double
Mandatory	No

Description of Attribute Unit Amount of the Entity ItemAssignItem

Shows the unit amount of the item batch.

Entity Attribute Remarks of the Entity ItemAssignItem

Card of Attribute Remarks of the Entity ItemAssignItem

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

Description of Attribute Remarks of the Entity ItemAssignItem

Store remarks.

Entity Attribute Serial No of the Entity ItemAssignItem

Card of Attribute Serial No of the Entity ItemAssignItem

Name	Serial No
Code	SerialNo
Data Type	char(20)
Mandatory	No

Description of Attribute Serial No of the Entity ItemAssignItem

Stores the serial number for the record.

Entity Attribute Bar Code of the Entity ItemAssignItem

Card of Attribute Bar Code of the Entity ItemAssignItem

Name	Bar Code
Code	BarCode
Data Type	char(20)
Mandatory	No

Description of Attribute Bar Code of the Entity ItemAssignItem

Shows the barcode of the assigned item.

Entity Attribute Expiry Date of the Entity ItemAssignItem

Card of Attribute Expiry Date of the Entity ItemAssignItem

Name	Expiry Date
Code	ExpiryDate
Data Type	date
Mandatory	No

Description of Attribute Expiry Date of the Entity ItemAssignItem

This attribute would record the expiry date for the user to access the system. This expiry date would only be checked upon starting up the system. If there isn't a date set, there is no expiry date for the user to access the system.
It is in the format: DD-MM-YYYY.

Entity Attribute Return Date of the Entity ItemAssignItem

Card of Attribute Return Date of the Entity ItemAssignItem

Name	Return Date
Code	ReturnDate
Data Type	date
Mandatory	No

Name	On Loan
Code	IsOnLoan
Data Type	smallint
Mandatory	No

Name	Waived Date
Code	WaivedDate
Data Type	date
Mandatory	No

Name	Next Issue Date
Code	NextIssueDate
Data Type	date
Mandatory	No

Name	Effective Date
Code	EffectiveDate
Data Type	date
Mandatory	No

Name	Issue Date
Code	IssueDate
Data Type	date
Mandatory	No

Name	Issue By Person
Code	ePortalIssueEmpeeSysId
Data Type	integer
Mandatory	No

Name	Status
Code	ePortalStatus
Data Type	char(20)
Mandatory	No

Description of Attribute Status of the Entity ItemAssignItem

Displays the ePortal status.

Home