I_LeadingMemoRecord

Basic View for Memo Record | view: ILDNGMEMORECORD | TRAN | Extraction: Not supported | Component: SAP Cash Management
Tables used: FQM_FLOW
Column Name Description
CashFlowID Flow ID
ValidFrom UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
Column Name Description
💲 Currency (TransactionCurrency):
AmountInTransactionCurrency Amount
💲 Currency (LocalCurrency):
AmountInLocalCurrency Amount
💲 Following Currency (FollowingCurrency):
AmountInFollowingCurrency Amount
Column Name Description
Column Name Description
TransactionDate Transaction Date
ExpirationDate Net Due Date
BankStatementDate Statement Date
OffsettingValueDate Value date
TermStartDate Value date
TermEndDate Value date
LoanTermStartDate Value date
LoanTermEndDate Value date
Column Name Description
OriginApplication Source Application Show values
CashReleaseStatus Release Status Show values
CertaintyLevel FCLM_MM_CERTAINTY_LEVEL Show values
MemoRecordStatisticItem Statistics Indicator Show values
MemoRecordStatus State for cash memo record Show values
CashCalendarTypeForFinInvmt Calendar Type Show values
CashPaymentAdvicePairingReason Reason for pairing payment advices in cash mgt and forecast Show values
CashRequestStatus Cash Request Status Show values
CashReqInstrCategory Trade Request Instrument Category Show values
TrsyTradedAmountBuySellCode Buy/Sell Indicator Show values
CashReqHasDocument Checkbox Show values
MemoRecordBorrowInvestCode Invest or Borrow Show values
Column Name Description Domain name
ValidTo UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
CashFlowCategory Flow Category FQM_FLOW_CATEGORY
MemoRecord ID number for cash management and forecast IDENR
OriginDocument Source Document ID FQM_ORIGIN_DOC_ID
CompanyCode Company Code BUKRS
PlanningLevel Planning Level FDLEV
CashPlanningGroup Planning Group FDGRP
LiquidityItem Liquidity Item FLQPOS
CreatedByUser User Name UNAME
CreationDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
LastChangedByUser User Name UNAME
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
BusinessArea Business Area GSBER
ProfitCenter Profit Center PRCTR
AssetFund Fund BP_GEBER
AssetGrant Grant GM_GRANT_NBR
BankStatement Statement Number NUM5
BankStatementShortID Short Key for Bank Statement (Surrogate Key) KUKEY_EB
BankStatementItem Memo Record Number (Line Item Number in Bank Statement) NUM5
GLAccount General Ledger Account SAKNR
DocumentItemText Item Text TEXT50
Segment Segment for Segmental Reporting FB_SEGMENT
MemoRecordInternalReference Internal Reference CHAR16
BusinessPartner Business Partner Number BU_PARTNER
FinancialInstrCharacteristic Characteristics CHAR25
HouseBank Short Key for a House Bank HBKID
HouseBankAccount ID for Account Details HKTID
BankAccountInternalID Bank Account Technical ID NUM10
OffsettingAccount Offsetting account GRUPP
OffsettingCompanyCode Company Code BUKRS
OffstgBankAccountInternalID Offsetting Bank Account Technical ID NUM10
OffsetBankAccountNumber Bank Account Number FCLM_BAM_ACC_NUM
OffsettingHouseBank Short Key for a House Bank HBKID
OffsettingHouseBankAccount ID for Account Details HKTID
MemoRecordInterestRate Interest rate PRZ43
MemoRecordExchangeRateType Exchange Rate Type KURST
CashPaymentAdviceGroup ID number for payment advice group in cash mgt and forecast IDENR
MemoRecordAssignment Assignment Number ZUONR
MemoRecordPlanningType Planning type DSART
ReceivingBankAccountIntID Bank Account Technical ID NUM10
FinancialInstrumentAssignment Assignment TEXT18
FinancialInstrumentReference Internal Reference CHAR16
BankIdentification Bank Details ID CHAR4
CashRequestSubmittedByUser Submitted By UNAME