VbzCart/tables/ord trx type

About

• Purpose: Types of transactions for

1. REDIRECT Template:l/vc/table

• History:
  • 2008-12-27 Adapted from MS Access version (table "TrxTypes")

SQL

<mysql>CREATE TABLE `ord_trx_types` (

 `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>