Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             OEMETHOD FILE

                            Shipping Method

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

REFERENCED BY

AR08.1    AR10.1    AR501     AR550     BL122     BL202
BL80.1    BL802     BL902     OE112     WH211

UPDATED BY

BL02.1    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     OE113     OE114     OE129
OE14.4    OE15.1    OE15.2    OE15.3    OE15.4    OE15.5
OE15.7    OE510     OE810     OE920     WH11.1    WH20.7

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

OMT-METHOD           Alpha 10                                    WH11.1
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
Method Description   The description of the shipping method      BL80.1  OE112
                     that prints on the invoice.                 OE114   WH11.1

OMT-METH-USED-FL     Alpha 1                                     BL02.1  BL92.1
Method Used Flag     This field indicates whether this           OE10.1  OE10.2
                     method has ever been added to a             OE10.3  OE10.4
                     customer's account.                         OE10.5  OE10.6
                     N = No                                      OE10.7  OE10.8
                     Y = Yes                                     OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE113
                                                                 OE114   OE129
                                                                 OE14.4  OE15.1
                                                                 OE15.2  OE15.3
                                                                 OE15.4  OE15.5
                                                                 OE15.7  OE510
                                                                 OE810   OE920
                                                                 WH11.1  WH20.7

OMT-METH-ACT-FL      Alpha 1                                     WH11.1
Method 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       Primary index used for accessing and     AR08.1  AR10.1
          METHOD        updating the table.                      AR501   AR550
                                                                 BL02.1  BL122
                                                                 BL202   BL80.1
                                                                 BL802   BL902
                                                                 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
                                                                 OE112   OE113
                                                                 OE114   OE129
                                                                 OE14.4  OE15.1
                                                                 ...

                         OEMETHOD FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oecompany      OECOMPANY    Required

                            OMT-COMPANY    -> OEC-COMPANY