OEINVCDTL FILE
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.
REFERENCED BY
BL121 BL290 BL80.1
UPDATED BY
BL320
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OID-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
OID-INVC-PREFIX Alpha 2
Invoice Prefix Invoice prefix is assigned from either
the company or process level depending
on the invoice level option chosen.
OID-INVC-NUMBER Numeric 8
Invc Number 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 Numeric 6
Line Number Indicates the line number on the
invoice to which this detail record
belongs.
OID-UOM Alpha 4
Unit of Measure This is the selling unit of measure for
the invoice line this detail is attached
to.
OID-LOT Alpha 10
Lot Number Identifier for a homogeneous quantity
of material. Only necessary if the item
is defined as lot tracking.
OID-SUBLOT Alpha 6
Sublot Number Identifier for a detail breakdown of a
lot number. Only necessary if the item
on this line is defined as lot tracking.
OID-BIN Alpha 7
Bin A storage area for an item or any
number of items. Only necessary if the
item on this line is bin tracked.
OID-SERIAL Alpha 16
Serial Number Serial number of this particular line
on the invoice. Only necessary if the
item is serial tracked.
OID-QUANTITY Signed 13.4
Quantity This is the requested quantity for the
line item.
OID-INVC-CW-QTY Signed 13.4
Invc Cw Qty 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 Signed 13.7
Unit of Measure This field contains the multiplier for
Multiplier converting this unit of measure to stock
unit of measure.
OID-LOT-STRING Derived
Lot String If the item is lot tracked, this field
identifies the format for the lot
information to print on the invoice.
OID-BIN-STRING Derived
Bin String If the item is bin tracked, this field
identifies the format in which the bin
number should print on the invoice.
OID-SERIAL-STRING Derived
Serial String If the item is serial tracked, this
field identifies the format in which the
serial number should print on the
invoice.
OID-UOM-STRING Derived
Uom String This field identifies the format of the
unit of measure that should print on the
invoice.
OID-PRINT-STRING Derived
Print String 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 BL121 BL290
INVC-PREFIX BL320 BL80.1
INVC-NUMBER
LINE-NBR
UOM
LOT
SUBLOT
BIN
SERIAL
OEINVCDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
