FerretMyMoney/sql/fmmTrxacts

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< FerretMyMoney
Revision as of 17:20, 21 February 2012 by Woozle (talk | contribs) (SortBank)
Jump to navigation Jump to search

About

  • Purpose: stores extended data about KMyMoney transactions
  • History:
    • 2012-02-19 designed
    • 2012-02-21 added SortBank field

SQL

<mysql>CREATE TABLE `fmmTrxacts` ( 

 ID       VARCHAR(32)      NOT NULL COMMENT "ID of Transaction record in KMM",
 WhenBank DATETIME     DEFAULT NULL COMMENT "posting date as shown by the bank record",
 SortBank DECIMAL(3,2) DEFAULT NULL COMMENT "additional sorting to match bank order, if needed",
 Balance  DECIMAL(9,2) DEFAULT NULL COMMENT "balance calculated after this transaction",
 PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;</mysql>

Retrieved from "https://htyp.org/mw/index.php?title=FerretMyMoney/sql/fmmTrxacts&oldid=16959"