FCLM_ACCOUNT_BALANCE_MONITOR

Bank account with balance upload detail | view: VACCTBALMNT | Extraction: Not supported | Component: Bank Account Management
Column Name Description
BankAccountInternalID Bank Account Technical ID
Column Name Description
💲 Currency Key (CashBalanceCurrency):
CashBalanceAmount Balance Amount
Column Name Description
Column Name Description
ValidityStartDate Bank Account Opening Date
ValidityEndDate Bank Account Closing Date
CashBalanceDate Date
ExpectedNextBalanceImportDate Date
Column Name Description
BankAccountStatus Bank Account Status Show values
ControlFrequency FTE-BSM: Frequency Unit Show values
CashBalanceChannel Bank Account Balance Update Method Show values
CashBalanceUploadStatus Account Balance Upload Status Show values
Column Name Description Domain name
BankAccountNumber Bank Account Number FCLM_BAM_ACC_NUM
BankAccountDescription Account Description TEXT60
iban IBAN (International Bank Account Number) IBAN
BankStmntReconciliationGrp Bank Statement Group FCLM_BAL_BSR_GROUP
ExpectedInterval Interval for Expected Bank Statements NUMC2
FactoryCalendar Factory Calendar WFCID
HouseBank Short Key for a House Bank HBKID
HouseBankAccount ID for Account Details HKTID
NextBalanceRemainingDays Remaining Days of Next Balance Import INT4
CashBalanceChannelText Short Text for Fixed Values DDTEXT
CompanyCodeName Name of Company Code or Company TEXT25
CountryShortName Name of Country/Region (Short) TEXT15
CurrencyShortName Short text TEXT15
BankName Name of Financial Institution TEXT60
BankAccountTypeText Bank Account Type Description TEXT60
BankAccountStatusName Bank Account Status Description DDTEXT
FrequencyDescription Short Text for Fixed Values DDTEXT
FactoryCalendarName Factory Calendar Text TEXT60
BankStmntReconciliationGrpName Bank Statement Group Description TEXT30
Master Data Relations Join Conditions
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • FCLM_ACCOUNT_BALANCE_MONITOR.MANDT == TCURC.MANDT
  • FCLM_ACCOUNT_BALANCE_MONITOR.BANKACCOUNTCURRENCY == TCURC.WAERS
  • FCLM_ACCOUNT_BALANCE_MONITOR.CASHBALANCECURRENCY == TCURC.WAERS
Bank Account Type ID
  • Bank Account Type ID
  • Client
Bank Country/Region Key
  • Bank Country/Region Key
  • Client
  • FCLM_ACCOUNT_BALANCE_MONITOR.BANKCOUNTRY == T005.LAND1
  • FCLM_ACCOUNT_BALANCE_MONITOR.MANDT == T005.MANDT
Bank Key
  • Bank Key
  • Bank Country/Region Key
  • Client
  • FCLM_ACCOUNT_BALANCE_MONITOR.BANKKEY == BNKA.BANKL
  • FCLM_ACCOUNT_BALANCE_MONITOR.BANKCOUNTRY == BNKA.BANKS
  • FCLM_ACCOUNT_BALANCE_MONITOR.MANDT == BNKA.MANDT
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • FCLM_ACCOUNT_BALANCE_MONITOR.MANDT == TCURC.MANDT
  • FCLM_ACCOUNT_BALANCE_MONITOR.BANKACCOUNTCURRENCY == TCURC.WAERS
  • FCLM_ACCOUNT_BALANCE_MONITOR.CASHBALANCECURRENCY == TCURC.WAERS
Company Code
  • Company Code
  • Client
  • FCLM_ACCOUNT_BALANCE_MONITOR.COMPANYCODE == T001.BUKRS
  • FCLM_ACCOUNT_BALANCE_MONITOR.MANDT == T001.MANDT