|
|
ACPRMSTN FILE
The ACPRMSTN file stores data related to product contract milestone headers.
This file is primarily updated by Product Billing Milestones (BR54.1). This
file has relations with the ACACCTCAT, ACACTIVITY, and ACPRMSTNX files.
REFERENCED BY
BR151 BR254
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: Account CategoAccount 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.
PMS-MILESTN-TYPE Numeric 1 BR54.2 BR54.3
Element: Milestone Type1 = Days BR54.4
2 = Date
3 = Percent Complete
4 = Manual
PMS-BALANCE Signed 15.2 BR54.2 BR54.3
Element: Adj 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 BR151 BR254
MILESTONE-CAT BR51.1 BR54.1
BR54.2 BR54.3
BR54.4
PMSSET2 MILESTN-TYPE 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
|
