CREATE TABLE ap_warehouse_statistics (
  AWS_MONTH 					varchar(6) 		NOT NULL 		COMMENT '出入库年月',
  AWS_IN_WEIGHT 				varchar(20) 		 			COMMENT '入库数量',
  AWS_OUT_WEIGHT 				varchar(20) 		 			COMMENT '出库数量',
  AWS_AVL_WEIGHT 				varchar(20) 		 			COMMENT '当月剩余库存',
  AWS_WAREHOUSE_ID				varchar(20) 	NOT NULL		COMMENT '仓库ID',
  AWS_STANDARD_ID				varchar(20)		NOT NULL		COMMENT '商品规格',
  AWS_BRAND_ID					varchar(20)		NOT NULL		COMMENT '品牌ID',
  AWS_COMPANY_ID				varchar(20)		NOT NULL		COMMENT '货权单位',
  PRIMARY KEY (AWS_MONTH,AWS_WAREHOUSE_ID,AWS_STANDARD_ID,AWS_COMPANY_ID, AWS_BRAND_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='仓库商品出入库月统计';