Lawson Insight Technical Documentation | 
  
    
  | 
  
                             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
 |