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

AR211     AR219     AR48.1    AR48.3    BL04.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    BL802     BL81.1    BL82.1    BL820     BL85.1
BL85.2    BL90.1    BL92.1    BR00.1    BR00.2    BR02.3
BR10.1    BR11.1    BR120     BR121     BR122     BR140
BR16.1    BR17.1    BR19.1    BR20.1    BR20.2    BR20.3
BR20.4    BR20.5    BR20.7    BR21.2    BR210     BR211
BR216     BR217     BR220     BR400     BR420     BR45.1
BR450     BR46.1    BR46.2    BR46.4    BR521     BRIP.1
CB06.2    IC02.1    IC531     OE10.1    OE10.2    OE10.3
OE10.4    OE10.5    OE10.6    OE10.7    OE10.8    OE11.1
OE11.4    OE11.8    OE11.9    OE110     OE111     OE112
OE113     OE114     OE116     OE129     OE13.2    OE13.3
OE13.5    OE13.6    OE130     OE14.3    OE14.4    OE16.1
OE230     OE254     OE260     OE270     OE271     OE272
OE284     OE285     OE286     OE290     OE291     OE292
OE293     OE294     OE30.1    OE30.2    OE30.3    OE30.4
OE30.5    OE30.6    OE30.7    OE30.9    OE330     OE510
OE53.1    OE530     OE54.1    OE60.1    OE80.1    OE80.2
OE81.1    OE81.2    OE810     OE830     OE85.1    OE85.3
OE86.1    OE90.1    OE90.2    PBIP.1    PR197     SA03.1
SA100     SA252     SA254     SA256     SA261     SA271
SA281     SA291     SA300     SA80.2    SA90.2    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

AR09.1    AR10.1    AR301     AR501     AR550     BL02.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

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).

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).

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).

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).

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).

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).

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).

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).

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).

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).

                         ARCUSTFLDS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ACFSET1   COMPANY       This is the primary path used to access  AR09.1  AR10.1
          CUSTOMER      customer fields records.                 AR211   AR219
                                                                 AR301   AR48.1
                                                                 AR48.3  AR501
                                                                 AR550   BL02.1
                                                                 BL04.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
                                                                 ...

                         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