OEREASON

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.
UPDATED BY
WH20.7

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OER-COMPANY
Element: Company
Numeric 4
Identifies the AP company if the 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
Element: Reason Code
Alpha 4
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
Element: Description
Alpha 30 (Lower Case)
The description of the reason code.
OER-CANCEL-FL
Element: All Flag
Alpha 1
Indicates whether this reason code is to be used as an order cancellation reason code.
Y = Yes
N = No
OER-BILLING-FL
Element: All Flag
Alpha 1
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
Element: All Flag
Alpha 1
Determines whether to remove the sale from bookings for the canceled order.
N = No
Y = Yes
OER-USED-FL
Element: Used Fl
Alpha 1
Once a reason code has been used (In Use = Yes), it cannot be deleted.
N = No
Y = Yes
WH20.7
OER-ACTIVE-STATUS
Element: Active Status
Alpha 1
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
REASON-CODE
WH20.2 WH20.7


OEREASON FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Oereason OECOMPANY Required
OER-COMPANY->OEC-COMPANY


File created: Thu Jun 09 02:09:43 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.