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  |   Cloud ERP  |   Home  |   qad.com



  •     QAD Glossary

  • 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.