单据查询（自定义查询）

• 接口：/common/customize/document/find
• Method：POST
• 数据格式：JSON
• 接口说明：
  • 该接口为自定义单据查询接口，支持更灵活的查询条件和字段筛选
  • 支持通过多种条件组合查询单据信息
  • 支持自定义返回字段，优化查询性能
  • 支持分页查询

参数

请求参数

基础查询参数

时间范围查询参数

单据基本信息查询参数

组织架构查询参数

主数据关联查询参数

支付相关查询参数

其他查询参数

自定义字段查询参数

支持 column1 ~ column50 的查询，每个自定义字段支持精确匹配查询方式：

• columnN：精确匹配

示例： | 字段名称 | 字段类型 | 字段描述 | 默认值 | 是否必填 | 长度限制 | |---------|---------|---------|-------|---------|---------| | column1 | Object | 自定义字段1 | | FALSE | / |

返回参数

分页信息

单据头信息

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

组织架构信息

人员信息

主数据信息

银行账号信息

城市信息

自定义字段信息

附件信息

单据行信息

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

自定义行信息

以下字段在 data.page_info.custom_line 路径下返回，用于返回自定义行信息

预算行信息

以下字段在 data.page_info.budget_line 路径下返回，用于返回预算行信息

审批流信息

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

关联单据信息

示例

请求示例

{
    "page_num": 1,
    "page_size": 20,
    "start_datetime_timestamp": 1672502400000,
    "end_datetime_timestamp": 1704038399000,
    "date_field_name": "submit_date",
    "statuses": [
        "submitted",
        "approved"
    ],
    "type_codes": [
        "T001",
        "T014"
    ],
    "branch_codes": [
        "D001",
        "D002"
    ],
    "supplier_code": "S001",
    "charge_user_codes": [
        "U001",
        "U002"
    ],
    "header_columns": [
        "id",
        "code",
        "status",
        "total_amount",
        "submit_date"
    ]
}

返回示例

{
    "resCode": 200000,
    "resMsg": "success",
    "data": {
        "page_num": 1,
        "page_size": 20,
        "total_page": 5,
        "total_count": 95,
        "page_info": [
            {
                "id": 123456,
                "code": "EXP0000012345",
                "status": "approved",
                "header_type": {
                    "id": 1001,
                    "code": "T001",
                    "type": "差旅报销",
                    "internal_type": "claim",
                    "config_type_code": "gl_none",
                    "auto_close": "N",
                    "group_num": 10,
                    "group_name": "差旅报销",
                    "staff_flag": "Y",
                    "request_required_flag": "Y"
                },
                "description": "北京出差报销",
                "total_amount": 3580.50,
                "total_claim_amount": 3580.50,
                "advance_amount": 2000.00,
                "total_pay_amount": 1580.50,
                "currency_code": "CNY",
                "submit_date": 1672588800000,
                "start_datetime": 1672502400000,
                "end_datetime": 1672675200000,
                "approved_date": 1672761600000,
                "payment_date": 1672848000000,
                "submit_user": {
                    "id": 10001,
                    "code": "U001",
                    "employee_number": "E001",
                    "user_name": "zhangsan@example.com",
                    "full_name": "张三",
                    "email_address": "zhangsan@example.com",
                    "mobile": "13800138000"
                },
                "charge_user": {
                    "id": 10001,
                    "code": "U001",
                    "employee_number": "E001",
                    "user_name": "zhangsan@example.com",
                    "full_name": "张三",
                    "email_address": "zhangsan@example.com",
                    "mobile": "13800138000"
                },
                "pay_user": {
                    "id": 10001,
                    "code": "U001",
                    "employee_number": "E001",
                    "user_name": "zhangsan@example.com",
                    "full_name": "张三",
                    "email_address": "zhangsan@example.com",
                    "mobile": "13800138000"
                },
                "branch": {
                    "id": 1,
                    "code": "D001",
                    "department_name": "北京分公司",
                    "company_name": "北京分公司",
                    "tax_number": "91110000000000000X",
                    "language": "zh_CN"
                },
                "submit_department": {
                    "id": 100,
                    "code": "D100",
                    "department_name": "研发部",
                    "language": "zh_CN"
                },
                "charge_department": {
                    "id": 100,
                    "code": "D100",
                    "department_name": "研发部",
                    "language": "zh_CN"
                },
                "project": {
                    "id": 1000,
                    "code": "P001",
                    "project_name": "XX项目"
                },
                "destination_city": {
                    "id": 1,
                    "country": "China",
                    "code": "BJS",
                    "city_name": "北京",
                    "english_name": "Beijing",
                    "short_name": "bj"
                },
                "destination_city_to": {
                    "id": 2,
                    "country": "China",
                    "code": "SHA",
                    "city_name": "上海",
                    "english_name": "Shanghai",
                    "short_name": "sh"
                },
                "claim_lines": [
                    {
                        "id": 500001,
                        "header_id": 123456,
                        "line_num": 1,
                        "internal_type": "train",
                        "receipt_currency": "CNY",
                        "exchange_rate": 1.0000,
                        "claim_amount": 553.50,
                        "tax_amount": 45.69,
                        "net_amount": 507.81,
                        "comments": "北京-上海高铁票",
                        "exp_type": {
                            "id": 2001,
                            "type_code": "T001",
                            "type": "火车票",
                            "category": "交通",
                            "internal_type": "train"
                        },
                        "tax_code": {
                            "id": 1,
                            "code": "9%",
                            "tax_rate": 0.09
                        },
                        "pay_method": {
                            "id": 1,
                            "pay_method": "个人支付",
                            "factor": "1",
                            "description": "员工个人支付"
                        }
                    },
                    {
                        "id": 500002,
                        "header_id": 123456,
                        "line_num": 2,
                        "internal_type": "hotel",
                        "receipt_currency": "CNY",
                        "exchange_rate": 1.0000,
                        "claim_amount": 1800.00,
                        "tax_amount": 101.89,
                        "net_amount": 1698.11,
                        "comments": "上海酒店住宿",
                        "exp_type": {
                            "id": 2002,
                            "type_code": "T002",
                            "type": "酒店住宿",
                            "category": "住宿",
                            "internal_type": "hotel"
                        },
                        "tax_code": {
                            "id": 2,
                            "code": "6%",
                            "tax_rate": 0.06
                        },
                        "pay_method": {
                            "id": 1,
                            "pay_method": "个人支付",
                            "factor": "1",
                            "description": "员工个人支付"
                        }
                    }
                ],
                "workflow_paths": [
                    {
                        "id": 80001,
                        "header_id": 123456,
                        "approve_type": "submit",
                        "workflow_step": "部门经理审批",
                        "workflow_type": "approve",
                        "status": "approved",
                        "open_date": 1672588800000,
                        "end_date": 1672675200000,
                        "user_id": 10002
                    },
                    {
                        "id": 80002,
                        "header_id": 123456,
                        "approve_type": "approve",
                        "workflow_step": "财务审批",
                        "workflow_type": "approve",
                        "status": "approved",
                        "open_date": 1672675200000,
                        "end_date": 1672761600000,
                        "user_id": 10003
                    }
                ],
                "header_links": [
                    {
                        "id": 123400,
                        "code": "REQ0000012340",
                        "status": "approved",
                        "header_type": {
                            "code": "RT001",
                            "type": "差旅申请"
                        }
                    }
                ],
                "header_back_links": [
                    {
                        "id": 123500,
                        "code": "PAY0000012350",
                        "status": "approved",
                        "header_type": {
                            "code": "P001",
                            "type": "付款单"
                        }
                    }
                ]
            }
        ]
    }
}