Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACPRMSTNX


                             ACPRMSTNX FILE

REFERENCED BY

BR254

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PMX-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.


PMX-MILESTONE          Alpha 3                                   BR54.2  BR54.3
Element: Milestone                                               BR54.4

PMX-DESCRIPTION        Alpha 30  (Lower Case)                    BR54.2  BR54.3
Element: Description   This field displays the description.      BR54.4

PMX-DATE               Numeric 8  (yyyymmdd)                     BR54.2  BR54.3
Element: Date          This field displays the system date       BR54.4
                       when this was created.

PMX-DAYS               Numeric 4                                 BR54.2  BR54.3
Element: Days                                                    BR54.4

PMX-PERC-COMPLETE      Signed 7.3
Element: Perc Complete

PMX-BUDGET-TYPE        Alpha 1
Element: Budget Type

PMX-BILL-AMOUNT        Signed 18.2                               BR54.2  BR54.3
Element: Intl Amt                                                BR54.4

PMX-MILESTONE-PCT      Signed 18.2                               BR54.2  BR54.3
Element: Intl Amt                                                BR54.4

PMX-STATUS             Numeric 1                                 BR02.3  BR120
Element: Status        This field displays the status of the     BR121   BR122
                       transaction.                              BR123   BR140
                       1 = To Process                            BR151   BR152
                       2 = Processed                             BR156   BR20.1
                       3 = Hold                                  BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR420   BR521
                                                                 BR54.2  BR54.3
                                                                 BR54.4

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

PMX-DUE-DATE           Numeric 8  (yyyymmdd)                     BR54.2  BR54.3
Element: Date          This field displays the system date       BR54.4
                       when this was created.

PMX-INVOICE            Alpha 22
Element: Invoice       Used to identify the invoice.

PMX-PMH-OBJ-ID         Numeric 12
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.

PMX-PROFORMA-FL        Alpha 1                                   BR02.3  BR120
Element: Flag1         Y = Yes                                   BR121   BR122
                       N = No                                    BR123   BR140
                                                                 BR151   BR152
                                                                 BR156   BR20.1
                                                                 BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR420   BR521

                         ACPRMSTNX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

PMXSET2   ACTIVITY      KeyChange                                BR02.3  BR120
          MILESTONE-CAT                                          BR121   BR122
          MILESTONE                                              BR123   BR140
          STATUS                                                 BR151   BR152
                                                                 BR156   BR20.1
                                                                 BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR254   BR420
                                                                 BR521

PMXSET3   PMH-OBJ-ID    KeyChange
          ACTIVITY
          MILESTONE-CAT
          MILESTONE

                         ACPRMSTNX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactivity     ACACTIVITY   Required

                            PMX-ACTIVITY         -> ACV-ACTIVITY  (ACVSET1)

Acpmhsthdr     ACPMHSTHDR   Not Required

                            PMX-PMH-OBJ-ID       -> PMH-OBJ-ID

Acprmstn       ACPRMSTN     Required

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