Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACPOOLHDR


                             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    AC37.1
AC490

UPDATED BY

AC131     AC32.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

POL-POOL-NAME          Alpha 12                                  AC32.1
Element: Allocation PooThis 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
Element: Pool DescriptiThis is the description of the pool.

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

POL-SOURCE-CODE        Alpha 2                                   AC32.1
Element: 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
Element: Transaction TyThis field indicates the type of values
                       to be allocated: amount or units.
                       A = Amount
                       U = Units

POL-CUM-BASIS          Alpha 1                                   AC32.1
Element: Cumulative BasThis 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
Element: Activity      This is the activity for which account
                       categories are accumulated in the
                       allocation pool.

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

POL-ACTIVITY-GRP       Alpha 15                                  AC32.1
Element: 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
Element: Group         Selected account categories belonging
                       to this group are accumulated in the
                       allocation pool.

POL-COMPUTE-NAME       Alpha 12                                  AC32.1
Element: Name User     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.

POL-COMPUTE-INFO       Alpha 1
Element: Account Flag

POL-COMPANY            Numeric 4                                 AC32.1
Element: 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
Element: Accounting UniThis is the accounting unit used when
                       evaluating General Ledger data names in
                       the compute statement.

POL-FR-ACCOUNT         Numeric 6                                 AC32.1
Element: 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
Element: Through AccounThis 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
Element: From SubaccounThis 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
Element: Through SubaccThis is the end of a subaccount range
                       used when evaluating General Ledger data
                       names in the compute statement.

POL-ALLOCATED          Signed 15.2                               AC131
Element: 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  AC37.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