ODBC Driver for Workday

Build 24.0.9060

PurchaseOrdersBillToAddress

Reads /billToAddress entries from the PurchaseOrders table.

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
PurchaseOrders_Id [KEY] String The Workday ID of the PurchaseOrders that contains this.
Descriptor String Supported for: SELECT. A preview of the instance
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.9060