Selected category
|
Selected base table
|
Selected tables (Available tables)
|
Selected fields
|
Order
|
HR - History
|
Payment history
|
Payment history
|
Earning / Deduction code*
|
N/A
|
Employee number
|
6
|
Accounting date
|
8
|
Payment date
|
9
|
Transaction quantity
|
10
|
Transaction amount
|
11
|
Employment and compensation
|
Employee status*
|
N/A
|
Employment and compensation > Personal information
|
Complete name
|
7
|
Company
|
Company*
|
N/A
|
Company short description
|
1
|
Divisions
|
Division
|
2
|
Division description
|
3
|
Services
|
Service
|
4
|
Service description
|
5
|
* These fields have been selected as “filters only” (by clicking on the  icon during creation). They are used to filter data and do not appear on the report.
Default filters:
(Conditions)
|
Filters
|
And / Or
|
Field(s) and condition(s) applied
|
Criteria
|
Values
|
1
|
|
|
Employee status (Employm./compens.)
|
Equal (=)
|
Active
|
2
|
And
|
|
Earning code / deduction (Payment hist.)
|
Equal (=)
|
G43
|
3
|
And
|
|
Accounting date (Payment hist.)
|
Larger or equal (>=)
|
|
|
And
|
Accounting date (Payment hist.)
|
Smaller or equal (<=)
|
|
4
|
And
|
|
Company (Company)
|
Equal (=)
|
|
Groups:
|
Selected fields
|
Company short description (Company)
|
Division (Divisions)
|
Service (Services)
|
Sort:
|
Fields
|
Order
|
Division (Divisions)
|
Ascending
|
Service (Services)
|
Ascending
|
Employee number (Payment hist.)
|
Ascending
|
Equation :
|
Fields
|
Equation
|
Transaction quantity (Payment hist.)
|
Amount
|
Transaction amount (Payment hist.)
|
Amount
|
1 During creation, this field was left blank.
2 During creation, the field has been left blank and during the production of the report, we have selected the required company.
|
