P_ARBSItmWithPayDoc

Bank Statement Item with its posted Payment Item | view: PARBSITMWPAYDOC | Extraction: Not supported | Component: Financial Cash Application Intelligence
Column Name Description
Column Name Description
AmountInTransactionCurrency Amount in Account Currency
AmountInOriginalCurrency Foreign Currency Amount (Different from Account Currency)
Column Name Description
Column Name Description
BankStatementDate Bank Statement Date
BankStatementImportDate Bank Statement Import Date into System
BankStatementImportTime Bank Statement Import Time into System
PostingDate Posting Date in the Document
Column Name Description
PaymentAdviceAccountType Payment Advice Account Type Show values
BankLedgerIsPosted Indicator that posting Area 1 was posted or not Show values
SubledgerIsPostedSuccessfully Indicator that posting Area 2 was posted or not Show values
InterpretationAlgorithm Interpretation Algorithm Show values
Column Name Description Domain name
BankStatementShortID Bank Statement Short Key FARP_KUKEY
BankStatement Bank Statement Number FARP_AZNUM
HouseBank Short Key for a House Bank HBKID
HouseBankAccount ID for Account Details HKTID
FiscalYear Fiscal Year GJAHR
CreatedByUser User who uploaded the file into the System CHAR12
BankStatementItem Line Item Number FARP_ESNUM
PaymentAdviceAccount Account Number KTONR
PaymentAdvice Payment Advice Number AVSID
CustomerReferenceNumber Check number CHCKN
PaymentReference Payment Reference CHAR30
DocumentReferenceID Reference Document Number XBLNR1
AssignmentReference Assignment number ZUONR
BankPostingKey Text Key CHAR4
PaymentExternalTransacType External Business Transaction VGEXT_EB
DocumentItemText Item Text TEXT50
DebitCreditCode Debit/Credit Key for Line Items (for Bank Purposes) CHAR1
IsCompleted Line Item Completed CHAR1
BusinessPartnerName Business Partner CHAR55
PartnerBank Bank Number of Partner Bank BANKK
PartnerBankSWIFTCode SWIFT Code of Partner Bank SWIFT
PartnerBankAccount Account Number at the Partner Bank BANKN
PartnerBankIBAN Partner Bank Account: IBAN IBAN
BankLedgerDocument Document Number of an Accounting Document BELNR
SubledgerDocument Subledger document number BELNR
SubledgerOnAccountDocument Payment on account document number BELNR
BankReference Bank Reference Number CHAR35
MemoLine Memo Line FAR_MEMO_LINE
BankStatementItemPayDoc Subledger document number BELNR
Master Data Relations Join Conditions
Input Help for Posting Rule (Internal Activity)
  • Client
  • Bank Statement Posting Rule
  • P_ARBSITMWITHPAYDOC.MANDT == T028D.MANDT
  • P_ARBSITMWITHPAYDOC.BANKSTATEMENTPOSTINGRULE == T028D.VGINT
Company code
  • Company Code
  • Client
  • P_ARBSITMWITHPAYDOC.COMPANYCODE == T001.BUKRS
  • P_ARBSITMWITHPAYDOC.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • P_ARBSITMWITHPAYDOC.MANDT == TCURC.MANDT
  • P_ARBSITMWITHPAYDOC.CURRENCY == TCURC.WAERS
Foreign currency (not account currency)
  • Client
  • Payment Currency Key
  • P_ARBSITMWITHPAYDOC.MANDT == TCURC.MANDT
  • P_ARBSITMWITHPAYDOC.ORIGINALCURRENCY == TCURC.WAERS
Partner Bank
  • Country/Region Key of Partner Bank
  • Client
  • P_ARBSITMWITHPAYDOC.PARTNERBANKCOUNTRY == T005.LAND1
  • P_ARBSITMWITHPAYDOC.MANDT == T005.MANDT