Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SACOMPANY


                             SACOMPANY FILE

                         Sales Analysis Company

The Sales Analysis Company file includes parameters for sales analysis at the
company level.

REFERENCED BY

BL320     OE310     OE330     SA01.1    SA02.1    SA02.2
SA03.1    SA03.2    SA04.1    SA04.2    SA101     SA200
SA201     SA202     SA203     SA204     SA250     SA251
SA252     SA253     SA254     SA255     SA256     SA257
SA258     SA260     SA261     SA262     SA270     SA271
SA272     SA280     SA281     SA282     SA290     SA291
SA292     SA300     SA310     SA80.1    SA80.2    SA80.3
SA90.1    SA90.2    SA90.3    SADM.2    SADM.5    SADM.6
SADM.7    SALD.1    SALO.1    SAOR.1

UPDATED BY

SA00.1    SA100     SA110

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

SAC-COMPANY            Numeric 4                                 SA00.1
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.

SAC-NAME               Alpha 30  (Lower Case)                    SA00.1
Element: Name          Displays the company description.

SAC-CURR-YEAR          Numeric 4                                 SA00.1  SA100
Element: Last Closed YeCurrent Sales Analysis year.

SAC-NBR-PERIODS        Numeric 2                                 SA00.1
Element: Number of PeriNumber of periods in the Sales Analysis
                       year.
                       12
                       13
                       52
                       53

SAC-CURR-PERIOD        Numeric 2                                 SA00.1  SA100
Element: Current PeriodCurrent period in Sales Analysis year.

SAC-DISC-INCLD-FL      Alpha 1                                   SA00.1  SA260
Element: All Flag      Discount include flag.  Setting this      SA270   SA280
                       flag to Yes instructs Sales Analysis      SA290   SA80.1
                       inquiries and reports to display and/or   SA90.1  SALD.1
                       print gross sales amounts. Setting it to
                       No instructs Sales Analysis inquiries
                       and reports to display and/or print net
                       sales amounts.
                       N = No
                       Y = Yes

SAC-COMP-FL            Alpha 1                                   SA00.1  SA110
Element: All Flag      Company factor summarization option.
                       Setting this to Yes will cause creation
                       of the company factor summary file.
                       Y = Yes
                       N = No

SAC-PERFORMANCE-FL     Alpha 1                                   SA00.1  SA110
Element: All Flag      Performance file creation option.
                       Setting this to Yes will cause creation
                       of the performance file used for
                       performance trend reporting.
                       Y = Yes
                       N = NO

SAC-REASON-CODE-FL     Alpha 1                                   SA00.1  SA110
Element: All Flag      Reason code option.  Setting this flag
                       to Yes causes creation of the reason
                       code trend file used for reason code
                       trend reporting.
                       Y = Yes
                       N = No

SAC-OVR-ADDR-FL        Alpha 1                                   SA00.1
Element: Ovr Addr Fl   Override address option.  Setting this
                       flag to Yes will cause storing an
                       override address for orders in the Sales
                       Analysis system.
                       Y = Yes
                       N = No

SAC-LAST-YEAR          Derived
Element: Last Year     Last year.  Derived field.

SAC-LAST-PER           Derived
Element: Last Per      Last period, if period is not the first
                       in the year.  Derived field.

SAC-LAST-PERIOD        Derived
Element: Last Period   Last period.  Derived field.  Either
                       one less than current period or last
                       period of last year.

                         SACOMPANY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SACSET1   COMPANY                                                BL320   OE310
                                                                 OE330   SA00.1
                                                                 SA00.2  SA01.1
                                                                 SA02.1  SA02.2
                                                                 SA03.1  SA03.2
                                                                 SA04.1  SA04.2
                                                                 SA100   SA101
                                                                 SA110   SA200
                                                                 SA201   SA202
                                                                 SA203   SA204
                                                                 SA250   SA251
                                                                 SA252   SA253
                                                                 SA254   SA255
                                                                 SA256   SA257
                                                                 SA258   SA260
                                                                 ...

                         SACOMPANY FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iccompany      ICCOMPANY    Required

                            SAC-COMPANY    -> ICC-COMPANY

Oecompany      OECOMPANY    Required

                            SAC-COMPANY    -> OEC-COMPANY

                         SACOMPANY FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Saformat       SAFORMAT     Delete Restricted

                            SAC-COMPANY    -> SAF-COMPANY
                                              SAF-FORMAT-NAME

Sayear         SAYEAR       Delete Restricted

                            SAC-COMPANY    -> SAY-COMPANY
                                              SAY-YEAR