P2RR_NRIC

Payroll Singapore: NRIC | #transactional | Component: Singapore
Column Name Description
MANDT Client
DCT_PERNR Personnel Number
DCT_SEQNR FK Sequence Number
DCT_ROWID Unique Row Number
Column Name Description
Column Name Description
Column Name Description
BEGDA Start Date
ENDDA End Date
DATE1 Date of issue for personal ID
EXPID ID expiry date
DATE2 Date of issue for work permit
EXPDT Expiry date of work permit
Column Name Description
Column Name Description Domain name
RESIS Residence status RESIS
IDCOD Personal ID and work permit (SG) IDCOD
IDTEX ID type text TEXT30
DOCN1 Document number for personal identification CHAR20
WPCOD Type of Work Permit P25_WPCOD
WPTEX Work permit type text TEXT30
DOCN2 Document number for work permit CHAR20
ICTYP Type of identification (IC type) ICTYP
ICNUM IC number ICNUM
ICPPN Document number for personal identification CHAR20