API中心

  1. 委外加工
  2. 材料核销
返回

材料核销_查询

接口所在U8C版本:U8 cloud5.0sp以及更高版本
详细描述:用于材料核销查询
API视频讲解API详情补丁列表常见问题参考
接口地址
请求方式
请求参数header
请求参数body
返回类型参数
代码示例
请求参数示例
正确返回示例
错误返回示例
接口地址:http://ip:port/u8cloud/api/sc/settleverify/query

参数填写指南

请求方式:POST

请求参数(header):

参数填写指南
参数名必填描述默认值
Content-Type是请求体数据类型application/json
usercode是用户
password是密码
trantype否翻译类型，按编码为code，不需要翻译为pk
system是系统参数

请求参数(body):

全量参数最简示例
参数名类型是否数组必填描述默认值示例值
billcode否否入库单号
corp否是公司编码
custcode否否供应商编码
date_begin否否业务日期开始
date_end否否业务日期截止
invcode否否加工品编号
page_now否否页数
page_size否否每页条数
verifyflag否是核销状态未核销1，已核销未结算2，已结算3
writeofftype否是核销方式任意核销，按备料发料核销，按BOM核销

返回类型参数:

参数名类型是否数组必填描述默认值
No Data

代码示例:

Java模板示例下载C#模板示例下载

请求参数示例:

最简示例

复制代码

{"verifyflag":"2","corp":"2901","writeofftype":"按备料发料核销"}

正确返回示例:

复制代码

