Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OESTDCOMM


                             OESTDCOMM FILE

                     Order Entry Standard Comments

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.

REFERENCED BY

BL122     BL130     BL203     BL21.6    BL520     BLI2.1
OE11.3    OE11.6    OE112     OE114     OE14.4    OE229
OE254     OE54.1

UPDATED BY

BL03.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OSC-COMPANY            Numeric 4                                 BL03.1
Element: Company       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.

OSC-STD-COMM           Alpha 4                                   BL03.1
Element: Standard CommeUser-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                Numeric 3                                 BL03.1
Element: Sequence NumbeThe record sequence number. Line or
                       sequence number of the line of comment
                       text this record represents.

OSC-PRINT-CODE         Alpha 1                                   BL03.1
Element: Print Code    The 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            Alpha 1                                   BL03.1
Element: Picking OptionDetermines whether to print the comment
                       on the pick list.
                       N = No
                       Y = Yes

OSC-INVC-FL            Alpha 1                                   BL03.1
Element: All Flag      This indicates if the comment prints on
                       the invoice.
                       N = No
                       Y = Yes

OSC-ACTIVE-STATUS      Alpha 1                                   BL03.1
Element: Status        Indicates whether the status of the
                       comment is active.
                       A = Active.
                       I = Inactive.

OSC-LANGUAGE-CODE      Alpha 10                                  BL03.1
Element: Language Code Language Code (LOCALE).

                         OESTDCOMM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OSCSET1   COMPANY                                                BL03.1  BL122
          STD-COMM                                               BL130   BL203
          LANGUAGE-CODE                                          BL21.6  BL520
          SEQ                                                    BLI2.1  OE11.3
                                                                 OE11.6  OE112
                                                                 OE114   OE14.4
                                                                 OE229   OE254
                                                                 OE54.1

                         OESTDCOMM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oecommhdr      OECOMMHDR    Required

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

Oecompany      OECOMPANY    Required

                            OSC-COMPANY     -> OEC-COMPANY