SAYEAR FILE

                     SA Period Ending Dates By Year

The SA Period Ending Dates by Year file stores the Sales Analysis fiscal
calendar.

REFERENCED BY

SA02.1    SA03.1    SA04.1    SA100     SA110     SA202
SA203     SA204     SA260     SA261     SA262     SA270
SA271     SA272     SA280     SA281     SA282     SA290
SA291     SA292     SA300     SA80.1    SA80.2    SA80.3
SA90.1    SA90.2    SA90.3    SA990     SA991     SAA2.1

UPDATED BY

SA00.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

SAY-COMPANY          Numeric 4                                   SA00.2
Company              The company number represents an
                     established company and is entered on
                     all function codes.

SAY-YEAR             Numeric 4                                   SA00.2
Last Closed Year     Sales Analysis fiscal year.

SAY-PERIOD-END-DT    Numeric 8  (yyyymmdd) Occurs 53 Times       SA00.2
Period Ending Date   Contains the inclusive ending date for
                     a reporting period.

                         SAYEAR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SAYSET1   COMPANY                                                SA00.1  SA00.2
          YEAR                                                   SA02.1  SA03.1
                                                                 SA04.1  SA100
                                                                 SA110   SA202
                                                                 SA203   SA204
                                                                 SA260   SA261
                                                                 SA262   SA270
                                                                 SA271   SA272
                                                                 SA280   SA281
                                                                 SA282   SA290
                                                                 SA291   SA292
                                                                 SA300   SA80.1
                                                                 SA80.2  SA80.3
                                                                 SA90.1  SA90.2
                                                                 SA90.3  SA990
                                                                 ...

                         SAYEAR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Sacompany      SACOMPANY    Required

                            SAY-COMPANY    -> SAC-COMPANY