Power BI Connector for Workday

Build 25.0.9454

Customers

Contains customer profile data, including contact details, purchase history, and account preferences for business operations and CRM integrations.

Workday Resource Information

Retrieves a customer with the specified ID.

Secured by: View: Customer

Scope: Customers

Columns

Name Type Description
Id [KEY] String The system-generated identifier (Id) for this customer record, uniquely distinguishing it in the system. This Id is used internally by Workday to reference the customer in transactions, reports, and integrations.
Category_Descriptor String The display name of the instance
Category_Href String A link to the Workday resource for the customer category, allowing retrieval of additional details about the category, such as its definition, applicable customers, and financial implications.
Category_Id String The unique Id for the customer category, which can be a Workday Id, an internal Id, or a reference Id. This value is used in API calls and integrations to link a customer to a predefined category.
CommercialCreditScore Decimal The Dun and Bradstreet commercial credit score assigned to the customer, indicating their creditworthiness based on financial data, payment history, and business risk factors. A higher score represents lower credit risk, influencing the terms and limits of credit extended to the customer.
CompositeRiskScore Decimal The Dun and Bradstreet composite risk score for the customer, assessing their overall financial stability and risk level. This score helps businesses evaluate potential financial exposure and make informed credit decisions.
CreditLimit_Currency String The currency in which the customer's maximum credit limit is defined, typically following ISO 4217 standards (for example, USD for US Dollar, EUR for Euro). This field ensures consistency in financial reporting and transactions.
CreditLimit_Value Decimal The maximum credit amount that can be extended to the customer, based on their financial standing and risk profile. This value determines the upper limit for outstanding balances on invoices before additional approvals or restrictions apply.
Name String The official name of the customer, as recorded in the Workday system. This name appears on invoices, reports, and financial transactions.
PaymentTerms_Descriptor String The display name of the instance
PaymentTerms_Href String A link to the Workday resource for the customer's payment terms, allowing retrieval of additional details (for examples, payment schedules, late fees, and applicable discounts).
PaymentTerms_Id String The unique Id for the payment terms assigned to the customer, which can be a Workday Id, an internal Id, or a reference Id. This value is used in financial transactions and reporting to ensure accurate tracking of payment conditions.
PrimaryPhone String The primary phone number associated with the customer, used for business communications, account inquiries, and support services.
SatisfactionScore Decimal A numerical score representing customer satisfaction, based on feedback, surveys, or performance metrics. This score can be used in customer relationship management (CRM) processes to track engagement and loyalty.
TotalBalance_Currency String The currency in which the total customer balance is recorded, typically following ISO 4217 standards (for example, USD for US Dollar, EUR for Euro). The balance currency can differ from the default company currency if transactions are conducted in multiple currencies.
TotalBalance_Value Decimal The total outstanding balance due from the customer, calculated as the sum of all approved and uncanceled customer invoices minus the total amount of all approved and uncanceled customer payments. This value represents the total amount owed by the customer as of the report run time.
Name_Prompt String A reference field used to specify or retrieve the customer's name in Workday, typically used in reports, integrations, and API calls.

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