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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OER-COMPANY Numeric 4 BL00.1 BL01.1
Company The company number represents an BL07.1
established company and is entered on
all function codes.
OER-REASON-CODE Alpha 4 BL00.1 BL01.1
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
Description The description of the reason code. BL07.1 BL201
OER-CANCEL-FL Alpha 1 BL00.1 BL01.1
Cancel 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
Billing Fl 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
Update Bookings 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
Used Once a reason code has been used (In BL07.1
Use = Yes), it cannot be deleted.
N = No
Y = Yes
OER-ACTIVE-STATUS Alpha 1 BL00.1 BL01.1
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 BL201
BL207
OEREASON FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Oereason OECOMPANY Required
OER-COMPANY -> OEC-COMPANY
|
