Lawson Insight Technical Documentation

                             OESOURCE FILE

                        Order Entry Order Source

The Order Entry Order Source file contains order source records set up in
OE52.1 (Order Source).  An order source indicates how a customer heard about
your company (advertisements, newspapers, and so on).

REFERENCED BY

OE252     OE53.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     OE129     OE13.2
OE13.3    OE13.5    OE14.4    OE30.1    OE30.2    OE30.3
OE30.4    OE30.5    OE30.6    OE30.7    OE30.9    OE510
OE52.1    OE530     OE810     OE830     WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OSR-COMPANY            Numeric 4                                 OE52.1
Element: Company       This field contains the company number.

OSR-ORDER-SOURCE       Alpha 2                                   OE52.1
Element: Order Source  This field contains the order source
                       code, which indicates how the customer
                       heard about your company.

OSR-SRC-DESC           Alpha 30  (Lower Case)                    OE52.1  OE53.1
Element: Description   This field contains the description of
                       the order source code.

OSR-SRC-USED-FL        Alpha 1                                   BL120   BL122
Element: All Flag      This field indicates if the order         BL130   BL20.1
                       source code has been used.                BL20.3  BL21.2
                       Y = Yes                                   BL21.5  BL29.1
                       N = No                                    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
                                                                 OE129   OE13.2
                                                                 OE13.3  OE13.5
                                                                 OE14.4  OE30.1
                                                                 OE30.2  OE30.3
                                                                 OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE510
                                                                 OE52.1  OE530
                                                                 OE810   OE830
                                                                 WH20.7

OSR-SRC-ACT-FL         Alpha 1                                   OE52.1
Element: Status        This field indicates if the order
                       source code is active.
                       A = Active
                       I = Inactive

                         OESOURCE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OSRSET1   COMPANY                                                BL120   BL122
          ORDER-SOURCE                                           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
                                                                 OE129   OE13.2
                                                                 ...

                         OESOURCE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oecompany      OECOMPANY    Required

                            OSR-COMPANY    -> OEC-COMPANY