-- Create Table Statement for 'Billing Credit Agency Transaction'
DROP TABLE IF EXISTS `BILLING_CREDIT_AGENCY_TRANSACTION`;
CREATE TABLE `BILLING_CREDIT_AGENCY_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CREATE_DATE datetime,
	COLLECTOR_ACCOUNT_CODE int(11),
	STATUS_CL varchar,
	EFFECTIVE_DATE datetime,
	CUSTOMER_ACCOUNT_CODE varchar,
	FIRST_NAME varchar,
	LAST_NAME varchar,
	MIDDLE_NAME varchar,
	STREET1 varchar,
	STREET2 varchar,
	CITY varchar,
	STATE varchar,
	ZIP_CODE varchar,
	SOCIAL_SECURITY_NUMBER varchar,
	BIRTH_DATE datetime,
	PHONE varchar,
	OPEN_DATE datetime,
	CLOSE_DATE datetime,
	ORIGINAL_DELINQUENCY_AMOUNT int(11),
	ORIGINAL_DELINQUENCY_DATE datetime,
	CURRENT_BALANCE int(11),
	ACTUAL_PAYMENT_AMOUNT int(11),
	LAST_PAYMENT_DATE datetime,
	IS_BANKRUPTCY_FILED tinyint(1),
	ORIGINAL_CREDITOR_NAME varchar,
	IS_DECEASED tinyint(1),
	IS_CORRECTED tinyint(1),
	CREDIT_AGENCY_DISPUTE_CL varchar,
	DELETE_CL varchar,
	PREV_TRANSACTION_CODE varchar,
	REF_CODE varchar,
	CUSTOMER_ACCOUNT_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;