Power BI Connector for Workday

Build 25.0.9454

PurchaseOrders

Stores and retrieves purchase order details, including supplier information, order amounts, and transaction records.

Workday Resource Information

Retrieves a purchase order with the specified ID.

Secured by: Process: Purchase Order - View, Process: Supplier Invoice (OLD), 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 Unique identifier for the purchase order instance, used as a primary key reference.
BillToContactDetail String Full billing contact details associated with the purchase order, including name, address, phone number, and email.
BillToContact_Descriptor String The display name of the instance
BillToContact_Href String A hyperlink reference to the detailed Workday record for the billing contact, allowing navigation to additional details.
BillToContact_Id String Unique identifier for the billing contact within Workday, which could be a Workday ID (WID), reference ID, or other system-generated ID.
Buyer_Descriptor String The display name of the instance
Buyer_Href String A direct hyperlink to the Workday record for the buyer, providing quick access to related details.
Buyer_Id String Unique system identifier for the buyer, such as a WID or reference ID, used for relational mapping.
Company_Descriptor String The display name of the instance
Company_Href String A hyperlink reference to the Workday record for the company associated with this purchase order, allowing for further details.
Company_Id String System-generated identifier for the company entity, which can be a WID or another reference key.
CreditCard_Descriptor String The display name of the instance
CreditCard_Href String A hyperlink reference to the Workday record for the credit card information associated with this purchase.
CreditCard_Id String Unique identifier for the credit card on file within Workday, which can be a WID or reference ID.
Currency_Descriptor String The display name of the instance
Currency_Href String A hyperlink reference to the Workday record for the currency, allowing access to exchange rates and additional financial details.
Currency_Id String System-generated identifier for the currency, which could be a WID or another reference value.
Descriptor String The display name of the instance
DocumentDate Datetime The date when the purchase order was created. This field allows users to set or update the date to reflect when the order was officially recorded in the system.
DueDate Datetime The expected date by which the purchase order should be fulfilled. This is typically agreed upon by the buyer and supplier to ensure timely delivery of goods or services.
ExcludeFromMassClose Bool Indicates whether this purchase order should be excluded from mass close operations. If the value is 'true,' the order will not be automatically closed in bulk processing.
FreightAmount_Currency String The currency in which the freight charges for the taxable document are recorded. This ensures correct currency conversion and reporting.
FreightAmount_Value Decimal The total freight charges associated with this purchase order. This includes transportation costs for shipping goods to the designated location.
InternalMemo String An internal note attached to the purchase order, visible only to company employees. This memo can contain additional details, instructions, or references related to the order.
IssueOption_Descriptor String The display name of the instance
IssueOption_Href String A URL link pointing to the specific instance of the issue option, allowing users to access further details or perform actions related to the issue.
IssueOption_Id String A unique identifier (WID, ID, or reference ID), used to track the issue option associated with the purchase order in the system.
LineTotalAmount_Currency String The currency in which the total extended amount for all line items on the purchase order is denominated. This ensures consistency in financial transactions.
LineTotalAmount_Value Decimal The total amount for all line items on the purchase order, considering unit price and quantity. This value represents the overall cost before taxes and additional charges.
Memo String A general-purpose memo field for the purchase order, which can include notes, references, or any additional context provided by the user.
OrderFromConnection_Descriptor String The display name of the instance
OrderFromConnection_Href String A URL link to the order's originating connection instance, allowing users to review related details or historical data.
OrderFromConnection_Id String A unique identifier (WID, ID, or reference ID) for the source connection of the order, enabling system tracking and integration.
OtherCharges_Currency String The currency in which additional charges applicable to the taxable document are recorded, ensuring clarity in financial calculations.
OtherCharges_Value Decimal The total amount of other charges applied to the purchase order, such as handling fees, special service charges, or other miscellaneous costs.
PaymentTerms_Descriptor String The display name of the instance
PaymentTerms_Href String A URL link providing access to the payment terms instance, detailing conditions and policies for payment.
PaymentTerms_Id String A unique identifier (WID, ID, or reference ID) assigned to the payment terms associated with this purchase order, enabling precise tracking and compliance.
PaymentType_Descriptor String The display name of the instance
PaymentType_Href String A URL link pointing to the payment type instance, offering additional details on the selected payment method.
PaymentType_Id String A unique identifier (WID, ID, or reference ID) representing the specific payment type associated with the purchase order.
ShipToAddress_Descriptor String The display name of the instance
ShipToAddress_Href String A URL link directing users to the instance of the shipping address, providing further logistical details.
ShipToAddress_Id String A unique identifier (WID, ID, or reference ID), used to track and reference the shipping address within the system.
ShipToContactDetail String The full contact details for the designated recipient of the purchase order, including name, phone number, and email.
ShipToContact_Descriptor String The display name of the instance
ShipToContact_Href String A hyperlink reference to the specific ship-to contact record within the Workday system, allowing easy navigation to detailed contact information.
ShipToContact_Id String A unique identifier (WID, ID, or reference ID) associated with the ship-to contact, used for system tracking and integration.
ShippingInstructions String Instructions provided for shipping the purchase order, which can include preferred carriers, special handling requirements, or delivery timeframes.
ShippingMethod_Descriptor String The display name of the instance
ShippingMethod_Href String A hyperlink reference to the shipping method record in the system, allowing direct access to additional shipping details.
ShippingMethod_Id String A unique identifier (WID, ID, or reference ID) representing the selected shipping method in the Workday system.
ShippingTerms_Descriptor String The display name of the instance
ShippingTerms_Href String A hyperlink reference directing users to the shipping terms documentation or system record for further details.
ShippingTerms_Id String A system-generated identifier (WID, ID, or reference ID) for the specific shipping terms applied to the purchase order.
Status_Descriptor String The display name of the instance
Status_Href String A hyperlink reference to the status record in the system, providing direct access to status history and updates.
Status_Id String A unique identifier (WID, ID, or reference ID) representing the purchase order status within the Workday system.
SubmittedBy_Descriptor String The display name of the instance
SubmittedBy_Href String A hyperlink reference to the submitter’s record within Workday, allowing for quick access to the submitter's details.
SubmittedBy_Id String A unique identifier (WID, ID, or reference ID) assigned to the individual who submitted the purchase order.
SupplierContract_Descriptor String The display name of the instance
SupplierContract_Href String A hyperlink reference to the supplier contract record within Workday, allowing users to view contract details and agreements.
SupplierContract_Id String A unique identifier (WID, ID, or reference ID) representing the specific supplier contract linked to this purchase order.
Supplier_Descriptor String The display name of the instance
Supplier_Href String A hyperlink reference to the supplier’s record in Workday, providing access to supplier profile and transaction history.
Supplier_Id String A unique identifier (WID, ID, or reference ID) assigned to the supplier within the system.
TaxAmount_Currency String The currency code (for example, USD, EUR) representing the currency in which the total tax amount is denominated.
TaxAmount_Value Decimal The total tax amount applied to the purchase order, expressed in the designated currency. This includes applicable sales tax, VAT, or other relevant taxes.
TaxOption_Descriptor String The display name of the instance
TaxOption_Href String A hyperlink reference to the tax option record in the system, providing access to tax settings and configurations.
TaxOption_Id String A system-generated identifier (WID, ID, or reference ID) representing the selected tax option for this purchase order.
TotalAmount_Currency String Represents the currency in which the total extended amount of all purchase order lines is calculated. This value aligns with the currency settings defined for the purchase order.
TotalAmount_Value Decimal Indicates the total monetary value of all purchase order lines combined, expressed in the currency specified by TotalAmount_Currency.
Buyer_Prompt String Allows filtering of purchase orders based on the designated buyer. Enter the WID of the worker assigned as the buyer for the purchase order.
Company_Prompt String Filters purchase orders by company. Enter the WID of the company associated with the purchase order.
ExcludeCanceled_Prompt Bool Determines whether purchase orders with a Canceled status should be excluded from the results. If the value is 'true,' purchase orders marked as Canceled will be omitted. The default value is 'false.'
ExcludeClosed_Prompt Bool Determines whether purchase orders with a Closed status should be excluded from the results. If the value is 'true,' purchase orders marked as Closed will be omitted. The default value is 'false.'
FromDate_Prompt Date Filters purchase orders by document date, returning only those with a date on or after the specified value. The date should be provided in the format YYYY-MM-DD.
OrderFromConnection_Prompt String Filters purchase orders based on the supplier's order-from connection. Enter the WID of the order-from connection to limit results.
Status_Prompt String Filters purchase orders by status. Enter the WID corresponding to the purchase order's current status.
SubmittedBy_Prompt String Filters purchase orders by the worker who submitted them. Enter the WID of the worker responsible for submitting the purchase order.
Supplier_Prompt String Filters purchase orders by supplier. Enter the WID of the supplier associated with the purchase order.
ToDate_Prompt Date Filters purchase orders by document date, returning only those with a date on or before the specified value. The date should be provided in the format YYYY-MM-DD.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454