OEINVCCOMM

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
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
BLI2.1
OIC-INVC-PREFIX
Element: Invc Prefix
Alpha 2
This field contains the invoice prefix that is assigned from either the company or process level, depending on the invoice-level option chosen.
BLI2.1
OIC-INVC-NUMBER
Element: Invc Number
Numeric 8
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.
BLI2.1
OIC-LINE-NBR
Element: Line Nbr
Numeric 6
Identifies the line number on the invoice to which the comment is attached.
BLI2.1
OIC-SEQ
Element: Seq
Numeric 3
The sequence number of the comment.
BLI2.1
OIC-PRINT-CODE
Element: Print Code
Alpha 1
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.
BLI2.1


OEINVCCOMM FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OICSET1 COMPANY
INVC-PREFIX
INVC-NUMBER
LINE-NBR
SEQ
BLI2.1 BLI3.1


OEINVCCOMM FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Oeinvcline OEINVCLINE Required
When OIC-LINE-NBR !=Zeroes
AndOIC-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


File created: Thu Jun 09 02:09:33 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.