-- Create Table Statement for 'NMI Auth Retail Transaction'
DROP TABLE IF EXISTS `NMI_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `NMI_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	TYPE varchar,
	AMOUNT varchar,
	PROCESSOR_ID varchar,
	DESCRIPTOR varchar,
	DESCRIPTOR_PHONE varchar,
	ORDERDESCRIPTION varchar,
	ORDERID varchar,
	TAX varchar,
	SHIPPING varchar,
	PONUMBER varchar,
	FIRSTNAME varchar,
	LASTNAME varchar,
	ADDRESS1 varchar,
	CITY varchar,
	STATE varchar,
	ZIP varchar,
	COUNTRY varchar,
	PHONE varchar,
	EMAIL varchar,
	SHIPPING_FIRSTNAME varchar,
	SHIPPING_LASTNAME varchar,
	SHIPPING_ADDRESS1 varchar,
	SHIPPING_CITY varchar,
	SHIPPING_STATE varchar,
	SHIPPING_ZIP varchar,
	SHIPPING_COUNTRY varchar,
	TRANSACTIONID varchar,
	RESPONSE varchar,
	RESPONSETEXT varchar,
	AUTHCODE varchar,
	AVSRESPONSE varchar,
	CVVRESPONSE varchar,
	RESPONSECODE varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_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;