Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARCUSTFLDS


                            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    BR10.1
BR11.1    BR120     BR121     BR122     BR123     BR15.1
BR151     BR152     BR155     BR156     BR16.1    BR16.2
BR210     BR211     BR215     BR220     BR251     BR252
BR253     BR420     BR450     BR51.1    BR51.2    BR52.1
BR52.2    BR521     BR53.1    BR55.2    BR91.1    BRIP.1
BRPI.1    CB06.2    IC02.1    IC531     PBIP.1    PR197
TX140     TX40.1    WH110     WH120     WH130     WH132
WH190     WH20.1    WH20.2    WH20.7    WH21.2    WH224
WH30.1    WH30.2    WH30.3    WH30.4    WH31.1    WH31.2
WH31.3    WH31.4    WH32.1    WH32.2    WH32.3    WH32.4
WH33.5    WH34.1    WH34.2    WH34.3    WH34.4    WH40.1
WH40.2    WH520     WH830     WO30.1

UPDATED BY

AR10.1    AR301     AR501     AR550

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ACF-COMPANY            Numeric 4                                 AR10.1  AR501
Element: Company       Company number.                           AR550

ACF-CUSTOMER           Alpha 9  (Right Justified)                AR10.1  AR501
Element: Customer      Customer number.                          AR550

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

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

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

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

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

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

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

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

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

ACF-CUST-USER10        Alpha 3                                   AR10.1  AR501
Element: Customer User Customer user-defined field 10. This      AR550
                       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   AR10.1
          CUSTOMER      customer fields records.                 AR211   AR219
                                                                 AR301   AR48.1
                                                                 AR48.3  AR550
                                                                 BR10.1  BR11.1
                                                                 BR120   BR121
                                                                 BR122   BR123
                                                                 BR15.1  BR151
                                                                 BR152   BR155
                                                                 BR156   BR16.1
                                                                 BR16.2  BR210
                                                                 BR211   BR215
                                                                 BR220   BR251
                                                                 BR252   BR253
                                                                 BR420   BR450
                                                                 ...

                         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