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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#PMS-ACTIVITY PKACTIVITY | Alpha 15 | Activities 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-CATEGORYACCT_CATEGORY | Alpha 5 | Account 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 thru | BR54.2, BR54.3, BR54.4 |
#PMS-MILESTN-TYPE SET2MILESTN_TYPE | Numeric 1 | —
| BR54.2, BR54.3, BR54.4 |
#PMS-BALANCEBALANCE | Signed 18.2 | — | BR54.2, BR54.3, BR54.4 |
#PMS-MILE-PCT-BALMILE_PCT_BAL | Signed 7.4 | — | BR54.2, BR54.3, BR54.4 |
#PMS-MILESTONE-CAT PKMILESTONE_CAT | Alpha 1 | —
| BR54.2, BR54.3, BR54.4 |
Indexes (2)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PMSSET1 |
| Primary | BR02.3, BR120, BR121, BR122, BR123, BR140, BR151, BR152 +14 more | |
PMSSET2 |
| KeyChange | BR54.2, BR54.3, BR54.4 |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||
|---|---|---|---|---|---|---|---|
| Acacctcat | ACACCTCAT | Not Required |
| ||||
| Acactivity | ACACTIVITY | Required |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Acprmstnx | ACPRMSTNX |
|
Programs
Updated by (4)
- BR51.1 Product Contract
- BR54.2 Days Product Billing Milestones
- BR54.3 Date Product Billing Milestones
- BR54.4 Manual Product Billing Milestones
Referenced by (17)
- BR02.3 Retainer Invoice Entry
- BR120 Invoice Calculation
- BR121 Invoice Print and Interface
- BR122 Online batch invoice process
- BR123 Product Invoice Cancel
- BR140 Billing and Revenue Backout
- BR151 Product Invoicing
- BR152 Maintenance Invoicing
- BR156 Maintenance Quote
- BR20.1 Invoice Edit Contract
- BR20.2 Invoice Edit Line
- BR20.3 Invoice Edit Activity
- BR20.4 Invoice Edit Activity and Account Category
- BR20.5 Invoice Edit Transaction
- BR254 Product Milestone Listing
- BR420 Billing Invoice Report
- BR521 Billing Import