Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OEINVCDTL


                             OEINVCDTL FILE

                      Invoice Lot/Serial/Bin Dtls

This file stores lot, serial, and bin information for invoice lines.  Only
items that require that information will have records here.  A company or
process level option (depending on what level invoicing is processed)
determines whether these actually print on the invoice.

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

OID-COMPANY            Numeric 4                                 BL820   OE114
Element: Company       Identifies the AP company if the          OE129   OE30.1
                       resource type = V.  Identifies the HR     OE30.2  OE30.3
                       company if the resource type = E.  It is  OE30.4  OE30.5
                       blank for type A, P or Q resources.       OE30.6  OE30.7
                                                                 OE30.9  OE530
                                                                 OE830

OID-INVC-PREFIX        Alpha 2                                   BL820   OE114
Element: Invoice PrefixInvoice prefix is assigned from either    OE129   OE30.1
                       the company or process level depending    OE30.2  OE30.3
                       on the invoice level option chosen.       OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE530
                                                                 OE830

OID-INVC-NUMBER        Numeric 8                                 BL820   OE114
Element: Invc Number   Invoice number assigned by the system.    OE129   OE30.1
                       Invoice numbers are assigned at the       OE30.2  OE30.3
                       company or process level, depending on    OE30.4  OE30.5
                       an invoice level option on the company    OE30.6  OE30.7
                       file.                                     OE30.9  OE530
                                                                 OE830

OID-LINE-NBR           Numeric 6                                 BL820   OE114
Element: Line Number   Indicates the line number on the          OE129   OE30.1
                       invoice to which this detail record       OE30.2  OE30.3
                       belongs.                                  OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE530
                                                                 OE830

OID-UOM                Alpha 4                                   BL820   OE114
Element: Unit of MeasurThis is the selling unit of measure for   OE129   OE30.1
                       the invoice line this detail is attached  OE30.2  OE30.3
                       to.                                       OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE530
                                                                 OE830

OID-LOT                Alpha 10                                  BL820   OE114
Element: Lot Number    Identifier for a homogeneous quantity     OE129   OE30.1
                       of material. Only necessary if the item   OE30.2  OE30.3
                       is defined as lot tracking.               OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE530
                                                                 OE830

OID-SUBLOT             Alpha 6                                   BL820   OE114
Element: Sublot Number Identifier for a detail breakdown of a    OE129   OE30.1
                       lot number. Only necessary if the item    OE30.2  OE30.3
                       on this line is defined as lot tracking.  OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE530
                                                                 OE830

OID-BIN                Alpha 7                                   BL820   OE114
Element: Bin           A storage area for an item or any         OE129   OE30.1
                       number of items. Only necessary if the    OE30.2  OE30.3
                       item on this line is bin tracked.         OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE530
                                                                 OE830

OID-SERIAL             Alpha 16                                  BL820   OE114
Element: Serial Number Serial number of this particular line     OE129   OE30.1
                       on the invoice. Only necessary if the     OE30.2  OE30.3
                       item is serial tracked.                   OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE530
                                                                 OE830

OID-QUANTITY           Signed 13.4                               BL820   OE114
Element: Quantity      This is the requested quantity for the    OE129   OE30.1
                       line item.                                OE30.2  OE30.3
                                                                 OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE530
                                                                 OE830

OID-INVC-CW-QTY        Signed 13.4                               BL820   OE114
Element: Quantity      Invoice catch weight quantity. This       OE129   OE30.1
                       field is valid only for catch weight      OE30.2  OE30.3
                       items. This is used in extended price     OE30.4  OE30.5
                       calculation, but quantity is used for     OE30.6  OE30.7
                       pricing.                                  OE30.9  OE530
                                                                 OE830

OID-UOM-MULT           Signed 13.7                               BL820   OE114
Unit of Measure        This field contains the multiplier for    OE129   OE30.1
Multiplier             converting this unit of measure to stock  OE30.2  OE30.3
                       unit of measure.                          OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE530
                                                                 OE830

OID-LOT-STRING         Derived
Element: Lot String    If the item is lot tracked, this field
                       identifies the format for the lot
                       information to print on the invoice.

OID-BIN-STRING         Derived
Element: Bin String    If the item is bin tracked, this field
                       identifies the format in which the bin
                       number should print on the invoice.

OID-SERIAL-STRING      Derived
Element: Serial String If the item is serial tracked, this
                       field identifies the format in which the
                       serial number should print on the
                       invoice.

OID-UOM-STRING         Derived
Element: Uom String    This field identifies the format of the
                       unit of measure that should print on the
                       invoice.

OID-PRINT-STRING       Derived
Element: Print String  This field determines the format of the
                       detail for the line to print on the
                       invoice.

                         OEINVCDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OIDSET1   COMPANY                                                BL120   BL121
          INVC-PREFIX                                            BL122   BL130
          INVC-NUMBER                                            BL20.1  BL20.3
          LINE-NBR                                               BL21.2  BL21.5
          UOM                                                    BL29.1  BL29.2
          LOT                                                    BL290   BL320
          SUBLOT                                                 BL520   BL80.1
          BIN                                                    BL820   BL92.1
          SERIAL                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE310   OE330
                                                                 OE530   OE830

                         OEINVCDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Coline         COLINE       Required

                            OID-COMPANY        -> COL-COMPANY
                            OIL-ORDER-NBR      -> COL-ORDER-NBR
                            OIL-LINE-NBR       -> COL-LINE-NBR

Iccompany      ICCOMPANY    Required

                            OID-COMPANY        -> ICC-COMPANY

Itemloc        ITEMLOC      Required

                            OID-COMPANY        -> ITL-COMPANY
                            OIL-LOCATION       -> ITL-LOCATION
                            OIL-ITEM           -> ITL-ITEM

Itemmast       ITEMMAST     Required

                            ICC-ITEM-GROUP     -> ITE-ITEM-GROUP
                            OIL-ITEM           -> ITE-ITEM

Oeinvcline     OEINVCLINE   Required

                            OID-COMPANY        -> OIL-COMPANY
                            OID-INVC-PREFIX    -> OIL-INVC-PREFIX
                            OID-INVC-NUMBER    -> OIL-INVC-NUMBER
                            OID-LINE-NBR       -> OIL-LINE-NBR