WebApi.案例.查询单据转换规则
【场景】WebApi 查询单据转换规则
【案例】
表单标识 单据转换规则 BOS_ConverRule
<1>根据名称查询
```json
{
"FormId": "BOS_ConvertRule",
"FieldKeys": "FNumber,FName",
"FilterString": [
{
"Left": "(",
"FieldName": "FName",
"Compare": "=",
"Value": "采购申请单至采购订单-仅携带",
"Right": ")",
"Logic": "and"
}
],
"OrderString": "",
"TopRowCount": 0,
"StartRow": 0,
"Limit": 2000,
"SubSystemId": ""
}
```
![image.webp](/download/010095ea6249e0694b42afdff7983e7ad053.webp)
![Image_20230208104140.webp](/download/01006e8f40d95c20495cac3bfca8439c979b.webp)
<2>根据源单标识和目标单标识查询
a)打开设计器,表单BOS_ConverRule,扩展增加两个文本字段,字段名指向fsourceformid, ftargetformid
(需要修改字段的存储类型为varchar)
![Image_20230208104441.webp](/download/0100421d247b7ca24a49ad1edcf8c1007091.webp)
![Image_20230208104555.webp](/download/01006914f15e34d64009959251678bb4d6b8.webp)
```json
{
"FormId": "BOS_ConvertRule",
"FieldKeys": "FNumber,FName",
"FilterString": [
{
"Left": "(",
"FieldName": "F_Jac_TextSrc",
"Compare": "=",
"Value": "PUR_Requisition",
"Right": ")",
"Logic": "and"
},
{
"Left": "(",
"FieldName": "F_Jac_TextTgt",
"Compare": "=",
"Value": "PUR_PurchaseOrder",
"Right": ")",
"Logic": "and"
},
],
"OrderString": "",
"TopRowCount": 0,
"StartRow": 0,
"Limit": 2000,
"SubSystemId": ""
}
```
![Image_20230208105058.webp](/download/0100c66bbdece5d549b188c987c764cc8e6b.webp)
【备注】其他字段查询的逻辑同<2>,需要自行增加字段,物理表t_meta_convertrule
WebApi.案例.查询单据转换规则
【场景】WebApi 查询单据转换规则【案例】表单标识 单据转换规则 BOS_ConverRule<1>根据名称查询```json{ "FormId": "BOS_Conve...
点击下载文档
本文2024-09-16 18:32:39发表“云星空知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3cloud-22836.html
您需要登录后才可以发表评论, 登录登录 或者 注册
最新文档
热门文章