VbzCart/tables/ord pkgs - Revision history

Woozle: ChgItemSale; minor cleanup

2014-05-25T16:21:59Z

ChgItemSale; minor cleanup

← Older revision		Revision as of 16:21, 25 May 2014
Line 10:		Line 10:
	** '''ChgShipItm''': total charged for per-item shipping		** '''ChgShipItm''': total charged for per-item shipping
	** '''ChgShipPkg''': amount charged for per-package shipping		** '''ChgShipPkg''': amount charged for per-package shipping
			** '''ChgItmSale''': total charged price of all items in this package
	* '''Future''':		* '''Future''':
	** The field "ArrivalNotes" should be added to the message log; leaving it out of the migration for this table.		** The field "ArrivalNotes" should be added to the message log; leaving it out of the migration for this table.
	** There should be '''ChgItmSale''' to go with the other 2 Chg* fields. Duh.
	* '''History''':		* '''History''':
	** '''2010-10-19''' Added '''ChgShipItm''', '''ChgShipPkg''' to complete the record of what was charged for the package. (This should make it a lot easier to estimate shipping rates, though that's not why I added them. I added them from a vague sense that they should be there.)		** '''2010-10-19''' Added '''ChgShipItm''', '''ChgShipPkg''' to complete the record of what was charged for the package. (This should make it a lot easier to estimate shipping rates, though that's not why I added them. I added them from a vague sense that they should be there.)
			** '''2014-05-25''' Added '''ChgItmSale''' to complete the record of how each package contributes to the total.
	==SQL==		==SQL==
	~~<section begin=sql />~~<mysql>CREATE TABLE `ord_pkgs` (		<mysql>CREATE TABLE `ord_pkgs` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`Seq` INT COMMENT "number used to make user-friendly pkg #",		`Seq` INT COMMENT "number used to make user-friendly pkg #",
Line 26:		Line 27:
	`isReturn` BOOL COMMENT "TRUE = this package is being returned, not shipped out",		`isReturn` BOOL COMMENT "TRUE = this package is being returned, not shipped out",
	`ID_Shipment` INT COMMENT "ord_shipmt.ID",		`ID_Shipment` INT COMMENT "ord_shipmt.ID",
	`ChgShipItm` DECIMAL(9,2) COMMENT "total amount charged for per-item shipping",		`ChgShipItm` DECIMAL(9,2) DEFAULT NULL COMMENT "total amount charged for per-item shipping",
	`ChgShipPkg` DECIMAL(9,2) COMMENT "amount charged for per-package shipping",		`ChgShipPkg` DECIMAL(9,2) DEFAULT NULL COMMENT "amount charged for per-package shipping",
	`ShipCost` DECIMAL(9,2) COMMENT "actual cost of shipping (postage)",		`ChgItmSale` DECIMAL(9,2) DEFAULT NULL COMMENT "total sale amount of all charged items in package",
	`PkgCost` DECIMAL(9,2) COMMENT "actual cost of packaging / insurance",		`ShipCost` DECIMAL(9,2) DEFAULT NULL COMMENT "actual cost of shipping (postage)",
			`PkgCost` DECIMAL(9,2) DEFAULT NULL COMMENT "actual cost of packaging / insurance",
	`ShipPounds` FLOAT COMMENT "shipping weight in pounds (whole or fractional)",		`ShipPounds` FLOAT COMMENT "shipping weight in pounds (whole or fractional)",
	`ShipOunces` FLOAT COMMENT "shipping weight in ounces, less ShipPounds",		`ShipOunces` FLOAT COMMENT "shipping weight in ounces, less ShipPounds",
Line 38:		Line 40:
	)		)
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>
	~~<section end=sql />~~

Woozle: Another field I should have included

2010-10-20T18:43:29Z

Another field I should have included

← Older revision		Revision as of 18:43, 20 October 2010
Line 8:		Line 8:
	*** This field may be less useful in the web-based UI than it was in the Access/desktop UI.		*** This field may be less useful in the web-based UI than it was in the Access/desktop UI.
	** '''WhenVoided''': We're not deleting packages anymore. Instead, we mark an emptied, unsent package as "VOID", and log it in the container record. Voided package records can be re-used if they aren't assigned to a closed shipment; log the un-voiding prior to re-use. (Should there be a "WhenLocked" field to represent the shipment being closed? <s>Maybe WhenFinished does this...</s>) A package should never be voided without first zeroing stock in all line items.		** '''WhenVoided''': We're not deleting packages anymore. Instead, we mark an emptied, unsent package as "VOID", and log it in the container record. Voided package records can be re-used if they aren't assigned to a closed shipment; log the un-voiding prior to re-use. (Should there be a "WhenLocked" field to represent the shipment being closed? <s>Maybe WhenFinished does this...</s>) A package should never be voided without first zeroing stock in all line items.
	* '''ChgShipItm''': total charged for per-item shipping		** '''ChgShipItm''': total charged for per-item shipping
	* '''ChgShipPkg''': amount charged for per-package shipping		** '''ChgShipPkg''': amount charged for per-package shipping
	* '''~~Notes~~''':		* '''Future''':
	** The field "ArrivalNotes" should be added to the message log; leaving it out of the migration for this table.		** The field "ArrivalNotes" should be added to the message log; leaving it out of the migration for this table.
			** There should be '''ChgItmSale''' to go with the other 2 Chg* fields. Duh.
	* '''History''':		* '''History''':
	** '''2010-10-19''' Added '''ChgShipItm''', '''ChgShipPkg''' to complete the record of what was charged for the package.		** '''2010-10-19''' Added '''ChgShipItm''', '''ChgShipPkg''' to complete the record of what was charged for the package. (This should make it a lot easier to estimate shipping rates, though that's not why I added them. I added them from a vague sense that they should be there.)
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE TABLE `ord_pkgs` (		<section begin=sql /><mysql>CREATE TABLE `ord_pkgs` (

Woozle: better documentation of fields

2010-10-19T23:00:07Z

better documentation of fields

← Older revision		Revision as of 23:00, 19 October 2010
Line 2:		Line 2:
	* '''Purpose''': Packages shipped in response to a customer order ({{vbzcart/table\|core_orders}})		* '''Purpose''': Packages shipped in response to a customer order ({{vbzcart/table\|core_orders}})
	* '''Refers to''': {{vbzcart/table\|core_orders}} (parent), {{vbzcart/table\|ord_shipmt}}		* '''Refers to''': {{vbzcart/table\|core_orders}} (parent), {{vbzcart/table\|ord_shipmt}}
			* '''Used by''': {{vbzcart\|table\|ord_pkg_lines}} (child)
			* '''Fields''':
			** '''WhenFinished''': I'm going to go out on a limb and define this as the time when the package charges are added up and created as {{vbzcart\|table\|ord_trxact\|order transaction}} records.
			** '''WhenChecked''': When the package was marked as ready (checked off) for inclusion in the shipment
			*** This field may be less useful in the web-based UI than it was in the Access/desktop UI.
			** '''WhenVoided''': We're not deleting packages anymore. Instead, we mark an emptied, unsent package as "VOID", and log it in the container record. Voided package records can be re-used if they aren't assigned to a closed shipment; log the un-voiding prior to re-use. (Should there be a "WhenLocked" field to represent the shipment being closed? <s>Maybe WhenFinished does this...</s>) A package should never be voided without first zeroing stock in all line items.
			* '''ChgShipItm''': total charged for per-item shipping
			* '''ChgShipPkg''': amount charged for per-package shipping
	* '''Notes''':		* '''Notes''':
	** The field "ArrivalNotes" should be added to the message log; leaving it out of the migration for this table.		** The field "ArrivalNotes" should be added to the message log; leaving it out of the migration for this table.
	** '''WhenVoided''': We're not deleting packages anymore. Instead, we mark an emptied, unsent package as "VOID", and log it in the container record. Voided package records can be re-used if they aren't assigned to a closed shipment; log the un-voiding prior to re-use. (Should there be a "WhenLocked" field to represent the shipment being closed? Maybe WhenFinished does this...) A package should never be voided without first zeroing stock in all line items.
	* '''History''':		* '''History''':
	** '''2010-10-19''' Added '''ChgShipItm''', '''ChgShipPkg''' to complete the record of what was charged for the package.		** '''2010-10-19''' Added '''ChgShipItm''', '''ChgShipPkg''' to complete the record of what was charged for the package.
Line 13:		Line 20:
	`ID_Order` INT NOT NULL COMMENT "core_orders.ID",		`ID_Order` INT NOT NULL COMMENT "core_orders.ID",
	`WhenStarted` DATETIME COMMENT "when package record was created",		`WhenStarted` DATETIME COMMENT "when package record was created",
	`WhenFinished` DATETIME, ~~/* need to check code for actual purpose of field */~~		`WhenFinished` DATETIME,
	`WhenChecked` DATETIME, ~~/* need to check code for actual purpose of field */~~		`WhenChecked` DATETIME,
	`WhenVoided` DATETIME COMMENT "when package was emptied; can be reused later",		`WhenVoided` DATETIME COMMENT "when package was emptied; can be reused later",
	`isReturn` BOOL COMMENT "TRUE = this package is being returned, not shipped out",		`isReturn` BOOL COMMENT "TRUE = this package is being returned, not shipped out",

Woozle: Added ChgShipItm, ChgShipPkg

2010-10-19T22:39:41Z

Added ChgShipItm, ChgShipPkg

← Older revision		Revision as of 22:39, 19 October 2010
Line 5:		Line 5:
	** The field "ArrivalNotes" should be added to the message log; leaving it out of the migration for this table.		** The field "ArrivalNotes" should be added to the message log; leaving it out of the migration for this table.
	** '''WhenVoided''': We're not deleting packages anymore. Instead, we mark an emptied, unsent package as "VOID", and log it in the container record. Voided package records can be re-used if they aren't assigned to a closed shipment; log the un-voiding prior to re-use. (Should there be a "WhenLocked" field to represent the shipment being closed? Maybe WhenFinished does this...) A package should never be voided without first zeroing stock in all line items.		** '''WhenVoided''': We're not deleting packages anymore. Instead, we mark an emptied, unsent package as "VOID", and log it in the container record. Voided package records can be re-used if they aren't assigned to a closed shipment; log the un-voiding prior to re-use. (Should there be a "WhenLocked" field to represent the shipment being closed? Maybe WhenFinished does this...) A package should never be voided without first zeroing stock in all line items.
			* '''History''':
			** '''2010-10-19''' Added '''ChgShipItm''', '''ChgShipPkg''' to complete the record of what was charged for the package.
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE TABLE `ord_pkgs` (		<section begin=sql /><mysql>CREATE TABLE `ord_pkgs` (
Line 16:		Line 18:
	`isReturn` BOOL COMMENT "TRUE = this package is being returned, not shipped out",		`isReturn` BOOL COMMENT "TRUE = this package is being returned, not shipped out",
	`ID_Shipment` INT COMMENT "ord_shipmt.ID",		`ID_Shipment` INT COMMENT "ord_shipmt.ID",
	`ShipCost` DECIMAL(9,2) COMMENT "cost of shipping (postage)",		`ChgShipItm` DECIMAL(9,2) COMMENT "total amount charged for per-item shipping",
	`PkgCost` DECIMAL(9,2) COMMENT "cost of packaging / insurance",		`ChgShipPkg` DECIMAL(9,2) COMMENT "amount charged for per-package shipping",
			`ShipCost` DECIMAL(9,2) COMMENT "actual cost of shipping (postage)",
			`PkgCost` DECIMAL(9,2) COMMENT "actual cost of packaging / insurance",
	`ShipPounds` FLOAT COMMENT "shipping weight in pounds (whole or fractional)",		`ShipPounds` FLOAT COMMENT "shipping weight in pounds (whole or fractional)",
	`ShipOunces` FLOAT COMMENT "shipping weight in ounces, less ShipPounds",		`ShipOunces` FLOAT COMMENT "shipping weight in ounces, less ShipPounds",

Woozle: extracted from VbzCart/tables

2008-12-27T15:22:37Z

extracted from VbzCart/tables

New page

==About==
* '''Purpose''': Packages shipped in response to a customer order ({{vbzcart/table|core_orders}})
* '''Refers to''': {{vbzcart/table|core_orders}} (parent), {{vbzcart/table|ord_shipmt}}
* '''Notes''':
** The field "ArrivalNotes" should be added to the message log; leaving it out of the migration for this table.
** '''WhenVoided''': We're not deleting packages anymore. Instead, we mark an emptied, unsent package as "VOID", and log it in the container record. Voided package records can be re-used if they aren't assigned to a closed shipment; log the un-voiding prior to re-use. (Should there be a "WhenLocked" field to represent the shipment being closed? Maybe WhenFinished does this...) A package should never be voided without first zeroing stock in all line items.
==SQL==
<section begin=sql /><mysql>CREATE TABLE `ord_pkgs` (
`ID` INT NOT NULL AUTO_INCREMENT,
`Seq` INT COMMENT "number used to make user-friendly pkg #",
`ID_Order` INT NOT NULL COMMENT "core_orders.ID",
`WhenStarted` DATETIME COMMENT "when package record was created",
`WhenFinished` DATETIME, /* need to check code for actual purpose of field */
`WhenChecked` DATETIME, /* need to check code for actual purpose of field */
`WhenVoided` DATETIME COMMENT "when package was emptied; can be reused later",
`isReturn` BOOL COMMENT "TRUE = this package is being returned, not shipped out",
`ID_Shipment` INT COMMENT "ord_shipmt.ID",
`ShipCost` DECIMAL(9,2) COMMENT "cost of shipping (postage)",
`PkgCost` DECIMAL(9,2) COMMENT "cost of packaging / insurance",
`ShipPounds` FLOAT COMMENT "shipping weight in pounds (whole or fractional)",
`ShipOunces` FLOAT COMMENT "shipping weight in ounces, less ShipPounds",
`ShipNotes` VARCHAR(255) COMMENT "human-entered notes about this pkg",
`ShipTracking` VARCHAR(127) COMMENT "shipper's tracking number for pkg",
`WhenArrived` DATETIME COMMENT "when arrived at customer, if known",
PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;</mysql>
<section end=sql />