Diagrams


Table

Employee

DynamicsDocs.comEmployee«Table 5200»EmployeeNo. [PK]First NameMiddle NameLast NameInitialsJob TitleSearch NameAddressAddress 2CityPost CodeCountyPhone No.Mobile Phone No.E-MailAlt. Address CodeAlt. Address Start DateAlt. Address End DatePictureBirth DateSocial Security No.Union CodeUnion Membership No.Gender; [,Female,Male]Country/Region CodeManager No.Emplymt. Contract CodeStatistics Group CodeEmployment DateStatus; [Active,Inactive,Terminated]Inactive Date...«Table 5201»Alternative AddressEmployee No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityPost CodeCountyPhone No.Fax No.E-MailCommentCountry/Region Code«Table 5203»Employee QualificationEmployee No. [PK,NN]Line No. [PK]Qualification CodeFrom DateTo DateType; [,Internal,External,Previous Pos...DescriptionInstitution/CompanyCostCourse GradeEmployee Status; [Active,Inactive,Term...CommentExpiration Date«Table 5205»Employee RelativeEmployee No. [PK,NN]Line No. [PK]Relative CodeFirst NameMiddle NameLast NameBirth DatePhone No.Relative's Employee No.Comment«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 5214»Misc. Article InformationEmployee No. [PK,NN]Misc. Article Code [PK,NN]Line No. [PK]DescriptionFrom DateTo DateIn UseCommentSerial No.«Table 5216»Confidential InformationEmployee No. [PK,NN]Confidential Code [PK,NN]Line No. [PK,NN]DescriptionComment«Table 5600»Fixed AssetNo. [PK]DescriptionSearch DescriptionDescription 2FA Class CodeFA Subclass CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeFA Location CodeVendor No.Main Asset/Component; [,Main Asset,Com...Component of Main AssetBudgeted AssetWarranty DateResponsible EmployeeSerial No.Last Date ModifiedInsuredCommentBlockedPictureMaintenance Vendor No.Under MaintenanceNext Service DateInactiveFA Posting Date FilterNo. SeriesFA Posting GroupAcquiredImage...«Table 5209»UnionCode [PK,NN]NameAddressPost CodeCityPhone No.No. of Members EmployedName 2Address 2CountyFax No.E-MailHome PageCountry/Region Code«Table 5211»Employment ContractCode [PK,NN]DescriptionNo. of Contracts«Table 5212»Employee Statistics GroupCode [PK,NN]Description«Table 5210»Cause of InactivityCode [PK,NN]Description«Table 5217»Grounds for TerminationCode [PK,NN]Description«Table 156»ResourceNo. [PK]Type; [Person,Machine]NameSearch NameName 2AddressAddress 2CitySocial Security No.Job TitleEducationContract ClassEmployment DateResource Group No.Global Dimension 1 CodeGlobal Dimension 2 CodeBase Unit of MeasureDirect Unit CostIndirect Cost %Unit CostProfit %Price/Profit Calculation; [Profit=Pric...Unit PriceVendor No.Last Date ModifiedCommentBlockedDate FilterUnit of Measure FilterCapacityQty. on Order [Job]...«Table 5221»Employee Posting GroupCode [PK]Payables Account«Table 1112»Cost CenterCode [PK,NN]NameCost Subtype; [,Service Cost Center,Au...Cost Type FilterDate FilterNet ChangeBalance at DateBalance to AllocateResponsible PersonSorting OrderCommentLine Type; [Cost Center,Heading,Total,...BlockedNew PageBlank LineIndentationTotaling«Table 1113»Cost ObjectCode [PK,NN]NameCost Type FilterDate FilterNet ChangeBalance at DateSorting OrderCommentLine Type; [Cost Object,Heading,Total,...BlockedNew PageBlank LineIndentationTotaling<Alt. Address Code><Employee No.><Union Code><Manager No.><Employee No. Filter><Emplymt. Contract Code><Statistics Group Code><Cause of Inactivity Code><Grounds for Term. Code><Resource No.><Cause of Absence Filter><Employee No. Filter><Employee Posting Group><Cost Center Code><Cost Object Code><Employee No.><Employee No.><Relative's Employee No.><Employee No.><Employee No.><Employee No.><Responsible Employee><Cause of Absence Code><Component of Main Asset>

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

Fields

# Name Type
1 No. Code20
2 First Name Text30
3 Middle Name Text30
4 Last Name Text30
5 Initials Text30
6 Job Title Text30
7 Search Name Code250
8 Address Text50
9 Address 2 Text50
10 City Text30
11 Post Code Code20
12 County Text30
13 Phone No. Text30 [Phone No.]
14 Mobile Phone No. Text30 [Phone No.]
15 E-Mail Text80 [E-Mail]
16 Alt. Address Code Code10
17 Alt. Address Start Date Date
18 Alt. Address End Date Date
19 Picture BLOB [Bitmap]
20 Birth Date Date
21 Social Security No. Text30
22 Union Code Code10
23 Union Membership No. Text30
24 Gender Option
25 Country/Region Code Code10
26 Manager No. Code20
27 Emplymt. Contract Code Code10
28 Statistics Group Code Code10
29 Employment Date Date
31 Status Option
32 Inactive Date Date
33 Cause of Inactivity Code Code10
34 Termination Date Date
35 Grounds for Term. Code Code10
36 Global Dimension 1 Code Code20
37 Global Dimension 2 Code Code20
38 Resource No. Code20
39 Comment Boolean Editable: No
FlowField
40 Last Date Modified Date Editable: No
41 Date Filter Date FlowFilter
42 Global Dimension 1 Filter Code20 FlowFilter
43 Global Dimension 2 Filter Code20 FlowFilter
44 Cause of Absence Filter Code10 FlowFilter
45 Total Absence (Base) Decimal (0:5) Editable: No
FlowField
46 Extension Text30
47 Employee No. Filter Code20 FlowFilter
48 Pager Text30
49 Fax No. Text30
50 Company E-Mail Text80 [E-Mail]
51 Title Text30
52 Salespers./Purch. Code Code20
53 No. Series Code20 Editable: No
54 Last Modified Date Time DateTime Editable: No
55 Employee Posting Group Code20
56 Bank Branch No. Text20
57 Bank Account No. Text30
58 IBAN Code50
59 Balance Decimal Editable: No
FlowField
60 SWIFT Code Code20
80 Application Method Option
140 Image Media [Person]
1100 Cost Center Code Code20
1101 Cost Object Code Code20
8000 Id GUID

Keys

# Fields
0 No. Clustered: Yes
1 Search Name
2 Status,Union Code
3 Status,Emplymt. Contract Code
4 Last Name,First Name,Middle Name

Table Relations To Other Tables

Field Related Table Related Field
Alt. Address Code Alternative Address Code 1..n
Cause of Absence Filter Cause of Absence Code 1..n
Cause of Inactivity Code Cause of Inactivity Code 1..n
Cost Center Code Cost Center Code 1..n
Cost Object Code Cost Object Code 1..n
Country/Region Code Country/Region Code 1..n
Global Dimension 2 Filter Dimension Value Code 1..n
Employee No. Filter Employee No. 1..n
Employee Posting Group Employee Posting Group Code 1..n
Statistics Group Code Employee Statistics Group Code 1..n
Emplymt. Contract Code Employment Contract Code 1..n
Grounds for Term. Code Grounds for Termination Code 1..n
No. Series No. Series Code 1..n
Resource No. Resource 1..n
Salespers./Purch. Code Salesperson/Purchaser Code 1..n
Union Code Union Code 1..n

Table Relations From Other Tables

From Table From Field
Alternative Address Employee No. 1..n
Cause of Absence Employee No. Filter 1..n
Confidential Information Employee No. 1..n
Default Dimension No. 1..n
Detailed Employee Ledger Entry Employee No. 1..n
Employee Employee No. Filter 1..n
Employee Absence Employee No. 1..n
Employee Ledger Entry Employee No. 1..n
Employee Payment Buffer Employee No. 1..n
Employee Qualification Employee No. 1..n
Employee Relative Relative's Employee No. 1..n
Fixed Asset Responsible Employee 1..n
G/L Entry Source No. 1..n
Gen. Journal Line Recipient Bank Account 1..n
HR Confidential Comment Line No. 1..n
Human Resource Comment Line No. 1..n
Misc. Article Information Employee No. 1..n
Payable Employee Ledger Entry Employee No. 1..n