Ratetable
Serves as the master reference for rate tables, maintaining data on various rates used in financial transactions.
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 record. |
| Ratetableid | String | False |
The unique identifier for the rate table. |
| Name | String | False |
The name of the rate table. |
| Description | String | False |
Details or additional information about the rate table. |
| Status | String | False |
Indicates whether the rate table is active or inactive. |
| Whencreated | Datetime | True |
Timestamp indicating when the rate table was created. |
| Whenmodified | Datetime | True |
Timestamp indicating the last modification to the rate table. |
| Createdby | Long | True |
Identifier for the user who created the rate table. |
| Modifiedby | Long | True |
Identifier for the user who last modified the rate table. |
| Megaentitykey | Long | True |
Key representing the entity where the rate table was created. |
| Megaentityid | String | True |
Identifier for the entity where the rate table was created. |
| Megaentityname | String | True |
Name of the entity where the rate table was created. |
| Record_url | String | True |
A user-independent, deep-link URL for viewing this rate table record. |