OEINVCUOM FILE
Invoice Unit of Measures
This file stores the invoice lines that are priced using multiple units of
measure. The multiple stock units of measure used for each line as well as
the different sell price quantities used.
REFERENCED BY
BL121 BL290 BL80.1
UPDATED BY
BL320
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OEU-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
OEU-INVC-PREFIX Alpha 2
Invoice Prefix This field contains the invoice prefix
that is assigned from either the company
or process level, depending on the
invoice-level option chosen.
OEU-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.
OEU-LINE-NBR Numeric 6
Line Number Displays the system-assigned line
number of the transaction that is priced
using multiple units of measure.
OEU-UOM Alpha 4 Occurs 10 Times
Unit of Measure This field contains the valid stock
unit of measure for this item.
OEU-UOM-MULT Signed 13.7 Occurs 10 Times
Unit of Measure This field contains the multiplier for
Multiplier converting this unit of measure to stock
unit of measure.
OEU-SELL-PRICE-FL Alpha 1 Occurs 10 Times
Sell Price Flag This flag specifies if this alternate
unit of measure is valid for the sell
price in the Order Entry system. Valid
values are:
Blank = Cannot be used
1 = Valid, default on entry
2 = Valid
OEU-SPR-QTY Signed 13.4 Occurs 10 Times
Spr Qty This field contains the quantity priced
in this unit of measure.
OEU-UNIT-PRICE Signed 13.5 Occurs 10 Times
Unit Price This field contains the unit price.
OEU-UOM-1 Derived
Uom 1 This field contains the first unit of
measure for the item.
OEU-UOM-2 Derived
Uom 2 This field contains the second unit of
measure for the item.
OEU-UOM-3 Derived
Uom 3 This field contains the third unit of
measure for the item.
OEU-UOM-4 Derived
Uom 4 This field contains the fourth unit of
measure for the item.
OEU-UOM-5 Derived
Uom 5 This field contains the fifth unit of
measure for the item.
OEU-UOM-6 Derived
Uom 6 This field contains the sixth unit of
measure for the item.
OEU-UOM-7 Derived
Uom 7
OEU-UOM-8 Derived
Uom 8
OEU-UOM-9 Derived
Uom 9
OEU-UOM-10 Derived
Uom 10
OEU-SPR-QTY-1 Derived
Spr Qty 1 This field contains the first sell
price quantity.
OEU-SPR-QTY-2 Derived
Spr Qty 2 This field contains the second sell
price quantity.
OEU-SPR-QTY-3 Derived
Spr Qty 3 This field contains the third sell
price quantity.
OEU-SPR-QTY-4 Derived
Spr Qty 4 This field contains the fourth sell
price quantity.
OEU-SPR-QTY-5 Derived
Spr Qty 5 This field contains the fifth sell
price quantity.
OEU-SPR-QTY-6 Derived
Spr Qty 6 This field contains the sixth sell
price quantity.
OEU-SPR-QTY-7 Derived
Spr Qty 7
OEU-SPR-QTY-8 Derived
Spr Qty 8
OEU-SPR-QTY-9 Derived
Spr Qty 9
OEU-SPR-QTY-10 Derived
Spr Qty 10
OEU-UNIT-PRICE-1 Derived
Unit Price 1 This field contains the price using the
first unit of measure.
OEU-UNIT-PRICE-2 Derived
Unit Price 2 This field contains the price using the
second unit of measure.
OEU-UNIT-PRICE-3 Derived
Unit Price 3 This field contains the price using the
third unit of measure.
OEU-UNIT-PRICE-4 Derived
Unit Price 4 This field contains the price using the
fourth unit of measure.
OEU-UNIT-PRICE-5 Derived
Unit Price 5 This field contains the price using the
fifth unit of measure.
OEU-UNIT-PRICE-6 Derived
Unit Price 6 This field contains the price using the
sixth unit of measure.
OEU-UNIT-PRICE-7 Derived
Unit Price 7
OEU-UNIT-PRICE-8 Derived
Unit Price 8
OEU-UNIT-PRICE-9 Derived
Unit Price 9
OEU-UNIT-PRICE-10 Derived
Unit Price 10
OEINVCUOM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OEUSET1 COMPANY BL121 BL290
INVC-PREFIX BL320 BL80.1
INVC-NUMBER
LINE-NBR
OEINVCUOM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcustomer ARCUSTOMER Required
OEU-COMPANY -> ACM-COMPANY
OEI-CUSTOMER -> ACM-CUSTOMER
Contract OEPRCLIST Required
When OEU-CONTRACT-NBR != Spaces
OEU-COMPANY -> OPL-COMPANY
OEI-CUSTOMER -> OPL-CUSTOMER
OIL-CONTRACT-NBR -> OPL-LIST-NAME
Spaces -> OPL-PROMOTION
Iccompany ICCOMPANY Required
OIL-COMPANY -> ICC-COMPANY
Itemmast ITEMMAST Required
When (OEU-LINE-TYPE != "X" )
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
OIL-ITEM -> ITE-ITEM
Oeinvcline OEINVCLINE Required
OEU-COMPANY -> OIL-COMPANY
OEU-INVC-PREFIX -> OIL-INVC-PREFIX
OEU-INVC-NUMBER -> OIL-INVC-NUMBER
OEU-LINE-NBR -> OIL-LINE-NBR
Oeinvoice OEINVOICE Required
OEU-COMPANY -> OEI-COMPANY
OEU-INVC-PREFIX -> OEI-INVC-PREFIX
OEU-INVC-NUMBER -> OEI-INVC-NUMBER
|
