ACPRMSTNX – No description in the Lawson data dictionary

System
AC Billing Revenue (BR)
Prefix
PMX
Primary key
ACTIVITY, MILESTONE-CAT, MILESTONE
Fields
15
Updated by
21 programs
Referenced by
1 program

ACPRMSTNX is a Lawson AC Billing Revenue table (prefix PMX); no description in the lawson data dictionary. It is indexed by ACTIVITY, MILESTONE-CAT, MILESTONE (PMXSET1); alternate indexes: PMXSET2 and PMXSET3. It is related 1:1 to ACACTIVITY, ACPMHSTHDR and ACPRMSTN. It is updated by BR02.3, BR120, BR121, BR122, BR123, BR140, BR151, BR152 and 13 more and referenced by BR254. The table has 15 fields, 3 indexes and 3 documented relations.

About ACPRMSTNX

No description in the Lawson data dictionary.

Fields (15)

Column = COBOL field name without the PMX- 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 / columnTypeDescription & valuesUpdated by
#PMX-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
#PMX-MILESTONE PK
MILESTONE		Alpha 3—BR54.2, BR54.3, BR54.4
#PMX-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.BR54.2, BR54.3, BR54.4
#PMX-DATE
DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.BR54.2, BR54.3, BR54.4
#PMX-DAYS
DAYS		Numeric 4—BR54.2, BR54.3, BR54.4
#PMX-PERC-COMPLETE
PERC_COMPLETE		Signed 7.3——
#PMX-BUDGET-TYPE
BUDGET_TYPE		Alpha 1——
#PMX-BILL-AMOUNT
BILL_AMOUNT		Signed 18.2—BR54.2, BR54.3, BR54.4
#PMX-MILESTONE-PCT
MILESTONE_PCT		Signed 18.2—BR54.2, BR54.3, BR54.4
#PMX-STATUS SET2
STATUS		Numeric 1This field displays the status of the transaction.
  • 1 To Process
  • 2 Processed
  • 3 Hold
BR02.3, BR120, BR121, BR122, BR123, BR140, BR151, BR152 +11 more
#PMX-MILESTONE-CAT PK
MILESTONE_CAT		Alpha 1—
  • 1 Product Revenue
  • 2 Product Billing
BR54.2, BR54.3, BR54.4
#PMX-DUE-DATE
DUE_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.BR54.2, BR54.3, BR54.4, BRIP.1
#PMX-INVOICE
INVOICE		Alpha 22Used to identify the invoice.BRIP.1
#PMX-PMH-OBJ-ID SET3
PMH_OBJ_ID		Numeric 12This 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.BRIP.1
#PMX-PROFORMA-FL
PROFORMA_FL		Alpha 1—
  • Y Yes
  • N No
BR02.3, BR120, BR121, BR122, BR123, BR140, BR151, BR152 +8 more

Indexes (3)

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.

IndexKeysFlagsConditionUsed in
PMXSET1
  1. ACTIVITY
  2. MILESTONE-CAT
  3. MILESTONE
PrimaryBR02.3, BR120, BR121, BR122, BR123, BR140, BR151, BR152 +13 more
PMXSET2
  1. ACTIVITY
  2. MILESTONE-CAT
  3. MILESTONE
  4. STATUS
KeyChangeBR02.3, BR120, BR121, BR122, BR123, BR140, BR151, BR152 +9 more
PMXSET3
  1. PMH-OBJ-ID
  2. ACTIVITY
  3. MILESTONE-CAT
  4. MILESTONE
KeyChange—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACACTIVITYACPMHSTHDRACPRMSTNACPRMSTNX

One to one (3) — lookups and parents

RelationTableRulesConditionField map
AcactivityACACTIVITYRequired
PMX-ACTIVITY→ACV-ACTIVITY (ACVSET1)
AcpmhsthdrACPMHSTHDRNot Required
PMX-PMH-OBJ-ID→PMH-OBJ-ID
AcprmstnACPRMSTNRequired
PMX-ACTIVITY→PMS-ACTIVITY
PMX-MILESTONE-CAT→PMS-MILESTONE-CAT

Programs

Updated by (21)

Referenced by (1)