Diagrams


Table

Employee Absence

Fields

# Name Type
1 Employee No. Code20 NotBlank: Yes
2 Entry No. Integer
3 From Date Date
4 To Date Date
5 Cause of Absence Code Code10
6 Description Text50
7 Quantity Decimal (0:5)
8 Unit of Measure Code Code10
11 Comment Boolean Editable: No
FlowField
12 Quantity (Base) Decimal (0:5)
13 Qty. per Unit of Measure Decimal (0:5) Editable: No

Keys

# Fields
0 Entry No. Clustered: Yes
1 Employee No.,From Date
2 Employee No.,Cause of Absence Code,From Date
3 Cause of Absence Code,From Date
4 From Date,To Date

Table Relations To Other Tables

Field Related Table Related Field
Cause of Absence Code Cause of Absence Code 1..n
Employee No. Employee No. 1..n
Unit of Measure Code Human Resource Unit of Measure Code 1..n

Table Relations From Other Tables

From Table From Field
Human Resource Comment Line No. 1..n