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

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

一、业务背景

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

1、保存接口

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

字段标识	字段名称	字段说明
FSrcBillType	系统源单类型	关联业务单据标识，如：委外用料清单【SUB_PPBOM】
FSrcBillNo	系统源单编号	关联业务单据编号，如：委外用料清单编号
FSrcBillId	系统源单内码	关联业务单据内码，如：委外用料清单内码
FSrcEntryId	系统源单分录内码	关联业务单据分录内码，如：委外用料清单分录内码
FSrcEntrySeq	系统源单行号	关联业务单据行号，如：委外用料清单行号
FPPBomBillNo	用料清单编号	用料清单编号
FPPBOMEntryId	用料清单分录ID	用料清单分录内码
FSUBReqId	委外订单ID	委外订单内码
FSUBReqBillNo	委外订单编号	委外订单编号
FSubReqEntryId	委外订单分录ID	委外订单分录内码
FSUBReqEntrySeq	委外订单行号	委外订单行号
FBFLowId	业务流程	委外领退补料流程【0b064121-4926-4808-8632-a195b6a202e8】，可查询表T_BF_DEFVERSION

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

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

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

字段标识	字段名称	字段说明
FEntity_Link_FFlowId	业务流程图	与业务流程一致，如：委外领退补料流程【0b064121-4926-4808-8632-a195b6a202e8】
FEntity_Link_FFlowLineId	推进路线	如：委外用料清单到委外退料单默认10
FEntity_Link_FRuleId	转换规则	单据转换规则标识，如：委外用料清单到委外退料单单据转换标识【SUB_PPBOM2RETURNMTRL】
FEntity_Link_FSTableName	源单表	如：委外用料清单分录表【T_SUB_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": "WWTLD01_SYS"
        },
        "FDate": "2024-05-24 17:23:06",
        "FStockOrgId": {
            "FNumber": "100"
        },
        "FSubOrgId": {
            "FNumber": "100"
        },
        "FSubSupplierId": {
            "FNumber": "VEN00001"
        },
        "FOwnerTypeId0": "BD_OwnerOrg",
        "FSTOCKERID": {
            "FNAME": ""
        },
        "FOwnerId0": {
            "FNumber": "100"
        },
        "FIsCrossTrade": false,
        "FVmiBusiness": false,
        "FIsOwnerTInclOrg": false,
        "FEntity": [
            {
                "FMaterialId": {
                    "FNumber": "testtld1"
                },
                "FUnitID": {
                    "FNumber": "Pcs"
                },
                "FAPPQty": 1,
                "FQty": 1,
                "FReturnType": "1",
                "FStockId": {
                    "FNumber": "014"
                },
                "FSUBReqBillNo": "SUB00000247",
                "FSrcEntrySeq": 1,
                "FParentMaterialId": {
                    "FNumber": "testtld"
                },
                "FSUBReqId": 100268,
                "FSUBReqEntrySeq": 1,
                "FPPBOMEntryId": 100745,
                "FSubReqEntryId": 100372,
                "FOwnerTypeId": "BD_OwnerOrg",
                "FOwnerId": {
                    "FNumber": "100"
                },
                "FSrcBillNo": "SUBBOM00000335",
                "FSrcBillType": "SUB_PPBOM",
                "FSrcBillId": 100353,
                "FSrcEntryId": 100745,
                "FBaseUnitId": {
                    "FNumber": "Pcs"
                },
                "FReserveType": "1",
                "FSettleOrgId": {
                    "FNumber": "100"
                },
                "FBaseStockQty": 1,
                "FBaseAppQty": 1,
                "FBaseQty": 1,
                "FStockUnitId": {
                    "FNumber": "Pcs"
                },
                "FStockAppQty": 1,
                "FStockQty": 1,
                "FStockStatusId": {
                    "FNumber": "KCZT01_SYS"
                },
                "FKeeperTypeId": "BD_KeeperOrg",
                "FKeeperId": {
                    "FNumber": "100"
                },
                "FOperId": 10,
                "FEntryVmiBusiness": false,
                "FIsUpdateQty": false,
                "FPOOrderBillNo": "CGDD000227",
                "FPOOrderSeq": 1,
                "FIsOverLegalOrg": false,
                "FCheckSubRtnMtrl": false,
                "FSupplierId": {
                    "FNUMBER": "VEN00001"
                },
                "FParentOwnerTypeId": "BD_OwnerOrg",
                "FParentOwnerId": {
                    "FNumber": "100"
                },
                "FPPBomBillNo": "SUBBOM00000335",
                "FEntity_Link": [
                    {
                        "FEntity_Link_FFlowId": "0b064121-4926-4808-8632-a195b6a202e8",
                        "FEntity_Link_FFlowLineId": 10,
                        "FEntity_Link_FRuleId": "SUB_PPBOM2RETURNMTRL",
                        "FEntity_Link_FSTableName": "T_SUB_PPBOMENTRY",
                        "FEntity_Link_FSBillId": "100353",
                        "FEntity_Link_FSId": "100745",
                        "FEntity_Link_FBaseQtyOld": 1,
                        "FEntity_Link_FBaseQty": 1
                    }
                ],
                "FBFLowId": {
                    "FID": "0b064121-4926-4808-8632-a195b6a202e8"
                }
            },
            {
                "FMaterialId": {
                    "FNumber": "testtld2"
                },
                "FUnitID": {
                    "FNumber": "Pcs"
                },
                "FAPPQty": 1,
                "FQty": 1,
                "FReturnType": "1",
                "FStockId": {
                    "FNumber": "014"
                },
                "FSUBReqBillNo": "SUB00000247",
                "FSrcEntrySeq": 0,
                "FParentMaterialId": {
                    "FNumber": "testtld"
                },
                "FSUBReqId": 100268,
                "FSUBReqEntrySeq": 1,
                "FPPBOMEntryId": 0,
                "FSubReqEntryId": 100372,
                "FOwnerTypeId": "BD_OwnerOrg",
                "FOwnerId": {
                    "FNumber": "100"
                },
                "FSrcBillNo": "SUBBOM00000335",
                "FSrcBillType": "SUB_PPBOM",
                "FSrcBillId": 100353,
                "FSrcEntryId": 0,
                "FBaseUnitId": {
                    "FNumber": "Pcs"
                },
                "FReserveType": "1",
                "FBaseStockQty": 1,
                "FBaseAppQty": 1,
                "FBaseQty": 1,
                "FStockUnitId": {
                    "FNumber": "Pcs"
                },
                "FStockAppQty": 1,
                "FStockQty": 1,
                "FStockStatusId": {
                    "FNumber": "KCZT01_SYS"
                },
                "FKeeperTypeId": "BD_KeeperOrg",
                "FKeeperId": {
                    "FNumber": "100"
                },
                "FOperId": 0,
                "FEntryVmiBusiness": false,
                "FIsUpdateQty": false,
                "FPOOrderBillNo": "CGDD000227",
                "FPOOrderSeq": 1,
                "FIsOverLegalOrg": false,
                "FCheckSubRtnMtrl": false,
                "FSupplierId": {
                    "FNUMBER": "VEN00001"
                },
                "FParentOwnerTypeId": "BD_OwnerOrg",
                "FParentOwnerId": {
                    "FNumber": "100"
                },
                "FPPBomBillNo": "SUBBOM00000335"
            }
        ]
    }
}