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 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
OEU-COMPANY Numeric 4 BL120 BL130
Company The company number represents an BL20.1 BL20.3
established company and is entered on BL21.2 BL21.5
all function codes. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OEU-INVC-PREFIX Alpha 2 BL120 BL130
Invoice Prefix This field contains the invoice prefix BL20.1 BL20.3
that is assigned from either the company BL21.2 BL21.5
or process level, depending on the BL29.1 BL29.2
invoice-level option chosen. BL520 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OEU-INVC-NUMBER Numeric 8 BL120 BL130
Invc Number Invoice number assigned by the system. BL20.1 BL20.3
Invoice numbers are assigned at the BL21.2 BL21.5
company or process level, depending on BL29.1 BL29.2
an invoice level option on the company BL520 BL820
file. BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OEU-LINE-NBR Numeric 6 BL120 BL130
Line Number Displays the system-assigned line BL20.1 BL20.3
number of the transaction that is priced BL21.2 BL21.5
using multiple units of measure. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OEU-UOM Alpha 4 Occurs 6 Times BL120 BL130
Unit of Measure This field contains the valid stock BL20.1 BL20.3
unit of measure for this item. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OEU-UOM-MULT Signed 13.7 Occurs 6 Times BL120 BL130
Unit of Measure This field contains the multiplier for BL20.1 BL20.3
Multiplier converting this unit of measure to stock BL21.2 BL21.5
unit of measure. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OEU-SELL-PRICE-FL Alpha 1 Occurs 6 Times BL120 BL130
Sell Price Flag This flag specifies if this alternate BL20.1 BL20.3
unit of measure is valid for the sell BL21.2 BL21.5
price in the Order Entry system. Valid BL29.1 BL29.2
values are: BL520 BL820
Blank = Cannot be used BL92.1 BL940
1 = Valid, default on entry OE114 OE129
2 = Valid OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OEU-SPR-QTY Signed 13.4 Occurs 6 Times BL120 BL130
Spr Qty This field contains the quantity priced BL20.1 BL20.3
in this unit of measure. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OEU-UNIT-PRICE Signed 13.5 Occurs 6 Times BL120 BL130
Unit Price This field contains the unit price. BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
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-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-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.
OEINVCUOM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OEUSET1 COMPANY BL120 BL121
INVC-PREFIX BL122 BL130
INVC-NUMBER BL20.1 BL20.3
LINE-NBR BL21.2 BL21.5
BL29.1 BL29.2
BL290 BL320
BL520 BL80.1
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
...
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
|