【应用场景】

【WEBAPI】采购订单执行明细表查询报表数据

【注意事项】

建议使用金蝶内置的API在线生成JSON工具，方便验证和参考格式：

通过WebAPI接口生成凭证（在线测试）演示 (kingdee.com)

【案例演示】

1、填写过滤方案：

2、返回JSON数据，"FieldKeys"为想要查询的字段标识，可手动增减字段

3、JSON格式

{
  "FieldKeys": "FPurchaseOrgId,FBillNo,FDate,FSUPPLIERNAME,FMATERIALID,FMATERIALNAME,FMaterialModel,FDELIVERYDATE,FUnitId,FCurrencyId,FOrderQty,FTAXPRICE,FOrderAmount,FReceiveNumber,FReceiveQty,FReceiveAmount,FEnterNumber,FImportQty,FImportAmount,FIMPORTNOTAXAMOUNT,FReturnNumber,FReturnQty,FReturnAmount,FPAYNUMBER,FSETACCOUNTTYPE,FPAYQTY,FPAYAMOUNT,FINVOICENUMBER,FINVOICEQTY,FINVOICEAMOUNT,FRECPAYBILLNUMBER,FRECPAYBILLAMOUNT,FPAYBILLNUMBER,FPAYBILLAMOUNT,FSETADJAMOUNT,FPAYWRITOFFAMOUNT,FSPEWOFFAMOUNT,FPREINVOCEBILLNO,FPREINVOICEQTY,FPREINVOICEAMOUNT",
  "SchemeId": "",
  "StartRow": 0,
  "Limit": 2000,
  "IsVerifyBaseDataField": "true",
  "FilterString": [],
  "Model": {
    "FPurchaseOrgIdList": "1",
    "FOrderStartDate": "2023-12-01 00:00:00",
    "FOrderEndDate": "2024-03-29 00:00:00",
    "FBusinessType": "A",
    "FDocumentStatus": "A",
    "FLineStatus": "A"
  }
}