VbzCart/tables/ord trx type
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
About
- Purpose: Types of transactions for ord_trxact
- Future: remove obsolete field "isShipg".
History
- 2008-12-27 Adapted from MS Access version (table "TrxTypes")
- 2009-07-07 Added to L48 version of database
- 2016-09-11 Created Catg field per to-do note from 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."
Fields
- Code: unique transaction-type code to be included in transaction listings because it seemed like a good idea at the time. It is probably useful in some way we don't ordinarily notice but would be problematic if absent.
- Descr: brief reminder of what that transaction type is for. This is mainly for admin usage. When creating actual transactions, it's better to generate something more context-appropriate. That will become especially important if this code is ever translated into other languages.
- Catg: code indicating how transactions of this type should be classified in a summary: 1 = SALE, 2 = SHIPPING, 3 = PAID
- Do we need a 4 for "adjustments"? Let's say no for now...
SQL
<mysql>CREATE TABLE `ord_trx_type` (
`ID` INT NOT NULL AUTO_INCREMENT, `Code` VARCHAR(15), `Descr` VARCHAR(255), `Catg` TINYINT NOT NULL, `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>