VbzCart/tables/rstk lines

From HTYP, the free directory anyone can edit

[edit] 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.

[edit] SQL

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;

[edit] Notes

• if isGone is TRUE, then ideally:
  • don't carry items forward into next restock
  • mark item as discontinued in catalog