VZPARZA

Partner addit. data (general part) | #masterdata | Component: Treasury and Risk Management
Column Name Description
MANDT FK Client
PARTNR FK Partner number
Column Name Description
Column Name Description
Column Name Description
DERF First Entered On
TERF Time of Creation
DBEAR Last Edited On
TBEAR Last Edited At
DSCHUFA Date of last credit information
Column Name Description
SPERRE Internal flag: Record is blocked for changes Show values
JEIDVER Submission of solemn declaration about wealth Show values
JKONKURS Bankruptcy proceedings indicator Show values
JZWANG Foreclosure indicator Show values
JSCHUFA Acct solicitation service status Show values
SBONITA Credit standing Show values
JKWG14 Indicator borrowers subject to reporting GBA §14 (KWG) Show values
STKZA Indicator: Business Partner Subject to Equalization Tax? Show values
SSAUSLA Non-resident tax indicator Show values
SID_AT Indicator: Assign Numbers for OeNB Externally Show values
Column Name Description Domain name
RERF Entered By SYCHAR12
REHER Source of Initial Entry CHAR10
RBEAR Employee ID SYCHAR12
RBHER Editing Source CHAR10
XKRED Summary of credit information XTEXT50
RKWG14 SCB borrower no. in acc. with par. 14 GBA RKWG14
RKWG14KE SCB borrower unit no. according to para. 14 KWG RKWG14
STCD1 Tax Number 1 STCD1
STCD2 Tax Number 2 STCD2
SFRT1 User-defined text (freely definable - 35 character text) TEXT35
SFRT2 User-defined text (freely definable - 35 character text) TEXT35
YKONKURS Year of bankruptcy proceedings GJAHR
YZWANG Year of foreclosure GJAHR
YEIDVER Year of affidavit GJAHR
XAPARNR Partner ID in previous system CHAR15
XID_AT OeNB ID Number VVXID_AT
Master Data Relations Join Conditions
Partner-company code allocation
  • VZPARZA.MANDT == T001.MANDT
  • VZPARZA.ABUKR == T001.BUKRS
Factory calendar VZPARZA.KALID == TFACD.IDENT
Account Number of Supplier
  • VZPARZA.MANDT == LFA1.MANDT
  • VZPARZA.LIFNR == LFA1.LIFNR
Client VZPARZA.MANDT == T000.MANDT
Role for which the additional data was last maintained
  • External role of partner
  • Client
  • VZPARZA.ROLLBEA == TZRE.SROLEXT
  • VZPARZA.MANDT == TZRE.MANDT
Role for which the additional data was created
  • External role of partner
  • Client
  • VZPARZA.ROLLERF == TZRE.SROLEXT
  • VZPARZA.MANDT == TZRE.MANDT
Currency Key
  • VZPARZA.MANDT == TCURC.MANDT
  • VZPARZA.SGRDWHR == TCURC.WAERS
Group Key 1 (Freely-Definable - 3 Figure Number)
  • Group Key 1 (Freely-Definable - 3 Figure Number)
  • Client
  • VZPARZA.SGRP1 == TZDG1.SGRP1
  • VZPARZA.MANDT == TZDG1.MANDT
Group Key 2 (Freely-Definable - 3 Figure Number)
  • Group Key 2 (Freely-Definable - 3 Figure Number)
  • Client
  • VZPARZA.SGRP2 == TZDG2.SGRP2
  • VZPARZA.MANDT == TZDG2.MANDT
Group Key 3 (Freely-Definable - 3 Figure Number)
  • VZPARZA.MANDT == TZDG3.MANDT
  • VZPARZA.SGRP3 == TZDG3.SGRP3
Source of credit information (informant in form of company)
  • VZPARZA.MANDT == TIV61.MANDT
  • VZPARZA.SKRED == TIV61.SKRED
Information in accordance with §18 GBA
  • Information in accordance with §18 GBA
  • Client
  • VZPARZA.SKWG18 == TZV15.SKWG18
  • VZPARZA.MANDT == TZV15.MANDT
Foreign key VZPARZA: Loans to managers SORGAN
  • VZPARZA.MANDT == TZD1.MANDT
  • VZPARZA.SORGAN == TZD1.SORGAN
VIP Partner
  • VIP Partner
  • Client
  • VZPARZA.SPAVIP == TVIP.PAVIP
  • VZPARZA.MANDT == TVIP.MANDT
Target Group According to OeNB
Target group
  • VZPARZA.MANDT == TD05.MANDT
  • VZPARZA.SZIEL == TD05.SZIEL