-
Notifications
You must be signed in to change notification settings - Fork 0
Employees
Nedelcho Delchev edited this page Jan 28, 2024
·
3 revisions
Employee is someone who is paid to work for someone else.
- 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 |
| 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 |
- 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 |