yilv_new/AA/sql/材料出库单到中间.sql

--将材料出库单传递到中间库(委外订单不受约束)
if exists (select * from sysobjects where id = object_id('dbo.usp_transrdrecord11') )
        drop procedure dbo.usp_transrdrecord11
go

Create  PROCEDURE usp_transrdrecord11

@v_start			datetime,			--开始时间
@v_end   			datetime    		--结束时间

as

select Id into #t_01 from rdrecord11 r
where (dnmaketime>=@v_start and dnmaketime <= @v_end and ISNULL(cDefine5,0) = 0)
	or (exists (select Id  from RdRecord01  where cBusType='委外加工' and ID=r.ID)    )
	
if @@ROWCOUNT=0 return  
	   


--delete from wtu..rdrecord11 where  exists (select id from #t_01)
--delete from wtu..rdrecords11 where  exists (select id from #t_01)
delete from wtu..rdrecord11  where  exists (select id from #t_01 where ID=wtu..rdrecord11.ID)
delete from wtu..rdrecords11 where  exists (select id from #t_01 where ID=wtu..rdrecords11.ID)


insert into wtu..RdRecord11
(ID,
bRdFlag,
cVouchType,
cBusType,
cSource,
cBusCode,
cWhCode,
dDate,
cCode,
cRdCode,
cDepCode,
cPersonCode,
cPTCode,
cSTCode,
cCusCode,
cVenCode,
cOrderCode,
cARVCode,
cBillCode,
cDLCode,
cProBatch,
cHandler,
cMemo,
bTransFlag,
cAccounter,
cMaker,
cDefine1,
cDefine2,
cDefine3,
cDefine4,
cDefine5,
cDefine6,
cDefine7,
cDefine8,
cDefine9,
cDefine10,
dKeepDate,
dVeriDate,
bpufirst,
biafirst,
iMQuantity,
dARVDate,
cChkCode,
dChkDate,
cChkPerson,
VT_ID,
bIsSTQc,
cDefine11,
cDefine12,
cDefine13,
cDefine14,
cDefine15,
cDefine16,
cPsPcode,
cMPoCode,
gspcheck,
ipurorderid,
iproorderid,

iExchRate,
cExch_Name,
bOMFirst,
bFromPreYear,
bIsLsQuery,
bIsComplement,
iDiscountTaxType,
ireturncount,
iverifystate,
iswfcontrolled,
cModifyPerson,
dModifyDate,
dnmaketime,
dnmodifytime,
dnverifytime,
bredvouch,
bmotran,
iFlowId,
cPZID,
cSourceLs,
cSourceCodeLs,
bHYVouch,
iPrintCount,
csysbarcode,
cCurrentAuditor,
cCheckSignFlag

)
select 
r.ID,
bRdFlag,
cVouchType,
cBusType,
cSource,
cBusCode,
cWhCode,
dDate,
cCode,
cRdCode,
cDepCode,
cPersonCode,
cPTCode,
cSTCode,
cCusCode,
cVenCode,
cOrderCode,
cARVCode,
cBillCode,
cDLCode,
cProBatch,
cHandler,
cMemo,
bTransFlag,
cAccounter,
cMaker,
cDefine1,
cDefine2,
cDefine3,
cDefine4,
cDefine5,
cDefine6,
cDefine7,
cDefine8,
cDefine9,
cDefine10,
dKeepDate,
dVeriDate,
bpufirst,
biafirst,
iMQuantity,
dARVDate,
cChkCode,
dChkDate,
cChkPerson,
VT_ID,
bIsSTQc,
cDefine11,
cDefine12,
cDefine13,
cDefine14,
cDefine15,
cDefine16,
cPsPcode,
cMPoCode,
gspcheck,
ipurorderid,
iproorderid,

iExchRate,
cExch_Name,
bOMFirst,
bFromPreYear,
bIsLsQuery,
bIsComplement,
iDiscountTaxType,
ireturncount,
iverifystate,
iswfcontrolled,
cModifyPerson,
dModifyDate,
dnmaketime,
dnmodifytime,
dnverifytime,
bredvouch,
bmotran,
iFlowId,
cPZID,
cSourceLs,
cSourceCodeLs,
bHYVouch,
iPrintCount,
csysbarcode,
cCurrentAuditor,
cCheckSignFlag

 
from RdRecord11 r where  exists(select ID from #t_01 t where t.ID=r.ID)


---------------------------------------------
insert into wtu..RdRecords11
(
AutoID,
r.ID,
cInvCode,
iNum,
iQuantity,
iUnitCost,
iPrice,
iAPrice,
iPUnitCost,
iPPrice,
cBatch,
cObjCode,
cVouchCode,
cInVouchCode,
cinvouchtype,
iSOutQuantity,
iSOutNum,
coutvouchid,
coutvouchtype,
iSRedOutQuantity,
iSRedOutNum,
cFree1,
cFree2,
iFlag,
iSQuantity,
iSNum,
iFNum,
iFQuantity,
dVDate,
iTrIds,
cPosition,
cDefine22,
cDefine23,
cDefine24,
cDefine25,
cDefine26,
cDefine27,
cItem_class,
cItemCode,
cName,
cItemCName,
cFree3,
cFree4,
cFree5,
cFree6,
cFree7,
cFree8,
cFree9,
cFree10,
cBarCode,
iNQuantity,
iNNum,
cAssUnit,
dMadeDate,
iMassDate,
cDefine28,
cDefine29,
cDefine30,
cDefine31,
cDefine32,
cDefine33,
cDefine34,
cDefine35,
cDefine36,
cDefine37,
iMPoIds,
iCheckIds,
cBVencode,
bGsp,
cGspState,
cCheckCode,
iCheckIdBaks,
cRejectCode,
iRejectIds,
cCheckPersonCode,
dCheckDate,
cMassUnit,
cMoLotCode,
iMaterialFee,
iProcessCost,
iProcessFee,
dMSDate,
iSMaterialFee,
iSProcessFee,
iOMoDID,
bFilled,
bChecked,
iOMoMID,
cmworkcentercode,
bLPUseFree,
iRSRowNO,
iOriTrackID,
coritracktype,
cbaccounter,
dbKeepDate,
bCosting,
bVMIUsed,
iVMISettleQuantity,
iVMISettleNum,
cvmivencode,
iInvSNCount,
cwhpersoncode,
cwhpersonname,
iMaIDs,
cserviceoid,
cbserviceoid,
iinvexchrate


)
select 
AutoID,
r.ID,
cInvCode,
iNum,
iQuantity,
iUnitCost,
iPrice,
iAPrice,
iPUnitCost,
iPPrice,
cBatch,
cObjCode,
cVouchCode,
cInVouchCode,
cinvouchtype,
iSOutQuantity,
iSOutNum,
coutvouchid,
coutvouchtype,
iSRedOutQuantity,
iSRedOutNum,
cFree1,
cFree2,
iFlag,
iSQuantity,
iSNum,
iFNum,
iFQuantity,
dVDate,
iTrIds,
cPosition,
cDefine22,
cDefine23,
cDefine24,
cDefine25,
cDefine26,
cDefine27,
cItem_class,
cItemCode,
cName,
cItemCName,
cFree3,
cFree4,
cFree5,
cFree6,
cFree7,
cFree8,
cFree9,
cFree10,
cBarCode,
iNQuantity,
iNNum,
cAssUnit,
dMadeDate,
iMassDate,
cDefine28,
cDefine29,
cDefine30,
cDefine31,
cDefine32,
cDefine33,
cDefine34,
cDefine35,
cDefine36,
cDefine37,
iMPoIds,
iCheckIds,
cBVencode,
bGsp,
cGspState,
cCheckCode,
iCheckIdBaks,
cRejectCode,
iRejectIds,
cCheckPersonCode,
dCheckDate,
cMassUnit,
cMoLotCode,
iMaterialFee,
iProcessCost,
iProcessFee,
dMSDate,
iSMaterialFee,
iSProcessFee,
iOMoDID,
bFilled,
bChecked,
iOMoMID,
cmworkcentercode,
bLPUseFree,
iRSRowNO,
iOriTrackID,
coritracktype,
cbaccounter,
dbKeepDate,
bCosting,
bVMIUsed,
iVMISettleQuantity,
iVMISettleNum,
cvmivencode,
iInvSNCount,
cwhpersoncode,
cwhpersonname,
iMaIDs,
cserviceoid,
cbserviceoid,
iinvexchrate

from RdRecords11 r  where  exists(select ID from #t_01 t where t.ID=r.ID)
--释放临时表
drop table #t_01