ODBC Driver for Workday

Build 24.0.9060

ExpenseEntries

Retrieves a single instance of a Quick Expense.

Workday Resource Information

Retrieves a Quick Expense with the specified WID.

Secured by: Self-Service: Expense Report

Scope: Expenses

Contains attachment(s)

Aggregate Fields

The driver represents the following fields as aggregates containing JSON text. Each of them conforms to their respective schema. Fields marked with an asterisk are required and must be included if their parent object is.

This information is derived from the Workday REST API specification which does not explicitly list all business rules and validations that apply to each object. More fields may be required than what is listed here.

Attachments_Aggregate


[{
  contentType: { /* Content type of the attachment */
     *id: Text /* wid / id / reference id */
  }
  descriptor: Text /* A preview of the instance */
  fileLength: Numeric /* File length of the attachment */
  fileName: Text /* File name of the attachment */
  href: Text /* A link to the instance */
  id: Text /* Id of the instance */
}]

Columns

Name Type ReadOnly Description
Id [KEY] String False

Id of the instance

Amount_Currency String False

Supported for: SELECT, INSERT, UPDATE. Amount for Expense Entry (Currency name)

Amount_Value Decimal False

Supported for: SELECT, INSERT, UPDATE. Amount for Expense Entry (Value)

Attachments_Aggregate String False

Supported for: INSERT. A JSON aggregate. CRF for Entries REST operation to expose Attachment related to Optical Character Recognition

Date Datetime False

Supported for: SELECT, INSERT, UPDATE. Date of Expense Entry

Descriptor String False

Supported for: SELECT, INSERT, UPDATE. A preview of the instance

EntryType_Descriptor String False

Supported for: SELECT. A description of the instance

EntryType_Href String False

Supported for: SELECT. A link to the instance

EntryType_Id String False

Supported for: SELECT. wid / id / reference id

ExpenseEntryStatus_Descriptor String False

Supported for: SELECT. A description of the instance

ExpenseEntryStatus_Href String False

Supported for: SELECT. A link to the instance

ExpenseEntryStatus_Id String False

Supported for: SELECT. wid / id / reference id

ExpenseItem_Descriptor String False

Supported for: SELECT. A description of the instance

ExpenseItem_Href String False

Supported for: SELECT. A link to the instance

ExpenseItem_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

HasOCRReceipt Bool False

Supported for: SELECT, INSERT. Boolean value indicating whether the Mobile Expense has an OCR image.

Href String False

Supported for: SELECT, INSERT, UPDATE. A link to the instance

Image_Id String False

Supported for: UPDATE. wid / id / reference id

Memo String False

Supported for: SELECT, INSERT, UPDATE. Memo for the Entry

Merchant String False

Supported for: SELECT, INSERT, UPDATE. Expense Merchant Name

ScanStatus_Descriptor String False

Supported for: SELECT. A description of the instance

ScanStatus_Href String False

Supported for: SELECT. A link to the instance

ScanStatus_Id String False

Supported for: SELECT, INSERT. wid / id / reference id

EntryType_Prompt String False

No description available.

ExpenseEntryStatus_Prompt String False

No description available.

FromDate_Prompt Date False

No description available.

ToDate_Prompt Date False

No description available.

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