Difference between revisions of "VbzCart/tables/ord trxact"
Jump to navigation
Jump to search
(created) |
m (→About: now on L48) |
||
| (One intermediate revision by the same user not shown) | |||
| 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-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` ( | ||
| Line 13: | Line 16: | ||
`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", | ||
Latest revision as of 21:22, 7 July 2009
About
- Purpose: Money transactions for orders
- Refers to: core_orders (parent), ord_pkgs, ord_trx_type
- 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
<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>