-- Create Table Statement for 'First Data LP Auth Retail Transaction'
DROP TABLE IF EXISTS `FIRST_DATA_LP_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `FIRST_DATA_LP_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CONFIGFILE varchar,
	ORDERTYPE varchar,
	TRANSACTIONORIGIN varchar,
	OID varchar,
	CHARGETOTAL varchar,
	CARDEXPMONTH varchar,
	CARDEXPYEAR varchar,
	CVMINDICATOR varchar,
	TERMINALTYPE varchar,
	NAME varchar,
	COMPANY varchar,
	ADDRESS1 varchar,
	ADDRNUM varchar,
	CITY varchar,
	STATE varchar,
	ZIP varchar,
	PHONE varchar,
	USERID varchar,
	TDATE varchar,
	RAVS varchar,
	RERROR varchar,
	RAPPROVED varchar,
	RCODE varchar,
	RMESSAGE varchar,
	RTIME varchar,
	RREF varchar,
	RTDATE varchar,
	RAUTHRESPONSE varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;