Standard Triggers in Microsoft Dynamics SL

Article translations Article translations
Article ID: 848073 - View products that this article applies to.
Expand all | Collapse all

TechKnowledge Content



SUMMARY

This article discusses the standard Triggers in Microsoft Dynamics SL. 

MORE INFORMATION

1. Make a BACKUP of the appropriate database that can be restored in case an undesired data loss occurs.

2. Using Query Analyzer, access the appropriate Application database and execute the following statement:

SELECT * from SYSOBJECTS where XType = 'TR'

3. Review the results from step 2.

Dynamics SL 2011 Service Pack 1 (SP1) uses the following triggers:
EDPurchOrd_Insert
TrnsfrDocStatusUpdate
UpdateSOShipLotWithShipLine
ADG_TR_CustNameXref_Add
ADG_TR_CustNameXref_Delete
ADG_TR_InvtDescrXref_Add
ADG_TR_InvtDescrXref_Delete
INPrjAllocHistory_Insert
INPrjAllocTranHist_Insert
INPrjAllocLotHist_Insert
Delegation_Message_Trigger

Dynamics SL 2011 uses the following triggers:
RC_Delete_Trigger
EDPurchOrd_Insert
TrnsfrDocStatusUpdate
UpdateSOShipLotWithShipLine
ADG_TR_CustNameXref_Add
ADG_TR_CustNameXref_Delete
ADG_TR_InvtDescrXref_Add
ADG_TR_InvtDescrXref_Delete

Dynamics SL 7.0 SP 4 users the following triggers:
batchhold_trigger
EDPurchOrd_Insert
TrnsfrDocStatusUpdate
UpdateSOShipLotWithShipLine
ADG_TR_CustNameXref_Add
ADG_TR_CustNameXref_Delete
ADG_TR_InvtDescrXref_Add
ADG_TR_InvtDescrXref_Delete

Dynamics SL 7.0 Feature Pack 1 (FP1) uses the following triggers:
batchhold_trigger
EDPurchOrd_Insert
TrnsfrDocStatusUpdate
UpdateSOShipLotWithShipLine
ADG_TR_CustNameXref_Add
ADG_TR_CustNameXref_Delete
ADG_TR_InvtDescrXref_Add
ADG_TR_InvtDescrXref_Delete
RC_Delete_Trigger

Dynamics SL 7.0 Service Pack 2 (SP2) uses the following triggers:
TrnsfrDocStatusUpdate
UpdateSOShipLotWithShipLine
ADG_TR_CustNameXref_Add
ADG_TR_CustNameXref_Delete
batchhold_trigger
ADG_TR_InvtDescrXref_Add
ADG_TR_InvtDescrXref_Delete
EDPurchOrd_Insert


Solomon IV only uses the following Triggers:

ADG_TR_CustNameXref_Add
ADG_TR_InvtDescrXref_Add
ADG_TR_CustNameXref_Delete
ADG_TR_InvtDescrXref_Delete
EDPurchOrd_Insert
TrnsfrDocStatusUpdate
UpdateSOShipLotWithShipLine

Note If FRx 6.5 is being used, the following Triggers are also standard:

FRx_account_update
FRx_accthist_insert
FRx_acctsub_update
FRx_gltran_insert

This article was TechKnowledge Document ID: 135778

Properties

Article ID: 848073 - Last Review: September 20, 2012 - Revision: 3.0
Applies to
  • Microsoft Dynamics SL 2011 Service Pack 1
  • Microsoft Dynamics SL 2011
  • Microsoft Dynamics SL 7.0 Service Pack 4
  • Microsoft Dynamics SL 7.0 Service Pack 3
  • Microsoft Dynamics SL 7.0 Service Pack 2
Keywords: 
kbmbsmigrate KB848073

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com