ODBC Driver for Workday

Build 25.0.9434

BillableTransactions

Contains detailed records of billable transactions. This table captures information such as transaction amounts, associated accounts, billing periods, and customer details for financial processing and revenue tracking.

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

The unique identifier (Id) for the billable transaction instance. This Id ensures that each transaction is distinctly tracked and associated with the correct billing process.

AdjustmentCount Decimal False

The total count of billing rate applications for this billable transaction. This count reflects the number of times the transaction has been adjusted due to rate modifications or other billing updates.

AdjustmentReason_Descriptor String False

A human-readable summary of the reason for the adjustment applied to the billable transaction. This summary provides context on why the adjustment was necessary, such as corrections or rate changes.

AdjustmentReason_Href String False

A direct link to the adjustment reason instance. This link provides programmatic access to retrieve details about the reason for the adjustment.

AdjustmentReason_Id String False

The unique Id for the adjustment reason associated with this billable transaction. This Id ensures proper tracking of billing changes and their justifications.

AmountToBill_Currency String False

The currency type for the amount to be billed for this billable transaction. This value specifies the currency in which the customer is invoiced, excluding applicable taxes.

AmountToBill_Value Decimal False

The total amount to be billed for this billable transaction. This value reflects the charge before taxes and adjustments are applied.

BillableAmount_Currency String False

The currency type for the original amount to be billed to the customer. This value ensures that billing transactions are accurately represented in the correct monetary unit.

BillableAmount_Value Decimal False

The original amount to be billed to the customer before adjustments or tax-only invoices are applied. This value represents the base charge for the transaction.

BillableHours Decimal False

The total number of hours originally designated as billable for this transaction. This value reflects the time worked before adjustments or approvals.

BillableRate_Currency String False

The currency type for the billable rate applied to this transaction. This value ensures that billing rates are properly recorded in the correct monetary unit.

BillableRate_Value Decimal False

The original rate applied for the billable transaction before adjustments. This value represents the agreed-upon rate per hour or unit of service.

BillingStatus_Descriptor String False

A human-readable summary of the billing status for this transaction. This summary provides insight into whether the transaction is pending, billed, or requires further processing.

BillingStatus_Href String False

A direct link to the billing status instance. This link provides programmatic access to retrieve additional details about the current billing status.

BillingStatus_Id String False

The unique Id for the billing status associated with this transaction. This Id ensures accurate tracking of billing progress and updates.

Category_Descriptor String False

A human-readable summary of the category assigned to this billable transaction. This summary classifies the transaction based on its type, such as labor, expenses, or service fees.

Category_Href String False

A direct link to the category instance associated with this billable transaction. This link provides programmatic access to retrieve category-specific details.

Category_Id String False

The unique Id for the category assigned to this billable transaction. This Id ensures proper classification for billing and reporting purposes.

Customer_Descriptor String False

A human-readable summary of the customer associated with this billable transaction. This summary identifies the client or entity responsible for payment.

Customer_Href String False

A direct link to the customer instance associated with this billable transaction. This link provides programmatic access to retrieve customer-specific details.

Customer_Id String False

The unique Id for the customer associated with this billable transaction. This Id ensures accurate assignment of transactions to the appropriate client.

Descriptor String False

A human-readable summary of the billable transaction instance. This summary provides a quick reference to identify key details about the transaction.

ExpenseDescriptor_Descriptor String False

A human-readable summary of the expense associated with this billable transaction. This summary provides context on reimbursable or chargeable expenses.

ExpenseDescriptor_Href String False

A direct link to the expense descriptor instance. This link provides programmatic access to retrieve additional details about the associated expense.

ExpenseDescriptor_Id String False

The unique Id for the expense descriptor linked to this billable transaction. This Id ensures that expenses are accurately recorded and assigned.

HoursToBill Decimal False

The actual number of hours available for billing in this transaction. This value represents the billable hours after adjustments or exclusions.

Href String False

A direct link to the billable transaction instance. This link provides programmatic access to retrieve details about the specific transaction.

InvoiceDescription String False

A detailed description of the supplier invoice line item, expense report line item, or usage-based transaction. This description provides clarity for invoicing and reporting purposes.

Memo String False

The memo associated with this project billable transaction. This note may include additional details or context about the transaction.

PreviouslyInvoiced Bool False

Indicates whether the billable transaction has been previously invoiced. A value of 'true' signifies that the transaction has already been included in an invoice.

ProjectRole_Descriptor String False

A human-readable summary of the project role associated with this billable transaction. This summary provides context on the role or responsibility linked to the transaction.

ProjectRole_Href String False

A direct link to the project role instance. This link provides programmatic access to retrieve details about the role involved in the transaction.

ProjectRole_Id String False

The unique Id for the project role linked to this billable transaction. This Id ensures that labor costs are correctly assigned based on the worker’s role.

ProjectTask_Descriptor String False

A human-readable summary of the project task associated with the billable transaction. This summary provides insight into the specific task that incurred the billable cost.

