P_ARBSItmMatchedItm

Matched Receivables with corresponding Bank Statement Item | view: PARBSITMTCITM | Extraction: Not supported | Component: Financial Cash Application Intelligence
Column Name Description
Column Name Description
BSAmountInTransactionCurrency Amount in Account Currency
BSAmountInOriginalCurrency Foreign Currency Amount (Different from Account Currency)
PIAmountInCompanyCodeCurrency Amount in Company Code Currency
MIAmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Transaction Currency (PITransactionCurrency):
PIAmountInTransactionCurrency Amount in Transaction Currency
💲 Transaction Currency (MITransactionCurrency):
MIAmountInTransactionCurrency Amount in Transaction Currency
Column Name Description
Column Name Description
BSBankStatementDate Bank Statement Date
BSBankStatementImportDate Bank Statement Import Date into System
BSBankStatementImportTime Bank Statement Import Time into System
BSPostingDate Posting Date in the Document
PIPostingDate Posting Date
PIAccountingDocCreationDate Accounting Document Entry Date
PICreationTime Creation Time
PIClearingCreationDate Clearing Creation Date
MIPostingDate Posting Date
MIAccountingDocCreationDate Accounting Document Entry Date
MICreationTime Creation Time
MIClearingCreationDate Clearing Creation Date
Column Name Description
BSPaymentAdviceAccountType Payment Advice Account Type Show values
BSBankLedgerIsPosted Indicator that posting Area 1 was posted or not Show values
BSSubledgerIsPosted Indicator that posting Area 2 was posted or not Show values
BSInterpretationAlgorithm Interpretation Algorithm Show values
PIDebitCreditCode Debit/Credit Code Show values
PIFinancialAccountType Account Type Show values
MIDebitCreditCode Debit/Credit Code Show values
MIFinancialAccountType Account Type Show values
Column Name Description Domain name
BSBankStatementShortID Bank Statement Short Key FARP_KUKEY
BSBankStatementItem Line Item Number FARP_ESNUM
BSBankStatement Bank Statement Number FARP_AZNUM
BSHouseBank Short Key for a House Bank HBKID
BSHouseBankAccount ID for Account Details HKTID
BSFiscalYear Fiscal Year GJAHR
BSCreatedByUser User who uploaded the file into the System CHAR12
BSPaymentAdviceAccount Account Number KTONR
BSPaymentAdvice Payment Advice Number AVSID
BSCustomerReferenceNumber Check number CHCKN
BSPaymentReference Payment Reference CHAR30
BSDocumentReferenceID Reference Document Number XBLNR1
BSAssignmentReference Assignment number ZUONR
BSBankPostingKey Text Key CHAR4
BSPaymentExternalTransacType External Business Transaction VGEXT_EB
BSDocumentItemText Item Text TEXT50
BSDebitCreditCode Debit/Credit Key for Line Items (for Bank Purposes) CHAR1
BSIsCompleted Line Item Completed CHAR1
BSBusinessPartnerName Business Partner CHAR55
BSPartnerBank Bank Number of Partner Bank BANKK
BSPartnerBankSWIFTCode SWIFT Code of Partner Bank SWIFT
BSPartnerBankAccount Account Number at the Partner Bank BANKN
BSPartnerBankIBAN Partner Bank Account: IBAN IBAN
BSBankLedgerDocument Document Number of an Accounting Document BELNR
BSSubledgerDocument Subledger document number BELNR
BSSubledgerOnAccountDocument Payment on account document number BELNR
BSBankReference Bank Reference Number CHAR35
BSMemoLine Memo Line FAR_MEMO_LINE
BSBankStatementItemPayDoc Subledger document number BELNR
PIAccountingDocument Journal Entry BELNR
PIFiscalYear Fiscal Year GJAHR
PIDocumentReferenceID Document Reference ID XBLNR1
PIOriginalReferenceDocument Original Reference Document AWKEY
PIReferenceDocumentLogicalSys Logical System of Reference Document LOGSYS
PIReferenceDocumentType Reference Document Type AWTYP
PIAccountingDocumentHeaderText Document Header Text TEXT25
PIAccountingDocCreatedByUser User that created the journal entry
PITransactionCode Transaction Code TCODE
PIAccountingDocumentItem Posting View Item BUZEI
PIClearingAccountingDocument Clearing Document Number BELNR
PIClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
PIAssignmentReference Assignment Reference ZUONR
PIPaymentReference Payment Reference CHAR30
PIDocumentItemText Item Text TEXT50
PIInvoiceReference Document No. of the Invoice to Which the Transaction Belongs BELNR
PIInvoiceReferenceFiscalYear Fiscal Year GJAHR
PIInvoiceItemReference Line Item BUZEI
PIFollowOnDocumentType Follow-On Document Type REBZT
MIAccountingDocument Journal Entry BELNR
MIFiscalYear Fiscal Year GJAHR
MIDocumentReferenceID Document Reference ID XBLNR1
MIOriginalReferenceDocument Original Reference Document AWKEY
MIReferenceDocumentLogicalSys Logical System of Reference Document LOGSYS
MIReferenceDocumentType Reference Document Type AWTYP
MIAccountingDocumentHeaderText Document Header Text TEXT25
MIAccountingDocCreatedByUser User that created the journal entry
MITransactionCode Transaction Code TCODE
MIAccountingDocumentItem Posting View Item BUZEI
MIClearingAccountingDocument Clearing Document Number BELNR
MIClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
MIAssignmentReference Assignment Reference ZUONR
MIPaymentReference Payment Reference CHAR30
MIDocumentItemText Item Text TEXT50
MIInvoiceReference Document No. of the Invoice to Which the Transaction Belongs BELNR
MIInvoiceReferenceFiscalYear Fiscal Year GJAHR
MIInvoiceItemReference Line Item BUZEI
MIFollowOnDocumentType Follow-On Document Type REBZT
Master Data Relations Join Conditions
Input Help for Posting Rule (Internal Activity)
  • Client
  • Bank Statement Posting Rule
  • P_ARBSITMMATCHEDITM.MANDT == T028D.MANDT
  • P_ARBSITMMATCHEDITM.BSBANKSTATEMENTPOSTINGRULE == T028D.VGINT
