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 352»Default DimensionTable ID [PK,NN]No. [PK]Dimension Code [PK,NN]Dimension Value CodeValue Posting; [,Code Mandatory,Same C...Table CaptionMulti Selection Action; [,Change,Delet...«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 5208»Human Resource Comment LineTable Name; [Employee,Alternative Addr...No. [PK]Table Line No. [PK]Alternative Address Code [PK]Line No. [PK]DateCodeComment«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 5219»HR Confidential Comment LineTable Name; [Confidential Information]...No. [PK]Code [PK]Table Line No. [PK]Line No. [PK]DateComment«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 9»Country/RegionCode [PK,NN]NameEU Country/Region CodeIntrastat CodeAddress Format; [Post Code+City,City+P...Contact Address Format; [First,After C...VAT Scheme«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 349»Dimension ValueDimension Code [PK,NN]Code [PK,NN]NameDimension Value Type; [Standard,Headin...TotalingBlockedConsolidation CodeIndentationGlobal Dimension No.Map-to IC Dimension CodeMap-to IC Dimension Value CodeDimension Value ID«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 13»Salesperson/PurchaserCode [PK,NN]NameCommission %ImageGlobal Dimension 1 CodeGlobal Dimension 2 CodeE-MailPhone No.Next To-do DateNo. of OpportunitiesEstimated Value [LCY]Calcd. Current Value [LCY]Date FilterNo. of InteractionsCost [LCY]Duration [Min.]Job TitleAction Taken Filter; [,Next,Previous,U...Sales Cycle FilterSales Cycle Stage FilterProbability % FilterCompleted % FilterAvg. Estimated Value [LCY]Avg.Calcd. Current Value [LCY]Contact FilterContact Company FilterCampaign FilterEstimated Value FilterCalcd. Current Value FilterChances of Success % FilterTo-do Status Filter; [Not Started,In P......«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«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><Country/Region Code><Manager No.><Employee No. Filter><Emplymt. Contract Code><Statistics Group Code><Cause of Inactivity Code><Grounds for Term. Code><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Resource No.><Cause of Absence Filter><Employee No. Filter><Salespers./Purch. Code><No. Series><Cost Center Code><Cost Object Code><No.><Employee No.><Employee No.><Relative's Employee No.><Employee No.><No.><Employee No.><Employee No.><No.><Responsible Employee><No.><No.><No.><Dimension Value Code><Country/Region Code><No.><Alternative Address Code><No.><No.><Global Dimension 1 Filter><Global Dimension 2 Filter><Cause of Absence Code><No.><No.><No.><Global Dimension 1 Code><Global Dimension 2 Code><Component of Main Asset><No. Series><Country/Region Code><Country/Region Code><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Code><Global Dimension 2 Code><No. Series>

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 Code30
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
51 Title Text30
52 Salespers./Purch. Code Code10
53 No. Series Code10 Editable: No
140 Image Media [Person]
1100 Cost Center Code Code20
1101 Cost Object Code Code20

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
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
Employee Employee No. Filter 1..n
Employee Absence Employee No. 1..n
Employee Qualification Employee No. 1..n
Employee Relative Relative's Employee No. 1..n
Fixed Asset Responsible Employee 1..n
HR Confidential Comment Line No. 1..n
Human Resource Comment Line No. 1..n
Misc. Article Information Employee No. 1..n