P05T_CVZ_UITW - CVZ: Tabel voor uitwisselingsbestand
CVZ: Tabel voor uitwisselingsbestand information is stored in SAP table P05T_CVZ_UITW.
It is part of development package P05T in software component PY-NL-RP. This development package consists of objects that can be grouped under "HR Payroll: The Netherlands".
It is part of development package P05T in software component PY-NL-RP. This development package consists of objects that can be grouped under "HR Payroll: The Netherlands".
Fields for table P05T_CVZ_UITW
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| JUPER | Representing Legal Person | X | P05_REPER | CHAR | 8 | T5N9P |
| PABRJ | CAK for-year year | X | P05T_CVZ_ANPRJ | NUMC | 8 | |
| PABRP | CAK for-period | X | P05T_CVZ_ANPRP | NUMC | 4 | |
| PERNR | Personnel Number | X | PERSNO | NUMC | 16 | PA0003 |
| PERSID | CAK: Sequence Number instead of Personnel Number | X | P05T_CVZ_PERSID | NUMC | 6 | |
| SEQNO | Alphanumeric Symbol for CAK Files | X | P05T_CVZ_SEQNO | CHAR | 8 | |
| GDATE | Creation/Change Date | P05T_GDATE | DATS | 16 | ||
| GTIME | Creation/Change Hour | P05T_GTIME | TIMS | 12 | ||
| CVZ_ORGNR | Organization number for HCIB | P05T_CVZ_ORGNR | CHAR | 20 | ||
| CVZ_ORGCDE | Organizational code for CAK | P05T_CVZ_ORGCDE | CHAR | 24 | ||
| CVZ_ID | Identification at CAK | P05T_CVZ_ID | NUMC | 16 | ||
| CVZ_MAAND | Month for HCIB | P05T_CVZ_MAAND | NUMC | 4 | ||
| CVZ_JAAR | Year for HCIB | P05T_CVZ_JAAR | NUMC | 8 | ||
| CVZ_ACTUEEL | Current status of insured person for HCIB | P05T_CVZ_ACTUEEL | NUMC | 2 | ||
| CVZ_INH_NOMINAAL | Deduction for nominal ZVW contribution | P05T_CVZ_INH_NOMINAAL | DEC | 4 | ||
| CVZ_INH_ZVW | Translation factor for deduction of ZVW contribution | P05T_CVZ_INH_ZVW | DEC | 3 | ||
| CVZ_INH_AWBZ | Conversion factor for deduction of AWBZ contribution | P05T_CVZ_INH_AWBZ | DEC | 3 | ||
| CVZ_HM | Registration number of main person insured/co-insured | P05T_CVZ_HM | CHAR | 2 | ||
| CVZ_ID_HV | Main person insured's identifier for co-insured person | P05T_CVZ_ID_HV | NUMC | 16 | ||
| CVZ_GESLACHT | Gender of insured person | P05T_CVZ_GESLACHT | CHAR | 2 | ||
| CVZ_OVERL | Reference number deceased | P05T_CVZ_OVERL | NUMC | 2 | ||
| CVZ_VOORLETTERS | Initials | P05T_CVZ_VOORLETTERS | CHAR | 12 | ||
| CVZ_VOORVOEGSEL | Name Prefix | P05T_CVZ_VOORVOEGSEL | CHAR | 20 | ||
| CVZ_ACHTERNAAM | Last Name | P05T_CVZ_ACHTERNAAM | CHAR | 140 | ||
| CVZ_PARTNERNAAM | Partner Name | P05T_CVZ_PARTNERNAAM | CHAR | 70 | ||
| CVZ_ADRES | Address for CAK | P05T_CVZ_ADRES | CHAR | 110 | ||
| CVZ_POSTCODE | Postal Code for CAK | P05T_CVZ_POSTCODE | CHAR | 16 | ||
| CVZ_WOONPLAATS | City for CAK | P05T_CVZ_WOONPLAATS | CHAR | 48 | ||
| CVZ_LAND | Country code for CAK | P05T_CVZ_LAND | CHAR | 4 | ||
| CVZ_SOFINUMMER | Social Security Number for CAK | P05T_CVZ_SOFINUMMER | NUMC | 18 | ||
| CVZ_GBDAT | Date of Birth for CAK | P05T_CVZ_GEBOORTEDATUM | CHAR | 20 | ||
| CVZ_DT_START | Start Date Deduction | P05T_CVZ_DT_START | CHAR | 20 | ||
| CVZ_DT_EIND | End Date deduction | P05T_CVZ_DT_EIND | CHAR | 20 | ||
| CVZ_REGNR | External registration number | P05T_CVZ_REGISTRATIENR | CHAR | 40 | ||
| FOUTMELDING | Error message code | P05T_CVZ_FOUTMELDING | NUMC | 4 | ||
| REGNR | External registration number | P05T_CVZ_REGISTRATIENR | CHAR | 40 | ||
| INH_NOMINAAL | Deduction for nominal ZVW contribution | P05T_CVZ_INH_NOMINAAL | DEC | 4 | ||
| INH_PERC_ZVW | Translation factor for deduction of ZVW contribution | P05T_CVZ_INH_ZVW | DEC | 3 | ||
| INH_ZVW | Amount of deduction by pension fund for ZVW contribution | P05T_CVZ_INH_BDRG_ZVW | DEC | 4 | ||
| INH_PERC_AWBZ | Conversion factor for deduction of AWBZ contribution | P05T_CVZ_INH_AWBZ | DEC | 3 | ||
| INH_AWBZ | Amount of deduction by pension fund for AWBZ contribution | P05T_CVZ_INH_BDRG_AWBZ | DEC | 4 | ||
| DT_START | Start Date Deduction | P05T_CVZ_DT_START | CHAR | 20 | ||
| DT_EIND | End Date deduction | P05T_CVZ_DT_EIND | CHAR | 20 | ||
| ORGCDE | Organizational code for CAK | P05T_CVZ_ORGCDE | CHAR | 24 | ||
| CVZ_FACTOR | Country of residence factor | P05T_CVZ_FACTOR | DEC | 5 | ||
| CVZ_INH_NOM_F | Nominal contribution amount, adjusted for COR HCIB | P05T_CVZ_INH_NOM_F | DEC | 4 | ||
| CVZ_INH_ZVW_F | Amount ZVW, adjusted for country of residence factor HCIB | P05T_CVZ_INH_ZVW_F | DEC | 4 | ||
| CVZ_INH_AWBZ_F | AWBZ amount, adjusted for country of residence factor HCIB | P05T_CVZ_INH_AWBZ_F | DEC | 4 | ||
| CVZ_DT_OVERL | Date of death | P05T_CVZ_DT_OVERL | CHAR | 20 | ||
| DT_OVERL | Date of death | P05T_CVZ_DT_OVERL | CHAR | 20 | ||
| PREMIELOON_ZVW | Cumulative Zvw premium rate (as of 1 Jan. of current year) | P05T_CVZ_PREMIELOON_ZVW | DEC | 5 | ||
| PREMIELOON_AWBZ | Cumulative premium rate AWBZ (beginning 1 Jan of current yr) | P05T_CVZ_PREMIELOON_AWBZ | DEC | 5 | ||
| WOONLAND | Country code for CAK | P05T_CVZ_LAND | CHAR | 4 | ||
| FACTOR | Country of residence factor | P05T_CVZ_FACTOR | DEC | 5 | ||
| CVZ_AANTAL_VERZ | Number of insured persons for whom contribution is deducted | P05T_CVZ_AANT_VERZ | DEC | 2 | ||
| AANTAL_VER | Number of insured persons for whom contribution is deducted | P05T_CVZ_AANT_VERZ | DEC | 2 | ||
| ALL_OUDEREN_KORT | Care Insurance Board: All Elderly Persons' Tax Credit | P05T_CVZ_ALL_OUDEREN_KORTING | CHAR | 2 | ||
| CVZ_INH_ZVW_2008 | Translation Ratio for Deduction of Contribution ZVW (2008) | P05T_CVZ_INH_ZVW_2008 | DEC | 4 | ||
| CVZ_IH_AWBZ_2008 | Translation Ratio for Deduction of Contribution AWBZ (2008) | P05T_CVZ_INH_AWBZ_2008 | DEC | 4 | ||
| INH_PER_ZVW_2008 | Translation Ratio for Deduction of Contribution ZVW (2008) | P05T_CVZ_INH_ZVW_2008 | DEC | 4 | ||
| INH_PR_AWBZ_2008 | Translation Ratio for Deduction of Contribution AWBZ (2008) | P05T_CVZ_INH_AWBZ_2008 | DEC | 4 | ||
| CVZ_IH_ZVW_F_08 | Amount Zvw, adjusted for country of residence factor CVZ | P05T_CVZ_INH_ZVW_F_2008 | DEC | 3 | ||
| CVZ_IH_AWBZ_F_08 | AWBZ amount, adjusted for country of residence factor CVZ | P05T_CVZ_INH_AWBZ_F_2008 | DEC | 3 |