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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PDL-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).AC130
#PDL-ALLOC-NAME PK
ALLOC_NAME		Alpha 12This is the allocation as defined in AC30.1 (Allocation).AC130
#PDL-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.AC130
#PDL-ACCT-CATEGORY PK
ACCT_CATEGORY		Alpha 5This is the account category for which amounts or units are accumulated into the pool to be allocated.AC130
#PDL-COMPANY
COMPANY		Numeric 4Identifies 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-UNIT
ACCT_UNIT		Alpha 15This is the accounting unit for which amounts and units are accumulated into the pool to be allocated.AC130
#PDL-ACCOUNT
ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.—
#PDL-SUB-ACCOUNT
SUB_ACCOUNT		Numeric 4This is the subaccount for which amounts or units are accumulated into the pool to be allocated.AC130
#PDL-POOL-AMT
POOL_AMT		Signed 18.2This is the amount to be allocated.AC130

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.

IndexKeysFlagsConditionUsed in
PDLSET1
  1. POOL-NAME
  2. ALLOC-NAME
  3. ACTIVITY
  4. ACCT-CATEGORY
PrimaryAC130
PDLSET3
  1. POOL-NAME
  2. ALLOC-NAME
  3. ACCT-CATEGORY
  4. ACTIVITY
AC130, AC30.1, AC30.2, AC30.3, AC32.1

Programs

Updated by (5)