VbzCart/tables/rstk req item

About

• Created: 2008-11-07
• To replace old VbzCart/tables/rstk_lines after data is migrated
• Records requested restock contents by item; planned distribution to customers is in VbzCart/tables/rstk_ord_lines

SQL

<mysql>CREATE TABLE `rstk_req_item` (

  `ID`          INT NOT NULL AUTO_INCREMENT,
  `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",
  `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 (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`)
)
ENGINE = MYISAM;</mysql>