Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARCSTMXVAL


                            ARCSTMXVAL FILE

This file contains an attribute value for a customer.  The objet ID element
relates the value to a customer.  Attribute values are used to help formulate
customer lists for reporting purposes within the AR system.

REFERENCED BY

AR120     AR129     AR130     AR131     AR135     AR170
AR210     AR211     AR217     AR222     AR223     AR227
AR228     AR229     AR230     AR232     AR233     AR235
AR237     AR238     AR239     AR245     AR250     AR251
AR253     AR258     AR264     AR265     AR271     AR275
AR282     AR285     AR290     AR291     AR292     AR293
AR294     AR296     AR300     BL232     BL290     MX123
WH110     WH130     WH226

UPDATED BY

AR23.1    AR23.2    AR501     AR515     AR550     MX500
AR09.1    AR10.1    AR301     BL02.1    BL802     PW550
TX140

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CTV-OBJ-ID             Numeric 12                                AR23.1  AR23.2
Element: Obj Id        This is the object identifier that        AR501   AR515
                       relates to a specific company customer    AR550   MX500
                       record.

CTV-MATRIX-CAT         Alpha 12                                  AR23.1  AR23.2
Element: Matrix Cat    Attribute name assigned to an object      AR501   AR515
                       (like customert) to track additional      AR550   MX500
                       information.

CTV-MX-VALUE           Alpha 32                                  AR23.1  AR23.2
Element: Mx Value      The attribute value.                      AR501   AR515
                                                                 AR550   MX500

                         ARCSTMXVAL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CTVSET1   OBJ-ID                                                 AR09.1  AR10.1
          MATRIX-CAT                                             AR120   AR129
                                                                 AR130   AR131
                                                                 AR135   AR170
                                                                 AR210   AR211
                                                                 AR217   AR222
                                                                 AR223   AR227
                                                                 AR228   AR229
                                                                 AR23.1  AR23.2
                                                                 AR23.3  AR230
                                                                 AR232   AR233
                                                                 AR235   AR237
                                                                 AR238   AR239
                                                                 AR245   AR250
                                                                 AR251   AR253
                                                                 ...

CTVSET2   MATRIX-CAT    KeyChange                                AR120   AR129
          MX-VALUE                                               AR130   AR131
          OBJ-ID                                                 AR135   AR170
                                                                 AR210   AR211
                                                                 AR217   AR222
                                                                 AR223   AR227
                                                                 AR228   AR229
                                                                 AR23.3  AR230
                                                                 AR232   AR233
                                                                 AR235   AR237
                                                                 AR238   AR239
                                                                 AR245   AR250
                                                                 AR251   AR253
                                                                 AR258   AR264
                                                                 AR265   AR271
                                                                 ...

                         ARCSTMXVAL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcustomer     ARCUSTOMER   Not Required

                            CTV-OBJ-ID    -> ACM-OBJ-ID