如何通过WebAPI构建委外领料单原创
金蝶云社区-插秧小能手
插秧小能手
2人赞赏了该文章 158次浏览 未经作者许可,禁止转载编辑于2023年11月27日 15:34:49

一、注意点

    1.1、选单下推的数据,业务流程不为空,业务流程参考表:T_BF_DEFVERSION,若不确定,可以WebAPI->查询->现有系统手工单据,得到对应的json数据参考。

    1.2、字段顺序不可随意调整,原因:实体服务规则,值更新影响,如:B字段值更新A,若A先赋值X,B赋值Y,则A的X值会被B值更新覆盖;

    1.3、部分参数说明:

        1.3.1、IsAutoAdjustField:禁止为true,自动调整字段并不能正确调整成可构建的Json字段顺序。

        1.3.2、IsEntryBatchFill:禁止为true,批量填充,一般基础资料等简单单据使用,业务单据复杂单据不使用。

    1.4、部分字段说明:

        1.4.1、FEntity_Link_FSBillId:单据转换中上游单据的单据ID,FEntity_Link_FSId:单据转换中上游单据的分录ID;

        1.4.2、FEntity_Link_FRuleId:BOS设计器中单据转换的标识;

二、格式参考

{
    "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": "WWLLD01_SYS"
        },
        "FDate": "2023-11-20 00:00:00",
        "FStockOrgId": {
            "FNumber": "120"
        },
        "FSubOrgId": {
            "FNumber": "120"
        },
        "FSupplierId": {
            "FNumber": "013247"
        },
        "FOwnerTypeId0": "BD_OwnerOrg",
        "FOwnerId0": {
            "FNumber": "120"
        },
        "FIsCrossTrade": false,
        "FVmiBusiness": false,
        "FIsOwnerTInclOrg": false,
        "FEntity": [
            {
                "FMaterialId": {
                    "FNumber": "c18aty49hs036"
                },
                "FUnitID": {
                    "FNumber": "zhang"
                },
                "FAppQty": 99.0,
                "FStockId": {
                    "FNumber": "CK047"
                },
                "FStockLocId": {
                    "FSTOCKLOCID__FF100002": {
                        "FNumber": ""
                    },
                    "FSTOCKLOCID__FF100003": {
                        "FNumber": "X-44"
                    },
                    "FSTOCKLOCID__FF100004": {
                        "FNumber": ""
                    },
                    "FSTOCKLOCID__FF100005": {
                        "FNumber": ""
                    },
                    "FSTOCKLOCID__FF100006": {
                        "FNumber": ""
                    },
                    "FSTOCKLOCID__FF100007": {
                        "FNumber": ""
                    },
                    "FSTOCKLOCID__FF100008": {
                        "FNumber": ""
                    },
                    "FSTOCKLOCID__FF100009": {
                        "FNumber": ""
                    },
                    "FSTOCKLOCID__FF100014": {
                        "FNumber": ""
                    },
                    "FSTOCKLOCID__FF100016": {
                        "FNumber": ""
                    }
                },
                "FLOT": {
                    "FNumber": "230521"
                },
                "FSRCBIZENTRYSEQ": 0,
                "FPickingStatus": 4,
                "FParentMaterialId": {
                    "FNumber": "dpet18P4598tdhs0046"
                },
                "FSrcBillType": "SUB_PPBOM",
                "FSrcBillNo": "SUBBOM00016086",
                "FSrcInterId": 116087,
                "FSrcEntryId": 131231,
                "FSrcEntrySeq": 1,
                "FSRCBIZINTERID": 0,
                "FConsome": "0",
                "FSubReqId": 101396,
                "FReserveType": "1",
                "FSettleOrgId": {
                    "FNumber": "120"
                },
                "FSRCBIZENTRYID": 0,
                "FPPbomBillNo": "SUBBOM00016086",
                "FSubReqEntryId": 116941,
                "FSubReqBillNo": "SUB00001332",
                "FSubReqEntrySeq": 1,
                "FBaseUnitId": {
                    "FNumber": "zhang"
                },
                "FBaseAppQty": 99.0,
                "FBaseAllowOverQty": 0.0,
                "FBaseSelPrcdReturnQty": 0.0,
                "FPrice": 0.0,
                "FAmount": 0.0,
                "FStockUnitId": {
                    "FNumber": "zhang"
                },
                "FSECUNITID":{
                    "FNumber": "m3"
                },
                "FStockAppQty": 99.0,
                "FStockAllowOverQty": 0.0,
                "FStockSelPrcdReturnQty": 0.0,
                "FSecAllowOverQty": 0.0,
                "FSecSelPrcdReturnQty": 0.0,
                "FEntryVmiBusiness": false,
                "FGroupRow": "00505691-a415-b1e9-11ee-87665427d24a",
                "FPOOrderBillNo": "CGDD2310270028",
                "FSrcPickEntryId": 0,
                "FPOOrderSeq": 1,
                "FSupplierId0": {
                    "FSupplierId": 3450513
                },
                "FCheckSubRtnMtrl": false,
                "FKeeperTypeId": "BD_KeeperOrg",
                "FTransRetId": 0,
                "FTransRetEntryId": 0,
                "FKeeperId": {
                    "FNumber": "120"
                },
                "FTransRetEntrySeq": 0,
                "FStockStatusId": {
                    "FNumber": "KCZT01_SYS"
                },
                "FIsOverLegalOrg": false,
                "FAllowOverQty": 0.0,
                "FOwnerTypeId": "BD_OwnerOrg",
                "FOwnerId": {
                    "FNumber": "120"
                },
                "FParentOwnerTypeId": "BD_OwnerOrg",
                "FParentOwnerId": {
                    "FNumber": "120"
                },
                "FBaseActualQty": 99.0,
                "FActualQty": 99.0,
                "FStockActualQty": 99.0,
                "FBaseStockActualQty": 99.0,
                "FEntity_Link": [
                    {
                        "FEntity_Link_FFlowId": "0b064121-4926-4808-8632-a195b6a202e8",
                        "FEntity_Link_FFlowLineId": 6,
                        "FEntity_Link_FRuleId": "SUB_PPBOM_Pick",
                        "FEntity_Link_FSTableId": 0,
                        "FEntity_Link_FSTableName": "T_SUB_PPBOMENTRY",
                        "FEntity_Link_FSBillId": "116087",
                        "FEntity_Link_FSId": "131231",
                        "FEntity_Link_FBaseActualQtyOld": 0.0,
                        "FEntity_Link_FBaseActualQty": 99.0
                    }
                ],
                "FBFLowId": {
                    "FID": "0b064121-4926-4808-8632-a195b6a202e8"
                }
            }
        ]
    }
}


注意事项:

    1、提示与采购订单供应商不一致,可以尝试使用ID来赋值,而不使用编码

    2、提示即时库存相关信息,检查各单位是否携带正常,数量是否计算正确,如果出现数量异常问题,可以先调用暂存接口,将单据暂存后,用客户端登录到单据中修改实发数量,看看其它数量字段有没有跟着变,如果没有变动,则是单位有问题,特别注意辅单位,有些物料启用辅单位则需要携带,如果有变动,则需要调整下webapi中数量字段之间的顺序,标准中走流程用的都是基本单位数量,注意基本单位数量是否正常。

    3、上方参考格式不一定适用现场环境,因为各环境字段联动更新配置不同,最好是现场用webapi填写测试数据来获取json数据包,再补充上关联信息和业务流程,填写测试数据调出选单操作参考:https://vip.kingdee.com/article/437310638176658944?productLineId=1

赞 2