Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACALLOC


                              ACALLOC FILE

                          Activity Allocation

The Activity Allocation file stores information on new allocations from
AC30.3 (New Allocation).

REFERENCED BY

AC230     AC32.1

UPDATED BY

AC130     AC131     AC30.1    AC30.2    AC30.3    AC30.4
AC37.1    AC37.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AOC-ALLOC-NAME         Alpha 12                                  AC30.4
Element: Allocation NamThis is the allocation name. Allocation
                       name is defined in AC30.1 (Allocation).

AOC-DESCRIPTION        Alpha 30  (Lower Case)                    AC30.4
Allocation             This is the allocation description.
Description

AOC-POOL-NAME          Alpha 12                                  AC30.1  AC30.2
Element: Allocation PooThis is the name assigned to the pool     AC30.3
                       (or 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
                       (for 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).

AOC-ALLOC-TYPE         Alpha 1                                   AC30.4
Element: Allocation TypThis field defines where the allocation
                       will take place.

                       A = AC Only
                       B = Both AC and GL

AOC-OPERATOR           Alpha 10                                  AC30.1  AC30.2
Element: Operator      This field displays the login ID of the   AC30.3  AC30.4
                       person who entered an allocation record.


AOC-AUTO-ZERO          Alpha 1                                   AC30.4
Element: Auto Zero     If you set this field to Yes (Y),
                       percents you enter in AC30.1
                       (Allocation) are zeroed out after the
                       allocation is processed.
                       Y = Yes
                       N = No

AOC-AUTO-REV           Alpha 1                                   AC30.4
Element: Auto Reverse  If you set this field to Yes (Y), a
                       reversing entry is created by AC131
                       (Allocation Update) in the run following
                       the run that creates the original entry.

                       Y = Yes
                       N = No

AOC-STATUS             Numeric 1                                 AC130   AC131
Element: Status        This is the allocation status.            AC30.1  AC30.2
                       0 = Unreleased                            AC30.3  AC30.4
                       1 = Released                              AC37.1  AC37.2
                       2 = Calculated

AOC-DEFAULT-DESC       Alpha 30  (Lower Case)                    AC30.4
Element: Default DescriThis description becomes the
                       transaction description for each
                       transaction whose Description field in
                       AC30.6 (Entry) has been left blank.

                       If this field is left blank in AC30.3
                       (New Allocation), the allocation
                       description defaults into this field.

AOC-PF-ACTIVITY        Alpha 15                                  AC30.4
Element: Post-From ActiOptional. This field specifies the
                       activity to which an offsetting
                       transaction is posted.

AOC-PF-ACCT-CAT        Alpha 5                                   AC30.4
Post-From Account      This is the account category of the
Category               post-from activity, to which an
                       offsetting transaction is posted.

AOC-CONTROL-GROUP      Numeric 8                                 AC131   AC30.4
Element: Control Group This is the control group number
                       assigned to the transactions created by
                       the most recent run of AC131 (Allocation
                       Update).

AOC-MAINT-DATE         Numeric 8  (yyyymmdd)                     AC30.1  AC30.2
Element: Maintenance DaThis is the date the allocation was       AC30.3  AC30.4
                       last changed.

AOC-MAINT-TIME         Numeric 6  (hhmmss)                       AC30.1  AC30.2
Element: Maintenance TiThis is the time the allocation was       AC30.3  AC30.4
                       last changed.

AOC-RUN-DATE           Numeric 8  (yyyymmdd)                     AC130
Element: Run Date      This is the date of the most recent
                       processing run of AC131 (Allocation
                       Update).

AOC-RUN-TIME           Numeric 6  (hhmmss)                       AC130
Element: Run Time      This is the time of the most recent
                       processing run of AC131 (Allocation
                       Update).

AOC-ALLOCATED-DATE     Numeric 8  (yyyymmdd)                     AC131
Element: Allocated DateThis is the date the allocation amount
                       was allocated.

AOC-ALLOCATED-TIME     Numeric 6  (hhmmss)                       AC131
Element: Allocated TimeThis is the time the allocation amount
                       was allocated.

AOC-TOTAL-PCT          Signed 11.4                               AC131   AC30.1
Element: Total Percent This is the sum of the percent values     AC30.2  AC30.3
                       entered in the detail lines of AC30.1
                       (Allocation).

AOC-LAST-CMT-SEQ       Numeric 4
Last Comment           This is the sequence number of the last
Sequence Number        comment for the allocation.

AOC-LAST-LINE-NBR      Numeric 6                                 AC30.1  AC30.3
Element: Last Line NumbThis is the number of the last line
                       item added to the allocation. It is used
                       to determine the line number when the
                       next line is added to the allocation.

AOC-NBR-LINES          Numeric 6
Number of Detail       This field indicates the number of
Lines                  detail lines for the allocation.

AOC-NBR-CMT-LINES      Numeric 6
Number of Comment      This field indicates the number of
Lines                  comment lines for the allocation.

AOC-PT-COMPANY         Numeric 4                                 AC30.4
Element: Post-to CompanThis is the company to post the
                       allocation to.

AOC-PT-ACCT-UNIT       Alpha 15                                  AC30.4
Post-to Accounting     This is the accounting unit to post the
Unit                   allocation to.

AOC-PT-ACCOUNT         Numeric 6                                 AC30.4
Element: Post-to AccounThis is the account to post the
                       allocation to.

AOC-PT-SUB-ACCT        Numeric 4                                 AC30.4
Element: Post-to SubaccThis is the subaccount to post the
                       allocation to.

AOC-PT-LIST            Alpha 12                                  AC30.3
Element: Post-to List  This is the list to post the allocation
                       to.

AOC-PF-COMPANY         Numeric 4                                 AC30.4
Element: Post-from CompThis is the company for the post-from
                       activity, to which an offsetting
                       transaction is posted.

AOC-PF-ACCT-UNIT       Alpha 15                                  AC30.4
Post-from              This is the accounting unit of the
Accounting Unit        post-from activity, to which an
                       offsetting transaction is posted.

AOC-PF-ACCOUNT         Numeric 6                                 AC30.4
Element: Post-from AccoThis is the account for the post-from
                       activity, to which an offsetting
                       transaction is posted.

AOC-PF-SUB-ACCT        Numeric 4                                 AC30.4
Element: Post-from SubaThis is the subaccount for the
                       post-from
                       activity, to which an offsetting
                       transaction is posted.

AOC-POOL-LIST          Alpha 1                                   AC30.3
Element: Pool List     Valid values are Yes or No.
                       Y = Yes
                       N = No

AOC-OFFSET-TYPE        Alpha 1
Element: Offset Type   1 = AC Only
                       2 = GL Only
                       3 = AC and GL
                       4 = None

                         ACALLOC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AOCSET1   ALLOC-NAME                                             AC130   AC131
                                                                 AC230   AC30.1
                                                                 AC30.2  AC30.3
                                                                 AC30.4  AC32.1
                                                                 AC37.1  AC37.2

AOCSET2   CONTROL-GROUP*KeyChange                                AC131   AC30.4
          ALLOC-NAME

                         ACALLOC FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Not Required

                            AOC-PF-ACCT-CAT    -> AAX-ACCT-CATEGORY

Acactivity     ACACTIVITY   Not Required

                            AOC-PF-ACTIVITY    -> ACV-ACTIVITY

Acpoolhdr      ACPOOLHDR    Required

                            AOC-POOL-NAME      -> POL-POOL-NAME

                         ACALLOC FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acallocgp      ACALLOCX

                            AOC-ALLOC-NAME     -> AOX-ALLOC-NAME
                                                  AOX-LINE-NBR

Acallocx       ACALLOCX

                            AOC-ALLOC-NAME     -> AOX-ALLOC-NAME
                                                  AOX-LINE-NBR