Ratetableglentry
Captures GL-based rate table entries, incorporating currency conversions and relevant ledger references.
Table Specific Information
To retrieve information from the Ratetableglentry 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 GL entry record. |
| Lineno | Long | True |
Unique identifier for the line entry within the rate table GL 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 GL entry. |
| Whencreated | Datetime | True |
Timestamp indicating when the entry was created. |
| Whenmodified | Datetime | True |
Timestamp indicating when the entry was last modified. |
| Createdby | Long | True |
Identifier for the user who created the entry. |
| Modifiedby | Long | True |
Identifier for 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 general ledger entry. |
| Markuppct | Decimal | False |
Markup percentage applied to the general ledger 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. |