VbzCart/tables/rstk rcd line - Revision history

Woozle: renamed ID_RstkReq -> ID_Parent; tidying

2016-01-06T19:00:54Z

renamed ID_RstkReq -> ID_Parent; tidying

← Older revision		Revision as of 19:00, 6 January 2016
Line 2:		Line 2:
	[[category:VbzCart/tables]]		[[category:VbzCart/tables]]
	* '''Purpose''': Items actually received in a restock shipment		* '''Purpose''': Items actually received in a restock shipment
	* '''Fields~~''':~~		==Fields==
	** '''CostActBal''' may be unnecessary anywhere except [[MS Access\|Access]], in which it is difficult for continuous form fields to show cumulatively calculated results rather than a value derived from a specific row -- evaluation of field functions for each row may take place in an order that does not correspond with the row's position on the form.		* '''CostActBal''' may be unnecessary anywhere except [[MS Access\|Access]], in which it is difficult for continuous form fields to show cumulatively calculated results rather than a value derived from a specific row -- evaluation of field functions for each row may take place in an order that does not correspond with the row's position on the form.
	* '''History~~''':~~		==History==
	** '''2008-11-07''' Created for revised restocking process -- split off from {{vbzcart\|table\|rstk_lines}}		* '''2008-11-07''' Created for revised restocking process -- split off from {{vbzcart\|table\|rstk_lines}}
	** '''2008-11-09''' +'''InvcDescr''' field, ID_RstkRecd -> '''ID_RstkRcd'''		* '''2008-11-09''' +'''InvcDescr''' field, ID_RstkRecd -> '''ID_RstkRcd'''
	** '''2008-11-18''' Changed '''InvcLineNo''' from DECIMAL(3,3) to DECIMAL(6,3)		* '''2008-11-18''' Changed '''InvcLineNo''' from DECIMAL(3,3) to DECIMAL(6,3)
	** '''2008-12-16''' Added '''InvcCatNo''' - can be used to update {{vbzcart/table\|cat_items}}.Supp_CatNum, if it wasn't updated during the request entry (requests sometimes get entered by pasting from the supplier's version of the order, which has SCat#s).		* '''2008-12-16''' Added '''InvcCatNo''' - can be used to update {{vbzcart/table\|cat_items}}.Supp_CatNum, if it wasn't updated during the request entry (requests sometimes get entered by pasting from the supplier's version of the order, which has SCat#s).
	** '''2010-11-28'''		* '''2010-11-28'''
	*** Added '''isActive''' field to help with data entry process: when invoice text is parsed, all existing lines are deactivated (not deleted), and then updated with new info and reactivated.		** Added '''isActive''' field to help with data entry process: when invoice text is parsed, all existing lines are deactivated (not deleted), and then updated with new info and reactivated.
	*** Changed '''InvcLineNo''' from DECIMAL(6,3) to INT. No fractions found in historical data, and current design makes it unnecessary. (If this is wrong, scenario needs to be documented.)		** Changed '''InvcLineNo''' from DECIMAL(6,3) to INT. No fractions found in historical data, and current design makes it unnecessary. (If this is wrong, scenario needs to be documented.)
			* '''2016-01-06''' Renamed '''ID_RstkRcd''' to '''ID_Parent'''
	==SQL==		==SQL==
	~~<section begin=sql />~~<mysql>CREATE TABLE `rstk_rcd_line` (		<mysql>CREATE TABLE `rstk_rcd_line` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`~~ID_RstkRcd~~` INT COMMENT "rstk_recd.ID of received restock shipment this line belongs to",		`ID_Parent` INT COMMENT "rstk_recd.ID of received restock shipment this line belongs to",
	`ID_Item` INT COMMENT "cat_items.ID of item being restocked",		`ID_Item` INT COMMENT "cat_items.ID of item being restocked",
	`isActive` BOOL DEFAULT NULL "FALSE = data in this line is obsolete, so ignore it",		`isActive` BOOL DEFAULT NULL "FALSE = data in this line is obsolete, so ignore it",
Line 35:		Line 36:
	)		)
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>
	~~<section end=sql />~~

Woozle: InvcLineNo is now an INT

2010-11-28T17:39:15Z

InvcLineNo is now an INT

← Older revision		Revision as of 17:39, 28 November 2010
Line 5:		Line 5:
	** '''CostActBal''' may be unnecessary anywhere except [[MS Access\|Access]], in which it is difficult for continuous form fields to show cumulatively calculated results rather than a value derived from a specific row -- evaluation of field functions for each row may take place in an order that does not correspond with the row's position on the form.		** '''CostActBal''' may be unnecessary anywhere except [[MS Access\|Access]], in which it is difficult for continuous form fields to show cumulatively calculated results rather than a value derived from a specific row -- evaluation of field functions for each row may take place in an order that does not correspond with the row's position on the form.
	* '''History''':		* '''History''':
	** '''2008-11-07''' Created for revised restocking process -- split off from ~~[[../~~rstk_lines]]		** '''2008-11-07''' Created for revised restocking process -- split off from {{vbzcart\|table\|rstk_lines}}
	** '''2008-11-09''' +'''InvcDescr''' field, ID_RstkRecd -> '''ID_RstkRcd'''		** '''2008-11-09''' +'''InvcDescr''' field, ID_RstkRecd -> '''ID_RstkRcd'''
	** '''2008-11-18''' Changed '''InvcLineNo''' from DECIMAL(3,3) to DECIMAL(6,3)		** '''2008-11-18''' Changed '''InvcLineNo''' from DECIMAL(3,3) to DECIMAL(6,3)
	*** Do the decimals ever get used? Was this a relic of the old system?		** '''2008-12-16''' Added '''InvcCatNo''' - can be used to update {{vbzcart/table\|cat_items}}.Supp_CatNum, if it wasn't updated during the request entry (requests sometimes get entered by pasting from the supplier's version of the order, which has SCat#s).
	** '''2008-12-16''' Added '''InvcCatNo''' - can be used to update {{vbzcart/table\|cat_items}}.Supp_CatNum		** '''2010-11-28'''
	** '''2010-11-28''' Added '''isActive''' field to help with data entry process		*** Added '''isActive''' field to help with data entry process: when invoice text is parsed, all existing lines are deactivated (not deleted), and then updated with new info and reactivated.
	*** When invoice text is parsed, all existing lines are deactivated (not deleted), and then updated with new info and reactivated.		*** Changed '''InvcLineNo''' from DECIMAL(6,3) to INT. No fractions found in historical data, and current design makes it unnecessary. (If this is wrong, scenario needs to be documented.)
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE TABLE `rstk_rcd_line` (		<section begin=sql /><mysql>CREATE TABLE `rstk_rcd_line` (
Line 18:		Line 18:
	`ID_Item` INT COMMENT "cat_items.ID of item being restocked",		`ID_Item` INT COMMENT "cat_items.ID of item being restocked",
	`isActive` BOOL DEFAULT NULL "FALSE = data in this line is obsolete, so ignore it",		`isActive` BOOL DEFAULT NULL "FALSE = data in this line is obsolete, so ignore it",
	`InvcLineNo` ~~DECIMAL(6,3)~~ COMMENT "line number ~~(use decimals for multiple restock lines as single~~ invoice ~~line)~~",		`InvcLineNo` INT COMMENT "line number on invoice",
	`InvcCatNo` VARCHAR(63) COMMENT "catalog number from invoice",		`InvcCatNo` VARCHAR(63) COMMENT "catalog number from invoice",
	`InvcQtyOrd` INT COMMENT "quantity ordered",		`InvcQtyOrd` INT COMMENT "quantity ordered",

Woozle: isActive field; tidied documentation a bit

2010-11-28T15:50:27Z

isActive field; tidied documentation a bit

← Older revision		Revision as of 15:50, 28 November 2010
Line 1:		Line 1:
	==About==		==About==
	[[category:VbzCart/tables]]		[[category:VbzCart/tables]]
	* '''~~Created~~''': 2008-11-07; split off from [[../rstk_lines]]		* '''Purpose''': Items actually received in a restock shipment
	* ~~Items actually received in~~ a ~~restock shipment~~		* '''Fields''':
			** '''CostActBal''' may be unnecessary anywhere except [[MS Access\|Access]], in which it is difficult for continuous form fields to show cumulatively calculated results rather than a value derived from a specific row -- evaluation of field functions for each row may take place in an order that does not correspond with the row's position on the form.
			* '''History''':
			** '''2008-11-07''' Created for revised restocking process -- split off from [[../rstk_lines]]
			** '''2008-11-09''' +'''InvcDescr''' field, ID_RstkRecd -> '''ID_RstkRcd'''
			** '''2008-11-18''' Changed '''InvcLineNo''' from DECIMAL(3,3) to DECIMAL(6,3)
			*** Do the decimals ever get used? Was this a relic of the old system?
			** '''2008-12-16''' Added '''InvcCatNo''' - can be used to update {{vbzcart/table\|cat_items}}.Supp_CatNum
			** '''2010-11-28''' Added '''isActive''' field to help with data entry process
			*** When invoice text is parsed, all existing lines are deactivated (not deleted), and then updated with new info and reactivated.
	==SQL==		==SQL==
	* '''Notes''':
	** '''CostActBal''' may be unnecessary anywhere except [[MS Access\|Access]], in which it is difficult for bound fields to relate to results which must be calculated in a specific sequence
	* '''History''':
	** '''2008-11-07''' Created for revised restocking process
	** '''2008-11-09''' +InvcDescr field, ID_RstkRecd -> ID_RstkRcd
	** '''2008-11-18''' Changed DECIMAL(3,3) to DECIMAL(6,3)
	** '''2008-12-16''' Added InvcCatNo - can be used to update {{vbzcart/table\|cat_items}}.Supp_CatNum
	<section begin=sql /><mysql>CREATE TABLE `rstk_rcd_line` (		<section begin=sql /><mysql>CREATE TABLE `rstk_rcd_line` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`ID_RstkRcd` INT COMMENT "rstk_recd.ID of received restock shipment this line belongs to",		`ID_RstkRcd` INT COMMENT "rstk_recd.ID of received restock shipment this line belongs to",
	`ID_Item` INT COMMENT "cat_items.ID of item being restocked",		`ID_Item` INT COMMENT "cat_items.ID of item being restocked",
			`isActive` BOOL DEFAULT NULL "FALSE = data in this line is obsolete, so ignore it",
	`InvcLineNo` DECIMAL(6,3) COMMENT "line number (use decimals for multiple restock lines as single invoice line)",		`InvcLineNo` DECIMAL(6,3) COMMENT "line number (use decimals for multiple restock lines as single invoice line)",
	`InvcCatNo` VARCHAR(63) COMMENT "catalog number from invoice",		`InvcCatNo` VARCHAR(63) COMMENT "catalog number from invoice",

Woozle: +InvcCatNo

2008-12-16T19:23:39Z

+InvcCatNo

← Older revision		Revision as of 19:23, 16 December 2008
Line 10:		Line 10:
	** '''2008-11-09''' +InvcDescr field, ID_RstkRecd -> ID_RstkRcd		** '''2008-11-09''' +InvcDescr field, ID_RstkRecd -> ID_RstkRcd
	** '''2008-11-18''' Changed DECIMAL(3,3) to DECIMAL(6,3)		** '''2008-11-18''' Changed DECIMAL(3,3) to DECIMAL(6,3)
			** '''2008-12-16''' Added InvcCatNo - can be used to update {{vbzcart/table\|cat_items}}.Supp_CatNum
	<section begin=sql /><mysql>CREATE TABLE `rstk_rcd_line` (		<section begin=sql /><mysql>CREATE TABLE `rstk_rcd_line` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
Line 15:		Line 16:
	`ID_Item` INT COMMENT "cat_items.ID of item being restocked",		`ID_Item` INT COMMENT "cat_items.ID of item being restocked",
	`InvcLineNo` DECIMAL(6,3) COMMENT "line number (use decimals for multiple restock lines as single invoice line)",		`InvcLineNo` DECIMAL(6,3) COMMENT "line number (use decimals for multiple restock lines as single invoice line)",
			`InvcCatNo` VARCHAR(63) COMMENT "catalog number from invoice",
	`InvcQtyOrd` INT COMMENT "quantity ordered",		`InvcQtyOrd` INT COMMENT "quantity ordered",
	`InvcQtySent` INT COMMENT "quantity shipped to us",		`InvcQtySent` INT COMMENT "quantity shipped to us",

Woozle: /* SQL */ DECIMAL(x,y) is x=total, not x=left-of-decimal

2008-11-18T12:31:37Z

SQL: DECIMAL(x,y) is x=total, not x=left-of-decimal

← Older revision		Revision as of 12:31, 18 November 2008
Line 4:		Line 4:
	* Items actually received in a restock shipment		* Items actually received in a restock shipment
	==SQL==		==SQL==
			* '''Notes''':
			** '''CostActBal''' may be unnecessary anywhere except [[MS Access\|Access]], in which it is difficult for bound fields to relate to results which must be calculated in a specific sequence
			* '''History''':
			** '''2008-11-07''' Created for revised restocking process
			** '''2008-11-09''' +InvcDescr field, ID_RstkRecd -> ID_RstkRcd
			** '''2008-11-18''' Changed DECIMAL(3,3) to DECIMAL(6,3)
	<section begin=sql /><mysql>CREATE TABLE `rstk_rcd_line` (		<section begin=sql /><mysql>CREATE TABLE `rstk_rcd_line` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`ID_RstkRcd` INT COMMENT "rstk_recd.ID of received restock shipment this line belongs to",		`ID_RstkRcd` INT COMMENT "rstk_recd.ID of received restock shipment this line belongs to",
	`ID_Item` INT COMMENT "cat_items.ID of item being restocked",		`ID_Item` INT COMMENT "cat_items.ID of item being restocked",
	`InvcLineNo` DECIMAL(3,3) COMMENT "line number (use decimals for multiple restock lines as single invoice line)",		`InvcLineNo` DECIMAL(6,3) COMMENT "line number (use decimals for multiple restock lines as single invoice line)",
	`InvcQtyOrd` INT COMMENT "quantity ordered",		`InvcQtyOrd` INT COMMENT "quantity ordered",
	`InvcQtySent` INT COMMENT "quantity shipped to us",		`InvcQtySent` INT COMMENT "quantity shipped to us",
Line 19:		Line 25:
	`CostInvTot` DECIMAL(9,2) COMMENT "invoice line total (CostExpPer x InvcQtySent) for this item",		`CostInvTot` DECIMAL(9,2) COMMENT "invoice line total (CostExpPer x InvcQtySent) for this item",
	`CostActTot` DECIMAL(9,2) COMMENT "actual (best) line total as used for reconciling",		`CostActTot` DECIMAL(9,2) COMMENT "actual (best) line total as used for reconciling",
	`CostActBal` DECIMAL(9,2) COMMENT "running total, calculated from CostActTot~~; may be unnecessary anywhere except Access~~",		`CostActBal` DECIMAL(9,2) COMMENT "running total, calculated from CostActTot",
	`Notes` VARCHAR(255) COMMENT "human-entered notes on this line item",		`Notes` VARCHAR(255) COMMENT "human-entered notes on this line item",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)

Woozle: /* SQL */ ID_RstkRecd -> ID_RstkRcd

2008-11-09T13:27:42Z

SQL: ID_RstkRecd -> ID_RstkRcd

← Older revision		Revision as of 13:27, 9 November 2008
Line 6:		Line 6:
	<section begin=sql /><mysql>CREATE TABLE `rstk_rcd_line` (		<section begin=sql /><mysql>CREATE TABLE `rstk_rcd_line` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`~~ID_RstkRecd~~` INT COMMENT "rstk_recd.ID of received restock shipment this line belongs to",		`ID_RstkRcd` INT COMMENT "rstk_recd.ID of received restock shipment this line belongs to",
	`ID_Item` INT COMMENT "cat_items.ID of item being restocked",		`ID_Item` INT COMMENT "cat_items.ID of item being restocked",
	`InvcLineNo` DECIMAL(3,3) COMMENT "line number (use decimals for multiple restock lines as single invoice line)",		`InvcLineNo` DECIMAL(3,3) COMMENT "line number (use decimals for multiple restock lines as single invoice line)",

Woozle: /* SQL */ +InvcDescr field

2008-11-09T13:26:25Z

SQL: +InvcDescr field

← Older revision		Revision as of 13:26, 9 November 2008
Line 6:		Line 6:
	<section begin=sql /><mysql>CREATE TABLE `rstk_rcd_line` (		<section begin=sql /><mysql>CREATE TABLE `rstk_rcd_line` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`ID_RstkRecd` INT COMMENT "rstk_recd.ID of received restock shipment this line belongs to",		`ID_RstkRecd` INT COMMENT "rstk_recd.ID of received restock shipment this line belongs to",
	`ID_Item` INT COMMENT "cat_items.ID of item being restocked",		`ID_Item` INT COMMENT "cat_items.ID of item being restocked",
	`InvcLineNo` DECIMAL(3,3) COMMENT "line number (use decimals for multiple restock lines as single invoice line)",		`InvcLineNo` DECIMAL(3,3) COMMENT "line number (use decimals for multiple restock lines as single invoice line)",
	`InvcQtyOrd` INT COMMENT "quantity ordered",		`InvcQtyOrd` INT COMMENT "quantity ordered",
	`InvcQtySent` INT COMMENT "quantity shipped to us",		`InvcQtySent` INT COMMENT "quantity shipped to us",
			`InvcDescr` VARCHAR(255) COMMENT "description from invoice",
	/* quantities - data from receiving the items */		/* quantities - data from receiving the items */
	`QtyRecd` INT COMMENT "quantity actually received",		`QtyRecd` INT COMMENT "quantity actually received",

Woozle: updated table name

2008-11-08T01:57:09Z

updated table name

← Older revision		Revision as of 01:57, 8 November 2008
Line 4:		Line 4:
	* Items actually received in a restock shipment		* Items actually received in a restock shipment
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE TABLE `~~rstk_recd_line~~` (		<section begin=sql /><mysql>CREATE TABLE `rstk_rcd_line` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`ID_RstkRecd` INT COMMENT "rstk_recd.ID of received restock shipment this line belongs to",		`ID_RstkRecd` INT COMMENT "rstk_recd.ID of received restock shipment this line belongs to",

Woozle: VbzCart/tables/rstk recd line moved to VbzCart/tables/rstk rcd line: reorganized naming for restock tables

2008-11-08T01:56:25Z

VbzCart/tables/rstk recd line moved to VbzCart/tables/rstk rcd line: reorganized naming for restock tables

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

Woozle: draft

2008-11-07T18:16:15Z

draft

New page

==About==
[[category:VbzCart/tables]]
* '''Created''': 2008-11-07; split off from [[../rstk_lines]]
* Items actually received in a restock shipment
==SQL==
<section begin=sql /><mysql>CREATE TABLE `rstk_recd_line` (
`ID` INT NOT NULL AUTO_INCREMENT,
`ID_RstkRecd` INT COMMENT "rstk_recd.ID of received restock shipment this line belongs to",
`ID_Item` INT COMMENT "cat_items.ID of item being restocked",
`InvcLineNo` DECIMAL(3,3) COMMENT "line number (use decimals for multiple restock lines as single invoice line)",
`InvcQtyOrd` INT COMMENT "quantity ordered",
`InvcQtySent` INT COMMENT "quantity shipped to us",
/* quantities - data from receiving the items */
`QtyRecd` INT COMMENT "quantity actually received",
`QtyFiled` INT COMMENT "quantity moved into stock",
/* cost information */
`CostInvPer` DECIMAL(9,2) COMMENT "invoiced per-item cost",
`CostInvTot` DECIMAL(9,2) COMMENT "invoice line total (CostExpPer x InvcQtySent) for this item",
`CostActTot` DECIMAL(9,2) COMMENT "actual (best) line total as used for reconciling",
`CostActBal` DECIMAL(9,2) COMMENT "running total, calculated from CostActTot; may be unnecessary anywhere except Access",
`Notes` VARCHAR(255) COMMENT "human-entered notes on this line item",
PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;</mysql>
<section end=sql />