FARMLVD_BSITM

Column Name Description
Column Name Description
AmountInTransactionCurrency Amount in Account Currency
Column Name Description
Column Name Description
PostingDate Posting Date in the Document
ValueDate Value Date of the Item to Be Cleared
Column Name Description
PaymentAdviceAccountType Payment Advice Account Type Show values
MemoLineIsChanged Note to Payee Has Been Changed Manually Show values
BankDataStorageApplication Application Using Bank Data Storage Show values
MachineLrngBankStmntItemStatus Machine Learning Status of Item Show values
Column Name Description Domain name
HouseBank House Bank Key HBKID
HouseBankAccount ID for Account Details HKTID
BankStatement Statement Number NUM5
BankStatementShortID Short Key for Bank Statement (Surrogate Key) KUKEY_EB
BankStatementItem Line Item Number FARP_ESNUM
FiscalYear Fiscal Year GJAHR
DebitCreditCode Debit/Credit Key for Line Items (for Bank Purposes) CHAR1
PartnerBank Bank Number of Partner Bank BANKK
PartnerBankSWIFTCode SWIFT Code of Partner Bank SWIFT
PartnerBankAccount Account Number at the Partner Bank BANKN
PartnerBankIBAN Partner Bank Account: IBAN IBAN
BusinessPartnerName Business Partner CHAR55
BankLedgerDocument Document Number of an Accounting Document BELNR
SubledgerDocument Subledger document number BELNR
DocumentReferenceID Reference Document Number XBLNR1
PaymentAdviceAccount Account Number KTONR
AssignmentReference Assignment number ZUONR
PaymentReference Payment Reference CHAR30
SubledgerOnAccountDocument Payment on account document number BELNR
PaymentAdvice Payment Advice Number AVSID
MemoLine null
SubDocumentNo Payment on account document number BELNR
BankShortkeyMemo null
PaymentTransactionDescription Bank Posting Text CHAR50
Cheque Check number CHCKN
BankPostingKey Text Key CHAR4
PaymentTransaction Business Transaction Code CHAR3
PaymentExternalTransacType External Business Transaction VGEXT_EB
BankStmntItemIsReprocessed null
BankStatementItemDescription1 Additional Information 1 CHAR30
BankStatementKey null
Master Data Relations Join Conditions
Input Help for Posting Rule (Internal Activity)
  • Client
  • Bank Statement Posting Rule
  • FARMLVD_BSITM.MANDT == T028D.MANDT
  • FARMLVD_BSITM.BANKSTATEMENTPOSTINGRULE == T028D.VGINT
Company code
  • Client
  • Company Code
  • FARMLVD_BSITM.MANDT == T001.MANDT
  • FARMLVD_BSITM.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Client
  • Country/Region Key
  • FARMLVD_BSITM.MANDT == T005.MANDT
  • FARMLVD_BSITM.COUNTRYKEY == T005.LAND1
Currency Key
  • Client
  • Currency Key
  • FARMLVD_BSITM.MANDT == TCURC.MANDT
  • FARMLVD_BSITM.CURRENCY == TCURC.WAERS
Partner Bank
  • Client
  • Country/Region Key of Partner Bank
  • FARMLVD_BSITM.MANDT == T005.MANDT
  • FARMLVD_BSITM.PARTNERBANKCOUNTRY == T005.LAND1