Purchaserequest

A purchase request [Purchaserequest] is a used to request the purchase of goods or services from external sources.

XML

SOAP

REST

Database table

Object

Purchaserequest

oaPurchaserequest

purchase_request

Supported Commands

Read

read()

The Purchaserequest object has the following standard properties:

Note:

Purchaserequest object properties may also include custom fields. The object type supports the custom equal to read method and the enable_custom read attribute.

XML / SOAP

Database

Description

approval_status

approval_status

[Read-only] A one-character string indicating the approval status of the purchase request. Possible values:

  • O - Open

  • P - Pending approval

  • A - Approved

  • R - Rejected

attachmentid

attachment_id

[Read-only] If non-zero, the attachment record associated with this purchase request.

attributes

attributes

[Read-only] A collection of additional attributes for this complex type.

created

created

[Read-only] Time the record was created. See Date Fields.

currency

currency

[Read-only] The currency of the total field.

customerid

customer_id

[Read-only] The ID of the associated customer that the material on this purchase request is for.

date

date

[Read-only] The date of the purchase request. See Date Fields.

date_approved

date_approved

[Read-only] The date the purchaserequest was approved. See Date Fields.

date_fulfilled

date_fulfilled

[Read-only] The date on which all of the total quantity was fulfilled. See Date Fields.

date_required

date_required

[Read-only] The date the material on this purchase request is required. See Date Fields.

date_submitted

date_submitted

[Read-only] The date the purchaserequest was submitted. See Date Fields.

description

description

[Read-only] The description or purpose for the purchaserequest.

exported

exported

[Read-only] Date and time the record was marked as exported. See Date Fields.

id

id

[Read-only] Unique ID. Automatically assigned by OpenAir.

name

name

[Read-only] The name of the purchaserequest (Prefix + number).

notes

notes

[Read-only] Notes associated with the purchase request.

number

number

[Read-only] The purchase request number that increments by 1.

ordered_request_items

ordered_request_items

[Read-only] The total number of request items on the purchase request which are part of a purchase order.

prefix

prefix

[Read-only] A static alphanumeric purchase request number prefix.

projectid

project_id

[Read-only] The ID of the associated project that the material on this purchase request is for.

quantity_fulfilled

quantity_fulfilled

[Read-only] The quantity fulfilled on all the request items in this purchase request.

request_items_fulfilled

request_items_fulfilled

[Read-only] The total number of fulfilled request items in the purchase request.

total

total

[Read-only] The purchase request total cost. Dated by the date field.

total_quantity

total_quantity

[Read-only] The total quantity of all the request items in this purchase request

total_request_items

total_request_items

[Read-only] The total number of request items in the purchase request.

updated

updated

[Read-only] Time the record was last updated or modified. See Date Fields.

userid

user_id

[Read-only] The ID of the associated user creating the purchase request. The requester.