Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

REASON


                              REASON FILE

                              Reason Code

The Reason Code file contains the approved reasons that explain why inventory
transactions were made. These reasons can also be used to explain physical
inventory count variances.

REFERENCED BY

AP125     AP126     AP131     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP21.1    AP23.1    AP25.1
AP25.2    AP26.1    AP27.1    AP30.4    API1.1    BL120
BL122     BL130     BL20.1    BL20.3    BL21.2    BL21.5
BL29.1    BL29.2    BL520     BL820     BL92.1    CXCP.1
IC01.1    MA180     MA41.1    MA41.2    MA41.4    MA41.7
MA43.1    MA43.2    MA43.3    MA43.7    MA530     MA531
MA60.2    MA60.3    MA60.5    MA61.1    MA66.2    MA66.3
MA67.2    MA67.3    MA68.2    MA68.3    MA68.5    MA70.1
MA75.1    MA80.1    MAI1.1    PD10.1    PD10.2    PD130
PD20.1    PD20.2    PD20.3    PO100     PO101     PO122
PO131     PO190     PO20.1    PO21.1    PO21.2    PO21.3
PO21.4    PO21.5    PO22.1    PO23.1    PO24.1    PO25.1
PO25.5    PO25.6    PO25.7    PO27.2    PO29.1    PO30.1
PO30.2    PO30.3    PO300     PO31.1    PO31.2    PO32.2
PO32.4    PO33.1    PO34.1    PO35.1    PO36.1    PO36.2
PO38.1    PO39.1    PO39.2    PO44.1    PO50.1    PO52.1
PO520     PO536     POI3.1    POID.1    POII.1    POIJ.1
RQ10.1    RQ10.2    RQ35.1    WH130     WH132     WH190
WH20.2    WH20.7    WH222     WH30.1    WH30.2    WH30.3
WH30.4    WH31.1    WH31.2    WH31.3    WH31.4    WH32.1
WH32.2    WH32.3    WH32.4    WH33.1    WH33.2    WH33.3
WH33.4    WH33.5    WH33.6    WH33.8    WH33.9    WH34.1
WH34.2    WH34.3    WH34.4    WH40.1    WH40.2    WH520
WH830

UPDATED BY

IC17.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

REA-COMPANY            Numeric 4                                 IC17.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.

REA-REASON-CODE        Alpha 4                                   IC17.1
Element: Reason Code   This field contains the reason code
                       that indicates the cause for credit
                       memos.  It is also allowed on debit
                       memos, and used to indicate the reason
                       for a return on a return to vendor.

REA-DESCRIPTION        Alpha 30  (Lower Case)                    IC17.1
Element: Description   This field contains the description of
                       the reason code.

REA-DESCRIPTION2       Alpha 30  (Lower Case)                    IC17.1
Element: Description   This field displays the description.

REA-ACCOUNT            Numeric 6                                 IC17.1
Element: Account       This field contains the general ledger
                       account that defaults as the offset
                       account number on inventory transactions
                       when the reason code is entered on a
                       transaction.

REA-SUB-ACCOUNT        Numeric 4                                 IC17.1
Element: Sub Acct      This field contains the general ledger
                       subaccount that defaults as the offset
                       subaccount number if the reason code is
                       entered on an inventory transaction.

REA-ACTIVE-STATUS      Alpha 1                                   IC17.1
Element: Active Status This field contains the status for the
                       reason code to control the use of the
                       code.
                       A = Active
                       I = Inactive

REA-REASON-TYPE        Alpha 2                                   IC17.1
Element: Reason Type   This field identifies the class of the
                       reason code. This classification is used
                       in the Case Carts system for reporting.
                       "  " = None
                       1 = Waste
                       2 = Returns

                         REASON FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

REASET1   COMPANY                                                AP125   AP126
          REASON-CODE                                            AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  CXCP.1
                                                                 ...

                         REASON FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        ICCOMPANY    Required

                            REA-COMPANY    -> ICC-COMPANY