VbzCart/docs/tables/rstk req item: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (→SQL: no ID field; index only on restock & item IDs) |
imported>Woozle (+QtyCust; tidied documentation) |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
[[category:VbzCart/tables]] | [[category:VbzCart/tables]] | ||
* ''' | * '''Purpose''': Stores requested restock contents by item; planned distribution to customers is in [[../rstk_ord_lines]] | ||
* '''History''': | |||
** '''2008-11-07''' Created for new restock process | |||
** '''2008-12-04''' Added '''QtyCust''' field to make it easier to tell how much immediate revenue a restock is likely to generate | |||
* '''Notes''': | |||
** replaces part of {{vbzcart/table|rstk_lines}} | |||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql>CREATE TABLE `rstk_req_item` ( | <section begin=sql /><mysql>CREATE TABLE `rstk_req_item` ( | ||
| Line 14: | Line 17: | ||
/* quantities - data from creation of restock */ | /* quantities - data from creation of restock */ | ||
`QtyNeed` INT COMMENT "quantity needed, either for an order or to keep stock at desired level", | `QtyNeed` INT COMMENT "quantity needed, either for an order or to keep stock at desired level", | ||
`QtyOrd` INT COMMENT "quantity actually ordered", | `QtyCust` INT COMMENT "quantity needed just to fill customer orders", | ||
`QtyOrd` INT COMMENT "quantity actually ordered from supplier", | |||
`QtyExp` INT COMMENT "quantity actually expected, if supplier doesn't have enough available to fill the order", | `QtyExp` INT COMMENT "quantity actually expected, if supplier doesn't have enough available to fill the order", | ||
`isGone` BOOL COMMENT "YES = item discontinued, no more available (if info from source other than invoice)", | `isGone` BOOL COMMENT "YES = item discontinued, no more available (if info from source other than invoice)", | ||
Revision as of 23:04, 4 December 2008
About
- Purpose: Stores requested restock contents by item; planned distribution to customers is in VbzCart/docs/tables/rstk_ord_lines
- History:
- 2008-11-07 Created for new restock process
- 2008-12-04 Added QtyCust field to make it easier to tell how much immediate revenue a restock is likely to generate
- Notes:
- replaces part of Template:Vbzcart/table
SQL
<section begin=sql /><mysql>CREATE TABLE `rstk_req_item` (
`ID_Restock` INT COMMENT "rstk_req.ID of restock this item belongs to", `ID_Item` INT COMMENT "cat_items.ID of item being restocked", `Descr` VARCHAR(255) DEFAULT NULL COMMENT "Item description as given at time of shopping",
/* timestamps */
`WhenCreated` DATETIME DEFAULT NULL COMMENT "when this line was added", `WhenVoided` DATETIME DEFAULT NULL COMMENT "when this line was voided; not NULL = ignore this line",
/* quantities - data from creation of restock */
`QtyNeed` INT COMMENT "quantity needed, either for an order or to keep stock at desired level", `QtyCust` INT COMMENT "quantity needed just to fill customer orders", `QtyOrd` INT COMMENT "quantity actually ordered from supplier", `QtyExp` INT COMMENT "quantity actually expected, if supplier doesn't have enough available to fill the order", `isGone` BOOL COMMENT "YES = item discontinued, no more available (if info from source other than invoice)",
/* cost information */
`CostExpPer` DECIMAL(9,2) COMMENT "expected per-item cost", `Notes` VARCHAR(255) COMMENT "human-entered notes on this line item", PRIMARY KEY(`ID_Restock`,`ID_Item`) ) ENGINE = MYISAM;</mysql>
<section end=sql />