P_CN_HouseBankwithGLBalance

House Bank with GL Balance for BkRecnclnStmnt | view: PCNHSBKWITHGLBAL | Extraction: Not supported | Component: E-Payment Integration China
Column Name Description
CompanyCode Company Code
HouseBank FK Short Key for a House Bank
HouseBankAccount House Bank Account
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AdjustedBkAcctBalanceAmt Adjusted Bank Account Balance
AdjustedGLAcctBalanceAmt Adjusted G/L Account Balance
UnmatchedIncgBkStmntPayt Unmatched Incoming Payment in Bank Statment
UnmatchedIncgJrnlEntrPayt Unmatched Incoming Payment in Journal Entry
UnmatchedOutgBkStmntPayt Unmatched Outcoming Payment in Bank Statement
UnmatchedOutgJrnlEntrPayt Unmatched Outcoming Payment in Journal Entry
💲 Currency Key (HouseBankCurrency):
GLAcctBalanceAmt null
Column Name Description
Column Name Description
LastBankReconciliationDate null
Column Name Description
Column Name Description Domain name
BankAccount Bank account number BANKN
BankAccountReferenceText Reference Information CHAR27
BankName Name of Financial Institution TEXT60
Ledger Ledger in General Ledger Accounting FINS_LEDGER
CreationUserName User Who Last Changed Bank Reconciliation Statement UNAME
Master Data Relations Join Conditions
Company Code Currency
  • Company Code Currency
  • Client
  • P_CN_HOUSEBANKWITHGLBALANCE.COMPANYCODECURRENCY == TCURC.WAERS
  • P_CN_HOUSEBANKWITHGLBALANCE.MANDT == TCURC.MANDT
General ledger account
  • Company Code
  • General Ledger Account
  • Client
  • P_CN_HOUSEBANKWITHGLBALANCE.COMPANYCODE == SKB1.BUKRS
  • P_CN_HOUSEBANKWITHGLBALANCE.GLACCOUNT == SKB1.SAKNR
  • P_CN_HOUSEBANKWITHGLBALANCE.MANDT == SKB1.MANDT
Short Key for a House Bank
  • Company Code
  • Short Key for a House Bank
  • Client
  • P_CN_HOUSEBANKWITHGLBALANCE.COMPANYCODE == T012.BUKRS
  • P_CN_HOUSEBANKWITHGLBALANCE.HOUSEBANK == T012.HBKID
  • P_CN_HOUSEBANKWITHGLBALANCE.MANDT == T012.MANDT
Currency Key
  • Currency Key
  • Client
  • P_CN_HOUSEBANKWITHGLBALANCE.HOUSEBANKCURRENCY == TCURC.WAERS
  • P_CN_HOUSEBANKWITHGLBALANCE.MANDT == TCURC.MANDT