CREATE TABLE `value entry` (
	`timestamp` BINARY(8) NULL DEFAULT NULL,
	`Entry No_` INT(11) NOT NULL,
	`Item No_` VARCHAR(20) NOT NULL,
	`Posting Date` DATETIME NOT NULL,
	`Item Ledger Entry Type` INT(11) NOT NULL,
	`Source No_` VARCHAR(20) NOT NULL,
	`Document No_` VARCHAR(20) NOT NULL,
	`Description` VARCHAR(50) NOT NULL,
	`Location Code` VARCHAR(10) NOT NULL,
	`Inventory Posting Group` VARCHAR(10) NOT NULL,
	`Source Posting Group` VARCHAR(10) NOT NULL,
	`Item Ledger Entry No_` INT(11) NOT NULL,
	`Valued Quantity` DECIMAL(38,20) NOT NULL,
	`Item Ledger Entry Quantity` DECIMAL(38,20) NOT NULL,
	`Invoiced Quantity` DECIMAL(38,20) NOT NULL,
	`Cost per Unit` DECIMAL(38,20) NOT NULL,
	`Sales Amount (Actual)` DECIMAL(38,20) NOT NULL,
	`Salespers__Purch_ Code` VARCHAR(10) NOT NULL,
	`Discount Amount` DECIMAL(38,20) NOT NULL,
	`User ID` VARCHAR(20) NOT NULL,
	`Source Code` VARCHAR(10) NOT NULL,
	`Applies-to Entry` INT(11) NOT NULL,
	`Global Dimension 1 Code` VARCHAR(20) NOT NULL,
	`Global Dimension 2 Code` VARCHAR(20) NOT NULL,
	`Source Type` INT(11) NOT NULL,
	`Cost Amount (Actual)` DECIMAL(38,20) NOT NULL,
	`Cost Posted to G_L` DECIMAL(38,20) NOT NULL,
	`Reason Code` VARCHAR(10) NOT NULL,
	`Drop Shipment` TINYINT(3) UNSIGNED NOT NULL,
	`Journal Batch Name` VARCHAR(10) NOT NULL,
	`Gen_ Bus_ Posting Group` VARCHAR(10) NOT NULL,
	`Gen_ Prod_ Posting Group` VARCHAR(10) NOT NULL,
	`Document Date` DATETIME NOT NULL,
	`External Document No_` VARCHAR(20) NOT NULL,
	`Cost Amount (Actual) (ACY)` DECIMAL(38,20) NOT NULL,
	`Cost Posted to G_L (ACY)` DECIMAL(38,20) NOT NULL,
	`Cost per Unit (ACY)` DECIMAL(38,20) NOT NULL,
	`Document Type` INT(11) NOT NULL,
	`Document Line No_` INT(11) NOT NULL,
	`Expected Cost` TINYINT(3) UNSIGNED NOT NULL,
	`Item Charge No_` VARCHAR(20) NOT NULL,
	`Valued By Average Cost` TINYINT(3) UNSIGNED NOT NULL,
	`Partial Revaluation` TINYINT(3) UNSIGNED NOT NULL,
	`Inventoriable` TINYINT(3) UNSIGNED NOT NULL,
	`Valuation Date` DATETIME NOT NULL,
	`Entry Type` INT(11) NOT NULL,
	`Variance Type` INT(11) NOT NULL,
	`Purchase Amount (Actual)` DECIMAL(38,20) NOT NULL,
	`Purchase Amount (Expected)` DECIMAL(38,20) NOT NULL,
	`Sales Amount (Expected)` DECIMAL(38,20) NOT NULL,
	`Cost Amount (Expected)` DECIMAL(38,20) NOT NULL,
	`Cost Amount (Non-Invtbl_)` DECIMAL(38,20) NOT NULL,
	`Cost Amount (Expected) (ACY)` DECIMAL(38,20) NOT NULL,
	`Cost Amount (Non-Invtbl_)(ACY)` DECIMAL(38,20) NOT NULL,
	`Expected Cost Posted to G_L` DECIMAL(38,20) NOT NULL,
	`Exp_ Cost Posted to G_L (ACY)` DECIMAL(38,20) NOT NULL,
	`Job No_` VARCHAR(20) NOT NULL,
	`Job Task No_` VARCHAR(20) NOT NULL,
	`Job Ledger Entry No_` INT(11) NOT NULL,
	`Prod_ Order No_` VARCHAR(20) NOT NULL,
	`Variant Code` VARCHAR(10) NOT NULL,
	`Adjustment` TINYINT(3) UNSIGNED NOT NULL,
	`Average Cost Exception` TINYINT(3) UNSIGNED NOT NULL,
	`Capacity Ledger Entry No_` INT(11) NOT NULL,
	`Type` INT(11) NOT NULL,
	`No_` VARCHAR(20) NOT NULL,
	`Prod_ Order Line No_` INT(11) NOT NULL,
	`Return Reason Code` VARCHAR(10) NOT NULL,
	`Use for Cost Calculation` TINYINT(3) UNSIGNED NOT NULL,
	PRIMARY KEY (`Entry No_`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB;
