ODBC Driver for Workday

Build 24.0.9062

PurchaseOrders

Retrieves a purchase order.

Workday Resource Information

Retrieves a purchase order with the specified ID.

Secured by: Process: Purchase Order - View, Process: Supplier Invoice (OLD)+TG, Process: Supplier Invoice - View, Self-Service: Purchase Order, Self-Service: Supplier Contact Tasks, View: Organization Purchase Order

Scope: Procurement, Supplier Accounts

Columns

Name Type Description
Id [KEY] String Id of the instance
BillToContactDetail String Supported for: SELECT. The bill-to contact information for the purchase order.
BillToContact_Descriptor String Supported for: SELECT. A description of the instance
BillToContact_Href String Supported for: SELECT. A link to the instance
BillToContact_Id String Supported for: SELECT. wid / id / reference id
Buyer_Descriptor String Supported for: SELECT. A description of the instance
Buyer_Href String Supported for: SELECT. A link to the instance
Buyer_Id String Supported for: SELECT. wid / id / reference id
Company_Descriptor String Supported for: SELECT. A description of the instance
Company_Href String Supported for: SELECT. A link to the instance
Company_Id String Supported for: SELECT. wid / id / reference id
CreditCard_Descriptor String Supported for: SELECT. A description of the instance
CreditCard_Href String Supported for: SELECT. A link to the instance
CreditCard_Id String Supported for: SELECT. wid / id / reference id
Currency_Descriptor String Supported for: SELECT. A description of the instance
Currency_Href String Supported for: SELECT. A link to the instance
Currency_Id String Supported for: SELECT. wid / id / reference id
Descriptor String Supported for: SELECT. A preview of the instance
DocumentDate Datetime Supported for: SELECT. The date of the purchase order. Users can manually update this value on the purchase order during creation.
DueDate Datetime Supported for: SELECT. The due date for the purchase order.
ExcludeFromMassClose Bool Supported for: SELECT. If true, indicates that the purchase order is manually excluded from mass close operations.
FreightAmount_Currency String Supported for: SELECT. The total amount of freight charges that are applicable for the taxable document. (Currency name)
FreightAmount_Value Decimal Supported for: SELECT. The total amount of freight charges that are applicable for the taxable document. (Value)
InternalMemo String Supported for: SELECT. The internal memo on a document. This type of memo is viewable by only internal workers of your company, and not any outside party.
IssueOption_Descriptor String Supported for: SELECT. A description of the instance
IssueOption_Href String Supported for: SELECT. A link to the instance
IssueOption_Id String Supported for: SELECT. wid / id / reference id
LineTotalAmount_Currency String Supported for: SELECT. The total extended amount for all purchase order lines. (Currency name)
LineTotalAmount_Value Decimal Supported for: SELECT. The total extended amount for all purchase order lines. (Value)
Memo String Supported for: SELECT. The memo on the purchase order. This field contains internal notes or reference text.
OrderFromConnection_Descriptor String Supported for: SELECT. A description of the instance
OrderFromConnection_Href String Supported for: SELECT. A link to the instance
OrderFromConnection_Id String Supported for: SELECT. wid / id / reference id
OtherCharges_Currency String Supported for: SELECT. The total amount of other charges that are applicable to the taxable document. (Currency name)
OtherCharges_Value Decimal Supported for: SELECT. The total amount of other charges that are applicable to the taxable document. (Value)
PaymentTerms_Descriptor String Supported for: SELECT. A description of the instance
PaymentTerms_Href String Supported for: SELECT. A link to the instance
PaymentTerms_Id String Supported for: SELECT. wid / id / reference id
PaymentType_Descriptor String Supported for: SELECT. A description of the instance
PaymentType_Href String Supported for: SELECT. A link to the instance
PaymentType_Id String Supported for: SELECT. wid / id / reference id
ShipToAddress_Descriptor String Supported for: SELECT. A description of the instance
ShipToAddress_Href String Supported for: SELECT. A link to the instance
ShipToAddress_Id String Supported for: SELECT. wid / id / reference id
ShipToContactDetail String Supported for: SELECT. The ship-to contact for the purchase order. This field contains the contact information for questions on orders, such as expected shipment date.
ShipToContact_Descriptor String Supported for: SELECT. A description of the instance
ShipToContact_Href String Supported for: SELECT. A link to the instance
ShipToContact_Id String Supported for: SELECT. wid / id / reference id
ShippingInstructions String Supported for: SELECT. The shipping instructions on the purchase order.
ShippingMethod_Descriptor String Supported for: SELECT. A description of the instance
ShippingMethod_Href String Supported for: SELECT. A link to the instance
ShippingMethod_Id String Supported for: SELECT. wid / id / reference id
ShippingTerms_Descriptor String Supported for: SELECT. A description of the instance
ShippingTerms_Href String Supported for: SELECT. A link to the instance
ShippingTerms_Id String Supported for: SELECT. wid / id / reference id
Status_Descriptor String Supported for: SELECT. A description of the instance
Status_Href String Supported for: SELECT. A link to the instance
Status_Id String Supported for: SELECT. wid / id / reference id
SubmittedBy_Descriptor String Supported for: SELECT. A description of the instance
SubmittedBy_Href String Supported for: SELECT. A link to the instance
SubmittedBy_Id String Supported for: SELECT. wid / id / reference id
SupplierContract_Descriptor String Supported for: SELECT. A description of the instance
SupplierContract_Href String Supported for: SELECT. A link to the instance
SupplierContract_Id String Supported for: SELECT. wid / id / reference id
Supplier_Descriptor String Supported for: SELECT. A description of the instance
Supplier_Href String Supported for: SELECT. A link to the instance
Supplier_Id String Supported for: SELECT. wid / id / reference id
TaxAmount_Currency String Supported for: SELECT. The total tax amount for the document. (Currency name)
TaxAmount_Value Decimal Supported for: SELECT. The total tax amount for the document. (Value)
TaxOption_Descriptor String Supported for: SELECT. A description of the instance
TaxOption_Href String Supported for: SELECT. A link to the instance
TaxOption_Id String Supported for: SELECT. wid / id / reference id
TotalAmount_Currency String Supported for: SELECT. The total extended amount of all purchase order lines for the purchase order. (Currency name)
TotalAmount_Value Decimal Supported for: SELECT. The total extended amount of all purchase order lines for the purchase order. (Value)
Buyer_Prompt String Accepts multiple inputs. Filters the purchase orders by buyer. Specify the Workday ID of the worker assigned as buyer on the purchase order. You can specify multiple buyer query parameters.
Company_Prompt String Accepts multiple inputs. Filters the purchase orders by company. Specify the Workday ID of the company. You can specify multiple company query parameters.
ExcludeCanceled_Prompt Bool If true, this method excludes the purchase orders with Canceled status. The default is false.
ExcludeClosed_Prompt Bool If true, this method excludes the purchase orders with Closed status. The default is false.
FromDate_Prompt Date Filters the purchase orders with document date on or after the specified date. Use the yyyy-mm-dd format.
OrderFromConnection_Prompt String Accepts multiple inputs. Filters the purchase orders by supplier order-from connections. Specify the Workday ID of the order-from connection. You can specify multiple order-from connection query parameters.
Status_Prompt String Accepts multiple inputs. Filters the purchase orders by status. Specify the Workday ID of the status. You can specify multiple status query parameters.
SubmittedBy_Prompt String Accepts multiple inputs. Filters the purchase orders by the worker who submitted the purchase order. Specify the Workday ID of the worker. You can specify multiple submittedBy query parameters. You can use a returned id from GET /workers in the Staffing REST web service.
Supplier_Prompt String Accepts multiple inputs. Filters the purchase orders by supplier. Specify the Workday ID of the supplier. You can specify multiple supplier query parameters.
ToDate_Prompt Date Filters the purchase orders with document date on or before the specified date. Use the yyyy-mm-dd format.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062