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