FCLM_BAL_ACCT_SETTING_DETAILS

Bank Account Setting Details | view: VBACCTSETDET | TRAN | Extraction: Not supported | Component: Bank Account Management
Column Name Description
BankAccountInternalID Bank Account Technical ID
Column Name Description
Column Name Description
Column Name Description
ValidityStartDate Valid From
ValidityEndDate Valid To
Column Name Description
BankStatementPostingType EoD Bank Statement Posting Category Show values
BankStatementTransferMode EoD Bank Statement Transfer Mode to Cash Show values
BankStatementSettingSource Bank Statement Setting Source Show values
ManualInputBalanceIsEnabled Enable Balance from Manual Entry Show values
ExcelImportBalanceIsEnabled Enable Balance from Spreadsheet Import Show values
InternalAPIBalanceIsEnabled Enable Balance from Electronic Payment Integration (China) Show values
BankAccountStatus Bank Account Status Show values
Column Name Description Domain name
BankAccountNumber Bank Account Number FCLM_BAM_ACC_NUM
BankAccountDescription Account Description TEXT60
LastChangedByUser User Name UNAME
UserDescription User Description SUIDTECHDESC
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
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
HouseBank Short Key for a House Bank HBKID
HouseBankAccount ID for Account Details HKTID
BankStatementPostingTypeText Short Text for Fixed Values DDTEXT
BankStatementTransferModeText Short Text for Fixed Values DDTEXT
BankStatementSettingSourceText Short Text for Fixed Values DDTEXT
Master Data Relations Join Conditions
Bank Key
  • Client
  • Bank Key
  • Bank Country/Region Key
  • FCLM_BAL_ACCT_SETTING_DETAILS.MANDT == BNKA.MANDT
  • FCLM_BAL_ACCT_SETTING_DETAILS.BANK == BNKA.BANKL
  • FCLM_BAL_ACCT_SETTING_DETAILS.BANKCOUNTRY == BNKA.BANKS
Currency Key
  • Client
  • Currency Key
  • FCLM_BAL_ACCT_SETTING_DETAILS.MANDT == TCURC.MANDT
  • FCLM_BAL_ACCT_SETTING_DETAILS.BANKACCOUNTCURRENCY == TCURC.WAERS
Bank Account Type ID
  • Bank Account Type ID
  • Client
Bank Country/Region Key
  • Client
  • Bank Country/Region Key
  • FCLM_BAL_ACCT_SETTING_DETAILS.MANDT == T005.MANDT
  • FCLM_BAL_ACCT_SETTING_DETAILS.BANKCOUNTRY == T005.LAND1
Company Code
  • Client
  • Company Code
  • FCLM_BAL_ACCT_SETTING_DETAILS.MANDT == T001.MANDT
  • FCLM_BAL_ACCT_SETTING_DETAILS.COMPANYCODE == T001.BUKRS