P_ARLockBoxBatchItem

Lockbox Batch Item Details Aggegation | view: PARLOCKBOXITEM | Extraction: Not supported | Component: Fiori UI for Accounts Receivable
Column Name Description
LockboxBatchInternalKey Short Key for Bank Statement (Surrogate Key)
LockboxBatchItem Memo Record Number (Line Item Number in Bank Statement)
LockboxBatch Batch Number (Bundle Number)
Column Name Description
AmountInTransactionCurrency Amount in Account Currency
AmountInOriginalCurrency Foreign Currency Amount (Different from Account Currency)
💲 Account Currency Key (Currency):
FeeAmountInTransactionCrcy Fees in Account Currency
OverdueChargeAmtInTransacCrcy Overdue Charges from/to Partners in Account Currency
💲 Foreign Currency Key (Not Account Currency) (OriginalCurrency):
FeeAmountInOriginalCrcy Fees in Foreign Currency (Not Same as Account Currency)
Column Name Description
Column Name Description
ValueDate Value Date of the Item to Be Cleared
BankPostingDate Posting Date at the Bank
PostingDate Posting Date in the Document
Column Name Description
MemoLineIsChanged Note to Payee Has Been Changed Manually Show values
PaymentAdviceAccountType Payment Advice Account Type Show values
TreasuryContractType Contract Type Show values
MachineLrngBankStmntItemStatus Machine Learning Status of Item Show values
Column Name Description Domain name
LockboxBatchItmStatus null
BankStatementItemDraftUUID Draft key (raw16) RAW16
BankStatementInternalID Temporary Accounting Document ID FDC_ACCDOC_TMP_DOC_ID
LockboxProcessingStatus null
Cheque Check number CHCKN
PartnerBank Bank Number of Partner Bank BANKK
PartnerBankAccount Account Number at the Partner Bank BANKN
BankLedgerDocument Document Number of an Accounting Document BELNR
BankLedgerAcctgDocFiscalYear Fiscal Year of Bank Accounting Document GJAHR
ApplicationLog null
MemoLine1 Payment Notes CHAR65
MemoLine null
AssignmentReference Assignment number ZUONR
PaymentExternalTransacType External Business Transaction VGEXT_EB
DocumentItemText Item Text TEXT50
DocumentReferenceID Reference Document Number XBLNR1
PaymentManualTransacType Transaction VGMAN_EB
BankLedgerIsPosted Update 1 OK CHAR1
SubledgerIsPostedSuccessfully 2nd Update OK CHAR1
LockboxSubledgerDocument Number of Second Subledger Document BELNR
FiscalYear Fiscal Year GJAHR
SubledgerDocument Subledger document number BELNR
SubledgerAcctgDocFiscalYear Fiscal Year of Subledger Accounting Document GJAHR
PaymentAdvice Payment Advice Number AVSID
NumberOfSecondSubledgerDoc Number of Second Subledger Document BELNR
SubledgerOnAccountDocument Payment on account document number BELNR
accdoc_tmp_doc_id Temporary Accounting Document ID FDC_ACCDOC_TMP_DOC_ID
DebitCreditCode Debit/Credit Key for Line Items (for Bank Purposes) CHAR1
BankPostingKey Text Key CHAR4
BankReference Bank Reference Number CHAR35
BusinessArea Business Area CHAR4
BusinessPartnerName Business Partner CHAR55
TreasuryContract Contract Number RANL
DaybookEntry Daybook Number CHAR10
DunningBlockingReason Dunning Block MANSP
ExchangeRate Exchange Rate: Foreign Currency to Account Currency KURSF
IsCompleted Line Item Completed CHAR1
PartnerBankIBAN Partner Bank Account: IBAN IBAN
PartnerBankSWIFTCode SWIFT Code of Partner Bank SWIFT
PaymentAdviceAccount Account Number KTONR
PaymentAdviceAccountTypeName Short Text for Fixed Values DDTEXT
PaymentReference Payment Reference CHAR30
PostingErrorStatus Error Status CHAR4
ProfitCenter Profit Center PRCTR
ReferenceDocument Reference Key AWKEY
ReferenceDocumentType Reference procedure AWTYP
ReturnReason Customer-to-Customer Reference CHAR35
ValueDateTime Value Date Time TIME6
CostCenter Cost Center CHAR10
AdditionalInformation Additional information from file ADDITIONAL_INFO_EB
Master Data Relations Join Conditions
Reprocessing Reason Code
  • Reprocessing Reason Code
  • Client
  • P_ARLOCKBOXBATCHITEM.BANKSTMNTITEMREPROCESSREASON == FEB_REPRO_RRC.REPROCREASONCODE
  • P_ARLOCKBOXBATCHITEM.MANDT == FEB_REPRO_RRC.MANDT
Company code
  • Company Code
  • Client
  • P_ARLOCKBOXBATCHITEM.COMPANYCODE == T001.BUKRS
  • P_ARLOCKBOXBATCHITEM.MANDT == T001.MANDT
Foreign currency (not account currency)
  • Foreign Currency Key (Not Account Currency)
  • Client
  • P_ARLOCKBOXBATCHITEM.ORIGINALCURRENCY == TCURC.WAERS
  • P_ARLOCKBOXBATCHITEM.MANDT == TCURC.MANDT
Partner Bank
  • Client
  • Country/Region Key of Partner Bank
  • P_ARLOCKBOXBATCHITEM.MANDT == T005.MANDT
  • P_ARLOCKBOXBATCHITEM.PARTNERBANKCOUNTRY == T005.LAND1