Difference between revisions of "FerretMyMoney/sql/fmmTrxacts"
Jump to navigation
Jump to search
(saving work) |
(SortBank) |
||
| Line 3: | Line 3: | ||
* '''History''': | * '''History''': | ||
** '''2012-02-19''' designed | ** '''2012-02-19''' designed | ||
| + | ** '''2012-02-21''' added '''SortBank''' field | ||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql>CREATE TABLE `fmmTrxacts` ( | <section begin=sql /><mysql>CREATE TABLE `fmmTrxacts` ( | ||
ID VARCHAR(32) NOT NULL COMMENT "ID of Transaction record in KMM", | 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", | 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", | Balance DECIMAL(9,2) DEFAULT NULL COMMENT "balance calculated after this transaction", | ||
PRIMARY KEY(`ID`) | PRIMARY KEY(`ID`) | ||
Revision as of 17:20, 21 February 2012
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>