VbzCart/tables/ord trxact - Revision history

Woozle: /* About */ now on L48

2009-07-07T21:22:35Z

About: now on L48

← Older revision		Revision as of 21:22, 7 July 2009
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': Money transactions for orders		* '''Purpose''': Money transactions for orders
	* '''Refers to''': {{vbzcart/table\|core_orders}} (parent), {{vbzcart/table\|ord_pkgs}}, {{vbzcart/table\|ord_trx_type}}		* '''Refers to''': {{vbzcart\|table\|core_orders}} (parent), {{vbzcart\|table\|ord_pkgs}}, {{vbzcart\|table\|ord_trx_type}}
	* '''History''':		* '''History''':
	** '''2008-12-27''' Adapted from MS Access version ("Trxacts" table)		** '''2008-12-27''' Adapted from MS Access version ("Trxacts" table)
	** '''2009-01-05''' Added WhenVoid field - deleting records leaves mysterious holes in the sequence; let's just void them		** '''2009-01-05''' Added WhenVoid field - deleting records leaves mysterious holes in the sequence; let's just void them
			** '''2009-07-07''' Added to L48 version of database
	* '''Fields''':		* '''Fields''':
	** '''ID_Package''' should be used to facilitate printing only package-relevant transactions on a packing slip, but I don't know if this is currently workable.		** '''ID_Package''' should be used to facilitate printing only package-relevant transactions on a packing slip, but I don't know if this is currently workable.

	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE TABLE `ord_trxact` (		<section begin=sql /><mysql>CREATE TABLE `ord_trxact` (

Woozle: +WhenVoid

2009-01-05T21:44:24Z

+WhenVoid

← Older revision		Revision as of 21:44, 5 January 2009
Line 4:		Line 4:
	* '''History''':		* '''History''':
	** '''2008-12-27''' Adapted from MS Access version ("Trxacts" table)		** '''2008-12-27''' Adapted from MS Access version ("Trxacts" table)
			** '''2009-01-05''' Added WhenVoid field - deleting records leaves mysterious holes in the sequence; let's just void them
	* '''Fields''':		* '''Fields''':
	** '''ID_Package''' should be used to facilitate printing only package-relevant transactions on a packing slip, but I don't know if this is currently workable.		** '''ID_Package''' should be used to facilitate printing only package-relevant transactions on a packing slip, but I don't know if this is currently workable.
Line 13:		Line 14:
	`ID_Type` INT NOT NULL COMMENT "ord_trx_type.ID",		`ID_Type` INT NOT NULL COMMENT "ord_trx_type.ID",
	`WhenDone` DATETIME DEFAULT NULL,		`WhenDone` DATETIME DEFAULT NULL,
			`WhenVoid` DATETIME DEFAULT NULL,
	`Descr` VARCHAR(255),		`Descr` VARCHAR(255),
	`Amount` DECIMAL(9,2) COMMENT "amount of transaction: +owed by customer -credit to customer",		`Amount` DECIMAL(9,2) COMMENT "amount of transaction: +owed by customer -credit to customer",

Woozle: created

2008-12-27T18:16:25Z

created

New page

==About==
* '''Purpose''': Money transactions for orders
* '''Refers to''': {{vbzcart/table|core_orders}} (parent), {{vbzcart/table|ord_pkgs}}, {{vbzcart/table|ord_trx_type}}
* '''History''':
** '''2008-12-27''' Adapted from MS Access version ("Trxacts" table)
* '''Fields''':
** '''ID_Package''' should be used to facilitate printing only package-relevant transactions on a packing slip, but I don't know if this is currently workable.
==SQL==
<section begin=sql /><mysql>CREATE TABLE `ord_trxact` (
`ID` INT NOT NULL AUTO_INCREMENT,
`ID_Order` INT NOT NULL COMMENT "core_orders.ID",
`ID_Package` INT DEFAULT NULL COMMENT "ord_pkgs.ID",
`ID_Type` INT NOT NULL COMMENT "ord_trx_type.ID",
`WhenDone` DATETIME DEFAULT NULL,
`Descr` VARCHAR(255),
`Amount` DECIMAL(9,2) COMMENT "amount of transaction: +owed by customer -credit to customer",
PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;</mysql>
<section end=sql />