Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SAREASON


                             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
Element: Company       Identifies the AP company if the          SA300
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

SAR-YEAR               Numeric 4                                 SA100   SA110
Element: Last Closed YeSales Analysis fiscal year.               SA300

SAR-PERIOD             Numeric 2                                 SA100   SA110
Element: Last Closed PeContains period when booked or actual     SA300
                       sales occurred.

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

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

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

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

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

SAR-AMOUNT             Signed 18.2                               SA100   SA110
Element: Intl Amt      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