Connectivity Manual - Employees
Employees
File name: premp.csv
1
| adm_nr
| INT
| N6
| admdat
| Company number
| Mandatory
| -
|
2
| employee_code
| CHAR
| A8
| -
| Employee code
| Mandatory
| -
|
3
| name
| CHAR
| A30
| -
| Name
| -
| -
|
4
| initials
| CHAR
| A10
| -
| Initials
| -
| -
|
5
| address
| CHAR
| A30
| -
| Address
| -
| -
|
6
| zipcode
| CHAR
| A8
| -
| Zip-code
| -
| -
|
7
| city
| CHAR
| A30
| -
| City
| -
| -
|
8
| telephone
| CHAR
| A15
| -
| Telephone number
| -
| -
|
9
| country
| CHAR
| A3
| countr
| Country
| -
| -
|
10
| e_mail
| CHAR
| A60
| -
| E-mail address
| -
| -
|
11
| room
| CHAR
| A10
| -
| Room number
| -
| -
|
12
| extension
| CHAR
| A6
| -
| Extension
| -
| -
|
13
| date_employed
| DATE
| DD/MM/YYYY
| -
| Date employed
| -
| -
|
14
| departure_date
| DATE
| DD/MM/YYYY
| -
| Departure date
| -
| -
|
15
| contract_time
| DEC
| N3,2
| -
| Contract time
| -
| -
|
16
| job_level
| INT
| N2
| -
| Job level
| -
| -
|
17
| capacity
| DEC
| N4,2
| -
| Capacity
| -
| -
|
18
| curr_code
| CHAR
| A3
| curren
| Currency code
| -
| Default currency
|
19
| rate_int
| DEC
| N9,2
| -
| Internal rate
| -
| -
|
20
| rate_ext
| DEC
| N9,2
| -
| External rate
| -
| -
|
21
| fiscal_id
| CHAR
| A9
| -
| Fiscal ID
| -
| -
|
22
| cost_center
| CHAR
| A8
| ccent
| Cost center
| -
| -
|
23
| department_code
| CHAR
| A8
| prdep
| Department code
| -
| -
|
24
| position_code
| CHAR
| A8
| prpos
| Postition code
| -
| -
|
25
| unit_code
| CHAR
| A8
| prunit
| Unit code
| -
| -
|
26
| euserid
| CHAR
| A12
| euser
| User ID
| -
| -
|
27
| block
| LOG
| Y/N
| -
| Block
| -
| No
|
28
| search_code
| CHAR
| A10
| -
| Search code
| -
| - |
29
| lang_code
| CHAR
| A3
| lang
| Language
| as of 3.51.1
| -
|
30
| house_nr
| INT
| N6
| -
| House number
| as of 3.51.1
| -
|
31
| house_nr_addition
| CHAR
| A8
| -
| House number addition
| as of 3.51.1 |
- |
Connectivity Manual - Contents
> Data import > Exact Project
> Employees
Main Category: |
Support Product Know How |
Document Type: |
Support - On-line help |
Category: |
On-line help files |
Security level: |
All - 0 |
Sub category: |
Details |
Document ID: |
11.577.796 |
Assortment: |
Exact Financials (v3)
|
Date: |
16-01-2007 |
Release: |
|
Attachment: |
|
Disclaimer |