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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#OID-COMPANY PKCOMPANY | 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 PKINVC_PREFIX | Alpha 2 | Invoice prefix is assigned from either the company or process level depending on the invoice level option chosen. | — |
#OID-INVC-NUMBER PKINVC_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 PKLINE_NBR | Numeric 6 | Indicates the line number on the invoice to which this detail record belongs. | — |
#OID-UOM PKUOM | Alpha 4 | This is the selling unit of measure for the invoice line this detail is attached to. | — |
#OID-LOT PKLOT | Alpha 10 | Identifier for a homogeneous quantity of material. Only necessary if the item is defined as lot tracking. | — |
#OID-SUBLOT PKSUBLOT | 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 PKBIN | 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 PKSERIAL | Alpha 16 | Serial number of this particular line on the invoice. Only necessary if the item is serial tracked. | — |
#OID-QUANTITYQUANTITY | Signed 13.4 | This is the requested quantity for the line item. | — |
#OID-INVC-CW-QTYINVC_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-MULTUOM_MULT | Signed 13.7 | This field contains the multiplier for converting this unit of measure to stock unit of measure. | — |
#OID-LOT-STRINGLOT_STRING | Derived | If the item is lot tracked, this field identifies the format for the lot information to print on the invoice. | — |
#OID-BIN-STRINGBIN_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-STRINGSERIAL_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-STRINGUOM_STRING | Derived | This field identifies the format of the unit of measure that should print on the invoice. | — |
#OID-PRINT-STRINGPRINT_STRING | Derived | This field determines the format of the detail for the line to print on the invoice. | — |
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
OIDSET1 |
| Primary | WH20.7 |
Relations
One to one (5) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Coline | COLINE | Required |
| |||||||||||||
| Iccompany | ICCOMPANY | Required |
| |||||||||||||
| Itemloc | ITEMLOC | Required |
| |||||||||||||
| Itemmast | ITEMMAST | Required |
| |||||||||||||
| Oeinvcline | OEINVCLINE | Required |
|
Programs
Updated by (1)
- WH20.7 Substitute Location