📚 SAP Business One SDK Help

Table Name: AWLS

Table Description: Workflow - Task Details - History

Field Description Type Size Related Default Value Constraints
WFInstID Workflow Instance ID Int 11 OWFI      
TaskID Task ID Int 11 -      
WFID Workflow ID nVarChar 64 -      
WFName Workflow Name nVarChar 100 -      
TaskDesc Task Description nVarChar 100 -      
ObjType Object Type nVarChar 20 -      
Operation Operation VarChar 1 -   A Add
            U Update
            D Delete
ObjKey Object Key nVarChar 100 -      
EnterDate Enter Date Date 8 -      
EnterTime Enter Time Int 6 -      
TaskType Task Type VarChar 1 -      
DueDate Due Date Date 8 -      
DueTime Due Time Int 6 -      
UpdateDate Update Date - History Date 8 -      
UpdateTime Update Time - History Int 6 -      
Owner Owner nVarChar 25 -      
Priority Priority Int 6 - 2 1 High
            2 Medium
            3 Low
UserSign User Signature Int 6 -      
Status Status VarChar 1 - W S Setup
            W To Be Picked
            P Picking
            G In Progress
            D Completing
            F Completed
            N Suspended
            C Cancelling
            Q Canceled
            O Forwarding
            E Error
LogIns Log Instance - History Int 11 -      
UserSign2 Updating User - History Int 6 -      
Deleted Deleted - History VarChar 1 -      
DuraDays Duration Days Int 11 -      
DuraHours Duration Hours Int 6 -      
TaskName Task Name nVarChar 100 -      
isPicked Is Picked VarChar 1 - N    
Attachment Attachment Text 16 -      
AtcEntry Attachment Entry Int 11 -      
WorkListId Worklist ID Int 11 -      
ObjSubType Object Subtype nVarChar 64 -      
ForwardTo User to Forward nVarChar 25 -      
WasRead Line Read VarChar 1 - N    
TrigParams Trigger Parameters Text 16 -      
Key Task ID in XML nVarChar 254 -      
Key Unique Field
PRIMARY Yes TaskID
    LogIns