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

API SWFQ

SBO SQL database table details

Field	Description	Type	Constraints	Size	Primary_Key	Unique
SequenceID ^KEY ^UNIQUE	Sequence ID	Int		11	PRIMARY	Yes
SourceDB	Source DB	nVarChar		100
Timestamp	Timestamp	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	TaskID	nVarChar		64
TrigEvntID	Trigger Event ID	nVarChar		64
TrigParams	Trigger parameters	Text		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

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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates