getPurchaseOrder

The getPurchaseOrder web service operation is a database query operation that enables consumers to query the JD Edwards EnterpriseOne Procurement system to retrieve existing purchase order information.

If the operation is successful, the system returns zero to many records to the consumer. You can specify the maximum number of records to return during a query using the Max Rows business service property. If the operation fails, the system returns an error message to the consumer.

The database query operation uses the V4301XPI business view which returns only the fields from the Purchase Order Header (F4301) and Purchase Order Detail File (F4311) tables that are needed for processing. Use of the business view allows retrieval of all required fields in a single optimized call.

Field retrieval is based on the selection criteria specified in the value object. The query published value object contains fields which filter the purchase order information retrieved by the JD Edwards EnterpriseOne operation.

This flow supports querying purchase order information in JD Edwards EnterpriseOne. The getPurchaseOrder web service operation enables source systems to query JD Edwards EnterpriseOne purchase order information in a real-time fashion. The selectPurchaseOrder adapter service is invoked to retrieve purchase order information from the V4301XPI business view in JD Edwards EnterpriseOne based on the selection criteria specified in the GetPurchaseOrder published interface document. Retrieved results are grouped together with header and detail information and mapped to the ShowPurchaseOrder published interface document and delivered back to the source application.

The query published interface contains fields that can be used to filter the purchase order information that is retrieved. At minimum, any of the purchase order keys (documentNumber, documentCompany, or documentType) or the item (short item number), or any combination of these fields, is required to process the getPurchaseOrder integration.

Optional fields to include in the filter are:

• BusinessUnit

• CurrencyCode

• Buyer

• Supplier

• ShipTo

• PaymentTermsCode

Note: Preceding spaces are already padded to the businessUnit value in the getPurchaseOrder web service operation. The JD Edwards EnterpriseOne date format is used to query purchase orders based on dates in the getPurchaseOrder operation.