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