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

  • Business Objects and Outbound QDocs
    All outbound QDocs are defined by an underlying business object. A business object usually consists of data from a related set of tables required from a source QAD application. One such set is the sales order business object, which consists of sales order header and line data; ship-to, sold-to, and bill-to customer information; Intrastat data; tax details; and comments.
    Each business object is defined in the QXO administrative interface, which lets you select the tables and fields your target applications—your subscribers—need. However, all subscribers do not require the same elements from any given business object. To tailor business object output for multiple subscribers, you define profiles that filter and qualify business object data for one or more subscribers.
    Business objects that are associated with a direct data publish (DDP) source application type are passed directly to QXO. For details see Direct Data Publish.
    Data Flow from QAD Enterprise Applications to Profiles shows the basic data flow of data from QAD Enterprise Applications tables to the profiles that provide the template for outbound QDocs for specific subscribers.

    Data Flow from QAD Enterprise Applications to Profiles
    With the current release of QXO, the following 36 business objects are shipped with the product.

    Standard QXO Business Objects for QAD Enterprise Applications
     
    Alternate Unit of Measure
    Inventory Status
    Sales Order Price List
    Analysis Code
    Inventory Transaction
    Scheduled Sales Order
    Analysis Code Link
    Invoice History
    Service Category
    Analysis Code Selection
    Item
    Service Support Call
    Carrier
    Item Site Cost
    Service Support End User
    Cost Set
    Master Comment
    Service Support Engineer
    Customer
    Product Line
    Service Support Work Code
    Customer Item
    Product Structure
    Shipper
    Customer Schedule
    Product Structure Code
    Ship-To Customer
    Department
    Purchasing Price List
    Site
    Forecast
    Routing
    Supplier Item
    Generalized Codes
    Sales Order
    Work Center
    These business objects reference data in the tables listed in Tables with Schema Triggers. Tables shown in Tables with Programmatic Triggers use database triggers or business events; if there is no business event indicated, a database trigger is used.

    Tables with Programmatic Triggers
     
    Business Event
    Table Name
    Description
    QAD EE
    QAD SE
     
    abs_mstr
    ASN/BOL/Shipper Master
    ?
    ?
     
    absd_det
    Shipment Line Item Detail
    ?
    ?
     
    absl_det
    Shipment Detail Line Charges
    ?
    ?
     
    absr_det
    Shipment Requirement Detail
    ?
    ?
    AccountMaintenance
    ac_mstr
    Account Master
     
    ?
    CarrierAddressMaintenance
     
     
    ?
     
    CurrencyAccountMaintenance
    acdf_mstr
    Account Default Master
     
    ?
     
    actid_det
    Activity ID Detail
     
     
     
    ad_mstr
    Address Master
    ?
    ?
     
    an_mstr
    Analysis Code Master
    ?
     
     
    anl_det
    Analysis Link Code Detail
    ?
     
     
    ans_det
    Analysis Code Selection Detail
    ?
     
     
    asc_mstr
    Account/Sub-Account/Cost Center Master
     
     
     
    aterr_mstr
    Audit Trail Error Master
     
     
     
    attmp_mstr
    Audit Trail Temporary Master
     
     
     
    bom_mstr
    Product Structure (Bill of Material) Master
    ?
    ?
     
    ca_mstr
    Service/Support Call Master
    ?
    ?
     
    cc_mstr
    Cost Center Master
     
     
     
    ccd_mstr
    Service/Support Call Fault Code Master
    ?
    ?
     
    cd_det
    Master Comments
    ?
    ?
    CustomerMaintenance
    cm_mstr
    Customer Master
    ?
    ?
    ShipToMaintenance
    cm_mstr
    Customer Master
    ?
    ?
     
    cmt_det
    Transaction Comments
    ?
    ?
     
    code_mstr
    Generalized Code Master
    ?
    ?
     
    com_mstr
    Commodity Code Master
     
    ?
     
    cp_mstr
    Customer Item Master
    ?
    ?
     
    cs_mstr
    Cost Set Master
    ?
     
    CreditTermsMaintenance
    ct_mstr
    Credit Terms Master
     
    ?
    CommodityCodeMaster
    com_mstr
    Commodity Code Master
    ?
     
    CommodityCodeMaintenance
     
     
     
    ?
     
    ctd_det
    Credit Terms Detail
     
     
    CountryMaintenance
    ctry_mstr
    Country Master
    ?
    ?
    CurrencyAccountMaintenance
    cu_mstr
    Currency Master
     
    ?
    CurrencyMaintenance
     
     
     
    ?
     
    dom_mstr
    Domain Master
     
     
     
    dpt_mstr
    Department Master
    ?
     
     
    dy_mstr
    General Ledger Daybook Master
     
     
     
    dybs_mstr
    Daybook Set Master
     
     
     
    egt_mstr
    Service/Support Engineer Tracking Master
    ?
    ?
     
    emp_mstr
    Employee Master
     
     
     
    en_mstr
    Entity Master
     
     
     
    eng_mstr
    Service/Support Engineer Master
    ?
    ?
     
    eu_mstr
    Service/Support End User Master
    ?
     
     
    eud_det
    Service/Support End User Detail
     
     
    ExchangeRateMaintenance
    exr_rate
    Exchange Rate Master
     
    ?
    FormatPositionMaintenance
     
     
     
    ?
    GeneralizedCodeMaintenance
     
     
    ?
    ?
     
    fcs_sum
    Forecast Summary
    ?
    ?
     
    fsc_mstr
    Service Category Master
    ?
    ?
     
    fwk_mstr
    Service/Support Work Code Master
    ?
    ?
     
    gl_ctrl
    System/Account Control
     
     
    CalendarMaintenance
    glc_cal
    General Ledger Calendar
     
    ?
     
    glcd_det
    General Ledger Calendar Detail
     
     
     
    idh_hist
    Invoice History Detail
    ?
    ?
     
    ied_det
    Import/Export Detail
    ?
    ?
     
    ie_mstr
    Import/Export Master
    ?
    ?
     
    ih_hist
    Invoice History Master
    ?
    ?
    InventoryStatusMaintenance
     
     
    ?
    ?
    InvoicePost
     
     
    ?
    ?
    ItemDataMaintenance
     
     
    ?
    ?
    ItemInventoryMaintenance
     
     
    ?
    ?
    ItemMaintenance
    in_mstr
    Inventory Master
    ?
    ?
    ItemSiteInventoryMaintenance
     
     
    ?
    ?
     
    isb_mstr
    Service/Support Installed Base Item Master
    ?
    ?
     
    isd_det
    Inventory Status Detail
    ?
     
     
    is_mstr
    Inventory Status Master
    ?
    ?
     
    itm_det
    Service/Support Call Item Detail
    ?
    ?
     
    lacd_det
    Logistics Accounting Charge Detail
    ?
    ?
     
    lng_mstr
    Language Master
     
     
     
    ls_mstr
    Address List Detail
    ?
     
     
    nr_mstr
    Number Range Master
     
     
     
    pc_mstr
    Price List Manager
    ?
     
     
    pid_det
    Price List Detail
    ?
    ?
     
    pi_mstr
    Price List Master
    ?
    ?
     
    pl_mstr
    Product Line Master
    ?
    ?
     
    pod_det
    Purchase Order Detail
     
    ?
     
    po_mstr
    Purchase Order Master
     
    ?
    ProductLineMaintenance
     
     
    ?
    ?
     
    ps_mstr
    Product Structure Master
    ?
    ?
     
    pt_mstr
    Item Master
    ?
    ?
     
    ptp_det
    Item Planning Detail
    ?
    ?
     
    qaddb_ctrl
    Database Control for QADDB
     
     
     
    rnd_mstr
    Rounding Method Master
     
     
     
    ro_det
    Routing Operation Detail
    ?
    ?
     
    schd_det
    Release Management Schedule Detail
    ?
    ?
     
    sch_mstr
    Release Management Schedule Master
    ?
    ?
     
    sct_det
    Cost Simulation Total Detail
    ?
    ?
     
    scx_ref
    Scheduled Order Cross-Reference
    ?
    ?
     
    si_mstr
    Site Master
    ?
    ?
    SalesOrderMaintenance
    so_mstr
    Sales Order Master
    ?
    ?
    SalesOrderPrint
    so_mstr
    Sales Order Master
     
    ?
    SalesOrderShip
    so_mstr
    Sales Order Master
     
    ?
     
    sob_det
    Sales Order Configuration Bill Detail
    ?
    ?
     
    sod_det
    Sales Order Detail
    ?
    ?
     
    sodlc_det
    Sales Order Detail Line Charges
    ?
    ?
     
    spt_det
    Cost Simulation Item Detail
    ?
    ?
     
    tr_hist
    Inventory Transaction History
    ?
    ?
     
    tx2d_det
    Tax Detail
    ?
    ?
     
    um_mstr
    Unit of Measure Conversion Master
    ?
     
     
    udd_det
    User Domain Detail
     
     
     
    usrgd_det
    User Group Detail
     
     
    ShipToMaintenance
     
     
     
    ?
    ShipperWorkbench
     
     
    ?
    ?
    ScheduledOrderMaintenance
     
     
    ?
    ?
    SupplierMaintenance
    vd_mstr
    Vendor Master
    ?
    ?
     
    vp_mstr
    Supplier Item Master
    ?
     
     
    wc_mstr
    Work Center Master
    ?
     
     
    wo_mstr
    Work Order Master
    ?
    ?
     
    wod_det
    Work Order Detail
    ?
    ?
     
    wr_route
    Word Order Routing
    ?
    ?
    Each of the tables in Tables with Schema Triggers is defined in QXO as an event type. For these tables, schema triggers are loaded during installation and can be activated as needed. The tables vary slightly by QAD Enterprise Applications release. A check mark indicates that, by default, a trigger is provided in the database schema.

    Tables with Schema Triggers
     
    Table Name
    Description
    eB
    eB2
    eB2.1
    QAD SE
    QAD EE
    absc_det
    Shipment Carrier Detail
     
     
     
     
    ?
    absd_det
    Shipment Line Item Detail
     
    ?
    ?
    ?
    ?
    absl_det
    Shipment Detail Line Charges
     
    ?
    ?
    ?
    ?
    absr_det
    Shipment Requirement Detail
    ?
    ?
    ?
    ?
    ?
    abs_mstr
    ASN/BOL/Shipper Master
    ?
    ?
    ?
    ?
    ?
    acdf_mstr
    Account Default Master
    ?
    ?
    ?
    ?
     
    ac_mstr
    Account Master
    ?
    ?
    ?
    ?
     
    ad_mstr
    Address Master
    ?
    ?
    ?
    ?
    ?
    anl_det
    Analysis Code Link Detail
     
     
     
     
    ?
    ans_det
    Analysis Code Selection Detail
     
     
     
     
    ?
    an_mstr
    Analysis Code Master
     
     
     
     
    ?
    bom_mstr
    Product Structure (Bill of Material) Master
    ?
    ?
    ?
    ?
    ?
    ca_mstr
    Service/Support Call Master
    ?
    ?
    ?
    ?
    ?
    ccd_mstr
    Service/Support Call Fault Code Master
    ?
    ?
    ?
    ?
    ?
    cd_det
    Master Comments
    ?
    ?
    ?
    ?
    ?
    cm_mstr
    Customer Master
    ?
    ?
    ?
    ?
    ?
    cmt_det
    Transaction Comments
    ?
    ?
    ?
    ?
     
    code_mstr
    Generalized Codes Master
    ?
    ?
    ?
    ?
    ?
    com_mstr
    Commodity Code Master
    ?
    ?
    ?
    ?
     
    cp_mstr
    Customer Item Master
    ?
    ?
    ?
    ?
    ?
    cs_mstr
    Cost Set Master
     
     
     
     
    ?
    cu_mstr
    Currency Master
    ?
    ?
    ?
    ?
     
    dpt_mstr
    Department Master
     
     
     
     
    ?
    egt_mstr
    Service/Support Engineer Tracking Master
    ?
    ?
    ?
    ?
    ?
    eng_mstr
    Service/Support Engineer Master
    ?
    ?
    ?
    ?
    ?
    eu_mstr
    Service/Support End User Master
    ?
    ?
    ?
    ?
    ?
    fcs_sum
    Forecast
    ?
    ?
    ?
    ?
    ?
    fsc_mstr
    Service Category Master
    ?
    ?
    ?
    ?
    ?
    fwk_mstr
    Service/Support Work Code Master
    ?
    ?
    ?
    ?
    ?
    glc_cal
    General Ledger Calendar
    ?
    ?
    ?
    ?
     
    idh_hist
    Invoice History Detail
    ?
    ?
    ?
    ?
    ?
    ie_mstr
    Import/Export Master
    ?
    ?
    ?
    ?
    ?
    ied_det
    Import/Export Detail
    ?
    ?
    ?
    ?
    ?
    ih_hist
    Invoice History Master
    ?
    ?
    ?
    ?
    ?
    in_mstr
    Inventory Master
    ?
    ?
    ?
    ?
    ?
    is_mstr
    Inventory Status Master
    ?
    ?
    ?
    ?
    ?
    isb_mstr
    Service/Support Installed Base Item Master
    ?
    ?
    ?
    ?
    ?
    isd_det
    Inventory Status Detail
     
     
     
     
    ?
    itm_det
    Service/Support Call Item Detail
    ?
    ?
    ?
    ?
    ?
    lacd_det
    Logistics Accounting Charge Detail
     
    ?
    ?
    ?
    ?
    ls_mstr
    Address List Detail
    ?
    ?
    ?
    ?
    ?
    pc_mstr
    Price List Master - Purchasing
     
     
     
     
    ?
    pi_mstr
    Price List Master
    ?
    ?
    ?
    ?
    ?
    pid_det
    Price List Detail
    ?
    ?
    ?
    ?
    ?
    pl_mstr
    Product Line Master
    ?
    ?
    ?
    ?
    ?
    pod_det
    Purchase Order Detail
    ?
    ?
    ?
    ?
     
    po_mstr
    Purchase Order Master
    ?
    ?
    ?
    ?
     
    ps_mstr
    Product Structure Master
    ?
    ?
    ?
    ?
    ?
    pt_mstr
    Item Master
    ?
    ?
    ?
    ?
    ?
    ptp_det
    Item Planning Detail
    ?
    ?
    ?
    ?
    ?
    ro_det
    Routing Operation Detail
    ?
    ?
    ?
    ?
    ?
    sch_mstr
    Release Management Schedule Master
    ?
    ?
    ?
    ?
    ?
    schd_det
    Release Management Schedule Detail
    ?
    ?
    ?
    ?
    ?
    sct_det
    Cost Simulation Total Detail
    ?
    ?
    ?
    ?
    ?
    scx_ref
    Scheduled Order Cross-Reference
    ?
    ?
    ?
    ?
    ?
    si_mstr
    Site Master
    ?
    ?
    ?
    ?
    ?
    sob_det
    Sales Order Configuration Bill Detail
    ?
    ?
    ?
    ?
    ?
    sod_det
    Sales Order Detail
    ?
    ?
    ?
    ?
    ?
    sodlc_det
    Sales Order Detail Line Charges
     
    ?
    ?
    ?
    ?
    so_mstr
    Sales Order Master
    ?
    ?
    ?
    ?
    ?
    spt_det
    Cost Simulation Item Detail
    ?
    ?
    ?
    ?
    ?
    tr_hist
    Inventory Transaction History
    ?
    ?
    ?
    ?
    ?
    tx2d_det
    Tax Detail
    ?
    ?
    ?
    ?
    ?
    um_mstr
    Alternate Unit of Measure Master
     
     
     
     
    ?
    vd_mstr
    Supplier Master
    ?
    ?
    ?
    ?
    ?
    vp_mstr
    Vendor Item Master
     
     
     
     
    ?
    wc_mstr
    Work Center
     
     
     
     
    ?
    wo_mstr
    Work Order Master
    ?
    ?
    ?
    ?
    ?
    wod_det
    Work Order Detail
    ?
    ?
    ?
    ?
    ?
    wr_route
    Work Order Routing
    ?
    ?
    ?
    ?
    ?
    Sequencing Business Dependencies
    Because QXO supports multiple event services in a distributed environment, it is possible to load data messages in an incorrect sequence. For example, a sales order may be sent through before the new or revised customer record for that order. In certain scenarios, it is possible for you to enforce correct chronological sequencing of data messages to avoid this kind of situation.
    By assigning business objects to a business object group, you can ensure that the business objects and their tables will be processed and published in the same order they are set up in the group, provided that all the active event types in the group are registered with the same event service. For example, place the Customer and Sales Order business objects in a business object group and register all related active event types with the same event service so that if an event is generated for both these objects, the customer data will be always extracted prior to the sales order data.
    However, if active event types in a business object group are not registered with the same event service, business objects in the group will be processed by different event services, which defeats the purpose of business object groups since you cannot guarantee that data of designated business objects will be processed as set up in the group in a single-thread manner. This gives rise to a warning message in configuration validation.
    For information on event type registration, see Registering Event Types with an Event Service.
    Business object groups are set up as part of the source application configuration. Each business object can belong to only one group.
    Note: Business object groups are not defined for business objects that employ DDP.