C_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
Column Name Description
Column Name Description
ValueDate Value Date of the Item to Be Cleared
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
Column Name Description Domain name
LockboxBatchItmStatusName Lockbox Batch Status Description DDTEXT
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
PaymentAdvice Payment Advice Number AVSID
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
SubledgerDocument Subledger document number BELNR
Master Data Relations Join Conditions
Company code
  • Company Code
  • Client
  • C_ARLOCKBOXBATCHITEM.COMPANYCODE == T001.BUKRS
  • C_ARLOCKBOXBATCHITEM.MANDT == T001.MANDT
Partner Bank
  • Client
  • Partner Bank Account: Bank Country/Region Key
  • C_ARLOCKBOXBATCHITEM.MANDT == T005.MANDT
  • C_ARLOCKBOXBATCHITEM.PARTNERBANKCOUNTRY == T005.LAND1