dynamiczip:glossary:database_triggers
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 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 Customer Maintenance window.
- This trigger will remove records from the DZ Customer Supplement table, the DZ Customer Address Supplement table and the 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 DZ PM Taxes Work and History table related to the deleted batch.
- Delete operations on the Sales Purchases Tax Schedule Header Master table performed in the Tax Schedule Maintenance window.
- This trigger will remove the related record from the DZ Tax Schedule Supplement table.
dynamiczip/glossary/database_triggers.txt · Last modified: 2017/09/08 21:55 by conni