P05T_CVZ_UITW

CVZ: Tabel voor uitwisselingsbestand | #transactional | Component: Reporting
Column Name Description
MANDT FK Client
JUPER FK Representing Legal Person
PABRJ CAK for-year year
PABRP CAK for-period
PERNR FK Personnel Number
PERSID CAK: Sequence Number instead of Personnel Number
SEQNO Alphanumeric Symbol for CAK Files
Column Name Description
Column Name Description
Column Name Description
GDATE Creation/Change Date
GTIME Creation/Change Hour
Column Name Description
CVZ_ACTUEEL Current status of insured person for HCIB Show values
CVZ_HM Registration number of main person insured/co-insured Show values
CVZ_GESLACHT Gender of insured person Show values
CVZ_OVERL Reference number deceased Show values
FOUTMELDING Error message code Show values
Column Name Description Domain name
CVZ_ORGNR Organization number for HCIB CHAR10
CVZ_ORGCDE Organizational code for CAK CHAR12
CVZ_ID Identification at CAK NUM8
CVZ_MAAND Month for HCIB NUM2
CVZ_JAAR Year for HCIB NUM4
CVZ_INH_NOMINAAL Deduction for nominal ZVW contribution P05T_CVZ_BEDRAG
CVZ_INH_ZVW Translation factor for deduction of ZVW contribution P05T_CVZ_PERC
CVZ_INH_AWBZ Conversion factor for deduction of AWBZ contribution P05T_CVZ_PERC
CVZ_ID_HV Main person insured's identifier for co-insured person NUM8
CVZ_VOORLETTERS Initials TEXT6
CVZ_VOORVOEGSEL Name Prefix TEXT10
CVZ_ACHTERNAAM Last Name TEXT70
CVZ_PARTNERNAAM Partner Name TEXT35
CVZ_ADRES Address for CAK TEXT55
CVZ_POSTCODE Postal Code for CAK CHAR8
CVZ_WOONPLAATS City for CAK TEXT24
CVZ_LAND Country code for CAK CHAR2
CVZ_SOFINUMMER Social Security Number for CAK NUM9
CVZ_GBDAT Date of Birth for CAK P05T_CVZ_DATUM
CVZ_DT_START Start Date Deduction P05T_CVZ_DATUM
CVZ_DT_EIND End Date deduction P05T_CVZ_DATUM
CVZ_REGNR External registration number CHAR20
REGNR External registration number CHAR20
INH_NOMINAAL Deduction for nominal ZVW contribution P05T_CVZ_BEDRAG
INH_PERC_ZVW Translation factor for deduction of ZVW contribution P05T_CVZ_PERC
INH_ZVW Amount of deduction by pension fund for ZVW contribution P05T_CVZ_BEDRAG
INH_PERC_AWBZ Conversion factor for deduction of AWBZ contribution P05T_CVZ_PERC
INH_AWBZ Amount of deduction by pension fund for AWBZ contribution P05T_CVZ_BEDRAG
DT_START Start Date Deduction P05T_CVZ_DATUM
DT_EIND End Date deduction P05T_CVZ_DATUM
ORGCDE Organizational code for CAK CHAR12
CVZ_FACTOR Country of residence factor P05T_CVZ_FACTOR
CVZ_INH_NOM_F Nominal contribution amount, adjusted for COR HCIB P05T_CVZ_BEDRAG
CVZ_INH_ZVW_F Amount ZVW, adjusted for country of residence factor HCIB P05T_CVZ_BEDRAG
CVZ_INH_AWBZ_F AWBZ amount, adjusted for country of residence factor HCIB P05T_CVZ_BEDRAG
CVZ_DT_OVERL Date of death P05T_CVZ_DATUM
DT_OVERL Date of death P05T_CVZ_DATUM
PREMIELOON_ZVW Cumulative Zvw premium rate (as of 1 Jan. of current year) P05T_CVZ_PREMIELOON
PREMIELOON_AWBZ Cumulative premium rate AWBZ (beginning 1 Jan of current yr) P05T_CVZ_PREMIELOON
WOONLAND Country code for CAK CHAR2
FACTOR Country of residence factor P05T_CVZ_FACTOR
CVZ_AANTAL_VERZ Number of insured persons for whom contribution is deducted P05T_CVZ_AANT_VERZ
AANTAL_VER Number of insured persons for whom contribution is deducted P05T_CVZ_AANT_VERZ
ALL_OUDEREN_KORT Care Insurance Board: All Elderly Persons' Tax Credit
CVZ_INH_ZVW_2008 Translation Ratio for Deduction of Contribution ZVW (2008) P05T_CVZ_PERC_2008
CVZ_IH_AWBZ_2008 Translation Ratio for Deduction of Contribution AWBZ (2008) P05T_CVZ_PERC_2008
INH_PER_ZVW_2008 Translation Ratio for Deduction of Contribution ZVW (2008) P05T_CVZ_PERC_2008
INH_PR_AWBZ_2008 Translation Ratio for Deduction of Contribution AWBZ (2008) P05T_CVZ_PERC_2008
CVZ_IH_ZVW_F_08 Amount Zvw, adjusted for country of residence factor CVZ P05T_CVZ_CONV_FACTOR
CVZ_IH_AWBZ_F_08 AWBZ amount, adjusted for country of residence factor CVZ P05T_CVZ_CONV_FACTOR
Master Data Relations Join Conditions
Representing Legal Person
  • Representing Legal Person
  • ?
  • P05T_CVZ_UITW.MANDT == T5N9P.MANDT
  • P05T_CVZ_UITW.JUPER == T5N9P.REPER
  • P05T_CVZ_UITW.[column in domain "ENDDA"] == T5N9P.ENDDA
Client P05T_CVZ_UITW.MANDT == T000.MANDT
Personnel Number
  • Personnel Number
  • Client
  • P05T_CVZ_UITW.PERNR == PA0003.PERNR
  • P05T_CVZ_UITW.MANDT == PA0003.MANDT