Difference between revisions of "VbzCart/tables/ord trx type"
Jump to navigation
Jump to search
m (→About: now on L48) |
(future note about transaction categories) |
||
Line 1: | Line 1: | ||
==About== | ==About== | ||
− | * '''Purpose''': Types of transactions for {{vbzcart | + | * '''Purpose''': Types of transactions for {{vbzcart|table|ord_trxact}} |
+ | * '''Future''': | ||
+ | ** '''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. | ||
* '''History''': | * '''History''': | ||
** '''2008-12-27''' Adapted from MS Access version (table "TrxTypes") | ** '''2008-12-27''' Adapted from MS Access version (table "TrxTypes") | ||
** '''2009-07-07''' Added to L48 version of database | ** '''2009-07-07''' Added to L48 version of database | ||
− | |||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql>CREATE TABLE `ord_trx_type` ( | <section begin=sql /><mysql>CREATE TABLE `ord_trx_type` ( |
Revision as of 19:47, 31 March 2011
About
- Purpose: Types of transactions for ord_trxact
- Future:
- 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.
- History:
- 2008-12-27 Adapted from MS Access version (table "TrxTypes")
- 2009-07-07 Added to L48 version of database
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>