-- Create Table Statement for 'Elavon 4 Capture Retail Transaction Item'
DROP TABLE IF EXISTS `ELAVON4_CAPTURE_RETAIL_TRANSACTION_ITEM`;
CREATE TABLE `ELAVON4_CAPTURE_RETAIL_TRANSACTION_ITEM` (
	ID bigint(20) NOT NULL,
	ITEM_DESCRIPTION varchar,
	PRODUCT_CODE varchar,
	ITEM_COMMODITY_CODE varchar,
	QUANTITY varchar,
	UNIT_OF_MEASURE varchar,
	UNIT_COST varchar,
	DISCOUNT_PER_LINE_ITEM varchar,
	TAX_RATE varchar,
	TAX_AMOUNT varchar,
	LINE_ITEM_TOTAL varchar,
	EXTENDED_ITEM_AMOUNT varchar,
	DEBIT_CREDIT_INDICATOR varchar,
	NET_GROSS_INDICATOR varchar,
	DISCOUNT_INDICATOR varchar,
	TAX_TYPE_APPLIED varchar,
	ALTERNATE_TAX_IDENTIFIER varchar,
	ELAVON4_CAPTURE_RETAIL_TRANSACTION_FK bigint(20),
	MERCHANT_ACCOUNT_CODE int(11),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;