- Home
- Resources
- SAP Tables
- T5G_DTONI - National Insurance Data Take-on
SAP Table T5G_DTONI
National Insurance Data Take-on
T5G_DTONI (National Insurance Data Take-on) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link T5G_DTONI to other SAP tables.
Source: T5G_DTONI (National Insurance Data Take-on)
T5G_DTONI table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| MANDT |
Client |
MANDT |
|
CLNT |
|
3 |
0 |
|
| PERNR |
Personnel Number |
PERNR_D |
|
NUMC |
|
8 |
0 |
|
| NICAT |
NI category (GB) |
NICAT |
T5G42
|
CHAR |
|
2 |
0 |
|
| CTOUT |
Contracted Out Flag |
P08_CTOUT |
|
CHAR |
|
1 |
0 |
Possible values
|
| DIRFB |
NI director indicator |
DIRFB |
|
CHAR |
|
1 |
0 |
Possible values
|
| PAYTY |
Payroll type |
PAYTY |
|
CHAR |
|
1 |
0 |
Possible values
| A |
Bonus payment |
| B |
Correction accounting |
| C |
Manual check |
| NULL |
Regular payroll run |
| S |
Additional payment |
|
| PAYID |
Payroll Identifier |
PAYID |
|
CHAR |
|
1 |
0 |
|
| PAYDT |
Pay date for payroll result |
PAY_DATE |
|
DATS |
|
8 |
0 |
|
| ASSGM |
Assignment number |
P08_ASSGM |
|
RAW |
|
1 |
0 |
|
| PRRTY |
NI calculation priority |
P08_PRRTY |
|
NUMC |
|
2 |
0 |
|
| APPS |
APPS flag |
P08_APPS |
|
CHAR |
|
1 |
0 |
Possible values
|
| DIRRP |
Director with regular payments |
P08_DIRRP |
|
CHAR |
|
1 |
0 |
Possible values
|
| DIRPW |
Director number of tax weeks for pro-rating |
P08_DIRPW |
|
NUMC |
|
2 |
0 |
|
| LSFLG |
Late starter /forgotten time sheet flag |
P08_LSFLG |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
not late starter/forgotten time sheet |
| X |
late starter/forgotten time sheet |
| Y |
late starter/forgotten time sheet yet to be processed |
| A |
late starter/forgotten time sheet to be processed this run |
|
| LTLVR |
Late leaver flag |
P08_LTLVR |
|
CHAR |
|
1 |
0 |
Possible values
|
| WK6FL |
Contracted-out later than six weeks after leaving flag |
P08_WK6FL |
|
CHAR |
|
1 |
0 |
Possible values
|
| NIPAY |
Niable pay |
P08_NI_PAY |
|
CURR |
|
15 |
2 |
|
| NIBASE |
Niable pay base |
P08_NIBASE |
|
CURR |
|
15 |
2 |
|
| AMTTOLEL |
Niable pay up to LEL |
P08_TOLEL |
|
CURR |
|
15 |
2 |
|
| AMTLELEET |
Niable pay between LEL and ST |
P08_TOEET |
|
CURR |
|
15 |
2 |
|
| AMTEETERT |
Niable pay between ST and PT |
P08_TOERT |
|
CURR |
|
15 |
2 |
|
| AMTERTUEL |
Niable pay between UAP and UEL |
P08_TOUEL |
|
CURR |
|
15 |
2 |
|
| AMTFROMUEL |
Niable pay above UEL |
P08_FMUEL |
|
CURR |
|
15 |
2 |
|
| EENIC |
Employee NICs |
P08_NIC_EE |
|
CURR |
|
15 |
2 |
|
| ERNIC |
Employer NICs |
P08_NIC_ER |
|
CURR |
|
15 |
2 |
|
| EENIR |
Employee (primary) NI rebate |
P08_NIREE |
|
CURR |
|
15 |
2 |
|
| ERNIR |
Employer (secondary) NI rebate |
P08_NIRER |
|
CURR |
|
15 |
2 |
|
| DELFLG |
Delete Flag for Data Take On for National Tables |
P08_DTODEL |
|
CHAR |
|
1 |
0 |
Possible values
|
| SRCFLG |
Flag for source of adjustment data(NI) |
P08_SRCFLG |
|
CHAR |
|
1 |
0 |
Possible values
|
| AMTERTUAP |
Niable pay between PT and UAP |
P08_TOUAP |
|
CURR |
|
15 |
2 |
|
T5G_DTONI foreign key relationships
| Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
| T5G_DTONI |
NICAT |
T5G_DTONI |
NICAT |
T5G42 |
HR-GB: National Insurance Categories |
NICAT |
| T5G_DTONI |
NICAT |
T5G_DTONI |
CTOUT |
T5G42 |
HR-GB: National Insurance Categories |
CTOUT |
| T5G_DTONI |
NICAT |
* |
|
T5G42 |
HR-GB: National Insurance Categories |
ENDDA |
