VbzCart/docs/tables/ord trxact: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (created) |
imported>Woozle (+WhenVoid) |
||
| Line 4: | Line 4: | ||
* '''History''': | * '''History''': | ||
** '''2008-12-27''' Adapted from MS Access version ("Trxacts" table) | ** '''2008-12-27''' Adapted from MS Access version ("Trxacts" table) | ||
** '''2009-01-05''' Added WhenVoid field - deleting records leaves mysterious holes in the sequence; let's just void them | |||
* '''Fields''': | * '''Fields''': | ||
** '''ID_Package''' should be used to facilitate printing only package-relevant transactions on a packing slip, but I don't know if this is currently workable. | ** '''ID_Package''' should be used to facilitate printing only package-relevant transactions on a packing slip, but I don't know if this is currently workable. | ||
| Line 13: | Line 14: | ||
`ID_Type` INT NOT NULL COMMENT "ord_trx_type.ID", | `ID_Type` INT NOT NULL COMMENT "ord_trx_type.ID", | ||
`WhenDone` DATETIME DEFAULT NULL, | `WhenDone` DATETIME DEFAULT NULL, | ||
`WhenVoid` DATETIME DEFAULT NULL, | |||
`Descr` VARCHAR(255), | `Descr` VARCHAR(255), | ||
`Amount` DECIMAL(9,2) COMMENT "amount of transaction: +owed by customer -credit to customer", | `Amount` DECIMAL(9,2) COMMENT "amount of transaction: +owed by customer -credit to customer", | ||
Revision as of 21:44, 5 January 2009
About
- Purpose: Money transactions for orders
- Refers to: Template:Vbzcart/table (parent), Template:Vbzcart/table, Template:Vbzcart/table
- History:
- 2008-12-27 Adapted from MS Access version ("Trxacts" table)
- 2009-01-05 Added WhenVoid field - deleting records leaves mysterious holes in the sequence; let's just void them
- Fields:
- ID_Package should be used to facilitate printing only package-relevant transactions on a packing slip, but I don't know if this is currently workable.
SQL
<section begin=sql /><mysql>CREATE TABLE `ord_trxact` (
`ID` INT NOT NULL AUTO_INCREMENT, `ID_Order` INT NOT NULL COMMENT "core_orders.ID", `ID_Package` INT DEFAULT NULL COMMENT "ord_pkgs.ID", `ID_Type` INT NOT NULL COMMENT "ord_trx_type.ID", `WhenDone` DATETIME DEFAULT NULL, `WhenVoid` DATETIME DEFAULT NULL, `Descr` VARCHAR(255), `Amount` DECIMAL(9,2) COMMENT "amount of transaction: +owed by customer -credit to customer", PRIMARY KEY(`ID`)
) ENGINE = MYISAM;</mysql> <section end=sql />