Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OESOURCE


                             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).

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

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

OSR-ORDER-SOURCE       Alpha 2
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)
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
                                                                 WH20.7

OSR-SRC-ACT-FL         Alpha 1
Element: Active Flag   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
                                                                 WH20.2  WH20.7

                         OESOURCE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oecompany      OECOMPANY    Required

                            OSR-COMPANY    -> OEC-COMPANY