|
|
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
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL320 BL520 BL820
BL92.1 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OEU-COMPANY Numeric 4 BL120 BL122
Element: Company Identifies the AP company if the BL130 BL20.1
resource type = V. Identifies the HR BL20.3 BL21.2
company if the resource type = E. It is BL21.5 BL29.1
blank for type A, P or Q resources. BL29.2 BL520
BL820 BL92.1
WH20.7
OEU-INVC-PREFIX Alpha 2 BL120 BL122
Element: Invc Prefix This field contains the invoice prefix BL130 BL20.1
that is assigned from either the company BL20.3 BL21.2
or process level, depending on the BL21.5 BL29.1
invoice-level option chosen. BL29.2 BL520
BL820 BL92.1
WH20.7
OEU-INVC-NUMBER Numeric 8 BL120 BL122
Element: Invc Number Invoice number assigned by the system. BL130 BL20.1
Invoice numbers are assigned at the BL20.3 BL21.2
company or process level, depending on BL21.5 BL29.1
an invoice level option on the company BL29.2 BL520
file. BL820 BL92.1
WH20.7
OEU-LINE-NBR Numeric 6 BL120 BL122
Element: Line Nbr Displays the system-assigned line BL130 BL20.1
number of the transaction that is priced BL20.3 BL21.2
using multiple units of measure. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OEU-UOM Alpha 4 Occurs 10 Times BL120 BL122
Element: Uom This field contains the valid stock BL130 BL20.1
unit of measure for this item. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OEU-UOM-MULT Signed 13.7 Occurs 10 Times BL120 BL122
Element: Uom Mult This field contains the multiplier for BL130 BL20.1
converting this unit of measure to stock BL20.3 BL21.2
unit of measure. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OEU-SELL-PRICE-FL Alpha 1 Occurs 10 Times BL120 BL122
Element: Account Flag This flag specifies if this alternate BL130 BL20.1
unit of measure is valid for the sell BL20.3 BL21.2
price in the Order Entry system. Valid BL21.5 BL29.1
values are: BL29.2 BL520
Blank = Cannot be used BL820 BL92.1
1 = Valid, default on entry WH20.7
2 = Valid
OEU-SPR-QTY Signed 13.4 Occurs 10 Times BL120 BL122
Element: Quantity This field contains the quantity priced BL130 BL20.1
in this unit of measure. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OEU-UNIT-PRICE Signed 18.5 Occurs 10 Times BL120 BL122
Element: Intl Cost BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OEU-UOM-1 Derived
Element: Uom 1 This field contains the first unit of
measure for the item.
OEU-UOM-2 Derived
Element: Uom 2 This field contains the second unit of
measure for the item.
OEU-UOM-3 Derived
Element: Uom 3 This field contains the third unit of
measure for the item.
OEU-UOM-4 Derived
Element: Uom 4 This field contains the fourth unit of
measure for the item.
OEU-UOM-5 Derived
Element: Uom 5 This field contains the fifth unit of
measure for the item.
OEU-UOM-6 Derived
Element: Uom 6 This field contains the sixth unit of
measure for the item.
OEU-UOM-7 Derived
Element: Uom 7
OEU-UOM-8 Derived
Element: Uom 8
OEU-UOM-9 Derived
Element: Uom 9
OEU-UOM-10 Derived
Element: Uom 10
OEU-SPR-QTY-1 Derived
Element: Spr Qty 1 This field contains the first sell
price quantity.
OEU-SPR-QTY-2 Derived
Element: Spr Qty 2 This field contains the second sell
price quantity.
OEU-SPR-QTY-3 Derived
Element: Spr Qty 3 This field contains the third sell
price quantity.
OEU-SPR-QTY-4 Derived
Element: Spr Qty 4 This field contains the fourth sell
price quantity.
OEU-SPR-QTY-5 Derived
Element: Spr Qty 5 This field contains the fifth sell
price quantity.
OEU-SPR-QTY-6 Derived
Element: Spr Qty 6 This field contains the sixth sell
price quantity.
OEU-SPR-QTY-7 Derived
Element: Spr Qty 7
OEU-SPR-QTY-8 Derived
Element: Spr Qty 8
OEU-SPR-QTY-9 Derived
Element: Spr Qty 9
OEU-SPR-QTY-10 Derived
Element: Spr Qty 10
OEU-UNIT-PRICE-1 Derived
Element: Unit Price 1 This field contains the price using the
first unit of measure.
OEU-UNIT-PRICE-2 Derived
Element: Unit Price 2 This field contains the price using the
second unit of measure.
OEU-UNIT-PRICE-3 Derived
Element: Unit Price 3 This field contains the price using the
third unit of measure.
OEU-UNIT-PRICE-4 Derived
Element: Unit Price 4 This field contains the price using the
fourth unit of measure.
OEU-UNIT-PRICE-5 Derived
Element: Unit Price 5 This field contains the price using the
fifth unit of measure.
OEU-UNIT-PRICE-6 Derived
Element: Unit Price 6 This field contains the price using the
sixth unit of measure.
OEU-UNIT-PRICE-7 Derived
Element: Unit Price 7
OEU-UNIT-PRICE-8 Derived
Element: Unit Price 8
OEU-UNIT-PRICE-9 Derived
Element: Unit Price 9
OEU-UNIT-PRICE-10 Derived
Element: Unit Price 10
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
WH20.7
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 OIL-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 (OIL-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
|
