Difference between revisions of "VbzCart/tables/rstk rcd line"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
(+InvcCatNo)
(isActive field; tidied documentation a bit)
Line 1: Line 1:
 
==About==
 
==About==
 
[[category:VbzCart/tables]]
 
[[category:VbzCart/tables]]
* '''Created''': 2008-11-07; split off from [[../rstk_lines]]
+
* '''Purpose''': Items actually received in a restock shipment
* Items actually received in a restock shipment
+
* '''Fields''':
 +
** '''CostActBal''' may be unnecessary anywhere except [[MS Access|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 [[../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 {{vbzcart/table|cat_items}}.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==
 
==SQL==
* '''Notes''':
 
** '''CostActBal''' may be unnecessary anywhere except [[MS Access|Access]], in which it is difficult for bound fields to relate to results which must be calculated in a specific sequence
 
* '''History''':
 
** '''2008-11-07''' Created for revised restocking process
 
** '''2008-11-09''' +InvcDescr field, ID_RstkRecd -> ID_RstkRcd
 
** '''2008-11-18''' Changed DECIMAL(3,3) to DECIMAL(6,3)
 
** '''2008-12-16''' Added InvcCatNo - can be used to update {{vbzcart/table|cat_items}}.Supp_CatNum
 
 
<section begin=sql /><mysql>CREATE TABLE `rstk_rcd_line` (
 
<section begin=sql /><mysql>CREATE TABLE `rstk_rcd_line` (
 
   `ID`          INT NOT NULL AUTO_INCREMENT,
 
   `ID`          INT NOT NULL AUTO_INCREMENT,
 
   `ID_RstkRcd`  INT COMMENT "rstk_recd.ID of received restock shipment this line belongs to",
 
   `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",
 
   `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)",
 
   `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",
 
   `InvcCatNo`  VARCHAR(63) COMMENT "catalog number from invoice",

Revision as of 15:50, 28 November 2010

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/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
  1. REDIRECT Template:l/vc/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

<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>