VbzCart/docs/tables/ord trxact: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (created) |
m (Woozle moved page VbzCart/VbzCart/tables/ord trxact to VbzCart/docs/tables/ord trxact without leaving a redirect: part 4/5) |
||
| (2 intermediate revisions by one other 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 01:57, 25 February 2024
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 />