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


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


<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>