-- Create Table Statement for 'Moneris Auth Retail Transaction'
DROP TABLE IF EXISTS `MONERIS_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `MONERIS_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	STORE_ID varchar,
	REQUEST_TYPE varchar,
	ORDER_ID varchar,
	AMOUNT varchar,
	COMP_AMOUNT varchar,
	ORIGINAL_TXN_NUMBER varchar,
	AUTH_CODE varchar,
	CRYPT_TYPE varchar,
	AVS_STREET_NUMBER varchar,
	AVS_STREET_NAME varchar,
	AVS_ZIPCODE varchar,
	CVD_INDICATOR varchar,
	DYNAMIC_DESCRIPTOR varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CUST_ID varchar,
	RECEIPT_ID varchar,
	REFERENCE_NUM varchar,
	RESPONSE_CODE varchar,
	ISO varchar,
	TRANS_TIME varchar,
	TRANS_DATE varchar,
	TRANS_TYPE varchar,
	COMPLETE varchar,
	MESSAGE varchar,
	TRANS_AMOUNT varchar,
	CARD_TYPE varchar,
	TRANS_ID varchar,
	TIMED_OUT varchar,
	AVS_RESULT_CODE varchar,
	CVD_RESULT_CODE varchar,
	CAVV_RESULT_CODE varchar,
	CORPORATE_CARD varchar,
	IS_VISA_DEBIT varchar,
	POS_CODE varchar,
	ECR_NUMBER varchar,
	MONERIS_RETAIL_FILE_BATCH_FK bigint(20),
	ITD_RESPONSE varchar,
	ISSUER_ID_REQUEST varchar,
	PAYMENT_INDICATOR varchar,
	PAYMENT_INFORMATION varchar,
	ISSUER_ID_RESPONSE varchar,
	MONERIS_RETAIL_FILE_BATCH_FK bigint(20),
	ISSUER_ID_REQUEST varchar,
	PAYMENT_INDICATOR varchar,
	PAYMENT_INFORMATION varchar,
	ISSUER_ID_RESPONSE varchar,
	MONERIS_RETAIL_FILE_BATCH_FK bigint(20),
	ISSUER_ID_REQUEST varchar,
	PAYMENT_INDICATOR varchar,
	PAYMENT_INFORMATION varchar,
	ISSUER_ID_RESPONSE 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;