单据查询

. 接口:plugin/claim/{code}

. Method:POST

. 数据格式:JSON

. 接口说明:单据查询接口,code请找定制开发配置


请求参数

字段名称 字段类型 字段描述 是否必填 长度
page_num Integer 分页页数 (最小1) true
page_size Integer 分页条数 (最小1, 最大100) true
start_datetime long 开始时间,13位数字时间戳, 与date_field_name结合使用 true 13
end_datetime long 结束时间, 13位数字时间戳, 与date_field_name结合使用 true 13
date_field_name String 该字段表示的时间参数大于start_datetime并且小于end_datetime, 不传默认submit_date (可以的取值: 单据提交时间submit_date, 业务开始时间start_datetime, 业务结束时间end_datetime, 支付时间payment_date, 实际支付时间actual_payment_date, 业务审批通过时间preapproved_date, checked_date财务审核时间, 审批通过时间approved_date, closed_date单据关闭时间, creation_date创建时间, last_update_date上次更新时间) false 64
type_code String 单据类型 false 64
type_codes Array 单据类型列表 (type_code有值时无效) false
document_num String 单据号 false 64
document_nums Array 单据号列表 (document_num有值时无效) false
status String 单据状态 false 64
statuses Array 单据状态列表 (status有值时无效) false
branch_code String 单据所属分公司编码 false 64
branch_codes Array 单据所属分公司编码列表 (branch_code有值时无效) false

请求示例

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

返回示例

{
    "resCode": 200000,
    ": {
        "page_num": 1,
        "total_page": 1,
        "page_size": 100,
        "total_count": 27,
        "page_info": [
            {
                "id": 70491,
                "column2": "6",
                "column17": "s01",
                "column23": "280.49",
                "description": "去义乌办理公司车辆油卡",
                "code": "EXP0000007114",
                "column17_obj": {
                    "value_meaning": "境内出差-参加公司组织的会议或培训(无补贴)",
                    "company_id": 17880,
                    "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",
                "submit_date": "2021-03-23T07:58:46.000+0000",
                "start_datetime": "2021-03-16T16:00:00.000+0000",
                "end_datetime": "2021-03-21T16:00:00.000+0000",
                "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,
                "approved_date": "2021-03-29T01:11:54.000+0000",
                "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
                        },
                        "claim_attachments": [],
                        "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": "个人支付"
                        },
                        "invoices": [
                            {
                                "comments": "xxxxxxxxxxxxx",
                                "amount": 62.00,
                                "currency": "CNY",
                                "status": 2,
                                "receipt_id": 40578,
                                "original_: "{\"amount\": 62, \"invoice_num\": \"Z51N045909\", \"train_class\": \"二等座\", \"invoice_type\": \"60\", \"receipt_date\": 1615910400000, \"train_number\": \"G1395\", \"passenger_name\": \"范小丽\", \"start_datetime\": \"1615979640000\", \"destination_city\": 1003, \"destination_city_to\": 1005}",
                                "invoice_type": "60",
                                "invoice_type_meaning": "\"火车票\"",
                                "invoice_status": "I",
                                "invoice_attachments": "[{\"location\": {\"direction\": \"0\"}, \"direction\": \"0\", \"file_name\": \"image.jpg\", \"attachment_url\": \"ca92b4e4-3dc7-4e7f-90f5-ee4d06b03681.jpg\"}]",
                                "expense_id": 41311,
                                "invoice_num": "Z51N045909",
                                "tax_code_id": 4,
                                "tax_amount": 5.12,
                                "receipt_date": "2021-03-16T16:00:00.000+0000",
                                "passenger_name": "xxx",
                                "train_class": "209",
                                "start_datetime": "2021-03-17T11:14:00.000+0000",
                                "train_number": "G1395"
                            },
                            {
                                "comments": "生成的发票号码是 : Z166R021820",
                                "amount": 62.00,
                                "currency": "CNY",
                                "status": 2,
                                "receipt_id": 40579,
                                "original_: "{\"amount\": 62, \"invoice_num\": \"Z166R021820\", \"train_class\": \"二等座\", \"invoice_type\": \"60\", \"receipt_date\": 1616342400000, \"train_number\": \"G7376\", \"passenger_name\": \"范小丽\", \"start_datetime\": \"1616396700000\", \"destination_city\": 1005, \"destination_city_to\": 1003}",
                                "invoice_type": "60",
                                "invoice_type_meaning": "\"火车票\"",
                                "invoice_status": "I",
                                "invoice_attachments": "[{\"location\": {\"direction\": \"0\"}, \"direction\": \"0\", \"file_name\": \"image.jpg\", \"attachment_url\": \"7ef8201a-00c1-418b-b4c1-a66f9a433e80.jpg\"}]",
                                "expense_id": 41311,
                                "invoice_num": "Z166R021820",
                                "tax_code_id": 4,
                                "tax_amount": 5.12,
                                "receipt_date": "2021-03-21T16:00:00.000+0000",
                                "passenger_name": "xxx",
                                "train_class": "209",
                                "start_datetime": "2021-03-22T07:05:00.000+0000",
                                "train_number": "G7376"
                            }
                        ]
                    }
                ],
                "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": "财务管理部"
                        }
                    }
                ],
                "attachments_count": 2
            }
        ]
    }
}

