Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            ARCUSTFLDS FILE

                        AR Customer User Fields

AR Customer User Fields

REFERENCED BY

AC115     AC15.2    AC450     AR211     BL04.1    BL120
BL121     BL122     BL123     BL130     BL20.1    BL20.3
BL202     BL204     BL21.2    BL21.5    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
BL80.1    BL80.3    BL802     BL81.1    BL820     BL85.1
BL85.2    BL90.1    BL902     BL92.1    BL940     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
OE112     OE113     OE114     OE129     OE130     OE14.3
OE14.4    OE15.1    OE15.2    OE15.3    OE15.4    OE15.5
OE15.7    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    OE54.1    OE60.1    OE80.1    OE80.2
OE81.1    OE81.2    OE810     OE830     OE85.1    OE90.1
OE90.2    OE920     OE950     PBIP.1    SA03.1    SA100
SA252     SA254     SA256     SA261     SA271     SA281
SA291     SA300     SA80.2    SA90.2    TX140     TX40.1
WH110     WH120     WH130     WH132     WH190     WH20.2
WH20.7    WH21.2    WH30.1    WH30.2    WH30.3    WH31.1
WH31.2    WH31.3    WH32.1    WH32.2    WH32.3    WH33.5
WH34.1    WH34.2    WH34.3    WH34.4    WH40.1    WH40.2
WH520     WH830

UPDATED BY

AR10.1    AR301     AR501     AR550     AR973     BL02.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

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

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

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

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

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

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

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

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

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

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

                         ARCUSTFLDS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ACFSET1   COMPANY       This is the primary path used to access  AC115   AC15.2
          CUSTOMER      customer fields records.                 AC450   AR10.1
                                                                 AR211   AR301
                                                                 AR550   BL02.1
                                                                 BL02.2  BL04.1
                                                                 BL120   BL121
                                                                 BL122   BL123
                                                                 BL130   BL20.1
                                                                 BL20.3  BL202
                                                                 BL204   BL21.2
                                                                 BL21.5  BL220
                                                                 BL231   BL246
                                                                 BL29.1  BL29.2
                                                                 BL290   BL291
                                                                 BL31.1  BL31.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