invoice_and_item_number	STRING		Concatenated invoice and line number associated with the liquor order. This provides a unique identifier for the individual liquor products included in the store order.	
date			DATE		Date of order	
store_number		STRING		Unique number assigned to the store who ordered the liquor.	
store_name		STRING		Name of store who ordered the liquor.	
address			STRING		Address of store who ordered the liquor.	
city			STRING		City where the store who ordered the liquor is located	
zip_code		STRING		Zip code where the store who ordered the liquor is located	
store_location		GEOGRAPHY	Location of store who ordered the liquor. The Address, City, State and Zip Code are geocoded to provide geographic coordinates. Accuracy of geocoding is dependent on how well the address is interpreted and the completeness of the reference data used.	
county_number		STRING		Iowa county number for the county where store who ordered the liquor is located	
county			STRING		County where the store who ordered the liquor is located	
category		STRING		Category code associated with the liquor ordered	
category_name		STRING		Category of the liquor ordered.	
vendor_number		STRING		The vendor number of the company for the brand of liquor ordered	
vendor_name		STRING		The vendor name of the company for the brand of liquor ordered	
item_number		STRING		Item number for the individual liquor product ordered.	
item_description	STRING		Description of the individual liquor product ordered.	
pack			INTEGER		The number of bottles in a case for the liquor ordered	
bottle_volume_ml	INTEGER		Volume of each liquor bottle ordered in milliliters.	
state_bottle_cost	FLOAT		The amount that Alcoholic Beverages Division paid for each bottle of liquor ordered	
state_bottle_retail	FLOAT		The amount the store paid for each bottle of liquor ordered	
bottles_sold		INTEGER		The number of bottles of liquor ordered by the store	
sale_dollars		FLOAT		Total cost of liquor order (number of bottles multiplied by the state bottle retail)	
volume_sold_liters	FLOAT		Total volume of liquor ordered in liters. (i.e. (Bottle Volume (ml) x Bottles Sold)/1,000)"	
volume_sold_gallons	FLOAT		Total volume of liquor ordered in gallons. (i.e. (Bottle Volume (ml) x Bottles Sold)/3785.411784)"