VbzCart/docs/tables/ctg sources: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | tables
Jump to navigation Jump to search
imported>Woozle
(rescued brief explanation from Tables page before deleting it there)
imported>Woozle
(battery low, saving edits)
Line 1: Line 1:
==About==
==About==
* '''Used by''': {{vbzcart/query|qryCtg_Sources_active}}
* '''Used by''': {{l/vbzcart/query|qryCtg_Sources_active}}
* '''Fields''':
==Fields==
** '''ID_Supercede''': Supplier Catalogs].ID of catalog which supercedes this one; NULL = this one is current
* '''ID_Supercede''': Supplier Catalogs].ID of catalog which supercedes this one; NULL = this one is current
** '''isCloseOut''':  
** It can be set to point to the current record if the superceding catalog has not been entered or is not known.
*** TRUE = this catalog is a list of discontinued items ''no longer in print'' (closeouts)
* '''isCloseOut''':  
*** FALSE = normal catalog; items will be marked as "in print"
** TRUE = this catalog is a list of discontinued items ''no longer in print'' (closeouts)
* '''Notes''':
** FALSE = normal catalog; items will be marked as "in print"
** A "source" is usually a printed catalog from a supplier, though it can also be the manufacturer's web site on a particular date.
* '''WhenUpdated''': When this record was last saved. This is actually significant for catalog building because it is copied to LCItem.Supp_LastUpdate. Presumably any time the record is edited, the editor would not leave the ID_Supercede field NULL if the catalog was not still current.
** To discontinue a supplier, set ID_Supercede=ID for all active sources; the catalog will then show only current stock as avaialble.
==Notes==
* A "source" is usually a printed catalog from a supplier, though it can also be the manufacturer's web site on a particular date.
* To discontinue a supplier, set ID_Supercede=ID for all active sources; the catalog will then show only current stock as available.
==SQL==
==SQL==
<mysql>CREATE TABLE `ctg_sources` (
<mysql>CREATE TABLE `ctg_sources` (

Revision as of 16:07, 18 June 2017

About

Fields

  • ID_Supercede: Supplier Catalogs].ID of catalog which supercedes this one; NULL = this one is current
    • It can be set to point to the current record if the superceding catalog has not been entered or is not known.
  • isCloseOut:
    • TRUE = this catalog is a list of discontinued items no longer in print (closeouts)
    • FALSE = normal catalog; items will be marked as "in print"
  • WhenUpdated: When this record was last saved. This is actually significant for catalog building because it is copied to LCItem.Supp_LastUpdate. Presumably any time the record is edited, the editor would not leave the ID_Supercede field NULL if the catalog was not still current.

Notes

  • A "source" is usually a printed catalog from a supplier, though it can also be the manufacturer's web site on a particular date.
  • To discontinue a supplier, set ID_Supercede=ID for all active sources; the catalog will then show only current stock as available.

SQL

<mysql>CREATE TABLE `ctg_sources` ( 

 ID          INT NOT NULL AUTO_INCREMENT,
 Name        VARCHAR(63) NOT NULL COMMENT "name of source",
 Abbr        VARCHAR(15) NOT NULL COMMENT "abbreviation, for drop-down lists",
 ID_Supplier INT NOT NULL COMMENT "Suppliers.ID - supplier for this source",
 DateAvail   DATETIME DEFAULT NULL COMMENT "earliest date on which this source is valid",
 ID_Supercede INT DEFAULT NULL COMMENT "[Supplier Catalogs].ID of catalog which supercedes this one, if any",
 isCloseOut  BOOL DEFAULT FALSE COMMENT "is this a close-out catalog?",
 PRIMARY KEY(`ID`)

) ENGINE = MYISAM;</mysql>

Retrieved from "https://wooz.dev/mw/index.php?title=VbzCart/docs/tables/ctg_sources&oldid=5777"