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