I_MEMORECORDTP

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Memo Record BO active and draft
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MEMORECORDTP (
    CASHFLOWID,
    AMOUNTINTRANSACTIONCURRENCY,
    BANKACCOUNT,
    BANKACCOUNTDESCRIPTION,
    BANKACCOUNTINTERNALID,
    BANKACCOUNTREVISION,
    BANKSTATEMENTDATE,
    BANKSTATEMENTSHORTID,
    BUSINESSAREA,
    CASHFLOWCATEGORY,
    CASHFLOWTYPE,
    CASHMEMORECORDID,
    CASHPLANNINGGROUP,
    CASHRELEASESTATUS,
    CASHRELEASESTATUSTEXT,
    CASHREQUESTSUBMITTEDBYUSER,
    CERTAINTYLEVEL,
    COMPANYCODE,
    CREATEDBYUSER,
    CREATEDBYUSERDESCRIPTION,
    CREATIONTIME,
    CUSTOMERFACTORYCALENDERCODE,
    EFFECTIVEINTERESTRATE,
    EXPIRATIONDATE,
    FUND,
    GLACCOUNT,
    GRANTID,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    ISDELETED,
    ISSTATISTICALITEM,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    LASTCHANGEDBYUSERDESCRIPTION,
    LIQUIDITYITEM,
    LIQUIDITYITEMDESCRIPTION,
    MEMORECORDSTATUS,
    OFFSETBANKACCOUNTNUMBER,
    OFFSETTINGACCOUNT,
    OFFSETTINGBANKACCOUNT,
    OFFSETTINGCOMPANYCODE,
    OFFSETTINGHOUSEBANK,
    OFFSETTINGHOUSEBANKACCOUNT,
    OFFSETTINGVALUEDATE,
    ORIGINAPPLICATION,
    OWNERNAME,
    PLANNINGLEVEL,
    PROFITCENTER,
    SEGMENT,
    TERMSTARTDATE,
    TEXTDESCRIPTION,
    TRANSACTIONCURRENCY,
    TRANSACTIONDATE,
    PRIMARY KEY (CASHFLOWID)
);