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 ten 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

AC56.1    AC560     AR211     AR219     AR48.1    AR48.3
AR72.1    BL04.1    BL10.1    BL120     BL121     BL122
BL123     BL125     BL130     BL20.1    BL20.3    BL20.6
BL202     BL204     BL21.2    BL21.5    BL217     BL220
BL231     BL246     BL29.1    BL29.2    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
BL520     BL530     BL546     BL80.1    BL80.3    BL81.1
BL82.1    BL820     BL85.1    BL85.2    BL90.1    BL92.1
BR00.1    BR00.2    BR02.3    BR10.1    BR10.9    BR11.1
BR120     BR121     BR122     BR123     BR140     BR151
BR152     BR155     BR156     BR16.1    BR16.2    BR17.1
BR180     BR19.1    BR20.1    BR20.2    BR20.3    BR20.4
BR20.5    BR20.7    BR21.2    BR210     BR211     BR216
BR217     BR220     BR251     BR252     BR253     BR400
BR420     BR45.1    BR450     BR46.1    BR46.2    BR46.4
BR51.1    BR51.2    BR52.1    BR52.2    BR521     BR53.1
BR55.2    BR70.1    BR70.2    BR91.1    BRIP.1    CB06.2
IC02.1    PW110     TX40.1    WH110     WH120     WH130
WH132     WH190     WH20.1    WH20.2    WH20.7    WH21.2
WH224     WH226     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

UPDATED BY

AR09.1    AR10.1    AR301     AR501     AR550     BL02.1
BL802     PW550     TX140

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ACF-COMPANY            Numeric 4                                 AR09.1  AR10.1
Element: Company       The number representing an AR company.    AR301   AR501
                                                                 AR550   BL02.1
                                                                 BL802   PW550
                                                                 TX140

ACF-CUSTOMER           Alpha 9  (Right Justified)                AR09.1  AR10.1
Element: Customer      Customer number.                          AR301   AR501
                                                                 AR550   BL02.1
                                                                 BL802   PW550
                                                                 TX140

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

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

ACF-CUST-USER3         Signed 18.2                               AR09.1  AR10.1
Element: Customer User Customer user-defined field 3. This       AR301   AR501
                       data is optionally maintained in AR10.1   AR550   BL02.1
                       (Customer).                               BL802   PW550
                                                                 TX140

ACF-CUST-USER4         Signed 18.2                               AR09.1  AR10.1
Element: Customer User Customer user-defined field 4. This       AR301   AR501
                       data is optionally maintained in AR10.1   AR550   BL02.1
                       (Customer).                               BL802   PW550
                                                                 TX140

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

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

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

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

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

ACF-CUST-USER10        Alpha 3                                   AR09.1  AR10.1
Element: Customer User Customer user-defined field 10. This      AR301   AR501
                       data is optionally maintained in AR10.1   AR550   BL02.1
                       (Customer).                               BL802   PW550
                                                                 TX140

                         ARCUSTFLDS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ACFSET1   COMPANY                                                AC56.1  AC560
          CUSTOMER                                               AR09.1  AR10.1
                                                                 AR211   AR219
                                                                 AR301   AR48.1
                                                                 AR48.3  AR501
                                                                 AR550   AR72.1
                                                                 BL02.1  BL04.1
                                                                 BL10.1  BL120
                                                                 BL121   BL122
                                                                 BL123   BL125
                                                                 BL130   BL20.1
                                                                 BL20.3  BL20.6
                                                                 BL202   BL204
                                                                 BL21.2  BL21.5
                                                                 BL217   BL220
                                                                 ...

                         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