I_BankAccountWithRevision

Bank Account With Revision | view: IBANKACCTWR | Extraction: Not supported | Component: Bank Account Management

Tables used: FCLM_BAM_AMD, FCLM_BAM_REV, FCLM_BAM_AMD

🔑 Keys (2)
💰 Amounts (4)
∑ Quantities
📅 Dates (14)
☰ Categorical (9)
Other (20)
🔗 Relations (14)

Column Name	Description
BankAccountInternalID	Bank Account Technical ID
BankAccountRevision	Revision Number

Column Name	Description
DifferenceAmount	FTE_BSM: Difference Amount Permitted in Account Currency
💲 Currency Key (BankAccountCurrency):
MaxTargetAmount	Target Balance for Subaccount
MinTargetAmount	Minimum Target Amount for Subaccount
MinTransferAmount	Minimum Transfer Amount for Subaccount

Column Name	Description

Column Name	Description
ValidityStartDate	Bank Account Opening Date
ValidityEndDate	Bank Account Closing Date
BankStatementCheckTime	Bank Statement Check Time
DomesticCutOffTime	Cut-Off Time Domestic
CrossBorderCutOffTime	Cut-Off Time Cross Border
PlannedClosingDate	Planned Closing Date
CreationDate	Bank Account Created On
CreationTime	Created At
OpenedDate	Bank Account: Openned On
LastChangeDate	Changed On
LastChangeTime	Changed At
ClosedDate	Closed On
ClosedTime	Closed At
IBANValidityStartDate	IBAN Valid From

Column Name	Description
BankAccountStatus	Bank Account Status	Show values
BankStatementImportChannel	Bank Statement Importing Channel	Show values
IsUploadOfIntraDayStatement	Upload of Intraday Statements	Show values
ProcessingStatus	Activate Processing Status for Bank Statement	Show values
DifferenceStatus	Activate Difference Status for Bank Statement	Show values
SerialNumberStatus	Activate Serial Number Status for Bank Statement	Show values
ReconciliationStatus	Activate Reconciliation Status for Bank Statement	Show values
ControlFrequency	FTE-BSM: Frequency Unit	Show values
BankAccountRevisionStatus	Bank Account Master Data: Revision Status	Show values

Column Name	Description	Domain name
BankAccountNumber	Bank Account Number	FCLM_BAM_ACC_NUM
IBAN	IBAN (International Bank Account Number)	IBAN
LeadingCashPoolID	Cash Pool ID	FCLM_BAM_CASH_POOL_ID
ProfitCenter	Profit Center	PRCTR
BankAccountHolderName	Bank Account Holder	TEXT60
BankContactPerson	General Contact Person at Bank	BU_PARTNER
BankRelationshipManager	Bank Relationship Manager	BU_PARTNER
CreatedByUser	Created By	XUBNAME
OpenedByUser	Bank Account: Opened By	XUBNAME
LastChangedByUser	Changed By	XUBNAME
ReviewedByUser	Bank Account Master Record Reviewed By	XUBNAME
ClosedByUser	Closed By	XUBNAME
BankControlKey	Bank Control Key	BKONT
ArchObjectNumber	Object number	J_OBJNR
ExpectedInterval	Interval for Expected Bank Statements	NUMC2
FactoryCalendar	Factory Calendar	WFCID
DisplayItem	FTE-BSM: Display Item in Bank Statement Monitor	NUMC3
ParticipantCashPoolID	Cash Pool for Subaccount	FCLM_BAM_CASH_POOL_ID
PaymentServiceProvider	Payment Service Provider for Digital Payments	DP_PAYMENT_SERVICE_PROVIDER
BankAccountRevActivatedByUser	Bank Account: Activated By	XUBNAME

