Employees - codbex/codbex-olympus GitHub Wiki

Employee is someone who is paid to work for someone else.

Employee

Entity Definition

• Entity Type: Primary Entity
• Layout Type: Manage Entities

Field	Type	Length	Null?	Calc?	Ref?	Description
Id	INTEGER		no	-	-
Name	VARCHAR	200	no	-	-	Usually first and last name of the person
Email	VARCHAR	100	-	-	-
Phone	VARCHAR	20	-	-	-
Address	VARCHAR	200	-	-	-
PostCode	VARCHAR	20	-	-	-
City	INTEGER		-	-	yes	Reference to Cities
Country	INTEGER		-	-	yes	Reference to Countries
IBAN	VARCHAR	34	-	-	-	Bank account number
Company	INTEGER		-	-	yes	Reference to Company
Team	INTEGER		-	-	yes	Reference to Team

EmployeePaymentEntry

Entity Definition

• Entity Type: Dependent Entity
• Layout Type: Manage Details Entities

Field	Type	Length	Null?	Calc?	Ref?	Description
Id	INTEGER		no	-	-
Employee	INTEGER		no	-	yes	Reference to Employee
PaymentEntry	INTEGER		no	-	yes	Reference to Payment Entry
Amount	DOUBLE		-	-	-	Amount from the payment assigned to this invoice