OPERATOR – Operator

System
OE (OE)
Prefix
OPE
Primary key
OPR-CODE, DEF-COMPANY
Fields
14
Updated by
0 programs
Referenced by
0 programs

OPERATOR is the Operator table in Lawson OE (prefix OPE). It is indexed by OPR-CODE, DEF-COMPANY (OPESET1); alternate indexes: OPESET2. It is related 1:1 to ARCOMP, ARCUSTGRP, ARCUSTOMER, CUSTDESC, ICLOCATION, OECOMPANY, OEPROCLEV, OESOURCE and 1 more and 1:M to CUSTORDER and ICLOCATION. The table has 14 fields, 2 indexes and 11 documented relations.

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

Fields (14)

Column = COBOL field name without the OPE- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#OPE-DEF-COMPANY PK
DEF_COMPANY		Numeric 4This field contains the default company number.—
#OPE-OPR-CODE PK
OPR_CODE		Alpha 10 (Lower Case)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
NAME		Alpha 30 (Lower Case)Displays the company description.—
#OPE-DEF-PROC-LEV
DEF_PROC_LEV		Alpha 5This field contains the process level associated with the user ID.—
#OPE-DEF-CUSTOMER
DEF_CUSTOMER		Alpha 9 (Right Justified)This field contains the customer number associated with the user ID.—
#OPE-DEF-LOCATION
DEF_LOCATION		Alpha 5This field contains the inventory location associated with the user ID.—
#OPE-DEF-ORDER-TYP
DEF_ORDER_TYP		Alpha 2This field contains the order type associated with the user ID.—
#OPE-DEF-ORDER-SRC
DEF_ORDER_SRC		Alpha 2This field contains the order source associated with the user ID.—
#OPE-DEF-ORDER-DATE
DEF_ORDER_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.—
#OPE-DEF-SHIP-DATE
DEF_SHIP_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.—
#OPE-DEF-RESTR-FL
DEF_RESTR_FL		Alpha 1This 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
LOC_TRANS_FL		Alpha 1This 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
CURR_OVR_FL		Alpha 1This 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
RATE_OVR_FL		Alpha 1This 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
—

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
OPESET1
  1. OPR-CODE
  2. DEF-COMPANY
PrimaryWH20.2, WH20.7
OPESET2
  1. DEF-COMPANY
  2. OPR-CODE
WH20.2, WH20.7

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ARCOMPARCUSTGRPARCUSTOMERCUSTDESCICLOCATIONOECOMPANYOEPROCLEVOESOURCEORDERTYPECUSTORDERICLOCATIONOPERATOR

One to one (9) — lookups and parents

RelationTableRulesConditionField map
ArcompARCOMPRequiredWhen OPE-DEF-COMPANY != Zeroes
OPE-DEF-COMPANY→ACO-COMPANY
ArcustgrpARCUSTGRPRequiredWhen OPE-DEF-CUSTOMER != Spaces
ACO-CUST-GROUP→ACG-CUST-GROUP
ArcustomerARCUSTOMERRequiredWhen OPE-DEF-CUSTOMER != Spaces
OPE-DEF-COMPANY→ACM-COMPANY
OPE-DEF-CUSTOMER→ACM-CUSTOMER
CustdescCUSTDESCRequiredWhen OPE-DEF-CUSTOMER != Spaces
ACO-CUST-GROUP→CUD-CUST-GROUP
OPE-DEF-CUSTOMER→CUD-CUSTOMER
IclocICLOCATIONRequiredWhen OPE-DEF-LOCATION != Spaces
OPE-DEF-COMPANY→ICL-COMPANY
OPE-DEF-LOCATION→ICL-LOCATION
OecompanyOECOMPANYRequired
OPE-DEF-COMPANY→OEC-COMPANY
OeproclevOEPROCLEVRequiredWhen OPE-DEF-PROC-LEV != Spaces
OPE-DEF-COMPANY→OEP-COMPANY
OPE-DEF-PROC-LEV→OEP-PROCESS-LEVEL
Order SourceOESOURCERequiredWhen OPE-DEF-ORDER-SRC != Spaces
OPE-DEF-COMPANY→OSR-COMPANY
OPE-DEF-ORDER-SRC→OSR-ORDER-SOURCE
OrdertypeORDERTYPERequiredWhen OPE-DEF-ORDER-TYP != Spaces
OPE-DEF-COMPANY→OTP-COMPANY
OPE-DEF-ORDER-TYP→OTP-ORDER-TYPE

One to many (2) — child tables

RelationTableRulesConditionField map
CustorderCUSTORDERDelete Restricted
OPE-DEF-COMPANY→COR-COMPANY
OPE-OPR-CODE→COR-OPR-CODE
—→COR-ORDER-NBR
IclocationICLOCATION
OPE-DEF-COMPANY→ICL-COMPANY
—→ICL-LOCATION

Programs

No Lawson programs are documented as updating or referencing this table.