CData Python Connector for Workday

Build 25.0.9454

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

The display name of the instance

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 original hours to bill the customer. Note: This field returns a value if it has any billing recommendation; even Do Not Bill.

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

The display name of the instance

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

The display name of the instance

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

The display name of the instance

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

The display name of the instance

ExpenseDescriptor_Descriptor String False

The display name of the instance

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 hours available to bill for the billable transaction. Note: This field returns a value if it has any billing recommendation; even Do Not Bill.

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

The display name of the instance

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

The display name of the instance

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

The display name of the instance

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

The display name of the instance

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

The display name of the instance

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

The display name of the instance

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

The display name of the instance

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.9454