I_ARLockBoxBatch

Lock Box Batch Header Data | view: IARLOCKBOXBATCH | Extraction: Not supported | Component: Fiori UI for Accounts Receivable
Column Name Description
LockboxBatchInternalKey Short Key for Bank Statement (Surrogate Key)
LockboxBatch Batch Number (Bundle Number)
Column Name Description
💲 null (Currency):
AmountInTransactionCurrency Payment Amount
Column Name Description
Column Name Description
DepositDate Deposit Date
DepositTime Deposit Time
BankStatementImportDate Import Date into Bank Data Buffer
BankStatementImportTime Import Time into Bank Data Buffer
Column Name Description
LockboxBatchStatus Lockbox Batch Status Code Show values
BatchIsLatest Latest Lockbox Batch Show values
Column Name Description Domain name
LockboxBatchDestination null
LockboxBatchOrigin null
Lockbox Lockbox Number CHAR7
HouseBank House Bank Key HBKID
HouseBankAccount House Bank Account HKTID
NumberOfItems Number of Checks in Lockbox Batch INT2
NumberOfIncompleteCheques Number of Incomplete Cheques in Lockbox Batch INT2
IncomingPaymentFile Incoming Payment File ID FARP_EFILEID
LockboxBatchStatusName Lockbox Batch Status Description DDTEXT
BankAccount Bank account number BANKN
BankAccountHolderName Bank Account Holder CHAR35
BankAccountAdditionalName Special Account Name CHAR35
BankAccountType Bank Account Type CHAR23
BankName Name of Financial Institution TEXT60
CreatedByUser User Who Fills the Bank Data Buffer CHAR12
InterestRateInPercent Credit Interest HZINS_EB
BankAccountReferenceText Reference Details for Bank Details CHAR20
Master Data Relations Join Conditions
Bank Account Technical ID
  • Client
  • ?
  • Bank Account Technical ID
  • I_ARLOCKBOXBATCH.MANDT == FCLM_BAM_AMD.MANDT
  • I_ARLOCKBOXBATCH.[column in domain "FCLM_REVISION"] == FCLM_BAM_AMD.REVISION
  • I_ARLOCKBOXBATCH.BANKACCOUNTINTERNALID == FCLM_BAM_AMD.ACC_ID
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_ARLOCKBOXBATCH.CHARTOFACCOUNTS == T004.KTOPL
  • I_ARLOCKBOXBATCH.MANDT == T004.MANDT
Company code
  • Client
  • Company Code
  • I_ARLOCKBOXBATCH.MANDT == T001.MANDT
  • I_ARLOCKBOXBATCH.COMPANYCODE == T001.BUKRS
General ledger account
  • Client
  • Company Code
  • General Ledger Account
  • I_ARLOCKBOXBATCH.MANDT == SKB1.MANDT
  • I_ARLOCKBOXBATCH.COMPANYCODE == SKB1.BUKRS
  • I_ARLOCKBOXBATCH.GLACCOUNT == SKB1.SAKNR