Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            ARCUSTFLDS FILE

                        AR Customer User Fields

The AR Customer User Fields file carries the user-defined field information
for each customer. User-defined field information consists of ten fields at
the company customer level. These fields serve as reference fields only.

REFERENCED BY

AC551     AR211     AR219     AR48.1    AR48.3    BL04.1
BL121     BL123     BL125     BL202     BL204     BL217
BL220     BL231     BL246     BL290     BL291     BL31.1
BL31.2    BL31.3    BL31.5    BL31.7    BL32.3    BL32.4
BL33.1    BL331     BL34.1    BL46.1    BL46.2    BL80.1
BL80.3    BL802     BL81.1    BL82.1    BL85.1    BL85.2
BL90.1    BR10.1    BR11.1    BR120     BR121     BR210
BR211     BR220     BR420     BR450     BRIP.1    IC02.1
PR197     TX140     TX40.1    WH110     WH120     WH130
WH21.2    WH33.1    WH33.2    WH33.3    WH33.4    WH33.5
WH33.6    WH33.8    WH33.9    WH34.1    WH34.2    WH34.3
WH34.4

UPDATED BY

AR301     AR501     AR550     BL02.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ACF-COMPANY          Numeric 4                                   AR501   AR550
Company              Company number.                             BL02.1

ACF-CUSTOMER         Alpha 9  (Right Justified)                  AR501   AR550
Customer             Customer number.                            BL02.1

ACF-CUST-USER1       Alpha 10                                    AR501   AR550
Customer User 1      Customer user-defined field 1. The data     BL02.1
                     is optionally maintained in AR10.1
                     (Customer).

ACF-CUST-USER2       Alpha 18                                    AR501   AR550
Customer User 2      Customer user-defined field 2. This         BL02.1
                     data is optionally maintained in AR10.1
                     (Customer).

ACF-CUST-USER3       Signed 15.2                                 AR501   AR550
Customer User 3      Customer user-defined field 3. This         BL02.1
                     data is optionally maintained in AR10.1
                     (Customer).

ACF-CUST-USER4       Signed 15.2                                 AR501   AR550
Customer User 4      Customer user-defined field 4. This         BL02.1
                     data is optionally maintained in AR10.1
                     (Customer).

ACF-CUST-USER5       Numeric 9                                   AR501   AR550
Customer User 5      Customer user-defined field 5. This         BL02.1
                     data is optionally maintained in AR10.1
                     (Customer).

ACF-CUST-USER6       Alpha 30                                    AR501   AR550
Customer User 6      Customer user-defined field 6. This         BL02.1
                     data is optionally maintained in AR10.1
                     (Customer).

ACF-CUST-USER7       Alpha 30                                    AR501   AR550
Customer User 7      Customer user-defined field 7. This         BL02.1
                     data is optionally maintained in AR10.1
                     (Customer).

ACF-CUST-USER8       Numeric 8  (yyyymmdd)                       AR501   AR550
Customer User 8      Customer user-defined field 8. This         BL02.1
                     data is optionally maintained in AR10.1
                     (Customer).

ACF-CUST-USER9       Numeric 3                                   AR501   AR550
Customer User 9      Customer user-defined field 9. This         BL02.1
                     data is optionally maintained in AR10.1
                     (Customer).

ACF-CUST-USER10      Alpha 3                                     AR501   AR550
Customer User 10     Customer user-defined field 10. This        BL02.1
                     data is optionally maintained in AR10.1
                     (Customer).

                         ARCUSTFLDS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ACFSET1   COMPANY       This is the primary path used to access  AC551   AR211
          CUSTOMER      customer fields records.                 AR219   AR301
                                                                 AR48.1  AR48.3
                                                                 AR550   BL02.1
                                                                 BL04.1  BL121
                                                                 BL123   BL125
                                                                 BL202   BL204
                                                                 BL217   BL220
                                                                 BL231   BL246
                                                                 BL290   BL291
                                                                 BL31.1  BL31.2
                                                                 BL31.3  BL31.5
                                                                 BL31.7  BL32.3
                                                                 BL32.4  BL33.1
                                                                 BL331   BL34.1
                                                                 ...

                         ARCUSTFLDS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcustomer     ARCUSTOMER   Required

                            ACF-COMPANY     -> ACM-COMPANY
                            ACF-CUSTOMER    -> ACM-CUSTOMER