付款台账查询
- 接口：/common/ledger/findPaymentLedgerPage
- Method：POST
- 数据格式：JSON
- 接口说明：
参数
请求参数
| 字段名称 |
字段类型 |
字段描述 |
是否必填 |
长度 |
| bizId |
String |
唯一标识 |
FALSE |
36 |
| timestamp |
Long |
时间戳 |
FALSE |
13 |
| data |
Object |
请求数据 |
TRUE |
/ |
| data.page_num |
Long |
页码 |
FALSE |
/ |
| data.page_size |
Long |
每页大小 |
FALSE |
/ |
| data.ledger_config_code |
String |
台账配置代码 |
TRUE |
255 |
| data.number |
String |
编号 (头) |
FALSE |
16 |
| data.user_code |
String |
用户 (头) |
FALSE |
255 |
| data.department_code |
String |
部门 (头) |
FALSE |
255 |
| data.branch_code |
String |
公司 (头) |
FALSE |
255 |
| data.supplier_code |
String |
供应商 (头) |
FALSE |
255 |
| data.customer_code |
String |
客户 (头) |
FALSE |
255 |
| data.external_person_code |
String |
外部人员 (头) |
FALSE |
255 |
| data.payment_date_from |
Long |
付款日期开始 (头) |
FALSE |
13 |
| data.payment_date_to |
Long |
付款日期结束 (头) |
FALSE |
13 |
| data.gl_period |
String |
总账期间 (头) |
FALSE |
255 |
| data.pay_amount_from |
Decimal |
应付金额开始 (头) |
FALSE |
255 |
| data.pay_amount_to |
Decimal |
应付金额结束 (头) |
FALSE |
255 |
| data.remaining_amount_from |
Decimal |
剩余应付金额开始 (头) |
FALSE |
255 |
| data.remaining_amount_to |
Decimal |
剩余应付金额结束 (头) |
FALSE |
255 |
| data.creation_date_from |
Long |
创建时间开始 (头) |
FALSE |
13 |
| data.creation_date_to |
Long |
创建时间结束 (头) |
FALSE |
13 |
| data.status |
String |
付款台账完成状态 (头) |
FALSE |
255 |
| data.line_status |
String |
应付台账完成状态 (行) |
FALSE |
255 |
| data.line_type_code |
String |
应付台账费用类型 (行) |
FALSE |
255 |
| data.line_user_code |
String |
应付台账用户 (行) |
FALSE |
255 |
| data.line_supplier_code |
String |
应付台账供应商 (行) |
FALSE |
255 |
| data.line_customer_code |
String |
应付台账客户 (行) |
FALSE |
255 |
| data.line_cost_center_code |
String |
应付台账成本中心 (行) |
FALSE |
255 |
| data.line_external_person_code |
String |
应付台账外部人员 (行) |
FALSE |
255 |
| data.line_payment_date_from |
Long |
应付台账付款日期开始 (行) |
FALSE |
13 |
| data.line_payment_date_to |
Long |
应付台账付款日期结束 (行) |
FALSE |
13 |
| data.line_payment_type |
String |
应付台账支付方式 (行) |
FALSE |
255 |
| data.line_duration |
String |
应付台账期间 (行) |
FALSE |
255 |
| data.line_budget_period |
String |
应付台账预算期间 (行) |
FALSE |
255 |
| data.line_receipt_date_from |
Long |
应付台账发票日期开始 (行) |
FALSE |
13 |
| data.line_receipt_date_to |
Long |
应付台账发票日期结束 (行) |
FALSE |
13 |
| data.line_expense_type |
String |
应付台账发票类型 (行) |
FALSE |
255 |
| data.line_expense_code |
String |
应付台账发票代码 (行) |
FALSE |
255 |
| data.line_expense_num |
String |
应付台账发票号码 (行) |
FALSE |
255 |
| data.line_expense_date_from |
Long |
应付台账发票日期开始 (行) |
FALSE |
13 |
| data.line_expense_date_to |
Long |
应付台账发票日期结束 (行) |
FALSE |
13 |
| data.line_expense_amount_from |
Decimal |
应付台账发票金额开始 (行) |
FALSE |
255 |
| data.line_expense_amount_to |
Decimal |
应付台账发票金额结束 (行) |
FALSE |
255 |
| data.line_expense_currency |
String |
应付台账发票币种 (行) |
FALSE |
255 |
| data.line_pay_amount_from |
Decimal |
应付台账应付金额开始 (行) |
FALSE |
255 |
| data.line_pay_amount_to |
Decimal |
应付台账应付金额结束 (行) |
FALSE |
255 |
| data.line_creation_date_from |
Long |
应付台账创建时间开始 (行) |
FALSE |
13 |
| data.line_creation_date_to |
Long |
应付台账创建时间结束 (行) |
FALSE |
13 |
返回参数
| 字段名称 |
字段类型 |
字段描述 |
| resCode |
Integer |
响应状态码 |
| resMsg |
String |
返回信息描述 |
示例
请求数据
{
"bizId": "0fd4fcdb-fb8f-475f-a885-e5adc71ed747",
"timestamp": "1672588800000",
"data": {
"ledger_config_code": "T001",
"page_size": 1,
"page_num": 1
}
}
错误时返回数据
{
"resCode": 0,
"resMsg": "字段: ledger_config_code 值: T001 不存在"
}
成功时返回数据
{
"resCode": 200000,
"resMsg": "success",
"data": {
"page_size": 1,
"page_num": 1,
"total_count": 35,
"total_page": 35,
"is_first_page": true,
"is_last_page": false,
"page_info": [
{
"id": 41,
"number": "EXP0000047230",
"status": "incomplete",
"column1": "212988",
"ledger_config_id": 15,
"header_id": 1713241,
"header_type_id": 47071,
"user_id": 212988,
"department_id": 14577,
"branch_id": 14151,
"pay_amount": 100.00,
"pay_currency": "CNY",
"paid_amount": -100.00,
"pending_amount": 0.00,
"remaining_amount": 200.00,
"created_by": 212988,
"creation_date": 1710990159000,
"last_updated_by": 212988,
"last_update_date": 1710990159000,
"user_vo": {
"id": 212988,
"code": "lishuaibin@qq.com",
"gender": "M",
"surname": "li",
"nationality": "CHN",
"column6": "",
"column36": "code1",
"parent_id": 212971,
"position_id": 2504,
"branch_id": 220298,
"company_id": 3809,
"level_id": 1716,
"department_id": 220298,
"supervisor_id": 212971,
"cost_center_id": 220298,
"email_address": "shuaibin.li@cloudpense.com",
"full_name": "李帅斌",
"employee_number": "lishuaibin@qq.com",
"user_name": "lishuaibin@qq.com",
"given_name": "shuaibin",
"user_type": "1",
"date_of_joining": "2020-12-01",
"credit_level": 247,
"credit_score": 9300,
"creation_date": 1567755784000,
"last_update_date": 1714355853000,
"default_language": "zh_CN",
"equipment_type": "",
"equipment_id": ""
},
"department_vo": {
"id": 14577,
"code": "D427",
"column10": "223546",
"type": "D",
"ledger2": 35213,
"parent_id": 14151,
"department_name": "研发部",
"department_code": "D427",
"department_id": 14577,
"sequence_num": 630,
"owner_id": 3121745,
"approval_level": 3,
"natural_level": 2,
"tax_number": "22222222",
"exchange_rate_type_id": 0,
"currency_code": "CNY",
"cost_center_flag": "Y",
"budget_flag": "Y",
"budget_control": "Y",
"ledger_id": 34717,
"enabled_flag": "Y",
"branch_company_id": 14151,
"supervisor_id": 14151
},
"branch_vo": {
"id": 14151,
"code": "D1",
"column7": "",
"column9": "1670895600000",
"column10": "223546测试",
"type": "B",
"phone": "02168331234",
"ledger2": 32777,
"parent_id": 0,
"department_name": "Tiny ship",
"department_code": "D1",
"department_id": 14151,
"sequence_num": 160,
"owner_id": 3055616,
"approval_level": 1,
"natural_level": 1,
"company_name": "上海云简软件科技有限公司",
"tax_number": "91330212MA7G99EFX2",
"tax_address": "测试开票地址",
"exchange_rate_type_id": 0,
"bank_name": "工商银行外马路支行",
"account_number": "121916050910201",
"currency_code": "CNY",
"receipt_currency": "CNY",
"tax_code_structure_id": 1,
"invoicing_limit_number": 100000.00,
"invoicing_limit_number_common": 10000.00,
"invoicing_limit_number_roll": 10000.00,
"cost_center_flag": "Y",
"budget_flag": "Y",
"budget_control": "Y",
"ledger_id": 17589,
"enabled_flag": "Y",
"branch_company_id": 14151,
"supervisor_id": 0
},
"column1_vo": {
"departmentId": 220298,
"id": 212988,
"branchId": 220298,
"creditScore": 9300,
"givenName": "shuaibin",
"uniqueKey": 212988,
"supervisorId": 212971,
"nationality": "CHN",
"column6": "",
"gender": "M",
"equipmentType": "",
"defaultLanguage": "zh_CN",
"surname": "li",
"pointBalance": 2.00,
"parentId": 212971,
"dateOfJoining": 1606780800000,
"positionId": 2504,
"lastUpdateDate": 1714355853000,
"equipmentId": "",
"employeeNumber": "lishuaibin@qq.com",
"emailAddress": "shuaibin.li@cloudpense.com",
"levelId": 1716,
"lastUpdatedBy": 212988,
"creationDate": 1567755784000,
"companyId": 3809,
"userType": "1",
"code": "lishuaibin@qq.com",
"creditLevel": 247,
"costCenterId": 220298,
"roleId": 2,
"fullName": "李帅斌",
"userName": "lishuaibin@qq.com",
"column36": "code1",
"createdBy": 212971
},
"payment_ledger_lines": [
{
"id": 62,
"status": "incomplete",
"payment_ledger_header_id": 41,
"type_id": 70849,
"user_id": 212988,
"pay_amount": 100.00,
"paid_amount": -100.00,
"pending_amount": 0.00,
"remaining_amount": 200.00,
"created_by": 212988,
"creation_date": 1710990159000,
"last_updated_by": 212988,
"last_update_date": 1710990159000,
"user_vo": {
"id": 212988,
"code": "lishuaibin@qq.com",
"gender": "M",
"surname": "li",
"nationality": "CHN",
"column6": "",
"column36": "code1",
"parent_id": 212971,
"position_id": 2504,
"branch_id": 220298,
"company_id": 3809,
"level_id": 1716,
"department_id": 220298,
"supervisor_id": 212971,
"cost_center_id": 220298,
"email_address": "shuaibin.li@cloudpense.com",
"full_name": "李帅斌",
"employee_number": "lishuaibin@qq.com",
"user_name": "lishuaibin@qq.com",
"given_name": "shuaibin",
"user_type": "1",
"date_of_joining": "2020-12-01",
"credit_level": 247,
"credit_score": 9300,
"creation_date": 1567755784000,
"last_update_date": 1714355853000,
"default_language": "zh_CN",
"equipment_type": "",
"equipment_id": ""
}
}
]
}
]
}
}