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 Group«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 %Global 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...Closed To-do Filter...«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. (No.) Code20
2 First Name (First Name) Text30
3 Middle Name (Middle Name) Text30
4 Last Name (Last Name) Text30
5 Initials (Initials) Text30
6 Job Title (Job Title) Text30
7 Search Name (Search Name) Code30
8 Address (Address) Text50
9 Address 2 (Address 2) Text50
10 City (City) Text30
11 Post Code (Post Code) Code20
12 County (County) Text30
13 Phone No. (Phone No.) Text30 [Phone No.]
14 Mobile Phone No. (Mobile Phone No.) Text30 [Phone No.]
15 E-Mail (E-Mail) Text80 [E-Mail]
16 Alt. Address Code (Alt. Address Code) Code10
17 Alt. Address Start Date (Alt. Address Start Date) Date
18 Alt. Address End Date (Alt. Address End Date) Date
19 Picture (Picture) BLOB [Bitmap]
20 Birth Date (Birth Date) Date
21 Social Security No. (Social Security No.) Text30
22 Union Code (Union Code) Code10
23 Union Membership No. (Union Membership No.) Text30
24 Gender (Gender) Option
25 Country/Region Code (Country/Region Code) Code10
26 Manager No. (Manager No.) Code20
27 Emplymt. Contract Code (Emplymt. Contract Code) Code10
28 Statistics Group Code (Statistics Group Code) Code10
29 Employment Date (Employment Date) Date
31 Status (Status) Option
32 Inactive Date (Inactive Date) Date
33 Cause of Inactivity Code (Cause of Inactivity Code) Code10
34 Termination Date (Termination Date) Date
35 Grounds for Term. Code (Grounds for Term. Code) Code10
36 Global Dimension 1 Code (Global Dimension 1 Code) Code20
37 Global Dimension 2 Code (Global Dimension 2 Code) Code20
38 Resource No. (Resource No.) Code20
39 Comment (Comment) Boolean Editable: No
FlowField
40 Last Date Modified (Last Date Modified) Date Editable: No
41 Date Filter (Date Filter) Date FlowFilter
42 Global Dimension 1 Filter (Global Dimension 1 Filter) Code20 FlowFilter
43 Global Dimension 2 Filter (Global Dimension 2 Filter) Code20 FlowFilter
44 Cause of Absence Filter (Cause of Absence Filter) Code10 FlowFilter
45 Total Absence (Base) (Total Absence (Base)) Decimal (0:5) Editable: No
FlowField
46 Extension (Extension) Text30
47 Employee No. Filter (Employee No. Filter) Code20 FlowFilter
48 Pager (Pager) Text30
49 Fax No. (Fax No.) Text30
50 Company E-Mail (Company E-Mail) Text80
51 Title (Title) Text30
52 Salespers./Purch. Code (Salespers./Purch. Code) Code10
53 No. Series (No. Series) Code10 Editable: No
1100 Cost Center Code (Cost Center Code) Code20
1101 Cost Object Code (Cost Object Code) Code20

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field
Alternative Address Employee No. (Employee No.) 1..n
Cause of Absence Employee No. Filter (Employee No. Filter) 1..n
Confidential Information Employee No. (Employee No.) 1..n
Default Dimension No. (No.) 1..n
Employee Employee No. Filter (Employee No. Filter) 1..n
Employee Absence Employee No. (Employee No.) 1..n
Employee Qualification Employee No. (Employee No.) 1..n
Employee Relative Relative's Employee No. (Relative's Employee No.) 1..n
Fixed Asset Responsible Employee (Responsible Employee) 1..n
HR Confidential Comment Line No. (No.) 1..n
Human Resource Comment Line No. (No.) 1..n
Misc. Article Information Employee No. (Employee No.) 1..n