-- Create Table Statement for 'Vantiv Lowell Auth Retail Transaction'
DROP TABLE IF EXISTS `VANTIV_LOWELL_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `VANTIV_LOWELL_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	TRANSACTION_TYPE varchar,
	MERCHANT_ID varchar,
	USER varchar,
	REQUEST_ID varchar,
	REPORT_GROUP varchar,
	CUSTOMER_ID varchar,
	ORDER_ID varchar,
	AMOUNT int(11),
	ORDER_SOURCE varchar,
	NAME varchar,
	ADDRESS_LINE1 varchar,
	CITY varchar,
	STATE varchar,
	ZIP varchar,
	EMAIL varchar,
	PHONE varchar,
	TYPE varchar,
	BIN varchar,
	LITLE_TOKEN varchar,
	CAPABILITY varchar,
	ENTRY_MODE varchar,
	CARDHOLDER_ID varchar,
	TOKEN_RESPONSE_CODE varchar,
	TOKEN_MESSAGE varchar,
	LITLE_TXN_ID varchar,
	VOID_LITLE_TXN_ID varchar,
	RESPONSE varchar,
	RESPONSE_TIME varchar,
	POST_DATE varchar,
	MESSAGE varchar,
	AUTH_CODE varchar,
	AVS_RESULT varchar,
	CARD_VALIDATION_RESULT varchar,
	AUTHENTICATION_RESULT varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	TOTAL_HEALTHCARE_AMOUNT int(11),
	RX_AMOUNT int(11),
	VISION_AMOUNT int(11),
	CLINIC_OTHER_AMOUNT int(11),
	DENTAL_AMOUNT int(11),
	ADVANCED_AVS_RESULT varchar,
	PAYPAGE_REGISTRATION_ID varchar,
	TERMINAL_ID varchar,
	NETWORK_TRANSACTION_ID varchar,
	ORIGINAL_NETWORK_TRANSACTION_ID varchar,
	PROCESSING_TYPE varchar,
	NETWORK_TRANSACTION_ID varchar,
	ORIGINAL_NETWORK_TRANSACTION_ID varchar,
	PROCESSING_TYPE varchar,
	NETWORK_TRANSACTION_ID varchar,
	ORIGINAL_NETWORK_TRANSACTION_ID varchar,
	PROCESSING_TYPE varchar,
	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;