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
Company              The company number represents an
                     established company and is entered on
                     all function codes.

SAF-FORMAT-NAME      Alpha 10                                    SA01.1
Format 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
Format Description   Format description.

SAF-CURR-YR-DEV      Signed 1.0                                  SA01.1
Current Year         Current year deviation.  For example,
Deviation            to display last year's data, enter -1.

SAF-FIELD            Alpha 1 Occurs 4 Times                      SA01.1
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