ACPOOLDTL – Pool Acct Unit/Activity Detail
- System
- Activity Management (AC)
- Prefix
PDL- Primary key
POOL-NAME,ALLOC-NAME,ACTIVITY,ACCT-CATEGORY- Fields
- 9
- Updated by
- 5 programs
- Referenced by
- 0 programs
ACPOOLDTL is the Pool Acct Unit/Activity Detail table in Lawson Activity Management (prefix PDL). It is indexed by POOL-NAME, ALLOC-NAME, ACTIVITY, ACCT-CATEGORY (PDLSET1); alternate indexes: PDLSET3. It is updated by AC130, AC30.1, AC30.2, AC30.3 and AC32.1. The table has 9 fields, 2 indexes and 0 documented relations.
About ACPOOLDTL
No description in the Lawson data dictionary.
Fields (9)
Column = COBOL field name without the PDL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
PDL-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). | AC130 |
PDL-ALLOC-NAME PKALLOC_NAME | Alpha 12 | This is the allocation as defined in AC30.1 (Allocation). | AC130 |
PDL-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. | AC130 |
PDL-ACCT-CATEGORY PKACCT_CATEGORY | Alpha 5 | This is the account category for which amounts or units are accumulated into the pool to be allocated. | AC130 |
PDL-COMPANYCOMPANY | Numeric 4 | Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. | — |
PDL-ACCT-UNITACCT_UNIT | Alpha 15 | This is the accounting unit for which amounts and units are accumulated into the pool to be allocated. | AC130 |
PDL-ACCOUNTACCOUNT | Numeric 6 | This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored. | — |
PDL-SUB-ACCOUNTSUB_ACCOUNT | Numeric 4 | This is the subaccount for which amounts or units are accumulated into the pool to be allocated. | AC130 |
PDL-POOL-AMTPOOL_AMT | Signed 18.2 | This is the amount to be allocated. | AC130 |
Indexes (2)
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 |
|---|---|---|---|---|
PDLSET1 | POOL-NAME, ALLOC-NAME, ACTIVITY, ACCT-CATEGORY | Primary | AC130 | |
PDLSET3 | POOL-NAME, ALLOC-NAME, ACCT-CATEGORY, ACTIVITY | AC130, AC30.1, AC30.2, AC30.3, AC32.1 |