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

CREATE TABLE ap_warehouse_settleCost (
  AWS_ID 					varchar(20) 	NOT NULL 		COMMENT '仓库结算费用编号',
  AWS_COST_SETTLED			varchar(100) 			 		COMMENT '已结算费用',
  AWS_UNSETTLED_FEE 		varchar(20) 		 			COMMENT '未结算费用',
  AWS_WAREHOUSE_CONTRACT	varchar(20) 					COMMENT '仓库合同关联ID ap_warehouse_contract.AWC_ID',
  AWS_WAREHOUSE_ID			varchar(20) 					COMMENT '仓库关联ID ap_warehouse_inf.AWI_ID',
  AWS_COMPANY_ID			varchar(20) 					COMMENT '客户ID ap_company_inf.ACI_ID',
  AWS_MODIFY_TIME 			varchar(14)  					COMMENT '最后执行时间',
  AWS_STATE 				varchar(2)  					COMMENT '状态 00正常 01删除',
  PRIMARY KEY (AWS_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='仓库结算费用表';