更新时间:2023-11-02 GMT+08:00
分享

创建保存数据业务流

保存数据时,条码应用会向集成工作台发送一个POST请求,请求样例为:

{
    "method": "InventoryGenEntry",
    "table": "OIGN",
    "data": [
        {
            "U_SCRKLX": "合格入库",
            "BaseEntry": "478",
            "BaseType": "202",
            "Quantity": "1",
            "ManBtchNum": "Y",
            "WarehouseCode": "W05001",
            "U_FJDSJ": "",
            "U_FJDRQ": "20230920",
            "U_FJDNR": "",
            "U_BGR1": "SF0006",
            "U_SBXH": "1",
            "linetable": [
                {
                    "Quantity": "1",
                    "BatchNumber": "11007510-01-50|20230920",
                    "BinAbsEntry": "14",
                    "AddmisionDate": "20230920"
                }
            ]
        }
    ],
    "MainTable": {
        "U_CZR": "CS01",
        "U_CZSJ": "2023-09-20 21:04:44",
        "DocDate": "20230920",
        "DocDueDate": "20230920",
        "U_BFYY1": "",
        "U_BFYY2": "",
        "U_BFYY3": "",
        "U_BFYY4": "",
        "U_BFYY5": "",
        "U_BFYY6": "",
        "U_FGYY1": "",
        "U_FGYY2": "",
        "U_FGYY3": "",
        "U_FGYY4": "",
        "U_FGYY5": "",
        "Inverted": "Y",
        "InvertedSql": "\nSelect T0.\"DocEntry\",T1.\"LineNum\",T1.\"ItemCode\",T2.\"ItemName\",T1.\"BaseQty\",T1.\"wareHouse\"  \nFrom OWOR T0 Left Join WOR1 T1 On T0.\"DocEntry\" =T1.\"DocEntry\" \nLeft Join OITM T2 On T1.\"ItemCode\"=T2.\"ItemCode\"  \nWhere T2.\"ManBtchNum\"='Y'   \n",
        "InvertedBathSql": "call TMDK('{0}','{1}','{2}')"
    }
}

相关文档