guomao/DOC/DB/00_table/ap_expense_statement.sql

CREATE TABLE ap_expense_statement(
  ASS_ID		  varchar(20) 	NOT NULL COMMENT '编号',
  ASS_HTML 		  text 		    NOT NULL COMMENT 'HTML内容',
  ASS_DATE 		  varchar(50) 	NOT NULL COMMENT '日期范围',
  ASS_WARE_ID 	  varchar(20)   NOT NULL COMMENT '仓库id',
  ASS_ALL_WEIGHT  varchar(20)   NOT NULL COMMENT '总重量',
  ASS_ALL_AMOUNT  varchar(20)   NOT NULL COMMENT '总金额',
  ASS_COST_ID     varchar(300)  NOT NULL COMMENT 'cost表id ap_warehouse_cost.AWC_ID',
  ASS_REMARK      varchar(200)  		 COMMENT '备注',
  ASS_BRANCH_ID   varchar(20)  		 	 COMMENT '部门编号',
  PRIMARY KEY (ASS_ID)
) ENGINE=InnoDB   DEFAULT CHARSET=utf8 COMMENT='费用结算单保存表';