Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OEFRTCODE


                             OEFRTCODE FILE

                        Order Entry Freight Code

This file contains freight codes that can be used in the Lawson Order Entry
system.  Freight codes are set up in BL12.1 (Freight Codes).

REFERENCED BY

AP125     AP126     AP131     AP25.1    AP25.2    AP26.1
AP27.1    AP30.4    AR08.1    AR10.1    AR501     AR550
BL123     BL202     BL212     BL290     BL80.1    BL802
CXCP.1    IC28.1    IC83.1    MA180     MA530     MA531
MA60.2    MA60.3    MA60.5    MA61.1    MA66.2    MA66.3
MA67.1    MA67.2    MA70.1    MA75.1    MA80.1    MAI1.1
OE112     OE116     OE286     OE81.1    OE90.1    OE90.2
PO100     PO101     PO122     PO131     PO20.1    PO21.2
PO21.3    PO21.4    PO21.5    PO22.1    PO23.1    PO29.1
PO30.1    PO30.2    PO30.3    PO300     PO31.1    PO31.2
PO32.2    PO33.1    PO34.1    PO35.1    PO38.1    PO39.1
PO39.2    PO44.1    PO50.1    PO52.1    PO520     POI3.1
POIE.1    POII.1    POIJ.1    RQ10.1    RQ10.2    RQ12.1
RQ13.1    RQ13.2    RQ35.1    RQ500     RQIF.1    WH130
WH132     WH190     WH222     WH224     WH25.1    WH25.2
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.1    WH33.2    WH33.3    WH33.4    WH33.5    WH33.6
WH33.8    WH33.9    WH34.1    WH34.2    WH34.3    WH34.4
WH40.1    WH40.2    WH520     WH830     WO120     WO132
WO140     WO20.1    WO30.1    WO32.1    WO40.1    WO40.2
WO40.3    WO40.4    WO40.5    WO41.1    WO41.2    WO41.3
WO41.4    WO42.1    WO42.2    WO42.3    WO42.4    WO42.5
WO45.1    WOEX.1    WOSP.1

UPDATED BY

BL02.1    BL12.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     WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OFR-COMPANY            Numeric 4                                 BL12.1
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

OFR-FRT-CODE           Alpha 2                                   BL12.1
Element: Add On Cost CoThe freight code, which is a
                       user-defined, two-character value that
                       identifies the general ledger freight
                       account that is credited. You can use
                       AR10.1 (Customer) to default the freight
                       code to the customer's file.

OFR-FRT-DESC           Alpha 20  (Lower Case)                    BL02.1  BL12.1
Freight Code           This field contains the description of    BL122   BL80.1
Description            the freight code that prints on invoices  OE112   OE114
                       where freight is assessed.                OE286

OFR-FRT-CARR-CD        Alpha 1                                   BL12.1
Element: Frt Carr Cd   This field indicates if the entry of
                       freight codes on an order also requires
                       the entry of a carrier. Valid carriers
                       must be set up as vendors in the
                       Accounts Payable system.
                       N = Not Allowed
                       O = Optional
                       R = Required

OFR-FRT-CHRG-CD        Alpha 1                                   AP125   AP126
Element: Frt Chrg Cd   This field indicates if freight charges   AP131   AP25.1
                       are optional, required, or not allowed    AP25.2  AP26.1
                       when this freight code has been entered   AP27.1  AP30.4
                       on an order.                              BL12.1  BL120
                       N = Not Allowed                           BL122   BL130
                       O = Optional                              BL20.1  BL20.3
                       R = Required                              BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  CXCP.1
                                                                 IC28.1  IC83.1
                                                                 MA180   MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MA75.1  MA80.1
                                                                 MAI1.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   OE116
                                                                 OE129   OE13.2
                                                                 OE13.3  OE13.5
                                                                 ...

OFR-AOC-CODE           Alpha 2                                   BL12.1
Element: Add On Cost CoThis field contains the purchase order
                       add-on cost code to be used if an order
                       line is causing a purchase order to be
                       created. Purchase order add-on cost
                       codes are added and updated in the
                       Invoice Matching system.

OFR-FRT-ACCT-UNIT      Alpha 15                                  BL12.1
Element: Accounting UniThe account unit used for posting the
                       credit side of the freight transaction.

OFR-FRT-ACCOUNT        Numeric 6                                 BL12.1
Element: Account       The account number used for posting the
                       credit side of the freight transaction.

OFR-FRT-SUB-ACCT       Numeric 4                                 BL12.1
Element: Subaccount    The subaccount number used for posting
                       the credit side of the freight
                       transaction.

OFR-FRT-USED-FL        Alpha 1                                   BL02.1  BL120
Element: All Flag      Freight code used flag. If the freight    BL122   BL130
                       code has ever been used, this flag will   BL20.1  BL20.3
                       be set to Yes.                            BL21.2  BL21.5
                       Y = Yes                                   BL212   BL29.1
                       N = No                                    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   WH20.7

OFR-FRT-ACT-FL         Alpha 1                                   BL12.1
Element: Status        Only freight codes that have not been
                       previously assigned to orders (In use =
                       No) can be deleted. To prevent future
                       use of a used freight code, make it
                       inactive by selecting Inactive in this
                       field.
                       A = Active
                       I = Inactive

                         OEFRTCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OFRSET1   COMPANY                                                AP125   AP126
          FRT-CODE                                               AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 AR08.1  AR10.1
                                                                 AR501   AR550
                                                                 BL02.1  BL12.1
                                                                 BL120   BL122
                                                                 BL123   BL130
                                                                 BL20.1  BL20.3
                                                                 BL202   BL21.2
                                                                 BL21.5  BL212
                                                                 BL29.1  BL29.2
                                                                 BL290   BL520
                                                                 BL80.1  BL802
                                                                 ...

                         OEFRTCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oecompany      OECOMPANY    Required

                            OFR-COMPANY    -> OEC-COMPANY