Ratetableexpenseentry
Defines rate-based expense entries, linking employee expense transactions with currency or rate adjustments.
Table Specific Information
To retrieve information from the Ratetable 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 rate table expense entry record. |
| Lineno | Long | True |
Unique identifier for a specific line item in the rate table expense entry. |
| Ratetablekey | Long | True |
Reference key for the associated rate table. |
| Ratetableid | String | False |
Identifier for the associated rate table. |
| Ratetablename | String | False |
Name of the associated rate table. |
| Description | String | False |
Details or notes about the rate table expense entry. |
| Whencreated | Datetime | True |
Timestamp indicating when the entry was created. |
| Whenmodified | Datetime | True |
Timestamp indicating the last modification to the entry. |
| Createdby | Long | True |
Identifier of the user who created the entry. |
| Modifiedby | Long | True |
Identifier of the user who last modified the entry. |
| Standardtaskid | String | False |
Identifier for the standard cost code linked to this entry. |
| Standardtaskkey | Long | True |
Reference key for the standard cost code linked to this entry. |
| Standardtaskname | String | False |
Name of the standard cost code linked to this entry. |
| Standardcosttypeid | String | False |
Identifier for the standard cost type associated with this entry. |
| Standardcosttypekey | Long | True |
Reference key for the standard cost type associated with this entry. |
| Standardcosttypename | String | False |
Name of the standard cost type associated with this entry. |
| Accumulationtypekey | Long | True |
Reference key for the accumulation type linked to this entry. |
| Accumulationtypename | String | False |
Name of the accumulation type linked to this entry. |
| Locationkey | Long | True |
Reference key for the location linked to this entry. |
| Location | String | False |
Details of the location linked to this entry. |
| Locationname | String | False |
Name of the location linked to this entry. |
| Departmentkey | Long | True |
Reference key for the department linked to this entry. |
| Department | String | False |
Details of the department linked to this entry. |
| Departmenttitle | String | False |
Title of the department linked to this entry. |
| Startdate | Date | False |
Start date for the expense entry. |
| Markuppct | Decimal | False |
Markup percentage applied to the expense entry. |
| Projectdimkey | Long | False |
Reference key for the associated project dimension. |
| Projectid | String | False |
Identifier for the associated project or job. |
| Projectname | String | False |
Name of the associated project or job. |
| Customerdimkey | Long | False |
Reference key for the associated customer dimension. |
| Customerid | String | False |
Identifier for the associated customer. |
| Customername | String | False |
Name of the associated customer. |
| Vendordimkey | Long | False |
Reference key for the associated vendor dimension. |
| Vendorid | String | False |
Identifier for the associated vendor. |
| Vendorname | String | False |
Name of the associated vendor. |
| Employeedimkey | Long | False |
Reference key for the associated employee dimension. |
| Employeeid | String | False |
Identifier for the associated employee. |
| Employeename | String | False |
Name of the associated employee. |
| Itemdimkey | Long | False |
Reference key for the associated item dimension. |
| Itemid | String | False |
Identifier for the associated item. |
| Itemname | String | False |
Name of the associated item. |
| Taskdimkey | Long | False |
Reference key for the associated task dimension. |
| Taskid | String | False |
Identifier for the associated cost code. |
| Taskname | String | False |
Name of the associated cost code. |
| Costtypedimkey | Long | False |
Reference key for the associated cost type dimension. |
| Costtypeid | String | False |
Identifier for the associated cost type. |
| Costtypename | String | False |
Name of the associated cost type. |
| Record_url | String | True |
User-independent, deep-link URL for accessing the entry record. |