adm_alert_config

Alert Configuration

This entity specifies general configuration for the alerts functionality. It defines the generic parameters required to send an e-mail alert.

adm_alert_group

Alert Group

This entity defines a collection of users and configuration parameters specific to that group of users. It is used to assign parameters defining the appropriateness of receiving an alert.

adm_alert_group_profile_subs

Alert Group Profile Subscription

This entity defines registrations between a group and profile such that the group is assigned to receive alerts for that profile.

adm_alert_group_subs

Alert Group Subscription

This entity defines registrations between a group and subscriber such that the group is assigned to receive alerts for that subscriber.

adm_alert_metric

Alert Metric

This entity defines a metric that is checked at runtime for all sessions derived from the session profile for which alerts are raised when stated conditions are not met. The metrics must be members of the set supported by QXtend Outbound.

adm_alert_user

Alert User

This entity defines an individual user (email address) that enables it to be registered to groups to receive alerts.

adm_alert_user_group

Alert User Group

This entity defines registrations between a user and group such that all members of a group will receive an alert if required.

adm_event_type

Event Type

This entity defines the event types for the source application type.

adm_event_type_src_app

Source Application Event Type

This entity defines the event types for the source application.

adm_evt_sess_link

Registered Event Type of Event Service

This entity maintains registered source application event types of an event service.

adm_module

Module

This entity defines the application module for the profile.

adm_session_profile

Service Session Profile

This entity defines a service session for all kinds of services, e.g. event service, message publisher, message sender; configures common session settings; and associates different entities to different services.

adm_sessprof_srcapp

Registered Source Application of Event Service

This entity lists source application codes that are serviced by profile sessions. It is populated for event service session profiles only.

adm_src_app

Source Application

This entity defines a source application whose events are published by QXtend Outbound.

adm_src_apptype

Source Application Type

This entity includes application type codes that represents source applications with the same structure. These applications may share the same business object definitions because their schema is the same.

adm_system_code

Outbound Parameter Settings

This table stores the various QXtend Outbound parameter settings in a hierarchical structure similar to that of an XML document.

adt_activity_log

Activity Log

This entity provides an audit trail of each significant QXtend Outbound activity, in the form of a comprehensive log record suitable for export to spreadsheet applications or other analysis/reporting tools. Activities recorded include session startup and shutdown, application event processing, and event message processing. The record references any associated application event or event message and provides the raw detail used to calculate overall QXtend Outbound operational statistics.

adt_alert_log

Alert Log

This entity stores alert conditions raised by QXtend Outbound processes and sends them to the attention of a system administrator. Where available, it references the activity log record for each alert condition.

adt_email_queue

Alert Email Queue

This entity contains the queue of email alerts ready to be delivered.

adt_msg_params

Message Parameters

This entity contains the message parameters passed between the Outbound services.

adt_session

Service Session

This entity describes the state of each running event service, message publisher, message sender, or subscriber services session, providing current processing status and basic throughput statistics.

adt_session_alive

Alive Service Sessions

This entity indicates whether a service is running.

adt_src_app_db

Databases Connection

This entity stores the database connection information for one database that is part of a source application.

adt_summary

Subscriber Summary

This entity contains the subscriber message summary.

adt_svc_alerts

Alert Conditions

This entity stores alert conditions raised by QXtend Outbound processes to the attention of a system administrator. It references the source process of each alert condition.

esm_bo

Business Object

This entity defines the business object. Business objects specify all application data available for publishing, constraining the definitions of subscription profiles. They query the application databases and extract the data to be published for each event.

esm_bo_do

Business Object Data Object

This entity defines a table contained in the business object that lists the joining relationship with the business object parent table and other extraction-related attributes. It references a child entity in the QXtend Outbound database to maintain field-level detail for each table.

esm_bo_event_type

Business Object Event Type

This entity contains the various event types for the business objects.

esm_bo_fld

Business Object Data Field

This entity identifies a field from a database table included in the business object or subscription profile and specifies data-formatting details inside outbound messages. Additional derived fields to be published are also defined. It is not maintained for all fields, only those using any attribute to control publishing.

Note: This table is obsolete as of version 1.4.

esm_bo_group

Business Object Group

This entity defines groups of business objects whose events must be published in chronological sequence. It is used to preserve the sequence of published outbound messages when all active event types within the group are all registered with the same event service.

esm_bo_group_ref

Business Object Group Link

This entity references each event group to its member event types.

esm_bo_sess_link

Registered Business Object of Message Publisher

