-- Create Table Statement for 'Payment'
DROP TABLE IF EXISTS `PAYMENT`;
CREATE TABLE `PAYMENT` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CUSTOMER_ACCOUNT_CODE varchar,
	PAYMENT_OPTION_CODE varchar,
	TRANSACTION_CODE varchar,
	CREATE_DATE datetime,
	STATUS_CL varchar,
	FIRST_NAME varchar,
	LAST_NAME varchar,
	ACCOUNT_PAYMENT_AMOUNT int(11),
	ACCOUNT_PAYMENT_DESCRIPTION varchar,
	NEW_SALE_AMOUNT int(11),
	NEW_SALE_TAX_AMOUNT int(11),
	NEW_SALE_DESCRIPTION varchar,
	TOTAL_AMOUNT int(11),
	CREDIT_CARD_CL varchar,
	CREATOR_CODE varchar,
	RESPONSE_CODE varchar,
	RESPONSE_MESSAGE varchar,
	STORE_NUMBER varchar,
	SALES_PERSON_NUMBER1 varchar,
	DRAWER_ID varchar,
	PRIMARY KEY ()
) ENGINE=InnoDB;