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 21:21, 7 July 2009 by Woozle (talk | contribs) (→About: now on L48)

About

  • Purpose: Types of transactions for ord_trxact
  • History:
    • 2008-12-27 Adapted from MS Access version (table "TrxTypes")
    • 2009-07-07 Added to L48 version of database

SQL

<section begin=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> <section end=sql />

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