{
    "status": "success",
    "data": "{\"allcount\":1,\"retcount\":1,\"queryallsql\":\"select distinct head.cgeneralhid from ic_general_b body inner join ic_general_h head on head.cgeneralhid = body.cgeneralhid AND ic_general_b.dr = 0  left outer join ic_general_bb3 on body.cgeneralbid = ic_general_bb3.cgeneralbid and ic_general_bb3.dr = 0  where head.cgeneralhid = body.cgeneralhid and head.cgeneralhid = ic_general_bb3.cgeneralhid and  head.cgeneralhid = body.cgeneralhid and head.cgeneralhid = ic_general_bb3.cgeneralhid  and head.cbilltypecode = '47'  and head.fbillflag in ( 3 , 4 ) and isnull(body.bzgflag,'N') = 'Y' and isnull ( ic_general_bb3.naccountnum1 , 0 ) = 0 and body.dr = 0 and head.dr = 0  and head.pk_corp in (select pk_corp from bd_corp where unitcode = '2901') and body.writeofftype = '按备料发料核销' and head.cbilltypecode ='47'  and head.dr = 0 and body.dr = 0 order by head.cgeneralhid\",\"datas\":[{\"parentvo\":{\"pk_corp\":\"1010\",\"pk_corp_code\":\"2901\",\"pk_corp_name\":\"lym投资控股有限公司\",\"vbillcode\":\"WW2310180005\",\"dbizdate\":\"2023-10-18\",\"cproviderid\":\"0001A21000000000LS7U\",\"cproviderid_code\":\"CU0025\",\"cproviderid_name\":\"快乐小客商\",\"cdptid\":\"1010A2100000000001L8\",\"cdptid_code\":\"2901-_-1001\",\"cdptid_name\":\"A采购-矿\",\"cbizid\":\"0001A21000000004C0WH\",\"cbizid_code\":\"HI2304130007\",\"cbizid_name\":\"赵小稳\",\"cwarehouseid\":\"1010A2100000000001LQ\",\"cwarehouseid_code\":\"2901^C01\",\"cwarehouseid_name\":\"C总仓\",\"writeofftype\":\"按备料发料核销\",\"cinventoryid\":\"0001A21000000004C0SX\",\"cinventoryid_code\":\"testinvcode\",\"cinventoryid_name\":\"testinvname\",\"cinvbasid\":\"0001A21000000004C0IV\",\"cinvbasid_code\":\"testinvcode\",\"cinvbasid_name\":\"testinvname\",\"ninnum\":\"1.00000000\",\"nprice\":\"9.78000000\",\"nmoney\":\"9.78000000\",\"cgeneralhid\":\"1010A2100000000022VV\",\"cgeneralbid\":\"1010A2100000000022VW\",\"bomversion\":\"1.0\",\"orderid\":\"1010A2100000000022UI\",\"orderbid\":\"1010A2100000000022UJ\",\"pk_bodycalbody\":\"1010A2100000000001LI\",\"pk_bodycalbody_code\":\"2901-_-K1001\",\"pk_bodycalbody_name\":\"A总-管\"},\"childrenvo\":[{\"pk_corp\":\"1010\",\"pk_corp_code\":\"2901\",\"pk_corp_name\":\"lym投资控股有限公司\",\"crow\":\"BOM标准\",\"matermanid\":\"0001A210000000001FYU\",\"matermanid_code\":\"IN0007\",\"matermanid_name\":\"TEST11111\",\"materbasid\":\"0001ZZ10000000000DX1\",\"materbasid_code\":\"IN0007\",\"materbasid_name\":\"TEST11111\",\"bomnum\":\"1.00000000\",\"lossnum\":\"0.00000000\",\"pk_calbody\":\"1010A2100000000001LI\",\"bombid\":\"1010A21000000000225I\"},{\"pk_corp\":\"1010\",\"pk_corp_code\":\"2901\",\"pk_corp_name\":\"lym投资控股有限公司\",\"crow\":\"发料\",\"outsourcewarehouseid\":\"1010A210000000001Z0C\",\"outsourcewarehouseid_code\":\"2901^C13\",\"outsourcewarehouseid_name\":\"委外材料仓\",\"matermanid\":\"0001A210000000001FYU\",\"matermanid_code\":\"IN0007\",\"matermanid_name\":\"TEST11111\",\"materbasid\":\"0001ZZ10000000000DX1\",\"materbasid_code\":\"IN0007\",\"materbasid_name\":\"TEST11111\",\"writeoffnum\":\"1.00000000\",\"nmoney\":\"0.00000000\",\"pk_calbody\":\"1010A2100000000001LI\"},{\"pk_corp\":\"1010\",\"pk_corp_code\":\"2901\",\"pk_corp_name\":\"lym投资控股有限公司\",\"crow\":\"BOM标准\",\"matermanid\":\"0001A210000000001G02\",\"matermanid_code\":\"IN0014\",\"matermanid_name\":\"12344DDD\",\"materbasid\":\"0001ZZ10000000000DYW\",\"materbasid_code\":\"IN0014\",\"materbasid_name\":\"12344DDD\",\"bomnum\":\"1.00000000\",\"lossnum\":\"0.00000000\",\"pk_calbody\":\"1010A2100000000001LI\",\"bombid\":\"1010A21000000000225J\"},{\"pk_corp\":\"1010\",\"pk_corp_code\":\"2901\",\"pk_corp_name\":\"lym投资控股有限公司\",\"crow\":\"发料\",\"outsourcewarehouseid\":\"1010A210000000001Z0C\",\"outsourcewarehouseid_code\":\"2901^C13\",\"outsourcewarehouseid_name\":\"委外材料仓\",\"matermanid\":\"0001A210000000001G02\",\"matermanid_code\":\"IN0014\",\"matermanid_name\":\"12344DDD\",\"materbasid\":\"0001ZZ10000000000DYW\",\"materbasid_code\":\"IN0014\",\"materbasid_name\":\"12344DDD\",\"writeoffnum\":\"1.00000000\",\"astunitid\":\"0001A2100000000003DG\",\"hsl\":\"1.00000000\",\"nmoney\":\"0.00000000\",\"pk_calbody\":\"1010A2100000000001LI\"}]}]}",
    "taskNumber": "202310180006"
}

错误返回示例:

复制代码

{
    "status": "falied",
    "errorcode": "-32000",
    "errormsg": "U8C返回信息:未找到注册条件billcode1的数据库映射字段",
    "taskNumber": "202310180011"
}