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