返回头参数

字段名称 字段类型 字段描述 长度
page_num Integer 当前页数 11
total_page Integer 总页数 11
page_size Integer 条数 11
total_count Integer 当前页总条数 11
page_info Array 单据信息
page_info.id Integer 单据头id 11
page_info.code String 单据号 64
page_info.status String 单据状态 64
page_info.delivery_status String 纸单状态 64
page_info.pay_object String 支付对象 64
page_info.pay_user Integer 支付对象 11
page_info.pay_status String 单据支付状态 64
page_info.preapproved_date Date 业务审批通过日期
page_info.checkd_date Date 财务审核日期
page_info.approved_date Date 审批通过日期
page_info.payment_date Date 支付日期
page_info.actual_payment_date Date 实际支付日期
page_info.close_date Date 支付关闭日期
page_info.description String 单据描述 255
page_info.finance_description String 财务审核描述 255
page_info.long_description String 富文本描述信息 255
page_info.note String 单据备注 255
page_info.total_amount BigDecimal internal_type 不是 advance 的行的 claim_amount 乘以 pay_method_id.factor 汇总,pay_method_id 为空的时候取 claim_amount 汇总
page_info.total_claim_amount BigDecimal internal_type 不是 advance 的行的 accumulation_claim_amount 汇总
page_info.advance_amount BigDecimal internal_type 是 advance 的行的 claim_amount 汇总
page_info.total_pay_amount BigDecimal internal_type 不是 advance 的行的 pay_claim_amount 汇总
page_info.currency_code String 币种缩写 64
page_info.submit_date Date 单据提交时间
page_info.start_datetime Date 业务开始时间
page_info.end_datetime Date 业务结束时间
page_info.project_name Integer 项目id 11
page_info.project JSONObject 项目信息
page_info.project.id Integer 项目id 11
page_info.project.code String 项目编码 64
page_info.project.project_name String 项目名称 64
page_info.submit_department_id Integer 单据提交部门id 11
page_info.submit_department JSONObject 单据提交部门信息
page_info.submit_department.id Integer 单据提交部门id 11
page_info.submit_department.code String 单据提交部门编码 64
page_info.submit_department.department_name String 单据提交部门名称 64
page_info.submit_department.tax_number String 单据提交部门税号 64
page_info.submit_department.language String 单据提交部门语种 64
page_info.charge_department JSONObject 费用承担部门信息(与submit_department字段保持一致)
page_info.branch JSONObject 单据所属公司信息(与submit_department字段保持一致)
page_info.submit_user JSONObject 单据提交人信息
page_info.submit_user.id Integer 单据提交人id 11
page_info.submit_user.mobile String 单据提交人手机号 64
page_info.submit_user.code String 单据提交人员工号 64
page_info.submit_user.email_address String 单据提交人邮箱 64
page_info.submit_user.full_name String 单据提交人全名 64
page_info.submit_user.employee_number String 单据提交人员工号 64
page_info.submit_user.user_name String 单据提交人用户名 64
page_info.pay_user JSONObject 单据收款人信息(submit_user字段保持一致)
page_info.charge_user JSONObject 报销人信息(与submit_user字段保持一致)
page_info.created_by JSONObject 单据创建人信息(与submit_user字段保持一致)
page_info.customer JSONObject 单据创建人信息(与submit_user字段保持一致)
page_info.header_type JSONObject 单据类型信息
page_info.header_type.id Integer 单据类型id 11
page_info.header_type.code String 单据类型编码 64
page_info.header_type.type String 单据类型名称 64
page_info.header_type.internal_type String 单据属性类型 64
page_info.header_type.auto_close String 是否自动关闭 1
page_info.header_type.group_num Integer 单据类型分组编号 11
page_info.header_type.group_name String 单据类型分组名称 11
page_info.destination_cities Array 多到达城市信息
page_info.destination_cities.country String 国家 64
page_info.destination_cities.city_name String 城市名 64
page_info.destination_cities.short_name String 城市名称缩写 64
page_info.destination_cities.english_name String 城市英文名 64
page_info.destination_city_to JSONObject 到达城市信息 (与destination_cities字段保持一致)
page_info.destination_city JSONObject 出发城市信息 (与destination_cities字段保持一致)
page_info.deliveries Array 纸单投递信息
page_info.deliveries.code String 纸单编号 64
page_info.deliveries.delivery_date Date 纸单投递日期
page_info.deliveries.received_date Date 纸单收单日期
page_info.deliveries.rejected_date Date 纸单退单日期
page_info.workflow_paths Array 所有审批流信息
page_info.workflow_paths.approve_type String 审批类型 64
page_info.workflow_paths.open_date String 审批开始日期
page_info.current_workflow JSONObject 当前审批流信息 (与workflow_paths字段保持一致)
page_info.workflow_paths.end_date String 审批结束日期
page_info.branch_account JSONObject 公司银行账号信息
page_info.branch_account.id Integer 公司银行账号id 11
page_info.branch_account.code String 公司银行账号 64
page_info.branch_account.department_code String 公司编码 64
page_info.branch_account.bank_name String 银行名称 64
page_info.branch_account.bank_code String 银行代码 64
page_info.branch_account.account_name String 账户名 64
page_info.branch_account.bank_branch String 支行名称 64
page_info.branch_account.bank_address String 地址 64
page_info.branch_account.payer_account_area_code String 招行地区吗 64
page_info.user_account JSONObject 收款用户银行账号信息
page_info.user_account.id Integer 收款用户银行id 11
page_info.user_account.code String 收款用户银行账号 64
page_info.user_account.bank_name String 收款用户银行名称 64
page_info.user_account.bank_code String 收款用户银行代码 64
page_info.user_account.account_name String 收款用户银行户名 64
page_info.user_account.bank_branch String 收款用户银行支行名称 64
page_info.user_account.bank_address String 收款用户银行地址 64
page_info.user_account.enabled_flag String 收款用户银行启用标志 1
page_info.user_account.employee_number String 收款用户员工号 64
page_info.supplier_vo JSONObject 供应商信息
page_info.supplier_vo.id Integer 供应商id
page_info.supplier_vo.code String 供应商编码 64
page_info.supplier_vo.branch_code_flag String 供应商分公司标记 1
page_info.supplier_vo.enabled_flag String 供应商启用标记 1
page_info.supplier_account JSONObject 供应商银行信息
page_info.supplier_account.supplier_code String 账户名对应供应商编码 64
page_info.supplier_account.code String 供应商银行账号 64
page_info.supplier_account.id Integer 供应商银行id 11
page_info.supplier_account.bank_name String 供应商银行名称 64
page_info.supplier_account.bank_code String 供应商银行代码 64
page_info.supplier_account.account_name String 供应商银行户名 64
page_info.supplier_account.bank_branch String 供应商银行名称 64
page_info.supplier_account.bank_address String 供应商银行地址 64
page_info.supplier_account.enabled_flag String 供应商银行启用标志 1
page_info.customer JSONObject 客户信息
page_info.customer.id Integer 客户id
page_info.customer.code String 客户编码 64
page_info.customer.enabled_flag String 客户启用标记 1
page_info.customer_account JSONObject 客户银行信息
page_info.customer_account.customer_code String 客户编码 64
page_info.customer_account.code String 客户银行账号 64
page_info.customer_account.id Integer 客户银行id 11
page_info.customer_account.bank_name String 客户银行名称 64
page_info.customer_account.bank_code String 客户银行代码 64
page_info.customer_account.account_name String 客户银行户名 64
page_info.customer_account.bank_branch String 客户银行名称 64
page_info.customer_account.bank_address String 客户银行地址 64
page_info.customer_account.enabled_flag String 客户银行启用标志 1
page_info.gl_period_vo JSONObject 财年信息
page_info.gl_period_vo.level_name String 财年等级 64
page_info.gl_period_vo.period_status String 财年状态 64
page_info.gl_period_vo.start_date Date 财年开始时间
page_info.gl_period_vo.start_date Date 财年结束
page_info.attachments Array 附件
page_info.attachments.attachment_url String 附件S3地址
page_info.attachment_count Integer 发票张数 11
page_info.column1-column50 String 自定义字段值 255
page_info.column1Obj JSONObject column1的关联主数据信息 (内容根据值列表确定)
page_info.column1Obj-column100Obj JSONObject 自定义关联信息 (关联的主数据信息) 255
page_info.header_links Array 前序单据信息 (与page_info字段保持一致)