Company code
  • Company Code
  • Company Code
  • Company Code
  • Client
  • P_ARBSITMMATCHEDITM.MICOMPANYCODE == T001.BUKRS
  • P_ARBSITMMATCHEDITM.PICOMPANYCODE == T001.BUKRS
  • P_ARBSITMMATCHEDITM.BSCOMPANYCODE == T001.BUKRS
  • P_ARBSITMMATCHEDITM.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • P_ARBSITMMATCHEDITM.BSCURRENCY == TCURC.WAERS
  • P_ARBSITMMATCHEDITM.MANDT == TCURC.MANDT
Foreign currency (not account currency)
  • Payment Currency Key
  • Client
  • P_ARBSITMMATCHEDITM.BSORIGINALCURRENCY == TCURC.WAERS
  • P_ARBSITMMATCHEDITM.MANDT == TCURC.MANDT
Partner Bank
  • Country/Region Key of Partner Bank
  • Client
  • P_ARBSITMMATCHEDITM.BSPARTNERBANKCOUNTRY == T005.LAND1
  • P_ARBSITMMATCHEDITM.MANDT == T005.MANDT
Journal Entry Type
  • Journal Entry Type
  • Journal Entry Type
  • Client
  • P_ARBSITMMATCHEDITM.PIACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_ARBSITMMATCHEDITM.MIACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_ARBSITMMATCHEDITM.MANDT == T003.MANDT
Company Code
  • Company Code
  • Company Code
  • Company Code
  • Client
  • P_ARBSITMMATCHEDITM.MICOMPANYCODE == T001.BUKRS
  • P_ARBSITMMATCHEDITM.PICOMPANYCODE == T001.BUKRS
  • P_ARBSITMMATCHEDITM.BSCOMPANYCODE == T001.BUKRS
  • P_ARBSITMMATCHEDITM.MANDT == T001.MANDT
Customer
  • Customer
  • Customer
  • Client
  • P_ARBSITMMATCHEDITM.MIDEBTOR == KNA1.KUNNR
  • P_ARBSITMMATCHEDITM.PIDEBTOR == KNA1.KUNNR
  • P_ARBSITMMATCHEDITM.MANDT == KNA1.MANDT
Transaction Currency
  • Transaction Currency
  • Transaction Currency
  • Client
  • P_ARBSITMMATCHEDITM.MITRANSACTIONCURRENCY == TCURC.WAERS
  • P_ARBSITMMATCHEDITM.PITRANSACTIONCURRENCY == TCURC.WAERS
  • P_ARBSITMMATCHEDITM.MANDT == TCURC.MANDT
Journal Entry Type
  • Journal Entry Type
  • Journal Entry Type
  • Client
  • P_ARBSITMMATCHEDITM.PIACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_ARBSITMMATCHEDITM.MIACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_ARBSITMMATCHEDITM.MANDT == T003.MANDT
Company Code
  • Company Code
  • Company Code
  • Company Code
  • Client
  • P_ARBSITMMATCHEDITM.MICOMPANYCODE == T001.BUKRS
  • P_ARBSITMMATCHEDITM.PICOMPANYCODE == T001.BUKRS
  • P_ARBSITMMATCHEDITM.BSCOMPANYCODE == T001.BUKRS
  • P_ARBSITMMATCHEDITM.MANDT == T001.MANDT
Customer
  • Customer
  • Customer
  • Client
  • P_ARBSITMMATCHEDITM.MIDEBTOR == KNA1.KUNNR
  • P_ARBSITMMATCHEDITM.PIDEBTOR == KNA1.KUNNR
  • P_ARBSITMMATCHEDITM.MANDT == KNA1.MANDT
Transaction Currency
  • Transaction Currency
  • Transaction Currency
  • Client
  • P_ARBSITMMATCHEDITM.MITRANSACTIONCURRENCY == TCURC.WAERS
  • P_ARBSITMMATCHEDITM.PITRANSACTIONCURRENCY == TCURC.WAERS
  • P_ARBSITMMATCHEDITM.MANDT == TCURC.MANDT