Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             ACPOOLHDR FILE

                         Allocation Pool Header

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

REFERENCED BY

AC121     AC123     AC130     AC20.1    AC20.2    AC20.3
AC20.4    AC20.5    AC30.1    AC30.2    AC30.3    AC490

UPDATED BY

AC131     AC32.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

POL-POOL-NAME        Alpha 12                                    AC32.1
Allocation Pool      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).

POL-DESCRIPTION      Alpha 30  (Lower Case)                      AC32.1
Pool Description     This is the description of the pool.

POL-STATUS           Numeric 1                                   AC32.1
Status               This is the pool status.
                     1 = Active
                     2 = Inactive

POL-SOURCE-CODE      Alpha 2                                     AC32.1
Pool Source          This code indicates whether the pool is
                     activity-based or general-ledger-based.
                     AC = Activity Management Pool
                     GL = General Ledger Pool

POL-TRANS-TYPE       Alpha 1                                     AC32.1
Transaction Type     This field indicates the type of values
                     to be allocated: amount or units.
                     A = Amount
                     U = Units

POL-CUM-BASIS        Alpha 1                                     AC32.1
Cumulative Basis     This 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

POL-ACTIVITY         Alpha 15                                    AC32.1
Activity             This is the activity for which account
                     categories are accumulated in the
                     allocation pool.

POL-MATRIX-LIST      Alpha 12                                    AC32.1
Attribute List       Selected account categories for
                     activities with this attribute are
                     accumulated in the allocation pool.

POL-ACTIVITY-GRP     Alpha 15                                    AC32.1
Activity Group       Selected account categories for
                     activities from this activity group are
                     accumulated into the allocation pool.

POL-FR-ACCT-CAT      Alpha 5                                     AC32.1
From Account         This is the beginning of a range of
Category             account categories to be accumulated
                     into the allocation pool.

POL-TH-ACCT-CAT      Alpha 5                                     AC32.1
Through Account      This is the end of a range of account
Category             categories to be accumulated into the
                     allocation pool.

POL-GROUP            Alpha 15                                    AC32.1
Group                Selected account categories belonging
                     to this group are accumulated in the
                     allocation pool.

POL-COMPUTE-NAME     Alpha 12                                    AC32.1
Compute Statement    The compute statement name is the name
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.

POL-COMPUTE-INFO     Alpha 1
Compute Info

POL-COMPANY          Numeric 4                                   AC32.1
Company              This is the General Ledger company used
                     when evaluating General Ledger data
                     names in the compute statement.

POL-ACCT-UNIT        Alpha 15                                    AC32.1
Accounting Unit      This is the accounting unit used when
                     evaluating General Ledger data names in
                     the compute statement.

POL-FR-ACCOUNT       Numeric 6                                   AC32.1
From Account         This is the beginning of a range of
                     accounts used when evaluating General
                     Ledger data names in the compute
                     statement.

POL-TH-ACCOUNT       Numeric 6                                   AC32.1
Through Account      This is the end of a range of accounts
                     used when evaluating General Ledger data
                     names in the compute statement.

POL-FR-SUB-ACCT      Numeric 4                                   AC32.1
From Subaccount      This is the beginning of a subaccount
                     range used when evaluating General
                     Ledger data names in the compute
                     statement.

POL-TH-SUB-ACCT      Numeric 4                                   AC32.1
Through Subaccount   This is the end of a subaccount range
                     used when evaluating General Ledger data
                     names in the compute statement.

POL-ALLOCATED        Signed 15.2                                 AC131
Allocated            This is the amount to be allocated.

                         ACPOOLHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

POLSET1   POOL-NAME                                              AC121   AC123
                                                                 AC130   AC131
                                                                 AC20.1  AC20.2
                                                                 AC20.3  AC20.4
                                                                 AC20.5  AC30.1
                                                                 AC30.2  AC30.3
                                                                 AC32.1  AC490

                         ACPOOLHDR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cmpute         CMPUTE       Not Required

                            POL-COMPUTE-NAME    -> CMP-COMPUTE-NAME

                         ACPOOLHDR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acpooldtl      ACPOOLDTL

                            POL-POOL-NAME       -> PDL-POOL-NAME
                                                   PDL-ALLOC-NAME
                                                   PDL-ACTIVITY
                                                   PDL-ACCT-CATEGORY