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     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP21.1    AP23.1    AP25.1
AP25.2    AP26.1    AP27.1    AP30.4    API1.1    AR08.1
AR10.1    AR120     AR501     AR550     BL123     BL202
BL212     BL290     BL80.1    BL802     CXCP.1    MA180
MA41.1    MA41.2    MA41.4    MA41.7    MA43.1    MA43.2
MA43.3    MA43.7    MA530     MA531     MA60.2    MA60.3
MA60.5    MA61.1    MA66.2    MA66.3    MA67.2    MA67.3
MA68.2    MA68.3    MA68.5    MA70.1    MA75.1    MA80.1
MAI1.1    PD10.1    PD10.2    PD130     PD20.1    PD20.2
PD20.3    PO100     PO101     PO122     PO131     PO190
PO20.1    PO21.1    PO21.2    PO21.3    PO21.4    PO21.5
PO22.1    PO23.1    PO24.1    PO25.1    PO25.5    PO25.6
PO25.7    PO27.2    PO29.1    PO30.1    PO30.2    PO30.3
PO300     PO31.1    PO31.2    PO32.2    PO32.4    PO33.1
PO34.1    PO35.1    PO36.1    PO36.2    PO38.1    PO39.1
PO39.2    PO44.1    PO50.1    PO52.1    PO520     PO536
POI3.1    POID.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

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    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: Aoc Code      The freight code, which is a
                       user-defined, two-character value that
                       identifies the general ledger freight
                       account that is credited. You can use
                       Customer (AR10.1) to default the freight
                       code to the customer's file.

OFR-FRT-DESC           Alpha 20  (Lower Case)                    BL02.1  BL12.1
Element: Frt Desc      This field contains the description of    BL122   BL80.1
                       the freight code that prints on invoices
                       where freight is assessed.

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   AP20.1
                       are optional, required, or not allowed    AP20.2  AP20.3
                       when this freight code has been entered   AP20.4  AP20.5
                       on an order.                              AP20.7  AP21.1
                       N = Not Allowed                           AP23.1  AP25.1
                       O = Optional                              AP25.2  AP26.1
                       R = Required                              AP27.1  AP30.4
                                                                 API1.1  BL12.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 CXCP.1  MA180
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.7
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.2  MA67.3
                                                                 MA68.2  MA68.3
                                                                 MA68.5  MA70.1
                                                                 MA75.1  MA80.1
                                                                 MAI1.1  PD10.1
                                                                 PD10.2  PD130
                                                                 ...

OFR-AOC-CODE           Alpha 2                                   BL12.1
Element: Aoc Code      This 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: Acct Unit     The 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: Sub Acct      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
                                                                 WH20.7

OFR-FRT-ACT-FL         Alpha 1                                   BL12.1
Element: Active Flag   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   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  AR08.1
                                                                 AR10.1  AR120
                                                                 AR501   AR550
                                                                 BL02.1  BL12.1
                                                                 BL120   BL122
                                                                 BL123   BL130
                                                                 BL20.1  BL20.3
                                                                 ...

                         OEFRTCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oecompany      OECOMPANY    Required

                            OFR-COMPANY    -> OEC-COMPANY