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