RE_SIMULATEACC - Detailed Cost report (ProReport II Export)
To Host
The primary unique key for the record is
Field 56 Department Id
Field 58 Group Id
Field 52 Account Id
Field 1 Employee Number
Field 64 Date
| Field | Description | Data Type | Mandatory | Comment |
|---|---|---|---|---|
| 1 | Employee Number | Text | ||
| 2 | Card Number | Text | ||
| 3 | First Name | Text | ||
| 4 | Surname | Text | ||
| 5 | Initials | Text | ||
| 6 | Phone Extension Number | Text | ||
| 7 | First Registration Day | Date | ||
| 8 | Terminal Rights | Text | ||
| 9 | Home Activity ID | Text | ||
| 10 | Home Project ID | Text | ||
| 11 | Qualifications | Text | ||
| 12 | Info 1 | Text | ||
| 13 | Info 2 | Text | ||
| 14 | Info 3 | Text | ||
| 15 | Info 4 | Text | ||
| 16 | Info 5 | Text | ||
| 17 | Terminal Area ID | Text | ||
| 18 | Inactive | Logical | ||
| 19 | Default Workcenter ID | Text | ||
| 20 | Date of Birth | Date | ||
| 21 | Date of Employment | Date | ||
| 22 | Working Place | Text | ||
| 23 | Division ID | Text | ||
| 24 | Division Description | Text | ||
| 25 | Gender | Text | ||
| 26 | Nationality | Text | ||
| 27 | Education | Text | ||
| 28 | Organisation | Text | ||
| 29 | Job Description | Text | ||
| 30 | Period Profile ID | Text | ||
| 31 | Period Profile Description | Text | ||
| 32 | Attendance Profile ID | Text | ||
| 33 | Attendance Profile Description | Text | ||
| 34 | Payroll Code Profile ID | Text | ||
| 35 | Payroll Code Profile Description | Text | ||
| 36 | Category ID | Text | ||
| 37 | Category Description | Text | ||
| 38 | Employee Home Department ID | Text | ||
| 39 | Employee Home Department Description | Text | ||
| 40 | Employee Current Department ID | Text | ||
| 41 | Employee Current Department Description | Text | ||
| 42 | Employee Home Group ID | Text | ||
| 43 | Employee Home Group Description | Text | ||
| 44 | Employee Current Group ID | Text | ||
| 45 | Employee Current Group Description | Text | ||
| 46 | Approval Group ID | Text | ||
| 47 | Approval Group Description | Text | ||
| 48 | Age Group ID (Internal) | Integer | ||
| 49 | Age Group Description | Text | ||
| 50 | Seniority Group ID (Internal) | Integer | ||
| 51 | Seniority Group Description | Text | ||
| 52 | Account ID | Text | ||
| 53 | Account Description | Text | ||
| 54 | Account Group Id | Text | ||
| 55 | Account Group Description | Text | ||
| 56 | Department Id | Text | ||
| 57 | Department Description | Text | ||
| 58 | Group Id | Text | ||
| 59 | Group Description | Text | ||
| 60 | Account Balance (seconds) | Integer | ||
| 61 | Account Balance (pieces) | Decimal number | ||
| 62 | Account balance (days) | Decimal number | ||
| 63 | Cost | Decimal number | ||
| 64 | Date | Date | ||
| 65 | Report From Time | Date and time | ||
| 66 | Report To Time | Date and time |