-- Create Table Statement for 'Paymentech Orbital Batch Transaction'
DROP TABLE IF EXISTS `PAYMENTECH_ORBITAL_BATCH_TRANSACTION`;
CREATE TABLE `PAYMENTECH_ORBITAL_BATCH_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	BATCH_REQUEST_NO int(11),
	INDUSTRY_TYPE varchar,
	TRANS_TYPE varchar,
	AVS_ZIP varchar,
	AVS_ADDRESS1 varchar,
	AVS_CITY varchar,
	AVS_STATE varchar,
	AVS_NAME varchar,
	ORDER_ID varchar,
	AMOUNT int(11),
	TX_REF_NUM varchar,
	TX_REF_IDX varchar,
	RESP_DATE_TIME varchar,
	PROC_STATUS varchar,
	APPROVAL_STATUS varchar,
	RESP_CODE varchar,
	AVS_RESP_CODE varchar,
	AUTHORIZATION_CODE varchar,
	PROC_STATUS_MESSAGE varchar,
	RESP_CODE_MESSAGE varchar,
	HOST_RESP_CODE varchar,
	HOST_AVS_RESP_CODE varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	CC_PAYMENTECH_BATCH_FK bigint(20),
	CC_PAYMENTECH_BATCH_CC_PAYMENT_TECH_BATCH_TRANSACTIONS_IDX int(11),
	CARD_BRAND varchar,
	COMMENTS varchar,
	SHIPPING_REF varchar,
	TAX_AMOUNT int(11),
	PCARD_ORDER_ID varchar,
	PCARD_DEST_ZIP varchar,
	PCARD_DEST_NAME varchar,
	PCARD_DEST_ADDRESS varchar,
	PCARD_DEST_CITY varchar,
	PCARD_DEST_STATE_CD varchar,
	AMEX_TRAN_ADV_ADDN1 varchar,
	AMEX_TRAN_ADV_ADDN2 varchar,
	AMEX_TRAN_ADV_ADDN3 varchar,
	AMEX_TRAN_ADV_ADDN4 varchar,
	BILLER_REFERENCE_NUMBER varchar,
	RETRY_TRACE varchar,
	CUSTOMER_REF_NUM varchar,
	AVS_PHONE varchar,
	AVS_COUNTRY_CODE varchar,
	SD_MERCHANT_NAME varchar,
	SD_PRODUCT_DESCRIPTION varchar,
	SD_MERCHANT_CITY varchar,
	SD_MERCHANT_PHONE varchar,
	SD_MERCHANT_EMAIL varchar,
	SD_MERCHANT_URL varchar,
	CUSTOMER_EMAIL varchar,
	ECP_BANK_ACCT_TYPE varchar,
	ECP_AUTH_METHOD varchar,
	ECP_DELV_METHOD varchar,
	ECP_BANK_ACCT_TYPE varchar,
	ECP_AUTH_METHOD varchar,
	ECP_DELV_METHOD varchar,
	ECP_BANK_ACCT_TYPE varchar,
	ECP_AUTH_METHOD varchar,
	ECP_DELV_METHOD varchar,
	ENTITY_NUMBER varchar,
	CURRENCY varchar,
	CATEGORY varchar,
	STATUS_FLAG varchar,
	SEQUENCE_NUMBER varchar,
	MERCHANT_ORDER_NUMBER varchar,
	REASON_CODE varchar,
	NOC_CODE varchar,
	ORIGINAL_TRANSACTION_DATE varchar,
	ECP_RETURN_DATE varchar,
	ACTIVITY_DATE varchar,
	ECP_RETURN_AMT varchar,
	USAGE_CODE varchar,
	CONSUMER_NAME varchar,
	ACCOUNT_TYPE varchar,
	REASON_CODE_CLASSIFICATION varchar,
	ACCOUNTHOLDER_AUTHORIZATION_METHOD varchar,
	CORRECTED_CONSUMER_NAME varchar,
	CORRECTED_ACCOUNT_TYPE varchar,
	SOURCE_OF_NOC varchar,
	MIT_MSG_TYPE varchar,
	MIT_STORED_CREDENTIAL_IND varchar,
	MIT_SUBMITTED_TRANSACTION_ID varchar,
	MIT_RECEIVED_TRANSACTION_ID varchar,
	MIT_MSG_TYPE varchar,
	MIT_STORED_CREDENTIAL_IND varchar,
	MIT_SUBMITTED_TRANSACTION_ID varchar,
	MIT_RECEIVED_TRANSACTION_ID varchar,
	CC_PAYMENTECH_BATCH_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	TX_REF_NUM varchar,
	CC_PAYMENTECH_BATCH_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	MIT_MSG_TYPE varchar,
	MIT_STORED_CREDENTIAL_IND varchar,
	MIT_SUBMITTED_TRANSACTION_ID varchar,
	MIT_RECEIVED_TRANSACTION_ID varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;