Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OEORDCMNT


                             OEORDCMNT FILE

                        Customer Order Comments

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.

REFERENCED BY

PO23.1    POCP.1    WH126     WH130     WH224

UPDATED BY

BLI2.1    WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OOC-COMPANY            Numeric 4                                 BLI2.1
Element: Company       This field contains the company number.

OOC-CUSTOMER           Alpha 9  (Right Justified)                BLI2.1
Element: Customer NumbeThis field contains the number that
                       represents the customer who placed the
                       order.

OOC-STD-ORDER-NBR      Alpha 22                                  BLI2.1
Standard Order         This field contains the number of the
Number                 standard order used to create the order
                       to which this comment line is attached.
                       Standard Orders are setup on OE54.1
                       (Standard Order).

OOC-ORDER-NBR          Numeric 8                                 BLI2.1
Element: Order Number  This field contains the order number to
                       which the comment line is attached.

OOC-LINE-NBR           Numeric 6                                 BLI2.1
Element: Line Number   This 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.

OOC-SEQ                Numeric 3                                 BLI2.1
Element: Sequence NumbeThis field contains the comment
                       sequence number.

OOC-PRINT-CODE         Alpha 1                                   BLI2.1
Element: Print Code    This 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

OOC-PICK-FL            Alpha 1                                   BLI2.1
Element: Picking OptionThis field determines whether to print
                       the comment on the pick list.
                       N = No
                       Y = Yes

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

OOC-COMM-TYPE          Derived
Element: Comment Type  This field defines the type of comment
                       added to the file.

                         OEORDCMNT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OOCSET1   COMPANY                                                BLI2.1  PO23.1
          CUSTOMER                                               POCP.1  WH126
          STD-ORDER-NBR                                          WH130   WH20.7
          ORDER-NBR                                              WH224
          LINE-NBR
          SEQ

                         OEORDCMNT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Coline         COLINE       Required
                            When OOC-LINE-NBR != Zeroes
                            And  OOC-LINE-NBR != 999999

                            OOC-COMPANY      -> COL-COMPANY
                            OOC-ORDER-NBR    -> COL-ORDER-NBR
                            OOC-LINE-NBR     -> COL-LINE-NBR

Custorder      CUSTORDER    Required

                            OOC-COMPANY      -> COR-COMPANY
                            OOC-ORDER-NBR    -> COR-ORDER-NBR