Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            ACALLOCGPX FILE

                     Activity Allocation Grp Detail

This file contains detailed information about allocation groups, as defined
in AC37.1 (Allocation Group).

REFERENCED BY

AC130     AC230     AC30.1    AC30.2    AC30.3    AC30.4

UPDATED BY

AC131     AC37.1    AC37.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

AGX-ALLOC-GROUP      Alpha 12                                    AC37.1  AC37.2
Allocation Group     This is the allocation group defined in
                     AC37.1 (Allocation Group).

AGX-ALLOC-NAME       Alpha 12                                    AC37.1  AC37.2
Allocation Name      The allocation name represents an
                     allocation as defined in AC30.1
                     (Allocation) or AC30.2 (Multiple Pool
                     Allocation).

AGX-STEP             Numeric 3                                   AC37.1  AC37.2
Step                 This field determines when an
                     allocation detail line gets processed.
                     All lower steps are processed before
                     processing higher steps.

AGX-RUN-DATE         Numeric 8  (yyyymmdd)
Program Run Date     This is the date component of the AC131
                     (Allocation Update) timestamp on
                     transactions produced for this
                     allocation by the most recent run of
                     AC131.

AGX-RUN-TIME         Numeric 6  (hhmmss)
Program Run Time     This is the time component of the AC131
                     (Allocation Update) timestamp on
                     transactions produced for this
                     allocation by the most recent run of
                     AC131.

AGX-ALLOCATED-DATE   Numeric 8  (yyyymmdd)                       AC131
Allocated Date       This is the date this allocation was
                     last processed by AC131 (Allocation
                     Update).

AGX-ALLOCATED-TIME   Numeric 6  (hhmmss)                         AC131
Allocated Time       This is the time this allocation was
                     last processed by AC131 (Allocation
                     Update).

                         ACALLOCGPX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AGXSET1   ALLOC-GROUP                                            AC130   AC131
          ALLOC-NAME                                             AC230   AC30.1
                                                                 AC30.2  AC30.3
                                                                 AC30.4  AC37.1

AGXSET2   ALLOC-GROUP                                            AC130   AC131
          STEP                                                   AC230   AC37.2
          ALLOC-NAME

AGXSET3   ALLOC-NAME
          ALLOC-GROUP

                         ACALLOCGPX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acalloc        ACALLOC      Required

                            AGX-ALLOC-NAME     -> AOC-ALLOC-NAME  (AOCSET1)

Acallocgp      ACALLOCGP    Required

                            AGX-ALLOC-GROUP    -> ALG-ALLOC-GROUP