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
AC115 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 OE113 OE14.4
OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7
OE230 OE272 OE282 OE510 OE810 OE85.1
OE920 SA100 WH20.2 WH20.7
UPDATED BY
BL00.1 BL01.1 BL07.1 BL120 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 BL940 OE114 OE129 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE830 OE950
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
OE230 OE272
OE282 OE30.3
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 BL120
Use = Yes), it cannot be deleted. BL130 BL20.1
N = No BL20.3 BL21.2
Y = Yes BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BL940 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
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 AC115 BL00.1
REASON-CODE BL01.1 BL07.1
BL120 BL130
BL20.1 BL20.3
BL201 BL207
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
...
OEREASON FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Oereason OECOMPANY Required
OER-COMPANY -> OEC-COMPANY
|