Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACALLOCGPX


                            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
Element: Allocation GroThis is the allocation group defined in
                       AC37.1 (Allocation Group).

AGX-ALLOC-NAME         Alpha 12                                  AC37.1  AC37.2
Element: Alloc 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
Element: 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)
Element: 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)
Element: Sys 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
Element: Allocated DateThis is the date this allocation was
                       last processed by AC131 (Allocation
                       Update).

AGX-ALLOCATED-TIME     Numeric 6  (hhmmss)                       AC131
Element: Allocated TimeThis 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   AC37.1

AGXSET2   ALLOC-GROUP   KeyChange                                AC130   AC131
          STEP                                                   AC230   AC30.1
          ALLOC-NAME                                             AC30.2  AC30.3
                                                                 AC30.4  AC37.2

                         ACALLOCGPX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acalloc        ACALLOC      Required

                            AGX-ALLOC-NAME     -> AOC-ALLOC-NAME

Acallocgp      ACALLOCGP    Required

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