-- Create Table Statement for 'Paymentech Stratus Chargeback Transaction'
DROP TABLE IF EXISTS `PAYMENTECH_STRATUS_CHARGEBACK_TRANSACTION`;
CREATE TABLE `PAYMENTECH_STRATUS_CHARGEBACK_TRANSACTION` (
	CHARGE_TRANSACTION_FK bigint(20),
	ENTITY_NUMBER varchar,
	PRESENTMENT_CURRENCY varchar,
	ISSUER_CHARGEBACK_PRESENTMENT_CURRENCY_AMOUNT varchar,
	PREVIOUS_PARTIAL_REPRESENTMENT varchar,
	CATEGORY varchar,
	STATUS_FLAG varchar,
	SEQUENCE_NUMBER varchar,
	MERCHANT_ORDER_NUMBER varchar,
	ACCOUNT_NUMBER_MASKED varchar,
	REASON_CODE varchar,
	TRANSACTION_DATE varchar,
	CHARGEBACK_INITIATED_DATE varchar,
	ACTIVITY_DATE varchar,
	CURRENT_ACTION_PRESENTMENT_CURRENCY_CHARGEBACK_AMOUNT varchar,
	FEE_AMOUNT varchar,
	USAGE_CODE varchar,
	SETTLEMENT_CURRENCY varchar,
	ISSUER_CHARGEBACK_SETTLEMENT_CURRENCY_AMOUNT varchar,
	CURRENT_ACTION_SETTLEMENT_CURRENCY_AMOUNT varchar,
	MOP_CODE varchar,
	AUTHORIZATION_DATE varchar,
	CHARGEBACK_DUE_DATE varchar,
	TICKET_NUMBER varchar,
	POTENTIAL_BUNDLED_CHARGEBACKS varchar,
	TOKEN_INDICATOR varchar,
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11),
	PAYMENTECH_STRATUS_CHARGEBACK_BATCH_FK bigint(20),
	ID bigint(20) NOT NULL,
	ID bigint(20) NOT NULL,
	CHARGE_TRANSACTION_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID, ID, ID)
) ENGINE=InnoDB;