返回行参数

字段名称 字段类型 字段描述 长度
page_info.claim_lines Array 单据行信息
page_info.claim_lines.exp_type JSONObject 行费用类型
page_info.claim_lines.exp_type.type_code String 行费用类型编码 64
page_info.claim_lines.charge_user JSONObject 行报销人, 与头charge_user格式一致
page_info.claim_lines.cost_center JSONObject 行成本中心, 与头charge_department格式一致
page_info.claim_lines.project JSONObject 行项目, 与头project格式一致
page_info.claim_lines.tax_code JSONObject 行税率税额
page_info.claim_lines.tax_code.tax_rate BigDecimal 行税率
page_info.claim_lines.fin_tax_code JSONObject 行税率税额
page_info.claim_lines.fin_tax_code.tax_rate BigDecimal 行财务审核税率
page_info.claim_lines.dr_account JSONObject 行借方会计科目
page_info.claim_lines.dr_account.code String 会计科目编码 64
page_info.claim_lines.dr_account.structure_name String 会计科目类型名称 64
page_info.claim_lines.dr_account.account_name String 会计科目名称 64
page_info.claim_lines.dr_account.enabled_flag String 是否启用 64
page_info.claim_lines.dr_account.category String 类别 64
page_info.claim_lines.dr_account.alias_name String 别名 64
page_info.claim_lines.dr_account.balance_type String 预算类型 64
page_info.claim_lines.cr_account JSONObject 行贷方会计科目
page_info.claim_lines.tax_account JSONObject 行税借方科目
page_info.claim_lines.tax_cr_account JSONObject 行税贷方科目
page_info.claim_lines.destination_city JSONObject 行出发城市
page_info.claim_lines.destination_city_to JSONObject 行到达城市
page_info.claim_lines.attachment JSONObject 行附件
page_info.claim_lines.pay_method JSONObject 行支付方式
page_info.claim_lines.pay_method.factor String 行支付因子
page_info.claim_lines.pay_user JSONObject 行收款人, 与头charge_user格式一致
page_info.claim_lines.supplier JSONObject 行供应商, 与头supplier格式一致
page_info.claim_lines.supplier_account JSONObject 行供应商, 与头supplier_account格式一致
page_info.claim_lines.user_account JSONObject 行收款人银行信息, 与头user_account格式一致
page_info.claim_lines.customer JSONObject 行客户, 与头customer格式一致
page_info.claim_lines.customer_account JSONObject 行客户银行, 与头customer_account格式一致
page_info.claim_lines.unit_vo JSONObject 单位主数据
page_info.claim_lines.unit_vo.id Integer 单位主数据id 11
page_info.claim_lines.unit_vo.code String 单位主数据编码 64
page_info.claim_lines.unit_vo.enabled_flag String 是否启用 16
page_info.claim_lines.unit_vo.description String 详情 255
page_info.claim_lines.unit_vo.unit_name String 单位名称 255
page_info.claim_lines.material_vo JSONObject 物料主数据
page_info.claim_lines.material_vo.id Integer 物料主数据id 11
page_info.claim_lines.material_vo.code String 物料主数据编码 64
page_info.claim_lines.material_vo.unit_code String 物料主数据单位编码 64
page_info.claim_lines.material_vo.enabled_flag String 是否启用 16
page_info.claim_lines.material_vo.description String 详情 255
page_info.claim_lines.material_vo.material_name String 物料名称 255
page_info.claim_lines.accumulation_type JSONObject 行费用计算方式
page_info.claim_lines.accumulation_type.id Integer 行费用计算方式id 11
page_info.claim_lines.accumulation_type.enabled String 行费用计算方式是否启用 64
page_info.claim_lines.accumulation_type.accumulation_type String 行费用计算方式名称 64
page_info.claim_lines.serial JSONObject 行银行流水(参考银行流水接口)
page_info.claim_lines.trans_serial_attachment JSONObject 行银行流水附件信息(参考银行流水附件接口)
page_info.claim_lines.comments String 行描述信息 255
page_info.claim_lines.finance_comments String 行财务审核描述信息 255
page_info.claim_lines.long_comments String 行富文本描述信息 255

results matching ""

    No results matching ""