-- Create Table Statement for 'TSYS Auth Retail Transaction'
DROP TABLE IF EXISTS `TSYS_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `TSYS_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	RECORD_FORMAT varchar,
	ACQUIRER_BIN varchar,
	MERCHANT_NUMBER varchar,
	STORE_NUMBER varchar,
	TERMINAL_NUMBER varchar,
	INDUSTRY_CODE varchar,
	CITY_CODE varchar,
	TIME_ZONE_DIFFERENTIAL varchar,
	MERCHANT_CATEGORY_CODE varchar,
	REQUESTED_ACI varchar,
	TRANSACTION_SEQUENCE_NUMBER varchar,
	TRANSACTION_CODE varchar,
	CARDHOLDER_ID_CODE varchar,
	ACCOUNT_DATA_SOURCE varchar,
	TRANSACTION_AMOUNT int(11),
	MARKET_SPECIFIC_DATA varchar,
	CARD_ACCEPTOR_DATA varchar,
	REVERSAL_TRANSACTION_ID varchar,
	CANCEL_DATA1 varchar,
	CANCEL_DATA2 varchar,
	SHARING_GROUPS varchar,
	MERCHANT_SETTLEMENT_AGENT_NUMBER varchar,
	AGENT_BANK_NUMBER varchar,
	AGENT_CHAIN_NUMBER varchar,
	BATCH_NUMBER varchar,
	RETURNED_ACI varchar,
	AUTHORIZATION_SOURCE_CODE varchar,
	RESPONSE_CODE varchar,
	APPROVAL_CODE varchar,
	LOCAL_TRANSACTION_DATE varchar,
	LOCAL_TRANSACTION_TIME varchar,
	AUTHORIZATION_RESPONSE_TEXT varchar,
	AVS_RESULT_CODE varchar,
	RETRIEVAL_REFERENCE_NUMBER varchar,
	MARKET_DATA_IDENTIFIER varchar,
	TRANSACTION_IDENTIFIER varchar,
	VALIDATION_CODE varchar,
	HOST_MESSAGE_IDENTIFIER varchar,
	SYSTEM_TRACE_AUDIT_NUMBER varchar,
	NETWORK_ID_CODE varchar,
	SETTLEMENT_DATE varchar,
	COMMERCIAL_CARD_RESPONSE_INDICATOR varchar,
	VERIFICATION_RESULT_CODE varchar,
	CAVV_RESULTS_CODE varchar,
	CARD_LEVEL_RESULTS varchar,
	FIRST_ACCOUNT_TYPE1 varchar,
	FIRST_ACCOUNT_TYPE2 varchar,
	FIRST_CURRENCY_CODE varchar,
	FIRST_SIGN varchar,
	FIRST_AMOUNT varchar,
	SECOND_ACCOUNT_TYPE1 varchar,
	SECOND_ACCOUNT_TYPE2 varchar,
	SECOND_SIGN varchar,
	SECOND_CURRENCY_CODE varchar,
	SECOND_AMOUNT varchar,
	THIRD_ACCOUNT_TYPE1 varchar,
	THIRD_ACCOUNT_TYPE2 varchar,
	THIRD_SIGN varchar,
	THIRD_CURRENCY_CODE varchar,
	THIRD_AMOUNT varchar,
	FOURTH_ACCOUNT_TYPE1 varchar,
	FOURTH_ACCOUNT_TYPE2 varchar,
	FOURTH_CURRENCY_CODE varchar,
	FOURTH_SIGN varchar,
	FOURTH_AMOUNT varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	GROUP001 varchar,
	GROUP014 varchar,
	GROUP020 varchar,
	GROUP022 varchar,
	GROUP026 varchar,
	GROUP034 varchar,
	GROUP043 varchar,
	SECONDARY_AMOUNT varchar,
	APPROVED_AMOUNT int(11),
	BALANCE int(11),
	SPEND_QUALIFIED_INDICATOR varchar,
	GROUP011 varchar,
	GROUP027 varchar,
	GROUP056 varchar,
	GROUP013 varchar,
	GROUP037 varchar,
	GROUP061 varchar,
	GROUP062 varchar,
	GROUP055 varchar,
	GROUP055_RESPONSE varchar,
	GROUP000 varchar,
	GROUP039 varchar,
	GROUP067 varchar,
	GROUP069 varchar,
	CARD_TYPE varchar,
	EBT_AVAILABLE_BALANCE varchar,
	GROUP066 varchar,
	ORIGINAL_PURCHASE_DATA varchar,
	ORIGINAL_PURCHASE_DATA varchar,
	ORIGINAL_PURCHASE_DATA varchar,
	MERCHANT_ADVICE_CODE varchar,
	GROUP074 varchar,
	TRANSACTION_INTEGRITY_CLASS varchar,
	GROUP024 varchar,
	GROUP072 varchar,
	DEVICE_CODE varchar,
	GROUP071 varchar,
	MERCHANT_ADVICE_CODE varchar,
	GROUP024 varchar,
	DEVICE_CODE varchar,
	GROUP074 varchar,
	TRANSACTION_INTEGRITY_CLASS varchar,
	GROUP072 varchar,
	GROUP071 varchar,
	MERCHANT_ADVICE_CODE varchar,
	GROUP024 varchar,
	DEVICE_CODE varchar,
	GROUP074 varchar,
	TRANSACTION_INTEGRITY_CLASS varchar,
	GROUP072 varchar,
	GROUP071 varchar,
	ELECTRONIC_COMMERCE_SECURITY_LEVEL_INDICATOR varchar,
	ELECTRONIC_COMMERCE_SECURITY_LEVEL_INDICATOR varchar,
	ELECTRONIC_COMMERCE_SECURITY_LEVEL_INDICATOR varchar,
	REIMBURSEMENT_ATTRIBUTE varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	RECORD_FORMAT varchar,
	RECORD_FORMAT varchar,
	RECORD_FORMAT varchar,
	ACQUIRER_BIN varchar,
	MERCHANT_NUMBER varchar,
	RECORD_FORMAT varchar,
	ACQUIRER_BIN_NEW varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	GROUP060 varchar,
	REIMBURSEMENT_ATTRIBUTE varchar,
	GROUP060 varchar,
	REIMBURSEMENT_ATTRIBUTE varchar,
	GROUP060 varchar,
	GROUP063 varchar,
	GROUP025 varchar,
	GROUP072 varchar,
	GROUP063 varchar,
	GROUP063 varchar,
	GROUP025 varchar,
	GROUP072 varchar,
	GROUP025 varchar,
	COUNTRY_CODE varchar,
	CURRENCY_CODE varchar,
	GROUP075 varchar,
	COUNTRY_CODE varchar,
	CURRENCY_CODE varchar,
	GROUP075 varchar,
	COUNTRY_CODE varchar,
	CURRENCY_CODE varchar,
	GROUP075 varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;