Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OEREASON


                             OEREASON FILE

                        Cancellation Reason Code

This file stores reason codes representing reasons for cancelling orders
during processing as well as reason codes used when adding credit memos to the
system.  These reason codes will print, along with orders cancelled, on OE282
(Cancellation Report).  When setting up reason codes, users can specify
whether or not order amounts are subtracted from bookings at cancellation
time.  When adding your company, a default reason code is required and once
added to the company cannot be removed.  The default reason code is used when
an order is cancelled or deleted during processing.

REFERENCED BY

BL201     BL207     OE10.1    OE10.2    OE10.3    OE10.4
OE10.5    OE10.6    OE10.7    OE10.8    OE11.1    OE11.4
OE11.8    OE11.9    OE110     OE111     OE113     OE116
OE13.2    OE13.3    OE13.5    OE14.4    OE230     OE272
OE282     OE510     OE810     OE85.1    OE86.1    OE86.4
SA100     WH20.2    WH20.7

UPDATED BY

BL00.1    BL01.1    BL07.1    BL120     BL122     BL130
BL20.1    BL20.3    BL21.2    BL21.5    BL29.1    BL29.2
BL520     BL820     BL92.1    OE114     OE129     OE30.1
OE30.2    OE30.3    OE30.4    OE30.5    OE30.6    OE30.7
OE30.9    OE530     OE830

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OER-COMPANY            Numeric 4                                 BL00.1  BL01.1
Element: Company       Identifies the AP company if the          BL07.1
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

OER-REASON-CODE        Alpha 4                                   BL00.1  BL01.1
Element: Reason Code   User-defined reason codes to be used      BL07.1
                       when canceling orders or entering credit
                       memos into the system. Users can print
                       out a report listing all the canceled
                       orders by reason code.


OER-DESCRIPTION        Alpha 30  (Lower Case)                    BL00.1  BL01.1
Element: Description   The description of the reason code.       BL07.1  BL201
                                                                 OE230   OE272
                                                                 OE282   OE30.3
                                                                 OE86.4

OER-CANCEL-FL          Alpha 1                                   BL00.1  BL01.1
Element: All Flag      Indicates whether this reason code is     BL07.1
                       to be used as an order cancellation
                       reason code.
                       Y = Yes
                       N = No

OER-BILLING-FL         Alpha 1                                   BL00.1  BL01.1
Element: All Flag      Indicates whether this reason code is     BL07.1
                       valid in the Billing system when adding
                       a credit memo to the system.
                       Y = Yes
                       N = No

OER-BOOKINGS-FL        Alpha 1                                   BL00.1  BL01.1
Element: All Flag      Determines whether to remove the sale     BL07.1
                       from bookings for the canceled order.
                       N = No
                       Y = Yes

OER-USED-FL            Alpha 1                                   BL00.1  BL01.1
Element: Used          Once a reason code has been used (In      BL07.1  BL120
                       Use = Yes), it cannot be deleted.         BL122   BL130
                       N = No                                    BL20.1  BL20.3
                       Y = Yes                                   BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  OE114
                                                                 OE129   OE30.1
                                                                 OE30.2  OE30.3
                                                                 OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE530
                                                                 OE830

OER-ACTIVE-STATUS      Alpha 1                                   BL00.1  BL01.1
Element: Status        Indicates whether the reason code is      BL07.1
                       active or not. Selecting Inactive in
                       this field will make it inactive,
                       preventing future use.
                       A = Active.
                       I = Inactive.

                         OEREASON FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OERSET1   COMPANY                                                BL00.1  BL01.1
          REASON-CODE                                            BL07.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL201   BL207
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  OE10.1
                                                                 OE10.2  OE10.3
                                                                 OE10.4  OE10.5
                                                                 OE10.6  OE10.7
                                                                 OE10.8  OE11.1
                                                                 OE11.4  OE11.8
                                                                 OE11.9  OE110
                                                                 ...

                         OEREASON FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oereason       OECOMPANY    Required

                            OER-COMPANY    -> OEC-COMPANY