HRPADNLP_P2RX_BT - Payroll Results: Bank Transfers

Payroll Results: Bank Transfers information is stored in SAP table HRPADNLP_P2RX_BT.
It is part of development package PAOC_PAY_NL_PENS in software component PY-NL. This development package consists of objects that can be grouped under "Add-On Payroll Development: - Netherlands (Pensions)".

Fields for table HRPADNLP_P2RX_BT

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE		X		HRDCT_S_PAYKEY	0
MANDT	Client	X	MANDT	CLNT	6	*
.INCLUDE	PCLKEY	X		HRDCT_S_PYPCL2KEY	0
DCT_PERNR	Personnel Number	X	P_PERNR	NUMC	16
DCT_SEQNR	Sequence Number	X	CDSEQ	NUMC	10	HRPY_RGDIR
DCT_ROWID	Unique Row Number	X	HRDCT_ROWID	NUMC	10
.INCLUDE		X		HRPADNLP_LOG_HRDCT_S_PAYKEY	0
HRPADNLP_SEQNR	Sequence Number	X	CDSEQ	NUMC	10
HRPADNLP_RUNDT	Date of payroll run	X	RUNDT	DATS	16
HRPADNLP_RUNTM	Time of payroll run	X	RUNTM	TIMS	12
.INCLUDE				PC209	0
BTZNR	Assignment of Transfers		BTZNR	RAW	1
LGART	Wage Type		LGART	CHAR	8	*
BETRG	HR Payroll: Amount		MAXBT	CURR	8
EMFTX	Payee Text		EMFTX	CHAR	80
BKPLZ	Postal Code		PSTLZ	CHAR	20
BKORT	City		ORT01	CHAR	50
BANKS	Country/Region Key		LAND1	CHAR	6	T005
BANKL	Bank Number		BANKL	CHAR	30
BANKN	Bank account number		BANKN	CHAR	36
EMFSL	Payee key for bank transfers		EMFSL	CHAR	16
VBAFM	Type of investment/asset for capital formation		VBAFM	CHAR	2	*
DTADT	Transfer date		DTADT_D	DATS	16
DTATI	Transfer time		DATTI	TIMS	12
DTAID	Transfer identification		DTATX	CHAR	40
BTTYP	PBS Transfer Type		P09_BTTYP	NUMC	4	*
PSKTO	PO Bank Current Acct No. or Building Society Ref. No.		PSKTO	CHAR	32
WAERS	Currency Key		WAERS	CUKY	10	*
STRAS	Street and House Number		STRAS	CHAR	60
BKONT	Bank Control Key		BKONT	CHAR	4
FBETR	HR Payroll: Amount		MAXBT	CURR	8
STATE	Region (State, Province, County)		REGIO	CHAR	6	T005S
ESRNR	ISR subscriber number		ESRNR	CHAR	22
ESRRE	ISR/QR Reference Number		ESRRE	CHAR	54
ESRPZ	POR check digit		ESRPZ	CHAR	4
BKREF	Reference Details for Bank Details		BKREF	CHAR	40
CTRNS	Coll. Bank Transfer Indicator		HRPAY00_COLDME_CTRNS	CHAR	2
IBAN	IBAN (International Bank Account Number)		IBAN	CHAR	68
CRDID	Creditor Identification Number		HRPAY00_SEPA_CRDID	CHAR	70
MNDID	SEPA Mandate: Unique Reference to Mandate per Creditor		HRPAY00_SEPA_MNDID	CHAR	70
DD_DUEDATE_SEPA	Requested Date for Collection of the SEPA Direct Debit		HRDME_DD_DUEDATE_SEPA	DATS	16
ADRS_BANKS	Country/Region Key		LAND1	CHAR	6	*
BETRG_ORIG	HR Payroll: Amount		MAXBT	CURR	8
OPBEL_REF	Document reference number		PAY_NL_PENS_OPBEL_REF	CHAR	24
ERDAT	Date on which the record was created		ERDAT	DATS	16
ERZEIT	Time at Which Record Was Added		ERZEIT	TIMS	12
ERNAM	Name of Person Responsible for Creating the Object		ERNAM	CHAR	24
AEDAT	Last Changed On		AEDAT	DATS	16
AEZEIT	Time of Change		AEZEIT	TIMS	12
AENAM	Name of Person Who Changed Object		AENAM	CHAR	24