ODBC Driver for Workday

Build 24.0.9060

BillableTransactions

Retrieves a single billable transaction instance.

Workday Resource Information

Retrieves a billable project transaction with the specified ID.

Secured by: Manage: Project Details, Process: Project Billing - View

Scope: Project Billing, Project Tracking

Columns

Name Type ReadOnly Description
Id [KEY] String False

Id of the instance

AdjustmentCount Decimal False

Supported for: SELECT. The count of the billing rate application for the billable transaction.

AdjustmentReason_Descriptor String False

Supported for: SELECT. A description of the instance

AdjustmentReason_Href String False

Supported for: SELECT. A link to the instance

AdjustmentReason_Id String False

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

AmountToBill_Currency String False

Supported for: SELECT, UPDATE. The amount to bill for a billable transaction, excluding applicable tax. (Currency name)

AmountToBill_Value Decimal False

Supported for: SELECT, UPDATE. The amount to bill for a billable transaction, excluding applicable tax. (Value)

BillableAmount_Currency String False

Supported for: SELECT. The original amount to bill the customer, excluding extended amounts on tax only customer invoices. (Currency name)

BillableAmount_Value Decimal False

Supported for: SELECT. The original amount to bill the customer, excluding extended amounts on tax only customer invoices. (Value)

BillableHours Decimal False

Supported for: SELECT. The original hours to bill the customer.

BillableRate_Currency String False

Supported for: SELECT. The original rate to bill the customer. (Currency name)

BillableRate_Value Decimal False

Supported for: SELECT. The original rate to bill the customer. (Value)

BillingStatus_Descriptor String False

Supported for: SELECT. A description of the instance

BillingStatus_Href String False

Supported for: SELECT. A link to the instance

BillingStatus_Id String False

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

Category_Descriptor String False

Supported for: SELECT. A description of the instance

Category_Href String False

Supported for: SELECT. A link to the instance

Category_Id String False

Supported for: SELECT. wid / id / reference id

Customer_Descriptor String False

Supported for: SELECT. A description of the instance

Customer_Href String False

Supported for: SELECT. A link to the instance

Customer_Id String False

Supported for: SELECT. wid / id / reference id

Descriptor String False

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

ExpenseDescriptor_Descriptor String False

Supported for: SELECT. A description of the instance

ExpenseDescriptor_Href String False

Supported for: SELECT. A link to the instance

ExpenseDescriptor_Id String False

Supported for: SELECT. wid / id / reference id

HoursToBill Decimal False

Supported for: SELECT, UPDATE. The actual hours available to bill for the billable transaction.

Href String False

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

InvoiceDescription String False

Supported for: SELECT. The description for the supplier invoice line item, expense report line item, or usage-based transaction.

Memo String False

Supported for: SELECT, UPDATE. The memo for the project billable transaction.

PreviouslyInvoiced Bool False

Supported for: SELECT. If true, the billable transaction has been previously invoiced.

ProjectRole_Descriptor String False

Supported for: SELECT. A description of the instance

ProjectRole_Href String False

Supported for: SELECT. A link to the instance

ProjectRole_Id String False

Supported for: SELECT. wid / id / reference id

ProjectTask_Descriptor String False

Supported for: SELECT. A description of the instance

ProjectTask_Href String False

Supported for: SELECT. A link to the instance

ProjectTask_Id String False

Supported for: SELECT. wid / id / reference id

Project_Descriptor String False

Supported for: SELECT. A description of the instance

Project_Href String False

Supported for: SELECT. A link to the instance

Project_Id String False

Supported for: SELECT. wid / id / reference id

RateToBill_Currency String False

Supported for: SELECT, UPDATE. The actual rate that the billable transaction is billed at. (Currency name)

RateToBill_Value Decimal False

Supported for: SELECT, UPDATE. The actual rate that the billable transaction is billed at. (Value)

ReasonForChange String False

Supported for: SELECT, UPDATE. The reason for the rate change for the billable transaction.

ResourceProvider_Descriptor String False

Supported for: SELECT. A description of the instance

ResourceProvider_Href String False

Supported for: SELECT. A link to the instance

ResourceProvider_Id String False

Supported for: SELECT. wid / id / reference id

RevenueStatus_Descriptor String False

Supported for: SELECT. A description of the instance

RevenueStatus_Href String False

Supported for: SELECT. A link to the instance

RevenueStatus_Id String False

Supported for: SELECT. wid / id / reference id

TransactionDate Datetime False

Supported for: SELECT. The date of the billable transaction.

TransactionSource_Descriptor String False

Supported for: SELECT. A description of the instance

TransactionSource_Href String False

Supported for: SELECT. A link to the instance

TransactionSource_Id String False

Supported for: SELECT. wid / id / reference id

Worker_Descriptor String False

Supported for: SELECT. A description of the instance

Worker_Href String False

Supported for: SELECT. A link to the instance

Worker_Id String False

Supported for: SELECT. wid / id / reference id

ZeroAmountToBill Bool False

Supported for: SELECT, UPDATE. If true, the billable transaction has a zero rate.

BillingStatus_Prompt String False

Accepts multiple inputs. Filters the billable transactions by status. Specify the Workday ID of the status. You can specify multiple status query parameters.

Customer_Prompt String False

The Workday ID of the customer associated with the project for the billable transaction. To get a valid ID, you can call GET /customers in the Customer Accounts REST service.

FromDate_Prompt Date False

Filters the billable transactions with transaction date on or after the specified date. Use the yyyy-mm-dd format.

Phase_Prompt String False

The Workday ID of the project phase associated with the billable transaction for the time entry. To get a valid ID, call GET /planPhases in the Projects REST service.

Project_Prompt String False

The Workday ID of the project associated with the billable transactions. To get a valid ID, you can call GET /projects in the Projects REST service.

SpendCategory_Prompt String False

Accepts multiple inputs. The Workday ID of the spend category for the billable transaction associated with the expense report line.

Task_Prompt String False

The Workday ID of the project task associated with the billable transaction for the time entry. To get a valid ID, call GET /planTasks in the Projects REST service.

TimeCode_Prompt String False

The Workday ID of the time code for the billable transaction associated with the time entry.

ToDate_Prompt Date False

Filters the billable transactions with transaction date on or before the specified date. Use the yyyy-mm-dd format.

TransactionSource_Prompt String False

Filters the billable transactions by transaction source. Specify the Workday ID of the transaction source.

Worker_Prompt String False

Accepts multiple inputs. The Workday ID of the worker associated with the billable transaction. To get a valid ID, call GET /workers in the Staffing service.

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