Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             ACRETAIN FILE

REFERENCED BY

AC121     AC123     AC130     AC20.1    AC20.2    AC20.3
AC20.4    AC20.5    AC32.1    AC490     BR120     BR202
BR420     BR450

UPDATED BY

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

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

RET-ACTIVITY         Alpha 15                                    BR02.1
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.



RET-RETAIN-ID        Numeric 6                                   BR02.1  BR21.1
Retain Id

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

RET-RETAINER-TYPE    Alpha 1                                     BR02.1  BR21.1
Retainer Type        F = First
                     L = Last
                     S = Specific

RET-AMOUNT           Currency 15.2                               BR02.1  BR21.1
Amount               This is the amounts by period for the
                     specified record.

RET-APPLIED-AMT      Signed 15.2                                 AC300   BR121
Applied Amount                                                   BR21.1

RET-CURRENCY-CODE    Alpha 5                                     BR02.1
Currency Code        This field contains the company base
                     currency code established in Company
                     (GL10.1 ).


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

                     0 = Open
                     1 = Applied

RET-RETAIN-GL-CD     Alpha 4
Retain Gl Cd

RET-ACCT-CATEGORY    Alpha 5
Account Category     Account categories are groupings of
                     costs, revenues, or a combination of
                     both used for reporting and inquiries
                     for activities in the Activity
                     Management system. All transactions are
                     posted to an account category within an
                     activity. You can assign a specific
                     General Ledger account or range of
                     accounts (company, accounting unit,
                     account, and subaccount) that make up
                     the transactions posted to an account
                     category using AC07.1 (Account
                     Assignment).

                     Period-to-date, year-to-date, and
                     life-to-date balances are maintained by
                     account category for activities. Account
                     categories must be assigned to
                     activities before you do any budgeting
                     or transaction processing.



RET-RETAINER-BAL     Signed 15.2                                 AC300   BR02.2
Retainer Bal                                                     BR21.1

RET-RETAIN-PCT-BAL   Signed 7.4                                  BR02.2  BR21.1
Retain Pct Bal

RET-RETAIN-RULE      Alpha 1                                     BR02.1
Retain Rule

                         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  AC490
                                                                 BR00.1  BR02.1
                                                                 BR02.2  BR02.3
                                                                 BR10.1  BR120
                                                                 BR121   BR202
                                                                 BR21.1  BR420
                                                                 BR450

RETSET2   ACTIVITY      KeyChange                                BR21.1
          RETAIN-ID*

                         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