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    AR120     AR501     AR550
BL202     BL80.1    BL802     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    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        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
Element: Meth Desc     The description of the shipping method    BL80.1  WH11.1
                       that prints on the invoice.

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  WH11.1
                                                                 WH20.7

OMT-METH-ACT-FL        Alpha 1                                   WH11.1
Element: Active Flag   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                                                AR02.1  AR08.1
          METHOD                                                 AR10.1  AR120
                                                                 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
                                                                 WH11.1  WH130
                                                                 WH132   WH190
                                                                 WH20.2  WH20.7
                                                                 WH211   WH30.1
                                                                 ...

                         OEMETHOD FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oecompany      OECOMPANY    Required

                            OMT-COMPANY    -> OEC-COMPANY