Woozle: extracted from VbzCart/tables

2008-11-07T17:45:30Z

extracted from VbzCart/tables

New page

==About==
[[category:VbzCart/tables]]This is the older version which includes data about items received and customer-order distribution. To be replaced by [[../rstk_lines_new]].
==SQL==
<section begin=sql /><mysql>CREATE TABLE `rstk_lines` (
`ID` INT NOT NULL AUTO_INCREMENT,
`ID_Restock` INT COMMENT "core_restocks.ID of restock this item belongs to",
`ID_Item` INT COMMENT "cat_items.ID of item being restocked",
`ID_Order` INT COMMENT "core_orders.ID of order which generated this line",
`Descr` VARCHAR(255) DEFAULT NULL COMMENT "Item description as given at time of shopping",
/* timestamps */
`WhenCreated` DATETIME DEFAULT NULL "when this line was added",
`WhenVoided` DATETIME DEFAULT NULL "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",
`QtyOrd` INT COMMENT "quantity actually ordered",
`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", /* data from invoice */
`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 */
`CostExpPer` DECIMAL(9,2) COMMENT "expected per-item cost",
`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 />
==Notes==
* if '''isGone''' is TRUE, then ideally:
** don't carry items forward into next restock
** mark item as discontinued in catalog

VbzCart/tables/rstk lines - Revision history

Woozle: extracted from VbzCart/tables