商旅账单交易明细（未出账单）

请求地址

https://api.es.xiaojukeji.com/river/Bill/getNotGeneratedBillDetail

返回数据格式

JSON

请求方式

GET

请求格式

Content-type:application/x-www-form-urlencoded

请求参数

注意事项

1. 商旅品类的入账时间:
   • 机票起飞时间T+3；
   • 酒店预订时间T+1；
   • 火车票发车时间T+1；
2. 取数建议:建议每天获取前一天产生的未出账单数据,进行汇总;计算汇总金额（企业应付总金额）时，机票使用company_real_pay字段，酒店使用company_real_amount字段，火车票使用company_real_pay字段，对应字段若为正数，一般为该笔订单产生的支付费用，对应字段若为负数，一般为该笔订单产生的退款费用，如将相关字段值累加，可计算出汇总金额；

3.时间字段(标注时间格式)

4.枚举字段【枚举值1、枚举值2】

返回参数说明

返回结构

机票返回参数

酒店返回参数

火车票返回参数

返回示例

机票返回示例

{
    "errno":0,
    "errmsg":"成功",
    "data":{
        "detail_list":[
            {
                "added_goods_name":"",
                "airline_simple_name":"中国国航",
                "approval_history":"1970-01-20 20:30:42郑小莓(11100009102)郑小莓 提交给 郑小莓,1970-01-20 20:30:43郑小莓(11100009102)郑小莓 审批通过",
                "approval_id":"",
                "arrival_airport_code":"PEK",
                "arrival_airport_name":"首都机场",
                "arrival_city_name":"北京",
                "booking_date":"2023-06-13 15:58:49",
                "booking_dep_code":"5",
                "booking_dep_name":"优秀部门",
                "booking_member_name":"郑小莓",
                "booking_member_number":"",
                "booking_parent_path_dep_name":"机票测试专用751>优秀部门",
                "budget_center_code": "11111111111111112222222222222222",
                "budget_center_id":"1125915256313501",
                "budget_center_name":"高优项目",
                "budget_center_parent_path_name":"机票测试专用751>高优项目",
                "cabin_code":"Y",
                "cabin_name":"经济舱",
                "cabin_type":4,
                "change_handle_cost":"0.00",
                "company_real_pay":"2230.00",
                "construction_cost":"50.00",
                "create_time":"2023-06-13 15:58:49",
                "department":"优秀部门",
                "departure_airport_code":"SHA",
                "departure_airport_name":"虹桥机场",
                "departure_city_name":"上海",
                "departure_time":"2023-08-03 07:55:00",
                "discount":"全价",
                "ex_info_01":"",
                "ex_info_02":"",
                "ex_info_03":"",
                "extra_info":"",
                "final_offline_status":"",
                "flight_number":"CA1564",
                "flight_segment_number":1,
                "flight_segment_travel":"上海-北京",
                "flight_travel_type":0,
                "fuelCost":"30.00",
                "invoice_fee":"",
                "is_agreement":"否",
                "legal_entity_id":0,
                "legal_entity_name":"",
                "member_id":"1125913579793830",
                "order_fix_settle_time":"",
                "order_fix_type":0,
                "order_id":"1125921043266803",
                "origin_ticket_id":"1125921043263453",
                "out_requisition_id":"",
                "passenger_dep_code":"5",
                "passenger_dep_name":"优秀部门",
                "passenger_legal_entity_id":0,
                "passenger_legal_entity_name":"",
                "passenger_member_name":"郑小莓",
                "passenger_member_number":"",
                "passenger_name":"郑小莓",
                "passenger_parent_path_dep_name":"机票测试专用751>优秀部门",
                "pay_type":"企业支付",
                "pnr_number":"KZC7ZW",
                "pre_order_id":"0",
                "rc_book":"",
                "rc_level":"指定时段内只有全价票",
                "rc_lowPrice":"其他原因",
                "rc_time_period":"",
                "reason":"",
                "refund_handle_cost":"0.00",
                "remark":"{\"trip_purpose_id\":1125916448214228,\"trip_purpose_name\":\"选填备注\",\"trip_purpose_desc\":\"777\"}",
                "requisition_id":"",
                "service_fee":"0.00",
                "settle_time":"2023-07-19 17:48:19",
                "settlement_time":"2023-07-19 17:48:19",
                "sub_company_no":"",
                "supplier_order_id":"9999744643597",
                "supplier_ticket_number":"999-9744643597",
                "ticket_fee":"2150.00",
                "ticket_id_text":"",
                "total_fee":"2230.00",
                "transaction_type":0,
                "travel_itinerary_fee":"",
                "travel_purpose":"选填备注",
                "trip_description":"777",
                "trip_reason":"",
                "unique_key":"1125921043263453-0",
                "upgrade_cost":"0.00"
            }
        ],
        "last_id":"1125916596803691",
        "total":3
    },
    "request_id":"i+2SqRl3AckuERVKCDQCxv7QOoDdSR8dvMJt40Yofdo3Gg/Q6+nBOYXgTGLKCVBS"
}

酒店返回示例

