OEINVCDTL

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OIDSET1 COMPANY
INVC-PREFIX
INVC-NUMBER
LINE-NBR
UOM
LOT
SUBLOT
BIN
SERIAL
WH20.7


OEINVCDTL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


File created: Thu Jun 09 11:09:32 2016

Home
Contact Us



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