|
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 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 OE111 OE113 OE116
OE13.2 OE13.3 OE13.5 OE14.4 OE230 OE272
OE282 OE510 OE810 OE85.1 OE86.1 OE86.4
SA100 WH20.2 WH20.7
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 OE114 OE129 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE530 OE830
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
OE230 OE272
OE282 OE30.3
OE86.4
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 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 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE530
OE830
OER-ACTIVE-STATUS Alpha 1 BL00.1 BL01.1
Element: 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 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
...
OEREASON FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Oereason OECOMPANY Required
OER-COMPANY -> OEC-COMPANY
|