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