-- Create Table Statement for 'TPG Terminal Order Transaction'
DROP TABLE IF EXISTS `TPG_TERMINAL_ORDER_TRANSACTION`;
CREATE TABLE `TPG_TERMINAL_ORDER_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	TPG_CUSTOMER_NUMBER varchar,
	ORDER_TYPE varchar,
	PO_NUMBER varchar,
	MERCHANT_ID varchar,
	COMMENTS varchar,
	USER_DEFINED1 varchar,
	USER_DEFINED2 varchar,
	USER_DEFINED3 varchar,
	USER_DEFINED4 varchar,
	USER_DEFINED5 varchar,
	SHIP_TO_NAME varchar,
	CONTACT_PERSON varchar,
	SHIP_METHOD varchar,
	PHONE_NUMBER varchar,
	ADDRESS1 varchar,
	ADDRESS2 varchar,
	CITY varchar,
	STATE varchar,
	ZIP_CODE varchar,
	COUNTRY varchar,
	STATUS varchar,
	TPG_ORDER_NUMBER varchar,
	RESPONSE_TYPE varchar,
	CREATION_DATE varchar,
	TPG_BATCH_FK bigint(20),
	TERMINAL_ORDER_TRANSACTION_FK bigint(20),
	INFORMATION varchar,
	VALIDATE_DATE datetime,
	RECEIVE_DATE datetime,
	PROCESSED_DATE datetime,
	TPG_TERMINAL_ORDER_TRANSACTION_DETAIL_FK bigint(20),
	TPG_BATCH_FK bigint(20),
	TERMINAL_ORDER_TRANSACTION_FK bigint(20),
	TPG_BATCH_FK bigint(20),
	TERMINAL_ORDER_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;