Populate Marketing Download Trigger File (G33)

Purpose: Use this screen to define what types of activity in the system should create records in the Marketing Download Trigger table.

Code field: Enter the code that indicates the types of activity that should create records in the Marketing Download Trigger table (IXMKDT).

Valid values are:

ORDER = Order entry and order maintenance.

CUSTOMER = Customer maintenance and catalog requests.

ORD/CUST = Order entry, order maintenance, customer requests, and catalog requests.

Why write trigger records? You can use the records in the Marketing Download Trigger table to drive an extract process for an interface related to order and/or customer activity. The presence of the trigger record indicates that there is updated information to be collected in Order Management System. Using the trigger table enables you to schedule the update and download process at a time when there is less interactive activity, making your system usage more efficient.

Example: You would like to download current information in your house list to an external service. You could set this system control value to CUSTOMER so that each time you update a customer record in Order Management System, the system writes a trigger. You could then run a periodic function on a weekly basis, preferably at a time when system resources are more available, to retrieve each customer record that has an associated trigger, and extract the new customer information from Order Management System to your external service.

When the system creates a marketing download trigger, the trigger is assigned a trigger type based on the type of activity that was performed. The trigger type determines what fields are populated in the Marketing Download Trigger table and what extract table is populated when you run the marketing download trigger periodic function.

See Working with the Marketing Download Extract for an overview of the Marketing Download extract process.

When is the trigger record created? Each of the trigger record types indicated are created when the update in Order Management System is complete. For an interactive process, such as creating or updating a customer in order entry, the trigger record is created immediately. For an update that is handled by an asynchronous job, such as order creation, the trigger record is not created until the job processing is complete.

Leave this field blank if you do not want to populate the Marketing Download Trigger table.

IN03_08 OMSCS 19.0 December 2019 OHC