API中心

  1. 销售管理
  2. 销售订单
返回

销售订单查询

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

参数填写指南

请求方式:POST

请求参数(header):

参数填写指南
参数名必填描述默认值
Content-Type请求体数据类型application/json
usercode用户
password密码
system系统参数

请求参数(body):

参数名类型是否数组必填描述默认值
calbody库存组织
cbiztype业务类型(即:业务流程)
cemployeeid业务员(5.2及以后支持)
code单据号
corp公司
customer客户
date_begin单据日期起始(v3.5版本前必填)
date_end单据日期结束(v3.5版本前必填)
dept部门
inventory存货
maker制单人
page_now当前页
page_size每页数量
salecorp销售组织
status单据状态
ts_begin时间戳(开始)
ts_end时间戳(结束)

返回类型参数:

参数名类型是否数组必填描述默认值
saleorder销售订单查询返回实体
children
advisecalbody_codestring发货库存组组织code
advisecalbody_namestring发货库存组组织name
bbindflagstring是否捆绑存货
bdericttransstring是否直运
blargessflagstring是否赠品
boosflagstring缺货标志
breturnprofitstring是否参与返利
bsafepricestring是否参与价保
bsupplyflagstring补货标志
cadvisecalbodyidstring建议发货库存组织
cbatchidstring批次
cbatchid string批次
cbodywarehouseidstring发货仓库主键
cbomorderidstring配置单ID
cchantypeidstring渠道类型ID
cconsigncorpidstring发货公司
ccurrencytypeidstring原币
cfactoryidstring工厂ID
cfreezeidstring库存冻结ID
cinvbasdocidstring存货档案主键
cinventoryidstring存货ID
cinventoryid1string存货ID1
clargessrownostring主存货行号
consigncorp_codestring发货公司code
consigncorp_namestring发货公司name
coperatoridstring制单人
corder_bidstring销售订单附表ID
cpackunitidstring辅单位
cpricecalprocstring价格计算过程
cpriceitemidstring价格项目ID
cpriceitemtablestring价目表
cpricepolicyidstring价格政策ID
cprolineidstring产品线
cprovideridstring供应商
cquoteunitidstring报价计量单位
crecaddrnodestring收货地点
creccalbodyidstring收货库存组织
creceiptareaidstring收货地区
creceiptcorpidstring收货单位
creceipttypestring来源单据类型(V5.1开始支持)
crecwareidstring收货仓库
crownostring行号
csaleidstring销售主表ID
csourcebillbodyidstring来源单据附表ID(V5.1开始支持)
csourcebillidstring来源单据主表ID(V5.1开始支持)
ct_managebidstring合同行ID
ct_manageidstring合同ID
cunitidstring主计量单位
dconsigndatestring发货日期
ddeliverdatestring交货日期
dept_codestring部门code
dept_namestring部门name
drint删除标志
fbatchstatusint批次状态
frownotestring行备注
frowstatusint行状态
inventory_codestring存货code
inventory_namestring存货name
nastretprofnumdouble已参与返利辅数量
nasttaldcnumdouble已参与价保辅数量
ndiscountmnydouble本币折扣额
ndiscountratedouble整单折扣
nestbalancenumberstring累计暂估应收
nexchangeotobratedouble折本汇率
nitemdiscountratedouble单品折扣率
nmnydouble本币无税金额
nnetpricedouble本币无税净价
nnumberdouble数量
norgqtnetprcdouble报价单位无税净价
norgqtprcdouble报价单位无税单价
norgqttaxnetprcdouble报价单位含税净价
norgqttaxprcdouble报价单位含税单价
noriginalcurdiscountmnydouble原币折扣额
noriginalcurmnydouble原币无税金额
noriginalcurnetpricedouble原币无税净价
noriginalcurpricedouble原币无税单价
noriginalcursummnydouble原币价税合计
noriginalcurtaxmnydouble原币税额
noriginalcurtaxnetpricedouble原币含税净价
noriginalcurtaxpricedouble原币含税单价
npacknumberdouble辅数量
npricedouble本币无税单价
nqtnetprcdouble报价单位本币无税净价
nqtorgnetprcdouble询价原币无税净价
nqtorgprcdouble询价原币无税单价
nqtorgtaxnetprcdouble询价原币含税净价
nqtorgtaxprc double询价原币含税单价
nqtprcdouble报价单位本币无税单价
nqttaxnetprcdouble报价单位本币含税净价
nqttaxprcdouble报价单位本币含税单价
nquoteunitnumdouble报价单位数量
nquoteunitratedouble报价计量单位换算率
nretprofmnydouble返利金额
nretprofnumdouble已参与返利主数量
nreturntaxratedouble出口退税率
nsummnydouble本币价税合计
ntaldcmnydouble价保金额
ntaldcnumdouble已参与价保主数量
ntaxmnydouble本币税额
ntaxnetpricedouble本币含税净价
ntaxpricedouble本币含税单价
ntaxratedouble税率
ntotalbalancenumberstring累计应收确认数量
ntotalinventorynumberstring累计出库
ntotalinvoicenumberstring累计开票
ntotalpaymnystring累计收款金额
ntotalreceivenumberstring累计发货数量
ntotlbalcostnumstring累计成本结算数量
packunit_codestring辅单位code
packunit_namestring辅单位name
pk_corpstring公司主键
recaddrnode_codestring收货地点code
recaddrnode_namestring收货地点name
receiptarea_codestring收货地区code
receiptarea_namestring收货地区name
receiptcorp_codestring开票单位code
receiptcorp_namestring开票单位name
tconsigntimestring发货时间
tdelivertimestring到货时间
tsstring时间戳
unit_codestring单位code
unit_namestring单位name
veditreasonstring修订理由
vreceiveaddressstring收货地址
warehouse_codestring发货仓库code
warehouse_namestring发货仓库name
parent
approver_codestring审批人code
approver_namestring审批人name
bcooptopostring是否已协同生成采购订单
bfreecustflagstring是否散户
binitflagstring期初标志
binvoicendflagstring开票关闭标记
biztype_codestring业务类型code
biztype_namestring业务类型name
boutendflagstring出库关闭标记
boverdatestring是否超帐期
bpayendflagstring付款关闭标记
bpocooptomestring是否由采购订单协同生成
breceiptendflagstring发货关闭标记
bretinvflagstring退货标记
btransendflagstring运输关闭标志
calbody_codestring库存组织code
calbody_namestring库存组织name
capproveidstring审批人
cbaltypeidstring结算方式
cbiztypestring业务类型
ccalbodyidstring库存组织
ccooppohidstring对方订单号
ccreditnumstring信用证号
ccustbankidstring开户银行
ccustomeridstring客户
cdeptidstring部门
cemployeeidstring业务员
cfreecustidstring散户ID
coperatoridstring制单人
corp_codestring公司code
corp_namestring公司name
creceiptareaidstring收货地区
creceiptcorpidstring开票单位
creceiptcustomeridstring收货单位
creceipttypestring单据类型
csalecorpidstring销售组织
csaleidstring销售主表ID
ctermprotocolidstring收款协议
ctransmodeidstring运输方式
customer_codestring客户code
customer_namestring客户name
cwarehouseidstring仓库
dapprovedatestring审批日期
daudittimestring审批时间
dbilldatestring日期
dbilltimestring制单时间
dept_codestring部门code
dept_namestring部门name
dmakedatestring制单日期
dmoditimestring最后修改时间
drint删除标志
editauthorstring修订人
editdatestring修订日期
editionnumstring修订版本号
employee_codestring业务员code
employee_namestring业务员name
finvoiceclassdouble发票类别
finvoicetypedouble发票类型
fstatusdouble状态
ibalanceflagdouble结算标志
iprintcountstring打印次数
naccountperioddouble帐期
ndiscountratedouble整单折扣
nevaluatecarriagedouble预估运费
nheadsummnydouble金额合计
npreceivemnydouble预收款金额
npreceiveratedouble预收款比例
nsubscriptiondouble订金
operator_codestring制单人code
operator_namestring制单人name
pk_corpstring公司
pk_defdoc1string自定义项1
pk_defdoc10string自定义项10
pk_defdoc11string自定义项11
pk_defdoc12string自定义项12
pk_defdoc13string自定义项13
pk_defdoc14string自定义项14
pk_defdoc15string自定义项15
pk_defdoc16string自定义项16
pk_defdoc17string自定义项17
pk_defdoc18string自定义项18
pk_defdoc19string自定义项19
pk_defdoc2string自定义项2
pk_defdoc20string自定义项20
pk_defdoc3string自定义项3
pk_defdoc4string自定义项4
pk_defdoc5string自定义项5
pk_defdoc6string自定义项6
pk_defdoc7string自定义项7
pk_defdoc8string自定义项8
pk_defdoc9string自定义项9
receiptarea_codestring收货地区code
receiptarea_namestring收货地区name
receiptcorp_codestring开票单位code
receiptcorp_namestring开票单位name
receiptcustomer_codestring收货单位code
receiptcustomer_namestring收货单位name
salecorp_codestring销售组织code
salecorp_namestring销售组织name
transmode_codestring运输方式code
transmode_namestring运输方式name
tsstring时间戳
vaccountyearstring会计年度
vdef1string自定义项1
vdef10string自定义项10
vdef11string自定义项11
vdef12string自定义项12
vdef13string自定义项13
vdef14string自定义项14
vdef15string自定义项15
vdef16string自定义项16
vdef17string自定义项17
vdef18string自定义项18
vdef19string自定义项19
vdef2string自定义项2
vdef20string自定义项2-
vdef3string自定义项3
vdef4string自定义项4
vdef5string自定义项5
vdef6string自定义项6
vdef7string自定义项7
vdef8string自定义项8
vdef9string自定义项9
veditreasonstring修订理由
vnotestring备注
vreceiptcodestring单据号
vreceiveaddressstring收货地址

