Difference between revisions of "FerretMyMoney/sql/fmmTrxacts"
Jump to navigation
Jump to search
(SortBank) |
(two balances, flags for how balance is applied) |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''Purpose''': stores extended data about [[KMyMoney]] [[KMyMoney/sql/kmmTransactions|transactions]] | * '''Purpose''': stores extended data about [[KMyMoney]] [[KMyMoney/sql/kmmTransactions|transactions]] | ||
| + | * '''Fields''': | ||
| + | ** '''UseBank''': if TRUE, use prior BalBank instead of prior BalCalc when calculating this BalCalc | ||
| + | ** '''UseDate''': if TRUE, the bank's balance should apply after the last transaction of the day, and is not tied to a specific transaction. | ||
| + | *** The actual implementation of this could either be to always move the bank's balance to the last transaction of the day, or it could be to store the balance in a separate table such as {{l/same|fmmBankBals}}. This table doesn't care how it's done. | ||
* '''History''': | * '''History''': | ||
** '''2012-02-19''' designed | ** '''2012-02-19''' designed | ||
** '''2012-02-21''' added '''SortBank''' field | ** '''2012-02-21''' added '''SortBank''' field | ||
| + | ** '''2012-03-03''' changed '''Balance''' to '''BalCalc''' and '''BalBank'''; added '''UseBank''' | ||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql>CREATE TABLE `fmmTrxacts` ( | <section begin=sql /><mysql>CREATE TABLE `fmmTrxacts` ( | ||
| Line 9: | Line 14: | ||
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", | SortBank DECIMAL(3,2) DEFAULT NULL COMMENT "additional sorting to match bank order, if needed", | ||
| − | + | BalCalc DECIMAL(9,2) DEFAULT NULL COMMENT "balance calculated after this transaction", | |
| + | BalBank DECIMAL(9,2) DEFAULT NULL COMMENT "balance according to bank after this transaction", | ||
| + | UseBank BOOL DEFAULT 0 COMMENT "TRUE = use the bank's balance; ignore previous calculations", | ||
| + | UseDate BOOL DEFAULT 0 COMMENT "TRUE = bank's balance is end-of-day, not specific transaction", | ||
PRIMARY KEY(`ID`) | PRIMARY KEY(`ID`) | ||
) | ) | ||
ENGINE = MYISAM;</mysql> | ENGINE = MYISAM;</mysql> | ||
<section end=sql /> | <section end=sql /> | ||
Revision as of 13:55, 3 March 2012
About
- Purpose: stores extended data about KMyMoney transactions
- Fields:
- UseBank: if TRUE, use prior BalBank instead of prior BalCalc when calculating this BalCalc
- UseDate: if TRUE, the bank's balance should apply after the last transaction of the day, and is not tied to a specific transaction.
- The actual implementation of this could either be to always move the bank's balance to the last transaction of the day, or it could be to store the balance in a separate table such as fmmBankBals. This table doesn't care how it's done.
- History:
- 2012-02-19 designed
- 2012-02-21 added SortBank field
- 2012-03-03 changed Balance to BalCalc and BalBank; added UseBank
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", BalCalc DECIMAL(9,2) DEFAULT NULL COMMENT "balance calculated after this transaction", BalBank DECIMAL(9,2) DEFAULT NULL COMMENT "balance according to bank after this transaction", UseBank BOOL DEFAULT 0 COMMENT "TRUE = use the bank's balance; ignore previous calculations", UseDate BOOL DEFAULT 0 COMMENT "TRUE = bank's balance is end-of-day, not specific transaction", PRIMARY KEY(`ID`) ) ENGINE = MYISAM;</mysql>