Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             ACRETAINX FILE

REFERENCED BY

BR120     BR202     BR420     BR450

UPDATED BY

AC300     AC310     BR02.1    BR02.2    BR121     BR00.1
BR10.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

REX-ACTIVITY         Alpha 15                                    BR02.2
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
Retain Id

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

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

REX-RETAINER         Signed 15.2                                 BR02.2
Retainer

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

REX-STATUS           Numeric 1                                   AC300   BR02.2
Status               This field displays the status of the       BR121
                     transaction.

                     0 = Not Applied
                     1 = Applied
                     2 = Apply to Next
                     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   BR202
                                                                 BR420   BR450

                         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