二开案例-【WebAPI】如何通过WebAPI生成生产退料单

栏目：云星空知识作者：金蝶来源：金蝶云社区发布：2024-09-23浏览：1

一、业务背景

随着越来越多的外部系统通过WebAPI的方式对接金蝶云星空中的生产退料单，下面就关于构建生产退料单的Json数据说明几个需要注意的点，以构建生产退料单关联生产用料清单的数据包作为案例，进行简单的介绍

1、保存接口

1）为了保证生产退料单的业务正常运转，除去一些必录字段，以下字段也需要必录

字段标识	字段名称	字段说明
FSrcBillType	系统源单类型	关联业务单据标识，如：生产用料清单【PRD_PPBOM】
FSrcBillNo	系统源单编号	关联业务单据编号，如：生产用料清单编号
FEntrySrcInterId	系统源单内码	关联业务单据内码，如：生产用料清单内码
FEntrySrcEnteryId	系统源单分录内码	关联业务单据分录内码，如：生产用料清单分录内码
FEntrySrcEntrySeq	系统源单行号	关联业务单据行号，如：生产用料清单行号
FPPBomBillNo	用料清单编号	用料清单编号
FPPBOMEntryId	用料清单分录ID	用料清单分录内码
FMoId	生产订单ID	生产订单内码
FMoBillNo	生产订单编号	生产订单编号
FMoEntryId	生产订单分录ID	生产订单分录内码
FMoEntrySeq	生产订单行号	生产订单行号
FBFLowId	业务流程	生产领退补料流程【81119477-4778-4d0b-94b9-1c43a1c1f768】，可查询表T_BF_DEFVERSION

2）涉及多行分录参数IsEntryBatchFill设置为false

3）关联关系表FEntity_Link（决定生产退料单是否正确关联生产用料清单以及反写）

关于关联关系的构建说明可参考【https://vip.kingdee.com/article/171055?productLineId=1 】

字段标识	字段名称	字段说明
FEntity_Link_FFlowId	业务流程图	与业务流程一致，如：生产领退补料流程【81119477-4778-4d0b-94b9-1c43a1c1f768】
FEntity_Link_FFlowLineId	推进路线	如：生产用料清单到生产退料单默认8
FEntity_Link_FRuleId	转换规则	单据转换规则标识，如：生产用料清单到生产退料单单据转换标识【PRD_PPBOM2RETURNMTRL】
FEntity_Link_FSTableName	源单表	如：生产用料清单分录表【T_PRD_PPBOMENTRY】
FEntity_Link_FSBillId	源单内码	如：生产用料清单内码
FEntity_Link_FSId	源单分录内码	如：生产用料清单分录内码
FEntity_Link_FBaseQtyOld	原始携带量	如：生产用料清单基本单位在制材料数量
FEntity_Link_FBaseQty	修改携带量	如：生产退料单基本单位实退数量

4）json示例（示例为两行分录，第一行分录关联用料清单，第二行分录新增返还件，注意字段顺序）

