Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WFHISMSGHD


                            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
Element: Workunit      The work unit number assigned by the
                       Workflow Management system.

WFM-WF-MESSAGE-ID      Alpha 10  (Lower Case)
Element: Wf Message Id

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

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

WFM-ATTACH-BY          Alpha 30  (Lower Case)
Element: Attach By     The user ID of the user who attached
                       the message to the work unit.

WFM-MESSAGE-NBR        Numeric 4
Element: 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
Element: 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.
                       N = No
                       Y = Yes

WFM-CREATED-BY         Alpha 1
Element: 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
          WF-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-WF-MESSAGE-ID    -> WMD-WF-MESSAGE-ID
                                                    WMD-MESSAGE-SEQ