Example: Key Fields 
Example: Key Fields
You have defined two field objects, Bank Number (BANKL) and Account Number (BANKN) as key fields in the table object containing the bank transfer amounts.
A bank transfer must exist for each account number so that change validation function can work with the key field function successfully.
Payroll Period 01 |
Payroll Period 02 | ||||||
BANKL |
BANKN |
AMOUNT |
BANKL |
BANKN |
AMOUNT | ||
Key field |
Key field |
Key field |
Key field |
||||
672922 |
700100 |
900.00 |
|
672922 |
700100 |
950.00 | |
672922 |
700101 |
500.00 |
|||||
672922 |
700102 |
400.00 |
|
672922 |
700102 |
400.00 | |
|
672922 |
700103 |
100.00 | |||||
|
672922 |
600500 |
500.00 | |||||
The Following Datasets are Exported:
BANKL |
BANKN |
AMOUNT |
Legend |
Key field |
Key field |
||
672922 |
700100 |
950.00 |
Change in amount |
672922 |
700101 |
<…< |
if delimitation active |
672922 |
700103 |
100.00 |
Only in period 02 |
672922 |
600500 |
500,00 |
Only in period 02 |
The Bank Number (BANKL) and Account Number (BANKN) field objects are key fields. The content of these fields is exported, not the "<" character (delimitation).