Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             OECOMMHDR FILE

                       Order Entry Comment Header

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.

REFERENCED BY

BL203     BL22.1    BL230     BL231     BL30.1    BL30.2
BL30.3    BL30.5    BL31.1    BL31.2    BL31.3    BL31.5
BL31.7    BL32.1    BL32.2    BL32.3    BL32.4    BLI2.1

UPDATED BY

BL03.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

OCH-COMPANY          Numeric 4                                   BL03.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.

OCH-STD-COMM         Alpha 4                                     BL03.1
Standard Comment     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-DESCRIPTION      Alpha 30  (Lower Case)                      BL03.1
Description          The description of the standard
                     comment.

OCH-LAST-SEQ         Numeric 3                                   BL03.1
Last Sequence        Last sequence number indicating the
                     last line of text tied to this standard
                     comment code.

                         OECOMMHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OCHSET1   COMPANY                                                BL03.1  BL203
          STD-COMM                                               BL22.1  BL230
                                                                 BL231   BL30.1
                                                                 BL30.2  BL30.3
                                                                 BL30.5  BL31.1
                                                                 BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.1  BL32.2
                                                                 BL32.3  BL32.4
                                                                 BLI2.1

                         OECOMMHDR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oecompany      OECOMPANY    Required

                            OCH-COMPANY     -> OEC-COMPANY

                         OECOMMHDR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oestdcomm      OESTDCOMM    Delete Cascades

                            OCH-COMPANY     -> OSC-COMPANY
                            OCH-STD-COMM    -> OSC-STD-COMM
                                               OSC-SEQ