I_ARLockBoxBatchItem

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
💲 Account Currency Key (Currency):
AmountInTransactionCurrency Payment Amount
FeeAmountInTransactionCrcy Fees in Account Currency
FeeAmountInOriginalCrcy Fees in Foreign Currency (Not Same as Account Currency)
AmountInOriginalCurrency Foreign Currency Amount (Different from Account Currency)
OverdueChargeAmtInTransacCrcy Overdue Charges from/to Partners in 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
LockboxBatchItmStatus Lockbox Batch Item Status 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
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
LockboxBatchItmStatusName Lockbox Batch Status Description DDTEXT
IsCompleted Line Item Completed CHAR1
Cheque Cheque Number CHCKN
PartnerBank Partner Bank Account: Bank Number BANKK
PartnerBankAccount Partner Bank Account: Account Number BANKN
BankLedgerDocument Document Number of an Accounting Document BELNR
Customer Customer Number KUNNR
ApplicationLog Constant - application log for UI CHAR3
MemoLine1 Line 1 of Memo Line CHAR65
MemoLine Memo Line FAR_MEMO_LINE
AssignmentReference Assignment number ZUONR
PaymentExternalTransacType External Payment Transaction CHAR3
DocumentItemText Text Field TEXT50
DocumentReferenceID Reference Document Number XBLNR1
PaymentManualTransacType Transaction VGMAN_EB
LockboxSubledgerDocument Number of second subledger document BELNR
FiscalYear Fiscal Year GJAHR
BankLedgerAcctgDocFiscalYear Fiscal Year of Bank Accounting Document GJAHR
SubledgerDocument Subledger document number BELNR
LockboxBatchItmAdditionalInfo Additional information from file ADDITIONAL_INFO_EB
SubledgerAcctgDocFiscalYear Fiscal Year of Subledger Accounting Document GJAHR
PaymentAdvice Payment Advice Number AVSID
SubledgerOnAccountDocument Payment on account document number BELNR
Lockbox Lockbox Number CHAR7
BankStatementItemDraftUUID Draft key (raw16) RAW16
BankStatementInternalID Temporary Accounting Document ID FDC_ACCDOC_TMP_DOC_ID
LockboxProcessingStatus null
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
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
ReferenceDocument Reference Key AWKEY
ReferenceDocumentType Reference procedure AWTYP
ReturnReason Customer-to-Customer Reference CHAR35
ValueDateTime Value Date Time TIME6
CostCenter Cost Center CHAR10
ProfitCenter Profit Center PRCTR
DebitCreditCode Debit/Credit Key for Line Items (for Bank Purposes) CHAR1
Master Data Relations Join Conditions
Reprocessing Reason Code
  • Reprocessing Reason Code
  • Client
  • I_ARLOCKBOXBATCHITEM.BANKSTMNTITEMREPROCESSREASON == FEB_REPRO_RRC.REPROCREASONCODE
  • I_ARLOCKBOXBATCHITEM.MANDT == FEB_REPRO_RRC.MANDT
Company code
  • Company Code
  • Client
  • I_ARLOCKBOXBATCHITEM.COMPANYCODE == T001.BUKRS
  • I_ARLOCKBOXBATCHITEM.MANDT == T001.MANDT
Foreign currency (not account currency)
  • Foreign Currency Key (Not Account Currency)
  • Client
  • I_ARLOCKBOXBATCHITEM.ORIGINALCURRENCY == TCURC.WAERS
  • I_ARLOCKBOXBATCHITEM.MANDT == TCURC.MANDT
Partner Bank
  • Partner Bank Account: Bank Country/Region Key
  • Client
  • I_ARLOCKBOXBATCHITEM.PARTNERBANKCOUNTRY == T005.LAND1
  • I_ARLOCKBOXBATCHITEM.MANDT == T005.MANDT