-- Create Table Statement for 'TSYS Capture Retail Transaction'
DROP TABLE IF EXISTS `TSYS_CAPTURE_RETAIL_TRANSACTION`;
CREATE TABLE `TSYS_CAPTURE_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	RECORD_TYPE1 varchar,
	RECORD_TYPE2 varchar,
	TRANSACTION_CODE varchar,
	CARDHOLDER_ID_CODE varchar,
	ACCOUNT_DATA_SOURCE varchar,
	REQUESTED_ACI varchar,
	RETURNED_ACI varchar,
	AUTHORIZATION_SOURCE_CODE varchar,
	TRANSACTION_SEQUENCE_NUMBER varchar,
	RESPONSE_CODE varchar,
	APPROVAL_CODE varchar,
	LOCAL_TRANSACTION_DATE varchar,
	LOCAL_TRANSACTION_TIME varchar,
	AVS_RESULT_CODE varchar,
	TRANSACTION_IDENTIFIER varchar,
	VALIDATION_CODE varchar,
	SETTLEMENT_AMOUNT varchar,
	AUTHORIZED_AMOUNT varchar,
	GROUP3 varchar,
	GROUP10 varchar,
	GROUP12 varchar,
	GROUP21 varchar,
	GROUP22 varchar,
	GROUP31 varchar,
	GROUP38 varchar,
	GROUP39 varchar,
	GROUP41 varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	TSYS_RETAIL_FILE_BATCH_FK bigint(20),
	GROUP25 varchar,
	GROUP26 varchar,
	GROUP27 varchar,
	GROUP2 varchar,
	GROUP35 varchar,
	TRANSACTION_STATUS_CODE varchar,
	GROUP1 varchar,
	GROUP34 varchar,
	GROUP5 varchar,
	GROUP7 varchar,
	GROUP61 varchar,
	ICC_TRANSACTION_TYPE varchar,
	ICC_TERMINAL_TRANSACTION_DATE varchar,
	ICC_TERMINAL_VERIFICATION_RESULTS varchar,
	ICC_TERMINAL_CURRENCY_CODE varchar,
	ICC_APPLICATION_TRANSACTION_COUNTER varchar,
	ICC_APPLICATION_INTERCHANGE_PROFILE varchar,
	ICC_APPLICATION_CRYPTOGRAM varchar,
	ICC_UNPREDICTABLE_NUMBER varchar,
	ICC_ISSUER_APPLICATION_DATA varchar,
	ICC_CRYPTOGRAM_INFORMATION_DATA varchar,
	ICC_TERMINAL_CAPABILITY_PROFILE varchar,
	ICC_CARD_SEQUENCE_NUMBER varchar,
	ICC_ISSUER_AUTHENTICATION_DATA varchar,
	ICC_CVM_RESULTS varchar,
	ICC_ISSUER_SCRIPT_RESULTS varchar,
	ICC_FORM_FACTOR_IDENTIFIER varchar,
	ICC_CRYPTOGRAM_AMOUNT varchar,
	GROUP32 varchar,
	TSYS_RETAIL_ITEMS_FK bigint(20),
	GROUP11 varchar,
	GROUP40 varchar,
	LODGING_ROOM_RATE varchar,
	LODGING_NUMBER_OF_NIGHTS varchar,
	GROUP36 varchar,
	ICC_DEDICATED_FILE_NAME varchar,
	ICC_TERMINAL_TYPE_CODE varchar,
	ICC_INTERFACE_DEVICE_SERIAL_NUMBER varchar,
	ICC_TRANSACTION_CATEGORY_CODE varchar,
	ICC_TERMINAL_APPLICATION_VERSION_NUMBER varchar,
	ICC_TRANSACTION_SEQUENCE_NUMBER varchar,
	ICC_APPLICATION_USAGE_CONTROL_PARAMETERS varchar,
	ICC_APPLICATION_IDENTIFIER_TERMINAL varchar,
	CHIP_CARD_ADDENDUM_RECORD_TYPE varchar,
	ICC_DEDICATED_FILE_NAME varchar,
	ICC_TERMINAL_TYPE_CODE varchar,
	ICC_INTERFACE_DEVICE_SERIAL_NUMBER varchar,
	ICC_TRANSACTION_CATEGORY_CODE varchar,
	ICC_TERMINAL_APPLICATION_VERSION_NUMBER varchar,
	ICC_TRANSACTION_SEQUENCE_NUMBER varchar,
	ICC_APPLICATION_USAGE_CONTROL_PARAMETERS varchar,
	ICC_APPLICATION_IDENTIFIER_TERMINAL varchar,
	CHIP_CARD_ADDENDUM_RECORD_TYPE varchar,
	ICC_DEDICATED_FILE_NAME varchar,
	ICC_TERMINAL_TYPE_CODE varchar,
	ICC_INTERFACE_DEVICE_SERIAL_NUMBER varchar,
	ICC_TRANSACTION_CATEGORY_CODE varchar,
	ICC_TERMINAL_APPLICATION_VERSION_NUMBER varchar,
	ICC_TRANSACTION_SEQUENCE_NUMBER varchar,
	ICC_APPLICATION_USAGE_CONTROL_PARAMETERS varchar,
	ICC_APPLICATION_IDENTIFIER_TERMINAL varchar,
	CHIP_CARD_ADDENDUM_RECORD_TYPE varchar,
	TRANSACTION_IDENTITY varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	REIMBURSEMENT_ATTRIBUTE varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	GROUP41 varchar,
	TRANSACTION_IDENTITY varchar,
	REIMBURSEMENT_ATTRIBUTE varchar,
	GROUP41 varchar,
	TRANSACTION_IDENTITY varchar,
	REIMBURSEMENT_ATTRIBUTE varchar,
	GROUP41 varchar,
	GROUP41 varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;