These entities expose ToolWatch report data through the same OData feed. Column descriptions for these entities are pending review.
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.
AdjustmentHistory
OData feed entity set: templates.AdjustmentHistory
Column | Required | Description | Relates to |
ItemNumber | No | - | - |
Description | No | - | - |
Category | No | - | - |
StockLocation | No | - | - |
BeginningQty | Yes | - | - |
AdjustedQty | Yes | - | - |
Difference | No | - | - |
AdjustedBy | Yes | - | - |
EmployeeID | No | - | - |
AdjustmentDate | Yes | - | - |
ItemType | No | - | - |
AdjustmentReason | No | - | - |
Document | No | - | - |
CostCenters
Cost Centers enable you to group and manage all job cost and billing charges. They contain links to the rate sheets and project calendar used when calculating transaction charges. Cost centers also contain other configuration options that will impact charge calculations. Cost Centers can optionally be subdivided into Cost Codes to provide a greater level of information granularity.
OData feed entity set: templates.ea.CostCenters
Custom fields: Your organization's cost-center custom fields are returned as additional columns, each named by the field's label.
Column | Required | Description | Relates to |
Description | Yes | A brief phrase describing this Cost Center | - |
Number | Yes | A shorthand string used to refer to this Cost Center | - |
Suffix | No | - | - |
StockLocationNumber | No | - | - |
StockLocation | No | - | - |
Manager | No | - | - |
StartDate | No | Cost Center Start Date | - |
CompletionDate | No | Cost Center Completion Date | - |
Notes | No | Free-form text notes | - |
CustomerName | No | - | - |
CustomerNumber | No | - | - |
MaterialsRateSheet | No | - | - |
ToolsRateSheet | No | - | - |
ProcessOrder | Yes | - | - |
IsInactive | Yes | 1 if inactive, 0 if active | - |
IsDeleted | Yes | Indicates if this record has been deleted. | - |
CreatedOn | Yes | When the record was created. | - |
CreatedBy | Yes | The name of the user that created the record. | - |
ModifiedOn | Yes | When the record was last modified. | - |
ModifiedBy | Yes | The name of the user that last modified the record. | - |
CostCenterId | Yes | The unique ID of this Cost Center | - |
Cumulative_Billing
OData feed entity set: template.Cumulative_Billing
Column | Required | Description | Relates to |
CumulativeBilling | No | - | - |
MaxCharge | No | - | - |
MaxChargeType | No | - | - |
MaxChargeRemaining | No | - | - |
SumMiscCharges | No | - | - |
billingCalculationMethod | No | - | - |
TransferDate | No | - | - |
ReturnDate | No | - | - |
PostedCharges | No | - | - |
glChargeNumber | No | - | - |
glCreditNumber | No | - | - |
Quantity | No | - | - |
relatedChargeDescription | No | - | - |
closed | No | - | - |
hold | Yes | - | - |
Message | No | - | - |
billingEntryType | Yes | - | - |
postingNumber | No | - | - |
CutOffDate | No | - | - |
calculatedOn | Yes | - | - |
breakdownHours | No | - | - |
breakdownDays | No | - | - |
breakdownWeeks | No | - | - |
breakdownMonths | No | - | - |
potential | No | - | - |
hours | No | - | - |
RatePerHour | No | - | - |
rate | No | - | - |
CostCodeNumber | No | - | - |
CostCode | No | - | - |
CostCenterNumber | No | - | - |
CostCenter | Yes | - | - |
costCenterSuffix | No | - | - |
ItemDescription | No | - | - |
billingEntryDescription | No | - | - |
transactionType | No | - | - |
ItemNumber | No | - | - |
Category | No | - | - |
ReplacementCost | No | - | - |
ItemType | No | - | - |
RateSheetEntryType | Yes | - | - |
BaseCost | No | - | - |
RateSheetType | No | - | - |
transferNumber | No | - | - |
assignmentDate | No | - | - |
postingCreatedBy | No | - | - |
assignment | No | - | - |
extended | No | - | - |
itemPurchaseCost | No | - | - |
transferFromCostCenter | No | - | - |
transferFromCostCode | No | - | - |
transferFrom | No | - | - |
Employees
OData feed entity set: templates.ea.Employees
Custom fields: Your organization's employee custom fields are returned as additional columns, each named by the field's label.
Column | Required | Description | Relates to |
EmployeeDescription | Yes | - | - |
EmployeeNumber | Yes | - | - |
FirstName | No | - | - |
LastName | No | - | - |
No | - | - | |
IsInactive | Yes | Indicates if this record is inactive. | - |
ParentLocation | No | - | - |
ParentLocationNumber | No | - | - |
StockLocationName | No | - | - |
StockLocationNumber | No | - | - |
Supervisor | No | - | - |
SupervisorNumber | No | - | - |
Street1 | No | - | - |
Street2 | No | - | - |
City | No | - | - |
State | No | - | - |
Zip | No | - | - |
Country | No | - | - |
Phone1 | No | - | - |
Phone2 | No | - | - |
HireDate | No | - | - |
Department | No | - | - |
EmployeeType | No | - | - |
TerminationDate | No | - | - |
InactiveDate | No | - | - |
IsDoNotTransfer | Yes | - | - |
DoNotTransferReason | No | - | - |
IsDeleted | Yes | Indicates if this record has been deleted. | - |
DefaultCostCenter | No | - | - |
DefaultCostCenterNumber | No | - | - |
DefaultCostCodeId | No | - | - |
DefaultCostCode | No | - | - |
DefaultCostCodeNumber | No | - | - |
IsDesktopUser | Yes | - | - |
IsWarehouseUser | Yes | - | - |
IsFieldUser | Yes | - | - |
CreatedOn | Yes | When the record was created. | - |
CreatedBy | No | The name of the user that created the record. | - |
ModifiedOn | Yes | When the record was last modified. | - |
ModifiedBy | No | The name of the user that last modified the record. | - |
EmployeeEntityId | Yes | - | - |
IsCloudUser | Yes | - | - |
UserRole | No | - | - |
Job_Cost_And_Billing_Transaction
OData feed entity set: template.Job_Cost_And_Billing_Tansaction
Column | Required | Description | Relates to |
CostCenterId | Yes | - | - |
CostCodeId | No | - | - |
CostCenter | No | - | - |
CostCode | No | - | - |
CostCenterNumber | No | - | - |
CostCenterSuffix | No | - | - |
CostCodeNumber | No | - | - |
Description | No | - | - |
ItemNumber | No | - | - |
BarCode | No | - | - |
SerialNumber | No | - | - |
CostCenterManagerId | No | - | - |
CurrentResponsibleParty | No | - | - |
ItemType | No | - | - |
ModelId | Yes | - | - |
ModelNumber | No | - | - |
Model | No | - | - |
BillingCalcMethod | No | - | - |
TrackingMethod | No | - | - |
Category | No | - | - |
MasterCategoryId | No | - | - |
RateSheet | No | - | - |
RateSheetNumber | No | - | - |
RecordId | Yes | - | - |
Quantity | Yes | - | - |
ChargeEach | No | - | - |
Hold | Yes | - | - |
TransactionTypeId | No | - | - |
TransactionTypeIdIn | No | - | - |
GlChargeNumber | No | - | - |
GlCreditNumber | No | - | - |
BillingEntryHeaderId | No | - | - |
Temp | No | - | - |
CutOffDate | Yes | - | - |
PostingNumber | No | - | - |
PostedOn | No | - | - |
CreatedOn | No | When the record was created. | - |
BillingEntryType | No | - | - |
BillingEntryTypeId | Yes | - | - |
ItemClass | No | - | - |
RateSheetTypeId | Yes | - | - |
StartTime | Yes | - | - |
EndTime | No | - | - |
AssignmentDate | No | - | - |
TransferNumber | No | - | - |
AssignedTo | No | - | - |
AssignmentSupervisorId | No | - | - |
TransactionType | No | - | - |
BreakdownHours | Yes | - | - |
BreakdownDays | Yes | - | - |
BreakdownWeeks | Yes | - | - |
BreakdownMonths | Yes | - | - |
Potential | Yes | - | - |
Hours | Yes | - | - |
RatePerHour | Yes | - | - |
TotalDaysBilled | Yes | - | - |
DailyRate | Yes | - | - |
DailyTotalChargeEach | Yes | - | - |
StartTransactionNumber | No | - | - |
RateType | No | - | - |
Operator | No | - | - |
Project | No | - | - |
HourlyRate | Yes | - | - |
IdleRate | Yes | - | - |
AccruedCharge | Yes | - | - |
MinCharge | Yes | - | - |
MaxCharge | Yes | - | - |
RateSheetEntryType | No | - | - |
Posted | Yes | - | - |
CostCenterManager | No | - | - |
Locations
OData feed entity set: templates.ea.Locations
Custom fields: Your organization's location custom fields are returned as additional columns, each named by the field's label.
Column | Required | Description | Relates to |
Number | Yes | - | - |
Description | Yes | - | - |
StockLocationName | No | - | - |
ParentLocation | No | - | - |
ParentLocationNumber | No | - | - |
IsStockLocation | Yes | - | - |
StockLocationNumber | No | - | - |
Supervisor | No | - | - |
SupervisorNumber | No | - | - |
Street1 | No | - | - |
Street2 | No | - | - |
City | No | - | - |
State | No | - | - |
Zip | No | - | - |
Country | No | - | - |
Phone1 | No | - | - |
Phone2 | No | - | - |
InactiveDate | No | - | - |
IsInactive | Yes | Indicates if this record is inactive. | - |
IsDoNotTransfer | Yes | - | - |
DoNotTransferReason | No | - | - |
IsDeleted | Yes | Indicates if this record has been deleted. | - |
DefaultCostCenter | No | - | - |
DefaultCostCenterNumber | No | - | - |
DefaultCostCodeNumber | No | - | - |
DecommissionDate | No | - | - |
CreatedOn | Yes | When the record was created. | - |
CreatedById | Yes | The user that created the record. | Entities |
CreatedBy | Yes | The name of the user that created the record. | - |
ModifiedOn | Yes | When the record was last modified. | - |
ModifiedBy | No | The name of the user that last modified the record. | - |
LocationEntityId | Yes | - | - |
Low_Level_Browser
OData feed entity set: template.Low_Level_Browser
Column | Required | Description | Relates to |
StockLocationSupervisorId | No | - | - |
StockLcationSupervisor | No | - | - |
Category | No | - | - |
Description | No | - | - |
Manufacturer | No | - | - |
Model | No | - | - |
ModelNumber | No | - | - |
CurrentLevel | Yes | - | - |
OnOrder | Yes | - | - |
LowLevel | No | - | - |
TargetLevel | No | - | - |
HighLevel | No | - | - |
Vendor | No | - | - |
StockLocationId | No | - | - |
StockLocation | No | - | - |
Material_Browser
OData feed entity set: template.Material_Browser
Column | Required | Description | Relates to |
Category | No | - | - |
Number | No | - | - |
Description | No | - | - |
Model | No | - | - |
Quantity | Yes | - | - |
Uom | No | - | - |
StockLocation | No | - | - |
Bin | No | - | - |
ReplacementCost | No | - | - |
ExtendedCostTotal | No | - | - |
BarCode | No | - | - |
Allocated | Yes | - | - |
Available | Yes | - | - |
Max_Cumulative_Billing
OData feed entity set: template.Max_Cumulative_Billing
Column | Required | Description | Relates to |
CumulativeBilling | No | - | - |
MaxCharge | No | - | - |
MaxChargeType | No | - | - |
MaxChargeRemaining | No | - | - |
SumMiscCharges | No | - | - |
billingCalculationMethod | No | - | - |
TransferDate | No | - | - |
ReturnDate | No | - | - |
PostedCharges | No | - | - |
glChargeNumber | No | - | - |
glCreditNumber | No | - | - |
Quantity | No | - | - |
relatedChargeDescription | No | - | - |
closed | No | - | - |
hold | Yes | - | - |
Message | No | - | - |
billingEntryType | Yes | - | - |
postingNumber | No | - | - |
CutOffDate | Yes | - | - |
calculatedOn | Yes | - | - |
breakdownHours | No | - | - |
breakdownDays | No | - | - |
breakdownWeeks | No | - | - |
breakdownMonths | No | - | - |
potential | No | - | - |
hours | No | - | - |
RatePerHour | No | - | - |
rate | No | - | - |
CostCodeNumber | No | - | - |
CostCode | No | - | - |
CostCenterNumber | No | - | - |
CostCenter | Yes | - | - |
costCenterSuffix | No | - | - |
ItemDescription | No | - | - |
billingEntryDescription | No | - | - |
transactionType | No | - | - |
ItemNumber | No | - | - |
Category | No | - | - |
ReplacementCost | No | - | - |
ItemType | No | - | - |
RateSheetEntryType | Yes | - | - |
BaseCost | No | - | - |
RateSheetType | No | - | - |
transferNumber | No | - | - |
assignmentDate | No | - | - |
postingCreatedBy | No | - | - |
assignment | No | - | - |
extended | No | - | - |
itemPurchaseCost | No | - | - |
transferFromCostCenter | No | - | - |
transferFromCostCode | No | - | - |
transferFrom | No | - | - |
costCenterManager | No | - | - |
CostCenterManagerID | No | - | - |
Notifications
OData feed entity set: templates.ea.Notifications
Column | Required | Description | Relates to |
EventDate | No | - | - |
EventType | No | - | - |
MessageDeliveryType | Yes | - | - |
To | Yes | - | - |
Subject | Yes | - | - |
MessageBody | Yes | - | - |
Status | Yes | - | - |
ErrorDetails | No | - | - |
SentOn | No | - | - |
replyTo | Yes | - | - |
Posted_Billing_Transaction_Summary
OData feed entity set: template.Posted_Billing_Tansaction_Summary
Column | Required | Description | Relates to |
rateSheetEntryType | Yes | - | - |
costCenterId | Yes | - | - |
costCodeId | No | - | - |
costCenter | Yes | - | - |
costCode | No | - | - |
costCenterNumber | No | - | - |
costCenterSuffix | No | - | - |
costCodeNumber | No | - | - |
description | No | - | - |
itemNumber | No | - | - |
barCode | No | - | - |
serialNumber | No | - | - |
costCenterManagerId | No | - | - |
currentResponsibleParty | No | - | - |
itemNumberSorter | No | - | - |
itemType | No | - | - |
masterId | No | - | - |
masterNumber | No | - | - |
model | No | - | - |
billingCalcMethod | Yes | - | - |
trackingMethod | Yes | - | - |
category | No | - | - |
masterCategoryId | No | - | - |
rateSheet | No | - | - |
rateSheetNumber | No | - | - |
recordId | Yes | - | - |
quantity | Yes | - | - |
chargeEach | No | - | - |
hold | No | - | - |
transactionTypeId | No | - | - |
transactionTypeIdIn | No | - | - |
glChargeNumber | No | - | - |
glCreditNumber | No | - | - |
billingEntryHeaderId | No | - | - |
temp | No | - | - |
cutOffDate | No | - | - |
postingNumber | No | - | - |
postedOn | No | - | - |
createdOn | No | When the record was created. | - |
billingEntryType | Yes | - | - |
billingEntryTypeId | Yes | - | - |
rateSheetTypeId | No | - | - |
startTime | Yes | - | - |
endTime | No | - | - |
assignmentDate | No | - | - |
transferNumber | No | - | - |
assignedTo | No | - | - |
assignmentSupervisorId | No | - | - |
transactionType | No | - | - |
breakdownHours | No | - | - |
breakdownDays | No | - | - |
breakdownWeeks | No | - | - |
breakdownMonths | No | - | - |
potential | No | - | - |
hours | No | - | - |
ratePerHour | No | - | - |
startTransactionNumber | No | - | - |
rateType | No | - | - |
operator | No | - | - |
project | No | - | - |
hourlyRate | No | - | - |
idleRate | No | - | - |
accruedCharge | Yes | - | - |
minCharge | Yes | - | - |
maxCharge | Yes | - | - |
costCenterManager | No | - | - |
Purchase_Order_Summary
OData feed entity set: templates.Purchase_Order_Summary
Column | Required | Description | Relates to |
Status | No | - | - |
PONumber | No | - | - |
OrderDate | Yes | - | - |
ExpectedDeliveryDate | Yes | - | - |
TotalCostReceived | Yes | - | - |
TotalCostOrdered | Yes | - | - |
OrderedByDescription | No | - | - |
VendorName | No | - | - |
VendorId | Yes | - | - |
OrderedById | No | - | - |
CreatedOn | Yes | When the record was created. | - |
PurchaseOrderId | Yes | - | - |
StateId | Yes | - | - |
State | No | - | - |
Purchases_by_Model_ID
OData feed entity set: templates.Purchases_by_Model_ID
Column | Required | Description | Relates to |
ItemNumber | No | - | - |
Description | No | - | - |
Cost | No | - | - |
State | No | - | - |
OrderDate | Yes | - | - |
QuantityCancelled | Yes | - | - |
QuantityOrdered | Yes | - | - |
QuantityReceived | Yes | - | - |
PONumber | No | - | - |
VendorName | No | - | - |
Category | No | - | - |
Receipts_by_Model_ID
OData feed entity set: templates.Receipts_by_Model_ID
Column | Required | Description | Relates to |
ItemNumber | No | - | - |
Description | No | - | - |
CostEach | Yes | - | - |
VendorName | No | - | - |
DocumentNumber | No | - | - |
OrderDate | No | - | - |
QuantityReceived | Yes | - | - |
PONumber | No | - | - |
PurchaseOrderId | Yes | - | - |
Category | No | - | - |
ReceivedOn | Yes | - | - |
ReceiptNumber | No | - | - |
Receiving_Ticket_Summary
OData feed entity set: templates.Receiving_Ticket_Summary
Column | Required | Description | Relates to |
VendorName | No | - | - |
DocumentNumber | No | - | - |
PONumber | No | - | - |
ReceiptNumber | No | - | - |
ReceivedBy | No | - | - |
DateReceived | Yes | - | - |
AmountReceived | No | - | - |
QuantityReceived | Yes | - | - |
ActualPrice | No | - | - |
OrderDate | Yes | - | - |
RetiredTools
OData feed entity set: templates.ea.Retired_Tools
Custom fields: Your organization's item/tool custom fields are returned as additional columns, each named by the field's label.
Column | Required | Description | Relates to |
description | Yes | - | - |
itemNumber | No | - | - |
barCode | No | - | - |
serialNumber | No | - | - |
retiredDate | Yes | - | - |
quantity | Yes | - | - |
notes | No | - | - |
categoryNumber | Yes | - | - |
category | Yes | - | - |
itemType | Yes | - | - |
model | No | - | - |
upc | No | - | - |
totalValue | No | - | - |
manufacturer | No | - | - |
statusCodeNumber | No | - | - |
statusDesc | No | - | - |
assignment | Yes | - | - |
assignmentNumber | Yes | - | - |
supervisorDesc | No | - | - |
retiredBy | No | - | - |
retiredAt | No | - | - |
classNumber | No | - | - |
itemClass | No | - | - |
reason | No | - | - |
PONumber | No | - | - |
PODate | No | - | - |
cost | No | - | - |
costCenter | No | - | - |
itemId | Yes | The item this record is for. | Items |
Service_Schedule
OData feed entity set: template.Service_Schedule
Column | Required | Description | Relates to |
CurrentWorkOrderNumber | No | - | - |
CreatedOn | No | When the record was created. | - |
NextDate | No | - | - |
NextMeter | No | - | - |
NextTurn | No | - | - |
Priority | No | - | - |
RequestedService | No | - | - |
ItemNumber | No | - | - |
Description | No | - | - |
SerialNumber | No | - | - |
Manufacturer | No | - | - |
Model | No | - | - |
CurrentAssignment | No | - | - |
CurrentMeter | No | - | - |
IsOpen | Yes | - | - |
IsScheduled | Yes | - | - |
Explanation | No | - | - |
OnDateExplanation | No | - | - |
OnMeterExplanation | No | - | - |
OnTurnExplanation | No | - | - |
IsScheduledExplanation | No | - | - |
ServiceEventId | Yes | - | - |
ItemId | Yes | The item this record is for. | Items |
MasterId | No | - | - |
InsertedOn | No | - | - |
TemplateWorkOrderId | Yes | - | - |
LastWorkOrderId | No | - | - |
Barcode | No | - | - |
CurrentAssignmentId | Yes | - | - |
Supervisor | No | - | - |
SupervisorId | No | - | - |
OwnerId | Yes | - | - |
Category | No | - | - |
Class | No | - | - |
Department | No | - | - |
Manager | No | - | - |
ManagerId | Yes | - | - |
StockLocationSupervisor | No | - | - |
StockLocationSupervisorId | No | - | - |
Service_Schedule_Scoped
OData feed entity set: template.Service_Schedule_Scoped
Column | Required | Description | Relates to |
CurrentWorkOrderNumber | No | - | - |
CreatedOn | No | When the record was created. | - |
NextDate | No | - | - |
NextMeter | No | - | - |
NextTurn | No | - | - |
Priority | No | - | - |
RequestedService | No | - | - |
ItemNumber | No | - | - |
Description | No | - | - |
SerialNumber | No | - | - |
Manufacturer | No | - | - |
Model | No | - | - |
CurrentAssignment | No | - | - |
CurrentMeter | No | - | - |
IsOpen | Yes | - | - |
IsScheduled | Yes | - | - |
Explanation | No | - | - |
OnDateExplanation | No | - | - |
OnMeterExplanation | No | - | - |
OnTurnExplanation | No | - | - |
IsScheduledExplanation | No | - | - |
ServiceEventId | Yes | - | - |
ItemId | Yes | The item this record is for. | Items |
MasterId | No | - | - |
InsertedOn | No | - | - |
TemplateWorkOrderId | Yes | - | - |
LastWorkOrderId | No | - | - |
Barcode | No | - | - |
CurrentAssignmentId | Yes | - | - |
Supervisor | No | - | - |
SupervisorId | No | - | - |
OwnerId | Yes | - | - |
Category | No | - | - |
Class | No | - | - |
Department | No | - | - |
Manager | No | - | - |
ManagerId | Yes | - | - |
StockLocationSupervisor | No | - | - |
StockLocationSupervisorId | No | - | - |
Tasks
OData feed entity set: template.Tasks
Column | Required | Description | Relates to |
Subject | Yes | - | - |
TaskCategory | No | - | - |
ToolWatchLocation | No | - | - |
OtherLocation | No | - | - |
AssignedTo | No | - | - |
AssignedToEmail | No | - | - |
AssignedToID | No | - | - |
DueBy | No | - | - |
Priority | No | - | - |
ToolBrowser
Contains a record for each asset as it appears within ToolWatch's Tool Browser.
OData feed entity set: template.Tool_Browser
Custom fields: Your organization's item/tool custom fields are returned as additional columns, each named by the field's label.
Column | Required | Description | Relates to |
Category | Yes | The category description | Categories |
Number | No | - | - |
Barcode | No | A short text string used to find this item when scanning. This is usually a printed barcode label physically on the asset. | Items |
SerialNumber | No | The serial number for this instance | Items |
Kit | No | The description of the kit containing this asset | - |
ItemType | Yes | The type of item (Q = Quantity, T = Unique, K = Kit) | - |
Description | Yes | The asset description | - |
Manufacturer | No | The manufacturer name | - |
Model | Yes | The asset model | Models |
Quantity | No | The number of assets this entry is for. Quantity is multiplied by ChargeEach to get the total charge for the entry. | - |
Allocated | Yes | - | - |
Available | Yes | - | - |
Uom | No | The unit of measure of the item. See ItemMeter UOM for the item's meter unit of measure | UOM |
Status | No | The status code description | StatusCodes |
PersonalIssue | Yes | - | - |
AssignedTo | No | - | - |
ReplacementCost | No | Cost to replace one item, taking into account time, delivery fees, effort, etc. | - |
ExtendedCostTotal | No | - | - |
AssignedToId | No | - | - |
AssignmentType | No | - | - |
Bin | No | - | - |
ResponsibleParty | No | The name of the responsible party | - |
Age | No | - | - |
LastScanned | No | - | - |
HoursSinceLastScan | No | - | - |
LastBleScanLocation | No | - | - |
LastBleScanArea | No | - | - |
IsOutOfBounds | Yes | - | - |
LastCounted | No | - | - |
TranNo | No | - | - |
TranDate | No | - | - |
Returning | No | - | - |
Owner | No | The description of the asset's owner | - |
Manager | No | The asset manager description | - |
Department | No | A brief phrase describing this department | Department |
Supervisor | No | The description of the entity's department supervisor | - |
SupervisorEntityId | No | - | - |
Delivered | No | - | - |
ItemClass | No | - | - |
ItemId | Yes | The unique ID of this item | Items |
TransactionHistory
OData feed entity set: template.TransactionHistory
Column | Required | Description | Relates to |
TransactionDate | Yes | - | - |
TransactionType | No | - | - |
PersonalIssue | Yes | - | - |
KitNumber | No | - | - |
Quantity | Yes | - | - |
Status | No | - | - |
Owner | No | - | - |
Description | No | - | - |
AssignedTo | No | - | - |
TransferNumber | No | - | - |
AssignmentDate | No | - | - |
Category | No | - | - |
ItemNumber | No | - | - |
ModelNumber | No | - | - |
Manufacturer | No | - | - |
ResponsibleParty | No | - | - |
TransferedTo | No | - | - |
TransferedFrom | No | - | - |
TransferValue
OData feed entity set: template.TransferValue
Column | Required | Description | Relates to |
AssignmentDate | Yes | - | - |
StockPoint | No | - | - |
DollarValue | Yes | - | - |
Model | No | - | - |
ItemNumber | No | - | - |
ReplacementCost | Yes | - | - |
Quantity | Yes | - | - |
Assignment | No | - | - |
TransferNumber | No | - | - |
Direction | No | - | - |
UserPreferences
OData feed entity set: templates.ea.UserPreferences
Column | Required | Description | Relates to |
Employee | Yes | - | - |
EmployeeEmail | No | - | - |
VerifiedSMSPhone | No | - | - |
AutoCheckExpressCheckInLines | Yes | - | - |
PickTicketCompletedByEmail | Yes | - | - |
PickTicketCompletedBySMS | Yes | - | - |
PickTicketCreatedByEmail | Yes | - | - |
PickTicketCreatedBySMS | Yes | - | - |
PickTicketRequestedByEmail | Yes | - | - |
PickTicketRequestedBySMS | Yes | - | - |
ResponsiblePartyAssignedByEmail | Yes | - | - |
ResponsiblePartyAssignedBySMS | Yes | - | - |
ResponsiblePartyClearedByEmail | Yes | - | - |
ResponsiblePartyClearedBySMS | Yes | - | - |
TransferToCompletedByEmail | Yes | - | - |
TransferToCompletedBySMS | Yes | - | - |
TransferToLocationCompletedByEmail | Yes | - | - |
TransferToLocationCompletedBySMS | Yes | - | - |
WorkOrderCreatedByEmail | Yes | - | - |
WorkOrderCreatedBySMS | Yes | - | - |
ReinstatedToolByEmail | Yes | - | - |
ReinstatedToolBySMS | Yes | - | - |
ServiceRequestCreatedByEmail | Yes | - | - |
ServiceRequestCreatedBySMS | Yes | - | - |
EmployeeFirstName | No | - | - |
EmployeeLastName | No | - | - |
EmployeeNumber | Yes | - | - |
Vendor_Discrepancy_Report
OData feed entity set: templates.Vendor_Discrepancy_Report
Column | Required | Description | Relates to |
ReceivedOn | No | - | - |
Description | No | - | - |
ManufacturerName | No | - | - |
Model | No | - | - |
QuantityReceived | No | - | - |
OrderPrice | No | - | - |
ActualPrice | No | - | - |
VendorNumber | No | - | - |
VendorName | No | - | - |
ItemNumber | No | - | - |
PONumber | No | - | - |
PurchaseOrderId | Yes | - | - |
DiscrepancyCost | No | - | - |
OrderDate | Yes | - | - |
VendorId | Yes | - | - |