ACPOOLHDR – Allocation Pool Header

System
Activity Management (AC)
Prefix
POL
Primary key
POOL-NAME
Fields
21
Updated by
2 programs
Referenced by
13 programs

ACPOOLHDR is the Allocation Pool Header table in Lawson Activity Management (prefix POL). It is indexed by POOL-NAME (POLSET1). It is related 1:1 to CMPUTE and 1:M to ACPOOLDTL. It is updated by AC131 and AC32.1 and referenced by AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 and 5 more. The table has 21 fields, 1 index and 2 documented relations.

About ACPOOLHDR

This file contains header information about allocation pools from AC32.1 (Allocation Pool).

Fields (21)

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

Field / columnTypeDescription & valuesUpdated by
POL-POOL-NAME PK
POOL_NAME
Alpha 12This is the name assigned to the pool (amount to be allocated). A pool consists of posted monetary amounts or statistical units found in ranges of activities and account categories or ranges of companies, accounting units, accounts, and subaccounts specified in AC32.1 (Allocation Pool). Pool balances can be accumulated on a period, year-to-date, or life-to-date (activity pools only) basis. A pool is attached to an allocation in AC30.1 (Allocation) or to individual allocation lines in AC30.2 (Multiple Pool Allocation).AC32.1
POL-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)This is the description of the pool.AC32.1
POL-STATUS
STATUS
Numeric 1This is the pool status.
  • 1 Active
  • 2 Inactive
AC32.1
POL-SOURCE-CODE
SOURCE_CODE
Alpha 2This code indicates whether the pool is activity-based or general-ledger-based.
  • AC Activity Management Pool
  • GL General Ledger Pool
AC32.1
POL-TRANS-TYPE
TRANS_TYPE
Alpha 1This field indicates the type of values to be allocated: amount or units.
  • A Amount
  • U Units
AC32.1
POL-CUM-BASIS
CUM_BASIS
Alpha 1This field indicates the period of time over which the pool is allocated: period, year-to-date, or life-to-date.
  • P Period-to-date
  • Y Year-to-date
  • L Life-to-date
AC32.1
POL-ACTIVITY
ACTIVITY
Alpha 15This is the activity for which account categories are accumulated in the allocation pool.AC32.1
POL-MATRIX-LIST
MATRIX_LIST
Alpha 12Selected account categories for activities with this attribute are accumulated in the allocation pool.AC32.1
POL-ACTIVITY-GRP
ACTIVITY_GRP
Alpha 15Selected account categories for activities from this activity group are accumulated into the allocation pool.AC32.1
POL-FR-ACCT-CAT
FR_ACCT_CAT
Alpha 5This is the beginning of a range of account categories to be accumulated into the allocation pool.AC32.1
POL-TH-ACCT-CAT
TH_ACCT_CAT
Alpha 5This is the end of a range of account categories to be accumulated into the allocation pool.AC32.1
POL-GROUP
GROUP
Alpha 15Selected account categories belonging to this group are accumulated in the allocation pool.AC32.1
POL-COMPUTE-NAME
COMPUTE_NAME
Alpha 12The compute statement name is the name assigned to an arithmetic equation created in RW50.1 (Compute Statement). The equation is used to determine the amount of the pool to allocate.AC32.1
POL-COMPUTE-INFO
COMPUTE_INFO
Alpha 1
POL-COMPANY
COMPANY
Numeric 4This is the General Ledger company used when evaluating General Ledger data names in the compute statement.AC32.1
POL-ACCT-UNIT
ACCT_UNIT
Alpha 15This is the accounting unit used when evaluating General Ledger data names in the compute statement.AC32.1
POL-FR-ACCOUNT
FR_ACCOUNT
Numeric 6This is the beginning of a range of accounts used when evaluating General Ledger data names in the compute statement.AC32.1
POL-TH-ACCOUNT
TH_ACCOUNT
Numeric 6This is the end of a range of accounts used when evaluating General Ledger data names in the compute statement.AC32.1
POL-FR-SUB-ACCT
FR_SUB_ACCT
Numeric 4This is the beginning of a subaccount range used when evaluating General Ledger data names in the compute statement.AC32.1
POL-TH-SUB-ACCT
TH_SUB_ACCT
Numeric 4This is the end of a subaccount range used when evaluating General Ledger data names in the compute statement.AC32.1
POL-ALLOCATED
ALLOCATED
Signed 18.2This is the amount to be allocated.AC131

Indexes (1)

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

IndexKeysFlagsConditionUsed in
POLSET1POOL-NAMEPrimaryAC121, AC123, AC130, AC131, AC20.1, AC20.2, AC20.3, AC20.4 +7 more

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
CmputeCMPUTENot RequiredPOL-COMPUTE-NAMECMP-COMPUTE-NAME

One to many (1) — child tables

RelationTableRulesConditionField map
AcpooldtlACPOOLDTLPOL-POOL-NAMEPDL-POOL-NAME, PDL-ALLOC-NAME, PDL-ACTIVITY, PDL-ACCT-CATEGORY

Programs

Updated by (2)

Referenced by (13)