{
    "errno":0,
    "errmsg":"成功",
    "data":{
        "detail_list":[
            {
                "amount":11,
                "approval_first":"",
                "approval_history":"",
                "approval_second":"",
                "approval_third":"",
                "book_day_number":1,
                "booking_date":"2023-07-06 15:49:51",
                "booking_dep_code":"1",
                "booking_dep_id":"1125912517768689",
                "booking_dep_name":"白全岭测试公司01",
                "booking_member_name":"任希望账号",
                "booking_member_number":"",
                "booking_parent_path_dep_name":"白全岭测试公司01",
                "budget_center_code": "11111111111111112222222222222222",
                "budget_center_id":"1125917802931722",
                "budget_center_name":"项目二测试",
                "budget_center_parent_path_name":"白全岭测试公司01>项目二测试",
                "check_in_date":"2023-07-10",
                "check_in_dep_code":"",
                "check_in_dep_id":"null",
                "check_in_dep_name":"",
                "check_in_member_departments":"",
                "check_in_member_numbers":"",
                "check_in_names":"任希望账号",
                "check_in_path_dep_name":"",
                "check_out_date":"2023-07-11",
                "city_name":"达州市",
                "company_coupon_cost":0,
                "company_pay_type":"消费",
                "company_real_amount":31,
                "cost_discount_before":11,
                "department":"",
                "ex_info_01":"",
                "ex_info_02":"",
                "ex_info_03":"",
                "extra_info":"",
                "hotel_name":"预发测试批量北京二号店",
                "hotel_type":"会员酒店",
                "is_vat":"",
                "legal_entity_id":0,
                "legal_entity_name":"",
                "member_id":"",
                "order_id":"1125921644738477",
                "order_source":"企业APP",
                "order_status":"预订成功",
                "order_type":"已支付",
                "original_check_out_date":"2023-07-11",
                "out_requisition_id":"",
                "passenger_legal_entity_id":0,
                "passenger_legal_entity_name":"",
                "passenger_name":"任希望账号",
                "pay_type":"企业支付",
                "personal_coupon_cost":0,
                "personal_real_pay":0,
                "personal_real_refund":0,
                "rc_agreed_price":"",
                "rc_book":"",
                "rc_level":"",
                "rc_low_price":"",
                "remark":"",
                "requisition_id":"",
                "room_num":1,
                "rooms":"批量房间二店一房",
                "service_fee":20,
                "settle_time":"2023-07-06 15:49:51",
                "tax_ratio":"",
                "total_nights":1,
                "travel_description":"",
                "travel_purpose":"",
                "trip_reason":"",
                "unique_key":"1125921644769704"
            }
        ],
        "last_id":"1125915323158472",
        "total":2
    },
    "request_id":"+xvHWIzBGl1lCfct0jtgZPFrgcHFmRGVshI3R+bE8sDGX4KYohw7YvmMR04kURc6"
}

火车票返回示例

{
    "errno":0,
    "errmsg":"成功",
    "data":{
        "detail_list":[
            {
                "abnormal":"",
                "booking_dep_code":"002",
                "booking_dep_id":1125915395595660,
                "booking_dep_name":"二级部门",
                "booking_member_id":1125913132972232,
                "booking_member_name":"姜秋羽",
                "booking_member_number":"D55979",
                "booking_parent_path_dep_name":"jqy火车票预发测试公司>二级部门",
                "budget_center_code":"11111111111111112222222222222222",
                "budget_center_id":0,
                "budget_center_name":"",
                "budget_center_parent_path_name":"",
                "change_extra_fee":0,
                "change_time":"",
                "company_real_pay":6.6,
                "end_time":"2023-07-12 20:17:00",
                "ex_info_01":"",
                "ex_info_02":"",
                "ex_info_03":"",
                "extra_info":"",
                "from_station_name":"北京西",
                "handing_extra_fee":0,
                "is_change":"否",
                "is_refund":"否",
                "legal_entity_id":0,
                "legal_entity_name":"",
                "order_id":"1125921462628506",
                "order_id_text":"",
                "order_pay":6.6,
                "order_time":"2023-06-30 19:35:27",
                "origin_ticket_id_text":"1125921462676355",
                "out_requisition_id":"",
                "passenger_dep_code":"002",
                "passenger_dep_id":1125915395595660,
                "passenger_dep_name":"二级部门",
                "passenger_legal_entity_id":0,
                "passenger_legal_entity_name":"",
                "passenger_member_id":1125913132972232,
                "passenger_member_name":"姜秋羽",
                "passenger_member_number":"D55979",
                "passenger_parent_path_dep_name":"jqy火车票预发测试公司>二级部门",
                "pay_type":"企业支付",
                "person_handing_extra_fee":0,
                "person_real_pay":0,
                "person_ticket_price":0,
                "rc_change_level":"",
                "rc_normal_level":"",
                "refund_extra_fee":0,
                "refund_fee":0,
                "refund_time":"",
                "remark":"",
                "requisition_id":"1125920664820915",
                "seat_level":"二等座",
                "seat_name":"二等座",
                "service_fee":0.6,
                "settle_time":"2023-07-19 17:48:19",
                "start_time":"2023-07-12 19:40:00",
                "stub_pay":6,
                "ticket_id_text":"",
                "ticket_price":6,
                "to_station_name":"通州",
                "total_handing_extra_fee":0,
                "total_ticket_price":6,
                "train_code":"S109",
                "transaction_type":"出票",
                "travel_purpose":"case2",
                "trip_description":"",
                "trip_reason":"航天多人",
                "unique_key":"1125921462676355-0"
            }
        ],
        "last_id":"1125915318678169",
        "total":2
    },
    "request_id":"+xvHWIzBGl0Nk2ZBzRSb87XiuHUuOzoyqM9M7hul4SQlXoHpQgwE12KbcJhYrlHM"
}