-- Create Table Statement for 'Charge Transaction Addenda'
DROP TABLE IF EXISTS `CHARGE_TRANSACTION_ADDENDA`;
CREATE TABLE `CHARGE_TRANSACTION_ADDENDA` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	ACCOUNT_NUMBER_SUPPLEMENTARY varchar,
	ACCOUNT_NUMBER_SUPPLEMENTARY_LAST4 varchar,
	ACCOUNT_NUMBER_SUPPLEMENTARY_MASKED varchar,
	TOKEN_CODE_SUPPLEMENTARY varchar,
	CARD_CL varchar,
	ALIAS varchar,
	RENTAL_NAME varchar,
	RENTAL_CITY varchar,
	RENTAL_STATE varchar,
	RENTAL_COUNTRY varchar,
	RENTAL_DATE datetime,
	RENTAL_TIME varchar,
	RENTAL_RETURN_CITY varchar,
	RENTAL_RETURN_STATE varchar,
	RENTAL_RETURN_COUNTRY varchar,
	RENTAL_RETURN_DATE datetime,
	RENTAL_RETURN_TIME varchar,
	RENTAL_EXTRA_CHARGES_AMOUNT int(11),
	RENTAL_AGREEMENT_NUMBER varchar,
	RENTAL_DURATION int(11),
	RENTAL_SPECIAL_PROGRAM_CL varchar,
	RENTAL_RETURN_LOCATION_CODE varchar,
	RENTAL_DAILY_RATE_AMOUNT int(11),
	RENTAL_MILE_RATE_AMOUNT int(11),
	RENTAL_TOTAL_MILES int(11),
	RENTAL_MAX_FREE_MILES int(11),
	RENTAL_INSURANCE_AMOUNT int(11),
	TOKEN_SUPPLEMENTARY varchar,
	LODGING_GUEST_NAME varchar,
	FORMAT varchar,
	RENTAL_ADDRESS varchar,
	COPAY_AMOUNT int(11),
	PETROLEUM_JOB_NUMBER varchar,
	PETROLEUM_JOB_ID_NUMBER varchar,
	PETROLEUM_DEPARTMENT_NUMBER varchar,
	PETROLEUM_USER_ID_NUMBER varchar,
	PETROLEUM_VEHICLE_ID_NUMBER varchar,
	PETROLEUM_DEVICE_SEQUENCE_NUMBER varchar,
	CUSTOM_FIELD_DATA varchar,
	CUSTOM_FIELD_DATA varchar,
	CUSTOM_FIELD_DATA varchar,
	ORIGINAL_NETWORK_TRANSACTION_ID varchar,
	NETWORK_TRANSACTION_ID varchar,
	SPLIT_SCHEMA_CODE varchar,
	SPLIT_SCHEMA_ID bigint(20),
	ORIGINAL_NETWORK_TRANSACTION_ID varchar,
	NETWORK_TRANSACTION_ID varchar,
	CUSTOM_FIELD_DATA varchar,
	CUSTOM_FIELD_DATA varchar,
	SPLIT_SCHEMA_CODE varchar,
	SPLIT_SCHEMA_ID bigint(20),
	ORIGINAL_NETWORK_TRANSACTION_ID varchar,
	NETWORK_TRANSACTION_ID varchar,
	SPLIT_SCHEMA_CODE varchar,
	SPLIT_SCHEMA_ID bigint(20),
	LANGUAGE_CODE varchar,
	AUTHENTICATION_VERIFICATION_VALUE varchar,
	AUTHENTICATION_VERIFICATION_VALUE varchar,
	AUTHENTICATION_VERSION varchar,
	AUTHENTICATION_CODE varchar,
	LANGUAGE_CODE varchar,
	AUTHENTICATION_VERSION varchar,
	AUTHENTICATION_CODE varchar,
	AUTHENTICATION_VERIFICATION_VALUE varchar,
	LANGUAGE_CODE varchar,
	AUTHENTICATION_VERSION varchar,
	AUTHENTICATION_CODE varchar,
	REWARD_NUMBER varchar,
	REWARD_NUMBER varchar,
	REMOTE_COMMERCE_ACCEPTOR_IDENTIFIER varchar,
	REWARD_NUMBER varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;