土主关联交易入库实绩

SELECT  A.*,A.rowid FROM WMSIFSTOCKINACTTBL A WHERE 1=1 AND  A.PURCHASENO = '6011008243';

SELECT  A.*,A.rowid FROM WMSIFSTOCKINACTDETAILTBL A WHERE 1=1 AND  A.PURCHASENO = '6011008243';


SELECT A.DATATYPE,
       A.BIZTRANSACTIONID,
       A.KEYWORD,
       A.CREDATE,
       A.DATA,
       A.ORDERNO
  FROM SCM_REQUEST_RECODE A
 WHERE 1 = 1
   AND DATATYPE = '发送'
   AND KEYWORD = 'SYS_SCM_RKSJ'
   AND ORDERNO LIKE '7696011008243%'
   AND ROWNUM <= 5

入库实绩生成的报文

{
    "REQUEST":{
        "HEAD":{
            "BIZTRANSACTIONID":"WMS_InAct_80_7696011008243",
            "COUNT":"1",
            "CONSUMER":"",
            "SRVLEVEL":"1",
            "ACCOUNT":"10018;",
            "PASSWORD":"",
            "PAGENUM":"",
            "PAGESIZE":"",
            "MODULE":""
        },
        "LIST":[
            {
                "CREDATE":"2023-11-10 09:51:26",--head RECTIME
                "WAREHID":"80",--head STOCKID
                "GOODSOWNERID":"76",--head OWNERID
                "OPERATIONTYPE":"36",--head INSTOCKTYPE
                "ERPORDERID":"6011008243",--head PURCHASENO
                "WMSORDERID":"_7696011008243",--head RECNO
                "ERPTRANSCOMPANYID":"014021",--head SENDERCD
                "REBACKFLAG":"1",
                "OTHERID":"",
                "ERPTANSMETHOD":"",
                "WMSTRID":"",
                "SOID":"",
                "INID":"3112405",--head SCMINID
                "STOCKINNO":"7696011008243",--head STOCKINNO
                "ZX_RCVNOX":"7696011008243",--head ZX_RCVNOX
                "CHILD_TABLE_LIST":[
                    {
                        "CREDATE":"2023-11-10 09:51:26",
                        "ERPORDERID":"15379745",--LNO
                        "ERPGOODSID":"1110684182",--detail GOODSID
                        "ERPGOODSQTY":"",
                        "WMSGOODSQTY":"10",--detail NOTCEQTY
                        "PACKNAME":"",
                        "PACKSIZE":"400",--detail PACKAGECOUNT
                        "GOODSSTATUSID":"0",
                        "LOTNO":"FL23070203",--detail LOTNO
                        "PRODDATE":"2023-07-02",--detail PRODUCTIONDATE
                        "VALIDDATE":"2025-07-01",--detail EXPIREDATE
                        "KILLLOTNO":"",
                        "REGISTNO":"",
                        "APPROVEDOCNO":"国药准字H20223964",--detail PERMISSIONNO
                        "PRODLICENSENO":"",
                        "LOTNOFACTNAME":"",
                        "ISRECEIVE":"1",
                        "RECEIVEMANNAME":"-",
                        "RECEIVEMANID":"-",
                        "CHECKMANNAME":"-",
                        "CHECKMANID":"-",
                        "CHECKMANNAME2":"-",
                        "CHECKMANID2":"-",
                        "RECEIVEDATE":"2023-11-10 09:51:26",
                        "CHECKDATE":"2023-11-10 09:51:26",
                        "WMSORDERID":"",
                        "DOCID":"_7696011008243",--detail RECNO
                        "REBACKFLAG":"1",
                        "STARTDATE":"",
                        "TEMPERATURESTATUS":"",
                        "STARTTEMPERATURE":"",
                        "REACHTEMPERATURE":"",
                        "HAVETRANSTEMP":"",
                        "STARTTEMP":"",
                        "TRANSTEMP":"",
                        "REACHDATE":"",
                        "INID":"3112405",--detail SCMINID
                        "INDTLID":"4651495",--detail SCMINDTLID
                        "REMARK":"",
                        "DAMAGEREASON":"-",
                        "DAMAGEREASONREMARK":"-",
                        "STOCKINNO":"7696011008243",--detail
                        "INNERCODE":"",
                        "GENBATCHNO":"231180760OJJ",--detail BATCHNUMBER
                        "PRICENOTAX":"0",--detail PRICENOTAX
                        "PRICETAX":"9.78",--detail SKUVALUE
                        "TAXRATE":"",
                        "ZX_RCVNOXDETIL":"7696011008243"--detail ZX_RCVNOXDETIL
                    }
                ]
            }
        ]
    }
}

原车退回 入库实绩

--erptype 即是 WMSIFSTOCKINACTTBL.INSTOCKTYPE 接口表类型
SELECT A.ERPTYPE, A.*,A.ROWID FROM ERPWMSRELATIONTBL A WHERE WMSTYPENM='原车退回';

SELECT A.*,A.rowid FROM WMSIFSTOCKINACTTBL A WHERE  A.INSTOCKTYPE IN (10)

SELECT A.*,A.rowid FROM WMSIFSTOCKINACTTBL A WHERE  A.STOCKINNO ='AN802023111000680'

SELECT A.*,A.rowid FROM WMSIFSTOCKINACTDETAILTBL A WHERE   A.STOCKINNO ='AN802023111000680'