Lawson Insight Technical Documentation


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.

REFERENCED BY

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     OE113     OE114     OE14.4    OE15.1    OE15.2
OE15.3    OE15.4    OE15.5    OE15.7    OE510     OE810
OE920     WH20.2    WH20.7    BL120     BL130     BL20.1
BL20.3    BL21.2    BL21.5    BL29.1    BL29.2    BL520
BL820     BL92.1    BL940     OE129     OE210     OE253
OE281     OE282     OE283     OE284     OE30.1    OE30.2
OE30.3    OE30.4    OE30.5    OE30.6    OE30.7    OE30.9
OE80.4    OE830     OE90.1    OE90.2    OE950

UPDATED BY

OE53.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

OPE-DEF-COMPANY      Numeric 4                                   OE53.1
Default Company      This field contains the default company
Number               number.

OPE-OPR-CODE         Alpha 10  (Lower Case)                      OE53.1
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)                      OE53.1
Company Name         Contains the company description.

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

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

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

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

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

OPE-DEF-RESTR-FL     Alpha 1                                     OE53.1
Default              This field indicates whether the person
Restrictions 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                                     OE53.1
Local Transactions   This field indicates if the person
Flag                 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                                     OE53.1
Currency Override    This field indicates whether the person
Flag                 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                                     OE53.1
Rate Override Flag   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      Duplicates                               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   OE113
                                                                 OE114   OE14.4
                                                                 OE15.1  OE15.2
                                                                 OE15.3  OE15.4
                                                                 OE15.5  OE15.7
                                                                 OE510   OE810
                                                                 OE920   WH20.2
                                                                 WH20.7

OPESET2   DEF-COMPANY                                            BL120   BL130
          OPR-CODE                                               BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  BL940
                                                                 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   OE113
                                                                 OE114   OE129
                                                                 OE14.4  OE15.1
                                                                 ...

                         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

Oestdorder     OESTDORDER   Delete Restricted

                            OPE-DEF-COMPANY      -> OSO-COMPANY
                            OPE-DEF-CUSTOMER     -> OSO-CUSTOMER
                                                    OSO-STD-ORDER-NBR