-- Create Table Statement for 'LSI Batch Transaction'
DROP TABLE IF EXISTS `LSI_BATCH_TRANSACTION`;
CREATE TABLE `LSI_BATCH_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_NUMBER varchar,
	REFERENCE_NUMBER varchar,
	ACCOUNT_NAME varchar,
	ACCOUNT_TYPE varchar,
	AMOUNT int(11),
	TRANSACTION_DATE varchar,
	TRANSACTION_TYPE varchar,
	INDIVIDUAL_FIRST_NAME varchar,
	INDIVIDUAL_LAST_NAME varchar,
	HOME_PHONE varchar,
	ADDRESS_STREET1 varchar,
	CITY varchar,
	STATE varchar,
	ZIP varchar,
	MERCHANT_ACCOUNT_ID varchar,
	DEBITOR_ID varchar,
	EMAIL_ADDRESS varchar,
	PAYEE_NAME varchar,
	DATE_RETURNED varchar,
	RETURN_CODE varchar,
	COLLECTION_STATUS varchar,
	TRANSACTION_METHOD varchar,
	RETURN_ADDENDA varchar,
	RETURN_COUNT varchar,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CHARGE_TRANSACTION_FK bigint(20),
	LSI_BATCH_FK bigint(20),
	LSI_BATCH_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	LSI_BATCH_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;