说明 / 示例
# 1. 维度表
SELECT * from t_dim_object where NAME='外埠交通费';
展示: e040780f2ba911ea9f571339acaed3e5
# 2. 插入类型表
SELECT * FROM t_travel_schedule_expense_type
## 2.1 搜集信息
Traffic_市内交通费_Traffic
OutsideTraffic_外埠交通费_Outside Traffic
## 2.2 搜集出发城市，到达城市
出发城市 DEF_CFCS_004
到达城市 DEF_DDCS_004
INSERT INTO T_TRAVEL_SCHEDULE_EXPENSE_TYPE(ID,SCHEDULE_TYPE,AMOUNT_TYPE,EXPENSE_TYPE_ID,REF_DISPLAY_DATA,BX_DISPLAY_DATA,CREATE_DATE,UPDATE_DATE,REF_DISPLAY_TITLE,BX_DISPLAY_TITLE)
values('e040780f2ba911ea9f571339acaed3e5','OTHER','OutsideTraffic','e040780f2ba911ea9f571339acaed3e5','<li> {expenseType} | {START_DATE}至{END_DATE} </li> <li>出行人：{TRIP_PERSON} </li> <li>说明：{DESCRIPTION} </li>','','2019-12-31','2019-12-31','{DEF_CFCS_004}→{DEF_DDCS_004}','{DEF_CFCS_004}→{DEF_DDCS_004}');
T_TRAVEL_SCHEDULE_EXPENSE_FD