FinanceFerret/2.0/sql/trx

About

• purpose: base transaction, to which transaction parts (trx_part are attached

SQL

CREATE TABLE `trx` (
  `ID`           INT(4)           NOT NULL auto_increment,
  `ID_Type`      INT(4)       default NULL COMMENT "[trx_type].ID",
  `Amount`       DECIMAL(9,2) default NULL COMMENT "total amount of money transferred",
  `Voided`       tinyint(1)   default FALSE COMMENT "transaction voided",
  `IsApprox`     tinyint(1)   default NULL COMMENT "exact amount of transaction is not known yet",  PRIMARY KEY  (`ID`),
  KEY `Acct` (`ID_Acct`)
) ENGINE=InnoDB;