farvd_bs_it_01

Column Name Description
BankStatementShortID Short Key for Bank Statement (Surrogate Key)
BankStatementItem Memo Record Number (Line Item Number in Bank Statement)
Column Name Description
💲 Currency Key (Currency):
AmountInTransactionCurrency Amount in Account Currency
AbsoluteAmountInTransacCrcy Amount in Account Currency
💲 Foreign Currency Key (Not Account Currency) (OriginalCurrency):
AmountInOriginalCurrency Foreign Currency Amount (Different from Account Currency)
FeeAmountInTransactionCrcy Fees in Account Currency
FeeAmountInOriginalCrcy Fees in Foreign Currency (Not Same as Account Currency)
OverdueChargeAmtInTransacCrcy Overdue Charges from/to Partners in Account Currency
OpeningBalanceAmtInTransCrcy Opening Balance Amount
TotalDebitAmountInTransCrcy Total Debit
TotalCreditAmountInTransCrcy Total Credit
ClosingBalanceAmtInTransCrcy Ending Balance Amount
Column Name Description
Column Name Description
BankStatementDate Statement Date
ValueDate Value Date of the Item to Be Cleared
BankPostingDate Posting Date at the Bank
PostingDate Posting Date in the Document
BillOfExchangeFailureDate Date of Failed Bills of Exchange in Japan
BankStatementImportDate Import Date into Bank Data Buffer
BankStatementImportTime Import Time into Bank Data Buffer
Column Name Description
InterpretationAlgorithm Interpretation Algorithm Show values
PaymentAdviceAccountType Payment Advice Account Type Show values
MemoLineIsChanged Note to Payee Has Been Changed Manually Show values
TreasuryContractType Contract Type Show values
BankStmntItemProcessingType Processing Type Show values
BankLedgerPostingIsSuppressed X - Standard (FI) Posting Should Be Suppressed Show values
SubledgerPostingIsSuppressed X - Standard (FI) Posting Should Be Suppressed Show values
MachineLrngBankStmntItemStatus Machine Learning Status of Item Show values
MachineLrngBkStmntItemAcctSts Machine Learning Status for Account Determination of Item Show values
PostingRuleBankStmntItemStatus Bank Statement Item Posting Rule Status Show values
OriginApplication Application Using Bank Data Storage Show values
PartialApplicationStatus Partial Application Status Show values
AdvcAssignmentRepetitionStatus Advice assignment repetition status Show values
Column Name Description Domain name
SendingBank Sending Bank (Electronic Bank Statement) CHAR50
HouseBank Short Key for a House Bank HBKID
HouseBankAccount ID for Account Details HKTID
BankStatement Statement Number NUM5
BankStatementStatus Statement Status CHAR1
BankLedgerIsPosted Update 1 OK CHAR1
SubledgerIsPostedSuccessfully 2nd Update OK CHAR1
IsCompleted Line Item Completed CHAR1
BankStatementItemGroup Bundle Number for Grouping Line Items CHAR2
BankStatementPostingRuleName Text, Length 40 TEXT40
PaymentTransactionCategoryName Name of Transaction TEXT60
PaymentTransactionCategory Transaction FEB_BSPROC_TATYP
PaymentAdviceAccountTypeName Short Text for Fixed Values DDTEXT
PaymentAdviceAccount Account Number KTONR
HasAttachment null
HasNote null
MemoLine1 Payment Notes CHAR65
OriginalMemoLine Memo Line FAR_MEMO_LINE
MemoLine Memo Line FAR_MEMO_LINE
IsInProcess null
BankInternalID Bank Keys BANKK
BankAccount Bank account number BANKN
BankAccountUUID GUID SYSUUID_C
ExchangeRate Exchange Rate FAC_KURSF_EXT
DebitCreditCode Debit/Credit Key for Line Items (for Bank Purposes) CHAR1
BusinessPartnerName Business Partner CHAR55
PaymentAdvice Payment Advice Number AVSID
ValueDateTime Value Date Time TIME6
PaymentExternalTransacType External Business Transaction VGEXT_EB
PaymentTransactionDescription Bank Posting Text CHAR50
AccountingClerk Accounting Clerk CHAR2
AccountingClerkName Name of Accounting Clerk TEXT30
UserID User Name USERNAME
PersonFullName User Description SUIDTECHDESC
CostCenter Cost Center CHAR10
BusinessArea Business Area CHAR4
ProfitCenter Profit Center PRCTR
Contract Contract Number RANL
DaybookEntry Daybook Number CHAR10
Cheque null
PaymentMediumReference Check number CHCKN
CustomerReferenceNumber Check number CHCKN
BankStatementItemIsInterpreted null
PostingErrorStatus Error Status CHAR4
BankLedgerDocument Document Number of an Accounting Document BELNR
BankLedgerDocFiscalYear Fiscal Year of Bank Accounting Document GJAHR
FiscalYear Fiscal Year GJAHR
BankPostingKey Text Key CHAR4
AcctDetnFreeDefinedAttribute Account modification KFMOD_EB
BankTransactionCategory SAP Bank Transaction CHAR4
DocumentReferenceID Reference Document Number XBLNR1
AssignmentReference Assignment number ZUONR
PartnerBank Bank Number of Partner Bank BANKK
PartnerBankSWIFTCode SWIFT Code of Partner Bank SWIFT
PartnerBankAccount Account Number at the Partner Bank BANKN
BankStatementItemDescription1 Additional Information 1 CHAR30
BankStatementItemDescription2 Additional Information 2 CHAR30
SubledgerDocument Subledger document number BELNR
SubledgerDocFiscalYear Fiscal Year of Subledger Accounting Document GJAHR
BankLedgerOnAccountDocument Payment on account document number BELNR
BankLedgerOnAccDocFiscalYear Fiscal Year of Document on Account in Banking Book GJAHR
SubledgerOnAccountDocument Payment on account document number BELNR
SubledgerOnAccDocFiscalYear Fiscal Year of Document on Account in Subledger GJAHR
IsPostedOnAccount null
PayerParty Account Number of an Alternative Payer KUNNR
BankStatementItemLifeCycSts null
ProcessingStatus null
AccountingExchangeRate Exchange Rate FAC_KURSF_EXT
DocumentItemText Item Text TEXT50
BankReference Bank Reference Number CHAR35
ReferenceDocument Reference Key AWKEY
ReferenceDocumentType Reference procedure AWTYP
PaymentReference Payment Reference CHAR30
BankStatementItemReturnReason Customer-to-Customer Reference CHAR35
DunningBlockingReasonCode Dunning Block MANSP
BankLedgerExternalApplication Application Indicator APPLK_BF
BankLedgerExtApplicationText Text (non-language specific) TEXT30
BankLedgerExtPostgErrorStatus Error Status CHAR4
BankLedgerExtPostingDocument Doc. no. (IDoc number, application document no., etc.) CHAR70
BankLedgerExtPostingRefDocType Reference procedure AWTYP
SubledgerExtPostingApplication Application Indicator APPLK_BF
SubledgerExtPostingApplText Text (non-language specific) TEXT30
SubledgerExtPostingErrorStatus Error Status CHAR4
SubledgerExtPostingDocument Doc. no. (IDoc number, application document no., etc.) CHAR70
SubledgerExtPostingRefDocType Reference procedure AWTYP
PartnerBankIBAN Partner Bank Account: IBAN IBAN
BankStatementInternalID Bank Statement Identification CHAR20
BankStatementProcessingStatus Statement Status CHAR1
BankStatementIsInterpreted All Items on Header Record Were Interpreted CHAR1
BankAccountHolderName Bank Account Holder CHAR35
BankAccountAdditionalName Special Account Name CHAR35
BankStatementPageNumber Page Number of Statement (5 Digits) NUM5
OpeningBalanceIsInterim null
ClosingBalanceIsInterim null
InterestRateInPercent Credit Interest HZINS_EB
BankAccountType Bank Account Type CHAR23
BankStatementNumberOfItems Number of Memo Records from the Bank Statement NUM5
PaymentTransactionTypeGroup Transaction Type VGTYP_EB
PaymentManualTransacType Transaction VGMAN_EB
PaymentManualTransacTypeName Text, Length 40 TEXT40
BankStatementIsManuallyCreated null
CreatedByUser User Who Fills the Bank Data Buffer CHAR12
CreatedByUserName User Description SUIDTECHDESC
BankAccountReferenceText Reference Details for Bank Details CHAR20
BankStatementFormat Input Format INPUT_FORMAT
IBAN Sender Bank Account: IBAN IBAN
BankStmntItmPostprocReasonName Reprocessing Reason TEXT60
BankStmntItemIsReprocessed null
HouseBankName Name of Financial Institution TEXT60
DraftUUID Draft key (raw16) RAW16
PostingType Account Determination: Attribute Value WERTN_AD
MachineLrngBkStmntItemStatName Machine Learning Status Name of Item DDTEXT
MchnLrngBkStmntItmAcctStsName Machine Learning Account Status Name of Item DDTEXT
IncomingPaymentFile Incoming Payment File ID FARP_EFILEID
BSItemId Composed of Bank Statement No. and Line Item No. CHAR11
CompanyCodeName Name of Company Code or Company TEXT25
HouseBankAccountDescription Account Description TEXT60
PostingRule Reprocessing Rule ID POSTINGRULEID
PostingRuleDescription Reprocessing Rule Description TEXT255
PostingRuleUUID Posting Rule Node Key SYSUUID
NumberPostingSteps null
PaymentClearingGroup null
Supplier Account Number of Supplier LIFNR
Customer Customer Number KUNNR
GLAccount General Ledger Account SAKNR
LockboxBatch Batch Number (Bundle Number) CHAR3
Lockbox Lockbox Number CHAR7
LockboxBatchDestination null
LockboxBatchOrigin null
LockboxSubledgerDocument Number of Second Subledger Document BELNR
Master Data Relations Join Conditions
Bank Account Technical ID
  • ?
  • Bank Account Technical ID
  • Client
