Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACRETAINX


                             ACRETAINX FILE

REFERENCED BY

BR120     BR202     BR420     BR450     BR521

UPDATED BY

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

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 15.2                               BR02.2
Element: Retainer

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     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                                              BR02.1  BR02.2
          RETAIN-CODE                                            BR02.3  BR10.1
                                                                 BR120   BR121
                                                                 BR202   BR420
                                                                 BR450   BR521

                         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