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) | Code250 | ||
| 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 | [ ,Female,Male] | |
| 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 | [Active,Inactive,Terminated] | |
| 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 | CaptionClass: '1,1,1'
|
|
| 37 | Global Dimension 2 Code (Global Dimension 2 Code) | Code20 | CaptionClass: '1,1,2'
|
|
| 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 | CaptionClass: '1,3,1'
|
FlowFilter |
| 43 | Global Dimension 2 Filter (Global Dimension 2 Filter) | Code20 | CaptionClass: '1,3,2'
|
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 [E-Mail] | ||
| 51 | Title (Title) | Text30 | ||
| 52 | Salespers./Purch. Code (Salespers./Purch. Code) | Code20 |
|
|
| 53 | No. Series (No. Series) | Code20 |
|
Editable: No |
| 54 | Last Modified Date Time (Last Modified Date Time) | DateTime | Editable: No | |
| 55 | Employee Posting Group (Employee Posting Group) | Code20 |
|
|
| 56 | Bank Branch No. (Bank Branch No.) | Text20 | ||
| 57 | Bank Account No. (Bank Account No.) | Text30 | ||
| 58 | IBAN (IBAN) | Code50 | ||
| 59 | Balance (Balance) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 60 | SWIFT Code (SWIFT Code) | Code20 | ||
| 80 | Application Method (Application Method) | Option | [Manual,Apply to Oldest] | |
| 140 | Image (Image) | Media [Person] | ||
| 1100 | Cost Center Code (Cost Center Code) | Code20 |
|
|
| 1101 | Cost Object Code (Cost Object Code) | Code20 |
|
|
| 8000 | Id (Id) | GUID |
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 |
| Employee Posting Group (Employee Posting Group) | Employee Posting Group | Code (Code) |
|
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 |
| Detailed Employee Ledger Entry | Employee No. (Employee No.) |
|
1..n |
| Employee | Employee No. Filter (Employee No. Filter) |
|
1..n |
| Employee Absence | Employee No. (Employee No.) |
|
1..n |
| Employee Ledger Entry | Employee No. (Employee No.) |
|
1..n |
| Employee Payment Buffer | 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 |
| G/L Entry | Source No. (Source No.) |
|
1..n |
| Gen. Journal Line | Recipient Bank Account (Recipient Bank Account) |
|
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 |
| Payable Employee Ledger Entry | Employee No. (Employee No.) |
|
1..n |