Qeasy Cloud
Get Started

用友BIP 销售订单列表查询_v1 API

Platform
用友BIP
Type
WebAPI
Effect
QUERY
API Version
0.1
Adapter
\Adapter\YYBIP\BIPQueryAdapter
Auth Mode
OTHER
Help Link
https://open.diwork.com/iuap-api-management/ucf-wh/console-fe/open-home/index.html#/doc-center/docDes/api?code=yonbip&section=12406993fdf24559969621f65e25b53f
Doc Link
https://open.diwork.com/iuap-api-management/ucf-wh/console-fe/open-home/index.html#/doc-center/docDes/api?code=yonbip&section=12406993fdf24559969621f65e25b53f
Updated At
2022-06-21

销售订单列表查询_v1

POST/yonbip/sd/voucherorder/list
Factory
{
  "operation": {
    "method": "none"
  }
}

Request Parameters

No.FieldNameTypeDefaultRequiredDescription
1pageIndexpageIndexstring1Required页号    示例：1    默认值：1
2pageSizepageSizestring30Required每页行数    示例：10    默认值：10
3codecodestring1Optional单据编号    示例：UO-20220513000001
4nextStatusNamenextStatusNamestring1Optional订单状态, CONFIRMORDER:开立、DELIVERY_PART:部分发货、DELIVERY_TAKE_PART:部分发货待收货、DELIVERGOODS:待发货、TAKEDELIVERY:待收货、ENDORDER:已完成、OPPOSE:已取消、APPROVING:审批中、    示例：CONFIRMORDER
5open_orderDate_beginopen_orderDate_beginstring1Optional制单日期开始时间,格式为:yyyy-MM-dd HH:mm:ss    示例：2022-05-13 00:00:00
6open_orderDate_endopen_orderDate_endstring1Optional制单结束时间,格式为:yyyy-MM-dd HH:mm:ss    示例：2022-05-13 00:00:00
7open_confirmDate_beginopen_confirmDate_beginstring1Optional审核开始时间,格式为:yyyy-MM-dd HH:mm:ss    示例：2022-05-13 00:00:00
8open_confirmDate_endopen_confirmDate_endstring1Optional审核截止时间,格式为:yyyy-MM-dd HH:mm:ss    示例：2022-05-13 00:00:00
9open_hopeReceiveDate_beginopen_hopeReceiveDate_beginstring1Optional期望收货开始时间,格式为:yyyy-MM-dd HH:mm:ss    示例：2022-05-13 00:00:00
10open_hopeReceiveDate_endopen_hopeReceiveDate_endstring1Optional期望收货截止,格式为:yyyy-MM-dd HH:mm:ss    示例：2022-05-13 00:00:00
11open_vouchdate_beginopen_vouchdate_beginstring1Optional单据开始时间,格式为:yyyy-MM-dd HH:mm:ss    示例：2022-05-13 00:00:00
12open_vouchdate_endopen_vouchdate_endstring1Optional单据截止时间,格式为:yyyy-MM-dd HH:mm:ss    示例：2022-05-13 00:00:00
13isSumisSumstring1Optional查询表头    示例：false    默认值：false

Response Parameters

