-- Create Table Statement for 'FirstData Omaha Auth Retail Transaction'
DROP TABLE IF EXISTS `FIRST_DATA_OMAHA_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `FIRST_DATA_OMAHA_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	PROTOCOL_TYPE varchar,
	TERMINAL_ID varchar,
	MERCHANT_NUMBER varchar,
	DEVICE_ID varchar,
	WRITE_CONTROL_CHARACTER varchar,
	TRANSACTION_TYPE varchar,
	TRANSACTION_CODE varchar,
	CARD_VERIFICATION_PRESENCE_INDICATOR varchar,
	TOTAL_AMOUNT varchar,
	INVOICE_NUMBER varchar,
	BATCH_NUMBER varchar,
	ITEM_NUMBER varchar,
	REVISION_NUMBER varchar,
	FORMAT_CODE varchar,
	TAX_AMOUNT varchar,
	TIP_AMOUNT varchar,
	TRANSACTION_IDENTIFIER varchar,
	CARD_TYPE_INDICATOR varchar,
	CASH_BACK_AMOUNT varchar,
	SURCHARGE varchar,
	EBT_VOUCHER_NUMBER varchar,
	AUTHORIZATION_CODE varchar,
	PARTIAL_AUTHORIZATION_INDICATOR varchar,
	TPP varchar,
	AUAR varchar,
	AVS_ZIP_CODE varchar,
	AVS_ADDRESS varchar,
	POS_DATA_CODES varchar,
	PHONE_MAIL_ORDER_FLAG varchar,
	ORDER_NUMBER varchar,
	AUTH_CHAR_INDICATOR_REQUEST varchar,
	AVS_RESPONSE_CODE varchar,
	TOTAL_AUTHORIZED_AMOUNT varchar,
	CUSTOMER_CODE varchar,
	MERCHANT_SET_CERTIFICATE_SERIAL_NUMBER varchar,
	CARDHOLDER_SET_CERTIFICATE_SERIAL_NUMBER varchar,
	XID varchar,
	TRANS_STAIN varchar,
	SHIP_TO_POSTAL_CODE varchar,
	ACTION_CODE varchar,
	RESPONSE_CODE varchar,
	RESPONSE_TEXT varchar,
	CARD_VERIFICATION_RESPONSE_CODE varchar,
	REMAINING_BALANCE varchar,
	BALANCE_SIGN varchar,
	APPROVED_AMOUNT varchar,
	REQUESTED_AMOUNT varchar,
	ADDITIONAL_RESPONSE_INDICATOR varchar,
	DEBIT_CARD_TYPE_NUMBER varchar,
	DEBIT_NETWORK_NAME varchar,
	EBT_RESPONSE_CODE varchar,
	EBT_REMAINING_BALANCE varchar,
	EBT_CURRENT_BALANCE varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	TERMINAL_CAPABILITY varchar,
	EMV_DATA_REQUEST varchar,
	MC_TRACE_ID varchar,
	EMV_DATA_RESPONSE varchar,
	ROUTING_CODE varchar,
	SIGNATURE_CODE varchar,
	AUTH_CHAR_INDICATOR_RESPONSE varchar,
	ITEM_NUMBER_RESPONSE varchar,
	TERMINAL_PIN_CAPABILITY varchar,
	TERMINAL_CATEGORY_CODE varchar,
	TERMINAL_CARD_CAPTURE_CAPABILITY 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;