-- Create Table Statement for 'First Data Compass Retail Item'
DROP TABLE IF EXISTS `FIRST_DATA_COMPASS_RETAIL_ITEM`;
CREATE TABLE `FIRST_DATA_COMPASS_RETAIL_ITEM` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	FIRST_DATA_COMPASS_CAPTURE_RETAIL_TRANSACTION_FK bigint(20),
	TAX_AMOUNT varchar,
	ITEM_COMMODITY_CODE varchar,
	PRODUCT_CODE varchar,
	DESCRIPTION varchar,
	DISCOUNT_RATE varchar,
	UNIT_OF_MEASURE varchar,
	UNIT_COST varchar,
	QUANTITY varchar,
	TAX_RATE varchar,
	LINE_ITEM_TOTAL varchar,
	DISCOUNT_AMOUNT varchar,
	GROSS_NET_INDICATOR varchar,
	TAX_TYPE_APPLIED varchar,
	DISCOUNT_INDICATOR varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;