Difference between revisions of "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
Jump to navigation Jump to search
(adapted from Access)
 
m (VbzCart/tables/ord trx types moved to VbzCart/tables/ord trx type: oops, trying to make table names singular from now on...)
(No difference)

Revision as of 18:10, 27 December 2008

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>

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