OEREASON – Cancellation Reason Code

System
Billing (BL)
Prefix
OER
Primary key
COMPANY, REASON-CODE
Fields
8
Updated by
1 program
Referenced by
0 programs

OEREASON is the Cancellation Reason Code table in Lawson Billing (prefix OER). It is indexed by COMPANY, REASON-CODE (OERSET1). It is related 1:1 to OECOMPANY. It is updated by WH20.7. The table has 8 fields, 1 index and 1 documented relation.

About OEREASON

No description in the Lawson data dictionary.

Fields (8)

Column = COBOL field name without the OER- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
OER-COMPANY PK
COMPANY		Numeric 4Identifies 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 PK
REASON_CODE		Alpha 4User-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
DESCRIPTION		Alpha 30 (Lower Case)The description of the reason code.—
OER-CANCEL-FL
CANCEL_FL		Alpha 1Indicates whether this reason code is to be used as an order cancellation reason code.
  • Y Yes
  • N No
—
OER-BILLING-FL
BILLING_FL		Alpha 1Indicates 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
BOOKINGS_FL		Alpha 1Determines whether to remove the sale from bookings for the canceled order.
  • N No
  • Y Yes
—
OER-USED-FL
USED_FL		Alpha 1Once a reason code has been used (In
  • Use Yes), it cannot be deleted.
  • N No
  • Y Yes
WH20.7
OER-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1Indicates whether the reason code is active or not. Selecting Inactive in this field will make it inactive, preventing future use.
  • A Active.
  • I Inactive.
—

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
OERSET1COMPANY, REASON-CODEPrimaryWH20.2, WH20.7

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
OereasonOECOMPANYRequiredOER-COMPANY → OEC-COMPANY

Programs

Updated by (1)