Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WFSERVCRIT


                            WFSERVCRIT FILE

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WSC-SERVICE            Alpha 15  (Lower Case)
Element: Service

WSC-PRODUCT            Alpha 14
Element: Product

WSC-DATA-AREA          Alpha 14
Element: Data Area

WSC-CRITERION-1        Alpha 30  (Lower Case)
Element: Criterion 1

WSC-CRITERION-2        Alpha 30  (Lower Case)
Element: Criterion 2

WSC-CRITERION-3        Alpha 30  (Lower Case)
Element: Criterion 3

WSC-WF-STATUS          Numeric 2
Element: Wf Status

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

                         WFSERVCRIT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WSCSET1   SERVICE
          PRODUCT
          DATA-AREA
          CRITERION-1
          CRITERION-2
          CRITERION-3

                         WFSERVCRIT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfservice      WFSERVICE    Required

                            WSC-SERVICE        -> WFS-SERVICE  (WFSSET1)
                            Spaces             -> WFS-PRODUCT
                            Spaces             -> WFS-DATA-AREA

                         WFSERVCRIT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfservproc     WFSERVPROC   Delete Cascades

                            WSC-SERVICE        -> WVP-SERVICE
                            WSC-PRODUCT        -> WVP-PRODUCT
                            WSC-DATA-AREA      -> WVP-DATA-AREA
                            WSC-CRITERION-1    -> WVP-CRITERION-1
                            WSC-CRITERION-2    -> WVP-CRITERION-2
                            WSC-CRITERION-3    -> WVP-CRITERION-3
                                                  WVP-PROCESS-NAME