Entity ItemBAssgn

Description of Entity ItemBAssgn

A batch ID is a convenient way to group together sets of items that need to be issued to an employee. The Items tab is the same as the single record variant. The additional is the General and the Assign Employee tab, for creating batch IDs and assigning them to employees respectively.


List of all Dependencies of the Entity ItemBAssgn

Name

Code

Class Name

Relation_439799

Relation_439799

Reference

Relation_439798

Relation_439798

Reference

Relation_534085

Relation_534085

Reference


List of Attributes of the Entity ItemBAssgn

Name

Code

Batch ID

ItemBatchId

ItemBAssignSysId

ItemBAssignSysId

Qty

AssignQty

Unit Amount

AssignUnitAmt

Remarks

Remarks

Expiry Date

ExpiryDate

On Loan

IsOnLoan

Waived Date

WaivedDate

Next Issue Date

NextIssueDate

Effective Date

EffectiveDate

Issue Date

IssueDate

Issue By Person

IssueByEmpeeSysId


Entity Attribute Batch ID of the Entity ItemBAssgn

Card of Attribute Batch ID of the Entity ItemBAssgn

Name

Batch ID

Code

ItemBatchId

Data Type

char(20)

Mandatory

No


Description of Attribute Batch ID of the Entity ItemBAssgn

Shows the identity of the item batch. This is the primary key for the ItemBatch table.


Entity Attribute ItemBAssignSysId of the Entity ItemBAssgn

Card of Attribute ItemBAssignSysId of the Entity ItemBAssgn

Name

ItemBAssignSysId

Code

ItemBAssignSysId

Data Type

integer

Mandatory

Yes


Description of Attribute ItemBAssignSysId of the Entity ItemBAssgn

A system generated identity. It is blind to the user. It also acts as a primary key for the ItemBAssgn table.


Entity Attribute Qty of the Entity ItemBAssgn

Card of Attribute Qty of the Entity ItemBAssgn

Name

Qty

Code

AssignQty

Data Type

integer

Mandatory

No


Description of Attribute Qty of the Entity ItemBAssgn

Shows the quantity of the item batch.


Entity Attribute Unit Amount of the Entity ItemBAssgn

Card of Attribute Unit Amount of the Entity ItemBAssgn

Name

Unit Amount

Code

AssignUnitAmt

Data Type

double

Mandatory

No


Description of Attribute Unit Amount of the Entity ItemBAssgn

Shows the unit amount of the item batch.


Entity Attribute Remarks of the Entity ItemBAssgn

Card of Attribute Remarks of the Entity ItemBAssgn

Name

Remarks

Code

Remarks

Data Type

char(100)

Mandatory

No


Description of Attribute Remarks of the Entity ItemBAssgn

Store remarks.


Entity Attribute Expiry Date of the Entity ItemBAssgn

Card of Attribute Expiry Date of the Entity ItemBAssgn

Name

Expiry Date

Code

ExpiryDate

Data Type

date

Mandatory

No


Description of Attribute Expiry Date of the Entity ItemBAssgn

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 On Loan of the Entity ItemBAssgn

Card of Attribute On Loan of the Entity ItemBAssgn

Name

On Loan

Code

IsOnLoan

Data Type

smallint

Mandatory

No


Description of Attribute On Loan of the Entity ItemBAssgn

Indicates if the item is on loan, in the form of a checkbox.


Entity Attribute Waived Date of the Entity ItemBAssgn

Card of Attribute Waived Date of the Entity ItemBAssgn

Name

Waived Date

Code

WaivedDate

Data Type

date

Mandatory

No


Description of Attribute Waived Date of the Entity ItemBAssgn

Stores the date where the item batch is not in use.
It is in the format: DD-MM-YYYY.


Entity Attribute Next Issue Date of the Entity ItemBAssgn

Card of Attribute Next Issue Date of the Entity ItemBAssgn

Name

Next Issue Date

Code

NextIssueDate

Data Type

date

Mandatory

No


Description of Attribute Next Issue Date of the Entity ItemBAssgn

Stores the date of the next issue for the item.
It is in the format: DD-MM-YYYY.


Entity Attribute Effective Date of the Entity ItemBAssgn

Card of Attribute Effective Date of the Entity ItemBAssgn

Name

Effective Date

Code

EffectiveDate

Data Type

date

Mandatory

No


Description of Attribute Effective Date of the Entity ItemBAssgn

Shows the effective date of the assigned item batch.
It is in the format: DD-MM-YYYY.


Entity Attribute Issue Date of the Entity ItemBAssgn

Card of Attribute Issue Date of the Entity ItemBAssgn

Name

Issue Date

Code

IssueDate

Data Type

date

Mandatory

No


Description of Attribute Issue Date of the Entity ItemBAssgn

Shows the issue date of the assigned item.
It is in the format: DD-MM-YYYY.


Entity Attribute Issue By Person of the Entity ItemBAssgn

Card of Attribute Issue By Person of the Entity ItemBAssgn

Name

Issue By Person

Code

IssueByEmpeeSysId

Data Type

integer

Mandatory

No


Description of Attribute Issue By Person of the Entity ItemBAssgn

Shows who issued the item batch.