SSIS Components for SAP Fieldglass

Build 24.0.9062

AuditTrails

Query this table for audit trails in SAPFieldglass.

View Specific Information

The 本製品 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 本製品.

  • 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.

使用できる値は次のとおりです。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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062