AWFQ - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL

Administration /

SWFQ History Table

API AWFQ

AWFQ - SWFQ History Table Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Primary_Key	Unique
SequenceID ^KEY ^UNIQUE	Sequence ID	Int		11	PRIMARY	Yes
SourceDB	Source Database	nVarChar		100
Timestamp	Time Stamp	nVarChar		20
ObjectType	Object Type	nVarChar		30
TransType	Transaction Type	VarChar	A) Add U) Update C) Cancel D) Delete	1
FieldsInKe	Number of Fields in Key	Int		11
FieldNames	Key Field Names	nVarChar		127
FieldValue	Key Field Values	nVarChar		127
UserID	UserID	nVarChar		8
TaskID	Task ID	nVarChar		64
TrigEvntID	Trigger Event ID	nVarChar		64
TrigParams	Trigger Parameters	Text		16
LogInst	Log Instance	Int		11
IsSuccess	Is Message Handled Successfully	VarChar		1
ResultMemo	Memo of the Result	nVarChar		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

biuan SAP® BUSINESS ONE

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