说明 / 示例
# 1.查询管理
## 1.1 发票余额台账
# 2.合同管理
## 合同信息管理
### 数据展示
搜合同编号
搜合同名称
t_bo_main_area_htd_def_002
t_bo_main_extend_htd_def_002
### 清库执行：
DELETE FROM T_BO_DATA where ID IN(SELECT ID FROM t_bo_main_area_htd_def_002);
DELETE FROM T_BO_DATA where ID IN(SELECT ID FROM t_bo_main_extend_htd_def_002);
DELETE FROM t_bo_main_area_htd_def_002;
DELETE FROM t_bo_main_extend_htd_def_002;
# 台账：
系统内置字段，目前无法修正。
# 凭证视图：
# 商旅
## 1.消费明细
DELETE FROM T_BO_TRAVEL_DETAIL
## 2.订单监控
delete from T_TRAVEL_ORDER_RECORD;
## 3.结算明细
DELETE from t_bo_settle_order;
## 3.机场明细：
DELETE FROM T_BO_TRAVEL_DETAIL
## 4.结算单
DELETE from t_bo_settlement;