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