-- Create Table Statement for 'FirstData North EDC Auth Retail Transaction'
DROP TABLE IF EXISTS `FIRST_DATA_NORTH_EDC_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `FIRST_DATA_NORTH_EDC_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	MERCHANT_ID varchar,
	TRANSACTION_CODE varchar,
	BIT03_TRANSACTION_AMOUNT varchar,
	BIT22_APPROVAL_CODE varchar,
	BIT29_POS_ENTRY_MODE varchar,
	BIT30_POS_PIN_CAPABILITY varchar,
	BIT31_POS_CONDITION_CODE varchar,
	BIT36_DEBIT_ACCOUNT_TYPE varchar,
	BIT37_LOCAL_DATE_TIME varchar,
	BIT38_DEBIT_RECEIPT_NUMBER varchar,
	BIT39_CASH_BACK_AMOUNT varchar,
	BIT43_DEBIT_FUNCTION_CODE varchar,
	BIT45_ADDRESS_VERIFICATION varchar,
	AVS_RESPONSE_CODE varchar,
	BALANCE1_ACCOUNT_TYPE varchar,
	BALANCE1_AMOUNT_TYPE varchar,
	BALANCE1_CURRENCY_TYPE varchar,
	BALANCE1_SIGN varchar,
	BALANCE1_AMOUNT varchar,
	BALANCE2_ACCOUNT_TYPE varchar,
	BALANCE2_AMOUNT_TYPE varchar,
	BALANCE2_CURRENCY_TYPE varchar,
	BALANCE2_SIGN varchar,
	BALANCE2_AMOUNT varchar,
	BALANCE3_ACCOUNT_TYPE varchar,
	BALANCE3_AMOUNT_TYPE varchar,
	BALANCE3_CURRENCY_TYPE varchar,
	BALANCE3_SIGN varchar,
	BALANCE3_AMOUNT varchar,
	BALANCE4_ACCOUNT_TYPE varchar,
	BALANCE4_AMOUNT_TYPE varchar,
	BALANCE4_CURRENCY_TYPE varchar,
	BALANCE4_SIGN varchar,
	BALANCE4_AMOUNT varchar,
	BALANCE5_ACCOUNT_TYPE varchar,
	BALANCE5_AMOUNT_TYPE varchar,
	BALANCE5_CURRENCY_TYPE varchar,
	BALANCE5_SIGN varchar,
	BALANCE5_AMOUNT varchar,
	BALANCE6_ACCOUNT_TYPE varchar,
	BALANCE6_AMOUNT_TYPE varchar,
	BALANCE6_CURRENCY_TYPE varchar,
	BALANCE6_SIGN varchar,
	BALANCE6_AMOUNT varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	APPROVAL_CODE varchar,
	CAPTURE_FLAG varchar,
	APPROVAL_DATE varchar,
	BIT21_TABLE14 varchar,
	BIT21_TABLE14_RESPONSE varchar,
	BIT21_TABLE48 varchar,
	BIT21_TABLE48_RESPONSE varchar,
	BIT21_TABLE49_RESPONSE varchar,
	BIT21_TABLE53 varchar,
	BIT21_TABLE53_RESPONSE varchar,
	BIT21_TABLE60 varchar,
	BIT21_TABLE62 varchar,
	BIT21_TABLE62_RESPONSE varchar,
	BIT21_TABLE66 varchar,
	BIT21_TABLE66_RESPONSE varchar,
	BIT21_TABLE68 varchar,
	BIT21_TABLE68_RESPONSE varchar,
	BIT21_TABLE69 varchar,
	BIT21_TABLE_VI varchar,
	BIT21_TABLE_VI_RESPONSE varchar,
	BIT21_TABLE_DS varchar,
	BIT21_TABLE_DS_RESPONSE varchar,
	RESPONSE_MESSAGE varchar,
	AUTHORIZED_AMOUNT int(11),
	BIT21_TABLE55_RESPONSE varchar,
	BIT21_TABLE72 varchar,
	BIT21_TABLE_SD varchar,
	IS_REVERSAL tinyint(1),
	BIT21_TABLE55 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;