-- Create Table Statement for 'TSYS Retail Item'
DROP TABLE IF EXISTS `TSYS_RETAIL_ITEM`;
CREATE TABLE `TSYS_RETAIL_ITEM` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	LINE_ITEM_CARD_TYPE varchar,
	ITEM_COMMODITY_CODE varchar,
	ITEM_DESCRIPTION varchar,
	PRODUCT_CODE varchar,
	QUANTITY varchar,
	UNIT_MEASURE varchar,
	UNIT_COST varchar,
	TAX_AMOUNT varchar,
	TAX_RATE varchar,
	DISCOUNT_AMOUNT varchar,
	DISCOUNT_RATE varchar,
	LINE_ITEM_TOTAL varchar,
	ALTERNATIVE_TAX_IDENTIFIER varchar,
	TAX_TYPE_APPLIED varchar,
	CREDIT_INDICATOR varchar,
	TSYS_CAPTURE_RETAIL_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;