IHC_DB_PN - Source Document for Incoming Payment Orders

Source Document for Incoming Payment Orders information is stored in SAP table IHC_DB_PN.
It is part of development package FIN_IHC in software component FIN-FSCM-IHC. This development package consists of objects that can be grouped under "Payment Order In-House Cash".

Fields for table IHC_DB_PN

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
GUID	GUID in 'RAW' format	X	GUID_16	RAW	16
.INCLUDE				IHC_STR_PN_SEMKEY	0
UNIT	Bank Area		IHC_DTE_UNIT	CHAR	8
PN_NUMBER	Payment Order Number		IHC_DTE_PN_NUMBER	NUMC	20
PN_YEAR	Fiscal Year of IHC Payment Order		IHC_DTE_PN_JAHR	NUMC	8
.INCLUDE				IHC_STR_PN_STATKEY	0
STATUS_CNT	Counter (includ. Status)		IHC_DTE_COUNTER	NUMC	12
BLOCK	Item Is Locked for Automatic Processing		IHC_DTE_PN_BLOCK	CHAR	2
ERROR	Error in Processing		IHC_DTE_PN_ERROR	CHAR	2
.INCLUDE				IHC_STR_PN_DATA	0
LAST_GUI_STATUS	Status of the Payment Order		IHC_DTE_GUI_STATUS	CHAR	4
PAY_BANK_KEY	Sender Bank Key		IHC_DTE_PN_PAY_BANK_KEY	CHAR	30
PAY_PRI_BNKID	Payer Primary Bank ID		IHC_DTE_PN_PAY_PRI_BNKID	CHAR	30
PAY_PRI_IDQUAL	Qualifier for Primary Bank ID		IHC_DTE_PN_PRI_IDQUAL	CHAR	12
PAY_SEC_BNKID	Payer Secondary Bank ID		IHC_DTE_PN_PAY_SEC_BNKID	CHAR	30
PAY_SEC_IDQUAL	Qualifier for Secondary Bank ID		IHC_DTE_PN_SEC_IDQUAL	CHAR	12
PAY_BKONT	Payer Bank Control Key		IHC_DTE_PN_PAY_BKONT	CHAR	4
PAY_BANK_NAME	Payer Name of Financial Institution		IHC_DTE_PN_PAY_BANK_NAME	CHAR	120
PAY_BANK_CNTRY	Payer Bank Country		IHC_DTE_PN_PAY_BANK_CNTRY	CHAR	6	*
PAY_ACCHO_NAME	Name of Account Holder for Payer Account		IHC_DTE_PN_PAY_ACCHO_NAME	CHAR	120
PAY_ACCHO_CNTRY	Payer Country Key		IHC_DTE_PN_PAY_ACCHO_CNTRY	CHAR	6	*
PAY_ACCTNO	Payer Account Number		IHC_DTE_PN_PAY_ACCTNO	CHAR	70
PAY_IBAN	Payer IBAN		IHC_DTE_PN_PAY_IBAN	CHAR	68
PAY_ACCTCURR	Payer Account Currency		IHC_DTE_PN_PAY_ACCTCURR	CUKY	10	*
PAY_AMOUNT	Payer Amount in Account Currency		IHC_DTE_PN_PAY_AMOUNT	CURR	9
PAY_VALUE_DATE	Payer Value Date		IHC_DTE_PN_PAY_VALUE_DATE	DATS	16
PAY_EXRATE	Payer Exchange Rate		IHC_DTE_PN_PAY_EXRATE	DEC	5
PAY_AMOUNT_PRIM	Payer Amount in Account Currency		IHC_DTE_PN_PAY_AMOUNT_EXT	CURR	9
PAY_EXRATE_PRIM	Payer Exchange Rate		IHC_DTE_PN_PAY_EXRATE_EXT	DEC	5
OPAY_PRI_BNKID	Original Payer Primary Bank ID		IHC_DTE_PN_OPAY_PRI_BNKID	CHAR	30
OPAY_PRI_IDQUAL	Qualifier for Primary Bank ID		IHC_DTE_PN_PRI_IDQUAL	CHAR	12
OPAY_SEC_BNKID	Original Payer Secondary Bank ID		IHC_DTE_PN_OPAY_SEC_BNKID	CHAR	30
OPAY_SEC_IDQUAL	Qualifier for Secondary Bank ID		IHC_DTE_PN_SEC_IDQUAL	CHAR	12
OPAY_BKONT	Original Payer Bank Control Key		IHC_DTE_PN_OPAY_BKONT	CHAR	4
OPAY_BANK_NAME	Original Payer Name of Financial Institution		IHC_DTE_PN_OPAY_BANK_NAME	CHAR	120
OPAY_BANK_CNTRY	Original Payer Bank Country Key		IHC_DTE_PN_OPAY_BANK_CNTRY	CHAR	6	*
OPAY_ACCHO_NAME	Original Payer Name of Account Holder		IHC_DTE_PN_OPAY_ACCHO_NAME	CHAR	120
OPAY_ACCHO_CNTRY	Original Payer Country Key		IHC_DTE_PN_OPAY_ACCHO_CNTRY	CHAR	6	*
OPAY_ACCTNO	Original Payer Account Number		IHC_DTE_PN_OPAY_ACCTNO	CHAR	70
OPAY_IBAN	Original Payer IBAN		IHC_DTE_PN_OPAY_IBAN	CHAR	68
OPAY_ACCTCURR	Original Payer Account Currency		IHC_DTE_PN_OPAY_ACCTCURR	CUKY	10	*
OPAY_VALUE_DATE	Original Payer Value Date		IHC_DTE_PN_OPAY_VALUE_DATE	DATS	16
OPAY_EXRATE	Original Payer Exchange Rate		IHC_DTE_PN_OPAY_EXRATE	DEC	5
REC_BANKL	Recipient Bank Key		IHC_DTE_PN_REC_BANKL	CHAR	30
REC_PRI_BNKID	Recipient Primary Bank ID		IHC_DTE_PN_REC_PRI_BNKID	CHAR	30
REC_PRI_IDQUAL	Qualifier for Primary Bank ID		IHC_DTE_PN_PRI_IDQUAL	CHAR	12
REC_SEC_BNKID	Recipient Secondary Bank ID		IHC_DTE_PN_REC_SEC_BNKID	CHAR	30
REC_SEC_IDQUAL	Qualifier for Secondary Bank ID		IHC_DTE_PN_SEC_IDQUAL	CHAR	12
REC_BKONT	Recipient Bank Control Key		IHC_DTE_PN_REC_BKONT	CHAR	4
REC_BANK_NAME	Recipient Name of Financial Insitution		IHC_DTE_PN_REC_BANK_NAME	CHAR	120
REC_BANK_CNTRY	Recipient Bank Country		IHC_DTE_PN_REC_BANK_CNTRY	CHAR	6	*
REC_BANK_REF	Recipient Reference Info for Bank Details		IHC_DTE_PN_REC_BANK_REF	CHAR	40
REC_ACCHO_NAME	Name of Account Holder for Recipient Account		IHC_DTE_PN_REC_ACCHO_NAME	CHAR	120
REC_ACCHO_CNTRY	Recipient Country Key		IHC_DTE_PN_REC_ACCHO_CNTRY	CHAR	6	*
REC_ACCTNO	Account Number of Recipient		IHC_DTE_PN_REC_ACCTNO	CHAR	70
REC_IBAN	Recipient IBAN		IHC_DTE_PN_REC_IBAN	CHAR	68
REC_ACCTCURR	Recipient Account Currency		IHC_DTE_PN_REC_ACCTCURR	CUKY	10	*
REC_AMOUNT	Recipient Amount in Account Currency		IHC_DTE_PN_REC_AMNT	CURR	9
REC_VALUE_DATE	Recipient Value Date		IHC_DTE_PN_REC_VALUE_DATE	DATS	16
REC_EXRATE	Recipient Exchange Rate		IHC_DTE_PN_REC_EXRATE	DEC	5
REC_AMOUNT_PRIM	Recipient Amount in Account Currency		IHC_DTE_PN_REC_AMNT_EXT	CURR	9
REC_EXRATE_PRIM	Recipient Exchange Rate		IHC_DTE_PN_REC_EXRATE_EXT	DEC	5
REC_UNIT	Bank Area Recipient		IHC_DTE_PN_REC_UNIT	CHAR	8
CLR_PRI_BNKID	Clearing Partner Primary Bank ID		IHC_DTE_PN_CLR_PRI_BNKID	CHAR	30
CLR_PRI_IDQUAL	Qualifier for Primary Bank ID		IHC_DTE_PN_PRI_IDQUAL	CHAR	12
CLR_SEC_BNKID	Clearing Partner Secondary Bank ID		IHC_DTE_PN_CLR_SEC_BNKID	CHAR	30
CLR_SEC_IDQUAL	Qualifier for Secondary Bank ID		IHC_DTE_PN_SEC_IDQUAL	CHAR	12
CLR_BKONT	Clearing Partner Bank Control Key		IHC_DTE_PN_CLR_BKONT	CHAR	4
CLR_BANK_NAME	Clearing Partner Name of Financial Institution		IHC_DTE_PN_CLR_BANK_NAME	CHAR	120
CLR_BANK_CNTRY	Clearing Partner Country Key of Bank		IHC_DTE_PN_CLR_BANK_CNTRY	CHAR	6	*
CLR_ACCHO_NAME	Clearing Partner Name of Account Holder		IHC_DTE_PN_CLR_ACCHO_NAME	CHAR	120
CLR_ACCHO_CNTRY	Clearing Partner Country Key		IHC_DTE_PN_CLR_ACCHO_CNTRY	CHAR	6	*
CLR_ACCTNO	Clearing Partner Account Number		IHC_DTE_PN_CLR_ACCTNO	CHAR	70
CLR_IBAN	Clearing Partner IBAN		IHC_DTE_PN_CLR_IBAN	CHAR	68
CLR_ACCTCURR	Clearing Partner Account Currency		IHC_DTE_PN_CLR_ACCTCURR	CUKY	10	*
CLR_AMOUNT	Clearing Partner Amount in Account Currency		IHC_DTE_PN_CLR_AMOUNT	CURR	9
CLR_VALUE_DATE	Clearing Partner Value Date		IHC_DTE_PN_CLR_VALUE_DATE	DATS	16
CLR_EXRATE	Clearing Partner Exchange Rate		IHC_DTE_PN_CLR_EXRATE	DEC	5
CLR_AMOUNT_PRIM	Clearing Partner Amount in Account Currency		IHC_DTE_PN_CLR_AMOUNT_EXT	CURR	9
CLR_EXRATE_PRIM	Clearing Partner Exchange Rate		IHC_DTE_PN_CLR_EXRATE_EXT	DEC	5
CLR_PRTNR_TYPE	Clearing Partner Type		IHC_DTE_PN_CLR_TYPE	CHAR	6
TRNS_TYPE	Transaction Type		IHC_DTE_PN_TRNS_TYPE	CHAR	12	IHC_TAB_TRANS
TRNS_DIRECTION	Bank Transfer		IHC_DTE_PN_DIRECTION	CHAR	2
TRNS_AMOUNT	Transaction Amount		IHC_DTE_TRANSACTION_AMOUNT	CURR	9
TRNS_CURR	Transaction Currency		IHC_DTE_TRANSACTION_CURRENCY	CUKY	10	*
PL_PROC_DATE	Date Executed		IHC_DTE_PN_PROC_DATE	DATS	16
PL_POST_DATE	Posting Date		IHC_DTE_PN_POST_DATE	DATS	16
EXEC_INSTRUCT	Execution Instruction		IHC_DTE_PN_INSTRUCT	CHAR	16	*
CRUSR	Created By		IHC_DTE_CREATE_USER	CHAR	24
CRDAT	Created On		IHC_DTE_CREATE_DATE	DATS	16
CRTIM	Created At		IHC_DTE_CREATE_TIME	TIMS	12
INPUT_CHANNEL	Input Channel		IHC_DTE_CHANNEL	CHAR	16
CHUSR	Changed By		IHC_DTE_CHANGE_USER	CHAR	24
CHDAT	Changed On		IHC_DTE_CHANGE_DATE	DATS	16
CHTIM	Changed At		IHC_DTE_CHANGE_TIME	TIMS	12
REUSR	Released By		IHC_DTE_RELEASE_USER	CHAR	24
REDAT	Released On		IHC_DTE_RELEASE_DATE	DATS	16
RETIM	Released At		IHC_DTE_RELEASE_TIME	TIMS	12
ARUSR	Archiving: User Name		IHC_DTE_ARCHIVED_USER	CHAR	24
ARDAT	Archiving Date		IHC_DTE_ARCHIVED_DATE	DATS	16
ARTIM	Archiving Time		IHC_DTE_ARCHIVED_TIME	TIMS	12
CS_PAY_FLAG	Currency Conversion for Sender Item		IHC_DTE_FLG_CS_SND	CHAR	2
CS_REC_FLAG	Currency Conversion for Recipient Item		IHC_DTE_FLG_CS_RCV	CHAR	2
RCV_EXTERN	Indicator: Enter External Forward		IHC_DTE_PN_RCV_EXTERN	CHAR	2
CLR_PRTNR_ID	Clearing Partner		IHC_DTE_PN_PRTNR_ID	CHAR	8
EXT_PAY	External Payment		IHC_DTE_PN_EXTPAY	CHAR	2
CHECK_PAY	This is a check payment		IHC_DTE_PN_CHECK_PAY	CHAR	2
SINGLE_PAY	IHC: Flag for Single Payment		IHC_DTE_PN_SINGLE_PAY	CHAR	2
IN_IDOC_NUMBER	IDoc number		EDI_DOCNUM	NUMC	32
OUT_IDOC_NUMBER	IDoc number		EDI_DOCNUM	NUMC	32
IN_RZAWE	Delivered Payment Method		IHC_DTE_IN_RZAWE	CHAR	2	*
IN_UZAWE	Delivered Payment Method Supplement		IHC_DTE_IN_UZAWE	CHAR	4	*
OUT_RZAWE	Payment Method for This Payment		RZAWE	CHAR	2	*
OUT_UZAWE	Payment method supplement		UZAWE	CHAR	4	*
PAYRQ_NO	Key Number for Payment Request		PRQ_KEYNO	CHAR	20	*
IN_IDOC_MESTYP	Message Type		EDI_MESTYP	CHAR	60	*
OUT_IDOC_MESTYP	Message Type		EDI_MESTYP	CHAR	60	*
INSTRUCTION_CODE	IHC Instruction Key		IHC_DTE_INSTRUCTION_CODE	CHAR	32	IHC_TAB_INST_KEY
INSTRUCTION1	Execution Instruction 1		IHC_DTE_PN_INSTRUCT1	CHAR	16	IHC_TAB_INST
INSTRUCTION2	Execution Instruction 2		IHC_DTE_PN_INSTRUCT2	CHAR	16	IHC_TAB_INST
INSTRUCTION3	Execution Instruction 3		IHC_DTE_PN_INSTRUCT3	CHAR	16	IHC_TAB_INST
INSTRUCTION4	Execution Instruction 4		IHC_DTE_PN_INSTRUCT4	CHAR	16	IHC_TAB_INST
CENTRAL_BANK_IND	State Central Bank Indicator		IHC_DTE_CENTRAL_BANK_INDICATOR	CHAR	6	*
SUPPLY_COUNTRY	Supplying Country		IHC_DTE_SUPPLY_COUNTRY	CHAR	6	*
XBS_KUKEY	Short key (surrogate)		BF_KUKEYEB	NUMC	16
XBS_POSITION	Memo record number (line item number in bank statement)		BF_ESNUMEB	NUMC	10
ARCHIVED	Payment Order Archived		IHC_DTE_ARCHIVED	CHAR	2
.INCLUDE				IHC_STR_PN_AWPARAMS	0
AWSYS	Logical system of source document		AWSYS	CHAR	20	*
AWTYP	Reference procedure		AWTYP	CHAR	10	*
AWKEY	Reference Key		AWKEY	CHAR	40
.INCLUDE				IHC_STR_BLK_IND	0
XPCPT	Business Purpose Completed Flag		IHC_DTE_XPCPT	CHAR	2
IHC_NOTIF_STATUS	Notification Status for In-House Cash Payment Order		IHC_NOTIF_STATUS	CHAR	2