-- Create Table Statement for 'FirstData Nashville Retail Item'
DROP TABLE IF EXISTS `FIRST_DATA_NASHVILLE_RETAIL_ITEM`;
CREATE TABLE `FIRST_DATA_NASHVILLE_RETAIL_ITEM` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	DESCRIPTION varchar,
	DEBIT_CREDIT_IND varchar,
	TAX_COLLECTED_IND varchar,
	QUANTITY varchar,
	PRODUCT_CODE varchar,
	UNIT_COST varchar,
	EXTENDED_AMOUNT varchar,
	DISCOUNT_AMOUNT varchar,
	LOCAL_TAX_AMOUNT varchar,
	UNIT_COST_IND varchar,
	EXTENDED_AMOUNT_IND varchar,
	DISCOUNT_AMOUNT_IND varchar,
	LOCAL_TAX_AMOUNT_IND varchar,
	UNIT_OF_MEASURE varchar,
	COMMODITY_CODE varchar,
	DISCOUNT_RATE varchar,
	FIRST_DATA_NASHVILLE_CAPTURE_RETAIL_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;