Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            WFHISMSGHD FILE

                      Workflow Msg Header History

The Workflow Message Header History file contains the message headers for
complete work units. A message header record is combined with one or more
message detail records to create a complete message.

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

WFM-WORKUNIT         Numeric 12
Workunit             The work unit number assigned by the
                     Workflow Management system.

WFM-MESSAGE-ID       Alpha 10  (Lower Case)
Message Id           A user-defined title for this message.

WFM-ATTACH-DATE      Numeric 8  (yyyymmdd)
Attach Date          The date when the message was attached
                     to the work unit.

WFM-ATTACH-TIME      Numeric 6  (hhmmss)
Attach Time          The time when the message was attached
                     to the work unit.

WFM-ATTACH-BY        Alpha 30
Attach By            The user ID of the user who attached
                     the message to the work unit.

WFM-MESSAGE-NBR      Numeric 4
Message Nbr          A unique number assigned to the
                     message. Each record in the message will
                     have the same message
                     number.

WFM-DELETE-FL        Alpha 1
Delete Fl            This is a Boolean flag indicating
                     whether or not this message is hidden
                     from Inbasket. If the message
                     records still exist, the message can be
                     restored by resetting this flag.

WFM-CREATED-BY       Alpha 1
Created By           This indicates whether the variable is
                     a user or system variable.

                         WFHISMSGHD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WFMSET1   WORKUNIT
          MESSAGE-ID

                         WFHISMSGHD FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfhiswkuni     WFHISWKUNI   Required

                            WFM-WORKUNIT      -> WFI-WORKUNIT  (WFISET1)

                         WFHISMSGHD FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfhismsgd      WFHISMSGD

                            WFM-WORKUNIT      -> WMD-WORKUNIT
                            WFM-MESSAGE-ID    -> WMD-MESSAGE-ID
                                                 WMD-MESSAGE-SEQ