VbzCart/tables/rstk lines

About
This is the older version which includes data about items received and customer-order distribution. To be replaced by ../rstk_lines_new.

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;