Ratetableexpenseentry
Retrieves Ratetableexpenseentry report data.
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.
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 cost code ID |
| Standardtaskkey | Long | True |
Standard cost code key |
| Standardtaskname | String | False |
Standard cost code 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 |
| 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 |
| Projectdimkey | Long | False |
Projectdimkey |
| Projectid | String | False |
Job |
| Projectname | String | False |
Job 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 |
| Taskdimkey | Long | False |
Taskdimkey |
| Taskid | String | False |
Cost Code |
| Taskname | String | False |
Cost Code name |
| Costtypedimkey | Long | False |
Costtypedimkey |
| Costtypeid | String | False |
Cost type |
| Costtypename | String | False |
Cost type name |
| Record_url | String | True |
A portable, user-independent, deep-link URL for viewing this record |