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='仓库结算费用表';