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 |