CAALLOCGRP FILE

                            Allocation Group

The Allocation Group file stores allocation group information.

REFERENCED BY

CA10.1    CA10.2    CA10.7    CA10.8    CA110     CA15.2
CA200

UPDATED BY

CA00.1    CA00.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CAG-ALLOCATION-GRP   Alpha 12                                    CA00.1  CA00.2
Allocation Group     The allocation group name. An
                     allocation group is used to store
                     allocations in a specific company or
                     company group.


CAG-DESCRIPTION      Alpha 30  (Lower Case)                      CA00.1  CA00.2
Allocation Group     The allocation group description.
Description

CAG-COMPANY-GROUP    Alpha 12                                    CA00.1  CA00.2
Company Group        The company group where allocations are
                     stored.


CAG-COMPANY          Numeric 4                                   CA00.1  CA00.2
Company              The company number where allocations
                     are stored.


CAG-ALLOC-TYPE       Alpha 1                                     CA00.1  CA00.2
Allocation Type      This field defines where the allocation
                     will take place.


                         CAALLOCGRP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CAGSET1   ALLOCATION-GRP                                         CA00.1  CA00.2
                                                                 CA10.1  CA10.2
                                                                 CA10.7  CA10.8
                                                                 CA110   CA15.2
                                                                 CA200

                         CAALLOCGRP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        GLSYSTEM     Required

                            CAG-COMPANY           -> GLS-COMPANY

Glcpygrp       GLCPYGRP     Required

                            CAG-COMPANY-GROUP     -> GCG-COMPANY-GROUP

                         CAALLOCGRP FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Caheader       CAHEADER

                            CAG-ALLOCATION-GRP    -> CAH-ALLOCATION-GRP
                                                     CAH-ALLOC-TYPE
                                                     CAH-COMPANY
                                                     CAH-ALLOC-NAME