|
|
SQL Administration / Notes of Tasks
DTW Purchasing / AP Down Payment
API Workflow Task Note Collection / Workflow Task Note
WLS3 - Notes of Tasks Table
Workflow Task Note WorkflowTaskNote Object· Table: WLS3
Parent: Workflow Task Note Collection WorkflowTaskNoteCollection Collection
Workflow - Task Details OWLS SQL 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 | 11 | |||||
| Note | Note | Text | 16 | |||||
| Creator | Creator | nVarChar | 8 | |||||
| NoteDate | Note Date | Date | 8 | |||||
| Access | Accessibility | VarChar | W) Workflow T) Task | 1 | W | |||
| LogIns | Log Instance | Int | 11 |
SELECT statement
SELECT
WLS3.WFInstID AS 'Workflow Instance ID',
WLS3.TaskID AS 'Task ID',
WLS3.LineID AS 'Line ID',
WLS3.Note AS 'Note',
WLS3.Creator AS 'Creator',
WLS3.NoteDate AS 'Note Date',
WLS3.Access AS 'Accessibility',
WLS3.LogIns AS 'Log Instance'
FROM WLS3 AS WLS3
Related information
Workflow Task Note WorkflowTaskNote Object· Table: WLS3
WorkflowTaskNote is a data object holding properties for the workflow task note.
Source table: WLS3
Parent: Workflow Task Note Collection WorkflowTaskNoteCollection CollectionWorkflow - Task Details OWLS SQL Table
WorkflowTaskNoteCollection
Object
WorkflowTaskNote
Method
Property
Creator
DB
LineId
DB
Note
DB
NoteDate
DB
TaskID
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates