VbzCart/tables/ord trxact

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< VbzCart‎ | tables
Revision as of 18:16, 27 December 2008 by Woozle (talk | contribs) (created)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

About

  • Purpose: Money transactions for orders
  • Refers to:
  1. REDIRECT Template:l/vc/table (parent), ord_pkgs, ord_trx_type
  • History:
    • 2008-12-27 Adapted from MS Access version ("Trxacts" table)
  • 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,
 `Descr`        VARCHAR(255),
 `Amount`       DECIMAL(9,2)     COMMENT "amount of transaction: +owed by customer -credit to customer",
 PRIMARY KEY(`ID`)

) ENGINE = MYISAM;</mysql>