IHC_DB_PN

Source Document for Incoming Payment Orders | #transactional | Component: FSCM In-House Cash
Column Name Description
MANDT FK Client
GUID GUID in 'RAW' format
Column Name Description
💲 Payer Account Currency (PAY_ACCTCURR):
PAY_AMOUNT Payer Amount in Account Currency
PAY_AMOUNT_PRIM Payer Amount in Account Currency
💲 Recipient Account Currency (REC_ACCTCURR):
REC_AMOUNT Recipient Amount in Account Currency
REC_AMOUNT_PRIM Recipient Amount in Account Currency
💲 Clearing Partner Account Currency (CLR_ACCTCURR):
CLR_AMOUNT Clearing Partner Amount in Account Currency
CLR_AMOUNT_PRIM Clearing Partner Amount in Account Currency
💲 Transaction Currency (TRNS_CURR):
TRNS_AMOUNT Transaction Amount
Column Name Description
Column Name Description
PAY_VALUE_DATE Payer Value Date
OPAY_VALUE_DATE Original Payer Value Date
REC_VALUE_DATE Recipient Value Date
CLR_VALUE_DATE Clearing Partner Value Date
PL_PROC_DATE Date Executed
PL_POST_DATE Posting Date
CRDAT Created On
CRTIM Created At
CHDAT Changed On
CHTIM Changed At
REDAT Released On
RETIM Released At
ARDAT Archiving Date
ARTIM Archiving Time
Column Name Description
BLOCK Item Is Locked for Automatic Processing Show values
ERROR Error in Processing Show values
LAST_GUI_STATUS Status of the Payment Order Show values
CLR_PRTNR_TYPE Clearing Partner Type Show values
TRNS_DIRECTION Bank Transfer Show values
INPUT_CHANNEL Input Channel Show values
CS_PAY_FLAG Currency Conversion for Sender Item Show values
CS_REC_FLAG Currency Conversion for Recipient Item Show values
EXT_PAY External Payment Show values
ARCHIVED Payment Order Archived Show values
XPCPT Business Purpose Completed Flag Show values
IHC_NOTIF_STATUS Notification Status for In-House Cash Payment Order Show values
Column Name Description Domain name
UNIT Bank Area IHC_DOM_UNIT
PN_NUMBER Payment Order Number IHC_DOM_PN_NUMBER
PN_YEAR Fiscal Year of IHC Payment Order JAHR
STATUS_CNT Counter (includ. Status) NUMC6
PAY_BANK_KEY Sender Bank Key BANKK
PAY_PRI_BNKID Payer Primary Bank ID BANKL
PAY_PRI_IDQUAL Qualifier for Primary Bank ID CHAR6
PAY_SEC_BNKID Payer Secondary Bank ID BANKL
PAY_SEC_IDQUAL Qualifier for Secondary Bank ID CHAR6
PAY_BKONT Payer Bank Control Key BKONT
PAY_BANK_NAME Payer Name of Financial Institution TEXT60
PAY_BANK_CNTRY Payer Bank Country LAND1
PAY_ACCHO_NAME Name of Account Holder for Payer Account KOINH
PAY_ACCHO_CNTRY Payer Country Key LAND1
PAY_ACCTNO Payer Account Number CHAR35
PAY_IBAN Payer IBAN IBAN
PAY_EXRATE Payer Exchange Rate NIHC_EXRATE
PAY_EXRATE_PRIM Payer Exchange Rate NIHC_EXRATE
OPAY_PRI_BNKID Original Payer Primary Bank ID BANKL
OPAY_PRI_IDQUAL Qualifier for Primary Bank ID CHAR6
OPAY_SEC_BNKID Original Payer Secondary Bank ID BANKL
OPAY_SEC_IDQUAL Qualifier for Secondary Bank ID CHAR6
OPAY_BKONT Original Payer Bank Control Key BKONT
OPAY_BANK_NAME Original Payer Name of Financial Institution TEXT60
OPAY_BANK_CNTRY Original Payer Bank Country Key LAND1
OPAY_ACCHO_NAME Original Payer Name of Account Holder KOINH
OPAY_ACCHO_CNTRY Original Payer Country Key LAND1
OPAY_ACCTNO Original Payer Account Number CHAR35
OPAY_IBAN Original Payer IBAN IBAN
OPAY_EXRATE Original Payer Exchange Rate NIHC_EXRATE
REC_BANKL Recipient Bank Key BANKK
REC_PRI_BNKID Recipient Primary Bank ID BANKL
REC_PRI_IDQUAL Qualifier for Primary Bank ID CHAR6
REC_SEC_BNKID Recipient Secondary Bank ID BANKL
REC_SEC_IDQUAL Qualifier for Secondary Bank ID CHAR6
REC_BKONT Recipient Bank Control Key BKONT
REC_BANK_NAME Recipient Name of Financial Insitution TEXT60
REC_BANK_CNTRY Recipient Bank Country LAND1
REC_BANK_REF Recipient Reference Info for Bank Details CHAR20
REC_ACCHO_NAME Name of Account Holder for Recipient Account KOINH
REC_ACCHO_CNTRY Recipient Country Key LAND1
REC_ACCTNO Account Number of Recipient CHAR35
REC_IBAN Recipient IBAN IBAN
REC_EXRATE Recipient Exchange Rate NIHC_EXRATE
REC_EXRATE_PRIM Recipient Exchange Rate NIHC_EXRATE
REC_UNIT Bank Area Recipient IHC_DOM_UNIT
CLR_PRI_BNKID Clearing Partner Primary Bank ID BANKL
CLR_PRI_IDQUAL Qualifier for Primary Bank ID CHAR6
CLR_SEC_BNKID Clearing Partner Secondary Bank ID BANKL
CLR_SEC_IDQUAL Qualifier for Secondary Bank ID CHAR6
CLR_BKONT Clearing Partner Bank Control Key BKONT
CLR_BANK_NAME Clearing Partner Name of Financial Institution TEXT60
CLR_BANK_CNTRY Clearing Partner Country Key of Bank LAND1
CLR_ACCHO_NAME Clearing Partner Name of Account Holder KOINH
CLR_ACCHO_CNTRY Clearing Partner Country Key LAND1
CLR_ACCTNO Clearing Partner Account Number CHAR35
CLR_IBAN Clearing Partner IBAN IBAN
CLR_EXRATE Clearing Partner Exchange Rate NIHC_EXRATE
CLR_EXRATE_PRIM Clearing Partner Exchange Rate NIHC_EXRATE
EXEC_INSTRUCT Execution Instruction IHC_DOM_INSTRUCTION
CRUSR Created By USNAM
CHUSR Changed By USNAM
REUSR Released By USNAM
ARUSR Archiving: User Name USNAM
RCV_EXTERN Indicator: Enter External Forward CHAR1
CLR_PRTNR_ID Clearing Partner
CHECK_PAY This is a check payment CHAR1
SINGLE_PAY IHC: Flag for Single Payment CHAR1
IN_IDOC_NUMBER IDoc number EDI_DOCNUM
OUT_IDOC_NUMBER IDoc number EDI_DOCNUM
IN_RZAWE Delivered Payment Method ZLSCH
IN_UZAWE Delivered Payment Method Supplement UZAWE
OUT_RZAWE Payment Method for This Payment ZLSCH
OUT_UZAWE Payment method supplement UZAWE
PAYRQ_NO Key Number for Payment Request PRQ_KEYNO
IN_IDOC_MESTYP Message Type EDI_MESTYP
OUT_IDOC_MESTYP Message Type EDI_MESTYP
CENTRAL_BANK_IND State Central Bank Indicator LZBKZ
SUPPLY_COUNTRY Supplying Country LAND1
XBS_KUKEY Short key (surrogate) BF_KUKEYEB
XBS_POSITION Memo record number (line item number in bank statement) NUM5
AWSYS Logical system of source document LOGSYS
AWTYP Reference procedure AWTYP
AWKEY Reference Key AWKEY
Master Data Relations Join Conditions
Execution Instruction 1
  • Bank Area Recipient
  • ?
  • Execution Instruction 1
Execution Instruction 2
  • Bank Area Recipient
  • ?
  • Execution Instruction 2
Execution Instruction 3
  • Bank Area Recipient
  • ?
  • Execution Instruction 3
Execution Instruction 4
  • Bank Area Recipient
  • ?
  • Execution Instruction 4
IHC Instruction Key
  • IHC Instruction Key
  • Bank Area
Client IHC_DB_PN.MANDT == T000.MANDT
Transaction Type
  • Transaction Type
  • Client