Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              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
Allocation Name      This 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
Allocation Pool      This 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
Allocation Type      This field defines where the allocation
                     will take place.

                     A = AC Only
                     B = Both AC and GL

AOC-OPERATOR         Alpha 10                                    AC30.1  AC30.2
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
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
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
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
Default Description  This 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
Post-From Activity   Optional. 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
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
Maintenance Date     This is the date the allocation was         AC30.3  AC30.4
                     last changed.

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

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

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

AOC-ALLOCATED-DATE   Numeric 8  (yyyymmdd)                       AC131
Allocated Date       This is the date the allocation amount
                     was allocated.

AOC-ALLOCATED-TIME   Numeric 6  (hhmmss)                         AC131
Allocated Time       This is the time the allocation amount
                     was allocated.

AOC-TOTAL-PCT        Signed 7.4                                  AC131   AC30.1
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
Last Line Number     This 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
Post-to Company      This 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
Post-to Account      This is the account to post the
                     allocation to.

AOC-PT-SUB-ACCT      Numeric 4                                   AC30.4
Post-to Subaccount   This is the subaccount to post the
                     allocation to.

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

AOC-PF-COMPANY       Numeric 4                                   AC30.4
Post-from Company    This 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
Post-from Account    This is the account for the post-from
                     activity, to which an offsetting
                     transaction is posted.

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

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

                         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