Ratetabletsentry
Retrieves Ratetabletsentry report data.
Table Specific Information
To retrieve information from the Ratetabletsentry table, Sage Intacct needs to have the Construction subscription enabled and the EnableSubscriptions connection property set.
Columns
| Name | Type | ReadOnly | Description |
| Recordno [KEY] | Long | True |
Record number |
| Lineno | Long | True |
Line number |
| Ratetablekey | Long | True |
Rate table key |
| Ratetableid | String | False |
Rate table ID |
| Ratetablename | String | False |
Rate table name |
| Description | String | False |
Description |
| Whencreated | Datetime | True |
Timestamp marking last time this was created. |
| Whenmodified | Datetime | True |
Timestamp marking last time this was changed. |
| Createdby | Long | True |
User who created this. |
| Modifiedby | Long | True |
User who modified this. |
| Standardtaskid | String | False |
Standard task ID |
| Standardtaskkey | Long | True |
Standard task key |
| Standardtaskname | String | False |
Standard task name |
| Standardcosttypeid | String | False |
Standard cost type ID |
| Standardcosttypekey | Long | True |
Standard cost type key |
| Standardcosttypename | String | False |
Standard cost type name |
| Accumulationtypekey | Long | True |
Accumulation type key |
| Accumulationtypename | String | False |
Accumulation type name |
| Emppositionkey | Long | True |
Employee position key |
| Emppositionid | String | False |
Employee position ID |
| Emppositionname | String | False |
Employee position name |
| Timetypekey | Long | True |
Time type key |
| Timetypename | String | False |
Time type name |
| Laborclasskey | Long | True |
Labor class key |
| Laborclassid | String | False |
Labor class ID |
| Laborclassname | String | False |
Labor class name |
| Laborshiftkey | Long | True |
Labor shift key |
| Laborshiftid | String | False |
Labor shift ID |
| Laborshiftname | String | False |
Labor shift name |
| Laborunionkey | Long | True |
Labor union key |
| Laborunionid | String | False |
Labor union ID |
| Laborunionname | String | False |
Labor union name |
| Locationkey | Long | True |
Location key |
| Location | String | False |
Location |
| Locationname | String | False |
Location name |
| Departmentkey | Long | True |
Department key |
| Department | String | False |
Department |
| Departmenttitle | String | False |
Department title |
| Startdate | Date | False |
Start date |
| Markuppct | Decimal | False |
Markup percent |
| Laborrate | Decimal | False |
Labor rate |
| Projectdimkey | Long | False |
Projectdimkey |
| Projectid | String | False |
Project |
| Projectname | String | False |
Project name |
| Customerdimkey | Long | False |
Customerdimkey |
| Customerid | String | False |
Customer |
| Customername | String | False |
Customer name |
| Vendordimkey | Long | False |
Vendordimkey |
| Vendorid | String | False |
Vendor |
| Vendorname | String | False |
Vendor name |
| Employeedimkey | Long | False |
Employeedimkey |
| Employeeid | String | False |
Employee |
| Employeename | String | False |
Employee name |
| Itemdimkey | Long | False |
Itemdimkey |
| Itemid | String | False |
Item |
| Itemname | String | False |
Item name |
| Classdimkey | Long | False |
Classdimkey |
| Classid | String | False |
Class |
| Classname | String | False |
Class name |
| Record_url | String | True |
A portable, user-independent, deep-link URL for viewing this record |