OEINVCDTL – Invoice Lot/Serial/Bin Dtls

System: Billing (BL)
Prefix: OID
Primary key: COMPANY, INVC-PREFIX, INVC-NUMBER, LINE-NBR, UOM, LOT, SUBLOT, BIN, SERIAL
Fields: 17
Updated by: 1 program
Referenced by: 0 programs

OEINVCDTL is the Invoice Lot/Serial/Bin Dtls table in Lawson Billing (prefix OID). It is indexed by COMPANY, INVC-PREFIX, INVC-NUMBER, LINE-NBR, UOM, LOT, SUBLOT, BIN, SERIAL (OIDSET1). It is related 1:1 to COLINE, ICCOMPANY, ITEMLOC, ITEMMAST and OEINVCLINE. It is updated by WH20.7. The table has 17 fields, 1 index and 5 documented relations.

About OEINVCDTL

No description in the Lawson data dictionary.

Fields (17)

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

Field / column	Type	Description & values	Updated by
`OID-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.	—
`OID-INVC-PREFIX` PK INVC_PREFIX	Alpha 2	Invoice prefix is assigned from either the company or process level depending on the invoice level option chosen.	—
`OID-INVC-NUMBER` PK 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.	—
`OID-LINE-NBR` PK LINE_NBR	Numeric 6	Indicates the line number on the invoice to which this detail record belongs.	—
`OID-UOM` PK UOM	Alpha 4	This is the selling unit of measure for the invoice line this detail is attached to.	—
`OID-LOT` PK LOT	Alpha 10	Identifier for a homogeneous quantity of material. Only necessary if the item is defined as lot tracking.	—
`OID-SUBLOT` PK SUBLOT	Alpha 6	Identifier for a detail breakdown of a lot number. Only necessary if the item on this line is defined as lot tracking.	—
`OID-BIN` PK BIN	Alpha 7	A storage area for an item or any number of items. Only necessary if the item on this line is bin tracked.	—
`OID-SERIAL` PK SERIAL	Alpha 16	Serial number of this particular line on the invoice. Only necessary if the item is serial tracked.	—
`OID-QUANTITY` QUANTITY	Signed 13.4	This is the requested quantity for the line item.	—
`OID-INVC-CW-QTY` INVC_CW_QTY	Signed 13.4	Invoice catch weight quantity. This field is valid only for catch weight items. This is used in extended price calculation, but quantity is used for pricing.	—
`OID-UOM-MULT` UOM_MULT	Signed 13.7	This field contains the multiplier for converting this unit of measure to stock unit of measure.	—
`OID-LOT-STRING` LOT_STRING	Derived	If the item is lot tracked, this field identifies the format for the lot information to print on the invoice.	—
`OID-BIN-STRING` BIN_STRING	Derived	If the item is bin tracked, this field identifies the format in which the bin number should print on the invoice.	—
`OID-SERIAL-STRING` SERIAL_STRING	Derived	If the item is serial tracked, this field identifies the format in which the serial number should print on the invoice.	—
`OID-UOM-STRING` UOM_STRING	Derived	This field identifies the format of the unit of measure that should print on the invoice.	—
`OID-PRINT-STRING` PRINT_STRING	Derived	This field determines the format of the detail for the line to print on the invoice.	—

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
`OIDSET1`	`COMPANY`, `INVC-PREFIX`, `INVC-NUMBER`, `LINE-NBR`, `UOM`, `LOT`, `SUBLOT`, `BIN`, `SERIAL`	Primary		WH20.7

Relations

One to one (5) — lookups and parents

Relation	Table	Rules	Field map
Coline	COLINE	Required	`OID-COMPANY` → `COL-COMPANY`, `OIL-ORDER-NBR` → `COL-ORDER-NBR`, `OIL-LINE-NBR` → `COL-LINE-NBR`
Iccompany	ICCOMPANY	Required	`OID-COMPANY` → `ICC-COMPANY`
Itemloc	ITEMLOC	Required	`OID-COMPANY` → `ITL-COMPANY`, `OIL-LOCATION` → `ITL-LOCATION`, `OIL-ITEM` → `ITL-ITEM`
Itemmast	ITEMMAST	Required	`ICC-ITEM-GROUP` → `ITE-ITEM-GROUP`, `OIL-ITEM` → `ITE-ITEM`
Oeinvcline	OEINVCLINE	Required	`OID-COMPANY` → `OIL-COMPANY`, `OID-INVC-PREFIX` → `OIL-INVC-PREFIX`, `OID-INVC-NUMBER` → `OIL-INVC-NUMBER`, `OID-LINE-NBR` → `OIL-LINE-NBR`

Programs

Updated by (1)

WH20.7 Substitute Location