biuan SAP® BUSINESS ONE SDK
SQL Administration / SWFQ History Table
API AWFQ
AWFQ - SWFQ History Table Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
SequenceID KEY UNIQUESequence IDInt
11
PRIMARYYes
SourceDBSource DatabasenVarChar
100
TimestampTime StampnVarChar
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
TaskIDTask IDnVarChar
64
TrigEvntIDTrigger Event IDnVarChar
64
TrigParamsTrigger ParametersText
16
LogInstLog InstanceInt
11
IsSuccessIs Message Handled SuccessfullyVarChar
1
ResultMemoMemo of the ResultnVarChar
127

SELECT statement

SELECT AWFQ.SequenceID AS 'Sequence ID', AWFQ.SourceDB AS 'Source Database', AWFQ.Timestamp AS 'Time Stamp', AWFQ.ObjectType AS 'Object Type', AWFQ.TransType AS 'Transaction Type', AWFQ.FieldsInKe AS 'Number of Fields in Key', AWFQ.FieldNames AS 'Key Field Names', AWFQ.FieldValue AS 'Key Field Values', AWFQ.UserID AS 'UserID', AWFQ.TaskID AS 'Task ID', AWFQ.TrigEvntID AS 'Trigger Event ID', AWFQ.TrigParams AS 'Trigger Parameters', AWFQ.LogInst AS 'Log Instance', AWFQ.IsSuccess AS 'Is Message Handled Successfully', AWFQ.ResultMemo AS 'Memo of the Result' FROM AWFQ AS AWFQ

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