FerretMyMoney/sql/fmmTrxacts

From Woozle Writes Code
< 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

<section begin=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>

<section end=sql />

Retrieved from "https://wooz.dev/mw/index.php?title=FerretMyMoney/sql/fmmTrxacts&oldid=7213"