AuditTrails
Query this table for audit trails in SAPFieldglass.
View Specific Information
The connector will use the SAP Fieldglass API to process WHERE clause conditions built with the following column and operator. The remaining filter criteria is executed client-side within the connector.
- Status supports the '=' operator.
For example, the following query is processed server-side:
SELECT * FROM AuditTrails WHERE Status = 'OK'
Columns
| Name | Type | Description |
| Id [KEY] | String | The Id of the audit trail. |
| Category | String | The category of the audit trail. |
| Company | String | The company of the audit trail. |
| Details | String | The details of the audit trail. |
| Status | String | The status of the audit trail.
The allowed values are OK, Error. |
| Type | String | The type of the audit trail. |
| User | String | The user of the audit trail. |
| StartTime | Datetime | The start time of the audit trail. |
| StopTime | Datetime | The stop time of the audit trail. |
| PassportActionType | Integer | The action type of the audit trail's passport. |
| PassportComponentType | Integer | The component type of the audit trail's passport. |
| PassportTransactionId | String | The transaction id of the audit trail's passport. |
| Version | String | The version of the audit trail. |
| Activity | String | The activity of the audit trail. |
| CompanyAttribute | String | The company attribute of the audit trail. |
| DocumentStatus | String | The document status of the audit trail. |
| ClientMessage | String | The client message of the audit trail. |
| ClientReturnCode | Integer | The client return code of the audit trail. |
| CRC32Checksum | String | The CRC32 checksum of the audit trail. |
| DeliveryTime | Integer | The delivery time of the audit trail. |
| DeliveryStatus | String | The delivery status of the audit trail. |
| Duration | Datetime | The duration of the audit trail. |
| Message | Boolean | The message of the audit trail. |
| RecordsFailed | String | The number of the audit trail's failed records. |
| RecordsProcessed | String | The number of the audit trail's processed records. |
| ServerMessage | String | The server message of the audit trail. |
| ServerStatus | String | The server status of the audit trail. |
| UploadFile | String | The uploaded file of the audit trail. |