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
Id uniqueidentifier Guid 0 Unique ID for this table /view
LogId uniqueidentifier Guid 0 Id of ROI log. ID is created for each entry in the log
TxrTitle nvarchar String 0 Name of the transaction script file
DataFile nvarchar String 0 Name of the data file file
ActivityDateTime datetime DateTime 0 Date of Run
SAPSystem nvarchar String 0 SAP system ID
SAPUSer nvarchar String 0 Runner SAP user
SAPClient nvarchar String 0 SAP client number
RecordsUploaded int Int32 0 no. of records uploaded
RunErrors int Int32 0 no. of errors in run
UploadTime datetime DateTime 0 Date of upload. This is same as Activity time
ReasonForRun nvarchar String 0 Reason for run
ManualUploadTime nvarchar String 0 Time required to upload each record manually via sap
ShuttleUploadTime nvarchar String 0 Time required to upload each record via Studio.
TimeSaved nvarchar String 0 ManualUploadTime - ShuttleUploadtime
TotalTimeSaved nvarchar String 0 (manual - shuttle time) * number of records
RecordingMode nvarchar String 0 Mode selected while recording the script. For example, batch, non batch.
SAPTCode nvarchar String 0 T-code
RunfailReason nvarchar String 0 Reason for failure.
RunTime nvarchar String 0 Total time for run (shuttle time * number of records)
Username nvarchar String 0 User name of Runner user
CustomerId uniqueidentifier Guid 0 Connect customer ID
CustomerName nvarchar String 0 Connect customer name
CRMCustomerId nvarchar String 0 Connect CRM customer ID
Product nvarchar String 0 Transaction/Query. In this case transaction.
ClientProduct nvarchar String 0 Studio/Integration Server. Here Integration Server means run by Worker
ProductVersion nvarchar String 0 Version of Studio/Integration Server (Worker) eg. 20.0
License nvarchar String 0 License used for run
CRMLicenseId nvarchar String 0 Connect CRM license ID
RunType nvarchar String 0 server/manual
ReferenceId uniqueidentifier Guid 0 ID of app in which transaction was run
IsLogSync bit Boolean 0 Indicated if log have been synced to connect
TransactionLogId int Int32 0 Unique log ID. This ID is sequential for maintaining the order of logs.
ProductName nvarchar String 0 Product name of license used for run
UserId uniqueidentifier Guid 0 ID of Runner user
AppId uniqueidentifier Guid 0 ID of app in which transaction was run