1.新增表
create table res_residual_strategy
(
  id                varchar(50)    not null
    primary key,
  name              varchar(100)   null,
  status            varchar(50)    null,
  strategydesc      varchar(200)   null
  comment '策略描述',
  code              varchar(50)    null
  comment '未使用',
  residualvaluerate decimal(10, 2) null
  comment '残值率，-1则使用资产设置的残值',
  depreciationrate  decimal(10, 2) null
  comment '折旧率',
  valuestr          varchar(100)   null,
  mark              varchar(500)   null,
  dr                varchar(1)     null,
  create_time       datetime       null,
  create_by         varchar(50)    null,
  update_time       datetime       null,
  update_by         varchar(50)    null
);


2.新增表
create table res_residual
(
  id                varchar(50)    not null
    primary key,
  uuid              varchar(50)    null,
  title             varchar(100)   null,
  residualvaluerate decimal(10, 2) null,
  depreciationrate  decimal(10, 2) null,
  valuestr          varchar(100)   null,
  status            varchar(50)    null,
  checkstatus       varchar(50)    null,
  strategyid        varchar(50)    null,
  processuserid     varchar(50)    null,
  processusername   varchar(100)   null,
  processdate       datetime       null,
  mark              varchar(100)   null,
  cnt               decimal        null,
  busidate          date           null,
  dr                varchar(1)     null,
  create_time       datetime       null,
  create_by         varchar(50)    null,
  update_time       datetime       null,
  update_by         varchar(50)    null
);

3.新增表
create table res_residual_item
(
  id               varchar(50)    not null
    primary key,
  uuid             varchar(50)    null,
  resid            varchar(50)    null,
  checkstatus      varchar(50)    null,
  curresidualvalue decimal(10, 2) null,
  buyprice         decimal(10, 2) null,
  bnetworth        decimal(10, 2) null,
  anetworth        decimal(10, 2) null,
  lossprice        decimal(10, 2) null,
  dr               varchar(1)     null,
  create_time      datetime       null,
  create_by        varchar(50)    null,
  update_time      datetime       null,
  update_by        varchar(50)    null
);


4.新增字典
res表新增字段
ALTER TABLE res ADD residualvalue decimal(10,2) DEFAULT 0 NULL;
ALTER TABLE res ADD usefullife varchar(50) NULL;
ALTER TABLE res ADD lastdepreciationdate date NULL;
ALTER TABLE res ADD accumulateddepreciation decimal(10,2) DEFAULT 0 NULL;

ALTER TABLE res_inventory_item ADD residualvalue decimal(10,2) DEFAULT 0 NULL;
ALTER TABLE res_inventory_item ADD usefullife varchar(50) NULL;
ALTER TABLE res_inventory_item ADD lastdepreciationdate date NULL;
ALTER TABLE res_inventory_item ADD accumulateddepreciation decimal(10,2) DEFAULT 0 NULL;

ALTER TABLE res_inventory_item_s ADD residualvalue decimal(10,2) DEFAULT 0 NULL;
ALTER TABLE res_inventory_item_s ADD usefullife varchar(50) NULL;
ALTER TABLE res_inventory_item_s ADD lastdepreciationdate date NULL;
ALTER TABLE res_inventory_item_s ADD accumulateddepreciation decimal(10,2) DEFAULT 0 NULL;

5.新增数据字典。
zcusefullife


6.新增菜单
略