This documentation supports the 19.02 version of Asset Management.

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

Query_PurchaseLineItem

The query operation supports a qualification to query for purchase line items. It will also return related children work information and return records for each purchase line item 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_PurchaseLineItem operation against the parent AST:PurchaseLineItemInterface form.

Input field values

DB field on interface form

Displayed on web services

Notes

Qualification

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

startRecord

maxLimit

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

Output field values

DB field on interface form

Displayed on web services

Notes

InstanceID

InstanceID

Returns unique identifier, purchase line item Instance Id.

Part Number

PartNumber

Description

ItemDescription

Status

ItemStatus

Asset Class

CIType

RequestedFor_Company

RequesterCompany

Unit of Measure

UnitOfMeasure

Required Qty

RequiredQty

Received Qty

ReceivedQty

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

ShippingAndHandling/currencyValue

ShippingAndHandlingAmount

ShippingAndHandling/currencyCode

ShippingAndHandling CurrencyCode

Product Categorization Tier 1

ProductTier1

Product Categorization Tier 2

ProductTier2

Product Categorization Tier 3

ProductTier3

ProductName

Model

ModelVersion

VersionNumber

MarketVersion

MarketVersion

Manufacturer

ManufacturerName+

SupplierName

Supplier Name+

RequisitionID

Requisition ID

OrderID

Order ID

QuoteNumber

Quote Number

QuoteDesc

QuoteInfo

PRNumber

PRNumber

PO Number

PONumber

Data Tags

DataTags

Date Required

DateRequired

Date Ordered

DateOrdered

EstimatedReceivingDate

DateToReceive

Notes to Purchasing

NotesToPurchasing

Notes to Supplier

NotesToSupplier

Cost Center

CostCenter

Accounting Code

AccountingCode

Project Number

ProjectNumber

Budget Code

BudgetCode

Attachment1/attachmentName

PLIAttachmentName

Attachment1/attachmentData

PLIAttachmentData

Attachment1/attachmentOrigSize

PLIAttachmentOrigSize

Audit Trail

ReadNotes

License Certificate Type

CertificatePurchaseType

Software Contract ID

Software Contract ID

zID_LicenseType

LicenseType

zID_LicenseCertificateID

CertificateID

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

Output field values

DB field on interface form

Displayed on web services

Notes

InstanceId

WorkInfoInstanceID

The unique Instance ID for the work information record.

Purchase Line Item Instance ID

SourceInstanceID

This is the foreign key, purchase line item Instance ID, which the work information record is linked to.

Work Log Type

WorkInfoType

Work Log Date

WorkInfoDate

Communication Source

WorkInfoSource

Description

WorkInfoSummary

Detailed Description

WorkInfoNotes

Secure Work Log

WorkInfoLocked

View Access

WorkInfoViewAccess

z2AF Work Log01/attachmentName

WorkInfoAttachment1Name

z2AF Work Log01/attachmentData

WorkInfoAttachment1Data

z2AF Work Log01/attachmentOrigSize

WorkInfoAttachment1OrigSize

z2AF Work Log02/attachmentName

WorkInfoAttachment2Name

z2AF Work Log02/attachmentData

WorkInfoAttachment2Data

z2AF Work Log02/attachmentOrigSize

WorkInfoAttachment2OrigSize

z2AF Work Log03/attachmentName

WorkInfoAttachment3Name

z2AF Work Log03/attachmentData

WorkInfoAttachment3Data

z2AF Work Log03/attachmentOrigSize

WorkInfoAttachment3OrigSize

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

Output field values

DB field on interface form

Displayed on web services

Notes

Instanceid

InstanceID

Returns unique identifier.

Line Item Instance ID

LineItemInstanceID

Purchase line item Instance ID.

Type

Type

RMA Number

RMANumber

Quantity to Return

QuantityToReturn

Reason for Return

ReasonForReturn

Replacement Received

ReplacementReceived

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

Comments