JDBC Driver for Workday

Build 23.0.8839

CustomersActivities

Retrieves an activity instance for a specific customer.

Workday Resource Information

Secured by: Reports: Customer Accounts

Scope: Customer Accounts

Columns

Name Type Description
Id [KEY] String Returns the Workday ID for a given object.
Customers_Id [KEY] String The Workday ID of the Customers that owns this
ApplicationStatus String Supported for: SELECT. The payment or application status of the customer invoice, customer invoice adjustment or customer invoice payment. For customer invoice payments, the application status can be Unapplied, Applied with On Account, or Fully Applied. For invoices, the payment status can be Paid, Partially Paid, or Unpaid.
InvoiceDueDate Datetime Supported for: SELECT. The due date of the customer invoice or invoice adjustment as of the defined reporting date.
InvoiceOpportunity_Id String Supported for: SELECT. Returns the Workday ID for a given object.
InvoiceOpportunity_Name String Supported for: SELECT. The non-unique name of the Opportunity. This is for internal use only.
InvoiceOpportunity_OpportunityReferenceID String Supported for: SELECT. The Reference ID to use for lookups within our Workday Web Services. For supervisory organizations, this is also the 'Organization ID'
PaymentReference String Supported for: SELECT. The check number for a customer payment. This is a reference number that's available only when processed through a settlement run and not a check number.
TransactionAmountSigned_Currency String Supported for: SELECT. The positive or negative sign of the transaction amount for this customer transaction. This is for internal use only on a REST API.
TransactionAmountSigned_Value Decimal Supported for: SELECT. The positive or negative sign of the transaction amount for this customer transaction. This is for internal use only on a REST API.
TransactionDate Datetime Supported for: SELECT. The date of the customer transaction. This field is for internal use only on a REST API.
TransactionNumber String Supported for: SELECT. The transaction number for the reporting transaction. This is for internal use only on a REST API.
TransactionStatus String Supported for: SELECT. The current status of the transaction. Applicable for all transaction types. This is for internal use only on a REST API.
TransactionType String Supported for: SELECT. The transaction type of this customer transaction. This is for internal use only on a REST API.
FromDate_Prompt Date No description available
ToDate_Prompt Date No description available
Name_Prompt String Only used when a Customers_Id filter is not provided. No description available

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