ExpenseEntries

Stores individual Quick Expense entries, detailing cost, category, and payment information for employee reimbursements and financial reporting.

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. Fields marked with a hyphen are read-only and must not be included when calling stored procedures or when performing an INSERT or UPDATE.

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 */
     -descriptor: Text /* A description of the instance */
     -href: Text /* A link to the instance */
     *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	Unique identifier for the expense entry instance.
Amount_Currency	String	False	Currency code representing the currency of the expense entry amount, for example, United States Dollar (USD), Euro (EUR), British Pound Sterling (GBP).
Amount_Value	Decimal	False	Monetary value of the expense entry, expressed in the specified currency.
Attachments_Aggregate	String	False	Aggregate reference for attachments related to Optical Character Recognition (OCR), exposed via the Entries REST operation.
Date	Datetime	False	Date when the expense entry was recorded.
Descriptor	String	False	A brief textual preview or summary of the expense entry instance.
EntryType_Descriptor	String	False	Descriptive label for the type of expense entry (for example, Travel, Meals, Lodging).
EntryType_Href	String	False	URL reference linking to the detailed information for the expense entry type.
EntryType_Id	String	False	Unique identifier (WID, Id, or reference Id) associated with the expense entry type.
ExpenseEntryStatus_Descriptor	String	False	Descriptive label for the current status of the expense entry (for example, Submitted, Approved, Rejected).
ExpenseEntryStatus_Href	String	False	URL reference linking to detailed information for the expense entry status.
ExpenseEntryStatus_Id	String	False	Unique identifier (WID, Id, or reference Id) associated with the expense entry status.
ExpenseItem_Descriptor	String	False	Descriptive label for the expense item category (for example, Airfare, Taxi, Hotel).
ExpenseItem_Href	String	False	URL reference linking to detailed information for the expense item category.
ExpenseItem_Id	String	False	Unique identifier (WID, Id, or reference Id) associated with the expense item category.
HasOCRReceipt	Bool	False	Boolean value indicating whether the expense entry includes an image captured using OCR.
Href	String	False	URL reference linking to the detailed expense entry instance.
Image_Id	String	False	Unique identifier (WID, Id, or reference Id) associated with the attached receipt image.
Memo	String	False	Additional notes or comments entered for the expense entry.
Merchant	String	False	Name of the merchant or vendor associated with the expense transaction.
ScanStatus_Descriptor	String	False	Descriptive label indicating the scan status of the OCR receipt (for example, Processed, Failed, Pending).
ScanStatus_Href	String	False	URL reference linking to detailed information about the scan status.
ScanStatus_Id	String	False	Unique identifier (WID, Id, or reference Id) associated with the scan status.
EntryType_Prompt	String	False	Prompt text displayed when selecting an expense entry type.
ExpenseEntryStatus_Prompt	String	False	Prompt text displayed when selecting the status of an expense entry.
FromDate_Prompt	Date	False	Prompt text indicating the starting date range for filtering expense entries.
ToDate_Prompt	Date	False	Prompt text indicating the ending date range for filtering expense entries.

JDBC Driver for Workday

ExpenseEntries

Workday Resource Information

Aggregate Fields

Attachments_Aggregate

Columns