VbzCart/tables/ord trx type

From HTYP, the free directory anyone can edit

[edit] 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

[edit] SQL

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;