1. Home
  2. Resources
  3. SAP Tables
  4. 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.

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
X Yes
NULL No
DIRFB NI director indicator DIRFB CHAR 1 0
X Yes
NULL No
PAYTY Payroll type PAYTY CHAR 1 0
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
X Yes
NULL No
DIRRP Director with regular payments P08_DIRRP CHAR 1 0
X Yes
NULL No
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
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
X Yes
NULL No
WK6FL Contracted-out later than six weeks after leaving flag P08_WK6FL CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
SRCFLG Flag for source of adjustment data(NI) P08_SRCFLG CHAR 1 0
X Yes
NULL No
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