Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WFSRVVAR


                             WFSRVVAR FILE

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

WSV-PRODUCT            Alpha 14
Element: Product

WSV-DATA-AREA          Alpha 14
Element: Data Area

WSV-VARIABLE-NAME      Alpha 20  (Lower Case)
Element: Variable Name

WSV-VARIABLE-TYPE      Alpha 1
Element: Variable Type A = Numeric
                       N

WSV-VARIABLE-SIZE      Numeric 2
Element: Variable Size

WSV-KEY-FIELD          Alpha 1
Element: Key Field     Y = Yes
                       N = No

                         WFSRVVAR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WSVSET1   SERVICE
          PRODUCT
          DATA-AREA
          VARIABLE-NAME

WSVSET2   SERVICE       KeyChange
          PRODUCT
          DATA-AREA
          KEY-FIELD
          VARIABLE-NAME

                         WFSRVVAR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfservice      WFSERVICE    Required

                            WSV-SERVICE      -> WFS-SERVICE  (WFSSET1)
                            WSV-PRODUCT      -> WFS-PRODUCT
                            WSV-DATA-AREA    -> WFS-DATA-AREA