-- Create Table Statement for 'First Data OmniPay Capture Retail Transaction'
DROP TABLE IF EXISTS `FIRST_DATA_OMNI_PAY_CAPTURE_RETAIL_TRANSACTION`;
CREATE TABLE `FIRST_DATA_OMNI_PAY_CAPTURE_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	TRAN_CODE varchar,
	CARD_TYPE_CODE varchar,
	TRANSACTION_DATE varchar,
	MAIL_TELEPHONE_ORDER_FLAG varchar,
	ELECTRONIC_COMMERCE_INDICATOR varchar,
	MERCHANT_REFERENCE_NUMBER varchar,
	CHARGE_DESCRIPTION varchar,
	TRANSACTION_AMOUNT varchar,
	TRANSACTION_CURRENCY_CODE varchar,
	COMMERCIAL_ENTITY_STATE varchar,
	COMMERCIAL_ENTITY_COUNTRY varchar,
	COMMERCIAL_ENTITY_ZIP varchar,
	COMMERCIAL_ENTITY_CITY varchar,
	INTERCHANGE_PROGRAM_QUALIFICATION_FLAG varchar,
	RECURRING_INSTALLMENT_TRANSACTION_FLAG varchar,
	SUBMISSION_ID varchar,
	AUTHORISATION_DATE varchar,
	TRANSACTION_TIME varchar,
	TRANSACTION_TIME_ZONE varchar,
	TERMINAL_ID varchar,
	JCB_TRANSACTION_DATE varchar,
	PAN_ENTRY_MODE varchar,
	POS_TERMINAL_CAPABILITY varchar,
	CARDHOLDER_ID varchar,
	NETWORK_REFERENCE_ID varchar,
	ENTRY_MODE varchar,
	DINERS_ACTION_CODE varchar,
	DINERS_MOBILE_POS_INDICATOR varchar,
	AUTHORISATION_SOURCE varchar,
	AUTHORISATION_CHARACTERISTIC_INDICATOR varchar,
	MARKET_SPECIFIC_AUTH_INDICATOR varchar,
	AUTHORISATION_RESPONSE_CODE varchar,
	VALIDATION_CODE varchar,
	CVV2_RESULT_CODE varchar,
	ORIGINAL_CREDIT_IDENTIFIER varchar,
	ATM_ACCOUNT_SELECTION varchar,
	CHIP_CONDITION_CODE varchar,
	PRODUCT_ID varchar,
	CAT_LEVEL_INDICATOR varchar,
	MULTIPLE_CLEARING_SEQUENCE_NUMBER varchar,
	MULTIPLE_CLEARING_SEQUENCE varchar,
	PURCHASE_IDENTIFIER_INDICATOR varchar,
	PURCHASE_IDENTIFIER varchar,
	AVS_RESPONSE_CODE varchar,
	FORM_FACTOR_INDICATOR varchar,
	BANKNET_REFERENCE_NUMBER varchar,
	UCAF_STATUS_INDICATOR varchar,
	ADDRESS_VERIFICATION_CODE varchar,
	CARD_DATA_INPUT_CAPABILITY varchar,
	CARDHOLDER_AUTHENTICATION_CAPABILITY varchar,
	CARD_CAPTURE_CAPABILITY varchar,
	OPERATING_ENVIRONMENT varchar,
	CARDHOLDER_PRESENT varchar,
	CARD_PRESENT varchar,
	CARD_DATA_INPUT_MODE varchar,
	CARDHOLDER_AUTHENTICATION_METHOD varchar,
	CARDHOLDER_AUTHENTICATION_ENTITY varchar,
	CARD_DATA_OUTPUT_CAPABILITY varchar,
	TERMINAL_OUTPUT_CAPABILITY varchar,
	PIN_CAPTURE_CAPABILITY varchar,
	AMEX_TRANSACTION_IDENTIFIER varchar,
	REFERENCE_NUMBER varchar,
	ICC_CARD_SEQUENCE_NUMBER varchar,
	TERMINAL_TRANSACTION_DATE varchar,
	TERMINAL_CAPABILITY_PROFILE varchar,
	TERMINAL_COUNTRY_CODE varchar,
	EMV_TRANSACTION_CURRENCY_CODE varchar,
	DEDICATED_FILE_NAME varchar,
	APPLICATION_TRANSACTION_COUNTER varchar,
	ICC_APPLICATION_INTERCHANGE_PROFILE varchar,
	TERMINAL_VERIFICATION_RESULTS varchar,
	TERMINAL_APPLICATION_VERSION_NUMBER varchar,
	CRYPTOGRAM_AMOUNT varchar,
	ISSUER_SCRIPT1_RESULT varchar,
	ICC_APPLICATION_CRYPTOGRAM varchar,
	CRYPTOGRAM_INFORMATION_DATA varchar,
	TRANSACTION_SEQUENCE_COUNTER varchar,
	TERMINAL_SERIAL_NUMBER varchar,
	UNPREDICTABLE_NUMBER varchar,
	AMOUNT_OTHER varchar,
	ISSUER_APPLICATION_DATA varchar,
	TRANSACTION_TYPE varchar,
	CARDHOLDER_VERIFICATION_METHOD_RESULTS varchar,
	TERMINAL_TYPE varchar,
	TRANSACTION_CATEGORY_CODE varchar,
	TRANSACTION_IDENTIFIER varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	BIN_OVERRIDE varchar,
	AUTHORISATION_CODE varchar,
	CARDHOLDER_NUMBER_LENGTH int(11),
	RECORD_E_TERMINAL_ID varchar,
	CASHBACK_AMOUNT varchar,
	MERCHANT_CATEGORY_CODE varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	FIRST_DATA_OMNI_PAY_RETAIL_FILE_BATCH_FK bigint(20),
	FIRST_DATA_OMNI_PAY_RETAIL_FILE_BATCH_FK bigint(20),
	FIRST_DATA_OMNI_PAY_RETAIL_FILE_BATCH_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;