-- Create Table Statement for 'Asset Transaction'
DROP TABLE IF EXISTS `ASSET_TRANSACTION`;
CREATE TABLE `ASSET_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MASKED_ACCOUNT_NUMBER varchar,
	MASKED_ACCESSORY varchar,
	TRANSACTION_CL varchar,
	IS_PREPAYMENT tinyint(1),
	IS_CAPTURED tinyint(1),
	PREVIOUS_PAYMENT_DATE datetime,
	AGGREGATION_INFO varchar,
	FEE_CLAIM_AMOUNT int(11),
	INVOICE_CLAIM_AMOUNT int(11),
	RETURN_CLAIM_AMOUNT int(11),
	TRANSACTION_SOURCE_CL varchar,
	IS_ACCOUNT_DELINQUENT tinyint(1),
	PROCESSED_DATE datetime,
	ATTEMPT_COUNT int(11),
	RESPONSE_CODE varchar,
	RESPONSE_DATE datetime,
	CAPTURE_INFO_FK bigint(20),
	CHARGEBACK_TRANSACTION_FK bigint(20),
	CHECK_NUMBER varchar,
	FEE_AMOUNT int(11),
	IS_DRAFT_RETURN tinyint(1),
	ALLOCATION_DETAIL varchar,
	FEE_AMOUNT int(11),
	FEE_AMOUNT int(11),
	FEE_AMOUNT int(11),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;