CREATE TABLE 0_denorm_qoh (
	id INT AUTO_INCREMENT,
	stock_id VARCHAR(20),
	loc_code VARCHAR(20),
	quantity DOUBLE, -- quantity in the order
	primary key (id),
	key stock_id (stock_id, loc_code)
)
;