Input Help for Posting Rule (Internal Activity)
  • Posting Rule
  • Client
  • FARVD_BS_IT_01.BANKSTATEMENTPOSTINGRULE == T028D.VGINT
  • FARVD_BS_IT_01.MANDT == T028D.MANDT
Reprocessing Reason Code
  • Reprocessing Reason Code
  • Client
Chart of Accounts
  • Chart of Accounts
  • Client
  • FARVD_BS_IT_01.CHARTOFACCOUNTS == T004.KTOPL
  • FARVD_BS_IT_01.MANDT == T004.MANDT
Company code
  • Company Code
  • Client
  • FARVD_BS_IT_01.COMPANYCODE == T001.BUKRS
  • FARVD_BS_IT_01.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • FARVD_BS_IT_01.CURRENCY == TCURC.WAERS
  • FARVD_BS_IT_01.MANDT == TCURC.MANDT
General ledger account
  • Company Code
  • General Ledger Account
  • Client
  • FARVD_BS_IT_01.COMPANYCODE == SKB1.BUKRS
  • FARVD_BS_IT_01.GLACCOUNTHEADER == SKB1.SAKNR
  • FARVD_BS_IT_01.MANDT == SKB1.MANDT
Foreign currency (not account currency)
  • Foreign Currency Key (Not Account Currency)
  • Client
  • FARVD_BS_IT_01.ORIGINALCURRENCY == TCURC.WAERS
  • FARVD_BS_IT_01.MANDT == TCURC.MANDT
Partner Bank
  • Country/Region Key of Partner Bank
  • Client
  • FARVD_BS_IT_01.PARTNERBANKCOUNTRY == T005.LAND1
  • FARVD_BS_IT_01.MANDT == T005.MANDT