-- Create Table Statement for 'Distribution Schema Detail'
DROP TABLE IF EXISTS `IAPP_DISTRIBUTION_SCHEMA_DETAIL`;
CREATE TABLE `IAPP_DISTRIBUTION_SCHEMA_DETAIL` (
	ID bigint(20) NOT NULL,
	CREATE_DATE datetime,
	IS_ACTIVE tinyint(1),
	AMOUNT int(11),
	RATE decimal(10,2),
	ACCOUNT_TYPE_CL varchar,
	AMOUNT_CL varchar,
	SOURCE_CL varchar,
	DESTINATION_CL varchar,
	DESTINATION_CODE int(11),
	DISTRIBUTION_SCHEMA_FK int(11),
	DISTRIBUTION_SCHEMA_DISTRIBUTION_SCHEME_DETAILS_IDX int(11),
	RATE decimal(10,2),
	RATE decimal(10,2),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;