账单查询

  • 接口：common/bill/findByCondition
  • Method：GET
  • 接口说明：根据条件查询账单信息

参数

请求参数

字段名称 字段类型 字段描述 是否必填 长度限制(字节)
source String 渠道 FALSE 无
source_type String 账单类型 FALSE 无
bill_code_list List<String> 账单编码集合 FALSE 无
check_status Integer 对账状态 FALSE 无
enabled_flag String 启用标识 FALSE 无
order_id_list List<String> 订单号集合 FALSE 无
start_datetime Date 订单时间范围 FALSE 无
end_datetime Date 订单时间范围 FALSE 无

返回参数

字段名称 字段类型 字段描述
resCode Integer 响应状态码（见附录）
resMsg String 返回信息描述
data List<BillInfoVo> 账单信息

BillInfoVo

字段名称 字段类型 字段描述
source String 渠道
bill_code String 账单编码
bill_name String 账单名称
start_date Date 账单起始时间
end_date Date 账单结束时间
source_type String 账单类型
check_batch_no String 账单批次号
total_amount BigDecimal 总金额
total_company_pay BigDecimal 总支付金额
branch_code String 公司编码
branch_name String 公司名称
remarks String 备注
total_service_price BigDecimal 总服务费
enabled_flag String 启用标识
bill_line_list BillLineVo 账单行信息

BillLineVo

字段名称 字段类型 字段描述
order_id String 订单号
bill_line_no String 账单行号
start_date_time Date 开始时间
end_date_time Date 结束时间
order_date Date 订单时间
branch_code String 公司编码
branch_name String 公司名称
department_code String 部门编码
department_name String 部门名称
cost_center_code String 成本中心编码
cost_center_name String 成本中心名称
amount BigDecimal 总金额
company_pay BigDecimal 公司支付金额
person_pay BigDecimal 个人支付金额
service_price BigDecimal 服务费
passenger_name String 出行人
employee_number String 员工号
journey_id String 第三方申请单id
document_num String 申请单号
description String 描述
remarks String 备注
price BigDecimal 单价
unit_price BigDecimal 最低价
quantity Integer 数量
price 1~20 BigDecimal 扩展金额字段
column 1~50 String 扩展字段

示例：

请求数据

{
  "source": "dttrip",
  "bill_code_list": [
    "CA2407231533152675_flight",
    "CA2407231533152675_hotel"
  ],
  "start_datetime": 1724169600000,
  "end_datetime": 1724256000000
}

返回数据

