THE GEIGER DATABASE
DATA TABLE STRUCTURES
DATABASE JGDBFULL TABLES
TABLE DETAIL: MMTFJDISTRIBUTIONREC
The structure of this table was designed to manage inventory and shipping of the Journal of the Taliesin Fellows (JTF) to retail outlets, university libraries, organizations, and individuals.
Note: The column labels shown within the table structures are historical references only, and do not reflect the definitions used within the version of the database being served through the website.
TABLE NOTES
Table MMTFJDISTRIBUTIONREC contains 1,472 rows arranged in 13 columns.
The table records number of copies sold or otherwise distributed, date, and miscellaneous notes related to subscription fulfillment for Issues #1 through #26 of the JTF, from April 6, 1992, through September 30, 2002.
Records from this table are displayed in a subform of Table MMTFJPUBCLICATIONREC. The table relies on an uncertain lookup relationship with a column in another table, noted below.
Database Search
The content of this table is not accessible through the version of the database available on the website.
ORIGINAL DATAEASE FORM SCREEN
Document: DataEase table definition printout (PDF)
COLUMN LABELS
Column: [ISSUE #] records an issue number of the JTF; intended lookup on a row value of Column [THRU ISSUE #] of a table name that does not exist in the surviving copies of the database; possibly an error for column of that name found of Table SUB LINE ITEMS.
Column: [REC#] records a unique row identifier number for each row in this table.
Column: [DATE] records the date of the row entry in a month/day/year format.
Column: [2C] records a number of unknown purpose.
Column: [QTYDIST] records a number indicating a quantity of JTF copies shipped for a purpose, individual, or retail outlet.
Column: [SINGLE ISSUE SOLD] records a number indicating a single JTF issue sold to an individual.
Column: [QTYSOLD] records a number indicating a quantity of JTF copies sold through an individual or retail outlet.
Column: [QTYPR] records a number indicating a quantity of JTF copies given for public relations purposes.
Column: [QTYPR2] records a number indicating a quantity of JTF copies given for secondary public relations purposes (e.g. contributors, Taliesin Fellows, or editorial staff).
Column: [QTYDMG] records a number indicating JTF copies written off as damaged.
Column: [COUNT] records a number indicating a count for the column [DISTTO].
Column: [DISTTO] records a description of purpose, or the name of a contributor, Taliesin Fellow, or retail outlet.
Column: [$RET] records a number indicating a value for JTF copies returned.
RELATED QUERY PROCEDURES
This table is not referenced directly in any of the query procedures devised by Geiger.