请求参数示例:

复制代码

{"corp":"1000","date_begin":"2018-04-12","date_end":"2018-04-12,"page_now":"1","page_size":"2","ts_begin":"2021-08-09 14:32:00","ts_end":"2021-08-10 14:32:00"}

正确返回示例:

复制代码

{

status: "success",

data: "{"allcount":2,"retcount":2,"datas":[{"parentvo":{"pk_corp":"1001","corp_code":"1000","corp_name":"天海总公司","cbiztype":"1001111000000000001W","biztype_code":"so02","biztype_name":"普通销售","ccustomerid":"000111100000000008Z2","customer_code":"1000","customer_name":"天海总公司","csalecorpid":"00011110000000000999","salecorp_code":"1001","salecorp_name":"天海销售总公司销售组织","ccalbodyid":"100111100000000000OQ","calbody_code":"1000","calbody_name":"天海集团库存组织","coperatorid":"0001ZZ10000000006JC9","operator_code":"18612329914","operator_name":"罗建伟","cdeptid":"100111100000000000PD","dept_code":"107","dept_name":"销售部门","vreceiptcode":"SOTH1804120005","dbilldate":"2018-04-12","dmakedate":"2018-04-12","dbilltime":"2018-04-12 17:26:05","creceiptcustomerid":"000111100000000008Z2","receiptcustomer_code":"1000","receiptcustomer_name":"天海总公司","creceiptcorpid":"000111100000000008Z2","receiptcorp_code":"1000","receiptcorp_name":"天海总公司","ndiscountrate":100},"childrenvo":[{"cinventoryid":"00011110000000000ETJ","inventory_code":"010101","inventory_name":"米奇宝新生儿配方奶粉900g","nnumber":1,"noriginalcursummny":1.17,"cunitid":"000111100000000006JA","unit_code":"10","unit_name":"罐","creceiptcorpid":"000111100000000008Z2","cadvisecalbodyid":"100111100000000000OQ","advisecalbody_code":"1000","advisecalbody_name":"天海集团库存组织","cconsigncorpid":"1001","consigncorp_code":"1000","consigncorp_name":"天海总公司","cpackunitid":"000111100000000006J4","packunit_code":"05","packunit_name":"箱","blargessflag":false,"noriginalcurprice":1,"crowno":"10","npacknumber":0.17,"ntaxrate":17,"noriginalcurtaxprice":1.17,"noriginalcurmny":1,"noriginalcurtaxmny":0.17,"ndiscountrate":100,"nitemdiscountrate":100,"noriginalcurnetprice":1,"noriginalcurtaxnetprice":1.17,"noriginalcurdiscountmny":0E-8,"dconsigndate":"2018-04-12","ddeliverdate":"2018-04-12","pk_defdoc1":"0001D11000000000P94E","vdef1":"封存流程"},{"cinventoryid":"00011110000000000ETH","inventory_code":"010102","inventory_name":"米奇宝婴幼儿配方奶粉900g","nnumber":1,"noriginalcursummny":1.17,"cunitid":"000111100000000006JA","unit_code":"10","unit_name":"罐","creceiptcorpid":"000111100000000008Z2","cadvisecalbodyid":"100111100000000000OQ","advisecalbody_code":"1000","advisecalbody_name":"天海集团库存组织","cconsigncorpid":"1001","consigncorp_code":"1000","consigncorp_name":"天海总公司","cpackunitid":"000111100000000006J4","packunit_code":"05","packunit_name":"箱","blargessflag":false,"noriginalcurprice":1,"crowno":"20","npacknumber":0.17,"ntaxrate":17,"noriginalcurtaxprice":1.17,"noriginalcurmny":1,"noriginalcurtaxmny":0.17,"ndiscountrate":100,"nitemdiscountrate":100,"noriginalcurnetprice":1,"noriginalcurtaxnetprice":1.17,"noriginalcurdiscountmny":0E-8,"dconsigndate":"2018-04-12","ddeliverdate":"2018-04-12","pk_defdoc1":"0001D11000000000P94F","vdef1":"租金计算"}]},{"parentvo":{"pk_corp":"1001","corp_code":"1000","corp_name":"天海总公司","cbiztype":"1001111000000000001W","biztype_code":"so02","biztype_name":"普通销售","ccustomerid":"000111100000000008Z2","customer_code":"1000","customer_name":"天海总公司","csalecorpid":"00011110000000000999","salecorp_code":"1001","salecorp_name":"天海销售总公司销售组织","ccalbodyid":"100111100000000000OQ","calbody_code":"1000","calbody_name":"天海集团库存组织","coperatorid":"0001ZZ10000000006JC9","operator_code":"18612329914","operator_name":"罗建伟","cdeptid":"100111100000000000PD","dept_code":"107","dept_name":"销售部门","vreceiptcode":"SOTH1804120004","dbilldate":"2018-04-12","dmakedate":"2018-04-12","dbilltime":"2018-04-12 17:25:44","creceiptcustomerid":"000111100000000008Z2","receiptcustomer_code":"1000","receiptcustomer_name":"天海总公司","creceiptcorpid":"000111100000000008Z2","receiptcorp_code":"1000","receiptcorp_name":"天海总公司","ndiscountrate":100},"childrenvo":[{"cinventoryid":"00011110000000000ETJ","inventory_code":"010101","inventory_name":"米奇宝新生儿配方奶粉900g","nnumber":1,"noriginalcursummny":1.17,"cunitid":"000111100000000006JA","unit_code":"10","unit_name":"罐","creceiptcorpid":"000111100000000008Z2","cadvisecalbodyid":"100111100000000000OQ","advisecalbody_code":"1000","advisecalbody_name":"天海集团库存组织","cconsigncorpid":"1001","consigncorp_code":"1000","consigncorp_name":"天海总公司","cpackunitid":"000111100000000006J4","packunit_code":"05","packunit_name":"箱","blargessflag":false,"noriginalcurprice":1,"crowno":"10","npacknumber":0.17,"ntaxrate":17,"noriginalcurtaxprice":1.17,"noriginalcurmny":1,"noriginalcurtaxmny":0.17,"ndiscountrate":100,"nitemdiscountrate":100,"noriginalcurnetprice":1,"noriginalcurtaxnetprice":1.17,"noriginalcurdiscountmny":0E-8,"dconsigndate":"2018-04-12","ddeliverdate":"2018-04-12","pk_defdoc1":"0001D11000000000P94E","vdef1":"封存流程"},{"cinventoryid":"00011110000000000ETH","inventory_code":"010102","inventory_name":"米奇宝婴幼儿配方奶粉900g","nnumber":1,"noriginalcursummny":1.17,"cunitid":"000111100000000006JA","unit_code":"10","unit_name":"罐","creceiptcorpid":"000111100000000008Z2","cadvisecalbodyid":"100111100000000000OQ","advisecalbody_code":"1000","advisecalbody_name":"天海集团库存组织","cconsigncorpid":"1001","consigncorp_code":"1000","consigncorp_name":"天海总公司","cpackunitid":"000111100000000006J4","packunit_code":"05","packunit_name":"箱","blargessflag":false,"noriginalcurprice":1,"crowno":"20","npacknumber":0.17,"ntaxrate":17,"noriginalcurtaxprice":1.17,"noriginalcurmny":1,"noriginalcurtaxmny":0.17,"ndiscountrate":100,"nitemdiscountrate":100,"noriginalcurnetprice":1,"noriginalcurtaxnetprice":1.17,"noriginalcurdiscountmny":0E-8,"dconsigndate":"2018-04-12","ddeliverdate":"2018-04-12","pk_defdoc1":"0001D11000000000P94F","vdef1":"租金计算"}]}]}"

}

错误返回示例:

复制代码

{

status: "falied",

errorcode: "-32000",

errormsg: "查询条件不能输入单引号!",

stacktrace: "u8c.vo.entity.APICondition.checkError(APICondition.java:139);u8c.bs.action.query.AbstractQueryAction.convertToConditions(AbstractQueryAction.java:147);u8c.bs.action.query.AbstractQueryAction.doAction(AbstractQueryAction.java:58);u8c.bs.invoke.bp.JSONInvokeBP.invoke(JSONInvokeBP.java:60);u8c.impl.invoke.json.InvokeWithJSonImpl.invoke(InvokeWithJSonImpl.java:25);sun.reflect.GeneratedMethodAccessor393.invoke(Unknown Source);sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43);java.lang.reflect.Method.invoke(Method.java:606);nc.bs.framework.ejb.CMTProxyImpl.delegate(CMTProxyImpl.java:22);nc.itf.framework.ejb.CMTProxyEjbBean.delegate(CMTProxyEjbBean.java:44);nc.itf.framework.ejb.CMTProxy_Local.delegate(CMTProxy_Local.java:61);sun.reflect.GeneratedMethodAccessor37.invoke(Unknown Source);sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43);java.lang.reflect.Method.invoke(Method.java:606);nc.bs.framework.ejb.AbstractEJBServiceHandler.invoke(AbstractEJBServiceHandler.java:56);nc.bs.framework.ejb.AbstractEJBServiceHandler.invoke(AbstractEJBServiceHandler.java:34);com.sun.proxy.$Proxy11.delegate(Unknown Source);nc.bs.framework.ejb.CMTEJBServiceHandler.invoke(CMTEJBServiceHandler.java:32);com.sun.proxy.$Proxy31.invoke(Unknown Source);u8c.server.APIServletForJSON.doAction(APIServletForJSON.java:117);nc.bs.framework.server.api.InvokerAPIServlet.doAction(InvokerAPIServlet.java:130);nc.bs.framework.server.api.InvokerAPIServlet.doPost(InvokerAPIServlet.java:65);javax.servlet.http.HttpServlet.service(HttpServlet.java:650);javax.servlet.http.HttpServlet.service(HttpServlet.java:731);org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303);org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208);org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52);org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241);org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208);nc.bs.framework.server.LoggerServletFilter.doFilter(LoggerServletFilter.java:34);org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241);org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208);org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218);org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110);org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506);org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169);org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103);org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:683);org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116);org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445);org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115);org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637);org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316);java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145);java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615);org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61);java.lang.Thread.run(Thread.java:745);"

}