OEUSRFLDEF – The User Field Definition file defines user field types and user field data types.

System
OE (OE)
Prefix
OUD
Primary key
USER-FLD-TYPE, COMPANY
Fields
7
Updated by
0 programs
Referenced by
0 programs

OEUSRFLDEF is the The User Field Definition file defines user field types and user field data types. table in Lawson OE (prefix OUD). It is indexed by USER-FLD-TYPE, COMPANY (OUDSET1). The table has 7 fields, 1 index and 0 documented relations.

About OEUSRFLDEF

The User Field Definition file defines user field types and user field data types.

Fields (7)

Column = COBOL field name without the OUD- 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
#OUD-COMPANY PK
COMPANY		Numeric 4Identifies 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.—
#OUD-USER-FLD-TYPE PK
USER_FLD_TYPE		Alpha 1Indicates the user field type. User flds can be added to operators, orders, order lines, returns and return lines. Valid values are:
  • O Operator
  • H Order Header
  • L Order Line
—
#OUD-DATA-TYPE-01
DATA_TYPE_01		Alpha 1Indicates the data type of the user field. Valid values are:
  • A Alpha
  • N Numeric
  • D Date (mmddyy)
  • M Amount
—
#OUD-DATA-TYPE-02
DATA_TYPE_02		Alpha 1Indicates the data type of the user field. Valid values are:
  • A Alpha
  • N Numeric
  • D Date (mmddyy)
  • M Amount
—
#OUD-DATA-TYPE-03
DATA_TYPE_03		Alpha 1Indicates the data type of the user field. Valid values are:
  • A Alpha
  • N Numeric
  • D Date (mmddyy)
  • M Amount
—
#OUD-DATA-TYPE-04
DATA_TYPE_04		Alpha 1Indicates the data type of the user field. Valid values are: M - Amount
  • A Alpha
  • N Numeric
  • D Date (mmddyy)
  • M Amount
—
#OUD-DATA-TYPE-05
DATA_TYPE_05		Alpha 1Indicates the data type of the user field. Valid values are:
  • A Alpha
  • N Numeric
  • D Dates (mmddyy)
  • M Amount
—

Indexes (1)

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
OUDSET1
  1. USER-FLD-TYPE
  2. COMPANY
PrimaryTX00.1

Programs

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