Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OPERATOR


                             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

BL120     BL122     BL130     BL20.1    BL20.3    BL21.2
BL21.5    BL29.1    BL29.2    BL520     BL820     BL92.1
WH20.2    WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OPE-DEF-COMPANY        Numeric 4
Element: Company       This field contains the default company
                       number.

OPE-OPR-CODE           Alpha 10  (Lower Case)
Element: Opr 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)
Element: Name          Displays the company description.

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

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

OPE-DEF-LOCATION       Alpha 5
Element: Location      This field contains the inventory
                       location associated with the user ID.

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

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

OPE-DEF-ORDER-DATE     Numeric 8  (yyyymmdd)
Element: Date          This field displays the system date
                       when this was created.

OPE-DEF-SHIP-DATE      Numeric 8  (yyyymmdd)
Element: Date          This field displays the system date
                       when this was created.

OPE-DEF-RESTR-FL       Alpha 1
Element: All Flag      This field indicates whether the person
                       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
Element: All Flag      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
Element: All Flag      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
Element: 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                                               BL120   BL122
          DEF-COMPANY                                            BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.2  WH20.7

OPESET2   DEF-COMPANY                                            BL120   BL122
          OPR-CODE                                               BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.2  WH20.7

                         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