VbzCart/tables/ord trxact

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to: navigation, search

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>