JDBC Driver for Workday

Build 23.0.8839

Customers

Retrieves a single customer instance.

Workday Resource Information

Retrieves a customer with the specified ID.

Secured by: View: Customer

Scope: Customers

Columns

Name Type Description
Id [KEY] String Id of the instance
Category_Descriptor String Supported for: SELECT. A description of the instance
Category_Href String Supported for: SELECT. A link to the instance
Category_Id String Supported for: SELECT. wid / id / reference id
CommercialCreditScore Decimal Supported for: SELECT. The Dun and Bradstreet Commercial credit score of the customer.
CompositeRiskScore Decimal Supported for: SELECT. The Dun and Bradstreet risk score of the customer.
CreditLimit_Currency String Supported for: SELECT. The maximum credit limit for the customer.
CreditLimit_Value Decimal Supported for: SELECT. The maximum credit limit for the customer.
Name String Supported for: SELECT. The name of the customer.
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
PrimaryPhone String Supported for: SELECT. The primary phone number of the customer.
SatisfactionScore Decimal Supported for: SELECT. The customer satisfaction score.
TotalBalance_Currency String Supported for: SELECT. The total customer balance due in the customer currency, as of the report run time. Workday calculates the total balance by adding the amount of all approved and uncanceled customer invoices and subtracting the total amount of all approved and uncanceled customer payments. The customer currency can be the default currency for the tenant, or the currency you define for a given customer.
TotalBalance_Value Decimal Supported for: SELECT. The total customer balance due in the customer currency, as of the report run time. Workday calculates the total balance by adding the amount of all approved and uncanceled customer invoices and subtracting the total amount of all approved and uncanceled customer payments. The customer currency can be the default currency for the tenant, or the currency you define for a given customer.
Name_Prompt String No description available

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