Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             SACOMPANY FILE

                         Sales Analysis Company

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

REFERENCED BY

BL320

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

SAC-NAME             Alpha 30  (Lower Case)
Name                 Displays the company description.

SAC-CURR-YEAR        Numeric 4
Current Year         Current Sales Analysis year.

SAC-NBR-PERIODS      Numeric 2
Number of Periods    Number of periods in the Sales Analysis
                     year.
                     12
                     13
                     52
                     53

SAC-CURR-PERIOD      Numeric 2
Current Period       Current period in Sales Analysis year.

SAC-DISC-INCLD-FL    Alpha 1
Disc Incld Fl        Discount include flag.  Setting this
                     flag to Yes instructs Sales Analysis
                     inquiries and reports to display and/or
                     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
Comp Fl              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
Performance Fl       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
Reason Code Fl       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
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
Last Year            Last year.  Derived field.

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

SAC-LAST-PERIOD      Derived
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

                         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