QAD QXtend Outbound Overview > Application Overview > Business Objects and Outbound QDocs
  
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. See Adding Source Application Business Object Groups. 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.