ACPRMSTN – No description in the Lawson data dictionary

System
AC Billing Revenue (BR)
Prefix
PMS
Primary key
ACTIVITY, MILESTONE-CAT
Fields
6
Updated by
4 programs
Referenced by
17 programs

ACPRMSTN is a Lawson AC Billing Revenue table (prefix PMS); no description in the lawson data dictionary. It is indexed by ACTIVITY, MILESTONE-CAT (PMSSET1); alternate indexes: PMSSET2. It is related 1:1 to ACACCTCAT and ACACTIVITY and 1:M to ACPRMSTNX. It is updated by BR51.1, BR54.2, BR54.3 and BR54.4 and referenced by BR02.3, BR120, BR121, BR122, BR123, BR140, BR151, BR152 and 9 more. The table has 6 fields, 2 indexes and 3 documented relations.

About ACPRMSTN

No description in the Lawson data dictionary.

Fields (6)

Column = COBOL field name without the PMS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
PMS-ACTIVITY PK
ACTIVITY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.BR54.2, BR54.3, BR54.4
PMS-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5Account categories are groupings of 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 thruBR54.2, BR54.3, BR54.4
PMS-MILESTN-TYPE
MILESTN_TYPE		Numeric 1—
  • 1 Days
  • 2 Date
  • 3 Percent Complete
  • 4 Manual
BR54.2, BR54.3, BR54.4
PMS-BALANCE
BALANCE		Signed 18.2—BR54.2, BR54.3, BR54.4
PMS-MILE-PCT-BAL
MILE_PCT_BAL		Signed 7.4—BR54.2, BR54.3, BR54.4
PMS-MILESTONE-CAT PK
MILESTONE_CAT		Alpha 1—
  • 1 Product Revenue
  • 2 Product Billing
BR54.2, BR54.3, BR54.4

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PMSSET1ACTIVITY, MILESTONE-CATPrimaryBR02.3, BR120, BR121, BR122, BR123, BR140, BR151, BR152 +14 more
PMSSET2MILESTN-TYPE, ACTIVITY, MILESTONE-CATKeyChangeBR54.2, BR54.3, BR54.4

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATNot RequiredPMS-ACCT-CATEGORY → AAX-ACCT-CATEGORY
AcactivityACACTIVITYRequiredPMS-ACTIVITY → ACV-ACTIVITY

One to many (1) — child tables

RelationTableRulesConditionField map
AcprmstnxACPRMSTNXPMS-ACTIVITY → PMX-ACTIVITY, PMS-MILESTONE-CAT → PMX-MILESTONE-CAT, → PMX-MILESTONE

Programs

Updated by (4)

Referenced by (17)