VbzCart/tables/rstk req - Revision history

Woozle: /* SQL */ warehouse now has its own table

2016-01-14T00:12:25Z

SQL: warehouse now has its own table

← Older revision		Revision as of 00:12, 14 January 2016
Line 19:		Line 19:
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`ID_Supplier` INT NOT NULL COMMENT "cat_supp.ID of supplier",		`ID_Supplier` INT NOT NULL COMMENT "cat_supp.ID of supplier",
	`ID_Warehouse` INT COMMENT "~~cat_supp~~.ID of ship-to warehouse",		`ID_Warehouse` INT COMMENT "stk_whse.ID of ship-to warehouse",
	`PurchOrdNum` VARCHAR(63) COMMENT "our purchase order number",		`PurchOrdNum` VARCHAR(63) COMMENT "our purchase order number",
	`SuppOrdNum` VARCHAR(63) COMMENT "supplier's order number",		`SuppOrdNum` VARCHAR(63) COMMENT "supplier's order number",

Woozle: related tables; purpose

2016-01-01T01:49:45Z

related tables; purpose

← Older revision		Revision as of 01:49, 1 January 2016
Line 1:		Line 1:
	==About==		==About==
	[[category:VbzCart/tables]]		[[category:VbzCart/tables]]
			'''Purpose''': restock requests (i.e. wholesale orders) sent to Suppliers
	===History===		===History===
	* '''2008-11-07''' several fields moved to <s>rstk_recd</s> {{vbzcart\|table\|rstk_rcd}}		* '''2008-11-07''' several fields moved to <s>rstk_recd</s> {{vbzcart\|table\|rstk_rcd}}
Line 6:		Line 7:
	* '''2008-11-20''' +WhenClosed		* '''2008-11-20''' +WhenClosed
	* '''2010-01-02''' +SuppPONum so we can reliably sort by our assigned PO #s		* '''2010-01-02''' +SuppPONum so we can reliably sort by our assigned PO #s
			===Related===
			* {{vbzcart\|table\|rstk_req_item}}: detail table
			* {{vbzcart\|table\|rstk_rcd}}: every restock received points to a restock request
	===Fields===		===Fields===
	* '''WhenKilled''' indicates that the order was either cancelled or never sent to the supplier, so no shipments are expected.		* '''WhenKilled''' indicates that the order was either cancelled or never sent to the supplier, so no shipments are expected.

Woozle: subsections; note about CarrierDescr

2015-12-25T17:48:16Z

subsections; note about CarrierDescr

