-- Create Table Statement for 'Employee Order'
DROP TABLE IF EXISTS `EMPLOYEE_ORDER`;
CREATE TABLE `EMPLOYEE_ORDER` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CREATE_DATE datetime,
	STATUS_CL varchar NOT NULL,
	IS_RETURN tinyint(1),
	EMPLOYEE_FK bigint(20) NOT NULL,
	EMPLOYEE_RECORD_FK bigint(20) NOT NULL,
	CREATOR_CODE varchar NOT NULL,
	ITEM_COUNT int(11) NOT NULL,
	GROSS_AMOUNT int(11) NOT NULL,
	DISCOUNT_AMOUNT int(11),
	NET_AMOUNT int(11) NOT NULL,
	ORDER_NOTES varchar,
	REVIEW_NOTES varchar,
	DOCUMENT_FK bigint(20),
	SHIP_TO_ACCOUNT int(11),
	APPROVAL_DATE datetime,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;