VbzCart/tables/ord trxact

About

 * Purpose: Money transactions for orders
 * Refers to: (parent), ,
 * 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
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;