|
|
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 BL220 BL290
BL80.1 OE114
UPDATED BY
BL21.3 BL21.4 BL320 BL520 BL820 BLI2.1
BLI3.1 OE310 OE330
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: Invoice PrefixThis 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 Number 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: Sequence NumbeThe 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 BL21.3 BL21.4
LINE-NBR BL220 BL290
SEQ BL320 BL520
BL80.1 BL820
BLI2.1 BLI3.1
OE114 OE310
OE330
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
|
