This documentation supports the 19.02 version of Asset Management.

To view the latest version, select the version from the Product version menu.

Query_PurchaseOrder

This operation supports a qualification to query for purchase orders. It will also return related children purchase line items for each purchase order found, based on the qualification entered. Depending on how general the qualification is, startRecord and maxLimit can be used to determine how many records should be shown at a time.

The following table lists input values for the Query_PurchaseOrder operation against the parent AST:PurchaseOrderInterface form.


Input field values

DB field on interface form

Displayed on web services

Notes

Qualification

AR System qualification required and is based on AST:PurchaseOrderInterface fields.

startRecord

maxLimit



The following table lists output values for the parent level of the Query_PurchaseOrder operation and maps to the AST:PurchaseOrderInterface form.


Output field values

DB field on interface form

Displayed on web services

Notes

Order ID

OrderID

Returns unique system-generated Order ID.

Status

Status

PO Number

PONumber

Date Ordered

DateOrdered

Payment Terms

PaymentTerms

Buyer

Buyer

Requested By+

RequestedBy

Supplier Name+

SupplierName

Notes to Supplier

NotesToSupplier

Tax Rate

TaxRate

Tax Amount/currencyValue

TaxAmount

Tax Amount/currencyCode

TaxCurrencyCode

Shipping & Handling/currencyValue

ShippingAndHandlingAmount

Shipping & Handling/currencyCode

ShippingAndHandlingCurrency Code

BillToAddr_Street

BillToStreet

BillToAddr_City Name+

BillToCity

BillToAddr_State/Prov

BillToStateProv

BillToAddr_Postal Code

BillToPostalCode

BillToAddr_Country

BillToCountry

ShipToAddr_Street

ShipToStreet

ShipToAddr_City Name+

ShipToCity

ShipToAddr_State/Prov

ShipToStateProv

ShipToAddr_Postal Code

ShipToPostalCode

ShipToAddr_Country

ShipToCountry

Freight Terms

FreightTerms

Ship Via

ShipVia

Shipping Options

ShippingOption

OrderConfirmation Type Code

OrderConfirmationTypeCode

WebServiceOrder

WebServiceOrder



The following table lists output values for the child level of the Query_PurchaseOrder operation and maps to the AST:PurchaseLineItem form.


Output field values

DB field on form

Displayed on web services

Notes

instanceId

InstanceID

Returns unique identifier, purchase line item Instance Id.

Part Number

PartNumber

Description

Description

Status

Status

Asset Class

CIType

RequestedForCompany

RequesterCompany

Unit of Measure

ProductUnitOfMeasureCode

Required Qty*

RequiredQty

Total Received Qty

TotalReceivedQty

Unit Price/currencyValue

UnitPriceAmount

Unit Price/currencyCode

UnitPriceCurrencyCode

Estimated Price/currencyValue

EstimatedPriceAmount

Estimated Price/currencyCode

EstimatedPriceCurrencyCode

Actual Price/currencyValue

ActualPriceAmount

Actual Price/currencyCode

ActualPriceCurrencyCode

Taxable

Taxable

Tax Amount/currencyValue

TaxAmount

Tax Amount/currencyCode

TaxCurrencyCode

Shipping & Handling/currencyValue

ShippingAndHandling Amount

Shipping & Handling/currencyCode

ShippingAndHandling CurrencyCode

Product Categorization Tier 1

Tier1

Product Categorization Tier 2

Tier2

Product Categorization Tier 3

Tier3

Model

ProductName

Version Number

ModelVersion

MarketVersion

MarketVersion

Manufacture Name+

Manufacturer

Supplier Name+

SupplierName

Requisition ID

RequisitionID

Order ID

OrderID

Quote Number

QuoteNumber

QuoteDesc

QuoteInfo

Date Required

DateRequired

Date Ordered

DateOrdered

Estimated Receiving Date

DateToReceive

Notes to Purchasing

NotesToPurchasing

Notes to Supplier

NotesToSupplier

Cost Center

CostCenter

Accounting Code

AccountingCode

Project Number

ProjectNumber

Budget Code

BudgetCode

Attachment1/attachmentName

DetailsAttachment1Name

Attachment1/attachmentData

DetailsAttachment1Data

Attachment1/attachmentOrigSize

DetailsAttachment1OrigSize

Audit Trail

ReadNotes

LicenseCertificateType

PurchaseType

Software Contract ID

SoftwareContractID

zID_LicenseType

LicenseType

zID_CertificateID

CertificateID



Was this page helpful? Yes No Submitting... Thank you

Comments