OEINVCUOM

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.
UPDATED BY
WH20.7

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


OEINVCUOM FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OEUSET1 COMPANY
INVC-PREFIX
INVC-NUMBER
LINE-NBR
WH20.7


OEINVCUOM FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:09:35 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.