-- Create Table Statement for 'World Pay TCMP Retail Transaction'
DROP TABLE IF EXISTS `WORLD_PAY_TCMP_RETAIL_TRANSACTION`;
CREATE TABLE `WORLD_PAY_TCMP_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	APPLICATION_TYPE varchar,
	PROCESSING_TYPE varchar,
	TERMINAL_IDENTIFICATION varchar,
	DEVICE_IDENTIFIER varchar,
	MESSAGE_NUMBER varchar,
	TRANSACTION_CODE varchar,
	ACCOUNT_TYPE varchar,
	ENTRY_METHOD varchar,
	REQUEST_TYPE varchar,
	MOTO_ECOMMERCE_FLAG varchar,
	CARD_HOLDER_ID_METHOD varchar,
	SIC_OVERRIDE_FLAG varchar,
	OVERRIDING_SIC_CODE varchar,
	BATCH_NUMBER varchar,
	SEQUENCE_NUMBER varchar,
	LOCAL_TRANSACTION_DATE varchar,
	LOCAL_TRANSACTION_TIME varchar,
	TOTAL_AMOUNT varchar,
	RETRIEVAL_BILLABLE_EVENT_DATA varchar,
	AUTHORIZATION_CODE varchar,
	ADDITIONAL_AMOUNT_FIELD varchar,
	TRANS_TYPE_IDENTIFIER varchar,
	EBT_VOUCHER_NUMBER varchar,
	EBT_AUTHORIZATION_CODE varchar,
	CUSTOMER_ADDRESS varchar,
	CUSTOMER_ZIP_CODE varchar,
	PARTIAL_AUTHORIZATION_SUPPORT varchar,
	MISCELLANEOUS_MERCHANT_ID varchar,
	TERMINAL_INPUT_CAPABILITIES varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	VERIFIED_VISA_MASTER_CARD_INDICATOR varchar,
	TOTAL_AMOUNT_AUTHORIZED varchar,
	ACTION_CODE varchar,
	RESPONSE_LITERAL varchar,
	RETRIEVAL_DATA varchar,
	ADDITIONAL_RECEIPT_DATA varchar,
	TRAN_TYPE_SPECIFIC_DATA varchar,
	TRAN_TYPE_IDENTIFIER varchar,
	AMOUNT_OF_CASH_BACK_AUTHORIZED varchar,
	FEE_AMT_FOR_DEBIT varchar,
	DEBIT_BALANCE varchar,
	FOOD_ACCOUNT_BALANCE varchar,
	CASH_ACCOUNT_BALANCE varchar,
	FCS_NUMBER varchar,
	AVS_RESULT_CODE varchar,
	CVV2_RESULT_CODE varchar,
	PURCHASE_CARD_INDICATOR varchar,
	AUTH_SOURCE varchar,
	CREDIT_ACI_AUTHORIZATION_CHARACTERISTICS_INDICATOR varchar,
	VALIDATION_CODE varchar,
	UCAF_CAVV_RESULT_CODE varchar,
	EMAIL varchar,
	DESCRIPTION varchar,
	INVOICE_NUMBER varchar,
	POSTAL_ZIP_CODE varchar,
	POSTAL_ADDRESS varchar,
	PHONE_NUMBER varchar,
	HEALTHCARE_AMOUNT varchar,
	TRANSIT_AMOUNT varchar,
	PRESCRIPTION_AMOUNT varchar,
	VISION_AMOUNT varchar,
	CLINIC_AMOUNT varchar,
	DENTAL_AMOUNT 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;