Each entity below lists its OData feed entity set name and its columns, whether a value is required, a description, and the entity it relates to. For the terms used in these articles (tools, materials, assets, uniquely-tracked, and quantity-tracked), see Document Conventions in the ToolWatch OData API Overview.
CountTicketCounted
OData feed entity set: rc.CountTicketCounted
Column | Required | Description | Relates to |
countTicketCountedId | Yes | - | - |
countTicketId | Yes | - | - |
inventoryKeyId | Yes | - | - |
countedById | Yes | - | - |
countedOn | Yes | - | - |
CountTicketLines
OData feed entity set: rc.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
OData feed entity set: rc.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
OData feed entity set: rc.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.
OData feed entity set: rc.PickTicketHeaders
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.
OData feed entity set: rc.PickTicketItemsPicked
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.
OData feed entity set: rc.PickTicketItemsToPick
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
OData feed entity set: rc.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
OData feed entity set: rc.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.
OData feed entity set: rc.TransferHeaders
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.
OData feed entity set: rc.TransferLines
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 |