WOUSRFLDEF – Work Order user field type definition file

System
WO (WO)
Prefix
WDU
Primary key
USER-FLD-TYPE, COMPANY
Fields
7
Updated by
1 program
Referenced by
2 programs

WOUSRFLDEF is the Work Order user field type definition file table in Lawson WO (prefix WDU). It is indexed by USER-FLD-TYPE, COMPANY (WDUSET1). It is updated by IC01.1 and referenced by IC501 and TX00.1. The table has 7 fields, 1 index and 0 documented relations.

About WOUSRFLDEF

Work Order user field type definition file

Fields (7)

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

Field / columnTypeDescription & valuesUpdated by
WDU-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.IC01.1
WDU-USER-FLD-TYPE PK
USER_FLD_TYPE
Alpha 1Allows the file to hold user defined data types for multiple master files.
  • B Work Order Burden
  • C Work Order Component
  • H Work Order Header
IC01.1
WDU-DATA-TYPE-01
DATA_TYPE_01
Alpha 1User defined data type for field number 1 in the user field file.
  • A Alpha
  • N Numeric
  • D Date (1st 6 positions)
  • M Amount
IC01.1
WDU-DATA-TYPE-02
DATA_TYPE_02
Alpha 1User defined data type for field number 2 in the user field file.
  • A Alpha
  • N Numeric
  • D Date (1st 6 positions)
  • M Amount
IC01.1
WDU-DATA-TYPE-03
DATA_TYPE_03
Alpha 1User defined data type for field number 3 in the user field file.
  • A Alpha
  • N Numeric
  • D Date (1st 6 positions)
  • M Amount
IC01.1
WDU-DATA-TYPE-04
DATA_TYPE_04
Alpha 1User defined data type for field number 4 in the user field file.
  • A Alpha
  • N Numeric
  • D Date (1st 6 positions)
  • M Amount
IC01.1
WDU-DATA-TYPE-05
DATA_TYPE_05
Alpha 1User defined data type for field number 5 in the user field file.
  • A Alpha
  • N Numeric
  • D Date (1st 6 positions)
  • M Amount
IC01.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
WDUSET1USER-FLD-TYPE, COMPANYPrimaryIC01.1, IC501, TX00.1

Programs

Updated by (1)

Referenced by (2)