OESTDCOMM – Order Entry Standard Comments

System
Billing (BL)
Prefix
OSC
Primary key
COMPANY, STD-COMM, LANGUAGE-CODE, SEQ
Fields
8
Updated by
0 programs
Referenced by
0 programs

OESTDCOMM is the Order Entry Standard Comments table in Lawson Billing (prefix OSC). It is indexed by COMPANY, STD-COMM, LANGUAGE-CODE, SEQ (OSCSET1). It is related 1:1 to OECOMMHDR and OECOMPANY. The table has 8 fields, 1 index and 2 documented relations.

About OESTDCOMM

This file stores standard comments for existing standard comment codes. These comments can be copied and attached to orders, order lines, invoices, and invoice lines.

Fields (8)

Column = COBOL field name without the OSC- 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
#OSC-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.—
#OSC-STD-COMM PK
STD_COMM		Alpha 4User-defined code tied to comment text. The standard comment code can be added to an order or an order line and the text tied to the code will default onto the order. There are options users can select when setting up the codes indicating where the text should print.—
#OSC-SEQ PK
SEQ		Numeric 3The record sequence number. Line or sequence number of the line of comment text this record represents.—
#OSC-PRINT-CODE
PRINT_CODE		Alpha 1The print code defines if the comment should display and/or print on reports.
  • B Both print and display.
  • D Display only.
  • P Print on forms and reports.
  • R Print on reports only.
—
#OSC-PICK-FL
PICK_FL		Alpha 1Determines whether to print the comment on the pick list.
  • N No
  • Y Yes
—
#OSC-INVC-FL
INVC_FL		Alpha 1—
  • N No
  • Y Yes
—
#OSC-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1Indicates whether the status of the comment is active.
  • A Active.
  • I Inactive.
—
#OSC-LANGUAGE-CODE PK
LANGUAGE_CODE		Alpha 10Language Code (LOCALE).—

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
OSCSET1
  1. COMPANY
  2. STD-COMM
  3. LANGUAGE-CODE
  4. SEQ
PrimaryBLI2.1

Relations

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

One to one (2) — lookups and parents

RelationTableRulesConditionField map
OecommhdrOECOMMHDRRequired
OSC-COMPANY→OCH-COMPANY
OSC-STD-COMM→OCH-STD-COMM
OecompanyOECOMPANYRequired
OSC-COMPANY→OEC-COMPANY

Programs

No Lawson programs are documented as updating or referencing this table.