VbzCart/docs/tables/rstk rcd line
Jump to navigation
Jump to search
About
- Purpose: Items actually received in a restock shipment
- Fields:
- CostActBal may be unnecessary anywhere except Access, in which it is difficult for continuous form fields to show cumulatively calculated results rather than a value derived from a specific row -- evaluation of field functions for each row may take place in an order that does not correspond with the row's position on the form.
- History:
- 2008-11-07 Created for revised restocking process -- split off from VbzCart/docs/tables/rstk_lines
- 2008-11-09 +InvcDescr field, ID_RstkRecd -> ID_RstkRcd
- 2008-11-18 Changed InvcLineNo from DECIMAL(3,3) to DECIMAL(6,3)
- Do the decimals ever get used? Was this a relic of the old system?
- 2008-12-16 Added InvcCatNo - can be used to update Template:Vbzcart/table.Supp_CatNum
- 2010-11-28 Added isActive field to help with data entry process
- When invoice text is parsed, all existing lines are deactivated (not deleted), and then updated with new info and reactivated.
SQL
<section begin=sql /><mysql>CREATE TABLE `rstk_rcd_line` (
`ID` INT NOT NULL AUTO_INCREMENT, `ID_RstkRcd` INT COMMENT "rstk_recd.ID of received restock shipment this line belongs to", `ID_Item` INT COMMENT "cat_items.ID of item being restocked", `isActive` BOOL DEFAULT NULL "FALSE = data in this line is obsolete, so ignore it", `InvcLineNo` DECIMAL(6,3) COMMENT "line number (use decimals for multiple restock lines as single invoice line)", `InvcCatNo` VARCHAR(63) COMMENT "catalog number from invoice", `InvcQtyOrd` INT COMMENT "quantity ordered", `InvcQtySent` INT COMMENT "quantity shipped to us", `InvcDescr` VARCHAR(255) COMMENT "description from invoice",
/* quantities - data from receiving the items */
`QtyRecd` INT COMMENT "quantity actually received", `QtyFiled` INT COMMENT "quantity moved into stock",
/* cost information */
`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", `Notes` VARCHAR(255) COMMENT "human-entered notes on this line item", PRIMARY KEY(`ID`) ) ENGINE = MYISAM;</mysql>
<section end=sql />