Ratetabletsentry
Manages timesheet-related rate table entries, ensuring accurate currency conversions and cost calculations for project time tracking.
Table Specific Information
To retrieve information from the Ratetabletsentry table, Sage Intacct needs to have the Construction subscription enabled and the EnableSubscriptions connection property set to one or more subscription names.
- If the connection property is not set, the table is not visible in the metadata for users.
- If the connection property is set, you can run simple SELECT * queries.
Columns
| Name | Type | ReadOnly | Description |
| Recordno [KEY] | Long | True |
Unique identifier for the timesheet entry record. |
| Lineno | Long | True |
Unique line number within the timesheet entry record. |
| Ratetablekey | Long | True |
Reference key for the associated rate table. |
| Ratetableid | String | False |
Unique identifier for the associated rate table. |
| Ratetablename | String | False |
Name of the associated rate table. |
| Description | String | False |
Detailed description or notes about the timesheet entry. |
| Whencreated | Datetime | True |
Timestamp indicating when the timesheet entry was created. |
| Whenmodified | Datetime | True |
Timestamp of the last modification to the timesheet entry. |
| Createdby | Long | True |
Identifier for the user who created the timesheet entry. |
| Modifiedby | Long | True |
Identifier for the user who last modified the timesheet entry. |
| Standardtaskid | String | False |
Unique identifier for the standard task associated with this entry. |
| Standardtaskkey | Long | True |
Reference key for the standard task associated with this entry. |
| Standardtaskname | String | False |
Name of the standard task associated with this entry. |
| Standardcosttypeid | String | False |
Unique identifier for the standard cost type. |
| Standardcosttypekey | Long | True |
Reference key for the standard cost type. |
| Standardcosttypename | String | False |
Name of the standard cost type. |
| Accumulationtypekey | Long | True |
Reference key for the accumulation type associated with this entry. |
| Accumulationtypename | String | False |
Name of the accumulation type associated with this entry. |
| Emppositionkey | Long | True |
Reference key for the employee position. |
| Emppositionid | String | False |
Unique identifier for the employee position. |
| Emppositionname | String | False |
Name of the employee position. |
| Timetypekey | Long | True |
Reference key for the time type associated with this entry. |
| Timetypename | String | False |
Name of the time type associated with this entry. |
| Laborclasskey | Long | True |
Reference key for the associated labor class. |
| Laborclassid | String | False |
Unique identifier for the labor class. |
| Laborclassname | String | False |
Name of the associated labor class. |
| Laborshiftkey | Long | True |
Reference key for the associated labor shift. |
| Laborshiftid | String | False |
Unique identifier for the labor shift. |
| Laborshiftname | String | False |
Name of the associated labor shift. |
| Laborunionkey | Long | True |
Reference key for the associated labor union. |
| Laborunionid | String | False |
Unique identifier for the labor union. |
| Laborunionname | String | False |
Name of the associated labor union. |
| Locationkey | Long | True |
Reference key for the associated location. |
| Location | String | False |
Unique identifier for the location. |
| Locationname | String | False |
Name of the associated location. |
| Departmentkey | Long | True |
Reference key for the associated department. |
| Department | String | False |
Unique identifier for the department. |
| Departmenttitle | String | False |
Title or name of the associated department. |
| Startdate | Date | False |
The date when the associated task or project starts. |
| Markuppct | Decimal | False |
The percentage markup applied to the associated item or service. |
| Laborrate | Decimal | False |
The hourly rate for labor associated with the task or project. |
| Projectdimkey | Long | False |
Reference key for the associated project dimension. |
| Projectid | String | False |
Unique identifier for the project. |
| Projectname | String | False |
Name of the associated project. |
| Customerdimkey | Long | False |
Reference key for the associated customer dimension. |
| Customerid | String | False |
Unique identifier for the customer. |
| Customername | String | False |
Name of the associated customer. |
| Vendordimkey | Long | False |
Reference key for the associated vendor dimension. |
| Vendorid | String | False |
Unique identifier for the vendor. |
| Vendorname | String | False |
Name of the associated vendor. |
| Employeedimkey | Long | False |
Reference key for the associated employee dimension. |
| Employeeid | String | False |
Unique identifier for the employee. |
| Employeename | String | False |
Name of the associated employee. |
| Itemdimkey | Long | False |
Reference key for the associated item dimension. |
| Itemid | String | False |
Unique identifier for the item. |
| Itemname | String | False |
Name of the associated item. |
| Classdimkey | Long | False |
Reference key for the associated class dimension. |
| Classid | String | False |
Unique identifier for the class. |
| Classname | String | False |
Name of the associated class. |
| Record_url | String | True |
A user-independent, deep-link URL for viewing the record. |