-- Create Table Statement for 'Dantom Letter'
DROP TABLE IF EXISTS `DANTOM_LETTER`;
CREATE TABLE `DANTOM_LETTER` (
	ID bigint(20) NOT NULL,
	CODE varchar,
	LETTER_CODE varchar,
	EXTERNAL_REFENCE_CODE varchar,
	FIRST_NAME varchar,
	LAST_NAME varchar,
	STREET1 varchar,
	STREET2 varchar,
	CITY varchar,
	STATE varchar,
	ZIP_CODE varchar,
	CUSTOMER_ACCOUNT_CODE varchar,
	CUSTOMER_ACCOUNT_BALANCE varchar,
	NOTICE_EFFECTIVE_DATE varchar,
	RETURN_REASON varchar,
	MERCHANT_NAME varchar,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	MERCHANT_ACCOUNT_NAME varchar,
	TRANSACTION_AMOUNT varchar,
	TRANSACTION_BALANCE varchar,
	TRANSACTION_DATE varchar,
	TRANSACTION_DUE_DATE varchar,
	RETURN_FEE_AMOUNT varchar,
	LATE_FEE_AMOUNT varchar,
	SOFT_DECLINE_TOTAL_AMOUNT varchar,
	HARD_DECLINE_TOTAL_AMOUNT varchar,
	CHARGEBACK_TOTAL_AMOUNT varchar,
	SCHEDULED_PAYMENT_AMOUNT varchar,
	AMOUNT0_11DAYS_LATE varchar,
	AMOUNT11_30DAYS_LATE varchar,
	AMOUNT30_60DAYS_LATE varchar,
	AMOUNT_OVER60DAYS_LATE varchar,
	PAYMENT_OPTION_HOLDER_NAME varchar,
	PAYMENT_OPTION_TYPE varchar,
	PAYMENT_OPTION_NUMBER varchar,
	PAYMENT_PLAN_AMOUNT varchar,
	FIRST_BILLING_DATE varchar,
	NEXT_BILLING_DATE varchar,
	CUSTOM_FIELD1 varchar,
	CUSTOM_FIELD2 varchar,
	CUSTOM_FIELD3 varchar,
	CUSTOM_FIELD4 varchar,
	CUSTOM_FIELD5 varchar,
	COLLECTIONS_TRANSACTION_FK bigint(20),
	LETTER_STATEMENT_CONTENT_FK bigint(20),
	LETTER_FILE_BATCH_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;