Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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    AR08.1    AR10.1    AR501     AR550     CXCP.1
DR100     IC141     IC142     IC28.1    IC83.1    MA180
MA43.9    MA530     MA531     MA60.2    MA60.3    MA60.5
MA61.1    MA66.3    MA67.1    MA67.2    MA70.1    MAI1.1
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    RQ10.3
RQ11.1    RQ12.1    RQ13.1    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

WH20.7

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

OFR-COMPANY          Numeric 4
Company              The company number represents an
                     established company and is entered on
                     all function codes.


OFR-FRT-CODE         Alpha 2
Freight 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
                     AR10.1 (Customer) to default the freight
                     code to the customer's file.

OFR-FRT-DESC         Alpha 20  (Lower Case)
Freight Code         This field contains the description of
Description          the freight code that prints on invoices
                     where freight is assessed.

OFR-FRT-CARR-CD      Alpha 1
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
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  CXCP.1
                     on an order.                                DR100   IC141
                     N = Not Allowed                             IC142   IC28.1
                     O = Optional                                IC83.1  MA180
                     R = Required                                MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 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
                                                                 ...

OFR-AOC-CODE         Alpha 2
Add On Cost 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
Default Freight      The account unit used for posting the
Acct. Unit           credit side of the freight transaction.

OFR-FRT-ACCOUNT      Numeric 6
Default Freight      The account number used for posting the
Account              credit side of the freight transaction.

OFR-FRT-SUB-ACCT     Numeric 4
Default Freight Sub  The subaccount number used for posting
Account              the credit side of the freight
                     transaction.

OFR-FRT-USED-FL      Alpha 1                                     WH20.7
Freight Code Used    Freight code used flag. If the freight
Flag                 code has ever been used, this flag will
                     be set to Yes.
                     Y = Yes
                     N = No

OFR-FRT-ACT-FL       Alpha 1
Freight Code Active  Only freight codes that have not been
Flag                 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  AR08.1
                                                                 AR10.1  AR501
                                                                 AR550   CXCP.1
                                                                 DR100   IC141
                                                                 IC142   IC28.1
                                                                 IC83.1  MA180
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 ...

                         OEFRTCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oecompany      OECOMPANY    Required

                            OFR-COMPANY    -> OEC-COMPANY