P05T_JLO_DATA

Data for Annual Wage Return | #transactional | Component: Reporting
Column Name Description
MANDT FK Client
LHNR Wage Return: Wage Tax Number
JAAR Year of Annual Wage Return
DATAANVTV Start Date
SEQNO Wage Return: Sequence Number
PERNR Personnel Number
BEGDAIV Start Date
Column Name Description
💲 Currency Key (T500C.WAERS):
LNLBPH Amount
LNSV Amount
LNTABBB Amount
INGLBPH Amount
PRWAOAOF Amount
PRWAOAOK Amount
PRAWF Amount
PRWGF Amount
PRUFO Amount
BIJDRZVW Amount
VERGZVW Amount
WRDPRGEBRAUT Amount
WRKNBIJDRAUT Amount
LVLPREG Amount
REISK Amount
VERRARBKRT Amount
BEDRZDAFTR Amount
BEDRALINWWB Amount
BEDRRCHTAL Amount
LVLPREGTOEG Amount
PRLNWAOAOF Amount
PRLNPRSECTFNDS Amount
PRLNWAOAOK Amount
PRLNAWF Amount
PRLNUFO Amount
WGHZVW Amount
Column Name Description
Column Name Description
DATAANVTV Start Date
BEGDAIV Start Date
ENDDAIV End Date
GEBDAT Date of Birth
BEGDAINKPER Wage Return: Income Period Start Date
Column Name Description
CDBEPTD Wage Return: Open-Ended/Fixed-Term Contract Code Show values
CDAGH Contribution Reduction Code Show values
INDLHKORT Wage Return: Wage Tax Reduction Code Show values
GEBRAUTO Wage Return: Reason for No Add.to Taxab.Income for Car Code Show values
INDWAO Wage Return: "WAO" Insured Code Show values
INDWW Wage Return: "WW" Insured Code Show values
INDZW Wage Return: "ZW" Insured Code Show values
CDZVW Wage Return: "Zvw" Insurance Situation Code Show values
INDSA71 Wage Return: Code Show values
INDSA72 Wage Return: Code Show values
INDSA43 Wage Return: Code Show values
INDSA03 Wage Return: Code Show values
INDPKAGH Premium Reduction Work Disability Show values
INDPKNAOW Premium Reduction Hiring Elderly Employee Show values
INDPKIDOW Premium Reduction Employing Elderly Employee Show values
INDPMA PMA (Ex-Social Benefits Recipient) Show values
INDWOR Reduced Pay Old Regulation Show values
Column Name Description Domain name
AANDIV Wage Return: Income Relationship Code TEXT35
SOFINR Wage return: CSN/SoFi Number
SIGNM Wage Return: Significant Part of Last Name TEXT200
SRTIV Wage Return: Income Relationship P05T_SRTIV
LBTAB Wage Return: Employment Tax Table Code CHAR3
NUMIV IR Number NUM4
Master Data Relations Join Conditions
Wage Return: Type of Work Relationship Code
  • Wage Return: Type of Work Relationship Code
  • ?
  • P05T_JLO_DATA.MANDT == T5N72.MANDT
  • P05T_JLO_DATA.CDAARD == T5N72.CAARD
  • P05T_JLO_DATA.[column in domain "ENDDA"] == T5N72.ENDDA
Insurance Obligation Influence Code
  • Insurance Obligation Influence Code
  • ?
  • P05T_JLO_DATA.MANDT == T5N74.MANDT
  • P05T_JLO_DATA.CDINVLVPL == T5N74.CIVPL
  • P05T_JLO_DATA.[column in domain "ENDDA"] == T5N74.ENDDA
Wage Return: F & S Phase Categorization Code
  • Wage Return: F & S Phase Categorization Code
  • ?
  • Client
  • P05T_JLO_DATA.FSINDFZ == T5N75.CFIFZ
  • P05T_JLO_DATA.[column in domain "ENDDA"] == T5N75.ENDDA
  • P05T_JLO_DATA.MANDT == T5N75.MANDT
Client P05T_JLO_DATA.MANDT == T000.MANDT
Risk Group Indicator
  • Sector
  • Client
  • Risk Group Indicator
  • ?
  • P05T_JLO_DATA.SECT == T5N13.SECTOR
  • P05T_JLO_DATA.MANDT == T5N13.MANDT
  • P05T_JLO_DATA.RISGRP == T5N13.RISICOGROEP
  • P05T_JLO_DATA.[column in domain "ENDDA"] == T5N13.ENDDA
Sector
  • ?
  • Sector
  • P05T_JLO_DATA.MANDT == T5N15.MANDT
  • P05T_JLO_DATA.[column in domain "ENDDA"] == T5N15.ENDDA
  • P05T_JLO_DATA.SECT == T5N15.SECTOR