Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OEINVCCOMM


                            OEINVCCOMM FILE

                            Invoice Comments

This file contains invoice and invoice line comments that can optionally be
entered when adding an invoice to the system on BL20.1 (Invoice Entry).

UPDATED BY

BLI2.1    BLI3.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OIC-COMPANY            Numeric 4                                 BLI2.1
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

OIC-INVC-PREFIX        Alpha 2                                   BLI2.1
Element: Invoice PrefixThis field contains the invoice prefix
                       that is assigned from either the company
                       or process level, depending on the
                       invoice-level option chosen.

OIC-INVC-NUMBER        Numeric 8                                 BLI2.1
Element: Invc Number   Invoice number assigned by the system.
                       Invoice numbers are assigned at the
                       company or process level, depending on
                       an invoice level option on the company
                       file. In this file the invoice number
                       indicates which invoice or debit memo
                       the comment belongs to.

OIC-LINE-NBR           Numeric 6                                 BLI2.1
Element: Line Number   Identifies the line number on the
                       invoice to which the comment is
                       attached.

OIC-SEQ                Numeric 3                                 BLI2.1
Element: Sequence NumbeThe sequence number of the comment.

OIC-PRINT-CODE         Alpha 1                                   BLI2.1
Element: Print Code    The print code defines where the
                       comment displays and/or prints.
                       B = Both, display and print.
                       D = Display only.
                       P = Print on forms and reports.
                       R = Print on reports only.

                         OEINVCCOMM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OICSET1   COMPANY                                                BLI2.1  BLI3.1
          INVC-PREFIX
          INVC-NUMBER
          LINE-NBR
          SEQ

                         OEINVCCOMM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oeinvcline     OEINVCLINE   Required
                            When OIC-LINE-NBR != Zeroes
                            And  OIC-LINE-NBR != 999999

                            OIC-COMPANY        -> OIL-COMPANY
                            OIC-INVC-PREFIX    -> OIL-INVC-PREFIX
                            OIC-INVC-NUMBER    -> OIL-INVC-NUMBER
                            OIC-LINE-NBR       -> OIL-LINE-NBR

Oeinvoice      OEINVOICE    Required

                            OIC-COMPANY        -> OEI-COMPANY
                            OIC-INVC-PREFIX    -> OEI-INVC-PREFIX
                            OIC-INVC-NUMBER    -> OEI-INVC-NUMBER