| 1234567891011 |
- 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='仓库商品出入库月统计';
|
