HRP1890 - DB Table for Infotype 1890

DB Table for Infotype 1890 information is stored in SAP table HRP1890.
It is part of development package PMIQ_NL in software component IS-HER-CM-NL. This development package consists of objects that can be grouped under "Student Lifecycle Management - Netherlands".

Fields for table HRP1890

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE		X		HRIKEY	0
MANDT	Client	X	MANDT	CLNT	6	T000
PLVAR	Plan Version	X	PLVAR	CHAR	4	T778P
OTYPE	Object Type	X	OTYPE	CHAR	4	T778O
OBJID	Object ID	X	HROBJID	NUMC	16	PLOGI
SUBTY	Subtype	X	SUBTYP	CHAR	8	*
ISTAT	Planning Status	X	ISTAT_D	CHAR	2	T778S
BEGDA	Start Date	X	BEGDATUM	DATS	16
ENDDA	End Date	X	ENDDATUM	DATS	16
VARYF	Variation Field for File PLOG	X	VARYF	CHAR	20
SEQNR	Number of Infotype Record With Same Key	X	SEQNR	NUMC	6
INFTY	Infotype		INFOTYP	CHAR	8	T778T
OTJID	Concatenation of Object Type and Object ID		OTJID	CHAR	20
.INCLUDE				HRIADMIN	0
AEDTM	Changed on		AEDTM	DATS	16
UNAME	User Name		USRNAME	CHAR	24
REASN	Reason		REASN	CHAR	4
HISTO	Historical Record Flag		HISTO	CHAR	2
ITXNR	Text Module for Infotype		ITXNR	NUMC	16
.INCLUDE				HRI1890	0
SC_OBJID	Program ID		PIQSCOBJID	NUMC	16	*
ADM_AYEAR	Academic Year		PIQPERYR	NUMC	8	*
ADM_PERID	Academic Session		PIQPERID	NUMC	6	*
PAIDBY	Paid By		PIQ_NL_PAIDBY	CHAR	2	T7PIQ_NL_PAIDBY
PAYMENTTYPE	Mode of Payment		PIQ_NL_PAYMENTTYPE	CHAR	2	T7PIQ_NL_PAYTY
PAYMENTNAME	Name of Payee		PIQ_NL_PYMNTNAME	CHAR	440
FORMOFPAYBANKDUT	Account Number (Netherlands)		PIQ_NL_PAYMENTBANKGBA	NUMC	20
FORMOFPAYBANKFOR	Account Number (Foreign)		PIQ_NL_PAYMENTBANKFORE	CHAR	68
BANK	Name of Bank		PIQ_NL_BANK	CHAR	100
BANKCOUNTRY	Country/Region Key		LAND1	CHAR	6	T005
INSTALLMENTS	Installments		PIQ_NL_INSTL	CHAR	2
PAID	Tuition Fee Refundable		PIQ_NL_PAID	CHAR	2
AMOUNTFEE	Tuition Fee		PIQ_NL_AMOUNTFEE	DEC	6
PROOFFEEPAID	Tuition Fee Paid		PIQ_NL_PROOFPD	CHAR	2
FEE_WAIVER	Fee Waiver		PIQ_NL_FEEWVR	CHAR	2
INVOICE	Invoice		PIQ_NL_INVOICE	CHAR	2
NOOFINST	No. of Installments		PIQ_NL_INSTALMENTS	NUMC	4
ADMINFEE	Administration Fee		PIQ_NL_ADMINFEE	DEC	4
BARCODE	Barcode		PIQ_NL_BARCODE	NUMC	24
ORDERNUM	Electronic Payment Order Number		PIQ_NL_ORDERNUMBER	CHAR	60
PAIDATBRIN	Paid at BRIN Number		PIQ_NL_PAIDATBRIN	CHAR	8
PAIDATINST	Paid at Institute		PIQ_NL_PAIDATINST	CHAR	140
DOCNR	Number of Fee Calculation Document		CMAC_FEE_DOCNR	CHAR	40
AUTHFEEAMT	Authorized Fee Amount		PIQ_NL_AUTHFEEAMT	DEC	6
AUTHSENT	Payment Authorization Sent		PIQ_NL_AUTHSENT	CHAR	2
AUTHSTACC	Authorization Accepted		PIQ_NL_AUTHSTACC	CHAR	2
AUTHWTDRW	Authorization Withdrawn		PIQ_NL_AUTHWTDRW	CHAR	2
AUTHSENTDATE	Authorization Sent Date		PIQ_NL_AUTHSENTDATE	DATS	16
AUTHSENTTIME	Authorization Sent Time		PIQ_NL_AUTHSENTTIME	TIMS	12
OPBEL	Number of a FI-CA Document		OPBEL_KK	CHAR	24	*
ADM_GUID	Unique Key (GUID) of the Admission		PIQADM_GUID	CHAR	64
PAID_INBRIN	Paid at BRIN Number for an Incoming Proof of Payment		PIQ_NL_INBRIN	CHAR	8
BRIN_SEQ	BRIN Sequence Number		PIQ_NL_BRINSEQ	NUMC	4
PAID_INSTNAME	Paid at Institute for an Incoming Proof of Payment		PIQ_NL_INSTNAME	CHAR	140
INITAMT	Initial Amount		PIQ_NL_INIAMOUNT	CURR	6
VALUTA_INIT	Currency Key		WAERS	CUKY	10	TCURC
INSTAMT	Incoming Proof of Payment Legal Tuition Fee		PIQ_NL_LEGALTUTFEE	CURR	6
VALUTA_INST	Currency Key		WAERS	CUKY	10	TCURC
PRF_INSTATUS	Incoming Proof of Payment Status		PIQ_NL_PINSTATUS	CHAR	2
RECEIV_BY	Received By (User Name)		PIQ_NL_RECIEVBY	CHAR	70
RECEIPT_DATE	Receipt Date		PIQ_NL_RECEIPTDATE	DATS	16
INCANCEL_BY	Incoming Proof of Payment Cancelled By (User Name)		PIQ_NL_INCANCELLEDBY	CHAR	70
INCANCEL_ON	Incoming Proof of Payment Cancellation Date		PIQ_NL_INCANCELLEDDATE	DATS	16
TOTAL_AMT	Amount		PIQ_NL_AMOUNT	CURR	6
VALUTA_TOT	Currency Key		WAERS	CUKY	10	TCURC
INST_BRIN	Institute BRIN Number		PIQ_NL_BRIN	CHAR	8
PRF_OUTSTATUS	Outgoing Proof of Payment Status		PIQ_NL_POUTSTATUS	CHAR	2
REG_BY	Registered By (User Name)		PIQ_NL_REGISTBY	CHAR	70
REG_DATE	Registered Date		PIQ_NL_REGISTDATE	DATS	16
OUTCANCEL_BY	Outgoing Proof of Payment Cancelled By (User Name)		PIQ_NL_OUTCANCELLEDBY	CHAR	70
OUTCANCEL_ON	Outgoing Proof of Payment Cancellation Date		PIQ_NL_OUTCANCELLEDDATE	DATS	16
LEGAL_TUTFEE	Outgoing Proof of Payment Legal Tuition Fee		PIQ_NL_OUTLEGALTUTFEE	CURR	6
VALUTA_LEGLFEE	Currency Key		WAERS	CUKY	10	TCURC
INST_TUTFEE	Institute Tuition Fee		PIQ_NL_INSTTUTFEE	CURR	6
VALUTA_INSTFEE	Currency Key		WAERS	CUKY	10	TCURC
IBAN	IBAN (International Bank Account Number)		IBAN	CHAR	68
MAND_REFID	Unique Reference to Mandate for each Payee		SEPA_MNDID	CHAR	70
BIC	SWIFT Code/Bank Identifier Code (BIC)		BICSW_KK	CHAR	22
EMANDATE_IND	Indicator		PIQ_NL_INDICATE	CHAR	2
AUTHISSUE_REUSEDATE	Issue Date Re-Use		PIQ_NL_AUTHREUSEDATE	DATS	16
TABNR	Reference Number to Table Part		HRTABNR	CHAR	64