-- Create Table Statement for 'Ln Skip Tracing Transaction'
DROP TABLE IF EXISTS `LN_SKIP_TRACING_TRANSACTION`;
CREATE TABLE `LN_SKIP_TRACING_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	ACCOUNT_NUMBER varchar,
	FIRST_NAME varchar,
	MIDDLE_NAME varchar,
	LAST_NAME varchar,
	SUFFIX varchar,
	DOB varchar,
	ADDRESS varchar,
	CITY varchar,
	STATE varchar,
	ZIP varchar,
	PHONE1 varchar,
	PHONE2 varchar,
	PHONE3 varchar,
	PHONE4 varchar,
	PHONE5 varchar,
	PHONE6 varchar,
	PHONE7 varchar,
	PHONE8 varchar,
	PHONE9 varchar,
	PHONE10 varchar,
	PROCESS_CODE varchar,
	MATCH_TYPE varchar,
	BEST_FIRST1 varchar,
	BEST_MIDDLE1 varchar,
	BEST_LAST1 varchar,
	BEST_SUFFIX1 varchar,
	BEST_ADDRESS1 varchar,
	BEST_CITY1 varchar,
	BEST_STATE1 varchar,
	BEST_ZIPCODE1 varchar,
	BEST_DATE_FIRST1 varchar,
	BEST_DATE_LAST1 varchar,
	SUBJ_FIRST1 varchar,
	SUBJ_MIDDLE1 varchar,
	SUBJ_LAST1 varchar,
	SUBJ_SUFFIX1 varchar,
	SUBJ_PHONE10_1 varchar,
	SUBJ_NAME_DUAL1 varchar,
	SUBJ_PHONE_TYPE1 varchar,
	SUBJ_DATE_FIRST1 varchar,
	SUBJ_DATE_LAST1 varchar,
	SUBJ_FIRST2 varchar,
	SUBJ_MIDDLE2 varchar,
	SUBJ_LAST2 varchar,
	SUBJ_SUFFIX2 varchar,
	SUBJ_PHONE10_2 varchar,
	SUBJ_NAME_DUAL2 varchar,
	SUBJ_PHONE_TYPE2 varchar,
	SUBJ_DATE_FIRST2 varchar,
	SUBJ_DATE_LAST2 varchar,
	SKIP_TRACING_TRANSACTION_FK bigint(20),
	LN_SKIP_TRACING_FILE_BATCH_FK bigint(20),
	BEST_DOD varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;