Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

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    AR501     AR550     BL202     BL80.1    BL802
WH130     WH211     WH33.5    WH34.1    WH34.2    WH34.3
WH34.4

UPDATED BY

BL02.1    WH11.1

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 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  BL80.1
Method Code          The description of the shipping method      WH11.1
Description          that prints on the invoice.

OMT-METH-USED-FL     Alpha 1                                     BL02.1  WH11.1
Method Code Used     This field indicates whether this
Flag                 method has ever been added to a
                     customer's account.
                     N = No
                     Y = Yes

OMT-METH-ACT-FL      Alpha 1                                     WH11.1
Method Code Active   This field indicates whether this
Flag                 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  AR501
          METHOD        updating the table.                      AR550   BL02.1
                                                                 BL202   BL80.1
                                                                 BL802   WH11.1
                                                                 WH130   WH211
                                                                 WH33.5  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

                         OEMETHOD FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oecompany      OECOMPANY    Required

                            OMT-COMPANY    -> OEC-COMPANY