| 解决方案： |
重新建立一个新的帐套,把丢失的记录采购退货单暂估记录导回.
INSERT INTO ufdata_006_2005.dbo.ia_subsidiary
SELECT bRdFlag,cBusType,cBusCode,cVouCode,ID,ValueID,JustID,dVouDate,dKeepDate,iMonth,iPZID,iPZDate,
cPZtype,cPZdigest,cInvHead,cDifHead,cOppHead,cVouType,cPTCode,cSTCode,cWhCode,cAccDep,cInvCode,
cRdCode,cVenCode,cCusCode,cOrderCode,cARVCode,cBillCode,cDLCode,cPSPCode,cProCode,cDepCode,
cPersonCode,cHandler,iAInQuantity,iAOutQuantity,iInCost,iOutCost,iAInPrice,iAOutPrice,cBatchCode,iDebitDifCost,
iCreditDifCost,cAccounter,cMaker,bFlag,bMoneyFlag,bSale,cMemo,cDefine1,cDefine2,cDefine3,cDefine4,
cDefine5,cDefine6,cDefine7,cDefine8,cDefine9,cDefine10,cFree1,cFree2,cPZID,cDefine22,cDefine23, cDefine24 ,cDefine25 ,cDefine26 ,cDefine27 ,cItem_class ,cItemCode ,cName ,cItemCName
FROM ufdata_666_2005.dbo.ia_subsidiary
WHERE iMonth = '0' AND iAInQuantity < 0 and bflag='1'
|