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     AP30.1    AP30.2    AP520     MA540
AM115     AM117     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    UK47.1

UPDATED BY

AP00.1    AP00.4    AP100

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AFL-COMPANY            Numeric 4                                 AP00.4
Element: Company       Identifies 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.

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

AFLSET2   COMPANY                                                AP00.4  AP170
          USER-FLD-TYPE                                          AP175   AP30.1
          VENDOR-GROUP                                           AP30.2  AP520
                                                                 MA540

AFLSET3   VENDOR-GROUP                                           AM115   AM117
          USER-FLD-TYPE                                          AM15.1  AM15.2
          COMPANY                                                AM15.3  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  UK47.1