Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARUSRFLDEF


                            ARUSRFLDEF FILE

The User Field Definition file defines field types and data types for
customer, payment, payment header, and trasaction header user fields.

REFERENCED BY

AR10.1    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    ARLL.1
TX00.1

UPDATED BY

AR01.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ADU-COMPANY            Numeric 4                                 AR01.1
Element: Company       The number representing an AR company.

ADU-USER-FLD-TYPE      Alpha 1                                   AR01.1
Element: 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
Element: 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
Element: 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-03       Alpha 1                                   AR01.1
Element: 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-04       Alpha 1                                   AR01.1
Element: 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-05       Alpha 1                                   AR01.1
Element: Data Type 01  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  AR10.1
          COMPANY                                                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
                                                                 ARLL.1  TX00.1