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

SQL Administration / Potential Processor of Tasks

DTW Purchasing / Goods Return

API AWL1

AWL1 - Potential Processor of Tasks Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
WFInstID	Workflow Instance ID	Int		11
TaskID ^KEY ^UNIQUE	Task ID	Int		11	OWLS Workflow - Task Details		PRIMARY	Yes
LineID	Line ID	Int		6
Candidate	Candidate	nVarChar		127
LogIns	Log Instance	Int		11
WasRead	Was Read	VarChar	Y) Yes N) No	1		N
CandExpr	Candidate Expression	nVarChar		127

SELECT statement

SELECT
   AWL1.WFInstID AS 'Workflow Instance ID', 
   AWL1.TaskID AS 'Task ID', 
   AWL1.LineID AS 'Line ID', 
   AWL1.Candidate AS 'Candidate', 
   AWL1.LogIns AS 'Log Instance', 
   AWL1.WasRead AS 'Was Read', 
   AWL1.CandExpr AS 'Candidate Expression'
FROM AWL1 AS AWL1

Related information

OWLS SQL Table

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