Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OECOLUF


                              OECOLUF FILE

The Order Line User Fields file contains user fields that can be entered on
order lines.

REFERENCED BY

TX00.1

UPDATED BY

BL120     BL122     BL130     BL20.1    BL20.3    BL21.2
BL21.5    BL29.1    BL29.2    BL520     BL820     BL92.1
WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OLU-COMPANY            Numeric 4                                 BL120   BL122
Element: Company       Identifies the AP company if the          BL130   BL20.1
                       resource type = V.  Identifies the HR     BL20.3  BL21.2
                       company if the resource type = E.  It is  BL21.5  BL29.1
                       blank for type A, P or Q resources.       BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OLU-ORDER-NBR          Numeric 8                                 BL120   BL122
Element: Order Nbr     This field contains the order number.     BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OLU-LINE-NBR           Numeric 6                                 BL120   BL122
Element: Line Nbr      This field contains the line number.      BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OLU-COL-USR-FLD-01     Alpha 20                                  BL120   BL122
Element: Col Usr Fld 01Order line user field 1.                  BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OLU-COL-USR-FLD-02     Alpha 20                                  BL120   BL122
Element: Col Usr Fld 02Order line user field 2.                  BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OLU-COL-USR-FLD-03     Alpha 20                                  BL120   BL122
Element: Col Usr Fld 03Order line user field 3.                  BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OLU-COL-USR-FLD-04     Alpha 20                                  BL120   BL122
Element: Col Usr Fld 04Order line user field 4.                  BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

OLU-COL-USR-FLD-05     Alpha 20                                  BL120   BL122
Element: Col Usr Fld 05Order line user field 5.                  BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

                         OECOLUF FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OLUSET1   COMPANY                                                BL120   BL122
          ORDER-NBR                                              BL130   BL20.1
          LINE-NBR                                               BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 TX00.1  WH20.2
                                                                 WH20.7