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 (2 revisions imported: stuff I missed the first time) |
(No difference)
| |
Revision as of 13:45, 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;