Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OEMETHOD


                             OEMETHOD FILE

                            Shipping Method

The Shipping Method file contains all user-defined shipping methods that are
defined in the Lawson Warehouse system.

REFERENCED BY

AR02.1    AR08.1    AR10.1    AR501     AR550     BL202
BL80.1    BL802     OE112     OE116     WH130     WH132
WH190     WH211     WH30.1    WH30.2    WH30.3    WH30.4
WH31.1    WH31.2    WH31.3    WH31.4    WH32.1    WH32.2
WH32.3    WH32.4    WH33.5    WH34.1    WH34.2    WH34.3
WH34.4    WH40.1    WH40.2    WH520     WH830

UPDATED BY

BL02.1    BL120     BL122     BL130     BL20.1    BL20.3
BL21.2    BL21.5    BL29.1    BL29.2    BL520     BL820
BL92.1    OE10.1    OE10.2    OE10.3    OE10.4    OE10.5
OE10.6    OE10.7    OE10.8    OE11.1    OE11.4    OE11.8
OE11.9    OE110     OE111     OE113     OE114     OE129
OE13.2    OE13.3    OE13.5    OE14.4    OE30.1    OE30.2
OE30.3    OE30.4    OE30.5    OE30.6    OE30.7    OE30.9
OE510     OE530     OE810     OE830     WH11.1    WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OMT-COMPANY            Numeric 4                                 WH11.1
Element: Company       This field contains the company number.

OMT-METHOD             Alpha 10                                  WH11.1
Element: Method Code   This field contains the shipping
                       method. Shipping methods are defined
                       using WH11.1 (Shipping Method).


OMT-METH-DESC          Alpha 30  (Lower Case)                    BL02.1  BL122
Method Code            The description of the shipping method    BL80.1  OE112
Description            that prints on the invoice.               OE114   WH11.1

OMT-METH-USED-FL       Alpha 1                                   BL02.1  BL120
Element: All Flag      This field indicates whether this         BL122   BL130
                       method has ever been added to a           BL20.1  BL20.3
                       customer's account.                       BL21.2  BL21.5
                       N = No                                    BL29.1  BL29.2
                       Y = Yes                                   BL520   BL820
                                                                 BL92.1  OE10.1
                                                                 OE10.2  OE10.3
                                                                 OE10.4  OE10.5
                                                                 OE10.6  OE10.7
                                                                 OE10.8  OE11.1
                                                                 OE11.4  OE11.8
                                                                 OE11.9  OE110
                                                                 OE111   OE113
                                                                 OE114   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE14.4
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE510   OE530
                                                                 OE810   OE830
                                                                 WH11.1  WH20.7

OMT-METH-ACT-FL        Alpha 1                                   WH11.1
Element: Status        This field indicates whether this
                       method is active or inactive.  A
                       shipping method can only be added to an
                       order or invoice if it is active.  If
                       inactive, the form validates the user's
                       ID when an attempt is made to enter the
                       shipping method.
                       A = Active
                       I = Inactive

                         OEMETHOD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OMTSET1   COMPANY       Primary index used for accessing and     AR02.1  AR08.1
          METHOD        updating the table.                      AR10.1  AR501
                                                                 AR550   BL02.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL202
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL80.1
                                                                 BL802   BL820
                                                                 BL92.1  OE10.1
                                                                 OE10.2  OE10.3
                                                                 OE10.4  OE10.5
                                                                 OE10.6  OE10.7
                                                                 OE10.8  OE11.1
                                                                 ...

                         OEMETHOD FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oecompany      OECOMPANY    Required

                            OMT-COMPANY    -> OEC-COMPANY