VbzCart/tables/rstk ord line

From HTYP, the free directory anyone can edit

Jump to: navigation, search

[edit] About

  • Created: 2008-11-07
  • Distribution of restock items to customer orders (planned). This is more of a historical-log-and-search kind of record than something which is actually part of the process. (Should we get rid of it at some point?)
    • Search for every time a particular item was restock-requested, and which orders we were trying to fill
    • Search for every time we tried to restock-request items for a particular order
    • Shows which items in a restock request are for customers; remainder are for stock

[edit] SQL

CREATE TABLE `rstk_ord_line` (
   `ID_RstkReq` INT NOT NULL COMMENT "restock request (rstk_req.ID) which is being used to fulfill the customer's order",
   `ID_Order`   INT NOT NULL COMMENT "customer order (core_orders.ID) which is being fulfilled by this restock request line",
   `ID_OrdLine` INT DEFAULT NULL COMMENT "specific order line (ord_lines.ID) being fulfilled",
   `ID_Item`    INT NOT NULL COMMENT "item which is being requested to fill the customer's order",
   `QtyOrd`     INT NOT NULL COMMENT "Quantity of item allocated to this order",
   `Notes`      VARCHAR(255) COMMENT "human-entered notes on this allocation item",
   PRIMARY KEY(`ID_RstkReq`,`ID_Order`, `ID_Item`)
 )
 ENGINE = MYISAM;

[edit] Notes

  • ID_OrdLine is sort of opportunistic – it isn't always available in legacy data. The functions using this new set of data schemas should always fill it in, however.
Retrieved from "http://htyp.org/VbzCart/tables/rstk_ord_line"
Personal tools