I_CN_BankRecnclnItem

Column Name Description
CompanyCode Company Code
HouseBank Short Key for a House Bank
HouseBankAccount ID for Account Details
BankReconciliationDate Reconciliation Date
Column Name Description
💲 Currency Key (HouseBankCurrency):
AdjustedGLAcctBalanceAmt Adjusted G/L Account Balance
AdjustedBkAcctBalanceAmt Adjusted Bank Account Balance
BankAcctBalanceAmt Bank Account Balance
GLAcctBalanceAmt G/L Account Balance
UnmatchedIncgBkStmntPayt Unmatched Incoming Payment in Bank Statment
UnmatchedOutgBkStmntPayt Unmatched Outcoming Payment in Bank Statement
UnmatchedIncgJrnlEntrPayt Unmatched Incoming Payment in Journal Entry
UnmatchedOutgJrnlEntrPayt Unmatched Outcoming Payment in Journal Entry
Column Name Description
Column Name Description
BankReconciliationDate Reconciliation Date
LastBankReconciliationDate Last Reconciliation Date
Column Name Description
BankReconciliationStatus Bank Reconciliation Status Show values
Column Name Description Domain name
Ledger Ledger in General Ledger Accounting FINS_LEDGER
BankAccount Bank account number BANKN
BankAccountReferenceText Reference Information CHAR27
BankName Name of Financial Institution TEXT60
CreationUserName User Who Last Changed Bank Reconciliation Statement UNAME
LastChangeDateTime Timestamp when Data of EPIC BRS was last Changed TZNTSTMPS
Master Data Relations Join Conditions
General ledger account
  • Company Code
  • Client
  • General Ledger Account
  • I_CN_BANKRECNCLNITEM.COMPANYCODE == SKB1.BUKRS
  • I_CN_BANKRECNCLNITEM.MANDT == SKB1.MANDT
  • I_CN_BANKRECNCLNITEM.GLACCOUNT == SKB1.SAKNR