biuan SAP® BUSINESS ONE SDK
SQL Others / SEVT
API SEVT
SEVT - SEVT Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
SequenceID KEY UNIQUESequence IDIdentity
11
PRIMARYYes
SourceDB KEYEvent source databasenVarChar
100
SOURCE_DBNo
TimestampEvent timestampnVarChar
20
StatusEvent statusnVarChar
50
RetrySending event retriesInt
11
ObjectTypeObject typenVarChar
30
TransTypeTransaction typeVarChar
1
FieldsInKeNumber of fields in keyInt
11
FieldNamesNames of key fieldsnVarChar
127
FieldValueValues of key fieldsnVarChar
127
UserIDModified by usernVarChar
127
USER_CODEUser codenVarChar
8

SELECT statement

SELECT SEVT.SequenceID AS 'Sequence ID', SEVT.SourceDB AS 'Event source database', SEVT.Timestamp AS 'Event timestamp', SEVT.Status AS 'Event status', SEVT.Retry AS 'Sending event retries', SEVT.ObjectType AS 'Object type', SEVT.TransType AS 'Transaction type', SEVT.FieldsInKe AS 'Number of fields in key', SEVT.FieldNames AS 'Names of key fields', SEVT.FieldValue AS 'Values of key fields', SEVT.UserID AS 'Modified by user', SEVT.USER_CODE AS 'User code' FROM SEVT AS SEVT

Related information
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates