Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SAYEAR


                              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    SALD.1

UPDATED BY

SA00.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

SAY-COMPANY            Numeric 4                                 SA00.2
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

SAY-YEAR               Numeric 4                                 SA00.2
Element: Last Closed YeSales Analysis fiscal year.

SAY-PERIOD-END-DT      Numeric 8  (yyyymmdd) Occurs 53 Times     SA00.2
Element: 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  SALD.1

                         SAYEAR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Sacompany      SACOMPANY    Required

                            SAY-COMPANY    -> SAC-COMPANY