FerretMyMoney/sql/fmmTrxacts

About

• Purpose: stores extended data about KMyMoney transactions
• History:
  • 2012-02-19 designed

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",
 Balance  DECIMAL(9,2) DEFAULT NULL COMMENT "balance calculated after this transaction",
 PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;</mysql>

<section end=sql />