Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACPRMSTN


                             ACPRMSTN FILE

REFERENCED BY

BR02.3    BR120     BR121     BR122     BR123     BR140
BR151     BR152     BR156     BR20.1    BR20.2    BR20.3
BR20.4    BR20.5    BR254     BR420     BR521

UPDATED BY

BR54.2    BR54.3    BR54.4    BR51.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PMS-ACTIVITY           Alpha 15                                  BR54.2  BR54.3
Element: Activity      Activities are the processes or           BR54.4
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


PMS-ACCT-CATEGORY      Alpha 5                                   BR54.2  BR54.3
Element: Acct Category Account categories are groupings of       BR54.4
                       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

PMS-MILESTN-TYPE       Numeric 1                                 BR54.2  BR54.3
Element: Milestn Type  1 = Days                                  BR54.4
                       2 = Date
                       3 = Percent Complete
                       4 = Manual

PMS-BALANCE            Signed 18.2                               BR54.2  BR54.3
Element: Intl Amt                                                BR54.4

PMS-MILE-PCT-BAL       Signed 7.4                                BR54.2  BR54.3
Element: Mile Pct Bal                                            BR54.4

PMS-MILESTONE-CAT      Alpha 1                                   BR54.2  BR54.3
Element: Milestone Cat 1 = Product Revenue                       BR54.4
                       2 = Product Billing

                         ACPRMSTN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PMSSET1   ACTIVITY                                               BR02.3  BR120
          MILESTONE-CAT                                          BR121   BR122
                                                                 BR123   BR140
                                                                 BR151   BR152
                                                                 BR156   BR20.1
                                                                 BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR254   BR420
                                                                 BR51.1  BR521
                                                                 BR54.1  BR54.2
                                                                 BR54.3  BR54.4

PMSSET2   MILESTN-TYPE  KeyChange                                BR54.2  BR54.3
          ACTIVITY                                               BR54.4
          MILESTONE-CAT

                         ACPRMSTN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Not Required

                            PMS-ACCT-CATEGORY    -> AAX-ACCT-CATEGORY

Acactivity     ACACTIVITY   Required

                            PMS-ACTIVITY         -> ACV-ACTIVITY

                         ACPRMSTN FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acprmstnx      ACPRMSTNX

                            PMS-ACTIVITY         -> PMX-ACTIVITY
                            PMS-MILESTONE-CAT    -> PMX-MILESTONE-CAT
                                                    PMX-MILESTONE