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




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.