Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WFPROCLOG


                             WFPROCLOG FILE

UPDATED BY

WF45.1    WF140     WF20.1    WF20.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WPL-WORKUNIT           Numeric 12                                WF45.1
Element: Workunit

WPL-PROCESS-ID         Numeric 12                                WF45.1
Element: Process Id

WPL-SEQ-NBR            Numeric 6                                 WF45.1
Element: Seq Nbr

WPL-ACTIVITY-ID        Alpha 20  (Lower Case)                    WF45.1
Element: Activity Id

WPL-MESSAGE-TYPE       Alpha 1                                   WF45.1
Element: Message Type  E = Error
                       L = Log

WPL-MESSAGE            Alpha 60  (Lower Case)                    WF45.1
Element: Message

                         WFPROCLOG FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WPLSET1   WORKUNIT                                               WF140   WF20.1
          PROCESS-ID                                             WF20.2  WF45.1
          SEQ-NBR

WPLSET2   WORKUNIT      KeyChange                                WF45.1
          PROCESS-ID
          ACTIVITY-ID
          MESSAGE-TYPE
          SEQ-NBR

                         WFPROCLOG FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfactivity     WFACTIVITY   Not Required

                            WPL-WORKUNIT       -> WAC-WORKUNIT
                            WPL-PROCESS-ID     -> WAC-PROCESS-ID
                            WPL-ACTIVITY-ID    -> WAC-ACTIVITY-ID

Wfproctran     WFPROCTRAN   Required

                            WPL-WORKUNIT       -> WPT-WORKUNIT
                            WPL-PROCESS-ID     -> WPT-PROCESS-ID

Wfworkunit     WFWORKUNIT   Required

                            WPL-WORKUNIT       -> WFW-WORKUNIT