FerretMyMoney/sql/fmmBankBals

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to: navigation, search

About

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

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>