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.
CountTicketCounted
Column | Required | Description | Relates to |
countTicketCountedId | Yes | - | - |
countTicketId | Yes | - | - |
inventoryKeyId | Yes | - | - |
countedById | Yes | - | - |
countedOn | Yes | - | - |
CountTicketLines
Column | Required | Description | Relates to |
countTicketLineId | Yes | - | - |
countTicketId | Yes | - | - |
inventoryKeyId | Yes | - | - |
expectedCount | No | - | - |
count | Yes | - | - |
countedOn | Yes | - | - |
countedById | Yes | - | - |
note | Yes | - | - |
countVariance | No | - | - |
CountTickets
Column | Required | Description | Relates to |
countTicketId | Yes | - | - |
locationId | Yes | - | - |
summary | Yes | - | - |
number | Yes | - | - |
createdOn | Yes | When the record was created. | - |
countTicketStatusId | Yes | - | - |
deleted | Yes | - | - |
closedOn | Yes | - | - |
sourceId | No | - | - |
stockpointId | No | - | - |
createdById | No | The user that created the record. | Entities |
modifiedById | No | The user that last modified the record. | Entities |
modifiedOn | No | When the record was last modified. | - |
CountTicketToCount
Column | Required | Description | Relates to |
countTicketToCountId | Yes | - | - |
countTicketId | Yes | - | - |
inventoryKeyId | Yes | - | - |
rowguid | Yes | - | - |
IsVerified | No | - | - |
VerifiedById | No | - | - |
VerifyDate | No | - | - |
PickTicketHeaders
Contains a single record for every Pick Ticket. Individual items that can or have been added to a Pick Ticket are in the PickTicketItemsToPick and PickTicketItemsPicked views, respectively.
Column | Required | Description | Relates to |
PickTicketId | Yes | The unique ID for each pick ticket | - |
Number | Yes | A shorthand string used to refer to this pick ticket | - |
Status | No | The status of the pick ticket (ex. Ready to Pick, In Progress, Complete) | - |
State | No | The state of the pick ticket (ex. Open, Closed) | - |
CreatedOn | Yes | The date the pick ticket was created | - |
PickFrom | No | - | - |
PickFromId | No | The stock point that it will be picked from | Entities |
PickFromCostCenterId | No | - | - |
PickFromCostCodeId | No | - | - |
PickFor | Yes | The name of the entity the pick ticket was created for | - |
PickForId | No | The entity that is requesting the items. | Entities |
PickForCostCenterId | No | - | - |
PickForCostCodeId | No | - | - |
AssignedTo | No | The name of the entity the pick ticket was assigned to | - |
PickedBy | No | The name of the entity the pick ticket was assigned to | Entities |
PickDueDate | No | - | - |
AssignedToId | No | The entity that is responsible for picking the items. | Entities |
StatusId | No | The unique ID for status | StatusCodes |
StateId | No | The unique ID for state | StatusCodes |
RequestedById | No | The unique ID for the entity that requested the item. | Entities |
CreatedById | Yes | The user that created the record. | Entities |
PickTicketItemsPicked
Contains Pick Tickets and their selected items.
Column | Required | Description | Relates to |
PickTicketId | Yes | The unique ID for each pick ticket | - |
PickTicketPickedId | Yes | Unique ID for each pick ticket picked record | - |
ModelId | No | The asset model ID | Models |
ItemId | No | Which item this asset is an instance of | Items |
DescriptionId | No | The asset description ID | Descriptions |
PickedQty | Yes | The number of assets picked | - |
PickedFromId | Yes | The unique ID of whom/where the asset was picked from | Entities |
PickedById | Yes | The unique ID of who picked the asset | Entities |
CreatedOn | Yes | The date the pick ticket picked record was created | - |
TransferId | No | The ID of the transfer | TransferHeaders |
PickedFromCostCenterId | No | The cost center that the asset was picked from | CostCenters |
PickedFromCostCodeId | No | The cost code the asset was picked from | CostCodes |
Manufacturer | No | The asset manufacturer | Manufacturers |
ModelRecordId | No | The asset model ID | Models |
ItemType | No | The type of item | Items |
Model | No | The asset model name | Models |
YourDescription | No | The item description | - |
TransferNumber | No | The number of this transfer | TransferHeaders |
PickedBy | No | The name of the person/location that picked the asset | Entities |
ItemNumber | No | The shorthand string used to refer to this asset | Items |
LineId | Yes | The unique ID of this pick ticket item | - |
IsPersonalIssue | No | If the asset has been personally issued | - |
ItemStatusId | No | The asset status ID | StatusCodes |
KitId | No | The kit containing this asset | Items |
OwnerEntityId | No | The owner of this asset | Entities |
ManagerEntityId | No | The manager unique ID | Entities |
PickTicketItemsToPick
Contains items available to be selected for a Pick Ticket.
Column | Required | Description | Relates to |
PickTicketId | Yes | The unique ID for each pick ticket | - |
IsGeneric | Yes | If the asset is generic | - |
LineId | Yes | The unique ID of this pick ticket item | - |
RequiredQty | Yes | The required quantity of items to pick | - |
Manufacturer | No | The asset manufacturer | Manufacturers |
Category | No | A brief phrase describing this category | Categories |
YourDescription | No | The asset description | - |
ModelId | No | The asset model ID | Models |
DescriptionId | No | The asset description ID | Descriptions |
ItemId | No | Which item this asset is an instance of | Items |
PickFromId | Yes | The unique ID of whom/where the asset was picked from | Entities |
StockPointBinLocation | No | Stock point Bin location | Entities |
PickFromDescription | No | A brief description of the entity this asset was picked from | Entities |
Model | No | The asset model name | Models |
ItemType | Yes | The type of item | Items |
ModelRecordId | Yes | - | - |
ItemNumber | No | The shorthand string used to refer to this asset | Items |
PickTicketStockpointEntityId | No | The stock location for this asset | Entities |
StockpointDataStockpointEntityId | No | The stock point data location for this asset | Entities |
TemplateHeaders
Column | Required | Description | Relates to |
TemplateHeaderId | Yes | The unique ID of this template. | - |
TemplateNumber | Yes | A number that is used to refer to this template. | - |
Description | Yes | A brief description of the purpose of the template. | - |
CategoryId | Yes | The category that the template is related to. | Categories |
TemplateTypeDescription | Yes | Type of template. | - |
Notes | No | Notes on the template | - |
CreatedById | Yes | The user that created the template. | Entities |
CreatedOn | Yes | When the template was created. | - |
ModifiedById | Yes | The user that last modified the template. | Entities |
ModifiedOn | Yes | When the template was last modified. | - |
TemplateLines
Column | Required | Description | Relates to |
TemplateLineId | Yes | The unique ID of this template line. | - |
TemplateHeaderId | Yes | The parent template header. | TemplateHeaders |
ModelId | Yes | The model that this template line relates to. | Models |
Quantity | Yes | The quantity of the items of this model on the template. | - |
IsGeneric | Yes | Indicates if the model should be viewed as a generic type as opposed to being specifically required (0 - Require specific model, 1 - Generic tool represented, other similar tools could be used). | Categories |
CreatedById | Yes | The user that created the template. | Entities |
CreatedOn | Yes | When the template was created. | - |
ModifiedById | Yes | The user that last modified the template. | Entities |
ModifiedOn | Yes | When the template was last modified. | - |
TransferHeaders
Contains a single record for every Transfer. Individual transfer lines are recorded in the TransferLines view.
Column | Required | Description | Relates to |
TransferHeaderId | Yes | The unique ID of this transfer | - |
StockpointEntityId | Yes | Where this transfer is visible in the org tree | Entities |
Number | Yes | The number of this transfer | - |
TransferredToEntityId | Yes | The entity all the assets were assigned to | Entities |
TransferredByEntityId | Yes | Who created this transfer | Entities |
DeliveredByEntityId | No | Who delivered this transfer | Entities |
Notes | No | Free-form text notes | - |
AssignedOn | Yes | The effective date of this transfer | - |
CreatedOn | Yes | The date this transfer was processed | - |
SignedByEntityId | No | The ID of the employee that signed | Entities |
ReturnOn | No | The date the assets are expected to be returned. | - |
TransferredFromEntityId | Yes | The ID of the employee or location that the transfer was from. | Entities |
DocumentNumber | No | - | - |
CostCenterIdFrom | No | The CostCenter that the transfer was from. | CostCenters |
CostCenterIdTo | No | The CostCenter that the transfer was to. | CostCenters |
CostCodeIdFrom | No | The CostCode that the transfer was from. | CostCodes |
CostCodeIDTo | No | The CostCode that the transfer was to. | CostCodes |
TransferLines
The TransferLines view contains a record for each asset transferred on a Transfer Ticket.
Column | Required | Description | Relates to |
TransferLineId | Yes | The unique ID for this record | - |
TransferHeaderId | Yes | The ID of the transfer this line belongs to. | TransferHeaders |
InventoryKeyId | Yes | The asset being transferred. | InventoryKeys |
Qty | Yes | How many are being transferred | - |
Meter | No | If present, the meter reading recorded at the time of the transfer. The asset's meter was set to this value when the transfer was processed | - |
ReturnOn | No | Deprected. See the ReturnOn column in the TransferHeaders view. | - |
ItemId | Yes | The item this record is for. | Items |
FromCostCenterId | No | The cost center to credit | CostCenters |
FromCostCodeId | No | The cost code to credit | CostCodes |
ToCostCenterId | No | The cost center to charge | CostCenters |
ToCostCodeId | No | The cost code to charge | CostCodes |