单据查询

• 接口：plugin/claim/{companyCode}
• Method：POST
• 数据格式：JSON
• 接口说明：

  • 警告: 该接口不再迭代, 仅做老项目运维,

  • 新建项目和对接请勿使用该接口, 移步使用单据单张详情查询口

  • companyCode为自定义字符串，需定制开发配置
  • status为单个单据状态，statuses为单据状态列表，优先级为status > statuses > 都不传(此时查询非deleted和cancelled状态的单据)
  • date_field_name的取值有:
    • 提交时间submit_date / 开始时间start_datetime / 结束时间end_datetime
    • 业务审批通过时间preapproved_date / 财务审核通过时间checked_date / 审批通过时间approved_date
    • 关闭时间closed_date / 支付日期payment_date / 实际支付日期actual_payment_date
    • 创建时间creation_date / 最近更新时间last_update_date

参数

请求参数

返回参数

返回头参数

以下字段在 data 路径下返回

返回行参数

以下字段在 data.page_info.claim_lines 路径下返回

其余参数

以下字段在 data.page_info 路径下返回

示例

请求示例

{
    "page_size": 100,
    "page_num": 1,
    "start_datetime": 1613995160000,
    "end_datetime": 1616414360000,
    "date_field_name": "submit_date",
    "type_codes": [
        "T001",
        "T014"
    ],
    "document_nums": [
        "EXP0000000001",
        "EXP0000000002"
    ],
    "statuses": [
        "submitted",
        "approved"
    ],
    "branch_codes": [
        "130",
        "D002"
    ],
    "charge_user_codes": [
        "U001"
    ]
}

返回示例

{
    "resCode": 200000,
    "resMsg": "success",
    "data": {
        "page_num": 1,
        "total_page": 1,
        "page_size": 100,
        "total_count": 1,
        "page_info": [
            {
                "id": 70491,
                "column2": "6",
                "column17": "s01",
                "column23": "280.49",
                "description": "去办理公司车辆油卡",
                "code": "EXP0000007114",
                "column17_obj": {
                    "value_meaning": "境内出差-参加公司组织的会议或培训（无补贴）",
                    "value_code": "s01",
                    "id": 134867,
                    "creation_date": 1576992318000,
                    "value_id": 830202,
                    "last_update_date": 1597057849000
                },
                "note": "",
                "total_amount": 280.49,
                "total_claim_amount": 280.49,
                "advance_amount": 0.00,
                "total_pay_amount": 280.49,
                "currency_code": "CNY",
                "project_name": "2",
                "submit_department_id": 94692,
                "charge_department_id": 94979,
                "submit_user_id": 222846,
                "charge_user_id": 222846,
                "pay_user": {
                    "id": 222846,
                    "mobile": "",
                    "column1": "",
                    "code": "00184372",
                    "email_address": "xxx@xxx.com",
                    "full_name": "xxx",
                    "employee_number": "00184372",
                    "user_name": "xxx@xxx.com",
                    "department": {
                        "id": 94692,
                        "language": "zh_CN",
                        "code": "520",
                        "department_name": "义乌xxx有限公司",
                        "company_name": "义乌xxx有限公司"
                    }
                },
                "header_type_id": 144404,
                "destination_city_to": {
                    "id": 189,
                    "country": "China",
                    "code": "杭州",
                    "english_name": "Hangzhou",
                    "short_name": "hz"
                },
                "claim_lines": [
                    {
                        "id": 172084,
                        "column5": "124",
                        "column20": "否",
                        "header_id": 70491,
                        "expense_id": 41311,
                        "type_id": 547590,
                        "internal_type": "train",
                        "receipt_currency": "CNY",
                        "exchange_rate": 1.0000000000,
                        "claim_amount": 124.00,
                        "tax_code_id": 4,
                        "tax_amount": 10.24,
                        "net_amount": 113.76,
                        "pay_method_id": 48925,
                        "project_name": "2",
                        "cost_center_id": 94979,
                        "tax_code": {
                            "id": 4,
                            "code": "9%",
                            "tax_rate": 0.0900000000
                        },
                        "exp_type": {
                            "id": 547590,
                            "type": "火车票",
                            "category": "交通",
                            "code": "T523",
                            "type_code": "T523",
                            "internal_type": "train"
                        },
                        "cost_center": {
                            "id": 94979,
                            "language": "zh_CN",
                            "code": "823877",
                            "department_name": "财务管理部"
                        },
                        "project": {
                            "id": 2,
                            "code": "000000",
                            "project_name": "常规预算"
                        },
                        "pay_method": {
                            "id": 48925,
                            "factor": 1,
                            "description": "员工个人支付",
                            "language": "zh_CN",
                            "pay_method": "个人支付"
                        }
                    }
                ],
                "time_line": [],
                "header_type": {
                    "id": 144404,
                    "code": "T001",
                    "type": "差旅报销",
                    "internal_type": "claim",
                    "config_type_code": "gl_none",
                    "autoClose": "N",
                    "group_num": 10,
                    "group_name": "差旅报销",
                    "staff_flag": "Y",
                    "request_required_flag": "Y"
                },
                "submit_user": {
                    "id": 222846,
                    "mobile": "",
                    "column1": "",
                    "code": "00184372",
                    "email_address": "xxx@xxx.com",
                    "full_name": "xxx",
                    "employee_number": "00184372",
                    "user_name": "xxx@xxx.com"
                },
                "project": {
                    "id": 2,
                    "code": "000000",
                    "project_name": "常规预算"
                },
                "charge_user": {
                    "id": 222846,
                    "mobile": "",
                    "column1": "",
                    "code": "00184372",
                    "email_address": "xxx@xxx.com",
                    "full_name": "xxx",
                    "employee_number": "00184372",
                    "user_name": "xxx@xxx.com"
                },
                "submit_department": {
                    "id": 94692,
                    "language": "zh_CN",
                    "code": "520",
                    "department_name": "义乌xxx有限公司",
                    "company_name": "义乌xxx有限公司",
                    "tax_number": "91330782MA29P1CL6C"
                },
                "charge_department": {
                    "id": 94979,
                    "language": "zh_CN",
                    "code": "823877",
                    "department_name": "财务管理部"
                },
                "destination_cities": [
                    {
                        "country": "China",
                        "city_name": "义乌",
                        "english_name": "Yiwu",
                        "short_name": "yw"
                    }
                ],
                "header_links": [
                    {
                        "id": 70219,
                        "code": "REQ0000005328",
                        "note": "",
                        "advance_amount": 0.00,
                        "charge_department_id": 94979,
                        "pay_user": {
                            "id": 222846,
                            "mobile": "",
                            "column1": "",
                            "code": "00184372",
                            "email_address": "xxx@xxx.com",
                            "full_name": "xxx",
                            "employee_number": "00184372",
                            "user_name": "xxx@xxx.com"
                        },
                        "header_type_id": 144411,
                        "claim_lines": [],
                        "time_line": [],
                        "header_type": {
                            "id": 144411,
                            "code": "RT006",
                            "type": "差旅行程申请",
                            "internal_type": "request_travel",
                            "config_type_code": "gl_none",
                            "autoClose": "Y",
                            "group_num": 5,
                            "group_name": "差旅申请",
                            "staff_flag": "Y",
                            "request_required_flag": "N"
                        },
                        "charge_department": {
                            "id": 94979,
                            "language": "zh_CN",
                            "code": "823877",
                            "department_name": "财务管理部"
                        }
                    }
                ]
            }
        ]
    }
}