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

OE81.1    OE90.1    TX00.1

UPDATED BY

BL120     BL122     BL130     BL20.1    BL20.3    BL21.2
BL21.5    BL29.1    BL29.2    BL520     BL820     BL92.1
OE10.1    OE10.2    OE10.3    OE10.4    OE10.5    OE10.6
OE10.7    OE10.8    OE11.1    OE11.4    OE11.8    OE11.9
OE110     OE111     OE113     OE114     OE116     OE129
OE13.2    OE13.3    OE13.5    OE13.6    OE14.4    OE30.1
OE30.2    OE30.3    OE30.4    OE30.5    OE30.6    OE30.7
OE30.9    OE310     OE510     OE530     OE810     OE830
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
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 OE30.2  OE30.3
                                                                 OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE510
                                                                 OE530   OE810
                                                                 OE830   WH20.7

OLU-ORDER-NBR          Numeric 8                                 BL120   BL122
Element: Order Number  This field contains the order number.     BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 OE30.2  OE30.3
                                                                 OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE510
                                                                 OE530   OE810
                                                                 OE830   WH20.7

OLU-LINE-NBR           Numeric 6                                 BL120   BL122
Element: Line Number   This field contains the line number.      BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 OE30.2  OE30.3
                                                                 OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE510
                                                                 OE530   OE810
                                                                 OE830   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
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 OE30.2  OE30.3
                                                                 OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE510
                                                                 OE530   OE810
                                                                 OE830   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
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 OE30.2  OE30.3
                                                                 OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE510
                                                                 OE530   OE810
                                                                 OE830   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
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 OE30.2  OE30.3
                                                                 OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE510
                                                                 OE530   OE810
                                                                 OE830   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
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 OE30.2  OE30.3
                                                                 OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE510
                                                                 OE530   OE810
                                                                 OE830   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
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 OE30.2  OE30.3
                                                                 OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE510
                                                                 OE530   OE810
                                                                 OE830   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
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 ...