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

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    WH20.7

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

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 Fl       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  WH20.7

OER-ACTIVE-STATUS      Alpha 1                                   BL00.1  BL01.1
Element: Active 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  WH20.2
                                                                 WH20.7

                         OEREASON FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oereason       OECOMPANY    Required

                            OER-COMPANY    -> OEC-COMPANY