Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WFWUQUEDTL


                            WFWUQUEDTL FILE

UPDATED BY

WF47.1    WF140     WF20.1    WF20.2    WF46.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WQD-WORKUNIT           Numeric 12                                WF47.1
Element: Workunit

WQD-PROCESS-ID         Numeric 12                                WF47.1
Element: Process Id

WQD-ACTIVITY-ID        Alpha 20  (Lower Case)                    WF47.1
Element: Activity Id

WQD-VAR-TYPE           Alpha 10  (Lower Case)                    WF47.1
Element: Var Type

WQD-VARIABLE-NAME      Alpha 20  (Lower Case)                    WF47.1
Element: Variable Name

WQD-VARIABLE-VALUE     Alpha 60  (Lower Case)                    WF47.1
Element: Variable Value

                         WFWUQUEDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WQDSET1   WORKUNIT                                               WF140   WF20.1
          PROCESS-ID                                             WF20.2  WF46.1
          ACTIVITY-ID                                            WF47.1
          VAR-TYPE
          VARIABLE-NAME

                         WFWUQUEDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfworkunit     WFWORKUNIT   Required

                            WQD-WORKUNIT       -> WFW-WORKUNIT

Wfwuqueue      WFWUQUEUE    Required

                            WQD-WORKUNIT       -> WWQ-WORKUNIT
                            WQD-PROCESS-ID     -> WWQ-PROCESS-ID
                            WQD-ACTIVITY-ID    -> WWQ-ACTIVITY-ID