VbzCart/tables/ord trx type

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 19:47, 31 March 2011 by Woozle (talk | contribs) (future note about transaction categories)
Jump to navigation Jump to search

About

  • Purpose: Types of transactions for ord_trxact
  • Future:
    • 2011-03-31 There needs to be a field which assigns each transaction to a single category so that when we do accounting summaries (e.g. the transaction listing for each order), we can show subtotals for each category (e.g. $a sale, $b shipping, $c paid). Right now we're using the isX fields to do this, which is klugey because a transaction type can be assigned to more than one.
  • History:
    • 2008-12-27 Adapted from MS Access version (table "TrxTypes")
    • 2009-07-07 Added to L48 version of database

SQL

<mysql>CREATE TABLE `ord_trx_type` ( 

 `ID`           INT NOT NULL AUTO_INCREMENT,
 `Code`         VARCHAR(15),
 `Descr`        VARCHAR(255),
 `isCash`       BIT COMMENT "is actual money being sent/recived",
 `isCard`       BIT COMMENT "is checkcard or credit card (TRUE requires isCash=TRUE)",
 `isCheck`      BIT COMMENT "is check or money order (TRUE requires isCash=TRUE)",
 `isShipg`      BIT COMMENT "is shipping charge/refund",
 PRIMARY KEY(`ID`)

) ENGINE = MYISAM;</mysql>

Retrieved from "https://htyp.org/mw/index.php?title=VbzCart/tables/ord_trx_type&oldid=15075"