可关联合同台账查询
- 接口：/common/ledger/leaseContractLedgerLink
- Method：POST
- 数据格式：JSON
- 接口说明：
user_name 和 employee_number 必传其一- 共享给我的和自己通过权限看到的需要分开查询
- 页码不传默认为 1
- 每页大小不传默认为 100
参数
请求参数
| 字段名称 |
字段类型 |
字段描述 |
是否必填 |
长度 |
| bizId |
String |
唯一标识 |
FALSE |
36 |
| timestamp |
Long |
时间戳 |
FALSE |
13 |
| data |
Object |
请求数据 |
TRUE |
/ |
| data.ledger_config_code |
String |
台账类型编码 |
TRUE |
255 |
| data.is_share |
String |
是否查共享给我的(Y 或 N), 不传默认为 N |
FALSE |
255 |
| data.user_name |
String |
查询用户名 |
FALSE |
255 |
| data.employee_number |
String |
查询用户员工号 |
FALSE |
255 |
| data.page_num |
Long |
页码 |
FALSE |
255 |
| data.page_size |
Long |
页大小 |
FALSE |
255 |
返回参数
| 字段名称 |
字段类型 |
字段描述 |
| resCode |
Integer |
响应状态码 |
| resMsg |
String |
返回信息描述 |
示例
请求数据
{
"data": {
"ledger_config_code": "90636",
"user_name": "yw1@qq.com",
"is_share": "Y",
"page_num": 1,
"page_size": 5
},
"bizId": "e2fb5400-856b-4661-831b-cdc8f0eba903",
"timestamp": 1742367266803
}
错误时返回数据
{
"resCode": 400000,
"resMsg": "用户不存在"
}
{
"resCode": 0,
"resMsg": "ledger_config_code: 90636123 不存在;"
}
成功时返回数据
{
"resCode": 200000,
"resMsg": "success",
"data": {
"page_size": 5,
"page_num": 1,
"total_count": 2,
"total_page": 1,
"is_first_page": true,
"is_last_page": true,
"page_info": [
{
"id": 282,
"column11": "200.00",
"number": "REQ0000025509",
"status": "incomplete",
"ledger_config_id": 19,
"ledger_num": "282",
"header_id": 1920128,
"header_type_id": 144817,
"user_id": 223564,
"department_id": 85926,
"branch_id": 14151,
"pay_amount": 200.00,
"pay_currency": "CNY",
"paid_amount": 0.00,
"pending_amount": 0.00,
"remaining_amount": 200.00,
"start_datetime": 1737022808000,
"end_datetime": 1737627608000,
"change_status": "unchanged",
"created_by": 223564,
"creation_date": 1736418098000,
"last_updated_by": 223564,
"last_update_date": 1736418098000,
"header_type_vo": {
"id": 144817,
"code": "90636-1",
"type_id": 144817,
"type_code": "90636-1",
"internal_type": "request",
"config_type_code": "gl_none",
"revision_flag": "N",
"share_flag": "N",
"delivery_flag": "N",
"type": "90636-1-申请单",
"document_name": "REQ",
"require_reason": "N",
"budget_hidden_flag": "N",
"budget_read_only": "N",
"budget_required_flag": "N",
"allow_workflow_withdraw": "N"
},
"user_vo": {
"id": 223564,
"code": "yw1@qq.com",
"mobile": "1234567890",
"gender": "F",
"nationality": "CHN",
"column1": "900",
"column2": "86909",
"column3": "3055616",
"column4": "3121405",
"column5": "021-838934992",
"column6": "Y",
"column7": "223057",
"column8": "19009",
"column9": "8667",
"column10": "INVT00006640",
"column11": "79",
"column12": "1712851200000",
"column13": "1713084480000",
"column14": "0",
"column15": "肿瘤免疫治疗",
"column36": "code1",
"column50": "59168",
"parent_id": 212989,
"position_id": 2464,
"company_id": 3809,
"level_id": 1067,
"department_id": 85926,
"supervisor_id": 212989,
"cost_center_id": 85926,
"email_address": "yw1@qq.com",
"full_name": "杨伊",
"employee_number": "yw1@qq.com",
"user_name": "yw1@qq.com",
"user_type": "1",
"start_work_date": "2021-06-03",
"credit_score": -9,
"creation_date": 1610676443000,
"last_update_date": 1741945290000,
"default_language": "zh_CN",
"base_city": "0",
"equipment_type": "",
"equipment_id": "",
"attachment_url": "d3836121-7763-4544-92cb-65f91ae4b83b.png"
},
"department_vo": {
"id": 85926,
"code": "DYF036",
"column3": "01",
"column5": "cw6@qq.com",
"column10": "001",
"column11": "11",
"column30": "224156",
"type": "D",
"ledger2": 35213,
"parent_id": 14577,
"department_name": "研发三部",
"department_code": "DYF036",
"department_id": 85926,
"sequence_num": 10,
"owner_id": 223563,
"natural_level": 3,
"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": 14577
},
"branch_vo": {
"id": 14151,
"code": "D1",
"column3": "1",
"column5": "cw18@qq.com",
"column6": "1",
"column7": "1",
"column8": "1",
"column9": "1670895600000",
"column11": "11",
"column12": "1",
"column13": "1",
"column14": "1",
"column15": "1",
"column16": "1",
"column17": "1",
"column18": "1",
"column19": "1",
"column20": "1",
"column21": "1",
"column22": "1",
"column23": "1",
"column24": "1",
"column25": "1",
"column26": "1",
"column27": "1",
"column28": "1",
"column29": "1",
"column31": "1",
"column32": "1",
"column33": "1",
"column34": "1",
"column35": "1",
"column36": "1",
"column37": "1",
"column38": "1",
"column39": "1",
"column40": "1",
"column41": "1",
"column42": "1",
"column43": "1",
"column44": "1",
"column45": "1",
"column46": "1",
"column47": "1",
"column48": "1",
"column49": "1",
"type": "B",
"address": "1",
"phone": "02168331234",
"ledger": "1",
"ledger2": 32777,
"parent_id": 0,
"department_name": "Tiny ship_zh_CN",
"department_code": "D1",
"legal_representative": "1",
"department_id": 14151,
"sequence_num": 130,
"owner_id": 224158,
"approval_level": 1,
"natural_level": 1,
"email_address": "cw6@qq.com",
"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
},
"lease_contract_ledger_lines": [
{
"id": 659,
"status": "incomplete",
"lease_contract_ledger_header_id": 282,
"ledger_line_num": "659",
"type_id": 548704,
"user_id": 223564,
"pay_amount": 100.00,
"paid_amount": 0.00,
"pending_amount": 0.00,
"remaining_amount": 100.00,
"advance_amount": 0.00,
"advance_pending_amount": 0.00,
"offset_amount": 0.00,
"offset_pending_amount": 0.00,
"remaining_offset_amount": 0.00,
"invoice_verification_amount": 0.00,
"invoice_verification_pending_amount": 0.00,
"remaining_invoice_verification_amount": 0.00,
"invoice_verification_flag": "incomplete",
"change_status": "unchanged",
"created_by": 223564,
"creation_date": 1736418098000,
"last_updated_by": 223564,
"last_update_date": 1736418098000,
"exp_type_vo": {
"id": 548704,
"code": "90636-1-1",
"type_code": "90636-1-1",
"type": "合同台账行——一般费用",
"enabled": "Y",
"category": "合同台账行",
"description": "合同台账行——一般费用"
},
"user_vo": {
"id": 223564,
"code": "yw1@qq.com",
"mobile": "1234567890",
"gender": "F",
"nationality": "CHN",
"column1": "900",
"column2": "86909",
"column3": "3055616",
"column4": "3121405",
"column5": "021-838934992",
"column6": "Y",
"column7": "223057",
"column8": "19009",
"column9": "8667",
"column10": "INVT00006640",
"column11": "79",
"column12": "1712851200000",
"column13": "1713084480000",
"column14": "0",
"column15": "肿瘤免疫治疗",
"column36": "code1",
"column50": "59168",
"parent_id": 212989,
"position_id": 2464,
"company_id": 3809,
"level_id": 1067,
"department_id": 85926,
"supervisor_id": 212989,
"cost_center_id": 85926,
"email_address": "yw1@qq.com",
"full_name": "杨伊",
"employee_number": "yw1@qq.com",
"user_name": "yw1@qq.com",
"user_type": "1",
"start_work_date": "2021-06-03",
"credit_score": -9,
"creation_date": 1610676443000,
"last_update_date": 1741945290000,
"default_language": "zh_CN",
"base_city": "0",
"equipment_type": "",
"equipment_id": "",
"attachment_url": "d3836121-7763-4544-92cb-65f91ae4b83b.png"
}
}
]
},
{
"id": 282,
"column11": "200.00",
"number": "REQ0000025509",
"status": "incomplete",
"ledger_config_id": 19,
"ledger_num": "282",
"header_id": 1920128,
"header_type_id": 144817,
"user_id": 223564,
"department_id": 85926,
"branch_id": 14151,
"pay_amount": 200.00,
"pay_currency": "CNY",
"paid_amount": 0.00,
"pending_amount": 0.00,
"remaining_amount": 200.00,
"start_datetime": 1737022808000,
"end_datetime": 1737627608000,
"change_status": "unchanged",
"created_by": 223564,
"creation_date": 1736418098000,
"last_updated_by": 223564,
"last_update_date": 1736418098000,
"header_type_vo": {
"id": 144817,
"code": "90636-1",
"type_id": 144817,
"type_code": "90636-1",
"internal_type": "request",
"config_type_code": "gl_none",
"revision_flag": "N",
"share_flag": "N",
"delivery_flag": "N",
"type": "90636-1-申请单",
"document_name": "REQ",
"require_reason": "N",
"budget_hidden_flag": "N",
"budget_read_only": "N",
"budget_required_flag": "N",
"allow_workflow_withdraw": "N"
},
"user_vo": {
"id": 223564,
"code": "yw1@qq.com",
"mobile": "1234567890",
"gender": "F",
"nationality": "CHN",
"column1": "900",
"column2": "86909",
"column3": "3055616",
"column4": "3121405",
"column5": "021-838934992",
"column6": "Y",
"column7": "223057",
"column8": "19009",
"column9": "8667",
"column10": "INVT00006640",
"column11": "79",
"column12": "1712851200000",
"column13": "1713084480000",
"column14": "0",
"column15": "肿瘤免疫治疗",
"column36": "code1",
"column50": "59168",
"parent_id": 212989,
"position_id": 2464,
"company_id": 3809,
"level_id": 1067,
"department_id": 85926,
"supervisor_id": 212989,
"cost_center_id": 85926,
"email_address": "yw1@qq.com",
"full_name": "杨伊",
"employee_number": "yw1@qq.com",
"user_name": "yw1@qq.com",
"user_type": "1",
"start_work_date": "2021-06-03",
"credit_score": -9,
"creation_date": 1610676443000,
"last_update_date": 1741945290000,
"default_language": "zh_CN",
"base_city": "0",
"equipment_type": "",
"equipment_id": "",
"attachment_url": "d3836121-7763-4544-92cb-65f91ae4b83b.png"
},
"department_vo": {
"id": 85926,
"code": "DYF036",
"column3": "01",
"column5": "cw6@qq.com",
"column10": "001",
"column11": "11",
"column30": "224156",
"type": "D",
"ledger2": 35213,
"parent_id": 14577,
"department_name": "研发三部",
"department_code": "DYF036",
"department_id": 85926,
"sequence_num": 10,
"owner_id": 223563,
"natural_level": 3,
"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": 14577
},
"branch_vo": {
"id": 14151,
"code": "D1",
"column3": "1",
"column5": "cw18@qq.com",
"column6": "1",
"column7": "1",
"column8": "1",
"column9": "1670895600000",
"column11": "11",
"column12": "1",
"column13": "1",
"column14": "1",
"column15": "1",
"column16": "1",
"column17": "1",
"column18": "1",
"column19": "1",
"column20": "1",
"column21": "1",
"column22": "1",
"column23": "1",
"column24": "1",
"column25": "1",
"column26": "1",
"column27": "1",
"column28": "1",
"column29": "1",
"column31": "1",
"column32": "1",
"column33": "1",
"column34": "1",
"column35": "1",
"column36": "1",
"column37": "1",
"column38": "1",
"column39": "1",
"column40": "1",
"column41": "1",
"column42": "1",
"column43": "1",
"column44": "1",
"column45": "1",
"column46": "1",
"column47": "1",
"column48": "1",
"column49": "1",
"type": "B",
"address": "1",
"phone": "02168331234",
"ledger": "1",
"ledger2": 32777,
"parent_id": 0,
"department_name": "Tiny ship_zh_CN",
"department_code": "D1",
"legal_representative": "1",
"department_id": 14151,
"sequence_num": 130,
"owner_id": 224158,
"approval_level": 1,
"natural_level": 1,
"email_address": "cw6@qq.com",
"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
},
"lease_contract_ledger_lines": [
{
"id": 658,
"status": "incomplete",
"lease_contract_ledger_header_id": 282,
"ledger_line_num": "658",
"type_id": 548704,
"user_id": 223564,
"pay_amount": 100.00,
"paid_amount": 0.00,
"pending_amount": 0.00,
"remaining_amount": 100.00,
"advance_amount": 0.00,
"advance_pending_amount": 0.00,
"offset_amount": 0.00,
"offset_pending_amount": 0.00,
"remaining_offset_amount": 0.00,
"invoice_verification_amount": 0.00,
"invoice_verification_pending_amount": 0.00,
"remaining_invoice_verification_amount": 0.00,
"invoice_verification_flag": "incomplete",
"change_status": "unchanged",
"created_by": 223564,
"creation_date": 1736418098000,
"last_updated_by": 223564,
"last_update_date": 1736418098000,
"exp_type_vo": {
"id": 548704,
"code": "90636-1-1",
"type_code": "90636-1-1",
"type": "合同台账行——一般费用",
"enabled": "Y",
"category": "合同台账行",
"description": "合同台账行——一般费用"
},
"user_vo": {
"id": 223564,
"code": "yw1@qq.com",
"mobile": "1234567890",
"gender": "F",
"nationality": "CHN",
"column1": "900",
"column2": "86909",
"column3": "3055616",
"column4": "3121405",
"column5": "021-838934992",
"column6": "Y",
"column7": "223057",
"column8": "19009",
"column9": "8667",
"column10": "INVT00006640",
"column11": "79",
"column12": "1712851200000",
"column13": "1713084480000",
"column14": "0",
"column15": "肿瘤免疫治疗",
"column36": "code1",
"column50": "59168",
"parent_id": 212989,
"position_id": 2464,
"company_id": 3809,
"level_id": 1067,
"department_id": 85926,
"supervisor_id": 212989,
"cost_center_id": 85926,
"email_address": "yw1@qq.com",
"full_name": "杨伊",
"employee_number": "yw1@qq.com",
"user_name": "yw1@qq.com",
"user_type": "1",
"start_work_date": "2021-06-03",
"credit_score": -9,
"creation_date": 1610676443000,
"last_update_date": 1741945290000,
"default_language": "zh_CN",
"base_city": "0",
"equipment_type": "",
"equipment_id": "",
"attachment_url": "d3836121-7763-4544-92cb-65f91ae4b83b.png"
}
}
]
}
]
}
}