Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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