FerretMyMoney/sql/fmmBankBals

From Woozle Writes Code
< FerretMyMoney
Revision as of 21:33, 5 February 2025 by Woozle (talk | contribs) (1 revision imported: belongs here now)
Jump to navigation Jump to search

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

Retrieved from "https://wooz.dev/mw/index.php?title=FerretMyMoney/sql/fmmBankBals&oldid=7211"