This file contains The Lorenz Corporation's catalog of all items currently in print. The information is provided in an Access database or an Excel file. The items in the database are in the following order:

ProductType	Status	ITEMID	ITEMNAME	Subtitle	Division	Artists	Voicing	Options	Seasons	Series	Level	Price	MinimumQty	ITEMBARCODE	Blurb	ReleaseDate

"ProductType"	The category of the product (Octavo, Cantata, Band Method, etc.)
"Status"	Contains "N" for new products; "B" for Best Sellers; "A" for Archive copies (print on demand)
"ITEMID"	The catalog number that The Lorenz Corporation assigns.
"ITEMNAME"	The title of the piece, or a description of the item.
"Subtitle"	The subtitle of the piece, if applicable.
"Division"	The company that published the piece. (see below).
"Artists "	These lines contain the last names of the people who
	   produced the work. Usually the author(s) or author-arranger
	   team. "Various" indicates that the work is a compilation of 
	   the works of many artists.
"Voicing"	The voicing of the piece.
"Options"	The performance options.
"Seasons"	The season when this might be applicable (if piece is seasonal).
"Series"	The series to which the piece belongs
"Level"	The level of difficulty (if known and applicable).
"Price"	The current retail price.
"MinimumQty"	The minimum quantity required for an order.
"ITEMBARCODE"	The UPC number or EAN13 number of the product (including check digit)
"Blurb"	Catalog Description of the piece (if available)
"ReleaseDate"	The date / season the item was first introduced. 
		Fall/Christmas items use Sept. 1. Spring/Easter items use March 1.
"AvailableDate"	The date that a particular product is scheduled to be available for
		ordering/shipping without back order.
 


The contents (the songs in each product) are in a separate table in the Access container. Link by code number.

Division	Division Name
AG	AGEHR-Handbell Musicians of America	
AUG	Augsburg Fortress Publishers	
CG	Choristers Guild	
CIM	Canadian International Music	
CMP	Candela Music Press
DIST	Distribution Company		
EX	Exaltation Publications	
HMP	Heritage Music Press
KH	Kirkland House
LEP	Lorenz Educational Press
LM	Latham Music	
LP	Laurel Press	
LPC	Lorenz Publishing Company	
MAD	Madison Street Products	
MIL	Milliken
MM	Monarch Music	
PPC	Purifoy Publishing Company	
RACE	Royal Amer. Conservatory Exams
RD	Roger Dean Publishing Company	
RM	Radiant Music	
SB	Santa Barbara Music Publishing
SF	SoundForth
SMP	Sacred Music Press	
SP	Sonshine Productions	
SUB	Subscription
TL	Teaching and Learning Company
TMI	Triune Music	
TWINS	Twin Sisters Productions, Inc.
UMP	Unity Music Press	
VAR	Various



Season	DESCRIPTION
TLCUSAGEEMPHASISID	DESCRIPTION
A	Advent
AC	Arts and Crafts
ALL	All Saints' Day
ASC	Ascension
B	Baptism
C	Christmas
CC	Cross-Curricular
CF	Confirmation
CK	Christ the King
CL	Christian Life
CM	Classroom Management
CON	Concert
CTS	Critical Thinking Skills
DED	Dedications
DIS	Discipleship
E	Eastertide
EP	Epiphany
EV	Evangelism
F	Family Days
FES	Festival Sundays
FNL	Funeral
G	General
GD	Graduation
GF	Good Friday
GVT	Government Holiday
H	Hanukkah
HC	Holy Communion
HW	Holy Week
HWN	Halloween
HYM	Hymn-Based Collection
KW	Kwanzaa
L	Lent
LA	Language Arts
M	Missions
MA	Math
MC	Multicultural
MEM	Memorial Services
MM	Movement and Music
MST	Masterworks and Transcriptions
MT	Maundy Thursday
N	Novelty
NY	New Year
P	Pentecost
PA	Patriotic
PR	Pastoral Retirement
PS	Palm/Palm-Passion Sunday
R	Reformation
RE	Responsibility Education / Values
S	Spiritual
SC	Secular Christmas
SCI	Science
SS	Social Studies
ST	Stewardship
T	Thanksgiving
TB	Team Building
TR	Transfiguration
TS	Trinity Sunday
W	Wedding
	



