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
BL121 BL122 BL220 BL290 BL80.1
UPDATED BY
BL120 BL130 BL20.1 BL20.3 BL21.2 BL21.3
BL21.4 BL21.5 BL21.6 BL22.1 BL29.1 BL29.2
BL320 BL520 BL820 BL92.1 BL940 OE114
OE129 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5
OE30.6 OE30.7 OE30.9 OE310 OE330 OE830
OE950
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OIC-COMPANY Numeric 4 BL120 BL130
Company The company number represents an BL20.1 BL20.3
established company and is entered on BL21.2 BL21.3
all function codes. BL21.4 BL21.5
BL21.6 BL22.1
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OIC-INVC-PREFIX Alpha 2 BL120 BL130
Invoice Prefix This field contains the invoice prefix BL20.1 BL20.3
that is assigned from either the company BL21.2 BL21.3
or process level, depending on the BL21.4 BL21.5
invoice-level option chosen. BL21.6 BL22.1
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OIC-INVC-NUMBER Numeric 8 BL120 BL130
Invc Number Invoice number assigned by the system. BL20.1 BL20.3
Invoice numbers are assigned at the BL21.2 BL21.3
company or process level, depending on BL21.4 BL21.5
an invoice level option on the company BL21.6 BL22.1
file. In this file the invoice number BL29.1 BL29.2
indicates which invoice or debit memo BL520 BL820
the comment belongs to. BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OIC-LINE-NBR Numeric 6 BL120 BL130
Line Number Identifies the line number on the BL20.1 BL20.3
invoice to which the comment is BL21.2 BL21.3
attached. BL21.4 BL21.5
BL21.6 BL22.1
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OIC-SEQ Numeric 3 BL120 BL130
Sequence Number The sequence number of the comment. BL20.1 BL20.3
BL21.2 BL21.3
BL21.4 BL21.5
BL21.6 BL22.1
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OIC-COMMENT Alpha 40 (Lower Case) BL120 BL130
Comment Line Enter comment text that is associated BL20.1 BL20.3
with this invoice. BL21.2 BL21.3
BL21.4 BL21.5
BL21.6 BL22.1
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OIC-PRINT-CODE Alpha 1 BL120 BL130
Print Code The print code defines where the BL20.1 BL20.3
comment displays and/or prints. BL21.2 BL21.3
B = Both, display and print. BL21.4 BL21.5
D = Display only. BL21.6 BL22.1
P = Print on forms and reports. BL29.1 BL29.2
R = Print on reports only. BL520 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OEINVCCOMM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OICSET1 COMPANY BL120 BL121
INVC-PREFIX BL122 BL130
INVC-NUMBER BL20.1 BL20.3
LINE-NBR BL21.2 BL21.3
SEQ BL21.4 BL21.5
BL220 BL29.1
BL29.2 BL290
BL320 BL520
BL80.1 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
...
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
|