OEORDCMNT – Customer Order Comments

System
OE (OE)
Prefix
OOC
Primary key
COMPANY, CUSTOMER, STD-ORDER-NBR, ORDER-NBR, LINE-NBR, SEQ
Fields
10
Updated by
2 programs
Referenced by
5 programs

OEORDCMNT is the Customer Order Comments table in Lawson OE (prefix OOC). It is indexed by COMPANY, CUSTOMER, STD-ORDER-NBR, ORDER-NBR, LINE-NBR, SEQ (OOCSET1). It is related 1:1 to COLINE and CUSTORDER. It is updated by BLI2.1 and WH20.7 and referenced by PO23.1, POCP.1, WH126, WH130 and WH224. The table has 10 fields, 1 index and 2 documented relations.

About OEORDCMNT

The Customer Order Comments file contains comments that have been placed on an order that was created from a standard order template. This file contains both standard comments that are assigned to the order header or order line. Each line of comments creates a separate record in this file.

Fields (10)

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

Field / columnTypeDescription & valuesUpdated by
OOC-COMPANY PK
COMPANY		Numeric 4This field contains the company number.BLI2.1
OOC-CUSTOMER PK
CUSTOMER		Alpha 9 (Right Justified)This field contains the number that represents the customer who placed the order.BLI2.1
OOC-STD-ORDER-NBR PK
STD_ORDER_NBR		Alpha 22This field contains the number of the standard order used to create the order to which this comment line is attached. Standard Orders are setup on OE54.1 (Standard Order).BLI2.1
OOC-ORDER-NBR PK
ORDER_NBR		Numeric 8This field contains the order number to which the comment line is attached.BLI2.1
OOC-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the number of the line on the order to which the comment can be attached. If this field is blank, the comment is attached at the order level.BLI2.1
OOC-SEQ PK
SEQ		Numeric 3This field contains the comment sequence number.BLI2.1
OOC-PRINT-CODE
PRINT_CODE		Alpha 1This field contains the print code, which defines where comments are displayed or printed.
  • B Both display and print
  • D Display only
  • P Print on all reports/forms
  • R Print on reports, not forms
BLI2.1
OOC-PICK-FL
PICK_FL		Alpha 1This field determines whether to print the comment on the pick list.
  • N No
  • Y Yes
BLI2.1
OOC-INVC-FL
INVC_FL		Alpha 1This field indicates if the comment prints on the invoice.
  • N No
  • Y Yes
BLI2.1
OOC-COMM-TYPE
COMM_TYPE		DerivedThis field defines the type of comment added to the file.—

Indexes (1)

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

IndexKeysFlagsConditionUsed in
OOCSET1COMPANY, CUSTOMER, STD-ORDER-NBR, ORDER-NBR, LINE-NBR, SEQPrimaryBLI2.1, PO23.1, POCP.1, WH126, WH130, WH20.7, WH224

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
ColineCOLINERequiredWhen OOC-LINE-NBR != Zeroes And OOC-LINE-NBR != 999999OOC-COMPANY → COL-COMPANY, OOC-ORDER-NBR → COL-ORDER-NBR, OOC-LINE-NBR → COL-LINE-NBR
CustorderCUSTORDERRequiredOOC-COMPANY → COR-COMPANY, OOC-ORDER-NBR → COR-ORDER-NBR

Programs

Updated by (2)

Referenced by (5)