Diagrams

Table

Human Resource Unit of Measure

DynamicsDocs.comHuman Resource Unit of Measure«Table 5220»Human Resource Unit of MeasureCode [PK,NN]Qty. per Unit of Measure«Table 5206»Cause of AbsenceCode [PK,NN]DescriptionUnit of Measure CodeTotal Absence [Base]Global Dimension 1 FilterGlobal Dimension 2 FilterEmployee No. FilterDate Filter«Table 5207»Employee AbsenceEmployee No. [NN]Entry No. [PK]From DateTo DateCause of Absence CodeDescriptionQuantityUnit of Measure CodeCommentQuantity [Base]Qty. per Unit of Measure«Table 5218»Human Resources SetupPrimary Key [PK]Employee Nos.Base Unit of Measure«Table 204»Unit of MeasureCode [PK,NN]DescriptionInternational Standard Code<Code><Unit of Measure Code><Unit of Measure Code><Base Unit of Measure><Cause of Absence Code>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Code (Code) Code10 NotBlank: Yes
2 Qty. per Unit of Measure (Qty. per Unit of Measure) Decimal (0:5)

Keys

# Fields
0 Code (Code) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Code (Code) Unit of Measure Code (Code) 1..1

Table Relations From Other Tables

From Table From Field
Cause of Absence Unit of Measure Code (Unit of Measure Code) 1..n
Employee Absence Unit of Measure Code (Unit of Measure Code) 1..n
Human Resources Setup Base Unit of Measure (Base Unit of Measure) 1..n