T7NZED

PY-NZ: Employee details report table | #transactional | Component: New Zealand
Column Name Description
MANDT Client
GLBID HR B2A: Global Object ID
PERNR Personnel Number
SRNO Employee Details Unique running sequence number
Column Name Description
Column Name Description
Column Name Description
IDENTIFIER_DATE_OF_BIRTH Date of Birth
IDENTIFIER_START_DATE Hire Date
EMPLOYEE_DATE_OF_BIRTH Date of Birth
EMPLOYMENT_START_DATE Hire Date
EMPLOYMENT_FINISH_DATE Fire Date
OPTED_OUT_SIGNATURE_DATE Opt Out Date Field
PDATE Pay date for payroll result
ENDDA End Date
BEGDA Start Date
Column Name Description
PAYTY Payroll type Show values
Column Name Description Domain name
SOFTWARE_PROVIDER Software Provider TEXT3
SOFTWARE_PLATFORM Software Platform TEXT50
SOFTWARE_RELEASE Software Release TEXT80
IDENTIFIER_VALUE_TYPE IdentifierValueType CHAR6
ERIRD Employer/Company Inland Revenue Number CHAR9
ACCOUNT_TYPE Account Type CHAR3
IDENTIFIER_IRD IRD number CHAR9
IDENTIFIER_NAME_ON_EILINE Name On EI Line CHAR82
EMPLOYEE_IRD IRD number CHAR9
EMPLOYEE_NAME_ON_EILINE Name On EI Line CHAR82
NAME_TITLE Form of address text ANREX
NAME_FIRST First Name PAD_VORNM
NAME_SURNAME Last Name PAD_NACHN
NAME_MIDDLE Middle Name PAD_VORNM
TAX_CODE Tax Code PNZ_TAXCD
STREET_NUMBER Street and House Number PAD_STRAS
STREET_NAME 2nd address line PAD_LOCAT
UNIT_TYPE Unit Type CHAR15
UNIT_NUMBER Unit Number CHAR15
DISTRICT District PAD_ORT01
TOWN_CITY City PAD_ORT01
POST_CODE Postal Code PSTLZ
COUNTRY Country/Region Key LAND1
STATE_PROVINCE State Province CHAR4
FREE_FROM_ADDRESS Free From Address CHAR250
EMPLOYEE_EMAIL_ADDRESS E-mail of Employer’s Payroll Contact TEXT60
MOBILE_NUMBER Mobile TEXT15
MOBILE_TYPE PhoneType CHAR15
MOBILE_COUNTRY Phone Country CHAR3
MOBILE_AREA_CODE Area Code CHAR5
MOBILE_EXTENSION Extension CHAR9
PHONE_TYPE PhoneType CHAR15
PHONE_COUNTRY Phone Country CHAR3
PHONE_AREA_CODE Area Code CHAR5
PHONE_EXTENSION Extension CHAR9
PHONE Phone TEXT12
KIWI_SAVER_STATUS KiwiSaver Status CHAR2
EMPLOYEE_KIWI_SAVER_ELIGIBILIT Employee KiwiSaver Eligibility TEXT2
OPTED_OUT Opt Out Flag CHAR1
BANK Bank ID PNZ_BNKID
BRANCH Bank Branch PNZ_BNKBR
ACCOUNT Account Base number PNZ_ACBAS
SUFFIX Account Suffix PNZ_ACSUF
ACCNM_NAME_TITLE Form of address text ANREX
ACCNM_NAME_FIRST Account Name PNZ_ACCNM
ACCNM_NAME_SURNAME Last Name PAD_NACHN
ACCNM_NAME_MIDDLE Middle Name PAD_VORNM
VALID_RELATIONSHIP Valid Relationship CHAR1
ACTION Action
ABKRS Payroll Area ABKRS
PAYID Payroll Identifier CHAR1
FPPER For-period for garnishment PRIOD
TAX_CODE2 Tax Code PNZ_TAXCD
TAX_CODE3 Tax Code PNZ_TAXCD
TAX_CODE4 Tax Code PNZ_TAXCD
LATE_OPT_OUT_REASON Late Opt Out Reason Code CHAR5
LATE_OPT_OUT_RETXT Late Opt Out Reason Text