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    AR10.1    AR501     AR550     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

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 Code          This field contains the shipping
                     method. Shipping methods are defined
                     using WH11.1 (Shipping Method).


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

OMT-METH-USED-FL     Alpha 1                                     WH11.1  WH20.7
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  AR10.1
          METHOD        updating the table.                      AR501   AR550
                                                                 WH11.1  WH130
                                                                 WH132   WH190
                                                                 WH20.2  WH20.7
                                                                 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
                                                                 ...

                         OEMETHOD FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oecompany      OECOMPANY    Required

                            OMT-COMPANY    -> OEC-COMPANY