Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WFFOLDER


                             WFFOLDER FILE

                            Workflow Folder

The Workflow Folder file describes Lawson application forms and report
documents that are associated with a Workflow Work Unit record. These forms
and report documents can be viewed in a procedure. For example, AP26.1
(Invoice Registration) can be viewed in the Invoice Approval procedure.

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WFF-WORKUNIT           Numeric 12
Element: Workunit      The work unit to which the folder is
                       associated.

WFF-WF-SEQ-NBR         Numeric 6
Element: Wf Seq Nbr

WFF-DOCUMENT-ID        Alpha 10  (Lower Case)
Element: Document Id   A simple identifier for the document.

WFF-FORM               Alpha 10
Element: Form          The Lawson application form that is
                       associated with the Workflow Folder file
                       record. Forms are defined on
                       WF02.1 (Form and Field Definition).

WFF-KEY-STRING         Alpha 70  (Lower Case)
Element: Key String    This is a string of key values
                       associated with the application form.

WFF-START-DATE         Numeric 8  (yyyymmdd)
Element: Start Date    The date that this form was attached to
                       the work unit.

WFF-START-TIME         Numeric 6  (hhmmss)
Element: Start Time    The time that this folder was attached
                       to the work unit.

WFF-WF-DESCRIPTION     Alpha 50  (Lower Case)
Element: Wf Description

WFF-WF-FILE-NAME       Alpha 30
Element: Wf File Name

WFF-DELETE-FL          Alpha 1
Element: Delete Fl     This is a Boolean field that indicates
                       that this file is hidden from Inbasket.
                       If the file still exists, it can be
                       restored by resetting the value of this
                       field.
                       N = No
                       Y = Yes

WFF-ATTACH-BY          Alpha 30  (Lower Case)
Element: Attach By     This field shows the user ID of the
                       user who attached the form to the work
                       unit.

                         WFFOLDER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WFFSET1   WORKUNIT
          WF-SEQ-NBR

WFFSET2   WORKUNIT      KeyChange
          DOCUMENT-ID
          WF-SEQ-NBR

                         WFFOLDER FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfworkunit     WFWORKUNIT   Required

                            WFF-WORKUNIT    -> WFW-WORKUNIT  (WFWSET1)