OECOMPREF – Company
- System
- Billing (BL)
- Prefix
OEL- Primary key
COMPANY,PROCESS-LEVEL,TYPE- Fields
- 5
- Updated by
- 1 program
- Referenced by
- 8 programs
OECOMPREF is the Company table in Lawson Billing (prefix OEL). It is indexed by COMPANY, PROCESS-LEVEL, TYPE (OELSET1); alternate indexes: OELSET2. It is updated by BLI1.1 and referenced by AC56.1, AC560, AR01.1, ARLL.1, BR11.1, BR48.1, WH20.2 and WH20.7. The table has 5 fields, 2 indexes and 0 documented relations.
About OECOMPREF
No description in the Lawson data dictionary.
Fields (5)
Column = COBOL field name without the OEL- 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 / column | Type | Description & values | Updated by |
|---|---|---|---|
#OEL-COMPANY PKCOMPANY | Numeric 4 | Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. | — |
#OEL-PROCESS-LEVEL PKPROCESS_LEVEL | Alpha 5 | This field contains the process level, which is the reporting hierarchy below company. | — |
#OEL-TYPE PKTYPE | Alpha 2 | This identifies whether this record is created because of a picking transaction, or because of a return. Valid values are: "IS" = Picking transaction. "RR" = Return. ~$1 VENDOR The vendor's identification code. | — |
#OEL-LAST-DOC-NBRLAST_DOC_NBR | Numeric 10 | — | BLI1.1 |
#OEL-PREFIXPREFIX | Alpha 2 | — | — |
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
OELSET1 |
| Primary | AC56.1, AC560, AR01.1, ARLL.1, BLI1.1, BR11.1, BR48.1, WH20.2 +1 more | |
OELSET2 |
| — |
Programs
Updated by (1)
- BLI1.1 Oecompref Number Assignment