CACOMMENT FILE

                          Allocation Comments

The Allocations Comment file contains the comments for allocation
transactions.


REFERENCED BY

CA190     IFGT.1

UPDATED BY

CA10.2    CA10.6    CA10.7    GL110

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CAC-COMPANY          Numeric 4                                   CA10.6
Company              The company number that contains the
                     allocation you are defining comments
                     for.


CAC-ALLOC-NAME       Alpha 12                                    CA10.6  CA10.7
Allocation           The allocation you are defining
                     comments for.


CAC-ALLOC-TYPE       Alpha 1                                     CA10.6  CA10.7
Allocation Type      The type of allocations you are
                     defining comments for.

                     A = Actual
                     C = Current Year Budget
                     N = Next Year Budget

CAC-SEQ-NBR          Numeric 4                                   CA10.6  CA10.7
Sequence Number      This field contains the automatically
                     assigned sequence number.


CAC-CMT-TEXT         Alpha 60  (Lower Case)                      CA10.6
Comment Text         The text you want to associate with the
                     allocation.


                         CACOMMENT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CACSET1   COMPANY                                                CA10.1  CA10.2
          ALLOC-NAME                                             CA10.6  CA10.7
          ALLOC-TYPE                                             CA10.8  CA190
          SEQ-NBR                                                GL110   IFGT.1

                         CACOMMENT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Caheader       CAHEADER     Required

                            CAC-COMPANY       -> CAH-COMPANY
                            CAC-ALLOC-NAME    -> CAH-ALLOC-NAME
                            CAC-ALLOC-TYPE    -> CAH-ALLOC-TYPE

Company        GLSYSTEM     Required

                            CAC-COMPANY       -> GLS-COMPANY

Glsystem       GLSYSTEM     Required

                            CAC-COMPANY       -> GLS-COMPANY