Lawson Insight Technical Documentation

                             ACRETAINX FILE

REFERENCED BY

BR120     BR121     BR123     BR140     BR151     BR152
BR156     BR20.1    BR20.2    BR20.3    BR20.4    BR20.5
BR202     BR420     BR450     BR521

UPDATED BY

AC300     AC310     BR02.1    BR02.2    BR122     BRIP.1
BR00.1    BR10.1    PW110

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

REX-ACTIVITY           Alpha 15                                  BR02.2
Element: Activity      Activities are the processes or
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


REX-RETAIN-ID          Numeric 6                                 BR02.2
Element: Retain Id

REX-RETAIN-CODE        Alpha 3                                   BR02.2
Element: Retain Code

REX-DESCRIPTION        Alpha 30  (Lower Case)                    BR02.2
Element: Description   This field displays the description.

REX-RETAINER           Signed 18.2                               BR02.2
Element: Intl Amt

REX-RETAINER-PCT       Percent 15.2  (Percent)                   BR02.2
Element: Retainer Pct

REX-STATUS             Numeric 1                                 AC300   BR02.2
Element: Status        This field displays the status of the     BR122   BRIP.1
                       transaction.
                       1 = Apply to Next
                       2 = Applied
                       3 = Hold

                         ACRETAINX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

REXSET1   ACTIVITY                                               AC300   AC310
          RETAIN-ID                                              BR00.1  BR02.1
          RETAIN-CODE                                            BR02.2  BR02.3
                                                                 BR10.1  BR120
                                                                 BR121   BR122
                                                                 BR123   BR140
                                                                 BR151   BR152
                                                                 BR156   BR20.1
                                                                 BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR202   BR420
                                                                 BR450   BR521
                                                                 BRIP.1  PW110

                         ACRETAINX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactivity     ACACTIVITY   Required

                            REX-ACTIVITY     -> ACV-ACTIVITY

Acretain       ACRETAIN     Required

                            REX-ACTIVITY     -> RET-ACTIVITY
                            REX-RETAIN-ID    -> RET-RETAIN-ID