Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            ARUSRFLDEF FILE

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

REFERENCED BY

AR20.3    AR21.9    AR43.2    AR501     AR502     AR503
AR550     AR560     AR575     AR580     AR97.1    AR97.3
AR97.6    AR98.1    AR99.1    AR99.3    TX00.1

UPDATED BY

AR01.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ADU-COMPANY          Numeric 4                                   AR01.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.

ADU-USER-FLD-TYPE    Alpha 1                                     AR01.1
User Fld Type        Indicates the user field type. User
                     fields can be added to customers,
                     payments, payment batches and
                     transaction headers.
                     Valid values are;
                     C = Customers
                     P = Payments
                     B = Payment Batches
                     T = Transaction Headers

ADU-DATA-TYPE-01     Alpha 1                                     AR01.1
Data Type 01         Indicates the data type of the user
                     field.
                     A = Alpha
                     N = Numeric
                     D = Date Format (1st 6 positions)
                     M = Amount

ADU-DATA-TYPE-02     Alpha 1                                     AR01.1
Data Type 02         Indicates the data type of the user
                     field.
                     A = Alpha
                     N = Numeric
                     D = Date Format (1st 6 positions)
                     M = Amount

ADU-DATA-TYPE-03     Alpha 1                                     AR01.1
Data Type 03         Indicates the data type of the user
                     field.
                     A = Alpha
                     N = Numeric
                     D = Date Format (1st 6 positions)
                     M = Amount

ADU-DATA-TYPE-04     Alpha 1                                     AR01.1
Data Type 04         Indicates the data type of the user
                     field.
                     A = Alpha
                     N = Numeric
                     D = Date Format (1st 6 positions)
                     M = Amount

ADU-DATA-TYPE-05     Alpha 1                                     AR01.1
Data Type 05         Indicates the data type of the user
                     field.
                     A = Alpha
                     N = Numeric
                     D = Date Format (1st 6 positions)
                     M = Amount

                         ARUSRFLDEF FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ADUSET1   USER-FLD-TYPE                                          AR01.1  AR20.3
          COMPANY                                                AR21.9  AR43.2
                                                                 AR501   AR502
                                                                 AR503   AR550
                                                                 AR560   AR575
                                                                 AR580   AR97.1
                                                                 AR97.3  AR97.6
                                                                 AR98.1  AR99.1
                                                                 AR99.3  TX00.1