-- Create Table Statement for 'Account Transaction'
DROP TABLE IF EXISTS `ACCOUNT_TRANSACTION`;
CREATE TABLE `ACCOUNT_TRANSACTION` (
	ID bigint(20) NOT NULL,
	AMOUNT int(11),
	BALANCE int(11),
	HISTORICAL_BALANCE int(11),
	NOTE varchar,
	POSTER_CODE varchar,
	REF_CREATOR_CODE varchar,
	REF_SELLER_CODE varchar,
	REF_SHIFT_CODE varchar,
	REF_TERMINAL_CODE varchar,
	TAX_AMOUNT int(11),
	DUE_DATE datetime,
	RETURN_FEE int(11),
	LATE_FEE int(11),
	PRE_CUSTOMER_ACCOUNT_AGE int(11),
	POST_CUSTOMER_ACCOUNT_AGE int(11),
	IS_COLLECTIONS_TRANSACTION tinyint(1),
	BALANCING_GROUP varchar,
	IS_VISIBLE_EXTERNALLY tinyint(1),
	ADJUSTMENT_TRANSACTION_FK bigint(20),
	PAYMENT_PLAN_FK bigint(20),
	CLIENT_HOST varchar,
	TRANSACTION_ORIGIN_CODE varchar,
	SOURCE_BALANCING_SUMMARY_FK bigint(20),
	BALANCING_SUMMARIES bigint(20),
	FRANCHISE_FEE_CODE bigint(20),
	FEE_AMOUNT int(11),
	FRANCHISE_FEE_CODE bigint(20),
	FEE_AMOUNT int(11),
	FRANCHISE_FEE_CODE bigint(20),
	FEE_AMOUNT int(11),
	INVOICE_LIST varchar,
	INVOICE_LIST varchar,
	INVOICE_LIST varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;