biuan SAP® BUSINESS ONE SDK
API SWFQ
SWFQ - SWFQ Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
SequenceID KEY UNIQUESequence IDInt
11
PRIMARYYes
SourceDBSource DBnVarChar
100
TimestampTimestampnVarChar
20
ObjectTypeObject TypenVarChar
30
TransTypeTransaction TypeVarChar
A) Add
U) Update
C) Cancel
D) Delete
1
FieldsInKeNumber of fields in keyInt
11
FieldNamesKey Field NamesnVarChar
127
FieldValueKey Field ValuesnVarChar
127
UserIDUserIDnVarChar
8
TaskIDTaskIDnVarChar
64
TrigEvntIDTrigger Event IDnVarChar
64
TrigParamsTrigger parametersText
16

SELECT statement

SELECT SWFQ.SequenceID AS 'Sequence ID', SWFQ.SourceDB AS 'Source DB', SWFQ.Timestamp AS 'Timestamp', SWFQ.ObjectType AS 'Object Type', SWFQ.TransType AS 'Transaction Type', SWFQ.FieldsInKe AS 'Number of fields in key', SWFQ.FieldNames AS 'Key Field Names', SWFQ.FieldValue AS 'Key Field Values', SWFQ.UserID AS 'UserID', SWFQ.TaskID AS 'TaskID', SWFQ.TrigEvntID AS 'Trigger Event ID', SWFQ.TrigParams AS 'Trigger parameters' FROM SWFQ AS SWFQ

Related information




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