-- Create Table Statement for 'Tpg Maverick Terminal Order Transaction'
DROP TABLE IF EXISTS `TPG_MAVERICK_TERMINAL_ORDER_TRANSACTION`;
CREATE TABLE `TPG_MAVERICK_TERMINAL_ORDER_TRANSACTION` (
	ID bigint(20) NOT NULL,
	TPG_MAVERICK_TERMINAL_ORDER_TRANSACTION_DETAILS bigint(20),
	TERMINAL_ORDER_TRANSACTION_FK bigint(20),
	FULFILLMENT_CENTER_CODE bigint(20),
	PO varchar,
	SHIPPER varchar,
	FIRST_NAME varchar,
	LAST_NAME varchar,
	ADDRESS1 varchar,
	CITY varchar,
	ZIP varchar,
	COUNTRY varchar,
	PHONE varchar,
	COMPANY varchar,
	ADDRESS2 varchar,
	STATE varchar,
	ADDITIONAL_OPTION_CUSTOMER_ID varchar,
	ADDITIONAL_OPTION_CUSTOMER_PO varchar,
	RESPONSE_NUMBER varchar,
	RESPONSE_ERROR_CODE varchar,
	RESPONSE_ERROR_MESSAGE varchar,
	RESPONSE_STATUS varchar,
	RESPONSE_TRACKING_NUMBER varchar,
	RESPONSE_TRACKING_STATUS varchar,
	RESPONSE_SHIP_DATE varchar,
	SHIPPING_METHOD varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;