Chapter 15: Field and Table Reference
Chapter Objectives:
Complete reference of all workflow table fields
Quick lookup of field numbers and types
Understanding field relationships
Quick reference cards for common tasks
15.1. Workflow Setup Fields (Table 72777600)
Complete Field List:
Field No.
Field Caption
Type
Description
1
No.
Code[20]
Unique workflow identifier
2
Description
Text[100]
Business description of workflow
10
Table No.
Integer
Source table for trigger (e.g., 18 = Customer)
11
Table Caption
Text
Auto-populated from Table No.
20
Start Date
Date
When workflow becomes active
21
End Date
Date
When workflow becomes inactive
30
Enabled
Boolean
Must be TRUE for workflow to trigger
40
Recurring Frequency
Option
Future use: Monthly, Quarterly, Annually
50
Created by User
Code[50]
User who created workflow
51
Created DateTime
DateTime
When workflow was created
52
Modified by User
Code[50]
User who last modified workflow
53
Modified DateTime
DateTime
When workflow was last modified
| | | | |
|---|---|---|---|
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
Key Relationships:
Workflow Setup (72777600)
Workflow Task (72777601) [Workflow No.]
Status Rules (72777603) [Workflow No., Code]
Precedance (72777604) [Workflow No., Workflow Task Code]
Initiated By (72777602) [Workflow No.]
WorkFlow Entries (72777606) [Workflow No.]15.2. Workflow Task Fields (Table 72777601)
Complete Field List:
Field No.
Field Caption
Type
Description
1
Workflow No.
Code[20]
Parent workflow (FK to 72777600)
2
Code
Code[20]
Unique task identifier within workflow
3
Description
Text[100]
User-visible task description (supports placeholders)
10
Status
Option
Initial status: Open, Released
11
Assigned to
Code[50]
User ID (supports placeholders)
12
Assigned to Team
Code[20]
Team code (FK to 72777607)
20
Due Date
Text[100]
Due date formula (supports placeholders)
21
Critical Date
Text[100]
Escalation date formula (supports placeholders)
30
Activity Type
Option
Manual, Conditional, Interaction, Job Queue, Approval Workflow
31
Template Code
Code[10]
Interaction template (for Activity Type = Interaction)
32
Contact No.
Text[100]
Contact for interaction (supports placeholders)
40
Rule
Code[20]
Validation Set ID for trigger/status rules
41
Rule Line No.
Integer
Primary rule line reference
50
Line No.
Integer
Display order in task list
| | | | |
|---|---|---|---|
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
Field Usage Notes:
Description (Field 3):
Supports placeholders:
Example: "Review customer [18:2]
Assigned to (Field 11):
Supports placeholders:
Can be:
- Fixed user ID: JSMITH
- Field placeholder: [18:29] (Salesperson Code)
- Email lookup: [18:102]
Assigned to Team (Field 12):
Due Date (Field 20):
Supports placeholders:
Can be:
- Fixed date: 2024-12-31
- Field placeholder: [18:54] (Customer Due Date)
- Date formula: [18:54]+30D
- TODAY-based: [TODAY]
Critical Date (Field 21):
Contact No. (Field 32):
Supports placeholders:
Required when Activity Type = Interaction
Example: [18:5050]
15.3. Workflow Entries Fields (Table 72777606)
Complete Field List:
Field No.
Field Caption
Type
Description
1
Entry No.
Integer
Unique entry identifier (auto-increment)
2
Detailed Entry No.
Integer
Sub-entry within workflow instance
3
Workflow No.
Code[20]
Workflow identifier (FK to 72777600)
4
Workflow Step Code
Code[20]
Task code (FK to 72777601.Code)
5
Table ID
Integer
Source table number
6
Record ID
RecordID
Source record identifier
7
Source Primary Key Value
Text[250]
Source record key (text format)
10
Status
Option
Open, Released, Completed, Cancelled
11
Assigned to
Code[50]
Resolved user ID
12
Assigned to Team
Code[20]
Team code (if team-assigned)
13
Due Date
Date
Resolved due date
14
Critical Date
Date
Resolved critical date
15
Released at
DateTime
When task became Released
16
Completed at
DateTime
When task became Completed
20
Activity Type
Option
Manual, Conditional, Interaction, Job Queue, Approval Workflow
21
Closed
Boolean
TRUE when Status = Completed or Cancelled
22
Template Code
Code[10]
Interaction template
23
Contact No.
Code[20]
Resolved contact number
30
Description
Text[250]
Resolved task description
40
Created by Rule ID
Code[20]
Validation Set that triggered workflow
41
Created by Rule Line No.
Integer
Validation line that triggered
42
Task Rule
Code[20]
Validation Set for task status rules
43
Task Rule Line No.
Integer
Current status rule executing
| | | | |
|---|---|---|---|
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
Placeholder Resolution:
Task Configuration:
Description: "Follow up with [18:2]"
Assigned to: [18:29]
Due Date: [18:54]
15.4. Other Workflow Tables
Table 72777602: QUA Initiated By
Purpose: Define workflow trigger conditions.
Field No.
Field Caption
Type
Description
1
Workflow No.
Code[20]
Parent workflow
2
Trigger
Option
OnInsert, OnModify, OnDelete, OnRename
3
Table No.
Integer
Table being monitored
4
Table Field No.
Integer
Specific field to monitor (if OnModify)
10
Rule
Code[20]
Validation Set ID for conditions
11
Rule Line No.
Integer
Validation line reference
| | | | |
|---|---|---|---|
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
Table 72777603: QUA Status
Purpose: Define task status rules (release/completion conditions, custom rules).
Field No.
Field Caption
Type
Description
1
Workflow No.
Code[20]
Parent workflow
2
Code
Code[20]
Task code
3
Line No.
Integer
Rule line number (9999, 10000, 10001+)
10
Active
Boolean
Must be TRUE for rule to execute
11
Description
Text[100]
Rule description
20
Field No.
Integer
Field to modify (if custom rule)
21
Value
Text[250]
Value to set (if custom rule)
30
Rule
Code[20]
Validation Set ID
31
Rule Line No.
Integer
Validation line reference
| | | | |
|---|---|---|---|
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
Special Line Numbers:
Table 72777604: QUA Precedance
Purpose: Define task dependencies (prerequisites).
Field No.
Field Caption
Type
Description
1
Workflow No.
Code[20]
Parent workflow
2
Line No.
Integer
Precedence rule line
3
Workflow Task Code
Code[20]
Current task (has prerequisites)
4
Step Code
Code[20]
Prerequisite task code
5
Status
Option
Required status of prerequisite
10
Description
Text[100]
Dependency description
| | | | |
|---|---|---|---|
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
Usage: May require custom implementation - verify enforcement logic.
Table 72777607: QUA Business Teams
Purpose: Define teams for task assignment.
Field No.
Field Caption
Type
Description
1
Code
Code[20]
Unique team identifier
2
Description
Text[100]
Team description
10
Default Assigned to
Code[50]
Default user for team tasks
| | | | |
|---|---|---|---|
| | | | |
| | | | |
| | | | |
Table 72777608: QUA Business Team Members
Purpose: Define team membership.
Field No.
Field Caption
Type
Description
1
Team Code
Code[20]
Parent team (FK to 72777607)
2
User ID
Code[50]
Team member User ID
10
Role
Text[50]
Member role (informational)
| | | | |
|---|---|---|---|
| | | | |
| | | | |
| | | | |
15.5. Quick Reference Cards
Placeholder Syntax Reference
Basic Format: [TableNo:FieldNo]
Finding Table/Field Numbers:
Method 1: FactBox (Design mode ON)
Method 2: Table Information page (search "Table Information")
Method 3: Common tables reference (see below)
Common Tables:
18: Customer
23: Vendor
27: Item
36: Sales Header
37: Sales Line
38: Purchase Header
39: Purchase Line
5050: Contact
Common Customer Fields:
[18:2]: Name
[18:29]: Salesperson Code
[18:54]: Due Date
[18:102]: E-Mail
[18:5050]: Primary Contact No.
[18:5700]: Credit Limit (LCY)
[18:5702]: Balance (LCY)
Common Sales Header Fields:
[36:2]: Sell-to Customer No.
[36:3]: No. (Order No.)
[36:29]: Salesperson Code
[36:5052]: Sell-to Contact
[36:5792]: Order Date
[36:5900]
Date Formula Quick Reference
Simple Offsets:
+30D 30 days from base
-7D 7 days before base
+1W 1 week from base
+2M 2 months from base
+1Y 1 year from base
Period End:
CW Current week end (Sunday)
CM Current month end (last day of month)
CQ Current quarter end (Mar 31, Jun 30, Sep 30, Dec 31)
CY Current year end (Dec 31)
Complex Formulas:
+1M+5D 1 month + 5 days from base
+2W-1D 2 weeks - 1 day from base
CM+7D Month end + 7 days
Work Days:
+5WD 5 working days from base (excludes weekends)
-3WD 3 working days before base
Date Formula in Placeholder:
[18:54]+30D Customer Due Date + 30 days
[36:5792]+7D Order Date + 7 days
[TODAY]
Activity Type Decision Tree
Common Configuration Pitfalls
Pitfall 1: Placeholder in Wrong Field
Assigned to Team: [18:29]
Assigned to: [18:29]
Pitfall 2: Missing Brackets
18:102
[18:102]
Pitfall 3: Type Mismatch
Contact No.: [18:5700] (Credit Limit - Decimal)
Contact No.: [18:5050] (Primary Contact - Code)
Pitfall 4: Date Formula Without Base
+30D (in Due Date field with no placeholder)
[18:54]+30D
[TODAY]
