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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
OERSET1
  1. COMPANY
  2. REASON-CODE
PrimaryWH20.2, WH20.7

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
OECOMPANYOEREASON

One to one (1) — lookups and parents

RelationTableRulesConditionField map
OereasonOECOMPANYRequired
OER-COMPANY→OEC-COMPANY

Programs

Updated by (1)