Query Sales Order Service
This service is in the WmOAOMG1227 package and has the following fully-qualified service name: orderManagement1227.queryOA.salesOrder:querySalesOrder.
This service queries for new, changed, and deleted booked sales orders. You can use the following parameters to query sales orders:
CUSTOMER_NAME
ORDER_NUMBER.
ORDER_TYPE
ORGANIZATION_NAME
SHIP_TO_ADDRESS (1-4)
SHIP_TO_CITY
SHIP_TO_COUNTY
SHIP_TO_POSTAL_CODE
SHIP_TO_PROVINCE
SHIP_TO_COUNTRY
INVOICE_ADDRESS (1-4)
INVOICE_CITY
INVOICE_COUNTY
INVOICE_POSTAL_CODE
INVOICE_PROVINCE_INT
INVOICE_COUNTRY
PRICE_LISTDatabase Scripts
This service uses the same database script as the Send Sales Order service.
Note:
If you use this service but you do not use the Send Sales Order service, you should run the wm_disable_from_salesorder.sql script to disable the triggers installed by the Send Sales Order service.
For a detailed description of these database scripts, see
Send Sales Order Service . For more information about using database scripts, see
Database Scripts.
Supporting Transaction Definitions
This service uses the following transaction definition:
![*](chapterTOC_bullet.png)
querySalesOrderTxn1227.txp
Flow Control
The main flow executes as follows:
querySalesOrderTxn: queries Sales Order information matching the parameter values. The parameters are defined as the input to this service.
For more details on query services, see
Using Query Services.
Business Document Structure
This service uses the same business document structure as the Send Sales Order service. For a detailed description of the business document structure, see
Send Sales Order Service.