ARUSRFLDEF – The User Field Definition file defines field types and data types for customer, payment, payment header, and trasaction…

System
Accounts Receivable (AR)
Prefix
ADU
Primary key
USER-FLD-TYPE, COMPANY
Fields
7
Updated by
1 program
Referenced by
6 programs

ARUSRFLDEF is the The User Field Definition file defines field types and data types for customer, payment, payment header, and trasaction… table in Lawson Accounts Receivable (prefix ADU). It is indexed by USER-FLD-TYPE, COMPANY (ADUSET1). It is updated by AR01.1 and referenced by AR10.1, AR501, AR550, AR98.1, ARLL.1 and TX00.1. The table has 7 fields, 1 index and 0 documented relations.

About ARUSRFLDEF

The User Field Definition file defines field types and data types for customer, payment, payment header, and trasaction header user fields.

Fields (7)

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

Field / columnTypeDescription & valuesUpdated by
ADU-COMPANY PK
COMPANY		Numeric 4The number representing an AR company.AR01.1
ADU-USER-FLD-TYPE PK
USER_FLD_TYPE		Alpha 1Indicates the user field type. User fields can be added to customers, payments, payment batches and transaction headers. Valid values are;
  • C Customers
  • P Payments
  • B Payment Batches
  • T Transaction Headers
AR01.1
ADU-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
AR01.1
ADU-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
AR01.1
ADU-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
AR01.1
ADU-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
AR01.1
ADU-DATA-TYPE-05
DATA_TYPE_05		Alpha 1Indicates the data type of the user field.
  • A Alpha
  • N Numeric
  • D Date Format (1st 6 positions)
  • M Amount
AR01.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
ADUSET1USER-FLD-TYPE, COMPANYPrimaryAR01.1, AR10.1, AR501, AR550, AR98.1, ARLL.1, TX00.1

Programs

Updated by (1)

Referenced by (6)