VbzCart/tables/rstk lines
Jump to navigation
Jump to search
About
This is the older version which includes data about items received and customer-order distribution. To be replaced by VbzCart/tables/rstk_lines_new.
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>
Notes
- if isGone is TRUE, then ideally:
- don't carry items forward into next restock
- mark item as discontinued in catalog