-- Create Table Statement for 'Metro To Transaction'
DROP TABLE IF EXISTS `METRO2_TRANSACTION`;
CREATE TABLE `METRO2_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	TIME_STAMP varchar,
	CORRECTION_INDICATOR varchar,
	IDENTIFICATION_NUMBER varchar,
	CONSUMER_ACCOUNT_NUMBER varchar,
	OPEN_DATE varchar,
	ORIGINAL_LOAN_AMOUNT varchar,
	ACTUAL_PAYMENT_AMOUNT varchar,
	ACCOUNT_STATUS varchar,
	SPECIAL_COMMENT varchar,
	COMPLIANCE_CONDITION_CODE varchar,
	CURRENT_BALANCE varchar,
	ACCOUNT_INFORMATION_DATE varchar,
	FIRST_DELINQUENCY_DATE varchar,
	CLOSE_DATE varchar,
	LAST_PAYMENT_DATE varchar,
	CONSUMER_TRANSACTION_TYPE varchar,
	SURNAME varchar,
	FIRST_NAME varchar,
	MIDDLE_NAME varchar,
	SOCIAL_SECURITY_NUMBER varchar,
	BIRTH_DATE varchar,
	TELEPHONE_NUMBER varchar,
	ECOA_CODE varchar,
	CONSUMER_INFORMATION_INDICATOR varchar,
	ADDRESS1 varchar,
	ADDRESS2 varchar,
	CITY varchar,
	STATE varchar,
	ZIP_CODE varchar,
	ORIGINAL_CREDITOR_NAME varchar,
	CREDIT_AGENCY_TRANSACTION_FK bigint(20),
	METRO2_BATCH_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;