{
  "resCode": 200000,
  "resMsg": "success",
  "data": [
    {
      "source": "dttrip",
      "bill_code": "CA2408211422427221_flight",
      "bill_name": "同程机票账单",
      "start_date": 1724054400000,
      "end_date": 1724140800000,
      "source_type": "flight",
      "check_batch_no": "dttrip-flight-CA2408211422427221",
      "total_amount": 9130.00,
      "total_service_price": 0.00,
      "enabled_flag": "Y",
      "bill_line_list": [
        {
          "amount": 1730.00,
          "remarks": "",
          "price": 1630.00,
          "quantity": 1,
          "order_id": "DF240821559857479",
          "bill_line_no": "IN2408211136572791A9",
          "start_date_time": 1724196600000,
          "end_date_time": 1724204400000,
          "order_date": 1724196600000,
          "service_price": 0.00,
          "passenger_name": "技术支持",
          "employee_number": "17812_213145",
          "journey_id": "REQ0000374265",
          "unit_price": 1630.00
        },
        {
          "amount": 1260.00,
          "remarks": "",
          "price": 1160.00,
          "quantity": 1,
          "order_id": "DF240821559861198",
          "bill_line_no": "IN24082111373951464A",
          "start_date_time": 1724209200000,
          "end_date_time": 1724217300000,
          "order_date": 1724209200000,
          "service_price": 0.00,
          "passenger_name": "技术支持",
          "employee_number": "17812_213145",
          "journey_id": "REQ0000374265",
          "unit_price": 1160.00
        },
        {
          "amount": 750.00,
          "remarks": "",
          "price": 650.00,
          "quantity": 1,
          "order_id": "DF240821559863891",
          "bill_line_no": "IN2408211138055601CD",
          "start_date_time": 1724216700000,
          "end_date_time": 1724224500000,
          "order_date": 1724216700000,
          "service_price": 0.00,
          "passenger_name": "技术支持",
          "employee_number": "17812_213145",
          "journey_id": "REQ0000374265",
          "unit_price": 650.00
        },
        {
          "amount": 1000.00,
          "remarks": "",
          "price": 900.00,
          "quantity": 1,
          "order_id": "DF240821559877495",
          "bill_line_no": "IN240821115831663492",
          "start_date_time": 1724267100000,
          "end_date_time": 1724276400000,
          "order_date": 1724267100000,
          "service_price": 0.00,
          "passenger_name": "技术支持",
          "employee_number": "17812_213145",
          "journey_id": "REQ0000374265",
          "unit_price": 900.00
        },
        {
          "amount": 820.00,
          "remarks": "",
          "price": 720.00,
          "quantity": 1,
          "order_id": "DF240821559879272",
          "bill_line_no": "IN2408211159432214C1",
          "start_date_time": 1724297100000,
          "end_date_time": 1724297100000,
          "order_date": 1724267100000,
          "service_price": 0.00,
          "passenger_name": "技术支持",
          "employee_number": "17812_213145",
          "journey_id": "REQ0000374265",
          "unit_price": 720.00
        },
        {
          "amount": 750.00,
          "remarks": "",
          "price": 650.00,
          "quantity": 1,
          "order_id": "DF240821559897264",
          "bill_line_no": "IN24082114065465522E",
          "start_date_time": 1724341800000,
          "end_date_time": 1724350500000,
          "order_date": 1724341800000,
          "service_price": 0.00,
          "passenger_name": "技术支持",
          "employee_number": "17812_213145",
          "journey_id": "REQ0000374265",
          "unit_price": 650.00
        },
        {
          "amount": 1050.00,
          "remarks": "",
          "price": 950.00,
          "quantity": 1,
          "order_id": "DF240821559912365",
          "bill_line_no": "IN240821140913755237",
          "start_date_time": 1724354700000,
          "end_date_time": 1724362800000,
          "service_price": 0.00,
          "passenger_name": "技术支持",
          "employee_number": "17812_213145",
          "journey_id": "REQ0000374265",
          "unit_price": 950.00
        },
        {
          "amount": 670.00,
          "remarks": "",
          "price": 570.00,
          "quantity": 1,
          "order_id": "DF240821559914928",
          "bill_line_no": "IN240821141018924525",
          "start_date_time": 1724428200000,
          "end_date_time": 1724436900000,
          "service_price": 0.00,
          "passenger_name": "技术支持",
          "employee_number": "17812_213145",
          "journey_id": "REQ0000374265",
          "unit_price": 570.00
        },
        {
          "amount": 600.00,
          "remarks": "",
          "price": 500.00,
          "quantity": 1,
          "order_id": "DF240821559916851",
          "bill_line_no": "IN24082114122075546C",
          "start_date_time": 1724472000000,
          "end_date_time": 1724479800000,
          "service_price": 0.00,
          "passenger_name": "技术支持",
          "employee_number": "17812_213145",
          "journey_id": "REQ0000374265",
          "unit_price": 500.00
        },
        {
          "amount": 500.00,
          "remarks": "",
          "price": 400.00,
          "quantity": 1,
          "order_id": "DF240821559920119",
          "bill_line_no": "IN240821141321883760",
          "start_date_time": 1724480100000,
          "end_date_time": 1724487900000,
          "service_price": 0.00,
          "passenger_name": "技术支持",
          "employee_number": "17812_213145",
          "journey_id": "REQ0000374265",
          "unit_price": 400.00
        }
      ]
    }
  ]
}

results matching ""

    No results matching ""