-- Create Table Statement for 'Master Reseller Statement Detail'
DROP TABLE IF EXISTS `IAPP_MASTER_RESELLER_STATEMENT_DETAIL`;
CREATE TABLE `IAPP_MASTER_RESELLER_STATEMENT_DETAIL` (
ID bigint(20) NOT NULL,
MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
AMOUNT int(11),
ACTIVITY_DATE datetime,
CREATOR_CODE varchar,
DESCRIPTION varchar,
IS_VISIBLE_EXTERNALLY tinyint(1),
PROCESSING_FEE_TOTAL_AMOUNT int(11),
FLAT_FEE_TOTAL_AMOUNT int(11),
RECURRING_FEE_TOTAL_AMOUNT int(11),
PROCESSING_COST_TOTAL_AMOUNT int(11),
RESELLER_STATEMENT_FK bigint(20),
DUE_DATE datetime,
MERCHANT_REQUIRED_AMOUNT int(11),
MERCHANT_COLLECTED_AMOUNT int(11),
ADJUSTMENT_TOTAL_AMOUNT int(11),
MERCHANT_REQUIRED_AMOUNT int(11),
MERCHANT_COLLECTED_AMOUNT int(11),
ID bigint(20) NOT NULL,
MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
ADJUSTMENT_TOTAL_AMOUNT int(11),
MERCHANT_REQUIRED_AMOUNT int(11),
MERCHANT_COLLECTED_AMOUNT int(11),
ID bigint(20) NOT NULL,
MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
MASTER_RESELLER_STATEMENT_FK bigint(20),
MASTER_RESELLER_STATEMENT_FK bigint(20),
AMOUNT int(11),
MERCHANT_REQUIRED_AMOUNT int(11),
MERCHANT_COLLECTED_AMOUNT int(11),
AMOUNT int(11),
ADJUSTMENT_TOTAL_AMOUNT int(11),
MERCHANT_REQUIRED_AMOUNT int(11),
MERCHANT_COLLECTED_AMOUNT int(11),
MERCHANT_REQUIRED_AMOUNT int(11),
MERCHANT_COLLECTED_AMOUNT int(11),
MASTER_RESELLER_STATEMENT_FK bigint(20),
MASTER_RESELLER_STATEMENT_FK bigint(20),
MASTER_RESELLER_STATEMENT_FK bigint(20),
PRIMARY KEY (ID, ID, ID)
) ENGINE=InnoDB;