VbzCart/tables/ord pkg lines

From HTYP, the free directory anyone can edit

[edit] About

• Purpose: What's in an order package (ord_pkgs)
• Refers to: ord_pkgs (parent), ord_lines, cat_items
• Fields:
  • QtyFromStock may be an obsolete field, as all package quantities should now come from stock.

[edit] SQL

CREATE TABLE `ord_pkg_lines` (
  `ID`           INT NOT NULL AUTO_INCREMENT,
  `ID_Pkg`       INT NOT NULL COMMENT "ord_pkgs.ID",
  `ID_OrdLine`   INT COMMENT "ord_lines.ID",
  `ID_Item`      INT NOT NULL COMMENT "cat_items.ID",
  `QtyShipped`   INT COMMENT "quantity shipped/charged in this package",
  `QtyExtra`     INT COMMENT "quantity tossed in as freebies in this pkg",
  `QtyKilled`    INT COMMENT "quantity fulfilled by being cancelled",
  `QtyNotAvail`  INT COMMENT "quantity which can't be filled",
  `QtyFromStock` INT COMMENT "quantity which was moved from stock",
  `Notes`        VARCHAR(255),
  PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;