Invoice Lot/Serial/Bin Dtls

This file stores lot, serial, and bin information for invoice lines. Only items that require that information will have records here. A company or process level option (depending on what level invoicing is processed) determines whether these actually print on the invoice.
UPDATED BY

WH20.7

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
OID-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.
OID-INVC-PREFIX Element: 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 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.
OID-LINE-NBR Element: Line Nbr	Numeric 6 Indicates the line number on the invoice to which this detail record belongs.
OID-UOM Element: Uom	Alpha 4 This is the selling unit of measure for the invoice line this detail is attached to.
OID-LOT Element: Lot	Alpha 10 Identifier for a homogeneous quantity of material. Only necessary if the item is defined as lot tracking.
OID-SUBLOT Element: 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 Element: 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 Element: Serial	Alpha 16 Serial number of this particular line on the invoice. Only necessary if the item is serial tracked.
OID-QUANTITY Element: Quantity	Signed 13.4 This is the requested quantity for the line item.
OID-INVC-CW-QTY Element: Quantity	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 Element: Uom Mult	Signed 13.7 This field contains the multiplier for converting this unit of measure to stock unit of measure.
OID-LOT-STRING Element: 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 Element: 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 Element: 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 Element: Uom String	Derived This field identifies the format of the unit of measure that should print on the invoice.
OID-PRINT-STRING Element: Print String	Derived This field determines the format of the detail for the line to print on the invoice.

OEINVCDTL FILE INDEX

OEINVCDTL FILE RELATIONS

ONE TO ONE RELATIONS

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