Ratetableccentry
Houses rate table entries tailored to credit card transactions, including rate details and related purchase data.
Table Specific Information
To retrieve information from the Ratetableccentry 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 credit card entry record. |
| Lineno | Long | True |
Identifier for a specific line item within the rate table credit card 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 |
Additional details or notes about the entry. |
| Whencreated | Datetime | True |
Timestamp indicating when the entry was created. |
| Whenmodified | Datetime | True |
Timestamp indicating the last modification of the entry. |
| 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 associated standard cost code. |
| Standardtaskkey | Long | True |
Reference key for the associated standard cost code. |
| Standardtaskname | String | False |
Name of the associated standard cost code. |
| Standardcosttypeid | String | False |
Identifier for the associated standard cost type. |
| Standardcosttypekey | Long | True |
Reference key for the associated standard cost type. |
| Standardcosttypename | String | False |
Name of the associated standard cost type. |
| Accumulationtypekey | Long | True |
Reference key for the accumulation type. |
| Accumulationtypename | String | False |
Name of the accumulation type. |
| Locationkey | Long | True |
Reference key for the associated location. |
| Location | String | False |
Details of the associated location. |
| Locationname | String | False |
Name of the associated location. |
| Departmentkey | Long | True |
Reference key for the associated department. |
| Department | String | False |
Details of the associated department. |
| Departmenttitle | String | False |
Title of the associated department. |
| Startdate | Date | False |
Start date for the entry. |
| Markuppct | Decimal | False |
Percentage markup applied to the 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 record. |