VbzCart/tables/rstk rcd - Revision history

Woozle: added Supplier and Warehouse fields

2016-01-14T00:25:39Z

added Supplier and Warehouse fields

← Older revision		Revision as of 00:25, 14 January 2016
Line 17:		Line 17:
	* '''2008-12-17''' Added '''InvcEntry''' field		* '''2008-12-17''' Added '''InvcEntry''' field
	* '''2016-01-06''' Renamed '''ID_Restock''' to '''ID_Request'''		* '''2016-01-06''' Renamed '''ID_Restock''' to '''ID_Request'''
			* '''2016-01-13''' Added '''ID_Supplier''' and '''ID_Warehouse''' fields (we previously had to look them up in the Request) because:
			** There might be restocks received without a Request that can reasonably be attached to them
			*** ...especially when entering old invoices, but possibly during the normal course of business
			** A restock might presumably be sent to a different Warehouse than where it was expected.
			** Having to look up the Request to get that information adds extra complexity.
	==SQL==		==SQL==
	<mysql>CREATE TABLE `rstk_rcd` (		<mysql>CREATE TABLE `rstk_rcd` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`ID_Request` INT COMMENT "rstk_req.ID of restock request fulfilled by this shipment",		`ID_Request` INT COMMENT "rstk_req.ID of restock request fulfilled by this shipment",
			`ID_Supplier` INT NOT NULL COMMENT "cat_supp.ID of supplier",
			`ID_Warehouse` INT COMMENT "stk_whse.ID of ship-to warehouse",
	`SuppInvcNum` VARCHAR(63) COMMENT "supplier's invoice number",		`SuppInvcNum` VARCHAR(63) COMMENT "supplier's invoice number",
	`CarrierDescr` VARCHAR(63) COMMENT "shipping carrier (UPS, USPS...)",		`CarrierDescr` VARCHAR(63) COMMENT "shipping carrier (UPS, USPS...)",

Woozle: more tidying: related table links consolidated

2016-01-06T18:57:55Z

more tidying: related table links consolidated

← Older revision		Revision as of 18:57, 6 January 2016
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': Master record for a restock shipment received~~; contents are in~~ {{vbzcart\|table\|rstk_rcd_line}}		* '''Purpose''': Master record for a restock (wholesale) shipment received
	* ~~'''Related''':~~ {{vbzcart\|table\|rstk_req}} ~~contains~~ restock requests, each of which may have one or more restock shipments received against it		* '''Related''':
			** {{vbzcart\|table\|rstk_rcd_line}} lists the contents of this shipment
			** {{vbzcart\|table\|rstk_req}} has the restock requests, each of which may have one or more restock shipments received against it
	* '''Future''':		* '''Future''':
	** Should this table be named '''rstk_shp''', and terminology changed from "restock received" to "restock shipment"?		** Should this table be named '''rstk_shp''', and terminology changed from "restock received" to "restock shipment"?

Woozle: ID_Restock -> ID_Request; tidying

2016-01-06T18:55:22Z

ID_Restock -> ID_Request; tidying

← Older revision		Revision as of 18:55, 6 January 2016
Line 2:		Line 2:
	* '''Purpose''': Master record for a restock shipment received; contents are in {{vbzcart\|table\|rstk_rcd_line}}		* '''Purpose''': Master record for a restock shipment received; contents are in {{vbzcart\|table\|rstk_rcd_line}}
	* '''Related''': {{vbzcart\|table\|rstk_req}} contains restock requests, each of which may have one or more restock shipments received against it		* '''Related''': {{vbzcart\|table\|rstk_req}} contains restock requests, each of which may have one or more restock shipments received against it
	* '''Fields''':
	** '''InvcCondition''': an integer describing the condition of the invoice paperwork --
	*** 0 = absent (no invoices found)
	*** 1 = partial (one or more pages missing/illegible)
	*** 2 = complete (all pages located and legible)
	* '''History''':
	** '''2008-11-07''' Created
	** '''2008-12-17''' Added '''InvcEntry''' field
	* '''Future''':		* '''Future''':
	** '''ID_Restock''' should be named '''ID_Request''' or '''ID_Req'''.
	** Should this table be named '''rstk_shp''', and terminology changed from "restock received" to "restock shipment"?		** Should this table be named '''rstk_shp''', and terminology changed from "restock received" to "restock shipment"?
	** ~~Add~~ a field to ~~link to images of the invoice~~		==Fields==
			* '''InvcCondition''': an integer describing the condition of the invoice paperwork --
			** 0 = absent (no invoices found)
			** 1 = partial (one or more pages missing/illegible)
			** 2 = complete (all pages located and legible)
			* '''TrackingCode''': eventually there will be a table of carriers so we can retrieve tracking info or at least pull it up from the web
			* '''TotalInvFinal''': Final = Merch + Ship + Adj
			==History==
			* '''2008-11-07''' Created
			* '''2008-12-17''' Added '''InvcEntry''' field
			* '''2016-01-06''' Renamed '''ID_Restock''' to '''ID_Request'''
	==SQL==		==SQL==
	~~<section begin=sql />~~<mysql>CREATE TABLE `rstk_rcd` (		<mysql>CREATE TABLE `rstk_rcd` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`~~ID_Restock~~` INT COMMENT "rstk_req.ID of restock this shipment ~~fulfills~~",		`ID_Request` INT COMMENT "rstk_req.ID of restock request fulfilled by this shipment",
	`SuppInvcNum` VARCHAR(63) COMMENT "supplier's invoice number",		`SuppInvcNum` VARCHAR(63) COMMENT "supplier's invoice number",
	`CarrierDescr` VARCHAR(63) COMMENT "shipping carrier (UPS, USPS...)",		`CarrierDescr` VARCHAR(63) COMMENT "shipping carrier (UPS, USPS...)",
Line 37:		Line 38:
	)		)
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>
	~~<section end=sql />~~
	* '''TrackingCode''': eventually there will be a table of carriers so we can retrieve tracking info or at least pull it up from the web
	* '''TotalInvFinal''': Final = Merch + Ship + Adj
	* '''InvcCondition''': 0 = absent, 1 = partial, 2 = complete

Woozle: InvcCondition field

2010-11-26T03:18:11Z

InvcCondition field

← Older revision		Revision as of 03:18, 26 November 2010
Line 2:		Line 2:
	* '''Purpose''': Master record for a restock shipment received; contents are in {{vbzcart\|table\|rstk_rcd_line}}		* '''Purpose''': Master record for a restock shipment received; contents are in {{vbzcart\|table\|rstk_rcd_line}}
	* '''Related''': {{vbzcart\|table\|rstk_req}} contains restock requests, each of which may have one or more restock shipments received against it		* '''Related''': {{vbzcart\|table\|rstk_req}} contains restock requests, each of which may have one or more restock shipments received against it
			* '''Fields''':
			** '''InvcCondition''': an integer describing the condition of the invoice paperwork --
			*** 0 = absent (no invoices found)
			*** 1 = partial (one or more pages missing/illegible)
			*** 2 = complete (all pages located and legible)
	* '''History''':		* '''History''':
	** '''2008-11-07''' Created		** '''2008-11-07''' Created
Line 8:		Line 13:
	** '''ID_Restock''' should be named '''ID_Request''' or '''ID_Req'''.		** '''ID_Restock''' should be named '''ID_Request''' or '''ID_Req'''.
	** Should this table be named '''rstk_shp''', and terminology changed from "restock received" to "restock shipment"?		** Should this table be named '''rstk_shp''', and terminology changed from "restock received" to "restock shipment"?
			** Add a field to link to images of the invoice
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE TABLE `rstk_rcd` (		<section begin=sql /><mysql>CREATE TABLE `rstk_rcd` (

Woozle: future terminology changes; link to req table

2010-11-26T03:11:50Z

future terminology changes; link to req table

← Older revision		Revision as of 03:11, 26 November 2010
Line 1:		Line 1:
	==About==		==About==
	~~[[category:VbzCart/tables]]~~		* '''Purpose''': Master record for a restock shipment received; contents are in {{vbzcart\|table\|rstk_rcd_line}}
	* '''Purpose''': Master record for a restock shipment received; contents are in {{vbzcart/table\|rstk_rcd_line}}		* '''Related''': {{vbzcart\|table\|rstk_req}} contains restock requests, each of which may have one or more restock shipments received against it
	* '''History''':		* '''History''':
	** '''2008-11-07''' Created		** '''2008-11-07''' Created
	** '''2008-12-17''' Added '''InvcEntry''' field		** '''2008-12-17''' Added '''InvcEntry''' field
			* '''Future''':
			** '''ID_Restock''' should be named '''ID_Request''' or '''ID_Req'''.
			** Should this table be named '''rstk_shp''', and terminology changed from "restock received" to "restock shipment"?
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE TABLE `rstk_rcd` (		<section begin=sql /><mysql>CREATE TABLE `rstk_rcd` (

Woozle: +InvcEntry

2008-12-17T19:28:25Z

+InvcEntry

← Older revision		Revision as of 19:28, 17 December 2008
Line 1:		Line 1:
	==About==		==About==
	[[category:VbzCart/tables]]		[[category:VbzCart/tables]]
	* '''~~Created~~''': ~~2008-11-07~~		* '''Purpose''': Master record for a restock shipment received; contents are in {{vbzcart/table\|rstk_rcd_line}}
	* Master record for a restock shipment received; contents are in ~~[[..~~/rstk_rcd_line]]		* '''History''':
			** '''2008-11-07''' Created
			** '''2008-12-17''' Added '''InvcEntry''' field
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE TABLE `rstk_rcd` (		<section begin=sql /><mysql>CREATE TABLE `rstk_rcd` (
Line 9:		Line 11:
	`SuppInvcNum` VARCHAR(63) COMMENT "supplier's invoice number",		`SuppInvcNum` VARCHAR(63) COMMENT "supplier's invoice number",
	`CarrierDescr` VARCHAR(63) COMMENT "shipping carrier (UPS, USPS...)",		`CarrierDescr` VARCHAR(63) COMMENT "shipping carrier (UPS, USPS...)",
			`InvcEntry` TEXT DEFAULT NULL COMMENT "invoice lines as parseable text",
	`WhenShipped` DATETIME DEFAULT NULL COMMENT "when supplier shipped the package",		`WhenShipped` DATETIME DEFAULT NULL COMMENT "when supplier shipped the package",
	`WhenReceived` DATETIME DEFAULT NULL COMMENT "when package was received from supplier",		`WhenReceived` DATETIME DEFAULT NULL COMMENT "when package was received from supplier",

Woozle: /* SQL */ +InvcCondition

2008-11-10T11:49:58Z

SQL: +InvcCondition

← Older revision		Revision as of 11:49, 10 November 2008
Line 12:		Line 12:
	`WhenReceived` DATETIME DEFAULT NULL COMMENT "when package was received from supplier",		`WhenReceived` DATETIME DEFAULT NULL COMMENT "when package was received from supplier",
	`WhenDebited` DATETIME DEFAULT NULL COMMENT "when charge for order was debited",		`WhenDebited` DATETIME DEFAULT NULL COMMENT "when charge for order was debited",
	~~/* eventually there will be a table of carriers so we can retrieve tracking info or at least pull it up from the web */~~
	`TrackingCode` VARCHAR(63) COMMENT "carrier's tracking number",		`TrackingCode` VARCHAR(63) COMMENT "carrier's tracking number",
	`TotalCalcMerch` DECIMAL(9,2) COMMENT "total cost of merchandise calculated from contents of received restock",		`TotalCalcMerch` DECIMAL(9,2) COMMENT "total cost of merchandise calculated from contents of received restock",
	/* ~~amounts~~ from supplier invoice */		/* from supplier invoice */
	`TotalInvMerch` DECIMAL(9,2) COMMENT "total cost of merchandise invoiced",		`TotalInvMerch` DECIMAL(9,2) COMMENT "total cost of merchandise invoiced",
	`TotalInvShip` DECIMAL(9,2) COMMENT "total shipping cost invoiced",		`TotalInvShip` DECIMAL(9,2) COMMENT "total shipping cost invoiced",
	`TotalInvAdj` DECIMAL(9,2) COMMENT "total invoice adjustments",		`TotalInvAdj` DECIMAL(9,2) COMMENT "total invoice adjustments",
	~~/* Final = Merch + Ship + Adj */~~
	`TotalInvFinal` DECIMAL(9,2) COMMENT "final total on invoice (must match amt paid)",		`TotalInvFinal` DECIMAL(9,2) COMMENT "final total on invoice (must match amt paid)",
			`InvcCondition` INT DEFAULT NULL COMMENT "do we have all the paperwork for this invoice?",
	`PayMethod` VARCHAR(63) COMMENT "how payment was made, if not same as restock request",		`PayMethod` VARCHAR(63) COMMENT "how payment was made, if not same as restock request",
	`Notes` TEXT DEFAULT NULL COMMENT "human-entered notes",		`Notes` TEXT DEFAULT NULL COMMENT "human-entered notes",
Line 27:		Line 26:
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>
	<section end=sql />		<section end=sql />
			* '''TrackingCode''': eventually there will be a table of carriers so we can retrieve tracking info or at least pull it up from the web
			* '''TotalInvFinal''': Final = Merch + Ship + Adj
			* '''InvcCondition''': 0 = absent, 1 = partial, 2 = complete

Woozle: /* SQL */ 3 "When" fields (how did I manage to leave these out? what else have I forgotten?)

2008-11-10T01:08:38Z

SQL: 3 "When" fields (how did I manage to leave these out? what else have I forgotten?)

← Older revision		Revision as of 01:08, 10 November 2008
Line 9:		Line 9:
	`SuppInvcNum` VARCHAR(63) COMMENT "supplier's invoice number",		`SuppInvcNum` VARCHAR(63) COMMENT "supplier's invoice number",
	`CarrierDescr` VARCHAR(63) COMMENT "shipping carrier (UPS, USPS...)",		`CarrierDescr` VARCHAR(63) COMMENT "shipping carrier (UPS, USPS...)",
			`WhenShipped` DATETIME DEFAULT NULL COMMENT "when supplier shipped the package",
			`WhenReceived` DATETIME DEFAULT NULL COMMENT "when package was received from supplier",
			`WhenDebited` DATETIME DEFAULT NULL COMMENT "when charge for order was debited",
	/* 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 */
	`TrackingCode` VARCHAR(63) COMMENT "carrier's tracking number",		`TrackingCode` VARCHAR(63) COMMENT "carrier's tracking number",

Woozle: /* SQL */ -TotalEstFinal

2008-11-09T00:10:03Z

SQL: -TotalEstFinal

← Older revision		Revision as of 00:10, 9 November 2008
Line 11:		Line 11:
	/* 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 */
	`TrackingCode` VARCHAR(63) COMMENT "carrier's tracking number",		`TrackingCode` VARCHAR(63) COMMENT "carrier's tracking number",
	`TotalCalcMerch` DECIMAL(9,2) COMMENT "total cost of merchandise calculated ~~by us",~~		`TotalCalcMerch` DECIMAL(9,2) COMMENT "total cost of merchandise calculated from contents of received restock",
	~~`TotalEstFinal` DECIMAL(9,2) COMMENT "estimate~~ of ~~final charge~~",
	/* amounts from supplier invoice */		/* amounts from supplier invoice */
	`TotalInvMerch` DECIMAL(9,2) COMMENT "total cost of merchandise invoiced",		`TotalInvMerch` DECIMAL(9,2) COMMENT "total cost of merchandise invoiced",

Woozle: updated table names

2008-11-08T01:55:44Z

updated table names

← Older revision		Revision as of 01:55, 8 November 2008
Line 2:		Line 2:
	[[category:VbzCart/tables]]		[[category:VbzCart/tables]]
	* '''Created''': 2008-11-07		* '''Created''': 2008-11-07
	* Master record for a restock shipment received; contents are in [[../~~rstk_recd_line~~]]		* Master record for a restock shipment received; contents are in [[../rstk_rcd_line]]
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE TABLE `~~rstk_recd~~` (		<section begin=sql /><mysql>CREATE TABLE `rstk_rcd` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`ID_Restock` INT COMMENT "~~core_restocks~~.ID of restock this shipment fulfills",		`ID_Restock` INT COMMENT "rstk_req.ID of restock this shipment fulfills",
	`SuppInvcNum` VARCHAR(63) COMMENT "supplier's invoice number",		`SuppInvcNum` VARCHAR(63) COMMENT "supplier's invoice number",
	`CarrierDescr` VARCHAR(63) COMMENT "shipping carrier (UPS, USPS...)",		`CarrierDescr` VARCHAR(63) COMMENT "shipping carrier (UPS, USPS...)",