OEINVCCOMM – Invoice Comments

System
Billing (BL)
Prefix
OIC
Primary key
COMPANY, INVC-PREFIX, INVC-NUMBER, LINE-NBR, SEQ
Fields
6
Updated by
2 programs
Referenced by
0 programs

OEINVCCOMM is the Invoice Comments table in Lawson Billing (prefix OIC). It is indexed by COMPANY, INVC-PREFIX, INVC-NUMBER, LINE-NBR, SEQ (OICSET1). It is related 1:1 to OEINVCLINE and OEINVOICE. It is updated by BLI2.1 and BLI3.1. The table has 6 fields, 1 index and 2 documented relations.

About OEINVCCOMM

No description in the Lawson data dictionary.

Fields (6)

Column = COBOL field name without the OIC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#OIC-COMPANY PK
COMPANY		Numeric 4Identifies 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 PK
INVC_PREFIX		Alpha 2This 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 PK
INVC_NUMBER		Numeric 8Invoice 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 PK
LINE_NBR		Numeric 6Identifies the line number on the invoice to which the comment is attached.BLI2.1
#OIC-SEQ PK
SEQ		Numeric 3The sequence number of the comment.BLI2.1
#OIC-PRINT-CODE
PRINT_CODE		Alpha 1The 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

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
OICSET1
  1. COMPANY
  2. INVC-PREFIX
  3. INVC-NUMBER
  4. LINE-NBR
  5. SEQ
PrimaryBLI2.1, BLI3.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
OEINVCLINEOEINVOICEOEINVCCOMM

One to one (2) — lookups and parents

RelationTableRulesConditionField map
OeinvclineOEINVCLINERequiredWhen 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
OeinvoiceOEINVOICERequired
OIC-COMPANY→OEI-COMPANY
OIC-INVC-PREFIX→OEI-INVC-PREFIX
OIC-INVC-NUMBER→OEI-INVC-NUMBER

Programs

Updated by (2)