T7PLD1

Payer data | #masterdata | Component: Poland
Column Name Description
MANDT FK Client
PYRID Payer identifier
Column Name Description
Column Name Description
Column Name Description
BUSSD Payer's bussiness start date
Column Name Description
BUDGT Budget unit flag Show values
SPCMF Code of application for subs. contributions for disabled Show values
KSACH Health insurance fund branch code Show values
Column Name Description Domain name
NMF11 Name 1 TEXT40
NMF21 Name 2 TEXT40
NMST1 Name 3 TEXT40
NMF12 Name 1 TEXT40
NMF22 Name 2 TEXT40
NMST2 Name 3 TEXT40
NMF13 Name 1 TEXT40
NMF23 Name 2 TEXT40
STRET Street TEXT60
HSNM1 House Number TEXT10
PSTCD City postal code CHAR10
CITY1 City TEXT40
CITY2 District TEXT40
POLOC PO Box city TEXT40
RMNUM Room or Apartment Number TEXT10
TLNMB First telephone no.: dialling code+number CHAR30
FXNMB First Fax No.: Area Code + Number CHAR30
TODES Tax office name and address CHAR70
NIP00 NIP number CHAR10
REGON REGON number CHAR14
ADMLN Last Name PAD_NACHN
ADMFN First Name PAD_VORNM
WSCIT City name for work statament TEXT40
EKD GUS field - PKD CHAR5
Master Data Relations Join Conditions
Payroll constant
  • ?
  • ?
  • Client
  • Payroll constant
  • T7PLD1.[column in domain "ENDDA"] == T511K.ENDDA
  • T7PLD1.[column in domain "MOLGA"] == T511K.MOLGA
  • T7PLD1.MANDT == T511K.MANDT
  • T7PLD1.AICON == T511K.KONST
County Code
  • County Code
  • Country/Region Key
  • Region (State, Province, County)
  • T7PLD1.MANDT == T005E.MANDT
  • T7PLD1.COUNC == T005E.COUNC
  • T7PLD1.LAND1 == T005E.LAND1
  • T7PLD1.REGIO == T005E.REGIO
Country/Region Key
  • Country/Region Key
  • Client
  • T7PLD1.LAND1 == T005.LAND1
  • T7PLD1.MANDT == T005.MANDT
Client T7PLD1.MANDT == T000.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • T7PLD1.MANDT == T005S.MANDT
  • T7PLD1.LAND1 == T005S.LAND1
  • T7PLD1.REGIO == T005S.BLAND
Municipality key according to GUS - TERYT
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • County Code
  • Municipality key according to GUS - TERYT
Other Relations | to Master Data Relations ↑ Join Conditions
Tax Office XML identifier
  • Tax Office XML identifier
  • ?
  • Client
  • T7PLD1.TOIDX == T7PL01.TOIDN
  • T7PLD1.[column in domain "ENDDA"] == T7PL01.ENDDA
  • T7PLD1.MANDT == T7PL01.MANDT