Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             WFMSGHDR FILE

                        Workflow Message Header

The Workflow Message Header file contains header information for a message
attached to a work unit. This includes the date and time it was attached and
the user who attached it. This file is associated with one or more Message
Detail file records. The Message Detail file records contain the body of the
message.

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

WFH-WORKUNIT         Numeric 12
Workunit             The work unit to which the message is
                     attached.

WFH-MESSAGE-ID       Alpha 10  (Lower Case)
Message Id           A unique identifier for this message.
                     This Message ID associates the message
                     header record with the
                     message detail records.

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

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

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

WFH-MESSAGE-NBR      Numeric 4
Message Nbr          A sequential number assigned to each
                     message. This ensures that each message
                     is unique.

WFH-DELETE-FL        Alpha 1
Delete Fl            This field indicates that the message
                     has been deleted. If this field is
                     reset, the message is reattached to the
                     work unit.

WFH-CREATED-BY       Alpha 1
Created By           The user ID of the user who added the
                     message to the work unit.

                         WFMSGHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WFHSET1   WORKUNIT
          MESSAGE-ID

                         WFMSGHDR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Workunit       WFWORKUNIT   Required

                            WFH-WORKUNIT      -> WFW-WORKUNIT  (WFWSET1)

                         WFMSGHDR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Messagedtl     WFMSGDTL

                            WFH-WORKUNIT      -> WDT-WORKUNIT
                            WFH-MESSAGE-ID    -> WDT-MESSAGE-ID
                                                 WDT-MESSAGE-SEQ