Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACRETNG


                              ACRETNG FILE

REFERENCED BY

AC04.1    BR00.1    BR18.1

UPDATED BY

AC300     AC310     BR01.1    BR01.2    BR02.3    BR120
BR121     BR122     BR123     BR140     BR151     BR152
BR156     BR20.1    BR20.2    BR20.3    BR20.4    BR20.5
BR420     BR521     BRIP.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RTG-ACTIVITY           Alpha 15                                  BR01.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.


RTG-SUM-ACCT-CAT       Alpha 5                                   BR01.2
Element: Sum Acct Cat  The name of the summary account
                       category.

RTG-ACCT-CATEGORY      Alpha 5                                   BR01.2
Element: Acct 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.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

RTG-PST-ACCT-CAT       Alpha 5                                   BR01.2
Element: Pst Acct Cat

RTG-PST-GL-CODE        Alpha 4                                   BR01.2
Element: Pst Gl Code

RTG-PERCENT            Signed 7.3                                BR01.2
Element: Percent       The percentage determines how much
                       retention is held. It can either be a
                       percentage of each invoice, or it can be
                       a percentage of a total.

RTG-BAL-RET-AMT        Signed 18.2                               AC300   BR140
Element: Intl Amt                                                BRIP.1

RTG-BAL-BILL-AMT       Signed 18.2                               AC300   BR02.3
Element: Intl Amt                                                BR120   BR121
                                                                 BR122   BR123
                                                                 BR140   BR151
                                                                 BR152   BR156
                                                                 BR20.1  BR20.2
                                                                 BR20.3  BR20.4
                                                                 BR20.5  BR420
                                                                 BR521

RTG-BAL-REL-AMT        Signed 18.2                               AC300   BR01.1
Element: Intl Amt                                                BR02.3  BR120
                                                                 BR121   BR122
                                                                 BR123   BR140
                                                                 BR151   BR152
                                                                 BR156   BR20.1
                                                                 BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR420   BR521

RTG-CEILING            Signed 18.2                               AC300   BR01.2
Element: Intl Amt

RTG-SEQ-NBR            Numeric 4                                 BR122   BRIP.1
Element: Seq Nbr       An automatically assigned sequence
                       number.

RTG-UNBILL-RET-BAL     Signed 18.2                               AC300   BR120
Element: Intl Amt                                                BR121   BR122
                                                                 BR123   BR140
                                                                 BR151   BR152
                                                                 BR156   BR420
                                                                 BR521   BRIP.1

RTG-CTR-CAT-GRP        Alpha 5                                   BR01.2
Element: Ctr Cat Grp

                         ACRETNG FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RTGSET1   ACTIVITY                                               AC04.1  AC300
          SUM-ACCT-CAT                                           AC310   BR00.1
          CTR-CAT-GRP                                            BR01.1  BR01.2
          ACCT-CATEGORY                                          BR02.3  BR120
                                                                 BR121   BR122
                                                                 BR123   BR140
                                                                 BR151   BR152
                                                                 BR156   BR18.1
                                                                 BR20.1  BR20.2
                                                                 BR20.3  BR20.4
                                                                 BR20.5  BR420
                                                                 BR521   BRIP.1

                         ACRETNG FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Required

                            RTG-ACCT-CATEGORY    -> AAX-ACCT-CATEGORY

Acactivity     ACACTIVITY   Required

                            RTG-ACTIVITY         -> ACV-ACTIVITY

Acglcode       ACGLCODE     Not Required

                            RTG-PST-GL-CODE      -> AGC-AC-GL-CODE

                         ACRETNG FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acretngx       ACRETNGX

                            RTG-ACTIVITY         -> RGX-ACTIVITY
                            RTG-SUM-ACCT-CAT     -> RGX-SUM-ACCT-CAT
                            RTG-CTR-CAT-GRP      -> RGX-CTR-CAT-GRP
                            RTG-ACCT-CATEGORY    -> RGX-ACCT-CATEGORY
                                                    RGX-SEQ-NBR