Lawson Insight Technical Documentation

                            APUSRFLDEF FILE

                        AP User Field Definition

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

REFERENCED BY

AP170     AP175     AP20.1    AP20.2    AP20.3    AP20.4
AP20.5    AP20.7    AP23.1    AP30.1    AP30.2    AP520
MA41.2    MA43.2    MA540     AM115     AM15.1    AM15.2
AM15.3    AM15.4    AM20.1    AM20.3    AM21.1    AM21.3
AM500     AM51.1    AM551     AM97.1    AP10.1    AP10.2
AP510     API3.1    API4.1    IC840     PR05.1    PR05.3
PR226     PR247     PR26.1    PR47.1    PR514     UK47.1

UPDATED BY

AP00.1    AP00.4    AP100

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AFL-COMPANY            Numeric 4                                 AP00.4
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

AFL-VENDOR-GROUP       Alpha 4                                   AP00.1  AP00.4
Element: Vendor Group  A vendor group represents a group of      AP100
                       vendors that can be shared by one or
                       more companies.

AFL-USER-FLD-TYPE      Alpha 1                                   AP00.1  AP00.4
Element: User Field TypIndicates the user field type. User       AP100
                       fields can be added to vendors,
                       invoices, or distributions.

                       Valid values are:

                       V = Vendor
                       I = Invoice
                       D = Distribution

AFL-DATA-TYPE-01       Alpha 1                                   AP00.1  AP00.4
User Field 1 Data      Indicates the data type of the user
Type                   field.

                       Valid values are:

                       A = Alpha
                       N = Numeric
                       D = Date (mmddyy)
                       M = Amount

AFL-DATA-TYPE-02       Alpha 1                                   AP00.1  AP00.4
User Field 2 Data      Indicates the data type of the user
Type                   field.

                       Valid values are:

                       A = Alpha
                       N = Numeric
                       D = Date (mmddyy)
                       M = Amount

AFL-DATA-TYPE-03       Alpha 1                                   AP00.1  AP00.4
User Field 3 Data      Indicates the data type of the user
Type                   field.

                       Valid values are:

                       A = Alpha
                       N = Numeric
                       D = Date (mmddyy)
                       M = Amount

AFL-DATA-TYPE-04       Alpha 1                                   AP00.1  AP00.4
User Field 4 Data      Indicates the data type of the user
Type                   field.

                       Valid values are:

                       A = Alpha
                       N = Numeric
                       D = Date (mmddyy)
                       M = Amount

AFL-DATA-TYPE-05       Alpha 1                                   AP00.1  AP00.4
User Field 5 Data      Indicates the data type of the user
Type                   field.

                       Valid values are:

                       A = Alpha
                       N = Numeric
                       D = Date (mmddyy)
                       M = Amount

AFL-DATA-TYPE-06       Alpha 1                                   AP00.1
Element: Data Type 01

                         APUSRFLDEF FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AFLSET1   USER-FLD-TYPE
          VENDOR-GROUP
          COMPANY

AFLSET2   COMPANY                                                AP00.4  AP170
          USER-FLD-TYPE                                          AP175   AP20.1
          VENDOR-GROUP                                           AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP30.1  AP30.2
                                                                 AP520   MA41.2
                                                                 MA43.2  MA540

AFLSET3   VENDOR-GROUP                                           AM115   AM15.1
          USER-FLD-TYPE                                          AM15.2  AM15.3
          COMPANY                                                AM15.4  AM20.1
                                                                 AM20.3  AM21.1
                                                                 AM21.3  AM500
                                                                 AM51.1  AM551
                                                                 AM97.1  AP00.1
                                                                 AP10.1  AP10.2
                                                                 AP100   AP510
                                                                 API3.1  API4.1
                                                                 IC840   MA540
                                                                 PR05.1  PR05.3
                                                                 PR226   PR247
                                                                 PR26.1  PR47.1
                                                                 PR514   UK47.1