Lawson Insight Technical Documentation |
|
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 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 API1.1 AR08.1 AR10.1
AR501 AR550 CXCP.1 IC28.1 IC83.1 MA180
MA41.2 MA41.7 MA43.1 MA43.2 MA43.3 MA43.9
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 PO100 PO101 PO122 PO131
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.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 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 POII.1
POIJ.1 RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ12.1
RQ13.1 RQ35.1 RQ500 RQIE.1 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
WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OFR-COMPANY Numeric 4
Element: Company The company number represents an
established company and is entered on
all function codes.
OFR-FRT-CODE Alpha 2
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)
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
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 AP23.1
N = Not Allowed AP25.1 AP25.2
O = Optional AP26.1 AP27.1
R = Required AP30.4 API1.1
CXCP.1 IC28.1
IC83.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
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
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
...
OFR-AOC-CODE Alpha 2
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
Element: Accounting UniThe account unit used for posting the
credit side of the freight transaction.
OFR-FRT-ACCOUNT Numeric 6
Element: Account The account number used for posting the
credit side of the freight transaction.
OFR-FRT-SUB-ACCT Numeric 4
Element: Subaccount The subaccount number used for posting
the credit side of the freight
transaction.
OFR-FRT-USED-FL Alpha 1 WH20.7
Element: All Flag Freight code used flag. If the freight
code has ever been used, this flag will
be set to Yes.
Y = Yes
N = No
OFR-FRT-ACT-FL Alpha 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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
AR08.1 AR10.1
AR501 AR550
CXCP.1 IC28.1
IC83.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
...
OEFRTCODE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Oecompany OECOMPANY Required
OFR-COMPANY -> OEC-COMPANY
|