VbzCart/docs/tables/ord trxact: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (+WhenVoid) |
imported>Woozle m (→About: now on L48) |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''Purpose''': Money transactions for orders | * '''Purpose''': Money transactions for orders | ||
* '''Refers to''': {{vbzcart | * '''Refers to''': {{vbzcart|table|core_orders}} (parent), {{vbzcart|table|ord_pkgs}}, {{vbzcart|table|ord_trx_type}} | ||
* '''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 | ** '''2009-01-05''' Added WhenVoid field - deleting records leaves mysterious holes in the sequence; let's just void them | ||
** '''2009-07-07''' Added to L48 version of database | |||
* '''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. | ||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql>CREATE TABLE `ord_trxact` ( | <section begin=sql /><mysql>CREATE TABLE `ord_trxact` ( | ||
Revision as of 21:22, 7 July 2009
About
- Purpose: Money transactions for orders
- Refers to: Template:Vbzcart (parent), Template:Vbzcart, Template:Vbzcart
- 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
- 2009-07-07 Added to L48 version of database
- 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 />