-- Create Table Statement for 'Eft Peoples Bank Retail Transaction'
DROP TABLE IF EXISTS `EFT_PEOPLES_BANK_RETAIL_TRANSACTION`;
CREATE TABLE `EFT_PEOPLES_BANK_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	VERB varchar,
	RESOURCE varchar,
	CLIENT_EFT_REFERENCE varchar,
	TRANSACTION_FLOW varchar,
	CPA_CODE varchar,
	AMOUNT_IN_CENTS bigint(20),
	DUE_DATE varchar,
	TRANSACTION_DESCRIPTOR varchar,
	ACCOUNT_TYPE varchar,
	FIRST_NAME varchar,
	LAST_NAME varchar,
	COMPANY_NAME varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	TRANSACTION_ID varchar,
	TRANSACTION_REFERENCE varchar,
	TRANSACTION_STATUS varchar,
	CREATION_DATE_TIME varchar,
	LAST_MODIFIED_DATE_TIME varchar,
	EVENT_DATE varchar,
	EVENT_TYPE varchar,
	NOTE varchar,
	CPA_RETURN_CODE varchar,
	ERROR_CODE varchar,
	ERROR_MESSAGE varchar,
	LIST_OF_ERRORS varchar,
	LIST_OF_ERRORS_CODE1 varchar,
	LIST_OF_ERRORS_MESSAGE1 varchar,
	ORIGINATOR_SHORT_NAME varchar,
	ORIGINATOR_LONG_NAME varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;