In order to bring you the best possible user experience, this site uses Javascript. If you are seeing this message, it is likely that the Javascript option in your browser is disabled. For optimal viewing of this site, please ensure that Javascript is enabled for your browser.
Login  |   On Demand  |   Home  |   qad.com




QXtend Table Descriptions
This section includes an alphabetical listing of tables used in the QXtend schema.
These definitions are meant to be used in conjunction with the section Entity Diagrams.
 
Table
Name
Description
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, for example, 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 represent 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.