OESOURCE – Order Entry Order Source

System
OE (OE)
Prefix
OSR
Primary key
COMPANY, ORDER-SOURCE
Fields
5
Updated by
1 program
Referenced by
0 programs

OESOURCE is the Order Entry Order Source table in Lawson OE (prefix OSR). It is indexed by COMPANY, ORDER-SOURCE (OSRSET1). It is related 1:1 to OECOMPANY. It is updated by WH20.7. The table has 5 fields, 1 index and 1 documented relation.

About OESOURCE

No description in the Lawson data dictionary.

Fields (5)

Column = COBOL field name without the OSR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
OSR-COMPANY PK
COMPANY		Numeric 4This field contains the company number.—
OSR-ORDER-SOURCE PK
ORDER_SOURCE		Alpha 2This field contains the order source code, which indicates how the customer heard about your company.—
OSR-SRC-DESC
SRC_DESC		Alpha 30 (Lower Case)This field contains the description of the order source code.—
OSR-SRC-USED-FL
SRC_USED_FL		Alpha 1This field indicates if the order source code has been used.
  • Y Yes
  • N No
WH20.7
OSR-SRC-ACT-FL
SRC_ACT_FL		Alpha 1This field indicates if the order source code is active.
  • A Active
  • I Inactive
—

Indexes (1)

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

IndexKeysFlagsConditionUsed in
OSRSET1COMPANY, ORDER-SOURCEPrimaryWH20.2, WH20.7

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
OecompanyOECOMPANYRequiredOSR-COMPANY → OEC-COMPANY

Programs

Updated by (1)