|
|
ACPRMSTNX FILE
The ACPRMSTNX file contains milestone detail information for product contract
billing. This file is primarily updated by Days Product Billing Milestones
(BR54.2), Date Product Billing Milestones (BR54.3), and Manual Product Billing
Milestones (BR54.4). This file has relations with the ACPRMSTN, ACACTIVITY,
and ACPMHSTHDR files.
REFERENCED BY
BR254
UPDATED BY
BR123 BR151 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: Percent Complete
PMX-BUDGET-TYPE Alpha 1
Element: Budget Type
PMX-BILL-AMOUNT Signed 15.2 BR54.2 BR54.3
Element: Adj Amt BR54.4
PMX-MILESTONE-PCT Signed 15.2 BR54.2 BR54.3
Element: Adj Amt BR54.4
PMX-STATUS Numeric 1 BR123 BR151
Element: Status This field displays the status of the BR54.2 BR54.3
transaction. BR54.4
1 = To Process
2 = Processed
3 = Hold
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 The transaction due date. BR54.4
PMX-INVOICE Alpha 22
Element: Invoice NumberUsed to identify the invoice.
PMX-PMH-OBJ-ID Numeric 12
Object
Identification
PMX-PROFORMA-FL Alpha 1 BR151
Tax Distrib. Flag - Y = Yes
Tax Code 1 N = No
ACPRMSTNX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PMXSET1 ACTIVITY BR123 BR151
MILESTONE-CAT BR51.1 BR54.2
MILESTONE BR54.3 BR54.4
PMXSET2 ACTIVITY KeyChange BR151 BR254
MILESTONE-CAT
MILESTONE
STATUS
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
|
