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

WH20.2    WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OER-COMPANY            Numeric 4
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

OER-REASON-CODE        Alpha 4
Accounts Receivable    User-defined reason codes to be used
Code                   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)
Element: Description   The description of the reason code.

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

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

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

OER-USED-FL            Alpha 1
Element: Used          Once a reason code has been used (In
                       Use = Yes), it cannot be deleted.
                       N = No
                       Y = Yes

OER-ACTIVE-STATUS      Alpha 1
Element: Status        Indicates whether the reason code is
                       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                                                WH20.2  WH20.7
          REASON-CODE

                         OEREASON FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oereason       OECOMPANY    Required

                            OER-COMPANY    -> OEC-COMPANY