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

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                                   WH20.7
Element: All Flag      This field indicates if the order
                       source code has been used.
                       Y = Yes
                       N = No

OSR-SRC-ACT-FL         Alpha 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                                                WH20.2  WH20.7
          ORDER-SOURCE

                         OESOURCE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oecompany      OECOMPANY    Required

                            OSR-COMPANY    -> OEC-COMPANY