OECOMMHDR – Order Entry Comment Header
- System
- Billing (BL)
- Prefix
OCH- Primary key
COMPANY,STD-COMM- Fields
- 4
- Updated by
- 0 programs
- Referenced by
- 0 programs
OECOMMHDR is the Order Entry Comment Header table in Lawson Billing (prefix OCH). It is indexed by COMPANY, STD-COMM (OCHSET1). It is related 1:1 to OECOMPANY and 1:M to OESTDCOMM. The table has 4 fields, 1 index and 2 documented relations.
About OECOMMHDR
This file stores the header for standard comments. Standard comments are used to save keystrokes during order entry for frequently used comments. This code is all that needs to be entered to copy the associated comments onto the order, standard order, or invoice.
Fields (4)
Column = COBOL field name without the OCH- 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 / column | Type | Description & values | Updated by |
|---|---|---|---|
#OCH-COMPANY PKCOMPANY | 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. | — |
#OCH-STD-COMM PKSTD_COMM | Alpha 4 | User-defined code tied to comment text. The standard comment code can be simply added to an order or a line and the text tied to the code will default onto the order. There are options users can choose when setting up the codes indicating where the text should print. User-defined value identifying a standard comment. Standard comments are established on BL03.1 (Standard Comments). | — |
#OCH-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | The description of the standard comment. | — |
#OCH-LAST-SEQLAST_SEQ | Numeric 3 | Last sequence number indicating the last line of text tied to this standard comment code. | — |
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
OCHSET1 |
| Primary | BLI2.1 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||
|---|---|---|---|---|---|---|---|
| Oecompany | OECOMPANY | Required |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Oestdcomm | OESTDCOMM | Delete Cascades |
|
Programs
No Lawson programs are documented as updating or referencing this table.