Each table below lists its columns, whether a value is required, a description, and the table it relates to. For the terms used in these tables (tools, materials, assets, unique, and quantity), see Conventions in the Reporting Cloud Articles in the ToolWatch Reporting Cloud Overview.
Categories
Column | Required | Description | Relates to |
CategoryId | Yes | The unique ID of this Category | - |
Number | Yes | A shorthand string used to refer to this Category | - |
Type | Yes | 'T' for tools, 'M' for materials, 'A' for templates | - |
Description | Yes | A brief phrase describing this Category | - |
IsDeleted | Yes | Indicates if this record has been deleted | - |
Classes
Column | Required | Description | Relates to |
ClassId | Yes | - | - |
Number | Yes | A shorthand string used to refer to this class | - |
Description | Yes | A brief phrase describing this class | - |
IsDeleted | Yes | Indicates if this record has been deleted | - |
Custom Fields
Column | Required | Description | Relates to |
customFieldId | Yes | - | - |
customFieldDefinitionId | Yes | The unique ID of this custom field | - |
parentId | Yes | The unique ID of the parent row | The row that this custom field is associated with |
fieldValue | No | The value recorded in the custom field for the parent row | - |
fieldDescription | Yes | - | - |
fieldLabel | Yes | - | - |
isRequired | Yes | Indicates if this custom field is required | - |
dataTypeId | Yes | The data type of the custom field | Data Types currently only supports a value of 1 for string type |
fieldName | Yes | The name of the custom field | - |
tableName | Yes | The name of the table that the custom field is associated with | - Currently only supports: CostCenters, Employees, Locations, Vendors, Item Details |
customFieldTableId | Yes | The unique ID of the custom field table | - 1 to 5 for the tables listed in tableName |
createdById | Yes | The unique ID of the user that created the custom field | - |
createdBy | Yes | The name of the user that created the custom field | - |
createdOn | Yes | The date and time that the custom field was created | - |
modifiedById | Yes | The unique ID of the user that last modified the custom field | - |
modifiedBy | Yes | The name of the user that last modified the custom field | - |
modifiedOn | Yes | The date and time that the custom field was last modified | - |
Departments
Column | Required | Description | Relates to |
DepartmentId | Yes | The unique ID of this department | - |
Number | Yes | A shorthand string used to refer to this department | - |
Description | Yes | A brief phrase describing this department | - |
SupervisorEntityId | No | The entity responsible for supervising this department | Entities |
IsDeleted | Yes | Indicates if this record has been deleted | - |
Descriptions
Column | Required | Description | Relates to |
DescriptionId | Yes | The unique ID of this unit of description | - |
Type | Yes | 'T' for unique tools, 'Q' for quantity tools, 'M' for materials. Other Types may be exposed in the future. | - |
Description | Yes | A brief phrase describing this description | - |
Manufacturers
Column | Required | Description | Relates to |
ManufacturerId | Yes | The unique ID of this manufacturer | - |
Number | Yes | A shorthand string used to refer to this manufacturer | - |
Description | Yes | A brief phrase describing this manufacturer (typically the name of the manufacturer) | - |
IsDeleted | Yes | Indicates if this record has been deleted | - |
StatusCodes
Status codes are one of the six attributes that are used to describe all assets (see InventoryKeys). They can be effectively used to distinguish between two groups of otherwise similar assets, such as New and Used. Status codes also are used to cause some assets to be treated differently. For example, if a status code has IsTransferProhibited set, then any asset given that status won't be able to change assignment.
Column | Required | Description | Relates to |
StatusCodeId | Yes | The unique ID of this status code | - |
Number | Yes | A shorthand string used to refer to this status code (e.g. BK) | - |
Description | Yes | A brief phrase describing this status code (e.g. Broken) | - |
IsTransferProhibited | Yes | If set then the user will be prevented from adding the associated asset to a transfer | - |
IsDeleted | Yes | Indicates if this record has been deleted | - |
Tasks
Column | Required | Description | Relates to |
TaskId | Yes | - | - |
Subject | Yes | - | - |
LocationId | No | - | - |
OtherLocation | Yes | - | - |
AssignedToId | No | - | - |
DueBy | No | - | - |
Notes | Yes | - | - |
CreatedById | Yes | The user that created the record. | Entities |
CreatedOn | Yes | When the record was created. | - |
ModifiedById | Yes | The user that last modified the record. | Entities |
ModifiedOn | Yes | When the record was last modified. | - |
Deleted | Yes | - | - |
IsCompleted | Yes | - | - |
CategoryId | No | - | - |
StatusId | No | - | - |
PriorityId | No | - | - |
CategoryNumber | Yes | - | - |
CategoryDescription | Yes | - | - |
PriorityNumber | Yes | - | - |
PriorityDescription | Yes | - | - |
StatusNumber | Yes | - | - |
StatusDescription | Yes | - | - |
AssignedToFirstName | Yes | - | - |
AssignedToLastName | Yes | - | - |
AssignedToDescription | Yes | - | - |
CreatedByFirstName | Yes | - | - |
CreatedByLastName | Yes | - | - |
CreatedByDescription | Yes | - | - |
LocationDescription | Yes | - | - |
ModifiedByFirstName | Yes | - | - |
ModifiedByLastName | Yes | - | - |
ModifiedByDescription | Yes | - | - |
UnitsOfMeasure
Column | Required | Description | Relates to |
UnitOfMeasureId | Yes | The unique ID of this unit of measure | - |
Number | Yes | A shorthand string used to refer to this unit (e.g. 'ft', 'lb') | - |
Description | Yes | A brief phrase describing this unit (e.g. 'feet', 'pounds') | - |