Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             OPERATOR FILE

                                Operator

The Operator file stores operator or user ID records.  A person entering an
order must have a user ID.  The user ID also has a number of defaults that are
found in this file.

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

OPE-DEF-COMPANY      Numeric 4
Default Company for  This field contains the default company
Operator             number.

OPE-OPR-CODE         Alpha 10  (Lower Case)
Operator Code        This field contains the user ID.  The
                     user ID defaults from the sign on of the
                     person who has the authority to add and
                     change orders.  The Lawson Order Entry
                     system ensures the user has the
                     authority by checking the default sign
                     on against the user IDs defined in
                     OE53.1 (User ID).

OPE-NAME             Alpha 30  (Lower Case)
Name                 Displays the company description.

OPE-DEF-PROC-LEV     Alpha 5
Default Process      This field contains the process level
Level for Opr        associated with the user ID.

OPE-DEF-CUSTOMER     Alpha 9  (Right Justified)
Default Customer     This field contains the customer number
for Operator         associated with the user ID.

OPE-DEF-LOCATION     Alpha 5
Default Location     This field contains the inventory
for Operator         location associated with the user ID.

OPE-DEF-ORDER-TYP    Alpha 2
Default Order Type   This field contains the order type
for Opr              associated with the user ID.

OPE-DEF-ORDER-SRC    Alpha 2
Default Order        This field contains the order source
Source For Opr       associated with the user ID.

OPE-DEF-RESTR-FL     Alpha 1
Restricted to        This field indicates whether the person
Defaults Flag        associated with the user ID is
                     restricted to the defaults of OE53.1
                     (User ID).
                     N = No
                     Y = Yes

OPE-LOC-TRANS-FL     Alpha 1
Loc Trans Fl         This field indicates if the person
                     associated with this user ID is
                     authorized to take inventory other than
                     from the default inventory location.
                     N = No
                     Y = Yes

OPE-CURR-OVR-FL      Alpha 1
Curr Ovr Fl          This field indicates whether the person
                     associated with this user ID is
                     authorized to override the currency
                     information that defaults onto orders.
                     Y = Yes
                     N = No

OPE-RATE-OVR-FL      Alpha 1
Rate Ovr Fl          This field indicates the person
                     associated with the user ID is
                     authorized to override the currency
                     conversion rate that defaults onto
                     orders.
                     Y = Yes
                     N = No

                         OPERATOR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OPESET1   OPR-CODE
          DEF-COMPANY

OPESET2   DEF-COMPANY
          OPR-CODE

                         OPERATOR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required
                            When OPE-DEF-COMPANY != Zeroes

                            OPE-DEF-COMPANY      -> ACO-COMPANY

Arcustgrp      ARCUSTGRP    Required
                            When OPE-DEF-CUSTOMER != Spaces

                            ACO-CUST-GROUP       -> ACG-CUST-GROUP

Arcustomer     ARCUSTOMER   Required
                            When OPE-DEF-CUSTOMER != Spaces

                            OPE-DEF-COMPANY      -> ACM-COMPANY
                            OPE-DEF-CUSTOMER     -> ACM-CUSTOMER

Custdesc       CUSTDESC     Required
                            When OPE-DEF-CUSTOMER != Spaces

                            ACO-CUST-GROUP       -> CUD-CUST-GROUP
                            OPE-DEF-CUSTOMER     -> CUD-CUSTOMER

Icloc          ICLOCATION   Required
                            When OPE-DEF-LOCATION != Spaces

                            OPE-DEF-COMPANY      -> ICL-COMPANY
                            OPE-DEF-LOCATION     -> ICL-LOCATION

Oecompany      OECOMPANY    Required

                            OPE-DEF-COMPANY      -> OEC-COMPANY

Oeproclev      OEPROCLEV    Required
                            When OPE-DEF-PROC-LEV != Spaces

                            OPE-DEF-COMPANY      -> OEP-COMPANY
                            OPE-DEF-PROC-LEV     -> OEP-PROCESS-LEVEL

Order Source   OESOURCE     Required
                            When OPE-DEF-ORDER-SRC != Spaces

                            OPE-DEF-COMPANY      -> OSR-COMPANY
                            OPE-DEF-ORDER-SRC    -> OSR-ORDER-SOURCE

Ordertype      ORDERTYPE    Required
                            When OPE-DEF-ORDER-TYP != Spaces

                            OPE-DEF-COMPANY      -> OTP-COMPANY
                            OPE-DEF-ORDER-TYP    -> OTP-ORDER-TYPE

                         OPERATOR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Custorder      CUSTORDER    Delete Restricted

                            OPE-DEF-COMPANY      -> COR-COMPANY
                            OPE-OPR-CODE         -> COR-OPR-CODE
                                                    COR-ORDER-NBR

Iclocation     ICLOCATION

                            OPE-DEF-COMPANY      -> ICL-COMPANY
                                                    ICL-LOCATION