This entity is an association table between esm_bo_profile and adm_session_profile.

esm_msgprof_link

Message Section Data Object Link

This entity maintains a link between a profile data table and the event message data table for determining if the record still exists in the source application.

esm_profile

Profile

This entity defines the business object. Business objects specify all application data available for publishing, constraining the definitions of subscription profiles. They also query the application databases and extract the data to be published for each event.

esm_profile_do

Profile Data Object

This entity defines a table contained in the business object that lists joining relationships with the business object parent table and other extraction-related attributes. It references a child entity in the QXtend Outbound database to maintain field-level detail for each table.

esm_profile_event_type

Profile Event Type

This entity contains the various event types for profiles.

esm_profile_fld

Profile Data Field

This entity identifies a field from a database table included in the business object or subscription profile and specifies data-formatting details inside outbound messages. Additional derived fields to be published are also defined. It is not maintained for all fields, only those using any attribute to control publishing.

esm_profile_type

Profile Type

This entity lists valid profile types that can be assigned to the esm_profile table.

est_event_msg

Event Message

This entity defines an event message consisting of a queued application event and the data regarding its associated business objects at the time the event was recorded. It is created and populated for each application event, and processed to create outbound messages for external subscribers.

est_event_msg_fld

Event Message Data Field

This entity defines a single data field and its value within a section of an event message. It represents the application data about the event that is available for publishing to external subscribers. This table is obsolete from version 1.4 onwards.

est_event_msg_sect

Event Message Section

This entity defines the section of an event message containing the data extracted from one entity instance within the event's associated business object. Normally, each section contains the data from a single record in the application database.

est_extract_event

Extract Event

This entity records the events that identify the data to be extracted from the source application.

est_extract_row

Extract Row

This entity includes the row identifier of the top level record of a business object in the source application.

mpm_archive

Archive Settings

This entity identifies the settings for the archive service.

mpm_delivery

Delivery Schedule

This entity identifies a delivery schedule that can be attached to a subscriber or a subscriber profile.

mpm_delivery_day

Delivery Day

This entity identifies a day to send a document for a delivery schedule.

mpm_delivery_Delay

Delivery Delay

This entity identifies a delay time for a delivery schedule.

mpm_delivery_month

Delivery Month

This entity identifies a sending month for a delivery schedule.

mpm_delivery_time

Delivery Time

This entity identifies a sending time for a delivery schedule.

mpm_profile_subs

Profile Subscription

This entity references a subscription profile to which an external system or application subscribes.

mpm_profile_subs_token

Subscriber Profile Tokens

This entity contains the tokens that can be used with subscriber profiles.

mpm_sesprof_subs

Registered Subscriber of Message Sender

This entity identifies the message sender process for a subscriber.

 

mpm_subs

Subscriber

This entity identifies an external system or application that subscribes to one or more business objects and describes how they communicate with QXtend Outbound.

mpm_subs_comm_param

Subscriber Communication Parameter

This entity defines the communications-related settings used to send messages to the external subscriber. The settings must be from the predefined set supported by QXtend Outbound for the subscriber’s communications method.

mpm_subs_event_type

Subscriber Event Type

This entity defines the event types for subscribers.

mpm_subs_srcapp

Source Application Restriction

This entity lists source applications that the subscriber is interested in.

mpm_subs_type

Subscriber Type

This entity identifies a subscriber type with which any external subscriber must be associated. The contents are populated at QAD and distributed to the customer, not maintained by users. All fields are encrypted before being stored to prevent users from making unauthorized changes to their QXtend Outbound license.

mpt_msg_subs_det

Subscriber Message Processing Details

This entity references a business object and external subscriber to which the outbound message is to be published. It is used to track the delivery of each message to all its subscribers.

mpt_msg_subs_excp

Subscriber Message Response Exception

This entity lists exceptions contained in a specific subscriber response message.

mpt_msg_subs_lock

Subscriber Message Lock

This entity indicates that a subscriber message for a particular rowid in the database is being sent. Only one message per rowid per subscriber can be sent at any one time.

mpt_msg_subs_resp

Subscriber Message Response

This entity contains the response information for a specific attempt to send the QDoc to the subscriber.

mpt_publ_msg

Profile Message

This entity defines a QDoc XML message created from an event message and to be published to one or more subscribers. It stores the processing state of the message.

mpt_subs_msg

Subscriber Message

This entity contains the message details for subscribers.

qxodb_ctrl

Outbound Database Control

Database Control for QXODB.