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.

Field / column	Type	Description & values	Updated by
`OPE-DEF-COMPANY` PK DEF_COMPANY	Numeric 4	This 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 5	This 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 5	This field contains the inventory location associated with the user ID.	—
`OPE-DEF-ORDER-TYP` DEF_ORDER_TYP	Alpha 2	This field contains the order type associated with the user ID.	—
`OPE-DEF-ORDER-SRC` DEF_ORDER_SRC	Alpha 2	This 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 1	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` LOC_TRANS_FL	Alpha 1	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` CURR_OVR_FL	Alpha 1	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` RATE_OVR_FL	Alpha 1	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	—

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`OPESET1`	`OPR-CODE`, `DEF-COMPANY`	Primary		WH20.2, WH20.7
`OPESET2`	`DEF-COMPANY`, `OPR-CODE`			WH20.2, WH20.7

Relations

One to one (9) — lookups and parents

Relation	Table	Rules	Condition	Field map
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`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
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`

Programs

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