-- Create Table Statement for 'Global Payments East Auth Retail Transaction'
DROP TABLE IF EXISTS `GLOBAL_PAYMENTS_EAST_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `GLOBAL_PAYMENTS_EAST_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	MESSAGE_TYPE varchar,
	BIT3 varchar,
	BIT4 varchar,
	BIT11 varchar,
	BIT12 varchar,
	BIT22 varchar,
	BIT31 varchar,
	BIT38 varchar,
	BIT42 varchar,
	BIT44 varchar,
	BIT48 varchar,
	BIT54 varchar,
	APPROVED_AMOUNT varchar,
	BIT31_TRANSACTION_ID varchar,
	BIT31_VALIDATION_CODE varchar,
	BIT31_AUTHORIZATION_SOURCE_CODE varchar,
	BIT31_RESPONSE_CODE varchar,
	BIT31_BALANCE_DATA varchar,
	BIT31_PRODUCT_IDENTIFIER varchar,
	BIT31_PROGRAM_IDENTIFIER varchar,
	BIT31_MERCHANT_ADVICE_CODE varchar,
	BIT31_SYSTEM_ADDRESS varchar,
	BIT44_VERBIAGE varchar,
	BIT44_BATCH_NUMBER varchar,
	BIT44_ITEM varchar,
	BIT44_BATCH_AMOUNT varchar,
	BIT44_FOOD_STAMP_BALANCE varchar,
	BIT44_CASH_BENEFIT_BALANCE varchar,
	BIT48_AVS_RESULT_CODE varchar,
	BIT48_CAVV_RESULT_CODE varchar,
	BIT62_GLOBAL_PAYMENTS_DATA varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	BIT25 varchar,
	BIT32 varchar,
	BIT31_ACQUIRER_REFERENCE_DATA varchar,
	BIT48_ADDITIONAL_DATA varchar,
	PROCESS_MODE varchar,
	BIT38_APPROVAL_CODE varchar,
	BIT39_ACTION_CODE varchar,
	BIT48_CARD_VERIFICATION_RESULT varchar,
	BIT61 varchar,
	ACQUIRER_INSTITUTION_ID varchar,
	BIT30 varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;