No.FieldNameTypeDefaultRequiredDescription
1codecodestring1Optional单据编号
2vouchdatevouchdatestring1Optional单据日期
3ididstring1Optional主体ID
4parentOrderNoparentOrderNostring1Optional父级订单号
5salesOrgIdsalesOrgIdstring1Optional销售组织id
6salesOrgId_namesalesOrgId_namestring1Optional销售组织名称
7saleDepartmentIdsaleDepartmentIdstring1Optional销售部门id
8transactionTypeIdtransactionTypeIdstring1Optional交易类型id
9transactionTypeId_nametransactionTypeId_namestring1Optional交易类型名称
10agentIdagentIdstring1Optional客户id
11agentId_nameagentId_namestring1Optional客户名称
12receiveContacterreceiveContacterstring1Optional客户联系人
13receiveContacterPhonereceiveContacterPhonestring1Optional客户联系人电话
14purchaseNopurchaseNostring1Optional客户采购订单号
15corpContactUserNamecorpContactUserNamestring1Optional销售业务员
16settlementOrgId_namesettlementOrgId_namestring1Optional开票组织名称
17corpContactUserErpCodecorpContactUserErpCodestring1Optional业务员erp编码
18orderPricesorderPricesarray1Optional订单价格
19payMoneypayMoneystring1Optional合计含税金额
20orderPayMoneyorderPayMoneystring1Optional商品实付金额
21realMoneyrealMoneystring1Optional应收金额
22orderRealMoneyorderRealMoneystring1Optional商品应付金额
23statusCodestatusCodestring1Optional订单当前状态码
24nextStatusnextStatusstring1Optional订单状态,CONFIRMORDER:开立、DELIVERY_PART:部分发货、DELIVERY_TAKE_PART:部分发货待收货、DELIVERGOODS:待发货、TAKEDELIVERY:待收货、ENDORDER:已完成、OPPOSE:已取消、APPROVING:审批中、
25currentStatuscurrentStatusstring1Optional当前状态位置
26payStatusCodepayStatusCodestring1Optional付款状态,NOTPAYMENT:未付款、PARTPAYMENT:部分付款、CONFIRMPAYMENT:部分付款待确认、CONFIRMPAYMENT_ALL:付款待确认、FINISHPAYMENT:付款完成、
27settlementOrgIdsettlementOrgIdstring1Optional开票组织id
28lockInlockInstring1Optional标记锁
29confirmDateconfirmDatestring1Optional订单确认时间
30payDatepayDatestring1Optional订单付款时间
31orderPayTypeorderPayTypestring1Optional支付方式
32settlementsettlementstring1Optional结算方式id
33shippingChoiceIdshippingChoiceIdstring1Optional发运方式id
34sendDatesendDatestring1Optional预计发货日期
35hopeReceiveDatehopeReceiveDatestring1Optional期望收货日期
36opposeMemoopposeMemostring1Optional驳回批注
37haveDeliveryhaveDeliverystring1Optional是否存在发货单
38occupyInventoryoccupyInventorystring1Optional库存占用时机标识
39separatePromotionTypeseparatePromotionTypestring1Optional拆单规则标识
40reightreightstring1Optional运费
41synSourceOrgsynSourceOrgstring1Optional协同来源组织id
42synSourceTenantsynSourceTenantstring1Optional协同来源租户
43pointsMoneypointsMoneystring1Optional积分抵扣金额
44synSourceOrg_namesynSourceOrg_namestring1Optional协同来源组织名称
45totalMoneytotalMoneystring1Optional总金额
46tagNametagNamestring1Optional采购组织弹框
47rebateMoneyrebateMoneystring1Optional返利金额
48rebateCashMoneyrebateCashMoneystring1Optional抵现金额
49particularlyMoneyparticularlyMoneystring1Optional特殊优惠
50promotionMoneypromotionMoneystring1Optional促销
51unConfirmPriceunConfirmPricestring1Optional未审核的金额
52confirmPriceconfirmPricestring1Optional已支付金额
53bizIdbizIdstring1Optional商家id
54bizNamebizNamestring1Optional商家名称
55agentRelationIdagentRelationIdstring1Optional客户交易关系id
56pointspointsstring1Optional积分
57pubtspubtsstring1Optional时间戳,格式为:yyyy-MM-ddHH:mm:ss
58pubutspubutsstring1Optional时间戳
59orderInvoiceorderInvoicestring1Optional发票信息
60orderShippingAddressorderShippingAddressstring1Optional收货地址信息
61orderErporderErpstring1Optional订单erp
62deliveryDatedeliveryDatestring1Optional交货日期
63isWfControlledisWfControlledstring1Optional是否审批流控制
64verifystateverifystatestring1Optional审批状态
65statusstatusstring1Optional状态
66isFinishDeliveryisFinishDeliverystring1Optional订单是否发完货
67productId_pbatchNameproductId_pbatchNamestring1Optional商品包装单位
68idKeyidKeystring1Optional行标识
69productIdproductIdstring1Optional商品id
70isBatchManageisBatchManagestring1Optional是否批次管理
71isExpiryDateManageisExpiryDateManagestring1Optional是否有效期管理
72expireDateNoexpireDateNostring1Optional保质期
73expireDateUnitexpireDateUnitstring1Optional保质期单位
74skuIdskuIdstring1Optional商品SKUid
75erpCodeerpCodestring1OptionalskuERP编码
76orderProductTypeorderProductTypestring1Optional商品售卖类型,SALE:销售品、GIFT:赠品、MARKUP:加价购、REBATE:返利商品、
77productCodeproductCodestring1Optional商品编码
78productNameproductNamestring1Optional商品名称
79skuCodeskuCodestring1OptionalSKU编码
80specDescriptionspecDescriptionstring1Optional规格描述
81projectIdprojectIdstring1Optional项目id
82unitExchangeTypeunitExchangeTypestring1Optional浮动（计价）
83unitExchangeTypePriceunitExchangeTypePricestring1Optional浮动（销售）
84productAuxUnitNameproductAuxUnitNamestring1Optional销售单位
85invExchRateinvExchRatestring1Optional销售换算率
86subQtysubQtystring1Optional销售数量
87productUnitNameproductUnitNamestring1Optional计价单位
88invPriceExchRateinvPriceExchRatestring1Optional计价换算率
89priceQtypriceQtystring1Optional计价数量
90qtyNameqtyNamestring1Optional主计量
91qtyqtystring1Optional数量
92orderDetailPricesorderDetailPricesstring1Optional订单商品金额
93stockNamestockNamestring1Optional发货仓库
94stockOrgId_namestockOrgId_namestring1Optional库存组织
95consignTimeconsignTimestring1Optional计划发货日期
96projectId_nameprojectId_namestring1Optional项目名称
97projectId_codeprojectId_codestring1Optional项目编码
98salePricesalePricestring1Optional含税报价
99taxIdtaxIdstring1Optional数目税率id
100saleCostsaleCoststring1Optional报价含税金额
101stockIdstockIdstring1Optional仓库ID
102oriTaxUnitPriceoriTaxUnitPricestring1Optional含税成交价
103orderDetails_stockOrgIdorderDetails_stockOrgIdstring1Optional库存组织id
104oriSumoriSumstring1Optional含税金额
105taxRatetaxRatestring1Optional税率
106taxItemstaxItemsstring1Optional税目
107taxCodetaxCodestring1Optional税目税率编码
108shoppingCartIdshoppingCartIdstring1Optional购物车id
109groupIdgroupIdstring1Optional分组Id
110rebateReturnProductIdrebateReturnProductIdstring1Optional返货单商品id
111mutualActivitiesmutualActivitiesstring1Optional活动的对象,用于校验互斥活动
112activitiesactivitiesstring1Optional包含的类型,用于校验互斥
113sendPayMoneysendPayMoneystring1Optional累计已发货含税金额
114invoiceQtyinvoiceQtystring1Optional累计开票数量
115invoiceOriSuminvoiceOriSumstring1Optional累计开票含税金额
116bizProductIdbizProductIdstring1Optional商家商品id
117takeQuantitytakeQuantitystring1Optional已审核收数量
118bizSkuIdbizSkuIdstring1Optional商家skuid
119takeSalePayMoneytakeSalePayMoneystring1Optional已审核收金额
120orderDetailPriceorderDetailPricestring1Optional订单金额
121sendQtysendQtystring1Optional累计已发货数量
122closedSumMoneyclosedSumMoneystring1Optional关闭总金额
123closedRowCountclosedRowCountstring1Optional行关闭数量
124iDeletediDeletedstring1Optional未定义名称
125iOrgIdiOrgIdstring1Optional组织ID
126memomemostring1Optional备注
127createDatecreateDatestring1Optional创建日期
128creatorIdcreatorIdstring1Optional创建人
129auditorIdauditorIdstring1Optional审核人ID
130auditDateauditDatestring1Optional审批日期
131closerIdcloserIdstring1Optional关闭人ID
132closeDatecloseDatestring1Optional关闭日期
133modifierIdmodifierIdstring1Optional修改人id
134modifyDatemodifyDatestring1Optional修改日期
135cCreatorcCreatorstring1Optional创建人
136iProductAuxUnitIdiProductAuxUnitIdstring1Optional销售单位id
137iProductUnitIdiProductUnitIdstring1Optional计价单位id
138masterUnitIdmasterUnitIdstring1Optional主计量单位id
139purUOM_PrecisionpurUOM_Precisionstring1Optional销售单位精度
140priceUOM_PrecisionpriceUOM_Precisionstring1Optional计价单位精度
141unit_Precisionunit_Precisionstring1Optional主计量单位精度
142cBizNamecBizNamestring1Optional供应商名称
143orderDetailIdorderDetailIdstring1Optional主体ID
144orderIdorderIdstring1Optional订单ID
145creatorcreatorstring1Optional创建人
146createTimecreateTimestring1Optional创建时间
147auditorauditorstring1Optional审批人
148auditTimeauditTimestring1Optional审批时间
149closeTimecloseTimestring1Optional关闭时间
150closercloserstring1Optional关闭人
151modifiermodifierstring1Optional修改人
152modifyTimemodifyTimestring1Optional修改时间
153bmake_st_salesoutbmake_st_salesoutstring1Optional流程入库
154bmake_voucher_deliverybmake_voucher_deliverystring1Optional流程发货
155bizFlowbizFlowstring1Optional流程ID
156bmake_voucher_saleinvoicebmake_voucher_saleinvoicestring1Optional流程开票
157isFlowCoreBillisFlowCoreBillstring1Optional是否流程核心单据
158bizFlow_versionbizFlow_versionstring1Optional版本信息
159batchNobatchNostring1Optional批次号
160productDateproductDatestring1Optional生产日期
161invalidDateinvalidDatestring1Optional有效期至
162currencycurrencystring1Optional币种id
163currency_priceDigitcurrency_priceDigitstring1Optional原币单价精度
164currency_moneyDigitcurrency_moneyDigitstring1Optional原币金额精度
165originalNameoriginalNamestring1Optional币种
166natCurrencynatCurrencystring1Optional本币pk
167natCurrency_priceDigitnatCurrency_priceDigitstring1Optional本币单价精度
168natCurrency_moneyDigitnatCurrency_moneyDigitstring1Optional本币金额精度
169domesticCodedomesticCodestring1Optional本币简称
170domesticNamedomesticNamestring1Optional本币
171exchRateexchRatestring1Optional汇率
172exchangeRateType_nameexchangeRateType_namestring1Optional汇率类型名称
173exchangeRateTypeexchangeRateTypestring1Optional汇率类型Idid

The 销售订单列表查询_v1 API (/yonbip/sd/voucherorder/list) of 用友BIP is curated by the API asset management module of the Qeasy Cloud data integration platform and kept in sync with 用友BIP version updates.

Need to integrate this API?

Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.

Contact Us