HRTKPERS
Employee Custom Details Data (TKPE)
| Seq | Field Name | Type | Length | Dec | Description |
|---|---|---|---|---|---|
|
1 |
U_CHADATE |
D |
8 |
0 |
Change Date |
|
2 |
U_COMPANY |
C |
3 |
0 |
Employer Code |
|
3 |
U_EMPNO |
C |
9 |
0 |
Employee ID |
Note: The database structure for this file varies based on the custom fields you have added for your custom pages.
TKFIELD
Custom Details Field Definitions (TKFLD)
| Seq | Field Name | Type | Length | Dec | Description |
|---|---|---|---|---|---|
|
1 |
D_ALIAS |
C |
8 |
0 |
Field Alias |
|
2 |
D_CHGLEVEL |
C |
10 |
0 |
Change Level |
|
3 |
D_DEC |
N |
3 |
0 |
Decimal Places |
|
4 |
D_DESC |
C |
40 |
0 |
Field Description |
|
5 |
D_DOSCOMP |
C |
3 |
0 |
DOS Company Code |
|
6 |
D_FIELD |
C |
10 |
0 |
Field Name |
|
7 |
D_FILE |
C |
8 |
0 |
File Name |
|
8 |
D_FORMULA |
M |
10 |
0 |
Formula |
|
9 |
D_LEN |
N |
3 |
0 |
Field Length |
|
10 |
D_LEVEL |
N |
2 |
0 |
RR Security Level |
|
11 |
D_MASSUP |
L |
1 |
0 |
Mass Updateable |
|
12 |
D_OBJTYPE |
C |
1 |
0 |
Object Type |
|
13 |
D_ORDER |
N |
2 |
0 |
Order |
|
14 |
D_PANEL |
C |
30 |
0 |
Related Detail |
|
15 |
D_SECNAME |
C |
8 |
0 |
Secondary Alias Name |
|
16 |
D_TABLE |
C |
2 |
0 |
Table ID |
|
17 |
D_TABNAME |
C |
25 |
0 |
Table Name |
|
18 |
D_TYPE |
C |
1 |
0 |
Field Type |
|
19 |
D_WIDTH |
N |
4 |
0 |
Font Width |
TKSCREEN
Custom Details Screen Definitions (TKSCR)
| Seq | Field Name | Type | Length | Dec | Description |
|---|---|---|---|---|---|
|
1 |
S_ALIAS |
C |
8 |
0 |
Field Alias |
|
2 |
S_COL |
C |
10 |
0 |
Column Position |
|
3 |
S_DOSCOMP |
C |
3 |
0 |
DOS Company Code |
|
4 |
S_FIELD |
C |
10 |
0 |
Field Name |
|
5 |
S_LBLLEFT |
N |
3 |
0 |
Left Position of Label |
|
6 |
S_NAME |
C |
25 |
0 |
Detail Name |
|
7 |
S_OBJLEFT |
N |
3 |
0 |
Left Position of Object |
|
8 |
S_OBJTYPE |
C |
1 |
0 |
Object Type |
|
9 |
S_OBJWIDTH |
N |
3 |
0 |
Object Width |
|
10 |
S_PAGE |
N |
1 |
0 |
Page Number |
|
11 |
S_PANTYPE |
C |
2 |
0 |
Type of Detail |
|
12 |
S_REQUIRED |
C |
1 |
0 |
Required Field |
|
13 |
S_ROW |
C |
1 |
0 |
Row Position |
|
14 |
S_SECURITY |
C |
10 |
0 |
Security Setting |
|
15 |
S_TITLE |
C |
20 |
0 |
Field Title |
|
16 |
S_VALIDATE |
C |
1 |
0 |
User Defined Function Call |
TKTABLES
User Defined Table Definitions (TKTAB)
| Seq | Field Name | Type | Length | Dec | Description |
|---|---|---|---|---|---|
|
1 |
Code |
C |
15 |
0 |
Code |
|
2 |
Desc |
C |
25 |
0 |
Description |
|
3 |
Program |
C |
100 |
0 |
Program Call |
|
4 |
UD1 |
C |
25 |
0 |
User-Defined Title 1 |
|
5 |
UD2 |
C |
25 |
0 |
User-Defined Title 2 |
|
6 |
UD3 |
C |
25 |
0 |
User-Defined Title 3 |
|
7 |
UD4 |
C |
25 |
0 |
User-Defined Title 4 |
|
8 |
UD5 |
C |
25 |
0 |
User-Defined Title 5 |
|
9 |
UD6 |
C |
25 |
0 |
User-Defined Title 6 |
TKMULXXX
Custom Details (Detail Name) Data (TKMULXXX)
| Seq | Field Name | Type | Length | Dec | Description |
|---|---|---|---|---|---|
|
1 |
U_COMPANY |
C |
3 |
0 |
Employer Code |
|
2 |
U_EMPNO |
C |
9 |
0 |
Employee ID |
Note: The
TKMULXXX files relate to multi-record pages only. The number of multi-record
custom page databases varies based on the number of multi-record pages
you create. You can create up to 999 multi-record pages, thus the name
of the database file can be TKMUL001 to TKMUL999. The database file description
includes the name of the page.
The database structure for all TKMULXXX files varies based on the custom
fields you have added to your multi-record custom pages.