-- Create Table Statement for 'Collections Transaction'
DROP TABLE IF EXISTS `COLLECTIONS_TRANSACTION`;
CREATE TABLE `COLLECTIONS_TRANSACTION` (
	ID bigint(20) NOT NULL,
	TEMPLATE_CODE varchar,
	COLLECTIONS_PROFILE_CL varchar,
	CREATE_DATE datetime,
	MERCHANT_NAME varchar,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	MERCHANT_ACCOUNT_NAME varchar,
	FIRST_NAME varchar,
	LAST_NAME varchar,
	STREET1 varchar,
	STREET2 varchar,
	CITY varchar,
	STATE varchar,
	ZIP_CODE varchar,
	PHONE varchar,
	EMAIL varchar,
	COUNTRY varchar,
	EXTERNAL_REFERENCE_CODE varchar,
	TRANSACTION_CODE varchar,
	TRANSACTION_TYPE varchar,
	TRANSACTION_AMOUNT int(11),
	TRANSACTION_BALANCE int(11),
	RETURN_FEE_AMOUNT int(11),
	LATE_FEE_AMOUNT int(11),
	TRANSACTION_DATE datetime,
	TRANSACTION_DUE_DATE datetime,
	RESPONSE_CODE varchar,
	RETURN_REASON varchar,
	NOTE varchar,
	CUSTOMER_ACCOUNT_CODE varchar,
	CUSTOMER_ACCOUNT_BALANCE int(11),
	PAYMENT_OPTION_HOLDER_NAME varchar,
	PAYMENT_OPTION_TYPE varchar,
	PAYMENT_OPTION_NUMBER varchar,
	PAYMENT_PLAN_AMOUNT int(11),
	FIRST_BILLING_DATE datetime,
	NEXT_BILLING_DATE datetime,
	CUSTOM_FIELD1 varchar,
	CUSTOM_FIELD2 varchar,
	CUSTOM_FIELD3 varchar,
	CUSTOM_FIELD4 varchar,
	CUSTOM_FIELD5 varchar,
	IS_STATEMENT tinyint(1),
	SUB_BATCH_FK bigint(20),
	RESPONSE_CODE varchar,
	RESPONSE_CODE varchar,
	EMAIL varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;