Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SAFORMAT


                             SAFORMAT FILE

                        SA Inquiry Format Names

The Sales Analysis Inquiry Format Names file stores user-defined inquiry
formats.

REFERENCED BY

SA00.1    SA201     SA90.1    SA90.2    SA90.3

UPDATED BY

SA01.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

SAF-COMPANY            Numeric 4                                 SA01.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.

SAF-FORMAT-NAME        Alpha 10                                  SA01.1
Element: Base Name     This field contains the identifier for
                       a user-defined setup file indicating
                       which data fields appear on the form
                       when  maintaining items.

SAF-FORMAT-DESC        Alpha 30                                  SA01.1
Element: Item DescriptiFormat description.

SAF-CURR-YR-DEV        Signed 1.0                                SA01.1
Element: Curr Yr Dev   Current year deviation.  For example,
                       to display last year's data, enter -1.

SAF-FIELD              Alpha 1 Occurs 4 Times                    SA01.1
Element: Field         Code to indicate what is to be
                       displayed in each of four columns.
                       A = PTD Budget
                       B = PTD Booked
                       C = PTD Actual
                       D = YTD Budget
                       E = YTD Booked
                       F = YTD Actual
                       G = Comparison Year PTD Budget
                       H = Comparison Year PTD Booked
                       I = Comparison Year PTD Actual
                       J = Comparison Year YTD Budget
                       K = Comparison Year YTD Booked
                       L = Comparison Year YTD Actual
                       M = Compute

                         SAFORMAT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SAFSET1   COMPANY                                                SA00.1  SA01.1
          FORMAT-NAME                                            SA01.2  SA201
                                                                 SA90.1  SA90.2
                                                                 SA90.3

                         SAFORMAT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Sacompany      SACOMPANY    Required

                            SAF-COMPANY        -> SAC-COMPANY

                         SAFORMAT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Sacompute      SACOMPUTE

                            SAF-COMPANY        -> SAP-COMPANY
                            SAF-FORMAT-NAME    -> SAP-FORMAT-NAME
                                                  SAP-COLUMN