Ratetablepoentry
Compiles PO-specific rate table entries, ensuring accurate currency conversions for purchase order 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 record. |
| Lineno | Long | True |
Unique line number within the record. |
| Ratetablekey | Long | True |
Reference key for the associated rate table. |
| Ratetableid | String | False |
Unique identifier for the rate table. |
| Ratetablename | String | False |
Name of the associated rate table. |
| Description | String | False |
Detailed description or notes for the record. |
| Whencreated | Datetime | True |
Timestamp indicating when the record was created. |
| Whenmodified | Datetime | True |
Timestamp of the last modification to the record. |
| Createdby | Long | True |
Identifier for the user who created the record. |
| Modifiedby | Long | True |
Identifier for the user who last modified the record. |
| Standardtaskid | String | False |
Unique identifier for the standard cost code. |
| Standardtaskkey | Long | True |
Reference key for the standard cost code. |
| Standardtaskname | String | False |
Name of the standard cost code. |
| Standardcosttypeid | String | False |
Unique identifier for the standard cost type. |
| Standardcosttypekey | Long | True |
Reference key for the standard cost type. |
| Standardcosttypename | String | False |
Name of the standard cost type. |
| Accumulationtypekey | Long | True |
Reference key for the accumulation type. |
| Accumulationtypename | String | False |
Name of the accumulation type. |
| Itemdimkey | Long | True |
Reference key for the associated item dimension. |
| Itemid | String | False |
Unique identifier for the item. |
| Itemname | String | False |
Name of the associated item. |
| Locationkey | Long | True |
Reference key for the associated location. |
| Location | String | False |
Unique identifier for the location. |
| Locationname | String | False |
Name of the associated location. |
| Startdate | Date | False |
The date when the associated task or project starts. |
| Markuppct | Decimal | False |
The percentage markup applied to the associated item or service. |
| Unitprice | Decimal | False |
The price per unit of the associated item or service. |
| Projectdimkey | Long | False |
The reference key for the associated project dimension. |
| Projectid | String | False |
The unique identifier for the associated project. |
| Projectname | String | False |
The name of the associated project. |
| Customerdimkey | Long | False |
The reference key for the associated customer dimension. |
| Customerid | String | False |
The unique identifier for the associated customer. |
| Customername | String | False |
The name of the associated customer. |
| Vendordimkey | Long | False |
The reference key for the associated vendor dimension. |
| Vendorid | String | False |
The unique identifier for the associated vendor. |
| Vendorname | String | False |
The name of the associated vendor. |
| Employeedimkey | Long | False |
The reference key for the associated employee dimension. |
| Employeeid | String | False |
The unique identifier for the associated employee. |
| Employeename | String | False |
The name of the associated employee. |
| Taskdimkey | Long | False |
The reference key for the associated task dimension. |
| Taskid | String | False |
The unique identifier for the associated cost code. |
| Taskname | String | False |
The name of the associated cost code. |
| Costtypedimkey | Long | False |
The reference key for the associated cost type dimension. |
| Costtypeid | String | False |
The unique identifier for the associated cost type. |
| Costtypename | String | False |
The name of the associated cost type. |
| Record_url | String | True |
A user-independent, deep-link URL for viewing the record. |