SETQUOTED_IDENTIFIERONGOSETANSI_NULLSONGOIFEXISTS(select*fromsysobjectswherename='ICMrpDestBills_Insert_SynFields'andtype='TR')DropTRIGGERICMrpDestBills_Insert_SynFieldsGOCREATETRIGGER[ICMrpDestBills_Insert_SynFields]ON[dbo].[ICMrpDestBills]FORINSERTASupdatev1setv1.FHeadSelfJ0158=u2.FBillNo--FHeadSelfJ0160产品预测单号,v1.FHeadSelfJ0159=u4.FName--FHeadSelfJ0161产品预测单表体物料名称fromICMOv1leftjoinICMrpDestBillsu1onv1.FInterID=u1.FDestBillInterIDleftouterjoinPPOrderu2onv1.FPPOrderInterID=u2.FInterID--产品预测单表头leftouterjoinPPOrderEntryu3onu2.FInterID=u3.FInterID--产品预测单表体leftouterjoinT_ICItemu4onu3.FItemID=u4.FItemIDwhereu1.FTranTypein(54,85)andu3.FEntryID=v1.FSourceEntryIDGOSETQUOTED_IDENTIFIEROFFGOSETANSI_NULLSONGOMPS订单自定义携带到MRP订单样例：SETQUOTED_IDENTIFIERONGOSETANSI_NULLSONGOIFEXISTS(select*fromsysobjectswherename='ICMRPResult_Insert'andtype='TR')DropTRIGGERICMRPResult_InsertGOCREATETRIGGER[ICMRPResult_Insert]ON[dbo].[ICMRPResult]FORINSERTASupdatev1setv1.FHeadSelfJ0538=T3.FHeadSelfJ0538fromICMRPResultv1innerjoininsertedu1onu1.FInterID=V1.FInterIDinnerjoin(SELECTT1.FInterID,T1.FHeadSelfJ0538FROMICMRPResultt1INNERJOINinsertedT2ONT2.FSrcPlanOrderInterID=T1.FInterID)T3ONV1.FSrcPlanOrderInterID=T3.FInterIDGOSETQUOTED_IDENTIFIEROFFGOSETANSI_NULLSONGO
