Power BI Connector for Sage Intacct

Build 26.0.9770

Workorder

Generated schema file.

Columns

Name Type ReadOnly Description
Recordno [KEY] Long False

A unique identifier for the work order record.

Workorderid String False

The work order ID.

Name String False

The name of this work order.

Description String False

The description of this work order.

Workordertypekey Long False

The system-assigned key of the work order type associated with this work order.

Workordertype String False

The work order type associated with this work order.

Workordercalltypekey Long False

The system-assigned key of the call type associated with this work order.

Workordercalltype String False

The call type associated with this work order.

Workorderproblemcodekey Long False

The system-assigned key of the problem code associated with this work order.

Workorderproblemcode String False

The problem code associated with this work order.

Workorderstatekey Long False

The system-assigned key of the work order state associated with this work order.

Workorderstate String False

The work order state associated with this work order.

Customerkey Long False

The system-assigned key of the customer associated with this work order.

Customerid String False

The Id of the customer associated with this work order.

Customername String False

The name of the customer associated with this work order.

Employeekey Long False

The system-assigned key of the employee associated with this work order.

Employeeid String False

The Id of the employee associated with this work order.

Employeename String False

The name of the employee associated with this work order.

Workorderdate Date False

The date on which this work order was created or issued.

Closeddate Date False

The date on which this work order was closed.

Status String False

Active or inactive

Projectkey Long False

The system-assigned key of the project associated with this work order.

Projectid String False

The Id of the project associated with this work order.

Projectname String False

The name of the project associated with this work order.

Locationkey Long False

The system-assigned key of the location associated with this work order.

Locationid String False

The Id of the location associated with this work order.

Locationname String False

The name of the location associated with this work order.

Deptkey Long False

The system-assigned key of the department associated with this work order.

Departmentid String False

The Id of the department associated with this work order.

Departmentname String False

The name of the department associated with this work order.

Workordernumber String False

The work order number.

Workorderurl String False

The URL of this work order.

Servicesite String False

The service site location for this work order.

Agreementno String False

The agreement number associated with this work order.

Agreementseq String False

The agreement sequence associated with this work order.

Salespersonkey Long False

The system-assigned key of the salesperson associated with this work order.

Salespersonid String False

The Id of the salesperson associated with this work order.

Salespersonname String False

The name of the salesperson associated with this work order.

Altwono String False

The alternate work order number.

Altworkorderno2 String False

The second alternate work order number.

Autogenerated Bool False

Indicates whether this work order was automatically generated.

Customerpo String False

The customer purchase order number associated with this work order.

Externalbillable Bool False

Indicates whether this work order is billable to the customer.

Extestimatedhours Decimal False

The estimated hours for this work order as recorded in the external system.

Extactualhours Decimal False

The actual hours worked on this work order as recorded in the external system.

Extestimatedcost Decimal False

The estimated cost for this work order as recorded in the external system.

Extactualcost Decimal False

The actual cost incurred on this work order as recorded in the external system.

Extnottoexceed Decimal False

The maximum allowable cost for this work order as defined in the external system.

Extwoamount Decimal False

The total work order amount as recorded in the external system.

Extamountbilled Decimal False

The total billed amount for this work order as recorded in the external system.

Entitykey Long False

The system-assigned key of the entity associated with this work order.

Entityid String False

The Id of the entity associated with this work order.

Entityname String False

The name of the entity associated with this work order.

Whencreated Datetime True

Timestamp marking last time this was created.

Whenmodified Datetime True

Timestamp marking last time this was changed.

Createdby Long True

User who created this.

Modifiedby Long True

User who modified this.

Classid String False

The Id of the class associated with this work order.

Classname String False

The name of the class associated with this work order.

Classkey Long False

The system-assigned key of the class associated with this work order.

Complete Bool False

Indicates whether this work order is complete.

Createdbyloginid String True

Created by user ID

Modifiedbyloginid String True

Modified by user ID

Megaentitykey Long True

The system-assigned key of the mega entity associated with this work order.

Megaentityid String True

The Id of the mega entity associated with this work order.

Megaentityname String True

The name of the mega entity associated with this work order.

Record_url String True

A portable, user-independent, deep-link URL for viewing this record

Project_recordno Long False

Foreign key for related object: PROJECT

Customer_recordno Long False

Foreign key for related object: CUSTOMER

Employee_recordno Long False

Foreign key for related object: EMPLOYEE

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770