Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APUSRFLDEF


                            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    AP21.1    AP23.1    AP30.1    AP30.2
AP30.4    AP520     MA41.1    MA41.2    MA41.4    MA41.7
MA43.2    MA43.1    MA43.3    MA43.4    MA43.6    MA43.7
MA540     AC160     AM115     AM117     AM15.1    AM15.2
AM15.3    AM15.4    AM19.1    AM19.2    AM20.1    AM20.3
AM21.1    AM21.3    AM500     AM51.1    AM551     AM97.1
AP03.3    AP10.1    AP10.2    AP110     AP115     AP125
AP126     AP131     AP210     AP220     AP25.1    AP25.2
AP26.1    AP27.1    AP305     AP510     AP90.1    AP91.1
API1.1    API2.1    API3.1    API4.1    BL120     BL122
BL130     BL20.1    BL20.3    BL21.2    BL21.5    BL29.1
BL29.2    BL520     BL820     BL92.1    MX123     MX500
MA180     MA279     MA530     MA531     MA60.2    MA60.3
MA60.5    MA61.1    MA63.1    MA65.1    MA66.2    MA66.3
MA67.2    MA67.3    MA68.2    MA68.3    MA68.5    MA70.1
MA75.1    MA80.1    MAI1.1    PD10.1    PD10.2    PD130
PD20.1    PD20.2    PD20.3    PD235     PO10.1    PO100
PO101     PO120     PO122     PO131     PO20.1    PO21.1
PO21.2    PO21.3    PO21.4    PO21.5    PO22.1    PO220
PO223     PO23.1    PO233     PO24.1    PO25.1    PO25.5
PO25.6    PO25.7    PO253     PO254     PO27.2    PO278
PO29.1    PO30.1    PO30.2    PO30.3    PO300     PO31.1
PO31.2    PO32.2    PO32.4    PO33.1    PO34.1    PO35.1
PO36.1    PO36.2    PO38.1    PO39.1    PO39.2    PO44.1
PO50.1    PO52.1    PO520     PO536     PO54.1    PO54.2
PO54.3    PO54.4    POI3.1    POID.1    POII.1    POIJ.1
PR05.1    PR05.3    PR226     PR247     PR26.1    PR47.1
PR514     UK47.1    RQ10.1    RQ10.2    WH20.2    WH20.7


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   AP20.1
          VENDOR-GROUP                                           AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP30.1
                                                                 AP30.2  AP520
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA540

AFLSET3   VENDOR-GROUP                                           AC160   AM115
          USER-FLD-TYPE                                          AM117   AM15.1
          COMPANY                                                AM15.2  AM15.3
                                                                 AM15.4  AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.3  AM21.1
                                                                 AM21.3  AM500
                                                                 AM51.1  AM551
                                                                 AM97.1  AP00.1
                                                                 AP03.3  AP10.1
                                                                 AP10.2  AP100
                                                                 AP110   AP115
                                                                 AP125   AP126
                                                                 AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 ...