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