T5G_NIDTO

National Insurance data take on | #other | Component: United Kingdom
Column Name Description
MANDT Client
PERNR Personnel Number
ENDDA End Date
Column Name Description
💲 Currency Key (T500C.WAERS):
NIPAY Niable pay
NIBASE Niable pay base
AMTTOLEL Niable pay up to LEL
AMTLELEET Niable pay between LEL and PT
AMTEETERT Niable pay between PT and ST
AMTERTUEL Niable pay between ST and UST/AUST/UEL
AMTFROMUEL Niable pay above UEL
EENIC Employee NICs
ERNIC Employer NICs
EENIR Employee (primary) NI rebate
ERNIR Employer (secondary) NI rebate
Column Name Description
Column Name Description
ENDDA End Date
BEGDA Start Date
Column Name Description
CTOUT Contracted Out Flag Show values
APPS APPS flag Show values
DIRFB NI director indicator Show values
DIRRP Director with regular payments Show values
LSFLG Late starter /forgotten time sheet flag Show values
LTLVR Late leaver flag Show values
WK6FL Contracted-out later than six weeks after leaving flag Show values
Column Name Description Domain name
ASSGM Assignment number RAW1
PRRTY NI calculation priority NUMC02
DIRPW Director number of tax weeks for pro-rating NUMC02
Other Relations Join Conditions
NI category (GB)
  • Contracted Out Flag
  • NI category (GB)
  • ?
  • T5G_NIDTO.CTOUT == T5G42.CTOUT
  • T5G_NIDTO.NICAT == T5G42.NICAT
  • T5G_NIDTO.[column in domain "ENDDA"] == T5G42.ENDDA