DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 848073 - Last Review: January 17, 2015 - Revision: 4.0

This article has been archived. It is offered "as is" and will no longer be updated.
This article has been archived. It is offered "as is" and will no longer be updated.

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

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: 
kbnosurvey kbarchive kbmbsmigrate KB848073
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support