-- Create Table Statement for 'EFT Profit Stars Retail Transaction'
DROP TABLE IF EXISTS `EFT_PROFIT_STARS_RETAIL_TRANSACTION`;
CREATE TABLE `EFT_PROFIT_STARS_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	STORE_ID bigint(20),
	ENTITY_ID int(11),
	LOCATION_ID int(11),
	PAYMENT_ORIGIN varchar,
	ACCOUNT_TYPE varchar,
	OPERATION_TYPE varchar,
	EFFECTIVE_DATE varchar,
	DESCRIPTION varchar,
	TOTAL_AMOUNT varchar,
	TRANSACTION_NUMBER bigint(20),
	TRANSACTION_STATUS varchar,
	SETTELMENT_STATUS varchar,
	FIELD1 varchar,
	FIELD2 varchar,
	FIELD3 varchar,
	CHECK_NUMBER varchar,
	IS_BUSSINESS_PAYMENT varchar,
	NAME_ON_ACCOUNT varchar,
	BILLING_ADDRESS1 varchar,
	BILLING_CITY varchar,
	BILLING_STATE_REGION varchar,
	BILLING_POSTAL_CODE varchar,
	BILLING_COUNTRY varchar,
	BILLING_PHONE varchar,
	IP_ADDRESS_OF_ORIGINATOR varchar,
	EMAIL_ADDRESS varchar,
	ORIGINAL_REFERENCE_NUMBER varchar,
	CAPTURE_AMOUNT varchar,
	IS_COMPANY varchar,
	CUSTOMER_NUMBER varchar,
	FIRST_NAME varchar,
	LAST_NAME varchar,
	ADDRESS1 varchar,
	CITY varchar,
	STATE_REGION varchar,
	POSTAL_CODE varchar,
	COUNTRY varchar,
	CREATE_CUSTOMER_IF_DOES_NOT_EXISTS varchar,
	UPDATE_CUSTOMER_IF_EXISTS varchar,
	RECURRING_PAYMENT_ORIGIN varchar,
	REFERENCE_NUMBER varchar,
	SUCCESS varchar,
	ERROR varchar,
	RESPONSE_CODE varchar,
	ACTUAL_DATE varchar,
	RESPONSE_MESSAGE varchar,
	ORIGINATED_AS varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	ACTION varchar,
	EFT_PROFIT_STARS_RETURNS_BATCH_FK bigint(20),
	EVENT_DATA_STRING varchar,
	EVENT_DATE_TIME varchar,
	RETURN_CODE varchar,
	NOTICE_OF_CHANGE varchar,
	EVENT_TYPE_NAME varchar,
	RETURN_DESCRIPTION varchar,
	NOTICE_OF_CHANGE_CODE varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	EFT_PROFIT_STARS_RETURNS_BATCH_FK bigint(20),
	EFT_PROFIT_STARS_RETURNS_BATCH_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;