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

System
Warehouse (WH)
Prefix
WUD
Primary key
USER-FLD-TYPE, COMPANY
Fields
7
Updated by
1 program
Referenced by
6 programs

WHUSRFLDEF is the The User Field Definition file defines user field types and user field data types. table in Lawson Warehouse (prefix WUD). It is indexed by USER-FLD-TYPE, COMPANY (WUDSET1). It is updated by IC01.1 and referenced by IC501, TX00.1, WH33.5, WH33.9, WH520 and WH830. The table has 7 fields, 1 index and 0 documented relations.

About WHUSRFLDEF

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

Fields (7)

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

Field / columnTypeDescription & valuesUpdated by
WUD-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
WUD-USER-FLD-TYPE PK
USER_FLD_TYPE		Alpha 1Indicates the user field type. User flds can be added to shipment headers and shipment lines. Valid values are:
  • S Shipments
  • L Shipment Lines
IC01.1
WUD-DATA-TYPE-01
DATA_TYPE_01		Alpha 1Indicates the data type of the user field.
  • A Alpha
  • N Numeric
  • D Date Format (1st 6 positions)
  • M Amount
IC01.1
WUD-DATA-TYPE-02
DATA_TYPE_02		Alpha 1Indicates the data type of the user field.
  • A Alpha
  • N Numeric
  • D Date Format (1st 6 positions)
  • M Amount
IC01.1
WUD-DATA-TYPE-03
DATA_TYPE_03		Alpha 1Indicates the data type of the user field.
  • A Alpha
  • N Numeric
  • D Date Format (1st 6 positions)
  • M Amount
IC01.1
WUD-DATA-TYPE-04
DATA_TYPE_04		Alpha 1Indicates the data type of the user field.
  • A Alpha
  • N Numeric
  • D Date Format (1st 6 positions)
  • M Amount
IC01.1
WUD-DATA-TYPE-05
DATA_TYPE_05		Alpha 1Indicates the data type of the user field.
  • A Alpha
  • N Numeric
  • D Date Format (1st 6 postions)
  • 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
WUDSET1USER-FLD-TYPE, COMPANYPrimaryIC01.1, IC501, TX00.1, WH33.5, WH33.9, WH520, WH830

Programs

Updated by (1)

Referenced by (6)