Lawson Insight Technical Documentation |
|
OEINVCUOM
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 OE114 OE129 OE30.1 OE30.2 OE30.3
OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE310
OE330 OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OEU-INVC-PREFIX Alpha 2 BL120 BL122
Element: Invoice PrefixThis 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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OEU-LINE-NBR Numeric 6 BL120 BL122
Element: Line Number 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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OEU-UOM Alpha 4 Occurs 10 Times BL120 BL122
Element: Unit of MeasurThis 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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OEU-UOM-MULT Signed 13.7 Occurs 10 Times BL120 BL122
Unit of Measure This field contains the multiplier for BL130 BL20.1
Multiplier converting this unit of measure to stock BL20.3 BL21.2
unit of measure. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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 OE114 OE129
2 = Valid OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OEU-UNIT-PRICE Signed 18.5 Occurs 10 Times BL120 BL122
Element: Intl Cost This field contains the unit price. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE310 OE330
OE530 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 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
|