APUSRFLDEF – AP User Field Definition

System
Accounts Payable (AP)
Prefix
AFL
Primary key
—
Fields
9
Updated by
3 programs
Referenced by
295 programs

APUSRFLDEF is the AP User Field Definition table in Lawson Accounts Payable (prefix AFL). It is updated by AP00.1, AP00.4 and AP100 and referenced by AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 and 287 more. The table has 9 fields, 2 indexes and 0 documented relations.

About APUSRFLDEF

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

Fields (9)

Column = COBOL field name without the AFL- 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
#AFL-COMPANY SET2 SET3
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.AP00.4
#AFL-VENDOR-GROUP SET2 SET3
VENDOR_GROUP		Alpha 4A vendor group represents a group of vendors that can be shared by one or more companies.AP00.1, AP00.4, AP100
#AFL-USER-FLD-TYPE SET2 SET3
USER_FLD_TYPE		Alpha 1Indicates the user field type. User fields can be added to vendors, invoices, or distributions. Valid values are:
  • V Vendor
  • I Invoice
  • D Distribution
AP00.1, AP00.4, AP100
#AFL-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
AP00.1, AP00.4
#AFL-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
AP00.1, AP00.4
#AFL-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
AP00.1, AP00.4
#AFL-DATA-TYPE-04
DATA_TYPE_04		Alpha 1Indicates the data type of the user field. Valid values are:
  • A Alpha
  • N Numeric
  • D Date (mmddyy)
  • M Amount
AP00.1, AP00.4
#AFL-DATA-TYPE-05
DATA_TYPE_05		Alpha 1Indicates the data type of the user field. Valid values are:
  • A Alpha
  • N Numeric
  • D Date (mmddyy)
  • M Amount
AP00.1, AP00.4
#AFL-DATA-TYPE-06
DATA_TYPE_06		Alpha 1—AP00.1, AP00.4

Indexes (2)

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
AFLSET2
  1. COMPANY
  2. USER-FLD-TYPE
  3. VENDOR-GROUP
AP00.4, AP170, AP175, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +15 more
AFLSET3
  1. VENDOR-GROUP
  2. USER-FLD-TYPE
  3. COMPANY
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)

Programs

Updated by (3)

Referenced by (295)