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 BL122 BL290 BL80.1
UPDATED BY
BL120 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL320 BL520 BL820 BL92.1
BL940 OE114 OE129 OE30.1 OE30.2 OE30.3
OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE310
OE330 OE830 OE950
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OID-COMPANY Numeric 4 BL820 BL940
Company The company number represents an OE114 OE129
established company and is entered on OE30.1 OE30.2
all function codes. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OID-INVC-PREFIX Alpha 2 BL820 BL940
Invoice Prefix Invoice prefix is assigned from either OE114 OE129
the company or process level depending OE30.1 OE30.2
on the invoice level option chosen. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OID-INVC-NUMBER Numeric 8 BL820 BL940
Invc Number Invoice number assigned by the system. OE114 OE129
Invoice numbers are assigned at the OE30.1 OE30.2
company or process level, depending on OE30.3 OE30.4
an invoice level option on the company OE30.5 OE30.6
file. OE30.7 OE30.9
OE830 OE950
OID-LINE-NBR Numeric 6 BL820 BL940
Line Number Indicates the line number on the OE114 OE129
invoice to which this detail record OE30.1 OE30.2
belongs. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OID-UOM Alpha 4 BL820 BL940
Unit of Measure This is the selling unit of measure for OE114 OE129
the invoice line this detail is attached OE30.1 OE30.2
to. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OID-LOT Alpha 10 BL820 BL940
Lot Number Identifier for a homogeneous quantity OE114 OE129
of material. Only necessary if the item OE30.1 OE30.2
is defined as lot tracking. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OID-SUBLOT Alpha 6 BL820 BL940
Sublot Number Identifier for a detail breakdown of a OE114 OE129
lot number. Only necessary if the item OE30.1 OE30.2
on this line is defined as lot tracking. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OID-BIN Alpha 7 BL820 BL940
Bin A storage area for an item or any OE114 OE129
number of items. Only necessary if the OE30.1 OE30.2
item on this line is bin tracked. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OID-SERIAL Alpha 16 BL820 BL940
Serial Number Serial number of this particular line OE114 OE129
on the invoice. Only necessary if the OE30.1 OE30.2
item is serial tracked. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OID-QUANTITY Signed 13.4 BL820 BL940
Quantity This is the requested quantity for the OE114 OE129
line item. OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OID-INVC-CW-QTY Signed 13.4 BL820 BL940
Invc Cw Qty Invoice catch weight quantity. This OE114 OE129
field is valid only for catch weight OE30.1 OE30.2
items. This is used in extended price OE30.3 OE30.4
calculation, but quantity is used for OE30.5 OE30.6
pricing. OE30.7 OE30.9
OE830 OE950
OID-UOM-MULT Signed 13.7 BL820 BL940
Unit of Measure This field contains the multiplier for OE114 OE129
Multiplier converting this unit of measure to stock OE30.1 OE30.2
unit of measure. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
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 BL120 BL121
INVC-PREFIX BL122 BL130
INVC-NUMBER BL20.1 BL20.3
LINE-NBR BL21.2 BL21.5
UOM BL29.1 BL29.2
LOT BL290 BL320
SUBLOT BL520 BL80.1
BIN BL820 BL92.1
SERIAL BL940 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE310
OE330 OE830
...
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
|