FerretMyMoney/sql/fmmBankBals

About

• Purpose: stores end-of-day balances as shown by the bank (online or statement)
• History:
  • 2012-02-20 designed

SQL

<section begin=sql /><mysql>CREATE TABLE `fmmTrxacts` (

 ID_Acct       VARCHAR(32)  NOT NULL COMMENT "ID of KMM Account",
 WhenBank      DATETIME     NOT NULL COMMENT "day for which this balance applies",
 Balance       DECIMAL(9,2) NOT NULL COMMENT "balance as given by bank",
 PRIMARY KEY(`ID_Acct`,`WhenBank`)
)
ENGINE = MYISAM;</mysql>

<section end=sql />