-- Create Table Statement for 'First Data Rapid Connect Auth Retail Item'
DROP TABLE IF EXISTS `FIRST_DATA_RAPID_CONNECT_AUTH_RETAIL_ITEM`;
CREATE TABLE `FIRST_DATA_RAPID_CONNECT_AUTH_RETAIL_ITEM` (
	ID bigint(20) NOT NULL,
	L3_ITEM_SEQ_NUM varchar,
	L3_ITEM_CODE varchar,
	L3_ITEM_DESC varchar,
	L3_QTY varchar,
	L3_UNIT_OF_MSURE varchar,
	L3_UNIT_COST varchar,
	L3_ITEM_TOT varchar,
	L3_DISCNT_AMT varchar,
	L3_TAX_AMT varchar,
	L3_TAX_RT varchar,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	FIRST_DATA_RAPID_CONNECT_AUTH_RETAIL_TRANSACTION_FK bigint(20),
	FIRST_DATA_RAPID_CONNECT_AUTH_RETAIL_TRANSACTION_FK bigint(20),
	FIRST_DATA_RAPID_CONNECT_AUTH_RETAIL_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;