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 / column | Type | Description & values | Updated by |
|---|---|---|---|
POL-POOL-NAME PKPOOL_NAME | Alpha 12 | This 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-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This is the description of the pool. | AC32.1 |
POL-STATUSSTATUS | Numeric 1 | This is the pool status.
| AC32.1 |
POL-SOURCE-CODESOURCE_CODE | Alpha 2 | This code indicates whether the pool is activity-based or general-ledger-based.
| AC32.1 |
POL-TRANS-TYPETRANS_TYPE | Alpha 1 | This field indicates the type of values to be allocated: amount or units.
| AC32.1 |
POL-CUM-BASISCUM_BASIS | Alpha 1 | This field indicates the period of time over which the pool is allocated: period, year-to-date, or life-to-date.
| AC32.1 |
POL-ACTIVITYACTIVITY | Alpha 15 | This is the activity for which account categories are accumulated in the allocation pool. | AC32.1 |
POL-MATRIX-LISTMATRIX_LIST | Alpha 12 | Selected account categories for activities with this attribute are accumulated in the allocation pool. | AC32.1 |
POL-ACTIVITY-GRPACTIVITY_GRP | Alpha 15 | Selected account categories for activities from this activity group are accumulated into the allocation pool. | AC32.1 |
POL-FR-ACCT-CATFR_ACCT_CAT | Alpha 5 | This is the beginning of a range of account categories to be accumulated into the allocation pool. | AC32.1 |
POL-TH-ACCT-CATTH_ACCT_CAT | Alpha 5 | This is the end of a range of account categories to be accumulated into the allocation pool. | AC32.1 |
POL-GROUPGROUP | Alpha 15 | Selected account categories belonging to this group are accumulated in the allocation pool. | AC32.1 |
POL-COMPUTE-NAMECOMPUTE_NAME | Alpha 12 | The 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-INFOCOMPUTE_INFO | Alpha 1 | — | — |
POL-COMPANYCOMPANY | Numeric 4 | This is the General Ledger company used when evaluating General Ledger data names in the compute statement. | AC32.1 |
POL-ACCT-UNITACCT_UNIT | Alpha 15 | This is the accounting unit used when evaluating General Ledger data names in the compute statement. | AC32.1 |
POL-FR-ACCOUNTFR_ACCOUNT | Numeric 6 | This is the beginning of a range of accounts used when evaluating General Ledger data names in the compute statement. | AC32.1 |
POL-TH-ACCOUNTTH_ACCOUNT | Numeric 6 | This is the end of a range of accounts used when evaluating General Ledger data names in the compute statement. | AC32.1 |
POL-FR-SUB-ACCTFR_SUB_ACCT | Numeric 4 | This is the beginning of a subaccount range used when evaluating General Ledger data names in the compute statement. | AC32.1 |
POL-TH-SUB-ACCTTH_SUB_ACCT | Numeric 4 | This is the end of a subaccount range used when evaluating General Ledger data names in the compute statement. | AC32.1 |
POL-ALLOCATEDALLOCATED | Signed 18.2 | This 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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
POLSET1 | POOL-NAME | Primary | AC121, AC123, AC130, AC131, AC20.1, AC20.2, AC20.3, AC20.4 +7 more |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Cmpute | CMPUTE | Not Required | POL-COMPUTE-NAME → CMP-COMPUTE-NAME |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Acpooldtl | ACPOOLDTL | POL-POOL-NAME → PDL-POOL-NAME, → PDL-ALLOC-NAME, → PDL-ACTIVITY, → PDL-ACCT-CATEGORY |
Programs
Updated by (2)
Referenced by (13)
- AC121 Budget Calculation
- AC123 Budget Copy
- AC130 Allocation Calculation
- AC20.1 Life Only Budget
- AC20.2 Annual Budget
- AC20.3 Period Budget
- AC20.4 Activity Budgets by Activity
- AC20.5 Activity Budgets by Account Category
- AC30.1 Allocation
- AC30.2 Multiple Pool Allocation
- AC30.3 List Allocation
- AC37.1 Allocation Group
- AC490 Activity Reconciliation