Master Data Relations	Join Conditions
Bank Key Bank Country/Region Key Bank Key Client	`I_BANKACCOUNTWITHREVISION.BANKCOUNTRY == BNKA.BANKS` `I_BANKACCOUNTWITHREVISION.BANK == BNKA.BANKL` `I_BANKACCOUNTWITHREVISION.MANDT == BNKA.MANDT`
Currency Key Client Currency Key	`I_BANKACCOUNTWITHREVISION.MANDT == TCURC.MANDT` `I_BANKACCOUNTWITHREVISION.BANKACCOUNTCURRENCY == TCURC.WAERS`
Bank Account Supervisor Client Bank Account Supervisor	`I_BANKACCOUNTWITHREVISION.MANDT == USR02.MANDT` `I_BANKACCOUNTWITHREVISION.BANKACCOUNTSUPERVISOR == USR02.BNAME`
Bank Account Type ID Bank Account Type ID Client	`I_BANKACCOUNTWITHREVISION.BANKACCOUNTTYPE == FCLM_BAM_AC_TYPE.ACC_TYPE_ID` `I_BANKACCOUNTWITHREVISION.MANDT == FCLM_BAM_AC_TYPE.MANDT`
Bank Country/Region Key Bank Country/Region Key Client	`I_BANKACCOUNTWITHREVISION.BANKCOUNTRY == T005.LAND1` `I_BANKACCOUNTWITHREVISION.MANDT == T005.MANDT`
Import Method for End-of-Day Bank Statements Client Import Method for End-of-Day Bank Statements	`I_BANKACCOUNTWITHREVISION.MANDT == FCLM_BAM_BSIMP.MANDT` `I_BANKACCOUNTWITHREVISION.BANKSTATEMENTIMPORTMETHOD == FCLM_BAM_BSIMP.IMPORT_TYPE`
Business Area Business Area Client	`I_BANKACCOUNTWITHREVISION.BUSINESSAREA == TGSB.GSBER` `I_BANKACCOUNTWITHREVISION.MANDT == TGSB.MANDT`
Company Code Company Code Client	`I_BANKACCOUNTWITHREVISION.COMPANYCODE == T001.BUKRS` `I_BANKACCOUNTWITHREVISION.MANDT == T001.MANDT`
Company Contact Person Company Contact Person Client	`I_BANKACCOUNTWITHREVISION.COMPANYCONTACTPERSON == USR02.BNAME` `I_BANKACCOUNTWITHREVISION.MANDT == USR02.MANDT`
Import Method for Intraday Bank Statements Import Method for Intraday Bank Statements Client	`I_BANKACCOUNTWITHREVISION.INTRADAYBANKSTATEIMPORTMETHOD == FCLM_BAM_BSIMP.IMPORT_TYPE` `I_BANKACCOUNTWITHREVISION.MANDT == FCLM_BAM_BSIMP.MANDT`
Payment Method for Header Account Bank Country/Region Key Payment Method for Header Account Client	`I_BANKACCOUNTWITHREVISION.BANKCOUNTRY == T042Z.LAND1` `I_BANKACCOUNTWITHREVISION.LEADINGPAYMENTMETHOD == T042Z.ZLSCH` `I_BANKACCOUNTWITHREVISION.MANDT == T042Z.MANDT`
Payment Method for Subaccount Bank Country/Region Key Payment Method for Subaccount Client	`I_BANKACCOUNTWITHREVISION.BANKCOUNTRY == T042Z.LAND1` `I_BANKACCOUNTWITHREVISION.PARTICIPANTPAYMENTMETHOD == T042Z.ZLSCH` `I_BANKACCOUNTWITHREVISION.MANDT == T042Z.MANDT`
Payment Transaction Type Group Payment Transaction Type Group Client	`I_BANKACCOUNTWITHREVISION.PAYMENTTRANSACTIONTYPEGROUP == T028V.VGTYP` `I_BANKACCOUNTWITHREVISION.MANDT == T028V.MANDT`
Segment for Segmental Reporting Client Segment for Segmental Reporting	`I_BANKACCOUNTWITHREVISION.MANDT == FAGL_SEGM.MANDT` `I_BANKACCOUNTWITHREVISION.SEGMENT == FAGL_SEGM.SEGMENT`