-- Create Table Statement for 'Retail Transaction Cycle'
DROP TABLE IF EXISTS `RETAIL_TRANSACTION_CYCLE`;
CREATE TABLE `RETAIL_TRANSACTION_CYCLE` (
	ID bigint(20) NOT NULL,
	OPEN_DATE datetime,
	CLOSE_DATE datetime,
	RETAIL_TRANSACTION_CYCLE_CL varchar,
	IS_LOCKED tinyint(1),
	PROCESSED_DATE datetime,
	IS_TRANSACTION_CONFIRMATION_ENABLED tinyint(1),
	CONFIRMATION_LOG varchar,
	SUB_BATCH_CODE bigint(20),
	IS_SETTLEMENT_NOTIFICATION_ENABLED tinyint(1),
	EXPECTED_CLOSE_DATE datetime,
	REVIEW_CL varchar,
	IS_REALTIME_MANUAL_CLIENT_CAPTURE tinyint(1),
	EXTERNAL_CODE1 int(11),
	EXTERNAL_CODE2 int(11),
	EXTERNAL_CODE3 int(11),
	BILLING_PROFILE_CODE1 bigint(20),
	BILLING_PROFILE_CODE2 bigint(20),
	BILLING_PROFILE_CODE3 bigint(20),
	BILLING_PROFILE_TYPE1 varchar,
	BILLING_PROFILE_TYPE2 varchar,
	BILLING_PROFILE_TYPE3 varchar,
	SETTLEMENT_MODE_CL varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	PROVISIONING_TRANSACTION_FK bigint(20),
	GENERIC_EMAIL_FK bigint(20),
	EMAIL_FK bigint(20),
	SUB_BATCH_FK bigint(20),
	TERMINAL_CODE bigint(20),
	TERMINAL_CODE bigint(20),
	TERMINAL_CODE bigint(20),
	CLOSE_DATE datetime,
	CLOSE_DATE datetime,
	RETAIL_TRANSACTION_CYCLE_CL varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;