Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WFMETSUM


                             WFMETSUM FILE

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WMS-WORKUNIT           Numeric 12
Element: Workunit

WMS-PROCESS-ID         Numeric 12
Element: Process Id

WMS-ACTIVITY-ID        Alpha 20  (Lower Case)
Element: Activity Id

WMS-START-DATE         Numeric 8  (yyyymmdd)
Element: Start Date

WMS-START-TIME         Numeric 6  (hhmmss)
Element: Start Time

WMS-END-DATE           Numeric 8  (yyyymmdd)
Element: Ending Date   The ending date in a range of dates.

WMS-END-TIME           Numeric 6  (hhmmss)
Element: End Time

WMS-ACTIVITY-NAME      Alpha 20  (Lower Case)
Element: Activity Name

WMS-NODE-CAPTION       Alpha 60  (Lower Case)
Element: Node Caption

WMS-ACTIVITY-TYPE      Alpha 10
Element: Activity Type

WMS-PRO-LOGIC-TYPE     Numeric 2
Element: Pro Logic Type

WMS-ACTION-TAKEN       Alpha 30  (Lower Case)
Element: Action Taken

WMS-WF-RM-ID           Alpha 80  (Lower Case)
Element: Wf Rm Id

WMS-TASK               Alpha 20  (Lower Case)
Element: Task

                         WFMETSUM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WMSSET1   WORKUNIT
          PROCESS-ID
          ACTIVITY-ID

WMSSET2   WORKUNIT
          END-DATE
          END-TIME
          PROCESS-ID
          ACTIVITY-ID

WMSSET3   END-DATE
          END-TIME
          WORKUNIT
          PROCESS-ID
          ACTIVITY-ID

WMSSET4   WORKUNIT
          START-DATE
          START-TIME
          PROCESS-ID
          ACTIVITY-ID

WMSSET5   START-DATE
          START-TIME
          WORKUNIT
          PROCESS-ID
          ACTIVITY-ID