Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            APUSRFLDEF FILE

                        AP User Field Definition

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

REFERENCED BY

AP30.1    AP30.2    AP520     AP10.1    AP10.2    AP510
API3.1    API4.1

UPDATED BY

AP00.1    AP00.4    AP100

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

AFL-VENDOR-GROUP     Alpha 4                                     AP00.1  AP00.4
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
User Field Type      Indicates 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
Data Type 06

                         APUSRFLDEF FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AFLSET1   USER-FLD-TYPE
          VENDOR-GROUP
          COMPANY

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

AFLSET3   VENDOR-GROUP                                           AP00.1  AP10.1
          USER-FLD-TYPE                                          AP10.2  AP100
          COMPANY                                                AP510   API3.1
                                                                 API4.1