SAREASON FILE

                       Reason Code Trend Summary

The Reason Code Trend Summary file stores statistics by reason codes.  Reason
codes are required for all credit memos and allowed for all debit memos.

REFERENCED BY

SA00.2

UPDATED BY

SA100     SA101     SA110     SA300

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

SAR-COMPANY          Numeric 4                                   SA100   SA110
Company              The company number represents an            SA300
                     established company and is entered on
                     all function codes.

SAR-YEAR             Numeric 4                                   SA100   SA110
Year                 Sales Analysis fiscal year.                 SA300

SAR-PERIOD           Numeric 2                                   SA100   SA110
Period               Contains period when booked or actual       SA300
                     sales occurred.

SAR-REASON-CODE      Alpha 4                                     SA100   SA110
Reason Code          Contains the reason code, which             SA300
                     indicates the cause for credit memos.

SAR-CUSTOMER         Alpha 9  (Right Justified)                  SA100   SA110
Customer             Contains the number that represents a       SA300
                     customer.

SAR-ITEM             Alpha 32                                    SA100   SA110
Item                 Contains the item identifier.               SA300

SAR-NBR-RETURNS      Numeric 6                                   SA100   SA110
Number of Returns    Total number of credit or debit memos       SA300
                     with this reason code on them.

SAR-QUANTITY         Signed 13.4                                 SA100   SA110
Quantity             Contains the requested quantity.            SA300

SAR-AMOUNT           Currency 15.2                               SA100   SA110
Amount               Contains the amounts by period for the      SA300
                     specified record.

                         SAREASON FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SARSET1   COMPANY                                                SA00.2  SA100
          YEAR                                                   SA101   SA110
          PERIOD                                                 SA300
          REASON-CODE
          CUSTOMER
          ITEM

SARSET2   COMPANY
          YEAR
          REASON-CODE
          CUSTOMER
          ITEM
          PERIOD