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
Company The company number represents an
established company and is entered on
all function codes.
OER-REASON-CODE Alpha 4
Reason Code User-defined reason codes to be used
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)
Description The description of the reason code.
OER-CANCEL-FL Alpha 1
Cancel 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
Billing Fl 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
Update Bookings Flag Determines whether to remove the sale
from bookings for the canceled order.
N = No
Y = Yes
OER-USED-FL Alpha 1
Used Once a reason code has been used (In
Use = Yes), it cannot be deleted.
N = No
Y = Yes
OER-ACTIVE-STATUS Alpha 1
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
|
