BEM Trigger Edit MXF3

This screen is used to create a BEM Trigger SQL expression from the before and after Base table column values.

To create a BEM Trigger enter:

Update Event; Update, Delete or Insert
Trigger granularity; Row or Statement.
The Query. For example for a High Value Order Line on a fixed company

N.CMPY = 'DK' AND N.ENTRD_VAL>=100000

In this case N.xxxxx is the new column value and O.xxxxx would be the original column value (for an Update)

This screen provides edit facilities to either;

Manually create a Custom DB Trigger for the current Object Event Action base Table building up the SQL expression one column at a time.
Reference a generated (for a Table defined for Web Service Export) DB Trigger within an Include definition.
Drop and Recreate the DB Trigger.

NOTE BEM Trigger definitions may differ between systems and therefore MUST be shipped using the Shipped Data system to convert between Databases. Also, any Generated Web Service Exports MUST be re-generated and Dropped / Recreated before any new versions come into effect.

If not described in this topic, click on a field and press F1 to view help. See Common Fields for more information.

Fast prompt allows you to quickly view a list of options for certain fields.

NOTE Field visibility can be defined by your System Administrator, so not all fields documented may be shown.

See Using the Command Line on opening the screen without going through the menu.