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

SQL Administration / Workflow Manager

API AWMG

SBO SQL database table details

Field	Description	Type	Constraints	Size	Default	Primary_Key	Unique
ID ^KEY ^UNIQUE	Workflow ID	Int		11		PRIMARY	Yes
TemplateID	Template ID	Int		11
TmplateKey	Template Key	nVarChar		64
Name	Name	nVarChar		100
Version	Version	nVarChar		13
MAXIns	Maximum Number of Instances	Int		11
Status	Status	VarChar	I) Inactive A) Active M) Importing P) Imported F) Import failed	1	I
XMLFile	XML File	Text		16
Desc	Description	Text		16
LogIns	Log Instance - History	Int		11
StartType	Start Type	VarChar	M) Manual Start T) Timer Start C) Conditional Start	1	M

SELECT statement

SELECT
   AWMG.ID AS 'Workflow ID', 
   AWMG.TemplateID AS 'Template ID', 
   AWMG.TmplateKey AS 'Template Key', 
   AWMG.Name AS 'Name', 
   AWMG.Version AS 'Version', 
   AWMG.MAXIns AS 'Maximum Number of Instances', 
   AWMG.Status AS 'Status', 
   AWMG.XMLFile AS 'XML File', 
   AWMG.Desc AS 'Description', 
   AWMG.LogIns AS 'Log Instance - History', 
   AWMG.StartType AS 'Start Type'
FROM AWMG AS AWMG

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