This article provides information about all available data tables and where they can be assessed in the CMMS.
To learn more about how to create your tables, see Create a custom table.
Table |
API |
Data Dictionary |
Data Export |
Reports |
Analytics |
---|---|---|---|---|---|
Account |
✓ |
– |
– |
✓ |
– |
Activity Log |
– |
– |
– |
✓ |
– |
Activity Log Status |
– |
– |
✓ |
✓ |
– |
Activity Log Type |
– |
– |
✓ |
✓ |
– |
Asset |
✓ |
✓ |
✓ |
✓ |
– |
Asset Activity Log |
– |
– |
✓ |
✓ |
– |
Asset Business |
✓ |
✓ |
✓ |
✓ |
– |
Asset Category |
✓ |
✓ |
✓ |
✓ |
– |
Asset Category Barcode Format Type |
– |
✓ |
✓ |
✓ |
– |
Asset Category Resolved |
– |
– |
– |
✓ |
– |
Asset Classification |
– |
✓ |
✓ |
✓ |
– |
Asset Classification Log |
– |
✓ |
✓ |
– |
– |
Asset Consuming Reference |
✓ |
✓ |
✓ |
✓ |
– |
Asset Depletion Tracking |
– |
✓ |
✓ |
✓ |
– |
Asset Event |
✓ |
✓ |
✓ |
✓ |
– |
Asset Event Type |
✓ |
✓ |
✓ |
✓ |
– |
Asset Event Type Asset |
– |
✓ |
✓ |
✓ |
– |
Asset Offline Tracking |
✓ |
✓ |
✓ |
✓ |
– |
Asset Purchase Tracking |
– |
✓ |
✓ |
✓ |
– |
Asset Resolved |
✓ |
– |
– |
✓ |
– |
Asset Status |
– |
– |
✓ |
✓ |
– |
Asset User |
✓ |
✓ |
✓ |
✓ |
– |
Asset User Type |
– |
– |
✓ |
✓ |
– |
Barcode Format Type |
– |
– |
✓ |
✓ |
– |
Billing Term |
✓ |
✓ |
✓ |
✓ |
– |
BOM Group |
– |
✓ |
✓ |
✓ |
– |
BOM Group Part |
– |
✓ |
✓ |
✓ |
– |
Branding |
– |
✓ |
✓ |
– |
– |
Business |
✓ |
✓ |
✓ |
✓ |
– |
Business Classification |
✓ |
✓ |
– |
✓ |
– |
Business Contact |
– |
✓ |
✓ |
✓ |
– |
Business Group |
✓ |
✓ |
✓ |
✓ |
– |
Business Role |
– |
✓ |
✓ |
✓ |
– |
Business Role Type |
– |
– |
✓ |
✓ |
– |
Business Type Def |
– |
– |
– |
✓ |
– |
Calendar Event |
✓ |
– |
✓ |
✓ |
– |
Certification |
– |
✓ |
✓ |
✓ |
– |
Charge Department |
✓ |
✓ |
✓ |
✓ |
– |
Country |
✓ |
– |
✓ |
✓ |
– |
Currency |
✓ |
– |
✓ |
✓ |
– |
Custom Field |
✓ |
✓ |
✓ |
✓ |
– |
Custom Field Value |
✓ |
✓ |
✓ |
✓ |
– |
Cycle Count |
✓ |
✓ |
✓ |
✓ |
– |
Dashboard Widget |
✓ |
– |
– |
– |
– |
Dd Column |
– |
✓ |
✓ |
– |
– |
Dd Column Type |
– |
– |
✓ |
– |
– |
Dd Custom Table Row |
– |
✓ |
✓ |
– |
– |
Dd Table |
– |
✓ |
✓ |
– |
– |
Dd Table Type |
– |
– |
✓ |
– |
– |
File |
✓ |
✓ |
✓ |
✓ |
– |
File Contents |
✓ |
✓ |
✓ |
✓ |
– |
Get Accessible Sites |
✓ |
– |
– |
– |
– |
Get Timezones |
✓ |
– |
– |
– |
– |
Inventory Transaction |
– |
✓ |
✓ |
– |
– |
Iso Week Calendar |
– |
– |
✓ |
✓ |
– |
Log Cost Type |
– |
– |
✓ |
✓ |
– |
Log Type |
– |
– |
✓ |
✓ |
– |
Maintenance Type |
✓ |
✓ |
✓ |
✓ |
– |
Message |
– |
– |
– |
✓ |
– |
Message Folder |
– |
– |
✓ |
✓ |
– |
Meter Reading |
✓ |
✓ |
✓ |
✓ |
– |
Meter Reading Unit |
✓ |
✓ |
✓ |
✓ |
– |
Misc Cost |
– |
✓ |
✓ |
✓ |
– |
Misc Cost Type |
– |
✓ |
✓ |
✓ |
– |
Move |
✓ |
✓ |
✓ |
✓ |
– |
Move Asset |
✓ |
✓ |
✓ |
✓ |
– |
Move Back |
✓ |
✓ |
✓ |
✓ |
– |
Move Back Asset |
✓ |
✓ |
✓ |
✓ |
– |
Move Site Manager |
✓ |
✓ |
✓ |
✓ |
– |
Move Status |
✓ |
✓ |
✓ |
✓ |
– |
Ping |
✓ |
– |
– |
– |
– |
Priority |
✓ |
✓ |
✓ |
✓ |
– |
Project |
✓ |
✓ |
✓ |
✓ |
– |
Project User |
– |
✓ |
✓ |
✓ |
– |
Purchase Order |
✓ |
✓ |
✓ |
✓ |
– |
Purchase Order Additional Cost |
– |
✓ |
✓ |
✓ |
– |
Purchase Order Additional Cost Type |
– |
✓ |
✓ |
✓ |
– |
Purchase Order Line Item |
✓ |
✓ |
✓ |
✓ |
– |
Purchase Order Line Item RFQ |
– |
✓ |
✓ |
✓ |
– |
Purchase Order Log |
– |
✓ |
✓ |
✓ |
– |
Purchase Order Status |
✓ |
✓ |
✓ |
✓ |
– |
Purchase Order Status Transition |
– |
– |
– |
✓ |
– |
Purchase Order Status Transition Permission |
– |
– |
– |
✓ |
– |
Purchase Order User |
– |
✓ |
✓ |
✓ |
– |
RCAAction |
✓ |
✓ |
✓ |
✓ |
– |
RCACause |
✓ |
✓ |
✓ |
✓ |
– |
RCAGrouping |
– |
✓ |
✓ |
– |
– |
RCAGrouping Cause |
– |
✓ |
✓ |
– |
– |
RCAProblem |
✓ |
✓ |
✓ |
✓ |
– |
Ready to Set Asset Offline |
✓ |
✓ |
✓ |
✓ |
– |
Ready to Set Asset Online |
✓ |
✓ |
✓ |
✓ |
– |
Receipt |
✓ |
✓ |
✓ |
✓ |
– |
Receipt Line Item |
✓ |
✓ |
✓ |
✓ |
– |
Receipt Status |
✓ |
✓ |
✓ |
✓ |
– |
Receipt Status Transition |
– |
– |
– |
✓ |
– |
Recurring Type |
– |
– |
✓ |
– |
– |
Reports to Resolved |
✓ |
– |
– |
✓ |
– |
RFQ |
– |
✓ |
✓ |
✓ |
– |
RFQ Asset |
– |
✓ |
✓ |
✓ |
– |
RFQ Line Item |
– |
✓ |
✓ |
✓ |
– |
RFQ Queue |
– |
– |
– |
✓ |
– |
RFQ Status |
– |
✓ |
✓ |
✓ |
– |
RFQ Status Transition |
– |
✓ |
✓ |
✓ |
– |
Schedule Trigger |
✓ |
✓ |
✓ |
✓ |
– |
Scheduled Maintenance |
✓ |
✓ |
✓ |
✓ |
✓ |
Scheduled Maintenance Activity Log |
– |
– |
✓ |
✓ |
– |
Scheduled Maintenance Asset |
✓ |
✓ |
✓ |
✓ |
– |
Scheduled Maintenance Business |
– |
✓ |
✓ |
– |
– |
Scheduled Maintenance Nesting |
– |
✓ |
✓ |
✓ |
– |
Scheduled Maintenance Part |
✓ |
✓ |
✓ |
✓ |
– |
Scheduled Maintenance User |
✓ |
✓ |
✓ |
✓ |
– |
Scheduled Task |
✓ |
✓ |
✓ |
✓ |
– |
Scheduled Task File |
– |
✓ |
✓ |
– |
– |
Shipping Type |
– |
✓ |
✓ |
✓ |
– |
Site User |
✓ |
– |
✓ |
✓ |
– |
Site User Group |
✓ |
✓ |
✓ |
✓ |
– |
Stock |
✓ |
✓ |
✓ |
✓ |
– |
Stock Adjustment Item |
– |
✓ |
✓ |
✓ |
– |
Stock Cycle Count |
✓ |
✓ |
✓ |
✓ |
– |
Stock History |
✓ |
✓ |
✓ |
✓ |
– |
Stock Purchase Item |
– |
✓ |
✓ |
✓ |
– |
Stock Tx Type |
✓ |
– |
✓ |
✓ |
– |
Stocks Received |
✓ |
– |
– |
– |
– |
Task |
– |
✓ |
✓ |
✓ |
– |
Task File |
– |
✓ |
✓ |
– |
– |
Task Group |
– |
✓ |
✓ |
✓ |
– |
Task Group Asset Category |
– |
✓ |
✓ |
✓ |
– |
Task Result Value |
– |
✓ |
✓ |
– |
– |
User |
✓ |
✓ |
✓ |
✓ |
– |
User Certification |
– |
✓ |
✓ |
✓ |
– |
User Clock in Out |
– |
– |
– |
✓ |
– |
User Purchase Order Status Transition |
– |
– |
– |
✓ |
– |
User Reports to User |
– |
✓ |
✓ |
✓ |
– |
Warranty |
– |
✓ |
✓ |
✓ |
– |
Warranty Type |
– |
– |
✓ |
✓ |
– |
Warranty Usage Term Type |
– |
– |
✓ |
✓ |
– |
Work Order |
✓ |
✓ |
✓ |
✓ |
– |
Work Order Asset |
✓ |
✓ |
✓ |
✓ |
– |
Work Order Business |
✓ |
✓ |
✓ |
✓ |
– |
Work Order Log |
✓ |
✓ |
✓ |
✓ |
– |
Work Order Part |
✓ |
✓ |
✓ |
✓ |
– |
Work Order Status |
✓ |
✓ |
✓ |
✓ |
– |
Work Order Status Transition |
✓ |
✓ |
✓ |
✓ |
✓ |
Work Order Task |
✓ |
✓ |
✓ |
✓ |
✓ |
Work Order Task File |
– |
✓ |
✓ |
– |
– |
Work Order User |
✓ |
✓ |
✓ |
✓ |
– |
Workflow Comment |
– |
– |
✓ |
✓ |
– |
Ye Mo |
– |
– |
✓ |
✓ |
– |
Total Accessible Tables |
73 |
106 |
129 |
127 |
3 |