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).

REFERENCED BY

BL120     BL121     BL122     BL20.2    BL20.4    BL220
BL290     BL80.1

UPDATED BY

BL21.3    BL21.4    BL320     BL520     BL820     BLI2.1
BLI3.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OIC-COMPANY            Numeric 4                                 BL21.3  BL21.4
Element: Company       Identifies the AP company if the          BL520   BL820
                       resource type = V.  Identifies the HR     BLI2.1
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

OIC-INVC-PREFIX        Alpha 2                                   BL21.3  BL21.4
Element: Invc Prefix   This field contains the invoice prefix    BL520   BL820
                       that is assigned from either the company  BLI2.1
                       or process level, depending on the
                       invoice-level option chosen.

OIC-INVC-NUMBER        Numeric 8                                 BL21.3  BL21.4
Element: Invc Number   Invoice number assigned by the system.    BL520   BL820
                       Invoice numbers are assigned at the       BLI2.1
                       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                                 BL21.3  BL21.4
Element: Line Nbr      Identifies the line number on the         BL520   BL820
                       invoice to which the comment is           BLI2.1
                       attached.

OIC-SEQ                Numeric 3                                 BL21.3  BL21.4
Element: Seq           The sequence number of the comment.       BL520   BL820
                                                                 BLI2.1

OIC-PRINT-CODE         Alpha 1                                   BL21.3  BL21.4
Element: Print Code    The print code defines where the          BL520   BL820
                       comment displays and/or prints.           BLI2.1
                       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                                                BL120   BL121
          INVC-PREFIX                                            BL122   BL20.2
          INVC-NUMBER                                            BL20.4  BL21.3
          LINE-NBR                                               BL21.4  BL220
          SEQ                                                    BL290   BL320
                                                                 BL520   BL80.1
                                                                 BL820   BLI2.1
                                                                 BLI3.1

                         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