基本信息
- 用途说明：产品档案列表查询接口（单据标识：wg_product_record）
- 请求方式：POST
- 请求地址：https://api.kingdee.com/weigusoft/wg_cost/loadList?access_token=&authority_info=
headers参数
- 所有的接口必须携带header参数
| 参数名称 | 参数示例 | 是否必填 | 参数说明 |
|---|---|---|---|
| Content-Type | application/json | true | 固定传：application/json |
| groupName | ns-v7g6 | true | 分组名称，获取授权信息时返回的groupName |
| accountId | 16xxxxxxxxxxxx | true | 账套ID，获取授权信息时返回的accountId |
| X-GW-Router-Addr | https://tf.jdy.com | true | IDC域名，获取授权信息时返回的domain |
| Appuserid | 10102023 | true | 当前登录用户id |
params参数
| 参数名称 | 参数类型 | 是否必填 | 参数说明 |
|---|---|---|---|
| access_token | string | true | 金蝶云通行证token |
| authority_info | string | true | 见文档authority_info参数说明 |
body参数
| 参数名称 | 必选 | 类型 | 说明 |
|---|---|---|---|
| entityName | true | String | 单据标识：wg_product_record |
| pageindex | true | Number | 当前页（默认1） |
| pagesize | true | Number | 每页显示条数 |
| andQfilters | false | Array |
"andQfilters": [ { "property": "billno", "cp": "=", "value": "JK-20240219-00001" }], //与条件 |
| orQfilters | false | Array |
orQfilters": [ { "property": "billno", //条件字段标识 "cp": "=", //条件符号 "value": "JK-20240219-00001" //条件值，like的要加% }], //或条件 |
| onlyBasic | false | Boolean |
是否只获取基本信息，名称和编码 |
| onlyCount | false | Boolean |
是否只获取数量 |
| haveMatPic | false | Boolean |
是否返回物料图片 |
| srcType | false | String |
上一个页面单据类型 |
| srcId | false | String |
上一个页面单据id |
| exclude | false | Boolean |
是否有排除的 |
| level | false | String |
基础资料查到哪一层，例："1" |
返回参数
| 字段名称 | 类型 | 说明 |
|---|---|---|
| number | String | 档案编号 |
| outbillno | String | 出库单号 |
| outdate | String | 出库日期 |
| materielfield | String | 物料 |
| wg_basedatapropfield | String | 产品名称 |
| model | String | 规格型号 |
| unitfield | String | 计量单位 |
| serialnumber | String | 序列号 |
| batchno | String | 批号 |
| qtyfield | String | 数量 |
| buycust | String | 购买客户 |
| servicecust | String | 服务客户 |
| wg_admindivisionfield | String | 服务地区 |
| wg_address | String | 详细地址 |
| duedate | String | 保修到期日 |
| orderno | String | 订单单号 |
| bomid | String | BOM版本 |
| project | String | 项目 |
| creator | String | 创建人 |
| createtime | String | 创建时间 |
| modifier | String | 修改人 |
| modifytime | String | 修改时间 |
| status | String | 单据状态，A:创建，B:审核中，C:已审核，D:重新审核 |
| enable | String | 使用状态，1：可用，0：禁用 |
请求示例
{
"pageindex": 1,
"pagesize": 10,
"entityName": "wg_product_record",
"selectProperties": "number,outbillno,outdate,materielfield.number,materielfield.name,model,unitfield.name,serialnumber,batchno,qtyfield,buycust.name,servicecust.name,duedate,orderno,bomid.number,project.name,status,enable,wg_admindivisionfield,wg_address,entryentity",
"orQfilters": [
{
"property": "number",
"cp": "like",
"value": "%CPDA-20250716-00000005%"
},
{
"property": "outbillno",
"cp": "like",
"value": "%CPDA-20250716-00000005%"
},
{
"property": "materielfield.name",
"cp": "like",
"value": "%CPDA-20250716-00000005%"
},
{
"property": "model",
"cp": "like",
"value": "%CPDA-20250716-00000005%"
},
{
"property": "batchno",
"cp": "like",
"value": "%CPDA-20250716-00000005%"
},
{
"property": "serialnumber",
"cp": "like",
"value": "%CPDA-20250716-00000005%"
},
{
"property": "materielfield.barcode",
"cp": "like",
"value": "%CPDA-20250716-00000005%"
}
],
"andQfilters": [
{
"property": "enable",
"cp": "=",
"value": "1"
}
],
"onlyBasic": false,
"level": "2"
}
crul:
curl ^"https://api.kingdee.com/weigusoft/wg_cost/loadList?access_token=1752460583ed0aefabd40ef6d7d9c3be^&authority_info=suTn5vQKI76SVXWhBv+mJog3APYWO88oWZIS4jfts59b7mqQZ7Wm6SahvOKK+2U2^" ^
-H ^"Accept: */*^" ^
-H ^"Accept-Language: zh-CN,zh;q=0.9^" ^
-H ^"Appuserid: 12888398^" ^
-H ^"Connection: keep-alive^" ^
-H ^"Content-Type: application/json;charset=UTF-8^" ^
-H ^"Origin: http://localhost:5173^" ^
-H ^"Referer: http://localhost:5173/^" ^
-H ^"Sec-Fetch-Dest: empty^" ^
-H ^"Sec-Fetch-Mode: cors^" ^
-H ^"Sec-Fetch-Site: cross-site^" ^
-H ^"User-Agent: Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1^" ^
-H ^"X-GW-Router-Addr: https://tf-ek.jdy.com^" ^
-H ^"access_token: 1752460583ed0aefabd40ef6d7d9c3be^" ^
-H ^"accountId: 1675743896569628608^" ^
-H ^"groupName: ns-isv5^" ^
--data-raw ^"^{^\^"pageindex^\^":1,^\^"pagesize^\^":10,^\^"entityName^\^":^\^"wg_product_record^\^",^\^"selectProperties^\^":^\^"number,outbillno,outdate,materielfield.number,materielfield.name,model,unitfield.name,serialnumber,batchno,qtyfield,buycust.name,servicecust.name,duedate,orderno,bomid.number,project.name,status,enable,wg_admindivisionfield,wg_address^\^",^\^"orQfilters^\^":^[^{^\^"property^\^":^\^"number^\^",^\^"cp^\^":^\^"like^\^",^\^"value^\^":^\^"^%^CPDA-20250716-00000005^%^\^"^},^{^\^"property^\^":^\^"outbillno^\^",^\^"cp^\^":^\^"like^\^",^\^"value^\^":^\^"^%^CPDA-20250716-00000005^%^\^"^},^{^\^"property^\^":^\^"materielfield.name^\^",^\^"cp^\^":^\^"like^\^",^\^"value^\^":^\^"^%^CPDA-20250716-00000005^%^\^"^},^{^\^"property^\^":^\^"model^\^",^\^"cp^\^":^\^"like^\^",^\^"value^\^":^\^"^%^CPDA-20250716-00000005^%^\^"^},^{^\^"property^\^":^\^"batchno^\^",^\^"cp^\^":^\^"like^\^",^\^"value^\^":^\^"^%^CPDA-20250716-00000005^%^\^"^},^{^\^"property^\^":^\^"serialnumber^\^",^\^"cp^\^":^\^"like^\^",^\^"value^\^":^\^"^%^CPDA-20250716-00000005^%^\^"^},^{^\^"property^\^":^\^"materielfield.barcode^\^",^\^"cp^\^":^\^"like^\^",^\^"value^\^":^\^"^%^CPDA-20250716-00000005^%^\^"^}^],^\^"andQfilters^\^":^[^{^\^"property^\^":^\^"enable^\^",^\^"cp^\^":^\^"=^\^",^\^"value^\^":^\^"1^\^"^}^],^\^"onlyBasic^\^":false,^\^"level^\^":^\^"2^\^"^}^"
响应示例
{
"data": {
"currentPageSize": 10,
"currentPageIndex": 1,
"totalPages": 1,
"count": 1,
"list": [
{
"materielfield_modifierfield_name": "董素敏",
"buycust_saledeptid_name": "开发部门",
"servicecust_saledeptid_id": "1358650037789263872",
"materielfield_name": "成品1",
"materielfield_model": "",
"materielfield_maxinventoryqty": "0",
"materielfield_wg_costprice": "0",
"materielfield_isinvauxset": false,
"servicecust_number": "chen100006",
"servicecust_wg_protect_end": "",
"materielfield_qtyinv": "0",
"masterid": "0",
"servicecust_wg_source_billid": "0",
"materielfield_conversionunitid2_number": "支",
"materielfield_prolicense": "",
"materielfield_saleprice10": "0",
"buycust_wg_address": "",
"buycust_wg_surplus_days": "0",
"materielfield_parent_name": "7-DSM",
"materielfield_tradeprice": "0",
"materielfield_createrfield_name": "董素敏",
"servicecust_modifierfield_masterid": "0",
"materielfield_checkmethod": "",
"buycust_enable": "1",
"buycust_saledeptid_number": "BM00004",
"buycust_wg_protect_end": "",
"unitfield_longnumber": "",
"materielfield_mininventoryqty": "0",
"materielfield_auxunitid_longnumber": "",
"materielfield_saleunitid_number": "支",
"materielfield_minorderqty": "0",
"materielfield_outmaterialid": "0",
"buycust_isdefault_mobile": "",
"buycust_wg_custttype": "",
"servicecust_enable": "1",
"materielfield_conversionunitid3_name": "支",
"servicecust_next_contacttime": "",
"unitfield_id": "3",
"servicecust_bank": "",
"buycust_number": "chen100006",
"materielfield_baseunitid_number": "支",
"servicecust_saledeptid_number": "BM00004",
"materielfield_invoicename": "",
"materielfield_conversionunitid1_longnumber": "",
"materielfield_gross_weight": "0",
"materielfield_wide": "0",
"servicecust_fullpinyin": "",
"batchno": "",
"servicecust_wg_is_ghkh": false,
"buycust_attachmentcountfield": "0",
"buycust_taxpayerno": "",
"servicecust_invoicephone": "",
"materielfield_wg_mpq": "0",
"materielfield_ispurchase": true,
"servicecust_saledeptid_name": "开发部门",
"materielfield_wg_productionleadtime": "0",
"servicecust_bankaccount": "",
"servicecust_saledeptid_masterid": "1358650037789263872",
"wg_address": null,
"servicecust_name": "chen100006",
"materielfield_helpcode": "cp1",
"materielfield_modifierfield_number": "njwgceshi",
"materielfield_iskfperiod": false,
"servicecust_registrationnumber": "",
"buycust_issystem": false,
"buycust_salerid_name": "小陈",
"servicecust_salerid_id": "1447195255588841472",
"buycust_createtime": "2023-11-15 13:11:33",
"materielfield_standardcurrencyid_priceprecision": "4",
"materielfield_conversionunitid1_name": "支",
"buycust_saledeptid_masterid": "1358650037789263872",
"materielfield_producunitid_number": "支",
"materielfield_conversionunitid2_longnumber": "",
"servicecust_modifierfield_name": "陈玉龙",
"materielfield_seccoefficient": "0",
"materielfield_standardcurrencyid_number": "CNY",
"materielfield_saleunitid_name": "支",
"buycust_modifierfield_id": "10419085",
"servicecust_salerid_name": "小陈",
"servicecust_wg_surplus_days": "0",
"materielfield_fullpinyin": "chengpin1",
"materielfield_conversionunitid3_longnumber": "",
"buycust_wg_service_expiration": "",
"materielfield_producunitid_longnumber": "",
"materielfield_stockid_id": "1358197367060301824",
"materielfield_auxunitid_name": "支",
"buycust_registeredaddr": "",
"servicecust_taxpayerno": "",
"materielfield_sharetimes": "0",
"buycust_bank": "",
"buycust_modifytime": "2023-11-15 13:11:33",
"buycust_bankaccount": "",
"materielfield_pinyin": "cp1",
"materielfield_standard_time_type": "1",
"materielfield_maxpurchaseprice": "0",
"servicecust_source": "BD",
"materielfield_parent_number": "SPFL00006",
"materielfield_isasstattr": false,
"materielfield_purchaseunitid_number": "支",
"materielfield_istaxfree": false,
"materielfield_isselfrestraint": true,
"buycust_creditlimit": "0",
"materielfield_source": "WEBIMPORT",
"unitfield_precision": "0",
"materielfield_storeunitid_longnumber": "",
"servicecust_wg_contact_number": "",
"servicecust_mullabel": [
{
"number": "113724193477307785",
"name": "6",
"id": "113724193477307785"
}
],
"servicecust_deduct": false,
"servicecust_salerid_number": "ZY00005",
"materielfield_refistrationnumber": "",
"materielfield_conversionunitid1_id": "3",
"servicecust_id": "100006",
"materielfield_isfloat": false,
"materielfield_createtime": "2022-03-29 15:51:03",
"materielfield_sendstatus": "0",
"materielfield_parent_fullname": "7-DSM",
"name": null,
"buycust_wg_source_type": "",
"buycust_wg_contact_number": "",
"servicecust_modifierfield_id": "10419085",
"materielfield_wg_mbsfps": "0",
"materielfield_kfperiodtype": "",
"servicecust_invoiceemail": "",
"buycust_fullpinyin": "",
"servicecust_wg_address": "",
"materielfield_wg_associate": false,
"unitfield_number": "支",
"buycust_legalperson": "",
"materielfield_stockid_name": "成品仓",
"buycust_scopeoperation": "",
"buycust_invoiceemail": "",
"servicecust_createtime": "2023-11-15 13:11:33",
"materielfield_coefficient4": "0",
"materielfield_coefficient3": "0",
"materielfield_wg_incominginspection": false,
"materielfield_wg_deliveryinspection": false,
"materielfield_coefficient2": "0",
"materielfield_coefficient1": "0",
"materielfield_standardcurrencyid_sign": "",
"materielfield_alarmday": "0",
"materielfield_length": "0",
"materielfield_wg_pro_manufact": false,
"materielfield_duedatetype": "1",
"buycust_isall": false,
"materielfield_stockup_day": "0",
"buycust_remark": "",
"servicecust_addr": "",
"buycust_isdefault_contactperson": "",
"servicecust_invoicetype": "",
"buycust_mullabel": [
{
"number": "113724193477307785",
"name": "6",
"id": "113724193477307785"
}
],
"materielfield_volume": "0",
"servicecust_pinyin": "",
"materielfield_standardcurrencyid_id": "1358196047473542144",
"buycust_addr": "",
"materielfield_purchaseunitid_name": "支",
"materielfield_isbatchcost": false,
"duedate": "2025-03-19",
"materielfield_vipprice": "0",
"buycust_invoicetype": "",
"buycust_wg_protect_start": "",
"materielfield_costmethod": "1",
"buycust_unifiedsocialcode": "",
"qtyfield": "0",
"buycust_next_contacttime": "",
"materielfield_conversionunitid2_name": "支",
"servicecust_unifiedsocialcode": "",
"materielfield_createrfield_masterid": "0",
"servicecust_next_tracetime": "",
"servicecust_wg_protect_start": "",
"materielfield_isbackflushed": false,
"materielfield_storeunitid_number": "支",
"servicecust_isspeedprice": false,
"servicecust_wg_is_trade": true,
"buycust_customerlng": "0",
"materielfield_conversionunitid2_id": "3",
"materielfield_taxrate": "0",
"materielfield_wg_purchaseleadtime": "0",
"materielfield_saleprice9": "0",
"number": "CPDA-20250716-00000005",
"materielfield_conversionunitid1_number": "支",
"materielfield_saleprice8": "0",
"materielfield_saleprice7": "0",
"materielfield_saleprice6": "0",
"servicecust_legalperson": "",
"materielfield_multicount": "0",
"materielfield_saleprice5": "0",
"materielfield_stockid_number": "CK00002",
"materielfield_saleprice4": "0",
"enable": "1",
"materielfield_saleprice3": "0",
"materielfield_saleprice2": "0",
"buycust_wg_last_contact": "",
"materielfield_saleprice1": "0",
"materielfield_auxtype1": false,
"materielfield_conversionunitid3_number": "支",
"model": null,
"id": "2259941487590672384",
"materielfield_auxtype4": false,
"materielfield_ismulti_unit": false,
"materielfield_auxtype5": false,
"materielfield_auxtype2": false,
"materielfield_auxtype3": false,
"buycust_accountopenaddr": "",
"materielfield_txtbarcode": "",
"materielfield_wg_productinspection": false,
"servicecust_onlylistinvoice": false,
"buycust_registrationnumber": "",
"materielfield_number": "SP00146",
"materielfield_storeunitid_name": "支",
"materielfield_enable": "1",
"materielfield_baseunitid_longnumber": "",
"wg_admindivisionfield": "0",
"servicecust_accountopenaddr": "",
"servicecust_issystem": false,
"buycust_next_tracetime": "",
"materielfield_costprice": "0",
"materielfield_high": "0",
"materielfield_leadtime": "0",
"materielfield_attachmentcountfield": "0",
"status": "A",
"servicecust_disabledate": "",
"servicecust_isdefault_mobile": "",
"buycust_next_visittime": "",
"materielfield_isassembly": true,
"buycust_id": "100006",
"buycust_disabledate": "",
"buycust_modifierfield_number": "wgcyl",
"materielfield_bindsupplier": "",
"servicecust_modifytime": "2023-11-15 13:11:33",
"buycust_last_tracetime": "",
"servicecust_wg_last_contact": "",
"materielfield_barcoderemark": "",
"buycust_modifierfield_name": "陈玉龙",
"materielfield_kfperiod": "0",
"materielfield_standardcurrencyid_amtprecision": "4",
"materielfield_isfeedautoint": false,
"servicecust_last_tracetime": "",
"servicecust_next_visittime": "",
"buycust_name": "chen100006",
"materielfield_modifierfield_masterid": "0",
"materielfield_isoutsource": true,
"buycust_onlylistinvoice": false,
"servicecust_customerlng": "0",
"servicecust_attachmentcountfield": "0",
"servicecust_creditlimit": "0",
"materielfield_isserial": false,
"materielfield_conversionrate": "",
"materielfield_isshowauxbarcode": false,
"buycust_saledeptid_longnumber": "100000!BM00004",
"materielfield_conversionunitid3_id": "3",
"materielfield_modifytime": "2025-03-12 17:45:31",
"servicecust_modifierfield_number": "wgcyl",
"servicecust_isall": false,
"materielfield_standard_time": "0",
"materielfield_saleunitid_id": "3",
"materielfield_issubpart": true,
"buycust_saledeptid_id": "1358650037789263872",
"servicecust_rate": "0",
"servicecust_wg_custttype": "",
"orderno": "",
"buycust_wg_is_ghkh": false,
"materielfield_producunitid_id": "3",
"materielfield_wg_isoutsource": true,
"materielfield_standardcurrencyid_name": "人民币",
"materielfield_wg_isselfrestraint": true,
"materielfield_sharedate": "",
"materielfield_wg_inventoryinspection": false,
"unitfield_conversiontype": "1",
"materielfield_lastauxtype": "",
"materielfield_auxunitid_id": "3",
"servicecust_saledeptid_longnumber": "100000!BM00004",
"buycust_isimport": false,
"buycust_invoicephone": "",
"servicecust_registeredaddr": "",
"materielfield_isautosplit": false,
"materielfield_disabledate": "",
"materielfield_wg_randrate": "0",
"materielfield_wg_standardworktime": "0",
"buycust_salerid_number": "ZY00005",
"materielfield_parent_longnumber": "SPFL00006",
"materielfield_checktype": "1",
"buycust_modifierfield_masterid": "0",
"materielfield_purleadtime": "0",
"materielfield_issale": true,
"serialnumber": "",
"materielfield_isweight": false,
"materielfield_isauxcost": false,
"buycust_salerid_id": "1447195255588841472",
"servicecust_wg_service_expiration": "",
"materielfield_wg_subcontinspection": false,
"materielfield_wg_orderpolicy": "",
"servicecust_wg_source_type": "",
"materielfield_auxunitid_number": "支",
"buycust_deduct": false,
"buycust_wg_is_trade": true,
"unitfield_name": "支",
"buycust_customerlat": "0",
"materielfield_secinventoryqty": "0",
"materielfield_retailprice": "0",
"unitfield_precisionaccount": "2",
"buycust_isspeedprice": false,
"materielfield_producunitid_name": "支",
"materielfield_baseunitid_name": "支",
"materielfield_inv_mgr_type": "0",
"materielfield_fixunitcount": "0",
"materielfield_baseunitid_id": "3",
"materielfield_mullabel": [],
"materielfield_entrust": false,
"servicecust_customerlat": "0",
"materielfield_storeunitid_id": "3",
"buycust_source": "BD",
"materielfield_purchaseunitid_longnumber": "",
"buycust_wg_source_billid": "0",
"outbillno": "XSCK-20241209-00001",
"materielfield_bomprice": "0",
"materielfield_distributionprice": "0",
"servicecust_isdefault_contactperson": "",
"materielfield_createrfield_id": "10102023",
"servicecust_scopeoperation": "",
"materielfield_purchaseprice": "0",
"buycust_pinyin": "",
"materielfield_wg_decimalfield": "100",
"materielfield_createrfield_number": "njwgceshi",
"materielfield_remark": "",
"materielfield_isbatch": false,
"buycust_rate": "0",
"materielfield_ischangeduedatetype": "1",
"materielfield_saleunitid_longnumber": "",
"servicecust_isimport": false,
"outdate": "2024-12-09",
"materielfield_id": "1386974936274329600",
"materielfield_net_weight": "0",
"materielfield_parent_id": "1376097769244082176",
"materielfield_modifierfield_id": "10102023",
"materielfield_producingpace": "",
"servicecust_remark": "",
"materielfield_outsourceprice": "0",
"materielfield_computationrule": "1",
"materielfield_barcode": "",
"materielfield_minsalesprice": "0",
"materielfield_purchaseunitid_id": "3",
"materielfield_iskeypieces": false
}
],
"qtycount": 0,
"allamount": 0
},
"errorCode": "success",
"status": true,
"success": true
}