====== Database Triggers ======

Database triggers are activated by successful table operations in an application, such as saving a record, deleting a record or reading a record. These triggers are activated in Dexterity as opposed to in and by SQL Server. This means that SQL table operations performed outside the [[dynamics:dynamics|Microsoft Dynamics GP]] environment will not activate these triggers. Dexterity database triggers can also be restricted to operations performed in a specified form. DynamicZip registers the following Database Triggers:

  * Delete operations on the RM Customer MSTR table performed in the [[dynamics:windows:Customer Maintenance window]].    
    * This trigger will remove records from the [[dynamiczip:tables:DZ Customer Supplement table]], the [[dynamiczip:tables:DZ Customer Address Supplement table]] and the [[dynamiczip:tables:DZ Customer Tax by State table]] related to the deleted customer.
  * Delete operations on the PM Transaction WORK table performed in the Payables Batch Entry form.    
    * This trigger will remove records from the [[dynamiczip:tables:DZ PM Taxes Work and History table]] related to the deleted batch.
  * Delete operations on the [[dynamics:tables:Sales Purchases Tax Schedule Header Master table]] performed in the [[dynamics:windows:Tax Schedule Maintenance window]]. 
    * This trigger will remove the related record from the [[dynamiczip:tables:DZ Tax Schedule Supplement table]].

----

[[dynamiczip:glossary:Glossary]]