跟踪了下新增订单时,发现插入语句有两个cinvcode,cinvname语句是这样的 Insert Into SO_SODetails(ID,cInvCode,cInvName,cUnitID,iQuantity,inum,iQuotedPrice,iUnitPrice,iMoney,iTax,iSum,iNatUnitPrice,iNatMoney,iNatTax,iNatSum,iNatDisCount,iDisCount,iFHQuantity,iFHNum,iFHMoney,iKPQuantity,fSaleCost,fSalePrice,iKPNum,iKPMoney,dPreDate,cMemo,cFree1,cFree2,iInvExchRate,iTaxUnitPrice,iTaxRate,KL,KL2,cDefine22,cDefine23,cDefine24,cDefine25,cDefine26,cDefine27,cDefine28,cDefine29,cDefine30,cDefine31,cDefine32,cDefine33,cDefine34,cDefine35,cDefine36,cDefine37,iSOsID,cItemCode,cItem_class,cItemName,cItem_CName,cFree3,cFree4,cFree5,cFree6,cFree7,cFree8,cFree9,cFree10,BomID,cbomsocode,dPreFinishDate,fTotolPut,bmrps,cinvcode,cinvname,dpredate,dprefinishdate,itaxrate,cfree1,cfree2,cfree3,cfree4,cfree5,cfree6,cfree7,cfree8,cfree9,cfree10,cunitid,iinvexchrate,iquantity,iquotedprice,isum,imoney,itax,idiscount,inatsum,inatmoney,inattax,inatdiscount,itaxunitprice,iunitprice,kl,kl2,inatunitprice,fsalecost,fsaleprice,id,csocode) Values (7003,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,107630,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,0,'A200C012','此编号作废','2016-01-16','2016-01-16',0,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,1,10,10,10,0,0,10,10,0,0,10,10,100,100,10,0,0,7003,'2016010001')
|