Lawson Insight Technical Documentation

                             ACRETAIN FILE

REFERENCED BY

AC121     AC123     AC130     AC20.1    AC20.2    AC20.3
AC20.4    AC20.5    AC32.1    AC37.1    AC490     BR120
BR121     BR123     BR140     BR151     BR152     BR156
BR20.1    BR20.2    BR20.3    BR20.4    BR20.5    BR202
BR21.1    BR420     BR450     BR521

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RET-ACTIVITY           Alpha 15                                  BR02.1
Element: Activity      The contract or posting activity
                       associated with the retainer.


RET-RETAIN-ID          Numeric 6                                 BR02.1
Element: Retain Id     The Retainer Sequence defined for the
                       activity in BR02.  This is a user
                       defined number that is unique by
                       activity.

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

RET-RETAINER-TYPE      Alpha 1                                   BR02.1
Element: Retainer Type The Retainer Type specified on BR02.
                       The values are:
                       F= First
                       L= Last
                       S=Specific
                       F = First
                       L = Last
                       S = Specific

RET-AMOUNT             Signed 18.2                               BR02.1  BR02.2
Element: Intl Amt

RET-APPLIED-AMT        Signed 18.2                               AC300   BRIP.1
Element: Intl Amt      The amount that has been applied to the
                       retainer.

RET-CURRENCY-CODE      Alpha 5                                   BR02.1
Element: Currency Code This field contains the company base
                       currency code established in Activity
                       (AC10.1).

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

RET-RETAIN-GL-CD       Alpha 4
Element: Retain Gl Cd  The retainer GL Code specified in the
                       Contract (BR10).

RET-ACCT-CATEGORY      Alpha 5
Element: Acct Category The retainer account category specified
                       in the Contract (BR10).

RET-RETAIN-RULE        Alpha 1                                   BR02.1
Element: Retain Rule   The apply to rule specified in the
                       Retainer (BR02).
                       The values are:
                       1 = Apply to all Activities
                       2 = Apply to Retainer Activity

RET-HIH-OBJ-ID         Numeric 12                                AC300   BR02.3
Element: Obj Id        The processed invoice object              BR122
                       Identification.

                         ACRETAIN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RETSET1   ACTIVITY                                               AC121   AC123
          RETAIN-ID                                              AC130   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC300   AC310
                                                                 AC32.1  AC37.1
                                                                 AC490   BR00.1
                                                                 BR02.1  BR02.2
                                                                 BR02.3  BR10.1
                                                                 BR120   BR121
                                                                 BR122   BR123
                                                                 BR140   BR151
                                                                 BR152   BR156
                                                                 BR20.1  BR20.2
                                                                 BR20.3  BR20.4
                                                                 ...

                         ACRETAIN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Not Required

                            RET-ACCT-CATEGORY    -> AAX-ACCT-CATEGORY

Acactivity     ACACTIVITY   Required

                            RET-ACTIVITY         -> ACV-ACTIVITY

Acbill         ACBILL       Required

                            RET-ACTIVITY         -> ACI-ACTIVITY

Acglcode       ACGLCODE     Not Required

                            RET-RETAIN-GL-CD     -> AGC-AC-GL-CODE

                         ACRETAIN FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acretainx      ACRETAINX

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