Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACRETNGX


                             ACRETNGX FILE

REFERENCED BY

BR450

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

RGX-ACTIVITY           Alpha 15                                  BR01.1  BR122
Element: Activity      Activities are the processes or           BRIP.1
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


RGX-SUM-ACCT-CAT       Alpha 5                                   BR01.1  BR122
Element: Sum Acct Cat  The name of the summary account           BRIP.1
                       category.

RGX-ACCT-CATEGORY      Alpha 5                                   BR01.1  BR122
Element: Acct Category Account categories are groupings of       BRIP.1
                       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

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

RGX-STATUS             Numeric 1                                 BR01.1  BR02.3
Element: Status        This field displays the status of the     BR120   BR121
                       transaction.                              BR122   BR123
                                                                 BR140   BR151
                                                                 BR152   BR156
                                                                 BR20.1  BR20.2
                                                                 BR20.3  BR20.4
                                                                 BR20.5  BR420
                                                                 BR521   BRIP.1

RGX-DESCRIPTION        Alpha 30  (Lower Case)                    BR01.1  BR122
Element: Description   This field displays the description.      BRIP.1

RGX-DATE               Numeric 8  (yyyymmdd)                     BR122   BRIP.1
Element: Date          This field displays the system date
                       when this was created.

RGX-PST-ACTIVITY       Alpha 15                                  BR01.1  BR122
Element: Pst Activity                                            BRIP.1

RGX-PST-ACCT-CAT       Alpha 5                                   BR01.1  BR122
Element: Pst Acct Cat                                            BRIP.1

RGX-PST-GL-CODE        Alpha 4                                   BR122   BRIP.1
Element: Pst Gl Code

RGX-RETAINAGE-AMT      Signed 18.2                               BR01.1  BR122
Element: Intl Amt                                                BRIP.1

RGX-RELEASED-AMT       Signed 18.2                               BR01.1  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

RGX-BILL-AMT           Signed 18.2                               BR01.1  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

RGX-INVOICE-PREFIX     Alpha 2                                   BR01.1  BR122
Element: Invoice Prefix                                          BRIP.1

RGX-INVOICE-NBR        Numeric 8                                 BR01.1  BR122
Element: Invoice Nbr                                             BRIP.1

RGX-OBJ-ID             Numeric 12                                BR122   BRIP.1
Element: Obj Id        This is the object identifier. It is
                       used to relate commitments or posted
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

RGX-CTR-CAT-GRP        Alpha 5                                   BR01.1  BR122
Element: Ctr Cat Grp                                             BRIP.1

                         ACRETNGX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RGXSET1   ACTIVITY                                               AC300   AC310
          SUM-ACCT-CAT                                           BR01.1  BR01.2
          CTR-CAT-GRP                                            BR02.3  BR120
          ACCT-CATEGORY                                          BR121   BR122
          SEQ-NBR                                                BR123   BR140
                                                                 BR151   BR152
                                                                 BR156   BR20.1
                                                                 BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR420   BR450
                                                                 BR521   BRIP.1

                         ACRETNGX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Required

                            RGX-ACCT-CATEGORY    -> AAX-ACCT-CATEGORY

Acactivity     ACACTIVITY   Required

                            RGX-ACTIVITY         -> ACV-ACTIVITY

Pst Acct Cat   ACACCTCAT    Required

                            RGX-PST-ACCT-CAT     -> AAX-ACCT-CATEGORY

Pst Activity   ACACTIVITY   Required

                            RGX-PST-ACTIVITY     -> ACV-ACTIVITY

Pst Gl Code    ACGLCODE     Required

                            RGX-PST-GL-CODE      -> AGC-AC-GL-CODE