FinanceFerret/2.0/sql/trx: Difference between revisions
< FinanceFerret | 2.0 | sql
Jump to navigation
Jump to search
(moved trx_part rules to trx_part table page) |
m (Woozle moved page FinanceFerret/tables/trx to FinanceFerret/2.0/sql/trx without leaving a redirect: renumbering - 1.0 is Access version) |
| (One intermediate revision by the same user not shown) | |
(No difference)
| |
Latest revision as of 13:49, 2 March 2020
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;