-- Create Table Statement for 'Elavon4 Global Capture Retail Transaction'
DROP TABLE IF EXISTS `ELAVON4_GLOBAL_CAPTURE_RETAIL_TRANSACTION`;
CREATE TABLE `ELAVON4_GLOBAL_CAPTURE_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	APPLICATION_REQUEST_CRYPTOGRAM varchar,
	APPLICATION_EXPIRATION_DATE varchar,
	APPLICATION_INTERCHANGE_PROFILE varchar,
	APPLICATION_TRANSACTION_COUNTER varchar,
	APPROVAL_CODE varchar,
	AUTHORIZATION_SOURCE varchar,
	AUTHORIZATION_CURRENCY_CODE varchar,
	TRANSACTION_DATE varchar,
	TRANSACTION_TIME varchar,
	AUTHORIZED_AMOUNT varchar,
	AVS_RESPONSE_CODE varchar,
	CARD_SEQUENCE_NUMBER varchar,
	CAT_CODE varchar,
	CARDHOLDER_ID_METHOD varchar,
	CVM_RESULTS varchar,
	CASH_BACK_AMOUNT varchar,
	CASH_BACK_AMOUNT_EMV varchar,
	CHIP_CONDITION_CODE varchar,
	CRYPTOGRAM_INFORMATION_DATA varchar,
	CRYPTOGRAM_TRANSACTION_TYPE varchar,
	CVV2_RESULTS_CODE varchar,
	ECI_OR_MOTO_INDICATOR varchar,
	NUMBER_OF_INSTALLMENTS varchar,
	ISSUER_APPLICATION_DATA varchar,
	MERCHANT_DBA_NAME varchar,
	POS_TERMINAL_CAPABILITY varchar,
	POS_ENTRY_MODE varchar,
	REFERENCE_CODE varchar,
	AUTHORIZATION_RESPONSE_CODE varchar,
	TRANSACTION_AMOUNT varchar,
	TERMINAL_CAPABILITIES_PROFILE varchar,
	TERMINAL_COUNTRY_CODE varchar,
	TERMINAL_TRANSMISSION_DATE varchar,
	TERMINAL_TYPE varchar,
	TERMINAL_VERIFICATION_RESULTS varchar,
	AUTHORIZED_AMOUNT varchar,
	TRANSACTION_TYPE_IDENTIFIER varchar,
	UCAF_COLLECTION_INDICATOR varchar,
	UNPREDICTABLE_NUMBER varchar,
	ACI varchar,
	TRANSACTION_IDENTIFIER varchar,
	VALIDATION_CODE varchar,
	CURRENCY_INDICATOR_CODE varchar,
	TRANSACTION_CURRENCY_CODE varchar,
	COUNTRY_CODE varchar,
	TRANSACTION_REFERENCE_ROC varchar,
	STATE_PROVINCE_CODE varchar,
	MCC varchar,
	POINT_OF_SALE_NAME varchar,
	DE22_POINT_OF_SERVICE_DATA_CODE varchar,
	PRODUCT_ID varchar,
	BANKNET_REFERENCE_NUMBER varchar,
	BANKNET_DATE varchar,
	SYSTEM_TRACE_AUDIT_NUMBER varchar,
	TRACK_DATA_CONDITION_CODE varchar,
	NETWORK_REFERENCE_ID varchar,
	AUTHORIZATION_DATE varchar,
	INTERFACE_DEVICE_SERIAL_NO varchar,
	TRANSACTION_CATEGORY_CODE varchar,
	DEDICATED_FILE_NAME varchar,
	TERMINAL_APPLICATION_VERSION_NO varchar,
	TRANSACTION_SEQUENCE_COUNTER varchar,
	ISSUER_SCRIPT_RESULTS_PART1 varchar,
	ISSUER_SCRIPT_RESULTS_PART2 varchar,
	DEVICE_TYPE varchar,
	FORM_FACTOR varchar,
	TYPE_OF_INSTALLMENT varchar,
	TOTAL_INSTALLMENT_AMOUNT varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	ELAVON4_GLOBAL_RETAIL_FILE_BATCH_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	PURCHASE_ID_FORMAT varchar,
	PURCHASE_IDENTIFIER varchar,
	SALES_TAX_AMOUNT varchar,
	SALES_TAX_INDICATOR varchar,
	TERMINAL_ID varchar,
	CARD_TYPE_IDENTIFIER varchar,
	DEBIT_NETWORK_ID varchar,
	DEBIT_SETTLEMENT_DATE varchar,
	SPEND_QUALIFIED_INDICATOR varchar,
	RETRIEVAL_REFERENCE_NUMBER varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	ELAVON4_GLOBAL_RETAIL_FILE_BATCH_FK bigint(20),
	ELAVON4_GLOBAL_RETAIL_FILE_BATCH_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;