OEINVHDR – Invoice Header

System: Billing (BL)
Prefix: OIH
Primary key: COMPANY, BATCH-NBR
Fields: 10
Updated by: 1 program
Referenced by: 0 programs

OEINVHDR is the Invoice Header table in Lawson Billing (prefix OIH). It is indexed by COMPANY, BATCH-NBR (OIHSET1). It is related 1:1 to OECOMPANY and 1:M to OEINVOICE. It is updated by WH20.7. The table has 10 fields, 1 index and 2 documented relations.

About OEINVHDR

No description in the Lawson data dictionary.

Fields (10)

Column = COBOL field name without the OIH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`OIH-COMPANY` PK 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.	WH20.7
`OIH-BATCH-NBR` PK BATCH_NBR	Numeric 6	This identifies the batch the entered invoices, debit memos, and credit memos are a part of.	WH20.7
`OIH-STATUS` STATUS	Numeric 1	This field displays the status of the transaction. `0` Unreleased `1` Released	—
`OIH-BATCH-DATE` BATCH_DATE	Numeric 8 (yyyymmdd)	This is the date the batch was created.	WH20.7
`OIH-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	The description of the batch.	WH20.7
`OIH-BATCH-COUNT` BATCH_COUNT	Signed 5.0	Control total number of records in the batch.	WH20.7
`OIH-DETAIL-COUNT` DETAIL_COUNT	Signed 5.0	The total number of records that have been entered in the batch.	WH20.7
`OIH-BTCH-QUANTITY` BTCH_QUANTITY	Signed 13.4	Control total amount in the invoice batch.	WH20.7
`OIH-DTL-QUANTITY` DTL_QUANTITY	Signed 13.4	The total amount actually entered into the batch.	WH20.7
`OIH-INVC-SOURCE` INVC_SOURCE	Alpha 1	Identifies where the invoices within the batch came from. For example, were they interfaced, manually entered, or created by the system. `I` Interfaced `M` Manual `S` Shipment `R` Return `C` Recurring Invoice	WH20.7

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`OIHSET1`	`COMPANY`, `BATCH-NBR`	Primary		WH20.7

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Company	OECOMPANY	Required		`OIH-COMPANY` → `OEC-COMPANY`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Oeinvoice	OEINVOICE	Delete Cascades		`OIH-COMPANY` → `OEI-COMPANY`, `OIH-BATCH-NBR` → `OEI-BATCH-NBR`, → `OEI-INVC-PREFIX`, → `OEI-INVC-NUMBER`

Programs

Updated by (1)

WH20.7 Substitute Location