ProjectTask_Href String False

A direct link to the project task instance. This link provides programmatic access to retrieve additional details about the task.

ProjectTask_Id String False

The unique Id for the project task associated with the billable transaction. This Id ensures that labor or expenses are correctly assigned to the appropriate task within the project.

Project_Descriptor String False

A human-readable summary of the project associated with the billable transaction. This summary helps identify the overarching project to which the transaction belongs.

Project_Href String False

A direct link to the project instance. This link provides programmatic access to retrieve additional details about the project.

Project_Id String False

The unique Id for the project associated with the billable transaction. This Id ensures that the transaction is correctly linked to the appropriate project.

RateToBill_Currency String False

The currency type for the actual rate at which the billable transaction is billed. This value ensures the rate is accurately recorded in the correct monetary unit.

RateToBill_Value Decimal False

The actual rate that is applied for billing the transaction. This value represents the agreed-upon charge per unit of service or labor.

ReasonForChange String False

The reason for the rate change applied to the billable transaction. This explanation helps track adjustments due to contract modifications, approvals, or billing corrections.

ResourceProvider_Descriptor String False

A human-readable summary of the resource provider associated with the billable transaction. This summary identifies the entity responsible for supplying the resource or service.

ResourceProvider_Href String False

A direct link to the resource provider instance. This link provides programmatic access to retrieve additional details about the resource provider.

ResourceProvider_Id String False

The unique Id for the resource provider associated with the billable transaction. This Id ensures that the correct provider is attributed to the transaction.

RevenueStatus_Descriptor String False

A human-readable summary of the revenue status of the billable transaction. This summary indicates whether the revenue has been recognized, deferred, or is in another status.

RevenueStatus_Href String False

A direct link to the revenue status instance. This link provides programmatic access to retrieve additional details about the revenue recognition status.

RevenueStatus_Id String False

The unique Id for the revenue status associated with the billable transaction. This Id ensures accurate tracking of revenue recognition for billing purposes.

TransactionDate Datetime False

The date on which the billable transaction occurred. This date is used for financial tracking, reporting, and reconciliation purposes.

TransactionSource_Descriptor String False

A human-readable summary of the transaction source for the billable transaction. This summary indicates the origin of the transaction, such as time entry, expense, or adjustment.

TransactionSource_Href String False

A direct link to the transaction source instance. This link provides programmatic access to retrieve additional details about the transaction source.

TransactionSource_Id String False

The unique Id for the transaction source associated with the billable transaction. This Id ensures accurate attribution of transactions to their respective sources.

Worker_Descriptor String False

A human-readable summary of the worker associated with the billable transaction. This summary helps identify the individual responsible for the work or service being billed.

Worker_Href String False

A direct link to the worker instance. This link provides programmatic access to retrieve additional details about the worker involved in the transaction.

Worker_Id String False

The unique Id for the worker associated with the billable transaction. This Id ensures that labor costs are accurately attributed to the correct employee.

ZeroAmountToBill Bool False

Indicates whether the billable transaction has a zero rate. A value of 'true' signifies that no charge is applied for this transaction.

BillingStatus_Prompt String False

Filters the billable transactions by status. This field requires the Workday Id of the billing status. Multiple status query parameters can be specified to refine the results.

Customer_Prompt String False

Filters the billable transactions by customer. This field requires the Workday Id of the customer associated with the project for the billable transaction. To retrieve a valid Id, call GET /customers in the Customer Accounts REST service.

FromDate_Prompt Date False

Filters the billable transactions to include only those with a transaction date on or after the specified date. This filter uses the YYYY-MM-DD format to define the starting range.

Phase_Prompt String False

Filters the billable transactions by project phase. This field requires the Workday Id of the project phase associated with the billable transaction for the time entry. To retrieve a valid Id, call GET /planPhases in the Projects REST service.

Project_Prompt String False

Filters the billable transactions by project. This field requires the Workday Id of the project associated with the billable transactions. To retrieve a valid Id, call GET /projects in the Projects REST service.

SpendCategory_Prompt String False

Filters the billable transactions by spend category. This field requires the Workday Id of the spend category associated with the billable transaction related to the expense report line.

Task_Prompt String False

Filters the billable transactions by project task. This field requires the Workday Id of the project task associated with the billable transaction for the time entry. To retrieve a valid Id, call GET /planTasks in the Projects REST service.

TimeCode_Prompt String False

Filters the billable transactions by time code. This field requires the Workday Id of the time code associated with the billable transaction for the time entry.

ToDate_Prompt Date False

Filters the billable transactions to include only those with a transaction date on or before the specified date. This filter uses the YYYY-MM-DD format to define the ending range.

TransactionSource_Prompt String False

Filters the billable transactions by transaction source. This field requires the Workday Id of the transaction source to refine the results.

Worker_Prompt String False

Filters the billable transactions by worker. This field requires the Workday Id of the worker associated with the billable transaction. To retrieve a valid Id, call GET /workers in the Staffing service.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434