Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WFMSGHDR


                             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.

UPDATED BY

WF140     WF20.1    WF20.2    WF23.1    WF25.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

WFH-MESSAGE-ID         Alpha 10  (Lower Case)                    WF23.1
Element: 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)                     WF23.1
Element: Attach Date   The date when the message was attached
                       to the work unit.

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

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

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

WFH-DELETE-FL          Alpha 1                                   WF23.1
Element: Delete Fl     This field indicates that the message
                       has been deleted. If this field is
                       reset, the message is reattached to the
                       work unit.
                       N = No
                       Y = Yes

WFH-CREATED-BY         Alpha 1                                   WF23.1
Element: 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                                               WF140   WF20.1
          MESSAGE-ID                                             WF20.2  WF23.1
                                                                 WF25.1

                         WFMSGHDR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Workunit       WFWORKUNIT   Required

                            WFH-WORKUNIT      -> WFW-WORKUNIT

                         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