-- Create Table Statement for 'Global Payments East Retail File Batch'
DROP TABLE IF EXISTS `GLOBAL_PAYMENTS_EAST_RETAIL_FILE_BATCH`;
CREATE TABLE `GLOBAL_PAYMENTS_EAST_RETAIL_FILE_BATCH` (
	ID bigint(20) NOT NULL,
	PROCESSING_CODE varchar,
	CARD_ACCEPTOR_ID_CODE varchar,
	TERMINAL_TYPE varchar,
	MARKET_ID varchar,
	APPLICATION_INFORMATION varchar,
	CREDIT_CARD_PURCHASES_NUMBER varchar,
	CREDIT_CARD_PURCHASES_AMT varchar,
	CREDIT_CARD_RETURNS_NUMBER varchar,
	CREDIT_CARD_RETURNS_AMT varchar,
	DEBIT_CARD_PURCHASES_NUMBER varchar,
	DEBIT_CARD_PURCHASES_AMT varchar,
	DEBIT_CARD_RETURNS_NUMBER varchar,
	DEBIT_CARD_RETURNS_AMT varchar,
	BATCH_NUMBER varchar,
	BATCH_CONTROL_NUMBER varchar,
	ACTION_CODE varchar,
	BIT44_VERBIAGE varchar,
	BIT44_BATCH_NUMBER varchar,
	BIT44_ITEMS_NUMBER varchar,
	BIT44_BATCH_AMOUNT varchar,
	BIT63_CREDIT_CARD_PURCHASES_NUMBER varchar,
	BIT63_CREDIT_CARD_PURCHASES_AMT varchar,
	BIT63_CREDIT_CARD_RETURNS_NUMBER varchar,
	BIT63_CREDIT_CARD_RETURNS_AMT varchar,
	BIT63_DEBIT_CARD_PURCHASES_NUMBER varchar,
	BIT63_DEBIT_CARD_PURCHASES_AMT varchar,
	BIT63_DEBIT_CARD_RETURNS_NUMBER varchar,
	BIT63_DEBIT_CARD_RETURNS_AMT varchar,
	TOTAL_COUNT int(11),
	TOTAL_AMOUNT int(11),
	PROCESS_MODE varchar,
	ACQUIRER_INSTITUTION_ID varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;