{
    "NeedUpDateFields": [],
    "NeedReturnFields": [],
    "IsDeleteEntry": "true",
    "SubSystemId": "",
    "IsVerifyBaseDataField": "false",
    "IsEntryBatchFill": "false",
    "ValidateFlag": "true",
    "NumberSearch": "true",
    "IsAutoAdjustField": "false",
    "InterationFlags": "",
    "IgnoreInterationFlag": "",
    "IsControlPrecision": "false",
    "ValidateRepeatJson": "false",
    "Model": {
        "FID": 0,
        "FBillType": {
            "FNUMBER": "SCTLD01_SYS"
        },
        "FDate": "2024-04-03 00:00:00",
        "FStockOrgId": {
            "FNumber": "100"
        },
        "FPrdOrgId": {
            "FNumber": "100"
        },
        "FOwnerTypeId0": "BD_OwnerOrg",
        "FOwnerId0": {
            "FNumber": "0"
        },
        "FIsCrossTrade": false,
        "FVmiBusiness": false,
        "FIsOwnerTInclOrg": true,
        "FEntity": [
            {
                "FMaterialId": {
                    "FNumber": "testtld1"
                },
                "FUnitID": {
                    "FNumber": "Pcs"
                },
                "FAPPQty": 1,
                "FQty": 1,
                "FReturnType": "1",
                "FStockId": {
                    "FNumber": "0901A"
                },
                "FSrcBillType": "PRD_PPBOM",
                "FSrcBillNo": "PPBOM00002392",
                "FEntrySrcEntrySeq": 1,
                "FPPBomBillNo": "PPBOM00002392",
                "FParentMaterialId": {
                    "FNumber": "testtld"
                },
                "FPPBOMEntryId": 135183,
                "FMoId": 123006,
                "FReserveType": "1",
                "FBASESTOCKQTY": 1,
                "FMoBillNo": "MO00001992",
                "FMoEntryId": 123800,
                "FMoEntrySeq": 1,
                "FStockUnitId": {
                    "FNumber": "Pcs"
                },
                "FStockAppQty": 1,
                "FStockQty": 1,
                "FStockStatusId": {
                    "FNumber": "KCZT01_SYS"
                },
                "FKeeperTypeId": "BD_KeeperOrg",
                "FKeeperId": {
                    "FNumber": "100"
                },
                "FBaseUnitId": {
                    "FNumber": "Pcs"
                },
                "FBaseAppQty": 1,
                "FBaseQty": 1,
                "FOwnerTypeId": "BD_OwnerOrg",
                "FOwnerId": {
                    "FNumber": "100"
                },
                "FEntrySrcEnteryId": 135183,
                "FEntrySrcInterId": 132889,
                "FWorkShopId1": {
                    "FNumber": "BM000020"
                },
                "FParentOwnerTypeId": "BD_OwnerOrg",
                "FParentOwnerId": {
                    "FNumber": "100"
                },
                "FEntity_Link": [
                    {
                        "FEntity_Link_FFlowId": "81119477-4778-4d0b-94b9-1c43a1c1f768",
                        "FEntity_Link_FFlowLineId": 8,
                        "FEntity_Link_FRuleId": "PRD_PPBOM2RETURNMTRL",
                        "FEntity_Link_FSTableName": "T_PRD_PPBOMENTRY",
                        "FEntity_Link_FSBillId": "132889",
                        "FEntity_Link_FSId": "135183",
                        "FEntity_Link_FBaseQtyOld": 5,
                        "FEntity_Link_FBaseQty": 1
                    }
                ],
                "FBFLowId": {
                    "FID": "81119477-4778-4d0b-94b9-1c43a1c1f768"
                }
            },
            {
                "FMaterialId": {
                    "FNumber": "testtld2"
                },
                "FUnitID": {
                    "FNumber": "Pcs"
                },
                "FAPPQty": 1,
                "FQty": 1,
                "FReturnType": "1",
                "FStockId": {
                    "FNumber": "0901A"
                },
                "FSrcBillType": "PRD_PPBOM",
                "FSrcBillNo": "PPBOM00002392",
                "FEntrySrcEntrySeq": 0,
                "FPPBomBillNo": "PPBOM00002392",
                "FParentMaterialId": {
                    "FNumber": "testtld"
                },
                "FPPBOMEntryId": 0,
                "FMoId": 123006,
                "FReserveType": "1",
                "FBASESTOCKQTY": 1,
                "FMoBillNo": "MO00001992",
                "FMoEntryId": 123800,
                "FMoEntrySeq": 1,
                "FStockUnitId": {
                    "FNumber": "Pcs"
                },
                "FStockAppQty": 1,
                "FStockQty": 1,
                "FStockStatusId": {
                    "FNumber": "KCZT01_SYS"
                },
                "FKeeperTypeId": "BD_KeeperOrg",
                "FKeeperId": {
                    "FNumber": "100"
                },
                "FBaseUnitId": {
                    "FNumber": "Pcs"
                },
                "FBaseAppQty": 1,
                "FBaseQty": 1,
                "FOwnerTypeId": "BD_OwnerOrg",
                "FOwnerId": {
                    "FNumber": "100"
                },
                "FEntrySrcEnteryId": 132889,
                "FEntrySrcInterId": 0,
                "FWorkShopId1": {
                    "FNumber": "BM000020"
                },
                "FParentOwnerTypeId": "BD_OwnerOrg",
                "FParentOwnerId": {
                    "FNumber": "100"
                }
            }
        ]
    }