Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


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

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

OSR-ORDER-SOURCE     Alpha 2
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)
Source Code          This field contains the description of
Description          the order source code.

OSR-SRC-USED-FL      Alpha 1
Source Code Used     This field indicates if the order
Flag                 source code has been used.
                     Y = Yes
                     N = No

OSR-SRC-ACT-FL       Alpha 1
Source Code Active   This field indicates if the order
Flag                 source code is active.
                     A = Active
                     I = Inactive

                         OESOURCE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OSRSET1   COMPANY
          ORDER-SOURCE

                         OESOURCE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oecompany      OECOMPANY    Required

                            OSR-COMPANY    -> OEC-COMPANY  (OECSET1)