正式环境数据库修正
# 2020-02-19
## 问题描述
拉取结算单错误
## 问题解决方案
云快报修正：
错误类型：代码错误
### 修正1；
```sql
UPDATE T_BO_TRAVEL_DETAIL SET COMPANY_AMOUNT = 400 ,TOTAL_AMOUNT = 400 WHERE ORDER_ID = '1579485052323804813'
```
```
02fcbd913b2811ea87066b2220548651 1 b73b5caf42e711e98d74c7de3a573203 0090a28cf60c11e98f613759ef46af6c 280fbd37f62a11e98f61033c678fe753 e660d320384711ea87064d4da8eb7e60 BO_DIM_1356D618DD3E0 8309623fbe1911e8811753ce08480ca3 1 02fcbd913b2811ea87066b2220548651 ACTIVED 1.0 2020-01-20 2020-01-20 1579485052323804813 bb02dd5fdda511e984f461a3b5177bce TFJZ-202001200002 13811508780 0.000000 6e589eb2dd9f11e8b5a69590a14a4e34 1200.000000 6e589eb2dd9f11e8b5a69590a14a4e34 0.000000 6e589eb2dd9f11e8b5a69590a14a4e34 1200.000000 6e589eb2dd9f11e8b5a69590a14a4e34 1200.000000 6e589eb2dd9f11e8b5a69590a14a4e34 986e5a3c-4f91-434b-ac2e-bc90474b77b7 杨芳芳 13811508780 2020-02-05 2020-02-05 0.000000 6e589eb2dd9f11e8b5a69590a14a4e34 BOOK YKB Y 0.000000 6e589eb2dd9f11e8b5a69590a14a4e34 北京 哈尔滨 NON_SETTLEMENT 南方航空 CZ6204 R 折扣经济舱 首都国际机场 太平国际机场 0.000000 6e589eb2dd9f11e8b5a69590a14a4e34 0.000000 6e589eb2dd9f11e8b5a69590a14a4e34 116.670000 6e589eb2dd9f11e8b5a69590a14a4e34 2.3 ["784-1481933692"] 0.000000 6e589eb2dd9f11e8b5a69590a14a4e34 116.670000 6e589eb2dd9f11e8b5a69590a14a4e34 0.000000 6e589eb2dd9f11e8b5a69590a14a4e34 FLIGHT 0.000000 6e589eb2dd9f11e8b5a69590a14a4e34 350.000000 6e589eb2dd9f11e8b5a69590a14a4e34 116.670000 6e589eb2dd9f11e8b5a69590a14a4e34 16.670000 6e589eb2dd9f11e8b5a69590a14a4e34 Y 单程 0.000000 6e589eb2dd9f11e8b5a69590a14a4e34 CCSQ202001200001 杨芳芳 2020-01-20 09:54:45 202001 2019年财小V “中国舆论场”项目组 企业自筹 3c2d2162db5e11e984f495bd0cdce4b9 b6f7ddd3f58a11e98f611f6c95ddabe4 1579485052323804813 央视网国际网络有限公司
034fe6ae3b2811ea8706bf25862e889a 1 b73b5caf42e711e98d74c7de3a573203 0090a28cf60c11e98f613759ef46af6c 280fbd37f62a11e98f61033c678fe753 e660d320384711ea87064d4da8eb7e60 BO_DIM_1356D81D4587D 8309623fbe1911e8811753ce08480ca3 1 034fe6ae3b2811ea8706bf25862e889a ACTIVED 1.0 2020-01-20 2020-01-20 1579485052323804813 bb02dd5fdda511e984f461a3b5177bce TFJZ-202001200002 13811508780 0.000000 6e589eb2dd9f11e8b5a69590a14a4e34 1200.000000 6e589eb2dd9f11e8b5a69590a14a4e34 0.000000 6e589eb2dd9f11e8b5a69590a14a4e34 1200.000000 6e589eb2dd9f11e8b5a69590a14a4e34 1200.000000 6e589eb2dd9f11e8b5a69590a14a4e34 0b8b27b2-509f-4eb2-9acd-fa6455d05f7f 于德志 18850078863 2020-02-05 2020-02-05 0.000000 6e589eb2dd9f11e8b5a69590a14a4e34 BOOK YKB Y 0.000000 6e589eb2dd9f11e8b5a69590a14a4e34 北京 哈尔滨 NON_SETTLEMENT 南方航空 CZ6204 R 折扣经济舱 首都国际机场 太平国际机场 0.000000 6e589eb2dd9f11e8b5a69590a14a4e34 0.000000 6e589eb2dd9f11e8b5a69590a14a4e34 116.670000 6e589eb2dd9f11e8b5a69590a14a4e34 2.3 ["784-1481933693"] 0.000000 6e589eb2dd9f11e8b5a69590a14a4e34 116.670000 6e589eb2dd9f11e8b5a69590a14a4e34 0.000000 6e589eb2dd9f11e8b5a69590a14a4e34 FLIGHT 0.000000 6e589eb2dd9f11e8b5a69590a14a4e34 350.000000 6e589eb2dd9f11e8b5a69590a14a4e34 116.670000 6e589eb2dd9f11e8b5a69590a14a4e34 16.670000 6e589eb2dd9f11e8b5a69590a14a4e34 Y 单程 0.000000 6e589eb2dd9f11e8b5a69590a14a4e34 CCSQ202001200001 杨芳芳 2020-01-20 09:54:45 202001 2019年财小V “中国舆论场”项目组 企业自筹 3c2d2162db5e11e984f495bd0cdce4b9 b6f7ddd3f58a11e98f611f6c95ddabe4 1579485052323804813 央视网国际网络有限公司
03a46f5b3b2811ea8706e716b2b85e9f 1 b73b5caf42e711e98d74c7de3a573203 0090a28cf60c11e98f613759ef46af6c 280fbd37f62a11e98f61033c678fe753 e660d320384711ea87064d4da8eb7e60 BO_DIM_1356DA2ED263F 8309623fbe1911e8811753ce08480ca3 1 03a46f5b3b2811ea8706e716b2b85e9f ACTIVED 1.0 2020-01-20 2020-01-20 1579485052323804813 bb02dd5fdda511e984f461a3b5177bce TFJZ-202001200002 13811508780 0.000000 6e589eb2dd9f11e8b5a69590a14a4e34 1200.000000 6e589eb2dd9f11e8b5a69590a14a4e34 0.000000 6e589eb2dd9f11e8b5a69590a14a4e34 1200.000000 6e589eb2dd9f11e8b5a69590a14a4e34 1200.000000 6e589eb2dd9f11e8b5a69590a14a4e34 76938ac9-a92d-4380-9dfc-49e98c4953aa 李卓亚 13161954269 2020-02-05 2020-02-05 0.000000 6e589eb2dd9f11e8b5a69590a14a4e34 BOOK YKB Y 0.000000 6e589eb2dd9f11e8b5a69590a14a4e34 北京 哈尔滨 NON_SETTLEMENT 南方航空 CZ6204 R 折扣经济舱 首都国际机场 太平国际机场 0.000000 6e589eb2dd9f11e8b5a69590a14a4e34 0.000000 6e589eb2dd9f11e8b5a69590a14a4e34 116.670000 6e589eb2dd9f11e8b5a69590a14a4e34 2.3 ["784-1481933691"] 0.000000 6e589eb2dd9f11e8b5a69590a14a4e34 116.670000 6e589eb2dd9f11e8b5a69590a14a4e34 0.000000 6e589eb2dd9f11e8b5a69590a14a4e34 FLIGHT 0.000000 6e589eb2dd9f11e8b5a69590a14a4e34 350.000000 6e589eb2dd9f11e8b5a69590a14a4e34 116.670000 6e589eb2dd9f11e8b5a69590a14a4e34 16.670000 6e589eb2dd9f11e8b5a69590a14a4e34 Y 单程 0.000000 6e589eb2dd9f11e8b5a69590a14a4e34 CCSQ202001200001 杨芳芳 2020-01-20 09:54:45 202001 2019年财小V “中国舆论场”项目组 企业自筹 3c2d2162db5e11e984f495bd0cdce4b9 b6f7ddd3f58a11e98f611f6c95ddabe4 1579485052323804813 央视网国际网络有限公司
```
### 修正2：
原始数据
更新数据
```sql
UPDATE T_BO_TRAVEL_DETAIL
SET COMPANY_AMOUNT = -325,
TOTAL_AMOUNT = -325
WHERE
ORDER_ID = '34202001161143310013'
AND
BUSINESS_TYPE = 'REFUNED'
```
### 修正3：
```sql
SETTLE_ORDER_ID ORDER_AMOUNT SUPPLIER_AMOUNT
1581391607393312773 3600.000000 1200.000000
1581391607486560588 0.000000 1530.000000
1581391607531045632 0.000000 1530.000000
1581391607620600838,1581391607681606536 0.000000 650.000000
```
```sql
UPDATE T_BO_SETTLE_ORDER SET ORDER_AMOUNT = 1530 WHERE SETTLE_ORDER_ID = '1581391607486560588';
UPDATE T_BO_SETTLE_ORDER SET ORDER_AMOUNT = 1530 WHERE SETTLE_ORDER_ID = '1581391607531045632';
UPDATE T_BO_SETTLE_ORDER SET ORDER_AMOUNT = 1200 WHERE SETTLE_ORDER_ID = '1581391607393312773';
UPDATE T_BO_SETTLE_ORDER SET SUPPLIER_AMOUNT = 0 WHERE SETTLE_ORDER_ID = '1581391607620600838,1581391607681606536';
```
明细表更新
```sql
UPDATE T_BO_TRAVEL_DETAIL
SET
COMPANY_AMOUNT = 400 ,
TOTAL_AMOUNT = 400 ,
STATIS_AMOUNT = 400,
AIRPORT_FEE = 50,
NET_TRANS_PRICE = 350,
FACE_PRICE = 350
WHERE
ORDER_ID = '1579485052323804813' ;
UPDATE T_BO_TRAVEL_DETAIL
SET
COMPANY_AMOUNT = -325 ,
TOTAL_AMOUNT = -325 ,
STATIS_AMOUNT = -325
WHERE ID='f380b0c9381411ea870649e17401203b';
UPDATE T_BO_TRAVEL_DETAIL
SET
COMPANY_AMOUNT = 325 ,
TOTAL_AMOUNT = 325 ,
STATIS_AMOUNT = 325
WHERE ID='8e2bf212381311ea8706a1c7a363ba47';
UPDATE T_BO_TRAVEL_DETAIL SET AMOUNT =325 , AVERAGE_PRICE = 325 WHERE ID = 'f380b0c9381411ea870649e17401203b';
UPDATE T_BO_TRAVEL_DETAIL SET OUT_STANDARD = 'N';
UPDATE T_BO_TRAVEL_DETAIL SET CIVIL_SERVANT = 'N';
--- 弃用
UPDATE t_bo_data SET JSON_DATA = '{"afterCommit":false,"appId":"b73b5caf42e711e98d74c7de3a573203","area":{"boAreaCode":"T_BO_TRAVEL_DETAIL","boAreaId":"0092ec80f60c11e98f61b5d8b562a185","boAreaName":"商旅消费明细主表","rowDatas":[{"datas":{"END_CITY_NAME":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"哈尔滨"},"FLIGHT_NUM":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"CZ6204"},"USER_MOBILE":{"dataAttribute":"DEFAULT","dataType":"MTEXT","value":"13811508780"},"USER_ID":{"dataAttribute":"DEFAULT","dataType":"MTEXT","value":"986e5a3c-4f91-434b-ac2e-bc90474b77b7"},"TOTAL_AMOUNT_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"STATIS_AMOUNT":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":400.0000,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"CREATOR_ID":{"dataAttribute":"DEFAULT","dataType":"PERSON","value":{"title":{},"value":"8309623fbe1911e8811753ce08480ca3"}},"SEAT_POINT_NAME":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"折扣经济舱"},"TICKET_NO":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"[\\"784-1481933692\\"]"},"APPLI_DEPART_ID":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"b6f7ddd3f58a11e98f611f6c95ddabe4"},"ID":{"dataType":"STEXT","value":"02fcbd913b2811ea87066b2220548651"},"MIN_PRICE_FLIGHT":{"dataAttribute":"DEFAULT","dataType":"MTEXT"},"CIVIL_SERVANT":{"dataAttribute":"DEFAULT","dataType":"ENUM","value":{"title":{"zh_CN":"是"},"value":"Y"}},"FACILITATOR_CODE":{"dataAttribute":"DEFAULT","dataType":"ENUM","value":{"title":{"zh_CN":"云快报"},"value":"YKB"}},"SERVICE_PRICE_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"BIZ_VERSION":{"dataType":"NUMBER","value":1.0},"EA_BILL_CODE":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"TFJZ-202001200002"},"CHANNEL":{"dataAttribute":"DEFAULT","dataType":"STEXT"},"GROUP1_NAME":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"企业自筹"},"TOTAL_AMOUNT":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":400.0000,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"END_AIRPORT_NAME":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"太平国际机场"},"DELIVERY_FEE":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":0,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"CARD_SWIPE_FEE":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":0.00,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"INSURE_FEE":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":0,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"BO_TYPE_DEFINE_ID":{"dataAttribute":"DEFAULT","dataType":"DROPDOWN","value":{"title":{"zh_CN":"机票消费明细"},"value":"280fbd37f62a11e98f61033c678fe753"}},"AGREE_PRICE_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"COMPANY_AMOUNT_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"POLICY_MIN_PRICE":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":116.67,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"FACE_PRICE_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"BUSINESS_TYPE":{"dataAttribute":"DEFAULT","dataType":"ENUM","value":{"title":{"zh_CN":"预订"},"value":"BOOK"}},"ITINERARY_FEE":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":0.00,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"FUEL_TAX_PRICE_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"PROJECT_ID":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"3c2d2162db5e11e984f495bd0cdce4b9"},"APP_ID":{"dataType":"STEXT","value":"b73b5caf42e711e98d74c7de3a573203"},"DEDUCTION_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"ORDER_TYPE":{"dataAttribute":"DEFAULT","dataType":"ENUM","value":{"title":{"zh_CN":"国内机票"},"value":"FLIGHT"}},"START_DATE":{"dataAttribute":"DEFAULT","dataType":"DATE","value":"2020-02-05 09:05:00.000"},"USER_NAME":{"dataAttribute":"DEFAULT","dataType":"MTEXT","value":"杨芳芳"},"START_CITY_NAME":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"北京"},"BOOK_USER_NAME":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"杨芳芳"},"FLIGHT_TYPE":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"单程"},"NET_TRANS_PRICE_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"AGREE_PRICE":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":0,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"ACC_COMPANY_NAME":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"央视网国际网络有限公司"},"Y_PRICE":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":0.00,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"VERSION":{"dataType":"NUMBER","value":1},"BOOK_SOURCE":{"dataAttribute":"DEFAULT","dataType":"STEXT"},"ACC_COMPANY_ID":{"dataAttribute":"DEFAULT","dataType":"DROPDOWN","value":{"title":{"zh_CN":"央视网国际网络有限公司"},"value":"bb02dd5fdda511e984f461a3b5177bce"}},"VIOLATION_CODE":{"dataAttribute":"DEFAULT","dataType":"STEXT"},"ACCOUNT_PERIOD":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"202001"},"PERSON_AMOUNT_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"UPDATE_DATE":{"dataType":"DATE","value":"2020-01-20T09:56:02.521"},"BOOK_EMP_NO":{"dataAttribute":"DEFAULT","dataType":"STEXT"},"END_DATE":{"dataAttribute":"DEFAULT","dataType":"DATE","value":"2020-02-05 11:05:00.000"},"MILEAGE":{"dataAttribute":"DEFAULT","dataType":"STEXT"},"SERVICE_PRICE":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":0.00,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"OUT_STANDARD":{"dataAttribute":"DEFAULT","dataType":"ENUM","value":{"title":{"zh_CN":"是"},"value":"Y"}},"APPLI_DEPART_NAME":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"“中国舆论场”项目组"},"INSURE_FEE_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"START_AIRPORT_NAME":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"首都国际机场"},"STATUS":{"dataType":"ENUM","value":{"title":{"zh_CN":"生效"},"value":"ACTIVED"}},"NET_TRANS_PRICE":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":350.00,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"EMP_NO":{"dataAttribute":"DEFAULT","dataType":"MTEXT"},"COMPANY_AMOUNT":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":400.0000,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"DAY_MIN_PRICE":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":350.0000,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"BO_TYPE_DEFINE_HISTORY_ID":{"dataType":"STEXT","value":"e660d320384711ea87064d4da8eb7e60"},"COST_CODE":{"dataAttribute":"DEFAULT","dataType":"MTEXT"},"SOURCE_BIZ_VERSION_ID":{"dataType":"STEXT"},"DEDUCTION":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":0.00,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"BO_DATA_ID":{"dataType":"STEXT","value":"02fcbd913b2811ea87066b2220548651"},"FUEL_TAX_PRICE":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":0.00,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"CREATE_DATE":{"dataType":"DATE","value":"2020-01-20T09:56:02.521"},"REF_BILL_CODE":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"CCSQ202001200001"},"VIOLATION_REASON":{"dataAttribute":"DEFAULT","dataType":"MTEXT"},"STATIS_AMOUNT_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"SETTLEMENT_FLAG":{"dataAttribute":"DEFAULT","dataType":"ENUM","value":{"title":{"zh_CN":"未对账"},"value":"NON_SETTLEMENT"}},"AIRPORT_FEE":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":50.00,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"BOOK_ORG_STRUCT_1":{"dataAttribute":"DEFAULT","dataType":"STEXT"},"BOOK_ORG_STRUCT_2":{"dataAttribute":"DEFAULT","dataType":"STEXT"},"BOOK_ORG_STRUCT_3":{"dataAttribute":"DEFAULT","dataType":"STEXT"},"POLICY_MIN_PRICE_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"FLIGHT_COMP_NAME":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"南方航空"},"BUSINESS_DATE":{"dataAttribute":"DEFAULT","dataType":"DATE","value":"2020-01-20 09:54:45.000"},"PROJECT_NAME":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"2019年财小V"},"AGREEMENT_DISC":{"dataAttribute":"DEFAULT","dataType":"STEXT"},"PERSON_AMOUNT":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":0.00,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"AIRPORT_FEE_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"BO_DEFINE_ID":{"dataType":"STEXT","value":"0090a28cf60c11e98f613759ef46af6c"},"FACE_PRICE":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":350.00,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"SUPP_ORIG_ORDER_ID":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"1579485052323804813"},"Y_PRICE_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"SEAT_DISCOUNT":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"2.3"},"DAY_MIN_PRICE_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"ITINERARY_FEE_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"ROW_NUM":{"dataType":"NUMBER","value":1},"SEAT_POINT_CLASS":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"R"},"BOOK_USER_MOBILE":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"13811508780"},"CARD_SWIPE_FEE_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"CODE":{"dataType":"STEXT","value":"BO_DIM_1356D618DD3E0"},"TRIP_PURPOSE":{"dataAttribute":"DEFAULT","dataType":"MTEXT"},"ORDER_ID":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"1579485052323804813"},"DELIVERY_FEE_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"reserve":false,"rowId":"02fcbd913b2811ea87066b2220548651","rowNum":1,"subAreaDatas":{}}]},"areaTemplateRow":{"0092ec80f60c11e98f61b5d8b562a185":{"datas":{"END_CITY_NAME":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"哈尔滨"},"FLIGHT_NUM":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"CZ6204"},"USER_MOBILE":{"dataAttribute":"DEFAULT","dataType":"MTEXT","value":"13811508780"},"USER_ID":{"dataAttribute":"DEFAULT","dataType":"MTEXT","value":"986e5a3c-4f91-434b-ac2e-bc90474b77b7"},"TOTAL_AMOUNT_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"STATIS_AMOUNT":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":400.0000,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"CREATOR_ID":{"dataAttribute":"DEFAULT","dataType":"PERSON","value":{"title":{},"value":"8309623fbe1911e8811753ce08480ca3"}},"SEAT_POINT_NAME":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"折扣经济舱"},"TICKET_NO":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"[\\"784-1481933692\\"]"},"APPLI_DEPART_ID":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"b6f7ddd3f58a11e98f611f6c95ddabe4"},"ID":{"dataType":"STEXT","value":"02fcbd913b2811ea87066b2220548651"},"MIN_PRICE_FLIGHT":{"dataAttribute":"DEFAULT","dataType":"MTEXT"},"CIVIL_SERVANT":{"dataAttribute":"DEFAULT","dataType":"ENUM","value":{"title":{"zh_CN":"是"},"value":"Y"}},"FACILITATOR_CODE":{"dataAttribute":"DEFAULT","dataType":"ENUM","value":{"title":{"zh_CN":"云快报"},"value":"YKB"}},"SERVICE_PRICE_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"BIZ_VERSION":{"dataType":"NUMBER","value":1.0},"EA_BILL_CODE":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"TFJZ-202001200002"},"CHANNEL":{"dataAttribute":"DEFAULT","dataType":"STEXT"},"GROUP1_NAME":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"企业自筹"},"TOTAL_AMOUNT":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":400.0000,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"END_AIRPORT_NAME":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"太平国际机场"},"DELIVERY_FEE":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":0,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"CARD_SWIPE_FEE":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":0.00,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"INSURE_FEE":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":0,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"BO_TYPE_DEFINE_ID":{"dataAttribute":"DEFAULT","dataType":"DROPDOWN","value":{"title":{"zh_CN":"机票消费明细"},"value":"280fbd37f62a11e98f61033c678fe753"}},"AGREE_PRICE_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"COMPANY_AMOUNT_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"POLICY_MIN_PRICE":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":116.67,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"FACE_PRICE_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"BUSINESS_TYPE":{"dataAttribute":"DEFAULT","dataType":"ENUM","value":{"title":{"zh_CN":"预订"},"value":"BOOK"}},"ITINERARY_FEE":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":0.00,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"FUEL_TAX_PRICE_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"PROJECT_ID":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"3c2d2162db5e11e984f495bd0cdce4b9"},"APP_ID":{"dataType":"STEXT","value":"b73b5caf42e711e98d74c7de3a573203"},"DEDUCTION_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"ORDER_TYPE":{"dataAttribute":"DEFAULT","dataType":"ENUM","value":{"title":{"zh_CN":"国内机票"},"value":"FLIGHT"}},"START_DATE":{"dataAttribute":"DEFAULT","dataType":"DATE","value":"2020-02-05 09:05:00.000"},"USER_NAME":{"dataAttribute":"DEFAULT","dataType":"MTEXT","value":"杨芳芳"},"START_CITY_NAME":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"北京"},"BOOK_USER_NAME":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"杨芳芳"},"FLIGHT_TYPE":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"单程"},"NET_TRANS_PRICE_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"AGREE_PRICE":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":0,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"ACC_COMPANY_NAME":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"央视网国际网络有限公司"},"Y_PRICE":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":0.00,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"VERSION":{"dataType":"NUMBER","value":1},"BOOK_SOURCE":{"dataAttribute":"DEFAULT","dataType":"STEXT"},"ACC_COMPANY_ID":{"dataAttribute":"DEFAULT","dataType":"DROPDOWN","value":{"title":{"zh_CN":"央视网国际网络有限公司"},"value":"bb02dd5fdda511e984f461a3b5177bce"}},"VIOLATION_CODE":{"dataAttribute":"DEFAULT","dataType":"STEXT"},"ACCOUNT_PERIOD":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"202001"},"PERSON_AMOUNT_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"UPDATE_DATE":{"dataType":"DATE","value":"2020-01-20T09:56:02.521"},"BOOK_EMP_NO":{"dataAttribute":"DEFAULT","dataType":"STEXT"},"END_DATE":{"dataAttribute":"DEFAULT","dataType":"DATE","value":"2020-02-05 11:05:00.000"},"MILEAGE":{"dataAttribute":"DEFAULT","dataType":"STEXT"},"SERVICE_PRICE":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":0.00,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"OUT_STANDARD":{"dataAttribute":"DEFAULT","dataType":"ENUM","value":{"title":{"zh_CN":"是"},"value":"Y"}},"APPLI_DEPART_NAME":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"“中国舆论场”项目组"},"INSURE_FEE_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"START_AIRPORT_NAME":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"首都国际机场"},"STATUS":{"dataType":"ENUM","value":{"title":{"zh_CN":"生效"},"value":"ACTIVED"}},"NET_TRANS_PRICE":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":350.00,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"EMP_NO":{"dataAttribute":"DEFAULT","dataType":"MTEXT"},"COMPANY_AMOUNT":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":400.0000,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"DAY_MIN_PRICE":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":350.0000,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"BO_TYPE_DEFINE_HISTORY_ID":{"dataType":"STEXT","value":"e660d320384711ea87064d4da8eb7e60"},"COST_CODE":{"dataAttribute":"DEFAULT","dataType":"MTEXT"},"SOURCE_BIZ_VERSION_ID":{"dataType":"STEXT"},"DEDUCTION":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":0.00,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"BO_DATA_ID":{"dataType":"STEXT","value":"02fcbd913b2811ea87066b2220548651"},"FUEL_TAX_PRICE":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":0.00,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"CREATE_DATE":{"dataType":"DATE","value":"2020-01-20T09:56:02.521"},"REF_BILL_CODE":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"CCSQ202001200001"},"VIOLATION_REASON":{"dataAttribute":"DEFAULT","dataType":"MTEXT"},"STATIS_AMOUNT_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"SETTLEMENT_FLAG":{"dataAttribute":"DEFAULT","dataType":"ENUM","value":{"title":{"zh_CN":"未对账"},"value":"NON_SETTLEMENT"}},"AIRPORT_FEE":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":50.00,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"BOOK_ORG_STRUCT_1":{"dataAttribute":"DEFAULT","dataType":"STEXT"},"BOOK_ORG_STRUCT_2":{"dataAttribute":"DEFAULT","dataType":"STEXT"},"BOOK_ORG_STRUCT_3":{"dataAttribute":"DEFAULT","dataType":"STEXT"},"POLICY_MIN_PRICE_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"FLIGHT_COMP_NAME":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"南方航空"},"BUSINESS_DATE":{"dataAttribute":"DEFAULT","dataType":"DATE","value":"2020-01-20 09:54:45.000"},"PROJECT_NAME":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"2019年财小V"},"AGREEMENT_DISC":{"dataAttribute":"DEFAULT","dataType":"STEXT"},"PERSON_AMOUNT":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":0.00,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"AIRPORT_FEE_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"BO_DEFINE_ID":{"dataType":"STEXT","value":"0090a28cf60c11e98f613759ef46af6c"},"FACE_PRICE":{"dataAttribute":"DEFAULT","dataType":"MONEY","value":{"amount":350.00,"currencyId":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"SUPP_ORIG_ORDER_ID":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"1579485052323804813"},"Y_PRICE_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"SEAT_DISCOUNT":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"2.3"},"DAY_MIN_PRICE_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"ITINERARY_FEE_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"ROW_NUM":{"dataType":"NUMBER","value":1},"SEAT_POINT_CLASS":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"R"},"BOOK_USER_MOBILE":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"13811508780"},"CARD_SWIPE_FEE_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"},"CODE":{"dataType":"STEXT","value":"BO_DIM_1356D618DD3E0"},"TRIP_PURPOSE":{"dataAttribute":"DEFAULT","dataType":"MTEXT"},"ORDER_ID":{"dataAttribute":"DEFAULT","dataType":"STEXT","value":"1579485052323804813"},"DELIVERY_FEE_CURRENCY_ID":{"dataType":"STEXT","value":"6e589eb2dd9f11e8b5a69590a14a4e34"}},"reserve":false,"rowId":"02fcbd913b2811ea87066b2220548651","rowNum":1,"subAreaDatas":{}}},"bizVersion":1.0,"boDataId":"02fcbd913b2811ea87066b2220548651","boDefineId":"0090a28cf60c11e98f613759ef46af6c","boMainId":"02fcbd913b2811ea87066b2220548651","boType":"BO_TYPE","boTypeDefineHistoryId":"e660d320384711ea87064d4da8eb7e60","boTypeDefineId":"280fbd37f62a11e98f61033c678fe753","commit":false,"createNew":true,"languages":["zh_CN"],"operationType":"ADD","scene":"WRITE","status":"ACTIVED"}' WHERE BO_DATA_ID = '034fe6ae3b2811ea8706bf25862e889a'
```
结算明细来自于消费明细。
## 部署时间
[x] 数据库备份
[ ] 代码备份
[ ] 更新测试是否成功
[ ] 正式环境部署结果