Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WOIAPRDDIM


                            WOIAPRDDIM FILE

                        WO Data Mart Product Def

REFERENCED BY

WODL.1

UPDATED BY

WODM.5    WOPR.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WO4-PRODUCT-DIM        Alpha 50  (Lower Case)                    WODM.5
Element: Product Dim

WO4-MEMBER-PREFIX      Alpha 5  (Lower Case)                     WODM.5
Element: Member Prefix

WO4-ITEM-GROUP         Alpha 5                                   WODM.5
Element: Item Group    This field contains the identifier for
                       a group of items that can be shared by
                       one or more companies.

WO4-COMPANY            Numeric 4                                 WODM.5
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

WO4-FR-INV-LOC         Alpha 5                                   WODM.5
Element: Fr Inv Loc

WO4-TO-INV-LOC         Alpha 5                                   WODL.1  WODM.5
Element: To Inv Loc                                              WOPR.1

WO4-FROM-ITEM          Alpha 32                                  WODM.5
Element: From Item

WO4-TO-ITEM            Alpha 32                                  WODL.1  WODM.5
Element: To Item                                                 WOPR.1

WO4-LAST-MAINT-DT      Numeric 8  (yyyymmdd)                     WODM.5
Element: Date

WO4-LAST-MAINT-TM      Numeric 6  (hhmmss)                       WODM.5
Element: Sys Time

WO4-LAST-LOAD-DT       Numeric 8  (yyyymmdd)                     WOPR.1
Element: Last Load Dt

WO4-LAST-LOAD-TM       Numeric 6  (hhmmss)                       WOPR.1
Element: Last Load Tm

                         WOIAPRDDIM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WO4SET1   PRODUCT-DIM                                            WODL.1  WODM.1
                                                                 WODM.5  WOPR.1