← Older revision		Revision as of 17:48, 25 December 2015
Line 1:		Line 1:
	==About==		==About==
	[[category:VbzCart/tables]]		[[category:VbzCart/tables]]
	* '''History~~''':~~		===History===
	** '''2008-11-07''' several fields moved to <s>rstk_recd</s> {{vbzcart\|table\|rstk_rcd}}		* '''2008-11-07''' several fields moved to <s>rstk_recd</s> {{vbzcart\|table\|rstk_rcd}}
	** '''2008-11-19''' +WhenOrphaned		* '''2008-11-19''' +WhenOrphaned
	** '''2008-11-20''' +WhenClosed		* '''2008-11-20''' +WhenClosed
	** '''2010-01-02''' +SuppPONum so we can reliably sort by our assigned PO #s		* '''2010-01-02''' +SuppPONum so we can reliably sort by our assigned PO #s
	* '''Notes''':		===Fields===
	** '''WhenKilled''' indicates that the order was either cancelled or never sent to the supplier, so no shipments are expected.		* '''WhenKilled''' indicates that the order was either cancelled or never sent to the supplier, so no shipments are expected.
	** '''WhenOrphaned''' indicates that there probably was at least one shipment received in response, but we don't have any data. This is for old restock records where paperwork is missing, so we don't know what date to fill in but we also don't want to keep the restock request active.		* '''WhenOrphaned''' indicates that there probably was at least one shipment received in response, but we don't have any data. This is for old restock records where paperwork is missing, so we don't know what date to fill in but we also don't want to keep the restock request active.
	** '''WhenClosed''' indicates that we are no longer expecting any responses to the restock request. This happens when the order has generated at least one received package and there are no items remaining on backorder with the supplier.		* '''WhenClosed''' indicates that we are no longer expecting any responses to the restock request. This happens when the order has generated at least one received package and there are no items remaining on backorder with the supplier.
			* '''CarrierDescr''' will eventually be replaced or supplemented by a more rigorous method of tracking delivery carriers. For now, it lets us keep a record without having to do that.
	==SQL==		==SQL==
	~~<section begin=sql />~~<mysql>CREATE TABLE `rstk_req` (		<mysql>CREATE TABLE `rstk_req` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`ID_Supplier` INT NOT NULL COMMENT "cat_supp.ID of supplier",		`ID_Supplier` INT NOT NULL COMMENT "cat_supp.ID of supplier",
Line 37:		Line 38:
	)		)
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>
	~~<section end=sql />~~

Woozle: +SuppPONum; updated documentation & layout

2010-01-02T19:54:37Z

+SuppPONum; updated documentation & layout

← Older revision		Revision as of 19:54, 2 January 2010
Line 1:		Line 1:
	==About==		==About==
	[[category:VbzCart/tables]]		[[category:VbzCart/tables]]
	* '''Modified''': 2008-11-07; several fields moved to rstk_recd; to replace [[../core_restocks]]
	~~==SQL==~~
	* '''History''':		* '''History''':
			** '''2008-11-07''' several fields moved to <s>rstk_recd</s> {{vbzcart\|table\|rstk_rcd}}
	** '''2008-11-19''' +WhenOrphaned		** '''2008-11-19''' +WhenOrphaned
	** '''2008-11-20''' +WhenClosed		** '''2008-11-20''' +WhenClosed
			** '''2010-01-02''' +SuppPONum so we can reliably sort by our assigned PO #s
	* '''Notes''':		* '''Notes''':
	** '''WhenKilled''' indicates that the order was either cancelled or never sent to the supplier, so no shipments are expected.		** '''WhenKilled''' indicates that the order was either cancelled or never sent to the supplier, so no shipments are expected.
	** '''WhenOrphaned''' indicates that there probably was at least one shipment received in response, but we don't have any data. This is for old restock records where paperwork is missing, so we don't know what date to fill in but we also don't want to keep the restock request active.		** '''WhenOrphaned''' indicates that there probably was at least one shipment received in response, but we don't have any data. This is for old restock records where paperwork is missing, so we don't know what date to fill in but we also don't want to keep the restock request active.
	** '''WhenClosed''' indicates that we are no longer expecting any responses to the restock request. This happens when the order has generated at least one received package and there are no items remaining on backorder with the supplier.		** '''WhenClosed''' indicates that we are no longer expecting any responses to the restock request. This happens when the order has generated at least one received package and there are no items remaining on backorder with the supplier.
			==SQL==
	<section begin=sql /><mysql>CREATE TABLE `rstk_req` (		<section begin=sql /><mysql>CREATE TABLE `rstk_req` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
Line 16:		Line 17:
	`PurchOrdNum` VARCHAR(63) COMMENT "our purchase order number",		`PurchOrdNum` VARCHAR(63) COMMENT "our purchase order number",
	`SuppOrdNum` VARCHAR(63) COMMENT "supplier's order number",		`SuppOrdNum` VARCHAR(63) COMMENT "supplier's order number",
			`SuppPONum` VARCHAR(63) COMMENT "purchase order number assigned by supplier",
	`CarrierDescr` VARCHAR(63) COMMENT "shipping carrier requested (UPS, USPS...)",		`CarrierDescr` VARCHAR(63) COMMENT "shipping carrier requested (UPS, USPS...)",
	/* eventually there will be a table of carriers so we can retrieve tracking info or at least pull it up from the web */		/* eventually there will be a table of carriers so we can retrieve tracking info or at least pull it up from the web */

Woozle: /* SQL */ +WhenClosed

2008-11-20T14:01:54Z

SQL: +WhenClosed

← Older revision		Revision as of 14:01, 20 November 2008
Line 5:		Line 5:
	* '''History''':		* '''History''':
	** '''2008-11-19''' +WhenOrphaned		** '''2008-11-19''' +WhenOrphaned
			** '''2008-11-20''' +WhenClosed
	* '''Notes''':		* '''Notes''':
	** '''WhenKilled''' indicates that the order was either cancelled or never sent to the supplier, so no shipments are expected.		** '''WhenKilled''' indicates that the order was either cancelled or never sent to the supplier, so no shipments are expected.
	** '''WhenOrphaned''' indicates that there probably was at least one shipment received in response, but we don't have any data. This is for old restock records where paperwork is missing, so we don't know what date to fill in but we also don't want to keep the restock request active.		** '''WhenOrphaned''' indicates that there probably was at least one shipment received in response, but we don't have any data. This is for old restock records where paperwork is missing, so we don't know what date to fill in but we also don't want to keep the restock request active.
			** '''WhenClosed''' indicates that we are no longer expecting any responses to the restock request. This happens when the order has generated at least one received package and there are no items remaining on backorder with the supplier.
	<section begin=sql /><mysql>CREATE TABLE `rstk_req` (		<section begin=sql /><mysql>CREATE TABLE `rstk_req` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
Line 24:		Line 26:
	`WhenConfirmed` DATETIME DEFAULT NULL COMMENT "when order was confirmed with supplier",		`WhenConfirmed` DATETIME DEFAULT NULL COMMENT "when order was confirmed with supplier",
	`WhenKilled` DATETIME DEFAULT NULL COMMENT "when order was explicitly cancelled or abandoned",		`WhenKilled` DATETIME DEFAULT NULL COMMENT "when order was explicitly cancelled or abandoned",
			`WhenClosed` DATETIME DEFAULT NULL COMMENT "when order was no longer considered active",
	`WhenOrphaned` DATETIME DEFAULT NULL COMMENT "when we decided the restock record could not be completed",		`WhenOrphaned` DATETIME DEFAULT NULL COMMENT "when we decided the restock record could not be completed",
	`WhenExpectedOrig` DATETIME DEFAULT NULL COMMENT "when we originally expected to receive order",		`WhenExpectedOrig` DATETIME DEFAULT NULL COMMENT "when we originally expected to receive order",

Woozle: /* SQL */ +WhenOrphaned

2008-11-19T21:22:15Z

SQL: +WhenOrphaned

← Older revision		Revision as of 21:22, 19 November 2008
Line 3:		Line 3:
	* '''Modified''': 2008-11-07; several fields moved to rstk_recd; to replace [[../core_restocks]]		* '''Modified''': 2008-11-07; several fields moved to rstk_recd; to replace [[../core_restocks]]
	==SQL==		==SQL==
			* '''History''':
			** '''2008-11-19''' +WhenOrphaned
			* '''Notes''':
			** '''WhenKilled''' indicates that the order was either cancelled or never sent to the supplier, so no shipments are expected.
			** '''WhenOrphaned''' indicates that there probably was at least one shipment received in response, but we don't have any data. This is for old restock records where paperwork is missing, so we don't know what date to fill in but we also don't want to keep the restock request active.
	<section begin=sql /><mysql>CREATE TABLE `rstk_req` (		<section begin=sql /><mysql>CREATE TABLE `rstk_req` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
Line 18:		Line 23:
	`WhenOrdered` DATETIME DEFAULT NULL COMMENT "when order was placed with supplier",		`WhenOrdered` DATETIME DEFAULT NULL COMMENT "when order was placed with supplier",
	`WhenConfirmed` DATETIME DEFAULT NULL COMMENT "when order was confirmed with supplier",		`WhenConfirmed` DATETIME DEFAULT NULL COMMENT "when order was confirmed with supplier",
	`WhenKilled` DATETIME DEFAULT NULL COMMENT "when order was ~~negated,~~ cancelled, ~~or otherwise terminated unsuccessfully~~",		`WhenKilled` DATETIME DEFAULT NULL COMMENT "when order was explicitly cancelled or abandoned",
			`WhenOrphaned` DATETIME DEFAULT NULL COMMENT "when we decided the restock record could not be completed",
	`WhenExpectedOrig` DATETIME DEFAULT NULL COMMENT "when we originally expected to receive order",		`WhenExpectedOrig` DATETIME DEFAULT NULL COMMENT "when we originally expected to receive order",
	`WhenExpectedFinal` DATETIME DEFAULT NULL COMMENT "most recent ETA",		`WhenExpectedFinal` DATETIME DEFAULT NULL COMMENT "most recent ETA",

Woozle: /* SQL */ updated name of table

2008-11-08T01:53:34Z

SQL: updated name of table

← Older revision		Revision as of 01:53, 8 November 2008
Line 3:		Line 3:
	* '''Modified''': 2008-11-07; several fields moved to rstk_recd; to replace [[../core_restocks]]		* '''Modified''': 2008-11-07; several fields moved to rstk_recd; to replace [[../core_restocks]]
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE TABLE `~~core_restock_new~~` (		<section begin=sql /><mysql>CREATE TABLE `rstk_req` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`ID_Supplier` INT NOT NULL COMMENT "cat_supp.ID of supplier",		`ID_Supplier` INT NOT NULL COMMENT "cat_supp.ID of supplier",

Woozle: VbzCart/tables/core restock new moved to VbzCart/tables/rstk req: reorganized naming for restock tables

2008-11-08T01:52:20Z

VbzCart/tables/core restock new moved to VbzCart/tables/rstk req: reorganized naming for restock tables

← Older revision	Revision as of 01:52, 8 November 2008
(No difference)

Woozle: New page: ==About== category:VbzCart/tables * '''Modified''': 2008-11-07; several fields moved to rstk_recd; to replace ../core_restocks ==SQL==
CREATE TABLE `cor...

2008-11-07T18:02:46Z

New page: ==About== category:VbzCart/tables * '''Modified''': 2008-11-07; several fields moved to rstk_recd; to replace [[../core_restocks]] ==SQL== <section begin=sql /><mysql>CREATE TABLE `cor...

New page

==About==
[[category:VbzCart/tables]]
* '''Modified''': 2008-11-07; several fields moved to rstk_recd; to replace [[../core_restocks]]
==SQL==
<section begin=sql /><mysql>CREATE TABLE `core_restock_new` (
`ID` INT NOT NULL AUTO_INCREMENT,
`ID_Supplier` INT NOT NULL COMMENT "cat_supp.ID of supplier",
`ID_Warehouse` INT COMMENT "cat_supp.ID of ship-to warehouse",
`PurchOrdNum` VARCHAR(63) COMMENT "our purchase order number",
`SuppOrdNum` VARCHAR(63) COMMENT "supplier's order number",
`CarrierDescr` VARCHAR(63) COMMENT "shipping carrier requested (UPS, USPS...)",
/* eventually there will be a table of carriers so we can retrieve tracking info or at least pull it up from the web */
`TotalCalcMerch` DECIMAL(9,2) COMMENT "total cost of merchandise calculated by us",
`TotalEstFinal` DECIMAL(9,2) COMMENT "estimate of final charge",
/* Final = Merch + Ship + Adj */
`PayMethod` VARCHAR(63) COMMENT "how payment was made (typically: which credit card?)",
`WhenCreated` DATETIME DEFAULT NULL COMMENT "when restock order was started (created)",
`WhenOrdered` DATETIME DEFAULT NULL COMMENT "when order was placed with supplier",
`WhenConfirmed` DATETIME DEFAULT NULL COMMENT "when order was confirmed with supplier",
`WhenKilled` DATETIME DEFAULT NULL COMMENT "when order was negated, cancelled, or otherwise terminated unsuccessfully",
`WhenExpectedOrig` DATETIME DEFAULT NULL COMMENT "when we originally expected to receive order",
`WhenExpectedFinal` DATETIME DEFAULT NULL COMMENT "most recent ETA",
`isLocked` BOOL DEFAULT FALSE COMMENT "TRUE = items may not be edited",
`Notes` TEXT DEFAULT NULL COMMENT "human-entered notes",
PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;</mysql>
<section end=sql />