Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARCSTMXVAL


                            ARCSTMXVAL FILE

REFERENCED BY

AR135     AR170     AR210     AR211     AR222     AR232
AR235     AR250     AR251     AR253     AR271     AR275
AR290     AR293     AR294     BL232     OE280     OE285
OE290

UPDATED BY

AR23.1    AR23.2    AR501     AR515     AR550     AR09.1
AR10.1    AR301     BL02.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CTV-OBJ-ID             Numeric 12                                AR23.1  AR23.2
Object                 This is the object identifier. It is      AR501   AR515
Identification         used to relate commitments or posted      AR550
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

CTV-MATRIX-CAT         Alpha 12                                  AR23.1  AR23.2
Element: Attribute     Attribute name assigned to an object      AR501   AR515
                       (like accounting unit) to track           AR550
                       additional information.  Attribute
                       values may then be used in selection and
                       sorting for report and analysis.

CTV-MX-VALUE           Alpha 32                                  AR23.1  AR23.2
Element: Attribute ValuThe attribute value.                      AR501   AR515
                                                                 AR550

                         ARCSTMXVAL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CTVSET1   OBJ-ID                                                 AR09.1  AR10.1
          MATRIX-CAT                                             AR135   AR170
                                                                 AR210   AR211
                                                                 AR222   AR23.1
                                                                 AR23.2  AR23.3
                                                                 AR232   AR235
                                                                 AR250   AR251
                                                                 AR253   AR271
                                                                 AR275   AR290
                                                                 AR293   AR294
                                                                 AR301   AR501
                                                                 AR515   AR550
                                                                 BL02.1  BL232
                                                                 OE280   OE285
                                                                 OE290

CTVSET2   MATRIX-CAT    KeyChange                                AR135   AR170
          MX-VALUE                                               AR210   AR211
          OBJ-ID                                                 AR222   AR23.3
                                                                 AR232   AR235
                                                                 AR250   AR251
                                                                 AR253   AR271
                                                                 AR275   AR290
                                                                 AR293   AR294
                                                                 BL232   OE280
                                                                 OE285   OE290

                         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