Transaction ROI View

This SQL View provides details for ROI generated upon running Transaction scripts.

Back to Reporting SQL Views.

Field Name DB Type Type Nullable Description
ActivityDateTime datetime DateTime 0 Date of Run
AppId uniqueidentifier Guid 0 ID of app in which transaction was run
ClientProduct nvarchar String 0 Studio/Integration Server. Here Integration Server means run by Worker
CRMCustomerId nvarchar String 0 Connect CRM customer ID
CRMLicenseId nvarchar String 0 Connect CRM license ID
CustomerId uniqueidentifier Guid 0 Connect customer ID
CustomerName nvarchar String 0 Connect customer name
DataFile nvarchar String 0 Name of the data file file
DocId uniqueidentifier Guid 0 This is the document ID of this ROI data belongs to.
Env nvarchar String 0

Environment with below values: Development : For environment activated with development license key.

Testing : For environment activated with testing license key.

Production : For environment activated with production license key.

Id uniqueidentifier Guid 0 Unique ID for this table /view
IsLogSync bit Boolean 0 Indicated if log have been synced to connect
License nvarchar String 0 License used for run
LogId uniqueidentifier Guid 0 Id of ROI log. ID is created for each entry in the log
ManualUploadTime nvarchar String 0 Time required to upload each record manually via sap
OpertaionType nvarchar String 0

OperationType with below values:

Run : A run on SAP for data posting or query.

Test : A test run on SAP.

Debug : Debug run on SAP .

Validate : Data validate run on SAP.

Simulate : Simulate run on SAP.
ParentDocId uniqueidentifier Guid 0 This is the document ID of parent document if current document has any parent document. or it would be empty guid.
ProcessSource nvarchar String 0

Process Source with below value:

Manual – ROI’s source document submitted from the Excel Add-in or Web UI.

SI_API – ROI’s source document submitted from SAP API.

PE_API – ROI’s source document submitted from Digital Access API.
Product nvarchar String 0 Transaction/Query. In this case transaction.
ProductName nvarchar String 0 Product name of license used for run
ProductVersion nvarchar String 0 Version of Studio/Integration Server (Worker) eg. 20.0
ReasonForRun nvarchar String 0 Reason for run
RecordingMode nvarchar String 0 Mode selected while recording the script. For example, batch, non batch.
RecordsUploaded int Int32 0 no. of records uploaded
ReferenceId uniqueidentifier Guid 0 ID of app in which transaction was run
RootDocId uniqueidentifier Guid 0 This is the root document ID of current document’s process inheritance else it would be empty guid.
RunErrors int Int32 0 no. of errors in run
RunfailReason nvarchar String 0 Reason for failure.
RunTime nvarchar String 0 Total time for run (shuttle time * number of records)
RunType nvarchar String 0 server/manual
SAPClient nvarchar String 0 SAP client number
SAPSystem nvarchar String 0 SAP system ID
SAPTCode nvarchar String 0 T-code
SAPUSer nvarchar String 0 Runner SAP user
ShuttleUploadTime nvarchar String 0 Time required to upload each record via Studio.
SolutionId uniqueidentifier Guid 0 This is the solution Id of the current document id. (i.e.Docid).
Tag nvarchar String 0 This is the Solution’s Category value of current document.
TimeSaved nvarchar String 0 ManualUploadTime - ShuttleUploadtime
TotalTimeSaved nvarchar String 0 (manual - shuttle time) * number of records
TransactionLogId int Int32 0 Unique log ID. This ID is sequential for maintaining the order of logs.
TxrTitle nvarchar String 0 Name of the transaction script file
UploadTime datetime DateTime 0 Date of upload. This is same as Activity time
UserId uniqueidentifier Guid 0 ID of Runner user
Username nvarchar String 0 User name of Runner user