|
|
Connectivity Manual - 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 > Data import > Available import formats > 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: |
18.325.014 |
| Assortment: |
Exact Financials
|
Date: |
03-10-2015 |
| Release: |
|
Attachment: |
|
| Disclaimer |
|
|